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_forum`.*, `xf_node_Node_1`.*, `xf_permission_cache_content_Permissions_2`.* FROM `xf_forum` INNER JOIN `xf_node` AS `xf_node_Node_1` ON (`xf_node_Node_1`.`node_id` = `xf_forum`.`node_id`) LEFT JOIN `xf_permission_cache_content` AS `xf_permission_cache_content_Permissions_2` ON (`xf_permission_cache_content_Permissions_2`.`content_type` = 'node' AND `xf_permission_cache_content_Permissions_2`.`content_id` = `xf_node_Node_1`.`node_id` AND `xf_permission_cache_content_Permissions_2`.`permission_combination_id` = '1') WHERE (`xf_forum`.`node_id` = '21') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_node_Node_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_permission_cache_content_Permissions_2 | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 |
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_user_LastPoster_2`.* 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_user` AS `xf_user_LastPoster_2` ON (`xf_user_LastPoster_2`.`user_id` = `xf_thread`.`last_post_user_id`) WHERE (`xf_thread`.`node_id` = 21) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`sticky` = 1) ORDER BY `xf_thread`.`last_post_date` DESC
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | node_id_last_post_date | 4 | const | 1 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | hrs32465_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_2 | eq_ref | PRIMARY | PRIMARY | 4 | hrs32465_forum.xf_thread.last_post_user_id | 1 |
SELECT `xf_thread`.*, `xf_user_User_1`.*, `xf_user_LastPoster_2`.* 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_user` AS `xf_user_LastPoster_2` ON (`xf_user_LastPoster_2`.`user_id` = `xf_thread`.`last_post_user_id`) WHERE (`xf_thread`.`node_id` = 21) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`sticky` = 0) ORDER BY `xf_thread`.`last_post_date` DESC LIMIT 20
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | node_id_last_post_date | 4 | const | 1 | Using where |
SIMPLE | xf_user_User_1 | eq_ref | PRIMARY | PRIMARY | 4 | hrs32465_forum.xf_thread.user_id | 1 | |
SIMPLE | xf_user_LastPoster_2 | eq_ref | PRIMARY | PRIMARY | 4 | hrs32465_forum.xf_thread.last_post_user_id | 1 |
SELECT COUNT(*) FROM `xf_thread` WHERE (`xf_thread`.`node_id` = 21) AND ((`xf_thread`.`discussion_state` IN ('visible'))) AND (`xf_thread`.`sticky` = 0)
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_thread | ref | node_id_last_post_date,node_id_sticky_state_last_post,node_id_sticky_state_vote_score | node_id_sticky_state_last_post | 6 | const,const,const | 1 | Using where; Using index |
SELECT view_date FROM xf_session_activity WHERE user_id = ? AND unique_key = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_session_activity | const | PRIMARY | PRIMARY | 22 | const,const | 1 |
-- XFDB=noForceAllWrite INSERT IGNORE INTO xf_session_activity ( ip, controller_name, controller_action, view_state, params, view_date, robot_key, user_id, unique_key ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
gets | 5 |
gets.time | 0.001066576 |
sets | 1 |
sets.time | 0.000174589 |
deletes | 0 |
deletes.time | 0 |
flushes | 0 |
flushes.time | 0 |
bytes_sent | 6 |
bytes_received | 649 |
time_compression | 4.995E-6 |
time_decompression | 6.231E-6 |
time_encoding | 1.4998E-5 |
time_decoding | 2.4023E-5 |
gets | 1 |
gets.time | 0.000443087 |
sets | 1 |
sets.time | 0.001830281 |
deletes | 0 |
deletes.time | 0 |
flushes | 0 |
flushes.time | 0 |
bytes_sent | 17395 |
bytes_received | 0 |
time_compression | 0.001314827 |
time_decompression | 0 |
time_encoding | 0.000156953 |
time_decoding | 0 |