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.004413
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.000605
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.000495
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user.*
,
user_profile.*,
user_option.*,
user_privacy.*
FROM xf_user AS user
LEFT JOIN xf_user_profile AS user_profile ON
(user_profile.user_id = user.user_id)
LEFT JOIN xf_user_option AS user_option ON
(user_option.user_id = user.user_id)
LEFT JOIN xf_user_privacy AS user_privacy ON
(user_privacy.user_id = user.user_id)
WHERE (user.trophy_points > 0) AND (user.is_banned = 0)
ORDER BY user.trophy_points DESC
LIMIT 20
Run Time: 0.002269
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | range | trophy_points | trophy_points | 4 | | 54893 | Using index condition; Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | xen.user.user_id | 1 | |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | xen.user.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | xen.user.user_id | 1 | |
SELECT trophy.*,
user.*,
user_trophy.award_date
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
LEFT JOIN xf_user AS user ON (user.user_id = user_trophy.user_id)
WHERE 1=1
ORDER BY user_trophy.award_date DESC
LIMIT 20
Run Time: 0.399720
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_trophy | index | | user_id_award_date | 8 | | 901761 | Using index; Using filesort |
SIMPLE | trophy | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.trophy_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.user_id | 1 | |
SELECT badge.*, trophy.*
FROM xf_trophy AS trophy
LEFT JOIN xf_badge AS badge ON
(badge.badge_id = trophy.badge_id)
ORDER BY badge.display_order, trophy.trophy_order
Run Time: 0.001070
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | trophy | ALL | | | | | 40 | Using temporary; Using filesort |
SIMPLE | badge | eq_ref | PRIMARY,badge_id_date,badge_id | PRIMARY | 4 | xen.trophy.badge_id | 1 | |
SELECT trophy.*,
user_trophy.award_date
FROM xf_user_trophy AS user_trophy
INNER JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
WHERE user_trophy.user_id = ?
ORDER BY user_trophy.award_date DESC
Params: 0
Run Time: 0.000440
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_trophy | ref | PRIMARY,user_id_award_date | user_id_award_date | 4 | const | 1 | Using where; Using index |
SIMPLE | trophy | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.trophy_id | 1 | |
SELECT COUNT(DISTINCT(user_trophy.user_id)) AS total, trophy.badge_id
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
WHERE (trophy.badge_id IN (1, 2, 3, 6, 5, 4))
GROUP BY trophy.badge_id
Run Time: 0.501773
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | trophy | ALL | PRIMARY | | | | 40 | Using where; Using filesort |
SIMPLE | user_trophy | ref | PRIMARY | PRIMARY | 4 | xen.trophy.trophy_id | 22544 | Using index |
SELECT COUNT(*) AS total,
trophy.badge_id
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
WHERE user_trophy.award_date BETWEEN ? AND ?
GROUP BY trophy.badge_id
Params: 1713560400, 1714106402
Run Time: 0.351058
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_trophy | index | | user_id_award_date | 8 | | 901761 | Using where; Using index; Using temporary; Using filesort |
SIMPLE | trophy | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.trophy_id | 1 | |
SELECT trophy.*,
user.*,
user_trophy.award_date
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
LEFT JOIN xf_user AS user ON (user.user_id = user_trophy.user_id)
WHERE (trophy.badge_id = 1)
GROUP BY user_trophy.user_id
ORDER BY user_trophy.award_date DESC
LIMIT 3
Run Time: 0.074786
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | trophy | ALL | PRIMARY | | | | 40 | Using where; Using temporary; Using filesort |
SIMPLE | user_trophy | ref | PRIMARY,user_id_award_date | PRIMARY | 4 | xen.trophy.trophy_id | 22544 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.user_id | 1 | |
SELECT trophy.*,
user.*,
user_trophy.award_date
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
LEFT JOIN xf_user AS user ON (user.user_id = user_trophy.user_id)
WHERE (trophy.badge_id = 2)
GROUP BY user_trophy.user_id
ORDER BY user_trophy.award_date DESC
LIMIT 3
Run Time: 0.025838
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | trophy | ALL | PRIMARY | | | | 40 | Using where; Using temporary; Using filesort |
SIMPLE | user_trophy | ref | PRIMARY,user_id_award_date | PRIMARY | 4 | xen.trophy.trophy_id | 22544 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.user_id | 1 | |
SELECT trophy.*,
user.*,
user_trophy.award_date
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
LEFT JOIN xf_user AS user ON (user.user_id = user_trophy.user_id)
WHERE (trophy.badge_id = 3)
GROUP BY user_trophy.user_id
ORDER BY user_trophy.award_date DESC
LIMIT 3
Run Time: 4.269539
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | trophy | ALL | PRIMARY | | | | 40 | Using where; Using temporary; Using filesort |
SIMPLE | user_trophy | ref | PRIMARY,user_id_award_date | PRIMARY | 4 | xen.trophy.trophy_id | 22544 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.user_id | 1 | |
SELECT trophy.*,
user.*,
user_trophy.award_date
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
LEFT JOIN xf_user AS user ON (user.user_id = user_trophy.user_id)
WHERE (trophy.badge_id = 6)
GROUP BY user_trophy.user_id
ORDER BY user_trophy.award_date DESC
LIMIT 3
Run Time: 1.603484
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | trophy | ALL | PRIMARY | | | | 40 | Using where; Using temporary; Using filesort |
SIMPLE | user_trophy | ref | PRIMARY,user_id_award_date | PRIMARY | 4 | xen.trophy.trophy_id | 22544 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.user_id | 1 | |
SELECT trophy.*,
user.*,
user_trophy.award_date
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
LEFT JOIN xf_user AS user ON (user.user_id = user_trophy.user_id)
WHERE (trophy.badge_id = 5)
GROUP BY user_trophy.user_id
ORDER BY user_trophy.award_date DESC
LIMIT 3
Run Time: 0.788255
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | trophy | ALL | PRIMARY | | | | 40 | Using where; Using temporary; Using filesort |
SIMPLE | user_trophy | ref | PRIMARY,user_id_award_date | PRIMARY | 4 | xen.trophy.trophy_id | 22544 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.user_id | 1 | |
SELECT trophy.*,
user.*,
user_trophy.award_date
FROM xf_user_trophy AS user_trophy
LEFT JOIN xf_trophy AS trophy ON (trophy.trophy_id = user_trophy.trophy_id)
LEFT JOIN xf_user AS user ON (user.user_id = user_trophy.user_id)
WHERE (trophy.badge_id = 4)
GROUP BY user_trophy.user_id
ORDER BY user_trophy.award_date DESC
LIMIT 3
Run Time: 0.140062
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | trophy | ALL | PRIMARY | | | | 40 | Using where; Using temporary; Using filesort |
SIMPLE | user_trophy | ref | PRIMARY,user_id_award_date | PRIMARY | 4 | xen.trophy.trophy_id | 22544 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | xen.user_trophy.user_id | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: f8a57b9f37d5a98633499d9a3ca48e93, , 1714110002
Run Time: 0.000331
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, , , MasterBadge_ControllerPublic_Badge, Index, valid, , 1714106402,
Run Time: 0.000249
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000326
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRcarta_pages | const | page_slug | page_slug | 302 | const | 1 | |
SELECT options.*, node.*,
permission.cache_value AS node_permission_cache
FROM nat_options AS options
INNER JOIN xf_node AS node
ON (node.node_id = options.node_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = ?
AND permission.content_type = 'node'
AND permission.content_id = options.node_id)
WHERE nat_display_tab = 1
ORDER BY options.nat_display_order
ASC
Params: 1
Run Time: 0.000758
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | options | ALL | node_id | | | | 24 | Using where; Using filesort |
SIMPLE | node | eq_ref | PRIMARY | PRIMARY | 4 | xen.options.node_id | 1 | |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,xen.options.node_id | 1 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('trophy_1_title', 'trophy_1_description', 'trophy_2_title', 'trophy_2_description', 'trophy_3_title', 'trophy_3_description', 'trophy_13_title', 'trophy_13_description', 'trophy_4_title', 'trophy_4_description', 'trophy_22_title', 'trophy_22_description', 'trophy_44_title', 'trophy_44_description', 'trophy_21_title', 'trophy_21_description', 'trophy_43_title', 'trophy_43_description', 'trophy_5_title', 'trophy_5_description', 'trophy_6_title', 'trophy_6_description', 'trophy_7_title', 'trophy_7_description', 'trophy_8_title', 'trophy_8_description', 'trophy_9_title', 'trophy_9_description', 'trophy_18_title', 'trophy_18_description', 'trophy_23_title', 'trophy_23_description', 'trophy_24_title', 'trophy_24_description', 'trophy_12_title', 'trophy_12_description', 'trophy_11_title', 'trophy_11_description', 'trophy_17_title', 'trophy_17_description', 'trophy_20_title', 'trophy_20_description', 'trophy_25_title', 'trophy_25_description', 'trophy_42_title', 'trophy_42_description', 'trophy_31_title', 'trophy_31_description', 'trophy_32_title', 'trophy_32_description', 'trophy_33_title', 'trophy_33_description', 'trophy_34_title', 'trophy_34_description', 'trophy_35_title', 'trophy_35_description', 'trophy_36_title', 'trophy_36_description', 'trophy_37_title', 'trophy_37_description', 'trophy_38_title', 'trophy_38_description', 'trophy_29_title', 'trophy_29_description', 'trophy_30_title', 'trophy_30_description', 'trophy_39_title', 'trophy_39_description', 'trophy_41_title', 'trophy_41_description', 'trophy_40_title', 'trophy_40_description', 'trophy_27_title', 'trophy_27_description', 'trophy_28_title', 'trophy_28_description', 'trophy_10_title', 'trophy_10_description', 'trophy_26_title', 'trophy_26_description', 'MasterBadge_badge_1_title', 'MasterBadge_badge_2_title', 'MasterBadge_badge_3_title', 'MasterBadge_badge_6_title', 'MasterBadge_badge_5_title', 'MasterBadge_badge_4_title', 'BRSTS_support_tickets', 'media')
Params: 2
Run Time: 0.000863
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 88 | Using where |