Tiempo de la consulta: 8.94 ms Después de la última consulta: 0.84 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.321 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 07:08:43')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 07:08:43')
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,24,33,38,60,61,66,78,81,94,117,120,126,160,167,180,201,212,216,265,304,305,306,316,317,340,354,368,377,390,462,463,493,495,509,514,515,519,549,584,592,593,621,635,656,697,728,731,740,741,742,744,753,766,791,792,825,841,855,872,877,891,894,904,908,931,933,948,954,955,956,958,978,990,1007,1020,1029,1038,1045,1052,1060,1067,1073,1075,1090,1103,1108,1109,1117,1126,1152,1157,1168,1187,1188,1217,1229,1254,1257,1265,1281,1283,1287,1296,1298,1302,1313,1336,1338,1344,1354,1364,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1470,1478,1493,1501,1506,1507,1515,1524,1531,1532,1537,1558,1568,1572,1598,1601,1654,1681,1695,1719,1774,1791,1823,1824,1905,1932,1976,2014,2096,2115,2145,2178,2194,2207,2209,2229,2236,2245,2314,2315,2316,2332,2333,2342,2373,2376,2410,2453,2459,2476,2481,2503,2511,2516,2524,2564,2579,2590,2594,2644,2695,2709,2720,2728,2765,2817,2830,2926,2930,2942,2977,3053,3058,3063,3073,3078,3112,3117,3126,3129,3137,3143,3163,3187,3202,3222,3235,3253,3293,3327,3382,3388,3433,3436,3457,3486,3494,3539,3546,3556,3558,3573,3574,3579,3582,3587,3602,3612,3657,3675,3709,3796,3827,3840,3864,3898,3979,3996,4005,4015,4019,4035,4074,4098,4132,4140,4153,4309,4335,4343,4397,4488,4525,4541,4565,4631,4632,4654,4664,4684,4688,4689,4691,4718,4764,4784,4808,4841,4847,4871,4902,4949,4971,4996,4999,5016,5020,5051,5099,5180,5241,5323,5334,5378,5431,5470,5566,5569,5572,5579,5588,5594,5597,5632,5633,5645,5650,5659,5662,5700,5722,5726,5727,5729,5747,5822,5870,5905,6006,6010,6151,6217,6272,6291,6292,6344,6348,6349,6354,6359,6363,6381,6392,6445,6537,6540,6568,6675,6677,6771,6872,6975,7056,7074,7082,7086,7096,7099,7110,7181,7212,7228,7248,7275,7299,7309,7334,7380,7403,7430,7466,7492,7495,7524,7555,7581,7589,7624,7680,7719,7837,7839,7860,7868,7876,7927,7932,7946,7970,7998,8037,8061,8071,8199,8203,8275,8276,8293,8328,8339,8413,8440,8447,8451,8498,8513,8540,8569,8593,8704,8710,8773,8776,8781,8830,8853,8916,8917,8983,9029,9046,9077,9108,9148,9191,9201,9202,9223,9244,9322,9323,9331,9341,9475,9637,9650,9652,9672,9747,9818,9839,9866,9909,9942,9964,10009,10010,10078,10079,10165,10178,10261,10294,10308,10340,10345,10348,10595,10665,10673,10708,10775,10967,11030,11147,11165,11241,11314,11439,11441,11444,11552,11591,11603,11626,11692,11698,11790,11943,11961,11967,12060,12116,12128,12181,12219,12223,12225,12385,12595,12620,12622,12623,12625,12630,12705,12717,12718,12752,12760,12892,12894,12902,12925,12945,12957,13002,13010,13078,13248,13473,13479,13578,13646,13688,13759,13814,13895,13950,13959,13968,13969,14005,14047,14048,14181,14204,14229,14293,14304,14350,14368,14434,14438,14448,14457,14462,14468,14516,14542,14570,14592,14719,14800,14834,14852,14864,14881,14987,14993,14997,15021,15243,15317,15321,15372,15408,15495,15505,15530,15552,15651,15816,15839,15850,15904,16142,16214,16249,16282,16283,16309,16328,16347,16349,16370,16421,16423,16488,16508,16536,16537,16549,16580,16607,16641,16724,16763,16817,16911,16998,17002,17148,17150,17185,17216,17291,17349,17379,17458,17485,17501,17529,17626,17640,17646,17751,17799,17851,17869,17882,17921,17947,17960,18033,18103,18110,18122,18127,18158,18193,18202,18212,18225,18231,18239,18251,18277,18284,18286,18301,18309,18321,18380,18382,18422,18433,18441,18490,18516,18546,18549,18571,18580,18602,18611,18630,18644,18661,18690,18770,18780,18803,18994,18999,19028,19050,19052,19096,19104,19130,19178,19184,19187,19219,19276,19319,19325,19328,19335,19370,19389,19398,19413,19445,19454,19492,19501,19503,19554,19555,19556,19574,19617,19703,19716,19720,19731,19795,19808,19840,19877,19898,19904,19972,19992,20003,20027,20059,20067,20076,20111,20120,20139,20160,20195,20208,20209,20248,20250,20251,20252,20254,20256,20271,20279,20282,20351,20443,20500,20501,20520,20590,20609,20667,20681,20767,20883,20888,20910,20940,20945,21032,21064,21068,21102,21109,21115,21163,21205,21229,21266,21282,21321,21340,21349,21376,21393,21402,21408,21411,21412,21414,21459,21467,21490,21508,21535,21541,21594,21721,21735,21774,21841,21853,21870,21873,21935,21961,21998,22005,22046,22082,22132,22175,22244,22245,22246,22257,22377,22385,22401,22438,22525,22549,22603,22647,22736,22792,22887,22929,22948,22962,22979,22988,23041,23106,23132,23168,23300,23319,23332,23434,23590,23598,23622,23675,23722,23801,23817,23903,23907,23922,23926,23944,24175,24193,24200,24330,24356,24361,24413,24421,24447,24478,24518,24597,24703,24708,24725,24799,24989,24990,25023,25315,25331,25336,25458,25475,25557,25609,25665,25685,25687,25690,25694,25834,25891,25981,26017,26024,26034,26062,26204,26226,26288,26315,26328,26369,26386,26447,26455,26509,26520,26530,26630,26646,26659,26680,26688,26731,26802,26918,26945,26967,27183,27184,27199,27345,27354,27374,27379,27458,27518,27584,27612,27616,27806,27808,28218,28366,28601,28636,28686,29002,29061,29814,30486,31640,33749,34096,34160,34699,35095,35153,35214,35384,35474,35560,35585,35716,35750,35778,35789,35791,35811,35865,35985,36051,36130,36196,36267,36292,36299,36341,36517,36591,36594,36598,36604,36769,37083,38016,38610,38613,38652,38777,38796,38917,38946,38971,39041,39051,39171,39225,39384,39483,39527,39531,39571,39590,39682,39697,39790,39821,39967,40385,40386,40387,40456,40742,40811,40983,41052,41068,41156,41292,41298,41376,41442,41559,41790,42286,42310,42343,42483,42502,42503,42533,42602,43018,43425,43426,44537,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 | 971 | 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.49 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.46 ms |
preparing | 0.75 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.41 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.03 ms |
freeing items | 0.10 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 |