Tiempo de la consulta: 18.48 ms Después de la última consulta: 1.13 ms Consulta a la memoria: 2.510 MB memoria antes de la consulta: 4.216 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 05:51:51')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 05:51: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(7,9,14,35,60,62,66,78,81,94,95,110,117,120,126,163,167,174,180,201,204,216,252,265,281,304,305,306,316,317,340,344,354,357,368,377,390,435,443,453,463,476,493,495,506,515,519,547,549,570,584,592,593,621,635,664,693,719,728,731,740,741,742,760,777,791,799,825,841,855,891,908,931,954,955,1007,1020,1029,1052,1103,1155,1168,1182,1187,1188,1229,1257,1265,1287,1289,1296,1298,1302,1313,1324,1336,1338,1344,1346,1354,1361,1364,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1439,1441,1443,1456,1463,1470,1478,1501,1506,1507,1524,1531,1532,1537,1538,1558,1567,1568,1572,1598,1607,1681,1695,1698,1716,1719,1739,1756,1757,1823,1825,1860,1898,1905,1919,1922,1932,1990,2031,2041,2042,2096,2144,2145,2150,2178,2182,2188,2194,2204,2207,2209,2219,2229,2235,2236,2241,2242,2243,2245,2261,2278,2285,2314,2315,2316,2319,2332,2333,2342,2353,2373,2376,2392,2396,2410,2453,2459,2472,2476,2481,2503,2511,2516,2524,2564,2579,2594,2604,2608,2611,2627,2631,2644,2658,2666,2695,2700,2720,2728,2765,2770,2797,2813,2817,2830,2834,2835,2843,2893,2908,2926,2942,2956,2967,3055,3063,3065,3073,3090,3109,3112,3117,3123,3126,3129,3137,3143,3163,3166,3180,3187,3222,3235,3293,3327,3344,3347,3362,3364,3382,3388,3390,3393,3414,3436,3451,3457,3486,3546,3556,3571,3574,3579,3582,3587,3602,3657,3675,3709,3737,3796,3827,3829,3840,3864,3931,3932,3979,4015,4074,4153,4166,4309,4335,4343,4488,4525,4631,4632,4654,4684,4688,4689,4691,4699,4713,4718,4767,4784,4808,4841,4847,4871,4902,4949,4971,4999,5016,5020,5051,5099,5100,5161,5180,5247,5269,5275,5323,5348,5378,5431,5439,5470,5471,5566,5569,5572,5579,5588,5590,5594,5597,5615,5617,5632,5645,5650,5659,5662,5722,5726,5727,5729,5747,5749,5822,5870,5881,5968,5998,6006,6010,6020,6076,6101,6174,6217,6272,6292,6348,6349,6354,6359,6363,6392,6445,6454,6472,6565,6568,6670,6675,6677,6694,6975,6989,7013,7014,7056,7082,7086,7096,7099,7110,7124,7138,7139,7150,7181,7205,7212,7246,7262,7265,7269,7272,7275,7288,7291,7293,7299,7300,7309,7334,7439,7466,7495,7521,7552,7555,7594,7617,7623,7636,7680,7719,7837,7839,7841,7860,7868,7887,7915,7923,7932,7934,7935,7946,7970,7992,7998,8015,8037,8071,8116,8147,8159,8173,8190,8199,8275,8276,8339,8345,8451,8498,8540,8569,8587,8593,8704,8773,8776,8781,8828,8853,8894,8983,9029,9041,9079,9148,9191,9201,9223,9322,9422,9428,9434,9475,9554,9650,9727,9773,9818,9820,9834,9839,9841,9924,9942,9963,10009,10019,10063,10071,10078,10079,10144,10202,10255,10261,10307,10308,10340,10345,10348,10416,10471,10502,10595,10630,10665,10673,10694,10708,10775,10783,10799,10958,11030,11031,11035,11059,11142,11237,11241,11247,11258,11402,11439,11441,11446,11603,11626,11679,11692,11967,12060,12116,12128,12166,12181,12190,12218,12219,12223,12225,12331,12385,12401,12463,12474,12595,12620,12622,12623,12625,12630,12677,12686,12705,12717,12718,12752,12760,12846,12875,12894,12925,12945,12957,13002,13010,13024,13052,13078,13248,13473,13611,13636,13697,13742,13759,13959,13963,13990,14005,14047,14048,14074,14082,14101,14117,14181,14204,14229,14244,14262,14273,14279,14293,14350,14391,14440,14445,14447,14456,14457,14468,14491,14507,14516,14529,14534,14536,14538,14542,14550,14570,14576,14592,14683,14707,14794,14852,14964,14983,14987,15032,15048,15094,15108,15111,15115,15129,15139,15213,15321,15346,15370,15372,15408,15495,15530,15548,15554,15575,15578,15599,15651,15725,15741,15757,15782,15836,15838,15839,15850,15935,16000,16092,16093,16153,16158,16214,16249,16317,16326,16347,16370,16374,16421,16423,16458,16523,16534,16537,16580,16664,16763,16832,16889,16976,16981,17002,17115,17128,17138,17148,17169,17185,17215,17220,17257,17291,17374,17379,17382,17432,17458,17501,17529,17541,17542,17562,17596,17615,17618,17634,17640,17646,17649,17688,17707,17729,17733,17799,17815,17818,17840,17851,17869,17895,17921,17947,17960,17980,18003,18031,18110,18122,18127,18157,18158,18172,18212,18277,18284,18286,18301,18309,18321,18369,18379,18380,18404,18427,18433,18447,18490,18516,18549,18561,18563,18571,18577,18580,18593,18594,18612,18630,18682,18687,18690,18691,18694,18770,18780,18837,18910,18920,18942,18969,18977,18982,18984,18991,18994,18995,18997,18999,19000,19022,19028,19048,19049,19052,19078,19083,19091,19110,19130,19132,19136,19149,19178,19184,19219,19247,19260,19270,19294,19325,19335,19370,19383,19389,19411,19419,19445,19447,19453,19454,19492,19501,19524,19545,19552,19555,19574,19595,19608,19617,19634,19650,19661,19684,19718,19731,19815,19894,19898,19930,19931,19932,19941,19944,19955,19971,19972,19983,19991,19993,20003,20024,20034,20036,20058,20059,20065,20067,20069,20111,20120,20145,20183,20195,20199,20207,20248,20250,20252,20256,20271,20279,20281,20344,20354,20363,20374,20403,20426,20440,20443,20500,20578,20590,20609,20636,20638,20667,20681,20699,20704,20775,20800,20814,20819,20826,20856,20888,20945,20955,21000,21020,21101,21106,21115,21118,21161,21163,21178,21229,21242,21252,21266,21305,21319,21321,21322,21323,21340,21393,21429,21433,21458,21459,21464,21467,21490,21508,21522,21531,21546,21548,21586,21592,21714,21721,21735,21737,21774,21814,21853,21870,21952,21961,22005,22059,22061,22082,22100,22132,22175,22257,22262,22267,22279,22333,22385,22414,22419,22423,22435,22455,22492,22500,22502,22525,22527,22576,22647,22649,22673,22708,22715,22736,22742,22803,22834,22874,22979,23000,23022,23034,23041,23073,23122,23132,23148,23168,23219,23225,23247,23286,23332,23344,23375,23467,23546,23559,23564,23592,23598,23675,23688,23691,23703,23722,23772,23785,23817,23857,23874,23907,23922,23926,23930,23959,23962,23967,23970,23984,24010,24024,24072,24075,24076,24111,24175,24193,24204,24220,24230,24236,24270,24275,24346,24361,24413,24454,24478,24497,24523,24603,24607,24616,24639,24673,24692,24703,24788,24799,24820,24857,24872,24924,24989,25003,25093,25106,25126,25270,25273,25331,25336,25349,25360,25373,25374,25421,25458,25475,25557,25636,25672,25685,25687,25690,25694,25760,25764,25798,25891,25921,25981,25987,26030,26062,26078,26107,26122,26176,26204,26226,26288,26301,26369,26386,26453,26509,26513,26520,26522,26530,26542,26564,26630,26659,26680,26731,26802,26816,26924,26926,26982,27018,27026,27151,27183,27184,27199,27218,27354,27356,27506,27558,27572,27597,27616,27806,27808,28005,28185,28218,28366,28367,28397,28424,28601,28636,28780,28824,28952,29002,29021,29089,29124,29256,29358,29569,29617,29810,29919,29930,30486,31227,31499,31516,31640,33815,34158,34699,35095,35153,35369,35548,35562,35585,35731,35750,35778,35865,35878,35950,36051,36060,36130,36153,36196,36241,36267,36292,36299,36341,36383,36396,36534,36591,36594,36598,36604,36639,36769,36893,36916,36918,36937,37005,37083,37109,37131,37315,37380,37455,37597,37874,37996,38056,38066,38361,38426,38455,38458,38474,38610,38613,38652,38734,38775,38777,38812,38836,38886,38890,38946,38971,39041,39171,39225,39307,39358,39406,39452,39483,39504,39505,39516,39571,39590,39682,39790,39821,39936,39938,39966,39995,40079,40169,40312,40313,40314,40317,40360,40385,40386,40387,40456,40484,40542,40558,40742,40801,40867,40983,41036,41063,41068,41298,41402,41423,41442,41515,41811,41885,42310,42316,42456,42460,42481,42489,42602,42971,43018,43155,43425,43426,43680,43705,43706,43707,43898,43907,43914,43915,43917,43980,44031,44041,44136,44369,44370,44497,44681,44906,45018,45038,45039,45040,45041,45042,45043,45115,45160,45206,45227,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 | 1302 | 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.62 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.97 ms |
preparing | 0.96 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 13.32 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.03 ms |
freeing items | 0.14 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 |