Explain Query (mysql)
EXPLAIN SELECT COUNT(orders.order_id) as baskets_shipped
FROM `orders`
WHERE `status` = 4
AND `charity_received` > 0
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | orders | range | ids_status, idx_status_delivery_date_subscription_type, orders_idx_status_droppoint_delivery, idx_status_charity_received | idx_status_charity_received | 5 | 55128 | 50.00 | Using where; Using index |