Tiempo de la consulta: 11.79 ms Después de la última consulta: 1.04 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.516 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-07 15:52:59')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 15:52: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,52,56,60,62,63,65,71,73,86,87,149,164,174,177,181,196,198,215,216,221,224,225,226,240,254,259,262,280,291,299,323,325,331,349,366,391,394,428,429,472,474,477,481,501,510,525,530,531,546,563,596,619,641,642,647,648,650,659,662,663,667,674,681,686,697,705,746,769,800,802,805,808,823,832,835,854,869,873,875,910,923,939,940,954,969,974,976,977,982,983,999,1004,1005,1011,1021,1044,1055,1066,1071,1091,1095,1114,1119,1158,1182,1205,1231,1247,1252,1253,1255,1266,1267,1268,1271,1276,1289,1308,1309,1319,1339,1347,1359,1363,1409,1410,1428,1432,1441,1444,1467,1485,1509,1514,1534,1557,1574,1606,1619,1629,1637,1648,1659,1675,1686,1693,1694,1709,1721,1724,1771,1778,1794,1795,1796,1805,1808,1810,1828,1843,1854,1855,1862,1896,1899,1918,1920,1930,1932,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2088,2137,2155,2157,2161,2221,2293,2428,2455,2527,2532,2551,2586,2597,2638,2643,2814,2824,2851,2855,2869,2883,2888,2960,3027,3055,3100,3107,3147,3169,3207,3269,3364,3368,3369,3387,3398,3408,3409,3412,3473,3520,3548,3552,3554,3590,3595,3630,3648,3683,3689,3748,3801,3853,3858,3868,3870,3872,3913,3919,3922,3962,3991,4034,4050,4068,4110,4129,4327,4338,4415,4457,4468,4529,4532,4547,4558,4578,4616,4620,4622,4626,4666,4745,4751,4752,4767,4799,4813,4815,4822,4831,4844,4846,4855,4865,4911,4933,4935,4965,4973,5053,5055,5062,5098,5134,5147,5151,5153,5160,5166,5184,5195,5220,5263,5273,5370,5374,5406,5415,5469,5519,5559,5585,5756,5780,5782,5793,5795,5835,5852,5906,5927,5979,5999,6014,6032,6069,6148,6198,6222,6226,6276,6373,6391,6420,6435,6442,6476,6477,6510,6542,6543,6548,6641,6666,6677,6699,6716,6779,6845,6855,6924,6939,6944,6958,7004,7022,7030,7048,7137,7195,7222,7242,7258,7324,7418,7423,7446,7491,7534,7535,7556,7560,7592,7595,7648,7653,7751,7795,7812,7819,7843,7904,7926,7968,8009,8060,8070,8086,8178,8192,8291,8294,8295,8296,8299,8300,8306,8314,8357,8404,8418,8538,8572,8592,8602,8634,8674,8678,8707,8710,8722,8779,8801,8810,8835,8895,8923,8940,8948,8995,9046,9075,9096,9110,9140,9180,9186,9190,9199,9237,9252,9277,9279,9362,9369,9380,9381,9401,9488,9541,9572,9576,9641,9685,9731,9873,9915,9930,10014,10044,10046,10113,10147,10258,10342,10407,10505,10572,10774,10840,11001,11184,11436,11465,11549,11555,11590,11689,11706,11750,11772,11791,11979,12242,12324,12334,12398,12408,12440,12550,12639,12667,12727,12795,12974,12998,13034,13065,13069,13070,13094,13121,13126,13209,13246,13263,13728,13779,13803,13894,13896,14048,14146,14352,14449,14494,14577,14666,14668,14703,14714,14741,14808,14857,14865,14889,14969,14976,15038,15063,15077,15087,15090,15133,15184,15186,15203,15235,15279,15460,15533,15544,15567,15598,15604,15627,15644,15751,15753,15781,15804,15807,15875,15895,15902,15913,15915,15960,15973,15998,16010,16040,16055,16078,16122,16156,16219,16224,16284,16401,16454,16570,16587,16588,16612,16737,16791,16830,16913,16995,17014,17054,17055,17140,17166,17333,17372,17388,17442,17580,17592,17629,17643,17644,17646,17683,17699,17737,17791,17798,17799,17806,17807,17936,17959,18014,18036,18068,18070,18276,18284,18306,18357,18382,18383,18423,18444,18480,18491,18497,18500,18516,18542,18582,18599,18657,18695,18733,18738,18744,18754,18779,18802,18832,19015,19019,19038,19112,19183,19187,19228,19258,19269,19280,19282,19283,19286,19289,19299,19302,19307,19316,19339,19359,19389,19400,19402,19421,19423,19427,19432,19458,19470,19503,19532,19533,19573,19607,19721,19742,19744,19758,19783,19800,19830,19937,20029,20044,20056,20057,20062,20150,20153,20177,20188,20215,20236,20278,20293,20306,20322,20391,20508,20530,20600,20604,20610,20637,20662,20704,20713,20733,20743,20764,20776,20804,20813,20832,20843,20851,20853,20858,20860,20871,20873,20879,20883,20920,20921,20944,20949,20954,20999,21013,21090,21112,21168,21174,21217,21236,21256,21282,21313,21340,21402,21435,21483,21523,21569,21660,21760,21787,21820,21869,21940,21969,22105,22224,22337,22352,22362,22372,22400,22551,22567,22573,22603,22615,22676,22737,22743,22767,22797,22847,22854,22855,22941,22955,22963,23115,23138,23170,23202,23224,23246,23313,23482,23511,23526,23536,23569,23599,23617,23682,23788,23875,23879,23943,24067,24107,24153,24164,24172,24189,24208,24219,24248,24415,24434,24458,24475,24484,24526,24585,24598,24609,24614,24682,24766,24797,24853,24880,24894,24896,24927,24967,24973,24993,25000,25001,25013,25040,25091,25094,25114,25167,25296,25321,25323,25367,25371,25372,25390,25391,25393,25414,25431,25433,25446,25451,25456,25457,25459,25464,25465,25467,25468,25472,25476,25481,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25517,25534,25536,25537,25538,25540,25545,25546,25552,25559,25569,25572,25576,25578,25582,25587,25588,25596,25598,25610,25632,25674,25721,25901,25937,25941,25953,25964,26014,26044,26047,26215,26245,26319,26362,26386,26407,26506,26554,26572,26577,26578,26653,26683,26694,26785,26787,26796,26797,26803,26829,26831,26841,26875,26920,26948,26954,26962,27067,27095,27103,27123,27133,27135,27157,27228,27342,27490,27805,27863,27904,27997,28248,28402,28416,28440,28534,28635,28741,28751,28870,28910,28918,28930,28960,29033,29136,29222,29281,30307,31114,31356,31463,31533,31671,31725,32097,32841,33259,33430,33593,33605,33651,33784,33993,34008,34030,34071,34159,34176,34243,34262,34270,34300,34375,34490,34573,34611,34783,34956,35266,35568,35643,35755,35822,35881,36007,36143,36219,36251,36339,36382,36617,36620,36838,37002,37056,37408,37411,37422,37524,37532,37688,37758,37796,38071,38199,38363,38452,38585,38664,38665,38719,38762,38816,38817,38933,39227,39231,39397,39687,39769,39826,39896,39897,39958,39964,39977,40025,40082,40183,40292,40530,40650,40703,41070,41095,41134,41188,41204,41256,41311,41430,41464,41503,41601,41677,41681,41778,41861,42107,42185,42205,42387,42396,42530,42590,42639,42708,42716,42752,42799,42836,42890,42900,42952,42991,42993,42998,43050,43051,43078,43114,43120,43191,43247,43248,43274,43291,43300,43301,43335,43360,43365,43386,43398,43412,43424,43528,43546,43599,43651,43688,43700,43716,43725,43885,44013,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44200,44208,44229,44263,44282,44312,44327,44382,44387,44396,44402,44406,44422,44447,44453,44458,44479,44487,44500,44517,44562,44602,44609,44662,44682,44743,44761,44762,44786,44797,44950,45008,45024,45050,45076,45086,45106,45131,45152,45183,45196,45208,45209,45257,45275,45309)
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 | 1147 | 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.93 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.36 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 2.45 ms |
preparing | 1.42 ms |
Sorting result | 0.05 ms |
executing | 0.01 ms |
Sending data | 5.57 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.09 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 |