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.000474
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.000155
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.000175
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 album.*, permission.*
,
shared.shared_user_id, private.private_user_id,
user.*, user_profile.*, IF(user.username IS NULL, album.album_username, user.username) AS username
FROM xengallery_album AS album
LEFT JOIN xengallery_shared_map AS shared ON
(shared.album_id = album.album_id AND shared.shared_user_id = 0)
LEFT JOIN xengallery_private_map AS private ON
(private.album_id = album.album_id AND private.private_user_id = 0)
LEFT JOIN xf_user AS user ON
(user.user_id = album.album_user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = album.album_user_id)
LEFT JOIN xengallery_album_permission AS permission ON
(album.album_id = permission.album_id
AND permission.permission = 'view')
WHERE (
private.private_user_id IS NOT NULL
OR shared.shared_user_id IS NOT NULL
OR permission.access_type = 'public'
) AND (album.album_state IN ('visible'))
ORDER BY album.album_create_date DESC
LIMIT 9 OFFSET 27
Run Time: 0.001010
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ALL | | | | | 21 | Using where; Using filesort |
SIMPLE | shared | eq_ref | PRIMARY | PRIMARY | 8 | xf.album.album_id,const | 1 | Using index |
SIMPLE | private | eq_ref | PRIMARY | PRIMARY | 8 | xf.album.album_id,const | 1 | Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf.album.album_user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xf.album.album_user_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 5 | xf.album.album_id,const | 1 | Using where |
SELECT data_value
FROM xf_data_registry
WHERE data_key = ?
Params: xengalleryFieldsInfo
Run Time: 0.000114
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |
SELECT COUNT(*)
FROM xengallery_album AS album
LEFT JOIN xengallery_album_permission AS permission ON
(album.album_id = permission.album_id AND permission.permission = 'view')
LEFT JOIN xengallery_shared_map AS shared ON
(shared.album_id = album.album_id AND shared.shared_user_id = 0)
LEFT JOIN xengallery_private_map AS private ON
(private.album_id = album.album_id AND private.private_user_id = 0)
LEFT JOIN xf_user AS user ON
(user.user_id = album.album_user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = album.album_user_id)
WHERE (
private.private_user_id IS NOT NULL
OR shared.shared_user_id IS NOT NULL
OR permission.access_type = 'public'
) AND (album.album_state IN ('visible'))
Run Time: 0.000551
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ALL | | | | | 21 | Using where |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 5 | xf.album.album_id,const | 1 | |
SIMPLE | shared | eq_ref | PRIMARY | PRIMARY | 8 | xf.album.album_id,const | 1 | Using index |
SIMPLE | private | eq_ref | PRIMARY | PRIMARY | 8 | xf.album.album_id,const | 1 | Using where; Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf.album.album_user_id | 1 | Using index |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xf.album.album_user_id | 1 | Using index |
SELECT *
FROM xengallery_category
ORDER BY display_order
Run Time: 0.000265
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xengallery_category | ALL | | | | | 36 | Using filesort |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000183
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 album.*, permission.*
,
shared.shared_user_id, private.private_user_id,
user.*, user_profile.*, IF(user.username IS NULL, album.album_username, user.username) AS username
FROM xengallery_album AS album
LEFT JOIN xengallery_shared_map AS shared ON
(shared.album_id = album.album_id AND shared.shared_user_id = 0)
LEFT JOIN xengallery_private_map AS private ON
(private.album_id = album.album_id AND private.private_user_id = 0)
LEFT JOIN xf_user AS user ON
(user.user_id = album.album_user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = album.album_user_id)
LEFT JOIN xengallery_album_permission AS permission ON
(album.album_id = permission.album_id
AND permission.permission = 'view')
WHERE (
private.private_user_id IS NOT NULL
OR shared.shared_user_id IS NOT NULL
OR permission.access_type = 'public'
) AND (album.album_media_count > 0) AND (user.is_banned = 0) AND (album.album_state IN ('visible'))
ORDER BY album.album_create_date DESC
LIMIT 5
Run Time: 0.000561
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ALL | album_user_id_album_create_date | | | | 21 | Using where; Using filesort |
SIMPLE | shared | eq_ref | PRIMARY | PRIMARY | 8 | xf.album.album_id,const | 1 | Using index |
SIMPLE | private | eq_ref | PRIMARY | PRIMARY | 8 | xf.album.album_id,const | 1 | Using index |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf.album.album_user_id | 1 | Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xf.album.album_user_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 5 | xf.album.album_id,const | 1 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 9bba7e8ecc032e2600cf28e113158682, , 1711694313
Run Time: 0.000159
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_Album, Index, valid, , 1711690713,
Run Time: 0.000098
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'xengallery_album_wrapper', 'xengallery_bb_code_tag_gallery', 'xengallery_album_index', 'xengallery_tab_links', 'xengallery_comments_block', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000358
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 8 | Using where |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000201
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 comment.*, media.media_title, media.media_type, media.media_id, media.media_state, media.attachment_id, media.media_tag, media.category_id,
album.album_title, album.album_description, albumviewperm.access_type, albumviewperm.share_users, album.album_id, album.album_state, album.album_user_id, album.album_thumbnail_date, user.*, container.album_state AS albumstate,
attachment.data_id, data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xengallery_comment AS comment
LEFT JOIN xengallery_media AS media ON
(comment.content_id = media.media_id AND comment.content_type = 'media')
LEFT JOIN xf_attachment AS attachment ON
(attachment.attachment_id = media.attachment_id)
LEFT JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
LEFT JOIN xengallery_album AS album ON
(comment.content_id = album.album_id AND comment.content_type = 'album')
LEFT JOIN xengallery_album_permission AS albumviewperm ON
(album.album_id = albumviewperm.album_id AND albumviewperm.permission = 'view')
LEFT JOIN xengallery_album AS container ON
(container.album_id = media.album_id)
LEFT JOIN xf_user AS user ON
(comment.user_id = user.user_id)
LEFT JOIN xengallery_shared_map AS shared ON
(shared.album_id = COALESCE(album.album_id, media.album_id) AND shared.shared_user_id = 0)
LEFT JOIN xengallery_private_map AS private ON
(private.album_id = COALESCE(album.album_id, media.album_id) AND private.private_user_id = 0)
WHERE (container.album_state IS NULL OR container.album_state = 'visible' OR album.album_state = 'visible')
AND user.is_banned = 0
AND (media.media_state IS NULL OR media.media_state = 'visible')
AND (album.album_state IS NULL OR album.album_state = 'visible')
AND (
private.private_user_id IS NOT NULL
OR shared.shared_user_id IS NOT NULL
OR media.media_privacy = 'public'
OR albumviewperm.access_type = '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 comment.comment_state = 'visible'
ORDER BY comment.comment_date DESC
LIMIT 5
Run Time: 0.000676
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | comment | ALL | user_id | | | | 12 | Using where; Using filesort |
SIMPLE | media | eq_ref | PRIMARY | PRIMARY | 4 | xf.comment.content_id | 1 | Using where |
SIMPLE | attachment | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.attachment_id | 1 | |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | xf.attachment.data_id | 1 | |
SIMPLE | album | eq_ref | PRIMARY | PRIMARY | 4 | xf.comment.content_id | 1 | Using where |
SIMPLE | shared | eq_ref | PRIMARY | PRIMARY | 8 | func,const | 1 | Using where; Using index |
SIMPLE | private | eq_ref | PRIMARY | PRIMARY | 8 | func,const | 1 | Using where; Using index |
SIMPLE | albumviewperm | eq_ref | PRIMARY | PRIMARY | 5 | xf.album.album_id,const | 1 | Using where |
SIMPLE | container | eq_ref | PRIMARY | PRIMARY | 4 | xf.media.album_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xf.comment.user_id | 1 | Using where |