[php + mysql] where not in i.c.m array id's

[Jboy1991]

Goedendag,

voor een klein projectje vroeg ik mij het volgende af:

Ik heb een database met aardig wat woorden (meer dan 100.000). voor een klein simpel project laat ik van deze 100.000 woorden telkens maar Random een X aantal zien.

Om te voorkomen dat bij een Reload de zelfde resultaten te zien zijn sla ik deze Id';s op in een session (die geupdate word via array_push met telkens de nieuw geshowde id's)

Echter heb ik het gevoel dat ik regelmatig woorden tegen kom die ik al eerder heb gezien in de sessie.

Doe ik misschien iets verkeerds? Ik heb de database al gecheckt op dubbele hits maar die geeft steeds 0 aan

code:

SELECT 
    word, 
    COUNT(word)
FROM
    word_db
GROUP BY word
HAVING COUNT(word) > 1;

en mn random woorden mysql ziet er als volgt uit:

code:

$arr = $ignore_ids; // word gevuld dmv opgeroepen functie -> session
$values = implode (",",$arr); // deze array lijst kan dus ENORM lang worden (zie voorbeeld)
        $check_query_sql = "select * from word_db WHERE `id` NOT IN (:id_Array) and remove_word=false and seen=false ORDER BY RAND()
LIMIT 10";
        $execute_array = array(":id_Array"=>$values);

voorbeeld van de array na implode

code:

21672,109269,21906,115674,11740,127601,150765,96188,97174,109241,79125,34162,64734,69994,13951,3421,105160,90355,95074,160949,137932,137182,59896,13217,31727,12490,115998,61446,58082,8575,80315,24870,16281,66967,39075,26621,6934,50210,146056,29118,50263,36241,81493,100805,67116,151180,117629,77776,102696,87866,5632,138378,134022,57673,53014,123191,104766,99775,3074,36084,22074,54896,146897,28361,137104,145226,60028,43734,76307,28048,62786,144565,21388,78367,43102,125174,111439,92471,47382,90544,140973,29632,38416,131944,106692,61379,39100,131243,30022,12794,138023,148678,162147,56598,140200,158984,13151,118466,100571,138215,503,140577,120792,128541,85289,43106,72338,120912,149181,151589,52926,132092,89394,41233,59102,147534,79734,49427,118541,108401,62327,116161,49868,55021,136820,13080,91567,87036,158507,143117,113238,96935,147015,103937,106361,55112,5162,114936,48144,45571,75938,31419,90929,109515,139101,139034,162660,75635,133828,102282,98771,118591,118431,145864,27618,154882,56921,100009,147830,122844,80298,27947,24867,64080,33604,15960,99636,93735,160184,122102,160304,112634,136289,95940,101633,14772,18593,131054,27008,125901,116276,39627,133324,33726,62414,37533,23894,136874,93608,26052,89702,18558,5847,67560,60801,14016,10392,64623,57945,47436,148494,113722,156988,16410,66487,79124,148587,139022,15784,139583,75517,141830,142957,62346,66375,117698,159639,141261,42680,28841,80538,153267,64880,88238,82743,140582,35519,82104,34226,148121,158997,21805,103031,35171,104788,118129,39304,114374,124619,126413,105301,71835,60465,160456,19734,142781,67675,77374,115457,42992,148639,137033,42617,75623,68781,63194,97782,80357,161015,130705,117459,2638,96782,36567,8219,133929,40058,34388,118182,118584,62907,48740,35354,1340,39923,7343,128412,83213,56464,17140,26397,25041,107767,147800,43390,85643,151688,136047,40103,77017,135836,43475,100997,159247,109742,95078,24116,158569,118553,533,67955,6544,36184,121401,35257,63868,157067,95799,26058,22688,157153,147246,23818,56138,39383,23053,23841,122103,50868,11392,134490,123494,20411,101580,86237,45105,46975,105826,44999,23472,34042,51230,33147,55531,150384,96393,59482,76801,157832,146158,151380,204,130007,109793,138579,185,24975,55027,137198,134522,106270,49406,52613,29124,130560,35314,45981,15467,11246,82746,132918,123738,159652,44259,44055,150913,64797,105547,69706,137441,132415,105251,149040,56146,19059,154499,98964,62593,97262,65171,111018,81160,154187,134828,155036,138794,1893,104569,93061,157306,119534,150650,108143,15457,25306,75213,27269,42720,41818,131048,37037,10575,124202,94110,79017,7999,133511,88294,31405,114021,155386,141199,104543,143171,147443,68111,85364,100002,95224,61824,132004,143292,153365,151381,41132,148215,116637,134195,87198,120840,49957,154074,90937,52929,120739,154161,135735,38858,138798,126895,43411,22713,82025,57658,43183,14254,28964,7582,58974,58753,96056,47251,43043,7243,48364,96559,132594,163300,42360,100989,104824,802,16081,28753,18052,58025,134021,39142,65898,127257,112171,134508,21601,106209,71440,117,25079,22340,18098,7405,105598,39745,102201,131728,155935,88196,108003,18639,41178,20695,150516,93332,158497,157225,129407,99056,15865,132400,146697,25955,9428,144266,17183,79688,23132,128838,36392,142598,56503,12740,161556,16427,8322,41978,129396,5506,972,62757,153007,24706,13339,50794,51570,121905,112330,49674,76491,58355,102744,93733,17702,123514,148288,61328,111745,145399,41054,129511,63992,71853,114080,113660,137051,27233,59774,1443,160865,152252,153976,84549,75391,24900,37419,36962,41589,163211,141953,46466,108149,133319,67972,155001,48283,118861,162287,49654,84264,96777,108492,46584,69426,12049,108500,92612,41061,68523,143881,4862,2633,28815,25577,9902,120020,39227,96260,92511,62495,112214,134441,15556,20851,135292,18043,93739,27676,14582,117694,55310,132670,106065,81087,52010,14177,10916,108087,28455,139425,154316,21959,49709,59679,37429,154472,29245,83308,6321,91701,2576,19167,139343,110309,105766,118591,106397,128275,88857,334,41691,145978,145182,151463,74765,130849,50240,65358,38813,65161,138061,152831,125189,6599,69429,94165,6147,772,47596,136526,148178,132901,163744,161304,5905,131680,8955,425,79717,60874,2212,107072,53962,133504,121040,40866,87414,61725,40731,156088,18068,56725,107941,81785,80547,142046,12539,54062,25822,4027,149826,19710,163580,45796,5873,148165,145472,116614,101768,17772,84866,42604,52035,125139,288,59805,1025,78539,92952,141058,67691,57834,122801,22769,154051,56220,136772,150490,55649,88590,96206,130421,53183,135566,77055,58349,117444,29814,150004,134012,4224,155008,64886,124552,26786,26657,37189,7248,106755,37273,103948,103441,143206,55979,137902,144632,130464,89778,62529,149018,45738,162985,99121,140120,25513,101010,131737,13024,81917,952,117456,100344,107459,163385,63595,7093,116366,46528,8697,89200,106092,43157,99328,99894,52454,94475,545,160377,113880,110589,64401,156155,73662,138278,89375,23473,125746,56645,18970,114737,81352,122881,112815,62198,130830,140513,88187,136863,52144,141365,23862,25973,133274,1642,93138,139618,35340,99601,60639,115202,29689,143340,135960,123341,6888,153705,60517,110154,76112,10905,23762,115301,76673,63472,65928,3845,6360,62887,28506,155982,64437,151301,97134,156385,39181,159638,126108,28318,115484,103451,81661,121269,107583,94698,109976,28394,69539,158990,32945,85095,136621,127995,46056,123806,61956,10759,71033,110835,1061,71263,2384,102058,162248,40224,44047,84419,35102,100473,140489,71289,229,52015,41291,128461,10920,40050,28570,23194,9655,163096,33303,76709,109290,13887,67915,32315,149008,75835,99742,127517,15444,19542,32415,143973,50672,149940,86289,159755,130992,34743,53580,141352,45530,143087,144180,163472,86886,49023,93676,71573,132082,10928,71801,139521,112862,68713,85877,139996,159742,72487,92172,116686,162863,72839,7276,144112,52687,134564,128677,6552,16741,95153,42971,21551,147485,44714,162390,79430,161450,114541,100317,154641,53920,59255,134846,1003,127330,99746,91591,72141,6518,55473,135017,94444,116843,59717,93564,7351,114956,161576,139659,127809,136148,107879,82888,95302,3569,154758,149275,92943,75589,81121,44910,32379,51249,116098,12889,45150,35373,150342,38531,134835,35358,110842,105335,129918,129352,72376,68428,159768,161729,114127,41277,4168,158851,64082,65812,77839,110643,128375,138298,79740,18363,138836,149710,133900,127777,25209,135044,96990,8373,105123,3912,61639,31020,70361,157181,159005,34095,24863,130114,96181,125322,87488,115181,163318,82074,81013,96661,137479,10781,106805,113296,101606,123158,34529,108325,135532,82727,44479,30289,94857,24989,18963,152662,76349,4424,55895,89629,141693,53603,76713,90742,18784,161008,150420,141328,23187,126944,65467,76547,110572,65078,50513,137589,142884,88452,60419,62567,48717,161054,143710,123241,70595,16172,114146,70020,142308,103714,107483,14941,37702,5036,1430,72930,32871,108212,5063,7118,7504,14393,65503,95400,101356,8358,118986,107397,65745,35409,154578,4821,835,146981,29175,141007,146677,3704,48903,138827,21804,97389,70466,27773,31886,2235,152958,65257,41771,150717,95676,110790,26753,147130,54955,72349,89751,66766,14539,1840,57467,4187,31145,137705,133774,141255,40428,55152,152407,154362,65143,153757,122469,76061,131529,36944,13683,141094,119196,78802,153043,133461,49670,55893,91672,30954,116450,116247,16502,149679,156035,47623,52164,56513,32530,121348,40345,124582,90636,90843,66229,29781,57563,82279,113469,20432,123352,26825,82542,96014,26357,114516,41029,8887,36098,94389,54504,61715,87138,95437,108252,102636,275,27394,48566,162213,123495,35344,160032,68441,160140,82634,106847,114833,90352,141173,133265,95911,7777,115268,148071,2532,80779,11222,68794,149152,157697,55458,104947,132786,94384,160111,8785,36439,35688,9047,77009,162639,20065,105105,40430,61720,91484,80337,140666,50194,163699,2611,131095,80301,50583,88748,54120,33720,111914,85299,110334,133818,73408,139534,84821,67903,73786,19072,99608,28555,73240,148959,71305,85076,160890,90847,57334,150175,53118,156792,89472,34300,86871,68251,123817,149943,61050,31516,50936,76436,29684,71509,68973,50595,9293,55673,20988,67313,101626,130544,19197,33289,49266,91300,153718,124844,72998,22166,124789,114889,88629,47706,103818,125495,125781,47289,93081,36448,86364,147929,45185,10053,19529,159928,97677,35071,41645,58246,125142,55324,158062,59687,134847,105140,100001,140016,31959,163535,155861,83679,107069,92676,135041,149723,18032,154000,27858,25935,154992,17195,31086,145809,142030,103092,34647,161520,22660,84015,70008,157750,30926,131676,95065,163948,83112,33851,141535,156843,140209,32237,36694,79210,78687,43896,21788,139248,103278,88641,81969,83396,28090,111339,109653,32344,73698,51333,49940,112594,73031,28152,22241,161426,75195,126837,116829,24070,86163,2678,111472,98798,45267,69845,16844,2762,4254,110923,46127,18600,81638,126317,41656,119681,63993,99430,1463,17646,72843,83630,79337,161280,63716,11432,90895,58089,102302,116738,3465,52529,160184,46755,67947,95975,141451,162875,80115,131922,88931,128830,80546,9142,12737,59571,5428,63187,56623,64460,71869,80673,142946,1686,154933,150013,9025,1836,112078,161221,146249,135390,16304,66812,69766,125750,44617,85742,119885,16657,13807,11309,97589,125111,2639,51365,37396,56048,131890,88398,157590,10669,76760,36621,22200,87022,12318,159023,46074,121298,137160,101425,31686,39963,74450,6192,135114,93347,120336,75625,34474,108665,139392,17932,64054,69693,96145,101190,140388,66334,45079,75733,61567,42723,44305,5977,150302,67478,107652,145066,154881,95352,64301,120528,12414,87692,92423,54018,61852,28749,153538,154005,47079,36755,156943,109885,34889,84040,108990,13412,93281,100356,38380,8245,40853,73918,140945,15156,144719,23265,3846,52054,41331,70829,40274,89993,63836,86272,39739,121968,162959,25981,31248,81944,50726,99708,27645,85250,61435,121769,105090,149725,97983,134389,77883,113011,34327,41945,106939,62943,125500,11478,156989,47111,90849,15917,84454,78070,91794,114763,68463,60829,89341,124186,129408,157218,25201,41250,97207,104828,50905,158039,117232,37029,86648,3486,82135,95320,8924,56226,30581,122694,130460,104884,141488,102269,69233,129792,74183,17998,163984,5864,33520,68944,67790,63551,84393,159296,43994,6516,15283,88514,75039,122818,88630,10980,63844,148317,77887,2389,117928,98182,2966,116548,162955,94582,67726,86419,23691,74152,48264,62997,147708,100570,57670,48165,68617,118245,59343,129114,154149,103228,35632,49038,18844,33257,103964,29146,84435,79463,143128,122605,142399,124901,120305,135533,145132,103143,9943,84070,140961,22228,21694,133497,96720,156981,19615,153495,59770,18518,17127,46921,92162,150956,102859,143784,9480,41328,141814,15448,9208,33652,32377,132265,134048,16739,19504,143781,151470,29289,102422,163005,41382,118250,99906,102775,3545,111260,161728,88897,97219,64567,163538,62095,112269,146178,35236,22950,145614,58439,63973,50106,92875,29844,161497,154946,153876,43538,84426,76637,110216,124965,156444,135557,59944,79270,159095,55184,95733,11618,83902,50775,104293,23284,152336,90499,105162,118212,13081,29828,71373,83344,160433,78769,111483,90251,94792,1881,120898,42608,103400,65125,157383,156150,75468,150164,92326,133708,100177,88712,68852,47103,112263,42273,59048,139978,130972,11101,114310,104015,55285,137254,10162,13294,82252,132517,33543,65156,45619,156522,87167,150332,19982,148146,18612,62200,92446,149542,44639,108069,88910,131449,157604,108045,77655,99949,160371,85194,59621,72293,137642,19525,105779,110303,102375,62380,109735,114546,14085,142919,13107,89295,32778,80926,123438,89781,101073,137268,138430,154360,61634,44260,42759,55750,59226,161573,76012,21541,5232,113068,67767,56500,51529,116599,41940,30742,138586,48729,106969,40229,56505,103089,73013,128814,107134,163946,137725,100550,6145,109734,116046,144613,30834,94697,7092,13597,17153,33684,39572,64852,107355,130536,85537,111075,135295,149552,77756,6419,1656,156415,64520,8780,104463,20907,124161,121362,138814,56931,158908,56922,16564,77203,159899,51111,48108,121541,130620,158406,152098,152504,139740,14676,148458,49778,79079,30698,97495,57562,78434,160661,143211,135447,26726,125232,109353,110967,42432,30092,110759,111263,148529,26717,115672,24340,159758,152619,11970,30177,25011,111797,91122,59937,105,21969,31379,38988,156790,67658,84592,152274,101762,15799,122066,160668,134002,145708,84620,36698,118368,128072,124318,86818,157166,59393,105144,5034,92608,142334,146002,154636,13797,21953,154790,87318,47016,142693,82526,104588,50487,94660,163424,78289,24986,4382,163586,153033,117682,111686,138295,9490,22734,117962,148087,144556,73333,22995,23245,87595,93982,79259,14011,101049,139504,84334,102628,21780,13454,155078,52460,143759,153678,79884,24888,96818,71956,143620,97427,110388,18246,58657,89455,106688,130457,156527,126701,91351,161706,80684,34646,10272,93804,23043,147027,92841,160151,50840,12216,15322,24564,114417,31578,138240,7360,9352,154973,99048,109038,138602,9026,49770,62910,60399,70821,126808,126682,21750,3997,58160,97688,15216,107863,133395,118917,104615,158965,61595,130234,4342,124009,127195,96064,17168,110915,130440,156100,115612,10577,132237,117643,37506,113071,109729,1697,85022,39570,92310,55822,152516,8331,77690,92366,65154,84091,100707,58699,4218,36389,22716,18233,5159,68960,74929,4772,119493,58777,31565,141765,24650,31353,152900,19267,122089,122991,104867,66203,36592,63256,95289,7921,91229,13064,54554,129287,136120,89378,75580,79802,7416,56004,139218,112536,126428,52255,42011,974,140983,97887,77092,1351,5456,102935,22526,50804,67414,141596,59798,18108,160104,12716,30490,4829,117661,10324,152555,31572,1577,90397,92590,108594,112446,141694,133118,35077,131106,17739,55319,63931,68058,2092,55148,69610,64052,96981,23400,98187,90120,66358,70318,39241,13301,44729,79569,5055,78690,114175,72389,77559,15699,80440,56397,104951,106876,104156,163465,93883,7446,129008,138795,75606,135067,49229,130351,56431,2981,372,27856,2134,12696,19397,66262,74382,11078,32263,162713,136864,133917,131302,61704,138495,116468,95521,133266,124050,10145,22903,129800,553,32544,115450,123475,59871,127357,34182,11871,128542,16681,93307,32551,30719,107928,78834,151356,141363,130408,57193,2065,1999,142266,13497,143061,53041,113492,80393,136107,162748,60694,120556,129012,54592,95615,160286,80922,114657,30945,64120,160862,163513,48785,163566,80107,99091,107396,120329,25604,45208,27881,50362,103101,126997,16676,54880,32520,116244,17058,23565,8096,152139,104138,61109,20381,74776,5790,58167,5184,159697,56435,77190,123477,35761,18563,73572,19591,62353,109053,78282,87828,52338,79059,100398,87298,20369,37945,150275,17263,2745,109525,154544,120267,76902,55443,87777,53691,76797,162129,108352,86053,18150,37721,110945,45291,43325,13373,133434,111760,127039,91650,97334,21838,124359,156508,41796,108339,117494,120781,18823,53906,144905,141166,103316,81273,120349,16125,739,73769,48253,1977,32100,125020,95318,101968,2312,37129,155215,90272,59139,119645,114055,137231,35439,149179,16571,115842,57838,77571,51837,1956,1475,10259,103524,27656,44097,145674,66,10540,107639,24789,140003,156697,161515,149458,97119,60415,76725,117874,24448,40242,2087,422,63341,122489,42874,12978,162749,123608,89236,52372,88569,82782,4175,15035,135832,59220,126393,105795,102911,90740,62723,15019,95329,102039,3727,11191,150292,83463,85258,135145,106675,38947,14381,24854,104414,139804,64486,155932,158179,36593,106191,47828,49681,145429,128914,38764,73580,88764,88141,120397,157442,71910,154015,127913,44270,111561,24178,105493,87303,134706,9000,154942,143598,70819,109257,69501,64666,152931,121976,105988,152566,91501,68110,2431,48442,25117,132065,158547,51086,150734,113623,19968,148099,53719,21080,78853,65890,23152,13724,128765,109141,146394,11402,73090,62937,15553,76378,24654,130358,25316,19344,96952,150077,89323,145870,132223,82108,7762,51903,37349,91685,57115,72741,842,24430,133894,160743,144226,59008,37407,63109,128987,48923,69477,141212,144259,68249,114446,5330,55011,36160,14569,108597,55723,23355,36599,119329,147825,78378,12005,22318,133990,73176,136618,76142,1233,110619,53099,29915,94080,122298,79096,79074,95127,61272,86264,51493,95001,161443,119897,49805,118293,81270,53571,45947,30918,19332,111750,96409,74678,53176,158586,70514,13624,141850,127978,5664,59488,67812,128746,102165,57607,138868,102537,2889,131823,109360,163791,98982,8986,42272,138989,107185,123851,140403,73086,65243,94218,108167,98105,35224,135249,134155,87439,21667,91170,67890,154637,56252,121313,105625,76124,108719,60016,15762,116739,11102,70862,52589,1561,18172,142432,40456,152223,64430,8698,92910,86479,96477,125575,138433,28247,130875,48091,136946,73201,76465,155077,21217,91666,2705,66293,62597,43758,132460,35591,77986,10682,82606,107734,151322,14630,132187,123669,155101,19623,151961,55304,14852,96647,89083,94599,118480,47859,157480,90835,54892,74284,157796,88425,102801,31446,57038,114846,117759,19300,91578,84965,77820,102259,144490,25728,10687,11293,32775,128696,121335,59554,84572,7653,55532,37833,130255,144993,116313,138503,149329,108039,9951,63985,84417,159854,108964,58716,122150,58647,37955,87042,56011,134503,22320,61232,81258,126562,93555,163604,134029,71211,125904,11155,97631,150445,104793,107439,162497,4863,67989,147088,84351,100561,28724,77781,147403,77578,92295,101560,116815,103477,27167,87076,129550,61310,160182,106146,78561,128556,18144,36464,79453,67383,137303,4918,128621,101068,130130,79406,85908,10620,109068,20953,39214,67718,141932,78516,111768,112383,145113,44501,53697,124954,136742,125759,79230,12549,6260,114539,1771,75328,117186,46721,26729,35815,30470,89702,32362,133222,138828,127602,81964,139715,163924,32413,145365,139600,135569,141047,162268,3101,70301,20495,146387,68383,129546,92798,105065,60448,24214,122878,128403,125524,162429,104765,15024,38702,75663,25137,55819,132266,5554,88367,17321,109519,79452,90182,99738,84037,82490,71582,80355,161536,62776,122346,81538,137,98481,30259,129005,163957,71556,59265,131065,35569,142952,54576,89079,19335,66960,134074,137112,12038,6700,131971,120307,158267,41081,138251,113391,53575,54589,31769,82062,152785,19059,52159,125336,92764,62188,88547,90777,136002,142109,111961,98823,141320,129857,104601,134545,153015,82158,133647,19038,156630,63555,66678,131495,35309,135326,42994,152455,80481,24050,93370,51755,55671,107331,149318,70743,147256,65160,71072,54667,77423,122544,140526,46590,2311,68332,44591,131703,135638,93388,155210,43834,60297,79769,7327,112671,27555,31884,141722,46128,94299,155679,61482,157950,136,18251,29506,61593,9111,61032,140859,142745,129973,42983,74986,116344,28210,12542,61529,48317,43889,114984,26423,130198,148436,23031,79505,80022,39104,41770,115462,121365,4872,94821,49385,96121,144290,55255,78401,137238,134386,78924,65098,121628,38992,136675,75205,18760,131024,32340,135833,2060,77186,147330,163630,111520,87656,42423,39096,75261,128742,19010,125482,155842,54779,106976,67047,49522,138045,50054,83071,153802,19175,55855,34361,7293,71717,130852,89122,102699,136622,141037,127225,4167,85199,152769,22949,2173,70099,28245,93543,112391,50854,112687,123198,151048,2810,153149,95086,67671,45117,117973,105695,36358,116975,163324,53121,31792,25525,101132,113901,45423,145061,120868,7245,26134,58474,13880,97775,122960,146681,101028,158653,152489,11852,22133,13364,45000,131985,29046,107436,24393,21160,112532,50413,149951,97848,14357,56853,133151,33041,75326,33647,144153,34187,38732,6241,161176,62073,70698,54854,133680,41096,74191,135279,56499,93438,16843,154640,156337,71863,10753,3546,154080,34134,114350,15365,31493,79113,12676,36503,108534,152983,29251,77617,93761,76942,144053,121740,57613,119003,152918,158034,163662,163213,13676,79908,62204,108870,18103,126118,34456,19387,125803,90780,84924,158870,104639,89217,55066,71060,149730,92413,18808,126081,92066,26738,138595,65524,76114,130790,126910,95314,99627,42012,59511,62051,28733,123615,18539,2926,86408,145758,52098,1535,70367,126444,6881,121099,128352,9529,90438,148091,70147,76950,92048,62800,6337,10857,144291,44257,150069,12056,48223,148915,100136,139330,127527,130491,78030,13385,136381,34823,38287,140451,147012,39255,10539,13443,8124,129653,100850,94446,54273,103011,163567,1610,110080,82352,101348,81792,88886,88862,128252,73667,38467,116728,19549,14458,63061,96947,144458,107955,134423,47860,57171,122101,23764,14509,12839,21147,60674,98121,134876,78525,96568,4103,120323,45351,71692,95747,734,103236,150520,154922,44522,61355,116447,74835,160330,58519,37890,58827,5274,48682,88740,69129,130931,56737,101222,63135,163888,126965,41926,100628,1298,124135,46409,43182,124256,49008,54826,154950,53138,43728,97097,102077,104535,26924,59030,85597,41595,113424,148760,79020,138972,19610,99516,149981,128183,26030,143969,91392,52258,147081,116150,93158,55912,19394,128503,63904,148433,89536,25556,21130,37224,26777,2553,38395,4476,10010,47746,8991,96625,57341,87293,7617,142042,87372,66199,33159,136006,151099,113347,131232,114757,63841,101531,131613,13521,81261,53011,107320,69080,106133,140631,120289,153728,48751,64239,155939,140109,104747,157099,6220,107760,83930,76192,123004,65237,10057,113673,73310,97861,157025,111837,139726,106530,46606,36365,80676,147310,141302,91288,125630,35460,8784,67918,68952,23845,20656,135015,68269,115572,103529,93937,49141,61514,43095,48145,34171,151793,31066,114148,127383,137545,79151,31960,89674,97344,125869,59101,94947,31559,145434,24683,135365,128585,116053,84061,140639,117266,102489,160531,33950,9953,60794,67503,160618,159471,28662,98507,17685,63391,22034,128528,87781,10196,1399,27810,146467,28526,90647,19655,129198,3086,149064,50021,37007,155610,121167,104971,77886,134306,88037,148561,105381,45008,142868,47699,123745,56318,55865,61854,79084,92329,95772,15170,106670,42556,49939,35496,75682,95977,74009,25564,37614,34597,14004,66571,136491,106447,76776,44587,36335,2845,92195,109065,93404,61716,132098,68710,6054,50838,10866,87143,148085,78655,49885,109226,113090,27551,61605,44960,76107,53867,102111,75208,232,76803,1790,94359,65799,99517,143327,37082,1566,70162,76396,114605,53901,72707,8862,7643,130308,121069,82609,79320,149342,56429,153990,116062,92256,13663,57373,161696,124676,163017,87150,156637,151917,38415,100259,19631,56346,100502,144176,126940,17571,6654,49496,13326,67861,68426,9204,14594,88309,26530,129565,11425,10333,152107,125119,60139,28791,17984,46351,98683,109979,36519,69694,10737,83648,137976,83073,152118,141528,124821,145568,139724,89229,44631,15689,161544,159946,159581,66136,97365,7840,58256,16650,114419,142003,118137,80523,80239,127197,86258,94844,29380,114853,140444,28385,72833,153026,100816,36294,32420,96134,111618,15607,124276,108076,113714,116480,106424,56496,146826,122854,136827,46255,60912,68150,49953,162782,125908,32114,64196,88000,109112,80637,114063,34357,50462,70437,162462,110059,41200,77384,131807,59966,115224,116305,95200,69104,117614,148842,36233,149606,84147,52309,50454,15169,94828,70289,85972,29854,37447,114612,93183,73179,145885,74176,6384,115308,113387,88431,13405,30596,139184,40510,115061,31977,19629,84411,31882,139016,82467,61221,137311,147407,138143,26138,93108,59950,99502,24566,134326,7010,101282,39620,148257,145224,151929,131109,141912,130661,158459,30149,134108,92688,78283,62193,74034,12548,161607,119119,24589,93390,124607,161087,63548,28433,65209,89782,126549,132966,103170,47226,59345,66640,27236,150226,103694,115875,120668,130242,81553,119165,48356,154337,114354,148597,2308,139385,107572,35700,30448,116298,112603,40329,84777,104540,149275,36168,44638,93088,117616,69768,86184,67655,100054,4247,50298,150583,71131,53475,142619,84890,78366,159579,156971,148933,8571,160367,101618,114949,17287,73420,42126,39010,81130,26539,69698,88702,18587,4856,39501,24793,126501,6197,90093,64818,21166,158147,28927,50067,152656,6171,153437,41560,142126,68686,134536,132345,82523,9233,121697,125744,108166,83074,41258,96535,5027,59924,91098,53579,111727,161938,124572,32792,35834,97164,102127,58218,44396,47609,100492,81677,10184,8602,61359,163031,32989,107979,133012,96687,124803,105253,58196,84018,116124,133598,61286,65639,33986,40409,63293,142875,152935,9789,36814,8673,20180,112871,152755,77844,162334,63259,34101,145827,103268,21011,5594,13776,43280,13020,111953,12229,133534,158502,100888,56319,5180,10714,134945,131791,44066,57263,112670,136466,21887,45676,40395,46490,37730,144836,115104,134299,43814,109046,142931,20005,28083,9821,42389,61532,110740,83424,131678,69063,84007,139602,92738,679,67286,110006,134592,97480,54927,6743,98737,20555,16880,45103,163919,130147,37350,94343,78724,79752,59844,10081,106034,143834,87716,112262,30403,35655,162578,25010,94646,115026,41650,124580,85182,15209,61960,58711,38108,7604,4972,73388,145573,141756,33108,41973,25758,147006,29524,118942,10188,9440,78012,53806,81524,112337,24761,97992,67617,78048,12537,46212,36745,36101,122214,74194,10198,36759,129016,4718,51066,87894,128028,118894,156700,2476,80641,88432,96904,6799,85355,69589,100376,77805,114122,16970,33151,124786,152836,49711,141032,138856,109019,61652,19803,10038,84338,137130,7393,162608,35770,117236,4437,117663,79100,11280,22014,37800,83020,109728,1084,35967,122736,11026,38052,163141,137961,59639,79633,153794,78436,100573,115525,140747,11470,66050,158507,145822,142074,93962,150967,31820,85372,9245,144944,111085,160980,129415,44336,116465,134438,79071,118028,147785,61044,38164,21719,83236,119748,500,84521,150890,144934,96405,27238,99358,70714,98247,10925,132374,144360,134812,126919,93396,99715,10927,43532,101325,40683,19355,44506,132647,134826,2203,116534,116982,128688,144471,1160,129879,161674,92291,83804,21730,101500,46167,37697,120454,29256,14122,124779,35923,125710,10960,70758,157344,53984,93764,136312,37529,67000,141633,142419,119606,163591,27304,130406,67619,52103,64473,143990,20652,28147,54139,58051,126541,34108,47159,133066,90956,35517,156592,81950,112878,129303,87612,126423,123075,104398,163008,49514,35039,126972,65817,26749,78281,142935,26537,107143,30350,103294,94053,29143,144569,124167,56718,69162,56978,121277,131193,132555,131674,126744,73622,68490,130764,138885,28239,71626,62123,13511,129068,32018,33264,26932,138907,73037,85995,141222,144818,66368,1050,45391,134170,12634,78256,57953,128324,65784,32500,122810,163071,128821,51581,29946,63064,99525,30682,35060,80784,33549,115408,25334,82082,59967,85386,136701,78225,51910,50644,102274,35360,13603,38322,112024,65398,7923,149220,98600,122377,19913,149664,70932,80456,133276,140947,56482,41647,59055,124261,110808,104363,159558,76662,156293,61910,88056,6965,75104,112708,139893,157966,121403,141669,49526,109394,142690,35141,112360,110624,62091,150367,72716,140634,79116,395,3195,72165,154054,84171,123730,18502,104533,72031,47754,101725,20950,144498,111723,90394,159338,64319,125271,130757,47568,108872,123631,153474,6031,51053,137879,118613,80919,141008,65379,96318,11212,119548,7399,60316,85205,87516,31249,16872,17158,97227,103198,119690,29888,125389,36559,131826,51224,109398,106752,50305,109297,67359,62745,113333,28491,152193,91045,13707,159541,59648,94414,128046,9743,96520,114492,40602,40624,95494,53061,93079,114703,53173,85896,162420,37871,71125,88786,126608,34772,112321,111477,57954,48153,158431,95089,127230,146336,104202,4088,44166,77059,59515,7371,9287,54371,133744,4716,141543,85058,58741,122607,26490,133853,103176,42830,35382,75028,162624,100899,128418,155020,11730,114396,149219,142345,127695,63200,149496,65948,75552,23371,129553,68015,20569,159813,87350,7866,84175,156765,94261,157352,161220,81235,135796,84478,7272,91339,140067,76689,36424,97137,59853,47432,82891,121342,138898,136390,21554,136034,134615,120056,72888,29035,55433,28129,117274,112350,43237,64841,13956,130905,22359,22456,99273,10514,109008,149030,79575,6191,7990,118878,100526,3769,152198,119469,76068,30519,93867,98132,134517,96694,81502,148306,146915,92019,74915,57412,23326,45434,26496,141696,9558,160739,84059,22368,96298,116345,101478,68316,133275,93503,92552,94880,94565,141042,119214,30789,43589,113580,94806,124562,116442,106732,79197,8934,121877,37307,92806,111254,7396,26373,36663,71129,66548,150889,134622,163626,47022,141358,146258,124260,31046,44726,46985,63089,159189,110218,78385,84705,126051,90848,68615,135323,160548,70136,124610,73033,52453,135598,38541,91132,142379,138127,93269,57773,4258,11535,98129,157572,147468,90407,113855,30276,91179,144514,155890,46928,49870,7591,109760,92078,61242,112619,112016,26590,94972,65012,30307,2405,109235,128455,128778,93136,65194,90009,87986,16698,117362,14046,160093,71700,149618,24999,112673,106434,98386,122255,77912,957,115312,87381,49558,20474,94639,94677,56862,121207,63471,112065,11328,152079,96637,121255,163069,20529,22556,90728,52401,105371,81386,49082,142573,164049,129332,9672,83163,27635,107193,12178,66493,154690,155279,93874,153853,56876,127741,126309,82959,159051,12135,9603,48618,69155,124358,38247,119993,41001,90412,120975,41597,20525,42993,53000,6856,54162,9520,24584,59601,67453,13605,46651,98592,110868,21456,114645,97715,59126,119477,85631,158133,1486,87823,53956,42151,110432,95449,35123,146122,59980,124280,113212,56700,16120,58786,80803,14139,9746,21968,27177,77915,84536,16974,51805,153191,162811,51635,37546,82326,82373,3990,116251,107241,150300,53153,126826,38512,91130,117174,51542,133942,56420,120783,106049,134815,140195,1902,108486,97296,42208,9495,70160,130629,153383,161305,97932,126293,127489,115738,103920,101074,16587,63278,70729,104898,20863,67068,51543,120937,117032,56993,147361,162574,82294,160189,95182,11901,89328,44737,98413,62758,76612,44820,77010,94876,42215,121352,44453,41259,5677,84499,155556,91904,103901,114535,153910,64377,42064,41993,124855,8626,75762,50182,34138,68937,78565,163911,110578,80839,91028,109500,93738,63045,147308,4048,117756,100647,39928,73002,100726,46013,39987,31835,20350,133978,134850,45610,72773,141639,126688,65481,25409,163047,98511,78843,132465,112929,120843,127724,139735,142411,138419,120360,54099,63359,141310,1346,85380,20120,147792,142532,98124,44948,137382,28891,66248,78577,115007,35682,146314,88914,773,72439,11813,2167,81383,119536,82486,115798,67951,116317,139461,35084,156029,358,30167,34147,100909,36491,153549,3777,77437,98743,112052,107417,52181,5704,133299,123386,34353,95570,14788,85310,129725,11467,145716,129211,87428,93375,100352,163544,14467,134600,4266,64758,540,73080,9157,54193,156760,24898,86742,148752,7690,75943,33833,60892,28358,72604,78447,71216,28166,21085,163445,49151,135183,18797,31230,150867,22722,10573,29833,41112,70801,153533,119045,54881,99189,36920,92478,10169,158631,13700,4760,160807,70146,35604,85795,13058,111018,139748,35839,96664,2744,96334,111344,163027,99350,29474,56159,140142,77834,152746,74430,27263,10456,158425,116301,71764,62514,82112,83224,65083,43591,63481,124988,5900,38878,42223,70021,100852,88442,162912,97241,81214,91864,89566,131573,100235,19938,98080,51851,142620,43418,100212,152930,157555,102027,64890,49888,117356,81949,49470,44039,106131,10890,35609,71085,114402,96259,7180,58294,82154,153916,33013,114851,104924,54960,124576,153520,137331,29201,76799,113513,159201,149706,60673,8883,57685,123761,90841,158679,147892,88277,71715,71472,58900,76287,150537,100176,146848,7064,10596,64784,71941,60938,42475,79591,22448,113067,111007,15559,128221,89016,160186,35595,47308,12960,158617,73496,57262,160513,139924,161519,48568,9977,82571,138788,36854,98744,49860,97138,49722,54741,158797,102614,83170,121546,163659,161762,124403,157423,142686,159070,109848,63015,38675,83632,88531,6148,140151,95246,68204,44771,60692,114968,124116,58790,98059,153975,103662,62602,37087,55812,83608,124737,22411,159739,131861,61176,45198,119658,33716,81361,16884,51660,161051,148013,103378,156370,146100,158690,125443,12206,56782,58,79958,56566,117241,59782,121765,92588,12258,95971,47056,63122,101,41484,85774,26128,144544,2211,84404,22776,24785,91252,160195,138953,135121,1782,41102,38695,18106,105959,96472,91067,81105,33262,91757,102666,72620,39465,62122,154916,110000,48226,153783,138512,114952,60782,146882,869,92820,26367,110703,157365,4402,101323,84867,114118,150152,85553,108370,42837,8963,36181,16869,151824,26233,16051,106180,147470,151494,46954,102339,155151,68620,47873,117552,70515,7067,6430,57331,135588,133052,56424,53303,131907,42029,39925,146773,141459,48099,13473,82949,22825,96528,38460,33703,79107,101637,76869,52138,113324,116016,163703,138629,161945,2582,124031,25880,35546,150217,100546,105074,153658,8295,12743,10281,41662,43764,143344,143175,84073,85026,13194,95905,83983,27222,107727,54522,104944,121679,17004,60691,93334,162610,15075,4667,157005,160776,39146,108567,8093,124766,25251,20630,124601,12458,2004,2236,114094,61116,92170,90108,126173,147234,117655,119761,25564,138887,40291,73222,162627,107576,86494,99403,4577,29862,76403,46524,20274,154049,48465,153460,126161,82826,72683,127157,54240,148488,140281,30280,61235,107475,9972,145494,141356,15231,33464,4969,117163,162820,124138,143992,94891,83245,108324,16761,16264,71074,69474,121663,117498,147208,31390,86572,73329,128488,101642,17648,149994,155721,100913,59424,158079,106136,137188,73971,56964,19114,132848,36051,41440,123348,11307,123618,14564,94850,119269,139676,96531,3821,84594,41842,139011,55572,123684,68065,13123,39866,75755,81351,45433,138594,130063,71152,155445,1668,57180,118321,104691,51624,36123,46672,12292,2930,86546,121294,10571,31958,149564,80526,137332,75263,25583,114718,24189,75332,56877,43598,156244,105221,97697,118823,9374,141964,157820,26809,2791,21657,101362,163260,14281,147657,27658,87728,25946,60504,145393,42863,75280,124425,10233,23512,114108,132297,29246,149953,44513,68613,113473,66831,128486,8487,83946,7829,23894,7983,34314,128381,55462,136857,20335,16400,63497,30944,2408,97625,73712,51127,136715,156361,6938,60025,137230,86939,93178,146156,93483,3142,39994,32477,100848,12444,98420,52668,20955,75136,127993,100459,153563,30160,109328,136559,91266,75563,88407,92628,90123,139442,122643,54940,139510,129393,68750,36884,63095,21365,30583,39185,151977,148237,124931,155862,57980,20188,88535,50749,93643,39813,65946,111553,57437,81113,70366,18729,105079,120194,107196,19596,64083,153596,51997,124312,75514,56900,69521,49179,62780,44766,109434,113575,124599,29303,56998,7683,25949,152528,14278,154068,54297,138254,149700,99324,73604,162626,54776,73684,135035,106909,94799,130759,53971,89539,1768,119428,60716,85314,59942,13472,19685,35854,107906,49169,157664,161425,17495,14294,85105,111482,57816,132352,118724,88232,158805,93510,22469,99565,115036,144492,23925,129732,138279,76906,79216,78177,74932,129915,93828,10025,128757,152573,109437,71669,47654,51971,4888,52638,45596,158358,17966,44189,39468,113145,29026,125163,31296,138804,43802,63505,33510,115712,876,59672,29248,46233,31885,126829,58573,130447,69938,100735,139356,58830,56358,60468,5812,143804,109781,55372,99299,1476,77761,23550,104108,76614,84764,146452,111208,163971,73225,146179,13423,154140,78275,886,80299,95356,83713,109878,102625,65414,18693,32815,82197,75780,157550,51842,127150,119765,36873,13075,128084,71073,42353,133973,51216,42398,53226,87062,118911,19888,152588,29963,42829,10150,128270,134996,146562,36012,141449,28376,106901,153934,34489,122093,31141,32623,50160,98506,86856,58162,35573,71605,145369,42397,37225,73711,77163,141457,4127,101853,121498,156479,125444,4297,25649,41003,144250,154735,67741,18173,2479,27664,136523,132299,161065,28502,25007,91511,40727,153679,124672,102383,55240,147717,2464,162982,120495,125979,145751,47953,40548,132284,124563,10724,19005,76475,113282,134827,24747,99348,13465,114631,91161,41318,44909,6927,56741,133654,35124,85706,97220,117385,76712,91198,92468,119914,132442,91371,51099,26881,50702,128348,122829,91311,114576,69281,37750,53109,128286,47369,4139,131909,47102,17762,53775,93608,82514,135749,88866,153257,31580,154586,108657,1681,8966,124251,34872,53409,50916,133033,149351,34220,54885,59791,161239,36393,65289,152260,113632,154998,9006,79914,145704,121199,156397,159510,59218,17069,78147,60087,135456,113184,76367,62428,147348,88710,113699,34703,6523,31810,51962,52398,17109,229,59309,110698,68460,149021,15612,102130,96496,162524,143971,91441,14751,91713,83494,82882,62893,14551,155692,77845,13205,96730,57546,1676,143558,70699,44269,94365,141870,122334,94668,129986,88130,84224,32939,116362,32790,74178,163941,107395,109339,18065,119283,34669,24572,61168,35027,74064,80237,98525,96315,122164,19199,132623,113147,16471,52176,84644,123784,67825,149904,69193,106163,69608,52963,160358,135118,131549,81306,56570,105122,32447,59473,154416,135325,61133,98552,93053,3378,142685,40567,92753,83842,49512,46164,150282,158372,20836,161509,99379,24621,148723,126276,133530,14243,97331,118120,62322,17840,153045,35937,110998,5955,125289,152641,55244,50890,19253,55745,129758,25205,10965,87380,103997,107129,42744,52276,83931,95697,88578,127351,147452,47359,78952,56212,160131,105544,28884,112149,92870,154440,163486,97208,104193,157487,21450,11575,117735,89962,130158,136271,45076,116384,111717,33582,42430,7311,124123,155584,149431,80040,118981,90509,125741,66984,162263,129543,119128,81635,91975,54492,91686,38,120690,133739,54582,133968,59009,24019,158180,90365,132392,94905,124238,1019,120653,27314,25579,134311,150726,2129,142062,47355,19236,103967,78903,87244,38216,52473,141735,93904,2642,125321,33988,103145,5046,48096,147425,161109,28826,71686,41782,132476,21878,150773,80659,159212,27253,115205,38089,146491,145673,115124,34966,77307,137293,146476,138539,100613,86576,82457,89013,56724,42484,5894,2042,57350,153731,87751,16107,64378,124230,18094,32875,20853,46917,14154,138095,123223,39699,98618,66976,15885,15814,135523,142682,118111,146612,152889,43244,111403,36649,61755,67295,151623,13670,129623,70480,104750,79284,113562,83515,157893,118482,109954,25374,26229,144914,91063,148454,47243,3224,75758,128401,23553,17433,39445,67599,15017,93930,93949,129929,135851,20049,100165,2965,91042,38943,39373,150598,71456,97010,153056,156226,14206,69613,125441,17819,805,74956,101526,93120,158475,29055,88794,125947,69662,78417,65062,79805,116069,6246,143347,103958,20509,1984,109097,114661,64514,83306,131,55638,138599,21683,22652,134139,140128,27974,79602,121864,61638,109450,114560,89475,82705,135786,101133,55530,29966,71319,33431,5230,151280,1704,107333,100265,44911,3246,124032,65859,133208,163183,133478,64715,132381,7016,135144,112198,29439,94902,88090,18907,116822,122378,62918,11531,100825,116126,55573,157426,42351,136663,42650,4990,39707,38319,43052,38049,126263,104863,145244,138093,111691,138514,30737,53789,132188,77935,68929,5539,83323,33514,71923,67501,133351,123358,142400,47178,41719,162887,19670,145250,44949,32171,64276,11161,39678,134314,65819,138915,8326,143863,160620,21091,33279,123460,19323,94701,157691,17581,113272,43749,63933,2887,17950,18337,53673,116038,78711,64945,56547,75135,100783,26718,112651,62404,94595,114935,43441,104539,46671,27370,108522,24724,35193,71226,153649,19930,111224,78245,112919,86007,51965,146639,139983,91226,97659,107530,22005,36156,46053,96986,100373,157458,11822,37867,73933,82246,107055,18409,112830,105750,14775,140959,17611,65022,160727,156094,153984,108828,62476,109992,128345,70845,73291,107386,18976,67508,130325,46036,126333,140392,37163,21053,115433,151901,120082,81219,115522,102450,113981,35962,84708,136752,92477,110649,113737,8263,121683,149044,61903,98890,75778,46806,142537,20238,20755,124900,38230,96349,123823,58082,54736,64265,102671,50321,139709,8869,115577,143048,53222,18694,145420,65931,108020,105167,21749,153514,107406,72078,162104,122687,82499,39481,116342,30866,114848,29292,30861,111025,33317,37416,150499,28955,136981,114779,113715,84455,149280,99904,96908,77105,134238,62149,635,3950,99762,62518,63673,70818,70505,27755,64216,160734,84606,134415,29444,162766,44629,135920,15318,155005,15544,58784,121,65406,105142,94478,15167,68483,52093,84732,117791,45691,163355,112868,32556,21923,24691,90645,132215,11820,160840,114922,120402,75596,118342,14217,17842,60998,54612,151717,117747,97165,129039,97770,77169,7939,132683,141144,125276,12283,39887,18921,129092,99653,161906,39754,142702,122582,67965,121311,130347,21743,76608,1607,24371,95214,40406,139428,22726,14602,27049,121482,142067,46176,62913,19987,87540,11153,89297,45287,24833,92858,32319,70100,86702,162256,93353,86658,21696,70542,104800,145077,156939,83913,149396,135349,71721,82871,98329,15732,89621,130305,111867,68005,75113,93984,129180,77365,65079,134644,42553,63463,55233,55317,85290,96258,29641,134119,74905,74019,154240,128597,114723,138587,104088,120517,23575,66686,17650,33280,120470,95948,97890,127680,36260,141481,142790,10544,149319,36302,119190,143326,119719,141439,34204,139234,101724,9504,49422,61900,68464,150452,113959,150219,105549,91801,65558,128776,96266,157655,8651,118010,118599,98391,44446,114464,46997,34895,6089,42974,127136,57800,105370,59460,32473,12784,12920,158252,88962,17770,95770,1715,9471,77497,78429,45086,151032,2460,35807,108469,10796,124795,125812,108661,86243,75429,90245,157522,127272,132476,134818,20448,150947,94106,86609,19689,63656,89917,163162,157603,15419,133839,111656,80701,159723,56439,83982,34935,141783,34404,73673,267,136685,123163,119826,50317,134941,80540,130061,3333,97113,35478,50164,48369,98742,159508,76006,111542,134340,31576,89965,126376,61539,8662,10037,151711,28768,25750,130042,48386,133924,51648,39980,119640,39395,112495,128104,88086,137147,28498,158466,99821,44824,49005,141052,123043,45982,877,154663,91341,9618,105965,152834,7861,157222,141539,138283,57315,117455,96576,121031,146831,29699,72628,146906,85485,42470,133477,49908,85072,29983,137376,129954,13141,7097,117364,121774,77132,82606,157511,21689,159809,37178,6425,143478,9202,27289,37557,36488,155015,57264,49942,49446,42483,137449,121702,15041,59781,33056,7823,137830,14685,46120,107816,112230,132600,15860,73389,148968,15761,151342,12032,46365,122458,146400,142006,30809,156694,162813,106865,160837,52060,104428,4796,67771,47001,100484,3020,87688,144257,148149,69360,23386,120123,108659,106900,73781,94592,128137,132922,62417,47470,59793,135283,28264,160064,84557,102140,160143,129834,42067,126761,83059,142312,151918,82229,51298,77208,18763,40673,59861,91706,113416,48676,15898,4689,59127,130701,123881,22673,43960,93726,156763,17042,68809,99296,114818,127892,41919,98972,163964,12780,38235,137526,111417,89715,93532,70551,72353,3982,129726,37465,135575,64719,154065,57406,1641,49352,158923,122350,3708,104165,118540,89846,71089,61131,23751,28098,3059,12542,41923,48963,103766,156563,131190,121304,17085,25749,100465,39123,115647,139519,142273,80390,4370,23947,141828,34628,93341,87102,34352,103872,13291,148860,143416,32468,69244,148736,128880,48199,9785,158351,68192,121281,118651,71690,139608,86048,133205,139565,116725,121704,160150,146899,84559,163272,58265,39222,55412,88839,60134,8324,111076,80661,74016,56983,104683,24012,19051,120902,44806,23260,18380,145563,116999,98482,56427,30031,57085,121555,29158,52690,76270,38600,17834,157470,9505,4043,6873,46460,25711,104297,63023,30902,138189,128431,94048,70962,67206,52230,145189,74092,155173,129205,101420,57003,7471,26063,129357,3148,100836,111283,65443,140307,27498,17689,9675,65601,22879,79264,95777,150080,132529,72177,1165,156478,50450,128253,20661,59660,32737,29361,135247,108482,154914,64027,92802,59461,57775,47541,37460,28594,69288,144607,52137,87809,25587,22307,103075,150126,14523,16602,113533,53233,11850,38008,103332,17071,111404,88128,51555,7431,31111,70578,150430,150991,92496,30026,150220,53801,55778,22875,125278,156139,94330,135000,144881,101584,74863,132956,6496,148135,53293,118581,64434,106321,27382,19105,146003,47069,34832,69094,79004,139584,91337,125780,67801,88995,77300,122868,139317,127547,115200,94752,113439,70779,72107,158162,153389,6382,104574,20723,13009,128439,44438,149848,87582,128016,43711,131084,120387,128595,140025,24539,154467,11365,108312,1798,57523,52331,36632,120370,105798,25264,114880,143037,72346,10949,101857,100935,49241,31229,153074,151922,70487,112314,145961,140110,8994,3848,34890,95305,562,48437,73132,25871,33406,135715,18578,147947,34412,62350,95656,47447,34032,113351,95172,112541,82187,5705,156858,121653,102523,8217,25572,52698,127456,154822,43999,55502,161948,31983,99216,89348,9638,142173,45879,38986,39791,73159,124454,28426,147918,45870,12021,56716,47328,119514,60701,3094,39033,123172,53988,4896,13159,65834,7669,23180,34584,111571,158796,12717,64995,17317,138721,77946,57550,121618,2916,142657,79958,45301,124852,25854,71502,128818,73756,94465,123159,59712,83544,10480,70534,133502,161349,43468,136645,135734,43701,134061,145465,64732,9809,154490,136482,80732,55056,48092,129488,149483,93610,42102,155333,121652,74032,106766,80978,126381,14412,14898,21632,17284,112070,51206,160474,2498,70156,83905,78796,26698,65575,11244,12727,107279,19456,2152,161024,108999,132368,84282,125257,110811,121101,116278,30369,84873,22210,50870,65381,108903,157871,47099,158212,22261,114724,94204,53290,157178,94827,35307,7136,97503,24655,39058,118124,42040,6581,76413,18404,142341,157457,35878,98103,149421,98092,6608,99759,126419,110914,137162,141791,31930,5602,56981,133072,63031,115361,25747,129909,67612,133317,72968,137679,10136,131478,57021,138863,118375,123519,56389,126398,119648,108047,54356,119129,64590,128870,161030,115559,87864,110122,126817,51235,142724,111286,23057,38977,120759,76554,76820,130870,125512,47087,129467,57676,143354,5953,97456,144697,63241,161069,109075,105911,78682,12655,79829,29402,43788,151249,123721,145878,79619,88919,115049,32184,25504,62084,77621,98765,140727,98299,9899,44210,25027,56215,86319,86523,21544,14698,107012,51092,148353,1210,26310,90132,50535,77862,76483,13012,50998,77986,110358,117153,155792,136681,103674,74809,41777,151295,158474,61143,161686,17580,76796,43959,120042,22332,121739,4869,45726,52955,85786,149077,44138,139050,93135,89609,103972,17010,13901,154563,129508,153428,53193,5775,134127,98372,146756,19862,5116,121657,19724,27912,17189,154496,124474,73479,75505,20425,12109,151406,102465,122729,106957,161044,145775,147975,136608,48918,128296,80307,158296,45404,10754,41462,32541,35681,154311,94567,121811,10571,143085,24462,129760,89643,33735,62202,136551,140305,50670,37827,34455,141666,83869,19874,86271,12263,93677,94977,117672,48408,122777,97215,105471,27807,127684,57833,128001,22092,110305,140918,154605,138535,89852,62807,28414,41774,132185,134482,105991,66799,3210,27768,145906,140250,13289,48695,87349,53384,154784,116459,150387,84851,40542,5194,42677,136475,10242,55478,154528,151267,159283,49600,117023,37544,157744,77269,131448,108228,45622,125565,133780,141475,158354,61566,3110,147419,141991,7183,74899,46816,61273,21351,78361,14565,64290,15223,129628,116979,82272,130449,69593,101350,6477,55947,127573,88984,30010,145378,46849,122984,29714,146160,118562,106563,141210,145495,34424,692,1235,149665,102106,117695,144330,97622,71487,87030,160777,107472,16422,86254,113165,78301,112941,90105,131933,84774,29214,116107,80657,63476,20192,40437,89788,44682,50282,56233,54412,62104,107846,159790,72719,91727,26244,3637,104532,29622,63729,95945,92771,159715,130712,40723,21319,18936,100549,51161,30257,146081,711,153499,101710,71258,127882,152146,109818,80418,129383,112678,146459,78423,130838,96765,118932,118039,79927,122596,70660,152447,5066,60849,65730,138330,7323,15162,126471,112197,131174,87633,160489,154582,18161,124294,88601,69903,62634,111811,72945,32653,88847,113458,113945,36331,97028,141979,31210,40818,63054,75165,15578,101076,125324,144013,63790,87399,121241,148397,837,58030,90673,122238,35241,131426,46555,80744,79771,74727,111149,79750,45678,85999,163687,127312,49853,109271,151905,35282,45493,108928,136281,94834,148983,100420,77508,6378,135733,97103,29903,54353,49825,70918,16660,111154,103491,110826,58170,47510,154562,81751,164012,60747,17681,113858,50055,71936,117688,156344,50030,125146,41316,136727,122763,137714,94212,141600,11966,137384,157711,87029,91773,82546,121387,55338,130837,152028,13578,12016,69187,9376,127041,50380,77937,52278,82119,121947,136327,3002,124127,134103,135068,45682,58144,59992,5030,35775,162046,105025,21366,77065,57492,150084,111386,142218,29148,53148,77855,48876,43764,1300,55574,72999,130324,3253,6485,95068,139418,140745,52966,11154,25843,106802,107154,104579,150633,27477,150558,55422,113048,140850,30206,156298,88853,71138,73327,114741,41427,11579,17231,142066,49769,52742,57973,6368,16136,159881,130104,19403,138746,93137,39618,143654,26862,70288,20345,7936,128074,82703,158478,38023,27258,149146,70929,27414,263,152288,97292,78859,77707,74692,98734,145107,63887,54635,53214,9772,122653,8151,152680,121349,25431,102481,114620,162485,38632,151715,71117,161838,13023,106923,86304,110718,30123,31327,62562,76514,54959,154102,53074,112657,33021,29176,153764,95359,81379,123862,121522,143960,22534,60336,159775,22513,155225,83943,161890,82372,92833,68089,65838,54284,39778,128281,126269,31224,43342,72224,12370,161033,69223,63742,5629,152238,76854,97322,157473,38930,47266,4702,40991,75776,8446,160495,112148,152560,7863,68226,88350,92482,77224,72340,16721,68370,35673,163296,54914,71600,129201,43017,111356,16478,106776,22830,135359,124232,57005,143643,34885,143138,151935,126794,6660,22545,12610,163958,26448,56711,97731,45166,40555,77383,58904,138228,27403,100972,74785,75889,108707,124692,125378,93361,49985,39480,82821,87375,110732,27486,5244,10879,26988,101329,46991,129574,53016,90614,141188,5209,84677,34579,34185,137785,79136,8495,29518,28392,96236,73163,24583,10697,132857,89654,126182,19239,86345,669,22957,92897,4690,154714,41107,143859,126703,118637,129013,117719,129079,106330,42271,26944,88020,132096,78863,14662,49519,147866,143780,114027,75981,30241,147578,11429,12962,57564,82300,5354,110552,159677,150171,126547,158448,151119,162310,131088,155570,111630,111117,118551,48181,49744,38276,123746,61995,10332,42039,50238,35969,137633,67847,76449,75242,15940,36996,14024,113688,29127,54466,95998,140493,11499,82449,113231,3190,37664,37335,121062,116816,18658,132226,142383,84623,6134,98540,162661,109213,84384,159874,39284,66695,18176,23979,23504,67341,132462,124808,151113,55733,88164,26565,142721,140026,137890,44431,96804,128070,80221,17175,114820,51032,121932,94760,100391,87952,58828,14639,55261,119874,87445,80475,108197,80789,104789,55786,126206,163796,14229,57436,73060,109409,121570,83519,49148,86011,91302,5424,78519,77137,54029,94274,147371,43201,19583,106592,155989,55658,48813,96390,59681,96173,79792,10000,136000,617,90432,59741,124036,94866,74052,100915,78592,135149,1234,161218,49265,36834

[Wiebeltje]

Gebruik je PDO? Ik weet niet zeker of die dat zo ondersteund. Misschien kun je de regels code omheen ook plaatsen? Als je de limit er af haalt en je print alle ID's kun je toch ook zien of die uit de array daar al of niet tussen staan (ctrl+f).

[Jboy1991]

Wiebeltje schreef op dinsdag 3 april 2018 @ 23:17:
Gebruik je PDO? Ik weet niet zeker of die dat zo ondersteund. Misschien kun je de regels code omheen ook plaatsen? Als je de limit er af haalt en je print alle ID's kun je toch ook zien of die uit de array daar al of niet tussen staan (ctrl+f).

Ja ik gebruik pdo. Code eromheen kom ik nog op terug. Pc is zojuist afgesloten. Krijg gewoon resultaten te zien en geen errors van pdo self. Dus ga er vanuit dat dit mag.

Als ik limiet eraf haal krijg ik meer dan 100.000 resultaten. Maar het is inderdaad een mogelijkheid om het te checken nog niet aangedacht eigenlijk.

[Navi]

Waarom gebruik je niet gewoon de RAND() functie van MySQL om een random aantal records te pakken?

http://www.rndblog.com/how-to-select-random-rows-in-mysql/

Dat bijhouden lijkt me niet echt nodig met 100.000 records. Of mag er echt geen enkele dubbele in zitten?

[ Voor 25% gewijzigd door Navi op 07-04-2018 13:36 ]

[RobIII]

Sowieso wordt bij elke reload je not-clause steeds groter (en je cookie of whatever idem). Dat gaat een keer stuk, gegarandeerd.

The number of values in the IN list is only limited by the max_allowed_packet value.

Ofwel 4mb by default. Je voorbeeld (implode van alle values) zit al op 48,7 kb; iemand die wil klieren zit dan zo aan die 4mb. Los daarvan performt MySQL (AFAIK) steeds slechter bij grotere in-clauses.

Kun je niet veel beter ergens een tabelletje bijhouden met user-id en woord-id van welke woorden een user al heeft gezien?

Navi schreef op zaterdag 7 april 2018 @ 13:34:
Waarom gebruik je niet gewoon de RAND() functie van MySQL om een random aantal records te pakken?

http://www.rndblog.com/how-to-select-random-rows-in-mysql/

Dat doet TS toch

Jboy1991 schreef op dinsdag 3 april 2018 @ 23:06:

code:

$check_query_sql = 'select * from word_db 
    WHERE `id` NOT IN (:id_Array) and remove_word=false and seen=false 
    ORDER BY RAND()';

Overigens is dat ook een performance killer. Je DB gaat voor élk van de 100.000 records een random waarde bepalen, die vervolgens sorteren en er daar dan, wat, een handvol uit pikken. Order by Rand() is altijd een slecht idee. Er is zat over te vinden (zoals dit), maar, generally speaking, is dit niet echt RDBMS werk to begin with. Ik zou eens kijken naar alternatieve methodes. Bijv; shuffle de woorden in je DB (dus niet opeenlopend op Id / PK) en hou bij bij welk ID je gebleven bent bij elke pageview. De volgende pageview serveer je gewoon de volgende batch van X woorden. Dan heb je ook meteen geen dubbele meer (aangenomen dat er geen dubbele woorden in de DB staan). Daarmee is de sequentie wel a) voorspelbaar en b) gaat de sequentie "rond" aan 't eind. Beide los je op door, wanneer je aan 't eind bent, de woorden opnieuw te shuffelen in je DB; dat is dan eens in de X-tal pageviews een dure operatie, maar alle andere pageviews profiteer je ervan. Je zou dat zelfs in een cronjob kunnen oplossen en je "current record pointer" daarin kunnen resetten na de reshuffle. En doorgaand op die gedachte zie ik zelfs prima oplossingen waarbij niet eens een RDBMS van pas komt, je de batches al kunt klaarzetten op voorhand in (bijv) files met precies genoeg woorden per pageview en die eens in de zoveel tijd (wederom middels een cronjob bijv.) op 1 hoop gooien, reshuffelen en weer opnieuw opsplitsen in losse files. Of zoiets. Je "betaalt" nu i.i.g. élke pageview 100.000 rand() calls en een sort om vervolgens 99.99% van dat werk overboord te mikken en een handvol resultaten eruit te plukken. Complete overkill.

[ Voor 126% gewijzigd door RobIII op 07-04-2018 14:16 ]

[Jboy1991]

RobIII schreef op zaterdag 7 april 2018 @ 13:56:
Sowieso wordt bij elke reload je not-clause steeds groter (en je cookie of whatever idem). Dat gaat een keer stuk, gegarandeerd.

[...]


Ofwel 4mb by default. Je voorbeeld (implode van alle values) zit al op 48,7 kb; iemand die wil klieren zit dan zo aan die 4mb. Los daarvan performt MySQL (AFAIK) steeds slechter bij grotere in-clauses.

Kun je niet veel beter ergens een tabelletje bijhouden met user-id en woord-id van welke woorden een user al heeft gezien?


[...]

Dat doet TS toch


[...]


Overigens is dat ook een performance killer. Je DB gaat voor élk van de 100.000 records een random waarde bepalen, die vervolgens sorteren en er daar dan, wat, een handvol uit pikken. Order by Rand() is altijd een slecht idee. Er is zat over te vinden (zoals dit), maar, generally speaking, is dit niet echt RDBMS werk to begin with. Ik zou eens kijken naar alternatieve methodes. Bijv; shuffle de woorden in je DB (dus niet opeenlopend op Id / PK) en hou bij bij welk ID je gebleven bent bij elke pageview. De volgende pageview serveer je gewoon de volgende batch van X woorden. Dan heb je ook meteen geen dubbele meer (aangenomen dat er geen dubbele woorden in de DB staan). Daarmee is de sequentie wel a) voorspelbaar en b) gaat de sequentie "rond" aan 't eind. Beide los je op door, wanneer je aan 't eind bent, de woorden opnieuw te shuffelen in je DB; dat is dan eens in de X-tal pageviews een dure operatie, maar alle andere pageviews profiteer je ervan. Je zou dat zelfs in een cronjob kunnen oplossen en je "current record pointer" daarin kunnen resetten na de reshuffle. En doorgaand op die gedachte zie ik zelfs prima oplossingen waarbij niet eens een RDBMS van pas komt, je de batches al kunt klaarzetten op voorhand in (bijv) files met precies genoeg woorden per pageview en die eens in de zoveel tijd (wederom middels een cronjob bijv.) op 1 hoop gooien, reshuffelen en weer opnieuw opsplitsen in losse files. Of zoiets. Je "betaalt" nu i.i.g. élke pageview 100.000 rand() calls en een sort om vervolgens 99.99% van dat werk overboord te mikken en een handvol resultaten eruit te plukken. Complete overkill.

Bedankt voor je uitgebreide reactie.

Die 100.000 woorden moeten nog heel wat uitgefilterd worden. Maar dat nam ik dus als voorbeeld voor nu aan.

Kan ik dan beter in een aparte column doen met longtext en dit vergelijken. Of gewoon een aparte tabel met woord id dus reeds voorbij zijn gekomen

[RobIII]

Jboy1991 schreef op zaterdag 7 april 2018 @ 14:40:

Kan ik dan beter in een aparte column doen met longtext en dit vergelijken.

Neen! Zoek even op wat (database) normaliseren is