gistfile1.txt

  EXPLAIN (3.1ms)  EXPLAIN SELECT word FROM `dictionary_words` WHERE `dictionary_words`.`dictionary_id` = 1 ORDER BY seed LIMIT 10 OFFSET 80112
EXPLAIN for: SELECT  word FROM `dictionary_words`  WHERE `dictionary_words`.`dictionary_id` = 1 ORDER BY seed LIMIT 10 OFFSET 80112
+----+-------------+------------------+------+-------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+---------+-------+-------+-------------+
| id | select_type | table            | type | possible_keys                                                                                                                             | key                                              | key_len | ref   | rows  | Extra       |
+----+-------------+------------------+------+-------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+---------+-------+-------+-------------+
|  1 | SIMPLE      | dictionary_words | ref  | index_dictionary_words_on_dictionary_id,index_dictionary_words_on_dictionary_id_and_seed,index_dictionary_words_on_dictionary_id_and_word | index_dictionary_words_on_dictionary_id_and_seed | 5       | const | 89531 | Using where |
+----+-------------+------------------+------+-------------------------------------------------------------------------------------------------------------------------------------------+--------------------------------------------------+---------+-------+-------+-------------+
1 row in set (0.00 sec)