首页 > SqlSugar

分表进行分页查询时，由于CollectValues是json字符串，导致PC的磁盘读写达到600M/s,查询时间太长返回

SqlSugar 沟通中

 6  287

贝壳里的心 发布于2025/8/27

悬赏：0 飞吻

SELECT * FROM

(SELECT [FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[ModifyTime],[FK_ModifyUserID],[Sort],[Id] FROM [Ts_ProductiveCollects20250801] WITH(NOLOCK) WHERE ( [CreateTime] < '2025/9/1 0:00:00' ) UNION ALL

SELECT [FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[ModifyTime],[FK_ModifyUserID],[Sort],[Id] FROM [Ts_ProductiveCollects20250501] WITH(NOLOCK) WHERE ( [CreateTime] < '2025/9/1 0:00:00' )) unionTable ORDER BY [CreateTime] DESC OFFSET 0 ROWS FETCH NEXT 1000 ROWS ONLY

这是分页查询，由于磁盘IO性能限制导致查询很慢；

目前改成分布查询，先查询FK_ProductiveProcessID，然后再根据FK_ProductiveProcessID进行条件查询，这样查询出来比上面的快一点，上面的语句查询有什么办法实现一下的分布方式

SELECT [FK_ProductiveProcessID] FROM (SELECT [FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[ModifyTime],[FK_ModifyUserID],[Sort],[Id] FROM [Ts_ProductiveCollects20250801] WITH(NOLOCK) WHERE ( [CreateTime] < '2025/9/1 0:00:00' ) UNION ALL

SELECT [FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[ModifyTime],[FK_ModifyUserID],[Sort],[Id] FROM [Ts_ProductiveCollects20250501] WITH(NOLOCK) WHERE ( [CreateTime] < '2025/9/1 0:00:00' )) unionTable ORDER BY [CreateTime] DESC OFFSET 0ROWS FETCH NEXT 1000 ROWS ONLY

SELECT * FROM (

SELECT [FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[ModifyTime],[FK_ModifyUserID],[Sort],[Id] FROM [Ts_ProductiveCollects20250801] WITH(NOLOCK) WHERE ([FK_ProductiveProcessID] IN (1953650723515043840,1953650717282308096,1953650709925498880,1953650708491046912,1953650696923156480,1953650696294010880,1953650688559714304,1953650686663888896,1953650685736947712,1953650684214415360,1953650678602436608,1953650676090048512,1953650674622042112,1953650674550738944,1953650674227777536,1953650660378185728,1953650657098240000,1953650645249331200,1953650641088581632,1953650639821901824,1953650639830290432,1953650636361601024,1953650612114329600,1953650604396810240,1953650594691190784,1953650593671974912,1953650591759372288,1953650590538829824,1953650590379446272,1953650589989376000,1953650589825798144,1953650584805216256,1953650583110717440,1953650581596573696,1953650579658805248,1953650579285512192,1953650570993373184,1953650562818674688,1953650562697039872,1953650556892123136,1953650555721912320,1953650545882075136,1953650545416507392,1953650537967423488,1953650528886755328,1953650523476103168,1953650517012680704,1953650511832715264,1953650510314377216,1953650510272434176,1953650509962055680,1953650509790089216,1953650508825399296,1953650505604173824,1953650494040477696,1953650491226099712,1953650490622119936,1953650490529845248,1953650476722196480,1953650473819738112,1953650465821200384,1953650465632456704,1953650464986533888,1953650453963902976,1953650444040179712,1953650438956683264,1953650436209414144,1953650434468777984,1953650432648450048,1953650430605824000,1953650423446147072,1953650423295152128,1953650422829584384,1953650421038616576,1953650421017645056,1953650420552077312,1953650417658007552,1953650414860406784,1953650410099871744,1953650409772716032,1953650396518715392,1953650395080069120,1953650386989256704,1953650374662197248,1953650364910440448,1953650361961844736,1953650360758079488,1953650359134883841,1953650353032171520,1953650348523294720,1953650344249298944,1953650342974230528,1953650341577527296,1953650341074210816,1953650341065822208,1953650340159852544,1953650339065139200,1953650338863812608,1953650337714573312,1953650317674188800,1953650314834644992,1953650308887121920,1953650306060161024,1953650305443598336,1953650304415993856,1953650296681697280,1953650296627171328,1953650285835227136,1953650280588152832,1953650276687450112,1953650275143946240,1953650271159357440,1953650267942326272,1953650263253094400,1953650257599172608,1953650255619461120,1953650253887213568,1953650253845270528,1953650253811716096,1953650252754751488,1953650249671938048,1953650248812105728,1953650240800985088,1953650232546594816,1953650230126481408,1953650219888185344,1953650214423007232,1953650208207048704,1953650207221387264,1953650193979969536,1953650193183051776,1953650192721678336,1953650185926905856,1953650184135938048,1953650182525325312,1953650181971677184,1953650175961239552,1953650174174466048,1953650174115745792,1953650174094774272,1953650173486600192,1953650170282151936,1953650157317558272,1953650154616426496,1953650147200897024,1953650141203042304,1953650139026198528,1953650138401247232,1953650136421535744,1953650130100719616,1953650118633492480,1953650113281560576,1953650108667826176,1953650107199819776,1953650100098863104,1953650096487567360,1953650094109396992,1953650094092619776,1953650090695233536,1953650086748393472,1953650086492540928,1953650085745954816,1953650085532045312,1953650084034678784,1953650082369540096,1953650080737955840,1953650074563940352,1953650060282335232,1953650058990489600,1953650052015362048,1953650048806719488,1953650046621487104,1953650043156992000,1953650039864463360,1953650033933717504,1953650026631434240,1953650025792573440,1953650024542670848,1953650017672400896,1953650013423570944,1953650006947565568,1953650006763016192,1953650003227217920,1953650002434494464,1953650002421911552,1953650001859874816,1953650001306226688,1953649989889331200,1953649987674738688,1953649984189272064,1953649983493017600,1953649978342412288,1953649978057199616,1953649974760476672,1953649971556028416,1953649970763304960,1953649969039446016,1953649962685075456,1953649961053491200,1953649949405908992,1953649940664979456,1953649934017007616,1953649933433999360,1953649930946777088,1953649927243206656,1953649921694142464,1953649920632983552,1953649920108695552,1953649919768956928,1953649919320166400,1953649919257251840,1953649915104890880,1953649915096502272,1953649906863083520,1953649894594744320,1953649894292754432,1953649885967060992,1953649884335476736,1953649879671410688,1953649877117079552,1953649874243981312,1953649871823867904,1953649870641074176,1953649864995540992,1953649863590449152,1953649860079816704,1953649859534557184,1953649857902972928,1953649850307088384,1953649846314110976,1953649839976517632,1953649839930380288,1953649838504316928,1953649837497683968,1953649836793040896,1953649836214226944,1953649834054160384,1953649820640776192,1953649816714907648,1953649812256362496,1953649808380825600,1953649807764262912,1953649803838394368,1953649803662233600,1953649803188277248,1953649795734999040,1953649795407843328,1953649782304837632,1953649774524403712,1953649773387747328,1953649768098729984,1953649765875748864,1953649762147012608,1953649760339267584,1953649759504601088,1953649758158229504,1953649754152669184,1953649752017768448,1953649751514451968,1953649751459926016,1953649751187296256,1953649750306492416,1953649750050639872,1953649747882184704,1953649746653253632,1953649738797322240,1953649727678222336,1953649716596871168,1953649706564096000,1953649703590334464,1953649703305121792,1953649700465577984,1953649693343649792,1953649691896614912,1953649689946263552,1953649689921097728,1953649678139297792,1953649672082722816,1953649669306093568,1953649668249128960,1953649668098134016,1953649666160365568,1953649650469474304,1953649647776731136,1953649646589743104,1953649643829891072,1953649640256344064,1953649637727178752,1953649636577939456,1953649636141731840,1953649605951131648,1953649597663186944,1953649593854758912,1953649590901968896,1953649584581152768,1953649584253997056,1953649584014921728,1953649583197032448,1953649582484000768,1953649581733220352,1953649558542913536,1953649547633528832,1953649521066807296,1953649512418152448,1953649509041737728,1953649504713216000,1953649502012084224,1953649500997062656,1953649500929953792,1953649499067682816,1953649497314463744,1953649491291443200,1953649489714384896,1953649477995499520,1953649477085335552,1953649470991011840,1953649467492962304,1953649451235840000,1953649437797289984,1953649431166095360,1953649429521928192,1953649423566016512,1953649416871907328,1953649415420678144,1953649414925750272,1953649413600350208,1953649413260611584,1953649406323232768,1953649394012950528,1953649394004561920,1953649390145802240,1953649380557623296,1953649373028847616,1953649371330154496,1953649371359514624,1953649358579470336,1953649353831518208,1953649349729488896,1953649342246850560,1953649340057423872,1953649336609705984,1953649336374824960,1953649333749190656,1953649333115850752,1953649332667060224,1953649331215831040,1953649330943201280,1953649321141112832,1953649316057616384,1953649314581221376,1953649313339707392,1953649312790253568,1953649303256600576,1953649302866530304,1953649300668715008,1953649294926712832,1953649282519961600,1953649271652519936,1953649270356480000,1953649267563073536,1953649262911590400,1953649262836092928,1953649258067169280,1953649258058780672,1953649257769373696,1953649253449240576,1953649249376571392,1953649248801951744,1953649247451385856,1953649247174561792,1953649246797074432,1953649239364767744,1953649238161002496,1953649233668902912,1953649228535074816,1953649223233474560,1953649221085990912,1953649212961624064,1953649210226937856,1953649210063360000,1953649207815213056,1953649204589793280,1953649200521318400,1953649199959281664,1953649199204306944,1953649191256100864,1953649190744395776,1953649188831793152,1953649186663337984,1953649183718936576,1953649168451670016,1953649164861345792,1953649156120416256,1953649154522386433,1953649154253950976,1953649151632510976,1953649151229857792,1953649147295600640,1953649144414113792,1953649140018483200,1953649135815790592,1953649135362805760,1953649134817546240,1953649126147919872,1953649122343686144,1953649117029502976,1953649115003654144,1953649113778917376,1953649111291695104,1953649105214148608,1953649104283013120,1953649100520722432,1953649096783597568,1953649088923471872,1953649087866507264,1953649084066467840,1953649083542179840,1953649081772183552,1953649081260478464,1953649078374797312,1953649066886598656,1953649049966776320,1953649047911567360,1953649042962288640,1953649040722530304,1953649040500232192,1953649039334215680,1953649035584507904,1953649030693949440,1953649030480039936,1953649027078459392,1953649023441997824,1953649022628302848,1953649018740183040,1953649017284759552,1953649016852746240,1953649013652492288,1953649013354696704,1953649003078651904,1953648999400247296,1953648995445018624,1953648991405903872,1953648986834112512,1953648982925021184,1953648978978181120,1953648976130248704,1953648973655609344,1953648970237251584,1953648962305822720,1953648954324062208,1953648954185650176,1953648952629563392,1953648949076987904,1953648943632781312,1953648919985295360,1953648919335178240,1953648913966469120,1953648909679890432,1953648896786599936,1953648891979927552,1953648891833126912,1953648891677937664,1953648887135506432,1953648883146723328,1953648877190811648,1953648860556201984,1953648858299666432,1953648856835854336,1953648855879553024,1953648855447539712,1953648835583315968,1953648830642425856,1953648830235578368,1953648827748356096,1953648823986065408,1953648800896421888,1953648800862867457,1953648797436121088,1953648795825508352,1953648777148272640,1953648770978451456,1953648769300729856,1953648769023905792,1953648767446847488,1953648764812824576,1953648750933872640,1953648747825893376,1953648741635100672,1953648740649439232,1953648736140562432,1953648718901972992,1953648710148460544,1953648709921968128,1953648708642705408,1953648705660555264,1953648699314573312,1953648698165334016,1953648681899823104,1953648680415039488,1953648665911136256,1953648657849683968,1953648652480974848,1953648652162207744,1953648648559300608,1953648647791742976,1953648645136748544,1953648626950246400,1953648619924787200,1953648612769304576,1953648597766279168,1953648595572658176,1953648583182684160,1953648577302269952,1953648577130303488,1953648576014618624,1953648572600455168,1953648571790954496,1953648565616939008,1953648533140443136,1953648530456088576,1953648520360398848,1953648519827722240,1953648519169216512,1953648518846255104,1953648518707843072,1953648515109130240,1953648510747054080,1953648482624245760,1953648466652336128,1953648463221395456,1953648459987587072,1953648458964176896,1953648458725101568,1953648458620243968,1953648454925062144,1953648445634678784,1953648421550985216,1953648412315127808,1953648408422813696,1953648384620138496,1953648376407691264,1953648136984236032,1953648125521203200,1953648090049974272,1953648081275490304,1953648071431458816,1953648035071037440,1953648034152484864,1953648027269632000,1953648014560890880,1953647979156770816,1953647978083028992,1953647975100878848,1953647970650722304,1953647957719683072,1953647926077853696,1953647922466557952,1953647921875161088,1953647918469386240,1953647914149253120,1953647899360137216,1953647885208555520,1953647878589943808,1953647875045756928,1953647872562728960,1953647869798682624,1953647867391152128,1953647866090917888,1953647866090917889,1953647862211186688,1953647862097940480,1953647855529660416,1953647845220061184,1953647817772535808,1953647814161240064,1953647810877100032,1953647809950158848,1953647809224544256,1953647805319647232,1953647801783848960,1953647787879731200,1953647780833300480,1953647774252437504,1953647762739073024,1953647761019408384,1953647757915623424,1953647757844320256,1953647757722685440,1953647753171865600,1953647752580468736,1953647748650405888,1953647744237998080,1953647706237603840,1953647703523889152,1953647701758087168,1953647696854945792,1953647696515207168,1953647691997941760,1953647690416689152,1953647684905373696,1953647672469262336,1953647670187560960,1953647668128157696,1953647667121524736,1953647661916393472,1953647648695947264,1953647646619766784,1953647640210870272,1953647636079480832,1953647626575187968,1953647616680824832,1953647615300898816,1953647592920092672,1953647589979885568,1953647586288898048,1953647580597227520,1953647580509147136,1953647580140048384,1953647579871612928,1953647573043286016,1953647571873075200,1953647571378147328,1953647563425746944,1953647557348200448,1953647556056354816,1953647552252121088,1953647549303525376,1953647524037038080,1953647523651162112,1953647523168817152,1953647520161501184,1953647515711344640,1953647512297181184,1953647494999871488,1953647472468070400,1953647466763816960,1953647464733773824,1953647463475482624,1953647432513130496,1953647426481721344,1953647425470894080,1953647425194070016,1953647417182949376,1953647411289952256,1953647410123935744,1953647407569604608,1953647403060727808,1953647396949626880,1953647394332381184,1953647391291510784,1953647388430995456,1953647378352082944,1953647370944942080,1953647367606276096,1953647365970497536,1953647363017707520,1953647359196696576,1953647354104811520,1953647350657093632,1953647343644217344,1953647341937135616,1953647340485906432,1953647332059549696,1953647324266532864,1953647322135826432,1953647318755217408,1953647318486781952,1953647313348759552,1953647312782528512,1953647312744779776,1953647310580518912,1953647310433718272,1953647307170549760,1953647298987462656,1953647293614559232,1953647290993119232,1953647273670643712,1953647264262819840,1953647262778036224,1953647261813346304,1953647252934004736,1953647252720095232,1953647251445026816,1953647251092705280,1953647250929127424,1953647249486286848,1953647230834216960,1953647227944341504,1953647220319096832,1953647208814120960,1953647206293344256,1953647202082263040,1953647200350015488,1953647195623034880,1953647195539148800,1953647195388153856,1953647194750619648,1953647193676877824,1953647192221454336,1953647190715699200,1953647182788464640,1953647179349135360,1953647173753933824,1953647171195408384,1953647169962283008,1953647147027828736,1953647144062455808,1953647140031729664,1953647137666142208,1953647137246711808,1953647136399462400,1953647136235884544,1953647135707402240,1953647134348447744,1953647126924529664,1953647120201060352,1953647118208765952,1953647109820157952,1953647105311281152,1953647102610149376,1953647086608879616,1953647083601563648,1953647080778797056,1953647080657162240,1953647080371949568,1953647077893115904,1953647074353123328,1953647072276942848,1953647072109170688,1953647070993485824,1953647069865218048,1953647050307178496,1953647019462266880,1953647017314783232,1953647016111017984,1953647013254696960,1953647012826877952,1953647012520693760,1953647011556003840,1953646998071316480,1953646981763862528,1953646955545268224,1953646951413878784,1953646944539414528,1953646943205625856,1953646943117545472,1953646943083991040,1953646942664560640,1953646941813116928,1953646939007127552,1953646908216741888,1953646885420699648,1953646884330180608,1953646883877195776,1953646883793309696,1953646882765705216,1953646872602906624,1953646869700448256,1953646849370656768,1953646832622800896,1953646827195371520,1953646826956296192,1953646824762675200,1953646822237704192,1953646810485264384,1953646779032178688,1953646776725311488,1953646763802660864,1953646753916686336,1953646744085237760,1953646724111962112,1953646722853670912,1953646722627178496,1953646721285001216,1953646704293875712,1953646698430238720,1953646671045627904,1953646669321768960,1953646635184328704,1953646616632922112,1953646616561618944,1953646613311033344,1953646552673980416,1953646545401057280,1953646124955635712,1953646068227674112,1953646058538831872,1953646023612862464,1953646005996785664,1953645932273504256,1953645883200147456,1953645859808514048,1953645853613527040,1953645852665614336,1953645767718375424,1953645760705499136,1953645320152584192,1953645307238322176,1953645272702423040,1953645264552890368,1953645251516993536,1953645224094633984,1953645217018843136,1953645216486166528,1953645207250309120,1953645194839363584,1953645171573559296,1953645160488013824,1953645159544295424,1953645158214701056,1953645157552001024,1953645154255278080,1953645153374474240,1953645151252156416,1953645147968016384,1953645138346283008,1953645135544487936,1953645131220160512,1953645125834674176,1953645119476109312,1953645106020782080,1953645104196259840,1953645104057847808,1953645101746786304,1953645094696161280,1953645080448110592,1953645066074230784,1953645064258097152,1953645057614319616,1953645055055794176,1953645053793308672,1953645047258583040,1953645046465859584,1953645044242878464,1953645041814376448,1953645035703275520,1953645031739658240,1953645028069642240,1953645023376216064,1953645020784136192,1953645015457370112,1953645014253604864,1953645013704151040,1953645001033158656,1953644989544960000,1953644986877382656,1953644986319540224,1953644981458341888,1953644980535595008,1953644979935809536,1953644973786959872,1953644968070123520,1953644967004770304,1953644961271156736,1953644960470044672,1953644955495600128,1953644948310757376,1953644942166102016,1953644940551294976,1953644939574022144,1953644933920100352,1953644929880985600,1953644929516081152,1953644924734574592,1953644923887325184,1953644923069435904,1953644920787734528,1953644917671366656,1953644916815728640,1953644915221893120,1953644914160734208,1953644913288318976,1953644911841284096,1953644906275442688,1953644905981841408,1953644901472964608,1953644898000080896,1953644880451112960,1953644872247054336,1953644870611275776,1953644870254759936,1953644869923409920,1953644862130393088,1953644861769682944,1953644861513830400,1953644859802554368,1953644858875613184,1953644852995198976,1953644849761390592,1953644846926041088,1953644829574205440,1953644828072644608,1953644826432671744,1953644824276799488,1953644817943400448,1953644813988171776,1953644813996560384,1953644806354538496,1953644805612146688,1953644803791818752,1953644802411892736,1953644792995680256,1953644789690568704,1953644788834930688,1953644784841953280,1953644782396674048,1953644768526110720,1953644757365067776,1953644754856873984,1953644753820880896,1953644753086877696,1953644752206073856,1953644751493042176,1953644747114188800,1953644741506404352,1953644739828682752,1953644736586485760,1953644736301273088,1953644730945146880,1953644730194366464,1953644718664224768,1953644716428660736,1953644710598578176,1953644703438901248,1953644701983477760,1953644700846821376,1953644699596918784,1953644697965334528,1953644697688510464,1953644695184510976,1953644694718943232,1953644693431291904,1953644692290441216,1953644691128619008,1953644687328579584,1953644686766542848,1953644686485524480,1953644685587943424,1953644680730939392,1953644677174169600,1953644672623349760,1953644672585601024,1953644670215819264,1953644667791511552,1953644662775123968,1953644662225670144,1953644661600718848,1953644661290340352,1953644656181678080,1953644652700405760,1953644647553994752,1953644643703623680,1953644641061212160,1953644639408656384,1953644638259417088,1953644638032924672,1953644637558968320,1953644637319892992,1953644636120322048,1953644634358714368,1953644633377247232,1953644631707914240,1953644629283606528,1953644627836571648,1953644617921236992,1953644617073987584,1953644608886706176,1953644606256877568,1953644600166748160,1953644600045113344,1953644599306915840,1953644598442889216,1953644595532042240,1953644595213275136,1953644586157772800,1953644584962396160,1953644582634557440,1953644582299013120,1953644581808279552,1953644581602758656,1953644578662551552,1953644577798524928,1953644575974002688,1953644574346612736,1953644574258532352,1953644568105488384,1953644567178547200,1953644561172303872,1953644558458589184,1953644554348171264,1953644552171327488,1953644551286329344,1953644543619141632,1953644543556227072,1953644543447175168,1953644542662840320,1953644537491263488,1953644535847096320,1953644529580806144,1953644529396256768)) UNION ALL

SELECT [FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[ModifyTime],[FK_ModifyUserID],[Sort],[Id] FROM [Ts_ProductiveCollects20250701] WITH(NOLOCK) WHERE ([FK_ProductiveProcessID] IN (1953650723515043840,1953650717282308096,1953650709925498880,1953650708491046912,1953650696923156480,1953650696294010880,1953650688559714304,1953650686663888896,1953650685736947712,1953650684214415360,1953650678602436608,1953650676090048512,1953650674622042112,1953650674550738944,1953650674227777536,1953650660378185728,1953650657098240000,1953650645249331200,1953650641088581632,1953650639821901824,1953650639830290432,1953650636361601024,1953650612114329600,1953650604396810240,1953650594691190784,1953650593671974912,1953650591759372288,1953650590538829824,1953650590379446272,1953650589989376000,1953650589825798144,1953650584805216256,1953650583110717440,1953650581596573696,1953650579658805248,1953650579285512192,1953650570993373184,1953650562818674688,1953650562697039872,1953650556892123136,1953650555721912320,1953650545882075136,1953650545416507392,1953650537967423488,1953650528886755328,1953650523476103168,1953650517012680704,1953650511832715264,1953650510314377216,1953650510272434176,1953650509962055680,1953650509790089216,1953650508825399296,1953650505604173824,1953650494040477696,1953650491226099712,1953650490622119936,1953650490529845248,1953650476722196480,1953650473819738112,1953650465821200384,1953650465632456704,1953650464986533888,1953650453963902976,1953650444040179712,1953650438956683264,1953650436209414144,1953650434468777984,1953650432648450048,1953650430605824000,1953650423446147072,1953650423295152128,1953650422829584384,1953650421038616576,1953650421017645056,1953650420552077312,1953650417658007552,1953650414860406784,1953650410099871744,1953650409772716032,1953650396518715392,1953650395080069120,1953650386989256704,1953650374662197248,1953650364910440448,1953650361961844736,1953650360758079488,1953650359134883841,1953650353032171520,1953650348523294720,1953650344249298944,1953650342974230528,1953650341577527296,1953650341074210816,1953650341065822208,1953650340159852544,1953650339065139200,1953650338863812608,1953650337714573312,1953650317674188800,1953650314834644992,1953650308887121920,1953650306060161024,1953650305443598336,1953650304415993856,1953650296681697280,1953650296627171328,1953650285835227136,1953650280588152832,1953650276687450112,1953650275143946240,1953650271159357440,1953650267942326272,1953650263253094400,1953650257599172608,1953650255619461120,1953650253887213568,1953650253845270528,1953650253811716096,1953650252754751488,1953650249671938048,1953650248812105728,1953650240800985088,1953650232546594816,1953650230126481408,1953650219888185344,1953650214423007232,1953650208207048704,1953650207221387264,1953650193979969536,1953650193183051776,1953650192721678336,1953650185926905856,1953650184135938048,1953650182525325312,1953650181971677184,1953650175961239552,1953650174174466048,1953650174115745792,1953650174094774272,1953650173486600192,1953650170282151936,1953650157317558272,1953650154616426496,1953650147200897024,1953650141203042304,1953650139026198528,1953650138401247232,1953650136421535744,1953650130100719616,1953650118633492480,1953650113281560576,1953650108667826176,1953650107199819776,1953650100098863104,1953650096487567360,1953650094109396992,1953650094092619776,1953650090695233536,1953650086748393472,1953650086492540928,1953650085745954816,1953650085532045312,1953650084034678784,1953650082369540096,1953650080737955840,1953650074563940352,1953650060282335232,1953650058990489600,1953650052015362048,1953650048806719488,1953650046621487104,1953650043156992000,1953650039864463360,1953650033933717504,1953650026631434240,1953650025792573440,1953650024542670848,1953650017672400896,1953650013423570944,1953650006947565568,1953650006763016192,1953650003227217920,1953650002434494464,1953650002421911552,1953650001859874816,1953650001306226688,1953649989889331200,1953649987674738688,1953649984189272064,1953649983493017600,1953649978342412288,1953649978057199616,1953649974760476672,1953649971556028416,1953649970763304960,1953649969039446016,1953649962685075456,1953649961053491200,1953649949405908992,1953649940664979456,1953649934017007616,1953649933433999360,1953649930946777088,1953649927243206656,1953649921694142464,1953649920632983552,1953649920108695552,1953649919768956928,1953649919320166400,1953649919257251840,1953649915104890880,1953649915096502272,1953649906863083520,1953649894594744320,1953649894292754432,1953649885967060992,1953649884335476736,1953649879671410688,1953649877117079552,1953649874243981312,1953649871823867904,1953649870641074176,1953649864995540992,1953649863590449152,1953649860079816704,1953649859534557184,1953649857902972928,1953649850307088384,1953649846314110976,1953649839976517632,1953649839930380288,1953649838504316928,1953649837497683968,1953649836793040896,1953649836214226944,1953649834054160384,1953649820640776192,1953649816714907648,1953649812256362496,1953649808380825600,1953649807764262912,1953649803838394368,1953649803662233600,1953649803188277248,1953649795734999040,1953649795407843328,1953649782304837632,1953649774524403712,1953649773387747328,1953649768098729984,1953649765875748864,1953649762147012608,1953649760339267584,1953649759504601088,1953649758158229504,1953649754152669184,1953649752017768448,1953649751514451968,1953649751459926016,1953649751187296256,1953649750306492416,1953649750050639872,1953649747882184704,1953649746653253632,1953649738797322240,1953649727678222336,1953649716596871168,1953649706564096000,1953649703590334464,1953649703305121792,1953649700465577984,1953649693343649792,1953649691896614912,1953649689946263552,1953649689921097728,1953649678139297792,1953649672082722816,1953649669306093568,1953649668249128960,1953649668098134016,1953649666160365568,1953649650469474304,1953649647776731136,1953649646589743104,1953649643829891072,1953649640256344064,1953649637727178752,1953649636577939456,1953649636141731840,1953649605951131648,1953649597663186944,1953649593854758912,1953649590901968896,1953649584581152768,1953649584253997056,1953649584014921728,1953649583197032448,1953649582484000768,1953649581733220352,1953649558542913536,1953649547633528832,1953649521066807296,1953649512418152448,1953649509041737728,1953649504713216000,1953649502012084224,1953649500997062656,1953649500929953792,1953649499067682816,1953649497314463744,1953649491291443200,1953649489714384896,1953649477995499520,1953649477085335552,1953649470991011840,1953649467492962304,1953649451235840000,1953649437797289984,1953649431166095360,1953649429521928192,1953649423566016512,1953649416871907328,1953649415420678144,1953649414925750272,1953649413600350208,1953649413260611584,1953649406323232768,1953649394012950528,1953649394004561920,1953649390145802240,1953649380557623296,1953649373028847616,1953649371330154496,1953649371359514624,1953649358579470336,1953649353831518208,1953649349729488896,1953649342246850560,1953649340057423872,1953649336609705984,1953649336374824960,1953649333749190656,1953649333115850752,1953649332667060224,1953649331215831040,1953649330943201280,1953649321141112832,1953649316057616384,1953649314581221376,1953649313339707392,1953649312790253568,1953649303256600576,1953649302866530304,1953649300668715008,1953649294926712832,1953649282519961600,1953649271652519936,1953649270356480000,1953649267563073536,1953649262911590400,1953649262836092928,1953649258067169280,1953649258058780672,1953649257769373696,1953649253449240576,1953649249376571392,1953649248801951744,1953649247451385856,1953649247174561792,1953649246797074432,1953649239364767744,1953649238161002496,1953649233668902912,1953649228535074816,1953649223233474560,1953649221085990912,1953649212961624064,1953649210226937856,1953649210063360000,1953649207815213056,1953649204589793280,1953649200521318400,1953649199959281664,1953649199204306944,1953649191256100864,1953649190744395776,1953649188831793152,1953649186663337984,1953649183718936576,1953649168451670016,1953649164861345792,1953649156120416256,1953649154522386433,1953649154253950976,1953649151632510976,1953649151229857792,1953649147295600640,1953649144414113792,1953649140018483200,1953649135815790592,1953649135362805760,1953649134817546240,1953649126147919872,1953649122343686144,1953649117029502976,1953649115003654144,1953649113778917376,1953649111291695104,1953649105214148608,1953649104283013120,1953649100520722432,1953649096783597568,1953649088923471872,1953649087866507264,1953649084066467840,1953649083542179840,1953649081772183552,1953649081260478464,1953649078374797312,1953649066886598656,1953649049966776320,1953649047911567360,1953649042962288640,1953649040722530304,1953649040500232192,1953649039334215680,1953649035584507904,1953649030693949440,1953649030480039936,1953649027078459392,1953649023441997824,1953649022628302848,1953649018740183040,1953649017284759552,1953649016852746240,1953649013652492288,1953649013354696704,1953649003078651904,1953648999400247296,1953648995445018624,1953648991405903872,1953648986834112512,1953648982925021184,1953648978978181120,1953648976130248704,1953648973655609344,1953648970237251584,1953648962305822720,1953648954324062208,1953648954185650176,1953648952629563392,1953648949076987904,1953648943632781312,1953648919985295360,1953648919335178240,1953648913966469120,1953648909679890432,1953648896786599936,1953648891979927552,1953648891833126912,1953648891677937664,1953648887135506432,1953648883146723328,1953648877190811648,1953648860556201984,1953648858299666432,1953648856835854336,1953648855879553024,1953648855447539712,1953648835583315968,1953648830642425856,1953648830235578368,1953648827748356096,1953648823986065408,1953648800896421888,1953648800862867457,1953648797436121088,1953648795825508352,1953648777148272640,1953648770978451456,1953648769300729856,1953648769023905792,1953648767446847488,1953648764812824576,1953648750933872640,1953648747825893376,1953648741635100672,1953648740649439232,1953648736140562432,1953648718901972992,1953648710148460544,1953648709921968128,1953648708642705408,1953648705660555264,1953648699314573312,1953648698165334016,1953648681899823104,1953648680415039488,1953648665911136256,1953648657849683968,1953648652480974848,1953648652162207744,1953648648559300608,1953648647791742976,1953648645136748544,1953648626950246400,1953648619924787200,1953648612769304576,1953648597766279168,1953648595572658176,1953648583182684160,1953648577302269952,1953648577130303488,1953648576014618624,1953648572600455168,1953648571790954496,1953648565616939008,1953648533140443136,1953648530456088576,1953648520360398848,1953648519827722240,1953648519169216512,1953648518846255104,1953648518707843072,1953648515109130240,1953648510747054080,1953648482624245760,1953648466652336128,1953648463221395456,1953648459987587072,1953648458964176896,1953648458725101568,1953648458620243968,1953648454925062144,1953648445634678784,1953648421550985216,1953648412315127808,1953648408422813696,1953648384620138496,1953648376407691264,1953648136984236032,1953648125521203200,1953648090049974272,1953648081275490304,1953648071431458816,1953648035071037440,1953648034152484864,1953648027269632000,1953648014560890880,1953647979156770816,1953647978083028992,1953647975100878848,1953647970650722304,1953647957719683072,1953647926077853696,1953647922466557952,1953647921875161088,1953647918469386240,1953647914149253120,1953647899360137216,1953647885208555520,1953647878589943808,1953647875045756928,1953647872562728960,1953647869798682624,1953647867391152128,1953647866090917888,1953647866090917889,1953647862211186688,1953647862097940480,1953647855529660416,1953647845220061184,1953647817772535808,1953647814161240064,1953647810877100032,1953647809950158848,1953647809224544256,1953647805319647232,1953647801783848960,1953647787879731200,1953647780833300480,1953647774252437504,1953647762739073024,1953647761019408384,1953647757915623424,1953647757844320256,1953647757722685440,1953647753171865600,1953647752580468736,1953647748650405888,1953647744237998080,1953647706237603840,1953647703523889152,1953647701758087168,1953647696854945792,1953647696515207168,1953647691997941760,1953647690416689152,1953647684905373696,1953647672469262336,1953647670187560960,1953647668128157696,1953647667121524736,1953647661916393472,1953647648695947264,1953647646619766784,1953647640210870272,1953647636079480832,1953647626575187968,1953647616680824832,1953647615300898816,1953647592920092672,1953647589979885568,1953647586288898048,1953647580597227520,1953647580509147136,1953647580140048384,1953647579871612928,1953647573043286016,1953647571873075200,1953647571378147328,1953647563425746944,1953647557348200448,1953647556056354816,1953647552252121088,1953647549303525376,1953647524037038080,1953647523651162112,1953647523168817152,1953647520161501184,1953647515711344640,1953647512297181184,1953647494999871488,1953647472468070400,1953647466763816960,1953647464733773824,1953647463475482624,1953647432513130496,1953647426481721344,1953647425470894080,1953647425194070016,1953647417182949376,1953647411289952256,1953647410123935744,1953647407569604608,1953647403060727808,1953647396949626880,1953647394332381184,1953647391291510784,1953647388430995456,1953647378352082944,1953647370944942080,1953647367606276096,1953647365970497536,1953647363017707520,1953647359196696576,1953647354104811520,1953647350657093632,1953647343644217344,1953647341937135616,1953647340485906432,1953647332059549696,1953647324266532864,1953647322135826432,1953647318755217408,1953647318486781952,1953647313348759552,1953647312782528512,1953647312744779776,1953647310580518912,1953647310433718272,1953647307170549760,1953647298987462656,1953647293614559232,1953647290993119232,1953647273670643712,1953647264262819840,1953647262778036224,1953647261813346304,1953647252934004736,1953647252720095232,1953647251445026816,1953647251092705280,1953647250929127424,1953647249486286848,1953647230834216960,1953647227944341504,1953647220319096832,1953647208814120960,1953647206293344256,1953647202082263040,1953647200350015488,1953647195623034880,1953647195539148800,1953647195388153856,1953647194750619648,1953647193676877824,1953647192221454336,1953647190715699200,1953647182788464640,1953647179349135360,1953647173753933824,1953647171195408384,1953647169962283008,1953647147027828736,1953647144062455808,1953647140031729664,1953647137666142208,1953647137246711808,1953647136399462400,1953647136235884544,1953647135707402240,1953647134348447744,1953647126924529664,1953647120201060352,1953647118208765952,1953647109820157952,1953647105311281152,1953647102610149376,1953647086608879616,1953647083601563648,1953647080778797056,1953647080657162240,1953647080371949568,1953647077893115904,1953647074353123328,1953647072276942848,1953647072109170688,1953647070993485824,1953647069865218048,1953647050307178496,1953647019462266880,1953647017314783232,1953647016111017984,1953647013254696960,1953647012826877952,1953647012520693760,1953647011556003840,1953646998071316480,1953646981763862528,1953646955545268224,1953646951413878784,1953646944539414528,1953646943205625856,1953646943117545472,1953646943083991040,1953646942664560640,1953646941813116928,1953646939007127552,1953646908216741888,1953646885420699648,1953646884330180608,1953646883877195776,1953646883793309696,1953646882765705216,1953646872602906624,1953646869700448256,1953646849370656768,1953646832622800896,1953646827195371520,1953646826956296192,1953646824762675200,1953646822237704192,1953646810485264384,1953646779032178688,1953646776725311488,1953646763802660864,1953646753916686336,1953646744085237760,1953646724111962112,1953646722853670912,1953646722627178496,1953646721285001216,1953646704293875712,1953646698430238720,1953646671045627904,1953646669321768960,1953646635184328704,1953646616632922112,1953646616561618944,1953646613311033344,1953646552673980416,1953646545401057280,1953646124955635712,1953646068227674112,1953646058538831872,1953646023612862464,1953646005996785664,1953645932273504256,1953645883200147456,1953645859808514048,1953645853613527040,1953645852665614336,1953645767718375424,1953645760705499136,1953645320152584192,1953645307238322176,1953645272702423040,1953645264552890368,1953645251516993536,1953645224094633984,1953645217018843136,1953645216486166528,1953645207250309120,1953645194839363584,1953645171573559296,1953645160488013824,1953645159544295424,1953645158214701056,1953645157552001024,1953645154255278080,1953645153374474240,1953645151252156416,1953645147968016384,1953645138346283008,1953645135544487936,1953645131220160512,1953645125834674176,1953645119476109312,1953645106020782080,1953645104196259840,1953645104057847808,1953645101746786304,1953645094696161280,1953645080448110592,1953645066074230784,1953645064258097152,1953645057614319616,1953645055055794176,1953645053793308672,1953645047258583040,1953645046465859584,1953645044242878464,1953645041814376448,1953645035703275520,1953645031739658240,1953645028069642240,1953645023376216064,1953645020784136192,1953645015457370112,1953645014253604864,1953645013704151040,1953645001033158656,1953644989544960000,1953644986877382656,1953644986319540224,1953644981458341888,1953644980535595008,1953644979935809536,1953644973786959872,1953644968070123520,1953644967004770304,1953644961271156736,1953644960470044672,1953644955495600128,1953644948310757376,1953644942166102016,1953644940551294976,1953644939574022144,1953644933920100352,1953644929880985600,1953644929516081152,1953644924734574592,1953644923887325184,1953644923069435904,1953644920787734528,1953644917671366656,1953644916815728640,1953644915221893120,1953644914160734208,1953644913288318976,1953644911841284096,1953644906275442688,1953644905981841408,1953644901472964608,1953644898000080896,1953644880451112960,1953644872247054336,1953644870611275776,1953644870254759936,1953644869923409920,1953644862130393088,1953644861769682944,1953644861513830400,1953644859802554368,1953644858875613184,1953644852995198976,1953644849761390592,1953644846926041088,1953644829574205440,1953644828072644608,1953644826432671744,1953644824276799488,1953644817943400448,1953644813988171776,1953644813996560384,1953644806354538496,1953644805612146688,1953644803791818752,1953644802411892736,1953644792995680256,1953644789690568704,1953644788834930688,1953644784841953280,1953644782396674048,1953644768526110720,1953644757365067776,1953644754856873984,1953644753820880896,1953644753086877696,1953644752206073856,1953644751493042176,1953644747114188800,1953644741506404352,1953644739828682752,1953644736586485760,1953644736301273088,1953644730945146880,1953644730194366464,1953644718664224768,1953644716428660736,1953644710598578176,1953644703438901248,1953644701983477760,1953644700846821376,1953644699596918784,1953644697965334528,1953644697688510464,1953644695184510976,1953644694718943232,1953644693431291904,1953644692290441216,1953644691128619008,1953644687328579584,1953644686766542848,1953644686485524480,1953644685587943424,1953644680730939392,1953644677174169600,1953644672623349760,1953644672585601024,1953644670215819264,1953644667791511552,1953644662775123968,1953644662225670144,1953644661600718848,1953644661290340352,1953644656181678080,1953644652700405760,1953644647553994752,1953644643703623680,1953644641061212160,1953644639408656384,1953644638259417088,1953644638032924672,1953644637558968320,1953644637319892992,1953644636120322048,1953644634358714368,1953644633377247232,1953644631707914240,1953644629283606528,1953644627836571648,1953644617921236992,1953644617073987584,1953644608886706176,1953644606256877568,1953644600166748160,1953644600045113344,1953644599306915840,1953644598442889216,1953644595532042240,1953644595213275136,1953644586157772800,1953644584962396160,1953644582634557440,1953644582299013120,1953644581808279552,1953644581602758656,1953644578662551552,1953644577798524928,1953644575974002688,1953644574346612736,1953644574258532352,1953644568105488384,1953644567178547200,1953644561172303872,1953644558458589184,1953644554348171264,1953644552171327488,1953644551286329344,1953644543619141632,1953644543556227072,1953644543447175168,1953644542662840320,1953644537491263488,1953644535847096320,1953644529580806144,1953644529396256768)) UNION ALL

SELECT [FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[ModifyTime],[FK_ModifyUserID],[Sort],[Id] FROM [Ts_ProductiveCollects20250601] WITH(NOLOCK) WHERE ([FK_ProductiveProcessID] IN (1953650723515043840,1953650717282308096,1953650709925498880,1953650708491046912,1953650696923156480,1953650696294010880,1953650688559714304,1953650686663888896,1953650685736947712,1953650684214415360,1953650678602436608,1953650676090048512,1953650674622042112,1953650674550738944,1953650674227777536,1953650660378185728,1953650657098240000,1953650645249331200,1953650641088581632,1953650639821901824,1953650639830290432,1953650636361601024,1953650612114329600,1953650604396810240,1953650594691190784,1953650593671974912,1953650591759372288,1953650590538829824,1953650590379446272,1953650589989376000,1953650589825798144,1953650584805216256,1953650583110717440,1953650581596573696,1953650579658805248,1953650579285512192,1953650570993373184,1953650562818674688,1953650562697039872,1953650556892123136,1953650555721912320,1953650545882075136,1953650545416507392,1953650537967423488,1953650528886755328,1953650523476103168,1953650517012680704,1953650511832715264,1953650510314377216,1953650510272434176,1953650509962055680,1953650509790089216,1953650508825399296,1953650505604173824,1953650494040477696,1953650491226099712,1953650490622119936,1953650490529845248,1953650476722196480,1953650473819738112,1953650465821200384,1953650465632456704,1953650464986533888,1953650453963902976,1953650444040179712,1953650438956683264,1953650436209414144,1953650434468777984,1953650432648450048,1953650430605824000,1953650423446147072,1953650423295152128,1953650422829584384,1953650421038616576,1953650421017645056,1953650420552077312,1953650417658007552,1953650414860406784,1953650410099871744,1953650409772716032,1953650396518715392,1953650395080069120,1953650386989256704,1953650374662197248,1953650364910440448,1953650361961844736,1953650360758079488,1953650359134883841,1953650353032171520,1953650348523294720,1953650344249298944,1953650342974230528,1953650341577527296,1953650341074210816,1953650341065822208,1953650340159852544,1953650339065139200,1953650338863812608,1953650337714573312,1953650317674188800,1953650314834644992,1953650308887121920,1953650306060161024,1953650305443598336,1953650304415993856,1953650296681697280,1953650296627171328,1953650285835227136,1953650280588152832,1953650276687450112,1953650275143946240,1953650271159357440,1953650267942326272,1953650263253094400,1953650257599172608,1953650255619461120,1953650253887213568,1953650253845270528,1953650253811716096,1953650252754751488,1953650249671938048,1953650248812105728,1953650240800985088,1953650232546594816,1953650230126481408,1953650219888185344,1953650214423007232,1953650208207048704,1953650207221387264,1953650193979969536,1953650193183051776,1953650192721678336,1953650185926905856,1953650184135938048,1953650182525325312,1953650181971677184,1953650175961239552,1953650174174466048,1953650174115745792,1953650174094774272,1953650173486600192,1953650170282151936,1953650157317558272,1953650154616426496,1953650147200897024,1953650141203042304,1953650139026198528,1953650138401247232,1953650136421535744,1953650130100719616,1953650118633492480,1953650113281560576,1953650108667826176,1953650107199819776,1953650100098863104,1953650096487567360,1953650094109396992,1953650094092619776,1953650090695233536,1953650086748393472,1953650086492540928,1953650085745954816,1953650085532045312,1953650084034678784,1953650082369540096,1953650080737955840,1953650074563940352,1953650060282335232,1953650058990489600,1953650052015362048,1953650048806719488,1953650046621487104,1953650043156992000,1953650039864463360,1953650033933717504,1953650026631434240,1953650025792573440,1953650024542670848,1953650017672400896,1953650013423570944,1953650006947565568,1953650006763016192,1953650003227217920,1953650002434494464,1953650002421911552,1953650001859874816,1953650001306226688,1953649989889331200,1953649987674738688,1953649984189272064,1953649983493017600,1953649978342412288,1953649978057199616,1953649974760476672,1953649971556028416,1953649970763304960,1953649969039446016,1953649962685075456,1953649961053491200,1953649949405908992,1953649940664979456,1953649934017007616,1953649933433999360,1953649930946777088,1953649927243206656,1953649921694142464,1953649920632983552,1953649920108695552,1953649919768956928,1953649919320166400,1953649919257251840,1953649915104890880,1953649915096502272,1953649906863083520,1953649894594744320,1953649894292754432,1953649885967060992,1953649884335476736,1953649879671410688,1953649877117079552,1953649874243981312,1953649871823867904,1953649870641074176,1953649864995540992,1953649863590449152,1953649860079816704,1953649859534557184,1953649857902972928,1953649850307088384,1953649846314110976,1953649839976517632,1953649839930380288,1953649838504316928,1953649837497683968,1953649836793040896,1953649836214226944,1953649834054160384,1953649820640776192,1953649816714907648,1953649812256362496,1953649808380825600,1953649807764262912,1953649803838394368,1953649803662233600,1953649803188277248,1953649795734999040,1953649795407843328,1953649782304837632,1953649774524403712,1953649773387747328,1953649768098729984,1953649765875748864,1953649762147012608,1953649760339267584,1953649759504601088,1953649758158229504,1953649754152669184,1953649752017768448,1953649751514451968,1953649751459926016,1953649751187296256,1953649750306492416,1953649750050639872,1953649747882184704,1953649746653253632,1953649738797322240,1953649727678222336,1953649716596871168,1953649706564096000,1953649703590334464,1953649703305121792,1953649700465577984,1953649693343649792,1953649691896614912,1953649689946263552,1953649689921097728,1953649678139297792,1953649672082722816,1953649669306093568,1953649668249128960,1953649668098134016,1953649666160365568,1953649650469474304,1953649647776731136,1953649646589743104,1953649643829891072,1953649640256344064,1953649637727178752,1953649636577939456,1953649636141731840,1953649605951131648,1953649597663186944,1953649593854758912,1953649590901968896,1953649584581152768,1953649584253997056,1953649584014921728,1953649583197032448,1953649582484000768,1953649581733220352,1953649558542913536,1953649547633528832,1953649521066807296,1953649512418152448,1953649509041737728,1953649504713216000,1953649502012084224,1953649500997062656,1953649500929953792,1953649499067682816,1953649497314463744,1953649491291443200,1953649489714384896,1953649477995499520,1953649477085335552,1953649470991011840,1953649467492962304,1953649451235840000,1953649437797289984,1953649431166095360,1953649429521928192,1953649423566016512,1953649416871907328,1953649415420678144,1953649414925750272,1953649413600350208,1953649413260611584,1953649406323232768,1953649394012950528,1953649394004561920,1953649390145802240,1953649380557623296,1953649373028847616,1953649371330154496,1953649371359514624,1953649358579470336,1953649353831518208,1953649349729488896,1953649342246850560,1953649340057423872,1953649336609705984,1953649336374824960,1953649333749190656,1953649333115850752,1953649332667060224,1953649331215831040,1953649330943201280,1953649321141112832,1953649316057616384,1953649314581221376,1953649313339707392,1953649312790253568,1953649303256600576,1953649302866530304,1953649300668715008,1953649294926712832,1953649282519961600,1953649271652519936,1953649270356480000,1953649267563073536,1953649262911590400,1953649262836092928,1953649258067169280,1953649258058780672,1953649257769373696,1953649253449240576,1953649249376571392,1953649248801951744,1953649247451385856,1953649247174561792,1953649246797074432,1953649239364767744,1953649238161002496,1953649233668902912,1953649228535074816,1953649223233474560,1953649221085990912,1953649212961624064,1953649210226937856,1953649210063360000,1953649207815213056,1953649204589793280,1953649200521318400,1953649199959281664,1953649199204306944,1953649191256100864,1953649190744395776,1953649188831793152,1953649186663337984,1953649183718936576,1953649168451670016,1953649164861345792,1953649156120416256,1953649154522386433,1953649154253950976,1953649151632510976,1953649151229857792,1953649147295600640,1953649144414113792,1953649140018483200,1953649135815790592,1953649135362805760,1953649134817546240,1953649126147919872,1953649122343686144,1953649117029502976,1953649115003654144,1953649113778917376,1953649111291695104,1953649105214148608,1953649104283013120,1953649100520722432,1953649096783597568,1953649088923471872,1953649087866507264,1953649084066467840,1953649083542179840,1953649081772183552,1953649081260478464,1953649078374797312,1953649066886598656,1953649049966776320,1953649047911567360,1953649042962288640,1953649040722530304,1953649040500232192,1953649039334215680,1953649035584507904,1953649030693949440,1953649030480039936,1953649027078459392,1953649023441997824,1953649022628302848,1953649018740183040,1953649017284759552,1953649016852746240,1953649013652492288,1953649013354696704,1953649003078651904,1953648999400247296,1953648995445018624,1953648991405903872,1953648986834112512,1953648982925021184,1953648978978181120,1953648976130248704,1953648973655609344,1953648970237251584,1953648962305822720,1953648954324062208,1953648954185650176,1953648952629563392,1953648949076987904,1953648943632781312,1953648919985295360,1953648919335178240,1953648913966469120,1953648909679890432,1953648896786599936,1953648891979927552,1953648891833126912,1953648891677937664,1953648887135506432,1953648883146723328,1953648877190811648,1953648860556201984,1953648858299666432,1953648856835854336,1953648855879553024,1953648855447539712,1953648835583315968,1953648830642425856,1953648830235578368,1953648827748356096,1953648823986065408,1953648800896421888,1953648800862867457,1953648797436121088,1953648795825508352,1953648777148272640,1953648770978451456,1953648769300729856,1953648769023905792,1953648767446847488,1953648764812824576,1953648750933872640,1953648747825893376,1953648741635100672,1953648740649439232,1953648736140562432,1953648718901972992,1953648710148460544,1953648709921968128,1953648708642705408,1953648705660555264,1953648699314573312,1953648698165334016,1953648681899823104,1953648680415039488,1953648665911136256,1953648657849683968,1953648652480974848,1953648652162207744,1953648648559300608,1953648647791742976,1953648645136748544,1953648626950246400,1953648619924787200,1953648612769304576,1953648597766279168,1953648595572658176,1953648583182684160,1953648577302269952,1953648577130303488,1953648576014618624,1953648572600455168,1953648571790954496,1953648565616939008,1953648533140443136,1953648530456088576,1953648520360398848,1953648519827722240,1953648519169216512,1953648518846255104,1953648518707843072,1953648515109130240,1953648510747054080,1953648482624245760,1953648466652336128,1953648463221395456,1953648459987587072,1953648458964176896,1953648458725101568,1953648458620243968,1953648454925062144,1953648445634678784,1953648421550985216,1953648412315127808,1953648408422813696,1953648384620138496,1953648376407691264,1953648136984236032,1953648125521203200,1953648090049974272,1953648081275490304,1953648071431458816,1953648035071037440,1953648034152484864,1953648027269632000,1953648014560890880,1953647979156770816,1953647978083028992,1953647975100878848,1953647970650722304,1953647957719683072,1953647926077853696,1953647922466557952,1953647921875161088,1953647918469386240,1953647914149253120,1953647899360137216,1953647885208555520,1953647878589943808,1953647875045756928,1953647872562728960,1953647869798682624,1953647867391152128,1953647866090917888,1953647866090917889,1953647862211186688,1953647862097940480,1953647855529660416,1953647845220061184,1953647817772535808,1953647814161240064,1953647810877100032,1953647809950158848,1953647809224544256,1953647805319647232,1953647801783848960,1953647787879731200,1953647780833300480,1953647774252437504,1953647762739073024,1953647761019408384,1953647757915623424,1953647757844320256,1953647757722685440,1953647753171865600,1953647752580468736,1953647748650405888,1953647744237998080,1953647706237603840,1953647703523889152,1953647701758087168,1953647696854945792,1953647696515207168,1953647691997941760,1953647690416689152,1953647684905373696,1953647672469262336,1953647670187560960,1953647668128157696,1953647667121524736,1953647661916393472,1953647648695947264,1953647646619766784,1953647640210870272,1953647636079480832,1953647626575187968,1953647616680824832,1953647615300898816,1953647592920092672,1953647589979885568,1953647586288898048,1953647580597227520,1953647580509147136,1953647580140048384,1953647579871612928,1953647573043286016,1953647571873075200,1953647571378147328,1953647563425746944,1953647557348200448,1953647556056354816,1953647552252121088,1953647549303525376,1953647524037038080,1953647523651162112,1953647523168817152,1953647520161501184,1953647515711344640,1953647512297181184,1953647494999871488,1953647472468070400,1953647466763816960,1953647464733773824,1953647463475482624,1953647432513130496,1953647426481721344,1953647425470894080,1953647425194070016,1953647417182949376,1953647411289952256,1953647410123935744,1953647407569604608,1953647403060727808,1953647396949626880,1953647394332381184,1953647391291510784,1953647388430995456,1953647378352082944,1953647370944942080,1953647367606276096,1953647365970497536,1953647363017707520,1953647359196696576,1953647354104811520,1953647350657093632,1953647343644217344,1953647341937135616,1953647340485906432,1953647332059549696,1953647324266532864,1953647322135826432,1953647318755217408,1953647318486781952,1953647313348759552,1953647312782528512,1953647312744779776,1953647310580518912,1953647310433718272,1953647307170549760,1953647298987462656,1953647293614559232,1953647290993119232,1953647273670643712,1953647264262819840,1953647262778036224,1953647261813346304,1953647252934004736,1953647252720095232,1953647251445026816,1953647251092705280,1953647250929127424,1953647249486286848,1953647230834216960,1953647227944341504,1953647220319096832,1953647208814120960,1953647206293344256,1953647202082263040,1953647200350015488,1953647195623034880,1953647195539148800,1953647195388153856,1953647194750619648,1953647193676877824,1953647192221454336,1953647190715699200,1953647182788464640,1953647179349135360,1953647173753933824,1953647171195408384,1953647169962283008,1953647147027828736,1953647144062455808,1953647140031729664,1953647137666142208,1953647137246711808,1953647136399462400,1953647136235884544,1953647135707402240,1953647134348447744,1953647126924529664,1953647120201060352,1953647118208765952,1953647109820157952,1953647105311281152,1953647102610149376,1953647086608879616,1953647083601563648,1953647080778797056,1953647080657162240,1953647080371949568,1953647077893115904,1953647074353123328,1953647072276942848,1953647072109170688,1953647070993485824,1953647069865218048,1953647050307178496,1953647019462266880,1953647017314783232,1953647016111017984,1953647013254696960,1953647012826877952,1953647012520693760,1953647011556003840,1953646998071316480,1953646981763862528,1953646955545268224,1953646951413878784,1953646944539414528,1953646943205625856,1953646943117545472,1953646943083991040,1953646942664560640,1953646941813116928,1953646939007127552,1953646908216741888,1953646885420699648,1953646884330180608,1953646883877195776,1953646883793309696,1953646882765705216,1953646872602906624,1953646869700448256,1953646849370656768,1953646832622800896,1953646827195371520,1953646826956296192,1953646824762675200,1953646822237704192,1953646810485264384,1953646779032178688,1953646776725311488,1953646763802660864,1953646753916686336,1953646744085237760,1953646724111962112,1953646722853670912,1953646722627178496,1953646721285001216,1953646704293875712,1953646698430238720,1953646671045627904,1953646669321768960,1953646635184328704,1953646616632922112,1953646616561618944,1953646613311033344,1953646552673980416,1953646545401057280,1953646124955635712,1953646068227674112,1953646058538831872,1953646023612862464,1953646005996785664,1953645932273504256,1953645883200147456,1953645859808514048,1953645853613527040,1953645852665614336,1953645767718375424,1953645760705499136,1953645320152584192,1953645307238322176,1953645272702423040,1953645264552890368,1953645251516993536,1953645224094633984,1953645217018843136,1953645216486166528,1953645207250309120,1953645194839363584,1953645171573559296,1953645160488013824,1953645159544295424,1953645158214701056,1953645157552001024,1953645154255278080,1953645153374474240,1953645151252156416,1953645147968016384,1953645138346283008,1953645135544487936,1953645131220160512,1953645125834674176,1953645119476109312,1953645106020782080,1953645104196259840,1953645104057847808,1953645101746786304,1953645094696161280,1953645080448110592,1953645066074230784,1953645064258097152,1953645057614319616,1953645055055794176,1953645053793308672,1953645047258583040,1953645046465859584,1953645044242878464,1953645041814376448,1953645035703275520,1953645031739658240,1953645028069642240,1953645023376216064,1953645020784136192,1953645015457370112,1953645014253604864,1953645013704151040,1953645001033158656,1953644989544960000,1953644986877382656,1953644986319540224,1953644981458341888,1953644980535595008,1953644979935809536,1953644973786959872,1953644968070123520,1953644967004770304,1953644961271156736,1953644960470044672,1953644955495600128,1953644948310757376,1953644942166102016,1953644940551294976,1953644939574022144,1953644933920100352,1953644929880985600,1953644929516081152,1953644924734574592,1953644923887325184,1953644923069435904,1953644920787734528,1953644917671366656,1953644916815728640,1953644915221893120,1953644914160734208,1953644913288318976,1953644911841284096,1953644906275442688,1953644905981841408,1953644901472964608,1953644898000080896,1953644880451112960,1953644872247054336,1953644870611275776,1953644870254759936,1953644869923409920,1953644862130393088,1953644861769682944,1953644861513830400,1953644859802554368,1953644858875613184,1953644852995198976,1953644849761390592,1953644846926041088,1953644829574205440,1953644828072644608,1953644826432671744,1953644824276799488,1953644817943400448,1953644813988171776,1953644813996560384,1953644806354538496,1953644805612146688,1953644803791818752,1953644802411892736,1953644792995680256,1953644789690568704,1953644788834930688,1953644784841953280,1953644782396674048,1953644768526110720,1953644757365067776,1953644754856873984,1953644753820880896,1953644753086877696,1953644752206073856,1953644751493042176,1953644747114188800,1953644741506404352,1953644739828682752,1953644736586485760,1953644736301273088,1953644730945146880,1953644730194366464,1953644718664224768,1953644716428660736,1953644710598578176,1953644703438901248,1953644701983477760,1953644700846821376,1953644699596918784,1953644697965334528,1953644697688510464,1953644695184510976,1953644694718943232,1953644693431291904,1953644692290441216,1953644691128619008,1953644687328579584,1953644686766542848,1953644686485524480,1953644685587943424,1953644680730939392,1953644677174169600,1953644672623349760,1953644672585601024,1953644670215819264,1953644667791511552,1953644662775123968,1953644662225670144,1953644661600718848,1953644661290340352,1953644656181678080,1953644652700405760,1953644647553994752,1953644643703623680,1953644641061212160,1953644639408656384,1953644638259417088,1953644638032924672,1953644637558968320,1953644637319892992,1953644636120322048,1953644634358714368,1953644633377247232,1953644631707914240,1953644629283606528,1953644627836571648,1953644617921236992,1953644617073987584,1953644608886706176,1953644606256877568,1953644600166748160,1953644600045113344,1953644599306915840,1953644598442889216,1953644595532042240,1953644595213275136,1953644586157772800,1953644584962396160,1953644582634557440,1953644582299013120,1953644581808279552,1953644581602758656,1953644578662551552,1953644577798524928,1953644575974002688,1953644574346612736,1953644574258532352,1953644568105488384,1953644567178547200,1953644561172303872,1953644558458589184,1953644554348171264,1953644552171327488,1953644551286329344,1953644543619141632,1953644543556227072,1953644543447175168,1953644542662840320,1953644537491263488,1953644535847096320,1953644529580806144,1953644529396256768)) UNION ALL

SELECT [FK_ProductiveProcessID],[CollectValues],[CreateTime],[FK_CreateUserID],[IsDelete],[ModifyTime],[FK_ModifyUserID],[Sort],[Id] FROM [Ts_ProductiveCollects20250501] WITH(NOLOCK) WHERE ([FK_ProductiveProcessID] IN (1953650723515043840,1953650717282308096,1953650709925498880,1953650708491046912,1953650696923156480,1953650696294010880,1953650688559714304,1953650686663888896,1953650685736947712,1953650684214415360,1953650678602436608,1953650676090048512,1953650674622042112,1953650674550738944,1953650674227777536,1953650660378185728,1953650657098240000,1953650645249331200,1953650641088581632,1953650639821901824,1953650639830290432,1953650636361601024,1953650612114329600,1953650604396810240,1953650594691190784,1953650593671974912,1953650591759372288,1953650590538829824,1953650590379446272,1953650589989376000,1953650589825798144,1953650584805216256,1953650583110717440,1953650581596573696,1953650579658805248,1953650579285512192,1953650570993373184,1953650562818674688,1953650562697039872,1953650556892123136,1953650555721912320,1953650545882075136,1953650545416507392,1953650537967423488,1953650528886755328,1953650523476103168,1953650517012680704,1953650511832715264,1953650510314377216,1953650510272434176,1953650509962055680,1953650509790089216,1953650508825399296,1953650505604173824,1953650494040477696,1953650491226099712,1953650490622119936,1953650490529845248,1953650476722196480,1953650473819738112,1953650465821200384,1953650465632456704,1953650464986533888,1953650453963902976,1953650444040179712,1953650438956683264,1953650436209414144,1953650434468777984,1953650432648450048,1953650430605824000,1953650423446147072,1953650423295152128,1953650422829584384,1953650421038616576,1953650421017645056,1953650420552077312,1953650417658007552,1953650414860406784,1953650410099871744,1953650409772716032,1953650396518715392,1953650395080069120,1953650386989256704,1953650374662197248,1953650364910440448,1953650361961844736,1953650360758079488,1953650359134883841,1953650353032171520,1953650348523294720,1953650344249298944,1953650342974230528,1953650341577527296,1953650341074210816,1953650341065822208,1953650340159852544,1953650339065139200,1953650338863812608,1953650337714573312,1953650317674188800,1953650314834644992,1953650308887121920,1953650306060161024,1953650305443598336,1953650304415993856,1953650296681697280,1953650296627171328,1953650285835227136,1953650280588152832,1953650276687450112,1953650275143946240,1953650271159357440,1953650267942326272,1953650263253094400,1953650257599172608,1953650255619461120,1953650253887213568,1953650253845270528,1953650253811716096,1953650252754751488,1953650249671938048,1953650248812105728,1953650240800985088,1953650232546594816,1953650230126481408,1953650219888185344,1953650214423007232,1953650208207048704,1953650207221387264,1953650193979969536,1953650193183051776,1953650192721678336,1953650185926905856,1953650184135938048,1953650182525325312,1953650181971677184,1953650175961239552,1953650174174466048,1953650174115745792,1953650174094774272,1953650173486600192,1953650170282151936,1953650157317558272,1953650154616426496,1953650147200897024,1953650141203042304,1953650139026198528,1953650138401247232,1953650136421535744,1953650130100719616,1953650118633492480,1953650113281560576,1953650108667826176,1953650107199819776,1953650100098863104,1953650096487567360,1953650094109396992,1953650094092619776,1953650090695233536,1953650086748393472,1953650086492540928,1953650085745954816,1953650085532045312,1953650084034678784,1953650082369540096,1953650080737955840,1953650074563940352,1953650060282335232,1953650058990489600,1953650052015362048,1953650048806719488,1953650046621487104,1953650043156992000,1953650039864463360,1953650033933717504,1953650026631434240,1953650025792573440,1953650024542670848,1953650017672400896,1953650013423570944,1953650006947565568,1953650006763016192,1953650003227217920,1953650002434494464,1953650002421911552,1953650001859874816,1953650001306226688,1953649989889331200,1953649987674738688,1953649984189272064,1953649983493017600,1953649978342412288,1953649978057199616,1953649974760476672,1953649971556028416,1953649970763304960,1953649969039446016,1953649962685075456,1953649961053491200,1953649949405908992,1953649940664979456,1953649934017007616,1953649933433999360,1953649930946777088,1953649927243206656,1953649921694142464,1953649920632983552,1953649920108695552,1953649919768956928,1953649919320166400,1953649919257251840,1953649915104890880,1953649915096502272,1953649906863083520,1953649894594744320,1953649894292754432,1953649885967060992,1953649884335476736,1953649879671410688,1953649877117079552,1953649874243981312,1953649871823867904,1953649870641074176,1953649864995540992,1953649863590449152,1953649860079816704,1953649859534557184,1953649857902972928,1953649850307088384,1953649846314110976,1953649839976517632,1953649839930380288,1953649838504316928,1953649837497683968,1953649836793040896,1953649836214226944,1953649834054160384,1953649820640776192,1953649816714907648,1953649812256362496,1953649808380825600,1953649807764262912,1953649803838394368,1953649803662233600,1953649803188277248,1953649795734999040,1953649795407843328,1953649782304837632,1953649774524403712,1953649773387747328,1953649768098729984,1953649765875748864,1953649762147012608,1953649760339267584,1953649759504601088,1953649758158229504,1953649754152669184,1953649752017768448,1953649751514451968,1953649751459926016,1953649751187296256,1953649750306492416,1953649750050639872,1953649747882184704,1953649746653253632,1953649738797322240,1953649727678222336,1953649716596871168,1953649706564096000,1953649703590334464,1953649703305121792,1953649700465577984,1953649693343649792,1953649691896614912,1953649689946263552,1953649689921097728,1953649678139297792,1953649672082722816,1953649669306093568,1953649668249128960,1953649668098134016,1953649666160365568,1953649650469474304,1953649647776731136,1953649646589743104,1953649643829891072,1953649640256344064,1953649637727178752,1953649636577939456,1953649636141731840,1953649605951131648,1953649597663186944,1953649593854758912,1953649590901968896,1953649584581152768,1953649584253997056,1953649584014921728,1953649583197032448,1953649582484000768,1953649581733220352,1953649558542913536,1953649547633528832,1953649521066807296,1953649512418152448,1953649509041737728,1953649504713216000,1953649502012084224,1953649500997062656,1953649500929953792,1953649499067682816,1953649497314463744,1953649491291443200,1953649489714384896,1953649477995499520,1953649477085335552,1953649470991011840,1953649467492962304,1953649451235840000,1953649437797289984,1953649431166095360,1953649429521928192,1953649423566016512,1953649416871907328,1953649415420678144,1953649414925750272,1953649413600350208,1953649413260611584,1953649406323232768,1953649394012950528,1953649394004561920,1953649390145802240,1953649380557623296,1953649373028847616,1953649371330154496,1953649371359514624,1953649358579470336,1953649353831518208,1953649349729488896,1953649342246850560,1953649340057423872,1953649336609705984,1953649336374824960,1953649333749190656,1953649333115850752,1953649332667060224,1953649331215831040,1953649330943201280,1953649321141112832,1953649316057616384,1953649314581221376,1953649313339707392,1953649312790253568,1953649303256600576,1953649302866530304,1953649300668715008,1953649294926712832,1953649282519961600,1953649271652519936,1953649270356480000,1953649267563073536,1953649262911590400,1953649262836092928,1953649258067169280,1953649258058780672,1953649257769373696,1953649253449240576,1953649249376571392,1953649248801951744,1953649247451385856,1953649247174561792,1953649246797074432,1953649239364767744,1953649238161002496,1953649233668902912,1953649228535074816,1953649223233474560,1953649221085990912,1953649212961624064,1953649210226937856,1953649210063360000,1953649207815213056,1953649204589793280,1953649200521318400,1953649199959281664,1953649199204306944,1953649191256100864,1953649190744395776,1953649188831793152,1953649186663337984,1953649183718936576,1953649168451670016,1953649164861345792,1953649156120416256,1953649154522386433,1953649154253950976,1953649151632510976,1953649151229857792,1953649147295600640,1953649144414113792,1953649140018483200,1953649135815790592,1953649135362805760,1953649134817546240,1953649126147919872,1953649122343686144,1953649117029502976,1953649115003654144,1953649113778917376,1953649111291695104,1953649105214148608,1953649104283013120,1953649100520722432,1953649096783597568,1953649088923471872,1953649087866507264,1953649084066467840,1953649083542179840,1953649081772183552,1953649081260478464,1953649078374797312,1953649066886598656,1953649049966776320,1953649047911567360,1953649042962288640,1953649040722530304,1953649040500232192,1953649039334215680,1953649035584507904,1953649030693949440,1953649030480039936,1953649027078459392,1953649023441997824,1953649022628302848,1953649018740183040,1953649017284759552,1953649016852746240,1953649013652492288,1953649013354696704,1953649003078651904,1953648999400247296,1953648995445018624,1953648991405903872,1953648986834112512,1953648982925021184,1953648978978181120,1953648976130248704,1953648973655609344,1953648970237251584,1953648962305822720,1953648954324062208,1953648954185650176,1953648952629563392,1953648949076987904,1953648943632781312,1953648919985295360,1953648919335178240,1953648913966469120,1953648909679890432,1953648896786599936,1953648891979927552,1953648891833126912,1953648891677937664,1953648887135506432,1953648883146723328,1953648877190811648,1953648860556201984,1953648858299666432,1953648856835854336,1953648855879553024,1953648855447539712,1953648835583315968,1953648830642425856,1953648830235578368,1953648827748356096,1953648823986065408,1953648800896421888,1953648800862867457,1953648797436121088,1953648795825508352,1953648777148272640,1953648770978451456,1953648769300729856,1953648769023905792,1953648767446847488,1953648764812824576,1953648750933872640,1953648747825893376,1953648741635100672,1953648740649439232,1953648736140562432,1953648718901972992,1953648710148460544,1953648709921968128,1953648708642705408,1953648705660555264,1953648699314573312,1953648698165334016,1953648681899823104,1953648680415039488,1953648665911136256,1953648657849683968,1953648652480974848,1953648652162207744,1953648648559300608,1953648647791742976,1953648645136748544,1953648626950246400,1953648619924787200,1953648612769304576,1953648597766279168,1953648595572658176,1953648583182684160,1953648577302269952,1953648577130303488,1953648576014618624,1953648572600455168,1953648571790954496,1953648565616939008,1953648533140443136,1953648530456088576,1953648520360398848,1953648519827722240,1953648519169216512,1953648518846255104,1953648518707843072,1953648515109130240,1953648510747054080,1953648482624245760,1953648466652336128,1953648463221395456,1953648459987587072,1953648458964176896,1953648458725101568,1953648458620243968,1953648454925062144,1953648445634678784,1953648421550985216,1953648412315127808,1953648408422813696,1953648384620138496,1953648376407691264,1953648136984236032,1953648125521203200,1953648090049974272,1953648081275490304,1953648071431458816,1953648035071037440,1953648034152484864,1953648027269632000,1953648014560890880,1953647979156770816,1953647978083028992,1953647975100878848,1953647970650722304,1953647957719683072,1953647926077853696,1953647922466557952,1953647921875161088,1953647918469386240,1953647914149253120,1953647899360137216,1953647885208555520,1953647878589943808,1953647875045756928,1953647872562728960,1953647869798682624,1953647867391152128,1953647866090917888,1953647866090917889,1953647862211186688,1953647862097940480,1953647855529660416,1953647845220061184,1953647817772535808,1953647814161240064,1953647810877100032,1953647809950158848,1953647809224544256,1953647805319647232,1953647801783848960,1953647787879731200,1953647780833300480,1953647774252437504,1953647762739073024,1953647761019408384,1953647757915623424,1953647757844320256,1953647757722685440,1953647753171865600,1953647752580468736,1953647748650405888,1953647744237998080,1953647706237603840,1953647703523889152,1953647701758087168,1953647696854945792,1953647696515207168,1953647691997941760,1953647690416689152,1953647684905373696,1953647672469262336,1953647670187560960,1953647668128157696,1953647667121524736,1953647661916393472,1953647648695947264,1953647646619766784,1953647640210870272,1953647636079480832,1953647626575187968,1953647616680824832,1953647615300898816,1953647592920092672,1953647589979885568,1953647586288898048,1953647580597227520,1953647580509147136,1953647580140048384,1953647579871612928,1953647573043286016,1953647571873075200,1953647571378147328,1953647563425746944,1953647557348200448,1953647556056354816,1953647552252121088,1953647549303525376,1953647524037038080,1953647523651162112,1953647523168817152,1953647520161501184,1953647515711344640,1953647512297181184,1953647494999871488,1953647472468070400,1953647466763816960,1953647464733773824,1953647463475482624,1953647432513130496,1953647426481721344,1953647425470894080,1953647425194070016,1953647417182949376,1953647411289952256,1953647410123935744,1953647407569604608,1953647403060727808,1953647396949626880,1953647394332381184,1953647391291510784,1953647388430995456,1953647378352082944,1953647370944942080,1953647367606276096,1953647365970497536,1953647363017707520,1953647359196696576,1953647354104811520,1953647350657093632,1953647343644217344,1953647341937135616,1953647340485906432,1953647332059549696,1953647324266532864,1953647322135826432,1953647318755217408,1953647318486781952,1953647313348759552,1953647312782528512,1953647312744779776,1953647310580518912,1953647310433718272,1953647307170549760,1953647298987462656,1953647293614559232,1953647290993119232,1953647273670643712,1953647264262819840,1953647262778036224,1953647261813346304,1953647252934004736,1953647252720095232,1953647251445026816,1953647251092705280,1953647250929127424,1953647249486286848,1953647230834216960,1953647227944341504,1953647220319096832,1953647208814120960,1953647206293344256,1953647202082263040,1953647200350015488,1953647195623034880,1953647195539148800,1953647195388153856,1953647194750619648,1953647193676877824,1953647192221454336,1953647190715699200,1953647182788464640,1953647179349135360,1953647173753933824,1953647171195408384,1953647169962283008,1953647147027828736,1953647144062455808,1953647140031729664,1953647137666142208,1953647137246711808,1953647136399462400,1953647136235884544,1953647135707402240,1953647134348447744,1953647126924529664,1953647120201060352,1953647118208765952,1953647109820157952,1953647105311281152,1953647102610149376,1953647086608879616,1953647083601563648,1953647080778797056,1953647080657162240,1953647080371949568,1953647077893115904,1953647074353123328,1953647072276942848,1953647072109170688,1953647070993485824,1953647069865218048,1953647050307178496,1953647019462266880,1953647017314783232,1953647016111017984,1953647013254696960,1953647012826877952,1953647012520693760,1953647011556003840,1953646998071316480,1953646981763862528,1953646955545268224,1953646951413878784,1953646944539414528,1953646943205625856,1953646943117545472,1953646943083991040,1953646942664560640,1953646941813116928,1953646939007127552,1953646908216741888,1953646885420699648,1953646884330180608,1953646883877195776,1953646883793309696,1953646882765705216,1953646872602906624,1953646869700448256,1953646849370656768,1953646832622800896,1953646827195371520,1953646826956296192,1953646824762675200,1953646822237704192,1953646810485264384,1953646779032178688,1953646776725311488,1953646763802660864,1953646753916686336,1953646744085237760,1953646724111962112,1953646722853670912,1953646722627178496,1953646721285001216,1953646704293875712,1953646698430238720,1953646671045627904,1953646669321768960,1953646635184328704,1953646616632922112,1953646616561618944,1953646613311033344,1953646552673980416,1953646545401057280,1953646124955635712,1953646068227674112,1953646058538831872,1953646023612862464,1953646005996785664,1953645932273504256,1953645883200147456,1953645859808514048,1953645853613527040,1953645852665614336,1953645767718375424,1953645760705499136,1953645320152584192,1953645307238322176,1953645272702423040,1953645264552890368,1953645251516993536,1953645224094633984,1953645217018843136,1953645216486166528,1953645207250309120,1953645194839363584,1953645171573559296,1953645160488013824,1953645159544295424,1953645158214701056,1953645157552001024,1953645154255278080,1953645153374474240,1953645151252156416,1953645147968016384,1953645138346283008,1953645135544487936,1953645131220160512,1953645125834674176,1953645119476109312,1953645106020782080,1953645104196259840,1953645104057847808,1953645101746786304,1953645094696161280,1953645080448110592,1953645066074230784,1953645064258097152,1953645057614319616,1953645055055794176,1953645053793308672,1953645047258583040,1953645046465859584,1953645044242878464,1953645041814376448,1953645035703275520,1953645031739658240,1953645028069642240,1953645023376216064,1953645020784136192,1953645015457370112,1953645014253604864,1953645013704151040,1953645001033158656,1953644989544960000,1953644986877382656,1953644986319540224,1953644981458341888,1953644980535595008,1953644979935809536,1953644973786959872,1953644968070123520,1953644967004770304,1953644961271156736,1953644960470044672,1953644955495600128,1953644948310757376,1953644942166102016,1953644940551294976,1953644939574022144,1953644933920100352,1953644929880985600,1953644929516081152,1953644924734574592,1953644923887325184,1953644923069435904,1953644920787734528,1953644917671366656,1953644916815728640,1953644915221893120,1953644914160734208,1953644913288318976,1953644911841284096,1953644906275442688,1953644905981841408,1953644901472964608,1953644898000080896,1953644880451112960,1953644872247054336,1953644870611275776,1953644870254759936,1953644869923409920,1953644862130393088,1953644861769682944,1953644861513830400,1953644859802554368,1953644858875613184,1953644852995198976,1953644849761390592,1953644846926041088,1953644829574205440,1953644828072644608,1953644826432671744,1953644824276799488,1953644817943400448,1953644813988171776,1953644813996560384,1953644806354538496,1953644805612146688,1953644803791818752,1953644802411892736,1953644792995680256,1953644789690568704,1953644788834930688,1953644784841953280,1953644782396674048,1953644768526110720,1953644757365067776,1953644754856873984,1953644753820880896,1953644753086877696,1953644752206073856,1953644751493042176,1953644747114188800,1953644741506404352,1953644739828682752,1953644736586485760,1953644736301273088,1953644730945146880,1953644730194366464,1953644718664224768,1953644716428660736,1953644710598578176,1953644703438901248,1953644701983477760,1953644700846821376,1953644699596918784,1953644697965334528,1953644697688510464,1953644695184510976,1953644694718943232,1953644693431291904,1953644692290441216,1953644691128619008,1953644687328579584,1953644686766542848,1953644686485524480,1953644685587943424,1953644680730939392,1953644677174169600,1953644672623349760,1953644672585601024,1953644670215819264,1953644667791511552,1953644662775123968,1953644662225670144,1953644661600718848,1953644661290340352,1953644656181678080,1953644652700405760,1953644647553994752,1953644643703623680,1953644641061212160,1953644639408656384,1953644638259417088,1953644638032924672,1953644637558968320,1953644637319892992,1953644636120322048,1953644634358714368,1953644633377247232,1953644631707914240,1953644629283606528,1953644627836571648,1953644617921236992,1953644617073987584,1953644608886706176,1953644606256877568,1953644600166748160,1953644600045113344,1953644599306915840,1953644598442889216,1953644595532042240,1953644595213275136,1953644586157772800,1953644584962396160,1953644582634557440,1953644582299013120,1953644581808279552,1953644581602758656,1953644578662551552,1953644577798524928,1953644575974002688,1953644574346612736,1953644574258532352,1953644568105488384,1953644567178547200,1953644561172303872,1953644558458589184,1953644554348171264,1953644552171327488,1953644551286329344,1953644543619141632,1953644543556227072,1953644543447175168,1953644542662840320,1953644537491263488,1953644535847096320,1953644529580806144,1953644529396256768)) ) unionTable

热忱回答（6）

fate sta VIP0
2025/8/27

0 回复
fate sta VIP0
2025/8/27

可以用这种方式实现高性能分表。

0 回复
贝壳里的心 VIP0
2025/8/27

@fate sta：可我的目的至少未了查询分页数据，你这样的方式至少用来统计了总条数，对于我需要查询第n条到n+1000条数数据，依然存在问题

0 回复
fate sta VIP0
2025/8/27

@贝壳里的心：聚合查出count不就统计出来了吗

0 回复
fate sta VIP0
2025/8/27

一样可以的。只是写些算法

0 回复
fate sta VIP0
2025/8/27

每个表count是多少就查哪几个表

0 回复

首页 > SqlSugar

分表进行分页查询时，由于CollectValues是json字符串，导致PC的磁盘读写达到600M/s,查询时间太长 返回

热忱回答（6）

分表进行分页查询时，由于CollectValues是json字符串，导致PC的磁盘读写达到600M/s,查询时间太长返回