Tiempo de la consulta: 3.85 ms Después de la última consulta: 0.73 ms Consulta a la memoria: 0.057 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-05 17:00:11')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 17:00:11')
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,125,176,178,179,188,189,190,200,205,234,246,248,249,263,271,297,325,353,362,412,415,416,420,421,422,423,424,426,427,429,431,432,461,484,496,501,503,531,574,575,593,686,785,853,862,868,972,975,986,1190,1207,1223,1331,1353,1357,1432,1434,1555,1718,1785,1878,1910,1928,2090,2092,2108,2208,2272,2592,2610,2740,2807,2825,3020,3051,3085,3212,3325,3346,3650,3682,3808,3870,3969,4163,4310,4378,4388,4511,4520,4572,4658,4668,4674,4723,4848,4902,4905,4927,5060,5189,5232,5286,5288,5324,5392,5476,5537,5538,5685,5798,5810,5820,5895,5976,6012,6112,6199,6307,6311,6392,6429,6482,6616,6626,6666,6671,6776,6836,6868,7017,7050,7056,7109,7124,7138,7143,7207,7210,7227,7287,7433,7450,7477,7582,7692,7716,7730,7738,7782,7811,7829,7869,7933,7936,7970,7993,8027,8034,8146,8167,8215,8362,8444,8502,8565,8589,8602,8610,8638,8679,8681,8689,8742,8750,8835,8856,8887,8899,9046,9051,9085,9107,9206,9211,9224,9262,9270,9273,9282,9411,9428,9454,9472,9480,9494,9500,9518,9524,9595,9650,9677,9678,9734,9775,9806,9851,9858,9892,9896,9924,9965,10035,10128,10274,10279,10420,10573,10715,10745,10878,11182,11199,11345,11374,11608,12020,12053,12054,12061,12318,12324,12453,12460,12482,12614,12620,12621,12650,12670,12685,12686,12708,12714,12895,12913,12973,12996,12997,13014,13016,13039,13152,13197,13290,13294,13348,13402,13474,13475,13719,13885,13900,13971,13973,13988,14145,14229,14293,14362,14366,14435,14534,14536,14554,14581,14586,14598,14699,14860,14953,15001,15038,15043,15240,15245,15261,15293,15311,15380,15382,15414,15475,15476,15520,15533,15561,15574,15602,15615,15705,15741,15781,15796,15861,15870,15910,15945,15965,15972,15985,16055,16062,16071,16080,16106,16115,16142,16161,16176,16188,16237,16240,16246,16377,16497,16526,16543,16566,16575,16667,16751,16833,16907,16908,16941,16944,16950,16976,17028,17058,17065,17114,17127,17299,17309,17334,17335,17346,17442,17463,17483,17496,17528,17607,17629,17645,17654,17698,17702,17719,17721,17824,17857,17900,17948,17995,18071,18073,18135,18175,18182,18220,18260,18271,18277,18292,18300,18309,18360,18410,18481,18509,18558,18578,18579,18624,18634,18670,18719,18757,18778,18795,18819,18854,18974,19029,19053,19076,19232,19242,19282,19288,19306,19381,19430,19460,19551,19650,19661,19668,19695,19715,19733,19772,19777,19825,19886,19920,19923,19931,19937,19976,19980,20060,20095,20192,20193,20213,20295,20308,20325,20439,20448,20459,20550,20567,20595,20598,20604,20616,20641,20648,20699,20700,20715,20727,20754,20807,20847,20877,20887,20897,20900,20901,21016,21027,21036,21038,21066,21159,21173,21191,21256,21279,21283,21285,21288,21300,21310,21338,21356,21368,21464,21485,21486,21502,21524,21526,21529,21530,21560,21618,21623,21650,21661,21664,21690,21695,21704,21719,21727,21759,21800,21818,21824,21842,21843,21850,21910,21954,21955,22015,22018,22037,22062,22077,22117,22156,22163,22164,22171,22195,22199,22241,22302,22314,22324,22406,22421,22446,22453,22512,22580,22603,22606,22609,22620,22622,22626,22634,22655,22658,22710,22727,22741,22746,22747,22765,22780,22787,22804,22829,22833,22897,22923,22947,22972,23007,23024,23043,23051,23062,23082,23086,23089,23124,23142,23179,23214,23217,23238,23257,23277,23404,23480,23521,23528,23556,23569,23576,23665,23695,23716,23731,23866,23906,23927,24015,24016,24112,24121,24156,24180,24181,24203,24206,24226,24249,24255,24335,24393,24408,24431,24474,24475,24522,24582,24592,24617,24663,24670,24721,24738,24784,24803,24808,24937,24947,24956,24993,25030,25035,25062,25131,25138,25146,25171,25223,25260,25318,25335,25351,25357,25406,25407,25436,25448,25542,25582,25584,25611,25646,25660,25904,25929,25964,25979,26000,26001,26033,26093,26128,26147,26221,26236,26317,26343,26360,26393,26415,26424,26448,26454,26474,26530,26651,26677,26713,26742,26796,26801,26820,26825,26841,26845,26881,26884,26905,26907,26944,26973,26990,27000,27038,27093,27366,27399,27471,27486,27530,27627,27688,27722,27757,27846,27944,27971,28072,28080,28139,28254,28339,28440,28441,28442,28614,28615,28616,28712,28728,28845,28944,29054,29460,29635,30222,31975,33417,35330,35713,35744,35831,35955,35990,39398,39530,39570,40036,40343,40356,40367,40492,40605,40904,43479,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 | 751 | 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.45 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.22 ms |
preparing | 0.64 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.41 ms |
end | 0.01 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 |