Tiempo de la consulta: 4.43 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.192 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 19:16:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 19:16:41')
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,140,142,143,144,145,146,178,179,202,214,271,280,344,350,353,367,374,376,377,378,379,380,450,456,489,512,556,608,611,656,686,723,754,831,843,864,868,884,891,941,964,976,986,1006,1033,1043,1044,1047,1080,1130,1143,1158,1207,1215,1252,1253,1256,1287,1302,1314,1329,1339,1351,1565,1601,1664,1698,1709,1776,1823,2013,2109,2354,2384,2628,2643,2656,2714,2742,2870,2898,2939,3033,3074,3091,3126,3215,3223,3283,3301,3329,3340,3377,3478,3512,3564,3567,3590,3641,3669,3687,3783,3816,3870,3895,3934,3957,3962,4025,4087,4172,4192,4206,4257,4319,4378,4380,4468,4622,4638,4674,4690,4718,4741,4765,4834,4876,5072,5233,5247,5299,5481,5495,5644,5647,5659,5730,5814,5827,5837,5888,6231,6292,6333,6381,6384,6464,6470,6501,6513,6538,6573,6631,6687,6690,6908,6940,6942,6950,6957,6961,6965,6966,6968,6989,7016,7043,7075,7104,7154,7161,7168,7258,7291,7303,7380,7387,7401,7403,7414,7427,7428,7434,7450,7454,7508,7522,7531,7546,7556,7594,7638,7713,7730,7774,7829,7831,7862,7867,7916,7923,7957,7965,7967,7983,7985,7989,7993,7995,7998,8108,8269,8355,8356,8391,8551,8694,8773,8776,8811,8950,9057,9091,9109,9115,9203,9239,9249,9318,9425,9429,9561,9579,9642,9723,9725,9728,9791,9861,9966,9985,10011,10028,10120,10227,10259,10265,10299,10313,10340,10357,10415,10534,10596,10611,10673,10777,10803,10820,10821,10835,10916,10971,10991,11005,11091,11192,11249,11260,11310,11333,11357,11362,11365,11377,11430,11539,11626,11663,11694,11799,11808,11816,11863,11893,11932,11936,11950,11976,12009,12042,12112,12147,12174,12178,12179,12204,12388,12401,12427,12446,12492,12500,12579,12609,12621,12625,12670,12681,12685,12709,12758,12764,12806,12838,12878,12897,12898,12936,12985,12990,13002,13004,13036,13079,13153,13216,13229,13285,13334,13436,13445,13461,13476,13492,13500,13585,13608,13629,13647,13666,13696,13750,13811,13837,13858,13859,13880,13901,13922,14047,14098,14116,14152,14205,14248,14250,14257,14258,14289,14336,14352,14354,14396,14424,14426,14596,14625,14629,14676,14695,14714,14754,14789,14843,14856,14879,14939,14984,14986,14988,15018,15063,15086,15173,15205,15208,15233,15286,15299,15304,15306,15315,15316,15332,15408,15444,15520,15569,15608,15616,15660,15672,15714,15723,15732,15755,15770,15778,15791,15805,15843,15870,15897,15898,15903,15926,15962,15988,16012,16030,16053,16088,16133,16177,16180,16184,16278,16297,16340,16362,16365,16381,16417,16439,16450,16474,16503,16507,16523,16541,16542,16622,16646,16657,16670,16675,16698,16783,16812,16831,16840,16865,16905,16982,17090,17096,17142,17163,17207,17256,17291,17336,17340,17361,17365,17410,17422,17440,17446,17449,17458,17487,17503,17518,17542,17559,17566,17571,17573,17599,17625,17632,17660,17662,17688,17712,17717,17734,17737,17784,17814,17820,17823,17839,17860,17881,17914,17930,17933,17941,17947,17967,18006,18066,18074,18088,18118,18186,18203,18300,18301,18311,18320,18429,18463,18473,18490,18524,18551,18552,18558,18605,18658,18668,18693,18750,18756,18770,18807,18810,18811,18816,18830,18846,18849,18866,18871,18873,18894,18926,18959,18984,18989,19001,19003,19013,19055,19096,19129,19131,19134,19145,19230,19254,19259,19277,19296,19311,19325,19344,19367,19381,19400,19402,19424,19460,19463,19521,19529,19536,19572,19574,19620,19622,19679,19733,19773,19830,19848,19855,19871,19877,19881,19901,19915,19965,19972,19982,19984,19988,19993,19996,20042,20054,20057,20095,20104,20134,20135,20148,20163,20169,20177,20188,20189,20276,20286,20345,20382,20390,20405,20424,20433,20437,20447,20450,20474,20483,20488,20515,20545,20588,20698,20708,20718,20752,20772,20778,20781,20794,20814,20835,20869,20886,20913,20940,20960,20979,20981,21075,21122,21132,21170,21176,21198,21270,21295,21321,21325,21350,21370,21380,21392,21398,21402,21416,21448,21449,21459,21521,21551,21577,21591,21607,21610,21611,21628,21640,21680,21775,21863,21867,21895,21909,21928,21961,21990,22039,22044,22067,22079,22096,22132,22140,22170,22207,22215,22255,22265,22276,22282,22320,22326,22349,22361,22363,22382,22395,22436,22465,22488,22501,22525,22579,22588,22619,22659,22693,22698,22709,22749,22751,22754,22781,22790,22804,22820,22840,22866,22868,22915,22930,22989,23009,23029,23072,23077,23087,23103,23112,23127,23137,23156,23196,23232,23233,23250,23252,23270,23279,23289,23308,23355,23367,23368,23397,23401,23444,23457,23471,23484,23527,23535,23555,23577,23621,23623,23642,23665,23682,23686,23691,23693,23709,23716,23719,23768,23787,23846,23849,23869,23888,23902,23920,23937,23944,23949,23965,23969,23973,24003,24009,24015,24024,24033,24060,24066,24090,24100,24110,24115,24143,24159,24164,24170,24196,24239,24270,24284,24296,24306,24335,24362,24422,24430,24441,24453,24461,24481,24506,24520,24556,24575,24591,24594,24617,24635,24656,24677,24707,24720,24724,24726,24754,24755,24775,24791,24794,24795,24816,24865,24912,24931,24998,25002,25026,25036,25043,25090,25109,25136,25164,25184,25192,25200,25282,25287,25291,25304,25327,25332,25367,25384,25386,25408,25416,25440,25473,25477,25484,25515,25517,25519,25526,25535,25548,25555,25560,25601,25638,25640,25664,25672,25687,25692,25697,25730,25740,25765,25769,25790,25806,25822,25835,25854,25887,25889,25959,25995,26023,26055,26274,26331,26340,26374,26390,26394,26413,26421,26427,26516,26521,26561,26595,26596,26601,26629,26638,26760,26769,26853,26868,26935,26936,27001,27009,27039,27100,27101,27175,27233,27259,27346,27352,27374,27379,27381,27384,27491,27524,27526,27559,27571,27584,27634,27673,27688,27795,28068,28129,28295,28372,28478,28511,28537,28623,28757,28849,28852,29214,29219,29269,29325,29484,29720,29962,30274,32331,32565,32820,35000,35135,35711,35740,35774,35798,35858,36216,36492,36600,36733,38740,38884,38898,38958,38975,39002,39020,39064,39159,39773,40184,40369,40636,41325,43000,44267)
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 | 991 | 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.53 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.62 ms |
preparing | 0.76 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |