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.000508
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.000117
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: brmsModernStatisticCache
Run Time: 0.000110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: modLogCounts
Run Time: 0.000105
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT user.*, permission_combination.cache_value AS global_permission_cache
FROM xf_moderator AS moderator
INNER JOIN xf_user AS user ON (user.user_id = moderator.user_id)
LEFT JOIN xf_permission_combination AS permission_combination ON (permission_combination.permission_combination_id = user.permission_combination_id)
Run Time: 0.000230
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | moderator | index | PRIMARY | PRIMARY | 4 | | 8 | Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | admin_123.moderator.user_id | 1 | |
SIMPLE | permission_combination | eq_ref | PRIMARY | PRIMARY | 4 | admin_123.user.permission_combination_id | 1 | |
DELETE FROM `xf_data_registry` WHERE (data_key = 'modLogCounts')
Run Time: 0.000169
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000098
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT DISTINCT
node.*,
(
SELECT
SUM(xf_thread.view_count)*1 as views
FROM
xf_thread
WHERE
xf_thread.node_id = node.node_id
) AS views,
(
SELECT
MAX(last_post_date)
FROM
xf_thread
WHERE
xf_thread.node_id = node.node_id
) AS last_post,
(
SELECT
po.message as th_message
FROM
xf_thread as th
LEFT JOIN
xf_post as po
ON
po.thread_id = th.thread_id
WHERE
th.node_id = node.node_id
ORDER BY po.post_date DESC
LIMIT 1
) as th_message
FROM
xf_node as node
WHERE 1
AND display_in_list = 1
ORDER BY
last_post DESC
Run Time: 0.000504
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | node | ALL | display_in_list | | | | 105 | Using where; Using filesort |
DEPENDENT SUBQUERY | th | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | admin_123.node.node_id | 51 | Using index; Using temporary; Using filesort |
DEPENDENT SUBQUERY | po | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | admin_123.th.thread_id | 10 | |
DEPENDENT SUBQUERY | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | admin_123.node.node_id | 51 | Using index |
DEPENDENT SUBQUERY | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | admin_123.node.node_id | 51 | |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000308
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 104 | Using where |
SELECT forum.*
,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE forum.node_id IN (26, 18, 77, 67, 62, 96, 109, 66, 83, 78, 19, 111, 12, 51, 44, 15, 27, 108, 6, 142, 94, 85, 114, 42, 106, 28, 33, 98, 20, 29, 14, 16, 133, 87, 48, 59, 102, 72, 10, 8, 131, 107, 132, 36, 79, 9, 13, 50, 43, 61, 46, 68, 5, 145, 81, 60, 93, 92, 117, 74, 88, 90, 64, 45, 89, 138, 137, 84, 135, 136, 116, 115, 63, 113, 120, 122, 127, 139, 99, 126, 129, 125, 118, 119, 121, 123, 124, 128)
Run Time: 0.000300
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 90 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | admin_123.forum.node_id | 1 | Using index |
SELECT user.user_id, user.avatar_date, user.gravatar, user.gender
FROM xf_user AS user
WHERE user.user_id IN (9366, 362, 7831, 7771, 2208, 44985, 8332, 3956, 10099, 2367, 1094, 1046, 39135, 6895, 5004, 9568, 775, 8002, 8687, 9685, 9014, 21655, 5192, 288, 12393, 1448, 9921, 3479, 8084, 2066, 3, 1642, 3460)
Run Time: 0.000132
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 33 | Using where |
SELECT DISTINCT
node.*,
(
SELECT
SUM(xf_thread.view_count)*1 as views
FROM
xf_thread
WHERE
xf_thread.node_id = node.node_id
) AS views,
(
SELECT
MAX(last_post_date)
FROM
xf_thread
WHERE
xf_thread.node_id = node.node_id
) AS last_post,
(
SELECT
po.message as th_message
FROM
xf_thread as th
LEFT JOIN
xf_post as po
ON
po.thread_id = th.thread_id
WHERE
th.node_id = node.node_id
ORDER BY po.post_date DESC
LIMIT 1
) as th_message
FROM
xf_node as node
WHERE 1
AND display_in_list = 1
ORDER BY
last_post DESC
Run Time: 0.000353
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | node | ALL | display_in_list | | | | 105 | Using where; Using filesort |
DEPENDENT SUBQUERY | th | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | admin_123.node.node_id | 51 | Using index; Using temporary; Using filesort |
DEPENDENT SUBQUERY | po | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | admin_123.th.thread_id | 10 | |
DEPENDENT SUBQUERY | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | admin_123.node.node_id | 51 | Using index |
DEPENDENT SUBQUERY | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | admin_123.node.node_id | 51 | |
SELECT forum.*
,
NULL AS forum_read_date
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE forum.node_id IN (26, 18, 77, 67, 62, 96, 109, 66, 83, 78, 19, 111, 12, 51, 44, 15, 27, 108, 6, 142, 94, 85, 114, 42, 106, 28, 33, 98, 20, 29, 14, 16, 133, 87, 48, 59, 102, 72, 10, 8, 131, 107, 132, 36, 79, 9, 13, 50, 43, 61, 46, 68, 5, 145, 81, 60, 93, 92, 117, 74, 88, 90, 64, 45, 89, 138, 137, 84, 135, 136, 116, 115, 63, 113, 120, 122, 127, 139, 99, 126, 129, 125, 118, 119, 121, 123, 124, 128)
Run Time: 0.000253
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 90 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | admin_123.forum.node_id | 1 | Using index |
SELECT user.user_id, user.avatar_date, user.gravatar, user.gender
FROM xf_user AS user
WHERE user.user_id IN (9366, 362, 7831, 7771, 2208, 44985, 8332, 3956, 10099, 2367, 1094, 1046, 39135, 6895, 5004, 9568, 775, 8002, 8687, 9685, 9014, 21655, 5192, 288, 12393, 1448, 9921, 3479, 8084, 2066, 3, 1642, 3460)
Run Time: 0.000129
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 33 | Using where |
SELECT
node_id,
title
FROM
xf_node
WHERE
node_type_id = 'Category'
Run Time: 0.000087
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 105 | Using where |
SELECT session_activity.*
,
user.*
FROM xf_session_activity AS session_activity
LEFT JOIN xf_user AS user ON
(user.user_id = session_activity.user_id)
WHERE (session_activity.view_date > 1686224618)
ORDER BY session_activity.view_date DESC
Run Time: 0.002141
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 142 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | admin_123.session_activity.user_id | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000237
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: a2fd3e5686a386699e1c3f8db062a33d, , 1686229118
Run Time: 0.000202
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_Forum, Index, valid, node_name=, 1686225518,
Run Time: 0.000155
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'BRMS_ModernStatistic', 'BRMS_modern_statistic_header', 'node_forum_level_2', 'node_category_level_1', 'node_forum_level_n', 'node_link_level_n', 'node_forum_level_1', 'node_link_level_1', 'forum_list_who_visited_wrapper', 'forum_list', 'xfa_blog_navigation_links', 'waindigo_navigation_visitor_tab_joinusergroup', 'xfa_blog_navigation_tab_link', 'modess_moderator_bar_mod_log_counts', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000781
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 16 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbms_twitter_css')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000091
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT *
FROM xf_brivium_modern_cache
WHERE modern_statistic_id = ? AND user_id = ?
ORDER BY last_update DESC
Params: 1, 0
Run Time: 0.000089
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT *
FROM xf_brivium_modern_cache
WHERE modern_statistic_id = ? AND user_id = ?
ORDER BY last_update DESC
Params: 1, 0
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT *
FROM xf_node
ORDER BY lft ASC
Run Time: 0.000178
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | | | | | 105 | Using filesort |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000158
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 104 | Using where |
SELECT thread.*
,
node.title AS node_title, node.node_name,
NULL AS thread_read_date,
last_post_user.user_group_id , last_post_user.display_style_group_id , last_post_user.is_banned
FROM xf_thread AS thread
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS last_post_user ON
(last_post_user.user_id = thread.last_post_user_id)
WHERE ((thread.discussion_type <> 'redirect') AND (thread.discussion_state IN ('visible'))) AND (thread.node_id NOT IN (130))
ORDER BY thread.last_post_date DESC
LIMIT 15
Run Time: 0.000152
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | index | node_id_last_post_date,node_id_sticky_state_last_post | last_post_date | 4 | | 28 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | admin_123.thread.node_id | 1 | |
SIMPLE | last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | admin_123.thread.last_post_user_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRMS_thread_post_latest')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('kin_postthread_main')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000071
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('social_connect_status_editor')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('xxtW_js')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbms_twitter_XFormer')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000080
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |