Prodromus

1) Optimize your WHERE clause.

• Remove unnecessary parentheses, this will speed up evaluation
• COUNT(*) on a single table without a WHERE is retrieved directly from the table information for MyISAM and MEMORY tables, but NOT Innodb tables. Beware.
• If you use the SQL_SMALL_RESULT option, MySQL uses an in-memory temporary table