Tiempo de la consulta: 5.69 ms Después de la última consulta: 0.67 ms Consulta a la memoria: 0.072 MB memoria antes de la consulta: 4.460 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 04:27:06')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 04:27:06')
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,99,110,111,125,188,189,190,200,205,234,246,248,249,263,271,325,353,362,412,415,416,420,421,422,423,424,426,427,429,431,454,484,496,501,503,531,574,575,593,686,743,785,801,853,862,868,897,918,971,979,986,1207,1223,1353,1357,1434,1614,1713,1718,1747,1878,1902,2046,2098,2108,2208,2272,2316,2419,2466,2825,2847,2974,3020,3051,3076,3212,3325,3426,3650,3682,3871,4304,4310,4674,4832,4902,4905,5060,5150,5189,5324,5392,5432,5476,5538,5685,5798,5895,5913,6311,6350,6392,6482,6573,6616,6666,6671,6761,6775,6776,6836,6868,7017,7050,7056,7081,7109,7124,7138,7210,7214,7287,7342,7377,7450,7523,7526,7692,7716,7730,7745,7782,7811,7855,7933,7970,7993,7997,8027,8215,8222,8289,8416,8444,8532,8565,8589,8602,8603,8610,8638,8732,8787,8835,8856,8865,8887,8903,9045,9206,9262,9282,9411,9428,9472,9566,9650,9677,9678,9924,9975,10035,10160,10274,10440,10504,10604,10660,10813,10915,10968,11345,12020,12140,12317,12324,12437,12460,12620,12650,12670,12685,12686,12708,12913,12973,12996,13014,13016,13152,13294,13348,13359,13474,13475,13725,13782,13900,13971,13973,14139,14206,14218,14229,14293,14328,14362,14378,14534,14536,14554,14601,14648,14663,14744,14860,14880,14890,14905,14940,15038,15043,15059,15060,15148,15180,15220,15245,15261,15262,15293,15319,15372,15382,15414,15456,15467,15475,15476,15494,15520,15533,15574,15796,15861,15945,15947,15972,16055,16062,16071,16115,16161,16176,16208,16465,16497,16526,16543,16566,16652,16706,16723,16751,16823,16833,16908,16950,16976,17105,17114,17133,17309,17317,17334,17335,17419,17496,17528,17531,17607,17629,17702,17721,17857,17866,17927,18071,18073,18220,18260,18300,18309,18360,18558,18578,18659,18757,18819,18927,18929,18982,18995,19010,19118,19217,19265,19281,19282,19381,19426,19460,19519,19551,19650,19661,19668,19695,19733,19772,19825,19886,19923,19931,19937,19980,20060,20095,20192,20193,20213,20246,20308,20439,20459,20567,20595,20616,20648,20699,20700,20711,20720,20727,20833,20837,20841,20847,20863,20883,20925,21016,21021,21038,21055,21056,21122,21159,21180,21256,21275,21279,21283,21285,21288,21300,21338,21368,21380,21441,21464,21485,21486,21520,21523,21524,21526,21529,21550,21566,21618,21623,21650,21661,21664,21690,21695,21704,21719,21727,21800,21824,21843,21850,21875,21910,21913,21914,21932,21954,21955,22015,22018,22062,22077,22117,22163,22164,22195,22241,22302,22324,22357,22362,22384,22406,22421,22424,22446,22453,22486,22510,22512,22528,22580,22603,22620,22622,22626,22655,22658,22659,22710,22726,22727,22753,22765,22779,22780,22787,22804,22829,22854,22856,22897,22915,22923,22947,22959,22971,22972,23007,23024,23043,23062,23082,23089,23124,23138,23179,23192,23214,23254,23273,23288,23305,23309,23365,23416,23479,23480,23528,23665,23716,23795,23804,23811,23913,23927,23996,24016,24077,24082,24089,24099,24140,24148,24187,24190,24201,24208,24226,24247,24249,24259,24337,24357,24381,24393,24408,24475,24522,24582,24617,24803,24908,24937,24951,24956,24980,24993,25030,25035,25062,25131,25138,25171,25318,25351,25406,25436,25448,25514,25542,25584,25639,25646,25648,25660,25665,25668,25673,25746,25763,25764,25779,25904,26000,26033,26113,26117,26134,26147,26174,26175,26191,26221,26317,26343,26360,26415,26424,26454,26474,26480,26626,26634,26651,26671,26677,26710,26713,26742,26760,26801,26820,26830,26845,26864,26881,26905,26907,26935,26944,26973,27000,27036,27038,27085,27196,27258,27323,27366,27396,27454,27510,27523,27530,27541,27555,27559,27570,27636,27655,27656,27671,27688,27722,27743,27846,28031,28045,28059,28066,28072,28075,28080,28095,28097,28120,28127,28129,28137,28158,28168,28243,28339,28435,28440,28442,28614,28615,28616,28712,28728,28759,28765,28845,28858,28944,29054,29460,29602,29630,29635,29660,29671,29681,29909,30334,30525,31706,31735,31794,32257,32468,32761,32768,32879,32977,32980,33026,33065,33090,33157,33289,33338,33417,33545,35330,35713,35744,35955,36254,36758,36955,36960,37370,37499,37508,37646,37850,37979,38158,39060,39137,39153,39199,39398,39530,40036,40492,40494,40605,41193,41226,41296,41308,41625,41883,42010,42029,42510,42513,43612,43704,44070,44098,44230,44379,44553,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 | 734 | 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.64 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.23 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.00 ms |
preparing | 0.91 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.70 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.05 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 |