gistfile1.sql

SELECT * FROM `delayed_jobs` WHERE ((run_at <= '2009-03-12 02:59:22' AND (locked_at IS NULL OR locked_at < '2009-03-11 22:59:22') OR (locked_by = 'host:client1.gethandcrafted.com pid:4664')) AND failed_at IS NULL)  ORDER BY priority DESC, run_at ASC LIMIT 5;

gistfile2.txt

mysql> EXPLAIN SELECT * FROM `delayed_jobs` WHERE ((run_at <= '2009-03-12 03:07:11' AND (locked_at IS NULL OR locked_at < '2009-03-11 23:07:11') OR (locked_by = 'host:client1.gethandcrafted.com pid:4664')) AND failed_at IS NULL)  ORDER BY priority DESC, run_at ASC LIMIT 5;
+----+-------------+--------------+------+---------------+------+---------+------+------+-----------------------------+
| id | select_type | table        | type | possible_keys | key  | key_len | ref  | rows | Extra                       |
+----+-------------+--------------+------+---------------+------+---------+------+------+-----------------------------+
|  1 | SIMPLE      | delayed_jobs | ALL  | run_at        | NULL | NULL    | NULL |    1 | Using where; Using filesort | 
+----+-------------+--------------+------+---------------+------+---------+------+------+-----------------------------+
1 row in set (0.01 sec)