[步骤]

zhcxkj-erpworker-dotnet-cronjob

select top 20 p.SKU,bt.BrowsePathByID

--,bt.BrowseNodeName 

from RB_Product p(nolock)

join RB_Product_Admin pa(nolock) on p.SKU=pa.SKU AND p.CustomerID=pa.CustomerID

join E_Product_Amazon_BrowseTree bt(nolock) on bt.sku=p.sku and bt.CustomerID=p.CustomerID and bt.IsDelete=0 and bt.IsMain=1

where p.CustomerID=1 and p.IsGroup = 0 and p.ProductState<>2 and p.DeleteStatus = 0 and pa.DevelopStatus in(1,3)

and not exists(select 1 from RB_Product_ClassAttributeAI(nolock) where CustomerID=p.CustomerID and SKU=p.SKU)

[结果]

[期望]

排查问题 优化SQL 减少并发