mysql> EXPLAIN SELECT job.id, job.arg, job.uniqkey, job.func_id, job.grabbed_until, job.retry_cnt, job.priority, func.name AS funcname FROM job INNER JOIN func ON job.func_id = func.id WHERE (func.name IN ('Idou::Worker::Test')) AND (job.grabbed_until <= '1275387047') AND (job.run_after <= '1275387047') ORDER BY job.priority DESC LIMIT 30;
+----+-------------+-------+-------+---------------+---------+---------+-------+-------+----------------+
| id | select_type | table | type  | possible_keys | key     | key_len | ref   | rows  | Extra          |
+----+-------------+-------+-------+---------------+---------+---------+-------+-------+----------------+
|  1 | SIMPLE      | func  | const | PRIMARY,name  | name    | 767     | const |     1 | Using filesort |
|  1 | SIMPLE      | job   | range | func_id       | func_id | 4       | NULL  | 99997 | Using where    |
+----+-------------+-------+-------+---------------+---------+---------+-------+-------+----------------+
2 rows in set (0.00 sec)