Tiempo de la consulta: 4.49 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.170 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 23:40:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 23:40:37')
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,9,11,25,28,56,62,71,86,119,165,185,255,263,271,272,275,276,283,323,400,403,429,463,472,495,583,607,611,613,657,686,689,722,723,728,758,808,832,863,868,883,895,900,917,937,940,958,963,1031,1101,1102,1133,1216,1233,1250,1271,1458,1459,1469,1684,1696,1718,1735,1745,1887,1975,2016,2069,2101,2254,2290,2293,2305,2365,2473,2498,2517,2605,2639,2674,2796,2804,2863,2866,2967,3001,3030,3065,3154,3183,3208,3303,3312,3343,3346,3493,3512,3569,3597,3604,3750,3754,3946,3983,3986,3994,4437,4492,4549,4580,4878,4902,5079,5093,5095,5123,5350,5365,5451,5513,5647,5675,5730,5894,6102,6127,6301,6315,6323,6354,6363,6372,6400,6405,6470,6473,6475,6488,6520,6542,6543,6573,6593,6630,6656,6688,6723,6742,6744,6807,6808,6835,6840,6860,6889,6895,6906,6936,6964,6985,6997,7015,7018,7026,7232,7248,7343,7432,7483,7545,7569,7583,7586,7588,7630,7730,7735,7749,7832,7917,7934,7950,7959,7997,8017,8027,8088,8109,8143,8206,8508,8740,8907,8937,9048,9056,9057,9082,9152,9200,9314,9658,9764,9825,10059,10110,10176,10195,10203,10250,10273,10306,10311,10462,10697,10734,10872,10951,10954,10973,10974,11015,11022,11063,11083,11173,11195,11226,11318,11394,11410,11414,11452,11479,11534,11593,11712,11766,11854,11883,11987,12306,12449,12545,12624,12625,12655,12789,12871,12894,12945,13029,13129,13166,13225,13241,13508,13524,13530,13548,13550,13573,13611,13641,13712,13763,13821,13851,13855,13950,13968,13972,13998,14018,14048,14081,14097,14114,14148,14159,14183,14188,14197,14205,14236,14361,14428,14507,14675,14684,14711,14769,14811,14856,15018,15038,15049,15069,15217,15248,15271,15302,15304,15310,15496,15545,15551,15606,15719,15757,15759,15866,15897,15903,15952,15957,16178,16218,16321,16325,16366,16415,16431,16521,16538,16603,16645,16713,16733,16734,16775,16779,16808,16996,17086,17100,17134,17138,17157,17197,17227,17228,17242,17285,17289,17309,17407,17510,17575,17634,17766,17775,17835,17852,17869,17883,17925,17938,17950,18043,18112,18113,18121,18129,18142,18156,18207,18276,18294,18295,18303,18311,18316,18326,18358,18409,18431,18505,18521,18609,18668,18670,18682,18698,18717,18730,18763,18772,18826,18846,18867,18872,18874,18948,19026,19051,19064,19086,19126,19133,19175,19207,19217,19223,19288,19322,19349,19444,19484,19516,19581,19652,19653,19693,19727,19828,19855,19871,19873,19962,19976,20033,20089,20099,20126,20127,20149,20163,20174,20198,20220,20256,20317,20397,20437,20471,20549,20564,20579,20587,20638,20654,20668,20683,20686,20687,20698,20714,20739,20757,20785,20797,20802,20840,20875,20897,20942,20973,20993,21110,21113,21165,21216,21346,21347,21369,21397,21405,21420,21500,21517,21579,21587,21606,21667,21732,21749,21750,21798,21846,21852,21906,21926,21950,21968,22026,22038,22040,22097,22098,22124,22139,22142,22150,22171,22180,22212,22229,22234,22270,22276,22290,22296,22385,22389,22414,22468,22478,22489,22611,22672,22692,22706,22720,22753,22784,22848,22854,22901,22960,23016,23040,23041,23046,23070,23147,23148,23156,23198,23245,23247,23253,23267,23305,23325,23363,23383,23388,23399,23423,23485,23488,23492,23501,23566,23615,23647,23654,23730,23790,23816,23838,23926,23978,23990,24024,24025,24118,24119,24147,24152,24192,24193,24219,24242,24277,24288,24312,24342,24383,24398,24403,24411,24433,24440,24450,24451,24455,24456,24479,24498,24557,24597,24601,24616,24643,24673,24701,24705,24732,24747,24748,24808,24826,24830,24841,24891,24941,25048,25080,25133,25139,25218,25222,25277,25287,25344,25349,25386,25413,25452,25535,25560,25561,25591,25631,25637,25642,25657,25775,25787,25816,25888,25934,25940,25968,25990,26017,26034,26043,26061,26102,26135,26161,26202,26261,26370,26378,26410,26439,26471,26483,26488,26519,26525,26570,26630,26640,26679,26763,26766,26770,26866,26901,26992,27041,27071,27074,27138,27267,27271,27292,27322,27371,27397,27407,27471,27475,27513,27518,27939,27974,28779,28799,28928,28933,29107,29187,29200,29341,29473,29500,29896,30284,30609,30854,31010,31773,32241,33621,33950,34524,34584,34758,34801,34927,35259,35305,35718,36197,36423,37025,38450,38662,38784,38818,38865,38905,38961,38962,39063,39078,39226,39296,39323,39673,39808,39823,40347,40812,40954,41199,41254,41594,42074,42262,42496,45191)
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 | 729 | 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.06 ms |
init | 0.27 ms |
System lock | 0.06 ms |
optimizing | 0.14 ms |
statistics | 1.62 ms |
preparing | 0.92 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.44 ms |
end | 0.01 ms |
query end | 0.05 ms |
closing tables | 0.01 ms |
freeing items | 0.09 ms |
cleaning up | 0.06 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 |