Tiempo de la consulta: 15.01 ms Después de la última consulta: 0.71 ms Consulta a la memoria: 1.455 MB memoria antes de la consulta: 4.305 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 10:54:48')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 10:54: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,173,188,189,190,200,205,234,246,248,249,252,263,271,325,353,362,412,415,416,420,421,422,423,424,425,426,427,429,431,469,484,495,496,501,503,510,531,574,575,593,618,686,706,785,787,825,837,853,860,862,868,966,986,1010,1053,1065,1066,1082,1128,1136,1207,1213,1223,1235,1268,1299,1322,1340,1353,1357,1370,1422,1431,1434,1480,1550,1628,1678,1706,1718,1748,1762,1788,1833,1835,1872,1878,1939,2036,2087,2093,2108,2162,2166,2193,2204,2208,2272,2289,2303,2435,2559,2560,2643,2652,2681,2786,2812,2825,3011,3020,3032,3051,3167,3190,3212,3228,3325,3329,3368,3373,3640,3650,3682,3772,3818,4189,4191,4310,4508,4608,4609,4674,4767,4845,4902,4905,4948,4983,5011,5033,5060,5103,5135,5189,5326,5392,5397,5476,5477,5487,5517,5533,5538,5604,5685,5719,5798,5829,5847,5895,5907,6016,6044,6207,6263,6271,6277,6293,6311,6352,6368,6392,6460,6462,6482,6616,6628,6629,6636,6666,6671,6728,6743,6776,6805,6836,6868,6908,6935,6949,6952,6983,7017,7050,7056,7109,7123,7124,7135,7138,7176,7210,7287,7305,7439,7450,7544,7553,7570,7692,7716,7730,7744,7782,7811,7933,7970,7993,8027,8075,8215,8232,8444,8565,8589,8602,8610,8638,8681,8734,8835,8856,8858,8887,9008,9081,9191,9206,9262,9282,9411,9428,9472,9650,9677,9678,9859,9924,10019,10035,10042,10093,10212,10274,11054,11244,11345,11699,11789,11808,11950,11970,12020,12086,12140,12237,12259,12324,12460,12470,12620,12650,12670,12685,12686,12708,12761,12901,12913,12916,12973,12996,13014,13016,13057,13152,13219,13228,13274,13275,13294,13346,13348,13474,13475,13501,13900,13971,13973,14101,14152,14229,14230,14279,14293,14300,14362,14389,14472,14479,14493,14534,14536,14539,14554,14582,14619,14683,14728,14754,14860,14904,14927,14931,14977,15024,15038,15043,15107,15111,15150,15219,15220,15245,15261,15293,15354,15382,15414,15475,15476,15508,15520,15533,15574,15745,15796,15861,15934,15945,15972,15978,16055,16062,16071,16115,16161,16176,16298,16364,16497,16503,16526,16543,16551,16566,16585,16623,16658,16670,16751,16803,16833,16908,16950,16971,16976,16989,16990,17010,17091,17106,17114,17170,17309,17334,17335,17419,17496,17528,17580,17607,17615,17629,17663,17702,17721,17727,17736,17857,17885,17995,18060,18071,18073,18080,18088,18096,18113,18125,18162,18220,18230,18260,18265,18266,18300,18307,18309,18327,18343,18360,18402,18459,18516,18558,18566,18578,18712,18728,18757,18764,18819,18854,18959,18982,19282,19381,19460,19551,19570,19632,19650,19661,19668,19695,19733,19772,19825,19886,19923,19931,19937,19980,19986,20060,20095,20122,20128,20180,20192,20193,20213,20308,20423,20439,20459,20557,20567,20595,20616,20643,20648,20699,20700,20727,20756,20847,20978,21016,21038,21044,21159,21171,21187,21189,21224,21252,21256,21257,21270,21279,21283,21285,21288,21300,21338,21368,21371,21464,21485,21486,21524,21526,21529,21618,21623,21633,21650,21661,21664,21690,21695,21704,21719,21727,21765,21800,21808,21824,21830,21843,21850,21910,21954,21955,21993,22015,22018,22043,22062,22077,22091,22117,22127,22163,22164,22169,22189,22195,22241,22302,22324,22406,22421,22446,22453,22512,22580,22603,22620,22622,22626,22649,22655,22658,22700,22710,22727,22763,22765,22780,22785,22787,22789,22804,22829,22833,22897,22920,22923,22947,22972,22996,23007,23024,23043,23052,23055,23062,23082,23089,23124,23179,23214,23373,23448,23480,23518,23528,23546,23575,23605,23665,23716,23760,23927,24016,24030,24191,24226,24249,24293,24341,24393,24394,24402,24408,24475,24522,24551,24582,24617,24623,24635,24803,24806,24814,24856,24883,24937,24943,24956,24993,25010,25030,25035,25062,25131,25138,25162,25171,25318,25351,25382,25406,25436,25448,25534,25542,25584,25646,25660,25839,25904,25955,26000,26023,26033,26147,26159,26221,26317,26343,26360,26415,26424,26425,26454,26474,26651,26655,26664,26677,26680,26713,26742,26801,26820,26845,26881,26905,26907,26944,26973,26983,26992,27000,27038,27117,27326,27366,27399,27420,27530,27587,27655,27688,27722,27846,28072,28080,28339,28440,28442,28614,28615,28616,28682,28695,28712,28728,28735,28845,28866,28907,28908,28944,29054,29135,29372,29460,29635,30470,30487,31064,31944,33417,33438,33795,33897,34297,34298,34317,34340,34341,34643,34644,34779,34926,35077,35265,35330,35332,35399,35480,35646,35713,35733,35744,35787,35955,35989,36026,36053,36251,36601,36655,36856,36885,37423,37594,37892,37926,37929,38067,38256,38279,38341,38381,38463,38586,38589,38760,38944,39398,39436,39530,39628,39860,40036,40300,40319,40492,40605,40635,41773,41962,42347,42600,42631,42671,42700,43456,43498,43878,43910,44814,45008,45173)
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 | 815 | 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.38 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.17 ms |
System lock | 0.02 ms |
optimizing | 0.06 ms |
statistics | 1.35 ms |
preparing | 1.07 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 11.11 ms |
end | 0.03 ms |
query end | 0.08 ms |
closing tables | 0.03 ms |
freeing items | 0.15 ms |
cleaning up | 0.05 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 |