Tiempo de la consulta: 3.88 ms Después de la última consulta: 0.82 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.476 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-08 19:58:15')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 19:58:15')
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(8,11,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,81,83,87,88,89,90,110,111,124,125,180,181,186,188,189,198,200,205,212,215,219,220,221,222,224,225,226,234,237,244,246,248,249,250,253,254,257,262,263,271,325,336,353,362,363,366,368,370,371,394,401,412,413,414,415,416,419,420,421,422,423,424,426,427,429,431,433,439,444,445,451,452,473,474,484,496,500,501,503,520,524,531,563,574,575,593,641,642,646,647,648,650,651,652,654,681,684,686,712,785,818,853,862,868,923,986,1052,1066,1207,1223,1227,1264,1266,1267,1268,1269,1270,1272,1273,1274,1275,1276,1277,1278,1285,1314,1329,1339,1348,1353,1357,1388,1389,1390,1394,1434,1718,1878,1979,2108,2208,2272,2569,2639,2697,2738,2825,2869,2911,3020,3051,3161,3181,3212,3325,3417,3473,3544,3559,3650,3662,3666,3682,3868,4310,4430,4674,4815,4902,4905,5060,5075,5176,5189,5215,5324,5392,5415,5472,5476,5538,5676,5685,5756,5798,5846,5895,5908,5954,6084,6254,6263,6311,6392,6393,6470,6473,6482,6616,6666,6671,6719,6776,6836,6868,7017,7050,7056,7100,7109,7124,7138,7210,7278,7287,7450,7591,7621,7692,7702,7716,7730,7782,7811,7821,7933,7970,7978,7993,8024,8027,8215,8296,8313,8353,8444,8448,8477,8565,8589,8602,8610,8638,8685,8715,8835,8856,8887,8891,8939,9084,9137,9139,9153,9199,9206,9238,9262,9282,9296,9369,9411,9428,9453,9472,9650,9677,9678,9716,9768,9784,9870,9924,9958,10035,10224,10274,10296,10330,11224,11345,11374,11462,11475,11663,11857,12020,12259,12315,12324,12334,12373,12420,12460,12620,12628,12650,12668,12670,12685,12686,12708,12839,12887,12891,12913,12973,12996,13004,13014,13016,13152,13197,13202,13277,13294,13315,13335,13348,13358,13474,13475,13646,13718,13722,13725,13775,13900,13971,13973,14229,14293,14362,14439,14534,14536,14554,14602,14675,14779,14809,14860,14972,15038,15043,15245,15261,15291,15293,15382,15392,15414,15433,15475,15476,15488,15520,15533,15574,15796,15861,15890,15945,15972,15998,16014,16029,16055,16062,16071,16115,16161,16176,16202,16258,16481,16497,16526,16543,16566,16751,16833,16903,16908,16950,16976,17104,17114,17139,17177,17217,17307,17309,17334,17335,17419,17496,17528,17607,17611,17629,17643,17645,17681,17695,17702,17721,17785,17851,17857,17862,17934,18071,18073,18074,18220,18257,18260,18284,18300,18309,18322,18360,18448,18454,18549,18558,18578,18757,18771,18778,18791,18819,19235,19282,19303,19381,19460,19551,19570,19650,19661,19668,19695,19698,19720,19733,19756,19772,19804,19825,19886,19923,19931,19937,19980,20025,20060,20076,20095,20192,20193,20208,20213,20288,20300,20308,20439,20459,20567,20595,20602,20616,20643,20648,20677,20699,20700,20727,20806,20847,20949,21016,21019,21038,21061,21062,21159,21198,21229,21256,21279,21280,21283,21285,21288,21298,21300,21308,21338,21342,21353,21361,21368,21411,21464,21485,21486,21488,21524,21526,21528,21529,21538,21618,21622,21623,21650,21656,21661,21664,21690,21695,21704,21719,21727,21786,21800,21818,21824,21826,21843,21850,21910,21933,21934,21954,21955,22015,22018,22045,22062,22077,22117,22163,22164,22180,22195,22196,22241,22300,22302,22309,22324,22406,22421,22426,22446,22453,22512,22580,22603,22620,22622,22626,22650,22655,22658,22710,22727,22734,22765,22780,22787,22804,22827,22829,22833,22845,22890,22897,22923,22947,22972,23007,23024,23043,23062,23082,23089,23124,23142,23168,23179,23203,23214,23364,23480,23521,23528,23665,23716,23906,23927,24015,24016,24043,24062,24079,24226,24249,24255,24335,24393,24408,24475,24499,24522,24582,24617,24654,24706,24708,24803,24808,24894,24922,24937,24954,24956,24993,25030,25035,25062,25066,25131,25138,25146,25157,25171,25253,25318,25335,25351,25356,25406,25407,25436,25448,25506,25510,25542,25582,25584,25631,25646,25660,25707,25731,25904,25963,26000,26028,26033,26147,26167,26171,26221,26317,26343,26360,26362,26415,26424,26454,26474,26617,26627,26651,26677,26713,26742,26801,26820,26845,26874,26881,26887,26905,26907,26916,26944,26947,26959,26973,27000,27038,27091,27154,27300,27366,27526,27530,27688,27707,27717,27722,27726,27786,27805,27809,27846,27878,27949,27978,28072,28078,28080,28339,28440,28442,28614,28615,28616,28643,28712,28728,28845,28944,29048,29054,29084,29314,29459,29460,29540,29635,29931,30484,30940,31550,31640,31670,31820,31908,32912,33417,33477,33575,34087,34195,34381,35115,35330,35574,35674,35713,35744,35760,35861,35909,35955,36209,36283,36431,36474,36479,36511,36711,36746,37099,37397,37926,38463,38586,38589,38631,39121,39335,39398,39447,39480,39530,39572,39617,39641,39839,40036,40244,40492,40523,40605,41055,41994,42357,42704,42856,42922,43193,43639,43640,43698,44040,44883,44884,44885,44886,44887,44888,44889,44890,45008,45247)
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 | 831 | 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.42 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.26 ms |
preparing | 0.64 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.47 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |