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