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.000845
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 24 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000274
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT thread.*
,
last_post_user.gender AS last_post_gender,
last_post_user.avatar_date AS last_post_avatar_date,
last_post_user.gravatar AS last_post_gravatar,
IF(last_post_user.username IS NULL, thread.last_post_username, last_post_user.username) AS last_post_username,
node.title AS node_title, node.node_name,
forum.*,
forum.last_post_id AS forum_last_post_id,
forum.last_post_date AS forum_last_post_date,
forum.last_post_user_id AS forum_last_post_user_id,
forum.last_post_username AS forum_last_post_username,
forum.last_thread_title AS forum_last_thread_title,
thread.last_post_id,
thread.last_post_date,
thread.last_post_user_id,
thread.last_post_username,
NULL AS thread_read_date,
permission.cache_value AS node_permission_cache
FROM xf_thread AS thread FORCE INDEX (last_post_date)
LEFT JOIN xf_user AS last_post_user ON
(last_post_user.user_id = thread.last_post_user_id)
LEFT JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_forum AS forum ON
(forum.node_id = thread.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 = thread.node_id)
WHERE (thread.discussion_type <> 'redirect') AND (thread.discussion_state IN ('visible')) AND (thread.last_post_date > 1712103247) AND (forum.find_new = 1)
ORDER BY thread.last_post_date DESC
LIMIT 20
Run Time: 0.002021
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | last_post_date | last_post_date | 4 | | 1 | Using index condition; Using where; Using temporary; Using filesort |
SIMPLE | forum | eq_ref | PRIMARY | PRIMARY | 4 | forum.thread.node_id | 1 | Using where |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,forum.thread.node_id | 1 | Using where |
SIMPLE | last_post_user | ALL | | | | | 12971 | Using where; Using join buffer (flat, BNL join) |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | forum.thread.node_id | 1 | |
SELECT *
FROM xf_node
WHERE display_in_list = 1
ORDER BY lft ASC
Run Time: 0.000837
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_node | ALL | display_in_list | | | | 32 | 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.000421
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 31 | 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, 3, 4, 5, 11, 13, 14, 42, 20, 21, 23, 24, 28, 29, 30, 31, 32, 33, 34, 35, 36, 25, 41)
Run Time: 0.000763
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | ALL | PRIMARY | | | | 25 | Using where |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | forum.forum.node_id | 1 | Using index |
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 > 1714694347)
ORDER BY session_activity.view_date DESC
Run Time: 0.118231
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 20 | Using where; Using temporary; Using filesort |
SIMPLE | user | ALL | | | | | 12971 | Using where; Using join buffer (flat, BNL join) |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000269
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: da06e1a12c0684701547228f8854ea0a, , 1714698847
Run Time: 0.000230
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=, 1714695247,
Run Time: 0.000101
SELECT count(*)
FROM dark_taigachat_activity AS activity
LEFT JOIN xf_user AS user ON
(user.user_id = activity.user_id)
WHERE activity.date > UNIX_TIMESTAMP()-150
AND user.visible=1
Run Time: 0.000197
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: simpleCache, a:1:{s:20:"taigachat_lastUpdate";i:1714695247;}
Run Time: 0.001488
SELECT `image`.*, `user`.user_id, `user`.username, `album`.title AS albumTitle,
`data`.filename, `data`.description, `data`.file_size, `data`.file_hash, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xfr_useralbum_image AS `image`
INNER JOIN xfr_useralbum_image_data AS `data` ON
(`data`.data_id = `image`.data_id)
INNER JOIN xfr_useralbum AS `album` ON
(`album`.album_id = `image`.album_id)
INNER JOIN xf_user AS `user` ON
(`user`.user_id = `album`.user_id)
WHERE `album`.album_type = "public" AND moderation = 0
ORDER BY `image`.image_date DESC
LIMIT 6
Run Time: 0.001402
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | image | ALL | album_id_date | | | | 1 | Using temporary; Using filesort |
SIMPLE | album | eq_ref | PRIMARY,user_id | PRIMARY | 4 | forum.image.album_id | 1 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | forum.image.data_id | 1 | |
SIMPLE | user | ALL | | | | | 12971 | Using where; Using join buffer (flat, BNL join) |
SELECT album.*
,
user.*,
image_data.data_id AS image_data_id, image_data.file_hash AS image_file_hash
FROM xfr_useralbum AS album
LEFT JOIN xf_user AS user ON
(user.user_id = album.user_id)
LEFT JOIN xfr_useralbum_image AS image ON image.image_id = album.last_image_id
LEFT JOIN xfr_useralbum_image_data AS image_data ON image_data.data_id = image.data_id
WHERE album.moderation = 0 AND (album.album_type = 'public' OR album.album_type = 'global') AND album.last_image_date > 0
ORDER BY album.last_image_date DESC, album.createdate DESC
LIMIT 5
Run Time: 0.001434
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ALL | | | | | 3 | Using where; Using temporary; Using filesort |
SIMPLE | user | ALL | | | | | 12971 | Using where; Using join buffer (flat, BNL join) |
SIMPLE | image | eq_ref | PRIMARY | PRIMARY | 4 | forum.album.last_image_id | 1 | |
SIMPLE | image_data | eq_ref | PRIMARY | PRIMARY | 4 | forum.image.data_id | 1 | Using where |