Tiempo de la consulta: 3.19 ms Después de la última consulta: 0.60 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.315 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-04 09:33:37')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 09:33:37')
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,51,131,132,135,138,139,155,204,323,390,460,489,492,529,583,623,690,808,892,907,929,986,1036,1051,1069,1101,1112,1130,1133,1169,1193,1204,1207,1216,1414,1459,1492,1587,1591,1645,1808,1978,2136,2222,2302,2383,2418,2485,2552,2688,2958,2961,2967,3099,3114,3126,3279,3379,3409,3507,3825,3832,3951,3984,4046,4061,4263,4301,4353,4383,4410,4515,4732,4910,4992,5078,5424,5584,5680,5700,5757,5870,6058,6221,6331,6448,6577,6616,6686,6691,6942,6965,7121,7282,7291,7311,7572,7594,7652,7804,7967,8027,8029,8258,8327,8530,8728,8819,8943,9091,9109,9115,9218,9239,9756,9983,10006,10198,10348,10355,10622,10869,10955,10970,11064,11207,11330,11441,11494,11533,11557,11560,11662,11753,11841,11937,11965,12113,12189,12207,12213,12244,12281,12430,12475,12477,12535,12628,12685,12704,12802,12935,12942,12999,13044,13086,13112,13188,13269,13345,13448,13587,13637,13672,13678,13707,13710,13729,13798,13893,14105,14186,14210,14264,14348,14591,14602,14840,14890,15027,15074,15245,15286,15520,15546,15572,15706,15760,15782,15834,15894,15904,15991,16014,16108,16157,16187,16269,16361,16375,16387,16390,16427,16444,16528,16546,16596,16604,16642,16675,16698,16700,16814,16850,16892,16894,17047,17087,17117,17135,17142,17148,17178,17189,17202,17248,17300,17328,17336,17338,17592,17613,17617,17688,17753,17811,17870,17883,17924,17954,17984,18027,18042,18072,18078,18140,18166,18212,18262,18290,18292,18384,18407,18419,18430,18452,18457,18485,18524,18534,18535,18622,18669,18693,18702,18703,18705,18708,18761,18764,18781,18839,18843,18853,18854,18879,18996,19145,19178,19184,19222,19249,19284,19290,19308,19364,19375,19414,19439,19455,19482,19514,19518,19541,19554,19565,19634,19644,19649,19655,19659,19664,19705,19720,19729,19759,19776,19779,19819,19820,19823,19942,19973,20002,20042,20045,20046,20055,20076,20082,20091,20159,20226,20276,20311,20315,20323,20394,20402,20408,20422,20438,20452,20456,20503,20533,20577,20652,20677,20767,20774,20885,20911,20915,20940,20969,20981,20992,21009,21044,21060,21075,21093,21107,21162,21171,21188,21218,21227,21251,21264,21304,21309,21326,21335,21341,21350,21378,21398,21415,21435,21480,21482,21502,21567,21609,21619,21622,21644,21704,21714,21728,21749,21777,21801,21815,21830,21834,21840,21864,21922,21941,21962,22038,22048,22057,22072,22154,22166,22200,22299,22332,22349,22373,22385,22395,22422,22495,22507,22556,22595,22607,22704,22715,22736,22798,22802,22804,22862,22879,22888,22889,22893,22920,22934,22951,22992,23014,23019,23035,23055,23078,23104,23106,23116,23119,23134,23145,23151,23178,23213,23273,23279,23287,23332,23343,23364,23365,23367,23409,23426,23474,23513,23569,23646,23648,23665,23668,23676,23677,23695,23709,23711,23716,23719,23749,23774,23776,23828,23833,23869,23872,23914,23935,23948,23998,24100,24108,24172,24195,24217,24224,24228,24233,24258,24271,24272,24275,24291,24309,24336,24368,24380,24391,24427,24428,24437,24442,24443,24477,24518,24527,24535,24565,24590,24625,24630,24636,24763,24780,24851,24942,24974,24995,25018,25033,25077,25090,25116,25170,25187,25195,25281,25286,25300,25356,25386,25400,25511,25664,25707,25736,25740,25745,25807,25860,25875,25885,25944,26002,26091,26106,26130,26132,26264,26281,26375,26396,26403,26412,26431,26458,26550,26591,26599,26637,26672,26792,26835,26842,26843,26864,26907,26933,27059,27105,27106,27142,27144,27178,27179,27186,27197,27201,27203,27265,27343,27384,27409,27457,27599,27633,27832,27855,27918,27921,27923,27924,27926,27999,28208,28349,28372,28419,29059,29223,29380,29511,29611,29626,29641,29930,30393,30394,30511,30621,30932,31412,31908,32304,32796,33613,33731,34052,34085,34415,34449,34525,34560,34795,34850,34854,34876,34923,34978,35195,35324,35436,35503,35584,35609,35626,35783,35840,35850,35953,36106,36131,36174,36192,36204,36222,36238,36439,36479,36481,36515,36736,36850,37810,37811,37812,37815,37846,38263,38314,38876,38885,38898,38932,39062,39114,39242,39314,39386,39585,39729,39846,39886,39945,39966,40111,40187,40212,40218,40225,40239,40392,40395,40665,40666,40786,40983,41059,41146,41154,41159,41221,41234,41248,41252,41257,41363,41667,42181,42786,43905,44255,44433,44567,45299,45314,45315)
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 | 704 | 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.37 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.14 ms |
preparing | 0.53 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.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 |