Tiempo de la consulta: 21.55 ms Después de la última consulta: 0.93 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.187 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 13:07:51')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 13:07:51')
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(9,49,58,62,78,85,155,163,170,172,174,214,279,285,287,290,291,293,303,344,349,353,357,437,450,495,531,572,607,666,667,693,797,808,843,863,869,885,954,997,1101,1102,1182,1207,1216,1232,1247,1278,1279,1289,1339,1346,1486,1538,1648,1846,1867,1919,1931,2013,2188,2328,2392,2402,2647,2757,2954,2997,3020,3028,3045,3054,3055,3106,3107,3109,3124,3174,3180,3209,3212,3364,3369,3402,3409,3412,3451,3454,3571,3577,3663,3671,3738,3842,4120,4128,4166,4399,4409,4503,4589,4699,4713,4767,4823,4863,5161,5247,5396,5461,5471,5478,5536,5559,5647,5686,5857,5881,5886,5913,6039,6056,6088,6120,6131,6178,6234,6465,6472,6484,6545,6616,6639,6688,6876,6988,6998,7013,7014,7122,7246,7272,7276,7336,7361,7437,7439,7478,7483,7677,7720,7736,7818,7841,7847,7894,7897,7923,7924,7965,8027,8046,8061,8090,8116,8118,8457,8760,8864,9029,9087,9204,9318,9364,9429,9434,9554,9773,9836,9924,10100,10149,10307,10382,10475,10478,10553,10623,10630,10694,10721,10782,10783,10801,10957,10958,11059,11258,11402,11446,11472,11899,11929,12218,12270,12331,12393,12401,12410,12463,12474,12581,12582,12617,12620,12622,12625,12637,12686,12708,12810,12851,12853,12875,12901,12944,12978,13017,13246,13294,13298,13307,13332,13420,13515,13671,13687,13697,13707,13742,13804,13842,13963,13972,13975,13990,14074,14082,14092,14105,14117,14142,14244,14262,14271,14273,14372,14440,14453,14456,14507,14630,14646,14683,14698,14759,14794,14845,14852,14856,14964,14983,14987,14992,15004,15007,15030,15032,15037,15048,15094,15108,15111,15129,15139,15156,15213,15214,15247,15335,15351,15370,15376,15382,15403,15406,15424,15439,15471,15475,15492,15520,15522,15542,15548,15562,15575,15581,15600,15689,15700,15717,15725,15728,15742,15757,15782,15785,15790,15812,15829,15880,15935,16000,16092,16093,16095,16127,16140,16153,16161,16206,16249,16257,16326,16357,16373,16374,16384,16427,16458,16459,16497,16521,16534,16543,16551,16652,16657,16675,16781,16816,16832,16841,16889,16929,16936,16981,17000,17049,17116,17128,17188,17215,17240,17246,17257,17273,17288,17331,17347,17358,17381,17382,17387,17432,17444,17484,17497,17541,17561,17573,17596,17630,17634,17659,17702,17711,17733,17736,17757,17766,17779,17818,17831,17834,17840,17862,17864,17895,17919,17930,17936,17950,17961,17967,17980,17983,18031,18044,18061,18222,18260,18267,18295,18309,18316,18326,18369,18382,18384,18419,18442,18498,18543,18552,18555,18561,18577,18612,18664,18682,18689,18693,18728,18739,18830,18847,18848,18869,18877,18888,18901,18904,18905,18910,18920,18942,18977,18982,18991,18995,19000,19015,19022,19083,19086,19091,19105,19110,19112,19124,19128,19132,19136,19140,19149,19171,19173,19185,19207,19247,19270,19274,19287,19294,19304,19313,19315,19350,19366,19381,19386,19396,19435,19442,19446,19453,19486,19524,19567,19581,19595,19604,19607,19608,19639,19650,19655,19661,19684,19700,19710,19718,19725,19733,19794,19807,19815,19867,19894,19923,19930,19932,19941,19983,19991,20030,20034,20036,20069,20099,20103,20119,20145,20162,20175,20183,20199,20216,20344,20354,20358,20363,20374,20403,20440,20445,20464,20542,20578,20579,20636,20638,20649,20659,20755,20768,20772,20777,20797,20826,20856,20940,20950,20959,21000,21117,21118,21143,21161,21178,21242,21252,21305,21323,21344,21367,21388,21398,21421,21433,21452,21457,21458,21464,21470,21516,21520,21522,21536,21546,21586,21593,21663,21684,21702,21709,21714,21737,21741,21764,21776,21778,21883,21906,21912,21917,21952,21968,21988,21997,22038,22059,22067,22100,22106,22119,22178,22244,22245,22246,22278,22298,22419,22435,22450,22455,22460,22476,22492,22500,22502,22517,22527,22555,22570,22668,22673,22708,22715,22742,22744,22759,22803,22805,22820,22829,22840,22874,22895,22924,22944,22960,22963,23000,23022,23034,23060,23081,23093,23122,23124,23148,23196,23200,23219,23234,23242,23247,23250,23256,23279,23286,23300,23344,23367,23368,23375,23405,23408,23430,23438,23467,23516,23546,23553,23555,23559,23564,23565,23668,23691,23703,23759,23763,23767,23772,23839,23849,23857,23874,23900,23922,23930,23955,23959,23962,23967,23968,23984,24010,24024,24072,24075,24111,24141,24164,24174,24230,24237,24264,24282,24346,24392,24472,24523,24530,24584,24607,24616,24618,24624,24673,24690,24727,24779,24788,24805,24823,24841,24844,24857,24888,24924,24943,24946,24963,24968,24979,24989,25003,25037,25048,25081,25100,25117,25126,25245,25273,25297,25329,25333,25349,25360,25373,25374,25421,25452,25523,25534,25624,25639,25673,25676,25764,25798,25807,25818,25919,25955,25971,25987,26107,26122,26176,26229,26261,26361,26454,26522,26564,26596,26665,26767,26772,26779,26800,26808,26816,26854,26873,26898,26910,26926,26939,26959,26982,26996,27001,27024,27026,27061,27062,27131,27151,27158,27186,27290,27356,27363,27438,27452,27490,27506,27520,27545,27552,27558,27572,27578,27646,27707,27738,27745,27790,27851,27891,27950,28005,28066,28094,28213,28264,28283,28397,28424,28452,28749,28780,28824,28826,28845,29021,29061,29073,29089,29124,29256,29358,29539,29617,29719,29810,29919,29930,31227,31499,31516,32250,32302,32381,32507,32590,32840,32843,32896,32943,33040,33129,33199,33649,33815,34078,34099,34109,34179,34184,34229,34241,34258,34260,34269,34292,34326,34343,34357,35144,36893,36916,36918,37315,37380,37874,37996,38056,38066,38361,38455,38734,38775,38812,39269,39307,39358,39452,39504,39516,39966,39981,39998,40168,40169,40213,40312,40313,40314,40360,40542,40611,40801,40822,40850,40990,41036,41063,41402,41423,41811,41885,42460,42489,43680,43705,43706,43707,43914,43915,43917,44031,44041,44497,44681,45115,45160,45206,45252)
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 | 947 | 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.73 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.40 ms |
System lock | 0.02 ms |
optimizing | 0.15 ms |
statistics | 2.60 ms |
preparing | 1.35 ms |
Sorting result | 0.05 ms |
executing | 0.01 ms |
Sending data | 15.48 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.04 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 |