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','Idou::Worker::Test1','Idou::Worker::Test2','Idou::Worker::Test3','Idou::Worker::Test4','Idou::Worker::Test5','Idou::Worker::Test6')) 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  | range | PRIMARY,name  | name    | 767     | NULL         |    7 | Using where; Using temporary; Using filesort |
|  1 | SIMPLE      | job   | ref   | func_id       | func_id | 4       | qudo.func.id | 1001 | Using where                                  |
+----+-------------+-------+-------+---------------+---------+---------+--------------+------+----------------------------------------------+
2 rows in set (0.00 sec)