Tiempo de la consulta: 4.78 ms Después de la última consulta: 0.65 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.307 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-07 19:41:50')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 19:41:50')
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,331,344,350,353,374,376,377,378,379,380,456,495,523,608,611,686,805,808,831,868,891,941,964,976,1033,1043,1123,1175,1207,1215,1248,1287,1326,1329,1339,1350,1486,1601,1644,1698,1709,2062,2118,2265,2294,2306,2324,2601,2656,2714,2742,3005,3070,3091,3215,3321,3329,3340,3531,3663,3783,3816,3831,3870,3895,3957,4087,4202,4206,4319,4378,4541,4638,4641,5236,5279,5362,5559,5598,5730,5792,5796,5825,6058,6232,6292,6333,6384,6464,6538,6558,6631,6660,6687,6700,6789,6908,6940,6942,6957,6961,6989,7063,7154,7292,7303,7325,7367,7380,7387,7401,7404,7430,7431,7434,7450,7453,7454,7455,7463,7488,7522,7556,7565,7638,7713,7774,7829,7847,7862,7916,7923,7965,7967,7973,7985,8108,8366,8694,8822,8997,9055,9057,9079,9141,9150,9215,9233,9249,9255,9318,9363,9429,9582,9664,9670,9688,9723,9725,9858,9861,9909,9966,9985,10011,10025,10122,10227,10257,10259,10265,10305,10313,10341,10357,10418,10462,10534,10611,10620,10629,10663,10732,10777,10820,10821,10847,10928,10946,10971,11005,11333,11362,11365,11477,11486,11539,11564,11612,11663,11720,11799,11816,11893,11928,11950,11976,11989,12009,12010,12156,12178,12179,12388,12415,12446,12519,12532,12565,12592,12670,12685,12699,12758,12783,12838,12851,12895,12898,12939,12942,12944,12985,13036,13079,13229,13269,13273,13285,13309,13334,13373,13580,13647,13672,13767,13770,13819,13834,13891,13901,13902,13933,13935,14030,14084,14098,14103,14152,14172,14205,14248,14250,14334,14336,14352,14354,14363,14396,14424,14426,14437,14478,14596,14625,14629,14676,14694,14695,14749,14754,14789,14843,14846,14856,14984,14990,15005,15018,15065,15092,15138,15213,15215,15217,15226,15286,15304,15315,15316,15329,15444,15520,15605,15608,15616,15714,15723,15755,15778,15805,15897,15899,15956,16014,16053,16087,16088,16089,16112,16190,16208,16289,16360,16362,16376,16381,16417,16523,16542,16579,16635,16645,16657,16670,16675,16715,16717,16748,16751,16783,16794,16921,16955,16964,16976,16982,17043,17050,17059,17156,17163,17205,17256,17263,17343,17365,17375,17422,17423,17455,17541,17542,17566,17573,17625,17657,17660,17688,17712,17717,17810,17812,17820,17824,17866,17879,17914,17930,17933,17967,18074,18098,18100,18118,18227,18300,18326,18333,18429,18455,18505,18520,18553,18605,18619,18653,18668,18749,18811,18830,18849,18871,18876,18877,18951,19001,19027,19044,19055,19145,19220,19254,19259,19277,19325,19428,19574,19619,19645,19646,19679,19702,19743,19773,19794,19830,19855,19871,19877,19881,19901,19930,19933,19954,19965,19972,19984,19996,20218,20291,20390,20405,20416,20433,20437,20447,20476,20488,20545,20588,20656,20660,20678,20698,20708,20718,20772,20781,20783,20794,20805,20814,20820,20872,20885,20940,20960,20979,21065,21122,21170,21198,21247,21325,21350,21359,21370,21380,21398,21448,21449,21551,21591,21607,21634,21640,21680,21698,21867,21895,21990,22011,22039,22044,22067,22080,22096,22132,22170,22215,22255,22276,22320,22349,22363,22374,22382,22436,22465,22501,22579,22588,22693,22709,22751,22781,22820,22866,22915,22930,22985,23009,23029,23072,23087,23103,23112,23137,23156,23157,23232,23251,23252,23270,23279,23308,23367,23368,23401,23423,23444,23484,23555,23577,23621,23623,23632,23642,23664,23665,23679,23682,23691,23693,23709,23716,23719,23768,23846,23849,23902,23920,23944,23949,24009,24015,24024,24060,24110,24115,24159,24164,24196,24239,24270,24279,24296,24306,24335,24362,24422,24430,24443,24453,24506,24556,24575,24586,24617,24635,24656,24675,24677,24707,24724,24725,24726,24752,24794,24816,24931,25036,25043,25054,25087,25136,25200,25282,25287,25291,25327,25332,25367,25384,25386,25408,25416,25440,25471,25475,25483,25484,25489,25515,25526,25548,25555,25560,25640,25687,25692,25697,25734,25765,25806,25854,25887,25888,25889,25959,26023,26055,26274,26340,26390,26413,26482,26595,26622,26853,26925,27001,27316,27374,27379,27447,27584,27679,27795,28511,28537,28623,28852,29190,29207,29325,29962,30274,32820,35000,35711,35740,35774,35858,36147,36208,36216,36223,36492,38593,38958,38975,39020,39064,39159,40184,40421,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 | 695 | 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.09 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.76 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.41 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.05 ms |
freeing items | 0.09 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 |