Explain Query (mysql)
EXPLAIN SELECT
o.*,
COUNT(od.order_details_id) AS totalQty
FROM
orders o
LEFT JOIN order_details od ON (od.order_id = o.order_id)
LEFT JOIN products p ON (p.product_id = od.product_id AND p.delivery_service_fees = 0)
WHERE (
(
(
o.status IN (0,1,2) OR (o.status = 5 AND o.subscription_id != 0 AND o.gift_receiver_id IS NULL)
) AND o.delivery_date > CURDATE()
) OR (
o.status = 4 AND o.delivery_date = CURDATE()
)
) AND o.user_id = '308842' AND o.gift_receiver_id IS NULL
GROUP BY
o.order_id
ORDER BY
o.delivery_date ASC
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | o | ref | PRIMARY, idx_subscription, idx_delivery_date, idx_user_id, ids_status, orders+delivery_date&status, idx_droppoint_id, fk_order_di, idx_status_delivery_date_subscription_type, orders_idx_status_droppoint_delivery, idx_status_charity_received, f_key_orders_company_id_associated, idx_oopm | idx_user_id | 4 | const | 213 | 0.03 | Using where; Using temporary; Using filesort | |
| 1 | SIMPLE | od | ref | idx_order_id | idx_order_id | 4 | securelufacom.o.order_id | 15 | 100.00 | ||
| 1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | securelufacom.od.product_id | 1 | 100.00 | Using where |