Tiempo de la consulta: 4.81 ms Después de la última consulta: 0.94 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.362 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-06 03:30:05')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 03:30:05')
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(5,7,9,14,29,39,49,56,58,60,62,63,65,71,73,86,87,149,161,162,163,165,166,167,174,177,185,196,221,226,240,255,259,262,283,291,299,331,339,343,345,346,349,350,351,352,366,385,391,403,417,428,429,437,472,476,477,481,485,501,502,510,525,530,531,546,563,570,609,619,659,662,663,667,669,674,679,686,689,697,705,708,709,710,711,712,713,746,769,782,783,797,800,802,805,806,808,813,823,832,835,844,851,867,869,873,881,910,911,923,939,940,954,958,963,969,970,974,977,982,983,984,986,999,1004,1005,1011,1012,1017,1021,1055,1091,1095,1114,1119,1137,1158,1182,1205,1207,1224,1226,1231,1247,1252,1253,1255,1268,1271,1276,1277,1289,1298,1308,1309,1319,1344,1347,1363,1409,1410,1428,1432,1441,1444,1469,1485,1503,1509,1555,1557,1606,1619,1629,1648,1675,1693,1694,1724,1771,1794,1795,1796,1808,1810,1843,1854,1855,1862,1899,1918,1920,1930,1960,1961,1975,1984,1994,1995,2001,2008,2013,2015,2035,2075,2088,2101,2107,2137,2155,2157,2161,2293,2455,2517,2527,2532,2548,2551,2586,2597,2638,2643,2814,2824,2851,2883,2888,2960,3008,3027,3055,3064,3069,3100,3107,3147,3154,3169,3207,3312,3364,3368,3369,3387,3409,3412,3427,3464,3473,3520,3531,3548,3552,3554,3562,3590,3648,3683,3689,3748,3750,3794,3853,3858,3872,3913,3919,3922,3962,3983,3991,4034,4050,4068,4105,4110,4129,4247,4327,4468,4492,4529,4532,4558,4616,4620,4622,4626,4666,4720,4751,4752,4767,4813,4815,4822,4831,4844,4846,4865,4933,4973,5055,5134,5153,5160,5220,5370,5415,5469,5512,5559,5596,5647,5730,5780,5795,5999,6148,6173,6198,6301,6311,6313,6349,6354,6363,6369,6372,6391,6420,6435,6442,6476,6477,6542,6543,6548,6593,6633,6660,6723,6724,6807,6808,6845,6855,6878,6912,6944,6958,6964,7018,7022,7026,7030,7048,7093,7124,7137,7195,7212,7242,7258,7296,7324,7342,7407,7415,7418,7491,7535,7551,7552,7569,7592,7595,7617,7625,7648,7710,7751,7819,7830,7838,7891,7929,8018,8019,8027,8070,8071,8086,8103,8133,8192,8250,8291,8295,8314,8538,8592,8602,8634,8663,8707,8779,8801,8802,8895,9200,9237,9277,9279,9369,9401,9488,9491,9542,9572,9930,10144,10214,10239,10241,10246,10260,10266,10291,10389,10423,10563,10572,10761,10800,10840,10850,10874,10952,10957,11001,11002,11126,11158,11184,11203,11259,11350,11452,11503,11555,11733,11743,11761,11914,11917,12097,12242,12398,12403,12404,12408,12471,12473,12517,12521,12562,12612,12639,12644,12667,12675,12713,12779,12874,12925,12944,12952,12969,12974,13034,13061,13105,13126,13138,13214,13219,13246,13251,13323,13395,13404,13407,13441,13442,13510,13512,13580,13604,13605,13692,13694,13827,13896,13966,14082,14168,14178,14201,14205,14208,14237,14287,14369,14382,14487,14504,14527,14529,14655,14666,14671,14703,14714,14750,14752,14812,14865,14969,14976,15005,15030,15038,15061,15063,15087,15094,15111,15125,15150,15194,15202,15203,15204,15235,15259,15305,15308,15355,15360,15375,15393,15438,15460,15487,15520,15533,15542,15544,15547,15591,15604,15722,15726,15740,15761,15781,15804,15807,15836,15844,15850,15858,15875,15881,15906,15913,15915,15930,15933,15940,15973,15995,16042,16122,16224,16303,16344,16366,16445,16454,16461,16467,16522,16547,16561,16587,16588,16612,16626,16683,16737,16754,16777,16782,16791,16819,16824,16830,16848,16913,16984,16995,17050,17054,17055,17123,17124,17140,17155,17166,17220,17273,17286,17333,17372,17388,17402,17442,17443,17515,17555,17592,17644,17646,17659,17683,17699,17716,17731,17737,17759,17791,17798,17799,17806,17807,17858,17921,17936,17999,18033,18036,18081,18159,18218,18242,18277,18292,18293,18302,18348,18357,18383,18398,18409,18410,18432,18443,18444,18451,18480,18506,18517,18542,18625,18648,18657,18668,18672,18692,18695,18721,18733,18754,18762,18779,18802,18814,18817,18827,18832,18870,18883,18939,18947,19015,19018,19038,19060,19075,19102,19107,19165,19183,19187,19189,19200,19228,19229,19255,19258,19260,19264,19269,19280,19282,19283,19289,19299,19302,19307,19314,19339,19350,19356,19378,19389,19400,19402,19406,19416,19418,19421,19423,19427,19447,19452,19458,19470,19484,19494,19503,19511,19532,19533,19573,19583,19589,19625,19634,19707,19721,19731,19746,19776,19782,19792,19800,19812,19813,19830,19832,19854,19908,19937,19956,20029,20040,20044,20056,20057,20062,20104,20126,20140,20153,20177,20188,20215,20221,20236,20261,20278,20289,20293,20306,20318,20336,20348,20357,20363,20379,20391,20418,20429,20443,20461,20508,20530,20541,20542,20553,20558,20600,20662,20673,20713,20733,20743,20758,20764,20773,20775,20776,20804,20813,20819,20830,20843,20851,20853,20858,20860,20871,20879,20883,20917,20920,20921,20944,20949,20950,20954,20957,20983,20999,21100,21119,21157,21168,21217,21220,21223,21236,21242,21282,21313,21323,21350,21384,21402,21447,21452,21483,21492,21545,21546,21569,21705,21752,21760,21787,21820,21855,21880,21945,21969,21972,21992,22027,22105,22127,22169,22187,22196,22210,22218,22268,22270,22277,22290,22315,22333,22340,22364,22386,22407,22432,22434,22468,22492,22508,22519,22529,22548,22559,22561,22562,22567,22592,22603,22605,22707,22743,22785,22788,22804,22819,22836,22847,22854,22858,22911,22949,23031,23033,23052,23055,23069,23078,23091,23138,23170,23190,23202,23204,23224,23239,23242,23246,23262,23295,23296,23318,23326,23438,23456,23459,23463,23526,23536,23553,23568,23569,23597,23599,23617,23626,23653,23662,23682,23693,23707,23783,23843,23874,23875,23925,23953,24001,24018,24023,24064,24067,24083,24106,24119,24145,24153,24187,24189,24208,24219,24228,24236,24268,24278,24329,24366,24373,24386,24413,24415,24484,24521,24526,24577,24581,24585,24598,24609,24614,24621,24634,24668,24682,24718,24735,24747,24773,24797,24817,24825,24841,24853,24855,24862,24899,24973,24976,25099,25105,25106,25224,25225,25323,25325,25382,25386,25412,25456,25512,25534,25545,25569,25585,25590,25598,25610,25632,25721,25762,25820,25901,25947,25965,25971,26014,26175,26215,26245,26386,26444,26554,26743,26760,26829,26920,26954,27060,27076,27103,27133,27135,27143,27145,27157,27438,27490,27525,27805,27863,27904,27957,27997,28248,28402,28416,28910,28918,28960,29033,29136,29281,29613,29719,30307,30440,30464,31114,31356,31671,32097,32841,33259,33430,33593,33651,33749,33784,33993,34008,34176,34300,34490,34573,34783,35568,35755,35893,36219,36418,37408,39716,41256,41311,41430,42530,42752,42799,44396,44402,44602,44743,45076)
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 | 1117 | 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.69 ms |
checking permissions | 0.02 ms |
checking permissions | 0.02 ms |
Opening tables | 0.05 ms |
init | 0.24 ms |
System lock | 0.03 ms |
optimizing | 0.09 ms |
statistics | 1.82 ms |
preparing | 0.85 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 ms |
cleaning up | 0.04 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 |