Tiempo de la consulta: 4.08 ms Después de la última consulta: 0.86 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.212 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-09 00:17:09')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 00:17:09')
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,49,56,58,60,62,63,65,71,73,86,87,149,164,170,172,174,177,196,221,226,240,259,262,287,290,291,293,299,331,344,349,353,366,391,428,429,437,472,477,481,501,510,525,530,531,546,563,607,619,659,662,663,667,674,693,697,705,710,746,769,797,800,802,805,808,823,832,835,843,869,873,910,923,939,940,954,969,974,977,982,983,997,999,1004,1005,1011,1021,1055,1091,1095,1114,1119,1158,1182,1205,1207,1231,1232,1247,1252,1253,1255,1268,1271,1276,1289,1308,1309,1319,1339,1347,1363,1409,1410,1428,1432,1441,1444,1479,1485,1486,1491,1509,1557,1606,1619,1629,1648,1675,1693,1694,1724,1771,1794,1795,1796,1808,1810,1843,1854,1855,1862,1888,1899,1918,1920,1930,1931,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2088,2137,2155,2157,2161,2293,2455,2478,2527,2532,2551,2586,2597,2638,2643,2757,2781,2814,2824,2851,2883,2888,2960,2997,3020,3027,3028,3045,3055,3100,3107,3124,3147,3169,3207,3209,3212,3251,3364,3368,3369,3387,3409,3412,3472,3473,3520,3548,3552,3554,3590,3638,3648,3671,3683,3689,3708,3738,3744,3748,3842,3853,3858,3872,3913,3919,3922,3962,3991,4034,4050,4068,4110,4120,4128,4129,4327,4399,4423,4468,4529,4532,4558,4616,4620,4622,4626,4666,4751,4752,4761,4767,4813,4815,4822,4831,4844,4846,4865,4903,4933,4973,5055,5103,5134,5153,5160,5220,5370,5376,5398,5415,5469,5471,5559,5581,5647,5682,5694,5780,5795,5817,5999,6012,6039,6131,6148,6190,6198,6234,6342,6343,6368,6391,6420,6435,6442,6476,6477,6484,6504,6548,6597,6599,6616,6688,6845,6855,6944,6945,6958,6998,7022,7030,7048,7137,7145,7195,7242,7258,7285,7324,7361,7413,7414,7418,7483,7491,7535,7592,7595,7648,7677,7751,7754,7819,7847,7894,7965,8020,8027,8070,8086,8087,8192,8194,8291,8295,8314,8538,8592,8602,8634,8707,8779,8801,8895,9176,9219,9237,9242,9276,9277,9279,9280,9282,9285,9318,9369,9387,9401,9488,9572,9702,9725,9852,9930,10100,10149,10336,10364,10382,10572,10623,10721,10782,10798,10840,10957,10993,11001,11184,11283,11555,11591,11665,11694,12242,12270,12398,12408,12581,12582,12621,12639,12667,12790,12851,12974,12978,13034,13060,13126,13142,13144,13246,13275,13297,13307,13332,13357,13420,13452,13515,13824,13896,13971,13972,14048,14372,14398,14453,14619,14630,14666,14703,14714,14718,14735,14752,14762,14790,14834,14844,14845,14852,14856,14865,14967,14969,14976,14983,15007,15038,15063,15087,15129,15156,15203,15214,15235,15241,15259,15269,15282,15335,15351,15376,15380,15383,15390,15406,15424,15460,15475,15516,15520,15522,15533,15544,15559,15581,15600,15604,15689,15700,15709,15742,15781,15785,15790,15804,15807,15812,15875,15880,15913,15915,15973,16002,16046,16095,16122,16127,16224,16249,16357,16358,16384,16393,16423,16427,16454,16521,16551,16587,16588,16612,16621,16675,16737,16770,16781,16788,16791,16816,16830,16841,16913,16995,17010,17037,17049,17054,17055,17116,17127,17140,17166,17188,17240,17246,17288,17331,17333,17351,17372,17377,17387,17388,17442,17444,17497,17561,17573,17592,17630,17644,17646,17680,17683,17699,17711,17736,17737,17738,17779,17791,17798,17799,17806,17807,17834,17862,17919,17930,17936,17942,17950,17967,17983,18036,18044,18061,18077,18222,18260,18295,18357,18382,18383,18444,18480,18542,18552,18629,18657,18664,18693,18695,18723,18728,18733,18754,18779,18802,18830,18832,18836,18855,18877,18888,18904,18905,18966,19006,19012,19014,19038,19062,19105,19124,19128,19140,19173,19183,19187,19228,19258,19269,19280,19282,19283,19287,19289,19299,19302,19307,19315,19339,19359,19381,19389,19400,19402,19421,19423,19427,19458,19470,19477,19486,19503,19532,19533,19569,19573,19575,19587,19607,19639,19684,19710,19721,19725,19733,19794,19800,19807,19830,19895,19923,19937,19987,20029,20044,20056,20057,20062,20119,20152,20153,20167,20175,20177,20188,20212,20215,20236,20256,20278,20293,20306,20321,20347,20391,20439,20445,20508,20530,20542,20600,20624,20638,20659,20662,20713,20733,20743,20756,20764,20772,20777,20802,20804,20813,20843,20851,20853,20858,20860,20871,20873,20879,20883,20892,20920,20921,20940,20944,20949,20954,20959,20978,20999,21049,21117,21118,21143,21168,21174,21195,21201,21217,21236,21256,21261,21279,21282,21313,21344,21367,21398,21402,21421,21457,21464,21470,21474,21483,21520,21522,21569,21630,21663,21684,21702,21741,21760,21764,21776,21778,21786,21787,21820,21836,21883,21906,21917,21968,21969,21997,22003,22038,22067,22105,22106,22119,22178,22187,22278,22298,22358,22450,22460,22471,22476,22477,22530,22531,22540,22550,22555,22567,22569,22570,22603,22631,22651,22655,22743,22758,22759,22789,22820,22840,22847,22850,22854,22927,22944,22960,22982,23007,23024,23034,23093,23138,23170,23171,23202,23224,23242,23246,23279,23367,23368,23379,23391,23405,23430,23438,23455,23526,23536,23553,23555,23569,23599,23617,23651,23673,23682,23687,23705,23849,23875,23878,23955,23968,23995,24050,24067,24076,24078,24153,24164,24189,24208,24219,24237,24374,24382,24415,24450,24468,24479,24480,24484,24526,24530,24584,24585,24598,24609,24614,24618,24640,24662,24682,24690,24733,24779,24797,24805,24841,24853,24916,24946,24963,24973,25037,25081,25117,25297,25323,25329,25366,25452,25456,25523,25534,25569,25598,25610,25632,25644,25676,25721,25750,25807,25901,25909,25919,25971,26011,26014,26109,26215,26229,26245,26261,26386,26521,26531,26554,26596,26628,26829,26854,26873,26920,26954,26959,26999,27001,27061,27062,27103,27133,27135,27157,27158,27290,27432,27490,27552,27578,27646,27707,27745,27805,27851,27863,27904,27950,27997,28037,28066,28094,28213,28225,28248,28264,28283,28402,28416,28749,28823,28826,28910,28918,28960,28971,29033,29061,29073,29136,29281,29539,29719,30307,31114,31356,31671,32097,32840,32841,33259,33278,33430,33593,33651,33736,33784,33993,34008,34176,34300,34490,34514,34573,34783,35568,35755,36219,37408,37800,38061,38147,38232,39156,39238,39375,39863,39981,39998,40093,40168,40480,40611,40851,41256,41311,41430,41902,42530,42752,42799,44396,44402,44602,44743,44851,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 | 1051 | 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.51 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.65 ms |
preparing | 0.77 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.10 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 |