只关注explain的type字段
1 id是主键的场景
explain select * from task_wait WHERE id = 18913352
id
|
select_type
|
table
|
type
|
possible_keys
|
key
|
key_len
|
ref
|
rows
|
Extra
|
1
|
SIMPLE |
task_wait |
const |
PRIMARY |
PRIMARY |
8 |
const |
1
|
Using pk access |