Time: 19
SELECT id, pid, tid, ft.user_id, UNIX_TIMESTAMP(ft.time + INTERVAL 0 MINUTE) AS disp_time, UNIX_TIMESTAMP(last_reply + INTERVAL 0 MINUTE) AS last_reply, UNIX_TIMESTAMP(ft.time) AS time, UNIX_TIMESTAMP(edited + INTERVAL 0 MINUTE) AS e_time, UNIX_TIMESTAMP(edited - INTERVAL 5 MINUTE) AS edited_diff, edited_by, name, email, subject, hp, location, ip, text, cache_text, show_signature, views, category, locked, ip, user_name, user_type, user_email, email_contact, user_hp, user_location, signature, cache_signature, edit_key, rst.user_id AS req_user, mlf2_akismet_rating.spam AS akismet_spam, spam_check_status, mlf2_b8_rating.spam AS b8_spam, training_type FROM mlf2_entries AS ft LEFT JOIN mlf2_entries_cache ON mlf2_entries_cache.cache_id=ft.id LEFT JOIN mlf2_userdata ON mlf2_userdata.user_id=ft.user_id LEFT JOIN mlf2_userdata_cache ON mlf2_userdata_cache.cache_id=mlf2_userdata.user_id LEFT JOIN mlf2_read_entries AS rst ON rst.posting_id = ft.id AND rst.user_id = 0 LEFT JOIN mlf2_akismet_rating ON mlf2_akismet_rating.`eid` = `ft`.`id` LEFT JOIN mlf2_b8_rating ON mlf2_b8_rating.`eid` = `ft`.`id` WHERE tid = 281632 AND (mlf2_akismet_rating.spam = 0 AND mlf2_b8_rating.spam = 0) ORDER BY ft.time ASC

Total time: 12960