Tiempo de la consulta: 3.41 ms Después de la última consulta: 0.55 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.159 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 15:24:41')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 15:24:41')
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(11,49,58,98,147,148,149,150,151,152,153,154,155,176,178,179,385,389,432,437,458,686,799,813,844,868,956,970,986,1018,1053,1091,1139,1185,1186,1207,1233,1277,1298,1331,1503,1555,1785,1817,1835,1910,1928,2090,2092,2592,2610,2713,2740,2827,2857,2964,3020,3085,3209,3210,3322,3346,3519,3692,3770,3870,3969,3986,4013,4076,4163,4281,4378,4388,4405,4511,4572,4658,4668,4670,4842,4982,5273,5288,5300,5525,5790,5810,5820,5894,5976,6012,6112,6199,6307,6362,6429,6484,6626,6633,6654,6725,6726,6744,6749,6785,6905,6911,6955,6971,7101,7227,7285,7296,7328,7433,7435,7456,7477,7544,7688,7710,7782,7797,7806,7829,7841,7858,7863,7917,7936,8027,8034,8146,8167,8250,8362,8663,8679,8681,8689,8742,8899,8939,9046,9051,9085,9107,9211,9224,9242,9270,9282,9305,9500,9507,9518,9524,9595,9626,9734,9775,9851,9858,9864,9892,9896,9965,10206,10239,10264,10315,10420,10425,10535,10611,10614,10644,10715,10741,10745,10779,10849,10878,10907,10919,10952,11059,11091,11182,11207,11374,11896,11924,12013,12053,12054,12165,12301,12318,12398,12482,12625,12714,12758,12850,12895,12997,13039,13061,13100,13290,13402,13481,13519,13635,13894,14107,14140,14189,14194,14205,14366,14401,14435,14457,14581,14586,14591,14598,14631,14698,14699,14725,14829,14847,14865,14911,14953,14999,15001,15023,15038,15063,15094,15158,15171,15177,15187,15233,15259,15270,15311,15346,15361,15407,15418,15429,15469,15487,15516,15561,15568,15615,15705,15741,15781,15850,15863,15870,15875,15937,15965,15981,15985,15987,16024,16043,16056,16090,16106,16129,16142,16155,16211,16237,16246,16281,16323,16338,16359,16431,16438,16455,16524,16526,16547,16561,16564,16571,16626,16667,16668,16689,16717,16797,16816,16840,16863,16883,16944,16950,16951,17002,17065,17067,17086,17127,17148,17242,17253,17273,17282,17287,17346,17360,17419,17442,17463,17479,17490,17509,17519,17539,17555,17572,17618,17654,17659,17698,17701,17719,17727,17759,17782,17818,17824,17826,17852,17853,17879,17893,17900,17920,17948,18022,18074,18083,18086,18135,18173,18219,18220,18271,18277,18292,18311,18352,18410,18450,18509,18572,18624,18648,18670,18696,18719,18778,18866,18880,18911,18953,18974,19004,19014,19029,19060,19063,19076,19155,19217,19231,19242,19283,19288,19297,19308,19407,19430,19457,19482,19583,19591,19617,19648,19663,19715,19718,19733,19747,19777,19812,19854,19920,20015,20127,20179,20261,20289,20295,20325,20333,20522,20598,20607,20615,20641,20664,20710,20715,20737,20807,20877,20887,20897,20947,21066,21079,21126,21128,21173,21187,21191,21223,21270,21297,21310,21323,21356,21372,21480,21496,21502,21530,21555,21560,21757,21759,21818,21842,21879,21941,21987,22011,22037,22040,22089,22156,22306,22359,22484,22606,22609,22634,22741,22746,22753,22909,22935,22974,22976,23011,23139,23221,23242,23257,23277,23398,23404,23417,23430,23439,23456,23525,23555,23562,23576,23585,23602,23636,23695,23731,23761,23826,23853,23866,23906,23910,23936,23958,24034,24220,24229,24326,24364,24429,24474,24526,24577,24592,24668,24721,24738,24784,24849,24868,24941,24947,24975,25070,25071,25081,25153,25260,25280,25310,25332,25352,25535,25611,25653,25676,25747,25785,25921,25929,25964,25979,26001,26008,26050,26093,26128,26358,26367,26393,26444,26448,26530,26583,26698,26841,26990,27002,27009,27024,27055,27082,27101,27218,27399,27757,27944,27971,28075,28139,28441,29372,29378,29617,29618,30222,31115,31975,32676,32773,34892,35744,35831,35882,35973,37123,39570,39857,40203,40343,40367,40483,40742,41512,41632,42207,44173,44555,45228)
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 | 605 | 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.39 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.14 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 0.93 ms |
preparing | 0.51 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 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 |