[步骤]
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 减少并发