Tiempo de la consulta: 5.11 ms Después de la última consulta: 1.21 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.379 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 19:50:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-06 19:50:19')
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(9,10,12,13,14,15,16,17,18,25,47,61,71,119,160,185,203,205,207,208,219,255,271,272,283,323,325,353,368,400,403,429,462,495,583,613,657,689,697,706,722,723,724,768,808,832,863,868,937,940,1101,1102,1126,1216,1233,1250,1284,1291,1324,1338,1345,1398,1413,1455,1458,1459,1469,1486,1490,1504,1506,1515,1600,1601,1654,1684,1735,1745,1815,1824,1887,1943,1956,1975,2016,2066,2069,2101,2254,2380,2517,2605,2674,2713,2724,2804,2967,3001,3065,3154,3183,3208,3303,3312,3327,3343,3346,3385,3390,3433,3448,3462,3490,3491,3493,3569,3572,3597,3653,3732,3750,3754,3916,3983,4015,4039,4055,4060,4063,4087,4092,4132,4144,4153,4163,4165,4177,4203,4276,4389,4395,4397,4457,4492,4496,4511,4549,4559,4602,4660,4760,4773,4912,4949,4983,5050,5079,5093,5095,5100,5123,5161,5203,5218,5240,5301,5334,5350,5428,5432,5462,5513,5633,5700,5725,5788,5931,5979,6043,6074,6081,6102,6116,6151,6177,6192,6291,6301,6315,6344,6350,6354,6363,6372,6374,6395,6400,6428,6435,6456,6471,6473,6494,6495,6497,6499,6515,6520,6521,6534,6537,6540,6542,6543,6576,6578,6593,6598,6601,6603,6636,6655,6656,6657,6659,6662,6695,6724,6725,6734,6764,6771,6789,6790,6805,6807,6808,6838,6840,6843,6869,6871,6872,6873,6875,6876,6879,6889,6903,6904,6914,6925,6927,6928,6940,6956,6957,6964,6968,6986,6990,6992,6994,6995,6997,7009,7011,7016,7018,7020,7026,7045,7057,7059,7100,7102,7311,7313,7314,7389,7397,7430,7432,7443,7449,7453,7478,7484,7488,7492,7494,7516,7523,7542,7547,7548,7569,7571,7578,7583,7586,7616,7618,7623,7626,7630,7675,7677,7680,7683,7711,7722,7726,7728,7737,7749,7773,7774,7787,7794,7797,7808,7832,7841,7877,7917,8026,8036,8062,8071,8088,8103,8106,8116,8135,8141,8157,8198,8199,8200,8206,8272,8293,8298,8323,8328,8334,8345,8399,8404,8413,8440,8447,8452,8489,8510,8513,8559,8598,8608,8619,8639,8641,8649,8655,8658,8665,8700,8702,8738,8740,8755,8761,8765,8770,8794,8823,8828,8829,8830,8856,8871,8907,8926,8937,8953,8973,8982,9020,9041,9048,9056,9057,9058,9065,9068,9082,9101,9127,9128,9147,9152,9192,9200,9244,9260,9300,9314,9323,9355,9406,9476,9489,9514,9542,9556,9558,9561,9565,9569,9592,9594,9602,9637,9652,9658,9714,9724,9730,9762,9764,9783,9794,9825,9843,9893,9896,9910,9911,9919,9941,9951,9961,9964,10017,10059,10083,10118,10149,10184,10192,10195,10208,10209,10221,10264,10273,10291,10294,10297,10322,10332,10352,10386,10395,10398,10436,10450,10462,10464,10473,10475,10480,10485,10543,10613,10629,10631,10645,10646,10650,10660,10663,10681,10692,10710,10754,10941,10969,10973,11022,11041,11065,11098,11106,11151,11163,11195,11209,11226,11229,11235,11258,11271,11289,11295,11318,11410,11416,11505,11552,11645,11682,11854,11867,11875,11904,11907,11934,11961,12002,12046,12055,12206,12296,12369,12412,12651,12652,12743,12841,12857,12902,13029,13030,13090,13129,13166,13187,13190,13290,13430,13455,13498,13505,13506,13524,13528,13530,13548,13550,13552,13573,13588,13601,13641,13646,13688,13712,13763,13777,13814,13821,13842,13855,13884,13895,13950,13968,13969,14047,14057,14081,14095,14108,14110,14118,14146,14148,14159,14188,14189,14195,14196,14197,14224,14234,14240,14244,14261,14276,14304,14318,14353,14367,14368,14383,14428,14440,14445,14448,14524,14528,14533,14622,14675,14681,14701,14711,14719,14726,14745,14748,14750,14765,14769,14773,14792,14800,14827,14834,14839,14842,14856,14864,14870,14871,14899,14943,14949,15018,15038,15048,15049,15116,15124,15166,15178,15247,15248,15251,15302,15319,15323,15333,15335,15338,15390,15432,15438,15453,15470,15482,15496,15500,15503,15521,15533,15542,15552,15560,15576,15578,15606,15628,15631,15647,15655,15678,15693,15705,15719,15720,15723,15746,15761,15770,15777,15780,15784,15808,15813,15840,15878,15896,15897,15912,15938,15954,15993,16008,16028,16036,16048,16141,16142,16178,16181,16218,16231,16233,16288,16309,16321,16325,16328,16349,16354,16372,16378,16389,16432,16434,16451,16461,16471,16475,16488,16508,16515,16521,16549,16603,16607,16641,16653,16666,16713,16733,16734,16739,16768,16770,16808,16822,16850,16886,16900,16911,16958,16967,17086,17096,17100,17134,17138,17157,17160,17190,17197,17214,17227,17228,17243,17275,17277,17294,17299,17309,17344,17389,17396,17437,17458,17484,17485,17573,17583,17602,17634,17646,17652,17668,17707,17709,17716,17718,17738,17751,17756,17775,17778,17809,17810,17817,17835,17869,17883,17888,17892,17923,17938,18033,18043,18058,18103,18112,18113,18129,18142,18183,18193,18202,18231,18240,18248,18267,18295,18311,18326,18356,18358,18382,18393,18404,18409,18422,18431,18451,18505,18518,18521,18530,18537,18541,18550,18595,18602,18603,18610,18611,18619,18629,18644,18694,18717,18753,18756,18763,18772,18775,18786,18826,18832,18852,18861,18867,18872,18878,18887,18919,18940,18941,18948,18966,18972,18985,18987,19003,19007,19034,19050,19061,19076,19086,19096,19100,19126,19133,19173,19184,19217,19223,19267,19318,19322,19353,19355,19358,19382,19413,19475,19479,19503,19519,19566,19575,19591,19612,19645,19646,19653,19674,19693,19703,19716,19787,19792,19801,19828,19855,19871,19873,19906,19943,19974,19992,20000,20020,20027,20076,20131,20139,20160,20163,20198,20208,20209,20251,20254,20274,20279,20281,20282,20351,20399,20408,20441,20463,20471,20472,20504,20520,20527,20541,20564,20579,20641,20648,20658,20698,20716,20729,20730,20731,20753,20757,20767,20776,20787,20797,20800,20809,20840,20866,20940,20993,20996,21012,21032,21063,21064,21068,21165,21205,21209,21262,21296,21312,21323,21343,21347,21351,21359,21369,21376,21397,21405,21408,21411,21413,21414,21425,21429,21436,21459,21517,21535,21541,21566,21578,21585,21594,21606,21610,21627,21700,21703,21732,21734,21750,21841,21846,21871,21886,21903,21926,22002,22026,22040,22046,22051,22097,22124,22125,22180,22214,22225,22229,22234,22243,22244,22245,22246,22247,22270,22276,22296,22305,22326,22339,22365,22385,22401,22414,22438,22439,22479,22489,22509,22549,22558,22564,22568,22608,22611,22690,22692,22705,22714,22720,22725,22745,22784,22792,22848,22854,22871,22946,22948,22960,22962,22988,23016,23033,23040,23079,23106,23147,23156,23198,23203,23209,23245,23247,23265,23299,23300,23319,23325,23388,23396,23399,23421,23434,23459,23485,23492,23512,23566,23590,23602,23606,23626,23647,23654,23670,23685,23700,23759,23769,23802,23898,23903,23944,23968,23989,24008,24020,24061,24119,24124,24152,24192,24196,24200,24202,24238,24242,24277,24288,24312,24316,24330,24342,24348,24352,24383,24398,24421,24429,24440,24447,24450,24451,24466,24476,24479,24498,24518,24525,24566,24597,24601,24643,24679,24705,24708,24725,24747,24775,24782,24794,24823,24826,24867,24886,24891,24924,24990,24994,25023,25046,25133,25139,25144,25194,25222,25224,25263,25269,25315,25412,25413,25418,25451,25478,25516,25531,25538,25554,25556,25563,25590,25609,25631,25738,25787,25816,25817,25834,25888,25940,25968,26017,26024,26034,26061,26062,26166,26202,26234,26249,26261,26286,26288,26302,26328,26344,26346,26366,26378,26410,26414,26439,26457,26471,26570,26630,26640,26646,26679,26685,26756,26763,26766,26770,26815,26827,26861,26866,26918,26945,26964,26967,26986,26992,27059,27071,27086,27128,27138,27139,27142,27171,27214,27322,27367,27404,27405,27423,27458,27475,27513,27518,27556,27567,27601,27655,27656,27663,27683,27692,27695,27758,27776,27887,27903,27974,27999,28049,28067,28530,28536,28686,28718,28720,28779,28795,28965,28973,28984,28992,29004,29005,29020,29021,29034,29037,29107,29153,29187,29200,29489,29694,29716,29772,29810,29871,29873,29907,29935,30609,30854,31510,31773,32182,32241,33099,33621,33950,34096,34160,34239,34524,34584,34758,34927,35259,35305,35474,35560,35716,35718,35722,35740,35769,35791,35811,35985,36197,36423,36517,37025,38662,38784,38818,38865,38905,38917,38962,39078,39226,39296,39432,39451,39673,39782,39808,39823,40198,40583,40809,40812,40954,41038,41052,41156,41254,41559,41594,41790,42074,42262,42286,42343,42483,42502,42503,44537,45191)
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 | 1371 | 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.61 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.25 ms |
System lock | 0.02 ms |
optimizing | 0.09 ms |
statistics | 1.99 ms |
preparing | 1.04 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.06 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 |