Tiempo de la consulta: 3.60 ms Después de la última consulta: 0.81 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.468 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-04 08:26:42')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 08:26:42')
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(130,197,263,269,275,311,341,466,482,715,764,869,1066,1101,1167,1225,1358,1359,1391,1402,1411,1432,1473,1490,1503,1513,1620,1668,1687,1693,1701,1735,1765,1775,1839,1848,1864,2006,2008,2054,2068,2098,2142,2228,2239,2313,2367,2632,2678,2710,2748,2859,2884,3009,3075,3079,3122,3132,3188,3210,3216,3264,3281,3292,3326,3329,3358,3372,3376,3381,3442,3464,3511,3515,3519,3563,3595,3613,3686,3735,3851,3868,3938,3985,4061,4108,4148,4215,4220,4227,4267,4312,4323,4334,4354,4411,4430,4466,4478,4493,4507,4520,4550,4554,4621,4672,4673,4705,4796,4821,4832,4833,4848,5008,5049,5056,5079,5094,5126,5144,5244,5266,5399,5430,5525,5578,5646,5704,5797,5874,5897,5932,5939,5972,6097,6130,6136,6141,6173,6241,6264,6442,6606,6612,6623,6633,6637,6638,6653,6706,6729,6814,6845,6905,6981,7022,7025,7207,7296,7324,7388,7395,7432,7440,7446,7522,7527,7569,7649,7739,7852,7953,8039,8045,8046,8050,8051,8094,8185,8217,8271,8273,8291,8294,8314,8332,8333,8367,8373,8386,8393,8439,8441,8454,8460,8474,8498,8550,8555,8583,8613,8634,8679,8685,8707,8714,8755,8821,8940,8988,9057,9061,9098,9131,9161,9190,9197,9199,9241,9360,9381,9473,9519,9553,9563,9638,9658,9663,9675,9713,9929,9930,9958,9992,10014,10061,10101,10113,10186,10240,10279,10407,10425,10482,10522,10562,10572,10701,10727,10779,10848,10952,10967,11146,11164,11199,11208,11244,11320,11437,11443,11469,11491,11549,11600,11683,11694,11700,11703,11742,11788,12198,12324,12330,12522,12575,12631,12807,12817,12888,12955,12973,13018,13065,13147,13186,13204,13205,13219,13231,13251,13264,13377,13469,13475,13561,13624,13642,13644,13668,13694,13699,13731,13787,13851,13885,13925,14039,14111,14128,14132,14140,14146,14155,14189,14194,14265,14271,14331,14344,14364,14389,14411,14428,14431,14432,14520,14565,14582,14594,14617,14710,14713,14737,14769,14808,14814,14865,14889,14891,14972,14975,14988,15087,15125,15144,15148,15171,15203,15238,15259,15262,15271,15289,15296,15322,15398,15407,15423,15461,15487,15564,15619,15643,15646,15650,15653,15681,15710,15734,15751,15759,15796,15820,15833,15849,15850,15908,15910,15982,16011,16102,16171,16240,16242,16245,16260,16273,16480,16511,16527,16547,16564,16568,16569,16571,16587,16630,16633,16634,16636,16643,16648,16649,16668,16674,16684,16689,16694,16698,16709,16719,16720,16721,16742,16743,16754,16775,16793,16800,16855,16860,16880,16906,16986,16997,17027,17062,17140,17167,17170,17198,17217,17304,17324,17335,17395,17412,17413,17427,17490,17524,17526,17576,17606,17635,17644,17721,17879,17881,17893,17942,18010,18035,18054,18080,18092,18096,18151,18170,18249,18265,18304,18306,18423,18473,18499,18548,18551,18609,18628,18630,18652,18732,18779,18784,18802,18832,18836,18863,18926,18953,18969,18977,18978,19012,19032,19039,19112,19158,19189,19282,19407,19424,19490,19522,19551,19597,19681,19854,19977,20026,20072,20077,20086,20188,20448,20458,20507,20510,20565,20571,20596,20604,20607,20615,20621,20637,20638,20662,20663,20703,20710,20762,20764,20806,20858,20871,20922,20997,21021,21024,21025,21031,21034,21042,21095,21145,21185,21203,21241,21268,21279,21307,21439,21534,21560,21569,21602,21630,21652,21720,21746,21757,21787,21835,21884,21890,22100,22129,22134,22196,22249,22300,22312,22340,22364,22603,22787,22806,22869,22870,22874,22966,22973,23116,23129,23161,23198,23313,23332,23433,23449,23452,23508,23551,23595,23648,23676,23701,23718,23751,23860,23945,24029,24067,24151,24177,24429,24617,24627,24781,24793,24854,24855,24874,25008,25017,25062,25072,25128,25182,25401,25537,25622,25757,25818,25836,25862,25916,26000,26043,26082,26124,26153,26211,26238,26262,26288,26342,26362,26376,26587,26619,26658,26664,26715,26716,26915,26949,26975,26991,26997,27105,27343,27354,27421,27460,27502,27524,27581,27635,27860,27875,27894,27898,27968,27990,28022,28030,28218,28272,28323,28416,28423,28440,28442,28458,28470,28524,28547,28582,28587,28635,28636,28642,28858,28884,29154,29221,29222,29865,31708,33897,34161,34319,34802,35036,35103,35219,35634,35676,35684,35724,35746,36252,36331,36364,36851,37497,38291,38855,38988,39056,39253,39301,39323,39392,39635,39683,39714,39720,39891,39971,40034,40082,40358,40422,40453,40481,40784,40863,41117,42411,42763,42876,43289,43461)
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 | 728 | 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.02 ms |
checking permissions | 0.01 ms |
Opening tables | 0.05 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.23 ms |
preparing | 0.55 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.40 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 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 |