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.000469
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | ALL | PRIMARY | | | | 35 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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_id = ?
Params: 296
Run Time: 0.000630
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 | 0 | unique row not found |
SIMPLE | albumviewperm | const | PRIMARY | | | | 1 | Impossible ON condition |
SIMPLE | category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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 DELAYED INTO xengallery_media_view
(media_id)
VALUES
(?)
Params: 296
Run Time: 0.000071
SELECT *
FROM xengallery_user_tag
WHERE media_id = ?
Params: 296
Run Time: 0.000177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_user_tag | ref | media_id | media_id | 4 | const | 1 | |
SELECT *
FROM xf_liked_content
WHERE content_type = ?
AND content_id = ?
AND like_user_id = ?
Params: xengallery_media, 296, 0
Run Time: 0.000138
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000199
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_category_map | index | | PRIMARY | 8 | | 296 | Using where; Using index |
SELECT media.media_id, media.media_title, media.media_type, media.last_edit_date,
media.media_description, media.user_id, media.username, media.position, media.media_date
,
album.*, albumviewperm.*
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')
WHERE media.media_id > ?
AND media.category_id = ?
AND (
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, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41), NULL)) AND (media.media_state IN ('visible')) AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
ORDER BY media.media_id ASC
LIMIT 1
Params: 296, 38
Run Time: 0.000419
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | range | PRIMARY,category_id_media_date | PRIMARY | 4 | | 167 | Using where |
SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.album_id | 1 | Using where |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | xf.album.album_id,const | 1 | |
SELECT media.media_id, media.media_title, media.media_type, media.last_edit_date,
media.media_description, media.user_id, media.username, media.position, media.media_date
,
album.*, albumviewperm.*
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')
WHERE media.media_id < ?
AND media.category_id = ?
AND (
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, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41), NULL)) AND (media.media_state IN ('visible')) AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
ORDER BY media.media_id DESC
LIMIT 1
Params: 296, 38
Run Time: 0.000350
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | range | PRIMARY,category_id_media_date | PRIMARY | 4 | | 167 | Using where |
SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.album_id | 1 | Using where |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | xf.album.album_id,const | 1 | |
SELECT comment.*
,
media.media_id, media.media_title, media.media_description, media.media_type, media.media_state,
media.comment_count, media.user_id AS media_user_id, media.username AS media_username, media.media_date, media.album_id, media.media_tag,
user.*, user_profile.*, IF(user.username IS NULL, comment.username, user.username) AS username,
category.*,
album.album_id, album.album_title, album.album_state,
album.album_user_id, album.album_username, albumviewperm.*,
rating.content_id, rating.rating_id, rating.rating, rating.rating_date
FROM xengallery_comment AS comment
LEFT JOIN xengallery_media AS media ON
(media.media_id = comment.content_id AND comment.content_type = 'media')
LEFT JOIN xf_user AS user ON
(user.user_id = comment.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = comment.user_id)
LEFT JOIN xengallery_category AS category ON
(category.category_id = media.category_id)
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_rating AS rating ON
(rating.rating_id = comment.rating_id)
WHERE (comment.content_id = 296) AND (comment.content_type = 'media') AND (comment.comment_state IN ('visible'))
ORDER BY comment.comment_date ASC
LIMIT 10
Run Time: 0.000451
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | comment | ref | content_type_content_id_comment_date | content_type_content_id_comment_date | 5 | const,const | 1 | Using index condition; Using where |
SIMPLE | media | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf.comment.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xf.comment.user_id | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.category_id | 1 | |
SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.album_id | 1 | |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | xf.album.album_id,const | 1 | |
SIMPLE | rating | eq_ref | PRIMARY | PRIMARY | 4 | xf.comment.rating_id | 1 | |
SELECT COUNT(*)
FROM xengallery_comment AS comment
WHERE (comment.content_id = 296) AND (comment.content_type = 'media') AND (comment.comment_state IN ('visible'))
Run Time: 0.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | comment | ref | content_type_content_id_comment_date | content_type_content_id_comment_date | 5 | const,const | 1 | Using where |
SELECT *
FROM xf_draft
WHERE draft_key = ? AND user_id = ?
Params: media-296, 0
Run Time: 0.000132
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: xengalleryFieldsInfo
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 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d635a4f8737058cd5666ce5cdf783770, , 1714833068
Run Time: 0.000145
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, , , XenGallery_ControllerPublic_Media, View, valid, media_id=296, 1714829468,
Run Time: 0.000116
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'xengallery_bb_code_tag_gallery', 'xengallery_media_view', 'xengallery_tab_links', 'xengallery_comments_block', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000405
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 13 | Using where |