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