HWY-ZH-GZ-RDS-Warehouse库，zhcxkj-center-warehouse 服务慢sql: SELECT
count(*)
FROM
t_stk_procurement_detail_checklist a
LEFT JOIN t_stk_procurement_list tp ON tp.p_code=a.p_code AND tp.customer_id=a.customer_id
left join rb_ware_house c on a.wareHouse_id=c.id and a.customer_id=c.customer_id

WHERE a.customer_id = 1

= 2025-11-15 00:00:00


= a.add_time 扫描行百万以上，执行时间近10s

性能优化