RDS Mysql 数据库sql优化
SELECT COUNT(1)
FROM a_goods g
INNER JOIN a_goods_lease gl ON gl.GOODS_ID = g.ID
LEFT JOIN (SELECT ORDER_NO, GOODS_ID AS goodsId
FROM a_order_item
WHERE 1 = 1
AND (ORDER_STATUS = 2
OR ORDER_STATUS = 4)
AND (END_TIME > NOW()
AND BEGIN_TIME < DATE_ADD(NOW(), INTERVAL 1 HOUR)
OR BEGIN_TIME < DATE_ADD(NOW(), INTERVAL 1 HOUR)
AND END_TIME > DATE_ADD(NOW(), INTERVAL 1 HOUR)
OR BEGIN_TIME >= NOW()
AND END_TIME < DATE_ADD(NOW(), INTERVAL 1 HOUR)
OR BEGIN_TIME < NOW()
AND END_TIME > DATE_ADD(NOW(), INTERVAL 1 HOUR))
GROUP BY GOODS_ID
) o ON o.goodsId = g.ID
WHERE g.GOODS_STATUS = 3
AND g.GOODS_FLAG = 0
AND o.ORDER_NO IS NULL
给位大神坐等。。。