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.000053
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.000056
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.000046
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.000130
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 | prav110_pravorg.moderator.user_id | 1 | |
SIMPLE | permission_combination | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.user.permission_combination_id | 1 | |
DELETE FROM `xf_data_registry` WHERE (data_key = 'modLogCounts')
Run Time: 0.000105
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000065
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.000289
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 | prav110_pravorg.node.node_id | 52 | Using index; Using temporary; Using filesort |
DEPENDENT SUBQUERY | po | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | prav110_pravorg.th.thread_id | 7 | |
DEPENDENT SUBQUERY | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | prav110_pravorg.node.node_id | 52 | Using index |
DEPENDENT SUBQUERY | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | prav110_pravorg.node.node_id | 52 | |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000139
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 105 | 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, 51, 12, 62, 27, 6, 96, 18, 28, 77, 81, 19, 29, 59, 136, 94, 14, 78, 68, 79, 67, 109, 66, 83, 111, 44, 15, 108, 142, 85, 114, 42, 106, 33, 98, 20, 16, 133, 87, 48, 102, 72, 10, 8, 131, 107, 132, 36, 9, 13, 50, 43, 61, 46, 5, 145, 60, 93, 92, 117, 74, 88, 90, 64, 45, 89, 138, 137, 84, 135, 116, 115, 63, 113, 120, 122, 127, 139, 99, 126, 129, 125, 118, 119, 121, 123, 124, 128)
Run Time: 0.000190
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 | prav110_pravorg.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 (48581, 45439, 362, 7771, 45240, 775, 2367, 39135, 9568, 9366, 1046, 48868, 3956, 8002, 48654, 1094, 5192, 45242, 44985, 8332, 45437, 2208, 6895, 8687, 9685, 9014, 21655, 288, 12393, 1448, 9921, 3479, 2066, 3, 1642, 3460)
Run Time: 0.000067
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 36 | 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.000317
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 | prav110_pravorg.node.node_id | 52 | Using index; Using temporary; Using filesort |
DEPENDENT SUBQUERY | po | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | prav110_pravorg.th.thread_id | 7 | |
DEPENDENT SUBQUERY | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | prav110_pravorg.node.node_id | 52 | Using index |
DEPENDENT SUBQUERY | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_last_post_date | 4 | prav110_pravorg.node.node_id | 52 | |
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, 51, 12, 62, 27, 6, 96, 18, 28, 77, 81, 19, 29, 59, 136, 94, 14, 78, 68, 79, 67, 109, 66, 83, 111, 44, 15, 108, 142, 85, 114, 42, 106, 33, 98, 20, 16, 133, 87, 48, 102, 72, 10, 8, 131, 107, 132, 36, 9, 13, 50, 43, 61, 46, 5, 145, 60, 93, 92, 117, 74, 88, 90, 64, 45, 89, 138, 137, 84, 135, 116, 115, 63, 113, 120, 122, 127, 139, 99, 126, 129, 125, 118, 119, 121, 123, 124, 128)
Run Time: 0.000192
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 | prav110_pravorg.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 (48581, 45439, 362, 7771, 45240, 775, 2367, 39135, 9568, 9366, 1046, 48868, 3956, 8002, 48654, 1094, 5192, 45242, 44985, 8332, 45437, 2208, 6895, 8687, 9685, 9014, 21655, 288, 12393, 1448, 9921, 3479, 2066, 3, 1642, 3460)
Run Time: 0.000074
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | PRIMARY | PRIMARY | 4 | | 36 | Using where |
SELECT
node_id,
title
FROM
xf_node
WHERE
node_type_id = 'Category'
Run Time: 0.000053
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 > 1728704258)
ORDER BY session_activity.view_date DESC
Run Time: 0.000999
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 42 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.session_activity.user_id | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000123
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: fc8199b1d3dc119a005ee48d2f75f479, a:8:{s:12:"sessionStart";i:1728705158;s:2:"ip";s:4:"bT4";s:11:"sessionCsrf";s:16:"P8lBrvBqrLBfg1Ry";s:9:"userAgent";s:40:"CCBot/2.0 (https://commoncrawl.org/faq/)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1435511682;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1395790635;}}, 1728708758
Run Time: 0.000238
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, bT4, bT4, XenForo_ControllerPublic_Forum, Index, valid, node_name=, 1728705158,
Run Time: 0.000207
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.000202
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.000065
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.000062
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.000049
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.000092
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.000104
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 105 | 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.000106
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 | prav110_pravorg.thread.node_id | 1 | |
SIMPLE | last_post_user | eq_ref | PRIMARY | PRIMARY | 4 | prav110_pravorg.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.000044
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.000055
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.000056
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.000052
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.000037
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |