Explain Query (mysql)
EXPLAIN SELECT COUNT(*) FROM `orders` WHERE `user_id` = '308842' AND status = 4 AND type = 0 ORDER BY order_id LIMIT 2
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | orders | ref | idx_user_id, ids_status, idx_status_delivery_date_subscription_type, orders_idx_status_droppoint_delivery | idx_user_id | 4 | const | 213 | 5.00 | Using where |