[步骤]
SQL:select LabelID,SKU from RB_Product_Label(nolock) where CustomerID=@CustomerID and SKU in(SELECT item FROM Charsplitforin(@SKUs, ',')) AND IsDeleted=0 PARAMS:@CustomerID = 1 ,@SKUs = 17581081,17577939,17574320,17569888,17568059,17568023,17566426,17562872,17560792,17560703,17558541,17554843,17554371,17553527,17553502,17552930,17552855,17549050,17547620,17546948,17546915,17546774,17546667,17545592,17542074,17540971,17540892,17540414,17539577,17539280,17539237,17538567,17538511,17538249,17538150,17535716,17535703,17535685,17535645,17535593,17535091,17535084,17535071,17534903,17534915,17534101,17533992,17533522,17533254,17533211,17532975,17532676,17532621,17532365,17531637,17528000,17527869,17527818,17526306,17525799,17525606,17522987,17522369,17520684,17519675,17518785,17518723,17518706,17518669,17518600,17518544,17517789,17517408,17517393,17517389,17516313,17516239,17514650,17514526,17514522,17514503,17514410,17514189,17513790,17513684,17513441,17512113,17512088,17511955,17512030,17512024,17512016,17511972,17511891,17511229,17511147,17511104,17510593,17508565,17507633,17506061,17506016,17505908,17503114,17502641,17501604,17501576,17501472,17501390,17501376,17501361,17501321,17501210,17501169,17501164,17501089,17500628,17500644,17500635,17500625,17500618,17500102,17500002,17499855,17499814,17499519,17499429,17499398,17499338,17499309,17498993,17496872,17496697,17496557,17495258,17494856,17494202,17491449,17491361,17491281,17491256,17491240,17489195,17488501,17487193,17486855,17485371,17484170,17483973,17483537,17482700,17482659,17482515,17482436,17482327,17482151,17481866,17481855,17479411,17478936,17475233,17475158,17475032,17474184,17472532,17472196,17471729,17471589,17471537,17471218,17471469,17471117,17470624,17470122,17470113,17470048,17464995,17464924,17464147,17462677,17461412,17461388,17459880,17458852,17457416,17457363,17457311,17457262,17457215,17457185,17457136,17457068,17455154,17452031,17451857,17451831,17451776,17451007,17450976,17450714,17450638,17450627,17450609,17450310,17450033,17450020,17449999,17449977,17449831,17449718,17444785,17444576,17444493,17444391,17444274,17443353,17443231,17443131,17443152,17442993,17442811,17440517,17440108,17439759,17437915,17437904,17437842,17437781,17437801,17437779,17437735,17437185,17437152,17437123,17437107,17436961,17436149,17435181,17435053,17434864,17434648,17434543,17430119,17430113,17430091,17429469,17428567,17427359,17427350,17427280,17426324,17424603,17424588,17422399,17422085,17421425,17420720,17420710,17420603,17418417,17415001,17414373,17414191,17412957,17410936,17410828,17408630,17408589,17408394,17407884,17407489,17407180,17407121,17407114,17407068,17406947,17406616,17405903,17400592,17400576,17400548,17399857,17399461,17399319,17399257,17398819,17398799,17398395,17397918,17395900,17392133,17392123,17392042,17392094,17392077,17392058,17392046,17392028,17391872,17391987,17391846,17391814,17391531,17391277,17391103,17391066,17390345,17388943,17388891,17387092,17384264,17383082,17383104,17382538,17382459,17382059,17380238,17380076,17377937,17377094,17376984,17376639,17375838,17375498,17375258,17375190,17374804,17374594,17374519,17374170,17374131,17374002,17373802,17373710,17373604,17373102,17373074,17369732,17369725,17369711,17369691,17369595,17369287,17369214,17368947,17368900,17368129,17368018,17364586,17362788,17362413,17362403,17362116,17361497,17361445,17361438,17361378,17361318,17361203,17359719,17355068,17354823,17352929,17352928,17352602,17352590,17352578,17352519,17352425,17347707,17346530,17345886,17345824,17345721,17345558,17345486,17345433,17343651,17340855,17336248,17334653,17334642,17329029,17325381,17315150,17314152,17313680,17313488,17312913,17307625,17307112,17307015,17307000,17306999,17306900,17305790,17305446,17304986,17304801,17300101,17298773,17295921,17294130,17293256,17293164,17291006,17285194,17285126,17277508,17272124,17269639,17260390,17260274,17258014,17256372,17254716,17254098,17253631,17252545,17251988,17251987,17251885,17248648,17248463,17248418,17246498,17246024,17246009,17238807,17238777,17238453,17238417,17236090,17235642,17235614,17235498,17225660,17225360,17223609,17223409,17221017,17218237,17213518,17213104,17210957,17209342,17208266,17208164,17199589,17198396,17195962,17195869,17182428,17179622,17179484,17178786,17178741,17171415,17167016,17166365,17161547,17155273,17152888,17152746,17150323,17150305,17144374,17144373,17144340,17143388,17143191,17138128,17132504,17132491,17132485,17132479,17112088,17110120,17093594,17089503,17089072,17088957,17084318,17083962,17079842,17079825,17079766,17070496,17031961,17010093,16965017,16947408,16947307,16936527,16931465,16930030,16897563,16897562,16897561,16897560 , MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。 TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.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,
历史记录
- 2023-10-08 17:40:53, 由 袁慧斌 创建。
-
2023-10-08 17:43:24, 由 李乐同 指派给 何建宝。
修改了 指派给，旧值为 "liletong"，新值为 "hejianbao"。
-
2023-10-09 17:11:22, 由 何建宝 解决，方案为 性能问题 。
修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2023-10-09 10:07:55"。
修改了 指派给 ，旧值为 "hejianbao"，新值为 "zengxiaolong"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "hejianbao"。
-
2023-10-10 10:37:21, 由 曾小龙 关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "zengxiaolong"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "zengxiaolong"。
修改了 关闭日期，旧值为 ""，新值为 "2023-10-10 10:37:21"。
功能没问题，正常筛选
-
2023-11-17 09:25:46, 由 刘超 编辑。
修改了 所属模块，旧值为 "1810"，新值为 "1852"。
-
2023-11-17 09:53:51, 由 刘超 编辑。
修改了 所属模块，旧值为 "1852"，新值为 "1863"。
节假日标签过滤SKU数量比较多的情况分批进行过滤，确保不出现超时，验证下功能正常即可