Tiempo de la consulta: 4.61 ms Después de la última consulta: 0.89 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.213 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 10:19:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 10:19:42')
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(49,74,75,76,77,78,117,131,134,136,137,140,142,143,144,145,146,178,179,202,207,208,225,271,280,325,344,350,353,374,376,377,378,379,380,456,489,511,608,609,611,686,723,744,782,831,868,891,941,942,951,952,960,964,976,986,1033,1043,1044,1047,1069,1080,1130,1143,1158,1185,1207,1215,1226,1252,1253,1256,1287,1302,1317,1329,1339,1459,1601,1664,1698,1709,2352,2485,2656,2713,2714,2742,2847,2978,3091,3126,3215,3223,3301,3329,3340,3353,3442,3668,3669,3687,3783,3814,3816,3870,3895,3957,4087,4206,4319,4378,4570,4638,4765,5472,5530,5647,5659,5730,5785,5814,5870,5996,6039,6057,6292,6298,6333,6384,6448,6464,6470,6538,6573,6616,6631,6687,6908,6940,6942,6957,6961,6965,6966,6968,6989,7016,7043,7061,7075,7154,7161,7189,7245,7269,7282,7287,7291,7303,7311,7380,7387,7401,7403,7414,7427,7434,7450,7454,7469,7486,7508,7522,7546,7556,7638,7713,7719,7730,7774,7829,7831,7836,7861,7862,7867,7914,7916,7923,7957,7965,7967,7983,7985,7989,8012,8027,8054,8108,8134,8356,8397,8416,8442,8551,8610,8694,8909,8919,8950,9057,9091,9203,9239,9249,9318,9429,9554,9723,9725,9779,9787,9791,9861,9916,9966,9985,10011,10028,10092,10120,10193,10227,10259,10265,10313,10357,10358,10369,10389,10415,10453,10534,10611,10682,10777,10803,10820,10821,10835,10916,10927,10971,11005,11037,11091,11192,11206,11249,11260,11310,11333,11362,11365,11377,11419,11430,11441,11468,11539,11663,11799,11808,11816,11863,11893,11950,11976,12009,12025,12042,12070,12112,12133,12147,12174,12178,12179,12204,12327,12388,12401,12427,12446,12475,12492,12579,12609,12610,12625,12670,12681,12685,12709,12758,12806,12838,12846,12898,12985,12990,13004,13036,13079,13124,13216,13229,13285,13334,13387,13445,13461,13476,13492,13500,13647,13666,13696,13718,13725,13771,13790,13837,13880,13901,13922,14083,14098,14116,14152,14205,14232,14248,14250,14257,14258,14285,14289,14336,14352,14354,14369,14370,14396,14412,14424,14426,14481,14583,14596,14625,14629,14676,14684,14695,14697,14700,14722,14744,14749,14754,14771,14789,14840,14843,14856,14896,14897,14939,14954,14984,14986,14988,15018,15035,15086,15109,15173,15205,15251,15286,15304,15315,15316,15332,15408,15444,15475,15486,15520,15569,15608,15616,15672,15714,15723,15732,15742,15755,15778,15805,15876,15897,15898,15966,16030,16053,16088,16133,16148,16180,16254,16278,16282,16362,16381,16417,16430,16474,16516,16523,16609,16622,16657,16670,16675,16687,16698,16760,16783,16839,16865,16872,16982,16984,17084,17096,17142,17153,17163,17186,17256,17274,17278,17288,17289,17300,17331,17333,17336,17337,17365,17405,17410,17414,17422,17437,17449,17540,17542,17559,17566,17573,17598,17599,17625,17632,17660,17664,17688,17703,17712,17717,17734,17783,17784,17814,17820,17851,17914,17930,17933,17941,17950,17967,17995,18006,18074,18118,18121,18260,18262,18291,18300,18301,18311,18320,18351,18391,18429,18463,18503,18524,18549,18552,18577,18596,18605,18642,18651,18658,18659,18668,18693,18702,18705,18724,18750,18770,18810,18811,18830,18839,18846,18847,18849,18850,18853,18871,18873,18894,18937,18959,18984,18990,19001,19003,19055,19069,19109,19124,19129,19134,19138,19145,19184,19191,19222,19230,19254,19259,19277,19296,19311,19325,19344,19381,19424,19455,19460,19501,19521,19536,19556,19565,19572,19574,19622,19670,19679,19690,19720,19733,19773,19830,19848,19855,19869,19871,19877,19881,19901,19915,19958,19960,19965,19972,19982,19984,19993,19996,20042,20076,20091,20104,20148,20163,20168,20189,20200,20276,20286,20345,20382,20390,20405,20425,20433,20437,20447,20474,20488,20515,20540,20545,20555,20588,20666,20698,20708,20718,20752,20772,20778,20781,20794,20814,20838,20869,20890,20913,20933,20940,20960,20979,20981,20996,21058,21075,21110,21116,21122,21170,21198,21199,21216,21247,21305,21321,21325,21350,21370,21378,21380,21392,21398,21448,21449,21494,21521,21540,21551,21577,21591,21607,21609,21611,21629,21640,21659,21680,21714,21734,21749,21775,21777,21863,21864,21867,21895,21924,21928,21961,21990,22000,22039,22044,22067,22079,22093,22096,22132,22139,22170,22180,22207,22215,22241,22255,22276,22320,22326,22345,22349,22363,22382,22395,22424,22436,22465,22488,22497,22501,22574,22579,22588,22659,22693,22698,22709,22715,22751,22754,22781,22804,22820,22840,22850,22866,22903,22915,22920,22930,22978,22989,23009,23029,23072,23077,23087,23103,23112,23137,23144,23156,23213,23232,23242,23252,23270,23279,23286,23289,23308,23317,23353,23367,23368,23373,23397,23401,23444,23457,23475,23484,23498,23520,23527,23535,23544,23555,23569,23577,23599,23619,23621,23623,23642,23646,23665,23682,23691,23693,23695,23709,23716,23719,23732,23768,23787,23836,23846,23849,23859,23869,23872,23902,23912,23920,23937,23944,23949,23965,23969,24003,24009,24015,24019,24024,24033,24060,24064,24066,24090,24110,24115,24159,24164,24170,24196,24207,24239,24255,24258,24270,24284,24296,24306,24335,24362,24417,24422,24430,24437,24439,24441,24453,24461,24481,24506,24520,24525,24556,24565,24567,24575,24602,24617,24635,24649,24656,24677,24707,24720,24724,24726,24730,24754,24755,24775,24794,24795,24816,24850,24865,24931,25002,25003,25026,25036,25043,25069,25090,25109,25136,25164,25170,25192,25193,25200,25281,25282,25287,25291,25327,25332,25352,25356,25367,25384,25386,25387,25408,25416,25440,25470,25477,25484,25490,25512,25515,25517,25519,25526,25535,25548,25555,25560,25601,25638,25640,25664,25672,25687,25692,25693,25697,25701,25740,25765,25806,25854,25887,25889,25922,25959,26023,26043,26055,26117,26218,26248,26257,26274,26340,26375,26390,26409,26412,26413,26421,26435,26521,26561,26595,26596,26671,26678,26744,26835,26842,26843,26853,26864,26930,26933,27001,27037,27039,27059,27197,27233,27263,27271,27305,27346,27374,27379,27384,27435,27506,27584,27634,27795,27832,27911,27921,27923,27924,27926,27949,27968,27990,28068,28295,28372,28478,28511,28537,28606,28623,28852,28933,28949,29214,29219,29223,29235,29269,29325,29380,29484,29611,29622,29683,29777,29814,29864,29911,29923,29962,30274,30280,30496,30916,31286,31640,31908,32331,32565,32820,35000,35628,35632,35667,35711,35713,35740,35744,35759,35774,35784,35858,36216,36492,36875,36949,38884,38898,38958,38960,38975,39020,39064,39159,39600,40184,40332,40351,40369,40414,40636,40684,40759,41325)
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 | 1066 | 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 | 0.49 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 1.63 ms |
preparing | 0.85 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |