Tiempo de la consulta: 4.23 ms Después de la última consulta: 0.80 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.332 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-07 13:43:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 13:43:28')
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(44,45,46,49,52,59,89,117,136,181,198,201,202,215,216,221,224,225,244,254,262,271,280,325,344,350,353,374,375,376,377,378,379,380,394,434,444,445,456,481,603,608,611,615,625,641,642,647,648,650,651,652,654,681,686,687,689,693,814,824,831,832,845,854,868,875,891,936,950,964,976,1033,1043,1066,1071,1073,1207,1215,1220,1227,1257,1266,1267,1268,1287,1329,1339,1359,1467,1574,1601,1637,1659,1698,1709,1721,1753,1778,1805,1863,1896,1932,1996,2221,2428,2656,2714,2742,2761,2773,2794,2855,2893,2980,3091,3215,3234,3291,3329,3340,3595,3716,3725,3733,3783,3801,3816,3870,3883,3895,3956,3957,4028,4063,4087,4093,4182,4199,4206,4260,4268,4302,4319,4338,4378,4405,4638,5182,5184,5207,5302,5576,5658,5698,5730,5756,5879,5889,5967,6084,6292,6333,6361,6384,6464,6536,6631,6641,6658,6687,6780,6908,6939,6940,6942,6957,6961,6989,7154,7303,7329,7333,7365,7434,7450,7454,7507,7522,7536,7554,7556,7621,7627,7638,7713,7743,7774,7829,7862,7916,7923,7965,7967,7985,8083,8108,8294,8306,8406,8520,8694,8765,8940,9010,9057,9111,9114,9186,9249,9318,9398,9429,9444,9454,9480,9505,9641,9723,9725,9741,9815,9861,9864,9928,9966,9981,9985,10011,10068,10138,10217,10227,10259,10265,10313,10324,10357,10402,10479,10534,10611,10674,10696,10758,10777,10820,10821,10827,10842,10863,10971,11005,11032,11140,11179,11333,11362,11365,11385,11398,11421,11539,11542,11663,11670,11706,11717,11723,11794,11799,11816,11838,11859,11893,11950,11976,11990,12009,12034,12178,12179,12206,12218,12320,12388,12413,12446,12670,12685,12758,12838,12852,12898,12902,12943,12957,12985,13036,13077,13079,13218,13229,13285,13334,13647,13698,13710,13765,13803,13901,13925,13926,13970,14037,14083,14098,14110,14115,14149,14152,14154,14176,14205,14248,14250,14255,14336,14352,14354,14385,14396,14424,14426,14449,14577,14596,14609,14625,14629,14658,14676,14695,14754,14766,14789,14811,14813,14843,14856,14984,15002,15018,15051,15115,15122,15133,15184,15257,15272,15286,15304,15315,15316,15362,15444,15488,15499,15520,15608,15616,15633,15643,15714,15723,15732,15755,15778,15805,15864,15887,15897,15910,15980,15996,15998,15999,16053,16055,16088,16356,16359,16362,16381,16394,16401,16417,16474,16523,16535,16542,16657,16670,16675,16686,16783,16784,16887,16955,16982,17163,17256,17327,17359,17365,17422,17423,17434,17438,17542,17562,17566,17573,17625,17660,17688,17712,17717,17730,17781,17820,17873,17914,17930,17933,17953,17967,18014,18073,18118,18145,18153,18300,18395,18429,18527,18570,18576,18581,18594,18605,18607,18617,18627,18697,18765,18811,18812,18830,18849,18871,18889,18900,18905,18915,18952,18960,18966,19001,19011,19026,19050,19055,19057,19079,19089,19145,19202,19254,19256,19259,19266,19277,19325,19374,19385,19401,19411,19456,19469,19574,19610,19648,19679,19713,19770,19773,19830,19855,19871,19877,19881,19901,19929,19944,19965,19972,19984,19996,20009,20078,20164,20179,20390,20405,20433,20437,20447,20480,20488,20510,20545,20588,20589,20698,20708,20717,20718,20772,20781,20794,20814,20919,20940,20951,20960,20962,20979,21019,21067,21072,21122,21146,21163,21170,21171,21179,21198,21226,21238,21239,21247,21274,21311,21325,21350,21351,21370,21379,21380,21398,21411,21448,21449,21450,21455,21467,21490,21551,21562,21583,21591,21592,21607,21640,21675,21680,21713,21771,21775,21789,21867,21886,21895,21920,21981,21990,22001,22029,22039,22044,22067,22096,22132,22170,22181,22211,22215,22255,22272,22276,22286,22290,22294,22320,22338,22349,22363,22382,22436,22465,22501,22579,22588,22664,22676,22687,22693,22709,22733,22751,22781,22783,22797,22820,22863,22866,22915,22930,22941,23009,23029,23042,23066,23067,23072,23075,23087,23103,23109,23112,23128,23137,23156,23163,23232,23252,23270,23278,23279,23308,23362,23367,23368,23401,23444,23484,23555,23577,23579,23621,23623,23642,23665,23682,23690,23691,23693,23696,23709,23716,23719,23768,23846,23849,23902,23920,23944,23949,23987,24009,24015,24024,24059,24060,24110,24115,24159,24164,24196,24235,24239,24270,24296,24306,24335,24362,24422,24430,24452,24453,24506,24556,24575,24617,24635,24656,24674,24677,24707,24724,24726,24794,24816,24931,24999,25013,25024,25036,25043,25073,25094,25136,25200,25282,25287,25291,25327,25332,25347,25367,25384,25386,25408,25416,25440,25484,25515,25526,25548,25555,25560,25640,25687,25692,25697,25765,25806,25854,25887,25889,25932,25959,25974,26023,26055,26274,26315,26340,26390,26413,26595,26775,26853,27001,27236,27279,27374,27379,27584,27795,27954,28423,28442,28511,28537,28623,28751,28817,28852,28922,29242,29325,29387,29486,29719,29832,29962,30274,31684,31821,31852,31899,32472,32679,32820,35000,35485,35643,35711,35740,35774,35858,36143,36214,36216,36492,37056,37796,38363,38452,38585,38664,38665,38719,38762,38866,38903,38958,38975,39020,39035,39048,39064,39111,39159,39195,39227,39231,39335,39397,39480,39572,39645,39666,39687,39769,39891,39907,40025,40052,40082,40183,40184,40344,40441,40558,40650,40760,41070,41092,41095,41188,41219,41325,41464,41503,41601,41681,41706,41778,41861,42107,42185,42205,42408,42590,42686,42716,42836,42900,42991,42993,42998,43050,43078,43114,43120,43191,43248,43291,43300,43301,43335,43386,43398,43412,43424,43688,43725,43942,44013,44046,44060,44079,44094,44120,44128,44200,44208,44263,44312,44382,44447,44453,44517,44609,44662)
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 | 917 | 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.47 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.44 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 |