Tiempo de la consulta: 4.30 ms Después de la última consulta: 0.78 ms Consulta a la memoria: 0.041 MB memoria antes de la consulta: 4.188 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 16:18:45')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 16:18:45')
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,78,81,87,88,89,110,111,125,151,167,188,189,190,200,204,205,234,246,248,249,252,263,271,293,325,353,362,390,412,415,416,420,421,422,423,424,426,427,429,431,435,437,443,447,484,495,496,501,503,506,531,547,574,575,593,605,607,639,644,645,653,663,686,693,701,719,721,757,760,777,785,836,853,862,868,912,944,986,1173,1207,1223,1236,1353,1357,1434,1463,1567,1643,1718,1725,1878,1893,1898,1990,2108,2144,2150,2163,2164,2169,2178,2182,2192,2194,2195,2199,2201,2202,2204,2208,2209,2210,2213,2219,2222,2227,2232,2234,2235,2237,2241,2242,2243,2245,2246,2249,2256,2261,2262,2272,2273,2278,2286,2319,2346,2348,2353,2386,2396,2398,2409,2627,2631,2658,2666,2770,2823,2825,2967,3013,3020,3049,3051,3065,3113,3166,3212,3286,3301,3325,3347,3379,3414,3650,3682,3886,3931,3932,4019,4045,4165,4188,4204,4229,4254,4310,4392,4631,4651,4674,4902,4905,4907,4908,5060,5189,5275,5298,5324,5392,5471,5476,5538,5615,5685,5798,5895,5969,5998,6020,6101,6311,6392,6482,6548,6565,6616,6666,6670,6671,6694,6751,6776,6830,6836,6868,6975,6986,6989,7017,7050,7056,7109,7124,7138,7181,7205,7210,7265,7269,7275,7287,7288,7293,7300,7326,7335,7450,7692,7716,7730,7758,7782,7811,7933,7935,7970,7993,8027,8061,8215,8345,8444,8447,8565,8589,8602,8610,8638,8828,8835,8856,8887,8932,9206,9249,9262,9282,9296,9411,9472,9650,9677,9678,9834,9924,10008,10035,10202,10255,10274,10366,10484,10502,10912,11031,11035,11113,11138,11142,11345,12020,12166,12225,12324,12460,12620,12650,12653,12670,12677,12685,12686,12708,12769,12808,12871,12913,12973,12996,13014,13016,13152,13293,13294,13348,13473,13474,13475,13534,13543,13544,13600,13611,13759,13900,13971,13973,13975,14005,14229,14271,14279,14293,14307,14321,14362,14363,14391,14445,14447,14450,14481,14491,14507,14529,14534,14536,14538,14550,14554,14560,14570,14573,14683,14707,14860,14893,14909,15038,15043,15100,15158,15245,15261,15293,15382,15414,15475,15476,15477,15520,15533,15574,15599,15796,15848,15861,15945,15972,16029,16055,16062,16071,16115,16161,16176,16183,16228,16364,16476,16497,16523,16526,16543,16566,16568,16573,16751,16833,16859,16908,16950,16976,17059,17114,17138,17222,17309,17312,17332,17334,17335,17374,17419,17496,17528,17542,17562,17607,17615,17629,17649,17688,17702,17707,17712,17721,17729,17767,17857,17943,18071,18073,18220,18260,18300,18309,18360,18369,18372,18380,18497,18558,18578,18590,18628,18687,18694,18711,18755,18757,18768,18781,18782,18819,18837,18847,18929,18934,18969,18997,19031,19080,19272,19282,19381,19383,19419,19435,19460,19541,19551,19634,19650,19661,19668,19695,19733,19772,19825,19886,19923,19931,19937,19971,19980,19993,20024,20036,20058,20060,20065,20095,20192,20193,20213,20281,20308,20333,20439,20459,20500,20542,20549,20563,20567,20595,20609,20616,20648,20699,20700,20727,20814,20847,20947,20955,21016,21034,21038,21106,21128,21145,21159,21256,21268,21279,21283,21285,21288,21300,21338,21350,21368,21398,21464,21485,21486,21524,21526,21529,21531,21536,21618,21623,21650,21661,21664,21690,21695,21704,21719,21727,21800,21812,21824,21843,21850,21878,21904,21910,21954,21955,22015,22018,22030,22062,22077,22117,22163,22164,22195,22241,22262,22267,22302,22324,22336,22359,22395,22406,22414,22417,22419,22421,22423,22446,22453,22512,22580,22603,22620,22621,22622,22626,22632,22655,22658,22689,22710,22727,22752,22765,22780,22787,22804,22829,22833,22834,22897,22913,22923,22935,22947,22972,23007,23024,23043,23062,23073,23082,23089,23124,23179,23214,23279,23287,23367,23480,23527,23528,23592,23634,23665,23693,23709,23716,23719,23927,23970,23991,24016,24024,24226,24236,24249,24255,24270,24272,24275,24302,24393,24408,24454,24475,24522,24573,24582,24603,24617,24672,24692,24803,24937,24956,24977,24993,25030,25035,25062,25081,25093,25102,25106,25121,25131,25138,25171,25310,25318,25343,25351,25352,25384,25386,25389,25402,25406,25436,25445,25448,25477,25501,25542,25560,25584,25636,25646,25657,25660,25664,25672,25676,25688,25697,25711,25718,25740,25756,25807,25820,25884,25896,25904,25908,25948,25971,25985,26000,26030,26033,26056,26133,26139,26140,26147,26160,26166,26167,26193,26221,26250,26275,26288,26292,26317,26336,26343,26360,26381,26397,26415,26424,26431,26451,26453,26454,26471,26474,26533,26541,26559,26571,26596,26651,26677,26697,26709,26713,26723,26741,26742,26761,26801,26802,26804,26809,26820,26845,26859,26881,26905,26907,26924,26944,26960,26969,26973,26993,27000,27018,27025,27028,27038,27044,27056,27058,27070,27079,27138,27148,27366,27417,27491,27530,27544,27597,27688,27722,27738,27763,27846,27998,28036,28072,28080,28309,28339,28342,28367,28440,28442,28457,28461,28472,28484,28496,28499,28614,28615,28616,28620,28690,28695,28712,28728,28747,28755,28787,28845,28887,28939,28944,29054,29241,29460,29534,29569,29588,29591,29593,29635,29722,30939,31430,32392,33417,34409,35330,35369,35548,35562,35632,35667,35713,35744,35878,35950,35955,36060,36153,36241,36383,36396,36534,36639,36866,36937,37005,37455,38380,38426,38495,38597,38612,38712,38736,38793,38836,38846,38847,38857,38867,38868,38878,38890,38960,39025,39049,39144,39385,39387,39398,39406,39530,39657,39902,39931,39936,39938,39995,40014,40036,40079,40223,40492,40605,40681,40684,40797,40867,41002,41005,41026,41034,41047,41399,41507,41515,42210,42434,42455,42456,42458,42532,42562,42948,42971,43466,43842,43898,43907,43912,43980,43981,43996,44289,44303,45004,45005,45008,45009,45018,45023,45038,45039,45040,45041,45042,45043,45180)
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 | 969 | 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.47 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
init | 0.19 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.58 ms |
preparing | 0.73 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 0.32 ms |
end | 0.01 ms |
query end | 0.02 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 |