Tiempo de la consulta: 11.01 ms Después de la última consulta: 2.27 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.410 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 08:24:10')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 08:24:10')
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,9,15,16,17,33,38,48,49,60,66,74,75,76,77,78,81,94,113,114,115,116,117,118,119,120,126,131,136,167,180,201,202,207,208,211,216,265,271,280,283,294,304,305,306,316,317,335,340,344,349,350,353,354,368,374,376,377,378,379,380,390,432,436,456,463,470,487,488,493,495,515,519,549,569,572,584,592,593,608,611,619,621,635,686,693,724,728,731,735,737,740,741,742,744,755,756,766,791,806,825,831,841,855,868,872,881,891,894,899,908,931,941,942,952,954,955,963,964,972,976,978,986,987,1007,1017,1020,1029,1033,1039,1043,1047,1052,1056,1067,1083,1090,1103,1137,1147,1152,1154,1168,1169,1181,1187,1188,1207,1215,1220,1229,1254,1257,1265,1273,1283,1292,1293,1296,1298,1302,1306,1311,1313,1318,1329,1336,1338,1339,1344,1348,1354,1361,1364,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1459,1461,1470,1478,1488,1495,1501,1506,1507,1524,1525,1531,1532,1537,1558,1568,1572,1581,1598,1601,1608,1664,1681,1695,1698,1706,1709,1719,1723,1726,1756,1814,1823,1845,1869,1876,1878,1879,1898,1905,1932,1943,2022,2096,2104,2145,2175,2178,2184,2194,2203,2207,2209,2229,2236,2245,2311,2314,2315,2316,2326,2332,2333,2342,2350,2356,2373,2376,2391,2400,2410,2446,2453,2454,2459,2476,2481,2485,2489,2502,2503,2511,2516,2524,2536,2564,2572,2579,2580,2583,2594,2603,2607,2610,2611,2621,2627,2644,2650,2656,2695,2713,2714,2720,2726,2728,2733,2740,2742,2763,2765,2766,2787,2794,2798,2817,2830,2836,2839,2844,2848,2894,2895,2896,2901,2926,2930,2932,2940,2942,2943,2977,2990,2991,2997,2998,3012,3047,3053,3063,3073,3078,3091,3112,3116,3117,3118,3126,3129,3136,3137,3143,3153,3162,3163,3171,3173,3175,3184,3187,3215,3222,3229,3235,3254,3293,3300,3308,3314,3327,3329,3340,3342,3347,3366,3382,3388,3393,3436,3442,3443,3457,3466,3486,3490,3494,3500,3529,3530,3532,3539,3546,3549,3556,3558,3572,3574,3579,3580,3582,3587,3602,3603,3657,3668,3675,3695,3698,3709,3771,3773,3778,3783,3796,3814,3816,3827,3840,3864,3870,3885,3895,3905,3928,3957,3979,4001,4013,4015,4019,4062,4074,4087,4089,4091,4115,4128,4130,4153,4163,4164,4182,4203,4206,4235,4276,4308,4309,4319,4335,4343,4366,4368,4369,4371,4377,4378,4406,4420,4488,4524,4525,4534,4631,4632,4638,4654,4684,4688,4689,4691,4697,4718,4758,4784,4808,4818,4819,4841,4847,4871,4902,4949,4950,4971,4999,5016,5020,5051,5095,5099,5180,5284,5309,5323,5343,5347,5349,5378,5431,5456,5470,5476,5522,5554,5566,5569,5572,5579,5588,5594,5596,5597,5632,5645,5647,5650,5656,5659,5662,5682,5722,5726,5727,5729,5730,5747,5822,5845,5850,5870,5965,6006,6010,6030,6039,6071,6078,6094,6173,6185,6190,6203,6207,6217,6272,6292,6298,6333,6348,6349,6354,6359,6363,6384,6392,6425,6445,6464,6501,6513,6559,6568,6616,6631,6670,6675,6677,6687,6690,6741,6802,6874,6899,6908,6940,6942,6957,6961,6975,6976,6989,7001,7035,7056,7064,7082,7086,7096,7099,7110,7120,7129,7148,7154,7176,7180,7181,7189,7212,7217,7275,7280,7282,7299,7303,7309,7311,7317,7318,7330,7333,7334,7352,7354,7378,7387,7402,7403,7410,7434,7450,7454,7466,7486,7495,7522,7546,7554,7555,7556,7574,7575,7584,7598,7614,7622,7626,7638,7656,7680,7691,7713,7719,7774,7799,7829,7836,7837,7839,7846,7860,7861,7862,7868,7875,7890,7908,7914,7916,7923,7932,7946,7965,7967,7970,7985,7991,7993,7998,8014,8027,8037,8061,8071,8090,8107,8108,8120,8122,8134,8177,8199,8209,8210,8228,8229,8233,8246,8247,8264,8272,8275,8276,8282,8286,8288,8301,8339,8384,8394,8401,8410,8412,8425,8426,8451,8468,8473,8498,8540,8558,8560,8569,8593,8598,8614,8620,8694,8704,8725,8773,8776,8781,8834,8839,8853,8886,8952,8983,9029,9052,9057,9091,9103,9134,9148,9191,9201,9223,9249,9298,9318,9322,9342,9429,9440,9475,9480,9483,9542,9564,9575,9627,9637,9650,9686,9712,9723,9725,9740,9780,9818,9839,9846,9861,9887,9892,9916,9942,9949,9953,9966,9975,9985,9986,10009,10011,10022,10038,10047,10078,10079,10092,10110,10120,10131,10181,10193,10227,10229,10259,10261,10265,10268,10275,10280,10308,10313,10318,10340,10345,10348,10357,10369,10370,10376,10399,10415,10429,10444,10453,10534,10595,10611,10612,10643,10665,10673,10682,10708,10755,10775,10777,10798,10820,10821,10900,10930,10953,10971,11005,11030,11037,11104,11151,11188,11234,11235,11237,11241,11252,11304,11333,11362,11365,11422,11439,11441,11539,11574,11603,11626,11663,11692,11726,11779,11799,11816,11843,11844,11867,11889,11893,11922,11950,11967,11974,11976,12009,12060,12070,12081,12105,12116,12128,12133,12178,12179,12181,12183,12197,12216,12219,12223,12225,12243,12283,12326,12332,12351,12382,12385,12388,12393,12434,12446,12460,12465,12480,12520,12556,12595,12610,12620,12622,12623,12625,12630,12670,12685,12705,12708,12717,12718,12752,12758,12760,12812,12838,12846,12873,12884,12887,12894,12898,12907,12925,12945,12957,12962,12985,12990,12997,13002,13006,13010,13035,13036,13041,13078,13079,13092,13124,13137,13187,13229,13236,13248,13276,13284,13285,13334,13349,13390,13466,13473,13497,13521,13647,13759,13771,13790,13805,13817,13835,13900,13901,13906,13953,13959,14005,14024,14047,14048,14098,14104,14113,14143,14152,14175,14181,14204,14205,14223,14229,14248,14250,14283,14285,14293,14336,14350,14352,14354,14370,14372,14386,14396,14424,14426,14457,14468,14470,14481,14516,14530,14542,14558,14570,14571,14592,14596,14625,14629,14647,14676,14695,14697,14700,14730,14749,14754,14771,14775,14789,14793,14811,14819,14843,14852,14856,14871,14956,14984,14987,15010,15018,15035,15231,15236,15286,15287,15296,15304,15305,15315,15316,15321,15372,15408,15444,15475,15486,15495,15512,15520,15522,15530,15552,15581,15603,15608,15616,15651,15655,15678,15704,15714,15723,15730,15742,15755,15778,15805,15839,15850,15870,15876,15897,15919,15938,15965,16001,16053,16058,16088,16149,16214,16249,16250,16254,16282,16316,16324,16347,16354,16356,16362,16370,16381,16407,16417,16421,16423,16430,16457,16474,16494,16509,16516,16523,16537,16542,16564,16565,16580,16610,16657,16670,16675,16687,16695,16721,16724,16754,16763,16776,16783,16790,16818,16834,16839,16854,16862,16942,16954,16982,17002,17067,17084,17148,17153,17163,17185,17201,17207,17234,17240,17256,17274,17278,17288,17289,17291,17300,17331,17333,17343,17365,17379,17386,17391,17394,17414,17417,17422,17430,17458,17471,17501,17529,17540,17542,17544,17547,17552,17553,17566,17573,17575,17598,17609,17625,17640,17646,17660,17664,17688,17712,17717,17750,17753,17783,17799,17820,17834,17850,17851,17869,17887,17914,17921,17922,17930,17933,17947,17950,17955,17960,17967,17995,17996,18060,18079,18110,18115,18118,18121,18122,18127,18136,18158,18159,18212,18275,18277,18278,18284,18286,18291,18300,18301,18309,18311,18321,18351,18380,18391,18397,18428,18429,18433,18490,18516,18526,18541,18549,18552,18571,18577,18580,18605,18626,18630,18651,18690,18693,18698,18706,18724,18770,18780,18784,18811,18830,18849,18871,18899,18971,18994,18999,19001,19028,19031,19052,19055,19082,19115,19130,19134,19138,19145,19178,19184,19219,19220,19224,19254,19259,19260,19277,19315,19325,19335,19370,19373,19379,19389,19445,19454,19460,19479,19484,19492,19501,19517,19531,19555,19574,19617,19659,19679,19731,19733,19754,19773,19830,19855,19869,19871,19877,19881,19898,19901,19929,19958,19959,19960,19965,19972,19984,19996,20003,20040,20059,20065,20067,20087,20091,20097,20111,20120,20140,20154,20168,20173,20179,20186,20195,20200,20248,20250,20252,20256,20270,20271,20279,20297,20300,20326,20333,20366,20390,20405,20411,20433,20437,20443,20447,20457,20461,20488,20500,20516,20540,20545,20555,20570,20588,20590,20609,20627,20632,20666,20667,20681,20698,20708,20718,20772,20781,20794,20800,20805,20814,20854,20885,20888,20897,20898,20940,20945,20960,20979,20983,20991,21009,21055,21058,21104,21115,21116,21122,21128,21163,21170,21178,21198,21228,21229,21247,21266,21305,21316,21321,21325,21340,21350,21370,21380,21390,21393,21398,21418,21448,21449,21459,21463,21467,21490,21495,21508,21514,21520,21537,21540,21543,21551,21591,21607,21611,21624,21627,21640,21653,21680,21681,21682,21721,21735,21774,21853,21867,21870,21895,21901,21915,21924,21947,21961,21977,21990,22000,22003,22005,22039,22044,22054,22067,22082,22093,22096,22132,22139,22154,22170,22175,22180,22181,22215,22255,22257,22276,22320,22349,22363,22382,22385,22395,22436,22465,22496,22497,22501,22525,22579,22588,22596,22616,22647,22653,22661,22677,22693,22698,22709,22718,22731,22736,22746,22751,22764,22781,22799,22804,22820,22866,22915,22916,22930,22979,23009,23029,23041,23042,23071,23072,23087,23103,23112,23132,23137,23140,23144,23156,23168,23232,23236,23242,23249,23252,23270,23279,23287,23302,23308,23332,23339,23351,23367,23368,23401,23444,23449,23452,23484,23486,23498,23527,23550,23555,23577,23598,23599,23621,23623,23642,23665,23675,23682,23691,23693,23698,23709,23716,23719,23722,23727,23743,23768,23784,23787,23800,23816,23817,23836,23846,23849,23873,23901,23902,23907,23912,23920,23922,23926,23944,23949,24009,24015,24024,24060,24065,24102,24110,24115,24159,24164,24175,24193,24196,24239,24241,24270,24283,24296,24306,24335,24361,24362,24372,24402,24413,24417,24422,24430,24453,24457,24461,24473,24475,24478,24495,24506,24556,24559,24575,24577,24617,24635,24649,24655,24656,24677,24703,24707,24724,24726,24730,24751,24794,24799,24800,24809,24816,24850,24859,24876,24884,24930,24931,24989,25003,25036,25043,25063,25069,25096,25109,25112,25121,25122,25136,25155,25165,25180,25192,25200,25282,25287,25291,25327,25331,25332,25336,25342,25352,25358,25367,25384,25386,25387,25408,25416,25418,25440,25441,25458,25462,25475,25477,25484,25515,25526,25547,25548,25555,25557,25560,25564,25589,25640,25644,25685,25687,25690,25692,25694,25697,25701,25729,25765,25806,25826,25854,25856,25869,25887,25889,25891,25926,25959,25981,26023,26038,26043,26055,26062,26063,26116,26204,26226,26258,26274,26338,26340,26369,26386,26390,26413,26509,26520,26530,26540,26541,26573,26595,26603,26630,26659,26680,26711,26725,26731,26802,26807,26853,26930,26978,27001,27039,27059,27094,27183,27184,27199,27221,27263,27271,27298,27327,27354,27374,27379,27424,27435,27506,27584,27616,27795,27806,27808,27871,27931,27949,27968,27975,27990,28198,28218,28323,28330,28366,28464,28511,28533,28537,28593,28601,28606,28623,28624,28632,28636,28852,28892,28907,28908,28917,28933,28949,28951,28972,28973,29002,29049,29140,29141,29171,29194,29208,29234,29325,29343,29349,29535,29576,29622,29642,29673,29720,29911,29912,29923,29939,29962,30274,30449,30486,31286,31640,32820,32993,33417,34699,35000,35095,35153,35576,35585,35711,35740,35750,35774,35778,35858,35865,35923,36051,36130,36196,36216,36267,36292,36299,36341,36492,36591,36594,36598,36604,36769,36875,36965,37083,37609,37748,38278,38391,38402,38453,38610,38613,38652,38777,38783,38826,38900,38946,38958,38971,38975,38986,39020,39041,39064,39131,39159,39171,39172,39225,39266,39483,39571,39579,39590,39682,39698,39790,39821,39940,40184,40351,40385,40386,40387,40456,40742,40759,40772,40983,40993,41068,41151,41157,41211,41298,41325,41442,42123,42270,42310,42602,42795,42843,43018,43425,43426,43808,43837,43964,44237,44509,44906,45227)
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 | 1953 | 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.90 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.39 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 2.89 ms |
preparing | 1.49 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.45 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.13 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 |