Tiempo de la consulta: 10.46 ms Después de la última consulta: 1.48 ms Consulta a la memoria: 1.080 MB memoria antes de la consulta: 4.303 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 07:43:25')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 07:43:25')
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(7,43,49,60,66,78,81,83,94,117,120,126,136,137,167,180,201,202,214,216,265,271,280,281,304,305,306,316,317,340,341,344,350,353,354,362,367,368,374,376,377,378,379,380,390,398,450,456,463,493,495,515,519,522,534,545,549,556,584,592,593,608,611,621,635,686,728,731,740,741,742,752,754,784,791,825,831,841,843,855,868,891,908,931,941,954,955,963,964,976,980,1006,1007,1020,1029,1033,1039,1043,1052,1103,1168,1187,1188,1195,1207,1215,1229,1257,1265,1287,1296,1298,1302,1313,1318,1329,1336,1338,1339,1344,1351,1354,1364,1367,1371,1380,1392,1402,1406,1413,1420,1421,1428,1430,1433,1435,1440,1441,1443,1461,1470,1478,1506,1507,1524,1531,1532,1537,1541,1556,1558,1565,1566,1568,1572,1598,1601,1649,1657,1673,1681,1690,1695,1698,1709,1719,1776,1782,1797,1823,1827,1905,1932,2000,2013,2096,2109,2110,2115,2145,2178,2194,2207,2209,2229,2236,2245,2314,2315,2316,2332,2333,2342,2354,2357,2373,2376,2384,2410,2453,2459,2476,2481,2503,2511,2516,2524,2540,2564,2579,2594,2628,2643,2644,2656,2695,2714,2715,2720,2728,2729,2735,2742,2765,2817,2826,2830,2870,2896,2898,2922,2926,2939,2942,2957,3018,3033,3040,3063,3073,3074,3086,3091,3112,3117,3126,3129,3137,3143,3163,3177,3187,3215,3222,3235,3257,3283,3293,3327,3329,3332,3340,3377,3382,3388,3397,3436,3457,3478,3486,3512,3546,3556,3564,3567,3574,3579,3582,3587,3590,3602,3641,3657,3675,3709,3759,3783,3796,3816,3827,3838,3840,3864,3870,3881,3895,3934,3957,3962,3979,4015,4019,4025,4074,4087,4153,4172,4192,4206,4257,4309,4319,4335,4343,4371,4378,4468,4488,4525,4622,4631,4632,4638,4654,4674,4684,4688,4689,4690,4691,4693,4718,4741,4745,4784,4808,4834,4841,4847,4856,4871,4876,4896,4902,4949,4971,4999,5016,5020,5051,5052,5053,5072,5099,5164,5180,5233,5247,5285,5299,5323,5378,5431,5470,5495,5566,5569,5572,5579,5588,5594,5597,5632,5633,5644,5645,5650,5659,5662,5710,5722,5726,5727,5729,5730,5747,5822,5827,5837,5840,5870,5888,5933,6006,6010,6047,6051,6094,6176,6203,6211,6217,6267,6272,6283,6284,6292,6333,6348,6349,6354,6359,6363,6381,6384,6392,6422,6438,6445,6453,6464,6501,6502,6567,6568,6619,6631,6675,6677,6687,6690,6802,6825,6832,6908,6915,6940,6942,6950,6957,6961,6975,6989,7002,7056,7082,7086,7096,7099,7104,7110,7154,7168,7175,7181,7212,7219,7225,7275,7299,7303,7309,7334,7358,7388,7428,7434,7450,7454,7466,7495,7522,7555,7556,7584,7594,7638,7670,7677,7678,7680,7713,7719,7749,7766,7774,7823,7829,7837,7839,7849,7860,7862,7868,7916,7923,7932,7946,7951,7965,7967,7970,7985,7993,7995,7998,8037,8061,8071,8108,8141,8169,8183,8189,8199,8204,8205,8223,8236,8245,8246,8247,8275,8276,8315,8320,8339,8355,8380,8391,8401,8426,8451,8471,8498,8521,8537,8540,8565,8569,8571,8593,8602,8626,8630,8694,8704,8757,8773,8776,8781,8816,8838,8839,8845,8853,8877,8888,8912,8921,8952,8959,8983,8986,9029,9057,9058,9109,9115,9131,9136,9148,9158,9164,9191,9201,9223,9249,9318,9322,9401,9425,9429,9442,9475,9487,9564,9650,9723,9725,9728,9752,9811,9818,9839,9842,9861,9942,9966,9985,10009,10011,10017,10078,10079,10144,10187,10227,10259,10261,10265,10299,10308,10313,10315,10317,10323,10340,10345,10348,10357,10375,10376,10392,10491,10534,10561,10595,10596,10611,10665,10673,10708,10775,10777,10820,10821,10860,10896,10938,10939,10948,10953,10970,10971,10975,10991,11005,11030,11037,11060,11074,11075,11093,11120,11165,11186,11241,11252,11255,11285,11292,11333,11343,11361,11362,11365,11371,11439,11441,11491,11539,11542,11603,11611,11625,11626,11629,11630,11648,11661,11663,11692,11694,11705,11729,11737,11738,11739,11789,11799,11800,11816,11893,11938,11950,11967,11976,12002,12009,12020,12060,12081,12082,12094,12116,12118,12128,12178,12179,12181,12219,12223,12225,12283,12326,12339,12356,12364,12384,12385,12388,12446,12500,12511,12513,12526,12595,12620,12621,12622,12623,12625,12630,12670,12685,12705,12717,12718,12752,12758,12760,12811,12838,12878,12894,12897,12898,12925,12945,12957,12985,13002,13010,13036,13056,13078,13079,13110,13125,13150,13152,13153,13207,13217,13229,13248,13285,13327,13334,13377,13436,13473,13476,13554,13585,13608,13613,13629,13647,13651,13685,13714,13750,13759,13811,13858,13859,13900,13901,13922,13931,13959,14002,14005,14038,14047,14048,14098,14152,14181,14204,14205,14229,14248,14250,14287,14293,14336,14350,14352,14354,14382,14386,14396,14424,14426,14457,14468,14516,14540,14542,14570,14592,14596,14610,14612,14625,14629,14642,14643,14676,14695,14754,14789,14791,14843,14847,14852,14856,14873,14879,14915,14960,14984,14987,15003,15018,15063,15117,15119,15137,15177,15208,15286,15304,15306,15312,15315,15316,15321,15333,15372,15400,15408,15444,15495,15501,15520,15530,15544,15581,15596,15608,15616,15651,15681,15700,15714,15723,15742,15755,15778,15784,15791,15805,15839,15850,15888,15897,15903,15904,16053,16066,16088,16214,16249,16340,16347,16362,16365,16370,16381,16417,16421,16423,16439,16446,16447,16450,16474,16503,16507,16523,16537,16542,16580,16622,16644,16646,16657,16670,16675,16763,16783,16806,16814,16815,16818,16831,16840,16844,16866,16887,16898,16905,16935,16982,16985,17002,17011,17047,17090,17108,17143,17148,17163,17185,17190,17194,17247,17256,17291,17292,17334,17365,17376,17379,17410,17417,17422,17440,17444,17446,17452,17456,17458,17487,17501,17514,17518,17529,17536,17542,17566,17573,17588,17625,17630,17640,17646,17660,17662,17688,17712,17717,17725,17734,17737,17799,17820,17823,17838,17839,17845,17851,17869,17881,17887,17896,17914,17921,17930,17933,17947,17960,17967,17989,17990,18066,18088,18110,18118,18122,18126,18127,18136,18139,18158,18186,18197,18203,18212,18277,18284,18286,18300,18301,18309,18311,18321,18351,18380,18429,18433,18447,18490,18516,18549,18571,18580,18605,18630,18690,18708,18716,18770,18780,18784,18807,18811,18816,18830,18849,18871,18881,18882,18909,18957,18989,18994,18999,19001,19017,19028,19031,19052,19055,19096,19114,19130,19131,19145,19178,19184,19219,19221,19254,19259,19277,19287,19311,19325,19330,19335,19339,19354,19367,19370,19389,19400,19413,19445,19454,19456,19463,19492,19501,19503,19520,19529,19545,19555,19574,19617,19644,19675,19679,19731,19773,19830,19855,19871,19877,19881,19883,19898,19901,19965,19972,19984,19996,20003,20041,20056,20057,20059,20067,20095,20111,20120,20134,20135,20154,20156,20158,20170,20177,20188,20195,20239,20248,20250,20252,20256,20271,20279,20345,20362,20390,20405,20420,20424,20433,20437,20443,20447,20450,20457,20483,20488,20495,20500,20545,20588,20590,20606,20609,20644,20654,20667,20681,20698,20708,20718,20751,20772,20781,20794,20800,20814,20854,20886,20888,20940,20945,20959,20960,20979,21084,21115,21122,21132,21163,21170,21198,21218,21229,21247,21255,21266,21279,21295,21303,21307,21321,21325,21340,21350,21367,21370,21376,21380,21393,21398,21402,21448,21449,21459,21467,21490,21508,21540,21551,21591,21607,21610,21628,21640,21680,21684,21689,21707,21716,21720,21721,21735,21774,21782,21853,21867,21870,21895,21909,21956,21961,21964,21990,22005,22039,22044,22067,22071,22075,22082,22096,22100,22119,22138,22170,22175,22215,22255,22257,22276,22316,22320,22344,22349,22363,22382,22385,22436,22445,22465,22501,22525,22579,22588,22619,22623,22647,22654,22669,22689,22693,22709,22736,22749,22751,22781,22820,22866,22868,22915,22917,22930,22936,22942,22944,22979,23009,23029,23041,23057,23072,23087,23103,23112,23127,23132,23137,23156,23168,23196,23232,23250,23252,23270,23279,23308,23332,23367,23368,23377,23397,23401,23414,23431,23444,23457,23471,23484,23555,23577,23598,23621,23623,23627,23642,23657,23665,23675,23682,23686,23691,23693,23709,23716,23719,23722,23726,23728,23740,23741,23768,23801,23817,23833,23846,23849,23882,23884,23888,23902,23907,23920,23922,23926,23944,23949,23973,24009,24015,24024,24033,24060,24100,24110,24115,24143,24159,24164,24175,24182,24184,24193,24196,24239,24270,24296,24306,24335,24361,24362,24413,24422,24430,24453,24478,24489,24495,24506,24556,24575,24591,24594,24617,24619,24620,24635,24656,24677,24703,24707,24724,24726,24794,24799,24816,24830,24912,24931,24989,24998,25036,25043,25136,25200,25282,25287,25291,25304,25327,25331,25332,25336,25367,25384,25386,25408,25416,25440,25441,25458,25473,25475,25484,25515,25526,25548,25555,25557,25560,25640,25685,25687,25690,25692,25694,25697,25730,25765,25769,25777,25806,25835,25854,25887,25889,25891,25959,25981,25995,26023,26038,26048,26055,26062,26116,26204,26226,26229,26274,26298,26340,26369,26374,26386,26390,26413,26494,26505,26509,26516,26520,26530,26595,26601,26629,26630,26638,26659,26680,26731,26760,26771,26802,26853,26915,26935,26936,26963,26978,27001,27009,27100,27101,27183,27184,27199,27259,27354,27374,27379,27384,27412,27434,27460,27491,27524,27526,27529,27559,27571,27584,27616,27673,27688,27795,27806,27808,27898,28129,28218,28366,28511,28537,28601,28623,28636,28852,28949,29002,29052,29325,29962,30274,30486,31640,32820,34699,35000,35095,35135,35153,35366,35585,35588,35589,35711,35740,35750,35774,35778,35834,35857,35858,35865,35886,35891,35922,35972,36051,36130,36156,36196,36201,36216,36240,36252,36267,36292,36299,36341,36364,36492,36591,36594,36598,36604,36624,36707,36725,36769,36947,37083,37576,37647,37851,38280,38610,38613,38616,38652,38746,38777,38855,38946,38958,38971,38975,39020,39041,39064,39112,39159,39171,39225,39483,39525,39571,39583,39590,39682,39773,39790,39821,40184,40385,40386,40387,40456,40483,40499,40742,40789,40835,40983,41025,41068,41106,41298,41302,41325,41442,42284,42310,42494,42568,42602,42833,43018,43322,43360,43425,43426,43543,43992,44157,44468,44784,44906,45141,45164,45227,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 | 1678 | 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.74 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.30 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.55 ms |
preparing | 1.25 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.80 ms |
end | 0.06 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.11 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 |