Tiempo de la consulta: 4.74 ms Después de la última consulta: 0.98 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.534 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 23:42:53')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 23:42:53')
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(3,8,11,14,44,46,50,52,57,59,67,83,87,89,90,92,97,99,109,112,124,127,136,137,149,155,180,181,186,188,189,190,195,198,210,212,215,219,220,221,222,224,225,226,232,233,237,238,239,241,243,244,245,246,248,249,250,253,254,255,257,262,276,278,289,295,296,301,302,307,309,325,328,330,336,337,357,358,366,370,371,373,374,394,395,401,412,413,414,417,418,419,423,424,426,427,433,439,444,445,446,451,452,459,461,468,474,481,488,500,520,521,524,525,527,528,532,548,553,555,563,565,567,587,593,595,596,597,603,604,618,620,621,626,628,632,641,642,646,647,648,650,651,652,654,659,662,681,684,686,697,698,706,711,730,737,746,757,771,781,787,788,792,800,804,805,812,818,820,823,826,833,840,842,852,853,878,901,902,925,928,955,962,994,1007,1008,1015,1018,1023,1058,1066,1072,1082,1100,1114,1119,1145,1165,1188,1200,1207,1210,1212,1227,1266,1267,1268,1269,1270,1272,1273,1274,1275,1276,1277,1278,1302,1314,1325,1328,1335,1361,1383,1388,1389,1390,1394,1412,1461,1462,1478,1504,1506,1507,1533,1559,1579,1596,1621,1638,1690,1691,1712,1724,1738,1754,1756,1760,1782,1797,1800,1803,1828,1839,1853,1873,1896,1945,1954,1960,1961,1979,1996,1999,2007,2012,2048,2053,2082,2086,2095,2133,2147,2185,2215,2225,2342,2355,2425,2429,2433,2463,2492,2520,2530,2532,2566,2580,2584,2589,2595,2638,2660,2667,2687,2740,2811,2818,2822,2823,2852,2869,2870,2875,2894,2922,2972,2975,3017,3022,3026,3065,3097,3103,3156,3167,3181,3253,3269,3273,3290,3318,3332,3337,3350,3389,3415,3416,3417,3424,3463,3468,3469,3473,3506,3512,3517,3520,3544,3550,3555,3557,3559,3589,3613,3653,3662,3704,3709,3727,3776,3836,3845,3853,3868,3951,3984,3991,4000,4094,4111,4301,4334,4357,4360,4457,4471,4509,4538,4561,4580,4620,4710,4741,4784,4785,4832,4834,4848,4896,4955,5043,5045,5072,5096,5106,5186,5220,5243,5285,5298,5301,5354,5357,5365,5375,5386,5392,5415,5417,5420,5495,5515,5555,5561,5573,5582,5583,5637,5644,5646,5678,5684,5702,5730,5732,5756,5759,5768,5777,5779,5780,5793,5794,5795,5798,5804,5831,5889,5894,5899,5910,5919,5923,5942,5969,5978,5999,6000,6002,6011,6016,6022,6060,6087,6112,6121,6160,6176,6194,6220,6258,6261,6266,6312,6335,6343,6377,6390,6391,6401,6403,6415,6420,6445,6449,6476,6477,6498,6542,6543,6550,6554,6564,6587,6623,6677,6742,6758,6774,6795,6802,6855,6856,6885,7002,7008,7048,7105,7121,7130,7195,7237,7258,7273,7274,7295,7366,7374,7391,7421,7473,7497,7546,7549,7576,7584,7594,7596,7606,7616,7670,7687,7697,7716,7738,7742,7758,7760,7771,7788,7853,7875,7950,7958,7969,8009,8027,8050,8064,8070,8074,8078,8081,8084,8087,8138,8178,8192,8215,8218,8273,8374,8398,8461,8465,8478,8487,8494,8495,8521,8565,8569,8589,8637,8650,8672,8781,8815,8861,8895,8969,8997,9017,9121,9139,9174,9175,9182,9186,9201,9237,9251,9256,9277,9345,9362,9380,9394,9424,9431,9572,9660,9663,9697,9701,9711,9781,9850,10046,10159,10213,10239,10258,10298,10315,10379,10572,10603,10645,10708,10720,10753,10860,10893,11016,11112,11131,11206,11281,11292,11302,11397,11419,11559,11730,11822,12027,12130,12162,12193,12223,12383,12426,12439,12442,12502,12505,12568,12590,12599,12630,12663,12703,12788,12806,12871,12873,12887,12955,12974,12982,13013,13037,13062,13079,13126,13130,13186,13215,13238,13247,13263,13285,13325,13365,13383,13415,13432,13459,13463,13530,13556,13558,13566,13590,13625,13753,13833,13881,13903,13986,13987,14015,14029,14047,14177,14193,14218,14238,14341,14382,14436,14571,14608,14631,14651,14665,14678,14680,14725,14733,14810,14850,14862,14885,14904,14914,14940,14945,14951,14957,14969,14975,14978,15006,15054,15096,15138,15175,15200,15235,15244,15277,15314,15455,15469,15490,15518,15534,15540,15547,15550,15561,15567,15579,15602,15610,15612,15623,15627,15630,15666,15667,15707,15803,15835,15902,15913,15925,15953,15969,15973,16005,16015,16021,16023,16024,16046,16087,16122,16197,16203,16213,16219,16258,16262,16336,16370,16382,16402,16417,16421,16443,16479,16588,16648,16737,16808,16816,16833,16865,16947,16995,17045,17160,17170,17172,17194,17234,17352,17359,17371,17373,17380,17413,17421,17470,17500,17584,17629,17662,17680,17710,17721,17783,17976,17977,18006,18035,18036,18067,18084,18151,18253,18264,18297,18308,18313,18378,18413,18421,18422,18437,18446,18447,18490,18491,18497,18500,18524,18545,18575,18596,18603,18620,18626,18635,18655,18668,18718,18720,18739,18751,18752,18766,18768,18779,18792,18801,18802,18804,18828,18853,18868,18874,18918,18956,18960,18979,19005,19038,19062,19082,19134,19164,19204,19267,19272,19275,19291,19293,19299,19302,19307,19310,19397,19426,19545,19568,19586,19587,19592,19604,19625,19659,19697,19744,19796,19824,19834,19876,19926,19939,19976,20017,20033,20041,20042,20057,20062,20120,20145,20150,20176,20184,20188,20193,20211,20212,20213,20264,20274,20277,20307,20310,20327,20337,20364,20410,20551,20554,20570,20709,20757,20821,20852,20853,20922,20963,21047,21050,21159,21188,21230,21237,21255,21273,21313,21401,21466,21653,21733,21740,21820,21844,21851,21950,21955,21956,21964,22012,22026,22100,22103,22298,22323,22344,22384,22452,22484,22540,22564,22615,22669,22692,22738,22750,22772,22890,22917,22955,23000,23017,23082,23085,23145,23201,23287,23302,23398,23435,23511,23533,23650,23663,23741,23757,23768,23808,23847,23901,23917,23932,23945,24095,24127,24156,24199,24245,24305,24346,24386,24388,24410,24502,24505,24545,24563,24576,24613,24662,24667,24697,24756,24805,24865,24878,24889,24962,24967,24973,25030,25048,25147,25164,25214,25228,25273,25315,25346,25453,25465,25500,25524,25959,26043,26332,26340,26473,26578,26588,26595,26728,26796,26875,26917,26920,26954,26997,26999,27135,27142,27164,27307,27345,27409,27432,27461,27483,27803,27805,27878,27901,27904,28049,28072,28198,28248,28416,28423,28440,28545,28547,28777,28821,28884,29159,29172,29214,29219,29221,29269,29328,29354,29388,29640,29650,29696,30111,30451,30478,30696,30700,30965,31533,31899,32339,32352,33749,33874,34426,35039,35181,35368,35571,35588,35922,36564,36600,37289,37656,37865,37871,38000,38489,38542,38563,38628,38691,39128,39535,39917,40053,40199,40270,40548,41074,41268,41360,41460,41494,41722,42444,42769,43388,43436,44149,44866)
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 | 1129 | 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.59 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.81 ms |
preparing | 0.84 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.02 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 |