sql语句:
SELECT
o.order_id,
SUM(o.discountAmount) AS discountAmount,
s.store_name,
o.create_time AS create_time,
o.cashPay AS cashAmount,
o.cardPay AS cardAmount,
m. NAME AS realname,
o.sn,
SUM(o.order_amount) AS order_amount,
o.aliPay AS aliPay,
o.wechatPay AS wechatPay,
o.payeasePay AS payeasePay
FROM
es_daycount_order o
LEFT JOIN es_daycount_order_items i ON i.order_id = o.order_id
LEFT JOIN es_goods AS g ON i.goods_id = g.goods_id
LEFT JOIN es_member AS m ON o.operator_id = m.member_id
LEFT JOIN es_store AS s ON m.store_id = s.store_id
WHERE
o.store_id IS NOT NULL
AND o.store_id IN (190, 192)
AND o.create_time > 1483200000
AND o.create_time < 1513958399
AND (
o.pay_status = 2
OR o.pay_status = 3
)
AND o.sn NOT LIKE '%SO10%'
AND o.sn NOT LIKE '%SO20%'
GROUP BY
i.order_id
ORDER BY
create_time DESC;
explain结果
现在查询时间是8秒左右。请问怎么优化