Tiempo de la consulta: 4.09 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.329 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-03 20:55:59')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 20:55:59')
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,78,85,86,87,120,121,149,155,163,164,174,177,196,214,221,226,240,259,262,279,285,291,299,303,331,349,366,391,428,429,450,453,472,477,481,495,501,510,525,530,531,546,563,572,619,659,662,663,666,667,674,697,705,746,769,800,802,805,808,823,832,835,839,863,869,870,873,885,910,923,939,940,954,969,974,977,982,983,999,1004,1005,1011,1021,1055,1091,1095,1101,1102,1114,1119,1123,1158,1182,1205,1216,1231,1247,1252,1253,1255,1268,1271,1276,1278,1279,1289,1308,1309,1319,1347,1363,1409,1410,1428,1432,1441,1444,1485,1509,1538,1557,1606,1619,1629,1648,1675,1693,1694,1724,1771,1794,1795,1796,1808,1810,1843,1846,1854,1855,1862,1867,1899,1918,1920,1930,1960,1961,1967,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2088,2137,2155,2157,2161,2293,2328,2402,2455,2463,2527,2532,2551,2586,2597,2638,2643,2647,2814,2824,2851,2883,2888,2954,2960,3027,3036,3055,3100,3106,3107,3147,3169,3174,3182,3207,3364,3368,3369,3387,3402,3409,3454,3461,3473,3474,3520,3548,3552,3554,3577,3590,3648,3663,3683,3689,3748,3853,3858,3872,3913,3919,3922,3962,3991,4034,4050,4068,4110,4129,4327,4468,4503,4529,4532,4558,4589,4616,4620,4622,4626,4666,4751,4752,4767,4813,4815,4822,4823,4831,4844,4846,4863,4865,4933,4973,5055,5134,5153,5160,5220,5351,5370,5396,5415,5461,5469,5478,5536,5559,5613,5780,5795,5857,5913,5999,6120,6148,6178,6198,6391,6420,6435,6442,6465,6476,6477,6548,6639,6806,6845,6855,6876,6944,6958,7022,7030,7048,7122,7137,7195,7242,7246,7258,7324,7418,7478,7491,7494,7535,7592,7595,7648,7720,7736,7751,7818,7819,7841,7847,7897,7924,7981,8046,8070,8086,8090,8116,8118,8128,8192,8291,8295,8314,8538,8592,8602,8634,8707,8779,8801,8864,8895,9029,9087,9237,9277,9279,9364,9369,9401,9488,9572,9836,9930,10475,10478,10536,10572,10630,10801,10840,11001,11059,11184,11348,11464,11472,11555,12242,12398,12401,12408,12410,12550,12620,12625,12637,12639,12667,12708,12810,12875,12901,12974,13017,13034,13126,13246,13294,13298,13528,13650,13671,13687,13697,13707,13804,13842,13896,13963,13975,13990,14092,14105,14142,14271,14273,14450,14456,14507,14646,14666,14703,14714,14752,14865,14969,14976,14987,15004,15030,15032,15037,15038,15048,15063,15087,15094,15151,15203,15235,15247,15266,15370,15382,15403,15424,15439,15460,15471,15492,15533,15542,15544,15560,15562,15574,15575,15604,15717,15725,15728,15781,15804,15807,15875,15913,15915,15973,16093,16122,16140,16153,16161,16163,16206,16224,16257,16326,16454,16497,16534,16543,16587,16588,16612,16623,16652,16657,16737,16791,16830,16913,16929,16936,16981,16995,17000,17054,17055,17128,17140,17166,17215,17257,17307,17333,17347,17358,17372,17381,17382,17388,17432,17442,17592,17596,17644,17646,17659,17683,17699,17702,17737,17757,17766,17791,17798,17799,17806,17807,17818,17831,17840,17895,17936,17961,18036,18198,18274,18309,18316,18326,18357,18383,18384,18419,18442,18444,18480,18498,18542,18543,18555,18561,18577,18612,18657,18682,18689,18695,18733,18739,18754,18769,18779,18802,18832,18847,18848,18901,18910,18927,18991,18995,19015,19022,19038,19083,19086,19105,19132,19171,19183,19185,19187,19207,19228,19247,19258,19269,19274,19280,19282,19283,19289,19294,19299,19302,19304,19307,19339,19366,19386,19389,19396,19400,19402,19421,19423,19427,19442,19453,19458,19470,19503,19524,19532,19533,19567,19573,19604,19648,19650,19661,19700,19721,19800,19830,19867,19932,19937,19991,20029,20036,20044,20056,20057,20062,20099,20103,20153,20162,20177,20183,20188,20215,20216,20225,20236,20278,20293,20306,20354,20374,20391,20440,20464,20508,20530,20578,20579,20600,20649,20659,20662,20713,20733,20743,20764,20768,20786,20804,20813,20843,20851,20853,20858,20860,20871,20879,20883,20920,20921,20944,20949,20954,20999,21161,21168,21178,21217,21236,21252,21282,21313,21323,21388,21402,21452,21483,21516,21522,21536,21569,21709,21760,21787,21820,21906,21912,21969,21988,22059,22105,22244,22245,22246,22363,22500,22502,22527,22567,22603,22668,22742,22743,22744,22781,22805,22829,22847,22854,22874,22895,22924,22963,23034,23081,23124,23138,23170,23202,23224,23246,23251,23256,23300,23408,23447,23451,23526,23536,23555,23565,23569,23599,23617,23664,23668,23682,23759,23763,23839,23857,23875,23900,23922,23930,23955,23962,23967,24067,24072,24076,24141,24153,24174,24189,24208,24219,24264,24282,24415,24472,24484,24526,24585,24598,24609,24614,24618,24624,24682,24797,24853,24888,24924,24937,24943,24968,24973,24979,24989,25048,25100,25126,25245,25323,25360,25456,25534,25569,25598,25610,25624,25632,25673,25721,25818,25901,25955,26014,26122,26176,26215,26245,26386,26454,26554,26665,26772,26779,26808,26829,26898,26910,26920,26939,26954,26996,27024,27026,27103,27131,27133,27135,27151,27157,27186,27356,27490,27520,27545,27738,27805,27863,27891,27904,27912,27997,28248,28383,28384,28402,28416,28452,28777,28845,28910,28918,28944,28960,29033,29136,29281,29557,29933,30307,31114,31356,31671,32097,32841,33259,33430,33593,33651,33784,33993,34008,34176,34300,34490,34573,34783,34951,35144,35568,35755,36219,37408,39269,39452,39966,40169,40213,40491,40796,41036,41256,41311,41430,42530,42752,42799,43573,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 | 924 | 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.52 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.14 ms |
statistics | 1.52 ms |
preparing | 0.75 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.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 |