Tiempo de la consulta: 14.62 ms Después de la última consulta: 1.32 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.391 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 05:48:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 05:48:49')
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,74,75,76,77,78,98,117,136,176,178,179,181,198,202,207,208,215,216,221,224,225,254,262,271,280,325,344,350,353,374,376,377,378,379,380,394,432,456,473,474,596,606,608,611,641,642,650,681,686,744,831,832,854,868,875,891,941,942,964,976,1033,1034,1043,1066,1071,1207,1215,1266,1267,1281,1287,1329,1331,1339,1359,1459,1467,1534,1555,1574,1601,1637,1659,1686,1698,1709,1721,1778,1785,1805,1837,1896,1910,1928,1932,2090,2092,2221,2428,2455,2592,2610,2656,2713,2714,2740,2742,2855,2869,2893,3085,3091,3215,3329,3340,3346,3398,3442,3595,3630,3783,3801,3814,3816,3868,3895,3957,3969,4047,4063,4087,4113,4163,4206,4217,4283,4319,4338,4378,4388,4511,4547,4572,4578,4638,4658,4668,4799,4855,4911,4935,4965,5053,5062,5098,5147,5151,5166,5184,5195,5222,5263,5273,5288,5302,5374,5406,5519,5585,5647,5674,5698,5730,5731,5756,5782,5805,5810,5820,5835,5852,5878,5879,5906,5927,5967,5976,6012,6014,6032,6039,6069,6112,6199,6222,6226,6276,6292,6298,6307,6319,6333,6373,6384,6429,6464,6510,6542,6543,6616,6626,6631,6641,6666,6677,6687,6716,6779,6908,6924,6939,6940,6942,6957,6961,6989,7004,7048,7154,7189,7222,7227,7282,7303,7311,7365,7423,7424,7433,7434,7446,7450,7454,7477,7486,7489,7507,7522,7534,7536,7556,7560,7608,7638,7713,7714,7767,7774,7777,7782,7812,7829,7836,7861,7862,7904,7914,7916,7923,7926,7936,7965,7967,7968,7985,8027,8034,8060,8108,8134,8146,8167,8178,8208,8294,8296,8299,8306,8357,8362,8418,8491,8572,8587,8607,8678,8681,8689,8694,8710,8732,8742,8810,8835,8899,8923,8940,8948,8995,9046,9051,9057,9085,9091,9096,9107,9110,9140,9180,9186,9190,9199,9211,9224,9249,9252,9270,9318,9362,9381,9402,9429,9500,9518,9524,9541,9576,9595,9641,9685,9689,9723,9725,9731,9734,9760,9775,9851,9853,9858,9861,9873,9892,9896,9915,9916,9965,9966,9985,10011,10014,10044,10046,10092,10113,10147,10193,10227,10259,10265,10313,10342,10357,10369,10402,10407,10420,10453,10519,10534,10570,10611,10682,10715,10745,10770,10774,10777,10793,10817,10820,10821,10842,10878,10971,11005,11016,11037,11074,11182,11199,11212,11333,11344,11362,11365,11374,11436,11462,11465,11539,11549,11590,11663,11684,11701,11705,11706,11750,11751,11772,11774,11791,11799,11816,11873,11888,11893,11950,11973,11976,11979,12009,12053,12054,12070,12133,12154,12158,12178,12179,12318,12321,12324,12334,12341,12388,12440,12446,12453,12482,12550,12610,12647,12670,12685,12714,12758,12795,12838,12839,12846,12895,12898,12981,12985,12997,12998,13036,13039,13065,13069,13070,13077,13079,13094,13121,13124,13152,13209,13229,13260,13263,13285,13290,13334,13402,13429,13647,13728,13765,13771,13790,13803,13894,13901,14048,14098,14146,14152,14205,14248,14250,14285,14295,14336,14352,14354,14366,14370,14396,14424,14426,14435,14481,14494,14569,14577,14581,14586,14596,14598,14609,14625,14629,14676,14695,14697,14699,14700,14741,14742,14749,14752,14754,14771,14779,14789,14843,14856,14857,14889,14953,14969,14984,15001,15009,15018,15035,15051,15077,15090,15122,15133,15184,15186,15279,15286,15293,15304,15311,15315,15316,15444,15475,15486,15520,15524,15561,15583,15598,15608,15613,15615,15616,15627,15644,15683,15705,15714,15723,15741,15742,15751,15753,15755,15778,15781,15805,15870,15876,15895,15897,15902,15960,15965,15985,15998,16003,16010,16040,16053,16055,16078,16088,16106,16142,16219,16237,16239,16246,16254,16282,16284,16362,16381,16401,16417,16430,16474,16516,16523,16526,16542,16570,16588,16657,16667,16670,16675,16680,16687,16783,16784,16839,16913,16944,16950,16982,17014,17065,17084,17127,17143,17153,17163,17245,17256,17274,17278,17288,17289,17300,17327,17331,17333,17346,17365,17414,17419,17422,17438,17442,17463,17540,17542,17566,17573,17580,17598,17625,17629,17643,17654,17660,17664,17688,17698,17712,17717,17719,17783,17805,17820,17824,17851,17900,17914,17930,17933,17948,17950,17959,17962,17967,17995,18014,18068,18118,18121,18135,18177,18271,18276,18277,18284,18291,18292,18300,18306,18311,18351,18382,18391,18410,18423,18429,18491,18509,18516,18549,18577,18582,18599,18605,18624,18648,18651,18670,18719,18724,18744,18771,18778,18811,18830,18849,18871,18960,18967,18974,19001,19019,19029,19055,19076,19112,19138,19145,19151,19242,19254,19259,19277,19286,19288,19316,19325,19340,19342,19359,19401,19417,19430,19432,19460,19466,19501,19533,19543,19548,19574,19607,19679,19715,19733,19742,19758,19770,19773,19777,19783,19799,19830,19842,19855,19869,19871,19877,19881,19901,19920,19958,19960,19965,19972,19984,19996,20025,20091,20150,20168,20200,20295,20325,20390,20405,20433,20437,20447,20488,20540,20545,20555,20588,20598,20637,20641,20666,20698,20704,20708,20713,20715,20718,20772,20776,20781,20794,20807,20814,20816,20832,20877,20887,20897,20940,20960,20979,21013,21058,21066,21072,21090,21122,21170,21173,21174,21186,21191,21198,21229,21247,21305,21308,21310,21325,21340,21345,21350,21356,21358,21370,21380,21398,21435,21443,21448,21449,21488,21490,21502,21530,21551,21552,21560,21591,21607,21616,21640,21660,21675,21680,21759,21818,21842,21867,21895,21924,21990,22000,22037,22039,22044,22067,22093,22096,22132,22139,22156,22170,22180,22211,22215,22255,22276,22320,22337,22349,22352,22362,22363,22382,22400,22436,22450,22465,22497,22501,22551,22573,22579,22588,22606,22609,22615,22634,22676,22693,22709,22737,22741,22746,22751,22767,22781,22797,22804,22820,22855,22866,22915,22930,22941,22963,23009,23029,23066,23072,23087,23103,23112,23115,23137,23144,23156,23165,23215,23232,23242,23252,23257,23270,23277,23279,23308,23313,23367,23368,23401,23404,23444,23482,23484,23498,23555,23576,23577,23599,23621,23623,23642,23665,23682,23691,23693,23695,23709,23716,23719,23731,23768,23787,23788,23836,23846,23849,23866,23879,23902,23906,23912,23920,23943,23944,23949,24009,24015,24024,24060,24107,24110,24115,24159,24164,24172,24179,24196,24239,24248,24270,24296,24306,24335,24353,24362,24417,24422,24430,24434,24453,24458,24461,24474,24475,24506,24556,24575,24592,24617,24635,24649,24656,24677,24707,24721,24724,24726,24730,24738,24766,24784,24794,24816,24850,24880,24894,24896,24927,24931,24947,24967,24993,25001,25003,25013,25036,25040,25043,25069,25091,25094,25114,25136,25167,25192,25200,25260,25282,25287,25291,25296,25321,25327,25332,25352,25367,25371,25372,25384,25386,25387,25390,25391,25393,25408,25414,25416,25431,25433,25440,25446,25451,25457,25459,25464,25465,25467,25468,25472,25476,25477,25482,25484,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25515,25517,25526,25536,25537,25538,25540,25545,25546,25548,25552,25555,25559,25560,25569,25572,25576,25578,25582,25587,25588,25596,25611,25640,25674,25687,25692,25697,25701,25765,25802,25806,25854,25887,25889,25897,25929,25937,25941,25953,25959,25963,25964,25979,26001,26023,26043,26044,26047,26055,26093,26128,26274,26340,26362,26390,26393,26413,26448,26506,26530,26554,26572,26577,26578,26595,26653,26683,26694,26741,26785,26787,26796,26803,26841,26853,26899,26930,26962,26990,27001,27067,27087,27095,27123,27152,27263,27271,27319,27325,27342,27374,27379,27399,27435,27506,27584,27694,27757,27795,27944,27949,27968,27971,27973,27990,28004,28139,28160,28200,28440,28441,28511,28534,28537,28606,28623,28635,28741,28751,28852,28870,28899,28930,28933,28949,29222,29325,29622,29719,29840,29848,29884,29911,29923,29962,30222,30274,31286,31377,31463,31533,31725,31942,31975,32820,33605,34030,34071,34159,34243,34262,34270,34375,34611,34956,35000,35245,35266,35643,35711,35740,35774,35822,35831,35858,35881,36007,36143,36216,36251,36294,36339,36382,36492,36617,36620,36838,36875,37002,37056,37186,37187,37287,37411,37422,37524,37532,37688,37758,37796,37987,38071,38199,38363,38452,38585,38664,38665,38719,38762,38903,38933,38958,38975,39020,39064,39159,39227,39231,39335,39397,39480,39488,39570,39687,39769,39826,39891,39896,39897,39918,39958,39964,39977,40025,40082,40183,40184,40292,40343,40351,40356,40367,40435,40530,40650,40703,40759,41070,41095,41134,41188,41204,41304,41325,41464,41502,41503,41601,41677,41681,41778,41844,41856,41861,42107,42185,42205,42387,42396,42590,42639,42708,42716,42836,42890,42900,42952,42991,42993,42998,43050,43051,43078,43105,43114,43120,43191,43218,43247,43248,43274,43291,43300,43301,43335,43360,43365,43386,43398,43412,43424,43528,43546,43599,43651,43688,43700,43716,43725,43885,44013,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44200,44208,44226,44229,44263,44282,44312,44327,44382,44387,44406,44422,44447,44453,44458,44479,44487,44500,44517,44562,44609,44662,44682,44761,44762,44786,44797,44950,45008,45024,45050,45086,45106,45131,45152,45183,45196,45208,45209,45257,45275,45309)
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 | 1483 | 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.88 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.08 ms |
init | 0.54 ms |
System lock | 0.06 ms |
optimizing | 0.10 ms |
statistics | 3.55 ms |
preparing | 2.05 ms |
Sorting result | 0.02 ms |
executing | 0.06 ms |
Sending data | 6.32 ms |
end | 0.02 ms |
query end | 0.05 ms |
closing tables | 0.02 ms |
freeing items | 0.10 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 |