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

001- 反馈人：吴荣发
001+ 反馈人：吴荣发 数据库：zhcxkj-center-warehouse 节点ID：312c1bb8cc0545f2b9a867053843bea2in01 查询时间：31.4392 扫描行数：1949100.0 返回行数：41.4898 一天执行次数： 49 慢日志时间：2025-07-25 指纹：0c63b19aa8248c71120f9db0095fa03a SQL语句：SELECT b . order_code , b . position_id , b . ware_house_id , b . customer_id , b . sku , SUM ( IFNULL ( b . product_occupy_volume , ? ) ) AS product_occupy_volume FROM ? 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 ? MONTH ) AND ( a . order_status = ? OR a . order_state = ? ) AND a . customer_id = ? GROUP BY b . order_code , b . position_id , b . ware_house_id , b . customer_id , b . sku HAVING SUM ( IFNULL ( b . product_occupy_volume , ? ) ) > ? ; 真实SQL：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; 负责人参考：程伟 项目参考：java项目
002- 数据库：zhcxkj-center-warehouse
003- 节点ID：312c1bb8cc0545f2b9a867053843bea2in01
004- 查询时间：31.4392
005- 扫描行数：1949100.0
006- 返回行数：41.4898
007- 一天执行次数： 49
008- 慢日志时间：2025-07-25
009- 指纹：0c63b19aa8248c71120f9db0095fa03a
010- SQL语句：SELECT b . order_code , b . position_id , b . ware_house_id , b . customer_id , b . sku , SUM ( IFNULL ( b . product_occupy_volume , ? ) ) AS product_occupy_volume FROM ? 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 ? MONTH ) AND ( a . order_status = ? OR a . order_state = ? ) AND a . customer_id = ? GROUP BY b . order_code , b . position_id , b . ware_house_id , b . customer_id , b . sku HAVING SUM ( IFNULL ( b . product_occupy_volume , ? ) ) > ? ;
011- 真实SQL：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;
012- 负责人参考：程伟
013- 项目参考：java项目

001- 反馈人：吴荣发<br />
001+ 反馈人：吴荣发<br /> 数据库：zhcxkj-center-warehouse<br /> 节点ID：312c1bb8cc0545f2b9a867053843bea2in01<br /> 查询时间：31.4392<br /> 扫描行数：1949100.0<br /> 返回行数：41.4898<br /> 一天执行次数： 49<br /> 慢日志时间：2025-07-25<br /> 指纹：0c63b19aa8248c71120f9db0095fa03a<br /> SQL语句：SELECT b . order_code , b . position_id , b . ware_house_id , b . customer_id , b . sku , SUM ( IFNULL ( b . product_occupy_volume , ? ) ) AS product_occupy_volume FROM ? 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 &gt;= DATE_ADD ( NOW ( ) , INTERVAL ? MONTH ) AND ( a . order_status = ? OR a . order_state = ? ) AND a . customer_id = ? GROUP BY b . order_code , b . position_id , b . ware_house_id , b . customer_id , b . sku HAVING SUM ( IFNULL ( b . product_occupy_volume , ? ) ) &gt; ? ;<br /> 真实SQL：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 &gt;= 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 )) &gt; 0;<br /> 负责人参考：程伟<br /> 项目参考：java项目<br />
002- 数据库：zhcxkj-center-warehouse<br />
003- 节点ID：312c1bb8cc0545f2b9a867053843bea2in01<br />
004- 查询时间：31.4392<br />
005- 扫描行数：1949100.0<br />
006- 返回行数：41.4898<br />
007- 一天执行次数： 49<br />
008- 慢日志时间：2025-07-25<br />
009- 指纹：0c63b19aa8248c71120f9db0095fa03a<br />
010- SQL语句：SELECT b . order_code , b . position_id , b . ware_house_id , b . customer_id , b . sku , SUM ( IFNULL ( b . product_occupy_volume , ? ) ) AS product_occupy_volume FROM ? 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 &gt;= DATE_ADD ( NOW ( ) , INTERVAL ? MONTH ) AND ( a . order_status = ? OR a . order_state = ? ) AND a . customer_id = ? GROUP BY b . order_code , b . position_id , b . ware_house_id , b . customer_id , b . sku HAVING SUM ( IFNULL ( b . product_occupy_volume , ? ) ) &gt; ? ;<br />
011- 真实SQL：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 &gt;= 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 )) &gt; 0;<br />
012- 负责人参考：程伟<br />
013- 项目参考：java项目<br />