Tiempo de la consulta: 3.72 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.326 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 00:54:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 00:54:19')
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,74,75,76,77,78,113,114,117,131,133,136,139,155,158,159,207,208,247,263,282,321,323,324,334,349,353,357,377,437,607,669,693,701,744,831,897,929,942,976,986,1083,1130,1169,1204,1207,1215,1236,1273,1277,1287,1330,1459,1679,1709,2064,2150,2190,2222,2235,2394,2713,2762,2827,2857,2859,2901,2991,3035,3069,3071,3099,3117,3279,3329,3425,3442,3668,3814,3870,4061,4286,4378,4516,4583,4661,4710,4910,5085,5501,5647,5730,5870,6039,6150,6298,6448,6475,6546,6577,6616,6669,6694,6799,6908,6913,6989,7014,7105,7189,7245,7280,7282,7311,7343,7387,7402,7403,7410,7451,7461,7486,7551,7567,7572,7614,7615,7626,7744,7836,7861,7890,7914,7965,7981,8022,8027,8051,8107,8108,8134,8177,8258,8663,8692,9091,9161,9239,9916,9983,10092,10110,10120,10181,10193,10294,10318,10331,10354,10369,10370,10399,10415,10444,10453,10682,10717,10798,10955,10970,11037,11062,11114,11188,11235,11417,11441,11726,11779,11823,11922,12024,12070,12081,12133,12162,12243,12297,12443,12465,12477,12520,12596,12610,12670,12685,12786,12846,12873,12907,12909,12963,13006,13035,13036,13041,13124,13137,13152,13257,13279,13390,13420,13443,13466,13497,13553,13587,13766,13771,13790,13805,13817,13835,13906,13929,13953,14013,14024,14061,14113,14143,14186,14197,14205,14223,14232,14283,14285,14335,14370,14426,14481,14516,14530,14558,14570,14571,14591,14625,14695,14697,14700,14727,14749,14754,14771,14775,14840,14929,14984,15010,15035,15038,15049,15105,15109,15131,15134,15189,15227,15231,15245,15268,15286,15401,15472,15475,15486,15489,15519,15520,15522,15552,15581,15615,15631,15632,15655,15704,15713,15730,15742,15778,15876,15884,15894,15897,15965,16058,16192,16250,16254,16282,16316,16317,16324,16375,16417,16427,16430,16516,16528,16542,16642,16657,16675,16687,16695,16717,16724,16739,16783,16791,16814,16839,16928,16942,16948,17047,17071,17084,17153,17201,17240,17274,17278,17288,17289,17290,17299,17331,17333,17340,17365,17386,17414,17540,17553,17575,17596,17598,17613,17650,17664,17688,17712,17714,17748,17753,17759,17783,17786,17810,17824,17850,17851,17887,17922,17924,17950,17954,17955,17995,17996,18003,18060,18072,18098,18121,18278,18291,18304,18311,18333,18351,18391,18397,18428,18467,18477,18498,18524,18541,18549,18552,18562,18571,18577,18616,18619,18622,18626,18651,18693,18702,18705,18706,18708,18724,18762,18764,18770,18789,18805,18811,18830,18839,18843,18845,18849,18853,18854,18997,19048,19049,19134,19138,19145,19178,19180,19183,19220,19222,19276,19280,19284,19290,19303,19364,19375,19379,19414,19416,19437,19439,19453,19455,19460,19501,19517,19518,19531,19556,19575,19634,19644,19655,19659,19720,19733,19754,19811,19819,19869,19929,19958,19960,19983,19984,19996,19997,20045,20048,20058,20076,20091,20097,20154,20168,20186,20200,20219,20276,20297,20315,20329,20333,20366,20405,20411,20423,20468,20540,20555,20559,20577,20630,20632,20666,20681,20761,20805,20868,20885,20915,20940,20960,21009,21055,21058,21060,21075,21089,21104,21107,21116,21128,21129,21136,21171,21218,21228,21289,21305,21316,21350,21378,21390,21398,21418,21421,21429,21463,21495,21506,21520,21540,21545,21609,21611,21682,21702,21711,21714,21749,21777,21853,21864,21894,21919,21924,21947,21977,22000,22003,22038,22052,22072,22075,22093,22139,22154,22180,22191,22332,22342,22349,22359,22382,22395,22495,22497,22502,22595,22596,22616,22653,22661,22693,22709,22715,22718,22746,22799,22804,22820,22879,22899,22920,22934,22951,23015,23055,23071,23078,23087,23112,23121,23140,23144,23222,23236,23242,23252,23273,23279,23295,23302,23318,23339,23367,23393,23438,23449,23498,23505,23527,23550,23555,23569,23577,23578,23596,23599,23646,23665,23682,23691,23693,23695,23698,23709,23716,23719,23727,23743,23774,23784,23787,23814,23815,23816,23836,23849,23869,23912,23995,24065,24068,24100,24102,24159,24189,24217,24233,24258,24270,24272,24275,24283,24291,24315,24364,24365,24368,24372,24402,24417,24428,24437,24438,24457,24461,24473,24475,24511,24565,24577,24590,24642,24649,24656,24672,24730,24751,24780,24800,24804,24806,24809,24850,24859,24872,24900,24906,24930,24998,25003,25063,25064,25069,25077,25096,25112,25116,25134,25155,25165,25180,25187,25192,25281,25300,25310,25314,25316,25352,25356,25358,25364,25386,25387,25411,25416,25418,25455,25462,25471,25477,25564,25589,25595,25664,25697,25701,25807,25887,25926,25942,25971,26043,26063,26101,26165,26246,26258,26375,26412,26431,26540,26541,26559,26672,26711,26807,26814,26835,26842,26843,26864,26898,26930,27001,27022,27024,27039,27055,27076,27083,27094,27186,27197,27221,27263,27271,27327,27384,27435,27438,27506,27633,27646,27737,27832,27871,27918,27921,27923,27924,27926,27949,27968,27975,27990,28300,28372,28464,28511,28606,28892,28907,28908,28933,28949,28951,28972,28973,29014,29049,29140,29171,29194,29208,29223,29349,29535,29576,29584,29611,29622,29642,29673,29911,29912,29923,29930,29939,30449,31286,31908,34196,35638,35812,36042,36310,36875,37497,38112,38836,38900,38932,38986,39131,39172,39527,39588,39966,40048,40351,40759,40877,40993,41211,41257,41468,41515,44770)
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 | 858 | 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.48 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.34 ms |
preparing | 0.65 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.35 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 |