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.000452
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.000105
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.000137
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.000078
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.000162
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.000133
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000107
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.000652
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.000428
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 (18, 26, 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.000286
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 (45236, 2208, 9366, 362, 7831, 7771, 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.000095
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 34 | 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.000327
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 (18, 26, 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.000199
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 (45236, 2208, 9366, 362, 7831, 7771, 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.000073
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 34 | Using where |
SELECT
node_id,
title
FROM
xf_node
WHERE
node_type_id = 'Category'
Run Time: 0.000092
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 > 1686358129)
ORDER BY session_activity.view_date DESC
Run Time: 0.001043
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 34 | 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.000082
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: 9175292349d03c3c43954834ad7e328b, , 1686362629
Run Time: 0.000146
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=, 1686359029,
Run Time: 0.000111
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.000532
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.000095
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.000082
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.000071
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.000176
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.000153
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.000166
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.000088
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.000068
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.000079
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.000064
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.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 | |