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.000432
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.000163
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: 9
Run Time: 0.000609
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 | |
SELECT *
FROM xengallery_album_permission
WHERE album_id = ?
Params: 2
Run Time: 0.000154
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_album_permission | ref | PRIMARY | PRIMARY | 4 | const | 2 | |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: xengalleryFieldsInfo
Run Time: 0.000115
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
INSERT DELAYED INTO xengallery_media_view
(media_id)
VALUES
(?)
Params: 9
Run Time: 0.000068
SELECT *
FROM xengallery_user_tag
WHERE media_id = ?
Params: 9
Run Time: 0.000156
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, 9, 0
Run Time: 0.000144
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.000196
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.album_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: 9, 2
Run Time: 0.000422
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | ref | PRIMARY,album_id_media_date | album_id_media_date | 4 | const | 12 | Using index condition; Using where; Using filesort |
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.album_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: 9, 2
Run Time: 0.000328
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | range | PRIMARY,album_id_media_date | PRIMARY | 4 | | 8 | 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 = 9) AND (comment.content_type = 'media') AND (comment.comment_state IN ('visible'))
ORDER BY comment.comment_date ASC
LIMIT 10
Run Time: 0.000452
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 = 9) AND (comment.content_type = 'media') AND (comment.comment_state IN ('visible'))
Run Time: 0.000147
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-9, 0
Run Time: 0.000127
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | no matching row in const table |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d81ed0faaaf88cfe810f1e599d66b035, , 1715883861
Run Time: 0.000134
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=9, 1715880261,
Run Time: 0.000091
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.000423
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 13 | Using where |