重现步骤

[步骤]

 SELECT     CAST(ph.[Id] AS BIGINT) AS [erp_id],     CAST(ph.[CustomerId] AS BIGINT) AS [customer_id],     ph.[SKU] AS [sku],     ph.[HighLightsOfFirst] AS [high_lights_off_first],     ph.[HighLightsOfSecond] AS [high_lights_off_second],     ph.[HighLightsOfThird] AS [high_lights_off_third],     ph.[HighLightsOfFourth] AS [high_lights_off_fourth],     ph.[HighLightsOfFifth] AS [high_lights_off_fifth],     CAST(ph.[AddAdminId] AS BIGINT) AS [create_by],     ph.[AddUserName] AS [create_name],     ph.[AddTime] AS [create_time],     CAST(ph.[UpdateAdminId] AS BIGINT) AS [update_by],     ph.[UpdateUserName] AS [update_name],     ph.[UpdateTime] AS [update_time],     CAST(0 AS INT) AS [is_deleted] FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK)     ON rb.SKU = ph.SKU WHERE     ph.[AddTime] >= DATEADD(MINUTE, -30, GETDATE())     OR ph.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE())     OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE())     OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE()) 
 SELECT     CAST(rpc.[ID] AS BIGINT) AS erp_id,     rpc.[CustomerID] AS customer_id,     rpc.[SKU] AS sku,     rpc.[RiskLevel] AS risk_level,     CAST(rpc.[PlatformId] AS BIGINT) AS platform_id,     NULLIF(LTRIM(RTRIM(rpc.[CountryShorthand])), '') AS country_shorthand,     0 AS create_by,     rpc.[AddTime] AS create_time,     0 AS update_by,     rpc.[AddTime] AS update_time,     0 AS is_deleted FROM dbo.RB_Product_Risklevel_PlatformCountry AS rpc WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK)     ON rb.SKU = rpc.SKU WHERE     rpc.[AddTime] >= DATEADD(MINUTE, -30, GETDATE())     OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE())     OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE()) 
 SELECT     CAST(rpf.[ID] AS BIGINT) AS [erp_id],     CAST(rpf.[CustomerID] AS BIGINT) AS [customer_id],     rpf.[SKU] AS [sku],     rpf.[Feature] AS [feature],     rpf.[InspectionStatus] AS [inspection_status],     rpf.[GeneratedDescription] AS [generated_description],     CAST(rpf.[InspectionId] AS BIGINT) AS [inspection_id],     rpf.[Inspection] AS [inspection_name],     rpf.[InspectionTime] AS [inspection_time],     0 AS [create_by],     '' AS [create_name],     rpf.[AddTime] AS [create_time],     0 AS [update_by],     '' AS [update_name],     rpf.[AddTime] AS [update_time],     0 AS [is_deleted] FROM dbo.RB_Product_Feature AS rpf WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK)     ON rb.SKU = rpf.SKU WHERE     rpf.[AddTime] >= DATEADD(MINUTE, -30, GETDATE())     OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE())     OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE()) 


SELECT Cast(ph.[Id] AS BIGINT)            AS [erp_id],
       Cast(ph.[CustomerId] AS BIGINT)    AS [customer_id],
       ph.[SKU]                           AS [sku],
       ph.[HighLightsOfFirst]             AS [high_lights_off_first],
       ph.[HighLightsOfSecond]            AS [high_lights_off_second],
       ph.[HighLightsOfThird]             AS [high_lights_off_third],
       ph.[HighLightsOfFourth]            AS [high_lights_off_fourth],
       ph.[HighLightsOfFifth]             AS [high_lights_off_fifth],
       Cast(ph.[AddAdminId] AS BIGINT)    AS [create_by],
       ph.[AddUserName]                   AS [create_name],
       ph.[AddTime]                       AS [create_time],
       Cast(ph.[UpdateAdminId] AS BIGINT) AS [update_by],
       ph.[UpdateUserName]                AS [update_name],
       ph.[UpdateTime]                    AS [update_time],
       Cast(0 AS INT)                     AS [is_deleted]
