Tiempo de la consulta: 4.49 ms Después de la última consulta: 0.89 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.534 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-05 06:42:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 06:42:52')
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(11,49,60,61,62,63,64,65,67,68,96,117,136,140,142,143,144,145,146,178,179,202,271,272,278,280,281,331,344,350,353,374,376,377,378,379,380,385,417,456,489,586,608,611,686,697,717,723,831,844,857,868,891,941,964,976,978,986,1024,1033,1043,1044,1047,1080,1130,1143,1158,1168,1178,1187,1207,1208,1215,1252,1253,1256,1287,1302,1305,1319,1329,1339,1506,1601,1664,1698,1709,1851,2005,2112,2394,2656,2714,2742,2962,3091,3126,3165,3215,3223,3301,3329,3340,3669,3687,3696,3783,3816,3870,3895,3957,3982,4028,4087,4206,4319,4378,4563,4587,4638,4765,4769,5539,5622,5647,5659,5730,5814,5956,6292,6333,6381,6384,6464,6470,6538,6555,6570,6573,6631,6687,6748,6847,6908,6930,6940,6942,6957,6961,6965,6966,6968,6989,7016,7043,7075,7125,7154,7161,7291,7296,7303,7380,7387,7401,7403,7414,7427,7432,7434,7450,7454,7508,7522,7546,7556,7638,7699,7713,7730,7774,7801,7829,7831,7838,7839,7860,7862,7867,7916,7923,7931,7946,7957,7965,7967,7981,7983,7985,7989,8108,8356,8531,8551,8555,8694,8950,9057,9091,9141,9203,9239,9249,9318,9429,9498,9532,9556,9581,9723,9725,9791,9794,9861,9892,9895,9944,9945,9952,9966,9979,9985,10011,10028,10120,10227,10243,10259,10265,10280,10313,10357,10383,10415,10534,10561,10583,10611,10777,10803,10820,10821,10834,10835,10891,10916,10971,11005,11091,11099,11129,11192,11249,11260,11299,11310,11333,11362,11365,11377,11390,11430,11482,11539,11565,11663,11688,11711,11799,11808,11816,11822,11863,11893,11950,11976,12009,12042,12054,12112,12147,12150,12174,12178,12179,12204,12238,12337,12388,12401,12424,12427,12446,12492,12579,12609,12625,12668,12670,12681,12685,12709,12758,12780,12806,12838,12898,12944,12985,12990,13004,13019,13036,13079,13111,13152,13153,13216,13229,13285,13334,13445,13461,13476,13492,13500,13647,13657,13666,13696,13748,13750,13783,13816,13837,13880,13901,13922,13924,13934,14098,14103,14116,14152,14153,14205,14248,14250,14257,14258,14289,14336,14352,14354,14396,14424,14426,14570,14596,14612,14625,14629,14676,14692,14695,14754,14762,14789,14843,14856,14895,14939,14958,14984,14986,14988,15018,15037,15038,15086,15114,15145,15173,15183,15205,15244,15286,15304,15315,15316,15332,15359,15368,15408,15444,15493,15520,15522,15569,15577,15608,15616,15632,15645,15669,15672,15714,15723,15732,15755,15778,15805,15843,15897,15898,15957,15975,16030,16053,16083,16088,16133,16180,16201,16278,16322,16334,16362,16381,16417,16446,16464,16474,16520,16523,16542,16556,16622,16629,16657,16670,16675,16684,16698,16783,16791,16830,16861,16865,16982,17096,17142,17163,17210,17253,17256,17336,17362,17365,17410,17422,17443,17449,17471,17521,17542,17559,17566,17573,17599,17625,17630,17632,17655,17660,17688,17712,17713,17717,17734,17761,17784,17814,17820,17899,17914,17930,17941,17947,17967,17994,18006,18074,18118,18144,18162,18229,18260,18285,18300,18301,18311,18320,18364,18429,18463,18467,18520,18524,18552,18567,18605,18658,18668,18671,18693,18720,18750,18762,18810,18811,18828,18830,18846,18849,18871,18873,18894,18959,18984,19001,19002,19003,19047,19055,19060,19067,19129,19134,19145,19148,19170,19180,19185,19230,19253,19254,19259,19276,19277,19296,19311,19325,19327,19344,19352,19376,19381,19424,19457,19460,19463,19521,19532,19536,19551,19572,19574,19577,19620,19622,19633,19668,19679,19687,19732,19733,19773,19811,19830,19848,19855,19870,19871,19877,19881,19901,19908,19909,19915,19965,19972,19982,19984,19993,19996,19998,20010,20028,20032,20042,20056,20086,20104,20141,20148,20156,20163,20170,20187,20189,20234,20256,20263,20271,20276,20286,20289,20345,20353,20382,20390,20405,20433,20437,20447,20449,20450,20474,20488,20515,20516,20535,20545,20564,20588,20630,20698,20708,20714,20718,20729,20752,20772,20778,20781,20794,20814,20866,20869,20913,20940,20960,20979,20981,20982,21050,21075,21122,21170,21173,21189,21198,21225,21247,21254,21314,21321,21325,21350,21370,21380,21392,21398,21422,21432,21448,21449,21513,21521,21545,21551,21577,21591,21607,21611,21620,21636,21640,21678,21680,21694,21738,21764,21768,21775,21854,21863,21867,21895,21928,21950,21961,21980,21990,22039,22044,22067,22079,22096,22100,22132,22137,22146,22170,22207,22215,22229,22255,22276,22297,22320,22325,22326,22337,22349,22361,22363,22382,22395,22436,22465,22488,22501,22559,22579,22588,22647,22659,22673,22693,22698,22709,22712,22751,22754,22774,22781,22804,22820,22840,22866,22903,22908,22915,22930,22980,22988,22989,23009,23029,23072,23077,23087,23103,23112,23137,23156,23186,23232,23252,23270,23275,23279,23281,23289,23295,23308,23367,23368,23374,23397,23401,23402,23444,23484,23495,23527,23535,23555,23577,23585,23593,23610,23621,23623,23636,23642,23665,23669,23682,23691,23693,23709,23716,23719,23732,23764,23768,23787,23840,23845,23846,23849,23858,23869,23902,23920,23937,23944,23949,23965,23969,24003,24009,24015,24024,24028,24033,24059,24060,24066,24090,24110,24115,24159,24164,24170,24194,24196,24239,24270,24284,24296,24306,24335,24342,24356,24362,24405,24422,24430,24441,24451,24453,24461,24481,24489,24506,24520,24540,24556,24575,24586,24617,24635,24639,24653,24656,24677,24707,24720,24724,24726,24754,24755,24775,24791,24794,24795,24804,24816,24865,24884,24897,24931,25002,25026,25036,25043,25045,25090,25109,25136,25164,25184,25192,25200,25264,25282,25287,25291,25315,25327,25332,25367,25384,25386,25408,25416,25417,25440,25477,25484,25515,25517,25519,25526,25535,25548,25555,25560,25601,25638,25640,25664,25672,25687,25692,25693,25697,25702,25740,25765,25775,25806,25854,25872,25887,25889,25906,25959,26023,26055,26274,26315,26340,26390,26413,26421,26521,26561,26595,26596,26640,26708,26807,26853,26990,27001,27039,27086,27141,27143,27233,27346,27374,27379,27384,27560,27584,27634,27795,28068,28295,28336,28372,28454,28478,28495,28511,28537,28623,28852,28882,29214,29219,29269,29325,29412,29419,29454,29484,29802,29962,30274,30740,31129,31604,32331,32565,32820,32905,34620,34763,35000,35603,35711,35740,35774,35858,36200,36216,36492,36594,36611,37062,37091,38884,38898,38958,38975,39020,39064,39159,39347,39722,40184,40369,40636,41325,41724,42431,42689,43244,43387)
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 | 1046 | 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.52 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.22 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.62 ms |
preparing | 0.79 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 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 |