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.000598
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.000192
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT resource_category.*
,
permission.cache_value AS category_permission_cache
FROM xf_resource_category AS resource_category
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'resource_category'
AND permission.content_id = resource_category.resource_category_id)
ORDER BY resource_category.lft
Run Time: 0.000350
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource_category | ALL | | | | | 31 | Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.resource_category.resource_category_id | 1 | |
SELECT resource.*
,
category.*, category.last_update AS category_last_update, resource.last_update,
version.version_string,
version.release_date,
version.download_url,
version.rating_count AS version_rating_count,
version.rating_sum AS version_rating_sum,
version.download_count AS version_download_count,
user.*, user_profile.*, IF(user.username IS NULL, resource.username, user.username) AS username,
feature.feature_date
FROM xf_resource AS resource
LEFT JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
LEFT JOIN xf_resource_version AS version ON
(version.resource_version_id = resource.current_version_id)
LEFT JOIN xf_user AS user ON
(user.user_id = resource.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = resource.user_id)
LEFT JOIN xf_resource_feature AS feature ON
(feature.resource_id = resource.resource_id)
WHERE (resource.resource_category_id IN (2, 3, 4, 12, 15, 20, 5, 6, 7, 16, 21, 22, 8, 9, 10, 13, 14, 11, 17, 18, 19, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32)) AND (resource.resource_state IN ('visible'))
ORDER BY resource.download_count DESC, resource.last_update DESC
LIMIT 20
Run Time: 0.003985
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 125 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.resource_category_id | 1 | |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.user_id | 1 | |
SIMPLE | feature | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.resource_id | 1 | |
SELECT resource.*
,
category.*, category.last_update AS category_last_update, resource.last_update,
version.version_string,
version.release_date,
version.download_url,
version.rating_count AS version_rating_count,
version.rating_sum AS version_rating_sum,
version.download_count AS version_download_count,
user.*, user_profile.*, IF(user.username IS NULL, resource.username, user.username) AS username,
feature.feature_date
FROM xf_resource AS resource
LEFT JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
LEFT JOIN xf_resource_version AS version ON
(version.resource_version_id = resource.current_version_id)
LEFT JOIN xf_user AS user ON
(user.user_id = resource.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = resource.user_id)
LEFT JOIN xf_resource_feature AS feature ON
(feature.resource_id = resource.resource_id)
WHERE (resource.resource_category_id IN (2, 3, 4, 12, 15, 20, 5, 6, 7, 16, 21, 22, 8, 9, 10, 13, 14, 11, 17, 18, 19, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32)) AND (resource.resource_state IN ('visible'))
ORDER BY resource.rating_weighted DESC, resource.last_update DESC
LIMIT 5
Run Time: 0.002500
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 125 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.resource_category_id | 1 | |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.user_id | 1 | |
SIMPLE | feature | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.resource_id | 1 | |
SELECT rating.*
,
resource.*, resource.title AS resource_title,
resource.user_id AS resource_user_id,
IF(resource_user.username IS NULL, resource.username, resource_user.username) AS resource_username,
resource_user.gender AS resource_gender,
resource_user.avatar_date AS resource_avatar_date,
resource_user.gravatar AS resource_gravatar,
rating.user_id,
category.*, category.last_update AS category_last_update, resource.last_update,
user.*, user_profile.*,
permission.cache_value AS category_permission_cache
FROM xf_resource_rating AS rating
INNER JOIN xf_resource AS resource ON
(resource.resource_id = rating.resource_id)
LEFT JOIN xf_user AS resource_user ON
(resource_user.user_id = resource.user_id)
INNER JOIN xf_resource_category AS category ON
(category.resource_category_id = resource.resource_category_id)
LEFT JOIN xf_user AS user ON
(user.user_id = rating.user_id)
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = rating.user_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'resource_category'
AND permission.content_id = resource.resource_category_id)
WHERE (resource.resource_category_id IN (2, 3, 4, 12, 15, 20, 5, 6, 7, 16, 21, 22, 8, 9, 10, 13, 14, 11, 17, 18, 19, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32)) AND (rating.rating_state IN ('visible')) AND (rating.is_review = 1) AND (rating.rating_date > 1573085339)
ORDER BY rating.rating_date DESC
LIMIT 5
Run Time: 0.002112
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | rating | range | resource_id_rating_date,rating_date | rating_date | 4 | | 1 | Using where |
SIMPLE | resource | eq_ref | PRIMARY,category_last_update,category_rating_weighted | PRIMARY | 4 | nma_xen.rating.resource_id | 1 | Using where |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.resource_category_id | 1 | Using where |
SIMPLE | resource_user | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.resource.user_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.rating.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.rating.user_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,nma_xen.resource.resource_category_id | 1 | |
SELECT user.*, user_profile.*
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user.user_id = user_profile.user_id)
WHERE user.resource_count > 0
AND user.is_banned = 0
ORDER BY user.resource_count DESC
LIMIT 5
Run Time: 0.000966
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | resource_count | resource_count | 4 | | 18 | Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | nma_xen.user.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 95daa9064c07f945a875b939b9d8d49c, , 1575680939
Run Time: 0.000298
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, , , XenResource_ControllerPublic_Resource, Index, valid, , 1575677339,
Run Time: 0.000219
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'resource_index', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', '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.000823
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 22 | Using where |