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.001176
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.000174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT grp.*,user.*
FROM xf_snog_socialgroup as grp
LEFT JOIN xf_user AS user ON
(user.user_id = grp.owner_id)
WHERE node_id = 5
Run Time: 0.000617
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | grp | ref | node_id | node_id | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.grp.owner_id | 1 | |
SELECT node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
0 AS forum_is_watched,
0 AS forum_is_ignored, 0 AS forum_ignore_news_feed,
0 AS forum_ignore_new_posts, 0 AS forum_ignore_forum_list
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: 5
Run Time: 0.000493
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 node.*, forum.*
,
permission.cache_value AS node_permission_cache,
NULL AS forum_read_date,
0 AS forum_is_watched,
0 AS forum_is_ignored, 0 AS forum_ignore_news_feed,
0 AS forum_ignore_new_posts, 0 AS forum_ignore_forum_list
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: 5
Run Time: 0.000431
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 = 5) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible')) AND (thread.thread_noworkflow = 1 OR thread.thread_analog = 1 OR thread.thread_digital = 1 OR thread.thread_hybrid = 1)
Run Time: 0.001360
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 | 527 | Using index condition; 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,
0 AS thread_is_ignored, 0 AS thread_ignore_news_feed,
0 AS thread_ignore_new_posts, 0 AS thread_ignore_forum_view
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE (thread.node_id = 5) AND (thread.sticky = 0) AND (thread.discussion_state IN ('visible')) AND (thread.thread_noworkflow = 1 OR thread.thread_analog = 1 OR thread.thread_digital = 1 OR thread.thread_hybrid = 1)
ORDER BY thread.last_post_date DESC
LIMIT 25
Run Time: 0.000840
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 | 527 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.thread.user_id | 1 | |
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,
0 AS thread_is_ignored, 0 AS thread_ignore_news_feed,
0 AS thread_ignore_new_posts, 0 AS thread_ignore_forum_view
FROM xf_thread AS thread
LEFT JOIN xf_user AS user ON
(user.user_id = thread.user_id)
WHERE (thread.node_id = 5) AND (thread.sticky = 1) AND (thread.discussion_state IN ('visible')) AND (thread.thread_noworkflow = 1 OR thread.thread_analog = 1 OR thread.thread_digital = 1 OR thread.thread_hybrid = 1)
ORDER BY thread.last_post_date DESC
Run Time: 0.000784
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 | 12 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.thread.user_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, data.xfa_flogo_target_url
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 (5)
ORDER BY attachment.content_id, attachment.attach_date
Params: xfaFlogo
Run Time: 0.000266
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition; Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.attachment.data_id | 1 | |
SELECT COUNT(thread_id)
FROM xf_thread
WHERE user_id = ?
AND post_date > ?
Params: 0, 1524600539
Run Time: 0.000182
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | range | post_date,user_id | post_date | 4 | | 26 | Using index condition; Using where |
SELECT thread.*,post.post_date
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
LEFT JOIN xf_forum_ignore_th AS forum_ignore
ON (forum_ignore.node_id = thread.node_id
AND forum_ignore.user_id = 0)
LEFT JOIN xf_thread_ignore_th AS thread_ignore
ON (thread_ignore.thread_id = thread.thread_id
AND thread_ignore.user_id = 0)
WHERE post.user_id = 0 AND forum_ignore.user_id IS NULL AND thread_ignore.user_id IS NULL
ORDER BY post.post_date DESC
LIMIT 5
Run Time: 0.364368
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | index | thread_id_post_date,thread_id_position,user_id | post_date | 4 | | 235 | Using where |
SIMPLE | thread | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.post.thread_id | 1 | |
SIMPLE | forum_ignore | eq_ref | PRIMARY,node_id_ignore_news_feed,node_id_ignore_new_posts,node_id_ignore_forum_list | PRIMARY | 8 | const,photrio_main.thread.node_id | 1 | Using where; Not exists; Using index |
SIMPLE | thread_ignore | eq_ref | PRIMARY,thread_id_ignore_news_feed,thread_id_ignore_new_posts,thread_id_ignore_forum_view | PRIMARY | 8 | const,photrio_main.post.thread_id | 1 | Using where; Not exists; Using index |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 15
Run Time: 0.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 316
Run Time: 0.000105
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT thread.*
FROM xf_thread AS thread
WHERE (thread.node_id IN ('152', '153', '154', '155', '156')) AND (thread.thread_noworkflow = 1 OR thread.thread_analog = 1 OR thread.thread_digital = 1 OR thread.thread_hybrid = 1)
ORDER BY thread.post_date DESC
LIMIT 5
Run Time: 0.000434
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 | | 12 | Using where |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 152
Run Time: 0.000127
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, node, 153
Run Time: 0.000105
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000131
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_category_map | index | | PRIMARY | 8 | | 189 | Using where; Using index |
SELECT media.*
,
album.*, albumviewperm.*,
category.*,
user.*, user_profile.*, IF(user.username IS NULL, media.username, user.username) AS username,
attachment.attachment_id, attachment.data_id, attachment.attach_date,data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height, data.xfa_flogo_target_url
FROM xengallery_media AS media
LEFT JOIN xengallery_album AS album ON
(album.album_id = media.album_id)
LEFT JOIN xengallery_album_permission as albumviewperm ON
(album.album_id = albumviewperm.album_id AND albumviewperm.permission = 'view')
LEFT JOIN xengallery_category AS category FORCE INDEX (PRIMARY) ON
(category.category_id = media.category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = media.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = media.user_id)
LEFT JOIN xf_attachment AS attachment ON
(attachment.content_type = 'xengallery_media' AND attachment.attachment_id = media.attachment_id)
LEFT JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE (
media.media_privacy = 'public'
OR IF(media.category_id > 0, media.category_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18), NULL)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1)) AND (media.mgmedia_noworkflow = 1 OR media.mgmedia_analog = 1 OR media.mgmedia_digital = 1 OR media.mgmedia_hybrid = 1)
ORDER BY media.media_date DESC, media.media_id DESC
LIMIT 2
Run Time: 0.001691
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | index | | media_date | 4 | | 2 | Using where |
SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.media.album_id | 1 | Using where |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | photrio_main.album.album_id,const | 1 | Using where |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.media.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.media.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.media.user_id | 1 | |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | photrio_main.media.attachment_id | 1 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.attachment.data_id | 1 | |
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 > 1524254939)
ORDER BY session_activity.view_date DESC
Run Time: 0.007708
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 2095 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.session_activity.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: c56600b2b24ead707791f13ac3fc1321, , 1524695939
Run Time: 0.000159
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=5, 1524686939,
Run Time: 0.000082
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('pht_home_news', 'snog_socialgroups_groups')
Params: 1
Run Time: 0.000188
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 2 | Using where |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: boardTotals
Run Time: 0.000117
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
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 > 1524254939)
ORDER BY session_activity.view_date DESC
Run Time: 0.007232
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | session_activity | range | view_date | view_date | 4 | | 2095 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | photrio_main.session_activity.user_id | 1 | |