Tiempo de la consulta: 11.21 ms Después de la última consulta: 0.79 ms Consulta a la memoria: 1.455 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-06 01:19:52')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 01:19: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(5,7,9,14,29,39,56,60,62,63,65,71,73,86,87,110,149,164,173,174,177,196,221,226,240,252,259,262,291,299,331,349,366,391,425,428,429,472,477,481,495,501,510,525,530,531,546,563,618,619,659,662,663,667,674,697,705,706,746,769,787,800,802,805,808,823,825,832,835,837,860,869,873,910,923,939,940,954,966,969,974,977,982,983,999,1004,1005,1010,1011,1021,1053,1055,1065,1082,1091,1095,1114,1119,1128,1136,1158,1182,1205,1213,1231,1235,1247,1252,1253,1255,1268,1271,1276,1289,1299,1308,1309,1319,1340,1347,1363,1370,1409,1410,1422,1428,1431,1432,1441,1444,1480,1485,1509,1550,1557,1606,1619,1628,1629,1648,1675,1678,1693,1694,1706,1724,1771,1788,1794,1795,1796,1808,1810,1833,1835,1843,1854,1855,1862,1872,1899,1918,1920,1930,1939,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2036,2075,2087,2088,2093,2137,2155,2157,2161,2162,2166,2193,2204,2289,2293,2303,2435,2455,2527,2532,2551,2559,2560,2586,2597,2638,2643,2652,2681,2786,2812,2814,2824,2851,2883,2888,2960,3011,3027,3032,3055,3100,3107,3147,3167,3169,3190,3207,3228,3329,3364,3369,3373,3387,3409,3412,3461,3473,3520,3548,3552,3554,3590,3648,3683,3689,3748,3772,3818,3853,3858,3872,3913,3919,3922,3962,3991,4034,4050,4068,4081,4110,4129,4132,4189,4191,4327,4468,4508,4529,4532,4558,4608,4609,4616,4620,4622,4626,4666,4751,4752,4767,4813,4815,4822,4831,4844,4845,4846,4865,4933,4948,4973,4983,5011,5033,5055,5091,5134,5135,5153,5160,5220,5324,5370,5397,5415,5469,5477,5517,5559,5604,5719,5780,5795,5829,5999,6044,6148,6198,6207,6277,6293,6352,6368,6391,6420,6435,6442,6460,6462,6476,6477,6548,6628,6629,6636,6728,6805,6845,6855,6908,6935,6944,6958,7022,7030,7048,7123,7135,7137,7176,7195,7242,7258,7287,7324,7418,7439,7491,7535,7553,7570,7592,7595,7648,7744,7751,7819,8070,8086,8192,8232,8291,8295,8314,8538,8592,8602,8634,8660,8707,8732,8779,8801,8858,8895,9008,9081,9191,9237,9277,9279,9303,9364,9369,9401,9488,9572,9859,9861,9930,10019,10042,10093,10572,10840,11001,11054,11184,11555,11784,11789,11808,11950,11970,12086,12140,12237,12242,12259,12398,12408,12639,12667,12761,12916,12974,13034,13057,13126,13228,13246,13274,13275,13346,13450,13501,13889,13896,13927,13985,14077,14152,14279,14389,14479,14493,14539,14619,14666,14683,14703,14714,14728,14752,14754,14865,14927,14931,14969,14976,14977,15024,15038,15063,15087,15107,15111,15120,15150,15203,15219,15220,15235,15354,15460,15533,15544,15604,15745,15781,15804,15807,15875,15881,15913,15915,15934,15973,15978,16122,16224,16298,16364,16454,16551,16587,16588,16612,16623,16658,16670,16737,16791,16803,16830,16876,16913,16995,17010,17054,17055,17091,17106,17140,17166,17170,17333,17372,17388,17442,17447,17516,17580,17592,17615,17644,17646,17663,17683,17699,17727,17736,17737,17773,17791,17798,17799,17806,17807,17885,17936,17995,18036,18060,18096,18113,18162,18163,18357,18383,18402,18444,18459,18480,18516,18542,18566,18657,18695,18712,18728,18733,18754,18779,18802,18832,18959,18982,19015,19038,19077,19183,19187,19228,19258,19269,19280,19282,19283,19289,19299,19302,19307,19339,19351,19389,19400,19402,19421,19423,19427,19458,19470,19503,19532,19533,19573,19632,19721,19800,19830,19887,19919,19937,19986,20029,20044,20056,20057,20062,20153,20177,20180,20188,20215,20236,20278,20293,20306,20391,20423,20508,20530,20557,20600,20662,20713,20733,20743,20756,20764,20804,20813,20843,20851,20853,20858,20860,20871,20879,20883,20920,20921,20944,20949,20954,20978,20999,21168,21187,21189,21217,21224,21236,21252,21257,21270,21282,21313,21371,21402,21483,21569,21633,21760,21765,21787,21820,21830,21902,21919,21969,22043,22091,22105,22127,22169,22189,22567,22603,22649,22696,22700,22743,22763,22785,22789,22794,22847,22854,22920,22996,23055,23138,23170,23202,23224,23246,23373,23448,23518,23526,23536,23546,23569,23575,23599,23605,23617,23644,23682,23875,24030,24067,24153,24189,24191,24208,24219,24293,24341,24394,24402,24415,24484,24526,24585,24598,24609,24614,24635,24682,24797,24806,24814,24853,24856,24883,24943,24973,25010,25162,25323,25382,25456,25534,25569,25598,25610,25632,25721,25839,25901,25955,26014,26023,26159,26215,26245,26386,26425,26554,26655,26829,26920,26937,26954,26983,26992,27103,27117,27133,27135,27157,27326,27420,27490,27655,27805,27863,27904,27997,28248,28402,28416,28682,28695,28735,28866,28907,28908,28910,28918,28960,29033,29135,29136,29281,29372,30307,30470,31064,31114,31356,31671,32097,32841,33259,33430,33593,33651,33784,33795,33897,33993,34008,34176,34300,34490,34573,34783,35077,35568,35646,35713,35733,35755,36053,36219,36251,36601,36655,36829,36856,36945,37284,37408,37557,37594,37892,38279,38341,38372,38381,38760,39511,40054,40251,40300,40319,40492,40635,40659,40904,41256,41311,41430,41962,42530,42600,42631,42671,42700,42752,42799,43056,43456,43498,43878,43910,44396,44402,44602,44743,44814,45076,45173)
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 | 875 | 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.48 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.33 ms |
preparing | 0.65 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 7.39 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |