Tiempo de la consulta: 3.87 ms Después de la última consulta: 0.77 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.307 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 11:31:48')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 11:31:48')
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,234,246,248,249,263,271,325,353,362,368,412,415,416,420,421,422,423,424,426,427,429,431,445,484,496,501,503,520,531,574,575,593,625,686,785,843,853,862,868,986,1051,1066,1207,1223,1285,1327,1329,1353,1357,1359,1432,1434,1505,1620,1686,1718,1724,1754,1839,1878,2108,2208,2272,2369,2569,2574,2780,2808,2825,2884,3020,3026,3037,3051,3165,3188,3193,3212,3281,3292,3325,3329,3346,3375,3593,3650,3682,3721,3722,3752,4026,4049,4310,4451,4461,4486,4507,4510,4520,4583,4584,4620,4640,4672,4674,4787,4832,4902,4905,5060,5092,5094,5170,5176,5183,5189,5244,5282,5301,5324,5392,5469,5472,5476,5505,5538,5677,5683,5685,5688,5703,5798,5802,5831,5848,5895,6093,6142,6166,6176,6254,6256,6311,6335,6345,6392,6393,6470,6473,6482,6538,6606,6612,6616,6666,6671,6776,6783,6836,6868,6944,6998,7017,7024,7050,7056,7105,7109,7124,7138,7139,7210,7287,7450,7513,7533,7591,7615,7621,7692,7716,7730,7782,7811,7869,7918,7933,7970,7993,8002,8027,8215,8294,8393,8444,8532,8565,8568,8589,8602,8610,8638,8707,8835,8856,8887,8939,8940,9061,9147,9190,9206,9262,9282,9401,9411,9428,9472,9559,9641,9650,9677,9678,9873,9924,9932,10035,10274,10371,10407,10501,10572,11207,11241,11345,11374,11408,11549,11693,11814,11857,12020,12324,12460,12620,12628,12650,12668,12670,12685,12686,12708,12870,12887,12913,12973,12996,13004,13014,13016,13067,13152,13277,13294,13348,13353,13474,13475,13646,13718,13725,13775,13900,13971,13973,14022,14129,14229,14293,14362,14534,14536,14554,14602,14675,14808,14860,14873,14944,14974,15038,15043,15133,15140,15144,15245,15261,15293,15382,15414,15475,15476,15520,15533,15574,15613,15619,15646,15690,15710,15796,15861,15868,15871,15878,15890,15945,15969,15972,16014,16029,16055,16062,16071,16081,16102,16103,16115,16120,16161,16176,16202,16245,16481,16497,16526,16543,16547,16566,16569,16742,16743,16751,16833,16905,16908,16950,16976,17104,17114,17136,17139,17177,17307,17309,17315,17334,17335,17395,17419,17449,17458,17483,17496,17528,17607,17608,17611,17629,17695,17702,17721,17756,17785,17857,17862,17986,18003,18071,18073,18074,18075,18077,18088,18220,18241,18260,18300,18307,18309,18322,18327,18360,18558,18578,18652,18757,18779,18791,18819,19019,19137,19282,19303,19381,19460,19551,19647,19650,19661,19668,19695,19706,19710,19720,19733,19772,19825,19860,19874,19886,19923,19931,19937,19980,19996,20060,20076,20095,20191,20192,20193,20208,20213,20308,20439,20448,20459,20567,20595,20599,20616,20643,20648,20677,20699,20700,20727,20847,20921,20966,20967,20997,21016,21036,21038,21061,21159,21198,21203,21256,21279,21280,21283,21285,21288,21300,21338,21368,21464,21473,21485,21486,21524,21526,21528,21529,21538,21560,21618,21622,21623,21650,21661,21664,21690,21695,21704,21719,21720,21727,21800,21824,21826,21835,21843,21850,21910,21954,21955,22015,22018,22038,22062,22077,22117,22163,22164,22195,22241,22302,22309,22324,22406,22421,22446,22453,22512,22580,22603,22620,22622,22626,22655,22658,22710,22726,22727,22765,22779,22780,22787,22804,22827,22829,22833,22870,22886,22897,22923,22947,22972,23007,23024,23043,23062,23065,23082,23089,23124,23179,23214,23364,23397,23400,23480,23482,23528,23665,23716,23788,23906,23927,23932,24016,24226,24249,24393,24408,24475,24522,24582,24617,24690,24803,24920,24922,24933,24937,24954,24956,24993,25030,25035,25062,25112,25131,25138,25171,25318,25351,25406,25436,25448,25506,25542,25584,25646,25660,25689,25707,25904,25966,26000,26028,26033,26037,26043,26044,26082,26100,26147,26148,26221,26241,26317,26343,26360,26405,26415,26424,26447,26454,26474,26504,26651,26652,26677,26707,26713,26742,26762,26801,26820,26825,26845,26874,26881,26897,26905,26907,26916,26944,26947,26949,26959,26973,26982,26991,27000,27023,27038,27091,27340,27344,27354,27366,27511,27522,27526,27530,27688,27702,27707,27717,27722,27726,27786,27803,27805,27809,27843,27846,27875,27878,27949,27978,28072,28078,28080,28152,28193,28218,28334,28339,28340,28402,28440,28442,28470,28512,28548,28614,28616,28629,28643,28656,28665,28671,28706,28707,28712,28725,28727,28728,28745,28763,28776,28795,28799,28800,28803,28807,28833,28834,28844,28845,28847,28866,28872,28925,28931,28944,29054,29071,29127,29134,29201,29329,29374,29389,29418,29459,29460,29468,29540,29635,29894,30138,30262,30484,30572,30573,30940,31401,31807,32286,32965,33107,33327,33417,33503,34265,34595,34785,34902,34942,34969,35051,35071,35072,35073,35088,35097,35156,35165,35167,35206,35294,35308,35326,35330,35427,35430,35564,35588,35657,35674,35694,35713,35724,35744,35861,35909,35931,35955,36012,36165,36191,36285,36346,36355,36463,36479,36575,36750,36795,36798,36806,37129,37251,37528,37529,37532,37972,38212,38365,38392,38417,38503,38598,38631,38825,38964,39056,39061,39170,39299,39301,39398,39529,39530,39703,39882,39971,40036,40052,40107,40110,40119,40358,40481,40492,40605,40625,40655,40784,41063,41117,41348,41353,41380,41381,41520,41723,41744,41866,41874,42394,42404,42822,43090,43107,43162,43353,43645,43944,44078,44100,44101,44817,45008,45134,45293)
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 | 893 | 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.48 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.44 ms |
preparing | 0.69 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.34 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.06 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 |