explain select * from `city`;
#全文搜索最慢
#范围搜索
explain select * from `city` where ID>5 and ID<20;
#主键查询
explain select * from `city` where ID=5;
#索引查询
explain select * from `city` where CountryCode='NLD';
#普通查询
explain select * from `city` where Name='Haag';