Tiempo de la consulta: 3.51 ms Después de la última consulta: 0.90 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.472 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 23:14:58')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 23:14:58')
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,49,58,117,136,170,172,202,271,280,287,290,291,293,344,350,353,374,376,377,378,379,380,437,456,607,608,611,686,693,797,831,843,868,891,941,964,976,997,1033,1043,1207,1215,1232,1247,1287,1329,1339,1486,1601,1698,1709,1931,2656,2714,2742,2757,2997,3020,3028,3045,3091,3124,3209,3212,3215,3329,3340,3346,3671,3738,3783,3816,3842,3870,3895,3957,4087,4120,4128,4206,4319,4378,4399,4638,5471,5559,5647,5730,6039,6131,6234,6292,6333,6384,6464,6484,6616,6631,6687,6688,6908,6940,6942,6957,6961,6989,6998,7154,7303,7361,7434,7450,7454,7483,7522,7556,7638,7677,7713,7774,7829,7847,7862,7894,7916,7923,7931,7965,7967,7985,8027,8108,8694,9057,9249,9318,9429,9723,9725,9861,9966,9985,10011,10100,10149,10227,10259,10265,10313,10357,10382,10534,10611,10623,10721,10777,10782,10820,10821,10957,10971,11005,11333,11334,11362,11365,11539,11663,11799,11816,11893,11950,11976,12009,12178,12179,12270,12388,12446,12581,12582,12670,12685,12758,12838,12851,12898,12978,12985,13036,13079,13229,13285,13307,13332,13334,13420,13515,13647,13901,13972,14098,14152,14205,14248,14250,14336,14352,14354,14372,14396,14424,14426,14453,14596,14625,14629,14630,14676,14695,14754,14789,14843,14845,14852,14856,14983,14984,15007,15018,15129,15156,15214,15286,15304,15315,15316,15335,15351,15376,15406,15424,15444,15475,15520,15522,15581,15600,15608,15616,15689,15700,15714,15723,15742,15755,15778,15785,15790,15805,15812,15880,15897,16053,16088,16095,16127,16249,16357,16362,16381,16384,16417,16427,16474,16521,16523,16542,16551,16657,16670,16675,16781,16783,16816,16841,16982,16996,17049,17116,17163,17188,17240,17246,17256,17288,17331,17365,17387,17422,17444,17497,17542,17561,17566,17573,17625,17630,17660,17688,17711,17712,17717,17736,17779,17820,17834,17862,17914,17919,17933,17936,17950,17967,17983,18044,18061,18118,18222,18260,18295,18300,18382,18429,18552,18605,18664,18693,18728,18811,18830,18849,18871,18877,18888,18905,19001,19015,19055,19105,19124,19128,19140,19145,19173,19254,19259,19277,19287,19315,19325,19381,19486,19574,19607,19639,19679,19684,19710,19725,19733,19773,19794,19807,19830,19855,19871,19877,19881,19901,19923,19965,19972,19984,19996,20119,20175,20390,20405,20433,20437,20445,20447,20488,20542,20545,20588,20638,20659,20698,20708,20718,20772,20777,20781,20794,20814,20940,20959,20960,20979,21117,21118,21122,21143,21170,21198,21247,21325,21329,21332,21344,21350,21367,21370,21380,21398,21421,21448,21449,21457,21470,21520,21522,21551,21591,21607,21640,21663,21680,21684,21702,21741,21764,21776,21778,21867,21883,21895,21906,21917,21968,21990,21997,22038,22039,22044,22067,22096,22106,22119,22132,22170,22178,22215,22255,22276,22278,22298,22320,22349,22363,22382,22436,22450,22460,22465,22476,22501,22555,22570,22579,22588,22693,22709,22751,22759,22781,22820,22840,22866,22915,22930,22944,22960,22992,23009,23029,23034,23072,23087,23093,23103,23112,23137,23156,23232,23242,23252,23270,23279,23308,23367,23368,23401,23405,23430,23438,23444,23484,23553,23555,23577,23621,23623,23642,23665,23682,23691,23693,23709,23716,23719,23768,23846,23849,23902,23920,23944,23949,23955,23968,24009,24015,24024,24060,24076,24110,24115,24159,24164,24196,24237,24239,24270,24296,24306,24335,24362,24422,24430,24453,24506,24530,24556,24575,24584,24617,24635,24656,24677,24690,24707,24724,24726,24779,24794,24805,24816,24841,24931,24946,24963,25036,25037,25043,25081,25117,25136,25200,25282,25287,25291,25297,25327,25329,25332,25367,25384,25386,25408,25416,25440,25452,25484,25515,25523,25526,25548,25555,25560,25640,25676,25687,25692,25697,25765,25806,25807,25854,25887,25889,25919,25959,25971,26023,26055,26229,26261,26274,26340,26390,26413,26595,26596,26853,26854,26873,26959,27001,27061,27062,27158,27290,27374,27379,27552,27578,27584,27646,27707,27745,27795,27851,27950,28066,28094,28213,28264,28283,28511,28537,28623,28749,28826,28852,29061,29073,29325,29539,29719,29962,30274,31195,32820,32840,34788,35000,35711,35740,35774,35858,36216,36492,38958,38975,39020,39064,39159,39981,39998,40168,40184,40611,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 | 696 | 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.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.14 ms |
preparing | 0.53 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |