#全文搜索最慢
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';