Explain Query (mysql)
EXPLAIN SELECT * FROM `user_home_deliveries` `t` WHERE `t`.`order_id`='22240692' LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | ref | idx_order_id | idx_order_id | 4 | const | 1 | 100.00 |