dev.mysql.com/doc/refman/5.1/en/general-thread-states.html
The thread is reading and processing rows for a SELECT statement, and sending data to the client. Because operations occurring during this this state tend to perform large amounts of disk access (reads), it is often the longest-running state over the lifetime of a given query.
покажите статистику по чтениям для обоих запросов.