Gorm [Preloading] Many Input Values to Preloaded Relationships Fail to Load

Description

I'd include a Go Playground if this was easy to setup, its not.

This is a bit of a strange one. I've been using gorm widely and successfully for a few years now, thank you for your work. I'm curious if you've seen this one before @jinzhu or if any ideas come to mind. Any insight is appreciated! <3

I have an API where I can deeply and recursively load relationships and have successfully been able to do so with large amounts of data.

I have ran into an issue which seems to be related to the amount of inputs to an IN() query not processing. When I bring the query limit down, I get the result, thus less items requested from the table. If I run the query raw against the database, I get all the items I expect and its only 5,245 entries - so the issue seems more related to the amount of inputs rather than the outputs

Example (Whole Request)

spawn2 is the main table, the rest of the tables are from preloading

items is the problem table showing 0 rows returned with many inputs

2022/06/18 02:12:55 
[3.192ms] [rows:0] SELECT * FROM `items` WHERE `items`.`id` IN (95842,95843,95861,95862,95863,95864,95865,95866,95867,95868,95869,95870,95871,95872,95885,95889,95893,95897,95901,95905,95909,95913,95917,95921,95925,95929,95933,95937,95940,95943,95946,95949,95952,95955,95958,95961,95964,95967,95970,95973,95976,95979,95982,95985,95988,95991,95994,95997,96000,96003,96006,96009,96012,96015,96018,96021,96927,95839,95840,95841,95849,95850,95851,95852,95853,95854,95855,95856,95857,95858,95859,95860,95887,95888,95891,95892,95895,95896,95899,95900,95903,95904,95907,95908,95911,95912,95915,95916,95919,95920,95923,95924,95927,95928,95931,95932,95935,95936,95939,95942,95945,95948,95951,95954,95957,95960,95963,95966,95969,95972,95975,95978,95981,95984,95987,95990,95993,95996,95999,96002,96005,96008,96011,96014,96017,96020,96926,9181,14800,14801,14802,14803,14804,17877,22535,29513,18518,18483,18484,18479,18480,18481,18482,18485,18486,18584,18585,18581,18582,18583,18586,18587,18588,18589,18475,18476,18477,18478,18574,18444,18445,18446,18447,18448,18471,13100,13101,13102,17048,18948,22700,22701,22702,22987,12004,12005,12028,12029,12030,12031,12032,12033,12034,12035,12064,12091,10001,10011,10015,10016,10017,10018,10019,10020,10021,10022,10023,10024,10025,10026,10027,10028,10029,10030,10031,10032,10033,10034,10035,16010,16017,16500,16501,16502,16503,16598,17912,18926,29351,35957,35958,35959,35960,36439,37798,37799,37800,37801,37802,37803,37956,37957,37958,41240,48944,48945,48946,48947,48948,48949,48950,51171,60917,63229,63230,63231,63232,63233,63234,63235,63236,63237,63238,63239,63240,63241,63242,63243,63244,67704,75850,75851,81843,95805,95806,95807,95808,95809,95810,95811,95812,95813,95814,95815,95816,95817,95818,95819,95820,95821,95822,95823,95824,95825,95826,95836,95837,129760,135564,22033,22034,22035,22036,22037,22038,22039,22040,22041,22042,22043,22224,34467,34468,34469,34470,34471,34472,34473,34474,34475,34476,34477,34478,34479,34480,34481,34522,34523,34524,34525,34526,34527,34528,34529,34530,34531,34532,34533,34534,34535,34536,34537,34538,34539,34540,34541,34542,34543,34544,34545,34546,113372,135309,22200,22201,22202,22203,22204,22205,22206,22207,22208,22209,22210,22211,22212,22213,22214,22215,22216,22217,22218,22219,22220,22221,22222,22223,12012,12013,12019,12027,12057,12061,12062,12063,12068,12069,12070,12077,29780,33305,8080,8081,8082,8083,8084,8085,8086,8087,8088,8089,8090,10917,17762,18116,29992,30471,75849,16826,16827,16842,16965,16966,16967,16980,16981,16982,16992,16993,17904,18143,72087,72098,72099,72164,72165,72166,72167,72168,72169,72170,72171,72172,72173,72174,72175,72176,72177,72178,72179,72180,72181,72182,72183,75852,11802,16898,16971,16975,17173,24080,44499,44500,44531,44532,44533,44534,44535,44536,44537,44538,44539,44540,44541,44542,44543,44544,44545,44701,44702,44703,44704,44705,44706,44707,44708,44709,44710,44711,44712,44713,44714,44715,44731,44732,44733,44734,44735,44736,44737,44738,44739,44740,44741,44742,44743,44744,44745,44746,44747,44748,44749,44750,44751,44761,44762,44763,44764,44765,44766,44776,44777,44778,44779,44780,44781,44782,44783,44784,44785,44786,44787,44788,44789,44790,44791,44792,44793,44794,44795,44796,44797,44798,44799,44800,44801,44802,44803,44804,44805,44806,44807,44808,44809,44810,44811,44812,44813,44814,44815,44816,44817,44818,44819,44820,44821,44822,44823,44824,44825,44826,44836,44837,44838,44839,44840,44841,44851,44852,44853,44854,44855,44856,44866,44867,44868,44878,44879,44880,44901,44902,44903,44904,44905,44906,44907,44908,44979,44980,44981,44982,44983,47571,56909,88726,124639,124640,124641,124649,124651,14224,14225,14226,14228,14234,14235,14236,14237,14239,14240,14241,14242,14243,14244,14245,14246,14247,14248,14249,17901,45225,45226,45227,45228,45229,45230,45231,81838,81839,13006,13547,13976,13977,13979,17007,17906,96811,16590,16591,16593,16595,16596,16597,18196,67393,67394,6179,16565,16580,16599,29790,37977,37978,41237,41238,16592,75847,75848,81841,83516,17764,16895,16909,16910,16911,16912,16950,16951,16952,16953,16954,16955,16956,16957,16958,16959,16960,16961,16963,16964,21349,92974,92975,92976,92977,16900,16901,16902,16903,16906,16907,16908,16968,16969,16970,17882,18114,21625,40586,41241,41811,41812,41813,45931,45932,45933,45934,45935,45936,48893,48894,48895,48896,48897,48898,48899,48900,48901,48902,48903,48904,48905,48906,96892,96893,96894,96895,96896,96897,96898,96899,96900,96901,96902,96903,96904,96905,96906,124293,124294,124295,124296,124297,124298,124299,124300,124301,124302,124303,124304,124305,124306,124307,124308,6027,7052,10062,10464,10465,10466,10467,10489,10500,10501,10502,12003,12006,12007,12008,12009,12010,12036,12037,12038,12039,12040,12041,12042,12043,12044,12045,12046,12047,12048,12049,12050,12051,12052,12053,12056,12060,12065,12066,12071,12092,12093,18089,18112,18113,18194,22000,22001,22002,22003,22004,22005,22006,22007,22008,22018,22019,22020,22021,22022,22023,22024,22025,22026,22027,22028,22030,22031,22044,22045,22046,22047,22048,22049,22050,22051,22052,22053,22054,22055,22056,22058,22059,22060,22061,22062,22063,22064,22065,22066,22067,22068,22069,22070,22071,22072,22073,22074,22075,22076,22077,22078,22079,22080,22081,22082,22083,22084,22085,22086,22087,22088,22089,22090,22091,22100,22101,22133,29546,30488,41247,41248,41249,41250,41251,48909,48910,48911,48912,48913,48914,48915,48916,48917,48918,48919,48920,48921,48922,48923,48924,48925,48926,48927,48928,48929,48930,48931,48932,48933,48934,48935,48936,50883,58682,58781,58782,60912,60913,60914,60915,62479,62516,62517,62518,62519,62520,62521,62522,63218,63219,63220,63221,63222,63223,63224,63225,63226,63227,63228,65261,72017,72054,75853,81842,81848,81849,81850,81851,81852,93659,93664,129755,129756,129757,129758,135559,135560,135561,135562,60757,9730,13002,13003,13005,13007,13008,13009,13015,13087,36106,36108,18104,18105,18106,18107,18109,18111,18119,18120,18121,18122,18126,18127,18128,18129,8160,8348,9257,12015,12016,12017,12018,12020,12021,12022,12023,12024,12025,12026,12058,12059,12067,12361,12447,12678,13004,13014,13016,13017,13018,13019,13020,13030,13031,13032,13033,13034,13035,13036,13037,13038,13039,13040,13052,13107,13193,13194,13404,13405,13406,13408,13412,13425,13426,13427,13428,13429,13975,14220,14238,14514,15961,16834,17947,18487,19151,19152,25759,29742,30517,30521,30794,30795,30796,33623,33631,40904,41239,45540,58280,58281,58282,58283,58284,58285,58286,58287,72090,75845,75846,75856,81840,92982,92983,92984,92985,98218,98219,98220,98226,98250,12087,12088,12089,12094,12095,12096,12097,13801,13802,13803,13804,13805,13806,13807,13808,13809,13810,13811,13812,16361,16479,17768,17880,17908,18100,18101,18102,18117,18149,18280,34264,34279,34294,34309,34324,34339,34354,34482,34483,34484,34485,34486,34487,34488,34489,34490,34491,34492,34493,34494,34495,34496,34497,34498,34499,34500,34501,34502,34503,34504,34505,34506,34507,34508,34509,34510,34511,34512,34513,34514,34515,34516,34517,34518,34519,34520,34521,34547,34548,34914,38387,38388,38389,48156,48157,48937,48938,48939,48940,48941,48942,48943,49909,60916,63837,63838,63839,63840,63845,63846,63847,63848,63849,63850,63859,65124,65125,65126,67646,75854,77592,77683,81692,81836,81845,81846,81847,92973,93425,113373,124620,124621,124622,124623,124624,124625,124626,124627,124628,124629,124630,129759,135310,135563,9729,13106,18516,18621,18626,18627,18628,33440,33441,33442,33443,33444,33445,33446,33447,37474,37475,37476,48158,48159,48160,48161,81837,93441,93442,93443,93444,112501,112502,123366,123367,134550,134551,24075,3637,8159,13799,18279,29354,29355,36398,38340,38939,38940,38941,62858,65469,65470,81844,96922,96923,98463,9731,9962,13068,13080,17355,40640,96952,8050,8051,8052,8055,8056,8057,8060,8061,8062,8063,8064,8065,8066,8067,8068,8069,10763,18115,38511,38512,38513,38514,38515,45168,45169,45170,45171,45172,45173,45174,45175,60763,93620,93623,129602,135406,14214,14215,14216,14217,14218,14219,14221,14222,14223,14227,14229,14230,14231,14232,14233,32244,32245,57111,57112,57113,57114,57115,57116,57125,64658,64659,64660,64661,64662,64663,64672,135383,135384,135385,135386,135387,135388,135397,10456,16850,16852,16894,17902,18118,18147,34029,34033,41233,41234,41235,41236,72018,72048,72051,75855,4001,4004,7471,7483,7485,7486,7487,12000,13010,16851,16854,16855,16856,16857,16858,16859,16860,16861,16862,16882,16888,16890,16891,16892,18123,18124,18346,18999,38595,38596,62493,62494,62495,62496,62497,62498,62499,65450,65451,65452,65453,81853,97893,97894,97895,97896,97901,97902,97903,97904,97905,97925,93172,14519,93170,14510,14518,14524,10073,14517,93169,14511,93171,13082,14515,14516,14007,93167,14512,93168,14402,17001,66200,66201,66220,66221,41299,78017,59973,17709,66412,66390,66391,66330,66331,66332,78020,66333,66334,66335,76050,66337,66392,66410,66338,59910,77294,77292,41269,77284,76033,77293,43564,77982,66210,66211,41288,66320,66321,66260,66261,66262,66263,78021,66264,66265,66322,66266,66267,66268,76051,66269,66323,66270,59912,77289,77291,41270,77285,76034,77290,77984,43565,66231,76037,76021,66230,77856,66434,18598,18593,18594,18595,18596,18597,18555,18556,18557,18490,18491,18590,18591,18592,79218,79217,15387,15544,59523,15261,15545,15547,27971,15065,15467,15546,15548,59658,15461,15462,15464,19471,36380,59670,59682,15528,15562,7653,26968,15022,36365,36366,15054,15205,15288,15372,15373,15374,15051,15378,15230,15375,15036,15080,15376,15379,15477,15246,15377,15232,15354,15323,15380,15656,15234,15381,15383,7651,15048,15529,15035,15085,15382,15236,59657,15305,15385,59669,59681,15309,15386,15657,15038,15042,15500,15679,36364,15131,19541,15458,15542,23486,7652,15503,15541,15578,15108,15543,36367,36377,36378,36379,27966,79219,59844,77179,77178,77182,77180,77191,26944,28413,28437,28438,28439,76043,21662,28440,28441,28442,77654,59528,28414,28445,28446,28448,59629,26940,28415,28444,77181,77271,77655,77184,77183,77188,77185,77186,41296,77189,36386,77194,77190,77196,77193,76027,41298,79457,77195,77187,77198,36374,77197,77192,41297,43575,78010,78008,79213,79212,79211,28447,36385,59624,59627,77656,79458,21663,26942,28443,28450,36373,59843,59845,19342,19344,36384,19343,19345,19415,19422,19469,19470,36372,30426,7660,19525,19526,59995,79216,79215,79214,19318,77931,77929,78035,78033,19295,19315,19316,19317,19319,19320,19321,19474,59021,59994,59878,19207,19322,19323,77659,36383,19300,19324,19325,19326,7657,26969,59628,59880,36371,19327,19328,19329,19330,30406,59992,77661,77932,78029,78036,19331,19332,19333,7658,19334,19335,19336,19411,59626,59879,19337,19338,19339,19414,7659,59631,77660,19340,19341,15394,19486,36369,59020,15023,15660,19485,27974,15109,15605,19488,30399,15073,15659,19487,30425,15067,19489,36382,30421,59630,15733,19509,7655,26978,15666,15674,19510,15606,15612,15755,19511,15731,16240,19512,15732,27979,59625,36370,30422,19534,19429,19475,30423,19539,15466,15568,15465,15468,15602,15899,15563,15636,59521,26976,15459,15470,15561,59547,15579,19540,27968,27976,15393,15471,36368,15463,30419,15469,15564,15603,19434,30417,15066,15565,30418,27973,59659,15049,15658,15861,36381,19513,59671,59683,15460,15566,19477,7654,59524,15567,15752,19430,19476,15084,15539,15604,19478,19514,26977,15132,19515,30420,27969,27978,15277,7621,15017,15278,59610,15255,15284,15227,15280,15283,15086,15281,15505,59666,15640,15649,15146,15149,15220,15096,15437,15424,15144,15265,15508,59667,15061,15434,59691,59679,59611,15245,15349,7623,15282,59690,59678,15345,15365,15308,26970,7622,15526,15580,15110,15147,15148,15012,15228,15511,15040,15093,15200,15201,15213,15225,15266,15267,15203,15211,15272,15269,15274,15075,15271,15275,15224,15270,15050,15276,15279,15079,15212,15238,15226,77144,77145,76025,41280,77151,77154,77153,77147,77152,77139,21660,21661,21695,26945,28491,28492,28493,28494,15172,21691,28495,28496,28497,28498,28499,28531,21693,26910,26911,26912,26913,26914,26946,59615,26915,26916,26917,26918,26919,59838,59837,59839,77133,77131,77132,77129,77130,77136,77149,77128,28487,28488,28489,28490,28523,76041,41279,43573,78004,78002,77143,77141,77142,77137,77138,77135,77134,77140,41278,77302,77150,77146,77148,19274,19275,19276,19507,30431,78027,15171,15133,19277,19278,7628,19279,19280,19281,19282,77867,19283,19284,19285,19286,19473,2483,7629,19528,19287,19288,19289,19290,66281,19291,19292,19293,19491,30432,7630,15009,19265,19523,19238,19243,19266,7626,19520,59525,19267,19268,19269,19270,19271,19272,19273,7627,19522,26961,59614,15160,15431,15111,15164,15260,15167,15509,59668,30427,59612,59609,59692,59680,15062,30428,15384,15438,15039,15046,15095,7624,15155,15435,15577,15507,15527,15754,19542,36012,15134,15145,15152,15153,15168,19502,15154,15163,15165,15170,15389,30429,15064,15158,59613,15510,59013,15166,15337,15159,7625,15156,26960,15098,15112,15157,15032,15436,28544,19264,30430,77866,15060,15506,15150,15151,15015,15162,15884,15885,15886,15891,15895,59542,59545,59548,59549,59555,59608,15063,15161,15326,15031,59972,15221,15342,15235,15340,15343,15491,15341,15347,7671,15344,15229,28216,15351,15502,7672,15346,15352,15218,15209,15355,15357,15359,15362,7673,15366,15006,30411,26920,26924,77848,15456,26921,26925,26937,77839,21633,21651,26922,26923,15443,30414,21632,21634,59592,21635,26926,26927,26928,59841,59840,59842,77065,77067,77066,77849,77069,77840,77070,77072,77068,77073,77078,77074,77071,41284,77079,77076,77075,77077,41285,77082,77080,77081,43568,77990,15442,15448,7675,7676,59005,15451,24541,15059,15364,7677,26950,59591,59594,15524,15662,19431,19490,24545,30459,7678,77847,15454,15525,19307,77838,15495,7679,19532,15453,24542,15447,15661,15853,24546,30460,7680,15446,15363,15360,15445,19506,15492,15522,59590,24539,26948,15003,30457,15367,15370,7674,15440,15233,24543,15090,59006,24540,15127,15452,15414,15478,15441,24544,15692,59593,26949,15117,15199,30458,15263,15250,15256,15264,59971,15239,15240,7691,15242,15026,15237,7692,15515,15092,15247,15249,15252,15241,15248,15254,15091,19232,19245,76038,15356,15665,21627,21628,19234,19249,26931,26943,21626,26929,26930,59588,19251,7617,19529,21655,26932,59835,59836,59834,77048,77047,77049,77052,77050,77053,77051,77054,77055,77056,77677,41282,77059,77058,77060,77057,76022,77063,77061,77062,43570,77994,15490,15519,30464,7700,15512,30476,15057,7696,59008,15430,15259,15422,7697,30463,30477,59589,15426,7698,15432,7699,59587,15423,19426,15268,15655,7693,26952,15516,15513,15115,15517,30461,15419,7694,15421,21960,26951,59007,59585,15518,15129,15078,15076,15034,15425,7695,15691,59586,19433,30462,15210,15208,7681,15202,7682,15223,15011,15215,59580,15219,23480,15037,15485,15501,19204,21631,21652,26933,26941,19211,26934,26939,19224,21649,21654,26935,19219,77031,77029,77030,77032,77033,77034,77042,77036,77035,77039,41286,77038,77041,77037,77040,41287,77045,77044,77043,43567,77988,21653,26936,26938,59584,59833,59832,59831,77028,15124,15504,59004,19505,59527,7687,23484,19432,30455,59582,78023,15044,7688,15488,7689,59583,15392,19500,15020,15314,19209,30456,7690,15391,26964,15123,15047,7685,59003,15693,15487,30454,23482,15486,59581,7684,15089,30453,15043,15018,15312,7686,15019,15207,15045,23483,26965,15368,23481,7683,15216,59672,59684,15371,15369,7642,15855,15331,15338,15339,15348,15196,15642,15698,15413,15204,15857,15859,15549,15449,59661,15493,59673,59685,15641,15353,15358,15361,15854,15856,7641,59660,59828,59830,77157,77159,77846,77158,77168,77161,77160,77167,77156,77834,77166,77162,77163,77274,41266,77172,77165,77171,77164,77173,76026,41267,77169,77174,77170,77176,77175,41265,78016,78014,43577,21638,21640,28417,28426,77845,76042,28418,28419,28454,77833,21694,28420,28421,28422,59621,28423,28424,59618,28416,28425,28427,28559,59829,19220,19304,19305,19314,19410,7648,77844,78326,19214,19306,77832,19308,19309,7649,59617,59623,19310,19311,19312,19228,19313,19425,19496,30416,7650,19527,19202,19294,19421,19296,19408,7646,19297,19423,19298,19299,19409,7647,26959,59620,19301,19302,19303,19424,19480,78031,59674,59686,19495,59019,15118,7645,15198,15644,26958,59616,15415,30412,15858,7644,59619,15457,15559,19479,30413,15860,15694,59622,78325,15444,7643,15197,15643,15455,30415,15494,59662,15396,23525,15004,15083,15335,7632,15068,15497,15663,15852,15411,15498,15101,15102,15499,15055,15496,23517,15056,15189,15570,15113,15571,15572,15615,15569,7633,15081,15322,15325,15398,59565,23522,15310,15311,15313,15315,15318,23516,15316,15321,15094,15317,15058,15324,15332,15399,15851,15400,15613,23519,15319,15397,15330,15402,23528,15327,15403,7631,15328,15404,15333,15401,15336,15614,15100,15320,15334,15395,77200,77205,77207,77203,77216,77215,77223,77213,77221,29358,29359,29360,29361,59568,76044,32411,21641,21642,28428,28429,29357,21644,28432,28433,29362,29363,21645,21659,21668,28434,28463,59635,16342,28435,28436,28466,28467,59825,59827,59826,77210,77209,77208,77202,77206,77204,77211,77201,77219,77220,77212,77226,77218,41294,77228,77217,77224,77214,77225,76028,41295,77229,77222,77231,77227,77230,41293,43576,78013,78011,21637,21643,21646,21669,28430,28431,28462,59639,16341,19262,19372,19418,19346,19347,30404,7640,19497,19536,59632,19350,23521,19349,19351,19352,19355,7636,23530,59018,19354,19357,19368,23527,19356,19358,19362,59567,7637,19521,23524,59559,59939,19359,19360,19361,19417,30405,30472,78030,19353,19363,19364,7638,29364,19365,19366,19348,19367,7639,59634,59638,19369,19370,19371,19501,15863,15412,15632,59633,15070,15107,15634,15116,15635,7635,15410,15633,19503,23520,15479,15576,15664,15103,15106,15573,15618,30400,23529,15120,15621,30401,15622,15069,15616,15623,15620,26971,15104,15121,15625,15105,15626,15409,15574,15617,15575,30402,23518,23526,15627,15680,7634,15122,15624,15114,15629,15082,15630,23523,59637,59636,15631,30403,15628,59566,15850,59017,15601,15304,15306,15307,15593,15651,15684,7662,15489,15592,15677,15021,15179,15439,37591,15173,15177,59530,15243,15350,15584,15024,15482,15685,15182,15185,15287,15289,15292,15582,15676,15681,15290,15293,15583,15291,15294,15297,15299,15669,59536,15191,15581,15041,15285,15286,15588,15295,15296,15667,59539,15298,15595,15796,59534,15302,15303,15645,15682,15301,15590,15650,15300,15390,15521,15589,37594,59558,7661,15587,15594,15187,15481,15591,15668,15683,15697,59535,15586,77236,77239,77237,77240,77855,77244,77242,77249,77246,41292,77241,77247,77301,77251,77245,77243,28451,28452,28453,28643,28644,76045,21639,21665,21667,26947,28455,28456,28457,28469,77836,21666,21692,28458,28460,28461,28464,59644,59806,28459,28465,28468,21648,76029,41291,36387,77248,77252,77250,77253,41290,78007,43574,78005,36375,21664,28470,59817,59816,59818,77272,77234,77235,77238,77233,77837,19215,19377,19378,19379,19380,7666,59016,67011,59645,19381,19382,19383,19384,19385,7667,19543,77918,19387,19388,19389,19390,30409,59643,78028,19391,19392,19401,19416,7668,19393,19394,19395,19396,77835,19397,19400,19481,7669,59647,19402,19403,19405,19406,19407,30410,7670,19535,15175,15192,7664,15183,15596,15653,15688,15600,15648,15695,37593,30407,15033,15186,15678,15689,15025,15181,15585,19386,15178,15673,15797,59646,59541,37595,26973,59015,59642,15194,15696,7665,15174,15408,15450,7663,15540,15652,15010,15599,15619,37592,15597,15686,59529,59641,15074,15188,26972,15646,15687,15071,15407,15670,59538,15483,59531,15484,30474,15184,15193,15647,15892,15176,15190,15195,59557,15072,15654,15690,15889,15890,15893,59532,59533,59537,59540,19374,19376,15598,15180,30408,15258,59597,15257,7611,15262,15514,15530,19483,15520,15532,15273,15531,15533,15139,23485,27965,7612,27981,15535,59522,78294,78295,78293,15405,15537,15027,15143,15534,15536,27970,59598,15099,19472,15538,15550,15552,15553,26974,15253,28532,28533,28535,28536,28538,21657,28534,28537,28539,28540,59602,77093,77097,77273,77105,77103,77094,77099,41275,77095,77098,77102,77104,76023,41276,77107,77106,77108,77091,77109,77101,41277,78001,77999,43572,78288,78289,78287,77657,79453,28541,28542,28543,28645,59824,59823,59822,77088,77852,77084,77085,77087,77096,77090,77092,77089,77100,28524,28525,28526,28564,77851,76039,21656,28527,28528,28529,28530,77658,21658,59881,79455,19246,19247,19252,30475,59601,59991,77662,78026,19248,19250,19413,7618,19253,19419,77850,19254,19255,19256,2482,7619,19257,19258,19259,9722,79454,19260,19261,19263,19508,30442,7620,19519,78291,78292,78290,19231,19235,19236,19237,7616,59012,59599,59993,59882,77928,77930,78032,78034,19239,19240,77663,19241,19242,19244,15611,15029,15433,15671,19205,30435,19412,7615,59600,15169,15428,59596,15558,19517,26967,15028,19428,30437,27977,15609,30438,26975,15137,19427,19518,7614,15427,30398,15140,15610,30436,30440,15142,27972,15429,15554,30439,59595,15406,15418,15557,30433,15555,15556,15608,30434,15141,15862,19516,15607,19482,27980,15551,7613,15217,15753,59520,15800,15888,59546,59552,27967,27975,59014,15077,15138,26966,15420,59664,59574,59688,59676,7603,15014,7602,59575,15126,15128,15244,15560,7601,59573,15231,59663,15016,59687,59675,26962,77003,77004,77009,77008,77012,77010,77011,77006,77831,77016,28572,28646,77842,76036,21690,28558,28563,28566,28567,59578,21647,28569,28571,28573,77830,28560,28562,59579,21689,28555,28565,28568,28570,59821,59819,59820,77001,77002,77843,77005,77013,77014,77015,77007,41272,77020,77019,77017,77018,77021,76020,41273,77024,77025,77026,77022,77023,41274,77998,77996,43571,28556,28557,28561,77275,78025,19217,19218,7117,7118,19201,19203,19420,19206,7606,19208,19210,19212,7607,59577,19216,30446,7608,77841,19221,19227,77865,19222,19223,19435,7119,7609,15997,19225,19226,7121,77829,19229,19230,30447,7120,7610,15995,19533,26963,15388,30443,15013,7604,15675,59011,59576,15097,15416,7605,77864,59556,29011,15135,15480,15053,15052,15130,15329,15798,15799,15887,15894,15896,15897,15898,59543,59544,59550,59551,59553,59554,15672,30444,15136,59572,15125,59665,30445,59689,59677,7712,7711,28720,7735,7713,7733,7736,7714,59813,77256,77255,77258,77257,77259,77261,77260,77262,41283,77267,77264,77263,77265,76030,77269,77268,77303,77266,43578,21629,28545,76046,28547,28548,21630,28549,28550,28551,28552,59652,28553,28554,59815,59814,7740,7722,19499,59010,7741,7723,19531,26957,7724,7725,7726,19530,7727,59651,7728,7729,7730,7731,19537,19538,7718,59648,59009,19498,19200,59649,7721,7739,26956,7720,59650,7734,7715,7737,7716,26955,7717,7719,7738,15700,15703,15720,15717,15007,15734,15728,15710,7701,15701,15708,15704,15711,15737,15724,7702,15729,15709,15730,15719,15705,19504,15739,15727,15738,15735,15712,59807,28474,28475,28484,77853,28478,28480,28483,21650,28472,28479,28481,28482,28477,28471,28473,28476,76040,16391,21636,28485,28486,59808,59812,59811,59810,77113,77111,77112,77854,77118,77114,77120,77116,77676,77119,77117,77121,41289,77124,77122,77115,76024,77123,77125,77126,77992,43569,19450,19451,19452,7706,59001,19453,19454,59604,19457,19458,7707,19459,19468,30451,78024,19455,19456,7708,19460,19461,19462,19463,24548,7709,19464,19465,19466,19467,30452,30479,7710,59653,15746,30450,7705,15747,30449,26954,15742,15745,15749,59002,59603,15744,15748,15706,15725,15741,15715,15707,7703,15718,15723,15713,15721,30448,15736,15740,15716,15743,15750,7704,15726,24547,15714,15702,26953,18370,18371,18368,18369,78022,59928,59925,59888,59904,59921,59931,76052,59929,59917,59887,59900,59901,59890,59902,59915,59926,59885,59924,59903,59891,59905,59930,59918,68774,77300,77296,77297,77298,77675,41271,77299,76035,77295,43566,77986,59927,59916,59922,59892,59893,59883,59894,59895,59886,59896,59889,59897,59898,59914,59884,59899,59934,59935,59933,35930,35931,35932,35933,35935,35936,35937,35938,35940,35941,35942,35943,37868,37869,37880,37881,37882,37893,37894,37895,40554,40555,40556,40557,40559,40560,56936,56939,56940,56941,56942,56943,56944,64607,64610,64611,64612,64613,64614,64615,77784,77785,77786,77787,77788,77794,77795,77796,77797,77798,77804,77805,77806,77807,77808,77814,77815,77816,77817,77818,77824,77825,77826,77827,77828,93986,93987,93988,93989,93990,93991,135335,135336,135337,135338,135339,135340,77779,77780,77781,77782,77783,77789,77790,77791,77792,77793,77799,77800,77801,77802,77803,77809,77810,77811,77812,77813,77819,77820,77821,77822,77823,66250,77857,66251,76047,76031,66240,66241,41281,66460,66400,66461,66401,66402,66403,78019,66462,66404,66405,66406,66407,66408,66409,76049,66463,66411,59908,77287,77288,41268,77283,76032,77286,43563,77980,18558,18559,18560,18561,18562,18575,18576,18577,18578,18579,18580,18563,18564,18565,18566,18567,18568,18488,18489,61083,61084,61085,61086,61087,61088,61089,61090,61091,18372,18373,16517,16523,37974,37975,40571,40572,40573,40574,40575,40576,40595,41252,51420,95848,95873,95874,95875,95876,95877,95878,95879,95880,95881,95882,95883,95884,95886,95890,95894,95898,95902,95906,95910,95914,95918,95922,95926,95930,95934,95938,95941,95944,95947,95950,95953,95956,95959,95962,95965,95968,95971,95974,95977,95980,95983,95986,95992,95995,95998,96001,96004,96007,96010,96013,96016,96019,96022,96928,13051,13063,93492,93508,93509,93511,93513,93529,93530,93531,93532,93533,93534,93535,93536,93537,93538,93539,93540,93541,93542,93543,93544,93591,93592,93593,93594,93595,93596,93597,93598,93599,93600,93601,93602,93603,93604,93605,93606,93607,93608,93609,93610,93611,93612,93613,93614,93615,93669,93670,93671,93672,93673,93674,93675,93676,97825,97826,97827,97828,97829,97830,97831,97832,97833,97834,97835,98456,98457,98458,16509,16510,16512,16513,16515,16519,16524,16527,16529,16530,21967,22141,22142,22143,35771,35772,35773,35786,35787,35788,35789,35790,35791,35792,35793,35794,35795,35796,35797,35798,35799,35800,36209,37948,51399,51400,51403,51405,51407,51413,51421,95844,95845,95846,95847,16514,16516,16518,16520,16521,16522,16525,16526,22138,22139,22140,22182,22183,22184,51396,51397,51398,51401,51404,51408,51411,51418,51419,51425,65454,65455,95989,54672,54673,54674,54675,54676,54677,54678,54679,54681,54682,54683,54684,54685,54687,54688,54690,54693,54694,54695,54697,54698,54699,54700,54701,54702,54703,54704,54705,54706,54707,54708,54709,54710,54711,54712,54713,54714,54715,54716,80058,54689,54727,54728,54729,54730,54731,54732,54733,54734,56997,56998,69221,85063,85065,85066,85067,85068,85069,85070,85071,85072,85073,85074,32591,32592,32593,32594,32595,32596,32597,32598,32616,32728,32785,32786,32787,32788,32789,32790,32791,32792,32793,32794,32795,32796,32797,32798,32799,32896,32897,32898,32899,32990,32991,32992,32993,32994,32995,32996,32997,32998,32999,33058,33059,33060,33061,33062,33063,33064,33065,33066,33067,33068,33069,33070,33071,33072,33073,33074,33075,33076,33077,33078,33079,33080,33081,33082,33083,33084,33085,33086,33087,33088,33089,22875,22884,22966,22967,22977,25846,26089,26090,26794,26894,26898,27099,27100,27163,27269,27275,27277,27287,27296,27639,27644,27645,27697,27985,27988,28069,28449,28698,28699,29199,29304,29305,29665,29739,29740,29741,32010,32011,32040,32041,32070,32071,32072,32073,32074,32076,32077,32078,32079,32082,32083,32084,32111,32248,32249,32290,32291,32292,32293,32294,37644,37646,37647,37664,37665,37667,37668,37670,37671,37673,37674,37676,37694,37695,37697,37698,37700,37701,15821,16719,20423,20429,20509,20910,21000,21239,21344,21497,21794,21796,21851,21862,21867,21873,21881,21883,21888,21890,22699,22876,22885,22888,22963,22968,22978,22981,22984,22992,22993,23495,23599,24579,24580,24582,24591,24595,24597,24619,24638,24644,24781,24786,24792,24795,24798,24883,25225,25845,25985,25992,25993,26044,26047,26080,26084,26091,26094,26098,26210,26215,26216,26219,26735,26736,26742,26790,26791,32068,32069,32295,32296,32297,32298,32299,32589,32590,33090,33091,33092,33093,33094,33095,33096,33097,33098,33099,33100,33132,33133,33134,33135,33136,33137,33138,33139,33140,33141,33142,33143,33144,33145,33146,33147,33148,33149,33150,33151,33152,33153,33154,33155,33156,33157,33158,33159,33160,33349,33377,33405,33433,33880,33984,33985,33986,33987,33988,33989,33990,33991,33992,33993,33994,33995,33996,33997,33998,37703,37704,37706,37707,37724,37725,37727,37728,37730,37731,37733,37734,37736,37737,37754,37755,37757,37758,47029,52023,52024,52200,57806,57808,57810,57811,57812,57813,57814,57815,57816,57817,57818,57819,57820,57821,57822,57823,57824,57825,57826,57827,57828,57829,57830,57831,57832,57833,57834,57836,57837,57838,57839,57840,57841,57842,57843,57844,57845,57846,57849,66615,96468,96469,96470,96471,96472,107350,50380,50381,50382,50383,50387,50388,50390,50391,50392,50393,50397,50398,50401,50402,50403,50404,50408,50409,50411,50412,50413,50414,50418,50419,50421,50422,50423,50424,50425,50429,50430,50432,50433,50434,50435,50439,50440,50442,50300,50301,50302,50303,50307,50308,50310,50311,50312,50313,50317,50318,50320,50321,50322,50323,50327,50328,50330,50331,50332,50333,50337,50338,50340,50341,50342,50343,50347,50348,50350,50351,50352,50353,50357,50358,50360,50361,50362,50363,50367,50368,50370,50371,50372,50373,50377,50378,35724,35725,35726,35727,35728,35729,35730,35711,35712,35713,35714,35715,35716,36694,36695,37588,45867,123466,123467,123468,112600,112601,112602,34919,34935,34983,34986,35659,35660,34984,34987,35963,35979,35976,35992,35965,35980,35967,35982,35968,35983,35969,35984,35970,35985,35961,35986,35971,35987,35973,35989,35974,35990,35975,35991,35993,35996,50684,50654,50670,50659,50674,50661,50676,50652,50677,50662,50678,50666,50682,35994,35997,50685,35995,35998,37587,50650,50651,50687,50743,45853,45854,45860,45861,45862,50999,60755,60756,124264,124265,124266,124267,124268,124269,129600,129601,113366,113367,113368,113369,113370,113371,38506,38507,38508,41242,41243,41244,41245,41246,41525,41526,41527,41528,41529,41530,41531,41532,41533,41534,41535,41536,41537,41538,41539,41540,41541,41542,41543,41544,41545,41546,41547,41548,41549,41550,41551,41552,41553,41554,41555,41631,41632,41633,64910,64911,64912,64913,64914,76288,76289,76290,76291,76292,90317,90318,90319,90320,90321,90327,97836,97837,97838,97839,97840,97841,97842,97843,97844,97845,97846,97847,97848,97849,97850,97851,97852,97853,97854,97855,97856,7001,7002,8001,17500,17501,17502,17503,17652,17653,17654,17655,17903,18125,18681,18872,18873,18874,18875,18876,18877,36288,36289,36290,36291,36292,36293,36294,36295,36296,36297,36298,36399,38334,38335,38336,38337,38338,38339,41948,45923,97857,97858,97859,38509,38510,93503,93504,93505,93506,93507,93514,93515,93516,93517,93518,93519,93520,93521,93522,93523,93524,93525,93526,93527,93528,93545,93546,93547,93548,93549,93550,93551,93552,93553,93554,93555,93556,93557,93558,93559,93560,93561,93562,93563,93564,93565,93566,93567,93568,93569,93570,93571,93572,93573,93574,93575,93576,93577,93578,93579,93580,93581,93582,93583,93584,93585,93586,93587,93588,93589,93590,93619,13817,16481,54249,54250,54251,54252,54253,54254,54255,54256,54257,54258,54259,54260,54442,54443,54444,81312,81313,81314,81315,81316,81317,81318,81319,81320,81321,81322,81323,81324,81326,8003,8005,8009,8011,8320,8322,17008,17910,51168,16508,16528,16843,18696,37870,37871,37872,37873,37874,37875,37876,37877,37878,37879,37883,37884,37885,37886,37887,37888,37889,37890,37891,37892,45216,45222,45223,45224,51402,51406,51409,51410,51412,51414,51415,51416,51417,51422,51423,51424,93969,96924,96925,56746,57126,60751,61239,61240,64417,64518,64523,64673,64685,64920,64921,66948,76298,76321,76323,76335,76431,76781,76809,76810,76811,76812,76813,76814,76815,76816,76817,76818,76819,76820,76821,76822,76823,76824,76825,76826,76827,76828,76829,76830,76831,76832,76833,76834,76835,76872,76909,76921,81135,81297,81684,81809,81987,81992,82770,82776,83183,83188,83196,83444,85276,85277,87971,88033,88720,89433,89437,90328,93959,93970,93979,94077,96973,96982,96985,99931,124276,124342,124688,127050,127118,127183,129596,129606,134649,134650,134651,135311,135398,135399,135410,135803,135885,135918,139642,139643,139644,139645,139646,141802,141803,141804,141805,141806,142955)

2022/06/18 02:12:55 
[103.315ms] [rows:10672] SELECT * FROM `merchantlist` WHERE `merchantlist`.`merchantid` IN (202002,202022,202023,202024,202025,202026,202064,202067,202069,202071,202073,202074,202075,202076,202077,202078,202079,202080,202081,202082,202083,202084,202085,202086,202087,202088,202089,202090,202091,202092,202093,202094,202095,202129,202131,202132,202133,202134,202136,202137,202138,202139,202140,202141,202142,202143,202144,202147,202148,202149,202150,202151,202152,202154,202155,202156,202157,202158,202161,202166,202167,202169,202171,202173,202174,202175,202176,202177,202178,202179,202180,202181,202182,202183,202184,202185,202186,202187,202188,202189,202190,202191,202192,202193,202194,202195,202196,202197,202198,202199,202200,202201,202202,202203,202204,202205,202206,202207,202208,202209,202210,202211,202212,202213,202214,202215,202216,202217,202218,202219,202220,202221,202222,202223,202224,202225,202226,202227,202228,202229,202230,202231,202232,202233,202283,202284,202288,202289,202292,202293,202303,202304,202306,202307,202308,202309,202310,202315,202316,202317,202324,202339,202344,52088,52089,202364,202375,202376,202378,202379,202386,202387,202397,202398,202399,202400,202409,202410,202412,202419,202424,202426,202427,202428,202429,202430,202433,202434,202435,202442,202445,202447,202460,202461,202462,202463,202464,202465,202466,202467,202468,202469,202470,202471,1000002,1000003,1000004,1000005,1000006,1000007,1000008,1000009,1000010,1000011,1000012,1000013,1000014,1000015,1000016,1000017,1000018,1000019,1000020)

