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.002899
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000341
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000351
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.001956
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource_category | ALL | | | | | 88 | Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,k46624_forum.resource_category.resource_category_id | 1 | Using where |
SELECT resource.*,
feature.feature_date
,
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
FROM xf_resource_feature AS feature
INNER JOIN xf_resource AS resource ON (resource.resource_id = feature.resource_id)
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)
WHERE resource.resource_category_id IN (89, 2, 5, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 6, 40, 41, 42, 3, 7, 8, 9, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 10, 56, 57, 58, 17, 87, 11, 59, 60, 13, 12, 77, 75, 76, 16, 61, 62, 14, 15, 78, 79, 80, 82, 88, 81, 84, 85, 86, 18, 19, 20, 21, 63, 64, 65, 22, 23, 66, 67, 24, 25, 68, 69, 70, 71, 26, 27, 72, 73, 74)
ORDER BY RAND() LIMIT 6
Run Time: 0.029004
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | feature | index | PRIMARY | feature_date | 4 | | 1 | Using index; Using temporary; Using filesort |
SIMPLE | resource | eq_ref | PRIMARY,category_last_update,category_rating_weighted | PRIMARY | 4 | k46624_forum.feature.resource_id | 1 | Using where |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.resource_category_id | 1 | Using where |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.user_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 (89, 2, 5, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 6, 40, 41, 42, 3, 7, 8, 9, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 10, 56, 57, 58, 17, 87, 11, 59, 60, 13, 12, 77, 75, 76, 16, 61, 62, 14, 15, 78, 79, 80, 82, 88, 81, 84, 85, 86, 18, 19, 20, 21, 63, 64, 65, 22, 23, 66, 67, 24, 25, 68, 69, 70, 71, 26, 27, 72, 73, 74)) AND (resource.resource_state IN ('visible'))
ORDER BY resource.last_update DESC
LIMIT 20 OFFSET 40
Run Time: 0.002099
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 257 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.resource_category_id | 1 | Using where |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.user_id | 1 | |
SIMPLE | feature | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.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 (89, 2, 5, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 6, 40, 41, 42, 3, 7, 8, 9, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 10, 56, 57, 58, 17, 87, 11, 59, 60, 13, 12, 77, 75, 76, 16, 61, 62, 14, 15, 78, 79, 80, 82, 88, 81, 84, 85, 86, 18, 19, 20, 21, 63, 64, 65, 22, 23, 66, 67, 24, 25, 68, 69, 70, 71, 26, 27, 72, 73, 74)) AND (resource.resource_state IN ('visible'))
ORDER BY resource.rating_weighted DESC, resource.last_update DESC
LIMIT 5
Run Time: 0.001940
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource | ALL | category_last_update,category_rating_weighted | | | | 257 | Using where; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.resource_category_id | 1 | Using where |
SIMPLE | version | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.current_version_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.user_id | 1 | |
SIMPLE | feature | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.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 (89, 2, 5, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 6, 40, 41, 42, 3, 7, 8, 9, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 10, 56, 57, 58, 17, 87, 11, 59, 60, 13, 12, 77, 75, 76, 16, 61, 62, 14, 15, 78, 79, 80, 82, 88, 81, 84, 85, 86, 18, 19, 20, 21, 63, 64, 65, 22, 23, 66, 67, 24, 25, 68, 69, 70, 71, 26, 27, 72, 73, 74)) AND (rating.rating_state IN ('visible')) AND (rating.is_review = 1) AND (rating.rating_date > 1711502070)
ORDER BY rating.rating_date DESC
LIMIT 5
Run Time: 0.001514
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 index condition; Using where |
SIMPLE | resource | eq_ref | PRIMARY,category_last_update,category_rating_weighted | PRIMARY | 4 | k46624_forum.rating.resource_id | 1 | Using where |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.resource_category_id | 1 | Using where |
SIMPLE | resource_user | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.resource.user_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.rating.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.rating.user_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,k46624_forum.resource.resource_category_id | 1 | Using where |
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.001207
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | resource_count | resource_count | 4 | | 17 | Using index condition; Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | k46624_forum.user.user_id | 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.001145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | resource_category | ALL | | | | | 88 | Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,k46624_forum.resource_category.resource_category_id | 1 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: b45c2a96f856d8597fef4e837387f986, , 1714097670
Run Time: 0.000334
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, , 1714094070,
Run Time: 0.000224
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'wf_widget_wrapper', 'resource_index', 'notice_cookies', 'resources_tab_links', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 3, 4
Run Time: 0.000742
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 8 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbm_js')
AND style_id = ?
AND language_id = ?
Params: 3, 4
Run Time: 0.000401
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |