[步骤]
SELECT pro.CustomerID,
pro.SKU,
pro.SKU SystemSKU,
pro.ProductName,
pro.ProductNameCN,
Isnull(pro.PackWeight, 0) PackWeight,
Isnull(pro.GrossWeight, 0) GrossWeight,
Isnull(pro.Length, 0) Length,
Isnull(pro.Width, 0) Width,
Isnull(pro.Height, 0) Height,
Isnull(pro.Pack_Length, 0) PackLength,
Isnull(pro.Pack_Width, 0) PackWidth,
Isnull(pro.Pack_Height, 0) PackHeight,
Isnull(pro.WithBattery, 0) WithBattery,
Isnull(pd.DeclarationPriceRate, 0) DeclarationPrice,
pd.DeclarationName,
pd.DeclarationNameCN,
pd.DeclarationCode,
pro.ProductSpec,
pb.BrandName,
pro.ClientSKU,
ProductColor,
pro.ImageUrl,
pc.ClassNameCn as ClassNameCn1,
pc1.ClassNameCn as ClassNameCn2,
pc2.ClassNameCn as ClassNameCn3,
IsNull(pro.IsGroup,0) AS IsGroup,
ISNULL(pb.BrandType,0) as BrandType
FROM RB_Product pro WITH(NOLOCK)
LEFT JOIN RB_Product_Declaration pd WITH(NOLOCK)
ON pro.CustomerID = pd.CustomerID
AND pro.SKU = pd.SKU
LEFT JOIN RB_Product_Brand pb WITH(NOLOCK)
ON pb.CustomerID=pro.CustomerID
AND pb.ID=pro.BrandID
LEFT JOIN RB_Product_Class pc WITH(NOLOCK)
ON pc.CustomerID=pro.CustomerID
AND pc.ID=pro.ClassID
LEFT JOIN RB_Product_Class pc1 WITH(NOLOCK)
ON pc1.CustomerID=pro.CustomerID
AND pc1.ID=pro.ClassID1
LEFT JOIN RB_Product_Class pc2 WITH(NOLOCK)
ON pc2.CustomerID=pro.CustomerID
AND pc2.ID=pro.ClassID2
WHERE pro.CustomerID = 1
AND pro.SKU IN( '3578441','18815221'
ORDER BY pro.ID DESC
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.DALExtend.RB_ProductExtend.GetProductListToOverseasBySKU(Int32 customerID, List`1 skus)
在 Biz.Irobotbox.ReStock.RemovalOrderService.SynRemovalOrderProductToWMS(List`1 paramList, Int32 adminId, String userName)
在 Biz.Irobotbox.ReStock.RemovalOrderService.SynBaseDataToWMS(String removalCode)
在 ChinaDownLoadImage.Task.Task_RemovalOrder_SynBaseDataToWMS.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()
[结果]
[期望]
分批次查询 减少SKU 的数量