В догонку - explain запроса
mysql> explain SELECT comment_ID FROM wp_comments WHERE comment_post_ID = '22' AND comment_approved != 'trash' AND ( comment_author = 'Fake Ray Bans Bulk' OR comment_author_email = '[email protected]' ) AND comment_content = 'I havent checked in here' LIMIT 1; +----+-------------+-------------+------+-------------------------------------------+-----------------+---------+-------+--------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+-------------+------+-------------------------------------------+-----------------+---------+-------+--------+-------------+ | 1 | SIMPLE | wp_comments | ref | comment_post_ID,comment_approved_date_gmt | comment_post_ID | 8 | const | 471051 | Using where | +----+-------------+-------------+------+-------------------------------------------+-----------------+---------+-------+--------+-------------+ 1 row in set (0.00 sec)
