Tiempo de la consulta: 2.98 ms Después de la última consulta: 0.55 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.162 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-07 00:02:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 00:02: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(49,78,98,113,114,136,176,178,179,207,208,349,353,377,432,693,986,1031,1059,1207,1273,1287,1316,1331,1555,1734,1785,1910,1928,1976,2090,2092,2130,2205,2592,2610,2740,2901,2991,3085,3117,3346,3519,3668,3855,3870,3969,4163,4330,4378,4388,4511,4572,4658,4668,5288,5444,5810,5820,5976,6012,6112,6199,6307,6429,6626,6953,6989,7227,7280,7282,7311,7387,7402,7403,7410,7433,7448,7477,7614,7626,7782,7829,7836,7890,7936,8034,8107,8108,8146,8167,8177,8362,8568,8681,8689,8742,8899,9046,9051,9085,9107,9211,9224,9270,9500,9518,9524,9595,9734,9745,9775,9781,9851,9858,9892,9896,9965,10092,10110,10120,10181,10241,10318,10369,10370,10399,10415,10418,10420,10444,10715,10745,10798,10878,11045,11182,11188,11235,11374,11425,11442,11448,11726,11756,11779,11922,12053,12054,12081,12230,12243,12274,12318,12465,12482,12520,12662,12714,12824,12873,12895,12907,12997,13006,13035,13036,13039,13041,13137,13290,13390,13402,13466,13497,13805,13817,13835,13906,13935,13953,14024,14087,14099,14113,14119,14143,14205,14223,14283,14366,14416,14435,14530,14558,14571,14581,14586,14598,14695,14699,14720,14754,14775,14823,14953,14984,15001,15010,15049,15231,15311,15390,15406,15522,15525,15552,15561,15563,15581,15615,15655,15704,15705,15730,15741,15742,15778,15781,15870,15897,15907,15982,15985,15997,16058,16106,16136,16142,16163,16237,16246,16250,16254,16316,16324,16417,16473,16526,16579,16657,16667,16675,16695,16724,16783,16839,16882,16893,16942,16944,16950,17065,17084,17127,17201,17205,17240,17288,17300,17346,17349,17365,17386,17399,17419,17442,17463,17553,17575,17654,17688,17698,17712,17719,17753,17773,17783,17824,17850,17887,17900,17919,17922,17948,17950,17955,17996,18060,18100,18121,18135,18258,18271,18277,18278,18292,18336,18391,18397,18410,18424,18428,18454,18508,18509,18531,18541,18550,18552,18571,18576,18579,18621,18624,18626,18653,18654,18670,18693,18706,18719,18731,18738,18778,18811,18820,18830,18849,18974,19013,19029,19043,19076,19101,19145,19218,19220,19242,19288,19361,19379,19430,19517,19531,19613,19659,19715,19747,19754,19777,19920,19929,19979,19984,19996,20097,20154,20186,20247,20253,20295,20297,20325,20333,20366,20405,20411,20598,20603,20632,20641,20715,20805,20807,20877,20885,20887,20897,20960,21009,21055,21066,21104,21116,21128,21150,21173,21191,21228,21290,21305,21310,21316,21356,21390,21398,21418,21463,21495,21502,21520,21530,21540,21560,21611,21682,21693,21759,21818,21842,21853,21924,21947,21977,22003,22037,22095,22154,22156,22349,22395,22596,22606,22609,22616,22634,22653,22661,22662,22709,22718,22741,22746,22799,22804,22924,22929,23071,23087,23112,23140,23236,23242,23252,23257,23277,23279,23302,23339,23387,23404,23449,23527,23550,23555,23576,23577,23648,23656,23682,23693,23695,23698,23727,23731,23743,23777,23784,23816,23845,23849,23866,23906,23958,24065,24096,24102,24130,24159,24270,24283,24346,24372,24378,24402,24433,24457,24473,24474,24475,24577,24592,24656,24721,24731,24738,24747,24751,24779,24784,24800,24809,24859,24930,24947,24994,25063,25096,25112,25155,25165,25180,25194,25216,25260,25307,25352,25358,25416,25418,25462,25477,25564,25589,25611,25868,25887,25926,25929,25933,25964,25979,26001,26043,26063,26093,26128,26258,26393,26448,26530,26540,26541,26711,26807,26841,26990,27001,27039,27094,27221,27327,27399,27441,27506,27757,27871,27944,27949,27968,27971,27975,28139,28166,28177,28441,28464,28892,28907,28908,28951,28972,28973,29049,29140,29171,29194,29208,29349,29535,29576,29639,29642,29673,29912,29939,30222,30449,31975,35831,38853,38900,38986,39131,39172,39570,40343,40351,40356,40367,40993,41211,41336)
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 | 614 | 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.14 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 1.00 ms |
preparing | 0.47 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.37 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.07 ms |
cleaning up | 0.02 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 |