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.003695
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.000344
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.000427
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.001796
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 COUNT(*)
FROM xf_resource_rating AS rating
WHERE (rating.rating_state IN ('visible')) AND (rating.is_review = 1) AND (rating.rating_date > 1710992128)
Run Time: 0.000383
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | rating | range | rating_date | rating_date | 4 | | 1 | Using index condition; Using where |
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 > 1710992128)
ORDER BY rating.rating_date DESC
LIMIT 20
Run Time: 0.001882
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 |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d6b21f27a340696f2225f8a9b3e35755, , 1713587728
Run Time: 0.000340
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, Reviews, valid, , 1713584128,
Run Time: 0.000272
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'wf_widget_wrapper', 'resource_latest_reviews', '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.000902
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.000285
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |