mysql> explain select * from cc_call where starttime > '2016-11-14 10:19:48' and starttime < '2016-11-30 23:59:59' limit 2;
+------+-------------+---------+-------+---------------+-----------+---------+------+---------+-----------------------+
| id   | select_type | table   | type  | possible_keys | key       | key_len | ref  | rows    | Extra                 |
+------+-------------+---------+-------+---------------+-----------+---------+------+---------+-----------------------+
|    1 | SIMPLE      | cc_call | range | starttime     | starttime | 4       | NULL | 2025490 | Using index condition |
+------+-------------+---------+-------+---------------+-----------+---------+------+---------+-----------------------+