Tiempo de la consulta: 5.12 ms Después de la última consulta: 1.27 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 4.375 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-05 08:14:16')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 08:14:16')
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(23,49,60,78,113,114,117,136,178,179,202,207,208,271,274,280,344,349,350,353,374,376,377,378,379,380,382,456,466,608,611,667,686,693,831,868,891,941,964,976,986,998,1033,1043,1207,1215,1273,1287,1304,1317,1329,1339,1601,1698,1709,1720,1809,1891,1984,2027,2078,2109,2388,2656,2714,2742,2767,2769,2799,2901,2971,2991,3091,3117,3161,3202,3215,3308,3329,3340,3570,3617,3639,3668,3682,3715,3762,3783,3795,3816,3833,3870,3895,3957,3974,4087,4114,4206,4285,4306,4310,4319,4378,4638,4930,5000,5026,5484,5525,5530,5537,5625,5700,5730,5758,5809,5849,5874,5908,5924,5934,5947,5950,5986,5989,5990,5991,6012,6020,6022,6073,6079,6083,6108,6110,6112,6132,6138,6222,6292,6319,6333,6384,6432,6464,6504,6608,6610,6611,6631,6659,6687,6833,6886,6887,6908,6925,6933,6940,6942,6945,6957,6961,6989,7146,7154,7162,7163,7164,7200,7251,7264,7280,7282,7303,7311,7343,7367,7387,7402,7403,7410,7434,7436,7447,7450,7454,7522,7550,7556,7614,7621,7626,7638,7679,7713,7774,7792,7810,7829,7836,7840,7854,7862,7866,7890,7916,7923,7965,7967,7985,8045,8083,8088,8089,8107,8108,8177,8261,8263,8397,8430,8441,8555,8567,8647,8694,8696,8723,8756,8841,8879,8903,8962,8971,9023,9040,9057,9126,9249,9304,9318,9326,9387,9429,9515,9665,9723,9725,9738,9833,9861,9966,9985,10011,10033,10092,10110,10111,10120,10160,10163,10169,10181,10227,10228,10259,10265,10272,10313,10318,10357,10369,10370,10399,10415,10427,10443,10444,10453,10484,10512,10534,10554,10607,10611,10661,10771,10777,10798,10820,10821,10971,11005,11006,11115,11137,11188,11235,11333,11362,11365,11417,11427,11539,11553,11663,11716,11726,11779,11781,11799,11816,11828,11868,11893,11922,11925,11950,11976,12009,12019,12077,12081,12178,12179,12243,12265,12388,12446,12465,12520,12670,12675,12685,12692,12758,12838,12873,12898,12907,12922,12933,12939,12985,13006,13015,13019,13035,13036,13041,13079,13129,13137,13145,13229,13231,13248,13285,13312,13323,13334,13390,13466,13497,13551,13604,13617,13647,13701,13805,13817,13835,13851,13855,13861,13901,13906,13953,14024,14098,14113,14141,14143,14152,14180,14205,14223,14246,14248,14250,14266,14283,14336,14352,14354,14375,14396,14398,14424,14426,14478,14491,14530,14531,14558,14571,14596,14613,14624,14625,14629,14632,14655,14676,14695,14701,14751,14754,14760,14775,14789,14843,14856,14984,15002,15010,15018,15046,15048,15094,15214,15231,15262,15273,15281,15286,15287,15298,15304,15314,15315,15316,15324,15351,15398,15426,15444,15475,15520,15522,15552,15581,15582,15606,15608,15616,15642,15655,15677,15704,15714,15723,15726,15730,15742,15749,15750,15755,15778,15805,15876,15897,15899,15949,15953,15965,16038,16053,16058,16088,16236,16250,16254,16305,16316,16322,16324,16362,16366,16381,16417,16430,16464,16474,16486,16497,16523,16542,16564,16571,16623,16648,16657,16670,16673,16675,16695,16724,16742,16783,16793,16795,16839,16903,16924,16942,16963,16982,16995,17066,17084,17088,17156,17163,17201,17240,17256,17266,17270,17288,17293,17300,17346,17365,17386,17406,17411,17420,17422,17431,17542,17553,17566,17573,17575,17618,17620,17625,17630,17660,17688,17698,17712,17715,17717,17753,17759,17783,17820,17842,17846,17850,17887,17911,17914,17922,17930,17933,17950,17955,17967,17996,18008,18038,18060,18102,18109,18118,18121,18128,18184,18234,18278,18300,18347,18391,18397,18428,18429,18453,18494,18517,18541,18552,18571,18605,18625,18626,18666,18678,18693,18698,18699,18706,18718,18755,18778,18811,18826,18830,18849,18851,18864,18871,18876,18891,18892,18905,18906,18907,18917,18929,18931,18934,18938,18940,18945,18956,18985,19000,19001,19046,19055,19145,19149,19163,19191,19197,19220,19254,19259,19277,19325,19354,19368,19379,19422,19504,19517,19531,19548,19553,19558,19571,19574,19580,19589,19626,19659,19679,19693,19705,19754,19773,19807,19808,19809,19818,19830,19845,19855,19857,19865,19871,19877,19879,19881,19901,19903,19919,19929,19946,19948,19951,19965,19972,19978,19984,19996,20018,20020,20024,20081,20089,20097,20105,20139,20154,20186,20215,20226,20294,20297,20312,20333,20353,20359,20366,20371,20388,20390,20405,20411,20431,20433,20436,20437,20447,20488,20498,20513,20523,20535,20545,20588,20596,20608,20632,20672,20698,20708,20718,20721,20772,20777,20781,20784,20794,20805,20814,20870,20885,20906,20940,20960,20979,21009,21055,21074,21104,21110,21116,21122,21128,21135,21160,21170,21198,21228,21231,21247,21305,21316,21325,21339,21350,21370,21380,21390,21398,21418,21448,21449,21463,21495,21505,21510,21512,21520,21540,21551,21591,21607,21611,21640,21671,21680,21682,21733,21765,21816,21833,21853,21867,21878,21895,21924,21947,21977,21990,22003,22027,22039,22044,22067,22096,22114,22122,22132,22144,22154,22160,22169,22170,22185,22205,22209,22215,22216,22254,22255,22273,22276,22277,22305,22311,22312,22320,22349,22362,22363,22365,22382,22383,22395,22430,22436,22465,22501,22579,22588,22591,22596,22605,22616,22651,22653,22661,22693,22706,22709,22718,22746,22751,22781,22799,22804,22820,22850,22866,22877,22915,22926,22930,22998,23009,23029,23071,23072,23076,23087,23103,23137,23139,23140,23156,23189,23209,23232,23236,23242,23252,23263,23270,23271,23279,23302,23306,23307,23308,23339,23367,23368,23393,23401,23402,23428,23444,23449,23458,23484,23494,23511,23527,23550,23555,23577,23584,23589,23611,23621,23623,23642,23665,23682,23689,23691,23693,23698,23709,23716,23719,23727,23732,23743,23768,23770,23784,23786,23816,23846,23849,23883,23892,23895,23902,23911,23912,23917,23920,23941,23944,23949,23957,23994,24009,24014,24015,24020,24024,24060,24064,24065,24086,24102,24110,24114,24115,24159,24164,24190,24196,24239,24270,24280,24283,24296,24297,24298,24306,24317,24335,24339,24362,24372,24382,24387,24396,24402,24415,24422,24423,24424,24430,24431,24451,24453,24457,24471,24473,24475,24486,24506,24536,24553,24554,24556,24559,24571,24574,24575,24577,24590,24617,24635,24641,24650,24656,24677,24684,24691,24707,24724,24726,24751,24756,24774,24777,24783,24794,24800,24807,24809,24812,24816,24822,24831,24856,24859,24930,24931,25022,25036,25043,25049,25063,25096,25111,25112,25136,25155,25165,25176,25180,25200,25215,25273,25274,25281,25282,25287,25291,25297,25327,25332,25348,25352,25358,25361,25367,25384,25386,25394,25408,25416,25418,25440,25452,25462,25477,25484,25515,25526,25548,25555,25560,25564,25580,25589,25592,25603,25640,25650,25655,25657,25671,25672,25676,25680,25681,25687,25692,25696,25697,25699,25711,25724,25752,25755,25765,25799,25806,25807,25820,25847,25854,25884,25887,25889,25907,25908,25909,25926,25935,25947,25948,25958,25959,25967,25971,26023,26030,26043,26055,26063,26064,26133,26177,26190,26193,26225,26230,26239,26250,26258,26274,26292,26340,26390,26409,26413,26431,26443,26456,26507,26508,26529,26530,26531,26540,26541,26543,26558,26559,26571,26582,26595,26596,26605,26651,26664,26678,26685,26711,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26807,26809,26818,26853,26859,26860,26875,26896,26937,26976,26991,27001,27025,27028,27039,27045,27056,27060,27082,27094,27096,27097,27155,27208,27217,27221,27223,27248,27249,27261,27318,27327,27374,27379,27417,27422,27478,27499,27506,27512,27544,27567,27584,27589,27591,27634,27737,27738,27763,27789,27795,27811,27822,27871,27930,27948,27949,27957,27968,27975,27998,28006,28036,28135,28184,28309,28320,28342,28360,28361,28460,28464,28472,28511,28537,28596,28620,28623,28675,28690,28702,28755,28852,28892,28907,28908,28916,28951,28972,28973,29023,29049,29123,29129,29140,29171,29194,29208,29231,29232,29241,29249,29250,29325,29349,29413,29438,29533,29535,29576,29608,29618,29642,29673,29799,29890,29904,29912,29939,29962,30274,30449,31060,32374,32820,33303,33476,34432,34451,34653,34750,35000,35196,35574,35637,35645,35711,35740,35774,35858,35871,36027,36216,36492,37426,38666,38900,38958,38975,38986,39020,39064,39131,39159,39172,39175,39286,39761,40184,40328,40351,40661,40727,40860,40887,40993,41158,41200,41211,41217,41325,41421,42486,42758,44318,44427)
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 | 1352 | 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.64 ms |
checking permissions | 0.01 ms |
checking permissions | 0.03 ms |
Opening tables | 0.03 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 2.01 ms |
preparing | 1.08 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.07 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 |