Tiempo de la consulta: 4.06 ms Después de la última consulta: 0.74 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.472 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-09 21:26:54')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 21:26:54')
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,98,110,111,119,125,126,176,178,179,188,189,190,200,205,210,234,246,248,249,263,271,283,325,353,362,412,415,416,420,421,422,423,424,426,427,429,431,432,484,496,501,503,531,574,575,593,680,686,785,787,808,853,862,868,986,1207,1223,1331,1353,1357,1434,1555,1601,1718,1785,1878,1910,1928,2013,2090,2092,2108,2208,2272,2477,2592,2610,2740,2825,2881,2967,3020,3051,3085,3140,3208,3209,3212,3325,3329,3346,3445,3522,3650,3668,3682,3803,3870,3969,4085,4141,4163,4277,4310,4378,4388,4511,4572,4656,4658,4668,4674,4774,4800,4902,4905,4989,5060,5090,5189,5200,5288,5324,5392,5476,5538,5542,5685,5689,5711,5730,5746,5798,5806,5810,5820,5871,5895,5976,6012,6045,6072,6074,6112,6134,6173,6199,6257,6274,6307,6311,6392,6429,6482,6495,6570,6616,6626,6666,6671,6727,6776,6836,6868,7017,7050,7056,7066,7080,7109,7124,7138,7210,7227,7281,7287,7433,7450,7477,7692,7716,7730,7782,7811,7829,7913,7933,7936,7970,7993,8027,8034,8146,8167,8215,8241,8260,8362,8411,8444,8565,8589,8602,8610,8638,8681,8689,8742,8835,8856,8871,8887,8899,8929,8967,9046,9051,9085,9107,9197,9206,9211,9224,9262,9270,9282,9411,9428,9472,9500,9518,9524,9562,9595,9625,9650,9677,9678,9734,9775,9851,9858,9892,9896,9924,9965,10035,10099,10180,10216,10274,10344,10412,10420,10459,10559,10705,10715,10745,10757,10802,10804,10829,10878,10925,10990,11006,11182,11214,11340,11345,11374,11460,11478,11489,11554,11655,11730,11777,12020,12045,12047,12053,12054,12065,12275,12276,12294,12318,12324,12346,12460,12482,12504,12532,12598,12603,12620,12650,12670,12685,12686,12708,12714,12799,12884,12895,12913,12924,12973,12996,12997,13014,13016,13039,13140,13152,13159,13223,13241,13290,13294,13348,13402,13465,13474,13475,13487,13662,13674,13870,13900,13971,13973,14076,14106,14229,14285,14293,14362,14366,14435,14534,14536,14554,14581,14586,14598,14699,14860,14920,14932,14953,15001,15038,15043,15245,15246,15261,15293,15311,15382,15414,15475,15476,15520,15533,15553,15561,15574,15615,15642,15705,15741,15761,15781,15796,15816,15861,15870,15945,15965,15972,15985,15997,16055,16062,16071,16106,16115,16142,16161,16176,16182,16237,16246,16497,16526,16539,16543,16566,16567,16667,16707,16751,16833,16876,16908,16944,16976,17023,17065,17073,17114,17127,17193,17309,17334,17335,17346,17350,17390,17419,17420,17441,17442,17463,17496,17511,17522,17528,17537,17592,17607,17629,17631,17654,17698,17702,17719,17721,17771,17809,17822,17824,17857,17900,17911,17948,17987,18038,18041,18071,18073,18105,18135,18220,18234,18260,18271,18277,18292,18300,18309,18360,18410,18509,18558,18578,18624,18670,18719,18757,18778,18819,18974,19024,19029,19040,19076,19107,19242,19282,19288,19381,19430,19431,19441,19460,19551,19650,19661,19668,19695,19715,19733,19772,19777,19793,19825,19833,19886,19920,19923,19931,19937,19980,20060,20095,20192,20193,20213,20272,20295,20308,20325,20439,20459,20567,20595,20598,20616,20641,20648,20650,20692,20699,20700,20715,20727,20801,20807,20847,20877,20887,20897,21016,21038,21066,21080,21158,21159,21173,21191,21254,21256,21279,21283,21285,21288,21300,21310,21338,21356,21368,21464,21485,21486,21502,21524,21526,21529,21530,21560,21599,21618,21623,21650,21661,21664,21690,21695,21704,21719,21727,21759,21785,21800,21818,21824,21842,21843,21850,21908,21910,21954,21955,22015,22018,22037,22062,22077,22117,22156,22157,22163,22164,22195,22241,22302,22324,22406,22421,22446,22453,22506,22512,22580,22603,22606,22609,22620,22622,22626,22634,22655,22658,22710,22727,22741,22746,22765,22780,22787,22804,22829,22833,22897,22923,22947,22972,23007,23024,23043,23062,23074,23082,23089,23124,23179,23214,23257,23277,23404,23480,23491,23528,23576,23584,23665,23695,23702,23716,23731,23866,23906,23927,24016,24226,24249,24329,24393,24408,24424,24474,24475,24522,24564,24582,24592,24617,24721,24738,24784,24803,24937,24947,24956,24993,25030,25035,25062,25131,25138,25171,25260,25318,25351,25406,25436,25448,25542,25584,25611,25646,25660,25904,25929,25964,25979,26000,26001,26033,26093,26128,26147,26221,26317,26343,26360,26393,26415,26424,26448,26454,26474,26530,26651,26677,26713,26742,26801,26820,26841,26845,26881,26905,26907,26944,26973,26990,27000,27038,27274,27275,27298,27366,27399,27530,27642,27688,27722,27757,27758,27846,27944,27971,28072,28080,28139,28339,28440,28441,28442,28614,28615,28616,28712,28728,28845,28944,29054,29105,29460,29635,30222,31422,31975,33317,33417,34115,34968,35330,35713,35744,35831,35878,35955,36198,36253,36307,36585,36952,38173,38221,39189,39398,39530,39570,39620,39738,40036,40343,40356,40367,40473,40492,40535,40595,40605,42260,42424,42726,42951,43089,43487,43530,43598,43602,44297,45008,45064,45114)
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 | 834 | 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.49 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.27 ms |
preparing | 0.64 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 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 |