https://alidocs.dingtalk.com/i/nodes/2Amq4vjg89gab9DztpZ1ZbK1V3kdP0wQ?doc_type=wiki_doc
反馈人：王凯
zhcxkj-center-warehouse 慢sql，请勿过多联表 和多层嵌套 ，业务拆分分步、分批处理数据，从代码中进行数据拼接、组装 ： 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
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
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
= 2025-01-08 15:15:00.097
AND a.is_stock_order = 1
0
0