哎,这次苦逼的经历,真泥坑爹,看了一下午SQL,眼睛都快看瞎了,现在终于解决了,总结一下吧.
中午的时候运维报了一个慢SQL出来.看了一下执行计划,没发现问题,SQL如下
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
SELECT f.factory_name AS factoryName, fw.workshop_name AS workshopName, c.commodity_code AS commodityCode, CONCAT( c.commodity_name, '(', c.commodity_spec, ')' ) AS commodityName, SUM(ol.commodity_num) AS commodityNum, ol.commodity_price * ol.commodity_num FROM t_order o JOIN t_order_list_gift ol ON o.id = ol.order_id JOIN t_store s ON o.store_id = s.id JOIN t_distribution_line dl ON s.store_line_id = dl.id JOIN t_commodity c ON ol.commodity_id = c.id JOIN t_factory f ON c.commodity_factory = f.factory_code JOIN t_factory_workshop fw ON c.new_workshop = fw.workshop_code WHERE o.order_time = '2017-06-02' AND s.store_code = '2010648' AND f.id = 59570401667998008 AND o.order_status = 0 GROUP BY c.commodity_code; |
执行计划如下图