Tiempo de la consulta: 3.60 ms Después de la última consulta: 0.66 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.310 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-08 14:17:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 14:17:45')
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,61,117,136,160,202,262,271,280,311,341,344,350,353,374,376,377,378,379,380,456,462,545,608,611,686,697,831,868,891,941,964,976,1033,1043,1126,1207,1215,1287,1329,1339,1515,1566,1601,1654,1685,1698,1709,1766,1797,1824,1924,2424,2656,2714,2715,2742,2826,3018,3086,3091,3215,3329,3340,3433,3495,3641,3783,3816,3819,3870,3895,3957,4035,4087,4132,4206,4292,4319,4378,4397,4487,4638,5150,5173,5206,5334,5680,5700,5730,5811,6151,6292,6333,6344,6384,6464,6537,6540,6631,6687,6771,6872,6908,6940,6942,6957,6961,6988,6989,7107,7154,7248,7290,7303,7430,7432,7434,7450,7454,7476,7492,7522,7556,7580,7638,7680,7713,7749,7774,7829,7862,7916,7923,7965,7967,7985,8002,8108,8293,8304,8328,8413,8437,8440,8447,8513,8694,8830,8911,8941,8959,9057,9063,9199,9244,9249,9318,9323,9370,9429,9620,9637,9652,9723,9725,9811,9848,9861,9964,9966,9985,10011,10227,10259,10265,10294,10313,10357,10534,10611,10777,10820,10821,10971,11005,11147,11333,11362,11365,11539,11542,11552,11581,11630,11663,11704,11705,11799,11816,11893,11921,11950,11961,11976,12009,12020,12084,12178,12179,12201,12274,12388,12446,12537,12670,12685,12758,12838,12898,12902,12985,12986,13036,13079,13229,13285,13334,13479,13553,13646,13647,13688,13714,13813,13814,13895,13901,13931,13950,13968,13969,13997,14047,14098,14152,14205,14248,14250,14278,14289,14301,14304,14336,14352,14354,14368,14396,14424,14426,14433,14596,14625,14629,14674,14676,14690,14695,14719,14754,14789,14800,14809,14834,14843,14856,14864,14906,14927,14984,15018,15137,15286,15304,15315,15316,15323,15444,15445,15456,15458,15520,15544,15552,15608,15616,15700,15714,15723,15755,15774,15778,15805,15897,16053,16088,16142,16309,16328,16349,16362,16381,16417,16474,16488,16505,16508,16523,16542,16549,16607,16641,16657,16670,16675,16739,16783,16887,16911,16982,17008,17089,17163,17185,17256,17365,17422,17458,17485,17542,17566,17573,17580,17625,17644,17646,17660,17688,17712,17717,17751,17820,17914,17930,17933,17967,18033,18103,18118,18126,18193,18202,18231,18291,18300,18359,18382,18422,18429,18602,18605,18611,18644,18669,18811,18830,18849,18871,19001,19050,19055,19096,19122,19125,19145,19184,19254,19259,19277,19287,19325,19413,19456,19484,19574,19679,19703,19716,19720,19773,19830,19855,19871,19877,19881,19901,19952,19965,19972,19984,19992,19996,20027,20113,20117,20139,20154,20160,20182,20208,20209,20214,20251,20282,20351,20390,20405,20433,20437,20447,20488,20520,20545,20588,20606,20619,20698,20708,20718,20767,20772,20781,20794,20800,20814,20940,20959,20960,20979,20996,21032,21064,21068,21081,21122,21170,21198,21205,21235,21247,21303,21325,21350,21367,21370,21376,21380,21398,21408,21411,21448,21449,21459,21535,21540,21541,21551,21589,21591,21594,21607,21640,21680,21684,21782,21790,21841,21867,21895,21990,22039,22044,22046,22067,22096,22132,22170,22215,22232,22244,22245,22246,22255,22276,22320,22344,22349,22363,22382,22398,22401,22436,22438,22465,22501,22549,22579,22588,22693,22709,22751,22781,22792,22820,22866,22915,22930,22942,22948,22962,23009,23029,23072,23087,23103,23112,23137,23156,23196,23232,23252,23270,23279,23300,23308,23319,23367,23368,23401,23434,23444,23484,23555,23577,23590,23621,23623,23642,23665,23682,23691,23693,23709,23716,23719,23740,23768,23846,23849,23902,23903,23920,23949,24009,24015,24024,24033,24060,24110,24115,24159,24164,24196,24200,24239,24270,24296,24306,24330,24335,24362,24395,24421,24422,24430,24447,24453,24506,24518,24556,24575,24597,24617,24635,24656,24677,24707,24708,24724,24725,24726,24793,24794,24816,24852,24931,24990,25023,25036,25043,25136,25200,25282,25287,25291,25315,25327,25332,25367,25384,25386,25408,25416,25440,25484,25515,25526,25548,25555,25560,25609,25640,25687,25692,25697,25706,25765,25777,25806,25834,25854,25887,25889,25936,25959,26017,26023,26024,26034,26055,26229,26274,26288,26328,26340,26390,26413,26494,26595,26646,26853,26918,26945,26967,27001,27065,27374,27379,27434,27458,27518,27584,27611,27630,27795,28275,28511,28537,28623,28686,28852,28949,29325,29962,30274,32820,33547,34096,34160,35000,35474,35560,35589,35711,35716,35740,35774,35791,35811,35858,35985,36156,36201,36216,36240,36492,36517,36624,36947,37333,37535,37536,37537,37549,37550,37551,38280,38436,38646,38746,38917,38958,38975,39020,39064,39159,39525,39583,40184,40499,41052,41106,41156,41325,41559,41790,42030,42066,42237,42286,42343,42407,42483,42502,43637,44537,44784,45029)
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 | 758 | 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.38 ms |
checking permissions | 0.03 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.16 ms |
preparing | 0.56 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.12 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 |