Tiempo de la consulta: 5.16 ms Después de la última consulta: 0.71 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.180 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-09 03:53:48')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 03:53:48')
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,78,113,114,117,136,201,202,207,208,271,280,344,349,350,353,374,375,376,377,378,379,380,456,608,611,686,693,814,831,868,891,941,964,976,986,1033,1043,1207,1215,1273,1287,1329,1339,1560,1601,1698,1709,1957,2622,2656,2714,2742,2761,2896,2901,2991,3091,3117,3215,3329,3340,3457,3603,3668,3714,3725,3783,3816,3840,3870,3895,3957,4087,4206,4319,4378,4638,4703,5730,5778,6292,6333,6361,6384,6464,6631,6687,6908,6940,6942,6957,6961,6989,7154,7280,7282,7303,7311,7387,7402,7403,7410,7434,7450,7454,7522,7556,7614,7621,7626,7638,7713,7774,7780,7829,7836,7862,7890,7916,7923,7965,7967,7985,8107,8108,8177,8211,8562,8686,8694,9010,9057,9249,9318,9429,9505,9723,9725,9815,9861,9864,9966,9985,10011,10019,10092,10110,10120,10181,10227,10259,10265,10313,10318,10324,10357,10369,10370,10382,10399,10415,10444,10534,10611,10673,10674,10777,10798,10820,10821,10971,11005,11188,11235,11333,11362,11365,11385,11539,11663,11670,11726,11779,11799,11815,11816,11893,11922,11950,11976,12009,12081,12178,12179,12184,12218,12243,12388,12446,12465,12466,12480,12520,12670,12685,12758,12838,12873,12898,12907,12957,12985,13006,13035,13036,13041,13079,13137,13229,13285,13334,13390,13466,13497,13647,13805,13817,13835,13901,13906,13952,13953,13970,14024,14098,14110,14113,14143,14152,14176,14205,14223,14248,14250,14283,14336,14352,14354,14396,14424,14426,14449,14530,14558,14571,14596,14625,14629,14658,14676,14695,14754,14775,14789,14813,14843,14856,14984,15010,15018,15231,15286,15304,15315,15316,15362,15444,15520,15522,15552,15581,15608,15616,15655,15704,15714,15723,15730,15742,15755,15778,15805,15887,15897,15965,16053,16058,16088,16250,16254,16316,16324,16335,16362,16381,16417,16474,16523,16542,16657,16670,16675,16695,16724,16783,16839,16942,16957,16982,17084,17163,17181,17201,17240,17256,17274,17288,17300,17365,17386,17422,17444,17466,17542,17553,17562,17566,17573,17575,17625,17660,17688,17712,17717,17753,17783,17820,17850,17867,17887,17898,17914,17922,17930,17933,17950,17955,17967,17996,18060,18118,18121,18278,18300,18391,18397,18428,18429,18541,18552,18571,18605,18626,18645,18674,18693,18706,18811,18823,18830,18849,18871,18905,18966,18971,19001,19055,19079,19133,19145,19177,19208,19220,19254,19259,19277,19325,19379,19456,19517,19531,19574,19659,19679,19754,19773,19830,19855,19871,19877,19881,19901,19929,19965,19972,19984,19996,20097,20134,20135,20154,20186,20297,20333,20366,20390,20405,20411,20433,20437,20447,20480,20488,20540,20545,20588,20632,20698,20708,20717,20718,20772,20781,20794,20805,20814,20885,20940,20960,20979,21009,21054,21055,21104,21105,21116,21122,21128,21170,21198,21226,21228,21247,21286,21303,21305,21316,21325,21350,21370,21380,21390,21398,21418,21448,21449,21463,21495,21520,21540,21551,21591,21607,21611,21640,21680,21682,21770,21771,21814,21853,21867,21895,21920,21924,21947,21977,21990,22000,22003,22039,22044,22066,22067,22096,22132,22154,22170,22193,22215,22255,22276,22290,22320,22349,22363,22382,22395,22436,22465,22501,22579,22588,22596,22616,22653,22661,22693,22709,22718,22746,22751,22781,22799,22804,22820,22866,22915,22930,22946,23009,23029,23049,23071,23072,23087,23103,23112,23137,23140,23156,23232,23236,23242,23252,23270,23279,23283,23302,23308,23339,23367,23368,23386,23401,23444,23449,23484,23527,23550,23555,23572,23577,23579,23600,23621,23623,23642,23665,23682,23690,23691,23693,23698,23709,23716,23719,23727,23743,23764,23768,23781,23784,23816,23846,23849,23902,23920,23944,23949,24009,24015,24024,24060,24065,24102,24110,24115,24164,24196,24239,24270,24283,24296,24306,24335,24348,24362,24372,24402,24422,24430,24453,24457,24473,24475,24506,24556,24575,24577,24617,24635,24656,24677,24707,24724,24726,24751,24794,24800,24809,24816,24859,24930,24931,25036,25043,25063,25096,25112,25136,25155,25165,25180,25200,25279,25282,25287,25291,25327,25332,25352,25358,25367,25384,25386,25408,25416,25418,25426,25440,25462,25477,25484,25515,25526,25548,25555,25560,25564,25589,25619,25640,25687,25692,25697,25765,25806,25854,25887,25889,25919,25926,25945,25957,25959,26023,26031,26043,26051,26055,26063,26258,26274,26340,26390,26413,26540,26541,26595,26711,26775,26807,26853,26930,27001,27012,27039,27061,27094,27221,27327,27348,27374,27379,27506,27584,27769,27795,27871,27949,27968,27975,28082,28464,28511,28537,28607,28623,28640,28852,28892,28907,28908,28951,28972,28973,29049,29140,29171,29194,29208,29257,29325,29349,29357,29535,29576,29642,29673,29912,29939,29962,30274,30449,32820,35000,35711,35740,35774,35858,36216,36492,38204,38485,38834,38900,38958,38975,38986,39020,39064,39131,39159,39172,39479,40170,40184,40351,40777,40993,41032,41211,41325,43839,45035)
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 | 797 | 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.61 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.92 ms |
preparing | 1.03 ms |
Sorting result | 0.01 ms |
executing | 0.01 ms |
Sending data | 0.47 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.01 ms |
freeing items | 0.08 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 |