Tiempo de la consulta: 20.42 ms Después de la última consulta: 0.75 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.184 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 02:18:43')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 02:18:43')
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,51,62,131,132,133,134,136,137,138,139,142,143,146,155,163,174,204,225,325,357,460,511,529,583,609,665,686,892,907,929,952,986,1036,1044,1047,1050,1112,1130,1133,1158,1169,1182,1185,1204,1207,1226,1289,1317,1339,1346,1538,1587,1664,1808,1919,2163,2181,2188,2195,2202,2214,2222,2383,2392,2485,2552,2595,3055,3109,3126,3180,3279,3353,3364,3379,3451,3504,3571,3668,3825,3915,3951,3984,3994,4046,4061,4166,4263,4378,4389,4515,4699,4713,4767,4910,4992,5161,5247,5453,5757,5785,5870,5881,6221,6448,6472,6577,6590,6616,6686,6691,6896,6942,6965,7004,7013,7014,7121,7245,7246,7259,7269,7272,7273,7282,7291,7311,7439,7486,7546,7572,7594,7652,7664,7719,7804,7821,7923,7967,8027,8054,8061,8099,8116,8258,8383,8423,8515,8610,8692,8700,8728,8909,9030,9037,9044,9054,9091,9109,9137,9138,9218,9239,9312,9429,9434,9554,9773,9779,9788,9924,9983,10044,10092,10220,10273,10307,10348,10415,10630,10694,10783,10805,10869,10927,10955,10958,10970,11059,11206,11258,11402,11419,11441,11446,11468,11560,11624,11662,11753,11965,12025,12068,12113,12143,12204,12213,12218,12281,12331,12401,12430,12463,12474,12475,12549,12552,12622,12625,12685,12686,12835,12875,12935,12999,13004,13036,13044,13079,13091,13112,13387,13448,13587,13697,13710,13729,13742,13813,13963,13990,13992,14020,14074,14082,14083,14116,14117,14186,14205,14232,14244,14262,14264,14273,14440,14456,14507,14583,14591,14683,14684,14722,14794,14836,14840,14869,14954,14964,14983,15027,15032,15048,15094,15108,15109,15111,15129,15139,15213,15245,15286,15370,15453,15520,15548,15575,15706,15725,15755,15757,15782,15894,15923,15935,15966,15991,16000,16014,16088,16092,16093,16148,16153,16157,16187,16326,16374,16375,16417,16427,16458,16528,16534,16542,16596,16609,16675,16814,16832,16853,16872,16889,16894,16981,17039,17047,17117,17128,17142,17153,17186,17215,17248,17257,17300,17328,17336,17382,17432,17437,17541,17592,17596,17613,17634,17655,17688,17703,17733,17753,17818,17840,17895,17924,17954,17980,18027,18031,18042,18072,18078,18212,18260,18262,18290,18311,18369,18384,18419,18430,18463,18466,18485,18503,18524,18552,18561,18577,18612,18642,18652,18682,18693,18702,18705,18708,18761,18764,18839,18843,18847,18850,18853,18854,18910,18920,18937,18942,18977,18982,18991,18995,19000,19022,19031,19083,19091,19110,19132,19134,19136,19145,19149,19178,19184,19222,19247,19249,19270,19284,19290,19294,19375,19414,19439,19453,19455,19524,19556,19565,19595,19608,19634,19644,19650,19659,19661,19664,19670,19684,19705,19718,19720,19743,19759,19779,19815,19819,19820,19894,19915,19930,19932,19941,19942,19973,19983,19991,20002,20034,20042,20045,20069,20076,20091,20104,20145,20183,20199,20226,20276,20315,20344,20354,20363,20374,20403,20425,20440,20515,20577,20578,20636,20638,20677,20767,20826,20856,20885,20890,20933,20940,20960,20969,20981,20992,21000,21009,21060,21075,21093,21107,21110,21111,21116,21118,21124,21161,21171,21178,21188,21218,21242,21251,21252,21264,21305,21323,21326,21350,21378,21398,21433,21458,21464,21469,21494,21502,21522,21540,21546,21549,21577,21586,21609,21644,21659,21728,21737,21749,21777,21830,21864,21895,21952,22038,22048,22059,22072,22100,22166,22207,22299,22332,22345,22349,22385,22395,22417,22419,22435,22446,22455,22492,22495,22500,22502,22507,22527,22550,22556,22595,22673,22693,22704,22708,22709,22715,22736,22742,22803,22804,22850,22874,22879,22893,22903,22920,22934,22951,22978,23000,23022,23034,23055,23078,23116,23119,23122,23134,23145,23148,23178,23213,23219,23244,23247,23273,23279,23286,23287,23317,23344,23353,23364,23365,23367,23373,23375,23397,23409,23426,23457,23467,23520,23544,23546,23559,23564,23569,23646,23665,23668,23677,23691,23695,23703,23709,23711,23716,23719,23732,23772,23774,23776,23857,23859,23869,23872,23874,23914,23959,23962,23967,23984,24010,24024,24072,24075,24076,24100,24108,24111,24115,24193,24195,24207,24217,24230,24233,24258,24272,24275,24291,24346,24368,24380,24391,24428,24437,24439,24442,24518,24523,24527,24565,24590,24607,24616,24673,24780,24788,24857,24924,24942,24974,25003,25077,25116,25126,25170,25187,25193,25195,25200,25273,25281,25300,25349,25356,25360,25373,25374,25386,25408,25421,25470,25490,25512,25664,25693,25745,25764,25798,25807,25920,25944,25987,26107,26122,26132,26176,26218,26257,26375,26412,26431,26522,26564,26591,26599,26672,26744,26816,26835,26842,26843,26864,26926,26933,26982,27026,27059,27151,27186,27197,27305,27356,27384,27457,27506,27558,27572,27633,27832,27855,27911,27918,27921,27923,27924,27926,27999,28005,28208,28349,28372,28397,28419,28424,28780,28824,29021,29089,29124,29223,29235,29256,29346,29358,29380,29611,29617,29641,29777,29810,29814,29864,29919,29930,30280,30621,30932,31227,31499,31516,31640,31908,32304,32796,33815,34795,34876,34923,35195,35628,35632,35667,35713,35744,35759,35783,35784,35850,36174,36222,36439,36893,36916,36918,36949,37315,37380,37874,37996,38056,38066,38361,38455,38734,38775,38812,38884,38885,38898,38932,38960,39062,39242,39307,39358,39452,39504,39516,39600,39886,39966,40169,40218,40312,40313,40314,40332,40360,40414,40542,40684,40786,40801,41036,41063,41257,41363,41402,41423,41811,41885,42181,42460,42489,42528,43458,43680,43705,43706,43707,43909,43914,43915,43917,44031,44041,44497,44681,45115,45160,45206,45252)
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 | 900 | 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.66 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.33 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 2.19 ms |
preparing | 1.08 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 15.33 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.10 ms |
cleaning up | 0.07 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 |