Tiempo de la consulta: 5.48 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.355 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-09 06:14:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 06:14:38')
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(137,185,214,259,367,374,416,450,523,556,669,697,754,797,808,825,843,1006,1068,1121,1223,1230,1286,1351,1492,1496,1540,1556,1565,1660,1776,1870,2013,2100,2109,2153,2304,2354,2384,2387,2462,2628,2643,2671,2831,2870,2898,2916,2921,2939,3033,3052,3074,3283,3375,3377,3427,3478,3512,3564,3567,3590,3614,3641,3847,3899,3929,3934,3962,4025,4172,4192,4194,4257,4386,4468,4622,4674,4677,4690,4693,4718,4741,4771,4794,4816,4825,4834,4876,4959,5053,5072,5138,5233,5247,5299,5398,5495,5515,5644,5649,5659,5708,5827,5837,5840,5850,5888,6071,6157,6164,6381,6396,6468,6497,6501,6557,6582,6644,6690,6820,6837,6847,6895,6916,6939,6950,6960,6976,6998,7018,7104,7168,7266,7270,7359,7428,7457,7594,7647,7678,7726,7728,7775,7929,7933,7949,7966,7991,7993,7995,7998,8037,8072,8129,8187,8269,8343,8355,8386,8391,8533,8569,8667,8773,8776,8819,8834,8914,8915,8999,9056,9058,9109,9115,9263,9351,9374,9425,9590,9728,9731,9776,9881,9996,10011,10017,10156,10268,10299,10340,10424,10440,10452,10508,10541,10612,10646,10673,10679,10709,10796,10803,10913,10991,11147,11207,11221,11462,11626,11693,11694,11766,11788,11815,11854,12091,12135,12242,12302,12332,12377,12441,12505,12529,12550,12567,12621,12645,12677,12752,12839,12878,12880,12897,12992,13002,13067,13102,13153,13155,13202,13220,13264,13269,13270,13319,13358,13436,13476,13585,13586,13608,13616,13629,13650,13731,13734,13750,13775,13811,13858,13859,13896,13922,14047,14095,14103,14115,14212,14293,14320,14333,14364,14402,14409,14425,14733,14759,14783,14873,14879,14927,14935,14995,15039,15061,15063,15074,15208,15227,15282,15306,15312,15464,15471,15608,15634,15667,15682,15755,15804,15806,15848,15903,16088,16090,16092,16095,16220,16224,16230,16340,16365,16439,16450,16481,16503,16507,16545,16578,16630,16636,16646,16667,16674,16693,16704,16728,16742,16772,16800,16831,16840,16880,16904,16905,16913,16957,16969,16994,17026,17041,17055,17082,17090,17117,17137,17181,17301,17316,17344,17353,17372,17377,17427,17440,17446,17458,17487,17527,17578,17662,17733,17737,17746,17767,17770,17798,17823,17839,17881,17883,17898,17942,17947,18066,18068,18083,18088,18161,18203,18265,18283,18311,18326,18327,18366,18384,18442,18469,18476,18490,18547,18548,18603,18628,18638,18646,18768,18770,18807,18816,18893,18927,18934,19031,19096,19111,19117,19125,19130,19158,19160,19192,19201,19260,19272,19327,19367,19400,19435,19463,19529,19547,19549,19583,19586,19596,19636,19694,19711,19800,19804,19897,19918,19929,20019,20057,20095,20134,20135,20154,20169,20177,20188,20297,20340,20396,20424,20451,20483,20548,20549,20624,20683,20693,20694,20707,20708,20763,20824,20836,20861,20883,20886,20942,20997,21019,21027,21031,21033,21037,21046,21112,21116,21132,21154,21203,21206,21227,21229,21233,21236,21247,21268,21283,21295,21354,21356,21358,21362,21402,21446,21449,21453,21459,21488,21500,21506,21536,21592,21593,21610,21614,21755,21769,21787,21805,21815,21828,21837,21852,21875,21909,21921,21940,22000,22033,22037,22058,22111,22131,22132,22136,22200,22214,22244,22245,22246,22259,22260,22264,22312,22313,22377,22401,22426,22444,22445,22487,22519,22525,22550,22559,22584,22585,22677,22684,22749,22854,22868,22911,22919,22938,22939,22954,22968,22991,23072,23099,23125,23127,23148,23173,23176,23196,23250,23311,23334,23350,23359,23371,23397,23401,23431,23457,23458,23471,23627,23686,23741,23764,23768,23816,23830,23860,23882,23888,23906,23938,23973,24043,24051,24100,24104,24112,24163,24164,24175,24185,24324,24406,24407,24408,24439,24502,24509,24556,24591,24593,24594,24623,24628,24912,24998,25030,25098,25130,25304,25415,25473,25520,25532,25538,25619,25622,25625,25730,25750,25769,25772,25818,25835,25912,25940,25957,25995,26003,26014,26031,26078,26108,26121,26136,26198,26221,26281,26362,26374,26378,26399,26403,26410,26447,26454,26493,26516,26601,26616,26626,26629,26630,26638,26760,26785,26791,26803,26804,26839,26866,26935,26936,26948,26950,26955,27009,27055,27100,27101,27107,27109,27118,27120,27124,27133,27134,27161,27175,27238,27259,27275,27287,27302,27322,27344,27353,27354,27384,27445,27450,27455,27457,27465,27473,27480,27490,27491,27524,27526,27548,27550,27559,27571,27630,27673,27688,27783,27806,27808,27809,27975,28129,28336,28483,28545,28562,28577,28777,28829,28890,28979,28982,28989,28999,29077,29091,29127,29214,29223,29293,30269,30810,31019,32322,33440,33504,33505,33506,33507,33508,33509,33510,33511,34024,34185,34186,34685,34944,35350,35421,35574,35669,35673,35684,35703,35710,35857,35926,36243,36267,36277,36427,36466,36901,37047,37681,37838,37843,37925,38045,38181,38384,38624,38651,38689,38778,38895,38932,39370,39411,39552,39806,39841,39878,40027,40048,40211,40401,40407,40822,40878,41263,41929,42097,43118,43309,43412,43529,43728,44076,44147,44436,45071,45072,45248)
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 | 816 | 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.86 ms |
checking permissions | 0.05 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.21 ms |
preparing | 1.01 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.45 ms |
end | 0.06 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.06 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 |