Tiempo de la consulta: 3.35 ms Después de la última consulta: 0.55 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.450 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:40:47')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 21:40:47')
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,165,188,189,190,200,205,219,234,246,248,249,263,271,325,353,362,412,415,416,420,421,422,423,424,426,427,429,431,484,496,501,503,531,550,574,575,583,593,686,785,853,862,868,954,986,1207,1223,1314,1316,1347,1353,1357,1384,1434,1477,1502,1503,1505,1512,1520,1543,1629,1655,1718,1724,1773,1878,2108,2208,2272,2473,2482,2589,2732,2746,2796,2825,2871,3020,3051,3212,3325,3650,3682,3794,4233,4310,4459,4651,4674,4766,4902,4905,5025,5060,5069,5189,5210,5324,5392,5417,5476,5538,5685,5769,5798,5895,6066,6075,6151,6193,6258,6311,6392,6482,6616,6666,6671,6776,6836,6868,7017,7050,7056,7109,7124,7138,7210,7287,7450,7692,7716,7730,7738,7782,7811,7933,7970,7993,8027,8215,8231,8255,8420,8444,8522,8565,8589,8602,8610,8623,8638,8691,8802,8835,8856,8887,8955,9206,9262,9282,9411,9428,9472,9549,9650,9677,9678,9773,9924,10035,10060,10274,10478,11124,11320,11345,11564,11853,11883,12020,12324,12409,12460,12620,12650,12670,12685,12686,12708,12846,12913,12973,12996,13014,13016,13152,13294,13348,13474,13475,13656,13887,13888,13900,13971,13973,14226,14229,14293,14362,14452,14534,14536,14554,14738,14740,14860,14919,15038,15043,15245,15261,15293,15382,15414,15475,15476,15520,15533,15574,15796,15861,15866,15871,15925,15932,15945,15972,16055,16062,16071,16073,16115,16161,16176,16335,16374,16475,16497,16522,16526,16543,16566,16751,16833,16861,16908,16950,16976,17114,17309,17334,17335,17412,17419,17421,17496,17523,17528,17565,17607,17629,17671,17702,17721,17813,17850,17857,18005,18071,18073,18220,18260,18299,18300,18309,18360,18368,18436,18521,18522,18558,18578,18665,18757,18775,18819,18859,18874,18902,19282,19381,19460,19551,19605,19650,19661,19668,19695,19733,19772,19825,19886,19923,19931,19937,19980,19996,20051,20060,20095,20192,20193,20213,20243,20308,20439,20459,20553,20567,20595,20616,20648,20699,20700,20727,20847,20957,21016,21033,21038,21049,21134,21159,21256,21279,21283,21285,21288,21292,21300,21322,21338,21343,21368,21419,21464,21485,21486,21524,21526,21529,21584,21618,21623,21650,21661,21664,21690,21695,21704,21719,21727,21751,21777,21800,21824,21843,21850,21910,21954,21955,22015,22018,22050,22062,22117,22163,22164,22195,22241,22302,22324,22405,22406,22421,22446,22453,22512,22580,22588,22603,22620,22622,22626,22655,22658,22680,22688,22699,22710,22714,22727,22765,22780,22787,22804,22829,22833,22854,22858,22897,22923,22947,22972,23007,23024,23043,23062,23072,23082,23089,23100,23124,23179,23192,23214,23348,23354,23366,23418,23420,23433,23449,23464,23480,23516,23528,23534,23573,23591,23596,23617,23665,23716,23769,23825,23927,23951,23957,23992,23996,24016,24063,24144,24226,24249,24276,24375,24393,24408,24475,24512,24522,24564,24582,24617,24654,24681,24706,24803,24805,24908,24937,24956,24993,25025,25030,25035,25062,25112,25131,25138,25171,25243,25318,25351,25406,25436,25448,25460,25491,25542,25584,25628,25646,25660,25904,25963,26000,26033,26056,26147,26221,26248,26317,26343,26354,26360,26415,26424,26454,26474,26651,26677,26693,26713,26742,26801,26820,26826,26845,26881,26905,26907,26944,26973,26975,27000,27038,27214,27366,27391,27438,27525,27530,27593,27688,27722,27746,27846,27867,28072,28080,28128,28140,28339,28436,28440,28442,28614,28615,28616,28712,28728,28845,28944,29054,29122,29173,29235,29460,29635,29715,29788,33417,35330,35443,35460,35713,35744,35932,35955,36282,36729,38822,38896,39398,39530,40036,40278,40492,40605,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 | 619 | 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.32 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.16 ms |
System lock | 0.02 ms |
optimizing | 0.05 ms |
statistics | 1.02 ms |
preparing | 0.51 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.36 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.05 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 |