mysql explain type

只关注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