[步骤]
(@tb_OrderSourceSkus [Tb_StringIds] READONLY) select a.ID as id,a.NotIncludeWithBatterys as notIncludeWithBatterys,a.Countrys as countries, d.TransportID as transportId,c.WareHouseID as wareHouseId, a.NoTaxTotalPriceMax as noTaxTotalPriceMax, a.ProductTotalPriceMax as productTotalPriceMax,b.ID AS ruleId, a.NoTaxCurrencyType AS noTaxCurrencyType, a.ProductTotalPriceCurrencyType as productTotalPriceCurrencyType,e.TransportType AS transportType FROM RB_OrderOperatePlan a ( NOLOCK ) INNER JOIN RB_AutoMatchWarehouseAndTransportRule b ( NOLOCK ) on a.RuleId = b.ID INNER JOIN RB_AutoMatchWarehouseDetail c ( NOLOCK ) on b.ID = c.RuleId INNER JOIN RB_AutoMatchTransportDetail d ( NOLOCK ) on b.ID = d.RuleId INNER JOIN RB_Transport e ON e.ID = d.TransportID where a.CustomerID = 1 and a.IsActive = 1 and b.IsActive = 1
虽然传入了 SKU 列表 但是没有使用，而且有大量并发
[结果]
[期望]
1.排查问题 传入了SKU 并未使用的原因（遗落）
2.如果不需要SKU 则需要添加缓存采用，控制并发