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.004051
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.000391
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000291
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*,
0 AS following_0
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
WHERE user.user_id = ?
Params: 8666
Run Time: 0.001083
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT search_index.content_type, search_index.content_id
FROM xf_search_index AS search_index
WHERE search_index.user_id = ?
ORDER BY search_index.item_date DESC
LIMIT 15
Params: 8666
Run Time: 0.000666
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | search_index | ref | user_id_item_date | user_id_item_date | 4 | const | 8 | Using where |
SELECT conversation_master.*,
conversation_user.*,
conversation_starter.*,
conversation_message.username AS username,
conversation_recipient.recipient_state, conversation_recipient.last_read_date,
conversation_message.*
FROM xf_conversation_message AS conversation_message
INNER JOIN xf_conversation_user AS conversation_user ON
(conversation_message.conversation_id = conversation_user.conversation_id)
INNER JOIN xf_conversation_master AS conversation_master ON
(conversation_user.conversation_id = conversation_master.conversation_id)
INNER JOIN xf_conversation_recipient AS conversation_recipient ON
(conversation_user.conversation_id = conversation_recipient.conversation_id
AND conversation_user.owner_user_id = conversation_recipient.user_id)
INNER JOIN xf_user AS conversation_starter ON
(conversation_starter.user_id = conversation_message.user_id)
WHERE conversation_user.owner_user_id = ?
AND conversation_message.message_id IN (5127, 5123, 2328)
ORDER BY conversation_user.last_message_date DESC
Params: 0
Run Time: 0.014038
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | conversation_user | ref | PRIMARY,owner_user_id_last_message_date,owner_user_id_is_unread,owner_starred_date | owner_user_id_last_message_date | 4 | const | 1 | Using temporary; Using filesort |
SIMPLE | conversation_recipient | eq_ref | PRIMARY,user_id | PRIMARY | 8 | k46624_forum.conversation_user.conversation_id,const | 1 | Using where |
SIMPLE | conversation_master | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.conversation_user.conversation_id | 1 | |
SIMPLE | conversation_message | range | PRIMARY,conversation_id_message_date,user_id | PRIMARY | 4 | | 3 | Using where; Using join buffer (Block Nested Loop) |
SIMPLE | conversation_starter | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.conversation_message.user_id | 1 | |
SELECT conversation_message.*,
conversation_master.*,
conversation_user.*,
conversation_starter.*,
conversation_master.username AS username,
conversation_recipient.recipient_state, conversation_recipient.last_read_date
FROM xf_conversation_user AS conversation_user
INNER JOIN xf_conversation_master AS conversation_master ON
(conversation_user.conversation_id = conversation_master.conversation_id)
INNER JOIN xf_conversation_message AS conversation_message ON
(conversation_message.message_id = conversation_master.first_message_id)
INNER JOIN xf_conversation_recipient AS conversation_recipient ON
(conversation_user.conversation_id = conversation_recipient.conversation_id
AND conversation_user.owner_user_id = conversation_recipient.user_id)
INNER JOIN xf_user AS conversation_starter ON
(conversation_starter.user_id = conversation_master.user_id)
WHERE conversation_user.owner_user_id = ?
AND conversation_user.conversation_id IN (771)
ORDER BY conversation_user.last_message_date DESC
Params: 0
Run Time: 0.001234
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT
post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
permission.cache_value AS node_permission_cache
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE post.post_id IN (16358, 16357, 16355, 16293, 16265)
Run Time: 0.001174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | | 5 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | k46624_forum.post.thread_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,k46624_forum.thread.node_id | 1 | Using where |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
node.title AS node_title, node.node_name,
post.message, post.attach_count,
NULL AS thread_read_date,
0 AS user_post_count,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_post AS post ON
(post.post_id = thread.first_post_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
WHERE thread.thread_id IN (2524)
Run Time: 0.000610
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: f57b996c66a456cbb8f80d83e1fb9cb9, a:9:{s:12:"sessionStart";i:1713556995;s:2:"ip";s:4:"ݍ,";s:11:"sessionCsrf";s:16:"BLiZLh-UgsRMAf2F";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;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1625316255;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1465599440;}s:11:"sedoQuattro";a:1:{s:18:"noJsonRequestPaths";a:6:{s:8:"basePath";s:1:"/";s:4:"host";s:16:"octagon-forum.eu";s:8:"protocol";s:5:"https";s:12:"fullBasePath";s:25:"https://octagon-forum.eu/";s:10:"requestUri";s:44:"/members/kamaxx.8666/recent-content?_debug=1";s:7:"fullUri";s:68:"https://octagon-forum.eu/members/kamaxx.8666/recent-content?_debug=1";}}}, 1713560595
Run Time: 0.000281
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_Member, RecentContent, valid, user_id=8666, 1713556995,
Run Time: 0.000241
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'search_result_post', 'search_result_thread', 'wf_widget_wrapper', 'member_recent_content', 'notice_cookies', 'resources_tab_links', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 4
Run Time: 0.000608
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 10 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbm_js')
AND style_id = ?
AND language_id = ?
Params: 3, 4
Run Time: 0.000350
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |