Tiempo de la consulta: 10.81 ms Después de la última consulta: 0.80 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.313 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 07:31:39')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-09 07:31:39')
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(174,193,205,218,257,275,311,466,471,610,1279,1280,1295,1322,1349,1375,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1460,1476,1481,1484,1534,1553,1586,1595,1624,1664,1666,1716,1785,1810,1811,1812,1841,1852,1855,1903,1906,1984,2001,2068,2081,2148,2193,2199,2301,2324,2359,2432,2469,2480,2629,2678,2691,2724,2748,2773,3035,3056,3163,3164,3202,3255,3278,3317,3355,3388,3393,3486,3497,3499,3513,3529,3553,3581,3590,3594,3613,3663,3686,3706,3713,3746,3747,3872,3938,3992,4048,4054,4069,4075,4084,4132,4146,4168,4197,4202,4215,4220,4252,4369,4375,4436,4466,4475,4478,4511,4512,4518,4523,4524,4525,4539,4558,4570,4580,4585,4586,4595,4605,4665,4731,4733,4734,4758,4760,4795,4796,4798,4800,4822,4842,4874,4892,4914,4919,4938,4960,5014,5035,5076,5079,5095,5143,5157,5166,5226,5250,5276,5284,5292,5295,5304,5310,5313,5329,5382,5430,5435,5442,5456,5489,5491,5496,5534,5642,5659,5700,5704,5751,5797,5876,5916,5932,5936,5939,5990,6007,6030,6031,6047,6064,6068,6075,6115,6133,6136,6200,6202,6217,6242,6264,6308,6323,6328,6348,6396,6409,6414,6417,6421,6433,6447,6453,6461,6485,6512,6520,6533,6553,6596,6648,6663,6667,6715,6778,6814,6815,6842,6900,6932,6981,7033,7148,7149,7182,7200,7207,7237,7261,7277,7318,7320,7352,7358,7421,7435,7452,7510,7537,7540,7611,7626,7649,7688,7709,7748,7765,7769,7802,7824,7834,7839,7845,7868,7878,7880,7883,7884,7908,7912,7931,7946,8069,8091,8094,8099,8100,8108,8160,8179,8196,8206,8229,8230,8244,8271,8283,8285,8305,8332,8341,8361,8365,8400,8412,8452,8454,8476,8570,8598,8627,8646,8677,8695,8715,8718,8730,8742,8753,8755,8778,8821,8842,8851,8854,8867,8876,8899,8907,8934,8938,9007,9019,9047,9064,9068,9071,9103,9108,9122,9127,9131,9132,9161,9166,9177,9181,9187,9189,9232,9244,9309,9311,9354,9381,9383,9449,9462,9466,9471,9473,9501,9534,9548,9562,9563,9569,9573,9584,9617,9638,9646,9663,9676,9684,9690,9713,9715,9717,9725,9760,9783,9794,9879,9893,9896,9911,9922,9971,9977,9992,10014,10052,10061,10084,10087,10122,10163,10210,10212,10240,10270,10279,10371,10392,10432,10450,10542,10570,10616,10701,10725,10727,10736,10754,10774,10775,10789,10791,10793,10812,10834,10877,10933,10953,10967,11056,11069,11120,11152,11164,11195,11199,11240,11314,11338,11373,11422,11428,11437,11491,11510,11558,11568,11600,11607,11636,11683,11703,11705,11742,11795,11806,11829,11842,11885,11886,11906,11907,12057,12063,12082,12170,12198,12229,12238,12274,12334,12384,12439,12440,12452,12513,12565,12631,12661,12662,12743,12816,12822,12824,12844,12946,12953,12955,12984,12994,13065,13078,13083,13110,13160,13175,13185,13204,13205,13258,13266,13272,13291,13295,13297,13313,13316,13344,13352,13377,13428,13436,13437,13438,13458,13467,13478,13479,13480,13481,13482,13497,13502,13503,13523,13525,13561,13563,13589,13597,13633,13639,13660,13668,13698,13724,13764,13784,13794,13797,13810,13853,13885,13968,13993,13995,14039,14111,14140,14148,14155,14177,14205,14226,14297,14309,14345,14407,14429,14432,14512,14520,14546,14566,14594,14641,14646,14710,14784,14814,14824,14828,14864,14874,14889,14958,14991,15012,15063,15101,15105,15138,15147,15148,15207,15216,15229,15238,15295,15420,15443,15527,15543,15563,15598,15632,15643,15645,15673,15681,15693,15701,15722,15759,15798,15810,15857,15894,15910,15935,15938,15976,15982,16136,16240,16258,16273,16274,16311,16314,16327,16348,16386,16396,16466,16493,16495,16509,16511,16529,16548,16562,16569,16586,16593,16602,16607,16629,16634,16653,16658,16681,16705,16726,16750,16767,16774,16780,16791,16798,16874,16883,16889,16937,16953,16959,16987,17023,17053,17121,17126,17131,17147,17159,17177,17198,17224,17282,17299,17304,17324,17329,17355,17383,17384,17413,17475,17478,17499,17554,17614,17620,17645,17667,17699,17720,17731,17780,17792,17853,17892,17913,17927,17955,18006,18037,18150,18160,18174,18202,18271,18290,18382,18399,18423,18450,18466,18540,18551,18614,18631,18725,18732,18739,18740,18813,18827,19043,19069,19135,19143,19196,19307,19335,19343,19383,19407,19412,19505,19522,19597,19638,19640,19691,19773,19787,19796,19797,19816,19832,19853,19933,19949,19979,20004,20009,20051,20056,20080,20181,20202,20208,20242,20265,20292,20360,20404,20452,20507,20568,20569,20737,20753,20773,20803,20845,20902,20933,21099,21189,21193,21197,21205,21208,21279,21280,21284,21307,21408,21411,21437,21438,21491,21527,21569,21601,21611,21620,21691,21779,21795,21957,22011,22042,22053,22100,22318,22400,22415,22416,22454,22464,22600,22710,22722,22731,22864,22872,22983,23031,23032,23039,23040,23101,23114,23221,23277,23284,23296,23313,23394,23406,23453,23473,23547,23552,23592,23593,23634,23664,23691,23695,23701,23715,23747,23782,23858,23859,23868,23954,24007,24017,24198,24441,24447,24455,24596,24599,24726,24778,24784,24819,24875,24884,24966,24977,25010,25039,25070,25071,25096,25141,25172,25197,25201,25278,25284,25292,25406,25542,25592,25609,25621,25655,25680,25681,25693,25792,25851,25862,25881,25902,25943,25964,26109,26154,26166,26167,26171,26348,26353,26438,26468,26530,26619,26706,26722,26765,26797,26807,26852,26860,26909,26944,26945,26950,26951,27035,27046,27054,27237,27274,27280,27311,27383,27414,27415,27491,27610,27802,27834,28320,28323,28454,28628,28716,28746,28839,28952,29357,29373,29865,34273,35102,35780,36085,36200,36297,36751,37883,38398,38974,39193,39276,39315,39347,39375,39722,39747,39768,39802,40082,40282,40465,40535,40614,41150,41220,41436,41800,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 | 985 | 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.48 ms |
checking permissions | 0.01 ms |
checking permissions | 0.02 ms |
Opening tables | 0.02 ms |
init | 0.18 ms |
System lock | 0.02 ms |
optimizing | 0.07 ms |
statistics | 1.50 ms |
preparing | 0.72 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 6.07 ms |
end | 0.02 ms |
query end | 0.02 ms |
closing tables | 0.02 ms |
freeing items | 0.07 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 |