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_forum_Forum_1`.*, `xf_node_Node_2`.*, `xf_permission_cache_content_Permissions_3`.* FROM `xf_thread` LEFT JOIN `xf_forum` AS `xf_forum_Forum_1` ON (`xf_forum_Forum_1`.`node_id` = `xf_thread`.`node_id`) LEFT JOIN `xf_node` AS `xf_node_Node_2` ON (`xf_node_Node_2`.`node_id` = `xf_forum_Forum_1`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_3` ON (`xf_permission_cache_content_Permissions_3`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_3`.`content_id` = `xf_node_Node_2`.`node_id` AND `xf_permission_cache_content_Permissions_3`.`permission_combination_id` = '1') WHERE (`xf_thread`.`thread_id` = '148124') 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_forum_Forum_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_3 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT active FROM xf_addon WHERE addon_id = 'SV/MultiPrefix' AND active = 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | Impossible WHERE noticed after reading const tables |
SELECT `xf_thread_prefix`.* FROM `xf_thread_prefix` WHERE (`xf_thread_prefix`.`prefix_id` = 3) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_thread_prefix`.* FROM `xf_thread_prefix` WHERE (`xf_thread_prefix`.`prefix_id` IN (15, 43, 27, 42, 101, 96, 97, 98, 99, 46, 94, 95, 1, 2, 4, 7, 5, 102, 6, 3, 82, 90, 81, 91, 103, 53, 54, 51, 34, 26, 20, 19, 11, 8)) ORDER BY `xf_thread_prefix`.`materialized_order` ASC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix | ALL | PRIMARY | 99 | Using where; Using filesort |
SELECT `xf_thread_prefix_group`.* FROM `xf_thread_prefix_group` WHERE (`xf_thread_prefix_group`.`prefix_group_id` = 6) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_thread_prefix_group`.* FROM `xf_thread_prefix_group` WHERE (`xf_thread_prefix_group`.`prefix_group_id` = 9) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_thread_prefix_group`.* FROM `xf_thread_prefix_group` WHERE (`xf_thread_prefix_group`.`prefix_group_id` = 10) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_thread_prefix_group`.* FROM `xf_thread_prefix_group` WHERE (`xf_thread_prefix_group`.`prefix_group_id` = 1) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_thread_prefix_group`.* FROM `xf_thread_prefix_group` WHERE (`xf_thread_prefix_group`.`prefix_group_id` = 3) LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread_prefix_group | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?