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.002660
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.000295
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
0 AS forum_is_watched
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = forum.node_id)
WHERE node.node_id = ?
Params: 3
Run Time: 0.000453
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 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT COUNT(*)
FROM xf_thread AS thread
WHERE (thread.node_id = 3) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))
Run Time: 0.000362
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_sticky_state_last_post | 6 | const,const,const | 29 | Using index |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count
,thread_thumbnail.attachment_id as altt_attachment_id
,thread_thumbnail.image_url as altt_image_url
,thread_thumbnail.is_auto_thumbnail as altt_is_auto_thumbnail
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN algp_guest_content AS guest_content ON
(guest_content.content_id = thread.thread_id AND guest_content.content_type='thread')
LEFT JOIN altt_thread_thumbnail AS thread_thumbnail ON
(thread_thumbnail.thread_id = thread.thread_id)
WHERE (thread.node_id = 3) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.last_post_date DESC
LIMIT 100
Run Time: 0.000923
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_sticky_state_last_post | 6 | const,const,const | 29 | Backward index scan |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | addonslab_xf1.thread.user_id | 1 | |
SIMPLE | guest_content | eq_ref | content_id_type | content_id_type | 31 | addonslab_xf1.thread.thread_id,const | 1 | Using where; Using index |
SIMPLE | thread_thumbnail | eq_ref | PRIMARY | PRIMARY | 4 | addonslab_xf1.thread.thread_id | 1 | Using where |
SELECT thread.*
,
user.*, IF(user.username IS NULL, thread.username, user.username) AS username,
NULL AS thread_read_date,
0 AS thread_is_watched,
0 AS user_post_count
,thread_thumbnail.attachment_id as altt_attachment_id
,thread_thumbnail.image_url as altt_image_url
,thread_thumbnail.is_auto_thumbnail as altt_is_auto_thumbnail
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
LEFT JOIN algp_guest_content AS guest_content ON
(guest_content.content_id = thread.thread_id AND guest_content.content_type='thread')
LEFT JOIN altt_thread_thumbnail AS thread_thumbnail ON
(thread_thumbnail.thread_id = thread.thread_id)
WHERE (thread.node_id = 3) AND (thread.sticky = 1) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.last_post_date DESC
Run Time: 0.000343
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | ref | node_id_last_post_date,node_id_sticky_state_last_post | node_id_sticky_state_last_post | 6 | const,const,const | 1 | Backward index scan |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | addonslab_xf1.thread.user_id | 1 | |
SIMPLE | guest_content | eq_ref | content_id_type | content_id_type | 31 | addonslab_xf1.thread.thread_id,const | 1 | Using where; Using index |
SIMPLE | thread_thumbnail | eq_ref | PRIMARY | PRIMARY | 4 | addonslab_xf1.thread.thread_id | 1 | Using where |
SELECT *
FROM xf_node
WHERE lft > ? AND rgt < ?
AND display_in_list = 1
ORDER BY lft ASC
Params: 8, 17
Run Time: 0.000331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | range | display_in_list,lft | display_in_list | 5 | | 8 | Using index condition; Using where |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000204
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 13 | 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 (5, 6, 8, 9)
Run Time: 0.000264
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | range | PRIMARY | PRIMARY | 4 | | 4 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | addonslab_xf1.forum.node_id | 1 | Using index |
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.attachment_id IN('', '', '', '', '', 4, 1, 2, 6, '', 8, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '')
Run Time: 0.000355
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | PRIMARY | PRIMARY | 4 | | 6 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | addonslab_xf1.attachment.data_id | 1 | |
SELECT route_prefix.*
, addon.active
FROM xf_route_prefix AS route_prefix
LEFT JOIN xf_addon AS addon ON (addon.addon_id = route_prefix.addon_id)
WHERE route_prefix.route_type = ?
AND (addon.active IS NULL OR addon.active = 1)
ORDER BY route_prefix.original_prefix
Params: admin
Run Time: 0.000412
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | route_prefix | ref | PRIMARY | PRIMARY | 1 | const | 77 | |
SIMPLE | addon | eq_ref | PRIMARY | PRIMARY | 27 | addonslab_xf1.route_prefix.addon_id | 1 | Using where |
SELECT prefix.*
,
fp.*
FROM xf_thread_prefix AS prefix
INNER JOIN xf_forum_prefix AS fp ON
(fp.prefix_id = prefix.prefix_id)
WHERE (fp.node_id = 3)
ORDER BY prefix.materialized_order
Run Time: 0.000282
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | fp | ref | PRIMARY,prefix_id | PRIMARY | 4 | const | 2 | Using index; Using temporary; Using filesort |
SIMPLE | prefix | eq_ref | PRIMARY | PRIMARY | 4 | addonslab_xf1.fp.prefix_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d088420ee34f1e9f2c45bba2cc72453b, , 1711726731
Run Time: 0.002510
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, Forum, valid, node_id=3, 1711723131,
Run Time: 0.002356
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'node_forum_level_2', 'node_forum_level_n', 'forum_view', 'notice_cookies', 'alwn_tab_links', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000459
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 7 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('alqt_thread_prompt_title_1', 'alqt_thread_prompt_title_2', 'alqt_thread_prompt_title_3', 'alqt_thread_prompt_title_4', 'alqt_thread_prompt_title_5', 'alwn_overview', 'alwn_whats_new')
Params: 1
Run Time: 0.000248
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 7 | Using where |