Tiempo de la consulta: 8.96 ms Después de la última consulta: 0.85 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.397 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 14:03:46')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 14:03:46')
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(193,218,257,275,311,423,466,471,475,529,610,1064,1279,1280,1295,1322,1349,1375,1386,1390,1394,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1460,1476,1481,1484,1534,1552,1553,1586,1595,1624,1664,1666,1811,1812,1841,1852,1855,1903,1906,1919,1984,2001,2140,2148,2193,2199,2301,2324,2359,2432,2469,2479,2480,2563,2629,2691,2724,2727,2773,2854,2909,3056,3102,3119,3202,3278,3297,3355,3434,3499,3513,3588,3590,3594,3663,3672,3739,3746,3747,3777,3798,3802,3806,3824,3828,3842,3850,3872,3923,3938,3980,3992,4033,4048,4075,4132,4168,4170,4178,4180,4193,4197,4205,4237,4252,4273,4280,4311,4334,4337,4339,4341,4354,4419,4523,4524,4525,4529,4532,4533,4535,4539,4541,4558,4568,4580,4585,4586,4594,4605,4650,4652,4665,4667,4758,4795,4817,4820,4822,4838,4840,4874,4892,4919,4936,4938,4940,4960,4965,4980,5005,5014,5025,5033,5035,5072,5076,5079,5086,5115,5124,5131,5143,5157,5166,5210,5213,5226,5250,5252,5258,5274,5329,5331,5337,5374,5375,5381,5435,5455,5496,5502,5504,5534,5536,5545,5598,5642,5659,5700,5704,5783,5792,5800,5801,5806,5812,5825,5835,5852,5855,5865,5876,5908,5913,5936,5940,5941,5943,5945,5954,5959,5979,5990,6007,6009,6020,6050,6051,6064,6068,6069,6070,6133,6135,6147,6165,6167,6200,6202,6217,6232,6262,6274,6291,6294,6308,6323,6328,6356,6361,6396,6414,6421,6438,6440,6461,6479,6512,6520,6533,6553,6581,6596,6648,6663,6667,6745,6769,6778,6826,6842,6881,6927,6930,6932,6963,6980,7009,7060,7085,7093,7116,7118,7148,7182,7200,7220,7237,7239,7277,7320,7357,7358,7381,7394,7421,7435,7452,7526,7540,7611,7626,7688,7694,7709,7732,7748,7765,7769,7793,7802,7813,7824,7834,7839,7845,7854,7868,7878,7880,7888,7905,7908,7911,7931,7946,8031,8060,8069,8091,8092,8099,8108,8116,8127,8151,8170,8201,8206,8230,8283,8331,8344,8361,8382,8388,8390,8400,8470,8517,8530,8539,8590,8595,8627,8649,8652,8684,8687,8695,8720,8747,8755,8761,8765,8778,8832,8875,8897,8899,8907,8913,8922,8929,8938,8953,8963,8969,9009,9024,9096,9108,9121,9122,9132,9140,9177,9181,9253,9285,9289,9365,9386,9410,9449,9462,9548,9562,9651,9675,9690,9704,9717,9734,9834,9877,9879,9910,9979,9989,10040,10084,10126,10133,10371,10432,10465,10607,10616,10620,10725,10736,10775,10790,10830,10834,10877,10881,11056,11069,11119,11195,11300,11314,11428,11650,11705,11749,11795,11801,11827,11842,11885,11972,12057,12170,12229,12238,12334,12392,12439,12440,12525,12627,12687,12712,12816,12822,12884,12946,12955,12978,12989,12994,13005,13063,13065,13078,13094,13160,13199,13208,13258,13266,13272,13291,13297,13316,13344,13366,13428,13436,13437,13438,13458,13467,13478,13479,13480,13481,13482,13502,13503,13525,13589,13597,13660,13698,13724,13784,13794,13797,13810,13854,13882,13968,13993,13997,14050,14121,14123,14140,14177,14205,14309,14334,14399,14410,14429,14432,14484,14546,14641,14646,14662,14699,14710,14802,14809,14864,14874,14958,15012,15058,15063,15099,15132,15138,15147,15211,15216,15229,15242,15343,15420,15503,15543,15598,15628,15632,15645,15681,15713,15722,15736,15759,15810,15933,15935,15982,16032,16052,16107,16113,16158,16258,16308,16348,16386,16403,16426,16466,16491,16529,16569,16586,16607,16629,16634,16658,16681,16774,16780,16791,16878,16899,16915,16953,16987,16993,16996,17053,17075,17121,17126,17131,17147,17177,17223,17224,17245,17282,17355,17383,17384,17396,17478,17645,17654,17667,17672,17699,17780,17892,17927,17938,17979,18006,18037,18137,18160,18174,18202,18290,18382,18466,18540,18589,18598,18739,18813,19038,19043,19115,19135,19196,19307,19335,19339,19343,19383,19407,19412,19505,19616,19638,19640,19773,19797,19816,19822,19832,19853,19933,19947,19979,20004,20051,20056,20181,20202,20208,20242,20265,20292,20404,20452,20507,20568,20569,20697,20759,20773,20803,20933,21028,21160,21189,21197,21205,21280,21284,21378,21408,21411,21437,21438,21491,21492,21527,21601,21611,21616,21620,21691,21779,21824,21957,22011,22400,22415,22416,22464,22511,22551,22588,22600,22613,22710,22722,22864,22872,23031,23032,23039,23040,23087,23101,23114,23221,23277,23284,23296,23313,23394,23406,23453,23547,23592,23593,23634,23691,23695,23701,23714,23715,23747,23782,23868,23954,24007,24017,24026,24056,24175,24198,24416,24441,24447,24455,24599,24726,24784,24819,24875,24884,24966,24977,25010,25039,25096,25141,25172,25197,25278,25284,25292,25405,25406,25542,25609,25621,25655,25693,25792,25881,25943,25964,26109,26114,26154,26166,26167,26171,26332,26338,26348,26353,26419,26468,26487,26530,26551,26602,26633,26722,26786,26797,26805,26807,26852,26909,26944,26945,26950,26951,27035,27046,27054,27224,27237,27274,27280,27311,27383,27414,27415,27491,27587,27610,27747,27935,28374,28628,28663,28666,28716,28746,28932,29373,35102,35780,36085,36200,36263,36287,36297,36389,36465,36496,36544,36628,36740,36751,36989,37018,37084,37097,38276,38398,39193,39276,39315,39347,39375,39688,39722,39747,39768,39802,40465,40535,40614,40682,40759,40812,41150,41220,41436,41749,41800,41814,42057,42065,42154,42163,42174,42188,42304,42405,42448,42490,42729,42806,42863,43009,43115,43143,43222,43234,43244,43345,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 | 912 | 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.03 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.12 ms |
statistics | 1.49 ms |
preparing | 0.70 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 5.20 ms |
end | 0.03 ms |
query end | 0.05 ms |
closing tables | 0.03 ms |
freeing items | 0.11 ms |
cleaning up | 0.05 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 |