反馈人：王凯
问题1：
严重级别：严重所属项目：JAVA项目仓储物流板块
问题原因：慢sql，扫描行数200万
SELECT b.order_code, a.warehouse_id, b.id AS order_list_id, b.sku, b.customer_id, (b.product_num + IFNULL(b.product_num_update,0)) product_num, b.pending_move_number- IFNULL(f.sumNumber, 0) lock_num, d.order_source_type, a.amazon_shipment_id, IFNULL(e.order_build_type, -1) order_build_type, IFNULL(e.is_sta_com_order, 0) is_sta_com_order, IFNULL(e.interface_type, 0) interface_type, 3 as task_type, 0 as taskStatus, b.pending_move_number, IFNULL(f.sumNumber, 0) sumNumber FROM t_stk_order_info a JOIN t_stk_order_list b ON a.order_code = b.order_code AND a.customer_id = b.customer_id JOIN rb_order_source d ON a.order_source_id = d.id AND a.customer_id = d.customer_id LEFT JOIN ( SELECT a.customer_id,a.origin_order_code,b.order_list_id, SUM(CASE WHEN a.task_status < 4 then b.sku_number else IFNULL(b.moved_number,0)+IFNULL(b.abnormal_number,0)end) sumNumber from t_stk_moving_task a join t_stk_moving_task_detail b on b.moving_task_id=a.id and b.customer_id=a.customer_id WHERE task_type=3 AND task_status < 5 GROUP BY a.customer_id,a.origin_order_code,b.order_list_id )f on f.origin_order_code=a.order_code and f.order_list_id=b.id AND f.customer_id=a.customer_id LEFT JOIN t_stk_order_info_beikuexpand e ON a.order_code = e.order_code AND a.customer_id = e.customer_id WHERE a.add_time >= DATE_ADD(CURRENT_TIMESTAMP,INTERVAL -12 MONTH) AND a.is_stock_order = 1 AND b.pending_move_number- IFNULL(f.sumNumber, 0) > 0;
解决方案：优化索引
问题2：
严重级别：严重
所属项目：JAVA项目仓储物流板块
问题原因：慢sql，扫描行数130万
SELECT
count(*) FROM t_stk_procurement_detail_orderbuy a
LEFT JOIN t_stk_procurement_detail_buylist_detail b ON a.buy_detail_id
= b.id LEFT JOIN t_stk_procurement_detail_singlelist_detail c
ON b.single_detail_id = c.id LEFT JOIN t_stk_order_list d ON
a.order_list_id = d.id WHERE 1=1
AND a.customer_id = 1
and a.add_time >= '2025-06-15
00:00:00'
and '2025-07-15 23:59:59' >= a.add_time;
解决方案：优化索引