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_profile_post`.*, `xf_user_User_1`.*, `xf_user_ProfileUser_2`.*, `xf_user_privacy_Privacy_3`.* FROM `xf_profile_post` LEFT JOIN `xf_user` AS `xf_user_User_1` ON (`xf_user_User_1`.`user_id` = `xf_profile_post`.`user_id`) LEFT JOIN `xf_user` AS `xf_user_ProfileUser_2` ON (`xf_user_ProfileUser_2`.`user_id` = `xf_profile_post`.`profile_user_id`) LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_3` ON (`xf_user_privacy_Privacy_3`.`user_id` = `xf_user_ProfileUser_2`.`user_id`) WHERE (`xf_profile_post`.`profile_post_id` = '29335') LIMIT 1
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_profile_post | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_User_1 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_ProfileUser_2 | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | xf_user_privacy_Privacy_3 | const | PRIMARY | PRIMARY | 4 | const | 1 |
SELECT `xf_reaction_content`.*, `xf_reaction_Reaction_1`.*, `xf_user_ReactionUser_2`.*, `xf_user_profile_Profile_3`.*, `xf_user_option_Option_4`.* FROM `xf_reaction_content` INNER JOIN `xf_reaction` AS `xf_reaction_Reaction_1` ON (`xf_reaction_Reaction_1`.`reaction_id` = `xf_reaction_content`.`reaction_id`) INNER JOIN `xf_user` AS `xf_user_ReactionUser_2` ON (`xf_user_ReactionUser_2`.`user_id` = `xf_reaction_content`.`reaction_user_id`) INNER JOIN `xf_user_profile` AS `xf_user_profile_Profile_3` ON (`xf_user_profile_Profile_3`.`user_id` = `xf_user_ReactionUser_2`.`user_id`) INNER JOIN `xf_user_option` AS `xf_user_option_Option_4` ON (`xf_user_option_Option_4`.`user_id` = `xf_user_ReactionUser_2`.`user_id`) WHERE (`xf_reaction_content`.`content_type` = 'profile_post' AND `xf_reaction_content`.`content_id` = 29335 AND `xf_reaction_Reaction_1`.`active` = 1) ORDER BY `xf_reaction_content`.`reaction_date` DESC LIMIT 51
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_reaction_Reaction_1 | ALL | PRIMARY | 6 | Using where; Using temporary; Using filesort | |||
SIMPLE | xf_reaction_content | ref | content_type_id_user_id,content_type_id_reaction_date,reaction_user_id | content_type_id_user_id | 31 | const,const | 3 | Using index condition; Using where |
SIMPLE | xf_user_ReactionUser_2 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_reaction_content.reaction_user_id | 1 | |
SIMPLE | xf_user_option_Option_4 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_reaction_content.reaction_user_id | 1 | |
SIMPLE | xf_user_profile_Profile_3 | eq_ref | PRIMARY | PRIMARY | 4 | thesims.xf_reaction_content.reaction_user_id | 1 |
-- XFDB=noForceAllWrite INSERT INTO xf_session_activity (`user_id`, `unique_key`, `ip`, `controller_name`, `controller_action`, `view_state`, `params`, `view_date`, `robot_key`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) ON DUPLICATE KEY UPDATE ip = VALUES(ip), controller_name = VALUES(controller_name), controller_action = VALUES(controller_action), view_state = VALUES(view_state), params = VALUES(params), view_date = VALUES(view_date), robot_key = VALUES(robot_key)