Tiempo de la consulta: 10.74 ms Después de la última consulta: 1.26 ms Consulta a la memoria: 1.080 MB memoria antes de la consulta: 4.398 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:55:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 17:55:49')
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,60,66,78,81,94,113,117,120,126,167,180,181,198,201,215,216,221,224,225,254,262,265,267,280,304,305,306,316,317,318,325,340,354,368,377,390,394,463,474,493,495,515,519,522,549,584,592,593,596,621,635,641,642,650,681,686,728,731,733,740,741,742,791,802,825,841,854,855,875,891,904,908,931,941,954,955,976,1007,1020,1029,1052,1066,1071,1103,1168,1187,1188,1229,1257,1265,1266,1267,1287,1296,1298,1302,1313,1336,1338,1339,1344,1348,1354,1359,1367,1380,1392,1402,1406,1413,1420,1421,1430,1433,1435,1441,1443,1467,1470,1478,1506,1507,1524,1531,1532,1534,1537,1558,1563,1568,1572,1573,1574,1598,1637,1659,1681,1686,1695,1709,1719,1721,1743,1753,1778,1805,1823,1891,1896,1905,2020,2053,2096,2145,2178,2194,2207,2209,2221,2229,2236,2245,2314,2315,2316,2332,2333,2342,2373,2376,2410,2428,2453,2455,2459,2476,2481,2503,2511,2516,2524,2564,2579,2594,2644,2695,2720,2728,2765,2817,2830,2855,2869,2926,2927,2942,3005,3063,3073,3085,3112,3117,3126,3129,3137,3143,3163,3187,3222,3235,3265,3293,3327,3382,3388,3393,3398,3436,3457,3486,3546,3556,3574,3579,3582,3587,3595,3602,3630,3657,3668,3675,3709,3745,3796,3801,3827,3840,3855,3864,3868,3870,3969,3979,4015,4055,4074,4152,4153,4165,4173,4182,4309,4335,4338,4343,4405,4433,4434,4488,4525,4547,4578,4582,4631,4632,4644,4654,4684,4688,4689,4691,4718,4784,4792,4799,4808,4841,4847,4855,4871,4902,4911,4914,4933,4935,4949,4965,4971,4999,5016,5020,5051,5053,5062,5065,5098,5099,5147,5151,5166,5179,5180,5184,5195,5211,5263,5273,5302,5323,5363,5367,5374,5378,5406,5431,5439,5470,5519,5566,5569,5572,5579,5585,5588,5593,5594,5597,5632,5645,5650,5659,5662,5722,5726,5727,5729,5747,5756,5782,5822,5835,5852,5870,5872,5906,5924,5927,6006,6010,6014,6032,6069,6217,6222,6226,6272,6276,6292,6348,6349,6354,6359,6363,6373,6392,6432,6445,6451,6510,6542,6543,6568,6641,6666,6675,6677,6716,6779,6780,6880,6924,6939,6975,7004,7048,7056,7082,7086,7095,7096,7099,7110,7181,7212,7222,7260,7275,7299,7309,7325,7329,7334,7423,7424,7446,7466,7495,7520,7534,7555,7556,7560,7680,7719,7720,7751,7771,7797,7812,7837,7839,7860,7868,7904,7926,7932,7946,7968,7970,7998,8037,8060,8061,8071,8094,8101,8178,8199,8224,8261,8275,8276,8294,8296,8299,8306,8339,8357,8418,8428,8451,8498,8540,8569,8572,8593,8661,8678,8704,8710,8773,8776,8779,8781,8810,8835,8853,8923,8940,8948,8963,8983,8995,8999,9029,9030,9038,9046,9096,9110,9111,9140,9148,9180,9186,9190,9191,9199,9201,9223,9252,9262,9263,9322,9362,9381,9384,9398,9426,9443,9444,9475,9541,9576,9641,9650,9685,9689,9715,9731,9755,9818,9820,9829,9839,9873,9901,9915,9942,10009,10014,10044,10046,10068,10078,10079,10113,10147,10214,10261,10308,10340,10342,10345,10348,10388,10402,10407,10481,10595,10665,10673,10708,10751,10774,10775,10886,11030,11038,11041,11159,11179,11229,11241,11279,11398,11436,11439,11441,11465,11499,11549,11575,11590,11603,11626,11692,11701,11706,11750,11757,11772,11791,11859,11967,11973,11979,12060,12116,12128,12158,12181,12219,12223,12225,12324,12334,12357,12385,12440,12550,12595,12620,12622,12623,12625,12630,12640,12651,12705,12717,12718,12747,12752,12760,12795,12894,12925,12945,12957,12998,13002,13010,13036,13065,13069,13070,13078,13094,13121,13209,13228,13248,13263,13265,13454,13473,13670,13728,13759,13803,13894,13907,13926,13959,13970,14005,14047,14048,14085,14146,14159,14181,14190,14204,14229,14278,14279,14293,14350,14352,14457,14468,14484,14494,14516,14542,14570,14577,14592,14685,14723,14741,14747,14752,14815,14852,14857,14889,14969,14987,15047,15077,15090,15091,15126,15133,15154,15184,15186,15218,15279,15321,15372,15408,15495,15530,15598,15627,15644,15651,15732,15751,15753,15839,15850,15863,15895,15902,15910,15927,15960,15998,16010,16040,16055,16078,16142,16214,16219,16249,16284,16311,16313,16320,16347,16365,16370,16401,16421,16423,16502,16535,16537,16545,16570,16580,16588,16712,16763,16828,16879,16910,16913,16916,17002,17014,17085,17148,17185,17291,17379,17458,17501,17529,17562,17580,17615,17629,17640,17643,17646,17667,17692,17750,17781,17799,17819,17820,17851,17869,17921,17947,17959,17960,18014,18040,18068,18073,18110,18122,18127,18158,18212,18244,18276,18277,18284,18286,18293,18301,18306,18309,18321,18357,18380,18382,18420,18423,18433,18490,18491,18516,18549,18564,18571,18578,18579,18580,18582,18591,18599,18630,18686,18690,18700,18734,18744,18747,18770,18771,18780,18829,18843,18853,18860,18990,18994,18999,19019,19028,19052,19112,19130,19139,19152,19178,19184,19216,19219,19255,19286,19316,19325,19335,19359,19370,19389,19432,19445,19454,19476,19492,19501,19505,19510,19533,19555,19562,19574,19591,19607,19617,19731,19742,19758,19760,19783,19829,19898,19900,19949,19972,20003,20059,20067,20080,20111,20120,20150,20195,20218,20230,20248,20250,20252,20256,20271,20279,20307,20341,20409,20440,20443,20500,20590,20609,20637,20667,20681,20704,20713,20740,20776,20800,20832,20888,20900,20901,20945,21013,21031,21042,21054,21067,21072,21085,21090,21115,21146,21163,21174,21229,21260,21266,21308,21321,21340,21345,21393,21435,21450,21459,21467,21490,21508,21561,21564,21643,21660,21721,21729,21735,21774,21853,21870,21961,21964,21975,21979,21981,22005,22028,22046,22065,22082,22120,22132,22175,22201,22213,22257,22269,22337,22352,22362,22385,22400,22525,22551,22573,22578,22615,22635,22647,22676,22736,22737,22767,22797,22846,22855,22916,22941,22963,22979,23041,23067,23115,23132,23164,23168,23313,23332,23482,23568,23598,23675,23722,23788,23817,23842,23879,23885,23907,23922,23926,23943,24107,24134,24164,24172,24175,24193,24248,24347,24361,24402,24413,24434,24458,24475,24478,24510,24551,24699,24703,24740,24757,24766,24799,24880,24894,24896,24927,24967,24989,24993,25001,25013,25040,25091,25094,25114,25167,25179,25296,25321,25331,25336,25347,25367,25371,25372,25390,25391,25393,25405,25414,25431,25433,25446,25451,25457,25458,25459,25464,25465,25467,25468,25472,25475,25476,25482,25485,25486,25489,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25517,25536,25537,25538,25540,25545,25546,25552,25557,25559,25569,25572,25576,25578,25582,25587,25588,25596,25674,25685,25687,25690,25694,25891,25937,25941,25953,25981,26044,26047,26062,26204,26226,26362,26369,26386,26506,26509,26520,26530,26548,26554,26572,26577,26578,26630,26653,26659,26680,26683,26694,26731,26785,26787,26796,26802,26902,26962,27049,27067,27095,27123,27183,27184,27199,27342,27354,27616,27761,27806,27808,28218,28366,28440,28534,28601,28635,28636,28741,28751,28870,28930,28999,29002,29222,30486,31463,31533,31640,31725,31975,33605,34030,34071,34159,34243,34262,34270,34375,34611,34699,34956,35095,35153,35266,35585,35643,35750,35778,35822,35865,35881,36007,36051,36130,36143,36151,36196,36251,36267,36292,36299,36339,36341,36382,36591,36594,36598,36604,36617,36620,36769,36838,37002,37056,37083,37411,37422,37524,37532,37568,37688,37758,37796,38071,38199,38363,38452,38585,38610,38613,38652,38664,38665,38719,38762,38763,38777,38933,38946,38971,39041,39171,39225,39227,39231,39397,39483,39571,39590,39682,39687,39769,39790,39821,39826,39896,39897,39958,39964,39977,40025,40082,40112,40183,40292,40385,40386,40387,40456,40502,40530,40650,40703,40742,40983,41068,41070,41095,41134,41188,41204,41298,41442,41464,41503,41601,41677,41681,41778,41861,42107,42185,42205,42310,42387,42396,42590,42602,42639,42708,42716,42836,42890,42900,42952,42991,42993,42998,43018,43050,43051,43078,43114,43120,43191,43247,43248,43274,43291,43300,43301,43335,43360,43365,43386,43398,43412,43424,43425,43426,43528,43546,43599,43651,43688,43700,43716,43725,43885,44013,44046,44051,44060,44079,44094,44120,44128,44159,44165,44175,44200,44208,44229,44263,44282,44312,44327,44382,44387,44406,44422,44447,44453,44458,44479,44487,44500,44517,44562,44609,44662,44682,44761,44762,44786,44797,44906,44950,45008,45024,45050,45086,45106,45131,45152,45183,45196,45208,45209,45227,45257,45275,45309)
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 | 1393 | 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.73 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.30 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.12 ms |
preparing | 1.10 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.43 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.04 ms |
freeing items | 0.12 ms |
cleaning up | 0.06 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 |