重现步骤

[步骤]

系统读写延迟，调查发现读库有这个语句非常慢，请调整处理。

select           t1.ID,  t1.CustomerID,  t1.OrderCode,  t1.P_S_Code,  t1.ProductType,  t1.SKU,  t1.ParameterIDs,  t1.OptionsIDs,  t1.ParameterValues,  t1.Standard,  t1.ProductNum,  t1.ProductNumUpdate,  t1.PurchaseNum,  t1.PurchaseType,  t1.ProblemType,  t1.ProductPrice,  t1.ShippingPrice,  t1.BuyPrice,  t1.ActivityID,  t1.ActivityName,  t1.ActivityMinusPrice,  t1.ClientSKU,  t1.OrderItemId,  t1.ASIN,  t1.SellerSKU,  t1.ItemTitle,  t1.ItemTitleCn,  t1.ItemMemo,  t1.MemberID,  t1.CookieValue,  t1.IP,  t1.AddTime,  t1.GroupSKU,  t1.GroupProductNum,  t1.GroupProductPrice,  t1.P_Code_Build,  t1.P_Code_Time,  t1.OldOrderListID,  t1.LockNum,  t1.LockTime,  t1.SharePrice,  t1.ItemListingType,  t1.CommentType,  t1.CheckAdminID,  t1.CheckAdminName,  t1.AssignDevelopAdminID,  t1.AssignDevelopAdminName,  t1.BuyerID,  t1.BuyerName,  t1.EditAdminID,  t1.EditAdminName,  t1.ImageAdminID,  t1.ImageAdminName,  t1.BusinessAdminID,  t1.BusinessAdminName,  t1.SellerType,  t1.IsFBA,  t1.ItemSite,  t1.RefundPrincipalAmount,  t1.RefundShippingAmount,  t1.PromotionDiscount,  t1.PromotionId,  t1.AmazonDeliveryStatus,  t1.AmazonCompeteRemark,  t1.BusinessTeamID,  t1.BusinessTeamName,  t1.DevelopAdminID,  t1.DevelopAdminName,  t1.Marks,  t1.GroupShippingPrice,  t1.GroupProductNumUpdate,  t1.LockGroupProductNum,  t1.IsBiSycnComplete,  t1.BiSycnCompleteTime,  CASE   WHEN t1.UpdateTime IS NULL THEN   t1.AddTime ELSE t1.UpdateTime   END "UpdateTime",  t1.ExtendedInfo FROM  dbo.RB_OrderList(NOLOCK)  t1  inner join dbo.RB_OrderInfo(NOLOCK)  t2 on t1.CustomerID = t2.CustomerID and t1.OrderCode = t2.OrderCode WHERE t2.IsStockOrder = 0 and t2.IsPay = 1 and (t1.UpdateTime >='2020-12-31 23:59:59' or t1.AddTime >='2020-12-31 23:59:59')


[结果]


[期望]


历史记录  
  1. 2022-08-08 11:06:42, 由 袁慧斌 创建。
  2. 2022-08-11 09:23:14, 由 胡晓龙 指派给 程伟。
    修改了 指派给，旧值为 "huxiaolong"，新值为 "chengwei"。
    程伟 安排人跟进一下
  3. 2022-08-11 11:26:13, 由 程伟 指派给 胡晓龙。
    修改了 指派给，旧值为 "chengwei"，新值为 "huxiaolong"。

    不是我这边的，记得改下所属模块

    看下是不是王谦的

  4. 2022-08-21 23:29:35, 由 胡晓龙 指派给 王谦。
    修改了 指派给，旧值为 "huxiaolong"，新值为 "wangqian"。
  5. 2022-08-21 23:29:56, 由 胡晓龙 编辑。
    修改了 所属模块，旧值为 "1680"，新值为 "1712"。
    修改了 重现步骤，区别为：
    002- select t1.ID, t1.CustomerID, t1.OrderCode, t1.P_S_Code, t1.ProductType, t1.SKU, t1.ParameterIDs, t1.OptionsIDs, t1.ParameterValues, t1.Standard, t1.ProductNum, t1.ProductNumUpdate, t1.PurchaseNum, t1.PurchaseType, t1.ProblemType, t1.ProductPrice, t1.ShippingPrice, t1.BuyPrice, t1.ActivityID, t1.ActivityName, t1.ActivityMinusPrice, t1.ClientSKU, t1.OrderItemId, t1.ASIN, t1.SellerSKU, t1.ItemTitle, t1.ItemTitleCn, t1.ItemMemo, t1.MemberID, t1.CookieValue, t1.IP, t1.AddTime, t1.GroupSKU, t1.GroupProductNum, t1.GroupProductPrice, t1.P_Code_Build, t1.P_Code_Time, t1.OldOrderListID, t1.LockNum, t1.LockTime, t1.SharePrice, t1.ItemListingType, t1.CommentType, t1.CheckAdminID, t1.CheckAdminName, t1.AssignDevelopAdminID, t1.AssignDevelopAdminName, t1.BuyerID, t1.BuyerName, t1.EditAdminID, t1.EditAdminName, t1.ImageAdminID, t1.ImageAdminName, t1.BusinessAdminID, t1.BusinessAdminName, t1.SellerType, t1.IsFBA, t1.ItemSite, t1.RefundPrincipalAmount, t1.RefundShippingAmount, t1.PromotionDiscount, t1.PromotionId, t1.AmazonDeliveryStatus, t1.AmazonCompeteRemark, t1.BusinessTeamID, t1.BusinessTeamName, t1.DevelopAdminID, t1.DevelopAdminName, t1.Marks, t1.GroupShippingPrice, t1.GroupProductNumUpdate, t1.LockGroupProductNum, t1.IsBiSycnComplete, t1.BiSycnCompleteTime, CASE WHEN t1.UpdateTime IS NULL THEN t1.AddTime ELSE t1.UpdateTime END "UpdateTime", t1.ExtendedInfo FROM dbo.RB_OrderList(NOLOCK) t1 inner join dbo.RB_OrderInfo(NOLOCK) t2 on t1.CustomerID = t2.CustomerID and t1.OrderCode = t2.OrderCode WHERE t2.IsStockOrder = 0 and t2.IsPay = 1 and (t1.UpdateTime >='2020-12-31 23:59:59' or t1.AddTime >='2020-12-31 23:59:59')
    002+ select t1.ID, t1.CustomerID, t1.OrderCode, t1.P_S_Code, t1.ProductType, t1.SKU, t1.ParameterIDs, t1.OptionsIDs, t1.ParameterValues, t1.Standard, t1.ProductNum, t1.ProductNumUpdate, t1.PurchaseNum, t1.PurchaseType, t1.ProblemType, t1.ProductPrice, t1.ShippingPrice, t1.BuyPrice, t1.ActivityID, t1.ActivityName, t1.ActivityMinusPrice, t1.ClientSKU, t1.OrderItemId, t1.ASIN, t1.SellerSKU, t1.ItemTitle, t1.ItemTitleCn, t1.ItemMemo, t1.MemberID, t1.CookieValue, t1.IP, t1.AddTime, t1.GroupSKU, t1.GroupProductNum, t1.GroupProductPrice, t1.P_Code_Build, t1.P_Code_Time, t1.OldOrderListID, t1.LockNum, t1.LockTime, t1.SharePrice, t1.ItemListingType, t1.CommentType, t1.CheckAdminID, t1.CheckAdminName, t1.AssignDevelopAdminID, t1.AssignDevelopAdminName, t1.BuyerID, t1.BuyerName, t1.EditAdminID, t1.EditAdminName, t1.ImageAdminID, t1.ImageAdminName, t1.BusinessAdminID, t1.BusinessAdminName, t1.SellerType, t1.IsFBA, t1.ItemSite, t1.RefundPrincipalAmount, t1.RefundShippingAmount, t1.PromotionDiscount, t1.PromotionId, t1.AmazonDeliveryStatus, t1.AmazonCompeteRemark, t1.BusinessTeamID, t1.BusinessTeamName, t1.DevelopAdminID, t1.DevelopAdminName, t1.Marks, t1.GroupShippingPrice, t1.GroupProductNumUpdate, t1.LockGroupProductNum, t1.IsBiSycnComplete, t1.BiSycnCompleteTime, CASE WHEN t1.UpdateTime IS NULL THEN t1.AddTime ELSE t1.UpdateTime END "UpdateTime", t1.ExtendedInfo FROM dbo.RB_OrderList(NOLOCK) t1 inner join dbo.RB_OrderInfo(NOLOCK) t2 on t1.CustomerID = t2.CustomerID and t1.OrderCode = t2.OrderCode WHERE t2.IsStockOrder = 0 and t2.IsPay = 1 and (t1.UpdateTime >='2020-12-31 23:59:59' or t1.AddTime >='2020-12-31 23:59:59')
    002- <p>select t1.ID, t1.CustomerID, t1.OrderCode, t1.P_S_Code, t1.ProductType, t1.SKU, t1.ParameterIDs, t1.OptionsIDs, t1.ParameterValues, t1.Standard, t1.ProductNum, t1.ProductNumUpdate, t1.PurchaseNum, t1.PurchaseType, t1.ProblemType, t1.ProductPrice, t1.ShippingPrice, t1.BuyPrice, t1.ActivityID, t1.ActivityName, t1.ActivityMinusPrice, t1.ClientSKU, t1.OrderItemId, t1.ASIN, t1.SellerSKU, t1.ItemTitle, t1.ItemTitleCn, t1.ItemMemo, t1.MemberID, t1.CookieValue, t1.IP, t1.AddTime, t1.GroupSKU, t1.GroupProductNum, t1.GroupProductPrice, t1.P_Code_Build, t1.P_Code_Time, t1.OldOrderListID, t1.LockNum, t1.LockTime, t1.SharePrice, t1.ItemListingType, t1.CommentType, t1.CheckAdminID, t1.CheckAdminName, t1.AssignDevelopAdminID, t1.AssignDevelopAdminName, t1.BuyerID, t1.BuyerName, t1.EditAdminID, t1.EditAdminName, t1.ImageAdminID, t1.ImageAdminName, t1.BusinessAdminID, t1.BusinessAdminName, t1.SellerType, t1.IsFBA, t1.ItemSite, t1.RefundPrincipalAmount, t1.RefundShippingAmount, t1.PromotionDiscount, t1.PromotionId, t1.AmazonDeliveryStatus, t1.AmazonCompeteRemark, t1.BusinessTeamID, t1.BusinessTeamName, t1.DevelopAdminID, t1.DevelopAdminName, t1.Marks, t1.GroupShippingPrice, t1.GroupProductNumUpdate, t1.LockGroupProductNum, t1.IsBiSycnComplete, t1.BiSycnCompleteTime, CASE WHEN t1.UpdateTime IS NULL THEN t1.AddTime ELSE t1.UpdateTime END "UpdateTime", t1.ExtendedInfo FROM dbo.RB_OrderList(NOLOCK) t1 inner join dbo.RB_OrderInfo(NOLOCK) t2 on t1.CustomerID = t2.CustomerID and t1.OrderCode = t2.OrderCode WHERE t2.IsStockOrder = 0 and t2.IsPay = 1 and (t1.UpdateTime &gt;='2020-12-31 23:59:59' or t1.AddTime &gt;='2020-12-31 23:59:59')<br /><br /></p>
    002+ <p>select t1.ID, t1.CustomerID, t1.OrderCode, t1.P_S_Code, t1.ProductType, t1.SKU, t1.ParameterIDs, t1.OptionsIDs, t1.ParameterValues, t1.Standard, t1.ProductNum, t1.ProductNumUpdate, t1.PurchaseNum, t1.PurchaseType, t1.ProblemType, t1.ProductPrice, t1.ShippingPrice, t1.BuyPrice, t1.ActivityID, t1.ActivityName, t1.ActivityMinusPrice, t1.ClientSKU, t1.OrderItemId, t1.ASIN, t1.SellerSKU, t1.ItemTitle, t1.ItemTitleCn, t1.ItemMemo, t1.MemberID, t1.CookieValue, t1.IP, t1.AddTime, t1.GroupSKU, t1.GroupProductNum, t1.GroupProductPrice, t1.P_Code_Build, t1.P_Code_Time, t1.OldOrderListID, t1.LockNum, t1.LockTime, t1.SharePrice, t1.ItemListingType, t1.CommentType, t1.CheckAdminID, t1.CheckAdminName, t1.AssignDevelopAdminID, t1.AssignDevelopAdminName, t1.BuyerID, t1.BuyerName, t1.EditAdminID, t1.EditAdminName, t1.ImageAdminID, t1.ImageAdminName, t1.BusinessAdminID, t1.BusinessAdminName, t1.SellerType, t1.IsFBA, t1.ItemSite, t1.RefundPrincipalAmount, t1.RefundShippingAmount, t1.PromotionDiscount, t1.PromotionId, t1.AmazonDeliveryStatus, t1.AmazonCompeteRemark, t1.BusinessTeamID, t1.BusinessTeamName, t1.DevelopAdminID, t1.DevelopAdminName, t1.Marks, t1.GroupShippingPrice, t1.GroupProductNumUpdate, t1.LockGroupProductNum, t1.IsBiSycnComplete, t1.BiSycnCompleteTime, CASE WHEN t1.UpdateTime IS NULL THEN t1.AddTime ELSE t1.UpdateTime END "UpdateTime", t1.ExtendedInfo FROM dbo.RB_OrderList(NOLOCK) t1 inner join dbo.RB_OrderInfo(NOLOCK) t2 on t1.CustomerID = t2.CustomerID and t1.OrderCode = t2.OrderCode WHERE t2.IsStockOrder = 0 and t2.IsPay = 1 and (t1.UpdateTime &gt;='2020-12-31 23:59:59' or t1.AddTime &gt;='2020-12-31 23:59:59')</p>
  6. 2022-08-22 14:29:51, 由 王谦 解决，方案为 性能问题 。
    修改了 解决方案，旧值为 ""，新值为 "performance"。
    修改了 解决版本，旧值为 ""，新值为 "569"。
    修改了 解决日期，旧值为 ""，新值为 "2022-08-22 14:28:36"。
    修改了 指派给 ，旧值为 "wangqian"，新值为 "yuanhuibin"。
    修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
    修改了 是否确认，旧值为 "0"，新值为 "1"。
    修改了 解决者 ，旧值为 ""，新值为 "wangqian"。
    全量数据执行时间27分钟，仅需要执行一次，后续不再执行。目前暂不优化
  7. 2022-08-22 14:30:09, 由 王谦 指派给 袁慧斌。
  8. 2022-08-22 14:35:36, 由 袁慧斌 关闭。
    修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
    修改了 指派给 ，旧值为 "yuanhuibin"，新值为 "closed"。
    修改了 由谁关闭，旧值为 ""，新值为 "yuanhuibin"。
    修改了 关闭日期，旧值为 ""，新值为 "2022-08-22 14:35:36"。
    已删除SQL，不在运行。
  9. 2023-11-17 09:53:56, 由 刘超 编辑。
    修改了 所属模块，旧值为 "1712"，新值为 "1863"。
所属项目 技术中心-需求池
所属模块 系统运维   性能优化
所属计划
所属迭代
Bug类型
严重程度 提示
优先级 P0
Bug状态 已关闭
业务部门
影响功能
开发责任人
测试责任人
解决时效 0
激活次数 0
激活日期
是否确认 是
当前指派 Closed 于 2022-08-22 14:35:36
截止日期 0000-00-00
上线时间
上线时效
操作系统
浏览器
关键词
抄送给
所属迭代
相关需求
相关任务
由谁创建 袁慧斌 于 2022-08-08 11:06:42
影响环境 577
由谁解决 王谦 于 2022-08-22 14:28:36
解决版本 569
解决方案 性能问题
由谁关闭 袁慧斌 于 2022-08-22 14:35:36
最后修改 刘超 于 2023-11-17 09:53:48
相关Bug