Tiempo de la consulta: 16.93 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.363 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-04 13:19:14')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 13:19:14')
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,32,62,70,71,72,73,75,163,174,263,275,287,357,463,583,607,726,816,860,868,892,895,917,1182,1207,1226,1289,1346,1519,1538,1696,1823,1883,1919,2013,2188,2290,2293,2303,2305,2365,2392,2531,2647,2866,2886,2887,2954,3054,3055,3109,3174,3180,3208,3364,3393,3451,3452,3454,3571,3604,3663,3680,3700,3880,3898,3918,3986,4052,4114,4166,4209,4258,4409,4625,4699,4713,4739,4767,4823,4863,4932,5161,5247,5396,5438,5451,5478,5686,5881,5886,5894,6017,6056,6088,6141,6294,6465,6472,6526,6542,6543,6545,6616,6936,6988,7013,7014,7099,7155,7246,7272,7276,7336,7337,7364,7412,7417,7437,7439,7457,7489,7672,7718,7720,7741,7806,7829,7847,7897,7923,7934,7950,7965,7982,8026,8027,8061,8074,8090,8116,8381,8457,8615,8652,8760,8780,8860,8916,8917,8932,9029,9087,9204,9364,9398,9429,9434,9554,9704,9773,9853,9924,10120,10176,10268,10307,10384,10475,10553,10628,10630,10659,10694,10696,10783,10894,10924,10958,10971,10982,11032,11059,11083,11091,11108,11122,11127,11143,11150,11157,11224,11258,11309,11328,11383,11402,11407,11446,11497,11534,11585,11587,11614,11721,11727,11839,11899,11915,11929,11944,11968,11987,12018,12038,12040,12091,12098,12109,12115,12133,12192,12218,12306,12307,12331,12401,12449,12463,12474,12554,12617,12620,12622,12625,12673,12686,12735,12789,12810,12834,12848,12853,12875,12901,12903,12916,12944,12991,13141,13172,13198,13246,13294,13298,13331,13346,13418,13425,13595,13611,13627,13675,13677,13687,13697,13741,13742,13804,13951,13963,13972,13990,14073,14074,14080,14082,14097,14104,14114,14117,14141,14150,14196,14222,14227,14236,14244,14262,14267,14273,14278,14281,14385,14440,14456,14469,14507,14563,14572,14574,14632,14646,14683,14698,14747,14759,14770,14794,14799,14827,14842,14855,14960,14964,14983,14992,15006,15032,15037,15048,15069,15094,15108,15111,15129,15139,15146,15175,15206,15213,15247,15277,15303,15370,15382,15411,15471,15475,15492,15524,15548,15565,15575,15631,15641,15668,15725,15731,15750,15757,15782,15829,15935,16000,16053,16092,16093,16140,16153,16161,16169,16206,16326,16356,16373,16374,16375,16415,16442,16458,16459,16515,16534,16640,16645,16688,16827,16832,16864,16889,16929,16981,16996,17090,17115,17128,17130,17132,17205,17215,17221,17227,17228,17234,17257,17273,17375,17381,17382,17407,17432,17436,17484,17488,17541,17596,17600,17634,17679,17701,17702,17724,17733,17753,17757,17766,17813,17818,17822,17840,17852,17864,17874,17895,17925,17935,17938,17956,17961,17966,17980,17991,17993,18018,18031,18032,18123,18138,18144,18156,18185,18200,18259,18260,18261,18267,18282,18303,18326,18356,18369,18370,18384,18396,18442,18445,18453,18498,18505,18528,18561,18562,18564,18577,18580,18584,18593,18599,18609,18612,18668,18682,18686,18718,18733,18735,18773,18793,18813,18829,18847,18853,18869,18874,18904,18910,18920,18927,18942,18949,18973,18977,18982,18985,18991,18995,19000,19018,19022,19026,19041,19073,19083,19091,19110,19112,19117,19132,19133,19134,19136,19149,19175,19185,19217,19223,19242,19247,19270,19294,19312,19313,19350,19366,19371,19381,19417,19429,19436,19446,19453,19503,19508,19524,19545,19567,19571,19576,19581,19595,19596,19602,19604,19606,19608,19643,19650,19655,19661,19667,19671,19684,19700,19701,19713,19718,19728,19744,19764,19769,19780,19815,19825,19829,19853,19867,19882,19894,19905,19930,19932,19941,19952,19962,19983,19991,20019,20029,20030,20034,20036,20044,20062,20069,20123,20133,20145,20149,20183,20199,20259,20291,20298,20307,20323,20326,20344,20354,20358,20363,20367,20374,20380,20398,20403,20440,20442,20444,20455,20488,20517,20542,20578,20587,20611,20629,20636,20638,20649,20651,20659,20705,20707,20714,20755,20764,20768,20797,20820,20826,20856,20875,20884,20923,20942,20945,20950,20962,20977,20993,21000,21012,21101,21118,21142,21161,21165,21178,21182,21186,21242,21245,21252,21274,21292,21305,21308,21312,21322,21323,21372,21402,21420,21433,21450,21458,21464,21477,21498,21512,21519,21522,21541,21544,21546,21554,21579,21584,21586,21593,21611,21616,21637,21667,21714,21737,21739,21755,21758,21798,21851,21882,21897,21921,21952,22002,22010,22023,22059,22064,22084,22092,22100,22165,22171,22188,22198,22237,22244,22245,22246,22252,22271,22285,22290,22307,22318,22322,22337,22341,22408,22419,22435,22439,22455,22469,22478,22480,22492,22500,22502,22517,22527,22557,22610,22614,22668,22673,22688,22708,22715,22725,22741,22742,22794,22820,22831,22852,22874,22883,22885,22901,22935,23000,23022,23034,23038,23041,23046,23060,23061,23068,23070,23081,23122,23135,23148,23188,23196,23200,23219,23234,23243,23247,23250,23253,23286,23305,23342,23344,23375,23419,23423,23433,23442,23449,23467,23484,23516,23521,23546,23551,23559,23564,23595,23615,23617,23631,23635,23668,23691,23697,23703,23767,23772,23777,23852,23857,23874,23896,23915,23922,23926,23930,23956,23959,23961,23962,23967,23984,23985,23990,23992,24010,24024,24072,24075,24076,24111,24141,24174,24230,24295,24304,24346,24392,24433,24440,24456,24458,24475,24513,24523,24532,24574,24607,24616,24632,24660,24664,24673,24691,24707,24727,24748,24768,24788,24789,24823,24830,24844,24857,24867,24904,24907,24924,24968,24988,25003,25048,25080,25123,25126,25135,25189,25190,25206,25241,25273,25277,25311,25333,25344,25349,25360,25373,25374,25421,25491,25534,25624,25639,25657,25755,25764,25798,25946,25987,25990,26107,26122,26161,26176,26219,26228,26256,26274,26317,26361,26454,26467,26475,26522,26563,26564,26689,26767,26779,26800,26816,26901,26910,26926,26976,26982,26986,27026,27041,27125,27131,27151,27186,27261,27314,27356,27362,27363,27427,27438,27452,27472,27506,27558,27572,27891,28005,28254,28327,28397,28424,28630,28780,28803,28807,28824,28845,29010,29021,29022,29089,29124,29250,29256,29281,29332,29355,29358,29476,29617,29648,29810,29868,29919,29930,30099,30285,31199,31227,31499,31516,32051,32250,32302,32381,32507,32590,32843,32896,32943,33040,33129,33199,33649,33815,33877,34078,34099,34109,34179,34184,34229,34241,34258,34260,34269,34292,34326,34343,34357,36893,36916,36918,37315,37380,37874,37996,38056,38066,38361,38455,38734,38775,38812,39307,39358,39384,39452,39504,39516,39542,39642,39646,39666,39819,39966,40116,40145,40169,40271,40312,40313,40314,40360,40542,40801,40806,40822,40850,40984,40990,41036,41063,41336,41350,41364,41402,41423,41811,41885,42460,42489,43680,43705,43706,43707,43914,43915,43917,44031,44041,44497,44681,45115,45160,45206,45252)
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 | 1078 | 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.51 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.20 ms |
System lock | 0.02 ms |
optimizing | 0.08 ms |
statistics | 1.68 ms |
preparing | 0.92 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 12.05 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.03 ms |
freeing items | 0.09 ms |
cleaning up | 0.07 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 |