Tiempo de la consulta: 9.40 ms Después de la última consulta: 1.11 ms Consulta a la memoria: 1.065 MB memoria antes de la consulta: 4.372 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 13:59:43')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 13:59: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(4,7,9,11,25,28,30,56,60,66,70,71,72,73,75,78,81,86,94,117,120,126,165,167,180,201,216,255,263,265,271,275,276,281,304,305,306,316,317,340,354,368,377,390,463,472,493,495,515,519,549,583,584,592,593,607,611,613,621,635,686,723,728,731,740,741,742,758,791,816,825,841,855,868,883,891,895,900,908,917,919,931,954,955,958,963,1007,1020,1029,1031,1052,1056,1103,1144,1148,1168,1181,1187,1188,1206,1207,1217,1229,1257,1265,1271,1287,1296,1298,1302,1313,1336,1338,1344,1354,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1442,1443,1470,1477,1478,1506,1507,1519,1524,1531,1532,1537,1558,1560,1568,1572,1598,1610,1613,1681,1695,1718,1719,1823,1905,1932,1978,2096,2145,2178,2194,2207,2209,2229,2236,2245,2272,2290,2293,2305,2314,2315,2316,2332,2333,2342,2365,2373,2376,2410,2453,2459,2476,2481,2493,2503,2511,2516,2524,2539,2564,2579,2594,2603,2639,2644,2695,2720,2728,2763,2765,2780,2796,2817,2830,2863,2886,2887,2892,2920,2926,2931,2942,3016,3038,3063,3068,3073,3112,3117,3126,3129,3137,3143,3163,3187,3208,3222,3235,3293,3327,3359,3382,3388,3393,3418,3419,3425,3436,3452,3457,3468,3486,3512,3516,3522,3546,3556,3574,3579,3582,3587,3602,3604,3657,3675,3700,3709,3796,3812,3827,3840,3864,3880,3979,3986,4015,4074,4114,4153,4209,4231,4309,4335,4343,4488,4525,4549,4577,4580,4599,4631,4632,4654,4684,4688,4689,4691,4718,4739,4779,4784,4808,4841,4847,4871,4878,4902,4949,4971,4999,5016,5020,5051,5099,5180,5239,5323,5333,5350,5365,5378,5386,5414,5431,5451,5470,5507,5566,5569,5572,5579,5588,5594,5597,5632,5645,5647,5650,5659,5662,5675,5722,5726,5727,5729,5730,5747,5822,5870,5894,6006,6010,6038,6127,6141,6217,6272,6292,6348,6349,6354,6359,6363,6392,6405,6445,6470,6473,6475,6476,6477,6485,6520,6522,6542,6543,6545,6568,6573,6616,6630,6656,6675,6677,6688,6723,6742,6744,6835,6860,6870,6889,6895,6906,6936,6975,6985,7015,7056,7082,7086,7096,7099,7110,7181,7212,7232,7275,7299,7309,7334,7343,7417,7466,7483,7489,7495,7525,7545,7555,7556,7586,7588,7680,7718,7719,7730,7741,7742,7832,7837,7839,7860,7868,7932,7934,7946,7950,7959,7965,7970,7994,7997,7998,8003,8026,8027,8037,8061,8071,8074,8109,8143,8199,8275,8276,8339,8381,8451,8498,8508,8540,8549,8569,8593,8691,8704,8773,8776,8781,8853,8860,8983,9029,9051,9148,9191,9201,9223,9322,9398,9475,9650,9704,9818,9839,9853,9942,10009,10078,10079,10110,10120,10176,10203,10250,10261,10268,10295,10306,10308,10311,10326,10340,10345,10348,10384,10595,10628,10665,10673,10696,10697,10708,10775,10872,10951,10954,10971,10974,10982,11015,11030,11032,11063,11083,11090,11108,11150,11173,11178,11224,11226,11241,11328,11383,11394,11439,11441,11479,11534,11558,11603,11626,11692,11712,11766,11883,11944,11967,11987,12060,12115,12116,12128,12181,12219,12223,12225,12306,12307,12334,12385,12449,12545,12554,12595,12620,12622,12623,12624,12625,12630,12705,12717,12718,12752,12760,12789,12834,12894,12925,12945,12957,13002,13010,13078,13172,13225,13241,13248,13425,13456,13473,13508,13611,13675,13741,13759,13851,13855,13959,13968,13972,13998,14005,14047,14048,14097,14114,14141,14181,14183,14204,14205,14229,14236,14281,14291,14293,14350,14361,14366,14385,14457,14468,14507,14516,14542,14570,14572,14592,14684,14811,14852,14856,14987,15038,15069,15217,15277,15304,15310,15321,15372,15408,15411,15475,15477,15495,15516,15524,15530,15551,15651,15744,15750,15757,15839,15850,15866,15903,15935,16161,16214,16249,16317,16347,16356,16366,16370,16415,16421,16423,16431,16432,16451,16515,16537,16538,16562,16580,16632,16645,16763,16775,16837,16996,17002,17019,17034,17090,17115,17132,17138,17148,17185,17205,17227,17228,17234,17242,17285,17291,17307,17379,17407,17458,17501,17510,17529,17634,17640,17646,17703,17753,17766,17799,17813,17822,17851,17852,17869,17921,17925,17935,17947,17950,17956,17960,17993,18018,18032,18110,18115,18121,18122,18127,18158,18200,18212,18260,18273,18276,18277,18282,18284,18286,18294,18301,18309,18311,18321,18360,18378,18380,18388,18433,18490,18505,18516,18549,18562,18571,18580,18590,18593,18630,18668,18670,18674,18682,18690,18698,18730,18733,18770,18773,18780,18793,18846,18874,18948,18949,18994,18999,19018,19026,19028,19051,19052,19064,19073,19117,19130,19133,19134,19175,19178,19184,19207,19219,19288,19322,19325,19335,19349,19366,19370,19371,19381,19389,19429,19444,19445,19454,19484,19492,19501,19508,19516,19541,19545,19555,19574,19576,19596,19604,19606,19617,19639,19658,19667,19713,19727,19731,19744,19764,19825,19853,19882,19898,19962,19972,19975,19976,20003,20029,20033,20059,20067,20089,20099,20111,20120,20127,20149,20174,20195,20220,20248,20250,20252,20256,20271,20279,20291,20317,20397,20398,20437,20443,20455,20500,20532,20542,20549,20587,20590,20609,20621,20651,20654,20665,20667,20668,20681,20686,20707,20714,20739,20764,20785,20790,20797,20800,20820,20888,20897,20945,20973,20977,20993,20996,21039,21101,21113,21115,21163,21174,21216,21229,21266,21274,21280,21292,21321,21322,21340,21346,21372,21393,21420,21450,21459,21467,21490,21508,21579,21584,21586,21667,21721,21735,21739,21774,21781,21798,21846,21852,21853,21870,21921,21950,21961,22005,22008,22010,22038,22082,22098,22124,22132,22150,22171,22175,22212,22257,22290,22307,22312,22318,22334,22385,22389,22455,22525,22647,22672,22688,22706,22736,22741,22753,22802,22803,22820,22831,22852,22854,22901,22935,22979,23046,23070,23097,23132,23148,23168,23243,23253,23267,23305,23332,23363,23383,23423,23433,23449,23484,23488,23501,23566,23598,23615,23617,23635,23648,23675,23676,23722,23730,23790,23816,23817,23838,23907,23922,23926,23978,23990,23992,24024,24025,24118,24147,24175,24193,24219,24361,24403,24411,24413,24433,24440,24456,24475,24478,24513,24557,24597,24616,24701,24703,24732,24748,24799,24830,24841,24941,24989,25048,25080,25135,25277,25287,25301,25331,25336,25386,25412,25443,25452,25458,25475,25535,25557,25560,25561,25591,25657,25685,25687,25690,25694,25767,25888,25891,25934,25946,25981,25990,26043,26062,26102,26161,26166,26167,26204,26226,26228,26317,26369,26373,26386,26483,26488,26499,26509,26519,26520,26525,26530,26630,26659,26680,26731,26802,26901,26930,26989,27014,27041,27074,27125,27183,27184,27199,27354,27359,27362,27397,27407,27427,27471,27491,27518,27616,27762,27806,27808,28218,28327,28339,28366,28601,28630,28636,28682,28799,28803,28928,29002,29022,29285,29473,29500,29626,29924,30284,30285,30486,31010,31640,33877,34699,35095,35153,35585,35750,35762,35778,35845,35865,35925,35980,36051,36130,36196,36267,36292,36299,36321,36336,36341,36378,36588,36591,36594,36598,36604,36769,37083,37749,37750,38339,38610,38613,38652,38777,38946,38961,38971,39041,39063,39171,39225,39323,39384,39467,39483,39542,39571,39590,39646,39666,39682,39790,39819,39821,40347,40385,40386,40387,40456,40742,40983,41068,41298,41350,41442,41984,41985,42310,42314,42570,42602,43018,43425,43426,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 | 1220 | 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.65 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.24 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.85 ms |
preparing | 0.95 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.93 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
freeing items | 0.15 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 |