Explain Query (mysql)
EXPLAIN SELECT
IFNULL(ROUND(SUM(order_amount)/COUNT(*)+2),0)
FROM (
SELECT
orders.total_order_amount /*+orders.discount*/ -orders.total_national_tax-orders.total_provincial_tax-orders.delivery_service_amount-orders.total_contribution_amount-orders.total_consigne_amount as order_amount
FROM
orders
WHERE
orders.status = 4 AND
orders.type NOT IN (4, 3) AND
orders.user_id = '308842'
ORDER BY
orders.delivery_date DESC
LIMIT 8
) tmp
| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | PRIMARY | <derived2> | ALL | 8 | 100.00 | ||||||
| 2 | DERIVED | orders | ref | idx_user_id, ids_status, idx_status_delivery_date_subscription_type, orders_idx_status_droppoint_delivery | idx_user_id | 4 | const | 213 | 40.00 | Using where; Using filesort |