Tiempo de la consulta: 4.09 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.330 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 02:21:49')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 02:21: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(5,7,9,14,29,39,56,60,62,63,65,71,72,73,86,87,149,164,174,177,196,221,226,240,259,262,291,299,331,349,366,391,428,429,471,472,477,481,495,501,510,525,530,531,546,563,619,659,662,663,667,674,675,697,705,746,769,800,802,805,808,823,832,835,844,869,873,900,910,923,939,940,954,969,974,977,982,983,999,1004,1005,1011,1021,1029,1039,1055,1066,1089,1091,1095,1114,1119,1158,1182,1195,1205,1231,1247,1249,1252,1253,1255,1268,1271,1276,1289,1308,1309,1312,1319,1337,1347,1363,1372,1384,1409,1410,1428,1432,1441,1444,1485,1497,1502,1503,1509,1557,1606,1619,1629,1648,1675,1687,1693,1694,1697,1724,1759,1771,1794,1795,1796,1808,1810,1843,1854,1855,1862,1899,1918,1920,1930,1935,1960,1961,1967,1975,1984,1994,1995,2001,2008,2013,2015,2035,2064,2075,2088,2103,2132,2137,2155,2157,2161,2293,2325,2372,2379,2404,2415,2426,2455,2461,2527,2532,2551,2555,2563,2586,2597,2625,2638,2643,2647,2750,2792,2814,2824,2842,2851,2857,2883,2916,2924,2960,3027,3038,3055,3100,3107,3141,3147,3169,3207,3248,3276,3285,3364,3368,3369,3387,3409,3412,3462,3473,3520,3548,3552,3554,3590,3648,3683,3689,3748,3812,3853,3858,3872,3913,3919,3922,3962,3991,4002,4006,4034,4050,4068,4110,4114,4129,4315,4327,4446,4468,4529,4532,4558,4616,4620,4622,4626,4666,4751,4752,4767,4813,4815,4822,4831,4844,4846,4865,4872,4933,4973,5055,5134,5153,5160,5220,5351,5370,5415,5458,5469,5559,5662,5780,5795,5854,5964,5977,5991,5999,6057,6148,6198,6391,6420,6435,6442,6476,6477,6534,6548,6561,6629,6685,6735,6736,6791,6804,6833,6845,6855,6860,6906,6944,6958,6969,6995,7022,7030,7045,7048,7131,7137,7195,7242,7258,7282,7324,7329,7368,7371,7412,7418,7447,7489,7490,7491,7535,7592,7595,7648,7751,7752,7798,7819,7855,7965,7994,8070,8086,8094,8192,8287,8291,8295,8314,8484,8499,8538,8592,8602,8634,8707,8758,8779,8801,8895,9036,9237,9277,9279,9369,9401,9415,9488,9572,9745,9834,9836,9854,9930,10156,10304,10532,10554,10572,10661,10706,10713,10769,10840,11001,11170,11184,11262,11277,11555,11821,11872,12019,12139,12242,12396,12398,12408,12639,12667,12974,13034,13126,13200,13246,13262,13659,13733,13855,13861,13896,14141,14305,14398,14525,14558,14613,14666,14692,14696,14703,14714,14752,14865,14969,14976,14981,15038,15063,15087,15111,15149,15203,15235,15330,15346,15460,15497,15533,15544,15552,15565,15604,15635,15668,15781,15804,15807,15850,15875,15913,15915,15973,16060,16062,16122,16128,16168,16224,16343,16416,16418,16428,16454,16515,16522,16571,16587,16588,16612,16671,16737,16760,16791,16827,16830,16880,16913,16995,17042,17054,17055,17138,17140,17166,17184,17222,17333,17372,17388,17389,17425,17442,17592,17644,17646,17683,17699,17704,17737,17791,17798,17799,17806,17807,17936,18024,18036,18121,18144,18357,18383,18444,18450,18463,18480,18499,18542,18652,18657,18695,18718,18733,18754,18755,18768,18779,18802,18832,18982,19015,19020,19038,19064,19092,19183,19187,19193,19228,19233,19258,19265,19269,19280,19282,19283,19289,19291,19299,19302,19307,19339,19389,19391,19400,19402,19421,19423,19427,19458,19470,19475,19503,19532,19533,19573,19576,19596,19721,19771,19790,19800,19809,19825,19830,19918,19920,19930,19937,20029,20044,20056,20057,20062,20088,20153,20177,20188,20215,20236,20278,20293,20306,20329,20361,20391,20508,20530,20556,20600,20655,20662,20666,20671,20713,20733,20743,20764,20804,20809,20813,20843,20850,20851,20853,20858,20860,20871,20879,20883,20920,20921,20944,20949,20954,20964,20977,20999,21078,21168,21210,21217,21236,21282,21292,21294,21297,21313,21402,21420,21469,21483,21510,21536,21569,21739,21760,21787,21798,21820,21969,22105,22159,22198,22311,22317,22347,22422,22553,22567,22571,22596,22603,22616,22638,22711,22743,22770,22847,22854,22883,23076,23116,23138,23148,23170,23188,23202,23224,23246,23286,23488,23495,23526,23536,23569,23599,23612,23617,23682,23744,23875,24067,24153,24189,24208,24219,24282,24415,24484,24526,24559,24576,24585,24598,24609,24614,24659,24682,24760,24797,24853,24860,24863,24973,25174,25217,25323,25374,25456,25534,25567,25569,25598,25610,25621,25632,25696,25700,25703,25717,25721,25799,25901,25909,25947,26014,26030,26039,26041,26053,26215,26245,26386,26408,26554,26582,26715,26818,26829,26912,26920,26954,27103,27133,27135,27157,27248,27283,27318,27478,27490,27491,27524,27558,27805,27863,27904,27955,27997,28184,28248,28402,28416,28654,28910,28918,28960,29033,29047,29130,29136,29281,29438,30307,31114,31356,31671,32097,32841,33092,33259,33430,33593,33651,33784,33993,34008,34176,34300,34490,34573,34783,34827,35568,35755,35899,35909,35975,36154,36219,36367,36402,36447,36490,36583,36596,36638,36897,37345,37408,37755,38226,38237,38352,38356,38850,38899,38991,39191,39214,39286,39323,39334,39338,39339,39542,39558,39580,39677,39737,39761,39801,39892,39942,40120,40272,40375,40391,40594,40739,40773,40887,40973,41122,41217,41256,41311,41430,41475,41636,41761,41826,42486,42530,42563,42591,42680,42752,42766,42799,42834,42944,43330,43569,43570,43571,43755,43856,43972,43973,44143,44160,44396,44402,44469,44602,44743,44843,44933,44998,45076)
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 | 904 | 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.43 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.36 ms |
preparing | 0.68 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.31 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 ms |
cleaning up | 0.02 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 |