BUG #58424 性能优化-ERP 更新 RB_Comment_Strategy_Performance 量太大，文本过多系统解析困难容易阻塞 - 智能中心-需求池

重现步骤

[步骤]

UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'4 von 5 Durchschnittliche Bewertung: 4,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 2 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"50%","4_Stars":"0%","5_Stars":"50%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 1 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 1 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 1 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 1 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'4 von 5 Durchschnittliche Bewertung: 4,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"50%","4_Stars":"0%","5_Stars":"50%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVW7X7KH' AND Site='DE' AND CustomerID=1;

UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'4,4 von 5 Durchschnittliche Bewertung: 4,4 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 5 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"14%","4_Stars":"29%","5_Stars":"57%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 3 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 3 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'4,4 von 5 Durchschnittliche Bewertung: 4,4 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 5 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"14%","4_Stars":"29%","5_Stars":"57%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVX3ZG27' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'3,4 von 5 Durchschnittliche Bewertung: 3,4 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 6 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"36%","2_Stars":"0%","3_Stars":"0%","4_Stars":"16%","5_Stars":"48%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 2 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 2 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'3,4 von 5 Durchschnittliche Bewertung: 3,4 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 6 END) , NewStarPercent = '{"1_Stars":"36%","2_Stars":"0%","3_Stars":"0%","4_Stars":"16%","5_Stars":"48%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVX994ZQ' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVX9TCP9' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVW7ZBPH' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'3,6 von 5 Durchschnittliche Bewertung: 3,6 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 3 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"72%","4_Stars":"0%","5_Stars":"28%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 2 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'3,6 von 5 Durchschnittliche Bewertung: 3,6 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 3 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"72%","4_Stars":"0%","5_Stars":"28%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVXDLLZV' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVW83N2W' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVXP6BNF' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'4 von 5 Durchschnittliche Bewertung: 4,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 11 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"17%","2_Stars":"0%","3_Stars":"0%","4_Stars":"32%","5_Stars":"51%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 8 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 1 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 8 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 1 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'4 von 5 Durchschnittliche Bewertung: 4,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 11 END) , NewStarPercent = '{"1_Stars":"17%","2_Stars":"0%","3_Stars":"0%","4_Stars":"32%","5_Stars":"51%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVXPMSML' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVXYLD1N' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVYC6ZJ3' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'4 von 5 Durchschnittliche Bewertung: 4,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 2 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"100%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 2 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'4 von 5 Durchschnittliche Bewertung: 4,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"100%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVW85XPW' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVYKDC7D' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'5 von 5 Durchschnittliche Bewertung: 5,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 1 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"100%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 1 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 1 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'5 von 5 Durchschnittliche Bewertung: 5,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 1 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"100%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVYNRMQ5' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'3,7 von 5 Durchschnittliche Bewertung: 3,7 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 3 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"31%","3_Stars":"0%","4_Stars":"33%","5_Stars":"36%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 1 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 1 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'3,7 von 5 Durchschnittliche Bewertung: 3,7 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 3 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"31%","3_Stars":"0%","4_Stars":"33%","5_Stars":"36%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVW87BFQ' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVYYW82T' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVW8DMSZ' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVW8G2JT' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVZ53LX5' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END ) , FirstStarCount = (CASE WHEN (GainNum=0 and 0=0) THEN N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' ELSE FirstStarCount END ) , FirstReviewCount = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstReviewCount END ) , FirstStarPercent = (CASE WHEN GainNum=0 THEN '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' ELSE FirstStarPercent END ) , FirstGoodNum =(CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstGoodNum END ) , FirstInNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstInNum END ) , FirstDifferNum = (CASE WHEN (GainNum=0 and 0=0) THEN 0 ELSE FirstDifferNum END) , NewGoodNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewInNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewDifferNum = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarCount = (CASE WHEN (GainNum=0 and 0=1) THEN '' ELSE N'0 von 5 Durchschnittliche Bewertung: 0,0 von 5 Sternen' END) , NewReviewCount = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 0 END) , NewStarPercent = '{"1_Stars":"0%","2_Stars":"0%","3_Stars":"0%","4_Stars":"0%","5_Stars":"0%"}' , State = (CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE 2 END) , GainNum =(CASE WHEN (GainNum=0 and 0=1) THEN 0 ELSE GainNum+1 END) WHERE Asin = 'B0CVZBGZBN' AND Site='DE' AND CustomerID=1; UPDATE dbo.RB_Comment_Strategy_Performance SET UpdateTime = (CASE WHEN UpdateTime<'2025/7/24 0:00:00' THEN '2025/7/24 12:01:01' ELSE UpdateTime END )&nb

历史记录

2025-07-24 14:58:09, 由 袁慧斌 创建。
2025-07-25 11:05:20, 由 李乐同 指派给宋宁。
修改了 指派给，旧值为 "liletong"，新值为 "songning"。
2025-07-25 12:40:38, 由宋宁指派给 李乐同。
修改了 指派给，旧值为 "songning"，新值为 "liletong"。

百货这边没有直接更新erp表的场景
2025-07-25 14:15:38, 由 王翔宇 指派给 冯名明。
修改了 指派给，旧值为 "liletong"，新值为 "fengmingming"。
2025-07-25 16:10:46, 由 冯名明 解决，方案为 性能问题 。
修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2025-07-25 16:08:44"。
修改了 指派给 ，旧值为 "fengmingming"，新值为 "yuanhuibin"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "fengmingming"。

一个批次100条数据，再100条数据里面循环单条执行需要更新的SQL，更新完一批之后，休眠1秒，再更新下一个批次
2025-07-25 17:00:47, 由 袁慧斌 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "yuanhuibin"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "yuanhuibin"。
修改了 关闭日期，旧值为 ""，新值为 "2025-07-25 17:00:47"。

基本信息
迭代/需求/任务

所属项目	智能中心-需求池
所属模块	战略独立项目智能运营
所属计划
所属迭代
Bug类型
严重程度	一般
优先级	P2
Bug状态	已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效	0
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2025-07-25 17:00:47
截止日期	0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给

所属迭代
相关需求
相关任务

Bug的一生
其他相关

由谁创建	袁慧斌于 2025-07-24 14:58:09
影响环境	生产环境-业务反馈
由谁解决	冯名明于 2025-07-25 16:08:44
解决版本	主干
解决方案	性能问题
由谁关闭	袁慧斌于 2025-07-25 17:00:47
最后修改	袁慧斌于 2025-07-25 17:00:47

相关Bug