[步骤]
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 ,同步数据不要包含逻辑,增加数据库的负载
问一下荣发这个海豚是哪一个组的,project_code = 126933523005728