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.000457
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.000146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*,
IF (session_activity.view_date IS NULL, user.last_activity, session_activity.view_date) AS effective_last_activity,
session_activity.view_date, session_activity.controller_name, session_activity.controller_action, session_activity.params, session_activity.ip,
0 AS following_0
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
LEFT JOIN xf_session_activity AS session_activity ON
(session_activity.user_id = user.user_id AND session_activity.unique_key = CAST(user.user_id AS BINARY))
WHERE user.user_id = ?
Params: 168
Run Time: 0.000441
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 0 | unique row not found |
SELECT category_id
FROM xengallery_category_map
WHERE view_user_group_id IN (1)
Run Time: 0.000191
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_user_id = 168) AND (album.album_state IN ('visible'))
ORDER BY album.album_likes DESC, album.album_create_date DESC
LIMIT 9
Run Time: 0.000668
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ref | album_user_id_album_create_date | album_user_id_album_create_date | 4 | const | 19 | Using index condition; 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 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 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.000123
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_user_id = 168) AND (album.album_state IN ('visible'))
Run Time: 0.000338
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ref | album_user_id_album_create_date | album_user_id_album_create_date | 4 | const | 19 | 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 | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | Using index |
SELECT *
FROM xengallery_category
ORDER BY display_order
Run Time: 0.000260
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.000228
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.000575
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: 0cec89e12294f6d1460c33a2f27d4a1a, , 1713909445
Run Time: 0.000151
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_User, Albums, valid, user_id=168, 1713905845,
Run Time: 0.000088
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'xengallery_album_wrapper', 'xengallery_bb_code_tag_gallery', 'xengallery_user_albums', 'xengallery_tab_links', 'xengallery_comments_block', 'xengallery_media_block_items', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 1
Run Time: 0.000324
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.000192
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.000654
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 |