Tiempo de la consulta: 9.99 ms Después de la última consulta: 1.14 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.230 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 17:02:28')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 17:02:28')
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,36,60,66,78,81,94,117,120,126,167,180,201,212,216,226,233,265,304,305,306,316,317,340,354,368,377,390,463,493,495,515,519,549,584,592,593,621,635,728,731,740,741,742,791,825,841,855,891,908,931,954,955,964,965,972,978,1007,1020,1029,1052,1085,1103,1144,1154,1168,1181,1187,1188,1206,1209,1229,1257,1265,1287,1292,1293,1296,1298,1302,1306,1311,1313,1318,1336,1338,1344,1345,1354,1364,1367,1380,1391,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1470,1478,1493,1506,1507,1513,1524,1531,1532,1537,1546,1558,1568,1572,1598,1600,1601,1610,1634,1640,1681,1682,1693,1695,1719,1747,1774,1823,1876,1889,1900,1905,1915,1922,1932,1974,2009,2014,2053,2056,2096,2097,2122,2125,2145,2156,2175,2178,2194,2207,2209,2229,2236,2245,2311,2314,2315,2316,2332,2333,2342,2361,2367,2373,2376,2410,2424,2453,2459,2476,2481,2493,2503,2511,2516,2524,2539,2564,2579,2590,2594,2598,2600,2611,2639,2644,2695,2720,2728,2765,2817,2830,2920,2926,2931,2936,2942,2963,2976,3054,3062,3063,3073,3078,3112,3117,3126,3129,3137,3143,3153,3163,3187,3222,3235,3293,3307,3308,3309,3311,3327,3347,3359,3363,3382,3388,3418,3419,3436,3457,3468,3486,3516,3546,3556,3574,3579,3582,3587,3602,3611,3612,3654,3657,3675,3709,3775,3796,3827,3830,3840,3864,3898,3899,3961,3979,4015,4035,4074,4098,4140,4153,4283,4309,4335,4343,4487,4488,4525,4541,4565,4631,4632,4647,4654,4684,4688,4689,4691,4714,4718,4720,4721,4722,4784,4808,4841,4847,4871,4876,4902,4949,4957,4971,4990,4999,5016,5020,5040,5051,5079,5086,5099,5104,5139,5140,5150,5162,5170,5173,5180,5241,5250,5323,5354,5355,5378,5431,5458,5470,5566,5569,5572,5579,5588,5594,5597,5614,5622,5623,5632,5645,5647,5650,5659,5662,5722,5726,5727,5729,5747,5797,5799,5814,5822,5870,6006,6010,6094,6097,6173,6178,6217,6264,6270,6272,6291,6292,6348,6349,6354,6359,6363,6392,6445,6446,6537,6568,6675,6677,6695,6775,6830,6839,6840,6847,6873,6910,6915,6937,6975,7056,7074,7083,7086,7096,7099,7110,7117,7133,7134,7181,7212,7213,7275,7294,7299,7309,7334,7380,7398,7403,7416,7435,7466,7495,7524,7526,7555,7607,7621,7624,7659,7663,7680,7717,7719,7745,7749,7766,7813,7837,7839,7860,7866,7868,7932,7946,7958,7970,7998,8036,8037,8056,8061,8071,8140,8199,8203,8275,8276,8330,8339,8347,8416,8451,8462,8498,8519,8540,8569,8593,8704,8710,8718,8773,8776,8781,8853,8917,8983,9018,9029,9039,9046,9051,9077,9108,9130,9148,9191,9197,9201,9202,9223,9248,9267,9322,9331,9341,9389,9422,9475,9599,9650,9652,9658,9672,9752,9770,9806,9818,9839,9858,9866,9909,9942,9964,9999,10009,10010,10078,10079,10112,10165,10178,10222,10261,10299,10308,10340,10345,10348,10400,10471,10476,10595,10604,10665,10673,10691,10708,10764,10775,10811,10902,10956,10967,11030,11163,11241,11305,11425,11435,11439,11441,11444,11476,11591,11603,11604,11626,11631,11692,11753,11859,11864,11943,11967,11994,12060,12073,12083,12095,12116,12128,12181,12219,12223,12225,12310,12315,12364,12385,12595,12620,12622,12623,12625,12630,12672,12683,12705,12717,12718,12749,12752,12760,12771,12807,12889,12894,12925,12945,12957,13002,13010,13045,13074,13078,13204,13248,13254,13268,13328,13468,13473,13479,13509,13535,13575,13576,13578,13633,13681,13748,13759,13782,13783,13846,13868,13895,13924,13938,13941,13950,13959,13969,14005,14047,14048,14169,14181,14198,14203,14204,14229,14274,14293,14327,14350,14356,14369,14430,14448,14457,14462,14468,14516,14542,14570,14592,14648,14663,14669,14679,14733,14760,14834,14847,14852,14877,14881,14923,14948,14973,14979,14984,14987,14993,14997,15021,15051,15110,15179,15201,15243,15262,15293,15298,15304,15317,15321,15372,15386,15408,15421,15457,15473,15482,15495,15506,15517,15530,15550,15650,15651,15751,15753,15765,15784,15787,15816,15839,15850,15876,15904,15947,16122,16214,16249,16282,16347,16370,16413,16421,16423,16440,16455,16519,16526,16535,16537,16580,16654,16689,16720,16724,16763,16785,16802,16812,16856,16876,16894,16917,16920,16998,17002,17016,17122,17133,17148,17150,17151,17185,17216,17291,17317,17334,17335,17337,17349,17373,17379,17409,17412,17430,17458,17479,17485,17496,17501,17520,17529,17584,17603,17619,17626,17640,17646,17655,17700,17735,17746,17789,17790,17799,17826,17843,17851,17862,17869,17880,17921,17947,17949,17960,17965,18028,18110,18122,18127,18129,18158,18170,18212,18213,18225,18239,18251,18277,18284,18286,18301,18309,18321,18362,18374,18380,18432,18433,18441,18446,18482,18490,18492,18516,18538,18549,18571,18580,18583,18601,18630,18661,18675,18690,18707,18726,18753,18770,18780,18803,18845,18852,18896,18899,18952,18974,18994,18999,19028,19039,19040,19052,19065,19098,19127,19130,19150,19153,19178,19184,19202,19204,19219,19235,19252,19254,19276,19315,19325,19328,19334,19335,19358,19370,19389,19398,19426,19445,19454,19476,19483,19487,19492,19501,19519,19527,19555,19572,19574,19617,19676,19731,19750,19752,19767,19772,19791,19792,19898,19972,20003,20027,20030,20039,20059,20066,20067,20068,20071,20092,20111,20120,20122,20139,20180,20183,20195,20205,20248,20250,20252,20254,20256,20262,20271,20277,20279,20351,20384,20386,20437,20443,20469,20500,20526,20528,20565,20566,20590,20592,20609,20642,20648,20667,20670,20681,20688,20701,20727,20750,20792,20800,20804,20883,20888,20894,20944,20945,20964,20984,20990,21016,21109,21115,21163,21182,21196,21198,21226,21229,21243,21266,21282,21321,21327,21329,21332,21340,21393,21404,21405,21407,21412,21450,21454,21459,21467,21487,21490,21508,21568,21721,21722,21726,21735,21761,21767,21769,21774,21811,21824,21853,21856,21870,21891,21932,21958,21961,21998,22005,22082,22129,22132,22156,22162,22172,22175,22253,22257,22262,22267,22307,22385,22409,22466,22481,22493,22499,22515,22525,22560,22647,22726,22736,22753,22797,22818,22862,22865,22914,22979,23037,23041,23099,23104,23119,23123,23132,23168,23183,23184,23213,23218,23244,23254,23257,23268,23309,23319,23332,23374,23390,23491,23504,23510,23524,23554,23565,23598,23604,23622,23628,23632,23637,23660,23675,23704,23722,23731,23751,23805,23813,23817,23882,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23922,23926,23927,23950,23964,23981,23983,23986,24000,24029,24039,24040,24160,24175,24193,24197,24294,24337,24356,24361,24407,24413,24429,24478,24496,24503,24587,24589,24633,24638,24678,24679,24703,24782,24799,24879,24911,24913,24935,24989,24990,25021,25171,25177,25233,25331,25336,25458,25475,25505,25557,25609,25653,25685,25687,25690,25694,25758,25785,25814,25863,25891,25909,25981,26017,26062,26116,26190,26204,26226,26335,26369,26386,26509,26520,26530,26615,26630,26659,26680,26731,26745,26758,26784,26802,26906,26936,27005,27065,27116,27141,27183,27184,27199,27208,27232,27272,27345,27354,27357,27449,27517,27585,27612,27616,27629,27795,27806,27808,28080,28140,28218,28366,28445,28601,28636,28652,29002,29061,29066,29193,29624,29715,29814,29856,30486,31239,31640,32646,33749,33907,33929,34699,34714,34864,35095,35153,35214,35384,35585,35750,35778,35865,36051,36130,36196,36267,36292,36299,36341,36591,36594,36598,36604,36697,36769,36917,37083,38610,38613,38652,38777,38946,38971,39041,39051,39171,39225,39453,39483,39499,39571,39590,39601,39603,39682,39697,39719,39790,39821,39883,39953,39967,40069,40172,40385,40386,40387,40456,40742,40811,40914,40983,40987,41068,41292,41298,41376,41378,41442,41625,41683,41703,41815,41998,42173,42310,42602,43018,43425,43426,44798,44811,44830,44870,44897,44898,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 | 1304 | 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.69 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.28 ms |
System lock | 0.02 ms |
optimizing | 0.11 ms |
statistics | 2.08 ms |
preparing | 1.12 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.36 ms |
end | 0.02 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
freeing items | 0.12 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 |