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_node`.*, `xf_category_complex_join_0_1`.*, `xf_forum_complex_join_1_2`.*, `xf_user_LastPostUser_3`.*, `xf_thread_LastThread_4`.*, `xf_tl_group_forum_GroupForum_5`.*, `xf_tl_group_Group_6`.*, `xf_tl_group_category_Category_7`.*, `xf_tl_group_feature_Feature_8`.*, `xf_attachment_AvatarAttachment_9`.*, `xf_attachment_data_Data_10`.*, `xf_attachment_CoverAttachment_11`.*, `xf_attachment_data_Data_12`.*, `xf_link_forum_complex_join_2_13`.*, `xf_page_complex_join_3_14`.* FROM `xf_node` LEFT JOIN `xf_category` AS `xf_category_complex_join_0_1` ON (`xf_category_complex_join_0_1`.`node_id` = `xf_node`.`node_id`) LEFT JOIN `xf_forum` AS `xf_forum_complex_join_1_2` ON (`xf_forum_complex_join_1_2`.`node_id` = `xf_node`.`node_id`) LEFT JOIN `xf_user` AS `xf_user_LastPostUser_3` ON (`xf_user_LastPostUser_3`.`user_id` = `xf_forum_complex_join_1_2`.`last_post_user_id`) LEFT JOIN `xf_thread` AS `xf_thread_LastThread_4` ON (`xf_thread_LastThread_4`.`thread_id` = `xf_forum_complex_join_1_2`.`last_thread_id`) LEFT JOIN `xf_tl_group_forum` AS `xf_tl_group_forum_GroupForum_5` ON (`xf_tl_group_forum_GroupForum_5`.`node_id` = `xf_forum_complex_join_1_2`.`node_id`) LEFT JOIN `xf_tl_group` AS `xf_tl_group_Group_6` ON (`xf_tl_group_Group_6`.`group_id` = `xf_tl_group_forum_GroupForum_5`.`group_id`) LEFT JOIN `xf_tl_group_category` AS `xf_tl_group_category_Category_7` ON (`xf_tl_group_category_Category_7`.`category_id` = `xf_tl_group_Group_6`.`category_id`) LEFT JOIN `xf_tl_group_feature` AS `xf_tl_group_feature_Feature_8` ON (`xf_tl_group_feature_Feature_8`.`group_id` = `xf_tl_group_Group_6`.`group_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_AvatarAttachment_9` ON (`xf_attachment_AvatarAttachment_9`.`attachment_id` = `xf_tl_group_Group_6`.`avatar_attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_10` ON (`xf_attachment_data_Data_10`.`data_id` = `xf_attachment_AvatarAttachment_9`.`data_id`) LEFT JOIN `xf_attachment` AS `xf_attachment_CoverAttachment_11` ON (`xf_attachment_CoverAttachment_11`.`attachment_id` = `xf_tl_group_Group_6`.`cover_attachment_id`) LEFT JOIN `xf_attachment_data` AS `xf_attachment_data_Data_12` ON (`xf_attachment_data_Data_12`.`data_id` = `xf_attachment_CoverAttachment_11`.`data_id`) LEFT JOIN `xf_link_forum` AS `xf_link_forum_complex_join_2_13` ON (`xf_link_forum_complex_join_2_13`.`node_id` = `xf_node`.`node_id`) LEFT JOIN `xf_page` AS `xf_page_complex_join_3_14` ON (`xf_page_complex_join_3_14`.`node_id` = `xf_node`.`node_id`) WHERE (`xf_node`.`display_in_list` = 1) ORDER BY `xf_node`.`lft` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_node | ALL | display_in_list | 324 | Using where; Using filesort | |||
SIMPLE | xf_category_complex_join_0_1 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_node.node_id | 1 | Using index |
SIMPLE | xf_forum_complex_join_1_2 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_node.node_id | 1 | |
SIMPLE | xf_user_LastPostUser_3 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_complex_join_1_2.last_post_user_id | 1 | Using where |
SIMPLE | xf_thread_LastThread_4 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_complex_join_1_2.last_thread_id | 1 | Using where |
SIMPLE | xf_tl_group_forum_GroupForum_5 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_forum_complex_join_1_2.node_id | 1 | Using where |
SIMPLE | xf_tl_group_Group_6 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_tl_group_forum_GroupForum_5.group_id | 1 | Using where |
SIMPLE | xf_tl_group_category_Category_7 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_tl_group_Group_6.category_id | 1 | Using where |
SIMPLE | xf_tl_group_feature_Feature_8 | eq_ref | PRIMARY,group_id | PRIMARY | 4 | admin_xen.xf_tl_group_Group_6.group_id | 1 | Using where |
SIMPLE | xf_attachment_AvatarAttachment_9 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_tl_group_Group_6.avatar_attachment_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_10 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_attachment_AvatarAttachment_9.data_id | 1 | Using where |
SIMPLE | xf_attachment_CoverAttachment_11 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_tl_group_Group_6.cover_attachment_id | 1 | Using where |
SIMPLE | xf_attachment_data_Data_12 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_attachment_CoverAttachment_11.data_id | 1 | Using where |
SIMPLE | xf_link_forum_complex_join_2_13 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_node.node_id | 1 | |
SIMPLE | xf_page_complex_join_3_14 | eq_ref | PRIMARY | PRIMARY | 4 | admin_xen.xf_node.node_id | 1 |
SELECT content_id, cache_value FROM xf_permission_cache_content WHERE permission_combination_id = ? AND content_type = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 846 | Using where |
SELECT `xf_tl_group_user_cache`.* FROM `xf_tl_group_user_cache` WHERE (`xf_tl_group_user_cache`.`user_id` = 0) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_tl_group_user_cache | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?