FROM   dbo.RB_Product_HighLights AS ph WITH (NOLOCK)
       JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK)
         ON rb.SKU = ph.SKU
WHERE  ph.[AddTime] >= Dateadd(MINUTE, -30, Getdate())
        OR ph.[UpdateTime] >= Dateadd(MINUTE, -30, Getdate())
        OR rb.[AddTime] >= Dateadd(MINUTE, -30, Getdate())
        OR rb.[UpdateTime] >= Dateadd(MINUTE, -30, Getdate()) 


[结果]


[期望]

优化SQL ,同步数据不要包含逻辑,增加数据库的负载
历史记录  
  1. 2026-07-13 14:07:46, 由 袁慧斌 创建。
  2. 2026-07-13 14:08:23, 由 李乐同 指派给 吴茵杰。
    修改了 指派给,旧值为 "liletong",新值为 "wuyinjie"。
  3. 2026-07-13 14:47:57, 由 吴茵杰 指派给 李乐同。
    修改了 指派给,旧值为 "wuyinjie",新值为 "liletong"。
    不是我这边的任务,没有权限调整
    问一下荣发这个海豚是哪一个组的,project_code = 126933523005728
  4. 2026-07-13 14:53:39, 由 李乐同 指派给 王海浪。
    修改了 指派给,旧值为 "liletong",新值为 "wanghailang"。
  5. 2026-07-13 14:55:59, 由 李乐同 指派给 刘朋。
    修改了 指派给,旧值为 "wanghailang",新值为 "liupeng"。
  6. 2026-07-13 16:04:52, 由 刘朋 解决,方案为 性能问题 。
    修改了 解决方案,旧值为 "",新值为 "performance"。
    修改了 解决日期,旧值为 "",新值为 "2026-07-13 16:04:36"。
    修改了 指派给 ,旧值为 "liupeng",新值为 "yuanhuibin"。
    修改了 Bug状态 ,旧值为 "active",新值为 "resolved"。
    修改了 是否确认,旧值为 "0",新值为 "1"。
    修改了 解决者 ,旧值为 "",新值为 "liupeng"。
    已处理。
  7. 2026-07-15 12:25:11, 由 袁慧斌 编辑。
    修改了 测试责任人,旧值为 "",新值为 "admin"。
    修改了 解决时效 ,旧值为 "0",新值为 "1.95"。
    修改了 截止日期 ,旧值为 "0000-00-00",新值为 "2026-07-14"。
    修改了 重现步骤 ,区别为:
    002- SELECT CAST(ph.[Id] AS BIGINT) AS [erp_id], CAST(ph.[CustomerId] AS BIGINT) AS [customer_id], ph.[SKU] AS [sku], ph.[HighLightsOfFirst] AS [high_lights_off_first], ph.[HighLightsOfSecond] AS [high_lights_off_second], ph.[HighLightsOfThird] AS [high_lights_off_third], ph.[HighLightsOfFourth] AS [high_lights_off_fourth], ph.[HighLightsOfFifth] AS [high_lights_off_fifth], CAST(ph.[AddAdminId] AS BIGINT) AS [create_by], ph.[AddUserName] AS [create_name], ph.[AddTime] AS [create_time], CAST(ph.[UpdateAdminId] AS BIGINT) AS [update_by], ph.[UpdateUserName] AS [update_name], ph.[UpdateTime] AS [update_time], CAST(0 AS INT) AS [is_deleted] FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = ph.SKU WHERE ph.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR ph.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE())SELECT CAST(rpc.[ID] AS BIGINT) AS erp_id, rpc.[CustomerID] AS customer_id, rpc.[SKU] AS sku, rpc.[RiskLevel] AS risk_level, CAST(rpc.[PlatformId] AS BIGINT) AS platform_id, NULLIF(LTRIM(RTRIM(rpc.[CountryShorthand])), '') AS country_shorthand, 0 AS create_by, rpc.[AddTime] AS create_time, 0 AS update_by, rpc.[AddTime] AS update_time, 0 AS is_deleted FROM dbo.RB_Product_Risklevel_PlatformCountry AS rpc WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = rpc.SKU WHERE rpc.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE())SELECT CAST(rpf.[ID] AS BIGINT) AS [erp_id], CAST(rpf.[CustomerID] AS BIGINT) AS [customer_id], rpf.[SKU] AS [sku], rpf.[Feature] AS [feature], rpf.[InspectionStatus] AS [inspection_status], rpf.[GeneratedDescription] AS [generated_description], CAST(rpf.[InspectionId] AS BIGINT) AS [inspection_id], rpf.[Inspection] AS [inspection_name], rpf.[InspectionTime] AS [inspection_time], 0 AS [create_by], '' AS [create_name], rpf.[AddTime] AS [create_time], 0 AS [update_by], '' AS [update_name], rpf.[AddTime] AS [update_time], 0 AS [is_deleted] FROM dbo.RB_Product_Feature AS rpf WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = rpf.SKU WHERE rpf.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE())
    002+ SELECT CAST(ph.[Id] AS BIGINT) AS [erp_id], CAST(ph.[CustomerId] AS BIGINT) AS [customer_id], ph.[SKU] AS [sku], ph.[HighLightsOfFirst] AS [high_lights_off_first], ph.[HighLightsOfSecond] AS [high_lights_off_second], ph.[HighLightsOfThird] AS [high_lights_off_third], ph.[HighLightsOfFourth] AS [high_lights_off_fourth], ph.[HighLightsOfFifth] AS [high_lights_off_fifth], CAST(ph.[AddAdminId] AS BIGINT) AS [create_by], ph.[AddUserName] AS [create_name], ph.[AddTime] AS [create_time], CAST(ph.[UpdateAdminId] AS BIGINT) AS [update_by], ph.[UpdateUserName] AS [update_name], ph.[UpdateTime] AS [update_time], CAST(0 AS INT) AS [is_deleted] FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = ph.SKU WHERE ph.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR ph.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE())SELECT CAST(rpc.[ID] AS BIGINT) AS erp_id, rpc.[CustomerID] AS customer_id, rpc.[SKU] AS sku, rpc.[RiskLevel] AS risk_level, CAST(rpc.[PlatformId] AS BIGINT) AS platform_id, NULLIF(LTRIM(RTRIM(rpc.[CountryShorthand])), '') AS country_shorthand, 0 AS create_by, rpc.[AddTime] AS create_time, 0 AS update_by, rpc.[AddTime] AS update_time, 0 AS is_deleted FROM dbo.RB_Product_Risklevel_PlatformCountry AS rpc WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = rpc.SKU WHERE rpc.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE())SELECT CAST(rpf.[ID] AS BIGINT) AS [erp_id], CAST(rpf.[CustomerID] AS BIGINT) AS [customer_id], rpf.[SKU] AS [sku], rpf.[Feature] AS [feature], rpf.[InspectionStatus] AS [inspection_status], rpf.[GeneratedDescription] AS [generated_description], CAST(rpf.[InspectionId] AS BIGINT) AS [inspection_id], rpf.[Inspection] AS [inspection_name], rpf.[InspectionTime] AS [inspection_time], 0 AS [create_by], '' AS [create_name], rpf.[AddTime] AS [create_time], 0 AS [update_by], '' AS [update_name], rpf.[AddTime] AS [update_time], 0 AS [is_deleted] FROM dbo.RB_Product_Feature AS rpf WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = rpf.SKU WHERE rpf.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] >= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] >= DATEADD(MINUTE, -30, GETDATE())
    005- SELECT Cast(ph.[Id] AS BIGINT) AS [erp_id], Cast(ph.[CustomerId] AS BIGINT) AS [customer_id], ph.[SKU] AS [sku], ph.[HighLightsOfFirst] AS [high_lights_off_first], ph.[HighLightsOfSecond] AS [high_lights_off_second], ph.[HighLightsOfThird] AS [high_lights_off_third], ph.[HighLightsOfFourth] AS [high_lights_off_fourth], ph.[HighLightsOfFifth] AS [high_lights_off_fifth], Cast(ph.[AddAdminId] AS BIGINT) AS [create_by], ph.[AddUserName] AS [create_name], ph.[AddTime] AS [create_time], Cast(ph.[UpdateAdminId] AS BIGINT) AS [update_by], ph.[UpdateUserName] AS [update_name], ph.[UpdateTime] AS [update_time], Cast(0 AS INT) AS [is_deleted]FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = ph.SKUWHERE ph.[AddTime] >= Dateadd(MINUTE, -30, Getdate()) OR ph.[UpdateTime] >= Dateadd(MINUTE, -30, Getdate()) OR rb.[AddTime] >= Dateadd(MINUTE, -30, Getdate()) OR rb.[UpdateTime] >= Dateadd(MINUTE, -30, Getdate())
    005+ SELECT Cast(ph.[Id] AS BIGINT) AS [erp_id], Cast(ph.[CustomerId] AS BIGINT) AS [customer_id], ph.[SKU] AS [sku], ph.[HighLightsOfFirst] AS [high_lights_off_first], ph.[HighLightsOfSecond] AS [high_lights_off_second], ph.[HighLightsOfThird] AS [high_lights_off_third], ph.[HighLightsOfFourth] AS [high_lights_off_fourth], ph.[HighLightsOfFifth] AS [high_lights_off_fifth], Cast(ph.[AddAdminId] AS BIGINT) AS [create_by], ph.[AddUserName] AS [create_name], ph.[AddTime] AS [create_time], Cast(ph.[UpdateAdminId] AS BIGINT) AS [update_by], ph.[UpdateUserName] AS [update_name], ph.[UpdateTime] AS [update_time], Cast(0 AS INT) AS [is_deleted]FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = ph.SKUWHERE ph.[AddTime] >= Dateadd(MINUTE, -30, Getdate()) OR ph.[UpdateTime] >= Dateadd(MINUTE, -30, Getdate()) OR rb.[AddTime] >= Dateadd(MINUTE, -30, Getdate()) OR rb.[UpdateTime] >= Dateadd(MINUTE, -30, Getdate())
    006-
    006+
    002- <p>SELECT CAST(ph.[Id] AS BIGINT) AS [erp_id], CAST(ph.[CustomerId] AS BIGINT) AS [customer_id], ph.[SKU] AS [sku], ph.[HighLightsOfFirst] AS [high_lights_off_first], ph.[HighLightsOfSecond] AS [high_lights_off_second], ph.[HighLightsOfThird] AS [high_lights_off_third], ph.[HighLightsOfFourth] AS [high_lights_off_fourth], ph.[HighLightsOfFifth] AS [high_lights_off_fifth], CAST(ph.[AddAdminId] AS BIGINT) AS [create_by], ph.[AddUserName] AS [create_name], ph.[AddTime] AS [create_time], CAST(ph.[UpdateAdminId] AS BIGINT) AS [update_by], ph.[UpdateUserName] AS [update_name], ph.[UpdateTime] AS [update_time], CAST(0 AS INT) AS [is_deleted] FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = ph.SKU WHERE ph.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR ph.[UpdateTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] &gt;= DATEADD(MINUTE, -30, GETDATE())<br />SELECT CAST(rpc.[ID] AS BIGINT) AS erp_id, rpc.[CustomerID] AS customer_id, rpc.[SKU] AS sku, rpc.[RiskLevel] AS risk_level, CAST(rpc.[PlatformId] AS BIGINT) AS platform_id, NULLIF(LTRIM(RTRIM(rpc.[CountryShorthand])), '') AS country_shorthand, 0 AS create_by, rpc.[AddTime] AS create_time, 0 AS update_by, rpc.[AddTime] AS update_time, 0 AS is_deleted FROM dbo.RB_Product_Risklevel_PlatformCountry AS rpc WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = rpc.SKU WHERE rpc.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] &gt;= DATEADD(MINUTE, -30, GETDATE())<br />SELECT CAST(rpf.[ID] AS BIGINT) AS [erp_id], CAST(rpf.[CustomerID] AS BIGINT) AS [customer_id], rpf.[SKU] AS [sku], rpf.[Feature] AS [feature], rpf.[InspectionStatus] AS [inspection_status], rpf.[GeneratedDescription] AS [generated_description], CAST(rpf.[InspectionId] AS BIGINT) AS [inspection_id], rpf.[Inspection] AS [inspection_name], rpf.[InspectionTime] AS [inspection_time], 0 AS [create_by], '' AS [create_name], rpf.[AddTime] AS [create_time], 0 AS [update_by], '' AS [update_name], rpf.[AddTime] AS [update_time], 0 AS [is_deleted] FROM dbo.RB_Product_Feature AS rpf WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = rpf.SKU WHERE rpf.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] &gt;= DATEADD(MINUTE, -30, GETDATE())<br /></p>
    002+ <p>SELECT CAST(ph.[Id] AS BIGINT) AS [erp_id], CAST(ph.[CustomerId] AS BIGINT) AS [customer_id], ph.[SKU] AS [sku], ph.[HighLightsOfFirst] AS [high_lights_off_first], ph.[HighLightsOfSecond] AS [high_lights_off_second], ph.[HighLightsOfThird] AS [high_lights_off_third], ph.[HighLightsOfFourth] AS [high_lights_off_fourth], ph.[HighLightsOfFifth] AS [high_lights_off_fifth], CAST(ph.[AddAdminId] AS BIGINT) AS [create_by], ph.[AddUserName] AS [create_name], ph.[AddTime] AS [create_time], CAST(ph.[UpdateAdminId] AS BIGINT) AS [update_by], ph.[UpdateUserName] AS [update_name], ph.[UpdateTime] AS [update_time], CAST(0 AS INT) AS [is_deleted] FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = ph.SKU WHERE ph.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR ph.[UpdateTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] &gt;= DATEADD(MINUTE, -30, GETDATE())<br />SELECT CAST(rpc.[ID] AS BIGINT) AS erp_id, rpc.[CustomerID] AS customer_id, rpc.[SKU] AS sku, rpc.[RiskLevel] AS risk_level, CAST(rpc.[PlatformId] AS BIGINT) AS platform_id, NULLIF(LTRIM(RTRIM(rpc.[CountryShorthand])), '') AS country_shorthand, 0 AS create_by, rpc.[AddTime] AS create_time, 0 AS update_by, rpc.[AddTime] AS update_time, 0 AS is_deleted FROM dbo.RB_Product_Risklevel_PlatformCountry AS rpc WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = rpc.SKU WHERE rpc.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] &gt;= DATEADD(MINUTE, -30, GETDATE())<br />SELECT CAST(rpf.[ID] AS BIGINT) AS [erp_id], CAST(rpf.[CustomerID] AS BIGINT) AS [customer_id], rpf.[SKU] AS [sku], rpf.[Feature] AS [feature], rpf.[InspectionStatus] AS [inspection_status], rpf.[GeneratedDescription] AS [generated_description], CAST(rpf.[InspectionId] AS BIGINT) AS [inspection_id], rpf.[Inspection] AS [inspection_name], rpf.[InspectionTime] AS [inspection_time], 0 AS [create_by], '' AS [create_name], rpf.[AddTime] AS [create_time], 0 AS [update_by], '' AS [update_name], rpf.[AddTime] AS [update_time], 0 AS [is_deleted] FROM dbo.RB_Product_Feature AS rpf WITH (NOLOCK) JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK) ON rb.SKU = rpf.SKU WHERE rpf.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[AddTime] &gt;= DATEADD(MINUTE, -30, GETDATE()) OR rb.[UpdateTime] &gt;= DATEADD(MINUTE, -30, GETDATE())</p>
    005- <p>SELECT Cast(ph.[Id] AS BIGINT) AS [erp_id],<br /> Cast(ph.[CustomerId] AS BIGINT) AS [customer_id],<br /> ph.[SKU] AS [sku],<br /> ph.[HighLightsOfFirst] AS [high_lights_off_first],<br /> ph.[HighLightsOfSecond] AS [high_lights_off_second],<br /> ph.[HighLightsOfThird] AS [high_lights_off_third],<br /> ph.[HighLightsOfFourth] AS [high_lights_off_fourth],<br /> ph.[HighLightsOfFifth] AS [high_lights_off_fifth],<br /> Cast(ph.[AddAdminId] AS BIGINT) AS [create_by],<br /> ph.[AddUserName] AS [create_name],<br /> ph.[AddTime] AS [create_time],<br /> Cast(ph.[UpdateAdminId] AS BIGINT) AS [update_by],<br /> ph.[UpdateUserName] AS [update_name],<br /> ph.[UpdateTime] AS [update_time],<br /> Cast(0 AS INT) AS [is_deleted]<br />FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK)<br /> JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK)<br /> ON rb.SKU = ph.SKU<br />WHERE ph.[AddTime] &gt;= Dateadd(MINUTE, -30, Getdate())<br /> OR ph.[UpdateTime] &gt;= Dateadd(MINUTE, -30, Getdate())<br /> OR rb.[AddTime] &gt;= Dateadd(MINUTE, -30, Getdate())<br /> OR rb.[UpdateTime] &gt;= Dateadd(MINUTE, -30, Getdate())<br /></p><div><br /></div>
    005+ <p>SELECT Cast(ph.[Id] AS BIGINT) AS [erp_id],<br /> Cast(ph.[CustomerId] AS BIGINT) AS [customer_id],<br /> ph.[SKU] AS [sku],<br /> ph.[HighLightsOfFirst] AS [high_lights_off_first],<br /> ph.[HighLightsOfSecond] AS [high_lights_off_second],<br /> ph.[HighLightsOfThird] AS [high_lights_off_third],<br /> ph.[HighLightsOfFourth] AS [high_lights_off_fourth],<br /> ph.[HighLightsOfFifth] AS [high_lights_off_fifth],<br /> Cast(ph.[AddAdminId] AS BIGINT) AS [create_by],<br /> ph.[AddUserName] AS [create_name],<br /> ph.[AddTime] AS [create_time],<br /> Cast(ph.[UpdateAdminId] AS BIGINT) AS [update_by],<br /> ph.[UpdateUserName] AS [update_name],<br /> ph.[UpdateTime] AS [update_time],<br /> Cast(0 AS INT) AS [is_deleted]<br />FROM dbo.RB_Product_HighLights AS ph WITH (NOLOCK)<br /> JOIN [dbo].[RB_Product] AS rb WITH (NOLOCK)<br /> ON rb.SKU = ph.SKU<br />WHERE ph.[AddTime] &gt;= Dateadd(MINUTE, -30, Getdate())<br /> OR ph.[UpdateTime] &gt;= Dateadd(MINUTE, -30, Getdate())<br /> OR rb.[AddTime] &gt;= Dateadd(MINUTE, -30, Getdate())<br /> OR rb.[UpdateTime] &gt;= Dateadd(MINUTE, -30, Getdate())</p>
    006-
    006+ <div><br /></div>
  8. 2026-07-15 12:25:13, 由 袁慧斌 关闭。
    修改了 Bug状态 ,旧值为 "resolved",新值为 "closed"。
    修改了 指派给 ,旧值为 "yuanhuibin",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "yuanhuibin"。
    修改了 关闭日期,旧值为 "",新值为 "2026-07-15 12:25:13"。
所属项目 技术中心-需求池
所属模块 数据智能   数据工程
所属计划
所属迭代
Bug类型
严重程度 一般
优先级 P1
Bug状态 已关闭
业务部门 供应链管理中心
影响功能
开发责任人 刘朋
测试责任人 admin
解决时效 1.95
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2026-07-15 12:25:13
截止日期 2026-07-14
上线时间 2026-07-14 18:30:00
上线时效 28.37
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2026-07-13 14:07:45
影响环境 生产环境-线上测试
由谁解决 刘朋 于 2026-07-13 16:04:36
解决版本
解决方案 性能问题
由谁关闭 袁慧斌 于 2026-07-15 12:25:13
最后修改 袁慧斌 于 2026-07-15 12:25:13
相关Bug