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.000943
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.000215
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.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000233
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.001115
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 87 | Using where; 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.000711
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 87 | 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 (71, 72, 73, 74, 75, 76, 77, 85, 79, 80, 81, 82, 83, 84, 2, 16, 17, 18, 19, 20, 21, 22, 3, 23, 24, 25, 26, 27, 4, 28, 29, 30, 31, 32, 43, 5, 33, 34, 35, 36, 37, 38, 6, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 50, 51, 52, 53, 54, 55, 8, 56, 57, 9, 86, 87, 11, 12, 13, 14, 15)
Run Time: 0.001387
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 83 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.forum.node_id | 1 | Using index |
SELECT post_id, user.avatar_date, user.gravatar, thread.*,
first_post_user.avatar_date AS first_post_user_avatar_date,
first_post_user.gravatar AS first_post_user_gravatar
FROM xf_post AS post
LEFT JOIN xf_user AS user ON (post.user_id = user.user_id)
LEFT JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id)
LEFT JOIN xf_user AS first_post_user ON (thread.user_id = user.user_id)
WHERE post.post_id IN (1078, 819, 1070, 897, 991, 263, 268, 98, 981, 133, 399, 90, 253, 494, 203, 809, 1006, 273, 892, 831, 896, 821)
Run Time: 0.009109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY | PRIMARY | 4 | | 22 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.post.thread_id | 1 | |
SIMPLE | first_post_user | ALL | | | | | 63 | Using where; Using join buffer (Block Nested Loop) |
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 > 1714042614)
ORDER BY session_activity.view_date DESC
Run Time: 0.000673
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 4 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.session_activity.user_id | 1 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000176
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: b0b52ce746ad1f3a48cb3017c1ff0b8c, a:6:{s:12:"sessionStart";i:1714043514;s:2:"ip";s:4:"";s:11:"sessionCsrf";s:16:"jGm9F-al7109iUXe";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;}, 1714047114
Run Time: 0.000225
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=, 1714043514,
Run Time: 0.000137
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'BRQCT_forum_list_nodes', 'BRQCT_ad_sidebar_top', 'BRQCT_button_top_ctrl', 'BRMS_ModernStatistic', 'BRMS_modern_statistic_header', 'node_forum_level_2', 'node_category_level_1', 'node_forum_level_n', 'hex_library_list_thumbnail_thumbnails', 'hex_library_list_replace_thumbnails', 'hex_forum_list_thumbnail_thumbnails', 'hex_forum_list_replace_thumbnails', 'wf_widget_wrapper', 'wf_widget_threads', 'wf_widget_stats', 'forum_list', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.001158
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 20 | Using where |
SELECT node.*
FROM xf_node AS node
WHERE node.node_id = ?
Params: 1
Run Time: 0.000331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
WHERE lft > ? AND rgt < ?
AND display_in_list = 1
ORDER BY lft ASC
Params: 33, 162
Run Time: 0.000807
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list,lft | | | | 87 | Using where; 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.000589
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 87 | 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 (2, 16, 17, 18, 19, 20, 21, 22, 3, 23, 24, 25, 26, 27, 4, 28, 29, 30, 31, 32, 43, 5, 33, 34, 35, 36, 37, 38, 6, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 50, 51, 52, 53, 54, 55, 8, 56, 57, 9, 86, 87)
Run Time: 0.001157
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 83 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.forum.node_id | 1 | Using index |
SELECT post_id, user.avatar_date, user.gravatar, thread.*,
first_post_user.avatar_date AS first_post_user_avatar_date,
first_post_user.gravatar AS first_post_user_gravatar
FROM xf_post AS post
LEFT JOIN xf_user AS user ON (post.user_id = user.user_id)
LEFT JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id)
LEFT JOIN xf_user AS first_post_user ON (thread.user_id = user.user_id)
WHERE post.post_id IN (203, 809, 1070, 1006, 273)
Run Time: 0.002522
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY | PRIMARY | 4 | | 5 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.post.thread_id | 1 | |
SIMPLE | first_post_user | ALL | | | | | 63 | Using where; Using join buffer (Block Nested Loop) |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRQCT_button_top_ctrl', 'BRNLR_forum_list_sidebar', 'BRNLR_node_list_render_item')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000260
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 3 | Using where |
SELECT node.*
FROM xf_node AS node
WHERE node.node_id = ?
Params: 1
Run Time: 0.000277
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_node
WHERE lft > ? AND rgt < ?
AND display_in_list = 1
ORDER BY lft ASC
Params: 33, 162
Run Time: 0.000691
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list,lft | | | | 87 | Using where; 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.000548
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 87 | 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 (2, 16, 17, 18, 19, 20, 21, 22, 3, 23, 24, 25, 26, 27, 4, 28, 29, 30, 31, 32, 43, 5, 33, 34, 35, 36, 37, 38, 6, 39, 40, 41, 42, 44, 45, 46, 47, 48, 49, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 50, 51, 52, 53, 54, 55, 8, 56, 57, 9, 86, 87)
Run Time: 0.001189
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 83 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.forum.node_id | 1 | Using index |
SELECT post_id, user.avatar_date, user.gravatar, thread.*,
first_post_user.avatar_date AS first_post_user_avatar_date,
first_post_user.gravatar AS first_post_user_gravatar
FROM xf_post AS post
LEFT JOIN xf_user AS user ON (post.user_id = user.user_id)
LEFT JOIN xf_thread AS thread ON (post.thread_id = thread.thread_id)
LEFT JOIN xf_user AS first_post_user ON (thread.user_id = user.user_id)
WHERE post.post_id IN (203, 809, 1070, 1006, 273)
Run Time: 0.002416
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY | PRIMARY | 4 | | 5 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.post.thread_id | 1 | |
SIMPLE | first_post_user | ALL | | | | | 63 | Using where; Using join buffer (Block Nested Loop) |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRQCT_button_top_ctrl', 'BRNLR_brnlr_node_list_render')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000344
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |
SELECT thread.*
,
user.gender, user.avatar_date, user.gravatar
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE ((thread.node_id IN ('71', '72', '73', '74', '75', '76', '77', '85', '79', '80', '81', '82', '83', '84', '2', '16', '17', '18', '19', '20', '21', '22', '3', '23', '24', '25', '26', '27', '4', '28', '29', '30', '31', '32', '43', '5', '33', '34', '35', '36', '37', '38', '6', '39', '40', '41', '42', '44', '45', '46', '47', '48', '49', '58', '59', '60', '61', '62', '63', '64', '65', '66', '67', '68', '69', '7', '50', '51', '52', '53', '54', '55', '8', '56', '57', '9', '11', '12', '13', '14', '15')) AND (thread.discussion_state IN ('visible')))
ORDER BY thread.post_date DESC
LIMIT 15
Run Time: 0.001787
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 | post_date | 4 | | 15 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.thread.user_id | 1 | |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000591
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 87 | Using where |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id IN (72, 72, 77, 77, 77, 14, 13, 13, 14, 11, 13, 13, 13, 14, 13)
Run Time: 0.000819
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | range | PRIMARY | PRIMARY | 4 | | 5 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.forum.node_id | 1 | |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (991, 984, 981, 972, 970)
AND (data.filename LIKE '%.png' OR
data.filename LIKE '%.jpg' OR
data.filename LIKE '%.jpeg' OR
data.filename LIKE '%.jpe' OR
data.filename LIKE '%.gif')
GROUP BY attachment.content_id
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000639
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ALL | content_type_id_date | | | | 20 | Using where; Using temporary; Using filesort |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | diendanv_db.attachment.data_id | 1 | Using where |
SELECT
post.*
FROM xf_post AS post
WHERE post.post_id IN (991, 984, 981, 972, 970)
Run Time: 0.000528
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY | PRIMARY | 4 | | 5 | Using where |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 72
Run Time: 0.000696
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
WHERE node.node_id = ?
Params: 77
Run Time: 0.000625
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('BRQCT_button_top_ctrl', 'BRQCT_navigation_tabs_forums')
AND style_id = ?
AND language_id = ?
Params: 1, 2
Run Time: 0.000361
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |