SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000391
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000180
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000072
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_addon | index | | PRIMARY | 77 | | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: brBriviumAddOns, a:0:{}
Run Time: 0.000126
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000077
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_help_page
ORDER BY display_order
Run Time: 0.000062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_help_page | ALL | | | | | 1 | Using filesort |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: dbf8b908743e750bb56f10643e689f04, , 1615009607
Run Time: 0.000145
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , XenForo_ControllerPublic_Help, Index, valid, page_name=, 1615006007,
Run Time: 0.000056
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: addOns
Run Time: 0.000154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT * FROM `vw_nodetype`
Run Time: 0.000059
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | vw_nodetype | ALL | | | | | 25 | |
SELECT `l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*,`likes`.`likes`,`likes`.`like_users`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`page`.`pageid` FROM `vw_page` `page` LEFT JOIN `vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1)
LEFT JOIN `vw_counter` `c` ON (`c`.`routeid` = `i`.`routeid`)
LEFT JOIN `vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`)
LEFT JOIN `vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`)
LEFT JOIN `vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`)
LEFT JOIN `vw_likes` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`) WHERE `page`.`areaid` = 0
Run Time: 0.000191
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ch | system | pageid | | | | 0 | const row not found |
SIMPLE | likes | system | PRIMARY | | | | 0 | const row not found |
SIMPLE | page | ref | areaid | areaid | 4 | const | 1 | |
SIMPLE | l | eq_ref | pageid | pageid | 4 | openplus_xf.page.pageid | 1 | |
SIMPLE | i | eq_ref | itemid | itemid | 8 | openplus_xf.page.pageid,const | 1 | |
SIMPLE | c | eq_ref | PRIMARY,lastupdate | PRIMARY | 4 | openplus_xf.i.routeid | 1 | Using where |
SIMPLE | r | eq_ref | PRIMARY | PRIMARY | 4 | openplus_xf.page.revisionid | 1 | |
SELECT * FROM `vw_permission` WHERE `applykey` IN ('0:0','1:1')
Run Time: 0.000101
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | vw_permission | range | race_condition,applykey | applykey | 38 | | 3 | Using index condition |
SELECT * FROM `vw_replacement` ORDER BY displayorder ASC
Run Time: 0.000062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | vw_replacement | system | | | | | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'help_wrapper', 'vw_navbar', 'vw_headinclude', 'vw_general_footer', 'vw_content_quote', 'vw_content_quote_view', 'vw_content_quote_print', 'help_index', 'notice_cookies', 'resources_tab_links', 'dark_taigachat', 'dark_taigachat_list', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 10, 2
Run Time: 0.017625
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 14 | Using where |