gistfile1.txt

mysql -uroot -ppw test -e 'explain SELECT c FROM sbtest1 WHERE id BETWEEN 39927041 AND 39927140 ORDER BY c;'

*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: sbtest1
   partitions: NULL
         type: range
possible_keys: PRIMARY
          key: PRIMARY
      key_len: 4
          ref: NULL
         rows: 118
     filtered: 100.00
        Extra: Using where; Using filesort