Tiempo de la consulta: 14.82 ms Después de la última consulta: 0.97 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.355 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-09 17:28:00')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 17:28:00')
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(62,79,80,81,82,83,85,86,163,165,174,271,284,325,357,368,434,458,544,744,794,870,940,974,999,1091,1182,1289,1346,1365,1409,1410,1428,1538,1606,1614,1619,1648,1694,1724,1794,1795,1796,1808,1810,1843,1919,1930,1975,2013,2061,2188,2197,2392,2613,2647,2954,3024,3032,3034,3054,3055,3109,3169,3174,3180,3183,3296,3330,3364,3439,3451,3454,3515,3571,3637,3663,3815,3822,3823,3848,3858,3963,4031,4034,4077,4107,4166,4175,4207,4409,4414,4436,4437,4550,4561,4569,4587,4623,4699,4713,4767,4823,4863,4877,4881,5024,5032,5123,5137,5161,5213,5247,5249,5267,5270,5289,5306,5329,5338,5368,5387,5396,5419,5421,5454,5478,5662,5686,5704,5762,5881,5886,5896,5909,5912,5927,6041,6056,6088,6194,6465,6470,6472,6473,6545,6564,6600,6654,6737,6759,6955,6971,6988,7013,7014,7191,7246,7272,7276,7336,7385,7386,7393,7394,7412,7437,7439,7474,7529,7568,7669,7720,7725,7732,7817,7878,7885,7897,7923,7942,7966,8008,8020,8061,8090,8116,8117,8163,8176,8330,8331,8358,8363,8364,8369,8387,8409,8421,8424,8455,8457,8502,8506,8599,8644,8667,8671,8703,8758,8760,8769,8803,8804,8809,8869,8873,8930,8952,8977,8980,8998,9019,9029,9087,9167,9204,9234,9302,9325,9327,9354,9364,9400,9420,9429,9434,9453,9554,9640,9697,9732,9773,9793,9838,9886,9924,10042,10048,10082,10124,10148,10172,10280,10299,10302,10307,10393,10395,10443,10473,10475,10513,10553,10560,10614,10630,10694,10783,10887,10915,10958,10998,11059,11089,11098,11184,11258,11275,11278,11367,11402,11415,11436,11446,11555,11728,11747,11772,11899,11929,12133,12214,12218,12268,12288,12293,12298,12331,12379,12401,12416,12463,12468,12472,12474,12572,12617,12620,12622,12625,12686,12716,12810,12853,12875,12886,12901,12917,12944,13029,13084,13094,13113,13135,13177,13178,13205,13213,13246,13278,13294,13298,13353,13388,13395,13550,13582,13596,13635,13658,13687,13697,13742,13763,13794,13804,13836,13841,13963,13990,14074,14082,14097,14108,14117,14191,14211,14234,14244,14260,14262,14273,14283,14306,14350,14355,14440,14456,14458,14460,14477,14494,14507,14532,14607,14635,14645,14646,14683,14693,14698,14729,14759,14794,14824,14848,14866,14895,14944,14950,14964,14983,14992,15032,15037,15048,15094,15098,15108,15111,15126,15129,15137,15139,15151,15158,15213,15242,15260,15270,15304,15324,15328,15364,15370,15382,15387,15406,15428,15458,15471,15487,15492,15513,15548,15575,15618,15624,15626,15725,15741,15743,15757,15766,15776,15782,15784,15800,15817,15822,15823,15829,15909,15935,15964,15978,16000,16002,16007,16027,16036,16039,16042,16056,16074,16085,16092,16093,16114,16123,16137,16140,16153,16161,16164,16190,16192,16206,16217,16223,16254,16264,16275,16281,16301,16325,16326,16351,16358,16372,16373,16374,16375,16392,16393,16396,16403,16405,16414,16436,16458,16459,16498,16534,16561,16563,16566,16606,16656,16683,16713,16832,16845,16886,16889,16924,16929,16962,16966,16981,17008,17056,17085,17097,17128,17152,17157,17214,17215,17257,17273,17298,17344,17381,17382,17432,17484,17499,17541,17549,17567,17596,17597,17628,17634,17657,17669,17702,17733,17757,17766,17818,17840,17864,17880,17895,17923,17946,17961,17968,17980,17984,18031,18049,18063,18161,18214,18235,18246,18254,18258,18267,18281,18326,18329,18361,18369,18384,18438,18442,18460,18498,18561,18577,18612,18632,18646,18647,18648,18655,18665,18678,18682,18695,18727,18742,18757,18847,18869,18894,18904,18910,18920,18942,18972,18976,18977,18982,18991,18995,19000,19022,19051,19060,19083,19091,19110,19112,19123,19132,19136,19149,19177,19210,19247,19270,19294,19310,19313,19350,19366,19392,19446,19453,19490,19495,19524,19569,19581,19584,19595,19604,19608,19641,19650,19655,19661,19674,19684,19700,19709,19718,19751,19815,19830,19833,19867,19894,19930,19932,19941,19983,19986,19991,20030,20031,20034,20036,20069,20072,20083,20086,20145,20179,20183,20199,20225,20286,20293,20335,20338,20344,20350,20354,20358,20363,20374,20397,20400,20403,20440,20445,20464,20473,20509,20513,20529,20534,20545,20562,20578,20579,20606,20636,20638,20649,20659,20680,20704,20707,20737,20755,20768,20796,20797,20826,20856,20898,20928,20950,20974,20975,20991,21000,21008,21118,21127,21138,21140,21149,21161,21178,21225,21242,21252,21259,21264,21305,21322,21323,21347,21386,21429,21433,21451,21458,21464,21522,21540,21546,21555,21586,21593,21640,21681,21714,21732,21737,21738,21750,21861,21891,21898,21952,21972,21973,21988,21999,22026,22059,22061,22100,22209,22222,22228,22244,22245,22246,22276,22296,22419,22432,22435,22455,22477,22492,22500,22502,22517,22527,22530,22640,22646,22663,22668,22673,22684,22708,22715,22742,22803,22822,22874,22898,22915,22949,22973,23000,23022,23034,23049,23060,23081,23100,23122,23148,23182,23196,23200,23219,23222,23234,23247,23250,23259,23286,23344,23354,23375,23399,23467,23492,23516,23546,23564,23572,23591,23596,23607,23614,23668,23691,23703,23767,23772,23857,23874,23922,23930,23938,23959,23962,23967,23984,23986,24010,24024,24064,24072,24075,24076,24084,24101,24111,24131,24141,24174,24184,24205,24230,24288,24313,24346,24392,24449,24480,24483,24523,24528,24607,24616,24642,24651,24668,24673,24727,24745,24748,24788,24806,24823,24844,24857,24879,24924,24968,25003,25020,25126,25134,25178,25193,25204,25222,25226,25242,25253,25273,25293,25333,25344,25349,25360,25373,25374,25421,25444,25525,25534,25556,25561,25624,25639,25764,25787,25798,25987,26107,26122,26176,26284,26347,26349,26352,26356,26361,26444,26454,26519,26522,26564,26760,26767,26779,26800,26808,26816,26910,26926,26958,26982,26985,27024,27026,27076,27131,27151,27186,27247,27356,27363,27406,27410,27438,27452,27506,27558,27572,27737,27891,28005,28169,28301,28310,28397,28424,28780,28824,28845,29014,29021,29089,29124,29256,29358,29374,29391,29475,29501,29535,29617,29810,29833,29906,29919,29930,29938,30284,30947,31227,31499,31516,32250,32302,32381,32507,32590,32724,32843,32896,32943,33040,33129,33199,33649,33815,34078,34099,34109,34179,34184,34229,34241,34258,34260,34269,34292,34326,34335,34343,34357,35926,36053,36893,36916,36918,37315,37380,37874,37996,38056,38066,38361,38455,38734,38775,38812,39307,39358,39452,39504,39516,39966,40169,40312,40313,40314,40360,40503,40542,40685,40801,40822,40850,40852,40990,41036,41063,41270,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 | 1081 | 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.55 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.71 ms |
preparing | 0.84 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 10.58 ms |
end | 0.08 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.15 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 |