56,679
社区成员
发帖
与我相关
我的任务
分享
mysql> explain select * from kaxi_art where verify=1 and img is not null order by id desc limit 5;
+----+-------------+----------+-------+---------------+------+---------+------+--------+-----------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+----------+-------+---------------+------+---------+------+--------+-----------------------------+
| 1 | SIMPLE | kaxi_art | range | img | img | 153 | NULL | 178664 | Using where; Using filesort |
+----+-------------+----------+-------+---------------+------+---------+------+--------+-----------------------------+