反馈人：erp运维监控
ERP站点慢sql, 仓库频繁反馈卡顿超时小黄鸡: [10:22:14] -------------------------------------------------------------
CODE:N10221413Error:11_-2_0_-2146232060
SQL:
SELECT
pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID AS AreaID,ISNULL(SUM(CASE WHEN pos.StockReduceNum > 0 THEN pos.StockReduceNum ELSE pos.PickingNum END),0) AS StatisticCount
FROM RB_Package_OperateStock pos(NOLOCK)
INNER JOIN RB_WareHousePostArea wpa(NOLOCK)
ON pos.WareHouseID=wpa.WareHouseID
AND pos.PositionID=wpa.PositionID
AND pos.CustomerID=wpa.CustomerID
INNER JOIN RB_Procurement_Order_Package pop WITH(NOLOCK)
ON pop.ID = pos.PackageID
AND pop.CustomerID = pos.CustomerID
INNER JOIN RB_Package_Picking pp WITH(NOLOCK)
ON pp.PrintBatchNo = pop.PrintBatchNo
AND pp.CustomerID = pop.CustomerID
WHERE pos.CustomerID=@CustomerID
AND pos.WareHouseID=@WarehouseID
AND pos.IsDelete=@IsDelete
AND pos.PickingTime>=@StartTime AND pos.PickingTime<=@EndTime
AND pos.StockReduceNum+pos.PickingNum>0
AND wpa.WareHouseAreaID in(315,327,329,330,456,458,465,467,468,469,470,534,542,554,556,572,573,574,575,576,577,578,579)
AND pp.PickingType = @PickingType AND pp.PickingStatus IN(0,1)
GROUP BY pos.CustomerID,pos.WareHouseID,wpa.WareHouseAreaID
PARAMS:@CustomerID = 1 ,@WarehouseID = 5312 ,@StartTime = 2026/4/2 9:00:00 ,@EndTime = 2026/4/3 9:00:00 ,@IsDelete = False ,@PickingType = 1 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。