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.000456
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000159
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user.*
FROM xf_user AS user
WHERE user.user_id = ?
Params: 14180
Run Time: 0.000241
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | 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 1000
Params: 14180
Run Time: 0.016307
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 | 309 | Using where |
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,
apppromotions.posid AS posid
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)
LEFT JOIN xf_snog_applications_promotions AS apppromotions
ON (apppromotions.post_id = post.post_id)
WHERE post.post_id IN (264252, 263425, 263416, 263414, 263411, 263409, 259658, 259642, 259636, 257589, 257587, 253332, 252263, 251330, 250898, 250872, 250866, 250860, 250621, 250613, 250522, 250374, 249808, 249805, 249607, 249526, 249337, 249315, 249246, 249132, 249131, 249099, 249095, 249084, 249071, 249070, 249066, 249061, 249058, 249019, 249015, 249008, 249002, 248991, 248989, 248981, 248976, 248895, 248891, 248882, 248879, 248876, 248873, 248871, 248334, 248296, 248217, 247634, 247630, 246603, 246578, 246573, 246440, 246437, 245869, 245607, 245597, 245206, 244905, 244899, 244692, 244485, 244458, 244284, 244070, 244065, 244039, 243963, 243928, 243862, 243861, 243780, 243768, 243741, 243739, 243726, 243708, 243515, 243511, 243463, 243439, 243437, 243435, 243434, 243432, 243392, 243302, 243180, 243173, 243123, 243029, 243002, 242793, 242588, 242583, 242555, 242551, 242511, 242492, 242491, 242437, 242434, 242432, 242429, 242428, 242425, 242385, 242318, 242313, 242267, 242257, 242256, 242247, 242244, 242234, 242233, 242232, 242052, 242028, 241993, 241967, 241966, 241903, 241894, 241845, 241841, 241819, 241812, 241803, 241230, 240877, 240869, 239071, 238977, 238664, 237948, 237444, 237441, 237411, 237057, 236904, 236898, 236890, 236877, 236837, 235991, 235878, 235491, 235124, 235038, 234982, 234951, 234859, 234303, 234100, 234058, 233761, 233756, 233713, 233692, 233691, 233622, 233315, 233291, 233278, 232498, 232360, 232048, 231356, 230980, 230979, 230948, 230919, 230729, 230710, 230577, 230378, 230162, 230109, 230106, 229970, 229964, 229681, 229635, 229547, 229514, 229505, 229504, 229503, 229497, 229370, 228919, 228918, 228906, 227306, 225570, 225555, 225082, 225078, 225007, 224791, 224711, 224668, 224403, 224402, 224393, 224337, 224335, 224274, 224237, 224235, 224234, 224048, 224026, 223872, 223871, 223870, 223395, 223197, 223146, 223141, 223140, 222957, 222010, 221793, 221717, 214960, 192140, 192139, 191843, 191579, 191578, 191577, 191573, 190930, 190929, 190907, 190790, 190620, 190570, 190506, 190489, 190479, 188804, 188799, 188798, 188793)
Run Time: 0.033307
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 | | 257 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.post.user_id | 1 | |
SIMPLE | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | wristhax_forum.post.thread_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.thread.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,wristhax_forum.thread.node_id | 1 | Using where |
SIMPLE | apppromotions | ALL | post_id | | | | 1 | Using where; Using join buffer (flat, BNL join) |
SELECT profile_post_comment.*
,
user.*,
IF(user.username IS NULL, profile_post_comment.username, user.username) AS username
FROM xf_profile_post_comment AS profile_post_comment
LEFT JOIN xf_user AS user ON
(user.user_id = profile_post_comment.user_id)
WHERE profile_post_comment.profile_post_comment_id IN (8161, 7230)
Run Time: 0.000807
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | profile_post_comment | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.profile_post_comment.user_id | 1 | |
SELECT profile_post.*
,
receiving_user.username
AS profile_username,
receiving_user.gender
AS profile_gender,
receiving_user.user_state
AS profile_user_state,
receiving_user.user_group_id
AS profile_user_group_id,
receiving_user.secondary_group_ids
AS profile_secondary_group_ids,
receiving_user.display_style_group_id
AS profile_display_style_group_id,
receiving_user.is_banned
AS profile_is_banned,
receiving_user.is_admin
AS profile_is_admin,
receiving_user.is_moderator
AS profile_is_moderator,
receiving_user.avatar_date
AS profile_avatar_date,
receiving_user.gravatar
AS profile_gravatar,
receiving_user.warning_points
AS profile_warning_points,
receiving_user.permission_combination_id
AS profile_permission_combination_id
FROM xf_profile_post AS profile_post
LEFT JOIN xf_user AS receiving_user ON
(receiving_user.user_id = profile_post.profile_user_id)
WHERE profile_post.profile_post_id IN(7067, 8696)
Run Time: 0.000207
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | profile_post | range | PRIMARY | PRIMARY | 4 | | 2 | Using where |
SIMPLE | receiving_user | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.profile_post.profile_user_id | 1 | |
SELECT user.*
,
user_privacy.*,
0 AS following_0
FROM xf_user AS user
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
WHERE user.user_id IN (14180)
ORDER BY user.username
Run Time: 0.000258
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 (33463, 32710, 32521, 32272, 32213, 31998, 31985, 31965, 31956, 31858, 31261, 30932, 30814, 30699, 30628, 30335, 30014, 29666, 29645, 29244, 29040, 28985, 28901, 28810, 28706, 28698, 28696, 28693, 28673, 28591, 28588, 28341, 28107, 27976, 27932, 27912, 27910, 27888, 27887, 27853, 27846, 27811, 27810, 27809, 27752, 27723, 27709, 27708, 27685, 27537, 27500, 27487, 26354, 22777, 22739, 22737, 22545)
Run Time: 0.000837
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 57 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | wristhax_forum.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,wristhax_forum.thread.node_id | 1 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 0225eed3f8f844a26f72262ea0b8fbfd, , 1714465632
Run Time: 0.000120
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_Search, Member, valid, , 1714462032,
Run Time: 0.000059
SELECT user_group_id, title
FROM xf_user_group
WHERE user_group_id IN (3,4,5,15,17,20,24,25,28,32,33,34)
ORDER BY FIELD(user_group_id,3,4,5,32,24,34,28,25,15,33,17,20)
Run Time: 0.000119
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_group | index | PRIMARY | title | 152 | | 20 | Using where; Using index; Using filesort |
SELECT user_id, user_group_id
FROM xf_user_group_relation
WHERE user_group_id IN (3,4,5,15,17,20,24,25,28,32,33,34)
ORDER BY user_group_id
Run Time: 0.000173
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_group_relation | range | user_group_id_is_primary | user_group_id_is_primary | 4 | | 83 | Using where; Using index |
SELECT type.appid, type.type, type.navtab, type.user_criteria as usercriteria, position.posid, position.position, position.user_criteria
FROM xf_snog_applications_types as type
LEFT JOIN xf_snog_applications_positions as position
ON position.appid = type.appid AND position.active = 1
WHERE type.navtab = 1 AND type.active = 1
ORDER BY type.type, position.position
Run Time: 0.000425
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | type | ALL | | | | | 3 | Using where; Using temporary; Using filesort |
SIMPLE | position | ref | appid | appid | 4 | wristhax_forum.type.appid | 1 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'aadvapp_sidebar', 'message_page', 'XenStaff_links', 'addm_navigation', 'steam_helper_criteria_privs', 'steam_navtabs', 'steam_public_index', 'dark_taigachat', 'dark_taigachat_list', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 43, 1
Run Time: 0.000223
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 13 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('no_results_found', 'addm_donations')
Params: 1
Run Time: 0.000102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 2 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('aadvapp_sidebar', 'nat_bodyjs')
AND style_id = ?
AND language_id = ?
Params: 43, 1
Run Time: 0.000103
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |