BUG #64786 性能优化- 本地服务器ZHCX-CWD-038 Python SQL 语句缺少 CustomerID 的关联导致无法使用索引性能差 - 技术中心-需求池

重现步骤

[步骤]

此查询文本从显示计划 XML 检索获得，并可能会被截断。

SELECT

m.SKU,

CASE WHEN m.ProductGroupType = 0 THEN '单品'

WHEN m.ProductGroupType = 1 THEN 'A*N'

WHEN m.ProductGroupType = 2 THEN 'A+B'

END AS '组合方式',

CASE m.DevelopType

WHEN 1 THEN '自主开发'

WHEN 2 THEN '供应商后台'

WHEN 3 THEN '指定开发'

WHEN 4 THEN '智能选品'

WHEN 5 THEN '销售提报_FBA新品'

WHEN 6 THEN '智选转FBA提报'

END AS '开发类型',

CASE WHEN m.DevelopmentStyle = 0 THEN '未设置'

WHEN m.DevelopmentStyle = 1 THEN '同款'

WHEN m.DevelopmentStyle = 2 THEN '类似款'

END AS '开发款',

m.SalesMarketCountryEN,

m.OnlineTime,

m.AddTime AS '新增时间',

m.审核时间,

m.OverTime AS '完结时间',

m.产品侵权风险,

m.是否停产,

m.产品一级品类,

m.平台一级类目,

m.中文名称,

m.提报人员,

m.AddAdminId,

m.DepartmentID

INTO #tb

FROM

