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.000438
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000132
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT category.*
FROM `sonnb_xengallery_category` AS category
WHERE (category.category_id = 22)
LIMIT 1
Run Time: 0.000324
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT category.*
FROM `sonnb_xengallery_category` AS category
WHERE 1=1
ORDER BY category.lft ASC, category.display_order ASC
Run Time: 0.000216
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | ALL | | | | | 137 | Using filesort |
SELECT COUNT(*)
FROM `sonnb_xengallery_album` AS album
LEFT JOIN `xf_user` AS user ON
(user.user_id = album.user_id)
LEFT JOIN `sonnb_xengallery_category` AS category ON
(album.category_id = category.category_id)
WHERE (album.category_id IN (125, 54, 55, 56, 57, 58, 60, 63, 64, 69, 90, 95, 96, 97, 99, 100, 53, 106, 107, 108, 110, 112, 124, 126, 132, 135, 147, 149, 152, 153, 22)) AND (album.album_type = 0) AND (album.content_count > 0) AND (album.album_state IN ('visible','moderated'))
Run Time: 0.001228
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ALL | category_update_date | | | | 198 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.album.user_id | 1 | Using index |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.album.category_id | 1 | Using index |
SELECT album.*
,
0 AS like_date,
0 AS watch_date,
IF(user.username IS NULL, album.username, user.username) AS username, user.avatar_date, user.gravatar,
0 AS following_0,
category.category_privacy
FROM `sonnb_xengallery_album` AS album
LEFT JOIN `xf_user` AS user ON
(user.user_id = album.user_id)
LEFT JOIN `sonnb_xengallery_category` AS category ON
(album.category_id = category.category_id)
WHERE (album.category_id IN (125, 54, 55, 56, 57, 58, 60, 63, 64, 69, 90, 95, 96, 97, 99, 100, 53, 106, 107, 108, 110, 112, 124, 126, 132, 135, 147, 149, 152, 153, 22)) AND (album.album_type = 0) AND (album.content_count > 0) AND (album.album_state IN ('visible','moderated'))
ORDER BY album.album_updated_date DESC
LIMIT 40
Run Time: 0.001550
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | range | category_update_date | category_update_date | 4 | | 61 | Using where; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.album.user_id | 1 | |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.album.category_id | 1 | |
SELECT content.*
,
content_data.*
FROM `sonnb_xengallery_content` AS content
INNER JOIN `sonnb_xengallery_content_data` AS content_data ON
(content.content_data_id = content_data.content_data_id)
WHERE (content.content_id IN (6228, 5386, 5382, 5353, 5205, 3321, 4595, 4441, 3986, 4101, 4154, 2669, 3700, 3869, 3822, 3529, 2554, 1951, 1047, 2517, 2479, 2463, 2059, 882, 1004, 1931, 1884, 990, 929, 853, 795))
Run Time: 0.001908
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | content | range | PRIMARY,content_type_id | PRIMARY | 4 | | 31 | Using where |
SIMPLE | content_data | eq_ref | PRIMARY,content_type_id | PRIMARY | 4 | nma_xen.content.content_data_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: c7621d5b37ea6e01de1bdb051a566cb8, , 1653399149
Run Time: 0.000240
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, , , sonnb_XenGallery_ControllerPublic_XenGallery_Category, View, valid, category_id=22, 1653395549,
Run Time: 0.000143
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'sonnb_xengallery_category_view', 'sonnb_xengallery_navbar_template', 'resources_tab_links', 'EWRporta2_Navtabs', 'dark_postrating', 'dark_postrating_member', 'dark_postrating_member_totals', 'message_user_info_extra', 'user_criteria_content', 'thread_list_item_icon_key', 'dark_postrating_member_notable_tabs', 'dark_postrating_account_wrapper', 'dark_postrating_navigation_visitor_tab', 'dark_postrating_visitor_panel', 'dark_postrating_member_card', 'dark_postrating_member_info', 'dark_postrating_message_user_info', 'sonnb_xengallery_nav_visitor', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 4, 1
Run Time: 0.002381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 22 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('sonnbXG_copyright', 'sonnb_xengallery_copyright')
AND style_id = ?
AND language_id = ?
Params: 4, 1
Run Time: 0.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |