Tiempo de la consulta: 16.83 ms Después de la última consulta: 1.25 ms Consulta a la memoria: 1.487 MB memoria antes de la consulta: 4.373 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-06 03:16:20')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 03:16:20')
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(10,47,62,78,85,155,163,174,203,205,207,208,214,219,267,279,285,303,349,357,368,450,495,531,572,666,667,808,863,869,885,954,1101,1102,1182,1216,1278,1279,1284,1289,1291,1324,1338,1345,1346,1398,1413,1455,1459,1486,1490,1504,1506,1538,1600,1601,1648,1815,1846,1867,1919,1943,1956,2066,2188,2328,2392,2402,2647,2954,3055,3106,3107,3109,3174,3180,3312,3327,3364,3369,3385,3390,3402,3409,3412,3448,3451,3454,3490,3499,3571,3572,3577,3663,3739,3802,3806,3916,4015,4033,4039,4055,4060,4063,4087,4092,4144,4153,4163,4165,4166,4177,4180,4203,4205,4237,4276,4280,4311,4334,4337,4341,4389,4395,4419,4457,4496,4503,4511,4533,4549,4559,4568,4589,4594,4602,4650,4660,4699,4713,4760,4767,4773,4820,4823,4840,4912,4936,4940,4949,4980,4983,5005,5050,5086,5100,5115,5131,5161,5203,5210,5218,5224,5240,5247,5258,5274,5301,5329,5337,5350,5396,5428,5432,5455,5461,5462,5478,5502,5504,5536,5598,5633,5704,5725,5783,5788,5825,5835,5855,5857,5881,5908,5913,5931,5940,5941,5959,5979,6009,6020,6043,6051,6064,6070,6074,6081,6116,6120,6135,6167,6177,6178,6192,6274,6291,6294,6350,6356,6361,6374,6428,6435,6456,6471,6472,6473,6479,6494,6495,6497,6499,6515,6520,6521,6534,6576,6578,6598,6601,6603,6636,6639,6655,6656,6657,6659,6662,6695,6724,6725,6734,6764,6789,6790,6805,6826,6838,6843,6869,6871,6873,6875,6876,6879,6881,6903,6904,6914,6925,6927,6928,6940,6956,6957,6968,6980,6986,6990,6992,6994,7009,7011,7013,7014,7016,7020,7045,7059,7085,7100,7102,7122,7148,7246,7248,7272,7311,7313,7314,7357,7389,7394,7397,7432,7439,7443,7449,7453,7478,7484,7488,7494,7516,7523,7542,7547,7548,7571,7578,7586,7616,7618,7623,7626,7675,7677,7683,7711,7720,7722,7726,7728,7736,7737,7773,7774,7787,7793,7794,7797,7808,7813,7818,7832,7841,7854,7877,7897,7923,7924,8026,8036,8046,8060,8061,8062,8071,8090,8092,8103,8106,8118,8135,8141,8151,8157,8170,8198,8199,8200,8272,8298,8323,8331,8334,8341,8345,8388,8399,8452,8470,8489,8510,8517,8539,8559,8595,8598,8608,8619,8639,8641,8649,8652,8655,8658,8665,8687,8700,8702,8738,8755,8761,8765,8770,8794,8823,8828,8829,8856,8864,8871,8875,8913,8922,8926,8953,8973,8982,9009,9020,9024,9029,9041,9058,9065,9068,9087,9096,9101,9127,9128,9140,9146,9147,9192,9253,9260,9300,9355,9364,9365,9406,9434,9476,9489,9514,9542,9554,9556,9558,9561,9565,9569,9592,9594,9602,9651,9714,9724,9730,9734,9762,9773,9783,9794,9836,9843,9877,9893,9896,9910,9911,9919,9924,9941,9951,9961,10017,10040,10083,10118,10133,10149,10184,10192,10208,10209,10221,10264,10291,10297,10307,10322,10332,10352,10395,10398,10436,10450,10464,10473,10475,10478,10480,10485,10543,10613,10629,10630,10631,10645,10646,10650,10660,10663,10681,10692,10694,10710,10754,10783,10801,10941,10958,10969,11041,11059,11065,11098,11106,11119,11151,11163,11209,11226,11229,11235,11258,11289,11295,11402,11416,11446,11472,11505,11867,11875,11904,11907,11934,11972,12002,12046,12218,12331,12401,12410,12412,12463,12474,12620,12622,12625,12637,12651,12652,12686,12708,12743,12841,12857,12875,12884,13017,13020,13090,13187,13290,13294,13298,13430,13455,13505,13506,13528,13552,13588,13671,13687,13697,13707,13742,13777,13842,13884,13963,13975,13990,14074,14082,14092,14095,14105,14108,14110,14117,14118,14123,14142,14146,14189,14195,14196,14224,14234,14240,14244,14261,14262,14271,14273,14276,14318,14353,14367,14383,14440,14445,14448,14456,14507,14524,14528,14533,14622,14646,14662,14681,14683,14701,14726,14745,14748,14750,14765,14773,14792,14794,14827,14842,14870,14871,14899,14943,14949,14964,14983,14987,15004,15030,15032,15037,15048,15049,15094,15108,15111,15116,15129,15132,15139,15166,15178,15213,15247,15251,15302,15319,15333,15335,15338,15370,15382,15390,15403,15424,15432,15438,15439,15453,15482,15492,15500,15503,15521,15533,15542,15548,15560,15562,15575,15578,15628,15631,15647,15655,15678,15693,15705,15717,15720,15723,15725,15728,15736,15746,15757,15761,15770,15777,15780,15782,15784,15808,15813,15840,15878,15896,15912,15933,15935,15938,15954,15993,16000,16008,16028,16036,16048,16057,16092,16093,16140,16141,16153,16161,16181,16206,16231,16233,16257,16288,16326,16335,16354,16372,16374,16378,16389,16458,16461,16471,16475,16497,16515,16534,16543,16652,16653,16657,16666,16768,16770,16822,16832,16850,16886,16889,16900,16929,16936,16958,16967,16981,17000,17075,17096,17128,17160,17190,17214,17215,17227,17228,17243,17245,17257,17275,17277,17299,17344,17347,17358,17382,17396,17432,17437,17541,17573,17583,17596,17602,17634,17652,17659,17668,17672,17702,17707,17709,17716,17718,17733,17738,17756,17766,17778,17783,17809,17810,17817,17818,17831,17840,17869,17888,17895,17923,17961,17980,18031,18248,18309,18316,18326,18356,18369,18384,18404,18419,18442,18451,18498,18505,18518,18530,18537,18541,18543,18550,18555,18561,18577,18595,18603,18610,18612,18619,18682,18689,18694,18739,18753,18775,18786,18832,18847,18848,18852,18861,18872,18878,18901,18910,18920,18940,18941,18942,18948,18966,18972,18977,18982,18985,18987,18991,18995,19000,19003,19007,19022,19034,19061,19076,19083,19086,19091,19100,19105,19110,19115,19132,19136,19149,19171,19173,19185,19207,19247,19270,19274,19294,19304,19318,19322,19353,19358,19366,19382,19386,19396,19442,19453,19479,19503,19519,19524,19566,19567,19575,19591,19595,19604,19608,19645,19646,19650,19661,19674,19684,19700,19718,19787,19792,19815,19867,19894,19906,19930,19932,19941,19943,19974,19983,19991,20000,20020,20034,20036,20069,20099,20103,20131,20145,20162,20183,20199,20216,20279,20281,20344,20354,20363,20374,20399,20403,20408,20440,20441,20464,20472,20504,20527,20541,20578,20579,20636,20638,20641,20648,20649,20658,20659,20716,20729,20730,20731,20753,20768,20776,20787,20797,20826,20856,20866,21000,21012,21063,21118,21161,21178,21209,21242,21252,21262,21296,21305,21312,21323,21343,21351,21388,21413,21425,21429,21433,21436,21452,21458,21464,21516,21522,21536,21546,21566,21578,21585,21586,21610,21627,21700,21703,21709,21714,21734,21737,21759,21871,21886,21906,21912,21952,21988,22002,22051,22059,22100,22124,22214,22243,22244,22245,22246,22247,22296,22305,22326,22339,22365,22419,22435,22439,22455,22492,22500,22502,22509,22527,22558,22564,22608,22673,22690,22708,22715,22725,22742,22744,22803,22805,22829,22854,22869,22871,22874,22895,22924,22946,22963,22988,23000,23022,23033,23034,23079,23081,23122,23124,23148,23203,23209,23219,23247,23256,23265,23286,23299,23300,23344,23375,23396,23408,23459,23467,23512,23546,23559,23564,23565,23602,23606,23626,23670,23685,23691,23703,23759,23763,23772,23839,23857,23874,23898,23900,23922,23930,23955,23959,23962,23967,23968,23984,23989,24008,24010,24020,24024,24061,24072,24075,24076,24111,24124,24141,24174,24196,24202,24230,24238,24264,24282,24316,24346,24348,24352,24429,24472,24523,24525,24566,24607,24616,24618,24624,24673,24679,24775,24782,24788,24794,24857,24867,24888,24924,24943,24968,24979,24989,25003,25046,25048,25100,25126,25139,25144,25194,25224,25245,25263,25269,25273,25349,25360,25373,25374,25412,25418,25421,25451,25478,25516,25531,25538,25554,25556,25563,25590,25624,25673,25764,25798,25817,25818,25888,25955,25987,26107,26122,26176,26234,26249,26344,26346,26366,26414,26454,26522,26564,26665,26685,26691,26756,26772,26779,26802,26808,26815,26816,26827,26861,26898,26910,26926,26939,26964,26982,26986,26996,27024,27026,27059,27086,27128,27131,27139,27151,27171,27186,27356,27367,27404,27405,27423,27490,27506,27520,27545,27558,27567,27572,27601,27655,27656,27663,27683,27692,27695,27738,27758,27887,27903,27999,28005,28067,28397,28424,28452,28530,28674,28718,28780,28824,28845,28973,28984,28992,29004,29005,29021,29034,29037,29089,29124,29256,29358,29489,29617,29694,29716,29810,29873,29919,29930,31227,31499,31510,31516,32182,33099,33815,34239,35144,35722,35740,36893,36916,36918,37315,37380,37874,37996,38056,38066,38361,38455,38734,38775,38812,39269,39307,39358,39451,39452,39504,39516,39966,40169,40198,40213,40312,40313,40314,40360,40542,40583,40801,41036,41063,41402,41423,41811,41885,42460,42489,43680,43705,43706,43707,43914,43915,43917,44031,44041,44497,44681,45115,45160,45206,45252)
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 | 1411 | 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.70 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.26 ms |
System lock | 0.02 ms |
optimizing | 0.10 ms |
statistics | 2.92 ms |
preparing | 1.37 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 10.17 ms |
end | 0.02 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.10 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 |