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';