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')
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 >= ?
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 = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT * FROM xf_search WHERE search_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT profile_post.* , posting_user.*, IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username, receiving_user.username AS profile_username, receiving_user.gender AS profile_gender, receiving_user.user_state AS profile_user_state, receiving_user.user_group_id AS profile_user_group_id, receiving_user.secondary_group_ids AS profile_secondary_group_ids, receiving_user.display_style_group_id AS profile_display_style_group_id, receiving_user.is_banned AS profile_is_banned, receiving_user.is_admin AS profile_is_admin, receiving_user.is_moderator AS profile_is_moderator, receiving_user.avatar_date AS profile_avatar_date, receiving_user.gravatar AS profile_gravatar, receiving_user.warning_points AS profile_warning_points, receiving_user.permission_combination_id AS profile_permission_combination_id, receiving_user_privacy.allow_view_profile AS profile_allow_view_profile, receiving_user_privacy.allow_post_profile AS profile_allow_post_profile, receiving_user_privacy.allow_send_personal_conversation AS profile_allow_send_personal_conversation, receiving_user_privacy.allow_view_identities AS profile_allow_view_identities, receiving_user_privacy.allow_receive_news_feed AS profile_allow_allow_receive_news_feed, IF (receiving_user_follow.follow_user_id, 1, 0) AS following_0 FROM xf_profile_post AS profile_post LEFT JOIN xf_user AS posting_user ON (posting_user.user_id = profile_post.user_id) LEFT JOIN xf_user AS receiving_user ON (receiving_user.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_privacy AS receiving_user_privacy ON (receiving_user_privacy.user_id = profile_post.profile_user_id) LEFT JOIN xf_user_follow AS receiving_user_follow ON (receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 0) WHERE (profile_post.message_state IN ('visible')) ORDER BY profile_post.post_date DESC LIMIT 200
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | profile_post | ALL | 1219 | Using where; Using filesort | ||||
SIMPLE | posting_user | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.profile_post.user_id | 1 | |
SIMPLE | receiving_user | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.profile_post.profile_user_id | 1 | |
SIMPLE | receiving_user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | degreeinfo_xenforo.profile_post.profile_user_id | 1 | |
SIMPLE | receiving_user_follow | eq_ref | PRIMARY,follow_user_id | PRIMARY | 8 | degreeinfo_xenforo.profile_post.profile_user_id,const | 1 | Using index |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_ban.*, user.username, banning_user.username AS banning_username FROM xf_user_ban AS user_ban LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id) LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id) WHERE user_ban.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_ban | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | banning_user | const | PRIMARY | PRIMARY | 4 | const | 1 |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = 'da81d4fa998d242af572a145493d5123')