Tiempo de la consulta: 5.11 ms Después de la última consulta: 0.99 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.277 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-08 23:09:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 23:09: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(5,7,9,14,29,39,46,56,57,60,62,63,65,71,73,86,87,90,92,99,149,164,174,177,189,196,215,221,224,226,232,240,243,244,245,246,249,259,262,276,291,299,309,328,330,331,337,349,366,391,412,417,418,427,428,429,433,468,472,477,481,501,510,521,525,528,530,531,546,548,553,555,563,595,596,597,603,619,641,646,647,659,662,663,667,674,697,705,706,711,730,746,769,781,800,802,805,808,818,823,832,835,863,869,873,910,923,939,940,954,969,974,977,982,983,994,999,1004,1005,1011,1021,1023,1055,1066,1072,1091,1095,1114,1119,1145,1158,1170,1182,1205,1231,1247,1252,1253,1255,1264,1268,1271,1272,1274,1275,1276,1277,1278,1289,1308,1309,1314,1319,1322,1325,1347,1363,1389,1390,1409,1410,1412,1428,1432,1441,1444,1462,1485,1504,1509,1557,1606,1619,1629,1648,1675,1693,1694,1724,1741,1771,1794,1795,1796,1808,1810,1816,1828,1843,1854,1855,1862,1899,1918,1920,1930,1948,1960,1961,1975,1984,1994,1995,2001,2008,2012,2013,2015,2035,2075,2088,2125,2137,2155,2157,2161,2185,2293,2355,2360,2455,2527,2532,2551,2575,2586,2597,2638,2643,2720,2764,2765,2788,2811,2814,2824,2851,2852,2883,2888,2898,2925,2960,3017,3027,3055,3100,3107,3129,3147,3169,3181,3197,3207,3250,3258,3269,3305,3364,3368,3369,3387,3409,3412,3446,3468,3473,3512,3520,3523,3536,3548,3552,3554,3557,3590,3609,3613,3618,3648,3657,3683,3689,3727,3748,3774,3824,3853,3858,3868,3872,3905,3913,3919,3922,3948,3952,3962,3991,4034,4050,4068,4069,4088,4099,4103,4110,4129,4224,4258,4327,4334,4360,4444,4451,4457,4468,4529,4532,4558,4577,4616,4620,4622,4626,4666,4715,4745,4751,4752,4767,4813,4815,4822,4831,4844,4846,4865,4933,4973,4988,4992,5055,5113,5134,5153,5160,5162,5191,5214,5220,5227,5357,5370,5392,5406,5415,5417,5469,5495,5559,5578,5581,5582,5637,5646,5678,5702,5732,5759,5768,5777,5779,5780,5793,5794,5795,5804,5831,5889,5899,5910,5919,5923,5942,5972,5999,6000,6002,6016,6022,6060,6075,6148,6160,6194,6198,6220,6229,6258,6261,6312,6377,6391,6401,6420,6435,6442,6449,6476,6477,6548,6554,6564,6587,6623,6646,6677,6697,6709,6733,6766,6774,6845,6855,6944,6958,7022,7030,7034,7048,7137,7147,7195,7242,7258,7324,7391,7418,7456,7473,7491,7535,7567,7569,7576,7592,7595,7606,7648,7687,7697,7738,7751,7760,7788,7819,7853,7875,7953,8009,8040,8064,8070,8074,8078,8081,8086,8087,8152,8167,8178,8192,8215,8218,8273,8291,8295,8314,8374,8384,8461,8465,8487,8495,8538,8552,8588,8589,8592,8601,8602,8624,8626,8634,8637,8650,8672,8707,8743,8779,8801,8815,8861,8872,8969,9019,9121,9174,9175,9182,9186,9237,9258,9262,9277,9279,9293,9362,9369,9380,9390,9394,9401,9424,9488,9500,9557,9572,9663,9697,9701,9711,9725,9760,9781,9882,9930,9958,10135,10168,10258,10312,10330,10335,10356,10466,10468,10489,10572,10704,10730,10778,10816,10840,10914,11001,11044,11086,11131,11147,11184,11187,11555,11788,11790,11805,12130,12234,12242,12257,12347,12383,12398,12408,12542,12602,12639,12667,12788,12824,12974,13013,13034,13037,13062,13126,13130,13246,13285,13378,13431,13459,13489,13556,13685,13703,13705,13706,13711,13719,13745,13896,14015,14026,14166,14177,14196,14219,14261,14310,14320,14341,14359,14469,14580,14651,14666,14703,14714,14752,14865,14914,14922,14951,14957,14969,14976,14978,14982,15038,15044,15063,15087,15096,15203,15235,15293,15324,15368,15460,15490,15533,15544,15604,15660,15667,15716,15744,15781,15794,15804,15807,15834,15875,15913,15915,15950,15973,16046,16122,16155,16224,16262,16285,16336,16363,16454,16584,16587,16588,16594,16612,16648,16737,16791,16830,16913,16933,16934,16995,17014,17054,17055,17078,17140,17166,17170,17172,17176,17239,17242,17246,17333,17359,17361,17368,17372,17380,17388,17437,17438,17442,17448,17539,17586,17592,17629,17630,17644,17646,17680,17683,17697,17699,17737,17791,17798,17799,17806,17807,17823,17849,17905,17936,17976,17977,18035,18036,18184,18192,18245,18253,18260,18308,18327,18357,18376,18383,18405,18413,18418,18444,18446,18480,18491,18497,18500,18524,18532,18542,18545,18575,18601,18603,18635,18657,18695,18733,18751,18754,18779,18802,18815,18828,18832,18844,18851,18868,18874,18885,18918,18956,19005,19015,19038,19144,19168,19183,19187,19228,19238,19258,19267,19269,19280,19282,19283,19289,19299,19301,19302,19306,19307,19310,19327,19339,19389,19397,19400,19402,19421,19423,19427,19458,19465,19470,19499,19503,19525,19532,19533,19553,19568,19573,19587,19610,19618,19625,19697,19721,19729,19764,19769,19800,19815,19824,19830,19845,19858,19937,19939,20017,20029,20033,20044,20056,20057,20062,20086,20128,20150,20151,20153,20176,20177,20188,20190,20211,20212,20213,20215,20236,20264,20277,20278,20293,20306,20307,20387,20391,20392,20410,20465,20508,20530,20600,20628,20662,20709,20713,20733,20743,20754,20760,20764,20778,20804,20813,20843,20851,20853,20858,20860,20871,20879,20883,20918,20920,20921,20944,20949,20954,20999,21029,21086,21096,21158,21168,21217,21236,21237,21273,21282,21313,21402,21466,21483,21569,21593,21688,21733,21754,21756,21760,21787,21820,21837,21911,21943,21969,21993,22033,22037,22094,22100,22105,22180,22219,22272,22281,22522,22564,22567,22603,22689,22743,22768,22801,22813,22847,22854,22881,22955,22991,22997,23017,23076,23085,23109,23138,23168,23170,23202,23211,23224,23238,23246,23282,23356,23402,23511,23526,23533,23536,23567,23569,23599,23617,23682,23722,23797,23799,23847,23875,23901,23945,24067,24127,24153,24156,24189,24208,24219,24245,24410,24415,24484,24502,24526,24563,24585,24598,24609,24614,24682,24697,24797,24853,24865,24878,24967,24973,25030,25147,25323,25445,25453,25456,25534,25535,25569,25598,25610,25632,25721,25813,25901,26014,26039,26215,26245,26386,26447,26473,26478,26554,26588,26769,26829,26871,26875,26920,26954,26999,27103,27133,27135,27157,27162,27175,27180,27184,27188,27197,27200,27215,27342,27345,27351,27399,27409,27412,27432,27445,27455,27461,27463,27479,27483,27490,27515,27529,27581,27619,27685,27765,27805,27854,27863,27886,27904,27913,27929,27965,27997,28002,28248,28305,28383,28402,28409,28416,28625,28910,28918,28919,28960,29013,29033,29136,29242,29281,29328,29354,30307,30696,31114,31356,31671,32097,32339,32841,33259,33430,33593,33651,33784,33993,34008,34176,34273,34300,34490,34573,34717,34783,35368,35568,35676,35755,35798,35834,35861,35886,35922,35941,36219,36737,37158,37408,38489,39321,39577,39752,39917,40199,40584,40902,41256,41311,41430,41494,42204,42344,42530,42752,42799,43641,43921,44396,44402,44602,44743,45076)
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 | 1155 | 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.57 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.29 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 2.15 ms |
preparing | 0.93 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.02 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 |