Explain Query (mysql)
EXPLAIN SELECT * FROM `orders` `t` WHERE (t.user_id=308842) AND ((user_id='308842') AND (status='4')) ORDER BY delivery_date DESC LIMIT 1
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | t | ref | idx_user_id, ids_status, idx_status_delivery_date_subscription_type, orders_idx_status_droppoint_delivery | idx_user_id | 4 | const | 213 | 50.00 | Using where; Using filesort |