深圳智汇创想科技有限公司

[步骤]

SELECT
            b.order_code,
            b.position_id,
            b.ware_house_id,
            b.customer_id,
            b.sku,
            SUM(IFNULL( b.product_occupy_volume, 0 )) AS product_occupy_volume
        FROM
            t_stk_order_info a
                INNER JOIN t_stk_order_position b ON a.customer_id = b.customer_id
                AND a.order_code = b.order_code
        WHERE
            a.add_time >= DATE_ADD( NOW(), INTERVAL -12 MONTH )
                AND ( a.order_status = 2 OR a.order_state = 2 )
                AND a.customer_id = 1
        GROUP BY
            b.order_code,
            b.position_id,
            b.ware_house_id,
            b.customer_id,
            b.sku
        HAVING SUM(IFNULL( b.product_occupy_volume, 0 )) > 0;

[结果]

[期望]

整改SQL 或者 把语句加入缓存 减少请求频率