Tiempo de la consulta: 4.50 ms Después de la última consulta: 0.83 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.320 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 21:57:43')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 21:57:43')
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(43,49,83,136,137,140,142,143,144,145,146,178,179,271,281,316,362,368,398,489,522,621,686,723,728,752,784,825,931,963,964,980,986,1044,1047,1060,1080,1130,1143,1158,1207,1252,1253,1256,1302,1318,1339,1344,1364,1365,1371,1428,1440,1461,1541,1556,1601,1649,1664,1665,1673,1690,1782,1823,1827,1922,2000,2110,2115,2207,2332,2357,2483,2500,2540,2572,2583,2720,2728,2729,2735,2765,2870,2896,2922,2939,2957,3033,3040,3117,3126,3177,3223,3257,3301,3332,3397,3478,3567,3574,3669,3687,3705,3759,3771,3838,3863,3881,3934,4015,4017,4019,4091,4116,4276,4281,4298,4343,4345,4366,4369,4371,4373,4378,4385,4428,4463,4690,4693,4745,4765,4797,4856,4896,5052,5053,5125,5233,5285,5294,5346,5379,5385,5633,5647,5659,5710,5729,5814,5827,5840,5933,5963,6047,6051,6094,6176,6203,6211,6267,6283,6284,6371,6422,6438,6445,6453,6470,6501,6538,6559,6567,6573,6619,6647,6802,6812,6825,6832,6900,6951,6965,6966,6968,6989,7002,7016,7043,7075,7161,7175,7219,7225,7291,7380,7387,7401,7403,7414,7427,7508,7546,7584,7639,7656,7670,7678,7730,7766,7823,7831,7849,7867,7951,7957,7970,7983,7989,8108,8141,8169,8183,8189,8204,8205,8207,8223,8233,8236,8245,8246,8247,8315,8320,8355,8356,8380,8401,8410,8426,8427,8464,8471,8521,8537,8551,8565,8569,8571,8602,8626,8630,8729,8757,8805,8816,8838,8839,8845,8876,8877,8888,8912,8918,8921,8931,8950,8952,8982,8983,8986,9058,9074,9091,9131,9136,9158,9164,9202,9203,9239,9294,9401,9429,9442,9487,9562,9564,9752,9791,9810,9818,9842,9993,10002,10017,10028,10120,10128,10144,10187,10207,10215,10315,10317,10340,10375,10376,10392,10415,10491,10561,10596,10617,10673,10685,10777,10803,10835,10860,10896,10916,10938,10939,10948,10953,10970,10975,10991,11037,11039,11060,11072,11074,11075,11091,11093,11120,11165,11186,11192,11249,11252,11255,11260,11285,11292,11310,11343,11344,11357,11361,11371,11377,11430,11458,11491,11611,11626,11629,11648,11661,11729,11737,11738,11739,11755,11789,11800,11808,11816,11830,11856,11863,11938,11967,12002,12042,12081,12082,12094,12112,12118,12147,12174,12204,12219,12283,12326,12339,12343,12356,12364,12384,12401,12405,12427,12492,12511,12513,12520,12526,12579,12588,12609,12625,12681,12709,12752,12806,12811,12990,13002,13004,13036,13056,13110,13125,13150,13152,13153,13207,13216,13217,13377,13445,13461,13476,13483,13492,13500,13521,13552,13554,13585,13613,13666,13685,13696,13837,13880,13900,13922,14002,14038,14039,14116,14147,14212,14257,14258,14280,14287,14289,14330,14382,14386,14394,14426,14457,14468,14484,14540,14610,14612,14642,14643,14676,14791,14798,14817,14847,14864,14873,14913,14915,14939,14960,14986,14988,15003,15086,15117,15119,15165,15173,15177,15205,15286,15332,15400,15408,15431,15501,15569,15596,15608,15609,15649,15672,15732,15742,15755,15778,15791,15801,15888,15898,15966,15994,16023,16028,16030,16036,16039,16061,16066,16133,16180,16184,16278,16283,16362,16365,16381,16417,16423,16439,16446,16447,16450,16523,16542,16622,16637,16644,16657,16675,16698,16806,16814,16815,16818,16831,16844,16865,16866,16898,16935,16985,17011,17047,17090,17096,17108,17142,17143,17144,17183,17190,17194,17247,17281,17291,17292,17336,17342,17376,17417,17449,17452,17456,17487,17514,17518,17536,17559,17574,17588,17599,17630,17632,17688,17712,17725,17734,17784,17814,17838,17845,17887,17896,17933,17941,17989,17990,18006,18074,18088,18124,18136,18139,18186,18270,18301,18320,18351,18447,18463,18512,18524,18552,18658,18668,18693,18708,18716,18750,18770,18810,18811,18830,18846,18849,18873,18881,18882,18894,18909,18957,18959,18984,18989,19003,19017,19031,19114,19129,19131,19134,19145,19206,19221,19230,19259,19296,19311,19330,19339,19344,19367,19381,19413,19424,19460,19515,19520,19521,19536,19572,19622,19644,19733,19848,19881,19883,19915,19982,19984,19993,20041,20042,20056,20067,20095,20104,20111,20148,20156,20158,20163,20170,20189,20239,20276,20286,20345,20362,20382,20420,20450,20457,20474,20483,20515,20644,20654,20666,20708,20752,20778,20854,20869,20888,20913,20940,20960,20981,21075,21115,21218,21247,21255,21307,21321,21350,21376,21390,21392,21398,21449,21521,21577,21611,21628,21689,21707,21716,21720,21775,21863,21895,21928,21956,21961,21964,22028,22039,22071,22075,22079,22100,22132,22138,22207,22252,22281,22316,22326,22344,22349,22363,22382,22395,22436,22445,22488,22525,22619,22623,22654,22659,22669,22689,22693,22698,22709,22754,22804,22840,22917,22930,22936,22989,23057,23077,23087,23279,23289,23332,23367,23368,23377,23397,23414,23431,23444,23527,23532,23535,23555,23627,23657,23665,23693,23709,23716,23726,23728,23741,23787,23801,23869,23873,23882,23884,23920,23937,23965,23969,23973,24003,24033,24066,24090,24100,24115,24143,24164,24170,24182,24184,24270,24284,24441,24461,24469,24481,24489,24520,24556,24619,24620,24720,24754,24755,24775,24795,24816,24865,24912,24994,24998,25002,25026,25090,25109,25164,25192,25268,25408,25441,25477,25484,25517,25519,25535,25601,25638,25664,25672,25740,26038,26048,26104,26145,26298,26421,26521,26561,26595,26596,26659,26771,26817,26915,26963,27039,27184,27233,27346,27384,27412,27634,27701,27898,28068,28295,28372,28447,28463,28478,29214,29219,29269,29484,29504,29557,31908,32331,32565,35135,35366,35588,35834,35857,35886,35891,35922,35972,36364,36707,37576,37851,38855,38884,38898,39112,39773,40369,40483,40636,40789,40835,41025,42284,42494,42833,43360,43543,45141,45240,45252)
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 | 933 | 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.50 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.57 ms |
preparing | 0.79 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.04 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 |