[步骤]

[09:19:21]  -------------------------------------------------------------
CODE:N091921120
Error:11_-2_0_-2146232060
SQL: SELECT alias.[ID],alias.[CustomerID],alias.[OrderCode],alias.[P_S_Code],alias.[ProductType],alias.[SKU],alias.[ParameterIDs],alias.[OptionsIDs],alias.[ParameterValues],alias.[Standard],alias.[ProductNum],alias.[ProductNumUpdate],alias.[PurchaseNum],alias.[PurchaseType],alias.[ProblemType],alias.[ProductPrice],alias.[ShippingPrice],alias.[BuyPrice],alias.[ActivityID],alias.[ActivityName],alias.[ActivityMinusPrice],alias.[ClientSKU],alias.[OrderItemId],alias.[ASIN],alias.[SellerSKU],alias.[ItemTitle],alias.[ItemTitleCn],alias.[ItemMemo],alias.[MemberID],alias.[CookieValue],alias.[IP],alias.[AddTime],alias.[GroupSKU],alias.[GroupProductNum],alias.[GroupProductPrice],alias.[P_Code_Build],alias.[P_Code_Time],alias.[OldOrderListID],alias.[LockNum],alias.[LockTime],alias.[SharePrice],alias.[ItemListingType],alias.[CommentType],alias.[CheckAdminID],alias.[CheckAdminName],alias.[AssignDevelopAdminID],alias.[AssignDevelopAdminName],alias.[BuyerID],alias.[BuyerName],alias.[EditAdminID],alias.[EditAdminName],alias.[ImageAdminID],alias.[ImageAdminName],alias.[BusinessAdminID],alias.[BusinessAdminName],alias.[SellerType],alias.[IsFBA],alias.[ItemSite],alias.[PromotionDiscount],alias.[PromotionId],alias.[BusinessTeamID],alias.[BusinessTeamName],alias.[AmazonDeliveryStatus],alias.[AmazonCompeteRemark],alias.[DevelopAdminID],alias.[DevelopAdminName],alias.[Marks],alias.[GroupShippingPrice],alias.[GroupProductNumUpdate],alias.[LockGroupProductNum],alias.[IsBiSycnComplete],alias.[BiSycnCompleteTime],alias.[UpdateTime],alias.[ExtendedInfo],alias.[ProductSkuId],alias.[SkuId],isnull(alias.IsAddLog,0) IsAddLog,oi.OrderSourceID FROM dbo.RB_OrderInfo (NOLOCK) oi 
   LEFT JOIN dbo.RB_OrderList (NOLOCK) alias ON alias.CustomerID = oi.CustomerID AND alias.OrderCode = oi.OrderCode
   LEFT JOIN dbo.RB_OrderSource(NOLOCK) os ON os.CustomerID = oi.CustomerID AND oi.OrderSourceID = os.ID
   WHERE oi.addtime > DATEADD(day, -30, GETDATE()) and oi.CustomerID =@CustomerID AND os.OrderSourceType IN (125) AND alias.ProductPrice<=0 AND oi.IsStockOrder =0
PARAMS:@CustomerID = 1 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DALExtendV3.RB_OrderListExtendV3.GetOrderListByOrderSourceType(Int32 customerId, Int32 orderSourceType)
   在 Biz.Temu.TemuOrderService.SynOrderCost()
   在 ChinaDownLoadImage.Task.Order.Temu.Task_Temu_OrderCost.Execute()
   在 RB.Utility.SystemTask.<doTask>b__43_0()
   在 System.Threading.Tasks.Task.Execute()
   在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
   在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
   在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
   在 System.Threading.ThreadPoolWorkQueue.Dispatch()

-------------------------------------------------------------

[结果]

[期望]

加入或者整改SQL 使其性能提升 不报错