Tiempo de la consulta: 4.08 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.176 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-05 21:28:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 21:28:39')
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,117,136,202,271,280,344,350,353,374,376,377,378,379,380,456,608,611,686,831,868,891,941,964,976,988,1033,1043,1207,1215,1287,1329,1339,1601,1650,1698,1709,2656,2714,2742,3091,3215,3234,3263,3329,3340,3432,3471,3482,3527,3547,3578,3588,3602,3608,3622,3645,3669,3677,3694,3697,3729,3730,3764,3765,3783,3802,3816,3820,3850,3867,3870,3874,3875,3895,3908,3910,3928,3957,3967,3968,3978,3987,3998,3999,4007,4029,4032,4038,4056,4057,4083,4084,4085,4087,4102,4141,4149,4151,4152,4171,4185,4186,4195,4206,4242,4270,4278,4317,4319,4321,4331,4346,4349,4351,4368,4374,4376,4377,4378,4397,4400,4418,4425,4427,4431,4432,4438,4439,4440,4441,4447,4455,4458,4469,4482,4486,4501,4513,4531,4533,4537,4538,4551,4552,4559,4566,4571,4576,4595,4598,4603,4631,4632,4634,4635,4638,4650,4655,4661,4662,4678,4749,4755,4762,4763,4806,4811,4814,4823,4824,4859,4861,4862,4872,4887,4895,4915,4918,4922,4942,4944,4946,4964,4984,5003,5027,5031,5032,5033,5054,5059,5073,5074,5090,5093,5127,5128,5129,5159,5187,5202,5251,5256,5277,5282,5288,5294,5314,5330,5331,5337,5339,5341,5361,5377,5380,5385,5386,5390,5396,5409,5422,5423,5431,5441,5460,5598,5670,5673,5712,5730,5753,5754,5763,5764,5774,5789,5790,5797,5813,5815,5822,5843,5844,5902,5965,5995,6017,6027,6031,6064,6106,6162,6167,6177,6192,6203,6283,6292,6328,6333,6359,6384,6436,6454,6464,6562,6565,6626,6631,6687,6813,6833,6900,6908,6923,6940,6942,6950,6957,6961,6975,6978,6982,6989,7063,7144,7154,7217,7228,7263,7303,7390,7434,7445,7450,7454,7478,7522,7540,7556,7638,7695,7713,7744,7774,7790,7793,7818,7829,7862,7905,7916,7923,7947,7965,7967,7985,8042,8063,8108,8142,8159,8195,8204,8210,8235,8257,8277,8312,8324,8336,8366,8375,8394,8398,8427,8457,8479,8487,8531,8576,8676,8678,8687,8689,8694,8759,8763,8769,8796,8802,8825,8863,8864,8912,8935,8937,8955,8957,8958,8962,8966,8980,8985,8986,8987,9006,9034,9057,9121,9123,9135,9184,9228,9243,9249,9269,9316,9318,9393,9429,9439,9453,9484,9486,9507,9509,9522,9544,9586,9591,9640,9672,9694,9718,9723,9725,9729,9785,9790,9792,9861,9891,9895,9916,9966,9985,9989,10011,10041,10123,10164,10177,10227,10259,10265,10281,10313,10324,10357,10360,10398,10415,10457,10534,10588,10611,10619,10677,10678,10777,10813,10820,10821,10844,10862,10916,10942,10966,10971,10999,11005,11136,11139,11167,11182,11191,11213,11240,11310,11313,11333,11341,11362,11363,11364,11365,11393,11402,11420,11454,11490,11493,11509,11539,11563,11566,11606,11610,11622,11623,11636,11654,11655,11663,11688,11691,11725,11759,11777,11778,11783,11799,11816,11832,11847,11877,11893,11941,11943,11950,11975,11985,11995,12009,12047,12066,12130,12150,12159,12178,12179,12180,12196,12220,12231,12277,12388,12422,12424,12425,12446,12456,12495,12501,12503,12504,12540,12604,12670,12685,12754,12758,12831,12838,12882,12898,12932,12971,12985,13036,13079,13083,13229,13271,13285,13334,13487,13639,13647,13746,13863,13901,14023,14098,14148,14152,14205,14248,14250,14251,14336,14352,14354,14396,14424,14426,14596,14625,14629,14676,14695,14754,14784,14785,14789,14823,14843,14856,14868,14878,14984,15018,15019,15022,15106,15159,15286,15304,15311,15315,15316,15437,15444,15520,15608,15616,15714,15723,15755,15778,15805,15897,15911,16053,16088,16110,16185,16271,16311,16330,16362,16381,16396,16417,16474,16514,16523,16542,16555,16590,16597,16614,16657,16670,16675,16723,16744,16769,16771,16783,16785,16786,16854,16855,16885,16901,16914,16982,17003,17079,17163,17256,17350,17365,17422,17475,17542,17546,17566,17573,17625,17660,17688,17712,17717,17820,17914,17930,17933,17967,18085,18118,18300,18429,18496,18605,18699,18732,18746,18811,18830,18849,18871,18923,19001,19036,19055,19145,19254,19259,19277,19325,19574,19621,19679,19773,19784,19830,19855,19871,19877,19881,19890,19901,19907,19965,19972,19984,19996,20048,20390,20405,20433,20437,20447,20477,20488,20545,20588,20646,20698,20708,20718,20772,20781,20786,20794,20814,20940,20960,20979,21122,21170,21198,21247,21303,21325,21350,21370,21380,21398,21444,21448,21449,21551,21591,21607,21640,21642,21680,21814,21867,21895,21990,22015,22039,22044,22067,22096,22132,22170,22215,22255,22276,22296,22320,22349,22363,22382,22436,22465,22501,22511,22579,22588,22693,22709,22751,22781,22820,22866,22915,22930,23009,23029,23072,23086,23087,23103,23112,23137,23156,23232,23252,23270,23279,23308,23367,23368,23401,23444,23484,23555,23577,23621,23623,23642,23665,23682,23691,23693,23709,23716,23719,23768,23846,23849,23902,23920,23944,23949,24009,24015,24024,24060,24108,24110,24115,24150,24159,24164,24196,24239,24270,24296,24306,24335,24362,24422,24430,24453,24506,24556,24575,24617,24635,24656,24677,24707,24724,24726,24794,24816,24931,25036,25043,25131,25136,25200,25282,25287,25291,25327,25332,25367,25384,25386,25408,25416,25440,25484,25510,25515,25526,25548,25553,25555,25560,25640,25687,25692,25697,25765,25806,25854,25887,25889,25959,26023,26055,26274,26340,26390,26413,26420,26595,26743,26853,26920,27001,27374,27379,27584,27795,28072,28227,28300,28322,28511,28523,28537,28623,28651,28852,28952,28993,29325,29910,29962,30274,30399,30934,32778,32820,34886,34910,34936,35000,35711,35740,35774,35858,36216,36492,38958,38975,39020,39064,39159,39515,40140,40184,41325)
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 | 926 | 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.42 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.18 ms |
System lock | 0.01 ms |
optimizing | 0.07 ms |
statistics | 1.43 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |