Tiempo de la consulta: 8.77 ms Después de la última consulta: 1.10 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.370 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-08 01:17:17')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 01:17:17')
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,8,10,11,25,29,44,45,46,50,52,59,83,89,90,124,131,134,136,137,165,175,180,181,186,188,189,190,197,198,205,206,212,215,216,219,220,221,222,224,226,237,244,246,248,249,250,253,254,257,262,263,271,272,280,287,308,325,327,329,336,366,370,371,385,387,388,390,392,393,394,395,397,398,400,401,402,403,404,405,408,410,411,412,413,414,419,423,424,427,433,434,435,436,437,438,439,442,443,444,445,448,451,454,455,474,481,500,511,524,563,589,596,603,609,615,625,641,642,646,647,648,650,651,652,654,667,681,684,686,687,689,701,760,814,818,824,845,854,856,875,936,941,950,952,976,985,1044,1047,1066,1071,1114,1119,1145,1185,1215,1226,1227,1264,1266,1267,1268,1269,1270,1272,1273,1274,1275,1276,1277,1278,1290,1314,1316,1317,1339,1359,1388,1389,1390,1394,1467,1491,1534,1574,1637,1659,1664,1686,1709,1721,1765,1778,1788,1805,1863,1896,1932,1963,1979,1996,2081,2162,2221,2353,2428,2455,2485,2569,2637,2732,2751,2855,2869,3126,3150,3181,3291,3353,3398,3417,3473,3531,3544,3559,3562,3569,3592,3595,3630,3668,3684,3801,3868,3870,4063,4199,4249,4260,4287,4338,4378,4547,4578,4612,4613,4614,4615,4617,4641,4688,4765,4799,4808,4815,4855,4911,4935,4965,5053,5062,5098,5147,5151,5166,5184,5195,5263,5273,5374,5406,5415,5519,5585,5730,5756,5782,5785,5833,5835,5852,5870,5906,5927,6014,6032,6069,6176,6222,6226,6276,6315,6373,6393,6448,6475,6510,6542,6543,6639,6641,6657,6666,6677,6716,6779,6783,6889,6924,6939,7004,7048,7194,7222,7245,7269,7291,7357,7405,7421,7423,7446,7486,7492,7507,7516,7534,7546,7556,7560,7591,7596,7597,7696,7719,7801,7812,7904,7926,7965,7966,7967,7968,8054,8060,8132,8178,8294,8296,8299,8306,8357,8377,8406,8418,8551,8572,8610,8613,8678,8710,8760,8774,8810,8835,8864,8909,8910,8923,8940,8948,8995,9046,9096,9110,9112,9140,9180,9186,9190,9199,9252,9362,9381,9416,9472,9541,9576,9641,9685,9731,9745,9757,9779,9873,9915,9934,9964,10014,10044,10046,10092,10113,10147,10186,10342,10407,10415,10553,10604,10774,10927,11091,11206,11235,11419,11436,11441,11465,11468,11549,11590,11641,11651,11706,11750,11772,11791,11979,12025,12071,12204,12324,12334,12413,12440,12475,12482,12550,12624,12625,12750,12795,12845,12913,12943,12973,12998,13004,13036,13065,13069,13070,13094,13121,13153,13209,13263,13348,13387,13560,13575,13725,13728,13803,13894,13900,14005,14027,14048,14052,14083,14146,14149,14183,14205,14226,14232,14352,14451,14494,14577,14583,14684,14687,14722,14741,14752,14840,14846,14857,14860,14862,14889,14892,14895,14906,14954,14969,15077,15090,15109,15133,15184,15186,15279,15470,15476,15500,15567,15596,15598,15627,15644,15663,15674,15715,15751,15753,15755,15832,15895,15901,15902,15960,15966,15998,15999,16010,16040,16055,16078,16088,16148,16157,16176,16219,16284,16401,16417,16542,16550,16570,16588,16609,16639,16669,16706,16844,16872,16876,16909,16913,16936,16994,16996,17014,17015,17131,17142,17153,17186,17251,17424,17427,17437,17492,17500,17543,17565,17580,17608,17629,17643,17690,17703,17725,17746,17757,17918,17959,18014,18068,18071,18160,18228,18240,18260,18262,18276,18284,18306,18311,18382,18423,18491,18503,18516,18552,18582,18599,18642,18702,18705,18744,18839,18847,18850,18853,18895,18937,19019,19112,19145,19184,19222,19286,19288,19313,19316,19359,19432,19455,19533,19556,19562,19565,19607,19670,19703,19720,19742,19758,19783,19806,20076,20091,20094,20104,20117,20150,20262,20271,20425,20441,20637,20704,20713,20776,20795,20832,20890,20933,20960,21013,21040,21075,21090,21110,21116,21149,21156,21174,21198,21200,21274,21290,21340,21378,21435,21485,21494,21540,21565,21609,21659,21660,21714,21749,21775,21777,21819,21861,21864,21895,21995,22129,22286,22294,22313,22337,22345,22352,22362,22400,22404,22411,22457,22476,22534,22551,22573,22615,22676,22693,22709,22715,22737,22767,22797,22850,22854,22855,22899,22903,22920,22941,22963,22978,23019,23045,23110,23115,23213,23229,23260,23269,23313,23317,23319,23332,23353,23373,23397,23430,23457,23482,23520,23544,23569,23646,23685,23695,23732,23788,23850,23859,23860,23872,23879,23881,23943,24011,24107,24164,24172,24207,24213,24248,24258,24414,24434,24437,24439,24458,24475,24565,24580,24617,24666,24766,24823,24854,24880,24894,24896,24922,24927,24967,24993,25001,25013,25040,25073,25091,25094,25114,25130,25167,25170,25193,25200,25281,25296,25321,25356,25367,25371,25372,25390,25391,25393,25414,25431,25433,25446,25451,25457,25459,25464,25465,25467,25468,25470,25472,25476,25482,25485,25486,25489,25490,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25512,25517,25536,25537,25538,25540,25545,25546,25552,25559,25569,25572,25576,25578,25582,25587,25588,25596,25648,25674,25693,25890,25916,25937,25941,25953,25974,26013,26030,26043,26044,26047,26124,26154,26166,26193,26215,26218,26257,26262,26317,26359,26362,26375,26376,26405,26412,26464,26506,26554,26572,26577,26578,26579,26627,26653,26683,26694,26727,26744,26752,26785,26787,26796,26835,26842,26843,26864,26885,26897,26933,26962,26968,27030,27059,27067,27095,27123,27143,27181,27183,27197,27305,27342,27518,27552,27582,27724,27832,27911,27921,27923,27924,27926,28390,28416,28423,28440,28442,28534,28635,28714,28741,28751,28808,28817,28870,28889,28930,29222,29223,29235,29242,29380,29611,29777,29814,29864,29935,30280,30381,31463,31533,31560,31640,31684,31725,31821,31852,31899,31908,31937,32010,32458,32472,32679,33331,33422,33475,33605,33740,34030,34067,34071,34159,34170,34243,34262,34270,34375,34428,34611,34722,34867,34956,35009,35266,35485,35628,35632,35643,35667,35713,35744,35759,35784,35822,35881,35926,35948,36007,36143,36160,36214,36251,36283,36339,36382,36617,36620,36833,36838,36847,36949,37002,37056,37158,37411,37422,37524,37532,37688,37758,37796,37806,37942,38071,38129,38199,38363,38452,38585,38664,38665,38719,38762,38818,38855,38884,38887,38898,38933,38960,39215,39227,39231,39271,39342,39397,39466,39561,39600,39687,39769,39826,39839,39896,39897,39906,39958,39964,39977,40015,40025,40052,40082,40116,40183,40292,40332,40344,40414,40530,40588,40650,40672,40684,40703,40736,40760,41070,41095,41134,41188,41204,41406,41464,41503,41532,41601,41677,41681,41706,41778,41788,41794,41861,42107,42185,42205,42387,42396,42408,42590,42639,42708,42716,42836,42890,42900,42952,42991,42993,42998,43050,43051,43078,43114,43120,43191,43247,43248,43274,43291,43300,43301,43335,43360,43365,43386,43398,43412,43424,43528,43546,43599,43651,43688,43700,43716,43725,43857,43885,43942,44013,44046,44051,44060,44079,44094,44120,44128,44141,44159,44165,44175,44200,44208,44229,44263,44277,44282,44312,44327,44361,44382,44387,44406,44422,44447,44453,44458,44479,44487,44500,44517,44518,44535,44562,44609,44662,44682,44761,44762,44786,44797,44815,44848,44858,44880,44911,44950,45008,45024,45050,45086,45106,45131,45152,45183,45196,45208,45209,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 | 1207 | 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.54 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.77 ms |
preparing | 0.93 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.19 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.09 ms |
cleaning up | 0.03 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 |