Tiempo de la consulta: 3.57 ms Después de la última consulta: 0.65 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.455 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 16:15:32')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 16:15:32')
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,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,81,87,88,89,110,111,125,188,189,190,200,205,226,234,246,248,249,263,271,325,353,362,412,415,416,420,421,422,423,424,426,427,429,431,484,496,501,503,531,574,575,593,686,785,824,853,862,868,986,1085,1207,1223,1353,1357,1391,1434,1513,1634,1693,1718,1878,1900,1915,2108,2122,2156,2208,2272,2367,2424,2598,2600,2825,2963,3020,3051,3212,3325,3650,3682,4310,4674,4902,4905,4957,4990,5040,5060,5079,5086,5104,5139,5150,5170,5173,5189,5324,5392,5476,5538,5622,5647,5685,5798,5799,5814,5895,6097,6173,6264,6270,6311,6392,6446,6482,6616,6666,6671,6695,6776,6830,6836,6839,6847,6868,6873,6915,6937,7017,7050,7056,7082,7083,7109,7117,7124,7134,7138,7210,7287,7294,7416,7450,7526,7659,7663,7692,7716,7717,7730,7745,7782,7811,7813,7866,7933,7958,7970,7993,8027,8036,8056,8215,8330,8347,8416,8444,8462,8565,8589,8602,8610,8638,8835,8856,8887,9018,9197,9206,9262,9282,9411,9428,9472,9650,9658,9677,9678,9924,10035,10046,10112,10274,10400,10604,10691,10764,10811,10956,11163,11305,11345,11476,11859,11864,11994,12020,12083,12095,12223,12324,12460,12620,12650,12670,12685,12686,12708,12771,12807,12889,12913,12973,12996,13014,13016,13045,13074,13152,13268,13294,13328,13348,13474,13475,13509,13535,13575,13576,13681,13748,13782,13783,13846,13868,13900,13924,13938,13941,13971,13973,14203,14229,14293,14327,14356,14362,14430,14534,14536,14554,14648,14663,14669,14679,14733,14860,14948,14973,14987,15021,15038,15043,15110,15126,15179,15201,15245,15261,15262,15293,15298,15304,15382,15386,15414,15421,15473,15475,15476,15482,15517,15520,15533,15550,15574,15650,15751,15753,15784,15796,15861,15945,15947,15972,16055,16062,16071,16115,16122,16161,16176,16214,16318,16440,16455,16497,16519,16526,16543,16566,16654,16689,16720,16751,16802,16812,16833,16894,16908,16917,16950,16976,17114,17133,17309,17317,17334,17335,17409,17412,17419,17479,17496,17520,17528,17584,17603,17607,17629,17643,17700,17702,17721,17826,17857,17862,17949,17965,17978,17981,18028,18071,18073,18170,18213,18220,18260,18300,18309,18360,18362,18538,18558,18578,18675,18707,18726,18753,18757,18819,18845,18974,19039,19040,19127,19150,19153,19204,19235,19252,19282,19358,19381,19426,19454,19460,19483,19487,19527,19551,19650,19661,19668,19676,19695,19733,19750,19767,19772,19791,19825,19886,19923,19931,19937,19980,20003,20030,20039,20060,20066,20068,20092,20095,20122,20183,20192,20193,20213,20262,20308,20384,20386,20437,20439,20459,20469,20526,20528,20565,20566,20567,20592,20595,20616,20642,20648,20670,20688,20699,20700,20727,20750,20792,20804,20847,20894,20944,20964,20984,20990,21016,21038,21159,21182,21196,21198,21243,21256,21279,21283,21285,21288,21300,21327,21329,21332,21338,21368,21404,21405,21454,21464,21485,21486,21487,21524,21526,21529,21618,21623,21650,21661,21664,21690,21695,21704,21719,21722,21726,21727,21761,21767,21769,21800,21811,21824,21843,21850,21891,21910,21932,21954,21955,21958,22015,22018,22062,22077,22117,22129,22156,22162,22163,22164,22172,22195,22241,22253,22262,22267,22302,22324,22406,22409,22421,22446,22453,22466,22481,22499,22512,22580,22603,22620,22622,22626,22655,22658,22710,22726,22727,22753,22765,22780,22787,22797,22804,22829,22833,22865,22897,22914,22923,22947,22972,23007,23024,23037,23043,23062,23082,23089,23099,23104,23119,23123,23124,23179,23184,23213,23214,23218,23254,23257,23268,23309,23480,23491,23504,23528,23554,23604,23621,23628,23632,23665,23704,23716,23751,23805,23813,23849,23886,23887,23888,23890,23891,23893,23897,23899,23901,23904,23905,23907,23921,23964,23981,23983,23986,23989,24000,24016,24029,24039,24040,24160,24197,24226,24249,24294,24337,24386,24393,24408,24429,24431,24475,24496,24503,24507,24522,24582,24587,24589,24617,24678,24679,24782,24803,24896,24937,24956,24993,25030,25035,25062,25073,25131,25138,25171,25233,25318,25351,25406,25436,25448,25505,25542,25582,25584,25646,25660,25863,25904,25909,25918,26000,26033,26147,26221,26317,26335,26343,26360,26362,26415,26424,26454,26474,26651,26677,26713,26742,26784,26801,26820,26845,26881,26905,26907,26944,26973,27000,27038,27065,27366,27530,27688,27722,27846,28072,28080,28339,28440,28442,28614,28615,28616,28712,28728,28845,28944,29054,29460,29635,33417,35330,35713,35744,35955,36917,39398,39530,40036,40492,40605,45008)
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 | 756 | 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.37 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.19 ms |
preparing | 0.56 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 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 |