Tiempo de la consulta: 5.04 ms Después de la última consulta: 1.19 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.356 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-06 12:14:51')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 12:14:51')
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(8,43,49,74,75,76,77,78,83,113,114,117,136,137,202,207,208,271,280,281,316,344,349,350,353,362,368,374,376,377,378,379,380,398,456,522,608,611,621,686,693,728,744,752,784,825,831,868,891,931,941,942,963,964,976,980,986,1033,1043,1207,1215,1273,1287,1318,1329,1339,1344,1364,1371,1428,1440,1459,1461,1541,1556,1601,1649,1673,1690,1698,1709,1782,1823,1827,2000,2110,2115,2207,2332,2357,2540,2656,2713,2714,2720,2728,2729,2735,2742,2765,2870,2896,2901,2922,2939,2957,2991,3033,3040,3091,3117,3177,3215,3257,3329,3332,3340,3397,3442,3478,3567,3574,3668,3759,3783,3814,3816,3838,3870,3881,3895,3934,3957,4015,4019,4062,4087,4103,4172,4206,4319,4371,4378,4638,4690,4693,4745,4856,4896,5052,5053,5233,5285,5633,5647,5710,5729,5730,5827,5840,5933,6039,6047,6051,6094,6176,6203,6211,6267,6283,6284,6292,6298,6333,6384,6422,6438,6445,6453,6464,6501,6567,6583,6616,6619,6631,6687,6802,6825,6832,6908,6940,6942,6950,6957,6961,6989,7002,7154,7175,7189,7219,7225,7280,7282,7303,7311,7387,7402,7403,7410,7412,7434,7450,7454,7486,7522,7556,7584,7614,7626,7638,7670,7678,7713,7766,7774,7823,7829,7836,7849,7861,7862,7890,7914,7916,7923,7951,7965,7967,7970,7985,8027,8107,8108,8134,8141,8169,8177,8183,8189,8204,8205,8223,8236,8245,8246,8247,8315,8320,8355,8380,8401,8426,8471,8495,8521,8537,8565,8569,8571,8602,8626,8630,8694,8757,8816,8838,8839,8845,8877,8888,8912,8921,8952,8983,8986,9057,9058,9070,9091,9131,9136,9158,9164,9249,9318,9401,9429,9442,9487,9564,9723,9725,9752,9818,9842,9861,9916,9966,9985,10011,10017,10092,10110,10120,10144,10181,10187,10193,10227,10259,10265,10313,10315,10317,10318,10340,10357,10369,10370,10375,10376,10392,10399,10415,10444,10453,10491,10534,10561,10596,10611,10673,10682,10777,10798,10820,10821,10860,10896,10908,10938,10939,10948,10953,10970,10971,10975,10991,11005,11037,11060,11074,11075,11093,11120,11165,11186,11188,11235,11252,11255,11285,11292,11333,11343,11361,11362,11365,11371,11491,11539,11611,11626,11629,11648,11661,11663,11726,11729,11737,11738,11739,11773,11779,11783,11789,11799,11800,11816,11893,11922,11938,11950,11967,11976,12002,12009,12070,12081,12082,12094,12118,12133,12178,12179,12219,12233,12243,12283,12326,12339,12356,12364,12384,12388,12446,12465,12511,12513,12520,12526,12610,12670,12685,12752,12758,12811,12838,12846,12873,12898,12907,12985,13002,13006,13035,13036,13041,13056,13079,13110,13124,13125,13137,13150,13152,13153,13207,13217,13229,13285,13334,13353,13375,13377,13390,13466,13476,13497,13554,13585,13613,13647,13685,13771,13790,13805,13817,13835,13900,13901,13906,13953,14002,14024,14038,14098,14113,14143,14152,14205,14218,14223,14248,14250,14283,14285,14287,14336,14352,14354,14370,14382,14386,14396,14424,14426,14457,14468,14481,14530,14540,14558,14571,14596,14610,14612,14625,14629,14642,14643,14676,14695,14697,14700,14749,14754,14771,14775,14789,14791,14843,14847,14856,14873,14915,14960,14984,15003,15010,15018,15035,15040,15110,15117,15119,15138,15177,15231,15286,15304,15315,15316,15400,15444,15475,15486,15501,15520,15522,15552,15581,15596,15608,15616,15655,15704,15714,15723,15730,15742,15755,15791,15805,15876,15888,15897,15903,15965,16053,16058,16066,16088,16250,16254,16271,16282,16316,16324,16362,16365,16381,16394,16417,16423,16430,16439,16446,16447,16450,16474,16516,16523,16541,16542,16622,16644,16646,16657,16670,16675,16687,16695,16724,16736,16783,16806,16814,16815,16818,16831,16839,16844,16866,16898,16935,16942,16982,16985,17011,17047,17084,17090,17108,17143,17153,17163,17190,17194,17201,17240,17247,17256,17274,17278,17288,17289,17291,17292,17300,17331,17333,17365,17376,17386,17410,17414,17417,17422,17452,17456,17469,17487,17503,17514,17518,17536,17540,17542,17553,17566,17573,17575,17588,17598,17625,17628,17630,17636,17660,17664,17688,17712,17717,17725,17734,17753,17783,17820,17838,17845,17850,17851,17868,17887,17896,17914,17922,17930,17933,17949,17950,17955,17967,17989,17990,17995,17996,18060,18088,18118,18121,18134,18136,18139,18186,18278,18291,18300,18311,18351,18391,18397,18428,18429,18447,18490,18541,18549,18552,18571,18577,18605,18626,18651,18693,18706,18708,18716,18724,18770,18811,18828,18830,18849,18871,18881,18882,18909,18957,18989,19001,19017,19031,19055,19114,19131,19138,19145,19184,19220,19221,19254,19259,19277,19311,19325,19330,19339,19367,19379,19400,19413,19460,19490,19501,19517,19520,19529,19531,19555,19574,19644,19659,19679,19733,19754,19773,19830,19855,19869,19871,19877,19881,19883,19901,19929,19958,19960,19965,19972,19984,19996,20041,20056,20063,20067,20091,20095,20097,20111,20154,20156,20158,20168,20170,20176,20186,20200,20239,20297,20333,20345,20362,20366,20390,20405,20411,20420,20424,20433,20437,20447,20450,20457,20483,20488,20540,20545,20555,20588,20632,20644,20654,20666,20698,20708,20718,20772,20781,20794,20805,20814,20854,20885,20888,20940,20960,20979,21009,21055,21058,21098,21104,21115,21116,21122,21128,21170,21198,21218,21228,21247,21255,21295,21305,21307,21316,21325,21350,21370,21376,21380,21390,21398,21418,21448,21449,21463,21495,21520,21540,21551,21591,21607,21611,21628,21640,21680,21682,21689,21707,21716,21720,21853,21867,21895,21924,21947,21956,21964,21977,21990,22000,22003,22039,22044,22067,22071,22075,22093,22096,22100,22132,22138,22139,22154,22170,22180,22215,22255,22276,22316,22320,22344,22349,22363,22382,22395,22427,22436,22445,22465,22497,22501,22525,22579,22588,22596,22616,22619,22623,22653,22654,22661,22669,22689,22693,22709,22718,22746,22751,22781,22799,22804,22820,22866,22915,22917,22930,22936,23009,23029,23057,23071,23072,23087,23103,23112,23137,23140,23144,23156,23232,23236,23242,23252,23270,23279,23302,23308,23332,23339,23367,23368,23377,23401,23414,23431,23444,23449,23484,23498,23527,23550,23555,23577,23599,23621,23623,23627,23642,23657,23665,23682,23691,23693,23698,23709,23716,23719,23726,23727,23728,23741,23743,23768,23784,23787,23801,23816,23836,23846,23849,23882,23884,23902,23912,23920,23944,23949,23973,24009,24015,24024,24060,24065,24100,24102,24110,24115,24143,24159,24164,24182,24184,24196,24239,24270,24283,24296,24306,24335,24362,24372,24402,24417,24422,24430,24453,24457,24461,24473,24475,24489,24506,24556,24575,24577,24617,24619,24620,24635,24649,24656,24677,24707,24724,24726,24730,24751,24794,24800,24809,24816,24850,24859,24912,24930,24931,24998,25003,25036,25043,25063,25069,25096,25112,25136,25155,25165,25180,25192,25200,25282,25287,25291,25327,25332,25352,25358,25367,25384,25386,25387,25408,25416,25418,25440,25441,25462,25477,25484,25515,25526,25548,25555,25560,25564,25589,25640,25687,25692,25697,25701,25765,25806,25854,25887,25889,25926,25959,26023,26038,26043,26048,26055,26063,26258,26274,26298,26340,26390,26413,26540,26541,26595,26659,26711,26771,26807,26853,26915,26930,26963,27001,27039,27094,27184,27221,27263,27271,27327,27352,27374,27379,27412,27435,27506,27531,27584,27795,27871,27898,27901,27949,27968,27975,27990,28464,28511,28537,28606,28623,28852,28892,28907,28908,28933,28949,28951,28972,28973,29049,29140,29171,29194,29208,29325,29349,29535,29576,29622,29642,29673,29911,29912,29923,29939,29962,30274,30449,31286,32820,35000,35135,35366,35588,35711,35740,35774,35834,35857,35858,35886,35891,35922,35972,36216,36364,36492,36707,36875,37576,37851,38855,38900,38958,38975,38986,39020,39064,39112,39131,39159,39172,39773,40184,40351,40483,40759,40789,40835,40993,41025,41211,41325,42284,42494,42833,43360,43543,45141,45240,45252)
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 | 1287 | 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.67 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.27 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.99 ms |
preparing | 0.95 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.33 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |