1.根据同步listing数据得定时服务，查到查询数据时超时情况，导致数据丢失

2.根据超时SQL，请求系统部吴高发优化SQL 脚本如下

DECLARE @OrderSourceSKUs VARCHAR(MAX) = @OrderSourceSKUList;
DROP TABLE IF EXISTS #tabSku;
DROP TABLE IF EXISTS #tabProductV2;

CREATE TABLE #tabSku
(
    sku VARCHAR(100)
);
INSERT INTO #tabSku
EXEC proc_string_split @OrderSourceSKUs, ',';
CREATE INDEX idx_sku ON #tabSku (sku);


SELECT a.OrderSourceID,
       a.OrderSourceSKU,
       a.TemplateID,
       a.VariantGroup,
       a.TranslateStatus,
       a.IsVariation,
       a.BrandAddTitle,
       a.QueueID,
       a.CustomerID
INTO #tabProductV2
FROM RB_AmazonUploadProduct_V2 a (NOLOCK)
    INNER JOIN #tabSku t
        ON a.OrderSourceSKU = t.sku
WHERE a.CustomerID = 1
      AND a.AddTime > '2022-08-01';

CREATE INDEX idx_QueueID_CustomerID
ON #tabProductV2 (
                     QueueID,
                     CustomerID
                 );

SELECT a.OrderSourceID,
       a.OrderSourceSKU,
       a.TemplateID,
       b.BrowsePathByID,
       b.RecommendedBrowseNodeName,
       a.VariantGroup,
       a.TranslateStatus,
       a.IsVariation,
       a.BrandAddTitle
FROM #tabProductV2 a
    INNER JOIN RB_AmazonUploadResult_V2 b (NOLOCK)
        ON a.CustomerID = b.CustomerID
           AND a.QueueID = b.ID;
DROP TABLE IF EXISTS #tabSku;
DROP TABLE IF EXISTS #tabProductV2;

3.再跳板机调试可以查询出结果

4.根据原来的SQL，查询2个渠道SKU原来需要38秒，现在查询200个店铺不到1秒

性能问题，需要持续跟进