Tiempo de la consulta: 22.88 ms Después de la última consulta: 1.72 ms Consulta a la memoria: 2.721 MB memoria antes de la consulta: 4.390 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 09:31:21')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 09:31:21')
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(49,62,64,74,75,76,77,78,117,136,157,163,174,193,202,207,208,218,257,271,275,280,311,344,350,353,357,374,376,377,378,379,380,401,456,466,471,482,499,543,560,608,610,611,635,643,661,680,685,686,692,700,703,709,713,736,744,761,772,783,786,831,859,868,891,941,942,960,964,968,976,984,998,1024,1032,1033,1034,1042,1043,1048,1079,1098,1106,1127,1138,1142,1150,1151,1172,1182,1192,1194,1207,1215,1226,1255,1269,1271,1279,1280,1287,1289,1295,1305,1322,1329,1339,1346,1349,1375,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1455,1459,1460,1466,1476,1481,1484,1534,1538,1553,1586,1595,1601,1624,1664,1666,1698,1709,1811,1812,1841,1852,1855,1870,1903,1906,1919,1984,2001,2013,2077,2148,2177,2188,2193,2199,2301,2359,2392,2408,2432,2469,2480,2629,2631,2647,2656,2691,2713,2714,2724,2742,2773,2954,2989,3054,3055,3056,3091,3109,3119,3174,3180,3202,3215,3278,3329,3340,3355,3364,3442,3451,3454,3513,3571,3590,3594,3663,3783,3814,3816,3836,3848,3870,3872,3895,3938,3957,3992,4012,4075,4087,4129,4132,4166,4168,4176,4197,4206,4252,4271,4319,4378,4409,4477,4523,4524,4525,4539,4558,4580,4585,4586,4587,4605,4638,4665,4699,4713,4758,4767,4795,4822,4823,4863,4874,4892,4919,4960,5014,5035,5076,5079,5143,5157,5161,5166,5226,5247,5250,5317,5396,5430,5435,5472,5478,5496,5507,5508,5534,5642,5647,5659,5686,5700,5730,5876,5881,5886,5936,5990,6007,6039,6056,6064,6068,6081,6088,6133,6200,6202,6217,6292,6298,6308,6323,6328,6333,6384,6396,6421,6461,6464,6465,6472,6480,6512,6520,6533,6545,6553,6596,6616,6631,6648,6663,6667,6687,6707,6778,6842,6908,6922,6932,6940,6942,6957,6961,6988,6989,7013,7014,7154,7182,7186,7189,7200,7237,7246,7256,7272,7276,7277,7282,7303,7311,7320,7336,7358,7410,7421,7434,7435,7437,7439,7450,7454,7486,7522,7556,7611,7626,7631,7638,7688,7709,7713,7720,7748,7756,7765,7769,7774,7802,7824,7829,7830,7834,7836,7839,7845,7860,7861,7862,7868,7870,7878,7897,7914,7916,7923,7931,7946,7951,7965,7967,7985,8012,8027,8061,8069,8090,8091,8099,8108,8116,8134,8206,8230,8283,8341,8361,8400,8442,8457,8466,8518,8572,8627,8641,8694,8695,8760,8778,8807,8907,8938,8944,9029,9057,9087,9091,9108,9122,9132,9154,9204,9249,9318,9324,9364,9429,9434,9449,9462,9484,9538,9548,9554,9562,9675,9690,9717,9723,9725,9773,9861,9870,9879,9916,9924,9966,9985,10011,10092,10193,10227,10259,10265,10307,10313,10316,10357,10358,10369,10371,10373,10453,10475,10501,10534,10553,10611,10616,10630,10682,10694,10725,10736,10749,10775,10777,10783,10820,10821,10834,10851,10958,10971,11005,11037,11059,11182,11195,11223,11258,11314,11333,11362,11365,11402,11428,11431,11446,11539,11573,11663,11705,11795,11799,11816,11842,11859,11885,11893,11899,11929,11950,11976,12009,12070,12089,12133,12170,12178,12179,12218,12238,12331,12334,12388,12401,12439,12440,12446,12463,12474,12610,12617,12620,12622,12625,12670,12685,12686,12758,12810,12816,12822,12838,12846,12853,12875,12898,12901,12944,12946,12985,12994,13036,13059,13078,13079,13124,13160,13229,13246,13258,13266,13272,13285,13294,13297,13298,13316,13334,13344,13428,13436,13437,13438,13458,13467,13478,13479,13480,13481,13482,13502,13503,13525,13589,13597,13647,13660,13687,13697,13698,13742,13771,13784,13790,13794,13797,13804,13824,13901,13961,13963,13968,13990,14074,14082,14098,14117,14140,14152,14153,14177,14205,14244,14248,14250,14262,14273,14285,14309,14336,14352,14354,14370,14396,14424,14426,14429,14432,14440,14456,14481,14493,14506,14507,14546,14596,14625,14629,14641,14646,14676,14678,14683,14695,14697,14698,14700,14710,14749,14754,14759,14771,14789,14794,14843,14856,14864,14874,14916,14958,14964,14983,14984,14992,15018,15032,15035,15037,15048,15063,15094,15108,15111,15129,15138,15139,15147,15213,15216,15229,15286,15304,15315,15316,15359,15370,15382,15420,15444,15464,15471,15475,15486,15492,15520,15543,15548,15551,15575,15577,15598,15608,15616,15632,15644,15645,15681,15714,15722,15723,15725,15742,15755,15757,15759,15778,15782,15805,15829,15876,15897,15935,15982,16000,16052,16053,16088,16092,16093,16100,16140,16153,16161,16206,16216,16254,16258,16271,16282,16326,16348,16362,16373,16374,16381,16385,16386,16417,16430,16458,16459,16466,16474,16516,16523,16529,16534,16542,16569,16586,16607,16629,16634,16657,16658,16670,16675,16687,16709,16774,16780,16783,16791,16832,16839,16889,16929,16981,16982,16987,16991,17084,17121,17126,17128,17131,17153,17163,17177,17215,17224,17256,17257,17273,17274,17278,17282,17288,17289,17300,17331,17333,17355,17365,17381,17382,17383,17384,17414,17422,17432,17478,17484,17540,17541,17542,17555,17566,17573,17596,17598,17625,17634,17645,17658,17660,17664,17667,17688,17699,17702,17712,17717,17733,17757,17766,17780,17783,17799,17818,17820,17840,17851,17864,17892,17895,17914,17921,17927,17930,17933,17950,17961,17967,17980,17995,18006,18013,18031,18037,18039,18055,18094,18118,18121,18160,18174,18181,18202,18267,18284,18290,18291,18300,18311,18326,18351,18369,18382,18384,18391,18429,18442,18466,18498,18512,18540,18549,18550,18561,18577,18596,18605,18612,18651,18682,18724,18739,18811,18813,18814,18830,18847,18849,18869,18871,18901,18904,18910,18916,18920,18942,18977,18982,18990,18991,18995,19000,19001,19022,19043,19055,19069,19083,19091,19110,19112,19124,19132,19135,19136,19138,19145,19149,19196,19247,19254,19259,19270,19277,19294,19307,19313,19325,19335,19343,19350,19366,19383,19407,19412,19446,19453,19460,19501,19505,19512,19524,19574,19581,19595,19596,19608,19612,19640,19650,19655,19661,19679,19684,19700,19704,19718,19733,19753,19773,19797,19815,19816,19830,19832,19853,19855,19867,19869,19871,19877,19881,19894,19901,19930,19932,19933,19941,19958,19960,19965,19972,19979,19983,19984,19991,19996,20004,20030,20034,20036,20043,20051,20056,20069,20091,20142,20145,20168,20181,20183,20199,20200,20202,20208,20242,20265,20344,20354,20358,20363,20374,20390,20403,20404,20405,20433,20437,20440,20447,20452,20488,20540,20545,20555,20568,20569,20578,20588,20602,20636,20638,20649,20659,20666,20698,20708,20718,20739,20755,20768,20772,20773,20781,20794,20797,20803,20814,20826,20856,20871,20933,20940,20950,20960,20979,20996,21000,21058,21118,21122,21161,21170,21178,21189,21197,21198,21205,21241,21242,21247,21252,21280,21284,21305,21323,21325,21350,21370,21380,21398,21408,21411,21433,21437,21438,21448,21449,21458,21464,21491,21522,21527,21546,21551,21586,21591,21593,21601,21607,21611,21620,21640,21680,21691,21714,21737,21779,21821,21867,21895,21924,21952,21957,21990,22000,22011,22039,22044,22059,22067,22093,22096,22100,22132,22139,22170,22173,22180,22215,22244,22245,22246,22255,22276,22320,22349,22363,22382,22400,22415,22416,22419,22435,22436,22455,22464,22465,22492,22497,22500,22501,22502,22517,22527,22579,22588,22600,22653,22668,22673,22693,22708,22709,22710,22715,22722,22742,22751,22756,22781,22803,22804,22820,22848,22864,22866,22872,22874,22915,22930,23000,23009,23022,23029,23031,23032,23034,23039,23040,23060,23072,23081,23087,23101,23103,23112,23114,23122,23137,23144,23148,23156,23196,23200,23219,23221,23232,23234,23242,23247,23250,23252,23270,23277,23279,23284,23286,23296,23308,23313,23344,23367,23368,23375,23394,23401,23406,23444,23453,23467,23484,23498,23516,23546,23547,23550,23555,23559,23564,23577,23592,23593,23599,23619,23621,23623,23634,23638,23642,23665,23668,23682,23693,23695,23701,23703,23709,23715,23716,23719,23722,23747,23767,23768,23769,23772,23787,23836,23846,23849,23857,23860,23868,23874,23902,23912,23920,23922,23930,23944,23949,23954,23959,23962,23967,23984,24009,24010,24015,24017,24024,24052,24060,24072,24075,24076,24110,24111,24115,24141,24159,24164,24170,24174,24196,24198,24230,24239,24270,24296,24306,24321,24335,24346,24362,24392,24417,24422,24430,24441,24447,24453,24455,24461,24506,24523,24524,24556,24567,24575,24599,24607,24616,24617,24635,24649,24656,24673,24677,24707,24724,24726,24727,24730,24784,24788,24794,24816,24819,24823,24838,24844,24850,24857,24875,24884,24924,24931,24966,24968,24977,25003,25010,25036,25039,25043,25069,25096,25126,25136,25141,25172,25192,25197,25200,25273,25278,25282,25284,25287,25291,25292,25317,25326,25327,25332,25333,25349,25352,25360,25367,25373,25374,25384,25386,25387,25406,25408,25416,25421,25440,25477,25484,25515,25526,25534,25542,25548,25555,25560,25609,25621,25624,25639,25640,25655,25687,25692,25693,25697,25701,25705,25709,25717,25764,25765,25792,25798,25806,25854,25881,25887,25889,25943,25959,25964,25987,26023,26043,26055,26107,26109,26122,26154,26166,26167,26171,26176,26274,26340,26348,26353,26361,26390,26413,26454,26468,26522,26530,26564,26595,26722,26753,26767,26779,26797,26800,26807,26816,26852,26853,26909,26910,26926,26930,26944,26945,26950,26951,26982,27001,27026,27035,27046,27054,27131,27151,27186,27237,27263,27271,27274,27280,27311,27356,27363,27374,27379,27383,27414,27415,27435,27438,27452,27491,27506,27558,27572,27584,27610,27742,27779,27795,27859,27891,27949,27968,27990,28005,28189,28233,28306,28397,28424,28511,28537,28598,28606,28623,28628,28716,28746,28780,28824,28845,28852,28933,28949,29021,29089,29124,29256,29325,29358,29373,29548,29617,29622,29810,29864,29911,29919,29923,29930,29962,30274,30562,31227,31286,31384,31499,31516,32250,32302,32381,32507,32530,32590,32820,32843,32896,32919,32943,33040,33129,33199,33345,33649,33815,34078,34099,34109,34174,34179,34184,34229,34241,34258,34260,34269,34292,34326,34343,34357,34676,35000,35102,35226,35299,35337,35360,35379,35434,35596,35711,35740,35774,35780,35858,36085,36200,36216,36297,36492,36751,36817,36875,36893,36916,36918,36961,37034,37107,37116,37170,37315,37380,37397,37403,37439,37454,37874,37996,38006,38056,38066,38103,38114,38122,38128,38315,38343,38361,38398,38440,38446,38452,38455,38530,38549,38674,38734,38775,38812,38958,38975,39020,39027,39052,39064,39150,39159,39163,39193,39245,39276,39307,39315,39319,39347,39358,39375,39389,39452,39475,39492,39504,39516,39609,39706,39722,39747,39768,39802,39966,40018,40089,40169,40184,40231,40276,40312,40313,40314,40351,40360,40398,40436,40438,40460,40465,40535,40542,40554,40555,40562,40614,40667,40688,40759,40774,40801,40811,40817,40822,40850,40959,40990,41036,41040,41063,41068,41150,41220,41246,41322,41325,41402,41418,41423,41436,41499,41570,41576,41649,41724,41797,41800,41811,41839,41865,41871,41879,41885,41896,41927,41956,41957,42040,42054,42057,42065,42091,42134,42154,42163,42174,42188,42212,42304,42405,42448,42460,42489,42490,42538,42572,42703,42729,42765,42800,42806,42863,43009,43115,43136,43143,43222,43234,43244,43294,43345,43459,43508,43509,43539,43550,43565,43596,43601,43605,43615,43680,43682,43705,43706,43707,43846,43914,43915,43917,43979,44026,44031,44041,44177,44184,44351,44400,44431,44491,44497,44544,44588,44611,44613,44681,44701,44894,44908,44941,45051,45115,45136,45157,45160,45206,45252,45302,45303)
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 | 1865 | 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.82 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.32 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 2.79 ms |
preparing | 1.42 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 16.53 ms |
end | 0.07 ms |
query end | 0.06 ms |
closing tables | 0.02 ms |
freeing items | 0.25 ms |
cleaning up | 0.09 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 |