[性能问题描述]转FBA备货情况V2 导出缓慢
抓取到缓慢的地方为
SELECT base.ID,base.CustomerID,base.OrderSourceSKUID,base.ASINorItemID,base.OrderSourceSKU,base.SKU,base.OrderSourceCountry, lc.WaitTransferFbaTime INTO #SearchBaseID FROM RB_Amazon_Product_Base base(NOLOCK) LEFT JOIN RB_Amazon_Product_Base_Local lc(NOLOCK) ON base.ID=lc.ProductBaseID WHERE base.CustomerID=@CustomerID AND base.OrderSourceID IN(SELECT CONVERT(INT,item) FROM dbo.CharSplitForIn(@OrderSourceID,',')) AND base.WaitToFbaType IN(SELECT CONVERT(INT,item) FROM dbo.CharSplitForIn(@WaitToFbaType,',')) AND base.IsDelete=0 AND base.OrderSourceSKUID>0 AND base.IsFBA=0 AND lc.WaitTransferFbaTime>=@Start_WaitTime AND lc.WaitTransferFbaTime<@End_WaitTime AND lc.WaitTransferFbaTime IS NOT NU
{"@Start_WaitTime":"2023-07-01","@End_WaitTime":"2023-07-31 23:59:59","@WaitToFbaType":"1,2,3","@OrderSourceID":"0,8541,9747,8992,8601,9947,8567,8568,8573,8595,9970,8689,8641,8569,8570,8574,8572,8548,8602,8544,8598,8515,8525,8599,8597,8524,8642,9978,8543,8540,9971,9976,12530,9946,8566,9977,12566,8517,9980,13431,9969,9979,17687,11991,12105,14672,12269,12266,12262,12334,12271,12267,12341,12611,13798,13440,12249,12201,13494,12450,12610,13448,13159,14694,12573,14644,13444,16139,13446,14698,15678,16969,16374,15897,15904,17159,16966,15892,17253,15894,16353,16116,15898,15900,15902,16281,15582,16110,16128,15839,16112,16114,15702,15554,16086,15950,15874,16173,15525,15355,15790,16254,15983,15373,15416,15322,15491,15339,15597,15675,15641,15769,16190,15965,16044,16002,15987,16158,16229,16058,15806,5782,5809,5781,6260,5783,5944,6757,5813,5780,6137,7892,6433,6507,7893,7894,18529,19688,20202,19851,20316,19913,7890,20153,19786,20296,7891,10416,10414,7896,10415,14086,13275,9562,17134,10745,11682,11695,11867,11880,11893,11853,11840,11827,11800,11813,11975,11963,13424,13560,13559,13426,12362,12440,12397,12410,12436,12469,12475,12488,12683,12698,12778,12740,12917,12768,12801,12734,12815,12639,12675,13038,13187,13116,13083,13105,13147,13411,13605,17779,15069,13799,20169,13609,15250,13853,14290,14295,13848,13876,13811,13816,13821,13838,13871,13843,14340,14314,14371,14366,14309,14997,14470,15042,14353,14327,14967,15017,15030,14571,15013,15073,14728,14716,14538,14899,14545,14579,15068,14533,14559,15091,14977,14583,14914,14526,14507,14847,14823,14931,14835,14502,14935,14803,14479,14483,14487,14474,14926,14512,14742,14497,14720,14973,14765,14724,14678,14859,15003,14807,14879,14819,14682,15085,15580,15137,15504,15213,15837,15181,16764,15193,15700,15552,16085,15949,15262,15658,16392,15523,15353,15788,16252,15982,15371,15414,15323,15489,15337,15595,15673,15639,16373,15767,16192,15964,16177,16042,16012,16294,15997,16160,16227,16057,15804,18372,16722,16653,16503,16587,16695,16749,16841,17907,18266,20245,18080,18574,18185,18558,18238,18588,18543,19249,20167,19464,17204,17181,17482,17274,17509,17470,17594,17189,17327,17384,17291,17296,16119,17496,17325,17254,17297,17312,17191,17180,18528,19684,20200,19847,20314,19911,17479,20149,19784,20292,17326,17483,17192,17478,17364,17530,17262,17593,17497,17304,17329,17316,17255,17477,17351,17476,17387,17527,17460,17598,17310,17190,17522,17484,17323,17471,17349,17256,17512,17601,17188,17388,17485,17275,17257,17486,17508,17607,17491,17513,17284,17276,17635,17592,17626,17480,17205,17889,17333,17303,17599,17461,17357,17634,17359,17186,17268,17271,17494,17315,17514,17597,17365,17305,17469,17285,17302,17463,17320,17298,17526,17277,17179,17403,17492,17317,17193,17270,17640,17602,17332,17396,17397,17633,17319,17507,17311,17606,17481,17266,17381,17251,17281,17330,17206,17490,17627,17265,17301,17472,17398,17178,17563,17318,17464,17361,17278,17603,17389,17385,17321,17404,17366,17608,17390,17473,17352,17358,17362,17260,17391,17267,17264,17290,17322,17353,17596,17313,17920,17405,17399,17511,17287,17307,17400,17182,17331,17363,17282,17521,17360,17590,17525,17604,17306,17704,17295,17269,17300,17638,17289,17395,17488,17279,17589,17493,17350,17176,17283,17324,17383,17430,17605,17280,17177,17292,17489,16118,17272,17393,17636,17392,17355,17591,17487,17328,17203,17354,17609,17562,17919,17465,17263,17273,17474,17394,17207,17498,17258,17309,17261,17475,17294,17637,17918,17510,17299,17631,17259,17917,17356,17884,17308,17879,17524,17916,17883,17466,17560,17882,17630,17915,17382,17914,17523,17288,17913,17610,17595,17685,17796,17881,17912,17639,17735,17911,17910,17880,17632,18368,16718,17909,17559,16582,16684,16750,16837,17903,18262,20243,18076,18573,18184,18554,18237,18584,18539,19245,20163,19462,9618,10861,10862,9887,9620,9619,9617,9649,9652,10884,19942,9655,9667,9646,9647,9650,9641,10851,10852,9640,9644,9643,10875,10889,10864,10863,10853,10886,9889,9882,10869,9886,10870,10894,11363,10885,9653,9881,9645,10845,9651,9648,9654,18519,19941,19902,9883,19810,12047,12071,12072,11404,10890,10854,10887,9884,10895,9890,14565,9885,11364,11403,10892,10881,10849,13229,10846,10891,10867,10878,11388,11393,10844,10888,11389,10896,10865,9888,10893,10868,10866,11624,10847,11584,10879,10873,10897,11710,16425,12240,11583,11705,11625,11713,10898,9891,13219,15144,11365,11405,13218,10880,13217,12048,14518,17778,10882,14447,14522,11513,14560,14561,13228,14562,14564,11512,11703,11387,11578,10848,13225,10872,11406,11394,13618,10876,10899,13515,14645,10856,10901,11407,11390,12588,10850,10900,10858,10859,10902,11582,17921,11395,13614,11511,10857,11702,12124,10883,12073,17133,13215,10877,12216,11572,14448,12021,13226,11391,11553,14563,13615,12125,13271,12268,13216,17777,13619,13214,12155,13221,12123,12075,13272,13887,13227,14550,13514,17755,14552,13513,15145,14449,14520,14553,13395,13220,17890,13511,13398,13396,13394,13613,13612,13512,17754,13224,13223,13516,13616,13617,13222,13878,17751,14519,17750,15680,15177,14895,16417,15302,17545,15383,16424,15565,15808,15645,14551,14750,14555,14554,15566,17753,16064,16419,16473,15143,15285,15286,15465,15825,15435,15141,15816,15402,15564,15455,15814,16062,15809,16414,16476,15167,15559,16477,16420,15433,15810,14894,15817,15567,16474,16416,16421,15457,16063,15824,15818,15821,14908,15492,15142,16418,15009,16415,15815,15359,16475,15458,16068,15301,16067,16422,15140,15563,15822,15303,16423,16069,15555,16070,15753,15812,15456,16065,15556,16102,16204,16755,15562,15811,15551,16459,16464,15646,15937,17684,16478,15603,16098,16504,16463,15599,15886,15600,16061,15602,16351,16393,16104,17550,16375,16472,16460,16471,16458,16461,16508,16462,16470,16507,16456,16465,17548,16751,17752,17546,17547,16767,19919,19224,18564,18175,18228,19772,19576,20003,5093,6925,5522,6782,6406,5094,5642,7357,5132,5326,5091,10467,6555,5095,6776,5051,12205,5367,5520,6655,5514,5946,5384,5327,5325,5368,5516,5504,5641,5533,5537,5544,5553,5574,5582,5604,5632,5668,5702,5741,5739,5764,5766,5949,5935,6076,6024,6031,6033,6047,6083,6090,6104,6102,6111,6139,6147,6154,18517,19686,20190,19849,20304,19900,6400,20151,19774,20294,6511,6449,6451,6625,8260,6890,6609,6611,6623,6892,6670,6943,6702,6443,6755,6936,6837,6867,6883,6928,7934,6954,6900,7516,6907,6922,7198,7388,7390,7527,8258,7733,7740,7704,7716,7760,7750,7905,7922,7936,7949,7997,8011,8078,8857,8071,8147,8093,8858,8149,8244,8251,8477,8523,8339,8346,8377,8519,8553,13518,8560,8693,13623,8696,9571,12127,11637,13600,13573,9009,10138,12107,9263,12260,12264,12058,12118,13528,9901,9034,10813,9129,9407,9543,9266,9767,9769,9771,9773,10252,12258,9777,10250,9807,10008,10006,9950,10042,10375,10254,9849,9857,9866,10024,10032,10034,10040,12090,10054,10056,10058,10060,10199,10276,13331,10314,10316,10318,10320,13594,13470,9928,10758,10737,10748,11301,13562,11680,11693,11865,11878,11898,12016,11891,11852,11839,11826,11797,11810,11976,11960,13466,12192,13568,13429,13200,13336,13406,13540,13525,13342,13339,12360,12438,12395,12408,12425,12458,12473,12486,12681,12696,12738,12915,12766,12799,12732,12813,12628,12664,13036,13114,13081,13103,13145,13409,13627,13603,13579,13582,13597,13576,13565,13585,13923,13588,15248,13850,14287,14292,13845,13874,13808,13813,13818,13835,13869,13840,14337,14311,14368,14363,14306,14995,14469,15040,14350,14324,14965,15015,15028,14570,15011,15072,14726,14714,14537,14898,14543,14577,15066,14532,14557,15090,14976,14581,14912,14524,14505,14846,14822,14930,14834,14500,14934,14801,14477,14481,14485,14473,14924,14510,14740,14496,14718,14972,14763,14722,14677,14858,15001,14805,14878,14817,14681,15083,15578,15135,15502,15211,15835,15180,16753,15192,15698,15549,16083,15947,15261,15656,16390,15521,15351,15786,16250,15980,15369,15412,15318,15487,15335,15593,15671,15637,16371,15765,16202,15962,16187,16040,16014,16292,15999,16170,16225,16055,15802,18370,16720,16643,16501,16585,16693,16739,16839,17905,18264,20233,18078,18562,18173,18556,18226,18586,18541,19247,20165,19452,5200,5305,5252,5400,5405,5482,5606,5626,5712,5748,5743,5774,5768,5952,6026,6070,6035,6040,6060,6049,6065,6085,6092,6097,6106,6113,6141,6149,6156,6437,18521,19677,20193,19840,20307,19904,6550,20142,19777,20285,6513,6571,6592,6597,6613,6618,6642,6657,6697,6688,6938,7977,6806,6869,6885,6930,7929,6949,6901,7518,6909,6916,7157,7162,7167,7359,7366,7376,7511,7383,7735,7711,7706,7718,7752,7900,7924,7943,7999,8013,8073,8472,8066,8095,8246,8253,8348,8379,8447,8036,8485,8491,8493,8468,8494,8495,8496,8498,8499,8501,8956,8555,9270,8562,8622,8637,13915,9004,9011,13241,13533,9626,9216,9021,9028,9211,9199,9077,9087,9097,9107,9147,9162,9167,9172,9124,9223,9258,9285,9290,9295,9300,9157,9361,9432,9437,9447,9452,9457,9467,9504,9509,9523,9529,9545,9550,9564,9817,9823,9835,9851,9859,9868,10026,10046,13298,9952,9957,10052,10294,10322,10327,10379,10739,10750,11024,11215,11246,11251,11256,11261,11376,11430,11437,11504,11610,11602,11672,11685,11721,11869,11882,11843,11830,11817,11789,11802,11972,11952,13291,13476,13496,12132,12138,14435,15119,12367,12445,12386,12399,12429,12493,12688,12703,12783,12922,12757,12790,12723,12804,12632,12668,13192,13121,13088,13094,13152,13416,13649,13769,13665,13657,13779,15240,13907,14279,14403,15437,13889,13859,14070,13899,15866,15620,14329,14412,15682,14355,14427,14987,16234,15032,14342,14316,14957,15045,15705,14684,15053,15075,14945,15148,14901,14665,15216,15224,14595,14657,15093,14979,14629,15252,16211,14585,14849,14825,15109,14837,14611,15019,15169,14637,15924,15916,14916,14603,14732,15908,14937,15431,14755,14767,14869,14861,15274,15713,14881,14809,16091,15746,15570,15127,15494,15203,15827,15183,16757,15195,15690,15541,16075,15939,15264,15648,16382,15513,15343,15778,16242,15972,15361,15404,15310,15479,15327,15585,15663,15629,16363,15757,16199,15954,16184,16032,16010,16284,15995,16167,16217,16047,15794,18361,16711,16646,16493,16576,16685,16742,16830,17896,18255,20236,18069,18566,18177,18547,18230,18577,18532,19238,20156,19455,5167,5178,5203,5345,5308,5402,5407,5484,5586,5608,5628,5636,5714,5706,5750,5745,5776,5770,5954,6028,6072,6037,6042,6062,6051,6067,6087,6094,6099,6108,6115,6143,6151,6158,6439,18527,19680,20196,19843,20310,19907,6552,20145,19780,20288,6515,6573,6594,6599,6615,6620,6644,6659,6674,6699,6690,6940,7979,6808,6871,6887,6932,7931,6951,6903,7520,6911,6918,7159,7164,7169,7361,7368,7378,7513,7385,7737,7713,7708,7720,7754,7902,7926,7945,8001,8015,8075,8068,8097,8248,8255,8350,8381,8449,8038,8058,8129,8458,8462,8958,8557,9272,8564,8624,8639,13918,9006,9013,13240,13536,9628,9218,9023,9030,9038,9079,9089,9099,9109,9149,9164,9169,9174,9126,9225,9260,9287,9292,9297,9302,9159,9363,9434,9439,9449,9454,9459,9469,9506,9511,9525,9531,9547,9566,9819,9825,9837,9853,9861,9870,10028,10048,13297,9954,9959,10077,10295,10323,10328,10381,10741,10752,11027,11216,11249,11254,11259,11264,11379,11433,11440,11507,11613,11605,11675,11688,11724,11872,11885,11846,11833,11820,11792,11805,11971,11955,13294,13479,13499,12134,12140,14438,15122,12365,12443,12389,12402,12432,12491,12686,12701,12781,12920,12760,12793,12726,12807,12635,12671,13190,13086,13097,13150,13414,13652,13772,13668,13660,13782,15243,13910,14282,14406,15440,13892,13862,14073,13902,15869,15623,14332,14415,15685,14358,14430,14990,16237,15035,14345,14319,14960,15048,15708,14687,15056,15078,14948,15151,14904,14668,15219,15227,14598,14660,15096,14982,14632,15255,16208,14588,14852,14828,15112,14840,14614,15022,15172,14640,15927,15919,14919,14606,14735,15911,14940,15426,14758,14770,14872,14864,15277,15716,14884,14812,16094,15749,15573,15130,15497,15206,15830,15186,16760,15198,15693,15544,16078,15942,15267,15651,16385,15516,15346,15781,16245,15975,15364,15407,15313,15482,15330,15588,15666,15632,16366,15760,16196,15957,16181,16035,16007,16287,15992,16164,16220,16050,15797,18364,16714,16652,16496,16579,16688,16745,16833,17899,18258,20239,18072,18572,18183,18550,18236,18580,18535,19241,20159,19458,5165,5176,5201,5306,5253,5401,5406,5483,5585,5607,5627,5635,5713,5705,5749,5744,5775,5769,5953,6027,6071,6036,6041,6061,6050,6066,6086,6093,6098,6107,6114,6142,6150,6157,6438,18522,19679,20194,19842,20308,19905,6551,20144,19778,20287,6514,6572,6593,6598,6614,6619,6643,6658,6673,6698,6689,6939,7978,6807,6870,6886,6931,7930,6950,6902,7519,6910,6917,7158,7163,7168,7360,7367,7377,7512,7384,7736,7712,7707,7719,7753,7901,7925,7944,8000,8014,8074,8067,8096,8247,8254,8349,8380,8448,8037,8057,8116,8124,8128,8456,8461,8957,8556,9271,8563,8623,8638,13917,9005,9012,13243,13535,9627,9217,9022,9029,9037,9078,9088,9098,9108,9148,9163,9168,9173,9125,9224,9259,9286,9291,9296,9301,9158,9362,9433,9438,9448,9453,9458,9468,9505,9510,9524,9530,9546,9551,9565,9818,9824,9836,9852,9860,9869,10027,10047,13301,9953,9958,10076,10296,10324,10329,10380,10740,10751,11026,11217,11248,11253,11258,11263,11378,11432,11506,11612,11604,11674,11687,11723,11871,11884,11845,11832,11819,11791,11804,11969,11954,13293,13478,13498,12133,12139,14437,15121,12371,12449,12388,12401,12431,12497,12692,12707,12787,12926,12759,12792,12725,12806,12634,12670,13196,13092,13096,13156,13420,13651,13771,13667,13659,13781,15242,13909,14281,14405,15439,13891,13861,14072,13901,15868,15622,14331,14414,15684,14357,14429,14989,16236,15034,14344,14318,14959,15047,15707,14686,15055,15077,14947,15150,14903,14667,15218,15226,14597,14659,15095,14981,14631,15254,16210,14587,14851,14827,15111,14839,14613,15020,15171,14639,15926,15918,14918,14605,14734,15910,14939,15425,14757,14769,14871,14863,15276,15715,14883,14811,16093,15748,15572,15129,15496,15205,15829,15185,16759,15197,15692,15543,16077,15941,15266,15650,16384,15515,15345,15780,16244,15974,15363,15406,15312,15481,15329,15587,15665,15631,16365,15759,16198,15956,16183,16034,16009,16286,15994,16166,16219,16049,15796,18363,16713,16647,16495,16578,16687,16744,16832,17898,18257,20237,18071,18567,18178,18549,18231,18579,18534,19240,20158,19456,5199,5304,5399,5404,5481,5486,5605,5625,5633,5711,5747,5742,5773,5767,5951,6025,6069,6034,6039,6059,6048,6064,6084,6091,6096,6105,6112,6140,6148,6155,6436,18520,19676,20192,19839,20306,19903,6549,20141,19776,20284,6512,6570,6591,6596,6612,6617,6641,6656,6671,6696,6687,6937,7976,6805,6868,6884,6929,7928,6948,6895,7517,6908,6915,7156,7161,7166,7358,7365,7375,7510,7382,7734,7710,7705,7717,7751,7899,7923,7942,7998,8012,8072,8471,8065,8094,8245,8252,8347,8378,8446,8035,8056,8115,8123,8127,8455,8460,8955,8554,9269,8561,8621,8636,13914,9003,9010,13239,13532,9625,9215,9020,9027,9035,9055,9076,9086,9096,9106,9146,9161,9166,9171,9123,9222,9257,9284,9289,9294,9299,9156,9061,9431,9436,9446,9451,9456,9466,9503,9508,9522,9528,9544,9549,9563,9816,9822,9834,9850,9858,9867,10025,10045,13296,9951,9956,10051,10293,10321,10326,10378,10749,11023,11214,11245,11250,11255,11260,11375,11429,11436,11527,11503,11609,11601,11671,11684,11720,11868,11881,11842,11829,11816,11788,11801,11973,11951,13290,13475,13495,12130,12136,14434,15118,12364,12442,12385,12398,12428,12490,12685,12700,12780,12742,12919,12756,12789,12722,12803,12631,12667,13189,13118,13085,13093,13149,13413,13648,13768,13664,13656,13778,15239,13906,14278,14402,15436,13888,13858,14069,13898,15865,15619,14328,14411,15681,14354,14426,14986,16233,15031,14341,14315,14956,15044,15704,14683,15052,15074,14944,15147,14900,14664,15215,15223,14594,14656,15092,14978,14628,15251,16212,14584,14848,14824,15108,14836,14610,15018,15168,14636,15923,15915,14915,14602,14731,15907,14936,15430,14754,14766,14868,14860,15273,15712,14880,14808,16090,15745,15569,15126,15493,15202,15826,15182,16756,15194,15689,15540,16074,15938,15263,15647,16381,15512,15342,15777,16241,15971,15360,15403,15309,15478,15326,15584,15662,15628,16362,15756,16200,15968,16185,16031,16011,16283,15996,16168,16216,16046,15793,18360,16710,16645,16492,16575,16683,16741,16829,17895,18254,20235,18068,18565,18176,18546,18229,18576,18531,19237,20155,19454,7723,7724,7828,7286,7822,7837,7117,7119,7289,7290,12199,7700,7898,7287,7116,7175,7823,12202,12219,7293,7702,7698,12218,7725,7831,7824,7832,7839,7897,8363,7821,7726,8406,7830,6228,8362,7826,8365,8407,7835,7827,8364,7880,8400,8404,8409,7878,8157,8392,8374,8393,8394,8395,6926,6955,8390,8375,8396,8336,8403,8408,8401,12323,7440,8399,8402,12736,8140,8137,8353,8373,8422,12325,12313,9176,9205,9212,10277,12318,5166,5177,5202,5346,5307,5255,5403,5408,5485,5587,5609,5629,5637,5715,5707,5751,5746,5777,5771,5955,6029,6073,6038,6043,6063,6068,6088,6095,6100,6109,6116,6144,6152,6159,6440,18523,19678,20195,19841,20309,19906,6553,20143,19779,20286,6516,6574,6595,6600,6616,6621,6645,6660,6675,6700,6691,6941,7980,6809,6872,6888,6933,7932,6952,6904,7521,6912,6919,7160,7165,7170,7362,7369,7379,7514,7386,7738,7714,7709,7721,7755,7903,7927,7946,8002,8016,8076,8069,8098,8249,8256,8351,8382,8450,8039,8059,8118,8130,8457,8463,8959,8558,9273,8565,8625,8640,13916,9007,9014,13242,13534,9629,9219,9024,9031,9039,9080,9090,9100,9110,9150,9165,9170,9175,9127,9226,9261,9288,9293,9298,9303,9160,9364,9435,9440,9450,9455,9460,9470,9507,9512,9526,9532,9548,9553,9567,9820,9826,9838,9854,9862,9871,10029,10049,13299,9955,9961,10078,10325,10330,10382,10753,11025,11218,11247,11252,11257,11377,11431,11505,11611,11603,11673,11686,11722,11870,11883,11844,11831,11818,11790,11803,11966,11953,13292,13477,13497,12131,12137,14436,15120,12368,12446,12387,12400,12430,12494,12689,12704,12784,12923,12758,12791,12724,12805,12633,12669,13193,13089,13095,13153,13417,13650,13770,13666,13658,13780,15241,13908,14280,14404,15438,13890,13860,14071,13900,15867,15621,14330,14413,15683,14356,14428,14988,16235,15033,14343,14317,14958,15046,15706,14685,15054,15076,14946,15149,14902,14666,15217,15225,14596,14658,15094,14980,14630,15253,16206,14586,14850,14826,15110,14838,14612,15021,15170,14638,15925,15917,14917,14604,14733,15909,14938,15432,14756,14768,14870,14862,15275,15714,14882,14810,16092,15747,15571,15128,15495,15204,15828,15184,16758,15196,15691,15542,16076,15940,15265,15649,16383,15514,15344,15779,16243,15973,15362,15405,15311,15480,15328,15586,15664,15630,16364,15758,16194,15955,16179,16033,16008,16285,15993,16162,16218,16048,15795,18362,16712,16648,16494,16577,16686,16743,16831,17897,18256,20238,18070,18568,18179,18548,18232,18578,18533,19239,20157,19457,5109,5678,5117,5073,5098,5691,5556,5679,5730,6236,5647,5676,5657,5677,5645,5580,5674,5610,5639,5630,5685,5684,5716,5690,6237,6263,6238,6275,6264,6265,6266,6267,6381,6268,8366,18530,19689,20201,19852,20315,19912,6964,20154,19785,20297,6960,6963,8930,6961,10003,9785,9780,9787,8987,8859,8860,10002,8861,8862,8988,8989,8990,10004,9786,9781,9788,9789,14087,18093,18149,9032,9040,10814,9130,9782,10022,18094,18150,10746,10754,10948,18095,11988,11683,11696,11864,11877,11890,11854,11841,11828,11812,11974,11962,18133,18096,13425,18097,15776,18134,12363,12441,12396,12427,12460,12476,12684,12699,12779,12741,12918,12767,12800,12733,12814,12630,12666,13039,13188,13117,13084,13104,13148,13412,18098,13570,18099,18100,13800,18101,18102,18103,18145,13610,15026,18104,13852,14289,14294,13847,13877,13810,13815,13820,13837,13872,13842,14339,14313,14370,14365,14308,18105,18152,18106,14352,14326,18545,18153,14787,18135,18144,18107,14648,14539,18136,14546,14998,18108,14534,14567,18146,18163,14592,18109,14527,14508,15004,14999,18147,18143,14503,18137,18110,18111,18112,18113,14475,14513,14498,18114,15005,15775,15006,18115,15732,18132,18003,18116,15287,15008,18148,18117,16135,18118,18164,15288,18154,18033,17129,15289,16142,18119,17561,16136,18155,18120,18138,18121,18122,18131,18139,16140,18123,18140,18124,18156,17131,18125,18126,17132,15627,15568,18157,18158,18141,18127,18159,16131,16968,16141,17600,18142,16137,18160,18373,18161,17130,18128,18130,18162,18129,16842,17908,18267,20244,18081,18575,18186,18559,18239,18589,18544,19250,20168,19463,13304,6173,7995,6783,6407,7192,6557,7421,6499,6464,6563,6561,6486,7121,6775,7297,6556,6485,6484,8687,6479,9662,6487,13107,6562,6607,6558,6777,6756,6639,6923,8428,7298,6638,6652,10952,6554,10953,6637,19225,9121,6564,7295,9074,13926,9713,8549,7701,12085,17734,11016,18518,19687,20191,19850,20305,19901,10429,20152,19775,20295,9711,8520,7196,6640,10230,8677,7296,9661,8505,9113,8679,8017,8678,11269,9892,10263,9114,12194,8018,19365,8357,8023,8511,6934,8411,9572,8412,9112,10906,8676,11990,8414,8024,8413,8410,8242,9712,11398,8155,14566,8437,17026,9379,9805,11399,16394,9905,11351,12045,19811,11400,11401,9714,9057,14521,8694,9663,13519,9283,18626,13629,9903,9904,12128,11638,13601,13574,9902,13709,12108,10264,12261,12265,12059,12119,13529,10266,10001,11267,9804,13520,10363,9380,10246,10075,10247,10043,10428,12272,10908,10282,9877,10245,10073,10709,10280,10427,10283,10285,10106,10089,10281,10087,10417,12091,10265,10229,10284,10094,10454,10388,13332,10561,10395,10710,11239,13595,13471,11392,10954,11302,13563,11681,11694,11866,11879,11899,12015,11892,11851,11838,11825,11798,11811,11965,11961,13468,12193,13569,13430,13201,13337,13407,13541,13526,13343,13340,12361,12439,12394,12407,12426,12459,12474,12487,12682,12697,12739,12916,12765,12798,12731,12812,12629,12665,13037,13115,13082,13102,13146,13410,13628,13604,13580,13583,13598,13577,13566,13586,13924,13589,15249,13851,14288,14293,13846,13875,13809,13814,13819,13836,13870,13841,14338,14312,14369,14364,14307,14996,14468,15041,14351,14325,14966,15016,15029,14569,15012,15071,14727,14715,14536,14897,14544,14578,15067,14531,14558,15089,14975,14582,14913,14525,14506,14845,14821,14929,14833,14501,14933,14802,14478,14482,14486,14472,14925,14511,14741,14495,14719,14971,14764,14723,14676,14857,15002,14806,14877,14818,14680,15084,15579,15136,15503,15212,15836,15179,16754,15191,15699,15550,16084,15948,15260,15657,16391,15522,15352,15787,16251,15981,15370,15413,15319,15488,15336,15594,15672,15638,16372,15766,16201,15963,16186,16041,16013,16293,15998,16169,16226,16056,15803,18371,16721,16644,16502,16586,16694,16740,16840,17906,18265,20234,18079,18563,18174,18557,18227,18587,18542,19248,20166,19453,9601,9588,9589,9611,10981,9603,9419,9598,9478,9493,9621,9425,9595,9486,9414,9596,9475,9483,9593,9586,9581,9487,9484,9417,9421,9427,9600,9476,9587,18524,19683,20197,19846,20311,19908,9488,20148,19781,20291,9608,12187,9582,9594,9482,9489,9477,9604,9535,9583,9494,9490,10989,9416,12195,9533,18010,10965,9491,10988,9605,9536,9613,9577,9624,9479,9481,9597,9584,11573,9496,9614,9599,9749,9612,9610,9480,13590,9592,9602,9495,16122,10992,9616,12186,9579,9591,9415,19807,9607,9578,10980,10800,10982,11021,9422,13920,10843,10554,17886,17336,10556,10071,10804,10809,9908,10991,11108,10799,11034,11015,10801,10835,10826,10975,10568,9679,10070,10074,9615,9622,9606,9623,9798,10558,10128,9810,10044,10424,10072,10095,9965,9945,9966,10818,9568,9821,9827,9839,9855,9863,9872,10030,10050,13300,9968,10088,12092,10398,10490,12129,10450,10990,11028,11219,11349,12179,12145,11380,11434,11441,11533,11509,11615,11607,11677,11690,11726,11874,11887,11848,11835,11822,11794,11807,11970,11957,13295,13480,13500,12135,12141,14440,15125,12370,12448,12392,12405,12433,12496,12691,12706,12786,12748,12925,12763,12796,12729,12810,12636,12672,13195,13124,13091,13100,13155,13419,13655,13773,13670,13663,13783,15246,13912,14284,14408,15443,13895,13864,14075,13904,15872,15626,14335,14418,15688,14361,14433,14993,16240,15038,14348,14321,14963,15050,15711,14689,15058,15080,14951,15153,14906,14671,15222,15230,14599,14663,15098,14984,14633,15258,16209,14589,14854,14830,15114,14842,14615,15024,15175,14641,15930,15922,14922,14607,14738,15914,14943,15429,14761,14773,14874,14866,15280,15719,14886,14815,16097,15752,15576,15133,15500,15209,15833,15188,16761,15200,15696,15547,16081,15945,15269,15654,16388,15519,15349,15784,16248,15978,15367,15410,15314,15485,15333,15591,15669,15635,16369,15763,16197,15960,16182,16038,16006,16290,15991,16165,16223,16053,15800,18367,16717,16649,16499,16583,16691,16746,16836,17902,18261,20240,18075,18569,18180,18553,18233,18583,18538,19244,20162,19459,11232,11992,11086,11127,11202,11096,11466,11156,13334,11450,11126,11172,11084,11243,11544,11175,12017,11137,14573,11098,11200,17557,11177,18012,18526,19681,20199,19844,20313,19910,11463,20146,19783,20289,11089,11145,11203,11169,11138,11190,14462,11124,11143,11139,11184,12196,11198,11461,11087,11462,11185,11205,11135,11206,11130,11157,11094,11167,11179,11131,11574,11092,11141,11085,11091,11093,13592,11201,13034,11144,16123,11090,11102,12185,11129,17528,11207,11147,11192,11148,11159,11318,11125,11316,11186,13919,11939,14088,17885,17334,12120,12061,11357,11132,11230,11100,11160,11170,11449,11095,11319,11154,12244,12104,11193,12234,11173,12282,11225,12232,11343,11345,12230,11396,11212,11161,18560,11717,12051,11088,12248,11178,12236,11164,11166,11180,12103,12177,11944,17227,12229,15557,11644,12176,13866,11220,11348,12178,12144,11946,11664,18358,14952,11508,11614,11606,11676,11689,11725,11860,11873,11886,11847,11834,11821,11793,11806,11968,11956,16120,16126,15506,15176,14439,15123,12366,12444,12390,12403,12434,12492,12687,12702,12782,12921,12761,12794,12727,12808,12637,12673,13191,13120,13087,13098,13151,13415,13653,13775,13669,13661,13785,15244,13911,14283,14407,15441,13893,13863,14074,13903,15870,15624,14333,14416,15686,14359,14431,14991,16238,15036,14346,14320,14961,15049,15709,14688,15057,15079,14949,15152,14905,14669,15220,15228,14600,14661,15097,14983,14634,15256,16205,14590,14853,14829,15113,14841,14616,15023,15173,14642,15928,15920,14920,14608,14736,15912,14941,15427,14759,14771,14875,14865,15278,15717,14885,14813,16095,15750,15574,15131,15498,15207,15831,15187,16763,15199,15694,15545,16079,15943,15268,15652,16386,15517,15347,15782,16246,15976,15365,15408,15315,15483,15331,15589,15667,15633,16367,15761,16193,15958,16178,16036,16004,16288,15989,16161,16221,16051,15798,18365,16715,16651,16497,16580,16689,16748,16834,17900,18259,20242,18073,18571,18182,18551,18235,18581,18536,19242,20160,19461,11715,9669,10187,10256,11018,9801,9670,9800,13786,14692,12565,13690,13432,10970,10977,17688,12038,12044,11757,12270,11756,11758,11903,11759,10978,10971,12204,10979,13797,13439,13158,13157,13447,14693,11421,11422,11423,11424,11425,11426,11427,11428,12572,13443,16138,13445,13449,14699,15677,14646,14700,15896,15905,17160,16967,15893,17252,15895,16352,16117,15899,17224,15901,15903,16280,15581,16111,16129,15838,16113,16115,15701,15553,16087,15951,15873,16172,15524,15354,15789,16253,15984,15372,15415,15320,15490,15338,15596,15674,15640,15768,16189,15966,16174,16043,16001,15986,16157,16228,16059,15805,10526,10539,10360,10367,10354,10349,10543,10387,10359,10765,10548,10564,10920,10430,10560,10431,10366,10766,10527,10348,10555,17556,10536,10532,10433,18525,19682,20198,19845,20312,19909,10540,20147,19782,20290,10528,10767,10353,10355,10541,10346,10550,10485,10549,10708,10764,10909,10351,12197,10533,10763,11227,10762,11010,11110,10525,11226,10547,10537,10350,10356,10396,11335,11575,10529,10358,10531,10530,10534,13591,10926,10565,10542,16124,11234,11240,10768,10551,17529,11123,12052,10929,11665,12114,10986,11120,11317,13921,10924,10911,17887,17335,10912,11113,12060,11229,10361,11231,10960,10496,11241,11111,11344,11464,10773,11211,10347,11320,10994,12245,11112,10976,10917,10910,10772,11321,10914,11009,10771,11336,10927,11114,12082,10921,10770,11228,10928,11242,11359,10524,10538,10343,10344,10922,14593,11115,11116,17228,11117,15558,10743,11118,14927,11714,11448,12180,12146,11311,11592,11435,14954,11510,11616,11608,11678,11691,11727,11875,11888,11849,11836,11823,11795,11808,11967,11958,16121,16125,14572,14574,14441,15124,12369,12447,12391,12404,12435,12495,12690,12705,12785,12747,12924,12762,12795,12728,12809,12638,12674,13194,13123,13090,13099,13154,13418,13654,13774,13671,13662,13784,15245,13913,14285,14409,15442,13894,13865,14076,13905,15871,15625,14334,14417,15687,14360,14432,14992,16239,15037,14347,14322,14962,15051,15710,14690,15059,15081,14950,15154,14907,14670,15221,15229,14601,14662,15099,14985,14635,15257,16207,14591,14855,14831,15115,14843,14617,15025,15174,14643,15929,15921,14921,14609,14737,15913,14942,15428,14760,14772,14873,14867,15279,15718,14887,14814,16096,15751,15575,15132,15499,15208,15832,15189,16762,15201,15695,15546,16080,15944,15270,15653,16387,15518,15348,15783,16247,15977,15366,15409,15316,15484,15332,15590,15668,15634,16368,15762,16195,15959,16180,16037,16005,16289,15990,16163,16222,16052,15799,18366,16716,16650,16498,16581,16690,16747,16835,17901,18260,20241,18074,18570,18181,18552,18234,18582,18537,19243,20161,19460,9916,9917,9924,9920,9921,9918,9912,8841,9919,9792,9690,9691,9922,9699,9701,9748,9702,9696,9692,9913,9910,9911,9704,9873,9875,9775,9695,9703,9705,9693,15341,9698,9694,9700,9697,14753,9874,14752,15679,15906,16356,15583,15840,15703,16088,15952,15526,15356,18403,15985,15374,15417,15321,15340,15598,15676,15642,15770,16191,15967,16176,16045,16003,16295,15988,16159,16230,16060,15807,11745,13257,11122,11151,11525,12110,11133,12011,11934,11280,11331,11524,11548,11521,13700,13701,11281,11993,11576,11171,13702,17558,11981,15891,19545,12721,11541,12113,11330,11622,12070,11522,12980,11550,11282,12109,12069,11739,11567,13372,11564,12068,11362,12009,12981,11594,12983,11555,11526,11194,11332,11285,11536,12049,11537,11708,11307,12100,12121,11565,12112,11289,11707,11292,12053,15281,11556,11712,11283,11709,14749,11459,12012,19096,11738,11276,11595,11543,11277,11540,11731,11557,11552,12284,11579,11566,11711,11621,12979,11278,11523,11743,11742,12285,14891,11741,11549,13258,11286,12002,11290,11558,11571,11460,12286,12013,11706,11554,11551,13170,11569,14691,11284,11279,12977,17226,11287,12972,13171,13830,11291,13867,13169,19765,13313,13174,14888,18359,14953,13268,13168,15060,12984,19985,13142,18051,13167,12982,17795,17794,17793,12978,15474,16127,13267,18004,18009,18011,13368,18008,15754,15755,20084,15843,14889,16407,15475,15434,15461,15931,14890,14748,15476,17791,16630,15846,15445,16638,15527,15446,15452,16633,15845,15847,16468,15451,15477,15933,15859,15468,15462,15823,15469,15470,15844,16408,16573,15463,15449,15860,15444,15448,16572,16568,15460,15856,16467,19766,15471,16570,15849,16571,16634,15842,15447,15459,16635,15450,16469,15850,16406,15861,15454,17792,16636,15813,16637,16569,15852,15453,20005,16404,15841,16466,17788,15473,15851,15560,16401,16411,15561,16405,16513,16574,15376,15863,16395,16410,15375,15858,15382,15932,15384,15853,15854,15855,16631,15862,16412,16409,16396,16400,16402,16511,16403,16512,16510,16398,15864,17789,17790,17891,17229,19920,19226,18475,18474,19771,5005,5059,5251,5250,5125,5007,5108,5249,5123,5288,5018,5105,5247,5014,5277,5042,5276,5075,5272,5515,5248,5383,5267,5269,5266,5086,5517,5505,5640,5534,5552,5573,5581,5603,5631,5667,5701,5740,5738,5763,5765,5948,5934,6075,6023,6030,6032,6123,6082,6089,6103,6101,6110,6138,6146,6153,18516,19685,20189,19848,20303,19899,6399,20150,19773,20293,6510,6446,6448,6450,6585,8259,6646,6608,6610,6622,6891,6669,6942,6701,6442,6754,6935,6835,6866,6882,6927,7933,6953,6899,7515,6906,6921,7197,7387,7389,7526,8257,7732,7739,7703,7715,7759,7749,7904,7921,7935,7948,7996,8010,8077,8856,8070,8092,8131,8605,8148,8243,8250,8476,8522,8345,8376,8518,13517,8559,8674,13622,8695,9570,12126,8606,13599,13572,9008,10137,12106,9036,12259,12263,12057,12117,13527,9900,9025,9033,10812,9128,9406,9542,9766,9768,9770,9772,10251,12257,9776,10249,9806,10007,10005,9949,10041,10374,10253,9848,9856,9865,10023,10031,10033,10039,12089,10053,10055,10057,10059,10198,10275,13330,10313,10315,10317,10319,13593,13469,9927,10757,10736,10747,11296,13561,11679,11692,11876,11897,12014,11889,11850,11837,11824,11796,11809,11964,11959,13467,12191,13567,13428,13199,13335,13405,13539,13524,13341,13338,12359,12437,12393,12406,12424,12457,12472,12485,12680,12695,12775,12737,12914,12764,12797,12730,12811,12627,12663,13035,13113,13080,13101,13144,13408,13626,13602,13578,13581,13596,13575,13564,13584,13922,13587,15247,13849,14286,14291,13844,13873,13807,13812,13817,13834,13868,13839,14336,14310,14367,14362,14305,14994,14467,15039,14349,14323,14964,15014,15027,14568,15010,15070,14725,14713,14535,14896,14542,14576,15065,14530,14556,15088,14974,14580,14911,14523,14504,14844,14820,14928,14832,14499,14932,14800,14476,14480,14484,14471,14923,14509,14739,14494,14717,14970,14762,14721,14675,14856,15000,14804,14876,14816,14679,15082,15577,15134,15501,15210,15834,15178,16752,15190,15697,15548,16082,15946,15259,15655,16389,15520,15350,15785,16249,15979,15368,15411,15317,15486,15334,15592,15670,15636,16370,15764,16203,15961,16188,16039,16015,16291,16000,16171,16224,16054,15801,18369,16719,16642,16500,16584,16692,16738,16838,17904,18263,20232,18077,18561,18172,18555,18225,18585,18540,19246,20164,19451,11935,3000,12591"}
[分析过程]
base.OrderSourceID IN 的渠道太多，反而使用索引过慢，建议 直接改成主键关联提升效率
[期望结果] 在导出的 语句中 采用 RB_Amazon_Product_Base base(NOLOCK) 改成 RB_Amazon_Product_Base base with(NOLOCK,index=0) 规避选择索引