gistfile1.txt

# mysql -uroot -ppw test -e 'explain SELECT c FROM sbtest1 WHERE id BETWEEN 39927041 AND 39927140 ORDER BY c\G'
mysql: [Warning] Using a password on the command line interface can be insecure.
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: sbtest1
   partitions: NULL
         type: ALL
possible_keys: PRIMARY
          key: NULL
      key_len: NULL
          ref: NULL
         rows: 1
     filtered: 100.00
        Extra: Using where; Using filesort