[步骤]

(@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  则需要添加缓存采用，控制并发