explain查询

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>196238 and Population<200000;