MySQL explain实际操作流程说明
作者:IT科技类资讯 来源:人工智能 浏览: 【大中小】 发布时间:2025-11-05 01:05:16 评论数:
实际说明复制MySQL> explain SELECT * FROM `whisper` WHERE to_id = 6696 AND del = 0 AND whisper=0 ORDER BY `send_time` DESC LIMIT 4; +----+-------------+---------+------+---------------+-------+---------+-------+------+-----------------------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------+------+---------------+-------+---------+-------+------+-----------------------------+ | 1 | SIMPLE | whisper | ref | to_id | to_id | 4 | const | 1 | Using where; Using filesort | +----+-------------+---------+------+---------------+-------+---------+-------+------+-----------------------------+ 1 row in set (0.00 sec) 1.2.3.4.5.6.7.