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.000445
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.000149
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000189
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.*
,
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, 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.album_id > 0) AND (media.media_state IN ('visible')) AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
ORDER BY media.likes DESC, media.media_date DESC, media.media_id DESC
LIMIT 9 OFFSET 36
Run Time: 0.002122
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | ALL | album_id_media_date | | | | 334 | 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 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.category_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.user_id | 1 | |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | xf.media.attachment_id | 1 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | xf.attachment.data_id | 1 | |
SELECT COUNT(*)
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, 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.album_id > 0) AND (media.media_state IN ('visible')) AND (IF(media.album_id > 0, album.album_state = 'visible', 1=1))
Run Time: 0.003150
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | media | ALL | album_id_media_date | | | | 334 | 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 | Using index |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.category_id | 1 | Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.user_id | 1 | Using index |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.user_id | 1 | Using index |
SIMPLE | attachment | eq_ref | PRIMARY,content_type_id_date | PRIMARY | 4 | xf.media.attachment_id | 1 | Using where |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | xf.attachment.data_id | 1 | Using index |
SELECT *
FROM xengallery_category
ORDER BY display_order
Run Time: 0.000257
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_category | ALL | | | | | 36 | Using filesort |
SELECT user.user_id, user.username,
user.xengallery_media_count, user.avatar_date,
user.gravatar, user.avatar_width,
user.avatar_height, user.display_style_group_id
FROM xf_user AS user
WHERE user.xengallery_media_count > 0
AND user.is_banned = 0
ORDER BY user.xengallery_media_count DESC
LIMIT ?
Params: 5
Run Time: 0.000209
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | xengallery_media_count | xengallery_media_count | 4 | | 11 | Using index condition; Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 500b5ca0904a7623756215cd101def12, a:6:{s:12:"sessionStart";i:1714160186;s:2:"ip";s:4:""