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.000451
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.000156
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: 251
Run Time: 0.000610
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: 251
Run Time: 0.000076
SELECT *
FROM xengallery_user_tag
WHERE media_id = ?
Params: 251
Run Time: 0.000173
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, 251, 0
Run Time: 0.000139
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.000198
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: 251, 35
Run Time: 0.000386
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | ref | PRIMARY,category_id_media_date | category_id_media_date | 4 | const | 3 | 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.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: 251, 35
Run Time: 0.000356
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | ref | PRIMARY,category_id_media_date | category_id_media_date | 4 | const | 3 | 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 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 = 251) AND (comment.content_type = 'media') AND (comment.comment_state IN ('visible'))
ORDER BY comment.comment_date ASC
LIMIT 10
Run Time: 0.000458
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 = 251) 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-251, 0
Run Time: 0.000134
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.000122
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: 16613cc6a1301b09922eb6a68e784045, , 1713559895
Run Time: 0.000199
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=251, 1713556295,
Run Time: 0.000102
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.000398
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 13 | Using where |