Tiempo de la consulta: 15.35 ms Después de la última consulta: 2.67 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.684 MB Filas devueltas: 5
SELECT i.*, c.alias AS categoryalias
FROM av04h_k2_items AS i
LEFT JOIN av04h_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-05-04 16:44:53')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 16:44:53')
AND i.access IN(1,1,2,3,5)
AND c.access IN(1,1,2,3,5)
AND c.published = 1
AND c.trash = 0
AND i.id IN(1,3,8,9,11,12,13,14,15,16,17,18,25,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,79,80,81,82,83,85,86,87,88,89,90,97,99,110,111,112,124,125,131,134,136,137,155,165,180,181,186,188,189,190,197,198,200,204,205,210,212,215,216,219,220,221,222,224,225,226,232,234,237,238,243,244,245,246,248,249,250,253,254,255,257,259,260,262,263,271,276,280,289,309,328,330,336,337,353,357,362,366,368,370,371,394,395,401,412,413,414,415,416,417,418,419,420,421,422,423,424,426,427,429,431,433,434,439,444,445,451,452,458,459,468,474,481,484,485,496,500,501,503,511,512,520,521,524,525,527,528,529,531,532,537,542,547,548,553,555,557,560,563,565,566,567,574,575,587,593,595,596,597,603,604,607,609,615,620,625,628,632,641,642,646,647,648,650,651,652,654,659,662,681,684,686,687,689,723,724,730,744,746,756,760,781,785,788,792,800,805,806,814,818,824,833,840,842,845,850,852,853,854,862,868,870,875,886,901,902,925,933,936,940,941,950,952,962,974,976,977,985,986,994,1007,1008,1015,1035,1044,1047,1058,1066,1071,1072,1091,1100,1114,1119,1145,1165,1171,1185,1207,1215,1223,1226,1227,1264,1265,1266,1267,1268,1269,1270,1272,1273,1274,1275,1276,1277,1278,1285,1314,1317,1325,1328,1329,1339,1347,1352,1353,1357,1359,1365,1388,1389,1390,1394,1412,1434,1464,1467,1475,1504,1534,1574,1600,1614,1637,1659,1664,1686,1698,1709,1712,1718,1721,1754,1765,1768,1778,1797,1800,1803,1805,1839,1853,1863,1878,1896,1932,1952,1960,1963,1979,1996,2007,2012,2048,2053,2081,2085,2086,2108,2185,2208,2221,2272,2355,2374,2380,2428,2429,2455,2463,2485,2520,2532,2569,2580,2589,2687,2689,2713,2719,2733,2751,2811,2825,2852,2855,2869,2900,2972,3017,3020,3024,3026,3034,3051,3067,3126,3144,3150,3156,3167,3181,3188,3212,3269,3291,3318,3323,3325,3337,3353,3398,3409,3415,3416,3417,3424,3439,3462,3473,3512,3517,3520,3544,3559,3562,3569,3595,3630,3650,3668,3674,3682,3704,3709,3710,3732,3776,3801,3836,3853,3868,3870,3872,3884,3898,3940,3963,3991,3993,4000,4055,4063,4109,4116,4127,4153,4199,4301,4309,4310,4338,4378,4409,4410,4436,4445,4453,4471,4538,4547,4561,4578,4580,4587,4612,4613,4614,4615,4617,4620,4674,4692,4799,4811,4815,4832,4848,4855,4902,4905,4911,4935,4955,4965,5001,5043,5045,5053,5060,5062,5085,5096,5098,5147,5151,5154,5166,5176,5184,5189,5190,5195,5220,5243,5263,5273,5301,5324,5357,5374,5392,5406,5415,5417,5469,5472,5476,5515,5519,5538,5544,5582,5583,5585,5637,5644,5646,5647,5662,5666,5678,5685,5702,5732,5756,5759,5768,5777,5779,5782,5785,5794,5795,5798,5804,5831,5835,5852,5870,5894,5895,5896,5899,5906,5910,5919,5923,5927,5978,5997,6000,6007,6011,6014,6016,6022,6032,6069,6087,6112,6176,6183,6220,6222,6226,6237,6254,6258,6261,6266,6268,6276,6311,6312,6343,6355,6373,6374,6390,6392,6393,6420,6448,6470,6473,6476,6477,6482,6510,6542,6543,6564,6596,6598,6600,6616,6641,6654,6666,6671,6677,6681,6716,6733,6749,6752,6758,6766,6775,6776,6779,6806,6809,6828,6836,6848,6855,6868,6885,6889,6916,6924,6939,6941,6955,6971,6994,7004,7017,7032,7048,7050,7056,7067,7105,7109,7124,7138,7173,7191,7210,7212,7222,7243,7245,7248,7269,7276,7287,7291,7357,7407,7418,7423,7446,7450,7462,7473,7486,7492,7507,7516,7527,7534,7546,7549,7556,7560,7568,7576,7591,7595,7621,7635,7692,7693,7696,7716,7719,7730,7756,7760,7771,7782,7811,7812,7840,7853,7902,7904,7926,7933,7958,7965,7966,7967,7968,7969,7970,7993,8009,8020,8027,8050,8053,8054,8060,8062,8064,8070,8078,8081,8084,8087,8095,8106,8162,8164,8178,8215,8218,8240,8294,8296,8299,8306,8351,8356,8357,8374,8377,8398,8418,8420,8444,8445,8461,8502,8546,8565,8572,8573,8589,8602,8610,8637,8638,8643,8663,8678,8710,8809,8810,8826,8835,8850,8856,8861,8864,8875,8887,8909,8923,8939,8940,8948,8952,8995,9046,9057,9093,9096,9110,9112,9139,9140,9175,9180,9182,9184,9186,9190,9199,9206,9237,9251,9252,9253,9254,9262,9277,9282,9307,9357,9362,9381,9394,9408,9411,9428,9430,9431,9472,9473,9509,9521,9531,9532,9540,9541,9572,9576,9580,9589,9624,9629,9635,9641,9644,9650,9660,9661,9677,9678,9685,9697,9711,9729,9731,9757,9771,9772,9779,9850,9864,9873,9899,9915,9924,9932,9934,9964,9992,10014,10024,10035,10044,10046,10048,10050,10077,10079,10092,10113,10147,10186,10197,10198,10213,10266,10274,10280,10290,10299,10302,10303,10342,10350,10361,10395,10407,10415,10443,10486,10499,10518,10557,10560,10603,10604,10690,10708,10720,10731,10753,10774,10806,10831,10887,10893,10915,10927,11087,11098,11131,11182,11206,11273,11278,11302,11345,11367,11374,11415,11419,11436,11441,11447,11465,11468,11494,11542,11549,11555,11559,11590,11692,11706,11747,11750,11772,11791,11822,11840,11857,11880,11979,12020,12025,12133,12204,12216,12217,12242,12250,12293,12324,12334,12338,12363,12366,12379,12413,12416,12426,12440,12460,12472,12475,12490,12520,12550,12568,12572,12590,12620,12625,12628,12650,12668,12670,12685,12686,12708,12716,12745,12746,12757,12764,12786,12788,12795,12799,12806,12810,12887,12913,12917,12920,12943,12965,12973,12977,12982,12983,12996,12998,13004,13010,13013,13014,13016,13029,13036,13037,13062,13065,13069,13070,13084,13094,13121,13126,13152,13153,13169,13177,13178,13186,13190,13209,13215,13235,13238,13249,13263,13277,13278,13285,13287,13294,13325,13348,13365,13383,13387,13388,13390,13415,13426,13432,13453,13459,13474,13475,13481,13540,13550,13556,13558,13566,13575,13590,13596,13625,13635,13646,13651,13658,13718,13725,13728,13753,13763,13775,13803,13833,13836,13841,13881,13894,13900,13903,13966,13971,13973,13985,13986,13987,14011,14015,14027,14029,14048,14057,14069,14083,14108,14109,14139,14146,14177,14193,14205,14218,14227,14229,14232,14238,14252,14261,14293,14350,14352,14362,14388,14461,14477,14494,14534,14536,14554,14557,14571,14577,14583,14591,14596,14602,14610,14631,14635,14651,14675,14680,14684,14701,14722,14725,14729,14741,14752,14774,14778,14805,14810,14818,14839,14840,14857,14860,14862,14885,14889,14895,14904,14914,14926,14940,14953,14954,14957,14969,14978,14979,15006,15038,15043,15054,15065,15077,15087,15090,15096,15109,15114,15124,15133,15138,15144,15175,15184,15186,15235,15242,15244,15245,15256,15261,15279,15292,15293,15297,15304,15314,15340,15382,15414,15441,15445,15455,15469,15470,15475,15476,15490,15518,15520,15533,15540,15547,15550,15574,15579,15598,15602,15612,15623,15626,15627,15630,15640,15644,15662,15666,15667,15707,15741,15751,15753,15755,15760,15766,15785,15796,15806,15808,15835,15840,15861,15877,15890,15892,15895,15902,15922,15925,15937,15945,15960,15966,15969,15972,15978,15998,15999,16005,16010,16013,16014,16015,16021,16023,16024,16029,16040,16053,16054,16055,16062,16071,16074,16078,16085,16088,16102,16115,16117,16123,16125,16148,16157,16161,16176,16187,16190,16202,16213,16217,16219,16228,16242,16262,16265,16277,16279,16281,16284,16301,16316,16325,16336,16346,16359,16382,16386,16392,16401,16402,16410,16417,16422,16436,16443,16451,16470,16479,16481,16497,16526,16542,16543,16547,16554,16558,16561,16566,16570,16588,16606,16607,16609,16635,16639,16642,16691,16698,16713,16751,16815,16831,16833,16834,16843,16844,16872,16908,16913,16917,16947,16950,16964,16966,16976,17001,17014,17015,17043,17045,17059,17104,17114,17139,17149,17153,17157,17160,17172,17177,17186,17189,17280,17307,17309,17334,17335,17341,17354,17364,17371,17381,17403,17417,17419,17437,17463,17484,17496,17500,17528,17567,17580,17584,17596,17597,17607,17611,17617,17629,17630,17643,17650,17657,17669,17680,17689,17695,17702,17703,17721,17729,17753,17772,17784,17785,17826,17857,17862,17892,17907,17954,17959,17968,17976,17977,17990,18001,18006,18014,18022,18035,18036,18049,18050,18058,18067,18068,18071,18073,18074,18106,18151,18158,18176,18214,18217,18220,18240,18253,18260,18262,18263,18276,18284,18297,18300,18306,18309,18311,18313,18322,18337,18352,18360,18361,18378,18382,18393,18421,18423,18427,18437,18438,18444,18455,18473,18485,18491,18503,18516,18520,18527,18547,18550,18552,18558,18565,18572,18576,18578,18581,18582,18586,18591,18599,18629,18638,18642,18647,18648,18655,18665,18695,18702,18705,18716,18744,18752,18757,18766,18791,18792,18804,18808,18809,18819,18839,18847,18850,18853,18868,18874,18887,18898,18919,18937,18956,18957,18972,18977,18986,18997,19019,19038,19060,19062,19063,19082,19112,19120,19123,19130,19134,19145,19160,19164,19184,19210,19217,19222,19251,19267,19270,19275,19282,19286,19293,19303,19310,19313,19316,19331,19359,19377,19381,19383,19413,19419,19426,19432,19433,19437,19440,19453,19455,19460,19484,19494,19495,19504,19522,19533,19551,19552,19556,19565,19566,19592,19593,19604,19607,19612,19625,19650,19651,19661,19668,19670,19695,19706,19720,19728,19730,19733,19742,19751,19758,19763,19766,19772,19779,19783,19796,19825,19864,19876,19886,19923,19927,19931,19937,19955,19976,19980,19986,19987,19989,19999,20007,20031,20038,20042,20052,20060,20062,20076,20083,20086,20091,20095,20104,20120,20145,20146,20150,20167,20179,20184,20191,20192,20193,20199,20208,20212,20213,20225,20229,20236,20274,20279,20308,20310,20332,20335,20337,20352,20362,20422,20425,20427,20439,20459,20463,20479,20502,20513,20562,20567,20572,20574,20595,20601,20605,20616,20637,20643,20648,20677,20680,20691,20697,20699,20700,20704,20713,20724,20727,20733,20737,20750,20753,20754,20765,20769,20774,20776,20792,20795,20799,20809,20817,20821,20826,20830,20832,20835,20847,20858,20890,20898,20915,20917,20932,20933,20949,20950,20960,20963,20966,20973,20975,20991,20997,20999,21002,21006,21013,21016,21017,21027,21038,21040,21041,21047,21050,21061,21069,21075,21090,21102,21104,21105,21110,21116,21140,21152,21159,21161,21172,21174,21184,21185,21195,21198,21221,21230,21233,21241,21242,21250,21256,21259,21262,21279,21280,21283,21285,21288,21293,21300,21313,21338,21340,21366,21368,21378,21386,21415,21435,21445,21452,21464,21465,21472,21485,21486,21494,21518,21524,21526,21528,21529,21538,21540,21543,21555,21606,21609,21618,21622,21623,21632,21640,21648,21650,21659,21660,21661,21662,21664,21681,21690,21695,21703,21704,21705,21714,21719,21727,21749,21766,21775,21777,21800,21824,21826,21843,21849,21850,21864,21891,21895,21907,21910,21913,21954,21955,22015,22018,22061,22062,22077,22089,22103,22117,22125,22126,22129,22163,22164,22195,22222,22225,22228,22235,22236,22241,22248,22249,22268,22302,22309,22324,22337,22345,22350,22352,22353,22362,22366,22378,22382,22395,22400,22406,22411,22419,22421,22431,22446,22453,22484,22498,22512,22514,22530,22531,22540,22550,22551,22559,22564,22573,22580,22590,22595,22603,22607,22615,22620,22622,22626,22655,22658,22665,22666,22676,22693,22709,22710,22715,22727,22737,22738,22740,22745,22753,22759,22765,22766,22767,22768,22772,22780,22787,22793,22797,22804,22822,22827,22829,22833,22850,22855,22875,22889,22897,22903,22906,22909,22920,22921,22923,22933,22934,22935,22941,22947,22963,22972,22976,22978,22989,23002,23006,23007,23017,23024,23035,23043,23050,23062,23080,23082,23089,23094,23103,23115,23124,23126,23143,23151,23179,23181,23194,23213,23214,23236,23256,23258,23271,23302,23313,23317,23336,23343,23353,23354,23358,23359,23364,23373,23380,23396,23397,23398,23417,23418,23421,23424,23429,23435,23440,23445,23449,23457,23465,23466,23476,23477,23480,23482,23495,23512,23516,23520,23528,23532,23544,23556,23559,23569,23571,23614,23627,23646,23651,23659,23665,23666,23677,23693,23695,23708,23716,23719,23732,23740,23761,23765,23768,23769,23782,23788,23792,23800,23806,23809,23816,23826,23827,23859,23860,23869,23872,23874,23879,23906,23914,23927,23943,23945,23965,23998,24001,24016,24027,24059,24101,24107,24125,24131,24140,24164,24168,24171,24172,24177,24181,24199,24207,24212,24223,24226,24246,24248,24249,24250,24258,24260,24286,24299,24303,24333,24373,24386,24393,24406,24408,24426,24434,24437,24439,24458,24466,24470,24475,24522,24528,24540,24543,24545,24565,24572,24582,24608,24617,24651,24659,24662,24672,24718,24754,24766,24780,24783,24790,24796,24803,24823,24851,24854,24857,24880,24894,24896,24905,24922,24927,24937,24941,24942,24954,24956,24960,24962,24967,24975,24981,24984,24993,24995,25001,25013,25030,25035,25040,25042,25062,25073,25083,25089,25090,25091,25094,25097,25104,25114,25118,25119,25129,25130,25131,25138,25141,25142,25143,25151,25157,25167,25170,25171,25180,25193,25199,25200,25207,25214,25222,25226,25242,25252,25257,25260,25281,25287,25296,25318,25321,25345,25351,25353,25355,25356,25366,25367,25371,25372,25390,25391,25393,25406,25414,25431,25433,25435,25436,25446,25448,25451,25456,25457,25459,25464,25465,25467,25468,25470,25472,25476,25479,25482,25485,25486,25489,25490,25492,25493,25494,25495,25499,25502,25504,25506,25508,25509,25510,25512,25517,25525,25536,25537,25538,25540,25542,25545,25546,25548,25552,25556,25558,25559,25569,25572,25576,25578,25582,25584,25587,25588,25592,25595,25596,25610,25615,25616,25628,25646,25650,25660,25674,25675,25693,25707,25756,25774,25778,25809,25819,25870,25886,25904,25916,25937,25941,25953,25974,26000,26010,26013,26014,26028,26033,26044,26047,26049,26103,26124,26147,26218,26221,26234,26236,26238,26257,26262,26286,26293,26317,26324,26338,26343,26359,26360,26362,26367,26375,26376,26389,26412,26415,26424,26431,26454,26466,26474,26479,26506,26513,26554,26572,26577,26578,26579,26589,26597,26605,26627,26651,26653,26654,26677,26683,26694,26713,26728,26742,26744,26760,26776,26785,26787,26792,26796,26801,26820,26835,26842,26843,26845,26857,26864,26874,26881,26905,26907,26916,26933,26939,26944,26947,26958,26959,26962,26968,26973,26985,26999,27000,27008,27015,27020,27024,27038,27055,27059,27067,27076,27091,27093,27095,27108,27109,27123,27126,27137,27139,27149,27181,27183,27192,27197,27209,27214,27231,27247,27248,27252,27305,27307,27342,27356,27366,27420,27437,27438,27453,27466,27470,27477,27526,27530,27566,27572,27688,27707,27717,27720,27722,27726,27786,27803,27805,27809,27822,27832,27846,27878,27911,27921,27923,27924,27926,27934,27949,27951,27952,27978,27991,28072,28078,28080,28117,28169,28252,28316,28325,28339,28390,28416,28423,28440,28442,28534,28547,28614,28615,28616,28635,28643,28679,28712,28728,28741,28751,28795,28817,28845,28870,28910,28911,28922,28930,28944,29023,29054,29123,29221,29222,29223,29235,29242,29374,29380,29391,29459,29460,29466,29499,29540,29584,29611,29635,29640,29696,29777,29814,29833,29834,29864,29909,30111,30280,30381,30478,30484,30940,30947,31409,31463,31533,31611,31623,31624,31640,31684,31725,31821,31852,31899,31908,32136,32366,32458,32472,32679,32850,33046,33274,33331,33358,33417,33422,33448,33475,33493,33534,33559,33570,33574,33600,33605,33624,33625,33649,33651,33728,33739,33740,33766,33778,33779,33780,33783,33874,33932,33941,33951,33992,33998,34012,34030,34044,34046,34062,34063,34064,34066,34067,34069,34071,34086,34092,34117,34119,34120,34128,34131,34136,34138,34139,34142,34143,34148,34155,34159,34164,34167,34169,34170,34177,34178,34179,34184,34187,34190,34210,34216,34220,34222,34223,34224,34225,34228,34229,34230,34231,34232,34235,34240,34241,34243,34244,34246,34255,34258,34260,34261,34262,34266,34269,34270,34272,34276,34279,34283,34288,34292,34296,34300,34301,34303,34308,34324,34325,34326,34332,34336,34338,34341,34343,34345,34346,34348,34349,34352,34355,34357,34359,34372,34375,34404,34459,34611,34722,34867,34956,35009,35266,35330,35333,35485,35628,35632,35643,35667,35713,35730,35741,35744,35759,35784,35803,35822,35861,35881,35909,35921,35926,35948,35955,35989,36007,36017,36041,36053,36079,36143,36214,36235,36251,36283,36339,36382,36479,36564,36617,36620,36633,36833,36838,36847,36949,36958,37002,37056,37158,37288,37289,37411,37422,37524,37532,37656,37688,37758,37796,37806,37865,38000,38071,38129,38199,38363,38452,38585,38631,38664,38665,38691,38719,38762,38800,38852,38855,38884,38898,38916,38933,38960,38985,39178,39227,39231,39318,39348,39369,39397,39398,39466,39530,39561,39600,39653,39687,39769,39826,39839,39858,39896,39897,39941,39958,39964,39977,39998,40025,40036,40050,40052,40053,40064,40072,40082,40183,40214,40290,40292,40332,40344,40414,40492,40503,40530,40605,40650,40684,40685,40703,40706,40736,40760,40809,41038,41070,41074,41095,41134,41188,41204,41337,41406,41460,41464,41503,41557,41601,41677,41681,41706,41778,41788,41861,42107,42185,42205,42387,42396,42408,42444,42590,42639,42708,42716,42836,42890,42900,42952,42991,42993,42998,43050,43051,43078,43114,43120,43191,43247,43248,43274,43291,43300,43301,43335,43360,43365,43386,43388,43398,43412,43424,43436,43528,43546,43599,43651,43688,43700,43716,43725,43857,43885,43942,44013,44046,44051,44060,44062,44079,44094,44120,44128,44141,44159,44165,44175,44200,44208,44229,44263,44282,44312,44327,44361,44382,44387,44406,44422,44447,44453,44458,44479,44480,44481,44487,44500,44517,44518,44535,44562,44609,44612,44662,44682,44759,44761,44762,44786,44797,44815,44846,44848,44858,44866,44880,44911,44950,45000,45008,45024,45050,45076,45086,45106,45131,45152,45183,45196,45208,45209,45219,45257,45275,45309)
ORDER BY i.id DESC
LIMIT 0, 5
id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
---|
1 | SIMPLE | i | NULL | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 2955 | 1.00 | Using where |
1 | SIMPLE | c | NULL | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | cms_domad_francisca.i.catid | 1 | 100.00 | Using where |
Status | Duration |
---|
starting | 1.32 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.52 ms |
System lock | 0.02 ms |
optimizing | 0.18 ms |
statistics | 4.59 ms |
preparing | 2.31 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 3.82 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.16 ms |
cleaning up | 0.04 ms |
# | Comunicador | Archivo y número de línea |
---|
15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
14 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:668 |
13 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:278 |
12 | K2ViewItem->display() | JROOT/libraries/src/Cache/Controller/ViewController.php:102 |
11 | Joomla\CMS\Cache\Controller\ViewController->get() | JROOT/libraries/src/MVC/Controller/BaseController.php:655 |
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 |