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 | index | post_date | 4 | 200 | Using where | ||
SIMPLE | posting_user | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.profile_post.user_id | 1 | |
SIMPLE | receiving_user | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.profile_post.profile_user_id | 1 | |
SIMPLE | receiving_user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.profile_post.profile_user_id | 1 | |
SIMPLE | receiving_user_follow | eq_ref | PRIMARY,follow_user_id | PRIMARY | 8 | ccxsccxs_dd.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 |
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)