Tiempo de la consulta: 5.30 ms Después de la última consulta: 1.07 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.506 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 13:51:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 13:51:49')
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(11,49,60,61,62,63,64,65,67,68,72,117,136,202,271,272,278,280,281,331,344,350,353,374,376,377,378,379,380,385,417,456,586,608,611,686,697,717,726,816,831,844,857,860,868,891,892,941,964,976,978,1024,1033,1043,1168,1187,1207,1208,1215,1226,1287,1305,1319,1329,1339,1340,1453,1506,1601,1698,1709,1851,1883,2005,2112,2193,2394,2417,2656,2714,2742,2962,3091,3208,3215,3329,3340,3452,3583,3696,3783,3816,3870,3895,3898,3918,3957,3982,4087,4206,4258,4319,4378,4421,4563,4587,4625,4638,4932,5193,5347,5438,5730,5814,6047,6292,6294,6333,6381,6384,6464,6470,6570,6631,6687,6748,6908,6936,6940,6942,6957,6961,6989,7125,7154,7296,7303,7337,7392,7412,7413,7432,7434,7450,7454,7457,7522,7556,7638,7675,7713,7774,7801,7806,7829,7838,7839,7847,7860,7862,7916,7923,7931,7946,7963,7965,7967,7981,7985,8108,8531,8555,8615,8694,8770,8780,8916,8917,8932,9057,9249,9318,9429,9532,9556,9723,9725,9861,9895,9944,9945,9966,9985,10011,10227,10243,10259,10265,10280,10313,10357,10383,10534,10561,10577,10611,10659,10699,10777,10820,10821,10834,10894,10924,10971,11005,11083,11091,11122,11127,11129,11143,11157,11299,11309,11333,11362,11365,11377,11407,11482,11497,11539,11543,11565,11585,11587,11610,11614,11663,11688,11711,11721,11727,11749,11799,11816,11822,11839,11893,11894,11907,11915,11950,11976,11987,12009,12018,12038,12040,12042,12091,12098,12109,12133,12150,12178,12179,12238,12306,12337,12342,12388,12424,12446,12449,12668,12670,12673,12674,12685,12735,12758,12780,12838,12848,12898,12903,12916,12944,12985,12991,13001,13004,13036,13060,13079,13141,13152,13153,13198,13229,13285,13331,13334,13346,13418,13425,13595,13611,13627,13647,13657,13677,13692,13697,13748,13750,13783,13806,13807,13816,13901,13924,13934,13951,14073,14080,14095,14097,14098,14103,14104,14114,14150,14152,14153,14196,14205,14222,14227,14236,14248,14250,14267,14278,14281,14336,14346,14352,14354,14396,14424,14426,14469,14563,14570,14574,14596,14625,14629,14632,14676,14695,14728,14747,14754,14770,14789,14799,14827,14842,14843,14844,14856,14895,14958,14960,14977,14984,15006,15018,15038,15069,15114,15145,15146,15175,15176,15183,15206,15241,15244,15284,15286,15303,15304,15315,15316,15353,15354,15359,15361,15368,15373,15444,15493,15520,15522,15565,15577,15608,15616,15631,15632,15641,15645,15668,15669,15714,15723,15731,15755,15778,15805,15843,15897,15957,15975,16053,16083,16088,16145,16169,16199,16201,16295,16322,16334,16356,16362,16367,16381,16415,16417,16425,16431,16442,16445,16446,16458,16464,16474,16493,16520,16523,16542,16556,16563,16629,16640,16645,16657,16670,16675,16684,16688,16777,16783,16791,16827,16830,16861,16864,16982,17049,17091,17130,17155,17163,17210,17221,17227,17228,17237,17253,17256,17362,17365,17422,17436,17443,17471,17488,17521,17542,17566,17573,17600,17625,17630,17638,17655,17660,17679,17688,17701,17711,17712,17713,17717,17724,17730,17761,17766,17777,17784,17820,17822,17852,17868,17874,17875,17914,17930,17933,17938,17963,17966,17967,17991,17994,17995,18118,18123,18138,18156,18162,18185,18229,18259,18260,18261,18285,18300,18303,18311,18356,18364,18370,18396,18402,18429,18445,18453,18467,18505,18520,18528,18564,18567,18580,18584,18599,18605,18668,18671,18680,18686,18700,18720,18728,18762,18793,18811,18813,18828,18829,18830,18849,18853,18871,18874,18937,18973,18985,19001,19002,19014,19041,19047,19055,19059,19060,19067,19117,19145,19148,19170,19175,19180,19185,19217,19223,19230,19242,19253,19254,19259,19276,19277,19312,19325,19327,19352,19371,19376,19417,19436,19457,19460,19503,19532,19563,19567,19571,19574,19577,19602,19604,19608,19620,19633,19643,19668,19671,19679,19687,19701,19728,19732,19764,19769,19773,19780,19811,19829,19830,19855,19863,19870,19871,19877,19881,19882,19901,19905,19908,19909,19952,19962,19965,19972,19984,19996,19998,20010,20013,20019,20028,20032,20056,20062,20086,20108,20123,20133,20141,20149,20156,20170,20185,20187,20234,20240,20256,20259,20263,20271,20289,20298,20307,20323,20326,20353,20367,20378,20380,20390,20405,20433,20437,20442,20444,20447,20449,20450,20479,20488,20516,20517,20522,20535,20545,20564,20587,20588,20611,20629,20630,20646,20698,20705,20708,20714,20718,20729,20772,20781,20794,20797,20814,20820,20866,20875,20884,20891,20923,20940,20941,20942,20960,20962,20979,20982,20993,21012,21050,21101,21122,21142,21165,21170,21173,21186,21189,21198,21225,21245,21247,21308,21312,21314,21325,21350,21370,21371,21380,21398,21402,21420,21422,21432,21448,21449,21458,21477,21498,21512,21513,21519,21541,21544,21545,21551,21554,21591,21607,21611,21616,21620,21636,21637,21640,21678,21680,21694,21738,21755,21758,21764,21768,21851,21854,21867,21882,21895,21897,21921,21950,21980,21990,22003,22023,22039,22044,22064,22067,22084,22091,22092,22096,22100,22132,22137,22139,22146,22165,22170,22171,22181,22188,22191,22198,22215,22229,22237,22252,22255,22271,22276,22285,22290,22297,22320,22322,22337,22341,22349,22361,22363,22382,22408,22436,22439,22465,22469,22478,22480,22485,22500,22501,22536,22557,22559,22575,22579,22588,22610,22614,22647,22673,22693,22709,22712,22725,22741,22751,22774,22781,22789,22794,22803,22820,22866,22885,22903,22908,22915,22930,22935,22980,22988,23009,23029,23038,23046,23061,23072,23087,23103,23112,23135,23137,23148,23156,23186,23188,23232,23252,23253,23270,23275,23279,23281,23295,23305,23308,23342,23367,23368,23374,23401,23402,23419,23442,23444,23484,23495,23521,23551,23555,23577,23585,23586,23595,23610,23615,23621,23623,23631,23636,23642,23665,23682,23691,23693,23697,23709,23716,23719,23732,23764,23768,23777,23840,23845,23846,23849,23852,23858,23902,23915,23920,23944,23946,23949,23956,23961,23985,24009,24015,24024,24028,24059,24060,24090,24110,24115,24129,24147,24159,24164,24194,24196,24239,24270,24292,24295,24296,24304,24306,24335,24342,24362,24422,24430,24433,24435,24440,24451,24453,24456,24458,24466,24489,24506,24532,24540,24556,24574,24575,24584,24586,24616,24617,24632,24635,24639,24640,24653,24656,24660,24664,24677,24691,24702,24724,24726,24748,24768,24789,24791,24794,24804,24806,24816,24830,24884,24897,24907,24931,24953,24987,24988,25036,25043,25045,25080,25098,25123,25136,25183,25184,25193,25200,25206,25241,25264,25277,25282,25287,25291,25315,25327,25332,25344,25365,25367,25374,25382,25384,25386,25408,25416,25440,25484,25491,25515,25526,25548,25555,25560,25583,25640,25687,25692,25697,25702,25709,25755,25761,25765,25775,25806,25812,25854,25872,25887,25889,25906,25959,25970,25990,26023,26036,26055,26158,26161,26256,26274,26286,26293,26315,26340,26390,26413,26425,26563,26595,26640,26689,26708,26807,26853,26901,26983,26986,27001,27086,27141,27143,27261,27263,27314,27374,27379,27401,27460,27472,27533,27560,27584,27771,27776,27795,27893,27984,28254,28336,28454,28495,28511,28536,28537,28623,28631,28807,28852,28882,28933,29036,29047,29173,29193,29250,29281,29325,29332,29355,29412,29441,29454,29476,29489,29530,29718,29738,29746,29802,29834,29868,29883,29962,30274,30740,31129,31604,32820,32905,35000,35603,35711,35740,35774,35858,36216,36492,38958,38975,39020,39064,39159,39642,40116,40145,40184,40271,40984,41325,41364)
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 | 1211 | 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.59 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.83 ms |
preparing | 1.29 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.53 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |