Tempo della query: 66.98 ms Dopo l'ultima query: 2.57 ms
SELECT i.*, c.alias AS categoryalias
FROM cgia2_k2_items AS i
LEFT JOIN cgia2_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-11-16 18:21:27')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-16 18:21:27')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(11035,64206,64207,64213,64252,64263,64266,64270,64329,64335,64336,64360,64367,64391,64398,64400,64401,64432,64440,64443,64449,64451,64481,64499,64518,64572,64573,64589,64637,64640,64658,64661,64705,64720,64723,64732,64744,64757,64788,64804,64808,64833,64902,64931,64959,64962,64964,64968,64969,64977,64996,65019,65034,65040,65073,65075,65087,65096,65148,65150,65156,65193,65194,65241,65281,65298,65339,65358,65382,65399,65400,65436,65451,65458,65459,65484,65506,65539,65540,65541,65597,65599,65618,65649,65658,65659,65670,65672,65730,65750,65755,65762,65845,65911,65927,65975,65980,65989,65995,66009,66159,66189,66195,66210,66218,66242,66252,66263,66347,66382,66404,66406,66407,66441,66444,66469,66517,66548,66593,66605,66807,66810,66858,66860,66906,66907,66940,66949,66985,66993,67087,67154,67156,67192,67225,67273,67321,67419,67440,67451,67488,67496,67523,67560,67589,67617,67657,67678,67684,67700,67707,67728,67730,67769,67770,67771,67787,67827,67843,67905,67913,67942,67972,67973,67992,68014,68029,68046,68065,68068,68128,68138,68245,68255,68263,68353,68377,68384,68413,68415,68427,68454,68455,68456,68466,68470,68536,68541,68542,68554,68568,68590,68593,68637,68644,68656,68680,68688,68699,68738,68746,68757,68790,68801,68804,68818,68831,68850,68876,68889,68909,68910,68913,68921,68925,68928,68931,68933,68950,68953,68992,68999,69029,69075,69104,69114,69138,69160,69161,69162,69170,69223,69235,69272,69282,69284,69298,69320,69321,69328,69333,69334,69374,69376,69390,69392,69432,69436,69438,69480,69487,69503,69549,69556,69558,69591,69593,69624,69631,69638,69639,69650,69651,69653,69660,69674,69680,69685,69688,69702,69740,69782,69792,69797,69807,69917,69974,69975,69977,69978,70039,70128,70134,70158,70194,70200,70228,70266,70297,70336,70343,70390,70430,70459,70467,70469,70526,70684,70698,70736,70793,70809,70895,70896,70910,70913,70929,70953,70990,70997,71020,71022,71043,71108,71112,71155,71232,71243,71280,71281,71282,71283,71285,71341,71357,71393,71414,71415,71417,71466,71478,71484,71520,71523,71576,71578,71579,71606,71629,71643,71644,71650,71672,71704,71766,71791,71849,71891,71902,71936,71981,71984,72012,72033,72036,72064,72065,72133,72173,72186,72193,72200,72238,72285,72303,72305,72307,72356,72432,72464,72485,72491,72627,72635,72637,72652,72667,72669,72689,72695,72696,72697,72704,72779,72794,72801,72818,72826,72833,72840,72841,72868,72881,72899,72944,72954,72963,72989,72994,72996,73002,73025,73027,73037,73090,73108,73158,73185,73204,73214,73220,73221,73242,73243,73257,73269,73270,73293,73305,73307,73310,73324,73353,73367,73377,73405,73407,73416,73526,73532,73547,73549,73550,73570,73572,73602,73612,73624,73630,73635,73645,73652,73689,73710,73733,73747,73757,73805,73810,73811,73838,73864,73909,73915,73919,74004,74030,74031,74067,74069,74074,74086,74088,74092,74097,74102,74103,74111,74119,74120,74127,74139,74184,74255,74281,74361,74401,74434,74447,74451,74477,74480,74504,74523,74535,74541,74559,74562,74571,74578,74620,74641,74642,74673,74697,74762,74788,74834,74863,74891,74898,74918,74971,75004,75042,75052,75100,75115,75196,75222,75238,75247,75248,75270,75292,75320,75322,75357,75390,75407,75409,75410,75440,75466,75498,75508,75511,75547,75574,75610,75650,75652,75661,75676,75720,75737,75741,75761,75768,75772,75776,75805,75817,75850,75871,75875,75900,75904,75911,75960,75961,75964,75971,75978,75983,75997,76020,76026,76031,76032,76059,76060,76106,76108,76117,76118,76125,76145,76170,76204,76227,76245,76258,76271,76275,76276,76278,76281,76309,76347,76357,76369,76370,76373,76398,76406,76425,76450,76464,76472,76518,76549,76559,76565,76572,76579,76591,76596,76604,76624,76629,76635,76648,76656,76701,76703,76706,76718,76724,76738,76739,76751,76753,76765,76767,76787,76797,76807,76832,76863,76879,76882,76886,76899,76904,76926,76930,76932,76971,77004,77019,77024,77041,77044,77076,77078,77087,77095,77127,77142,77149,77159,77164,77168,77180,77258,77260,77263,77318,77319,77327,77332,77335,77346,77369,77376,77389,77396,77401,77419,77446,77449,77467,77496,77500,77511,77558,77575,77577,77591,77602,77604,77623,77625,77640,77663,77667,77682,77687,77696,77720,77722,77727,77759,77771,77850,77869,77872,77882,77885,77892,77898,77921,77928,77930,77936,77939,77945,77950,77955,77956,77964,78013,78023,78041,78053,78081,78098,78108,78126,78145,78174,78175,78202,78222,78225,78226,78239,78258,78262,78263,78265,78286,78320,78321,78334,78341,78357,78370,78371,78375,78388,78396,78401,78414,78416,78439,78440,78451,78454,78461,78489,78495,78525,78568,78575,78589,78597,78603,78632,78638,78646,78648,78652,78655,78681,78683,78686,78687,78696,78708,78733,78744,78747,78752,78780,78868,78920,78922,78930,78945,78961,78969,78970,78979,78990,79039,79040,79050,79066,79084,79095,79112,79145,79156,79178,79182,79189,79203,79205,79209,79239,79256,79257,79284,79285,79292,79294,79302,79304,79310,79321,79332,79342,79364,79391,79396,79448,79471,79474,79482,79485,79486,79510,79515,79519,79523,79538,79539,79546,79566,79569,79609,79618,79655,79662,79672,79692,79707,79719,79725,79729,79736,79743,79760,79768,79793,79796,79821,79823,79868,79871,79879,79894,79927,79981,79995,80005,80006,80018,80028,80034,80053,80054,80057,80084,80106,80129,80138,80169,80179,80181,80187,80251,80271,80272,80312,80321,80325,80326,80334,80337,80341,80351,80366,80369,80374,80395,80413,80433,80458,80463,98478,98479,98485,98486,98511,98530,98531,98534,98545,98546,98560,98569,98590,98598,98607,98651,98678,98679,98681,98682,98704,98710,98718,98735,98742,98758,98786,98787,98800,98812,98828,98839,98853,98854,98861,98880,98893,98895,98900,98916,98917,98918,98920,98936,98940,98959,98965,98982,98991,99006,99038,99041,99063,99067,99075,99081,99086,99091,99093,99096,99099,99103,99105,99118,99122,99135,99140,99148,99169,99181,99192,99215,99216,99247,99255,99308,99373,99381,99394,99419,99462,99463,99502,99508,99517,99529,99530,99538,99546,99548,99550,99605,99606,99638,99656,99684,99687,99751,99778,99799,99806,99821,99823,99838,99839,99851,99852,99880,99881,99882,99911,99922,99961,99974,99989,99990,99996,100023,100054,100059,100089,100100,100119,100123,100148,100158,100160,100179,100180,100215,100216,100240,100251,100303,100329,100361,100363,100367,100376,100393,100412,100424,100426,100439,100446,100448,100455,100521,100535,100537,100571,100575,100605,100622,100631,100657,100660,100766,100812,100817,100839,100914,100927,100929,100947,100949,100953,100961,100980,100982,100988,100991,101042,101045,101084,101107,101120,101129,101141,101167,101171,101188,101218,101252,101293,101354,101367,101399,101402,101404,101435,101436,101440,101451,101476,101477,101510,101556,101573,101578,101584,101585,101586,101593,101621,101651,101652,101655,101691,101755,101759,101778,101780,101781,101789,101799,101817,101837,101867,101872,101879,101896,101901,101974,101988,101990,101999,102001,102004,102025,102031,102035,102044,102055,102066,102067,102070,102079,102095,102117,102122,102124,102138,102156,102159,102166,102188,102215,102227,102228,102242,102244,102245,102255,102271,102272,102286,102298,102299,102315,102329,102367,102381,102388,102418,102423,102449,102463,102476,102479,102520,102522,102589,102599,102600,102613,102617,102641,102660,102661,102664,102685,102693,102703,102705,102715,102733,102743,102754,102779,102813,102817,102822,102824,102843,102846,102857,102858,102861,102862,102865,102910,102948,102955,102994,103021,103029,103037,103066,103067,103068,103077,103082,103084,103135,103158,103184,103190,103228,103241,103257,103273,103293,103297,103304,103310,103311,103315,103317,103332,103360,103363,103367,103428,103433,103441,103465,103483,103484,103486,103505,103524,103538,103539,103544,103546,103555,103563,103572,103583,103630,103645,103657,103660,103687,103692,103713,103714,103719,103741,103744,103755,103800,103817,103819,103862,103864,103874,103880,103882,103902,103916,103930,103967,103979,104001,104009,104038,104051,104075,104104,104132,104136,104137,104138,104151,104162,104171,104172,104185,104209,104210,104211,104217,104238,104241,104242,104258,104259,104272,104306,104329,104356,104359,104363,104388,104406,104435,104449,104450,104453,104454,104460,104462,104474,104494,104505,104509,104523,104525,104568,104569,104633,104644,104654,104704,104711,104712,104737,104740,104749,104756,104771,104805,104809,104826,104858,104873,104879,104881,104909,104911,104919,104920,104950,104951,104977,105006,105061,105067,105071,105072,105077,105092,105099,105119,105138,105151,105156,105157,105197,105225,105232,105254,105332,105333,105334,105340,105341,105355,105387,105390,105424,105472,105476,105482,105484,105485,105539,105554,105566,105579,105593,105595,105598,105610,105611,105619,105625,105628,105630,105631,105656,105671,105679,105683,105691,105692,105701,105747,105767,105786,105791,105819,105823,105859,105872,105878,105912,105913,105928,105952,105956,105970,105986,105989,105990,105991,106000,106008,106009,106011,106065,106110,106116,106130,106147,106149,106166,106195,106198,106233,106238,106257,106263,106267,106290,106295,106298,106300,106334,106403,106436,106437,106447,106490,106491,106492,106523,106527,106532,106533,106565,106573,106585,106586,106620,106656,106676,106694,106695,106719,106739,106748,106749,106750,106754,106755,106758,106759,106760,106761,106762,106810,106815,106817,106839,106845,106849,106856,106864,106867,106868,106878,106883,106901,106903,106929,106940,106972,106975,107010,107021,107026,107030,107047,107063,107064,107085,107087,107088,107102,107109,107137,107143,107157,107164,107176,107178,107239,107241,107249,107250,107254,107265,107271,107274,107277,107311,107312,107324,107347,107348,107349,107350,107352,107374,107404,107417,107440,107491,107512,107520,107525,107537,107558,107559,107561,107570,107603,107607,107652,107659,107685,107734,107742,107749,107751,107768,107796,107811,107824,107850,107853,107854,107856,107871,107907,107922,107945,107947,107948,107956,107965,107980,108011,108012,108013,108023,108024,108026,108036,108040,108048,108051,108065,108077,108083,108098,108104,108108,108119,108154,108155,108178,108187,108190,108220,108227,108229,108233,108280,108281,108282,108307,108308,108318,108325,108342,108346,108388,108394,108525,108546,108559,108605,108636,108653,108669,108811,108838,108840,109129,109268,109316,109488,109519,110037,110139,110408,110485,110518,110529,110695,110704,111030,111093,111143,111346,111375,111417,111590,111618,111637,111646,111683,111684,111754,111909,111929,112109,112177,112192,112304,112492,112493,112632,112768,112770,112851,112969,112978,112998,113166,113180,113236,113237,113264,113270,113310,113352,113353,113438,113440,113444,113465,113572,113584,113629,113640,113670,113680,113787,113795,113801,113816,113911,113959,113965,114003,114004,114007,114019,114067,114069,114144,114254,114265,114274,114297,114350,114352,114390,114515,114522,114710,114741,114746,114761,114784,114793,114807,114813,114863,114866,114898,114901,114904,115005,115007,115008,115014,115020,115038,115044,115076,115164,115191,115234,115235,115240,115265,115281,115287,115322,115324,115488,115489,115492,115502,115510,115522,115567,115620,115626,115627,115726,115737,115810,115840,115952,116069,116106,116130,116206,116211,116222,116230,116311,116314,116331,116369,116428,116441,116462,116525,116551,116594,116603,116635,116645,116678,116689,116728,116773,116785,116786,116804,116826,116832,116899,116900,116972,116992,117016,117035,117050,117068,117094,117141,117218,117241,117263,117304,117305,117310,117356,117401,117438,117600,117744,117800,117880,117919,118084,118094,118113,118284,118352,118552,118592,118598,118607,118623,118629,118682,118736,118770,118783,118804,118823,118872,118891,118902,118907,118946,118978,118984,119016,119087,119144,119237,119285,119456,119731,119782,119864,119893,120009,120044,120048,120092,120093,120132,120209,120222,120223,120224,120256,120267,120272,120275,120479,120481,120521,120600,120670,120682,120687,120796,120826,120847,120859,120887,120942,120967,121012,121014,121024,121027,121028,121029,121031,121032,121054,121141,121158,121202,121243,121290,121298,121302,121309,121337,121362,121417,121421,121446,121483,121484,121500,121561,121572,121577,121579,121618,121619,121622,121623,121624,121638,121639,121648,121821,121823,121826,121842,121843,121844,121846,121855,121862,121867,121868,121920,122001,122007,122011,122044,122079,122080,122104,122105,122119,122138,122154,122176,122177,122185,122194,122226,122233,122296,122297,122301,122322,122327,122364,122365,122376,122432,122434,122435,122437,122438,122446,122450,122463,122472,122482,122494,122495,122497,122525,122552,122553,122656,122660,122684,122687,122692,122695,122699,122706,122719,122720,122752,122763,122771,122776,122786,122788,122815,122822,122843,122902,122913,122931,122932,122941,122957,122979,122986,123048,123079,123091,123092,123128,123131,123138,123146,123150,123156,123201,123220,123260,123264,123288,123291,123305,123316,123341,123345,123357,123363,123364,123367,123370,123373,123375,123380,123387,123397,123413,123414,123416,123439,123480,123502,123511,123529,123549,123558,123572,123582,123584,123617,123618,123639,123678,123733,123747,123760,123806,123808,123861,123908,123926,123975,123981,123988,124003,124056,124075,124093,124095,124124,124131,124136,124157,124176,124181,124188,124189,124218,124234,124275,124295,124319,124320,124347,124348,124353,124359,124410,124413,124418,124419,124446,124447,124494,124578,124579,124603,124608,124619,124624,124633,124635,124707,124715,124717,124766,124831,124841,124913,124934,124940,124953,124991,125014,125016,125021,125076,125081,125114,125118,125153,125162,125170,125174,125213,125271,125308,125331,125344,125392,125405,125409,125414,125425,125488,125500,125511,125514,125560,125563,125675,125679,125705,125753,125762,125782,125820,125884,125911,125928,125934,125972,125981,126002,126030,126046,126088,126119,126163,126287,126288,126289,126311,126316,126346,126357,126361,126363,126378,126379,126380,126381,126382,126396,126399,126404,126405,126422,126429,126434,126449,126494,126496,126508,126526,126527,126582,126607,126614,126624,126639,126669,126688,126703,126704,126718,126721,126747,126768,126769,126784,126813,126839,126849,126861,126916,126954,126955,126958,126959,127003,127051,127079,127110,127172,127215,127270,127282,127312,127315,127380,127389,127398,127400,127402,127425,127435,127454,127455,127456,127512,127521,127545,127564,127596,127606,127625,127667,127673,127707,127718,127719,127731,127732,127763,127765,127787,127793,127803,127843,127864,127957,127988,127993,128000,128017,128018,128026,128030,128056,128057,128063,128106,128151,128152,128159,128178,128179,128180,128196,128204,128225,128238,128300,128342,128348,128357,128360,128365,128368,128389,128390,128393,128396,128403,128407,128435,128444,128487,128529,128539,128540,128561,128574,128576,128577,128579,128586,128607,128608,128642,128660,128700,128721,128724,128741,128758,128762,128767,128770,128771,128782,128789,128790,128848,128877,128890,128904,128942,128943,128944,128946,128949,128952,128953,128962,128977,128980,128981,128997,129023,129026,129027,129030,129037,129038,129041,129110,129164,129172,129189,129193,129195,129197,129213,129214,129219,129224,129228,129231,129242,129243,129256,129257,129258,129275,129276,129307,129348,129350,129378,129428,129433,129453,129456,129459,129461,129475,129480,129484,129501,129513,129528,129538,129541,129548,129553,129606,129644,129647,129667,129673,129680,129708,129709,129722,129775,129782,129876,129880,129884,129898,129913,129916,129917,129929,129934,129936,129944,129950,129967,129988,130102,130123,130135,130136,130180,130350,130377,130442,130547,130560,130581,130583,130632,130656,130657,130720,130740,130766,130770,130828,130892,130961,130969,130983,130996,131001,131005,131010,131079,131130,131143,131145,131149,131163,131174,131178,131179,131186,131205,131207,131250,131251,131322,131345,131362,131371,131372,131381,131382,131396,131408,131419,131421,131469,131522,131532,131547,131570,131571,131572,131579,131582,131584,131621,131622,131626,131629,131631,131634,131639,131669,131683,131688,131709,131743,131767,131790,131794,131796,131797,131798,131808,131811,131813,131843,131851,131853,131879,131893,131903,131906,131917,131918,131919,131934,131966,131983,131988,132015,132036,132049,132050,132055,132058,132063,132064,132065,132088,132089,132093,132105,132114,132130,132131,132171,132172,132173,132174,132206,132207,132242,132275,132287,132305,132315,132323,132336,132376,132389,132395,132407,132410,132425,132447,132462,132484,132488,132490,132491,132498,132503,132509,132517,132521,132523,132524,132530,132531,132535,132536,132538,132551,132566,132569,132588,132591,132603,132604,132606,132610,132617,132624,132644,132647,132668,132690,132705,132713,132714,132718,132719,132732,132735,132736,132748,132754,132756,132784,132785,132818,132823,132840,132842,132843,132905,132907,132945,132949,132955,132969,132977,132979,133002,133005,133007,133008,133020,133029,133031,133062,133063,133090,133101,133130,133131,133140,133162,133164,133180,133189,133197,133200,133219,133221,133228,133246,133270,133273,133292,133296,133309,133328,133329,133330,133352,133359,133365,133369,133394,133396,133403,133404,133410,133411,133422,133436,133446,133461,133529,133553,133555,133560,133562,133586,133587,133599,133603,133604,133606,133614,133627,133661,133667,133691,133695,133749,133753,133754,133772,133773,133774,133787,133790,133792,133815,133841,133859,133866,133880,133918,133925,133945,133973,133976,133996,134027,134035,134072,134096,134107,134126,134176,134183,134195,134202,134211,134222,134241,134249,134252,134271,134274,134289,134292,134294,134299,134319,134322,134336,134397,134398,134452,134463,134471,134472,134492,134547,134554,134558,134561,134564,134565,134584,134648,134664,134665,134682,134684,134720,134722,134748,134766,134777,134796,134803,134825,134898,134902,134910,134916,134922,134969,134974,134984,135033,135050,135051,135075,135098,135101,135118,135148,135159,135167,135176,135202,135205,135207,135208,135244,135254,135279,135280,135286,135296,135302,135327,135334,135347,135358,135397,135408,135420,135456,135462,135463,135469,135477,135481,135498,135514,135517,135524,135543,135548,135575,135585,135601,135634,135643,135645,135653,135671,135694,135708,135715,135741,135743,135746,135747,135775,135780,135783,135804,135889,135913,135945,135953,135964,135969,135975,135991,136027,136083,136084,136097,136116,136153,136197,136215,136222,136265,136271,136290,136320,136344,136369,136384,136419,136425,136439,136460,136468,136483,136502,136503,136539,136551,136565,136594,136611,136614,136625,136626,136628,136677,136691,136708,136733,136780,136794,136803,136811,136833,136841,136937,136967,136970,137069,137070,137096,137102,137103,137117,137138,137139,137147,137161,137164,137173,137226,137255,137273,137275,137295,137307,137308,137319,137329,137330,137336,137353,137379,137382,137383,137385,137428,137429,137445,137451,137453,137464,137467,137478,137481,137486,137502,137504,137505,137506,137516,137525,137527,137534,137535,137591,137597,137599,137611,137635,137658,137659,137660,137667,137687,137716,137717,137718,137719,137732,137764,137765,137780,137793,137811,137820,137827,137836,137837,137843,137856,137900,137951,137972,137974,137979,137987,137988,137989,137998,137999,138015,138019,138024,138025,138035,138036,138054,138068,138072,138080,138091,138113,138125,138140,138145,138146,138147,138153,138163,138186,138190,138203,138205,138206,138207,138218,138223,138235,138254,138289,138290,138294,138300,138301,138302,138311,138314,138321,138331,138334,138337,138338,138344,138352,138357,138364,138433,138448,138449,138450,138451,138456,138459,138461,138462,138479,138485,138488,138504,138514,138515,138550,138551,138575,138601,138607,138629,138630,138632,138639,138644,138651,138655,138656,138658,138661,138666,138673,138679,138695,138699,138700,138717,138720,138724,138733,138760,138781,138791,138792,138793,138811,138820,138821,138825,138829,138833,138836,138841,138847,138848,138853,138879,138901,138905,138926,138970,138977,138978,138979,138995,139001,139002,139015,139021,139023,139027,139035,139065,139079,139103,139104,139112,139138,139156,139162,139186,139189,139196,139198,139218,139230,139233,139237,139247,139295,139326,139363,139364,139370,139383,139385,139389,139390,139395,139396,139399,139407,139411,139412,139415,139439,139441,139442,139443,139445,139446,139456,139487,139488,139505,139529,139535,139538,139542,139574,139577,139581,139584,139598,139599,139604,139605,139606,139607,139609,139611,139619,139634,139639,139681,139688,139690,139701,139704,139715,139717,139729,139730,139765,139767,139770,139773,139776,139777,139778,139781,139782,139803,139816,139834,139853,139859,139887,139930,139940,139946,139947,139948,139956,139957,139958,139959,139976,139994,140033,140058,140062,140096,140121,140156,140172,140191,140229,140230,140235,140261,140273,140281,140282,140283,140292,140293,140295,140296,140298,140302,140304,140308,140311,140326,140327,140339,140340,140343,140349,140350,140351,140369,140388,140401,140427,140435,140436,140442,140443,140452,140475,140477,140478,140483,140484,140492,140497,140499,140501,140502,140548,140549,140563,140599,140615,140618,140619,140620,140629,140640,140643,140666,140679,140684,140688,140690,140691,140692,140743,140749,140778,140799,140801,140808,140809,140817,140820,140822,140827,140829,140830,140838,140851,140858,140862,140882,140944,140949,140959,140969,140978,140989,140993,140994,141003,141005,141009,141011,141012,141014,141020,141022,141025,141030,141031,141040,141045,141048,141049,141068,141069,141084,141091,141098,141164,141165,141184,141187,141196,141197,141202,141214,141222,141231,141251,141254,141260,141278,141288,141292,141304,141357,141369,141374,141375,141376,141377,141380,141383,141384,141386,141398,141399,141401,141428,141429,141430,141456,141458,141460,141465,141477,141531,141532,141535,141541,141546,141547,141557,141560,141564,141565,141571,141572,141573,141590,141591,141614,141619,141622,141627,141659,141682,141705,141713,141733,141747,141748,141749,141750,141751,141755,141788,141790,141799,141810,141818,141819,141820,141829,141857,141874,141922,141926,141931,141934,141935,141938,141941,141946,141948,141951,141957,141963,141965,141966,141969,141974,141976,141983,141988,141989,142007,142065,142066,142067,142080,142086,142105,142106,142107,142127,142139,142145,142146,142147,142151,142154,142155,142161,142166,142175,142180,142193,142197,142219,142232,142254,142260,142278,142298,142301,142304,142310,142316,142320,142321,142324,142325,142332,142335,142346,142350,142352,142357,142358,142359,142360,142361,142367,142387,142397,142408,142458,142461,142464,142465,142486,142491,142500,142502,142504,142526,142534,142542,142544,142586,142587,142588,142600,142603,142609,142612,142667,142668,142673,142694,142695,142718,142742,142761,142780,142787,142793,142815,142837,142844,142853,142871,142873,142882,142909,142910,142913,142915,142916,142917,142918,142924,142925,142926,142933,142936,142938,142945,142946,142949,142951,142963,142966,142969,142977,142982,142992,143008,143028,143030,143041,143045,143070,143078,143102,143107,143115,143116,143117,143120,143121,143129,143132,143133,143144,143150,143156,143166,143170,143186,143199,143220,143230,143263,143287,143297,143301,143306,143307,143316,143319,143329,143350,143353,143354,143355,143358,143365,143387,143390,143397,143405,143432,143466,143494,143512,143513,143516,143527,143537,143549,143550,143566,143604,143605,143626,143632,143633,143668,143669,143675,143698,143703,143726,143731,143736,143761,143765,143783,143794,143796,143798,143799,143820,143821,143824,143858,143859,143890,143899,143908,143917,143921,143922,143923,143933,143955,143959,143960,143961,143969,143983,143984,143989,144018,144060,144062,144065,144072,144083,144121,144126,144133,144137,144148,144170,144196,144209,144223,144225,144226,144228,144237,144239,144255,144268,144292,144300,144327,144366,144393,144417,144422,144431,144434,144445,144447,144449,144457,144469,144487,144496,144510,144512,144514,144517,144526,144546,144549,144552,144553,144555,144569,144601,144612,144628,144629,144657,144696,144701,144721,144727,144773,144774,144775,144777,144797,144802,144807,144808,144820,144826,144828,144836,144841,144844,144852,144873,144885,144893,144894,144899,144919,144922,144945,145002,145013,145022,145033,145034,145041,145069,145094,145099,145115,145129,145141,145150,145249,145251,145320,145321,145347,145366,145393,145395,145407,145408,145464,145486,145494,145497,145506,145520,145530,145536,145551,145556,145562,145580,145585,145605,145690,145713,145778,145788,145789,145802,145850,145882,145908,145962,146059,146073,146090,146113,146115,146118,146122,146123,146124,146126,146195,146204,146245,146263,146321,146323,146331,146334,146340,146347,146366,146376,146387,146389,146429,146437,146452,146461,146472,146473,146479,146483,146487,146515,146533,146539,146581,146595,146608,146609,146627,146646,146647,146653,146657,146663,146667,146668,146678,146679,146680,146681,146686,146687,146691,146714,146720,146728,146747,146766,146791,146793,146798,146805,146806,146812,146813,146816,146829,146830,146835,146836,146838,146842,146843,146844,146845,146846,146850,146854,146855,146858,146877,146889,146905,146916,146935,146957,146968,146970,146971,146973,146975,146976,146978,146983,146988,147003,147012,147015,147017,147045,147054,147062,147092,147098,147099,147125,147135,147139,147155,147157,147159,147166,147187,147262,147280,147297,147299,147328,147337,147340,147341,147345,147352,147367,147372,147413,147428,147465,147472,147483,147511,147512,147513,147514,147515,147517,147525,147530,147534,147537,147540,147548,147556,147562,147563,147564,147566,147569,147579,147634,147638,147650,147653,147678,147696,147705,147722,147725,147729,147730,147733,147734,147745,147753,147761,147762,147768,147777,147781,147783,147791,147799,147814,147820,147821,147836,147846,147895,147898,147908,147911,147912,147921,147933,147942,147943,147944,147947,147952,147965,147966,147974,147992,148006,148029,148045,148068,148071,148079,148084,148113,148114,148119,148133,148136,148145,148148,148151,148200,148231,148251,148256,148257,148258,148266,148267,148302,148305,148308,148318,148325,148326,148345,148373,148381,148402,148403,148419,148443,148464,148473,148475,148480,148489,148493,148496,148502,148503,148512,148513,148519,148524,148525,148551,148569,148570,148592,148600,148608,148609,148622,148640,148684,148685,148686,148697,148700,148701,148705,148706,148722,148733,148734,148750,148751,148753,148772,148862,148865,148869,148871,148872,148873,148879,148880,148881,148887,148893,148901,148905,148907,148912,148922,148924,148928,148942,148945,148947,148978,149021,149036,149057,149065,149076,149091,149103,149105,149107,149108,149127,149132,149150,149187,149207,149208,149243,149254,149255,149256,149266,149280,149281,149297,149352,149356,149416,149450,149460,149472,149473,149549,149551,149582,149606,149619,149650,149663,149667,149704,149708,149709,149714,149718,149725,149736,149737,149741,149751,149752,149757,149836,149862,149864,149868,149870,149883,149884,149886,149888,149893,149896,149918,149923,149926,149933,149937,149944,149969,149970,149986,150005,150052,150063,150064,150069,150075,150081,150082,150085,150086,150087,150088,150089,150090,150108,150110,150116,150132,150136,150142,150144,150146,150161,150166,150194,150255,150264,150268,150269,150286,150292,150295,150296,150318,150323,150325,150346,150367,150368,150384,150402,150412,150456,150462,150466,150467,150489,150492,150495,150501,150518,150519,150541,150551,150573,150605,150609,150663,150674,150675,150676,150679,150680,150681,150682,150685,150699,150701,150703,150705,150708,150721,150729,150731,150737,150738,150740,150742,150744,150745,150762,150769,150771,150772,150774,150791,150801,150806,150820,150843,150855,150878,150882,150883,150892,150902,150917,150922,150923,150926,150927,150935,150940,150945,150946,150950,150951,150954,150955,150963,150968,150971,150972,150974,150975,150982,151001,151002,151004,151007,151034,151062,151070,151071,151073,151098,151099,151102,151112,151131,151136,151140,151141,151142,151144,151147,151159,151160,151165,151167,151173,151179,151187,151191,151195,151197,151199,151200,151208,151213,151215,151217,151218,151261,151280,151353,151378,151379,151385,151397,151399,151408,151410,151430,151432,151437,151438,151439,151468,151494,151548,151578,151608,151609,151622,151623,151634,151636,151643,151644,151646,151652,151656,151658,151673,151677,151678,151679,151706,151710,151714,151715,151718,151732,151753,151772,151779,151805,151821,151846,151848,151862,151863,151866,151873,151876,151899,151900,151910,151924,151947,151954,151975,151981,151983,151984,151987,151988,151990,152004,152010,152027,152034,152037,152061,152070,152078,152094,152095,152096,152097,152104,152111,152117,152127,152146,152147,152157,152183,152227,152230,152257,152259,152282,152295,152296,152297,152301,152314,152403,152431,152443,152448,152449,152474,152476,152479,152503,152504,152508,152586,152592,152597,152608,152609,152640,152653,152666,152667,152669,152673,152678,152686,152697,152701,152704,152705,152706,152724,152727,152728,152746,152759,152790,152821,152850,152862,152863,152894,152899,152916,152918,152930,152933,152937,152940,152962,152970,153040,153068,153075,153078,153094,153095,153108,153120,153122,153129,153166,153204,153213,153253,153259,153299,153309,153310,153316,153317,153321,153331,153344,153352,153373,153396,153398,153413,153509,153518,153521,153530,153535,153548,153557,153558,153574,153580,153609,153638,153644,153650,153663,153667,153677,153689,153713,153714,153715,153723,153744,153747,153758,153772,153874,153884,153913,153915,153931,153947,153949,153959,153987,153995,154070,154114,154122,154128,154144,154157,154173,154175,154178,154208,154219,154326,154343,154377,154379,154419,154448,154459,154460,154465,154495,154557,154561,154564,154570,154604,154660,154688,154689,154721,154724,154748,154763,154781,154785,154788,154847,154866,154872,154875,154877,154890,154891,154903,154904,154921,154933,154936,154993,155002,155023,155026,155049,155057,155063,155064,155079,155112,155114,155178,155180,155208,155210,155215,155231,155277,155286,155294,155314,155343,155352,155421,155487,155488,155497,155529,155536,155566,155579,155584,155605,155608,155618,155621,155689,155695,155715,155727,155761,155765,155770,155803,155826,155843,155854,155855,155868,155870,155906,155911,155917,155918,155944,155973,156014,156035,156049,156073,156114,156116,156120,156127,156173,156210,156211,156219,156298,156357,156362,156379,156410,156416,156433,156497,156516,156532,156551,156572,156579,156590,156596,156601,156602,156625,156654,156670,156674,156675,156690,156693,156707,156732,156737,156740,156754,156768,156779,156780,156813,156815,156819,156824,156835,156908,156915,156917,156921,156923,156955,156983,156996,156997,157018,157046,157070,157078,157080,157083,157084,157085,157095,157096,157099,157116,157120,157135,157136,157138,157169,157204,157210,157235,157251,157254,157267,157303,157326,157330,157354,157361,157378,157398,157405,157406,157407,157454,157465,157470,157481,157489,157492,157503,157505,157506,157519,157523,157524,157533,157552,157565,157567,157573,157575,157576,157595,157648,157704,157722,157723,157733,157734,157745,157751,157770,157777,157830,157871,157902,157905,157909,157913,157925,157950,157953,157954,157958,157960,158003,158010,158016,158018,158099,158107,158108,158116,158120,158127,158135,158136,158139,158140,158141,158142,158143,158144,158145,158151,158156,158161,158164,158167,158168,158169,158170,158171,158172,158217,158242,158271,158304,158309,158321,158325,158328,158329,158332,158333,158337,158338,158341,158346,158363,158366,158377,158386,158387,158388,158397,158415,158416,158450,158452,158480,158516,158528,158550,158551,158552,158553,158554,158555,158556,158557,158564,158566,158571,158584,158593,158600,158602,158629,158636,158654,158664,158691,158694,158732,158733,158744,158750,158759,158760)
ORDER BY i.id DESC
LIMIT 3| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | <subquery2> | ALL | distinct_key | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 4694 | Using temporary; Using filesort |
| 1 | PRIMARY | i | eq_ref | PRIMARY,catid,idx_item | PRIMARY | 4 | tvc_0._col_1 | 1 | Using where |
| 1 | PRIMARY | c | eq_ref | PRIMARY,category,published,access,trash,idx_category | PRIMARY | 4 | gazz_spezia.i.catid | 1 | Using where |
| 2 | MATERIALIZED | <derived3> | ALL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | 4694 | |
| 3 | DERIVED | NULL | NULL | NULL | NON È POSSIBILE UTILIZZARE ALCUN INDICE | NULL | NULL | NULL | No tables used |
Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)
| # | Caller | File e numero di linea |
|---|
| 14 | JDatabaseDriverPdo->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:668 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:278 |
| 11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
| 10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
| 8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:57 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
