Tiempo de la consulta: 10.31 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.471 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 03:43:40')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-05 03:43:40')
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(21,193,218,257,275,311,394,441,466,471,610,1279,1280,1284,1295,1322,1349,1352,1357,1375,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1460,1476,1481,1484,1534,1553,1586,1595,1624,1664,1666,1781,1785,1811,1812,1841,1852,1855,1903,1906,1913,1959,1984,2001,2122,2148,2193,2199,2210,2301,2359,2424,2432,2469,2480,2629,2689,2691,2724,2773,2825,2898,3056,3150,3202,3212,3278,3355,3513,3590,3594,3646,3663,3667,3872,3938,3992,4075,4131,4132,4166,4168,4197,4215,4222,4227,4252,4468,4493,4523,4524,4525,4539,4558,4580,4585,4586,4605,4612,4613,4614,4615,4617,4665,4758,4795,4822,4874,4892,4919,4960,5014,5035,5076,5079,5092,5143,5157,5166,5226,5250,5268,5435,5496,5534,5642,5659,5700,5876,5936,5943,5990,6007,6032,6064,6068,6133,6192,6200,6202,6217,6268,6308,6323,6324,6328,6396,6421,6461,6512,6520,6533,6553,6571,6586,6596,6648,6663,6667,6711,6778,6788,6842,6932,6977,7081,7182,7200,7218,7237,7277,7320,7358,7421,7435,7482,7565,7604,7611,7624,7626,7659,7688,7690,7709,7735,7745,7748,7765,7769,7799,7802,7815,7824,7834,7839,7845,7868,7877,7878,7931,7946,8069,8091,8099,8108,8126,8206,8230,8273,8283,8341,8361,8400,8407,8436,8437,8627,8695,8706,8730,8778,8907,8938,9051,9091,9108,9122,9132,9142,9197,9308,9449,9462,9481,9548,9562,9624,9635,9675,9690,9717,9757,9879,9988,10039,10260,10363,10371,10373,10400,10422,10458,10510,10604,10616,10634,10725,10736,10775,10811,10834,10920,11098,11121,11195,11314,11323,11428,11476,11703,11705,11721,11722,11795,11803,11842,11859,11885,12035,12170,12238,12290,12310,12334,12439,12440,12488,12541,12592,12650,12686,12816,12822,12946,12994,13078,13154,13160,13188,13258,13266,13272,13276,13297,13316,13344,13349,13352,13428,13436,13437,13438,13458,13467,13474,13478,13479,13480,13481,13482,13502,13503,13525,13575,13589,13597,13660,13698,13782,13783,13784,13794,13797,13947,13968,14008,14079,14140,14169,14177,14205,14263,14295,14309,14357,14429,14432,14505,14546,14641,14646,14663,14679,14710,14713,14732,14749,14754,14782,14810,14832,14864,14874,14906,14911,14958,14973,14996,15045,15046,15063,15138,15147,15216,15217,15229,15234,15304,15366,15420,15539,15543,15598,15632,15645,15681,15689,15690,15722,15759,15796,15851,15862,15917,15935,15982,16011,16057,16103,16120,16195,16258,16346,16348,16354,16386,16422,16455,16466,16529,16562,16569,16575,16578,16586,16607,16615,16629,16634,16658,16678,16774,16780,16791,16888,16893,16987,17014,17015,17034,17126,17131,17167,17177,17224,17282,17304,17334,17335,17353,17355,17383,17384,17385,17478,17603,17630,17645,17667,17699,17751,17780,17892,17927,18006,18037,18160,18170,18174,18202,18290,18334,18382,18466,18531,18540,18590,18658,18739,18782,18813,18906,18907,18926,18929,19043,19101,19135,19153,19161,19196,19204,19211,19235,19306,19307,19335,19343,19383,19407,19412,19505,19640,19642,19773,19797,19816,19832,19853,19875,19904,19916,19933,19967,19979,20004,20051,20056,20166,20180,20181,20202,20208,20242,20265,20376,20398,20404,20452,20568,20569,20642,20690,20773,20803,20933,21189,21197,21205,21280,21284,21329,21408,21411,21413,21437,21438,21487,21491,21520,21523,21524,21527,21566,21601,21611,21612,21620,21691,21719,21726,21779,21787,21891,21932,21957,22011,22067,22129,22134,22253,22400,22415,22416,22424,22453,22464,22494,22600,22620,22659,22689,22710,22722,22739,22781,22864,22872,22894,22964,23031,23032,23039,23040,23094,23101,23104,23114,23123,23184,23201,23221,23273,23277,23284,23296,23313,23328,23362,23365,23394,23406,23453,23523,23547,23592,23593,23634,23691,23695,23701,23715,23720,23747,23860,23868,23954,23993,24017,24145,24198,24407,24425,24441,24447,24455,24599,24726,24766,24784,24819,24854,24875,24884,24966,24977,25010,25032,25039,25062,25096,25141,25172,25197,25278,25284,25292,25406,25505,25518,25542,25554,25589,25592,25609,25621,25639,25646,25648,25655,25671,25693,25723,25727,25747,25757,25758,25771,25792,25817,25830,25836,25881,25916,25924,25927,25941,25942,25943,25949,25961,25964,25990,25992,25994,25995,26000,26010,26013,26025,26033,26035,26060,26082,26087,26109,26113,26120,26136,26146,26147,26153,26154,26161,26166,26167,26171,26185,26187,26188,26191,26194,26215,26221,26227,26234,26259,26296,26335,26337,26348,26353,26359,26376,26468,26530,26606,26646,26658,26722,26780,26797,26807,26852,26873,26909,26927,26933,26944,26945,26950,26951,26968,27035,27046,27054,27181,27187,27211,27237,27240,27270,27274,27280,27298,27311,27323,27327,27383,27405,27414,27415,27445,27487,27491,27526,27578,27583,27610,27688,27707,27717,27786,27922,27924,28019,28075,28097,28114,28183,28264,28628,28716,28746,28846,28931,28943,29373,29611,29616,29655,29724,30111,31735,31820,31837,31853,32171,32720,32767,32768,33874,33908,33930,34200,34239,34249,35102,35728,35814,35835,35846,36085,36141,36200,36297,36751,36930,37544,37677,37902,38092,38330,38398,38617,38723,38771,38799,38821,38824,38829,38877,38912,38965,38990,39155,39193,39205,39276,39290,39293,39315,39347,39366,39375,39442,39559,39686,39722,39724,39747,39768,39802,39822,40263,40275,40465,40535,40614,40624,40736,41150,41171,41220,41289,41436,41800,42057,42065,42154,42163,42174,42188,42304,42405,42448,42490,42729,42806,42863,43003,43009,43115,43143,43222,43234,43244,43345,43483,43550,43601,43605,43615,43682,43846,43979,44184,44351,44491,44588,44613,44701,44894,44908,45051,45302,45303)
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 | 918 | 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.51 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.21 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.57 ms |
preparing | 0.69 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.34 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.07 ms |
cleaning up | 0.04 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 |