Tiempo de la consulta: 5.43 ms Después de la última consulta: 0.71 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.317 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 22:04:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 22:04:28')
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(20,49,75,85,133,136,140,142,143,144,145,146,178,179,271,323,390,479,489,622,625,665,686,690,723,808,826,874,906,964,986,1036,1044,1047,1069,1080,1101,1130,1143,1158,1193,1207,1216,1235,1252,1253,1256,1302,1339,1344,1414,1459,1492,1591,1645,1664,1808,1978,2383,2569,2958,2961,2967,3099,3114,3126,3223,3295,3301,3409,3456,3476,3488,3669,3687,3757,3832,3915,3984,4005,4301,4353,4378,4383,4410,4732,4765,4785,4831,5078,5424,5453,5584,5632,5647,5659,5680,5700,5814,6058,6331,6470,6538,6573,6577,6595,6600,6607,6635,6965,6966,6968,6989,7002,7012,7016,7043,7075,7161,7291,7348,7380,7387,7401,7403,7414,7427,7508,7546,7730,7747,7755,7831,7867,7957,7983,7989,8108,8327,8356,8530,8551,8692,8819,8943,8950,8964,9091,9115,9203,9239,9272,9429,9756,9779,9791,10006,10028,10120,10198,10353,10355,10415,10464,10777,10803,10835,10856,10916,10986,11064,11091,11138,11192,11193,11207,11249,11260,11310,11330,11377,11430,11447,11494,11533,11557,11808,11816,11841,11863,11937,11965,12030,12042,12112,12147,12174,12189,12204,12207,12244,12401,12427,12430,12442,12477,12492,12535,12579,12609,12625,12628,12681,12704,12709,12802,12806,12942,12956,12990,13004,13036,13086,13112,13188,13216,13269,13445,13448,13461,13476,13492,13500,13588,13637,13666,13672,13678,13696,13707,13798,13837,13880,13922,14105,14116,14257,14258,14264,14289,14327,14348,14356,14386,14393,14426,14427,14430,14535,14602,14676,14778,14790,14890,14939,14970,14986,14988,15074,15086,15152,15153,15170,15173,15205,15223,15286,15332,15408,15546,15569,15572,15672,15732,15760,15834,15898,15904,15919,15991,16014,16030,16108,16133,16180,16269,16278,16292,16313,16361,16362,16381,16387,16390,16417,16444,16459,16488,16523,16542,16546,16596,16604,16622,16631,16642,16657,16675,16676,16698,16700,16750,16850,16857,16865,16892,16909,16964,17039,17085,17087,17096,17135,17142,17148,17178,17189,17192,17202,17295,17336,17338,17393,17410,17449,17463,17559,17590,17599,17617,17630,17632,17688,17712,17722,17734,17784,17788,17811,17814,17870,17883,17928,17933,17941,18006,18042,18074,18078,18140,18150,18166,18292,18301,18320,18381,18407,18452,18456,18457,18463,18466,18485,18524,18534,18535,18552,18622,18658,18666,18668,18669,18677,18693,18703,18750,18767,18781,18810,18811,18815,18830,18846,18849,18873,18879,18894,18959,18984,18996,19003,19031,19129,19134,19145,19230,19249,19296,19308,19311,19344,19364,19381,19392,19424,19460,19482,19514,19518,19521,19536,19541,19554,19572,19622,19649,19720,19729,19733,19776,19779,19823,19848,19915,19982,19984,19993,19999,20002,20042,20046,20055,20063,20082,20104,20148,20159,20163,20189,20201,20230,20276,20286,20311,20323,20345,20368,20382,20394,20402,20408,20422,20438,20452,20456,20473,20474,20475,20491,20503,20515,20533,20584,20652,20677,20689,20708,20752,20766,20774,20778,20869,20911,20913,20915,20940,20946,20960,21044,21060,21075,21124,21162,21227,21247,21304,21309,21321,21335,21336,21341,21350,21392,21398,21415,21480,21482,21521,21549,21567,21577,21611,21619,21622,21704,21708,21714,21775,21801,21815,21830,21834,21840,21862,21863,21895,21922,21928,21941,21961,21962,21975,22019,22039,22048,22057,22072,22079,22154,22194,22200,22207,22326,22345,22349,22350,22363,22373,22382,22395,22422,22436,22488,22550,22607,22659,22693,22698,22709,22754,22802,22804,22840,22889,22989,22992,23014,23019,23035,23077,23087,23104,23109,23145,23151,23178,23279,23289,23332,23343,23367,23368,23397,23444,23474,23481,23513,23527,23531,23535,23555,23648,23665,23676,23693,23709,23716,23749,23787,23828,23833,23869,23920,23935,23937,23948,23965,23969,23995,23998,24003,24033,24066,24090,24095,24115,24164,24170,24172,24224,24228,24270,24271,24284,24309,24427,24441,24443,24461,24477,24481,24520,24535,24625,24630,24636,24720,24754,24755,24763,24775,24795,24816,24840,24851,24865,24922,24923,24942,24995,25002,25018,25026,25090,25109,25164,25192,25286,25400,25408,25477,25484,25511,25517,25519,25535,25601,25638,25664,25672,25707,25736,25740,25829,25838,25848,25860,25885,26002,26091,26130,26237,26264,26396,26403,26421,26458,26521,26550,26561,26591,26596,26637,26792,26879,26907,27039,27053,27105,27106,27142,27144,27164,27178,27179,27201,27203,27233,27265,27343,27346,27384,27409,27634,28068,28295,28372,28478,29214,29219,29269,29484,29511,29626,29938,30393,30394,30471,30511,32009,32331,32565,33403,34052,34415,34449,34525,34560,34978,35324,35436,35503,35609,35626,35953,36192,36204,36222,36238,36329,36342,36515,36736,36783,36850,36864,36871,36892,37106,37146,37373,37575,37810,37811,37812,37815,37934,38005,38008,38077,38263,38387,38884,38898,38901,39065,39114,39265,39271,39464,39506,39729,39741,39846,39877,39886,39941,40111,40114,40187,40212,40225,40239,40369,40392,40501,40636,40665,40672,40983,41059,41146,41748,41850,42528,43905,43909,44240,44255,44433)
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 | 820 | 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.59 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.99 ms |
preparing | 1.06 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.43 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.13 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 |