Tiempo de la consulta: 5.71 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.319 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-06 20:39:44')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 20:39:44')
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(15,16,17,33,48,131,178,179,281,294,316,329,335,380,436,457,488,569,572,619,664,724,735,744,755,756,766,872,894,899,952,972,978,987,1039,1047,1056,1083,1090,1137,1147,1154,1287,1298,1302,1306,1313,1322,1336,1338,1344,1380,1392,1406,1430,1443,1470,1478,1525,1531,1532,1572,1610,1639,1673,1695,1878,1943,2015,2022,2184,2311,2326,2350,2356,2372,2381,2485,2489,2536,2572,2580,2583,2591,2607,2610,2611,2621,2627,2650,2726,2733,2740,2766,2787,2794,2798,2836,2838,2839,2848,2943,2960,2970,2972,2974,2990,3078,3116,3118,3136,3162,3173,3175,3199,3215,3229,3234,3247,3252,3343,3393,3443,3471,3502,3514,3549,3579,3587,3602,3603,3633,3698,3771,3773,3778,3850,3885,3905,3910,3928,3971,3974,3979,3991,3997,4001,4007,4013,4019,4029,4038,4056,4057,4062,4084,4085,4089,4091,4115,4128,4130,4141,4152,4163,4164,4171,4182,4203,4217,4235,4242,4270,4276,4278,4308,4317,4321,4331,4346,4349,4368,4374,4377,4397,4400,4418,4427,4438,4440,4455,4458,4469,4482,4486,4501,4513,4527,4531,4533,4537,4538,4559,4566,4571,4595,4631,4632,4635,4650,4655,4661,4662,4697,4733,4755,4758,4762,4763,4811,4814,4818,4819,4823,4857,4859,4861,4895,4915,4918,4944,4946,4950,4964,4984,5003,5027,5032,5033,5054,5059,5061,5073,5074,5093,5129,5187,5202,5251,5256,5277,5282,5284,5288,5294,5309,5314,5337,5339,5349,5361,5377,5380,5385,5386,5396,5422,5423,5431,5441,5460,5476,5537,5598,5631,5657,5665,5670,5673,5684,5690,5712,5763,5774,5789,5790,5797,5800,5813,5822,5843,5902,5933,5965,5972,5995,6027,6031,6048,6064,6094,6095,6106,6162,6167,6177,6185,6192,6203,6283,6328,6359,6383,6399,6418,6436,6454,6496,6514,6550,6559,6562,6565,6621,6626,6670,6813,6833,6866,6899,6900,6950,6975,6978,6982,7009,7035,7063,7076,7115,7144,7149,7167,7174,7215,7217,7224,7228,7263,7330,7333,7352,7354,7390,7478,7534,7540,7546,7554,7574,7575,7584,7598,7610,7656,7657,7687,7695,7700,7766,7790,7793,7818,7875,7876,7905,7947,8042,8043,8068,8120,8122,8142,8159,8195,8204,8209,8212,8228,8235,8246,8247,8248,8257,8264,8270,8275,8277,8280,8282,8301,8312,8320,8324,8336,8366,8375,8382,8387,8394,8412,8426,8427,8457,8468,8471,8473,8479,8510,8531,8560,8568,8576,8593,8614,8620,8676,8678,8687,8689,8699,8700,8725,8759,8763,8769,8790,8802,8816,8825,8845,8851,8862,8863,8864,8874,8886,8888,8912,8921,8935,8937,8952,8955,8957,8958,8966,8971,8980,8985,8986,8987,9001,9006,9034,9103,9123,9124,9135,9184,9187,9228,9265,9269,9313,9342,9393,9403,9439,9441,9456,9480,9484,9486,9544,9548,9575,9589,9637,9640,9672,9683,9686,9694,9712,9714,9741,9785,9790,9792,9799,9842,9891,9905,9916,9943,9949,9953,9972,9986,9988,9989,9994,9995,10052,10061,10074,10084,10123,10131,10164,10177,10234,10275,10280,10281,10308,10324,10348,10392,10394,10395,10398,10411,10415,10429,10441,10491,10498,10575,10588,10675,10677,10678,10813,10841,10930,10939,10953,10983,10999,11074,11075,11085,11164,11182,11213,11234,11237,11240,11252,11255,11284,11360,11402,11420,11431,11574,11603,11610,11629,11636,11658,11698,11737,11738,11776,11783,11796,11800,11806,11832,11843,11844,11889,11893,11905,11920,11974,11976,11985,11998,12066,12082,12118,12130,12159,12179,12220,12231,12314,12326,12384,12412,12434,12441,12460,12480,12495,12501,12513,12540,12556,12604,12651,12754,12831,12845,12865,12922,12932,12962,12997,13083,13110,13217,13412,13485,13616,13633,13639,13685,13705,13706,14038,14104,14113,14175,14244,14293,14359,14470,14580,14647,14649,14673,14701,14714,14730,14784,14785,14793,14811,14823,14868,14873,14878,14881,14956,15019,15022,15084,15215,15236,15305,15314,15412,15512,15632,15678,15693,15729,15756,15842,15911,16001,16029,16071,16079,16097,16110,16173,16311,16324,16353,16356,16360,16396,16421,16484,16494,16564,16565,16580,16597,16621,16628,16721,16723,16754,16766,16771,16785,16844,16854,16901,16914,17055,17070,17079,17145,17207,17257,17350,17382,17430,17475,17546,17547,17552,17675,17687,17751,17783,18060,18088,18115,18159,18192,18276,18277,18291,18351,18396,18404,18433,18441,18467,18483,18531,18664,18671,18690,18732,18758,18775,18786,18899,18923,18971,19006,19096,19142,19318,19370,19526,19548,19641,19739,19790,19841,19907,20028,20048,20087,20141,20184,20248,20270,20300,20326,20352,20360,20518,20536,20545,20631,20646,20654,20681,20854,20897,20898,20906,20983,21010,21112,21129,21176,21191,21218,21222,21307,21459,21591,21783,21787,21819,21910,21952,21961,21987,22015,22017,22096,22216,22261,22296,22315,22389,22496,22518,22731,22916,22936,23168,23249,23310,23598,23657,23741,23785,23793,23873,23913,24097,24100,24108,24118,24150,24174,24188,24241,24320,24413,24449,24495,24556,24597,24876,24884,24888,24931,25036,25122,25131,25342,25374,25694,25835,25856,25891,25995,26038,26053,26078,26116,26145,26148,26298,26308,26309,26339,26394,26420,26427,26461,26476,26485,26520,26539,26554,26561,26567,26573,26578,26595,26627,26642,26643,26647,26675,26743,26769,26791,26828,26847,26893,26906,26920,26938,26978,26991,27113,27121,27134,27141,27155,27162,27175,27233,27250,27342,27354,27381,27424,27442,27455,27463,27494,27626,27650,27864,27884,27887,27900,27931,27937,28088,28118,28252,28259,28263,28300,28322,28323,28330,28335,28422,28487,28554,28560,28579,28637,28651,28849,28882,28902,28917,28941,28993,29010,29028,29073,29077,29104,29126,29141,29172,29194,29265,29437,29608,29622,29650,29783,29933,30381,30475,30499,30547,31173,31733,31742,31762,32993,34066,34841,35675,35751,35798,35843,35923,35941,36046,37218,39483,39527,39698,43837)
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 | 980 | 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 | 1.06 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.97 ms |
preparing | 1.08 ms |
Sorting result | 0.04 ms |
executing | 0.01 ms |
Sending data | 0.71 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.08 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 |