SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000641
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_tag
WHERE tag_url = ?
Params: elk
Run Time: 0.001290
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: 445, 0, 1611035704
Run Time: 0.000537
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 500
Params: 445
Run Time: 0.001557
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 | 44 | 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 (700847, 591450, 570278, 559127)
Run Time: 0.001718
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 4 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.thread.user_id | 1 | |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.thread.node_id | 1 | |
SIMPLE | post | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.thread.first_post_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xf_michigan.thread.node_id | 1 | Using where |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000617
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_category_map | index | | PRIMARY | 8 | | 819 | 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 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 (2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59), NULL)) AND (media.media_id IN (110697, 109683, 90648, 90647, 90645, 90227, 75595, 75500, 75499, 75498, 75497, 73609, 73013, 68077, 68044, 67104, 64917, 61198, 59129, 57387, 56878, 53696, 53393, 53391, 53390, 53364, 53362, 53361, 53358, 52883, 52571, 51144, 51143, 50099, 50098, 50072, 50071, 50042)) AND (media.media_state = 'visible') AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.006425
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | range | PRIMARY | PRIMARY | 4 | | 38 | Using where |
SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.media.album_id | 1 | Using where |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | xf_michigan.album.album_id,const | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.media.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.media.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.media.user_id | 1 | |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | xf_michigan.media.attachment_id | 1 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | xf_michigan.attachment.data_id | 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: 445, 0, 1611035704, 1611039304, [["thread",700847],["thread",591450],["thread",570278],["thread",559127],["xengallery_media",110697],["xengallery_media",109683],["xengallery_media",90648],["xengallery_media",90647],["xengallery_media",90645],["xengallery_media",90227],["xengallery_media",75595],["xengallery_media",75500],["xengallery_media",75499],["xengallery_media",75498],["xengallery_media",75497],["xengallery_media",73609],["xengallery_media",73013],["xengallery_media",68077],["xengallery_media",68044],["xengallery_media",67104],["xengallery_media",64917],["xengallery_media",61198],["xengallery_media",59129],["xengallery_media",57387],["xengallery_media",56878],["xengallery_media",53696],["xengallery_media",53393],["xengallery_media",53391],["xengallery_media",53390],["xengallery_media",53364],["xengallery_media",53362],["xengallery_media",53361],["xengallery_media",53358],["xengallery_media",52883],["xengallery_media",52571],["xengallery_media",51144],["xengallery_media",51143],["xengallery_media",50099],["xengallery_media",50098],["xengallery_media",50072],["xengallery_media",50071],["xengallery_media",50042]]
Run Time: 0.003793
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=elk&page=2, 1611035704,
Run Time: 0.003570
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000817
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_widget | ALL | | | | | 25 | Using where; Using filesort |