(SELECT

a.SKU,

a.ProductGroupType,

a.DevelopType,

a.DevelopmentStyle,

a.SalesMarketCountryEN,

a.OnlineTime,

a.产品侵权风险,

a.是否停产,

a.产品一级品类,

a.平台一级类目,

a.中文名称,

a.提报人员,

a.AddAdminId,

a.DepartmentID,

a.审核时间,

a.OverTime,

a.AddTime,

ROW_NUMBER()OVER(PARTITION BY a.SKU ORDER BY a.AddTime) AS 'rowid'

FROM

(SELECT

DISTINCT

a.SKU,

e.OnlineTime,

CASE a.ProductProperty

WHEN 0 THEN '未选择'

WHEN 1 THEN '非仿牌'

WHEN 2 THEN '仿牌'

WHEN 3 THEN '灰色产品'

END AS '产品侵权风险',

CASE WHEN a.ProductState = 2 THEN '停产' ELSE '未停产' END AS '是否停产',

c.SalesMarketCountryEN,

d.ClassNameCn AS '产品一级品类',

(select value from dbo.StringSplit(br.BrowseNodeName, '>>',1) where id= 1) AS '平台一级类目',

a.ProductNameCN AS '中文名称',

c.AddAdminName AS '提报人员',

-- CASE WHEN c.AddAdminName != '' THEN c.AddAdminName ELSE g.UserName END AS '提报人员',

-- CASE WHEN CAST(c.AddAdminName AS varchar) != '' THEN c.AddAdminName ELSE CAST(g.UserName AS varchar) END AS '提报人员',

-- CASE WHEN c.AddAdminId > 0 THEN c.AddAdminId ELSE c.SalesAdminIds END AS 'AddAdminId',

c.AddAdminId,

f.DepartmentID,

c.AddTime,

(

SELECT TOP 1

AddTime

FROM dbo.RB_Product_Development_Status

WHERE CustomerID = c.CustomerID

AND Remarks = '销售已审核'

AND ProductDevelopmentId = c.Id

ORDER BY AddTime DESC

) 审核时间,

c.ProductGroupType,

a.DevelopType,

c.DevelopmentStyle,

c.OverTime

FROM

dbo.RB_ProductDevelopment_Related_Product(NOLOCK) AS b

LEFT JOIN RB_Product_Development(NOLOCK) AS c ON c.CustomerID = 1 AND b.ProductDevelopmentId = c.Id

LEFT JOIN E_Product_Amazon_BrowseTree br WITH (NOLOCK) ON b.SKU = br.SKU AND br.IsMain=1 AND br.IsDelete = 0

LEFT JOIN dbo.RB_Product(NOLOCK) AS a ON a.CustomerID = b.CustomerID AND b.SKU = a.SKU

LEFT JOIN dbo.RB_Product_Class(NOLOCK) AS d ON b.CustomerID = d.CustomerID AND a.ClassID1 = d.ID

LEFT JOIN dbo.RB_Product_Admin(NOLOCK) AS e ON b.CustomerID = e.CustomerID AND b.SKU = e.SKU

LEFT JOIN dbo.RB_Admin(NOLOCK) AS f ON b.CustomerID = f.CustomerID AND c.AddAdminId = f.ID

LEFT JOIN dbo.RB_Admin(NOLOCK) AS g ON b.CustomerID = g.CustomerID AND c.SalesAdminIds = g.ID

LEFT JOIN E_Product_Amazon_BrowseTree br WITH (NOLOCK) ON b.SKU = br.SKU AND br.IsMain=1 AND br.IsDelete = 0 这里缺少 CustomerID 导致用不上索引

[结果]

[期望]

补充条件 CustomerID =1

历史记录

2026-08-27 10:15:21, 由 袁慧斌 创建。
2026-08-27 11:04:07, 由 袁慧斌 编辑。
修改了 解决时效，旧值为 "0"，新值为 "-1"。
修改了 Bug标题 ，区别为：
001- ~~性能优化-本地服务器ZHCX-CWD-038 SQL 语句缺少 CustomerID 的关联导致无法使用索引性能差~~
001+ 性能优化- 本地服务器ZHCX-CWD-038 Python SQL 语句缺少 CustomerID 的关联导致无法使用索引性能差

001- ~~性能优化-本地服务器ZHCX-CWD-038 SQL 语句缺少 CustomerID 的关联导致无法使用索引性能差~~
001+ 性能优化- 本地服务器ZHCX-CWD-038 Python SQL 语句缺少 CustomerID 的关联导致无法使用索引性能差
修改了 重现步骤，区别为：
002- /*
002+ /*
004- ~~此查询文本从显示计划 XML 检索获得，并可能会被截断。~~
004+ 此查询文本从显示计划 XML 检索获得，并可能会被截断。
006- */
006+ */
009- ~~SELECT~~
009+ SELECT
011- ~~m.SKU,~~
011+ m.SKU,
013- ~~CASE WHEN m.ProductGroupType = 0 THEN '单品'~~
013+ CASE WHEN m.ProductGroupType = 0 THEN '单品'
015- ~~WHEN m.ProductGroupType = 1 THEN 'A*N'~~
015+ WHEN m.ProductGroupType = 1 THEN 'A*N'
017- ~~WHEN m.ProductGroupType = 2 THEN 'A+B'~~
017+ WHEN m.ProductGroupType = 2 THEN 'A+B'
019- ~~END AS '组合方式',~~
019+ END AS '组合方式',
021- ~~CASE m.DevelopType~~
021+ CASE m.DevelopType
023- ~~WHEN 1 THEN '自主开发'~~
023+ WHEN 1 THEN '自主开发'
025- ~~WHEN 2 THEN '供应商后台'~~
025+ WHEN 2 THEN '供应商后台'
027- ~~WHEN 3 THEN '指定开发'~~
027+ WHEN 3 THEN '指定开发'
029- ~~WHEN 4 THEN '智能选品'~~
029+ WHEN 4 THEN '智能选品'
031- ~~WHEN 5 THEN '销售提报_FBA新品'~~
031+ WHEN 5 THEN '销售提报_FBA新品'
033- ~~WHEN 6 THEN '智选转FBA提报'~~
033+ WHEN 6 THEN '智选转FBA提报'
035- ~~END AS '开发类型',~~
035+ END AS '开发类型',
037- ~~CASE WHEN m.DevelopmentStyle = 0 THEN '未设置'~~
037+ CASE WHEN m.DevelopmentStyle = 0 THEN '未设置'
039- ~~WHEN m.DevelopmentStyle = 1 THEN '同款'~~
039+ WHEN m.DevelopmentStyle = 1 THEN '同款'
041- ~~WHEN m.DevelopmentStyle = 2 THEN '类似款'~~
041+ WHEN m.DevelopmentStyle = 2 THEN '类似款'
043- ~~END AS '开发款',~~
043+ END AS '开发款',
045- ~~m.SalesMarketCountryEN,~~
045+ m.SalesMarketCountryEN,
047- ~~m.OnlineTime,~~
047+ m.OnlineTime,
049- ~~m.AddTime AS '新增时间',~~
049+ m.AddTime AS '新增时间',
051- ~~m.审核时间,~~
051+ m.审核时间,
053- ~~m.OverTime AS '完结时间',~~
053+ m.OverTime AS '完结时间',
055- ~~m.产品侵权风险,~~
055+ m.产品侵权风险,
057- ~~m.是否停产,~~
057+ m.是否停产,
059- ~~m.产品一级品类,~~
059+ m.产品一级品类,
061- ~~m.平台一级类目,~~
061+ m.平台一级类目,
063- ~~m.中文名称,~~
063+ m.中文名称,
065- ~~m.提报人员,~~
065+ m.提报人员,
067- ~~m.AddAdminId,~~
067+ m.AddAdminId,
069- ~~m.DepartmentID~~
069+ m.DepartmentID
071- ~~INTO #tb~~
071+ INTO #tb
073- ~~FROM~~
073+ FROM
075- ~~(SELECT~~
075+ (SELECT
077- ~~a.SKU,~~
077+ a.SKU,
079- ~~a.ProductGroupType,~~
079+ a.ProductGroupType,
081- ~~a.DevelopType,~~
081+ a.DevelopType,
083- ~~a.DevelopmentStyle,~~
083+ a.DevelopmentStyle,
085- ~~a.SalesMarketCountryEN,~~
085+ a.SalesMarketCountryEN,
087- ~~a.OnlineTime,~~
087+ a.OnlineTime,
089- ~~a.产品侵权风险,~~
089+ a.产品侵权风险,
091- ~~a.是否停产,~~
091+ a.是否停产,
093- ~~a.产品一级品类,~~
093+ a.产品一级品类,
095- ~~a.平台一级类目,~~
095+ a.平台一级类目,
097- ~~a.中文名称,~~
097+ a.中文名称,
099- ~~a.提报人员,~~
099+ a.提报人员,
101- ~~a.AddAdminId,~~
101+ a.AddAdminId,
103- ~~a.DepartmentID,~~
103+ a.DepartmentID,
105- ~~a.审核时间,~~
105+ a.审核时间,
107- ~~a.OverTime,~~
107+ a.OverTime,
109- ~~a.AddTime,~~
109+ a.AddTime,
111- ~~ROW_NUMBER()OVER(PARTITION BY a.SKU ORDER BY a.AddTime) AS 'rowid'~~
111+ ROW_NUMBER()OVER(PARTITION BY a.SKU ORDER BY a.AddTime) AS 'rowid'
113- ~~FROM~~
113+ FROM
115- ~~(SELECT~~
115+ (SELECT
117- ~~DISTINCT~~
117+ DISTINCT
119- ~~a.SKU,~~
119+ a.SKU,
121- ~~e.OnlineTime,~~
121+ e.OnlineTime,
123- ~~CASE a.ProductProperty~~
123+ CASE a.ProductProperty
125- ~~WHEN 0 THEN '未选择'~~
125+ WHEN 0 THEN '未选择'
127- ~~WHEN 1 THEN '非仿牌'~~
127+ WHEN 1 THEN '非仿牌'
129- ~~WHEN 2 THEN '仿牌'~~
129+ WHEN 2 THEN '仿牌'
131- ~~WHEN 3 THEN '灰色产品'~~
131+ WHEN 3 THEN '灰色产品'
133- ~~END AS '产品侵权风险',~~
133+ END AS '产品侵权风险',
135- ~~CASE WHEN a.ProductState = 2 THEN '停产' ELSE '未停产' END AS '是否停产',~~
135+ CASE WHEN a.ProductState = 2 THEN '停产' ELSE '未停产' END AS '是否停产',
137- ~~c.SalesMarketCountryEN,~~
137+ c.SalesMarketCountryEN,
139- ~~d.ClassNameCn AS '产品一级品类',~~
139+ d.ClassNameCn AS '产品一级品类',
141- ~~(select value from dbo.StringSplit(br.BrowseNodeName, '>>',1) where id= 1) AS '平台一级类目',~~
141+ (select value from dbo.StringSplit(br.BrowseNodeName, '>>',1) where id= 1) AS '平台一级类目',
143- ~~a.ProductNameCN AS '中文名称',~~
143+ a.ProductNameCN AS '中文名称',
145- ~~c.AddAdminName AS '提报人员',~~
145+ c.AddAdminName AS '提报人员',
147- ~~-- CASE WHEN c.AddAdminName != '' THEN c.AddAdminName ELSE g.UserName END AS '提报人员',~~
147+ -- CASE WHEN c.AddAdminName != '' THEN c.AddAdminName ELSE g.UserName END AS '提报人员',
149- ~~-- CASE WHEN CAST(c.AddAdminName AS varchar) != '' THEN c.AddAdminName ELSE CAST(g.UserName AS varchar) END AS '提报人员',~~
149+ -- CASE WHEN CAST(c.AddAdminName AS varchar) != '' THEN c.AddAdminName ELSE CAST(g.UserName AS varchar) END AS '提报人员',
151- ~~-- CASE WHEN c.AddAdminId > 0 THEN c.AddAdminId ELSE c.SalesAdminIds END AS 'AddAdminId',~~
151+ -- CASE WHEN c.AddAdminId > 0 THEN c.AddAdminId ELSE c.SalesAdminIds END AS 'AddAdminId',
153- ~~c.AddAdminId,~~
153+ c.AddAdminId,
155- ~~f.DepartmentID,~~
155+ f.DepartmentID,
157- ~~c.AddTime,~~
157+ c.AddTime,
159- (
159+ (
161- ~~SELECT TOP 1~~
161+ SELECT TOP 1
163- ~~AddTime~~
163+ AddTime
165- ~~FROM dbo.RB_Product_Development_Status~~
165+ FROM dbo.RB_Product_Development_Status
167- ~~WHERE CustomerID = c.CustomerID~~
167+ WHERE CustomerID = c.CustomerID
169- ~~AND Remarks = '销售已审核'~~
169+ AND Remarks = '销售已审核'
171- ~~AND ProductDevelopmentId = c.Id~~
171+ AND ProductDevelopmentId = c.Id
173- ~~ORDER BY AddTime DESC~~
173+ ORDER BY AddTime DESC
175- ~~) 审核时间,~~
175+ ) 审核时间,
177- ~~c.ProductGroupType,~~
177+ c.ProductGroupType,
179- ~~a.DevelopType,~~
179+ a.DevelopType,
181- ~~c.DevelopmentStyle,~~
181+ c.DevelopmentStyle,
183- ~~c.OverTime~~
183+ c.OverTime
185- ~~FROM~~
185+ FROM
187- ~~dbo.RB_ProductDevelopment_Related_Product(NOLOCK) AS b~~
187+ dbo.RB_ProductDevelopment_Related_Product(NOLOCK) AS b
189- ~~LEFT JOIN RB_Product_Development(NOLOCK) AS c ON c.CustomerID = 1 AND b.ProductDevelopmentId = c.Id~~
189+ LEFT JOIN RB_Product_Development(NOLOCK) AS c ON c.CustomerID = 1 AND b.ProductDevelopmentId = c.Id
191- ~~LEFT JOIN E_Product_Amazon_BrowseTree br WITH (NOLOCK) ON b.SKU = br.SKU AND br.IsMain=1 AND br.IsDelete = 0~~
191+ LEFT JOIN E_Product_Amazon_BrowseTree br WITH (NOLOCK) ON b.SKU = br.SKU AND br.IsMain=1 AND br.IsDelete = 0
193- ~~LEFT JOIN dbo.RB_Product(NOLOCK) AS a ON a.CustomerID = b.CustomerID AND b.SKU = a.SKU~~
193+ LEFT JOIN dbo.RB_Product(NOLOCK) AS a ON a.CustomerID = b.CustomerID AND b.SKU = a.SKU
195- ~~LEFT JOIN dbo.RB_Product_Class(NOLOCK) AS d ON b.CustomerID = d.CustomerID AND a.ClassID1 = d.ID~~
195+ LEFT JOIN dbo.RB_Product_Class(NOLOCK) AS d ON b.CustomerID = d.CustomerID AND a.ClassID1 = d.ID
197- ~~LEFT JOIN dbo.RB_Product_Admin(NOLOCK) AS e ON b.CustomerID = e.CustomerID AND b.SKU = e.SKU~~
197+ LEFT JOIN dbo.RB_Product_Admin(NOLOCK) AS e ON b.CustomerID = e.CustomerID AND b.SKU = e.SKU
199- ~~LEFT JOIN dbo.RB_Admin(NOLOCK) AS f ON b.CustomerID = f.CustomerID AND c.AddAdminId = f.ID~~
199+ LEFT JOIN dbo.RB_Admin(NOLOCK) AS f ON b.CustomerID = f.CustomerID AND c.AddAdminId = f.ID

002- ~~/*~~
002+ /*
004- ~~此查询文本从显示计划 XML 检索获得，并可能会被截断。~~
004+ 此查询文本从显示计划 XML 检索获得，并可能会被截断。
006- ~~*/~~
006+ */
009- ~~SELECT~~
009+ SELECT
011- ~~ m.SKU,~~
011+ m.SKU,
013- ~~ CASE WHEN m.ProductGroupType = 0 THEN '单品'~~
013+ CASE WHEN m.ProductGroupType = 0 THEN '单品'
015- ~~ WHEN m.ProductGroupType = 1 THEN 'A*N'~~
015+ WHEN m.ProductGroupType = 1 THEN 'A*N'
017- ~~ WHEN m.ProductGroupType = 2 THEN 'A+B'~~
017+ WHEN m.ProductGroupType = 2 THEN 'A+B'
019- ~~ END AS '组合方式',~~
019+ END AS '组合方式',
021- ~~ CASE m.DevelopType~~
021+ CASE m.DevelopType
023- ~~ WHEN 1 THEN '自主开发'~~
023+ WHEN 1 THEN '自主开发'
025- ~~ WHEN 2 THEN '供应商后台'~~
025+ WHEN 2 THEN '供应商后台'
027- ~~ WHEN 3 THEN '指定开发'~~
027+ WHEN 3 THEN '指定开发'
029- ~~ WHEN 4 THEN '智能选品'~~
029+ WHEN 4 THEN '智能选品'
031- ~~ WHEN 5 THEN '销售提报_FBA新品'~~
031+ WHEN 5 THEN '销售提报_FBA新品'
033- ~~ WHEN 6 THEN '智选转FBA提报'~~
033+ WHEN 6 THEN '智选转FBA提报'
035- ~~ END AS '开发类型',~~
035+ END AS '开发类型',
037- ~~ CASE WHEN m.DevelopmentStyle = 0 THEN '未设置'~~
037+ CASE WHEN m.DevelopmentStyle = 0 THEN '未设置'
039- ~~ WHEN m.DevelopmentStyle = 1 THEN '同款'~~
039+ WHEN m.DevelopmentStyle = 1 THEN '同款'
041- ~~ WHEN m.DevelopmentStyle = 2 THEN '类似款'~~
041+ WHEN m.DevelopmentStyle = 2 THEN '类似款'
043- ~~ END AS '开发款',~~
043+ END AS '开发款',
045- ~~ m.SalesMarketCountryEN,~~
045+ m.SalesMarketCountryEN,
047- ~~ m.OnlineTime,~~
047+ m.OnlineTime,
049- ~~ m.AddTime AS '新增时间',~~
049+ m.AddTime AS '新增时间',
051- ~~ m.审核时间,~~
051+ m.审核时间,
053- ~~ m.OverTime AS '完结时间',~~
053+ m.OverTime AS '完结时间',
055- ~~ m.产品侵权风险,~~
055+ m.产品侵权风险,
057- ~~ m.是否停产,~~
057+ m.是否停产,
059- ~~ m.产品一级品类,~~
059+ m.产品一级品类,
061- ~~ m.平台一级类目,~~
061+ m.平台一级类目,
063- ~~ m.中文名称,~~
063+ m.中文名称,
065- ~~ m.提报人员,~~
065+ m.提报人员,
067- ~~ m.AddAdminId,~~
067+ m.AddAdminId,
069- ~~ m.DepartmentID~~
069+ m.DepartmentID
071- ~~ INTO #tb~~
071+ INTO #tb
073- ~~ FROM ~~
073+ FROM 
075- ~~ (SELECT~~
075+ (SELECT
077- ~~ a.SKU,~~
077+ a.SKU,
079- ~~ a.ProductGroupType,~~
079+ a.ProductGroupType,
081- ~~ a.DevelopType,~~
081+ a.DevelopType,
083- ~~ a.DevelopmentStyle,~~
083+ a.DevelopmentStyle,
085- ~~ a.SalesMarketCountryEN,~~
085+ a.SalesMarketCountryEN,
087- ~~ a.OnlineTime,~~
087+ a.OnlineTime,
089- ~~ a.产品侵权风险,~~
089+ a.产品侵权风险,
091- ~~ a.是否停产,~~
091+ a.是否停产,
093- ~~ a.产品一级品类,~~
093+ a.产品一级品类,
095- ~~ a.平台一级类目,~~
095+ a.平台一级类目,
097- ~~ a.中文名称,~~
097+ a.中文名称,
099- ~~ a.提报人员,~~
099+ a.提报人员,
101- ~~ a.AddAdminId,~~
101+ a.AddAdminId,
103- ~~ a.DepartmentID,~~
103+ a.DepartmentID,
105- ~~ a.审核时间,~~
105+ a.审核时间,
107- ~~ a.OverTime,~~
107+ a.OverTime,
109- ~~ a.AddTime,~~
109+ a.AddTime,
111- ~~ ROW_NUMBER()OVER(PARTITION BY a.SKU ORDER BY a.AddTime) AS 'rowid'~~
111+ ROW_NUMBER()OVER(PARTITION BY a.SKU ORDER BY a.AddTime) AS 'rowid'
113- ~~ FROM ~~
113+ FROM 
115- ~~ (SELECT~~
115+ (SELECT
117- ~~ DISTINCT~~
117+ DISTINCT
119- ~~ a.SKU,~~
119+ a.SKU,
121- ~~ e.OnlineTime,~~
121+ e.OnlineTime,
123- ~~ CASE a.ProductProperty~~
123+ CASE a.ProductProperty
125- ~~ WHEN 0 THEN '未选择'~~
125+ WHEN 0 THEN '未选择'
127- ~~ WHEN 1 THEN '非仿牌'~~
127+ WHEN 1 THEN '非仿牌'
129- ~~ WHEN 2 THEN '仿牌'~~
129+ WHEN 2 THEN '仿牌'
131- ~~ WHEN 3 THEN '灰色产品'~~
131+ WHEN 3 THEN '灰色产品'
133- ~~ END AS '产品侵权风险',~~
133+ END AS '产品侵权风险',
135- ~~ CASE WHEN a.ProductState = 2 THEN '停产' ELSE '未停产' END AS '是否停产',~~
135+ CASE WHEN a.ProductState = 2 THEN '停产' ELSE '未停产' END AS '是否停产',
137- ~~ c.SalesMarketCountryEN,~~
137+ c.SalesMarketCountryEN,
139- ~~ d.ClassNameCn AS '产品一级品类',~~
139+ d.ClassNameCn AS '产品一级品类',
141- ~~ (select value from dbo.StringSplit(br.BrowseNodeName, '>>',1) where id= 1) AS '平台一级类目',~~
141+ (select value from dbo.StringSplit(br.BrowseNodeName, '>>',1) where id= 1) AS '平台一级类目',
143- ~~ a.ProductNameCN AS '中文名称',~~
143+ a.ProductNameCN AS '中文名称',
145- ~~ c.AddAdminName AS '提报人员',~~
145+ c.AddAdminName AS '提报人员',
147- ~~ -- CASE WHEN c.AddAdminName != '' THEN c.AddAdminName ELSE g.UserName END AS '提报人员',~~
147+ -- CASE WHEN c.AddAdminName != '' THEN c.AddAdminName ELSE g.UserName END AS '提报人员',
149- ~~ -- CASE WHEN CAST(c.AddAdminName AS varchar) != '' THEN c.AddAdminName ELSE CAST(g.UserName AS varchar) END AS '提报人员',~~
149+ -- CASE WHEN CAST(c.AddAdminName AS varchar) != '' THEN c.AddAdminName ELSE CAST(g.UserName AS varchar) END AS '提报人员',
151- ~~ -- CASE WHEN c.AddAdminId > 0 THEN c.AddAdminId ELSE c.SalesAdminIds END AS 'AddAdminId',~~
151+ -- CASE WHEN c.AddAdminId > 0 THEN c.AddAdminId ELSE c.SalesAdminIds END AS 'AddAdminId',
153- ~~ c.AddAdminId,~~
153+ c.AddAdminId,
155- ~~ f.DepartmentID,~~
155+ f.DepartmentID,
157- ~~ c.AddTime,~~
157+ c.AddTime,
159- ~~ (~~
159+ (
161- ~~ SELECT TOP 1~~
161+ SELECT TOP 1
163- ~~ AddTime~~
163+ AddTime
165- ~~ FROM dbo.RB_Product_Development_Status~~
165+ FROM dbo.RB_Product_Development_Status
167- ~~ WHERE CustomerID = c.CustomerID~~
167+ WHERE CustomerID = c.CustomerID
169- ~~ AND Remarks = '销售已审核'~~
169+ AND Remarks = '销售已审核'
171- ~~ AND ProductDevelopmentId = c.Id~~
171+ AND ProductDevelopmentId = c.Id
173- ~~ ORDER BY AddTime DESC~~
173+ ORDER BY AddTime DESC
175- ~~ ) 审核时间,~~
175+ ) 审核时间,
177- ~~ c.ProductGroupType,~~
177+ c.ProductGroupType,
179- ~~ a.DevelopType,~~
179+ a.DevelopType,
181- ~~ c.DevelopmentStyle,~~
181+ c.DevelopmentStyle,
183- ~~ c.OverTime~~
183+ c.OverTime
185- ~~ FROM ~~
185+ FROM 
187- ~~ dbo.RB_ProductDevelopment_Related_Product(NOLOCK) AS b~~
187+ dbo.RB_ProductDevelopment_Related_Product(NOLOCK) AS b
189- ~~ LEFT JOIN RB_Product_Development(NOLOCK) AS c ON c.CustomerID = 1 AND b.ProductDevelopmentId = c.Id~~
189+ LEFT JOIN RB_Product_Development(NOLOCK) AS c ON c.CustomerID = 1 AND b.ProductDevelopmentId = c.Id
191- ~~ LEFT JOIN E_Product_Amazon_BrowseTree br WITH (NOLOCK) ON b.SKU = br.SKU AND br.IsMain=1 AND br.IsDelete = 0~~
191+ LEFT JOIN E_Product_Amazon_BrowseTree br WITH (NOLOCK) ON b.SKU = br.SKU AND br.IsMain=1 AND br.IsDelete = 0
193- ~~ LEFT JOIN dbo.RB_Product(NOLOCK) AS a ON a.CustomerID = b.CustomerID AND b.SKU = a.SKU~~
193+ LEFT JOIN dbo.RB_Product(NOLOCK) AS a ON a.CustomerID = b.CustomerID AND b.SKU = a.SKU
195- ~~ LEFT JOIN dbo.RB_Product_Class(NOLOCK) AS d ON b.CustomerID = d.CustomerID AND a.ClassID1 = d.ID~~
195+ LEFT JOIN dbo.RB_Product_Class(NOLOCK) AS d ON b.CustomerID = d.CustomerID AND a.ClassID1 = d.ID
197- ~~ LEFT JOIN dbo.RB_Product_Admin(NOLOCK) AS e ON b.CustomerID = e.CustomerID AND b.SKU = e.SKU~~
197+ LEFT JOIN dbo.RB_Product_Admin(NOLOCK) AS e ON b.CustomerID = e.CustomerID AND b.SKU = e.SKU
199- ~~ LEFT JOIN dbo.RB_Admin(NOLOCK) AS f ON b.CustomerID = f.CustomerID AND c.AddAdminId = f.ID~~
199+ LEFT JOIN dbo.RB_Admin(NOLOCK) AS f ON b.CustomerID = f.CustomerID AND c.AddAdminId = f.ID
2026-08-27 15:25:10, 由 李乐同 指派给 林渝渊。
修改了 指派给，旧值为 "liletong"，新值为 "linyuyuan"。
修改了 抄送给，旧值为 ",shupengming,zhurongfeng"，新值为 ""。
2026-08-27 15:29:14, 由 林渝渊 解决，方案为 程序BUG 。
修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2026-08-27 15:29:07"。
修改了 指派给 ，旧值为 "linyuyuan"，新值为 "yuanhuibin"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "linyuyuan"。
2026-08-28 15:07:05, 由 袁慧斌 编辑。
修改了 开发责任人，旧值为 ""，新值为 "admin"。
修改了 测试责任人，旧值为 ""，新值为 "admin"。
修改了 解决时效 ，旧值为 "0"，新值为 "5.23"。
修改了 截止日期 ，旧值为 "0000-00-00"，新值为 "2026-08-27"。
修改了 上线时间 ，旧值为 "0000-00-00 00:00:00"，新值为 "2026-08-27 18:30"。
修改了 上线时效 ，旧值为 "-1"，新值为 "8.24"。
2026-08-28 15:07:07, 由 袁慧斌 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "yuanhuibin"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "yuanhuibin"。
修改了 关闭日期，旧值为 ""，新值为 "2026-08-28 15:07:07"。

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

所属项目	技术中心-需求池
所属模块	数据智能数据工程
所属计划
所属迭代
Bug类型
严重程度	一般
优先级	P1
Bug状态	已关闭
业务部门	技术研发中心
影响功能
开发责任人	admin
测试责任人	admin
解决时效	5.23
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2026-08-28 15:07:07
截止日期	2026-08-27
上线时间	2026-08-27 18:30:00
上线时效	8.24
操作系统
浏览器
关键词
抄送给

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

Bug的一生
其他相关

由谁创建	袁慧斌于 2026-08-27 10:15:21
影响环境	生产环境-线上测试
由谁解决	林渝渊于 2026-08-27 15:29:07
解决版本	主干
解决方案	程序BUG
由谁关闭	袁慧斌于 2026-08-28 15:07:07
最后修改	袁慧斌于 2026-08-28 15:07:07

相关Bug