[TYPO3-core] Speed up of page cache
Dmitry Dulepov
dima at spamcop.net
Tue Jan 17 16:18:02 CET 2006
Hi!
Btw, I enabled slow query log and got the following queries execuring
for 15-172 seconds:
---------------------------
SELECT IR.phash
FROM index_words IW,
index_rel IR,
index_section ISEC
WHERE
IW.baseword LIKE '%konditorejas%'
AND IW.wid=IR.wid
AND ISEC.phash = IR.phash
AND ISEC.rl0 IN (1)
AND is_stopword=0
GROUP BY IR.phash;
---------------------------
and
---------------------------
SELECT ISEC.*, IP.*, MAX(IR.flags) AS order_val1, SUM(IR.freq) AS order_val2
FROM index_words IW,
index_rel IR,
index_section ISEC,
index_phash IP
WHERE
(IW.baseword LIKE '%kompots%') AND
IP.phash IN
(143215,189646,232543,245308,260728,339892,428940,449372,467995,474594,602248,649306,661156,687778,833258,844035,916618,921700,963033,970160,1001852,1076374,1101411,1129295,1288851,1380571,1406449,1418544,1560806,1641160,1686022,1841779,1910687,2112679,2126343,2133611,2164890,2186279,2198310,2247747,2495851,2552270,2726451,2753931,2816527,2878655,3001556,3058837,3177592,3294710,3308950,3317022,3389099,3504488,3607087,3793549,3805909,3919064,3919606,4012844,4026946,4140369,4159274,4312241,4445774,4591555,4677675,4680059,4862708,4864260,4881909,4902746,5183867,5255397,5268827,5285168,5301302,5517929,5779374,5808081,5899738,6064757,6110465,6129388,6131893,6255691,6265910,6290065,6319645,6337928,6381710,6396627,6472980,6475877,6547503,6573379,6608115,6646505,6737715,6783828,6855002,7184704,7247370,7318311,7354214,7362470,7424455,7446209,7462197,7472390,7475257,7572709,7581477,7610038,7706768,7722389,7742977,7746358,7785160,7854721,7953696,7976449,8119003,8134616,8300144,8356006,
8403543,8454561,8497674,8571428,8591967,8616161,8671013,8673687,8745203,8781161,8904652,8961908,9015782,9039281,9588804,9663257,9672104,9754555,9772959,9798659,9824746,9875335,9883314,9884988,9885414,10116924,10281826,10490029,10617231,10663644,10743998,10871497,10950105,10997616,11005425,11167403,11216917,11295592,11415597,11450582,11575125,11637308,11729062,11764798,11784258,11812058,12040109,12137846,12451112,12500975,12522179,12539612,12685519,12687793,12740088,12776731,12781255,12890266,13424733,13459603,13547519,13548123,13558169,13598848,13652571,13787986,13807681,13913132,13918622,13933243,14184198,14202852,14206547,14226196,14441879,14559832,14576186,14598818,14603377,14745933,14813466,14849002,14874396,15015042,15233042,15381208,15466829,15467621,15512699,15735310,15801815,15913771,15937620,16063747,16220530,16274540,16283036,16383262,16447629,16507000,16552851,16613932,16764403,16923696,16942374,17009967,17020522,17029818,17116065,17133929,17234479,17258356,1729415
3,17304201,17317818,17386545,17413827,17425242,17456366,17512512,17520212,17533512,17583290,17639453,17679480,17725755,17760925,17877803,17957424,18094346,18126513,18227234,18243678,18253419,18259151,18315283,18397016,18738269,18918955,18934771,19236149,19499294,19539966,19561714,19639326,19652251,19655365,19689573,19721820,19745215,19964773,19975263,19988270,20066050,20174142,20207309,20414814,20418807,20438184,20453794,20755829,20770098,20777314,20967432,21069969,21231320,21284274,21446680,21719201,21821587,21836889,21867171,21894403,21997230,22005869,22011826,22232133,22290380,22361120,22381870,22431161,22433129,22608465,22615300,22668327,22695074,22695970,22741416,22750278,22819345,22921535,23071284,23087541,23098331,23214469,23261577,23285066,23361379,23361422,23545601,23562794,23772121,23779079,23904194,23905061,23940261,23955498,23991750,24047660,24110268,24130909,24141091,24210917,24282919,24381359,24410731,24434097,24588494,24671229,24714845,24718803,24773711,2480266
8,24993750,25048702,25092696,25113088,25117554,25435974,25550311,25631315,25680029,25906439,26049367,26057197,26060534,26123080,26143134,26178090,26260212,26309446,26420385,26424109,26429279,26529229,26538450,26622484,26647882,26778714,26983643,27174239,27198291,27220670,27250471,27274609,27402257,27419934,27446629,27526106,27611549,27623395,27764298,27843699,27952956,27979961,27985577,28230671,28428757,28462825,28517733,28568259,28570849,28585447,28626917,28631199,28642762,28705042,28758805,28786034,28797797,28861416,29003962,29065030,29200066,29244581,29449912,29502230,29574260,29617221,29624288,29683161,29740624,29747354,29859126,30012415,30069562,30411642,30443409,30515782,30701093,30703700,30755416,30797853,30845636,30992164,31052060,31083573,31150888,31158445,31167568,31223867,31234941,31252379,31286783,31523010,31613192,31631828,31647638,31648281,31679515,31756768,31770371,31851456,31853119,31876345,31913835,31934427,32017219,32072504,32085770,32137325,32151592,3220555
3,32274460,32300598,32388086,32410480,32426599,32609464,32728461,32745629,32794899,32920659,32994484,33004621,33090429,33370420,33437705,33599465,33611406,33667698,33733323,33749992,33945214,34070256,34105566,34519626,34531461,34658243,34659266,34746654,34758916,34791675,34869250,34931811,34983906,35079528,35115424,35231471,35241723,35395944,35471880,35619112,35639983,35642906,35685115,35782264,35865376,35903403,35977315,36033669,36220513,36267122,36272812,36282982,36382728,36424612,36517685,36520863,36566445,36601858,36630755,36682047,36751129,36794213,36926898,36988844,37042147,37049068,37071894,37145987,37182015,37258260,37273248,37442458,37449588,37450590,37482409,37692475,37732905,37771330,37782311,37866179,37871077,38031311,38061247,38126278,38214840,38439520,38469932,38630871,38668140,38738835,38779428,38929508,38931788,38982462,39055373,39267127,39287377,39341121,39409982,39532494,39547627,39610122,39636396,39681269,39684397,39686858,39828928,40013090,40059364,4008621
2,40122056,40132550,40268072,40303893,40314712,40363390,40409014,40573935,40700572,40920693,40948243,40960566,41052520,41271337,41291105,41299128,41424486,41455910,41512103,41535445,41590413,41741616,41775347,41845002,41863474,41889188,41973544,41995981,42002630,42046076,42169642,42279822,42297010,42336586,42389768,42393820,42445303,42475141,42488141,42534066,42700446,42723064,42773667,42894021,43023598,43068130,43159191,43197065,43216027,43369285,43434293,43437476,43474209,43504834,43533164,43583387,43666112,43716527,43722941,43779981,43801852,43904280,44056452,44091118,44162188,44168945,44243479,44263552,44282410,44507194,44536233,44569704,44622968,44714430,44716383,44763587,44796026,44901473,44903840,44954405,45009881,45143941,45231756,45307320,45329746,45552157,46012788,46015134,46245210,46258870,46271846,46326081,46337551,46408160,46445837,46519438,46664714,46684459,46830119,46834179,46845748,47103642,47146897,47172155,47235036,47260911,47264613,47266710,47294992,4731491
3,47384533,47503023,47629111,47800876,47927535,47944093,47944225,47953197,48113377,48190190,48252644,48289194,48335765,48344815,48375976,48389062,48416865,48425868,48555336,48691861,48747080,48766898,48848238,48881731,48935129,48973689,49029055,49077311,49107369,49108932,49143386,49175532,49356925,49363575,49461428,49638206,49646971,49663491,49798500,50004725,50013878,50173575,50209448,50217914,50232295,50239802,50265278,50442974,50486063,50522086,50572513,50624182,50668257,50676852,50744458,50875101,50960121,51004742,51013835,51134604,51145949,51159323,51192982,51195606,51229703,51239637,51282984,51291693,51341330,51432029,51476468,51492458,51492964,51557093,51637536,51651994,51689130,51714164,51868515,51881985,51886319,51908269,51928828,51989234,52038930,52092762,52098939,52119510,52134944,52202614,52226755,52270900,52280941,52283438,52367310,52420700,52438079,52457119,52475495,52528273,52652887,52697890,52765091,52777857,52793118,52823652,52894904,52970103,53150001,5326463
8,53301606,53407552,53421967,53433007,53583826,53598727,53720168,53799211,53825799,53853287,53911267,53912134,53963526,53963627,54039555,54041912,54046057,54094541,54115280,54332652,54401793,54446192,54452065,54472794,54531442,54539900,54568853,54681678,54959673,54974524,55030957,55045518,55089288,55184039,55215854,55327003,55369547,55373248,55389543,55412950,55420768,55444296,55462994,55471183,55552388,55602540,55644349,55668079,55710947,55816003,56026694,56233287,56410846,56497358,56572833,56612470,56631943,56787350,56788174,56888736,56888987,56931980,56938775,57100943,57129380,57153439,57255844,57275219,57279340,57297313,57434004,57453363,57604553,57611360,57615589,57638676,57641974,57760908,57769681,57815185,57885474,57964464,58055984,58098581,58116305,58141143,58163358,58208034,58273521,58406945,58416738,58434250,58540964,58565114,58776321,58996663,59249212,59317650,59440863,59474046,59494190,59632162,59659635,59703104,59777603,59821105,59829235,59836223,59864023,5988302
0,60053190,60178070,60349555,60412220,60417469,60513443,60697690,60745032,60870153,60874004,60894240,60899331,60940266,60956152,60995728,60996178,61094692,61106270,61278564,61419995,61527727,61544527,61549898,61564533,61598829,61793401,61940293,62034515,62037288,62121785,62138257,62159075,62187150,62447631,62578387,62588417,62592052,62619472,62630502,62859258,62871551,62876233,62911605,62922911,62996911,63046736,63408695,63520789,63619080,63655897,63859130,63920045,63988526,63998247,64121226,64129544,64254572,64411654,64441517,64459871,64566591,64571036,64577323,64627715,64637216,64654328,64738768,64766978,64873808,64875351,64932302,64971036,64976500,65003201,65104163,65172823,65193756,65195123,65224070,65300894,65440281,65491233,65540506,65748947,65769267,65836112,65909654,65915390,65925569,65984537,66007908,66071600,66163338,66250674,66277328,66279472,66298834,66365505,66459061,66474040,66677835,66683066,66697228,66768894,66776986,66782033,66825672,66827263,66827630,6683574
4,66870886,66959257,66963353,66968496,66977670,67001182,67018475,67071969,67086687,67130491,67342467,67349516,67354795,67453092,67453870,67608245,67626885,67701439,67770129,67996220,68023754,68099774,68130604,68212569,68398637,68461275,68483775,68509849,68599121,68771389,68885127,68886521,68934693,68936659,68942171,69007455,69170841,69303260,69311798,69380496,69563869,69605390,69623569,69646018,69719320,69792993,69819622,69917201,69943499,70008581,70017659,70093182,70129332,70135865,70270466,70368717,70514727,70611581,70619368,70706173,70906785,70923634,70945057,71344452,71437688,71443913,71453320,71497629,71592954,71606550,71620593,71719406,71724597,71891587,71948997,71989104,72045191,72208025,72332297,72485764,72534846,72559520,72606819,72614337,72773182,72773814,72931327,72938182,73000286,73034951,73084519,73097468,73198158,73307174,73339033,73379733,73471312,73643714,73732722,73743318,73754411,73772148,73799606,73842437,73851460,73868083,73883379,73981097,74192607,7436476
8,74450095,74459205,74465080,74498538,74613764,74640962,74734005,74872608,75180632,75245892,75252348,75262184,75278648,75334003,75341271,75468115,75507616,75703283,75714843,75714985,75729849,76147381,76271593,76325404,76637538,76647167,76686251,76719563,76768677,76833502,76868376,76891435,76935208,76957000,77073181,77101221,77121725,77169312,77176128,77223808,77491321,77763197,77830092,77893408,77968395,77979177,78143578,78167778,78231809,78278112,78317197,78361621,78452107,78686621,78704433,78931212,78955229,78979681,79055791,79058382,79133816,79407761,79421521,79469159,79473646,79560392,79590262,79636667,79757950,79784234,79787388,79860060,80058960,80069257,80082782,80229802,80597578,80654194,80669599,80671582,80690359,80715549,80730960,80788638,80797493,80808434,80816819,80875316,80954202,80954519,80979714,81033975,81114195,81114708,81131279,81145984,81182511,81247817,81262128,81276154,81330814,81402096,81422773,81459913,81511106,81605770,81662936,81675327,81744188,8187957
6,81939591,82007109,82087642,82110454,82130039,82199088,82265709,82313274,82321194,82375600,82489564,82516234,82523939,82559757,82734499,82783890,82875673,82962122,83015608,83078761,83152943,83192528,83227417,83271287,83564880,83564983,83641290,83771128,83791953,83856892,83937468,83959492,84124091,84245968,84438454,84454468,84543091,84549766,84593431,84668535,84753275,84776878,84822212,84878757,84899527,84979206,85007750,85043613,85064765,85075921,85113075,85145363,85221694,85262562,85311150,85317818,85331080,85417196,85482460,85487781,85575552,85581828,85736396,85899378,86059982,86077768,86083031,86085939,86136335,86139097,86174262,86218131,86232283,86277491,86308798,86317356,86373243,86607470,86664669,86781622,86833078,86966284,87099525,87122393,87123508,87126974,87203746,87250918,87301485,87344181,87347795,87429857,87544591,87567173,87579662,87683398,87847156,87884502,87916667,88052489,88076023,88077687,88215173,88255800,88269775,88416553,88442630,88504674,88551607,8859013
4,88653231,88725750,88757839,88811419,88934930,89057187,89143208,89152660,89161943,89179794,89184888,89193871,89265421,89380207,89388953,89392351,89395486,89610586,89654296,89658393,89747881,89768639,89800026,89814774,89839459,89852200,89908120,89964481,90051103,90075164,90086627,90376782,90402735,90531906,90580405,90742730,90750846,90830084,90836289,90851718,90861947,90880396,90926106,90933565,90957674,90968208,90984319,91096936,91116244,91131000,91144600,91197871,91236339,91313471,91315110,91421779,91516218,91590766,91591088,91646997,91712866,91750379,91754118,91780017,91795035,91896124,91999904,91999938,92054406,92081143,92138517,92202949,92215453,92268475,92310107,92384372,92395766,92474565,92493673,92559902,92716131,92789920,92891495,93010863,93026160,93037165,93193975,93240100,93360616,93376463,93484590,93542483,93546074,93581476,93596511,93744980,93784570,93823702,93972917,94242151,94329088,94381333,94454529,94491723,94518217,94520149,94610875,94623405,94641574,9470094
3,94734597,94742445,94771527,94858255,94911257,94953006,95350529,95369551,95477022,95542767,95744016,95795300,95805150,95870998,96023291,96048956,96058456,96197237,96255089,96442632,96478757,96493257,96498465,96521432,96530796,96548115,96613278,96689249,96831735,96840029,96875789,96892721,96928229,97135264,97145682,97536480,97750713,97789579,97813365,97818207,97931891,97965306,98122941,98171806,98311676,98462469,98531375,98553601,98591598,98677528,98709348,98794515,99094521,99191597,99223528,99242799,99264607,99288559,99331953,99333760,99408472,99464798,99514084,99527527,99623528,99777285,99837230,99867494,99967010,99967334,99971189,99985735,100006649,100010047,100053323,100227636,100230945,100277386,100343109,100359670,100422494,100435776,100514913,100567070,100605195,100694374,100743453,100762117,100777404,100891154,100921251,101034654,101049875,101064636,101088654,101095226,101098675,101220960,101235794,101294499,101400438,101542169,101611708,101619024,101727099,101819531,
101849759,102223710,102288646,102308488,102416011,102468757,102475395,102548123,102551775,102561465,102568705,102576406,102693993,102761796,102875076,102892544,103060264,103084687,103195308,103252537,103493694,103660775,103722713,103762981,103886011,103962893,103999147,104000385,104209853,104262870,104341548,104510085,104522778,104666725,104717821,104784229,104869517,104999815,105017980,105100355,105120879,105127566,105238101,105243672,105404380,105404773,105418763,105439146,105465454,105717712,105751468,105796907,105847176,105895844,105943231,105943977,105947861,106120909,106165023,106204715,106316695,106583496,106749477,106795419,106801544,106845068,106923869,106950737,107009686,107074105,107132897,107190571,107202612,107232481,107242456,107325720,107647418,107790256,107809973,107940546,108044413,108117088,108145275,108164815,108182574,108187649,108254404,108266441,108269172,108270267,108283656,108335140,108374456,108516033,108527056,108615095,108639031,108696648,108829368,
108859067,108883478,108924603,108940222,109092067,109134596,109214674,109224245,109348736,109366155,109489580,109646825,109780889,109838193,109860654,109870858,109884481,109892460,110014087,110052441,110079076,110124260,110133884,110174855,110194368,110226460,110364751,110449750,110461280,110532281,110620867,110718201,110756556,110783283,111012781,111097452,111111618,111157963,111180360,111186890,111187646,111287178,111394301,111403039,111422505,111526667,111585002,111696943,111716838,111725643,111778933,111912164,111915816,112019978,112446446,112533584,112603208,112613119,112780377,112795307,112857484,112879572,112968355,113108973,113132489,113451852,113481538,113496246,113563854,113623113,113722522,113769186,113774746,113796470,113829289,113861001,113897823,113905675,113930971,113936224,114351960,114401273,114491803,114527603,114565186,114754457,114776668,114781884,114798512,114823615,114890687,115052503,115133678,115164576,115356433,115374993,115408586,115413835,115591295,
115620267,115729703,115866299,115942697,115959433,116154726,116167685,116173275,116302118,116343528,116418115,116489220,116578243,116624076,116627476,116630847,116693970,116718359,116788523,116799152,116862143,116915371,116919167,116974687,117014952,117022626,117376341,117573424,117576240,117642887,117897522,117925263,117928028,117928100,118031533,118055444,118063970,118065260,118151507,118160725,118353222,118445605,118564252,118603282,118644304,118740947,118741586,118767059,118774732,118851409,118856060,118872262,118873120,118965851,119041203,119432589,119718069,119728325,119811386,119832650,119878224,119929936,120092550,120123493,120140649,120318085,120332750,120416390,120422380,120490900,120598938,120783547,120810779,120815299,120817688,120872108,120879014,120966488,121237470,121256656,121323833,121328935,121523477,121535842,121536575,121658806,121665054,121792507,121831143,121863203,121879709,121986307,122031754,122041236,122182819,122340182,122378790,122474972,122497180,
122652377,122682469,122893159,122917525,122923569,122945223,122950571,122953424,122985752,123022029,123134960,123208863,123236244,123279210,123312652,123350613,123386638,123476699,123610662,123622476,123764786,123789449,123888047,123906432,123916496,124037613,124062991,124080263,124099658,124121951,124172065,124194770,124267292,124391057,124392604,124646174,124909917,124922402,124963658,125039270,125091719,125094134,125115731,125116253,125311449,125382366,125389922,125417310,125441010,125505609,125523117,125580672,125704174,125735435,125786666,125907823,126005071,126016051,126115953,126210665,126260714,126288472,126305128,126319433,126321767,126395319,126418691,126467026,126638426,126737785,126779261,126861428,126891362,127020397,127200309,127227430,127363727,127431409,127439504,127525204,127544740,127630732,127636213,127656463,127668935,127716013,127726573,127913425,127922734,128004967,128211435,128311887,128334348,128408334,128563680,128616958,128655676,128705410,128772306,
128813463,128820805,128994199,128998352,129004140,129019300,129050243,129146336,129245950,129325988,129355680,129456064,129459804,129486909,129537087,129558743,129612927,129720403,129754312,129801831,129928642,129958743,129960946,129968432,130097670,130221927,130261694,130332851,130399260,130543822,130575621,130611698,130611966,130771054,130779346,130792315,130807410,130835110,131009232,131106053,131140778,131273137,131287652,131400331,131443304,131464660,131587635,131645088,131670452,131824121,132037236,132108353,132124894,132177601,132311783,132330261,132351806,132352661,132362826,132458108,132563799,132601845,132724642,132757484,132798106,132885219,132967498,132974523,132975582,132979991,133058670,133077523,133120254,133135982,133142985,133171224,133368972,133371947,133390855,133550802,133566484,133589982,133603312,133634471,133667806,133745289,133909587,133948207,134186932,134224936,134243190,134252869,134287670,134478732,134495911,134516225,134563870,134621533,134747338,
134764865,134798051,134813957,134831266,134901289,134977288,134989243,135053255,135082972,135099659,135188738,135227131,135253454,135281130,135324604,135335198,135382327,135466592,135481614,135505388,135701763,135714250,135797016,135843033,135867933,135993193,136065854,136114487,136238777,136310441,136342713,136416473,136529978,136545882,136669600,136728796,136730043,136732904,136795976,136827449,136836019,136898999,136966107,137064634,137081576,137132554,137192527,137305724,137510935,137617465,137649450,137767238,137830822,137858980,137934005,137976987,138040698,138088848,138091367,138094397,138215691,138285552,138309082,138336016,138347274,138438520,138474071,138568946,138619040,138675126,138708046,138731253,138743686,138850049,138866223,138891198,138913469,138930068,139031645,139091199,139100427,139157768,139597414,139613953,139764322,139869658,139910680,140025041,140084954,140103519,140175797,140238809,140246267,140252395,140352000,140544389,140623537,140650410,140800240,
140896381,140997071,141011547,141115026,141233428,141299719,141473453,141577468,141589977,141602255,141715263,141767181,141872096,141939422,142061244,142096922,142205205,142205775,142254114,142288915,142291281,142346373,142354262,142538870,142588243,142619373,142785073,142792714,142795713,142801161,142819734,143064203,143103654,143231973,143311473,143378758,143381474,143548447,143734582,143748676,143793443,143811274,143844974,143854601,143880704,143896990,143976500,144203806,144250342,144254509,144285806,144322167,144480849,144518829,144546215,144636586,144640080,144665505,144762690,144798956,144814109,144833470,144918139,144959531,144970564,144998510,145008516,145056665,145081938,145132996,145181882,145184343,145305448,145391032,145405989,145430838,145583286,145618585,145619516,145719293,145720420,145738487,145768191,145857003,145861177,145922235,146004551,146100713,146178235,146184264,146240345,146390651,146433365,146438222,146510579,146588382,146692008,146726432,146744363,
146775670,146786021,146845407,146886699,146942433,147131868,147132199,147318182,147342111,147423751,147439322,147442706,147484740,147490091,147668441,148022090,148131631,148170184,148192669,148314448,148341294,148450422,148508042,148590641,148699032,148798297,148850951,149058143,149127186,149131660,149182183,149227250,149250591,149318827,149490043,149492052,149516351,149621803,149629628,149661002,149681162,149744537,149749594,149824925,149938064,150146981,150157650,150236690,150454123,150464518,150515130,150530652,150624068,150661299,150778563,150818198,150971326,150980778,150984164,151012993,151013906,151070328,151215568,151277403,151351148,151371812,151376734,151432423,151446064,151537256,151600299,151601848,151718958,151742208,151754669,151956439,152035547,152037683,152321405,152368753,152439713,152470314,152542462,152577987,152607683,152623691,152643888,152657484,152659120,152767507,152787285,152790691,152859266,152971629,152979579,153097409,153123439,153131356,153178390,
153198312,153275632,153385333,153491647,153560712,153602027,153677841,153711821,153746670,154033768,154161709,154223328,154547781,154584205,154614094,154635304,154645760,154682579,154724299,154734928,154769844,154774780,154829271,154843878,154978938,155003885,155004986,155084943,155118947,155121102,155126806,155133535,155164606,155200298,155413506,155453590,155549148,155649397,155659273,155670543,155679641,155731373,155865480,155896119,155916317,155959324,156106619,156136421,156158343,156209492,156260840,156399434,156459135,156467205,156576216,156578895,156653570,156805515,156933185,157005408,157123405,157171815,157223858,157251833,157268455,157301507,157352911,157401177,157685408,157696525,157703491,157719697,157753223,157793034,157884084,157893350,157941198,158047414,158122450,158169661,158176142,158263714,158333801,158420735,158526645,158533355,158544177,158604808,158650413,158784171,158824538,158826373,158827476,158828952,158895581,158930934,158932527,158985898,159046733,
159313472,159313837,159371089,159373212,159395708,159440290,159453143,159639195,159673286,159747770,159811437,160031434,160045638,160174005,160251950,160324491,160407175,160449179,160510234,160547187,160698929,160772713,160941706,160967112,161061945,161118219,161238949,161244426,161315663,161317370,161356376,161367371,161377850,161418209,161555339,161584601,161659559,161685735,161709844,161758900,161766313,161892373,161913144,162012109,162232645,162280538,162398639,162457486,162525200,162665996,162706345,162792253,162800441,162855512,162863097,162898019,162944454,163064226,163271687,163308529,163337950,163351470,163369623,163373233,163394900,163424829,163461895,163631779,163775671,163792002,163812716,163949128,163984560,164066754,164070755,164111006,164138281,164189021,164282319,164456214,164542958,164569949,164573939,164585889,164654060,164839744,164867967,164883378,165136039,165152482,165162992,165245999,165366644,165490261,165541521,165624763,165638828,165711920,165860525,
165916067,165961065,165975003,166164121,166210213,166332088,166517287,166530381,166567703,166749817,166758696,166782979,166813448,166883387,166955210,166966920,166991746,167221213,167232401,167314734,167330883,167446013,167457923,167523554,167589823,167616491,167639201,167674216,167703146,167728479,167760019,167763633,167799156,167856133,167926253,167981025,168007251,168079512,168097472,168114030,168201895,168226468,168313836,168387296,168432720,168568832,168572051,168654327,168740604,168857766,168875978,168987448,169121833,169167908,169274161,169286124,169447402,169617496,169652138,169984847,170017106,170029958,170126680,170226621,170249499,170321344,170341975,170414869,170429270,170551927,170560193,170664224,170742473,170786625,170805324,170872304,170888463,170922723,170926166,170973716,170977438,171078035,171083834,171157323,171235461,171283741,171314752,171336545,171383011,171421428,171462945,171715567,171846325,171904548,171943268,171970171,171999631,172024254,172042622,
172141725,172162151,172190288,172203984,172232281,172303915,172311302,172352883,172353541,172384392,172468429,172520920,172647898,172673675,172932485,172937329,172948550,172978509,173095606,173113262,173248335,173271383,173306448,173400214,173490983,173561361,173599667,173655221,173749801,173752287,173803990,173816545,173832501,173945443,173991564,173994429,174077082,174135556,174146777,174197231,174202185,174205321,174209310,174211745,174251704,174256471,174306385,174430532,174430600,174495227,174547549,174791985,174804102,174940809,174969001,175009951,175105431,175308834,175334080,175401530,175503187,175516593,175529172,175586331,175600499,175606160,175616586,175658677,175767052,175782343,175847328,175861480,175986909,176027629,176149347,176265873,176369399,176411032,176470207,176483649,176488004,176631947,176742752,176744182,176768144,176783290,176841359,176881927,176940113,177191128,177199354,177225889,177281977,177380675,177380766,177530641,177542574,177706447,177849380,
177979098,177989659,178015768,178021756,178042307,178113883,178456692,178574782,178583342,178691758,178894903,178976756,179035225,179132861,179144498,179149160,179192430,179276734,179370882,179454709,179511730,179657038,179787767,179794703,179946834,179985784,180103864,180250806,180263063,180288070,180309938,180394761,180469738,180482188,180554373,180683504,180771215,180779391,180943134,180951797,180990074,181218704,181229816,181296281,181332659,181361255,181387876,181430599,181625822,181820688,181857262,181881946,182193699,182201608,182215721,182245349,182312275,182313686,182419931,182470554,182580803,182615251,182690646,182860058,182872415,182873615,182882907,182918400,182942852,183025384,183129060,183226238,183271359,183314953,183464822,183622554,183637131,183693941,183709275,183751661,183846539,183922010,183947026,184003154,184110755,184111992,184301377,184323366,184444407,184514417,184519913,184535242,184584448,184594272,184606257,184640092,184696521,184707802,184889405,
184999621,185071254,185094096,185117033,185188136,185513942,185538400,185699859,185735683,185787072,185791265,185793154,185839774,185905700,185908505,185913851,186086897,186197549,186288330,186359816,186380860,186414248,186472667,186531471,186593945,186608494,186653949,186675411,186813120,186825524,186981734,187069517,187113519,187166814,187170486,187235710,187242764,187295126,187329123,187680304,187700109,187747928,187810385,187837777,187847136,187984517,188121029,188175840,188315058,188421229,188439273,188446622,188526653,188750401,188872810,188896738,188925941,189041755,189156381,189156578,189196001,189318672,189386601,189455598,189631140,189648020,189734365,189835204,189913576,189963605,190051119,190221201,190321467,190341741,190352353,190641260,190891548,190905368,190952292,191013305,191071937,191179515,191284007,191441319,191474526,191493876,191503506,191829943,191846069,191919021,191977454,192124148,192136773,192141745,192142661,192174017,192292222,192326458,192458847,
192484177,192530786,192644031,192648467,192712431,192769213,192801740,192822683,192896323,193084117,193248073,193273908,193308658,193323474,193526077,193651593,193702945,193792929,193824754,193859602,193894366,194071116,194086955,194223396,194315851,194367022,194467249,194495814,194837533,194865554,194910113,194970806,195016812,195058531,195085733,195504120,195508151,195520178,195627035,195790354,195802127,195901306,195958083,196020959,196066885,196113699,196119754,196150411,196188334,196359390,196369428,196419849,196460850,196505601,196710590,196710954,196776432,196895225,197034998,197042705,197109337,197124425,197184382,197491155,197522461,197640844,197830903,197891224,197899032,197909084,197937498,197947042,198083538,198142514,198350796,198360180,198408795,198424273,198477505,198545965,198738092,198845309,198850830,198995386,199022672,199062901,199241439,199311028,199313306,199418808,199459214,199568925,199624054,199887434,199903691,199908834,199963167,200021928,200030081,
200031418,200096463,200140431,200168889,200198969,200205321,200213979,200250007,200339226,200406446,200409008,200449084,200534886,200555810,200649092,200765128,200783472,201035370,201142356,201152403,201323784,201340303,201349410,201363929,201516959,201818707,201872563,201977401,202117635,202131083,202229861,202287794,202354605,202468681,202489129,202592365,202669670,202746923,202774442,202956999,202980913,202982058,202995550,203084827,203129744,203141325,203197041,203226515,203235449,203237748,203323373,203386628,203390748,203406599,203448736,203467295,203478491,203697065,203760231,203915498,203952171,203978254,204020404,204024158,204274408,204344143,204392197,204633077,204633540,204658070,204690645,204717179,204965574,205004533,205114970,205199257,205322401,205462003,205510591,205532542,205543820,205712642,205845752,205872999,205903519,206146703,206245934,206316916,206336847,206628435,206646730,206832918,206844771,206964512,206973153,206984231,207129108,207199094,207205186,
207224831,207412683,207481498,207501664,207564375,207593073,207609656,207672999,207691969,207695585,207995814,208084566,208161892,208211832,208219183,208255073,208279595,208328444,208335835,208416321,208493796,208494995,208498400,208561439,208574783,208718897,208758215,208764497,208806937,208963960,209009865,209097934,209145041,209220490,209417258,209448259,209525980,209593722,209594211,209602422,209720693,209753681,209760659,209793861,209814809,209817894,209882207,209903130,209910394,210176713,210194942,210222767,210441706,210485741,210494508,210497775,210593881,210644642,210741555,210756444,210808098,210927651,211105287,211108404,211210913,211305855,211316304,211410102,211532258,211673428,211704803,211713255,211730396,211786996,211881249,211971780,212048935,212171532,212178984,212219028,212231715,212302303,212413894,212479328,212509207,212527879,212566822,212772210,212828752,212851550,213073257,213168848,213349845,213458285,213593082,213597218,213640989,213659992,213670991,
213729941,213737214,213773652,213829243,213842125,213934040,214048034,214507287,214607595,214648624,214735635,214751721,214760353,214775365,214782336,215014424,215021580,215026525,215218706,215252120,215349260,215408565,215446849,215450562,215464850,215522049,215710639,215720780,215800023,215813907,215912551,215954674,216065907,216102020,216225321,216264977,216349586,216426381,216444578,216450706,216473304,216499967,216529769,216670167,216928261,216969590,217004078,217087383,217193116,217295160,217336231,217439775,217480137,217527358,217670728,217682187,217696904,217698564,217762216,217775787,217802643,217874721,218039379,218045915,218072774,218242094,218246978,218341901,218377312,218458507,218556863,218636170,218648893,218670885,218796964,218819977,218865702,218937093,218957613,219040652,219195387,219243592,219325908,219356880,219454630,219535401,219558408,219623277,219718580,219746838,219760436,219793991,219797125,219848842,219946222,220113599,220127695,220208569,220301726,
220383392,220457878,220513459,220550683,220559399,220592155,220649109,220673344,220824095,220828103,220846124,220957401,221021402,221125096,221261131,221266712,221293426,221419792,221454558,221482186,221592743,221639210,221649116,221702039,221732590,221754653,221755955,221771151,221847054,221902296,222022303,222045894,222106598,222143578,222185295,222293438,222300223,222481226,222527935,222533187,222588450,222646667,222760227,222761979,222768180,222879771,222901442,223150136,223396811,223426935,223514996,223535723,223538011,223590737,223664667,223712084,223842983,223849022,223900604,223921200,223941653,223953251,224041480,224121944,224143307,224189868,224206732,224289404,224422352,224437580,224534215,224592516,224666024,224720736,224877323,224938393,225123760,225152505,225152986,225218835,225300835,225382683,225438983,225439112,225472452,225508723,225535080,225618002,225622274,225630557,225680306,225705758,225781509,225979903,226200767,226225829,226247608,226266105,226299993,
226303512,226557686,226590004,226644569,226719036,226721539,226735031,226749535,226765074,226861285,226873870,226913698,226964662,226996842,227141359,227192492,227244552,227249111,227276897,227285302,227349198,227357046,227395354,227455480,227469321,227533045,227545153,227563442,227598799,227719074,227805414,227835275,227881519,228011629,228016670,228062450,228094016,228113314,228117484,228165299,228187137,228319382,228336963,228370517,228377013,228533380,228560892,228656852,228657593,228712610,228713366,228758649,228855335,229047882,229111074,229117617,229245368,229305446,229563143,229577842,229618466,229631201,229634942,229678538,229747188,229749342,229826069,230036551,230066632,230069024,230173085,230349984,230490764,230552825,230571879,230591049,230608481,230621447,230658022,230685532,230722369,230749443,230767070,230818174,230886637,231023045,231048754,231071986,231137176,231194215,231238089,231439284,231440564,231544942,231593263,231739081,231779429,231880640,231907119,
232086999,232130745,232188074,232297837,232334862,232396519,232467292,232489808,232531091,232580282,232720408,232905268,233021960,233036399,233070163,233256304,233333672,233339322,233420455,233638732,233796693,233835227,233921305,234009742,234087197,234089232,234098329,234176302,234254439,234366947,234371335,234415165,234472590,234487061,234513293,234677924,234695386,234917623,235020741,235035719,235040112,235163337,235181492,235543837,235669774,235688698,235723066,235744131,235761307,235871092,235967310,236012788,236051636,236111405,236231928,236238485,236256052,236261584,236318116,236378505,236392908,236504340,236525855,236529114,236550992,236558348,236659016,236699439,236713106,236716441,236860460,236880324,237096480,237179884,237182137,237224863,237240295,237270693,237318103,237323184,237344072,237383057,237401217,237405493,237429077,237539477,237610808,237638037,237639125,237727957,237774982,237789996,237803497,237817258,237856154,237924681,238038629,238041782,238099510,
238122835,238259852,238263225,238301339,238301803,238402156,238458944,238481001,238556948,238561891,238719498,238815118,238815689,238816517,238879001,238884572,238921789,239018055,239373687,239468189,239501195,239534374,239592391,239632186,239740776,239934289,239990663,240074690,240241998,240305518,240466336,240473080,240497762,240611873,240787746,240796849,240943982,240945483,240967555,241069305,241085693,241090036,241195144,241260301,241382444,241416369,241462225,241647021,241781598,241875739,242009904,242051723,242150162,242182819,242191347,242214217,242254459,242295516,242330276,242394883,242479610,242482459,242558510,242632762,242655841,242700274,242734624,242760307,242841739,242855226,242971204,242991175,243012947,243181184,243198164,243228050,243303158,243315875,243322844,243351013,243359069,243359806,243394818,243453343,243505111,243526307,243665196,243695933,243767967,243776722,243808263,243861084,243882087,243894515,244109892,244148471,244168503,244173056,244241406,
244242439,244266397,244327924,244355101,244507398,244511611,244564055,244848534,244852572,244882140,244906668,245005890,245017612,245071939,245099701,245178281,245222376,245429401,245446469,245482607,245522204,245575809,245638954,245696906,245805925,245924595,245968719,246002491,246090118,246129675,246160224,246188747,246192568,246202305,246223290,246275421,246352076,246365680,246409193,246424892,246452874,246454598,246611007,246687175,246694699,246962495,247044981,247138368,247150458,247259007,247277112,247480611,247498520,247557474,247915838,248019424,248092131,248119165,248249346,248379563,248408350,248453578,248589011,248622721,248720734,248797890,248938801,248994054,249024618,249069166,249394990,249624508,249696271,249817238,249820548,249908686,249973196,250006675,250035808,250056018,250241707,250439105,250633579,250654264,250938266,251048639,251086304,251090944,251138663,251199816,251255827,251355707,251491382,251493778,251536283,251580788,251634045,251777316,251859666,
251885087,251932971,252144406,252204223,252229284,252271804,252496379,252511846,252518568,252541119,252564433,252576674,252637635,252729178,252852143,252852602,252973922,253026443,253205710,253260196,253287595,253342638,253365570,253439366,253503609,253616976,253659256,253782176,253808967,253809627,253818885,253899270,253996696,254023639,254158547,254193999,254273056,254372906,254424806,254438889,254489439,254530226,254549286,254582849,254789299,254983410,255142752,255150908,255168356,255255701,255332297,255448129,255480218,255527428,255528707,255611028,255656943,255697876,255722521,256049273,256071536,256167476,256176580,256211532,256262204,256417652,256418695,256441365,256446647,256473000,256612611,256663849,256750961,256908846,256939637,256960735,257120652,257129102,257131580,257362740,257565493,257628998,257788094,257789902,257814191,257861247,257877957,257916006,257927873,257960694,257963712,258122878,258155899,258292067,258317688,258321118,258352910,258470085,258486059,
258498047,258695292,258766278,258808849,258808916,259155643,259267241,259324236,259368960,259388818,259413407,259498945,259579055,259646920,259832987,259840296,259897699,259919782,259946839,259954755,259960233,260011415,260019590,260279750,260340125,260351966,260380128,260461511,260521498,260527788,260563326,260617654,260666284,260814509,260938393,261098952,261242880,261243910,261280041,261315939,261385165,261404222,261456195,261533331,261693956,261828894,261957927,261988602,262115738,262180912,262192404,262319754,262340237,262577930,262579404,262594187,262610309,262687549,262722342,262783544,262834357,262885619,262897921,263012393,263043825,263048733,263060487,263118577,263137588,263142607,263226196,263292402,263313166,263359899,263411957,263521460,263559758,263586306,263635949,263801408,263814672,263836006,263962937,264062465,264243318,264271894,264317848,264328531,264411557,264475395,264535805,264580742,264632255,264737104,264738794,264934353,264956825,265134634,265139358,
265196358,265269011,265384567,265416104,265417970,265616051,265680049,265684865,265760554,265901741,265921874,265945583,266175152,266405562,266494922,266551708,266782860,266811413,266855685,266856444,266982389,266992113,267077020,267096269,267118140,267156048,267277284,267284045,267301969,267357802,267360431,267388253,267561931,267607860,267638721,268017047,268030685,268036786,268109715,268113698,268136304,268218427,268286249,268326927,268361193,268380998,268389974)
AND IW.wid=IR.wid
AND ISEC.phash =
IR.phash
AND IP.phash =
IR.phash
AND
ISEC.page_id IN
(13,2415,2860,5460,5411,4500,2861,2862,2863,2864,2869,2444,2455,5393,3859,2457,1036,4629,2458,2456,684,2454,2451,2446,1308,2445,2450,2452,2453,2449,2416,5091,4142,2418,4222,88,2417,2419,4161,2425,2421,2428,2427,2426,2420,2424,2422,2423,1602,4187,4188,1590,1587,1576,2441,2436,2435,4189,2438,2439,94,2440,2442,2437,101,4139,4141,4135,4136,4140,4138,4137,2159,4174,2434,2443,5041,5295,5089,5073,5072,5071,5042,14,95,842,1606,1608,1609,172,196,118,2334,4133,200,838,5711,5710,5709,5708,5707,5706,5702,5700,5699,5665,5656,5611,5597,5529,5528,5527,5526,5525,5475,5453,5446,5445,5396,5356,5301,5300,5290,2336,4190,4508,4274,3601,4895,4242,4149,4150,4816,3615,3616,4151,4148,5132,1621,4239,4238,4240,4244,882,2333,1099,1098,2610,3618,1100,1097,4047,4288,4287,1101,3617,165,1102,166,4289,5140,3632,3779,4961,5159,5162,169,202,446,4245,175,174,177,179,4833,2335,5251,4950,4296,3625,3624,5179,4056,2567,2563,2561,2557,5090,2562,2564,2560,2565,191,192,5137,4295,121,194,4110,3621,4243,4270,4269,4279,
4282,4838,4281,5247,932,930,195,197,4275,3613,3614,437,438,1317,3627,199,4280,924,4278,3821,3820,4268,115,4271,4292,3631,5097,4055,4283,4276,4284,4285,4286,4291,4290,4293,2316,4294,4241,1141,4900,163,3623,3642,119,840,5480,5261,1355,4593,3619,173,3630,3629,999,4519,1707,4157,4155,2258,1111,3639,116,1705,168,847,108,931,987,4984,206,178,837,5542,5541,5540,5539,5538,5372,5371,4724,4723,3603,4729,3604,2263,176,2262,1200,4834,2327,4098,4097,4946,2261,2328,3605,3817,1194,1196,1195,1193,4520,2326,1566,184,185,117,3640,186,1092,4159,4158,851,3816,4590,190,2323,193,5200,2161,2160,2162,4153,4126,1703,5181,1704,3636,1091,4623,205,923,203,204,4578,3643,3641,209,1093,4127,2329,2322,5025,1094,1700,4125,171,3635,3620,4169,5433,4759,4173,4171,4172,4746,5022,839,5609,5365,5355,114,1120,1124,1128,4089,1121,4095,1127,4092,1122,1125,4091,1126,1119,4090,4093,4094,3633,4611,846,1123,835,5474,5255,201,4146,187,2324,4849,794,796,797,798,799,2325,793,795,4128,836,4778,4773,1002,180,4622,3622,933,497
3,2264,1708,167,208,3637,3638,4777,5092,170,852,5502,5501,5500,5038,4892,863,862,853,856,855,854,857,858,859,860,861,207,834,5664,5610,162,850,164,4614,1459,5185,4827,189,5005,3591,4758,4124,4626,161,4595,198,188,849,4121,4120,848,4122,3644,925,4277,3600,3628,4934,4123,841,5451,5547,183,922,120,3634,5548,3626,5543,5545,5550,5449,4747,5553,5554,5544,5546,5552,5450,5549,4997,5531,3602,864,5496,5493,5492,5490,5484,5483,5482,5481,5478,5457,5243,5100,5037,5024,4964,1607,1610,1581,865,1875,1107,1106,1878,1879,1877,1619,2320,5535,5534,5458,5452,4579,4580,4237,4246,4226,4273,4721,2321,4272,5198,4625,4297,4129,4130,4131,43,1603,5651,5418,5407,5364,3593,4884,4465,110,3850,2544,3851,4609,4942,3810,4086,4087,4088,4499,4493,112,5176,109,4462,4757,111,5201,5276,5333,5332,5329,5265,5267,5271,5274,5268,5273,5269,5266,5275,5272,5270,5229,5282,5281,5280,5279,5278,5237,5236,5232,5231,5235,5230,5233,5222,5224,5226,5223,5227,5225,5204,93,92,5203,5209,5206,5208,5212,5214,5211,5213,5210,1599,5636,5
468,4728,1626,2319,4192,4191,4193,89,2318,5009,2259,568,99,98,4134,3734,4463,4685,4147,5172,4540,4751,5622,5604,5430,5361,4815,4752,4831,4770,4763,4769,5043,1600,5652,5638,5530,5389,4851,107,104,567,1706,105,4745,4848,937,936,103,106,102,100,4477,4474,4476,4850,4646,1387,5606,5524,5523,5473,5369,4300,4735,5099,1096,4303,4741,4209,4628,4632,1248,1250,1252,725,5249,1253,1243,1246,1244,1245,1247,1241,1266,1242,5144,2266,4194,2267,1270,4832,1147,4557,1604,5712,5629,5621,5620,5359,3724,3729,3728,2542,2541,5302,4517,4467,3721,91,2690,2691,2708,2709,3722,888,5171,4935,3592,113,96,3726,3727,90,3725,5152,5339,3720,4638,1605,5659,4154,4475,1109,351,3733,48,1108,1110,4521,1601,5246,4162,2337,4824,1199,1198,1197,1202,879,5303,4998,984,4854,4219,890,5294,1702,4164,2284,395,4970,935,2291,898,1201,5334,1701,4649,3841,5666,5600,5467,5383,5382,4820,4265,4247,4468,3842,3843,4469,4470,4471,4472,4473,4712,4642,4516,3844,15,617,5679,5532,5177,4968,4775,4772,4686,4591,4513,4349,620,4144,1272,627,6
19,634,1828,2154,845,844,618,1829,637,948,4350,624,4046,4348,3823,625,986,626,5657,5612,5447,5245,5148,4941,4606,953,632,2609,843,71,631,945,1818,72,1837,80,83,952,2588,638,910,909,1813,440,63,4064,4063,59,69,954,951,2623,2624,635,5694,4774,2193,2640,2635,2634,1809,2633,2643,2642,2632,2644,2641,1808,4356,1112,1806,1805,1804,636,1816,1824,876,1821,1819,1820,1812,2587,546,1822,946,1826,921,907,908,996,997,1814,1825,84,1811,929,1203,1815,1310,1314,1313,1315,1810,76,1827,4357,1847,5613,5158,4943,4167,86,87,1849,1852,1858,1850,1856,1860,4168,1857,1855,1853,1854,1859,1851,2539,2540,943,4855,4692,4589,1807,1823,944,1312,947,1817,628,5353,4879,4688,629,630,1526,1531,1527,633,942,1833,77,1830,1834,998,1832,1831,949,78,1532,615,5533,4641,2382,1844,2247,2248,621,1843,623,4353,4203,950,1842,1845,616,2373,2377,2374,2372,2375,2376,3805,3806,2388,2381,1846,2383,2378,639,5695,5489,75,19,279,5557,5556,5555,5165,5118,5015,4967,4944,4826,4096,413,2152,870,2190,1612,320,1613,4204,4206,4205,4690,
416,280,4654,3778,3839,3838,550,4538,934,871,281,899,5643,5429,5250,5119,5085,5039,5000,4969,4541,1192,1191,4651,366,5630,5167,5147,5146,5145,5088,805,2184,806,804,801,577,807,800,576,803,802,887,4753,885,4727,886,4202,3556,2582,2583,4817,2584,2585,129,5465,5461,5454,5413,5391,5114,5084,4985,4893,2543,390,336,417,1617,1861,3803,4208,4227,4835,391,1615,1614,1616,356,1618,1869,3607,358,4713,4223,392,4640,1872,361,362,363,1871,3611,393,389,1868,1873,602,4645,3608,359,360,4695,3609,3610,131,2340,5598,5380,5007,4995,4989,4988,881,4524,322,379,381,383,880,4494,4359,2605,2606,4776,296,4596,368,1154,343,4616,4510,4607,4581,298,4536,4718,4019,3836,4710,4856,554,4498,1641,2600,1639,1640,4495,3837,4821,3612,2153,4514,4496,1598,4360,1904,2342,5697,5641,5477,5402,5020,4506,4507,4624,3840,1920,1928,4526,4598,371,4726,2343,5667,5094,5017,4945,4933,1892,1899,380,335,1903,1893,334,2265,367,372,4248,1905,1894,378,382,4725,4722,373,1891,375,1907,1906,1895,560,1897,1901,1898,4358,1885,1886,370,3
23,1900,384,1909,325,1884,2344,5298,5297,5296,4918,4917,4853,2279,1654,4522,310,387,1653,4527,4594,2345,5562,5561,5560,5113,5112,5111,4601,4518,350,1103,1104,4568,1113,1115,4525,1114,285,376,377,1116,299,1638,4201,4207,1117,4200,369,2341,5696,5637,5498,5455,5263,5256,1918,4761,555,2601,1916,1910,1913,4523,283,1919,374,1911,1912,181,5047,5479,4878,5021,4502,4592,328,5046,5605,5103,316,1095,1644,315,1647,314,1646,1643,1645,4528,5048,4363,4694,386,2351,2292,5044,5704,5633,5354,5149,5098,4343,2616,2617,4177,1503,553,552,2186,4689,2603,5040,2599,2602,2604,4497,3647,4221,330,331,1269,4615,332,4163,4179,4180,4178,333,4999,327,3815,2286,3814,4857,4974,5045,4362,4361,312,385,311,4996,5049,1642,326,130,5056,5645,4637,2548,3848,3849,2545,2546,5019,2547,5053,5634,5511,5510,5509,5508,5507,5506,5444,2615,5060,5647,5632,5175,5174,5153,4647,321,5054,5648,5631,5138,5136,288,4301,4302,4828,289,2185,4823,4818,4822,4559,287,292,4858,4830,4734,4813,4644,4829,317,4881,2157,4762,883,5051,5649,5409,
304,295,349,302,4842,5052,4825,4224,306,308,309,307,5057,5596,5456,5374,4515,5059,318,319,439,5061,5650,5170,4143,3606,3595,4532,5055,4990,4991,1637,2621,2622,5058,5476,5443,5442,5390,5157,1139,3824,3827,3826,1143,1142,1140,5050,5655,5644,5642,5635,5469,5441,5440,5439,5420,5410,5292,5260,5169,5133,5117,5115,445,447,282,3829,284,3828,182,5068,564,400,399,406,5028,5067,5401,5252,4531,397,5064,5116,565,561,2620,4698,2618,5065,2619,2282,409,4947,5062,4551,421,398,5066,897,404,3594,5018,5063,4529,566,5070,5705,5701,5698,5689,5417,5404,4814,4501,402,4652,403,407,563,396,4530,410,4543,408,551,562,401,4217,4503,4894,18,4976,5663,5662,5661,5584,5583,5582,5581,5580,5503,4977,4081,2494,2270,4083,4082,4602,4603,4605,4665,721,5381,4966,4195,765,1651,2288,4431,4432,1655,4196,726,4262,722,4434,4433,4428,4430,766,4427,4429,4435,4691,764,2681,2683,2685,2684,2682,2693,2698,2694,2695,2697,2696,38,5576,5575,5518,5415,5357,5264,5131,5130,5129,5128,5126,5124,5123,5121,5108,4994,4993,1081,1083,4673
,138,136,144,143,1656,1657,1658,1660,1661,1659,2180,4677,137,156,1628,1630,1032,1069,1029,4675,146,4702,4668,4705,4216,4840,4210,4704,4663,4674,155,1631,139,4620,154,1629,573,575,574,145,753,148,3891,4537,983,149,4703,142,4672,3890,141,140,2405,1068,4664,4375,5259,4051,157,2476,4050,4049,436,569,5703,5590,5589,5588,5587,5586,5585,5499,5464,5412,5405,5398,5370,5363,5199,5087,5081,5079,5006,5004,5003,4972,4960,4937,4687,4566,715,4048,3652,3856,3857,3854,4298,4299,891,873,4612,3855,720,717,3893,3894,3852,4860,4841,990,2629,4618,780,4743,703,688,1636,699,2338,4549,700,877,701,760,2576,901,4504,3808,4610,4550,928,680,3896,3895,2257,989,4533,713,1267,677,5602,1035,2191,1031,1030,4264,759,728,1118,2192,4235,4236,4234,4233,689,731,729,1623,1650,1649,1648,678,3788,3789,732,3792,3791,3790,679,767,218,730,763,1622,442,4438,5624,5513,5186,4852,4542,2631,2613,3513,3517,3515,58,2630,4437,5569,5568,5567,5566,5565,5406,5368,5184,5105,5101,5096,5095,5078,5077,5010,4899,4883,4880,4836,4700,461
9,782,3809,778,783,2269,2645,706,3518,707,697,2497,705,874,784,2268,3589,3550,216,785,4062,914,3645,2277,2407,875,434,4374,5168,5134,3818,3653,2534,2532,3519,2499,3520,2158,3514,3516,761,3819,2285,771,769,3524,5640,5639,5403,5399,5388,4962,4716,3530,4459,3532,3535,4621,3529,3526,3527,3533,3534,3531,3525,686,4448,1624,4183,4185,4184,571,1034,1033,1084,3835,4199,4198,3801,4450,5658,5178,4992,4938,4558,4266,991,4453,4455,4454,2625,4452,4449,5135,5082,4631,4555,4460,777,1652,775,776,687,2500,2580,4342,4451,4457,4458,3646,4373,5592,5591,4959,4936,4898,4441,4444,4442,4443,4403,3853,695,2194,696,4440,4446,4445,781,702,4447,919,4439,4371,895,4766,894,893,1028,4750,892,1021,1271,1022,4739,1023,1024,1020,1025,2252,5435,5262,4897,4896,2250,2251,2249,4819,4261,4260,4258,4257,709,4259,2574,4351,4352,4347,2253,2254,673,5619,5002,4971,1082,2156,153,995,992,993,994,3794,3793,681,1189,4714,4701,2273,150,152,4511,4771,723,2274,724,4653,1190,683,674,124,123,675,676,4608,3651,37,5571,5570,5517,5
516,5515,5293,5180,5093,4707,4706,660,666,53,655,658,657,654,1066,656,667,668,62,653,67,125,455,1027,2533,127,652,454,4613,4505,1625,2627,2187,2189,2188,4263,692,693,441,2536,2537,2535,2538,669,671,670,54,55,647,648,56,572,645,661,646,52,3834,1067,453,762,1026,2181,770,1018,956,756,757,1019,4599,896,51,644,641,642,665,878,50,664,663,913,772,659,650,649,651,640,49,126,60,61,4372,4419,755,779,754,4420,5437,4539,2182,685,4414,4417,5660,5494,5154,4412,4256,4255,768,4416,711,2183,712,708,4415,2578,4411,4413,3802,4370,5617,5616,5514,5505,5504,5291,4979,4423,4676,4254,3899,758,4426,4424,4425,2260,1086,1017,704,4565,4422,4421,2406,719,714,4376,2933,2937,2939,2938,2940,2941,2942,4390,5603,5400,5127,4655,1268,1880,1882,1881,1085,774,4395,5625,5258,5001,4534,4397,4396,4398,4405,4399,4407,4404,4400,2577,4408,4406,4402,4409,915,4389,5627,5626,5623,5512,5156,5008,4600,4382,2614,4380,4394,4387,1071,4392,4393,985,4385,4384,2575,4391,4386,4388,4379,4383,4381,17,133,3495,5459,4981,4980,4715,35
85,3496,2486,1634,2487,3499,788,866,2484,2489,3498,3501,2488,789,3500,5160,5164,5161,5076,5681,1006,1012,1007,1005,1009,1008,1014,1010,1013,1016,1015,4953,4839,1011,5075,5653,4553,2309,2312,2314,2308,2313,2311,4552,2310,4951,4570,4597,4575,4564,4573,501,4577,4574,1089,545,541,542,543,544,500,5012,4587,4586,4585,4548,4547,4546,4544,530,1070,534,532,540,533,1209,535,536,537,538,539,531,499,5163,5109,525,529,526,527,528,498,5110,4561,520,519,521,522,524,523,497,4635,4584,4576,4563,4560,4545,514,517,516,518,515,496,502,511,512,513,485,4582,506,491,505,495,488,486,493,510,507,489,494,3587,3586,508,492,490,509,487,787,5713,5683,5654,5601,5107,5106,5104,5074,4957,4837,4588,4569,2408,2687,2689,867,2688,1090,132,2932,5690,812,4859,4787,4779,4780,4783,4784,4785,4793,4792,4796,4798,4800,4791,4797,4790,4789,4795,4786,4802,4803,4794,4801,4788,4781,4799,813,4782,2930,5362,5034,5033,4175,889,2579,1841,2929,5599,5366,5102,5036,5031,5013,4954,4948,809,1207,1087,808,811,810,1088,790,791,435,29
31,5392,4965,4958,4805,4804,3885,3888,3861,3862,3864,3886,3887,869,3863,3860,3865,3884,3866,2936,5680,5408,5395,5358,5248,5032,5030,5029,5011,4956,4955,4554,1208,3796,1206,1205,16,134,1368,4760,979,232,977,220,970,969,973,975,972,971,231,227,980,221,235,234,982,978,233,1336,219,228,229,981,976,974,1382,1321,1320,1369,223,1323,238,1329,1328,1324,1326,222,1327,226,225,237,239,1331,236,264,265,224,1370,240,242,249,1319,247,256,252,253,245,251,244,241,250,261,263,266,257,254,246,248,243,259,255,260,1371,1418,1416,230,1364,1366,595,596,580,600,604,4105,601,606,597,605,603,599,598,4103,4104,590,4099,4218,4100,4101,4102,1563,591,592,593,594,579,612,586,610,582,583,584,585,614,587,1564,613,611,589,1562,588,773,581,607,608,609,364,2888,5607,5436,5426,5424,5423,5385,5384,5155,5141,4630,4617,3374,3373,3371,3372,3376,3378,3379,2905,3377,3141,3142,3393,3155,4253,3387,3883,3882,3388,3389,4252,3391,419,420,2611,2612,4250,4249,3139,3878,3879,3880,2906,2903,3588,2910,2909,2948,3881,2498,868,2
902,3392,3375,3154,414,415,2949,3875,916,418,917,3877,3876,4251,2901,3390,433,3156,2891,1065,3873,912,3301,2784,3872,2889,5386,422,2911,2912,2947,2893,5463,5304,5143,5142,3283,3316,904,3157,423,3281,3282,3128,3300,3319,426,3138,2946,430,2944,2945,3320,2607,3318,425,3322,3321,3310,3303,3311,3297,2943,3317,411,3302,2892,5448,5434,3152,428,2894,5628,5618,5615,5614,5466,5462,5425,5419,5416,5387,5254,5253,5166,3325,3312,3323,3314,3328,3326,3329,905,902,1635,3296,3279,3280,427,3333,3327,3330,3324,911,903,3313,3315,429,1262,5686,5688,5684,5685,5431,5432,5421,5491,5422,2289,3417,3414,3413,3410,3408,3411,3409,2290,3412,3416,3418,3415,2003,4709,1709,5125,1771,1720,3867,1711,3869,1714,1717,1710,1712,1715,1718,2396,4886,5083,4890,2397,2400,2398,2399,4889,5173,5338,4885,4887,4891,4888,3812,3813,3521,3522,3830,5693,5692,5691,5336,5335,3832,3831,2410,2412,2411,2402,5299,4697,900,4165,4166,2403,5497,4696,305,338,2331,2332,4182,5086,4711,4181,5150,5151,2271,5427,5608,5428,2598,2593,2589,2595,
2592,2590,2591,2596,2594,2597,1611,337,3420,938,2573,2549,2552,2551,2555,2554,2553,2281,2280,939,2272,3811,2550,475,748,2036,2043,749,2034,2035,734,2038,741,739,742,740,751,2030,4042,4043,832,750,2032,819,2040,2037,2045,752,821,820,822,829,831,823,2033,744,733,738,747,826,824,4492,4491,4487,4489,737,2039,2042,745,2041,4485,746,825,735,833,736,4486,2031,2029,827,828,958,4036,2831,1774,1078,1777,1080,1773,4071,4072,4067,1772,2829,1079,959,4078,1105,2830,4075,4070,4074,4065,4069,2283,4073,1686,4077,4066,4076,1687,2294,4068,2833,1775,1778,1787,2296,2295,2243,1802,1801,1800,1799,1798,1788,1803,1797,1796,2245,1786,1795,1794,1793,1792,1791,1790,1785,2278,2242,1784,1779,3874,1782,1783,2246,1781,2330,1780,2244,1789,2241,2300,2306,2822,2813,2808,2821,2305,5027,2885,2303,2302,2882,2886,2298,2301,2884,2883,2823,4708,2824,2887,2826,2227,4873,4003,4748,2229,2155,4931,2056,4059,4874,2511,4031,4875,4002,4764,2148,2230,4032,2847,2849,4876,4669,4667,4749,4670,4033,4932,4926,4924,3661,4662,4061
,2235,3552,3557,4756,4755,4754,4744,4742,4717,3567,3565,3562,3566,4079,3770,3582,3583,3558,5023,5016,4765,4740,3584,3774,3772,3773,3570,3771,3559,3578,3569,3797,3576,3572,3563,3777,3573,3798,3574,3575,4080,3564,3581,3580,3579,3775,3776,3799,3577,3571,3560,3800,3568,2502,2659,4583,344,2661,339,2660,2663,2662,2664,2665,345,347,2673,2677,2668,2675,2674,2667,2669,342,329,341,346,348,2666,2507,2521,2519,2520,2531,2522,2518,2530,2509,2508,4952,4509,2525,2529,2524,2503,5394,5360,5257,5244,5080,4949,4847,4843,4844,4845,4846,4512,2516,2523,2527,2517,2505,2526,2504,2506,2528,926,2859,5183,966,3590,968,965,2857,5182,5120,4693,3807,2636,2637,2638,2639,1835,1836,3490,1838,1839,1840,3491,2858,5035,5026,5014,4978,4720,4699,3822,3597,967,3599,927,3553,3554,3555,3596,3598,3650,964,963,962,961,3549,3551,3548,3492,960,2293,3502,4627,3507,3504,3505,3508,3506,3509,3503,3351,3352,3355,3353,3359,3356,3357,3360,3361,3425,3428,3426,3427,3429,3430,3431,3737,3755,3756,3757,3764,3765,3766,4307,4313,4312
,4311,4310,4309,4308,5305,5308,5313,5310,5309,5315,5318,3929,3930,4882,4001,4000,3999,3998,3997,3996,3995,3994,3993,3992,3991,3990,3989,3988,3987,3986,3985,3931,3982,3983,3975,3974,3977,3980,3981,3978,3979,3976,3932,5714,3970,3969,3971,3972,3973,6,1062,1064,1063,1188,472,2054,5217,483,1696,2201,5218,2048,12,1217,1076,450,465,11,463,8,4913,5378,5377,1074,1073,484,3469,3719,1000,3968,461,26,3454,1883,3870,3451,2839,1204,3453,3446,2404,2057,2871,2058,2059,2092,215,2165,2095,2061,2088,2104,2062,2173,2063,2470,2175,2064,2065,2066,2067,2171,2069,2068,214,2170,2071,2496,2172,2073,2096,2075,2177,1075,2168,2072,2166,2079,2080,2178,2081,2097,2169,2179,2099,2082,2083,2098,2084,2174,2086,2087,2101,2100,2089,2090,2074,2091,2102,2469,2085,2103,2176,2093,2094,2105,2077,2078,30,5375,3354,3482,3736,4337,5321,4336,1697,3752,3468,2395,5216,5330,3437,212,1072,2647,4870,818,451,4058,468,1001,3732,2491,3892,4346,4812,4730,1318,2926,29,5521,478,1004,2928,786,462,28,1187,2855,27,3472,1279,3285,1498,
2686,1240,1688,4057,578,4807,815,4919,4808,20,4682,4684,4683,2464,4109,4108,4107,4106,3754,3938,2465,3753,3787,3731,2466,5219,5522,5379,5331,5220,21,872,22,1138,1077,469,470,3470,3444,3445,432,3218,4338,5668,5193,5194,4982,4983,4920,4921,4871,4872,4810,4811,4678,4681,4482,4680,4365,4679,4364,4340,4341,4339,3223,3222,3221,3220,3214,3213,3212,3219,32,31,34,5348,2741,1186,816,35,2,1)
GROUP BY
IP.phash,ISEC.phash,ISEC.phash_t3,ISEC.rl0,ISEC.rl1,ISEC.rl2
,ISEC.page_id,ISEC.uniqid,IP.phash_grouping,IP.data_filename
,IP.data_page_id
,IP.data_page_reg1,IP.data_page_type,IP.data_page_mp,IP.gr_list,IP.item_type,IP.item_title,IP.item_description,IP.item_mtime,IP.tstamp,IP.item_size,IP.contentHash,IP.crdate,IP.parsetime,IP.sys_language_uid,IP.item_crdate,IP.cHashParams,IP.externalUrl,IP.recordUid,IP.freeIndexUid
ORDER BY order_val1 DESC,order_val2 DESC;
---------------------------
This is not related to cache_pages but needs optimizing as well.
Dmitry.
Dmitry Dulepov wrote:
> Hi!
>
> I was able to speed up page cache quite a lot by adding index on
> "expire" field in cache_pages. One moment a single instance of mysql
> 3.23 started to get around 400 request/second and sites were running
> slowly. Immediately after altering cache_pages table with phpMyAdmin
> it ran significally faster.
>
> I do not know where cache_pages structure is defined but it may be
> good to make such change there.
>
> Dmitry. _______________________________________________
> TYPO3-team-core mailing list TYPO3-team-core at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-team-core
More information about the TYPO3-team-core
mailing list