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.000609
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.000082
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.000083
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.000058
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.000234
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.000193
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.000427
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 | 51 | 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 | 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 | prav110_pravorg.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.000180
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 (29, 59, 26, 12, 18, 19, 136, 96, 77, 27, 94, 14, 78, 68, 79, 67, 62, 109, 66, 83, 111, 51, 44, 15, 108, 6, 142, 85, 114, 42, 106, 28, 33, 98, 20, 16, 133, 87, 48, 102, 72, 10, 8, 131, 107, 132, 36, 9, 13, 50, 43, 61, 46, 5, 145, 81, 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.000214
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 (45439, 1094, 362, 9366, 7771, 2367, 1046, 39135, 9568, 45437, 45242, 44985, 8332, 10099, 3956, 2208, 6895, 775, 8002, 8687, 9685, 9014, 21655, 5192, 288, 12393, 1448, 9921, 3479, 2066, 3, 1642, 3460)
Run Time: 0.000144
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.000410
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 | 51 | 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 | 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 | prav110_pravorg.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 (29, 59, 26, 12, 18, 19, 136, 96, 77, 27, 94, 14, 78, 68, 79, 67, 62, 109, 66, 83, 111, 51, 44, 15, 108, 6, 142, 85, 114, 42, 106, 28, 33, 98, 20, 16, 133, 87, 48, 102, 72, 10, 8, 131, 107, 132, 36, 9, 13, 50, 43, 61, 46, 5, 145, 81, 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.000258
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 (45439, 1094, 362, 9366, 7771, 2367, 1046, 39135, 9568, 45437, 45242, 44985, 8332, 10099, 3956, 2208, 6895, 775, 8002, 8687, 9685, 9014, 21655, 5192, 288, 12393, 1448, 9921, 3479, 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 | | 33 | Using where |
SELECT
node_id,
title
FROM
xf_node
WHERE
node_type_id = 'Category'
Run Time: 0.000066
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 > 1711710836)
ORDER BY session_activity.view_date DESC
Run Time: 0.002759
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 200 | 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.000605
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: cfb651d3d09f36657e9cb0d756238925, a:10:{s:12:"sessionStart";i:1711711736;s:2:"ip";s:4:"[N";s:11:"sessionCsrf";s:16:"g-gpdnjyi-CY3G4A";s:9:"userAgent";s:9:"claudebot";s:7:"robotId";s:0:"";s:7:"referer";s:38:"http://pravoslavie-forum.org/?_debug=1";s:10:"fromSearch";b: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;}}, 1711715336
Run Time: 0.000179
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, [N, [N, XenForo_ControllerPublic_Forum, Index, valid, node_name=, 1711711736,
Run Time: 0.000601
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.000315
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.000084
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.000075
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.000166
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.000152
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.000187
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.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.000093
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.000100
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.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 ('bbms_twitter_XFormer')
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 | |