Tiempo de la consulta: 8.41 ms Después de la última consulta: 2.21 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.488 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-05 10:22:59')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 10:22:59')
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(9,11,25,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,74,75,76,77,78,79,80,81,82,83,85,86,87,88,89,110,111,117,120,121,122,123,124,125,136,140,142,143,144,145,146,147,148,149,150,151,152,153,154,155,170,172,178,179,188,189,190,200,203,204,205,207,208,234,246,247,248,249,255,256,263,271,272,282,287,290,291,293,321,323,324,325,334,344,353,362,371,385,389,412,415,416,420,421,422,423,424,426,427,429,431,434,437,446,447,458,484,489,495,496,501,503,531,574,575,593,607,669,670,671,677,686,693,701,723,744,746,757,785,797,799,800,813,831,843,844,853,862,868,897,940,942,954,956,964,970,974,976,986,997,1018,1044,1047,1053,1080,1091,1123,1130,1139,1143,1158,1169,1173,1185,1186,1207,1215,1223,1232,1233,1236,1247,1252,1253,1256,1277,1287,1298,1302,1304,1330,1339,1353,1357,1434,1459,1463,1486,1503,1643,1664,1709,1718,1725,1817,1835,1878,1893,1931,2108,2144,2150,2169,2199,2208,2210,2217,2237,2242,2256,2261,2272,2273,2286,2299,2322,2346,2348,2386,2394,2482,2713,2757,2776,2825,2827,2853,2857,2859,2964,2997,3020,3028,3045,3049,3051,3071,3099,3106,3107,3113,3124,3126,3198,3209,3210,3212,3219,3223,3229,3301,3322,3325,3329,3341,3384,3415,3425,3439,3442,3449,3463,3503,3519,3522,3543,3577,3650,3669,3671,3672,3682,3687,3692,3706,3738,3784,3786,3814,3842,3852,3870,3886,3902,3912,3986,3997,4013,4030,4076,4078,4090,4114,4120,4128,4168,4191,4236,4239,4257,4281,4310,4315,4325,4346,4347,4378,4399,4405,4417,4499,4516,4533,4583,4643,4670,4674,4676,4710,4760,4765,4778,4780,4789,4848,4894,4902,4905,4915,4940,5060,5085,5115,5152,5187,5189,5210,5211,5229,5274,5300,5304,5324,5350,5386,5392,5407,5433,5442,5451,5471,5476,5525,5536,5538,5559,5647,5652,5659,5662,5685,5725,5798,5814,5816,5842,5851,5854,5894,5895,5896,5979,6039,6062,6131,6150,6164,6234,6247,6274,6298,6311,6337,6361,6362,6392,6393,6419,6448,6470,6473,6475,6482,6484,6486,6538,6546,6567,6573,6616,6619,6633,6647,6654,6666,6669,6671,6688,6715,6725,6726,6744,6748,6749,6776,6785,6799,6836,6841,6868,6895,6905,6911,6913,6948,6955,6965,6966,6968,6971,6989,6998,7014,7016,7017,7031,7043,7050,7056,7075,7101,7105,7109,7124,7138,7142,7143,7161,7165,7166,7187,7189,7210,7217,7218,7282,7285,7287,7291,7296,7311,7328,7343,7359,7361,7364,7380,7387,7391,7401,7403,7414,7427,7435,7450,7451,7456,7461,7483,7486,7508,7509,7539,7544,7546,7547,7551,7561,7567,7568,7581,7588,7603,7615,7677,7682,7688,7692,7710,7716,7730,7736,7737,7744,7779,7782,7787,7797,7806,7811,7818,7825,7827,7829,7831,7836,7847,7848,7858,7861,7863,7867,7894,7914,7930,7933,7950,7957,7965,7966,7970,7973,7981,7983,7984,7989,7993,7998,8010,8014,8020,8022,8027,8036,8041,8065,8108,8115,8123,8134,8163,8171,8177,8207,8215,8219,8250,8258,8259,8263,8264,8311,8318,8356,8379,8400,8422,8444,8455,8469,8509,8519,8520,8523,8551,8563,8565,8576,8589,8602,8610,8623,8625,8638,8663,8679,8692,8698,8701,8727,8736,8756,8785,8789,8835,8856,8857,8862,8867,8887,8919,8934,8949,8950,8971,8980,9005,9020,9050,9080,9091,9128,9138,9159,9165,9203,9206,9212,9214,9239,9242,9249,9262,9282,9305,9310,9311,9318,9347,9351,9365,9384,9411,9414,9428,9429,9435,9438,9445,9448,9451,9457,9467,9472,9503,9507,9549,9555,9568,9574,9585,9594,9616,9626,9650,9656,9676,9677,9678,9690,9702,9774,9791,9827,9829,9860,9864,9892,9893,9907,9916,9924,9959,10028,10035,10060,10092,10100,10108,10116,10117,10120,10149,10154,10170,10187,10188,10193,10196,10206,10208,10239,10264,10268,10274,10277,10278,10294,10315,10342,10354,10366,10369,10382,10401,10415,10425,10435,10453,10498,10512,10522,10535,10567,10611,10623,10644,10682,10721,10741,10754,10757,10771,10777,10779,10780,10782,10803,10835,10846,10903,10907,10916,10925,10952,10957,10983,11008,11035,11037,11059,11062,11065,11073,11091,11095,11114,11148,11149,11150,11167,11192,11207,11242,11249,11260,11269,11310,11316,11335,11344,11345,11366,11377,11391,11417,11427,11430,11503,11607,11749,11757,11808,11816,11863,11875,11886,11896,11924,11974,11978,11983,12020,12024,12042,12070,12096,12112,12121,12133,12147,12156,12162,12165,12174,12193,12204,12270,12285,12297,12299,12301,12324,12355,12388,12398,12401,12427,12443,12445,12460,12477,12482,12492,12515,12519,12527,12567,12579,12581,12582,12609,12610,12620,12624,12625,12631,12650,12651,12670,12681,12685,12686,12695,12708,12709,12743,12758,12786,12806,12808,12812,12823,12837,12844,12846,12850,12851,12856,12884,12902,12913,12940,12963,12973,12978,12990,12996,12997,13004,13014,13016,13036,13038,13061,13089,13090,13100,13124,13152,13161,13207,13213,13216,13279,13294,13307,13332,13348,13376,13420,13445,13461,13474,13475,13476,13481,13492,13500,13504,13506,13515,13519,13553,13587,13635,13666,13696,13740,13771,13790,13792,13808,13837,13844,13879,13880,13886,13894,13900,13909,13910,13922,13929,13948,13949,13971,13972,13973,14061,14107,14116,14123,14128,14140,14163,14186,14189,14194,14197,14205,14229,14232,14249,14257,14258,14260,14285,14289,14293,14297,14330,14346,14350,14362,14370,14372,14401,14426,14453,14457,14481,14516,14534,14536,14554,14591,14598,14625,14630,14631,14676,14697,14698,14700,14725,14726,14740,14749,14771,14824,14828,14829,14833,14845,14847,14850,14852,14856,14860,14865,14911,14939,14947,14962,14983,14986,14988,14999,15003,15007,15035,15038,15043,15056,15063,15086,15089,15094,15103,15129,15156,15158,15171,15173,15177,15187,15193,15205,15214,15227,15233,15240,15245,15259,15260,15261,15270,15286,15293,15318,15332,15335,15346,15351,15361,15376,15382,15406,15407,15408,15414,15418,15424,15429,15432,15447,15469,15475,15476,15486,15487,15489,15501,15516,15520,15522,15533,15560,15569,15574,15581,15590,15600,15615,15626,15628,15632,15672,15689,15699,15700,15721,15723,15732,15738,15742,15768,15775,15776,15778,15785,15790,15793,15796,15799,15812,15850,15855,15861,15863,15872,15875,15876,15879,15880,15884,15889,15898,15912,15932,15937,15945,15958,15972,15978,15981,15987,16024,16030,16038,16043,16055,16056,16062,16071,16084,16090,16095,16100,16115,16119,16127,16129,16133,16155,16161,16172,16176,16180,16192,16193,16211,16217,16249,16254,16278,16281,16282,16301,16310,16314,16315,16323,16325,16338,16357,16359,16362,16366,16368,16378,16381,16384,16417,16427,16430,16438,16450,16476,16497,16509,16516,16521,16523,16524,16526,16542,16543,16547,16551,16561,16564,16566,16571,16622,16626,16642,16651,16657,16668,16675,16687,16689,16698,16705,16713,16715,16717,16728,16729,16732,16739,16746,16751,16771,16781,16816,16833,16839,16840,16841,16850,16863,16865,16872,16875,16908,16928,16950,16951,16954,16960,16976,16988,16993,17002,17024,17025,17049,17060,17067,17071,17084,17086,17096,17109,17112,17114,17116,17120,17132,17142,17148,17152,17153,17188,17193,17200,17222,17240,17242,17246,17253,17260,17273,17274,17278,17282,17287,17288,17289,17297,17298,17299,17300,17309,17331,17333,17334,17335,17336,17339,17360,17387,17410,17414,17418,17419,17444,17449,17456,17468,17470,17475,17486,17490,17496,17497,17500,17509,17528,17539,17540,17545,17548,17550,17559,17561,17572,17573,17583,17598,17599,17601,17607,17616,17618,17627,17629,17630,17632,17659,17664,17668,17688,17693,17701,17702,17711,17712,17721,17727,17734,17736,17748,17753,17755,17759,17779,17782,17783,17784,17786,17810,17814,17818,17824,17826,17834,17851,17853,17857,17862,17870,17879,17893,17919,17920,17930,17931,17933,17936,17941,17950,17954,17967,17983,17988,17992,17995,18001,18003,18006,18022,18032,18044,18061,18071,18072,18073,18074,18083,18121,18143,18173,18190,18219,18220,18222,18246,18260,18271,18274,18291,18295,18300,18301,18304,18309,18311,18320,18330,18351,18352,18358,18360,18382,18391,18450,18463,18467,18494,18498,18510,18524,18529,18549,18552,18558,18572,18577,18578,18609,18612,18619,18622,18629,18648,18651,18658,18664,18665,18668,18693,18694,18696,18715,18724,18728,18744,18750,18751,18757,18762,18789,18810,18811,18819,18830,18846,18849,18866,18873,18877,18880,18888,18894,18901,18905,18911,18916,18923,18953,18959,18961,18984,18997,19003,19004,19014,19015,19018,19048,19049,19060,19063,19105,19124,19128,19129,19134,19138,19140,19143,19145,19152,19155,19173,19180,19217,19230,19231,19260,19276,19282,19283,19287,19296,19297,19303,19308,19311,19315,19344,19364,19381,19407,19416,19419,19420,19424,19437,19453,19457,19460,19482,19486,19501,19518,19521,19536,19551,19556,19572,19575,19583,19591,19601,19607,19617,19622,19639,19645,19646,19648,19650,19652,19655,19659,19661,19668,19684,19695,19710,19718,19719,19720,19725,19747,19772,19784,19787,19794,19807,19811,19814,19825,19827,19839,19848,19854,19857,19869,19875,19886,19915,19923,19931,19937,19958,19960,19980,19982,19983,19984,19993,20015,20023,20031,20042,20048,20053,20060,20076,20083,20091,20095,20104,20119,20127,20148,20161,20163,20168,20175,20179,20189,20192,20193,20200,20213,20243,20276,20286,20289,20301,20303,20308,20315,20329,20333,20345,20382,20405,20439,20445,20459,20468,20472,20474,20489,20504,20515,20522,20540,20542,20555,20559,20563,20567,20595,20607,20615,20616,20630,20638,20648,20659,20664,20666,20676,20680,20699,20700,20708,20710,20727,20732,20737,20752,20761,20772,20777,20778,20805,20812,20826,20847,20869,20913,20940,20947,20959,20960,20975,20981,20982,21005,21016,21038,21058,21063,21075,21079,21089,21117,21118,21126,21128,21129,21136,21140,21143,21159,21187,21209,21223,21247,21255,21256,21270,21279,21283,21285,21288,21289,21297,21300,21305,21313,21321,21323,21338,21344,21349,21350,21367,21368,21369,21372,21386,21392,21398,21421,21429,21433,21457,21464,21470,21475,21485,21486,21491,21496,21498,21520,21521,21522,21524,21526,21529,21545,21555,21577,21590,21611,21618,21623,21627,21650,21661,21663,21664,21681,21684,21690,21695,21702,21704,21711,21719,21727,21740,21741,21746,21751,21757,21764,21775,21776,21778,21800,21824,21843,21850,21851,21858,21863,21870,21878,21879,21883,21895,21904,21906,21910,21917,21924,21928,21954,21955,21961,21968,21987,21997,22000,22011,22015,22018,22030,22038,22039,22040,22061,22062,22067,22077,22079,22089,22093,22098,22099,22106,22113,22117,22119,22122,22126,22139,22163,22164,22178,22180,22191,22194,22195,22207,22222,22241,22278,22298,22302,22306,22315,22324,22326,22336,22342,22349,22359,22363,22382,22395,22396,22406,22421,22432,22436,22446,22450,22453,22460,22476,22484,22488,22497,22502,22512,22554,22555,22570,22572,22580,22596,22603,22620,22622,22626,22642,22647,22655,22658,22659,22693,22698,22709,22710,22715,22727,22751,22752,22753,22754,22759,22765,22780,22787,22804,22820,22829,22833,22840,22897,22909,22913,22923,22934,22935,22944,22947,22960,22972,22974,22976,22985,22989,22999,23007,23011,23015,23022,23024,23034,23043,23062,23077,23078,23082,23087,23089,23093,23124,23127,23139,23144,23179,23214,23221,23242,23251,23279,23289,23295,23297,23308,23318,23367,23368,23397,23398,23405,23424,23430,23438,23439,23444,23456,23463,23480,23498,23505,23525,23527,23528,23535,23553,23555,23562,23573,23574,23585,23591,23599,23602,23618,23665,23682,23691,23693,23709,23716,23730,23746,23761,23787,23814,23815,23826,23836,23849,23853,23869,23910,23912,23920,23921,23927,23936,23937,23955,23958,23965,23968,23969,23995,24003,24012,24016,24033,24034,24061,24066,24068,24076,24082,24090,24101,24115,24127,24164,24168,24170,24178,24189,24220,24226,24237,24249,24270,24284,24315,24326,24364,24365,24390,24393,24408,24417,24429,24438,24441,24461,24475,24481,24499,24511,24520,24522,24526,24528,24530,24573,24577,24582,24584,24605,24617,24649,24668,24672,24690,24720,24730,24754,24755,24775,24779,24780,24795,24803,24805,24806,24807,24816,24841,24849,24850,24865,24868,24888,24909,24937,24941,24946,24956,24963,24975,24993,24998,25002,25003,25026,25030,25035,25037,25048,25062,25064,25069,25070,25071,25081,25090,25091,25109,25117,25131,25134,25138,25147,25153,25164,25171,25192,25226,25230,25280,25293,25294,25297,25310,25314,25316,25318,25326,25329,25332,25333,25343,25351,25352,25384,25387,25389,25406,25408,25420,25429,25434,25436,25448,25452,25471,25477,25484,25501,25517,25519,25523,25535,25542,25560,25573,25584,25595,25601,25614,25638,25646,25653,25660,25664,25672,25676,25688,25691,25697,25701,25711,25718,25740,25747,25785,25807,25820,25904,25919,25921,25948,25971,26000,26008,26033,26042,26043,26050,26053,26066,26101,26133,26147,26165,26188,26216,26221,26229,26231,26246,26250,26261,26275,26292,26317,26343,26358,26360,26367,26379,26380,26412,26415,26421,26424,26431,26440,26444,26451,26454,26474,26521,26541,26559,26561,26568,26571,26583,26596,26604,26618,26651,26672,26677,26697,26698,26713,26729,26730,26742,26747,26801,26809,26820,26845,26854,26859,26873,26881,26905,26907,26930,26944,26958,26959,26960,26973,26985,27000,27001,27002,27006,27009,27015,27024,27025,27038,27039,27055,27056,27058,27061,27062,27076,27082,27083,27089,27101,27153,27158,27161,27178,27213,27218,27233,27263,27271,27290,27316,27317,27321,27333,27346,27366,27384,27417,27435,27438,27506,27530,27544,27552,27578,27634,27646,27688,27707,27722,27737,27741,27745,27763,27839,27846,27851,27905,27949,27950,27968,27990,28036,28066,28068,28072,28075,28080,28094,28102,28131,28213,28215,28223,28232,28264,28283,28295,28333,28336,28339,28346,28352,28353,28360,28372,28373,28440,28442,28457,28478,28484,28485,28499,28511,28548,28552,28606,28611,28614,28615,28616,28664,28690,28712,28728,28731,28747,28749,28774,28787,28826,28845,28896,28897,28933,28939,28944,28949,29054,29061,29073,29143,29214,29219,29241,29269,29356,29365,29372,29374,29378,29391,29460,29484,29539,29584,29617,29618,29622,29635,29719,29722,29743,29844,29867,29911,29923,30000,30031,30180,30382,30398,30403,30479,30507,30574,30604,30723,30864,31097,31115,31286,31430,31634,31850,32331,32565,32676,32840,32874,33417,35330,35495,35566,35638,35713,35744,35812,35882,35942,35955,36310,36875,37497,38802,38803,38804,38805,38806,38850,38884,38898,38932,39049,39385,39398,39527,39530,39588,39629,39857,39981,39998,40028,40036,40048,40168,40203,40351,40356,40369,40483,40492,40605,40611,40636,40681,40759,40877,41005,41399,41507,42458,42948,43564,45008)
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 | 2443 | 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.03 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.41 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 3.60 ms |
preparing | 1.83 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.41 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.03 ms |
freeing items | 0.08 ms |
cleaning up | 0.03 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 |