Tiempo de la consulta: 12.60 ms Después de la última consulta: 1.01 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.459 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-05 17:47:36')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 17:47:36')
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(181,198,215,216,221,224,225,254,262,263,280,325,341,394,474,482,596,641,642,650,681,686,854,869,875,976,1066,1071,1101,1225,1266,1267,1339,1359,1411,1467,1503,1534,1574,1620,1637,1659,1686,1701,1709,1721,1735,1765,1775,1778,1805,1839,1848,1896,1932,2006,2008,2054,2142,2221,2428,2455,2632,2710,2855,2869,3009,3122,3188,3281,3292,3326,3329,3376,3398,3442,3515,3595,3630,3735,3801,3868,3870,4148,4227,4312,4323,4334,4338,4354,4423,4430,4507,4520,4547,4550,4554,4578,4621,4672,4673,4799,4821,4832,4833,4848,4855,4911,4935,4965,5049,5053,5056,5062,5094,5098,5144,5147,5151,5166,5184,5195,5263,5266,5273,5356,5374,5399,5406,5519,5578,5585,5646,5756,5782,5835,5852,5874,5897,5906,5927,6014,6032,6069,6141,6222,6226,6276,6373,6442,6510,6542,6543,6606,6612,6623,6637,6638,6641,6666,6677,6716,6729,6779,6845,6924,6939,7004,7022,7048,7222,7324,7388,7395,7423,7446,7522,7527,7534,7556,7560,7812,7852,7904,7926,7968,8060,8178,8273,8294,8296,8299,8306,8357,8367,8386,8393,8418,8498,8572,8678,8679,8707,8710,8810,8835,8923,8940,8948,8995,9046,9057,9061,9096,9110,9140,9180,9186,9190,9199,9252,9362,9381,9541,9553,9576,9641,9685,9731,9873,9915,9992,10014,10044,10046,10101,10113,10147,10342,10407,10562,10572,10774,11113,11320,11436,11443,11465,11469,11549,11590,11700,11706,11750,11772,11791,11979,12324,12334,12440,12550,12795,12817,12973,12998,13065,13069,13070,13094,13121,13186,13209,13219,13263,13475,13728,13803,13851,13894,13925,14048,14132,14146,14189,14194,14331,14352,14364,14428,14494,14565,14577,14713,14737,14741,14752,14857,14889,14969,14972,14975,14988,15077,15087,15090,15133,15144,15171,15184,15186,15203,15279,15322,15398,15598,15627,15644,15710,15751,15753,15796,15850,15895,15902,15960,15998,16010,16040,16055,16078,16102,16219,16245,16284,16401,16547,16548,16569,16570,16571,16588,16636,16698,16742,16793,16913,16997,17014,17062,17167,17170,17335,17391,17412,17427,17524,17580,17606,17629,17635,17643,17721,17942,17959,18014,18035,18068,18080,18096,18151,18265,18276,18284,18306,18382,18423,18473,18491,18516,18582,18599,18609,18630,18744,18779,18802,18836,18969,18977,18978,19012,19019,19039,19112,19286,19316,19359,19424,19432,19533,19551,19607,19681,19742,19758,19783,20150,20188,20448,20565,20621,20637,20662,20704,20713,20776,20832,20868,20871,20997,21013,21025,21034,21090,21174,21185,21203,21241,21340,21435,21439,21534,21560,21652,21660,21720,21746,21787,22249,22312,22337,22352,22362,22400,22450,22551,22573,22603,22615,22676,22737,22767,22797,22855,22870,22941,22963,22966,23115,23313,23452,23482,23648,23676,23701,23788,23879,23943,23945,24107,24151,24164,24172,24248,24434,24458,24475,24627,24766,24880,24894,24896,24927,24967,24993,25001,25013,25040,25091,25094,25114,25128,25167,25296,25321,25367,25371,25372,25390,25391,25393,25414,25431,25433,25446,25451,25457,25459,25464,25465,25467,25468,25472,25476,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25517,25536,25537,25538,25540,25545,25546,25552,25559,25569,25572,25576,25578,25582,25587,25588,25596,25674,25937,25941,25953,26000,26044,26047,26082,26362,26506,26554,26572,26577,26578,26653,26683,26694,26762,26785,26787,26796,26949,26962,26997,27067,27095,27123,27342,27354,27421,27460,27502,27635,27860,27875,27894,27898,27968,27990,28022,28030,28218,28272,28416,28423,28437,28440,28442,28458,28470,28524,28534,28547,28582,28587,28636,28741,28751,28858,28870,28884,28930,29136,29221,29222,30169,31463,31533,31725,33605,33897,34030,34071,34159,34243,34262,34270,34319,34375,34611,34956,35036,35103,35219,35266,35643,35676,35724,35746,35822,35881,36007,36143,36251,36252,36339,36382,36617,36620,36838,37002,37056,37184,37411,37422,37497,37524,37532,37688,37758,37796,38071,38199,38291,38363,38452,38585,38664,38665,38719,38762,38855,38933,38988,39227,39231,39253,39301,39397,39683,39687,39714,39769,39826,39896,39897,39958,39964,39971,39977,40025,40034,40082,40183,40292,40358,40453,40481,40530,40650,40703,40784,40863,41070,41095,41117,41134,41188,41204,41464,41503,41601,41677,41681,41778,41861,42107,42185,42205,42387,42396,42411,42590,42639,42708,42716,42763,42836,42876,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,43461,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,44406,44422,44447,44453,44458,44479,44487,44500,44517,44562,44609,44662,44682,44761,44762,44786,44797,44950,45008,45024,45050,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 | 811 | 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.50 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| init | 0.18 ms |
| System lock | 0.02 ms |
| optimizing | 0.11 ms |
| statistics | 1.52 ms |
| preparing | 0.69 ms |
| Sorting result | 0.02 ms |
| executing | 0.01 ms |
| Sending data | 8.80 ms |
| end | 0.01 ms |
| query end | 0.11 ms |
| closing tables | 0.03 ms |
| freeing items | 0.17 ms |
| cleaning up | 0.08 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 |
