SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routesPublic', 'routeFiltersIn', 'routeFiltersOut', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'trophyUserTitles', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.001399
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: e4122464d0d9a0452bd621bf99827e1f, 1716027723
Run Time: 0.000226
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000198
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.is_staff = 1)
ORDER BY user.username ASC
Run Time: 0.006832
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | ref | staff_username | staff_username | 1 | const | 8 | Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | XENFORO.user.user_id | 1 | |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | XENFORO.user.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | XENFORO.user.user_id | 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.is_banned = 0)
ORDER BY user.message_count DESC
LIMIT 20
Run Time: 0.012994
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | index | | message_count | 4 | | 378 | Using where |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | XENFORO.user.user_id | 1 | |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | XENFORO.user.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | XENFORO.user.user_id | 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_profile.dob_month = ?
AND user_profile.dob_day = ?
AND user_option.show_dob_date = 1
AND ((user.user_state = 'valid') AND (user.is_banned = 0))
ORDER BY user.username
LIMIT 20
Params: 5, 18
Run Time: 0.001668
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user_profile | ref | PRIMARY,dob | dob | 2 | const,const | 1 | Using where; Using temporary; Using filesort |
SIMPLE | user | eq_ref | PRIMARY,user_state | PRIMARY | 4 | XENFORO.user_profile.user_id | 1 | Using where |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | XENFORO.user_profile.user_id | 1 | Using where |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | XENFORO.user_option.user_id | 1 | |
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = 'e4122464d0d9a0452bd621bf99827e1f')
Params: 1716031323
Run Time: 0.000195
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, 59574023, 59574023, XenForo_ControllerPublic_Member, Index, valid, , 1716027723,
Run Time: 0.000154
SELECT page_name FROM EWRcarta_pages WHERE page_slug = 'index'
Run Time: 0.000186
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRcarta_pages | const | page_slug | page_slug | 302 | const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'ragtek_invite_visitortab', 'member_notable', 'EWRcarta_Navtabs', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 1, 3
Run Time: 0.031217
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 160 | | 4 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('wiki')
Params: 3
Run Time: 0.000220
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 81 | const,const | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('bbm_js')
AND style_id = ?
AND language_id = ?
Params: 1, 3
Run Time: 0.000229
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 160 | const,const,const | 1 | |
SELECT xf_user.user_id, xf_user.username, xf_user.email, fam.field_value AS lname, name_fio.field_value AS fname, otch_fio.field_value AS mname
FROM ((xf_user LEFT JOIN (SELECT user_id, field_id, field_value FROM xf_user_field_value WHERE field_id="fam") AS fam ON xf_user.user_id = fam.user_id) LEFT JOIN (SELECT user_id, field_id, field_value FROM xf_user_field_value WHERE field_id="name_fio") AS name_fio ON xf_user.user_id = name_fio.user_id) LEFT JOIN (SELECT user_id, field_id, field_value FROM xf_user_field_value WHERE field_id="otch_fio") AS otch_fio ON xf_user.user_id = otch_fio.user_id
WHERE
(
xf_user.user_id In (
SELECT user_id FROM xf_user_group_relation WHERE user_group_id In (6)
)
)
And (
xf_user.user_id Not In (
SELECT xf_user_field_value.user_id FROM xf_user_field_value
WHERE (xf_user_field_value.field_id="idhtline") AND (Length(Trim(field_value))>0)
)
or
xf_user.user_id Not In (
SELECT xf_user_field_value.user_id FROM xf_user_field_value
WHERE (xf_user_field_value.field_id="uid_ht_line") AND (Length(Trim(field_value))>0)
)
)
Run Time: 0.008775
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | xf_user | ALL | | | | | 378 | Using where |
PRIMARY | <derived2> | ALL | | | | | 369 | |
PRIMARY | <derived3> | ALL | | | | | 369 | |
PRIMARY | <derived4> | ALL | | | | | 369 | |
DEPENDENT SUBQUERY | xf_user_field_value | unique_subquery | PRIMARY,field_id | PRIMARY | 81 | func,const | 1 | Using where |
DEPENDENT SUBQUERY | xf_user_field_value | unique_subquery | PRIMARY,field_id | PRIMARY | 81 | func,const | 1 | Using where |
DEPENDENT SUBQUERY | xf_user_group_relation | unique_subquery | PRIMARY,user_group_id_is_primary | PRIMARY | 8 | func,const | 1 | Using index; Using where |
DERIVED | xf_user_field_value | ref | field_id | field_id | 77 | | 377 | Using where |
DERIVED | xf_user_field_value | ref | field_id | field_id | 77 | | 371 | Using where |
DERIVED | xf_user_field_value | ref | field_id | field_id | 77 | | 379 | Using where |