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_tl_post_reply_root_PostReplyRoot_2`.*, `xf_es_thread_similar_XFES_SimilarThreads_3`.*, `xf_forum_Forum_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_tl_post_reply_root` AS `xf_tl_post_reply_root_PostReplyRoot_2` ON (`xf_tl_post_reply_root_PostReplyRoot_2`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_es_thread_similar` AS `xf_es_thread_similar_XFES_SimilarThreads_3` ON (`xf_es_thread_similar_XFES_SimilarThreads_3`.`thread_id` = `xf_thread`.`thread_id`) LEFT JOIN `xf_forum` AS `xf_forum_Forum_4` ON (`xf_forum_Forum_4`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_5` ON (`xf_node_Node_5`.`node_id` = `xf_forum_Forum_4`.`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` = '989695') 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_tl_post_reply_root_PostReplyRoot_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_es_thread_similar_XFES_SimilarThreads_3 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_forum_Forum_4 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_5 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_6 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
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_tl_post_reply_item_PostReplyItem_7`.*, `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_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_tl_post_reply_item` AS `xf_tl_post_reply_item_PostReplyItem_7` ON (`xf_tl_post_reply_item_PostReplyItem_7`.`post_id` = `xf_post`.`post_id`) LEFT JOIN `xf_tck_signature_once_container_first_user_content` AS `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8` ON (`xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`user_id` = `xf_post`.`user_id` AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`container_type` = 'thread' AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`container_id` = `xf_post`.`thread_id` AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`content_type` = 'post') WHERE (`xf_post`.`thread_id` = 989695) 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 | cmclubcom_xf2xx.xf_post.user_id | 1 | |
SIMPLE | xf_user_option_Option_2 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_user_privacy_Privacy_4 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_user_User_1.user_id | 1 | Using where |
SIMPLE | xf_permission_combination_PermissionCombination_5 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_user_User_1.permission_combination_id | 1 | Using where |
SIMPLE | xf_session_activity_Activity_6 | eq_ref | PRIMARY | PRIMARY | 22 | cmclubcom_xf2xx.xf_user_User_1.user_id,func | 1 | Using where |
SIMPLE | xf_tl_post_reply_item_PostReplyItem_7 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_post.post_id | 1 | |
SIMPLE | xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8 | eq_ref | user_id_container_type_container_id_content_type,container_type_container_id | user_id_container_type_container_id_content_type | 62 | cmclubcom_xf2xx.xf_post.user_id,const,const,const | 1 | Using where |
-- XFDB=noForceAllWrite INSERT INTO xf_thread_view (thread_id, total) VALUES (? , 1) ON DUPLICATE KEY UPDATE total = total + 1
SELECT `xf_thread_read`.*, `xf_user_User_1`.* FROM `xf_thread_read` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_thread_read`.`user_id`) WHERE (`xf_thread_read`.`thread_id` = 989695)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_read | ref | thread_id | thread_id | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | cmclubcom_xf2xx.xf_thread_read.user_id | 1 |
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_tl_post_reply_item_PostReplyItem_7`.*, `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_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_tl_post_reply_item` AS `xf_tl_post_reply_item_PostReplyItem_7` ON (`xf_tl_post_reply_item_PostReplyItem_7`.`post_id` = `xf_post`.`post_id`) LEFT JOIN `xf_tck_signature_once_container_first_user_content` AS `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8` ON (`xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`user_id` = `xf_post`.`user_id` AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`container_type` = 'thread' AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`container_id` = `xf_post`.`thread_id` AND `xf_tck_signature_once_container_first_user_content_ThreadFirstUserPost_8`.`content_type` = 'post') WHERE (1 = 0)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?