Tiempo de la consulta: 8.98 ms Después de la última consulta: 0.76 ms Consulta a la memoria: 0.846 MB memoria antes de la consulta: 4.323 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 02:55:23')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 02:55:23')
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(52,72,181,198,215,216,221,224,225,254,262,280,325,394,474,596,641,642,647,648,650,681,686,726,816,854,860,875,892,976,1066,1071,1207,1226,1266,1267,1339,1359,1467,1534,1574,1637,1659,1686,1709,1721,1778,1805,1883,1896,1932,2221,2428,2455,2855,2869,3208,3398,3452,3595,3630,3801,3868,3870,3898,3918,4258,4338,4547,4578,4625,4799,4855,4911,4932,4935,4965,5053,5062,5098,5147,5151,5166,5184,5195,5263,5273,5374,5406,5438,5519,5585,5756,5782,5835,5852,5906,5927,6014,6032,6069,6222,6226,6276,6294,6373,6510,6542,6543,6641,6666,6677,6716,6779,6924,6936,6939,7004,7032,7048,7222,7337,7351,7412,7423,7446,7457,7534,7556,7560,7653,7806,7812,7829,7847,7888,7904,7926,7968,8060,8178,8294,8296,8299,8306,8357,8418,8572,8615,8678,8710,8780,8810,8835,8916,8917,8923,8932,8940,8948,8995,9020,9046,9096,9110,9140,9144,9180,9186,9190,9199,9252,9362,9381,9541,9576,9641,9685,9717,9731,9873,9915,10014,10044,10046,10113,10147,10342,10407,10505,10585,10659,10753,10774,10894,10924,11083,11086,11091,11122,11127,11143,11157,11309,11407,11436,11465,11497,11549,11585,11587,11590,11614,11706,11721,11727,11750,11772,11791,11839,11915,11979,11987,12018,12038,12040,12091,12098,12109,12133,12306,12324,12334,12440,12449,12550,12673,12735,12795,12848,12903,12916,12991,12998,13065,13069,13070,13094,13121,13141,13198,13209,13263,13331,13346,13418,13425,13595,13611,13627,13655,13677,13697,13728,13779,13803,13894,13951,14048,14073,14080,14097,14104,14114,14146,14150,14196,14222,14227,14236,14267,14278,14352,14469,14494,14563,14574,14577,14632,14741,14742,14747,14752,14770,14799,14827,14842,14857,14889,14960,14969,15006,15069,15077,15090,15133,15146,15175,15184,15186,15206,15279,15303,15565,15567,15598,15627,15631,15641,15644,15668,15731,15751,15753,15895,15902,15960,15998,16010,16040,16053,16055,16078,16169,16219,16284,16356,16401,16415,16442,16458,16556,16570,16588,16601,16640,16645,16688,16736,16827,16864,16913,17014,17130,17221,17227,17228,17436,17488,17580,17600,17629,17643,17679,17701,17724,17766,17822,17852,17874,17938,17959,17966,17991,18014,18068,18123,18138,18156,18185,18259,18261,18276,18284,18303,18306,18356,18370,18382,18396,18423,18445,18453,18491,18505,18516,18528,18564,18567,18580,18582,18584,18599,18668,18686,18744,18793,18813,18829,18853,18874,18973,18985,19019,19041,19112,19117,19175,19217,19223,19242,19286,19312,19316,19359,19371,19417,19432,19436,19503,19533,19567,19571,19602,19604,19607,19643,19671,19701,19728,19742,19758,19764,19769,19780,19783,19829,19882,19905,19952,19962,20019,20062,20123,20133,20149,20150,20259,20298,20307,20323,20326,20367,20380,20442,20444,20488,20517,20587,20610,20611,20629,20637,20704,20705,20713,20776,20797,20820,20832,20875,20884,20923,20942,20962,20993,21012,21013,21056,21090,21101,21142,21165,21174,21186,21245,21308,21312,21340,21402,21420,21435,21458,21477,21498,21512,21519,21541,21544,21554,21611,21616,21624,21637,21660,21724,21729,21755,21758,21851,21882,21897,21921,22023,22064,22084,22092,22100,22165,22171,22188,22198,22237,22252,22271,22285,22290,22322,22337,22341,22352,22362,22400,22408,22439,22469,22478,22480,22500,22551,22557,22573,22610,22614,22615,22676,22725,22737,22741,22767,22794,22797,22803,22855,22885,22899,22935,22941,22963,23038,23046,23061,23064,23115,23135,23148,23188,23253,23305,23313,23342,23362,23419,23442,23482,23521,23551,23595,23615,23631,23697,23777,23788,23852,23879,23915,23943,23956,23961,23985,24107,24164,24172,24248,24295,24304,24433,24434,24440,24456,24475,24532,24574,24616,24632,24660,24664,24691,24707,24748,24766,24768,24789,24830,24880,24894,24896,24907,24927,24967,24988,24993,25001,25013,25040,25080,25091,25094,25114,25123,25167,25206,25241,25277,25296,25321,25344,25357,25367,25371,25372,25374,25390,25391,25393,25414,25431,25433,25446,25451,25457,25459,25464,25465,25467,25468,25472,25476,25481,25482,25485,25486,25489,25491,25492,25493,25494,25495,25499,25504,25506,25508,25509,25510,25517,25536,25537,25538,25540,25545,25546,25552,25559,25569,25572,25576,25578,25582,25587,25588,25596,25674,25755,25870,25937,25941,25953,25990,26044,26047,26161,26256,26274,26362,26407,26506,26554,26563,26572,26577,26578,26653,26683,26689,26694,26785,26787,26796,26901,26962,26986,27067,27095,27123,27261,27314,27342,27472,27600,28254,28440,28534,28635,28741,28751,28807,28870,28930,29222,29250,29281,29332,29355,29476,29868,31463,31533,31725,33605,34030,34071,34159,34243,34262,34270,34375,34611,34956,35266,35643,35822,35881,36007,36143,36251,36339,36382,36617,36620,36838,37002,37056,37411,37422,37524,37532,37688,37758,37796,38071,38199,38363,38452,38585,38664,38665,38719,38762,38933,39227,39231,39397,39642,39687,39769,39826,39896,39897,39958,39964,39977,40025,40082,40116,40145,40183,40271,40292,40530,40650,40703,40984,41070,41095,41134,41188,41204,41364,41464,41503,41601,41677,41681,41778,41861,42107,42185,42205,42387,42396,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,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,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 | 931 | 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.47 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.41 ms |
preparing | 0.71 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 4.52 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.07 ms |
freeing items | 0.06 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 |