Tiempo de la consulta: 3.59 ms Después de la última consulta: 0.68 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 4.181 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-08 15:04:44')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 15:04: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(49,117,122,136,202,271,280,318,344,350,353,374,376,377,378,379,380,456,608,611,660,686,831,868,891,941,964,976,1033,1043,1207,1215,1287,1329,1339,1386,1458,1601,1644,1698,1709,2656,2714,2742,3091,3215,3329,3340,3783,3816,3870,3895,3957,4071,4087,4206,4319,4378,4638,5148,5730,6097,6288,6292,6333,6384,6464,6631,6687,6826,6908,6940,6942,6957,6961,6989,7154,7303,7314,7434,7449,7450,7454,7522,7523,7548,7556,7618,7638,7711,7713,7746,7774,7797,7808,7829,7862,7916,7923,7944,7965,7967,7985,8016,8108,8113,8694,9057,9075,9249,9318,9429,9584,9723,9725,9730,9861,9966,9985,10011,10122,10199,10227,10259,10265,10313,10332,10357,10398,10534,10558,10611,10656,10777,10820,10821,10971,11005,11164,11333,11362,11365,11379,11474,11532,11539,11648,11663,11799,11816,11893,11911,11950,11976,12009,12051,12178,12179,12388,12446,12565,12670,12685,12758,12838,12898,12985,13036,13079,13229,13285,13334,13644,13647,13901,13998,14098,14152,14199,14205,14242,14248,14250,14336,14348,14352,14354,14373,14378,14396,14424,14426,14469,14480,14482,14502,14508,14596,14608,14625,14629,14637,14654,14676,14695,14747,14754,14789,14814,14843,14856,14896,14897,14964,14984,15018,15107,15154,15174,15181,15199,15210,15283,15286,15304,15315,15316,15325,15358,15375,15410,15417,15444,15520,15557,15580,15608,15616,15714,15723,15755,15762,15778,15794,15805,15840,15897,15901,15954,15955,15977,16040,16047,16053,16056,16088,16126,16198,16279,16337,16362,16370,16381,16417,16474,16518,16523,16542,16556,16611,16627,16657,16660,16670,16675,16783,16822,16927,16982,17036,17162,17163,17256,17269,17365,17408,17422,17433,17437,17511,17542,17566,17573,17610,17625,17660,17688,17712,17717,17820,17831,17914,17918,17930,17933,17967,18031,18057,18118,18215,18248,18262,18263,18300,18315,18376,18406,18429,18435,18519,18605,18695,18732,18804,18811,18821,18830,18849,18852,18871,18933,18948,18952,18966,19001,19053,19055,19061,19062,19093,19104,19106,19121,19145,19254,19259,19267,19277,19325,19350,19405,19434,19440,19462,19508,19509,19523,19574,19592,19601,19654,19658,19668,19679,19761,19762,19773,19774,19830,19855,19856,19871,19877,19881,19885,19901,19957,19965,19972,19984,19996,20035,20061,20064,20117,20213,20214,20263,20343,20390,20405,20433,20437,20447,20459,20488,20543,20545,20588,20691,20698,20708,20716,20718,20726,20772,20781,20782,20794,20810,20814,20837,20841,20862,20876,20940,20956,20960,20979,20986,21002,21010,21122,21135,21142,21167,21170,21172,21198,21222,21247,21262,21269,21312,21324,21325,21346,21350,21366,21370,21380,21398,21436,21448,21449,21466,21501,21516,21551,21585,21588,21591,21596,21607,21640,21647,21664,21680,21727,21860,21867,21895,21969,21990,22002,22013,22039,22044,22067,22081,22087,22096,22115,22132,22153,22156,22162,22170,22210,22215,22239,22255,22276,22320,22349,22363,22382,22411,22436,22465,22501,22511,22523,22534,22539,22579,22588,22666,22671,22680,22693,22709,22743,22751,22779,22781,22820,22866,22872,22915,22923,22930,22949,23009,23013,23029,23036,23064,23072,23087,23093,23103,23112,23117,23137,23156,23157,23202,23203,23232,23252,23257,23264,23270,23277,23279,23305,23308,23315,23358,23367,23368,23401,23440,23444,23465,23480,23484,23524,23544,23555,23577,23602,23621,23623,23642,23665,23682,23691,23693,23709,23716,23719,23743,23768,23846,23849,23876,23893,23920,23944,23949,24009,24015,24016,24024,24060,24088,24110,24115,24159,24164,24196,24197,24210,24213,24239,24270,24277,24296,24306,24335,24362,24369,24395,24412,24414,24422,24425,24430,24453,24456,24486,24496,24503,24506,24556,24563,24575,24598,24617,24618,24635,24656,24663,24677,24679,24707,24724,24726,24764,24773,24776,24794,24816,24852,24888,24931,24984,25036,25043,25046,25136,25142,25153,25157,25200,25203,25205,25233,25282,25287,25291,25320,25327,25332,25367,25376,25384,25386,25405,25408,25416,25418,25440,25484,25515,25526,25548,25555,25560,25639,25640,25687,25692,25697,25765,25785,25806,25854,25887,25889,25904,25959,26023,26055,26120,26131,26136,26146,26147,26161,26164,26168,26172,26274,26340,26344,26390,26413,26415,26434,26452,26453,26595,26651,26671,26673,26677,26706,26710,26810,26811,26827,26853,26861,26887,26898,26900,26924,26925,26940,26971,27001,27057,27066,27085,27128,27171,27232,27247,27363,27374,27379,27393,27395,27485,27505,27584,27606,27699,27739,27743,27761,27777,27795,27821,27922,28163,28322,28351,28425,28441,28465,28511,28537,28609,28623,28739,28786,28789,28852,28986,29004,29005,29017,29037,29053,29065,29105,29142,29155,29208,29325,29460,29484,29502,29550,29563,29635,29682,29742,29760,29801,29803,29895,29897,29962,30274,32820,34239,34535,35000,35711,35740,35772,35774,35858,36216,36492,37398,37909,38958,38975,39020,39064,39159,40150,40184,40772,40799,40831,40883,41325,43115)
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 | 805 | 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.40 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.26 ms |
preparing | 0.60 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.49 ms |
end | 0.01 ms |
query end | 0.02 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 |