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.000740
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.000147
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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.album_type = 0) AND (album.content_count > 0) AND (album.album_state IN ('visible','moderated'))
Run Time: 0.001968
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ALL | | | | | 164 | 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.album_type = 0) AND (album.content_count > 0) AND (album.album_state IN ('visible','moderated'))
ORDER BY album.album_date DESC, album.album_updated_date DESC
LIMIT 40
Run Time: 0.001286
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ALL | | | | | 164 | 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 (6027, 6011, 6004, 5975, 5967, 5959, 5942, 5895, 5867, 5833, 5836, 5787, 5712, 5663, 5615, 5609, 5595, 5592, 5564, 5534, 5451, 5469, 5483, 4855, 5478, 5448, 5474, 5441, 5416, 3885, 4932, 2844, 5417, 4863, 4744, 4416, 5386, 5382, 4640, 4953))
Run Time: 0.002293
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | content | range | PRIMARY,content_type_id | PRIMARY | 4 | | 40 | 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: 7e47f5dad92ba092815c23c1584587e7, a:6:{s:12:"sessionStart";i:1611413903;s:2:"ip";s:4:"腍";s:11:"sessionCsrf";s:16:"dgfd9OLMxbEtcATm";s:9:"userAgent";s:40:"CCBot/2.0 (https://commoncrawl.org/faq/)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;}, 1611417503
Run Time: 0.000205
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, NewAlbums, valid, , 1611413903,
Run Time: 0.000114
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'sonnb_xengallery_gallery_new_albums', '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.004643
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.000146
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 2 | Using where |