SELECT *
FROM xf_tag
WHERE tag_url = ?
Params: premiumsnapchat
Run Time: 0.000409
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag | const | tag_url | tag_url | 302 | const | 1 | |
SELECT *
FROM xf_tag_result_cache
WHERE tag_id = ?
AND user_id = ?
AND expiry_date > ?
Params: 1185, 0, 1711705246
Run Time: 0.000216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_result_cache | const | tag_id_user_id,expiration_date | tag_id_user_id | 8 | const,const | 1 | |
SELECT tag_content_id, content_type, content_id
FROM xf_tag_content
WHERE tag_id = ?
AND visible = 1
ORDER BY content_date DESC
LIMIT 200
Params: 1185
Run Time: 0.000862
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_tag_content | ref | tag_id_content_date | tag_id_content_date | 4 | const | 39 | 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 (2006223, 1974499, 1973365, 1943924, 1943923, 1932151, 1932147, 1928096, 1927759, 1927758, 1911126, 1909825, 1909563, 1889647, 1814931, 1781438, 1098925, 1098914, 1098908, 1098851, 1098839, 1084112, 1060083, 821681, 273655, 192579, 180228, 178800, 177329, 147910, 139866, 132294, 125575, 101723, 97163, 95781, 83442, 82953)
Run Time: 0.005834
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 38 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | dirty.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,dirty.thread.node_id | 1 | Using where |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000223
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_category_map | index | | PRIMARY | 8 | | 4 | 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
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 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), NULL)) AND (media.media_id IN (601)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.000835
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | album | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | albumviewperm | const | PRIMARY | PRIMARY | 5 | const,const | 1 | |
SIMPLE | category | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | attachment | const | PRIMARY,content_type_id_date | PRIMARY | 4 | const | 1 | |
SIMPLE | data | const | PRIMARY | PRIMARY | 4 | const | 1 | |
INSERT INTO xf_tag_result_cache
(tag_id, user_id, cache_date, expiry_date, results)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
cache_date = VALUES(cache_date),
expiry_date = VALUES(expiry_date),
results = VALUES(results)
Params: 1185, 0, 1711705246, 1711708846, [["thread",2006223],["thread",1974499],["thread",1973365],["thread",1943924],["thread",1943923],["thread",1932151],["thread",1932147],["thread",1928096],["thread",1927759],["thread",1927758],["thread",1911126],["thread",1909825],["thread",1909563],["thread",1889647],["thread",1814931],["thread",1781438],["thread",1098925],["thread",1098914],["thread",1098908],["xengallery_media",601],["thread",1098851],["thread",1098839],["thread",1084112],["thread",1060083],["thread",821681],["thread",273655],["thread",192579],["thread",180228],["thread",178800],["thread",177329],["thread",147910],["thread",139866],["thread",132294],["thread",125575],["thread",101723],["thread",97163],["thread",95781],["thread",83442],["thread",82953]]
Run Time: 0.003168
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: e9278b2cbb4a7522c49f9d9a4ba5e65e, , 1711708846
Run Time: 0.000234
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_Tag, Tag, valid, tag_url=premiumsnapchat, 1711705246,
Run Time: 0.000127
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'xengallery_bb_code_tag_gallery', 'search_result_thread', 'xengallery_search_result_media', 'tag_view', 'xengallery_tab_links', 'bdcache_moderator_bar', 'xengallery_comments_block', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 1
Run Time: 0.000669
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 ('BRME_page_container_head')
AND style_id = ?
AND language_id = ?
Params: 3, 1
Run Time: 0.000258
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |