Tiempo de la consulta: 3.48 ms Después de la última consulta: 0.62 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.306 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 22:32:21')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-03 22:32:21')
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(27,78,85,148,155,163,214,247,279,285,303,349,450,495,531,572,666,667,708,710,711,712,713,723,783,808,863,869,885,954,1018,1080,1101,1102,1141,1216,1233,1278,1279,1538,1555,1648,1835,1846,1867,2013,2328,2402,2463,2647,2954,3014,3036,3054,3106,3107,3174,3369,3402,3409,3412,3454,3461,3577,3663,3737,4116,4409,4503,4589,4823,4863,4973,5247,5351,5396,5461,5478,5536,5613,5686,5785,5857,5881,5886,5913,6056,6062,6088,6120,6178,6465,6545,6600,6639,6673,6684,6744,6806,6876,6988,7014,7101,7122,7246,7262,7272,7276,7313,7336,7437,7454,7478,7720,7722,7736,7818,7841,7897,7924,7981,8046,8059,8090,8116,8118,8250,8457,8679,8692,8760,8864,9029,9087,9204,9364,9429,9836,9924,10008,10026,10033,10475,10478,10530,10553,10563,10630,10694,10801,10831,11039,11059,11258,11348,11472,11870,11899,11929,12401,12402,12410,12564,12617,12620,12625,12637,12708,12810,12853,12875,12901,12944,13017,13246,13294,13298,13528,13635,13671,13687,13697,13707,13742,13804,13842,13963,13975,13990,14074,14092,14105,14117,14142,14271,14273,14450,14456,14463,14507,14646,14698,14759,14763,14987,14992,15004,15010,15030,15031,15032,15037,15048,15094,15247,15266,15370,15382,15403,15424,15439,15471,15492,15523,15542,15562,15574,15575,15717,15725,15728,15747,15757,15829,15863,15935,15955,16005,16093,16124,16153,16161,16206,16257,16326,16373,16458,16459,16497,16534,16543,16559,16652,16657,16877,16889,16929,16936,16981,17000,17128,17184,17201,17215,17257,17273,17307,17339,17347,17358,17360,17381,17382,17432,17484,17566,17596,17631,17634,17659,17702,17757,17766,17818,17831,17840,17864,17870,17895,17961,18056,18059,18131,18198,18267,18309,18316,18326,18350,18384,18403,18419,18429,18442,18464,18498,18541,18543,18555,18561,18577,18612,18662,18682,18689,18724,18739,18769,18810,18847,18848,18869,18880,18901,18904,18910,18927,18977,18984,18991,18995,19022,19054,19083,19086,19091,19095,19105,19112,19132,19149,19171,19185,19188,19205,19207,19247,19274,19294,19304,19309,19313,19350,19366,19379,19386,19396,19442,19446,19453,19517,19524,19567,19581,19595,19604,19608,19650,19652,19655,19661,19684,19700,19718,19720,19730,19867,19917,19932,19983,19991,20023,20030,20034,20036,20054,20074,20076,20099,20100,20103,20130,20143,20145,20162,20183,20199,20216,20266,20281,20313,20354,20358,20374,20403,20433,20440,20464,20472,20497,20510,20512,20578,20579,20589,20638,20649,20659,20710,20755,20768,20786,20797,20824,20826,20856,20858,20950,21000,21118,21133,21161,21178,21181,21227,21252,21305,21323,21388,21433,21452,21458,21464,21516,21522,21531,21536,21546,21593,21709,21737,21906,21912,21952,21988,22028,22053,22059,22068,22082,22099,22244,22245,22246,22268,22315,22435,22455,22477,22500,22502,22517,22527,22607,22616,22668,22715,22742,22744,22786,22803,22805,22829,22874,22878,22895,22924,22963,23000,23019,23022,23034,23042,23060,23081,23124,23196,23200,23234,23247,23250,23256,23300,23408,23451,23467,23516,23546,23559,23564,23565,23594,23664,23668,23691,23732,23759,23763,23767,23828,23839,23857,23900,23922,23930,23955,23962,23967,24072,24075,24076,24111,24141,24174,24176,24202,24230,24264,24282,24392,24472,24523,24616,24618,24624,24702,24727,24734,24788,24823,24843,24844,24868,24885,24888,24924,24943,24964,24968,24979,24989,25003,25008,25022,25048,25082,25100,25126,25245,25333,25360,25415,25534,25557,25624,25639,25673,25764,25798,25818,25833,25955,26050,26107,26122,26176,26205,26247,26361,26454,26522,26665,26715,26716,26767,26772,26779,26800,26808,26816,26898,26910,26939,26996,27009,27024,27026,27081,27101,27131,27150,27151,27161,27174,27186,27230,27259,27272,27293,27294,27295,27315,27317,27356,27363,27438,27452,27490,27497,27520,27524,27545,27577,27738,27891,28048,28452,28773,28780,28845,28944,28955,29088,29098,29372,29378,29557,29672,29833,32250,32302,32381,32507,32590,32843,32896,32943,33040,33129,33199,33649,34078,34099,34109,34179,34184,34229,34241,34258,34260,34269,34292,34326,34343,34357,34951,35144,35882,36291,36893,37573,38980,39269,39452,39966,40169,40213,40491,40796,40822,40850,40990,41036,41163,43008)
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 | 695 | 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.41 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.14 ms |
preparing | 0.53 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.48 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 |