Tiempo de la consulta: 4.52 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.301 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 12:59:29')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 12:59:29')
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(49,58,71,131,134,136,137,145,164,225,325,337,338,339,340,342,343,345,346,347,348,349,350,352,437,466,471,476,482,511,612,640,669,679,686,692,782,797,823,844,851,905,952,986,1012,1022,1044,1047,1157,1185,1207,1226,1277,1317,1339,1367,1664,2337,2476,2485,2545,2576,2710,2880,3020,3064,3082,3126,3211,3254,3353,3427,3436,3440,3464,3668,3715,3866,3922,3985,4245,4289,4355,4378,4485,4495,4622,4710,4720,4894,4988,5298,5472,5647,5785,5798,5870,5972,6113,6132,6278,6279,6317,6374,6442,6448,6546,6549,6597,6609,6610,6612,6653,6680,6689,6698,6706,6722,6729,6763,6866,6873,6894,6912,6958,6987,7023,7046,7053,7054,7195,7223,7242,7245,7269,7291,7323,7324,7375,7382,7383,7415,7435,7466,7486,7515,7527,7546,7551,7569,7613,7617,7618,7711,7719,7747,7778,7819,7838,7860,7920,7929,7953,7967,7969,7976,8027,8040,8045,8046,8054,8073,8074,8104,8133,8185,8187,8192,8217,8225,8227,8240,8242,8273,8291,8295,8314,8610,8663,8909,9401,9606,9779,10092,10239,10389,10415,10423,10442,10562,10761,10927,10957,11002,11046,11111,11206,11390,11419,11441,11468,11503,11788,12025,12160,12204,12300,12403,12475,12517,12521,12562,12625,12668,13004,13034,13036,13105,13117,13387,13404,13692,13732,13840,13919,13965,14077,14083,14127,14144,14201,14205,14208,14232,14245,14349,14483,14503,14583,14615,14658,14684,14703,14722,14750,14768,14808,14831,14840,14954,14985,15109,15111,15150,15178,15188,15195,15273,15305,15355,15438,15491,15520,15541,15577,15639,15722,15740,15755,15761,15785,15786,15838,15874,15905,15930,15940,15949,15966,15981,15995,16063,16088,16148,16227,16366,16417,16461,16542,16561,16609,16625,16626,16690,16777,16819,16848,16872,16880,16926,16984,17050,17124,17153,17155,17186,17273,17314,17405,17437,17466,17489,17555,17610,17659,17665,17703,17716,17759,17974,17975,17999,18008,18030,18045,18081,18101,18163,18218,18242,18250,18260,18262,18277,18293,18311,18348,18365,18410,18443,18448,18451,18496,18503,18519,18552,18585,18625,18641,18642,18702,18705,18723,18747,18762,18796,18811,18814,18827,18839,18847,18850,18853,18875,18883,18937,18947,18981,19004,19045,19107,19145,19165,19184,19189,19222,19229,19255,19260,19314,19378,19406,19416,19418,19447,19452,19455,19485,19511,19556,19565,19634,19670,19687,19707,19720,19731,19792,19795,19812,19832,19870,19908,19954,20040,20076,20091,20104,20129,20140,20196,20245,20261,20318,20348,20357,20363,20379,20425,20429,20443,20461,20542,20553,20634,20653,20662,20695,20731,20758,20775,20890,20899,20917,20932,20933,20957,20960,20983,21075,21110,21116,21119,21137,21239,21323,21343,21350,21378,21384,21447,21479,21492,21494,21540,21545,21546,21609,21659,21714,21749,21777,21864,21880,21895,21945,22027,22079,22091,22123,22187,22256,22306,22340,22345,22364,22407,22432,22480,22492,22519,22529,22559,22561,22605,22693,22709,22715,22734,22819,22850,22858,22903,22911,22920,22950,22978,23014,23033,23052,23055,23069,23078,23147,23190,23213,23239,23242,23262,23276,23295,23309,23317,23318,23326,23347,23353,23373,23397,23438,23456,23457,23463,23519,23520,23544,23568,23569,23611,23617,23626,23638,23646,23653,23662,23693,23695,23732,23774,23795,23859,23872,23878,23925,23953,23970,24064,24106,24132,24145,24195,24207,24236,24258,24268,24278,24301,24329,24378,24386,24418,24428,24437,24439,24471,24487,24565,24568,24577,24581,24634,24668,24773,24795,24813,24825,24862,24899,25065,25110,25170,25193,25200,25225,25246,25281,25341,25356,25359,25386,25412,25470,25490,25512,25590,25681,25693,25726,25762,25820,25843,25850,25869,25965,25971,26112,26175,26177,26218,26257,26375,26412,26435,26444,26684,26744,26760,26835,26842,26843,26864,26933,27059,27060,27076,27197,27305,27404,27438,27525,27703,27832,27911,27921,27923,27924,27926,27957,28000,28979,29223,29235,29380,29611,29613,29719,29777,29814,29864,30280,31640,31908,33749,34115,35628,35632,35667,35713,35744,35759,35784,36949,38884,38898,38960,39600,40332,40414,40684,42054)
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 | 680 | 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.41 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.10 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.37 ms |
preparing | 0.76 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.44 ms |
end | 0.02 ms |
query end | 0.08 ms |
closing tables | 0.02 ms |
freeing items | 0.04 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 |