Tiempo de la consulta: 14.98 ms Después de la última consulta: 1.08 ms Consulta a la memoria: 1.455 MB memoria antes de la consulta: 4.374 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 00:34:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 00:34:50')
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,110,117,136,173,201,202,252,271,280,308,344,350,353,374,375,376,377,378,379,380,425,456,466,477,495,510,608,611,618,686,693,706,787,814,825,831,837,860,868,891,941,964,966,976,1010,1033,1043,1053,1065,1082,1128,1136,1207,1213,1215,1235,1251,1287,1299,1329,1339,1340,1370,1422,1431,1479,1480,1514,1550,1601,1623,1628,1641,1678,1698,1706,1709,1720,1788,1796,1806,1833,1835,1872,1939,2036,2078,2087,2093,2109,2162,2166,2193,2204,2289,2303,2435,2452,2559,2560,2636,2652,2656,2681,2714,2716,2742,2767,2786,2799,2812,2849,2929,3011,3016,3032,3065,3091,3167,3190,3215,3228,3329,3340,3368,3373,3570,3617,3682,3715,3772,3783,3816,3818,3824,3870,3895,3957,3974,4087,4114,4189,4191,4206,4240,4285,4306,4310,4319,4325,4378,4508,4608,4609,4638,4767,4772,4845,4948,4983,5011,5026,5033,5135,5324,5381,5397,5437,5477,5484,5517,5530,5537,5604,5719,5730,5829,5849,5874,5895,5934,6044,6155,6207,6227,6277,6292,6293,6333,6342,6352,6368,6384,6460,6462,6464,6515,6517,6602,6608,6628,6629,6631,6636,6687,6728,6805,6833,6908,6925,6933,6935,6940,6942,6957,6961,6989,7123,7135,7136,7142,7154,7162,7163,7164,7176,7245,7251,7264,7303,7343,7414,7434,7436,7439,7447,7450,7454,7485,7522,7553,7556,7570,7638,7679,7713,7744,7774,7829,7840,7854,7862,7872,7916,7923,7965,7967,7985,8030,8045,8108,8109,8232,8397,8430,8441,8555,8567,8625,8694,8719,8762,8777,8858,8897,8903,8978,8983,9008,9010,9057,9081,9191,9249,9286,9304,9318,9326,9340,9355,9423,9429,9461,9489,9723,9725,9769,9817,9818,9859,9861,9864,9966,9985,10011,10019,10033,10042,10093,10132,10160,10163,10169,10227,10259,10265,10272,10313,10357,10430,10443,10453,10484,10512,10534,10554,10607,10611,10661,10765,10771,10777,10820,10821,10971,11005,11054,11333,11362,11365,11417,11418,11427,11539,11553,11663,11716,11789,11799,11808,11816,11828,11893,11948,11950,11955,11970,11976,12009,12019,12086,12140,12178,12179,12237,12259,12388,12446,12566,12670,12685,12692,12758,12761,12838,12898,12916,12933,12985,13002,13019,13036,13057,13079,13094,13097,13228,13229,13274,13275,13285,13312,13323,13334,13346,13356,13501,13551,13604,13647,13901,14062,14063,14098,14137,14141,14152,14180,14205,14246,14248,14250,14266,14279,14287,14336,14352,14354,14362,14375,14389,14396,14424,14426,14479,14491,14493,14539,14554,14596,14613,14619,14624,14625,14629,14632,14658,14676,14683,14695,14701,14728,14751,14753,14754,14760,14789,14843,14856,14896,14897,14927,14931,14949,14977,14984,15018,15024,15048,15094,15107,15111,15150,15214,15219,15220,15221,15273,15281,15286,15304,15315,15316,15351,15354,15426,15444,15475,15520,15582,15608,15616,15677,15714,15723,15726,15745,15750,15755,15778,15805,15818,15861,15897,15934,15944,15949,15953,15978,16038,16053,16088,16236,16298,16305,16322,16362,16364,16366,16381,16417,16430,16474,16486,16497,16523,16542,16551,16564,16571,16582,16623,16657,16658,16670,16673,16675,16698,16742,16783,16788,16803,16848,16903,16957,16963,16982,17010,17066,17088,17091,17106,17138,17155,17163,17170,17256,17266,17280,17309,17365,17406,17411,17422,17431,17542,17566,17573,17580,17615,17625,17660,17663,17688,17712,17715,17717,17727,17736,17820,17846,17875,17885,17914,17930,17933,17967,17995,18008,18060,18096,18109,18113,18118,18128,18129,18162,18300,18402,18429,18453,18459,18516,18566,18605,18625,18666,18698,18699,18712,18718,18728,18811,18830,18849,18859,18864,18871,18905,18937,18959,18982,18985,19000,19001,19055,19145,19191,19254,19259,19277,19325,19368,19464,19504,19571,19574,19580,19626,19632,19679,19705,19773,19807,19818,19830,19855,19871,19877,19881,19901,19903,19913,19919,19929,19946,19948,19951,19965,19972,19978,19984,19986,19996,20018,20020,20058,20089,20105,20180,20186,20226,20294,20312,20347,20359,20371,20378,20388,20390,20405,20423,20431,20433,20437,20447,20480,20488,20498,20513,20523,20545,20557,20588,20596,20603,20608,20672,20698,20708,20712,20718,20721,20756,20772,20777,20781,20784,20794,20802,20814,20870,20906,20940,20960,20978,20979,21074,21110,21122,21135,21160,21170,21187,21189,21198,21220,21224,21229,21231,21247,21252,21257,21270,21325,21339,21350,21370,21371,21380,21398,21448,21449,21505,21510,21512,21518,21551,21591,21607,21633,21640,21680,21733,21765,21786,21816,21830,21867,21878,21895,21947,21990,22007,22027,22039,22043,22044,22067,22091,22096,22114,22122,22127,22132,22144,22169,22170,22185,22189,22205,22215,22216,22252,22254,22255,22273,22276,22277,22305,22312,22320,22349,22363,22382,22383,22430,22436,22465,22501,22529,22579,22588,22605,22648,22649,22692,22693,22700,22706,22709,22751,22763,22781,22785,22789,22820,22849,22866,22877,22915,22920,22930,22996,23009,23029,23043,23052,23055,23072,23076,23087,23092,23103,23112,23137,23156,23189,23209,23232,23252,23263,23270,23279,23306,23307,23308,23318,23328,23367,23368,23373,23393,23401,23444,23448,23457,23458,23461,23484,23518,23546,23555,23575,23577,23605,23621,23623,23642,23665,23682,23689,23691,23693,23698,23709,23716,23719,23768,23770,23786,23846,23849,23883,23895,23902,23917,23920,23941,23944,23949,23957,23994,24009,24015,24020,24024,24030,24060,24064,24086,24110,24114,24115,24159,24164,24191,24192,24196,24239,24270,24293,24296,24297,24306,24335,24341,24361,24362,24366,24392,24394,24399,24402,24422,24423,24430,24453,24471,24497,24506,24536,24556,24559,24571,24574,24575,24601,24617,24641,24656,24677,24683,24684,24707,24714,24717,24720,24724,24726,24756,24794,24806,24807,24812,24814,24816,24822,24856,24883,24931,24936,24943,25010,25022,25036,25043,25069,25081,25111,25136,25162,25176,25200,25215,25273,25274,25282,25287,25291,25297,25327,25332,25348,25361,25367,25382,25384,25386,25394,25408,25411,25416,25440,25452,25477,25484,25515,25526,25548,25555,25560,25580,25603,25640,25648,25650,25657,25671,25672,25673,25676,25680,25681,25687,25692,25696,25697,25699,25709,25711,25724,25755,25765,25799,25806,25807,25820,25823,25839,25847,25854,25884,25887,25889,25898,25907,25908,25935,25947,25948,25955,25958,25959,25967,25971,26023,26030,26055,26064,26133,26159,26177,26193,26225,26230,26239,26250,26274,26292,26340,26390,26409,26413,26425,26431,26456,26507,26508,26529,26541,26543,26559,26571,26582,26595,26596,26605,26630,26651,26655,26664,26678,26685,26686,26715,26723,26725,26740,26743,26749,26750,26756,26767,26768,26801,26809,26818,26853,26859,26860,26896,26937,26976,26983,26991,26992,26996,27001,27025,27028,27045,27056,27060,27082,27097,27117,27155,27220,27248,27261,27318,27326,27374,27379,27417,27420,27478,27512,27544,27567,27584,27589,27591,27634,27655,27737,27738,27763,27789,27795,27811,27822,27930,27948,27957,27998,28006,28036,28135,28184,28309,28320,28342,28360,28361,28460,28472,28511,28537,28620,28623,28675,28682,28690,28695,28702,28735,28755,28852,28866,28907,28908,28916,29023,29123,29129,29135,29241,29249,29250,29325,29372,29413,29438,29533,29608,29618,29799,29890,29904,29962,30274,30470,31064,32374,32820,33725,33795,33897,34432,34451,34653,34750,35000,35077,35196,35645,35646,35711,35713,35733,35740,35774,35858,35871,36053,36216,36251,36492,36601,36655,36856,37426,37594,37892,38279,38341,38381,38666,38760,38958,38975,38986,39020,39035,39064,39129,39159,39192,39286,39287,39761,40184,40202,40300,40319,40492,40635,40661,40727,40860,40887,41115,41158,41200,41217,41325,41421,41962,42486,42600,42631,42671,42700,42758,43456,43498,43878,43910,44814,45173)
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 | 1264 | 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.58 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.88 ms |
preparing | 0.94 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 10.06 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.05 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 |