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.000395
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.000066
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.000059
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.000051
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.000138
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.000107
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000064
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.000254
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.000113
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.000145
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.000055
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.000260
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.000175
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.000056
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.000046
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 > 1728205557)
ORDER BY session_activity.view_date DESC
Run Time: 0.000763
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 73 | 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.000135
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: 64b21d6610b284a9df56391922540dea, , 1728210057
Run Time: 0.000122
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=, 1728206457,
Run Time: 0.000150
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.000264
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.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 *
FROM xf_brivium_modern_cache
WHERE modern_statistic_id = ? AND user_id = ?
ORDER BY last_update DESC
Params: 1, 0
Run Time: 0.000096
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.000058
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.000119
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.000134
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.000109
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.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 ('kin_postthread_main')
AND style_id = ?
AND language_id = ?
Params: 5, 1
Run Time: 0.000061
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.000054
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.000051
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.000050
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |