rendered paste body EXPLAIN SELECT COUNT(*) AS ct FROM order_master, cc_transactions WHERE order_master.auth_transaction = cc_transactions.id AND cc_transactions.time >= FROM_UNIXTIME(1155441600) AND cc_transactions.time < FROM_UNIXTIME(1155528000);
+----+-------------+-----------------+--------+------------------+------------------+---------+-------------------------------------+-------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-----------------+--------+------------------+------------------+---------+-------------------------------------+-------+-------------+
| 1 | SIMPLE | order_master | index | auth_transaction | auth_transaction | 5 | NULL | 15341 | Using index |
| 1 | SIMPLE | cc_transactions | eq_ref | PRIMARY | PRIMARY | 4 | danc7.order_master.auth_transaction | 1 | Using where |
+----+-------------+-----------------+--------+------------------+------------------+---------+-------------------------------------+-------+-------------+