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 `xf_thread`.*, `xf_user_User_1`.*, `xf_snog_forms_forms_Form_2`.*, `xf_forum_Forum_3`.*, `xf_tl_group_forum_GroupForum_4`.*, `xf_node_Node_5`.*, `xf_permission_cache_content_Permissions_6`.* FROM `xf_thread` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread`.`user_id`) LEFT JOIN `xf_snog_forms_forms` AS `xf_snog_forms_forms_Form_2` ON (`xf_snog_forms_forms_Form_2`.`oldthread` > '0' AND `xf_snog_forms_forms_Form_2`.`oldthread` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_3` ON (`xf_forum_Forum_3`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_tl_group_forum` AS `xf_tl_group_forum_GroupForum_4` ON (`xf_tl_group_forum_GroupForum_4`.`node_id` = `xf_forum_Forum_3`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_5` ON (`xf_node_Node_5`.`node_id` = `xf_forum_Forum_3`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_6` ON (`xf_permission_cache_content_Permissions_6`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_6`.`content_id` = `xf_node_Node_5`.`node_id` AND `xf_permission_cache_content_Permissions_6`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` = '150641') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_snog_forms_forms_Form_2 | ref | oldthread | oldthread | 4 | const | 1 | Using where |
SIMPLE | xf_forum_Forum_3 | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_tl_group_forum_GroupForum_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_node_Node_5 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_Forum_3.node_id | 1 | Using where |
SIMPLE | xf_permission_cache_content_Permissions_6 | eq_ref | PRIMARY | PRIMARY | 35 | const,const,admin_xen.xf_node_Node_5.node_id | 1 | Using where |
SELECT `xf_post`.*, `xf_user_User_1`.*, `xf_user_option_Option_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_privacy_Privacy_4`.*, `xf_permission_combination_PermissionCombination_5`.*, `xf_session_activity_Activity_6`.*, `xf_sv_content_mentions_Mentions_7`.*, `xf_snog_forms_promotions_Promotions_8`.* FROM `xf_post` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_post`.`user_id`) LEFT JOIN `xf_user_option` AS `xf_user_option_Option_2` ON (`xf_user_option_Option_2`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_4` ON (`xf_user_privacy_Privacy_4`.`user_id` = `xf_user_User_1`.`user_id`) LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_5` ON (`xf_permission_combination_PermissionCombination_5`.`permission_combination_id` = `xf_user_User_1`.`permission_combination_id`) LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_6` ON (`xf_session_activity_Activity_6`.`user_id` = `xf_user_User_1`.`user_id` AND `xf_session_activity_Activity_6`.`unique_key` = CONCAT(`xf_user_User_1`.`user_id`, '')) LEFT JOIN `xf_sv_content_mentions` AS `xf_sv_content_mentions_Mentions_7` ON (`xf_sv_content_mentions_Mentions_7`.`content_type` = 'post' AND `xf_sv_content_mentions_Mentions_7`.`content_id` = `xf_post`.`post_id`) LEFT JOIN `xf_snog_forms_promotions` AS `xf_snog_forms_promotions_Promotions_8` ON (`xf_snog_forms_promotions_Promotions_8`.`post_id` = `xf_post`.`post_id`) WHERE (`xf_post`.`thread_id` = 150641) AND ((`xf_post`.`message_state` IN ('visible'))) AND (`xf_post`.`position` >= 0) AND (`xf_post`.`position` < 20) ORDER BY `xf_post`.`position` ASC, `xf_post`.`post_date` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_post | ref | thread_id_post_date,thread_id_position,thread_id_score_date | thread_id_post_date | 4 | const | 1 | Using where; Using filesort |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | admin_xen.xf_user_User_1.user_id,func | 1 | Using where |
SIMPLE | xf_sv_content_mentions_Mentions_7 | eq_ref | PRIMARY | PRIMARY | 31 | const,admin_xen.xf_post.post_id | 1 | Using where |
SIMPLE | xf_snog_forms_promotions_Promotions_8 | eq_ref | post_id | post_id | 4 | admin_xen.xf_post.post_id | 1 |
SELECT `xf_dbtech_credits_event`.* FROM `xf_dbtech_credits_event` WHERE (`xf_dbtech_credits_event`.`event_trigger_id` = 'read')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dbtech_credits_event | ALL | 15 | Using where |
SELECT `xf_dbtech_credits_event`.* FROM `xf_dbtech_credits_event` WHERE (`xf_dbtech_credits_event`.`event_trigger_id` = 'view')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_dbtech_credits_event | ALL | 15 | Using where |
SELECT `swrp_user_moods`.* FROM `swrp_user_moods` WHERE (`swrp_user_moods`.`user_id` = 1) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | swrp_user_moods | ALL | 8334 | Using where |
SELECT `swrp_moods`.* FROM `swrp_moods` WHERE (`swrp_moods`.`default` = 1)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | swrp_moods | ALL | 1282 | Using where |
SELECT `swrp_moods`.* FROM `swrp_moods` WHERE (`swrp_moods`.`default` = 1) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | swrp_moods | ALL | 1282 | Using where |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?