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 user.* , user_profile.*, user_option.*, user_privacy.*, permission_combination.cache_value AS global_permission_cache, IF (session_activity.view_date IS NULL, user.last_activity, session_activity.view_date) AS effective_last_activity, session_activity.view_date, session_activity.controller_name, session_activity.controller_action, session_activity.params, session_activity.ip, 0 AS following_0 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) LEFT JOIN xf_permission_combination AS permission_combination ON (permission_combination.permission_combination_id = user.permission_combination_id) LEFT JOIN xf_session_activity AS session_activity ON (session_activity.user_id = user.user_id AND session_activity.unique_key = CAST(user.user_id AS BINARY)) WHERE user.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 |
SELECT thread.* , node.title AS node_title, node.node_name, permission.cache_value AS node_permission_cache FROM xf_thread AS thread LEFT JOIN xf_node AS node ON (node.node_id = thread.node_id) LEFT JOIN xf_permission_cache_content AS permission ON (permission.permission_combination_id = 1 AND permission.content_type = 'node' AND permission.content_id = thread.node_id) WHERE thread.thread_id IN (25041)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT COUNT(*) FROM xf_profile_post AS profile_post WHERE (profile_post.profile_user_id = 6) AND (profile_post.message_state IN ('visible'))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | profile_post | ref | profile_user_id_post_date | profile_user_id_post_date | 4 | const | 667 | Using where |
SELECT profile_post.* , posting_user.*, IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username, 0 AS like_date FROM xf_profile_post AS profile_post LEFT JOIN xf_user AS posting_user ON (posting_user.user_id = profile_post.user_id) WHERE (profile_post.profile_user_id = 6) AND (profile_post.message_state IN ('visible')) ORDER BY profile_post.post_date DESC LIMIT 10 OFFSET 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | profile_post | ref | profile_user_id_post_date | profile_user_id_post_date | 4 | const | 667 | Using where |
SIMPLE | posting_user | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.profile_post.user_id | 1 |
SELECT profile_post_comment.* , user.*, IF(user.username IS NULL, profile_post_comment.username, user.username) AS username, 0 AS like_date FROM xf_profile_post_comment AS profile_post_comment LEFT JOIN xf_user AS user ON (user.user_id = profile_post_comment.user_id) WHERE (profile_post_comment.profile_post_comment_id IN(1066)) AND (profile_post_comment.message_state IN ('visible'))
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | profile_post_comment | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user_field.* , field_value.field_value FROM xf_user_field AS user_field LEFT JOIN xf_user_field_value AS field_value ON (field_value.field_id = user_field.field_id AND field_value.user_id = 6) WHERE (user_field.display_group <> 'preferences' AND user_field.viewable_profile = 1) ORDER BY user_field.display_group, user_field.display_order
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_field | ALL | display_group_order | 7 | Using where; Using filesort | |||
SIMPLE | field_value | eq_ref | PRIMARY,field_id | PRIMARY | 31 | const,ccxsccxs_dd.user_field.field_id | 1 |
SELECT user.*, user_profile.*, user_option.* FROM xf_user_follow AS user_follow INNER JOIN xf_user AS user ON (user.user_id = user_follow.follow_user_id AND user.is_banned = 0) INNER JOIN xf_user_profile AS user_profile ON (user_profile.user_id = user.user_id) INNER JOIN xf_user_option AS user_option ON (user_option.user_id = user.user_id) WHERE user_follow.user_id = ? ORDER BY RAND() LIMIT 6
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_follow | ref | PRIMARY,follow_user_id | PRIMARY | 4 | const | 7 | Using index; Using temporary; Using filesort |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.user_follow.follow_user_id | 1 | |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.user_follow.follow_user_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.user_follow.follow_user_id | 1 | Using where |
SELECT COUNT(*) FROM xf_user_follow WHERE follow_user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_user_follow | ref | follow_user_id | follow_user_id | 4 | const | 353 | Using index |
SELECT user.*, user_profile.*, user_option.* FROM xf_user_follow AS user_follow INNER JOIN xf_user AS user ON (user.user_id = user_follow.user_id AND user.is_banned = 0) INNER JOIN xf_user_profile AS user_profile ON (user_profile.user_id = user.user_id) INNER JOIN xf_user_option AS user_option ON (user_option.user_id = user.user_id) WHERE user_follow.follow_user_id = ? ORDER BY RAND() LIMIT 6
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user_follow | ref | PRIMARY,follow_user_id | follow_user_id | 4 | const | 353 | Using index; Using temporary; Using filesort |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.user_follow.user_id | 1 | |
SIMPLE | user_option | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.user_follow.user_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | ccxsccxs_dd.user_follow.user_id | 1 | Using where |
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)
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'member_view', 'wf_hook_footer', 'wf_hook_moderator_bar', 'dark_taigachat', 'dark_taigachat_list', 'PAGE_CONTAINER') AND style_id = ? AND language_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | 13 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('viewing_thread', 'user_field_Phone_desc', 'user_field_aim_desc', 'user_field_icq_desc', 'user_field_yahoo_desc', 'user_field_skype_desc', 'user_field_facebook_desc', 'user_field_twitter_desc')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | 8 | Using where |
SELECT user.* , user_profile.*, user_option.*, user_privacy.*, permission_combination.cache_value AS global_permission_cache 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) LEFT JOIN xf_permission_combination AS permission_combination ON (permission_combination.permission_combination_id = user.permission_combination_id) WHERE user.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user.* , user_profile.*, user_option.*, user_privacy.*, permission_combination.cache_value AS global_permission_cache 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) LEFT JOIN xf_permission_combination AS permission_combination ON (permission_combination.permission_combination_id = user.permission_combination_id) WHERE user.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user.* , user_profile.*, user_option.*, user_privacy.*, permission_combination.cache_value AS global_permission_cache 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) LEFT JOIN xf_permission_combination AS permission_combination ON (permission_combination.permission_combination_id = user.permission_combination_id) WHERE user.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT user.* , user_profile.*, user_option.*, user_privacy.*, permission_combination.cache_value AS global_permission_cache 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) LEFT JOIN xf_permission_combination AS permission_combination ON (permission_combination.permission_combination_id = user.permission_combination_id) WHERE user.user_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_profile | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_option | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 |