Tiempo de la consulta: 6.35 ms Después de la última consulta: 1.45 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.324 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 06:41:43')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 06:41:43')
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,51,56,60,62,63,65,71,73,86,87,133,138,149,164,174,177,196,204,210,221,226,240,244,259,262,291,299,323,331,349,366,391,428,429,460,472,477,481,501,510,525,529,530,531,546,563,583,619,659,662,663,667,674,697,705,746,769,800,802,805,808,823,832,835,869,873,892,907,910,923,939,940,954,969,974,977,982,983,999,1004,1005,1011,1021,1036,1044,1055,1091,1095,1112,1114,1119,1130,1133,1158,1182,1205,1231,1247,1252,1253,1255,1268,1271,1276,1289,1308,1309,1319,1347,1363,1409,1410,1428,1432,1441,1444,1485,1509,1514,1557,1587,1601,1606,1619,1629,1648,1675,1693,1694,1724,1765,1771,1785,1794,1795,1796,1808,1810,1828,1843,1854,1855,1862,1899,1918,1920,1930,1945,1960,1961,1975,1984,1994,1995,2001,2007,2008,2013,2015,2034,2035,2075,2088,2092,2133,2137,2155,2157,2161,2293,2455,2477,2485,2527,2532,2551,2552,2586,2597,2638,2643,2764,2796,2814,2824,2851,2881,2883,2888,2960,3027,3055,3100,3107,3126,3147,3169,3207,3209,3269,3279,3364,3368,3369,3377,3379,3387,3408,3409,3412,3473,3512,3520,3523,3548,3552,3554,3564,3590,3613,3648,3683,3689,3748,3803,3825,3853,3858,3872,3913,3919,3922,3951,3962,3984,3991,4034,4046,4050,4068,4110,4129,4263,4327,4415,4457,4468,4515,4529,4532,4558,4616,4620,4622,4626,4666,4741,4745,4751,4752,4767,4800,4813,4815,4822,4831,4844,4846,4865,4933,4973,4988,4992,5055,5134,5153,5160,5220,5370,5415,5420,5469,5559,5746,5757,5780,5793,5795,5871,5894,5979,5999,6045,6148,6198,6221,6274,6391,6420,6435,6442,6448,6476,6477,6548,6554,6678,6686,6691,6699,6845,6855,6942,6944,6958,6965,7022,7030,7048,7121,7137,7195,7242,7258,7281,7291,7324,7418,7491,7535,7592,7594,7595,7648,7652,7751,7795,7804,7819,7913,7967,8009,8070,8086,8192,8258,8291,8295,8314,8404,8411,8522,8538,8592,8602,8634,8674,8707,8722,8728,8779,8801,8895,9075,9109,9197,9218,9237,9239,9277,9279,9369,9380,9401,9488,9562,9572,9625,9930,10099,10216,10258,10344,10348,10559,10572,10705,10802,10840,10869,10925,10955,11001,11006,11184,11214,11554,11555,11560,11662,11689,11730,11753,11965,12113,12213,12242,12281,12398,12408,12430,12475,12532,12550,12598,12639,12667,12714,12727,12799,12884,12935,12974,12999,13034,13044,13126,13159,13223,13241,13246,13465,13474,13662,13674,13710,13729,13779,13851,13870,13896,14076,14106,14264,14285,14449,14586,14598,14666,14668,14703,14714,14752,14808,14865,14920,14969,14976,15027,15038,15063,15087,15203,15235,15246,15460,15533,15544,15553,15604,15642,15705,15706,15761,15781,15782,15804,15807,15816,15875,15913,15915,15973,15991,15997,16014,16122,16156,16157,16182,16187,16224,16237,16375,16454,16539,16567,16587,16588,16612,16737,16791,16830,16876,16894,16913,16950,16995,17023,17054,17055,17065,17117,17140,17142,17166,17170,17193,17242,17248,17328,17333,17336,17372,17388,17390,17421,17442,17446,17511,17522,17537,17631,17644,17646,17683,17699,17737,17771,17791,17798,17799,17806,17807,17809,17822,17911,17924,17936,17954,17987,18027,18036,18038,18041,18042,18070,18072,18078,18105,18191,18212,18234,18290,18357,18383,18384,18419,18430,18444,18480,18485,18497,18500,18542,18657,18695,18733,18738,18754,18761,18779,18802,18832,19015,19024,19029,19038,19040,19114,19131,19145,19168,19183,19187,19228,19249,19258,19269,19280,19282,19283,19289,19299,19302,19307,19339,19389,19400,19402,19421,19423,19427,19430,19431,19439,19441,19458,19470,19503,19532,19533,19565,19573,19664,19705,19720,19721,19744,19759,19779,19800,19820,19830,19833,19937,19942,19973,20002,20028,20029,20033,20041,20042,20044,20045,20051,20056,20057,20062,20076,20086,20142,20152,20153,20158,20177,20187,20188,20215,20226,20236,20256,20271,20278,20293,20295,20306,20315,20322,20325,20391,20508,20530,20577,20600,20604,20629,20641,20650,20662,20677,20713,20733,20743,20764,20767,20801,20804,20813,20843,20851,20853,20858,20860,20871,20873,20877,20879,20883,20885,20920,20921,20944,20949,20954,20969,20992,20999,21080,21093,21112,21158,21168,21188,21217,21236,21251,21256,21264,21282,21313,21326,21378,21402,21445,21483,21502,21523,21569,21593,21599,21609,21644,21714,21728,21760,21787,21820,21830,21869,21940,21950,21969,22048,22049,22072,22100,22105,22157,22166,22224,22299,22372,22385,22506,22507,22556,22567,22603,22606,22704,22736,22743,22847,22854,22893,22923,22934,22955,23074,23116,23119,23134,23138,23145,23170,23178,23202,23213,23224,23246,23273,23275,23287,23364,23365,23409,23426,23491,23511,23526,23536,23569,23599,23615,23617,23668,23677,23682,23711,23776,23869,23872,23875,23914,23932,23940,24067,24108,24153,24189,24195,24208,24219,24233,24329,24368,24380,24391,24415,24424,24442,24484,24518,24526,24527,24585,24597,24598,24609,24614,24682,24697,24721,24797,24853,24942,24973,24974,25000,25116,25170,25195,25323,25456,25491,25534,25569,25598,25610,25632,25721,25745,25901,25944,25964,26014,26132,26215,26245,26319,26386,26393,26412,26530,26554,26591,26599,26672,26797,26803,26829,26831,26835,26841,26843,26864,26875,26920,26933,26948,26954,27059,27103,27133,27135,27157,27228,27274,27457,27490,27642,27758,27805,27855,27863,27904,27918,27923,27944,27997,27999,28208,28248,28349,28372,28402,28416,28419,28910,28918,28960,29033,29105,29136,29223,29281,29380,29611,29641,30307,30621,30932,31114,31356,31671,32097,32304,32796,32841,33259,33317,33430,33593,33651,33784,33993,34008,34115,34176,34300,34490,34573,34783,34795,34876,34923,35195,35568,35755,35783,35798,35850,36174,36219,36222,36439,37408,38816,38817,38885,38898,39062,39242,39886,40218,40786,41256,41311,41363,41430,42181,42260,42530,42752,42799,42951,43602,44396,44402,44602,44743,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 | 990 | 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.68 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.32 ms |
System lock | 0.02 ms |
optimizing | 0.23 ms |
statistics | 2.35 ms |
preparing | 1.30 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.56 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.04 ms |
freeing items | 0.16 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 |