I have created a news page normally. But this is extremely slow. Ideas?
no Add-Ons installed.
no Add-Ons installed.
Code:
SELECT `xf_thread`.*, `xf_deletion_log_DeletionLog_1`.*, `xf_user_User_2`.*, `xf_user_LastPoster_3`.*, `xf_thread_read_Read_4`.*, `xf_thread_user_post_UserPosts_5`.*, `xf_thread_watch_Watch_6`.*, `xf_post_FirstPost_7`.*, `xf_user_User_8`.*, `xf_user_option_Option_9`.*, `xf_user_profile_Profile_10`.*, `xf_user_privacy_Privacy_11`.*, `xf_permission_combination_PermissionCombination_12`.*, `xf_session_activity_Activity_13`.*, `xf_reaction_content_Reactions_14`.*, `xf_bookmark_item_Bookmarks_15`.*
FROM `xf_thread`
LEFT JOIN `xf_deletion_log` AS `xf_deletion_log_DeletionLog_1` ON (`xf_deletion_log_DeletionLog_1`.`content_type` = 'thread' AND `xf_deletion_log_DeletionLog_1`.`content_id` = `xf_thread`.`thread_id`)
LEFT JOIN `xf_user` AS `xf_user_User_2` ON (`xf_user_User_2`.`user_id` = `xf_thread`.`user_id`)
LEFT JOIN `xf_user` AS `xf_user_LastPoster_3` ON (`xf_user_LastPoster_3`.`user_id` = `xf_thread`.`last_post_user_id`)
LEFT JOIN `xf_thread_read` AS `xf_thread_read_Read_4` ON (`xf_thread_read_Read_4`.`thread_id` = `xf_thread`.`thread_id` AND `xf_thread_read_Read_4`.`user_id` = '259')
LEFT JOIN `xf_thread_user_post` AS `xf_thread_user_post_UserPosts_5` ON (`xf_thread_user_post_UserPosts_5`.`thread_id` = `xf_thread`.`thread_id` AND `xf_thread_user_post_UserPosts_5`.`user_id` = '259')
LEFT JOIN `xf_thread_watch` AS `xf_thread_watch_Watch_6` ON (`xf_thread_watch_Watch_6`.`thread_id` = `xf_thread`.`thread_id` AND `xf_thread_watch_Watch_6`.`user_id` = '259')
LEFT JOIN `xf_post` AS `xf_post_FirstPost_7` ON (`xf_post_FirstPost_7`.`post_id` = `xf_thread`.`first_post_id`)
LEFT JOIN `xf_user` AS `xf_user_User_8` ON (`xf_user_User_8`.`user_id` = `xf_post_FirstPost_7`.`user_id`)
LEFT JOIN `xf_user_option` AS `xf_user_option_Option_9` ON (`xf_user_option_Option_9`.`user_id` = `xf_user_User_8`.`user_id`)
LEFT JOIN `xf_user_profile` AS `xf_user_profile_Profile_10` ON (`xf_user_profile_Profile_10`.`user_id` = `xf_user_User_8`.`user_id`)
LEFT JOIN `xf_user_privacy` AS `xf_user_privacy_Privacy_11` ON (`xf_user_privacy_Privacy_11`.`user_id` = `xf_user_User_8`.`user_id`)
LEFT JOIN `xf_permission_combination` AS `xf_permission_combination_PermissionCombination_12` ON (`xf_permission_combination_PermissionCombination_12`.`permission_combination_id` = `xf_user_User_8`.`permission_combination_id`)
LEFT JOIN `xf_session_activity` AS `xf_session_activity_Activity_13` ON (`xf_session_activity_Activity_13`.`user_id` = `xf_user_User_8`.`user_id` AND `xf_session_activity_Activity_13`.`unique_key` = CONCAT(`xf_user_User_8`.`user_id`, ''))
LEFT JOIN `xf_reaction_content` AS `xf_reaction_content_Reactions_14` ON (`xf_reaction_content_Reactions_14`.`content_type` = 'post' AND `xf_reaction_content_Reactions_14`.`content_id` = `xf_post_FirstPost_7`.`post_id` AND `xf_reaction_content_Reactions_14`.`reaction_user_id` = '259')
LEFT JOIN `xf_bookmark_item` AS `xf_bookmark_item_Bookmarks_15` ON (`xf_bookmark_item_Bookmarks_15`.`content_type` = 'post' AND `xf_bookmark_item_Bookmarks_15`.`content_id` = `xf_post_FirstPost_7`.`post_id` AND `xf_bookmark_item_Bookmarks_15`.`user_id` = '259')
WHERE (`xf_thread`.`node_id` = 4063) AND ((`xf_thread`.`discussion_state` IN ('visible', 'deleted', 'moderated'))) AND (`xf_thread`.`discussion_type` <> 'redirect') AND (`xf_thread`.`sticky` = 0)
ORDER BY `xf_thread`.`last_post_date` DESC
LIMIT 20
