Tiempo de la consulta: 3.49 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.412 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 00:21:01')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 00:21:01')
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(46,56,57,86,87,89,90,92,99,149,165,174,189,215,221,224,232,243,244,245,246,249,276,307,309,328,330,337,412,417,418,427,428,433,468,520,521,528,548,553,555,588,595,596,597,603,626,641,646,647,662,697,698,706,711,730,781,784,800,818,820,823,863,980,994,1023,1066,1072,1114,1145,1212,1264,1268,1271,1272,1274,1275,1276,1277,1278,1314,1325,1389,1390,1412,1439,1462,1502,1503,1504,1507,1528,1638,1715,1724,1765,1828,1896,1945,1960,1961,1968,2007,2012,2034,2061,2095,2133,2185,2334,2355,2381,2455,2638,2643,2687,2764,2796,2811,2818,2843,2851,2852,2870,2871,2894,2972,3017,3055,3066,3103,3108,3181,3269,3377,3440,3512,3523,3557,3564,3613,3727,3794,3868,3962,3991,4105,4214,4334,4360,4457,4468,4622,4741,4766,4988,5062,5072,5113,5153,5191,5242,5283,5298,5357,5375,5392,5417,5420,5469,5495,5582,5637,5639,5646,5678,5684,5702,5732,5759,5768,5769,5777,5779,5780,5793,5794,5795,5804,5831,5889,5894,5899,5910,5919,5923,5942,5999,6000,6002,6016,6022,6032,6060,6066,6160,6183,6194,6220,6258,6261,6308,6312,6377,6391,6401,6415,6420,6449,6450,6476,6477,6554,6564,6587,6623,6677,6678,6733,6766,6774,6943,7030,7048,7067,7195,7258,7391,7395,7473,7497,7576,7580,7606,7687,7697,7738,7751,7760,7788,7853,7875,7945,8009,8064,8074,8078,8081,8147,8178,8192,8215,8218,8273,8294,8357,8374,8461,8465,8487,8495,8522,8565,8569,8588,8589,8592,8637,8650,8672,8781,8815,8861,8867,8895,8969,8997,9121,9174,9175,9182,9186,9237,9277,9362,9380,9394,9408,9410,9424,9549,9572,9601,9663,9697,9701,9711,9781,9848,10246,10258,10572,10749,10764,10779,10792,11016,11044,11089,11131,11212,11301,11317,11398,11431,11443,11462,11465,11541,11549,11551,11590,11609,11684,11694,11699,11701,11705,11750,11751,11788,11793,11794,11807,11828,11977,11984,12006,12020,12043,12052,12130,12162,12201,12266,12324,12334,12375,12383,12442,12498,12505,12506,12550,12630,12648,12776,12788,12818,12819,12839,12867,12873,12955,12974,13013,13037,13062,13130,13168,13202,13209,13285,13313,13358,13386,13429,13454,13459,13489,13530,13556,13581,13727,13850,13851,13894,13925,13941,13947,13970,14015,14047,14082,14126,14129,14146,14155,14177,14208,14211,14341,14403,14427,14651,14658,14678,14835,14914,14951,14957,14969,14975,14978,15087,15171,15227,15314,15487,15490,15567,15597,15604,15667,15689,15865,15868,15913,15969,15973,16026,16033,16042,16046,16080,16121,16122,16136,16220,16336,16416,16522,16544,16549,16587,16588,16607,16648,16737,16855,16995,17014,17170,17172,17242,17359,17380,17413,17421,17443,17446,17470,17500,17523,17527,17592,17606,17629,17680,17710,17751,17799,17976,17977,18035,18036,18145,18165,18191,18253,18308,18383,18413,18418,18491,18497,18500,18524,18531,18545,18551,18575,18603,18620,18634,18635,18718,18720,18751,18768,18779,18802,18828,18868,18874,18918,18933,18939,18970,19005,19038,19114,19131,19168,19187,19258,19267,19299,19302,19307,19310,19508,19568,19587,19625,19697,19824,19925,19939,20017,20028,20033,20041,20051,20056,20057,20062,20086,20090,20113,20141,20142,20150,20152,20158,20176,20177,20187,20188,20193,20211,20212,20213,20256,20264,20271,20274,20277,20298,20307,20327,20410,20470,20501,20535,20554,20567,20629,20662,20709,20713,20764,20806,20852,20853,20922,20928,21006,21021,21036,21214,21237,21273,21279,21308,21375,21402,21408,21411,21445,21466,21564,21593,21660,21733,21790,21817,21820,21950,21956,21972,22049,22178,22209,22344,22453,22560,22564,22669,22692,22772,22842,22852,22955,23016,23017,23085,23182,23246,23275,23435,23498,23499,23506,23511,23533,23569,23615,23663,23741,23745,23768,23808,23847,23901,23932,23940,23945,24127,24156,24238,24245,24330,24410,24478,24502,24563,24597,24708,24725,24793,24805,24855,24865,24878,24911,24967,24973,25030,25147,25164,25346,25453,25491,25535,25592,25627,25674,25984,26044,26142,26362,26473,26486,26554,26578,26588,26595,26875,26920,26954,26957,26962,26997,26999,27135,27240,27300,27345,27376,27409,27432,27437,27461,27483,27630,27803,27805,27871,27878,27901,27904,28049,28248,28416,28440,28540,28777,28821,28884,29214,29219,29269,29328,29354,29388,29492,29650,29837,30696,30965,31050,31533,31716,32339,33164,33618,35039,35047,35229,35368,35588,36542,36603,36698,37332,37535,37536,37537,37569,37570,37571,37572,37758,37769,37770,37771,37772,37821,37871,38175,38489,39331,39455,39535,39917,40199,41360,41385,41494,41722,42769,42978,43005,43031,43064,43328,43394,43395,43413,43438,43545,43585,43586,43631,43848,43945,44029,44149,45256)
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 | 790 | 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.39 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.30 ms |
preparing | 0.58 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |