Tiempo de la consulta: 4.36 ms Después de la última consulta: 1.86 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.432 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-04 14:20:40')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 14:20:40')
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,56,60,62,63,65,71,73,86,87,149,158,164,174,177,196,216,220,221,226,240,259,262,263,269,291,299,325,331,341,349,366,391,428,429,472,477,481,482,501,510,525,530,531,546,548,553,563,587,596,619,626,659,662,663,667,674,684,697,705,746,769,781,800,802,805,808,823,832,835,869,873,901,910,923,925,939,940,954,969,974,976,977,980,982,983,994,999,1004,1005,1011,1021,1055,1066,1072,1091,1095,1099,1101,1114,1119,1158,1182,1205,1225,1231,1247,1252,1253,1255,1268,1271,1276,1289,1308,1309,1319,1333,1334,1347,1359,1363,1409,1410,1411,1428,1432,1441,1444,1467,1485,1503,1509,1557,1606,1619,1620,1629,1637,1648,1675,1693,1694,1701,1721,1724,1735,1765,1771,1775,1778,1794,1795,1796,1808,1810,1839,1843,1848,1854,1855,1862,1897,1899,1918,1920,1930,1960,1961,1975,1984,1994,1995,2001,2006,2008,2013,2015,2035,2054,2075,2088,2137,2142,2155,2157,2161,2293,2374,2381,2455,2527,2532,2551,2574,2586,2597,2632,2638,2643,2687,2710,2814,2824,2851,2883,2888,2960,2972,3009,3027,3055,3100,3107,3122,3147,3156,3169,3188,3207,3281,3292,3326,3329,3364,3368,3369,3376,3387,3409,3412,3442,3473,3515,3520,3548,3552,3554,3590,3595,3648,3683,3689,3710,3735,3748,3853,3858,3868,3872,3913,3919,3922,3962,3991,4034,4050,4068,4110,4129,4148,4227,4312,4323,4327,4334,4354,4430,4467,4468,4490,4507,4520,4529,4532,4550,4554,4558,4616,4620,4621,4622,4626,4666,4672,4673,4751,4752,4767,4787,4811,4813,4815,4821,4822,4831,4832,4833,4844,4846,4848,4865,4933,4973,5049,5055,5056,5094,5134,5144,5153,5160,5220,5266,5283,5333,5370,5399,5415,5417,5469,5559,5578,5639,5646,5678,5690,5697,5732,5780,5795,5874,5897,5999,6032,6141,6148,6176,6198,6381,6391,6420,6435,6442,6476,6477,6548,6606,6612,6623,6637,6638,6729,6845,6855,6944,6958,7022,7030,7048,7137,7195,7242,7258,7324,7388,7395,7418,7491,7522,7527,7535,7592,7595,7648,7751,7819,7852,8070,8086,8090,8192,8273,8291,8294,8295,8314,8353,8367,8386,8393,8498,8538,8592,8602,8634,8679,8707,8779,8801,8850,8895,8940,9057,9061,9186,9190,9199,9237,9277,9279,9362,9369,9401,9480,9488,9497,9509,9540,9541,9553,9572,9624,9635,9661,9716,9754,9771,9853,9930,9992,10068,10101,10113,10407,10562,10572,10764,10779,10792,10840,11001,11044,11089,11184,11212,11301,11317,11320,11398,11431,11443,11462,11465,11469,11496,11541,11549,11551,11555,11559,11590,11609,11625,11684,11694,11699,11700,11701,11705,11750,11751,11788,11793,11794,11807,12006,12020,12052,12201,12216,12242,12266,12324,12334,12341,12375,12398,12408,12506,12550,12590,12639,12648,12667,12684,12764,12786,12817,12819,12839,12973,12974,12998,13034,13126,13168,13186,13202,13209,13219,13231,13246,13313,13348,13358,13386,13390,13429,13454,13475,13581,13850,13851,13894,13896,13925,13941,13947,13966,13970,14126,14129,14132,14146,14155,14189,14194,14211,14238,14320,14331,14352,14364,14398,14403,14427,14428,14565,14658,14666,14703,14713,14714,14737,14752,14865,14969,14972,14975,14976,14988,15038,15063,15144,15171,15203,15227,15235,15272,15314,15322,15398,15460,15533,15544,15594,15604,15613,15689,15710,15781,15796,15804,15807,15850,15865,15868,15875,15895,15913,15915,15969,15973,16077,16080,16102,16121,16122,16220,16224,16245,16416,16454,16475,16547,16548,16569,16571,16587,16588,16607,16612,16636,16639,16648,16650,16698,16737,16742,16791,16793,16830,16834,16913,16995,16997,17054,17055,17062,17140,17166,17167,17170,17333,17335,17372,17383,17384,17388,17412,17427,17442,17524,17527,17592,17606,17635,17644,17646,17649,17683,17699,17721,17737,17783,17791,17798,17799,17806,17807,17863,17936,17942,18035,18036,18077,18080,18096,18125,18145,18151,18165,18171,18265,18306,18327,18357,18383,18444,18446,18473,18480,18483,18531,18542,18547,18551,18587,18609,18630,18657,18695,18733,18754,18779,18790,18802,18832,18836,18969,18977,18978,19012,19015,19038,19039,19112,19183,19187,19228,19258,19269,19280,19282,19283,19289,19299,19302,19307,19339,19389,19400,19402,19421,19423,19424,19427,19458,19470,19503,19508,19532,19533,19551,19573,19647,19681,19721,19800,19830,19937,20029,20038,20044,20056,20057,20062,20141,20153,20177,20188,20215,20236,20278,20293,20306,20391,20448,20508,20530,20535,20565,20567,20600,20617,20621,20662,20713,20733,20743,20764,20804,20813,20843,20851,20853,20858,20860,20871,20873,20879,20883,20920,20921,20928,20944,20949,20954,20973,20997,20999,21006,21025,21027,21034,21036,21168,21185,21203,21214,21217,21236,21241,21282,21308,21313,21361,21375,21402,21408,21439,21483,21534,21560,21564,21569,21593,21652,21703,21720,21746,21760,21787,21790,21817,21820,21933,21969,22105,22209,22249,22312,22353,22453,22484,22560,22567,22603,22743,22767,22847,22854,22870,22966,23138,23155,23170,23202,23224,23246,23452,23498,23526,23536,23569,23599,23617,23648,23676,23682,23701,23775,23875,23945,24067,24140,24151,24153,24189,24208,24219,24223,24246,24415,24484,24526,24585,24598,24609,24614,24627,24682,24697,24708,24725,24797,24853,24952,24973,25089,25128,25151,25323,25456,25534,25569,25576,25578,25598,25610,25627,25632,25675,25721,25756,25870,25901,26000,26014,26044,26082,26215,26236,26245,26362,26386,26473,26486,26554,26796,26829,26920,26949,26954,26957,26962,26997,27103,27133,27135,27139,27157,27231,27240,27354,27376,27421,27437,27460,27490,27502,27635,27803,27805,27860,27863,27875,27894,27898,27904,27968,27990,27997,28022,28030,28117,28218,28248,28252,28272,28402,28416,28423,28440,28442,28458,28470,28524,28547,28582,28587,28591,28635,28636,28680,28767,28858,28870,28884,28910,28918,28960,28994,29033,29134,29136,29221,29222,29281,29470,29837,30307,31050,31114,31356,31533,31611,31671,31716,31853,32097,32366,32841,32850,33164,33259,33430,33593,33651,33784,33897,33993,34008,34176,34300,34319,34459,34490,34573,34783,35036,35047,35103,35219,35245,35568,35597,35676,35724,35746,35755,36219,36252,36698,36750,37206,37408,37497,38175,38855,38988,39253,39301,39392,39455,39683,39714,39971,40034,40344,40358,40453,40481,40784,40863,41117,41256,41311,41385,41430,42411,42530,42752,42763,42799,42876,42978,43005,43031,43064,43328,43413,43438,43461,43545,43585,43586,43631,43945,44079,44100,44101,44396,44402,44602,44612,44743,44769,44846,44855,45076)
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 | 1097 | 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.60 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.67 ms |
preparing | 0.83 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 ms |
cleaning up | 0.02 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 |