2022/06/18 02:12:55 /home/go/src/internal/http/crudcontrollers/spawn_2_controller.go:60
[119.638ms] [rows:437] SELECT * FROM `npc_types` WHERE `npc_types`.`id` IN (202363,202042,202369,202031,202113,202030,202097,202109,202096,202106,202307,202169,202317,202327,202328,202274,202277,202336,202340,202033,202028,202027,202034,202111,202000,202001,202002,202003,202004,202006,202007,202008,202012,202013,202014,202015,202016,202017,202019,202021,202022,202023,202024,202025,202026,202037,202038,202039,202040,202041,202043,202044,202045,202046,202047,202048,202049,202050,202051,202052,202054,202055,202056,202057,202058,202059,202298,202299,202301,202064,202067,202364,202069,202071,202073,202074,202075,202076,202077,202078,202079,202080,202081,202082,202083,202084,202085,202086,202087,202088,202089,202090,202091,202092,202093,202094,202095,202120,202121,202122,202123,202124,202126,202127,202128,202129,202130,202131,202132,202133,202134,202135,202136,202137,202138,202139,202140,202141,202142,202143,202144,202145,202146,202147,202148,202149,202150,202151,202152,202153,202154,202155,202156,202157,202158,202161,202166,202167,202171,202173,202174,202175,202176,202177,202178,202179,202180,202181,202182,202183,202184,202185,202186,202187,202188,202189,202190,202191,202192,202193,202194,202195,202196,202197,202198,202199,202200,202201,202202,202203,202204,202205,202206,202207,202208,202209,202210,202211,202212,202213,202214,202215,202216,202217,202218,202219,202220,202221,202222,202223,202224,202225,202226,202227,202228,202229,202230,202231,202232,202233,202234,202238,202244,202248,202249,202250,202251,202260,202263,202265,202267,202268,202331,202332,202333,202272,202273,202276,202337,202280,202281,202283,202284,202341,202342,202288,202289,202010,202011,202036,202291,202292,202293,202294,202295,202020,202330,202035,202009,202117,202114,202303,202304,202306,202308,202309,202310,202311,202312,202313,202315,202316,202321,202322,202324,202325,202326,202329,202339,202344,202345,202346,202029,202005,202105,202112,202235,202246,202032,202275,202107,202237,202101,202108,202110,202098,202099,202115,202116,202236,202239,202240,202245,202247,202254,202258,202252,202241,202100,202259,202103,202253,202256,202104,202119,202255,202290,202118,202102,202243,202242,202257,202053,202300,202372,202125,202375,202373,202376,202378,202379,202381,202384,202385,202386,202387,202018,202388,999000,999013,999201,999202,999203,999204,999205,999206,999207,999208,999209,999210,999211,999212,202389,202390,202391,202392,202393,202394,202395,202396,202397,202398,202399,202400,202401,202402,202403,202404,202405,202406,202407,202408,202409,202410,202411,202412,202413,202414,202415,202416,202417,202418,202419,202420,202421,202422,202423,202424,202425,202426,202427,202428,202429,202430,202431,202432,202433,202434,202435,202436,202437,202438,202439,202440,202441,202442,202443,202444,202445,202446,202447,202448,202449,202450,202451,202452,202453,202454,202455,202456,202457,202458,202460,202461,202462,202463,202464,202465,202466,202467,202468,202469,202470,202471,202472,202473,202474,202475,202476,202477,202478,202479,202480,202481,202482,202483,202484,202485,202486,202487,202488,202489,202490,202491,202492,202493,202494)

2022/06/18 02:12:55 /home/go/src/internal/http/crudcontrollers/spawn_2_controller.go:60
[121.990ms] [rows:439] SELECT * FROM `spawnentry` WHERE `spawnentry`.`spawngroupID` IN (34262,34263,34264,34265,34270,34272,34274,34275,34276,34277,34278,34279,34280,34281,34282,34283,34285,34288,34290,34291,34294,34295,34296,34297,34298,34299,34300,34301,34302,34303,34304,34305,34306,34307,34308,34309,34310,34311,34312,34313,34314,34315,34316,34317,34318,34319,34320,34321,34322,34323,34324,34325,34326,34327,34328,34329,34330,34331,34332,34333,34334,34335,34336,34337,34338,34339,34340,34342,34343,34344,34346,34348,34349,34350,34351,34352,34353,34354,34355,34356,34357,34358,34359,34360,34361,34362,34363,34364,34365,34366,34367,34368,34369,34370,34371,34372,34373,34374,34375,34376,34377,34378,34379,34380,34381,34382,34383,34384,34385,34386,34387,34388,34389,34390,34391,34392,34393,34394,34395,34396,34397,34398,34399,34400,34401,34402,34403,34404,34405,34406,34407,34408,34410,34413,34414,34416,34418,34420,34421,34422,34423,34424,34425,34426,34427,34428,34429,34430,34431,34432,34433,34434,34435,34436,34437,34438,34439,34440,34441,34442,34443,34444,34445,34446,34447,34448,34449,34450,34451,34452,34453,34454,34455,34456,34457,34458,34459,34460,34461,34462,34463,34464,34465,34466,34467,34468,34469,34470,34471,34472,34473,34474,34475,34476,34477,34478,34479,34480,34481,34482,34484,34485,34486,34487,34488,34490,34492,34494,34495,34496,34497,34498,34499,34500,34501,34502,34503,34504,34505,34507,34508,34509,34510,34511,34512,34514,34519,34523,34524,34525,34526,34527,34528,34529,34530,34534,34539,34541,34543,34545,34546,34548,34549,34550,34551,34552,34553,34554,34555,34556,34558,34559,34560,34561,34562,34563,34564,34565,34566,34567,34574,34582,34584,34586,34588,34589,34593,34597,34598,34604,34610,34611,34613,34621,34622,34627,34628,34629,34630,34631,34632,34633,34634,34635,34641,34644,34647,34650,34657,34663,34670,34673,34676,34689,34694,34699,34705,34713,34714,34729,5329,36869,13617,47312,33943,48188,48189,48193,48355,48351,48359,53518,53530,54831,98988,99016,99036,99037,99105,99128,104098,104099,104102,104103,104104,104105,104106,104107,104108,104109,104110,104111,104112,104113,110142,110143,110144,110145,110146,110147,110148,110149,110150,110151,110152,110153,110154,110155,110156,110157,110158,110159,110160,110161,110162,110163,110164,110165,110166,110167,110168,110169,110170,110171,110172,110173,110174,110175,110176,110177,110178,110179,110180,110181,110182,110183,110184,110185,110186,110187,110188,110189,110190,110191,110192,110193,110194,110195,110196,110197,110198,110199,110200,110201,110202,110203,110204,110205,110206,110207,110208,110209,110210,117985,259486,259487,259488,259489,259490,259491,259492,259493,259494,259495,259496,259497,275117,275118,275119,275120,275121,275122,275123,275124,275125,275126,275127,275128,275129,275130,275131,275132,275133,275134,275135,275165,275166,275167,275218)

