现象 今天遇到一个慢查询,查询日志找到慢查询语句是这样的: select * from convert_test where areacode=0001 and period>='20170511' and period<='20170511'; convert_test表结构如下: CREATE TABLE `convert_test` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `areacode` char(12) NOT NULL DEFAULT '', `period` int