Tiempo de la consulta: 6.25 ms Después de la última consulta: 1.33 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.256 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-07 20:01:35')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 20:01:35')
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,60,62,63,65,69,71,73,74,75,76,77,78,86,87,113,114,116,117,119,136,149,164,174,177,196,201,202,207,208,221,226,240,259,262,271,280,283,287,291,299,309,331,344,349,350,353,366,374,376,377,378,379,380,391,393,428,429,456,472,477,481,501,510,525,530,531,546,563,608,611,619,659,662,663,667,674,686,693,697,705,744,746,769,800,802,805,808,823,831,832,835,868,869,873,891,910,914,923,939,940,941,942,954,964,969,974,976,977,982,983,986,999,1004,1005,1011,1021,1033,1043,1055,1091,1095,1114,1119,1133,1158,1169,1178,1179,1182,1205,1207,1215,1231,1232,1247,1252,1253,1255,1268,1271,1273,1276,1278,1287,1289,1308,1309,1319,1329,1338,1339,1347,1363,1409,1410,1428,1432,1441,1444,1459,1485,1509,1557,1601,1606,1619,1629,1648,1664,1675,1693,1694,1698,1709,1718,1724,1771,1794,1795,1796,1808,1810,1843,1854,1855,1862,1899,1918,1920,1930,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2088,2137,2155,2157,2161,2293,2455,2527,2532,2551,2586,2597,2638,2643,2656,2713,2714,2742,2814,2824,2840,2851,2883,2888,2901,2960,2991,2997,3027,3055,3091,3100,3107,3117,3147,3169,3198,3207,3215,3227,3249,3329,3340,3364,3368,3369,3387,3409,3412,3442,3473,3520,3548,3552,3554,3590,3615,3648,3668,3683,3689,3748,3783,3814,3816,3853,3858,3870,3872,3895,3913,3919,3922,3957,3962,3991,4034,4050,4068,4087,4110,4129,4206,4319,4327,4378,4468,4529,4532,4558,4616,4620,4622,4626,4638,4666,4751,4752,4767,4813,4815,4822,4831,4844,4846,4863,4865,4916,4933,4973,5001,5055,5134,5153,5160,5176,5220,5254,5259,5370,5415,5469,5559,5594,5647,5730,5780,5795,5999,6039,6148,6198,6292,6298,6311,6333,6384,6391,6420,6435,6442,6464,6476,6477,6484,6488,6536,6548,6616,6631,6687,6845,6855,6908,6940,6942,6944,6957,6958,6961,6989,7001,7022,7030,7048,7137,7154,7189,7195,7242,7258,7280,7282,7303,7311,7324,7333,7342,7361,7378,7387,7402,7403,7410,7418,7434,7450,7454,7460,7486,7488,7491,7522,7535,7546,7556,7592,7595,7614,7626,7638,7648,7713,7731,7751,7774,7819,7829,7836,7861,7862,7890,7914,7916,7923,7952,7965,7967,7985,8027,8054,8070,8086,8107,8108,8134,8177,8192,8291,8295,8314,8538,8592,8602,8634,8694,8707,8779,8801,8860,8886,8895,8929,9057,9091,9237,9249,9277,9279,9318,9369,9401,9429,9488,9572,9723,9725,9861,9916,9930,9966,9985,10011,10092,10100,10110,10120,10181,10193,10217,10227,10259,10260,10265,10313,10318,10357,10369,10370,10399,10403,10415,10444,10453,10534,10572,10611,10615,10682,10688,10777,10798,10820,10821,10840,10971,11001,11005,11037,11082,11094,11184,11188,11235,11289,11333,11362,11365,11505,11539,11555,11663,11726,11779,11799,11816,11893,11922,11950,11976,12009,12019,12070,12081,12133,12153,12178,12179,12242,12243,12320,12388,12398,12408,12446,12465,12499,12520,12610,12611,12620,12625,12639,12667,12670,12685,12715,12749,12758,12789,12838,12846,12873,12898,12907,12948,12974,12985,13006,13034,13035,13036,13041,13079,13124,13126,13137,13211,13229,13231,13246,13285,13334,13390,13466,13493,13497,13557,13583,13647,13771,13790,13805,13817,13835,13896,13901,13906,13913,13953,14024,14098,14113,14143,14152,14205,14223,14248,14250,14277,14283,14285,14336,14352,14354,14370,14396,14424,14426,14435,14447,14481,14530,14558,14571,14596,14625,14629,14666,14676,14684,14695,14697,14700,14703,14714,14749,14752,14754,14759,14771,14775,14789,14792,14843,14856,14865,14969,14976,14984,15007,15010,15018,15035,15038,15063,15087,15203,15231,15235,15245,15286,15304,15315,15316,15444,15460,15475,15486,15520,15522,15533,15544,15552,15581,15600,15604,15608,15616,15655,15678,15704,15714,15723,15730,15742,15744,15753,15755,15778,15781,15782,15785,15804,15805,15807,15812,15819,15875,15876,15880,15897,15913,15915,15965,15973,15996,16053,16058,16088,16122,16127,16200,16224,16249,16250,16254,16282,16297,16305,16316,16324,16362,16381,16410,16417,16430,16449,16454,16459,16474,16516,16523,16542,16587,16588,16611,16612,16657,16665,16670,16675,16687,16695,16714,16717,16724,16737,16748,16783,16791,16792,16830,16839,16862,16913,16942,16982,16995,17054,17055,17084,17140,17153,17163,17166,17201,17240,17256,17270,17274,17278,17288,17289,17300,17314,17331,17333,17363,17365,17372,17386,17388,17414,17422,17442,17540,17542,17553,17566,17573,17575,17584,17592,17598,17625,17644,17646,17660,17663,17664,17683,17688,17691,17699,17700,17712,17717,17737,17748,17749,17753,17783,17791,17798,17799,17806,17807,17820,17850,17851,17854,17876,17887,17914,17922,17930,17933,17936,17950,17955,17967,17995,17996,18034,18036,18060,18084,18111,18118,18121,18233,18254,18278,18291,18300,18311,18318,18342,18351,18357,18364,18383,18384,18391,18397,18428,18429,18444,18480,18541,18542,18549,18552,18571,18577,18596,18605,18626,18651,18657,18658,18664,18673,18693,18695,18706,18724,18733,18754,18779,18802,18811,18830,18832,18849,18871,18989,19001,19015,19018,19035,19038,19055,19105,19111,19138,19145,19158,19183,19187,19199,19220,19228,19254,19258,19259,19269,19277,19280,19282,19283,19289,19299,19302,19307,19325,19339,19379,19385,19389,19400,19402,19421,19423,19427,19458,19460,19470,19484,19501,19503,19517,19531,19532,19533,19573,19574,19593,19659,19679,19708,19721,19733,19754,19773,19800,19820,19830,19855,19862,19869,19871,19877,19881,19901,19929,19937,19958,19960,19965,19972,19984,19996,20029,20044,20056,20057,20062,20078,20091,20097,20153,20154,20168,20177,20186,20188,20200,20215,20234,20236,20278,20293,20297,20306,20329,20333,20366,20390,20391,20405,20411,20433,20437,20447,20488,20508,20530,20540,20545,20555,20588,20595,20600,20606,20632,20638,20656,20659,20662,20666,20698,20708,20713,20718,20733,20735,20743,20764,20772,20781,20794,20804,20805,20813,20814,20820,20843,20851,20853,20858,20860,20871,20879,20883,20885,20920,20921,20940,20944,20949,20954,20960,20969,20979,20999,21009,21055,21058,21104,21116,21122,21128,21168,21170,21198,21217,21228,21236,21247,21282,21305,21313,21316,21325,21350,21351,21370,21380,21390,21398,21402,21418,21422,21426,21448,21449,21463,21483,21495,21502,21505,21520,21540,21551,21569,21591,21607,21611,21621,21640,21680,21682,21698,21733,21752,21756,21760,21787,21820,21851,21853,21867,21895,21899,21924,21947,21969,21977,21990,22000,22003,22025,22028,22039,22044,22067,22093,22096,22105,22132,22139,22140,22149,22154,22170,22180,22215,22255,22276,22290,22320,22349,22363,22382,22395,22436,22465,22497,22501,22567,22579,22588,22596,22603,22616,22633,22653,22661,22693,22709,22718,22743,22746,22751,22781,22799,22804,22820,22844,22847,22854,22865,22866,22915,22930,23009,23029,23053,23071,23072,23087,23103,23112,23137,23138,23140,23144,23156,23170,23187,23202,23208,23224,23232,23233,23236,23242,23246,23252,23270,23279,23302,23308,23339,23356,23367,23368,23401,23444,23449,23467,23484,23486,23498,23526,23527,23536,23550,23555,23569,23577,23599,23600,23617,23621,23623,23642,23665,23691,23693,23698,23709,23716,23719,23727,23743,23763,23768,23784,23787,23816,23836,23846,23849,23875,23902,23912,23920,23944,23949,23955,23977,24009,24015,24024,24060,24065,24067,24102,24110,24115,24153,24159,24164,24165,24176,24189,24196,24208,24219,24239,24243,24270,24283,24296,24306,24328,24335,24345,24362,24372,24402,24415,24417,24422,24430,24453,24457,24461,24473,24475,24481,24484,24506,24526,24539,24556,24566,24575,24577,24585,24598,24609,24614,24617,24635,24649,24656,24677,24682,24707,24724,24726,24730,24751,24794,24797,24800,24804,24809,24816,24850,24853,24859,24930,24931,24973,25003,25036,25043,25063,25069,25096,25112,25135,25136,25155,25165,25180,25192,25200,25282,25287,25289,25291,25306,25323,25327,25332,25352,25358,25367,25384,25386,25387,25408,25416,25418,25440,25456,25462,25477,25484,25515,25526,25534,25548,25555,25560,25564,25569,25589,25598,25610,25632,25640,25678,25687,25692,25697,25701,25721,25765,25806,25854,25887,25889,25901,25925,25926,25959,26014,26023,26043,26055,26063,26135,26147,26187,26208,26215,26238,26245,26258,26274,26340,26360,26386,26390,26413,26540,26541,26554,26595,26631,26677,26711,26737,26807,26829,26853,26854,26902,26920,26930,26954,26972,27001,27039,27094,27103,27133,27135,27151,27157,27158,27221,27263,27271,27327,27332,27355,27374,27379,27390,27410,27431,27435,27490,27506,27533,27584,27609,27775,27795,27805,27863,27871,27904,27949,27968,27975,27990,27997,28248,28310,28402,28416,28464,28497,28511,28537,28606,28623,28852,28892,28907,28908,28910,28918,28933,28949,28951,28960,28961,28972,28973,29033,29049,29136,29140,29171,29194,29208,29215,29281,29325,29349,29502,29515,29535,29576,29622,29642,29673,29720,29908,29911,29912,29923,29939,29962,30274,30307,30449,31114,31286,31356,31651,31671,31876,32097,32820,32841,33259,33430,33593,33651,33784,33993,34008,34076,34176,34300,34490,34573,34783,35000,35218,35568,35689,35711,35740,35755,35774,35858,35885,36016,36177,36216,36219,36384,36492,36875,37408,37856,38900,38958,38975,38986,39020,39064,39131,39154,39159,39172,39211,40184,40212,40243,40351,40622,40759,40993,41207,41211,41256,41311,41325,41430,42530,42752,42799,44143,44291,44396,44402,44478,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 | 1583 | 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.70 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.31 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.63 ms |
preparing | 1.20 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |