Tiempo de la consulta: 3.89 ms Después de la última consulta: 1.15 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.167 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 09:52:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 09:52:49')
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,117,136,202,264,271,280,344,350,353,374,376,377,378,379,380,456,497,608,611,686,831,868,891,941,964,976,1033,1043,1070,1087,1175,1207,1215,1287,1297,1300,1307,1329,1339,1341,1573,1601,1698,1709,1717,1744,1857,2187,2656,2709,2714,2742,3044,3085,3091,3215,3233,3237,3241,3287,3329,3340,3391,3428,3432,3483,3503,3527,3528,3537,3547,3585,3626,3628,3643,3644,3645,3670,3676,3678,3679,3693,3694,3728,3729,3730,3731,3783,3816,3817,3867,3870,3874,3877,3878,3895,3903,3907,3908,3909,3935,3938,3957,3967,3978,3987,3998,3999,4032,4057,4086,4087,4149,4185,4206,4277,4279,4316,4319,4349,4351,4372,4374,4378,4382,4400,4425,4427,4429,4431,4441,4448,4450,4455,4470,4474,4481,4501,4536,4552,4553,4571,4576,4603,4629,4638,4648,4655,4656,4754,4805,4814,4824,4838,4858,4861,4862,4885,4922,4923,4942,4946,4964,5003,5097,5127,5155,5196,5200,5320,5330,5339,5340,5409,5670,5672,5715,5730,5754,5763,5764,5813,5815,5843,5918,5930,5937,6292,6315,6333,6384,6464,6631,6648,6687,6822,6908,6940,6942,6957,6961,6989,7108,7154,7303,7434,7450,7452,7454,7522,7556,7638,7713,7744,7774,7829,7862,7916,7923,7965,7967,7985,8056,8108,8422,8694,8899,9055,9057,9133,9156,9249,9316,9318,9429,9527,9723,9725,9861,9966,9985,10011,10227,10235,10259,10265,10302,10313,10357,10534,10551,10611,10613,10777,10807,10820,10821,10843,10971,11005,11088,11136,11139,11197,11216,11217,11298,11313,11333,11347,11362,11363,11364,11365,11413,11420,11509,11514,11539,11565,11566,11606,11654,11663,11691,11711,11714,11724,11725,11752,11759,11777,11778,11802,11816,11817,11825,11890,11893,11943,11950,11962,11964,11971,11975,11976,11980,11985,11986,12009,12021,12029,12047,12065,12150,12178,12179,12231,12275,12277,12388,12446,12456,12473,12560,12604,12637,12670,12685,12733,12758,12838,12858,12898,12985,13003,13034,13036,13079,13179,13188,13206,13229,13285,13334,13647,13776,13901,14084,14098,14152,14205,14248,14250,14336,14352,14354,14396,14424,14426,14596,14625,14629,14676,14695,14754,14789,14843,14846,14856,14984,14990,15018,15197,15286,15304,15315,15316,15444,15520,15566,15608,15616,15708,15714,15723,15755,15778,15805,15897,16053,16088,16362,16381,16417,16474,16515,16523,16542,16657,16670,16675,16783,16885,16909,16982,17012,17163,17256,17261,17270,17350,17365,17422,17542,17566,17573,17625,17660,17675,17688,17712,17716,17717,17763,17801,17820,17848,17864,17888,17914,17930,17933,17967,18118,18224,18260,18300,18429,18543,18545,18553,18605,18661,18811,18830,18849,18871,18963,19001,19036,19041,19055,19099,19145,19157,19159,19254,19259,19277,19325,19574,19679,19735,19773,19830,19855,19871,19877,19881,19901,19965,19972,19984,19996,20002,20390,20405,20433,20437,20447,20488,20517,20545,20588,20698,20708,20718,20769,20772,20781,20794,20814,20875,20940,20960,20979,21053,21122,21170,21198,21247,21303,21325,21350,21370,21380,21398,21448,21449,21551,21591,21607,21640,21680,21867,21895,21990,22039,22044,22067,22096,22132,22170,22215,22255,22276,22320,22349,22363,22382,22436,22465,22501,22579,22588,22693,22709,22751,22781,22820,22866,22915,22930,23009,23029,23072,23087,23103,23112,23137,23156,23232,23252,23270,23279,23308,23367,23368,23401,23444,23484,23555,23577,23603,23621,23623,23642,23665,23682,23691,23693,23709,23716,23719,23768,23846,23849,23902,23920,23944,23949,24009,24015,24024,24060,24110,24115,24159,24164,24196,24239,24270,24296,24306,24310,24335,24362,24422,24430,24453,24506,24534,24556,24575,24617,24635,24656,24677,24707,24724,24726,24794,24816,24931,25036,25043,25136,25200,25247,25282,25287,25291,25327,25332,25367,25384,25386,25408,25416,25440,25484,25515,25526,25548,25555,25560,25575,25640,25666,25687,25692,25697,25765,25806,25854,25887,25889,25893,25959,26023,26055,26274,26340,26390,26413,26595,26799,26853,26855,26856,26984,27001,27077,27140,27159,27163,27168,27182,27193,27205,27226,27241,27253,27255,27257,27278,27309,27334,27370,27374,27379,27429,27488,27503,27508,27515,27519,27547,27584,27598,27674,27682,27702,27751,27795,27980,28025,28093,28125,28156,28182,28216,28511,28537,28593,28623,28775,28852,29168,29325,29935,29962,30274,30326,31673,32746,32820,33034,34928,34936,34952,34972,34974,34979,35000,35022,35711,35740,35774,35858,36216,36492,38958,38975,39020,39064,39159,39289,39708,40009,40057,40140,40174,40184,40751,40854,41325,43334,43402,43403,44315)
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 | 753 | 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.48 ms |
checking permissions | 0.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.30 ms |
preparing | 0.71 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.42 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |