# explain 标签
下面的笔记是根据我自己的 mysql 服务的版本号来的 mysql> select version(); +------------+ | version() | +------------+ | 5.6.16-log | +------------+ 1 row in set (0.00 sec) 随便放一个查询结果，我们要说的就是这里的type的值。 mysql> explain SELECT id,title FROM seo_php_article where is_delete=0 order by id asc limit 66500,500; +----+-------------+-----------------+------+---------------+-----------+---------+-------+-------+-----------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | ....
有更新！

mysql explain type 字段解读