1.
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;