2022/06/18 02:12:55 /home/go/src/internal/http/crudcontrollers/spawn_2_controller.go:60
[125.841ms] [rows:439] SELECT * FROM `spawn2` WHERE zone = 'poknowledge' AND version = '0' LIMIT 100000
method=GET, uri=/api/v1/spawn_2s?includes=Spawnentries.NpcType%2CSpawnentries.NpcType.Merchantlists.Items&where=zone__poknowledge.version__0&limit=100000, status=200, time=142.382468ms

Smaller Request (Successful, Limit 10)

DEBUG[2022-06-18 02:31:37] JWT validation success as user [1]           

2022/06/18 02:31:37 
[3.204ms] [rows:16] SELECT * FROM `items` WHERE `items`.`id` IN (18555,18556,18557,6027,7052,10489,10500,10501,10502,12056,16900,16901,16902,50883,18488,18489)

2022/06/18 02:31:37 
[4.328ms] [rows:16] SELECT * FROM `merchantlist` WHERE `merchantlist`.`merchantid` IN (202169,202307,202317)

2022/06/18 02:31:37 /home/go/src/internal/http/crudcontrollers/spawn_2_controller.go:60
[5.953ms] [rows:10] SELECT * FROM `npc_types` WHERE `npc_types`.`id` IN (202031,202113,202030,202097,202109,202096,202106,202307,202169,202317)

2022/06/18 02:31:37 /home/go/src/internal/http/crudcontrollers/spawn_2_controller.go:60
[6.871ms] [rows:10] SELECT * FROM `spawnentry` WHERE `spawnentry`.`spawngroupID` IN (34262,34263,34264,34265,34270,34272,34274,34275,34276,34277)

2022/06/18 02:31:37 /home/go/src/internal/http/crudcontrollers/spawn_2_controller.go:60
[8.293ms] [rows:10] SELECT * FROM `spawn2` WHERE zone = 'poknowledge' AND version = '0' LIMIT 10
method=GET, uri=/api/v1/spawn_2s?includes=Spawnentries.NpcType%2CSpawnentries.NpcType.Merchantlists.Items&where=zone__poknowledge.version__0&limit=10, status=200, time=10.115ms

Comment From: github-actions[bot]

The issue has been automatically marked as stale as it missing playground pull request link, which is important to help others understand your issue effectively and make sure the issue hasn't been fixed on latest master, checkout https://github.com/go-gorm/playground for details. it will be closed in 30 days if no further activity occurs. if you are asking question, please use the Question template, most likely your question already answered https://github.com/go-gorm/gorm/issues or described in the document https://gorm.io ✨ Search Before Asking ✨

Comment From: Akkadius

A possibility that comes to mind is that this might be hitting a Go SQL param limit - but after investigating Go MySQL driver issues; there shouldn't be any limits anymore. Not sure if there would be anything at the Gorm level that would cause this

Comment From: github-actions[bot]