explain SELECT * FROM `city`;
#主键查询
explain SELECT * FROM `city` where ID=5;
#索引查询
explain select * from city where CountryCode='NLD';
#主键范围查询
explain select * from city where ID>5 and ID<20;
#非索引查询范围
explain select * from city where Population>193238 and Population<200000;