Tiempo de la consulta: 7.20 ms Después de la última consulta: 0.59 ms Consulta a la memoria: 0.643 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-05 05:01:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 05:01:45')
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,64,71,119,126,185,220,255,267,271,272,274,283,323,341,400,403,429,495,497,559,657,678,689,699,722,808,832,863,868,937,939,940,970,992,1049,1057,1080,1101,1102,1154,1216,1233,1250,1306,1318,1458,1459,1469,1670,1684,1696,1735,1745,1887,1975,1994,2016,2028,2064,2069,2101,2111,2144,2180,2254,2385,2517,2548,2586,2587,2605,2646,2674,2719,2727,2761,2777,2804,2806,2860,2906,2967,3001,3065,3075,3130,3154,3157,3183,3186,3201,3208,3303,3312,3333,3343,3346,3493,3562,3569,3597,3599,3621,3750,3754,3795,3809,3813,3833,3836,3839,3841,3983,4033,4122,4144,4210,4388,4443,4477,4492,4557,4597,4628,4643,4778,4789,4845,4879,5008,5020,5079,5093,5095,5123,5134,5144,5150,5513,5664,5755,5817,5896,5971,6102,6113,6186,6197,6273,6289,6290,6301,6313,6315,6331,6354,6358,6363,6369,6372,6400,6416,6542,6543,6593,6709,6725,6726,6752,6807,6808,6840,6907,6964,6997,7018,7026,7079,7093,7101,7248,7321,7418,7426,7473,7556,7569,7583,7589,7625,7630,7637,7749,7826,7844,7851,7917,8088,8206,8296,8304,8493,8737,8740,8824,8898,8907,8937,8975,8977,8998,9048,9056,9057,9082,9097,9152,9200,9253,9266,9314,9658,9667,9764,9808,9825,10059,10183,10195,10236,10273,10284,10289,10349,10383,10445,10462,10511,10531,10592,10676,10747,10805,10906,10961,10973,11022,11051,11183,11195,11303,11318,11392,11401,11410,11495,11679,11850,11854,12308,12339,12747,12775,12777,12783,13029,13052,13071,13129,13166,13220,13524,13530,13536,13548,13549,13550,13573,13641,13712,13763,13812,13821,13855,13950,13987,14046,14068,14081,14143,14148,14159,14188,14197,14223,14255,14359,14428,14490,14497,14530,14615,14675,14711,14718,14742,14748,14769,14779,14856,14927,15018,15049,15053,15124,15160,15182,15202,15248,15336,15438,15496,15551,15606,15719,15897,16005,16033,16164,16178,16193,16194,16201,16205,16218,16299,16308,16321,16325,16370,16384,16391,16432,16513,16521,16575,16603,16668,16694,16713,16733,16734,16794,16808,16844,16928,17062,17086,17098,17100,17133,17134,17138,17145,17157,17197,17279,17309,17319,17372,17489,17515,17559,17563,17564,17690,17704,17721,17732,17742,17758,17767,17775,17796,17799,17835,17877,17883,17938,17942,17989,18043,18112,18113,18117,18126,18129,18142,18295,18326,18358,18364,18409,18431,18500,18519,18521,18660,18667,18689,18717,18742,18763,18772,18826,18867,19086,19108,19124,19126,19133,19196,19217,19223,19227,19253,19267,19368,19560,19653,19693,19768,19828,19855,19865,19871,19873,19874,19905,19909,19961,19998,20029,20118,20124,20163,20187,20198,20236,20242,20334,20338,20376,20445,20471,20564,20579,20698,20710,20757,20840,20842,20924,20957,20993,21010,21107,21127,21149,21165,21169,21172,21181,21268,21347,21369,21397,21405,21517,21548,21606,21652,21713,21732,21750,21771,21800,21846,21898,21926,21944,22026,22040,22097,22180,22204,22229,22231,22234,22270,22276,22296,22385,22396,22414,22489,22543,22558,22597,22611,22645,22681,22692,22709,22784,22848,22852,22898,22960,23016,23040,23115,23135,23147,23156,23193,23198,23241,23245,23247,23280,23325,23388,23399,23459,23485,23492,23566,23621,23647,23654,23666,23690,23724,24119,24152,24192,24242,24277,24288,24312,24342,24383,24398,24440,24450,24451,24479,24480,24498,24531,24565,24601,24637,24643,24705,24747,24826,24891,25019,25133,25156,25222,25268,25290,25342,25413,25556,25631,25787,25816,25852,25890,25940,25968,26017,26024,26034,26061,26202,26261,26361,26370,26378,26410,26429,26439,26471,26570,26630,26640,26679,26763,26766,26770,26866,26894,26913,26992,27071,27138,27235,27314,27322,27412,27475,27497,27513,27576,27823,27939,27974,28177,28188,28313,28439,28451,28779,28965,29057,29107,29111,29187,29200,29242,29306,29347,29802,29913,30609,30854,31773,32003,32241,33621,33950,34524,34584,34681,34758,34927,35259,35305,35718,35754,35794,35926,35999,36067,36068,36159,36197,36273,36351,36358,36423,37025,37788,37915,38379,38447,38662,38784,38818,38865,38905,38962,39078,39226,39296,39673,39684,39808,39823,40252,40309,40812,40939,40954,40957,40958,41254,41594,41888,42074,42262,42509,44498,44637,45191,45241,45287)
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 | 703 | 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.35 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.14 ms |
preparing | 0.56 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 3.93 ms |
end | 0.01 ms |
query end | 0.07 ms |
closing tables | 0.06 ms |
freeing items | 0.15 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 |