Tiempo de la consulta: 16.79 ms Después de la última consulta: 1.73 ms Consulta a la memoria: 1.877 MB memoria antes de la consulta: 4.258 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-08 00:04:08')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 00:04:08')
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,72,99,114,203,205,207,208,219,249,368,412,414,423,427,595,604,726,816,842,860,892,1058,1207,1226,1284,1291,1324,1338,1345,1388,1398,1412,1413,1455,1459,1475,1486,1490,1504,1506,1600,1601,1696,1815,1883,1943,1956,2035,2066,2531,2589,2739,2853,2900,3144,3208,3312,3327,3385,3390,3448,3452,3473,3490,3572,3605,3674,3898,3916,3918,4015,4039,4055,4060,4063,4087,4092,4144,4153,4163,4165,4177,4203,4258,4276,4389,4395,4457,4496,4511,4549,4559,4602,4625,4660,4760,4773,4879,4912,4932,4949,4983,5050,5100,5161,5190,5203,5218,5240,5301,5350,5428,5432,5438,5462,5582,5633,5725,5777,5788,5931,5979,6043,6074,6081,6112,6116,6119,6177,6192,6258,6291,6294,6350,6355,6374,6428,6435,6456,6471,6473,6494,6495,6497,6499,6515,6520,6521,6534,6549,6576,6578,6598,6601,6603,6636,6655,6656,6657,6659,6662,6695,6724,6725,6734,6744,6764,6789,6790,6805,6838,6843,6869,6871,6873,6875,6876,6879,6903,6904,6914,6925,6927,6928,6936,6940,6956,6957,6968,6986,6990,6992,6994,7009,7011,7016,7020,7032,7045,7059,7100,7102,7248,7311,7313,7314,7337,7389,7397,7412,7432,7443,7449,7453,7457,7478,7484,7488,7494,7516,7523,7542,7547,7548,7571,7578,7586,7616,7618,7623,7626,7675,7677,7683,7711,7722,7726,7728,7737,7773,7774,7787,7794,7797,7806,7808,7829,7832,7841,7847,7877,8026,8036,8062,8071,8100,8103,8106,8116,8135,8141,8157,8198,8199,8200,8240,8272,8298,8323,8334,8345,8398,8399,8452,8470,8489,8510,8559,8598,8608,8615,8619,8639,8641,8649,8655,8658,8665,8700,8702,8738,8755,8761,8765,8770,8780,8794,8823,8826,8828,8829,8856,8871,8875,8916,8917,8926,8932,8953,8954,8973,8982,9009,9020,9041,9058,9065,9068,9101,9127,9128,9147,9184,9192,9260,9295,9300,9355,9406,9476,9489,9514,9542,9556,9558,9561,9565,9569,9592,9594,9602,9714,9724,9730,9762,9783,9794,9843,9850,9855,9893,9896,9910,9911,9919,9941,9951,9961,10017,10083,10118,10149,10184,10192,10208,10209,10221,10264,10291,10297,10322,10332,10352,10395,10398,10436,10450,10464,10473,10475,10480,10485,10509,10543,10613,10629,10631,10645,10646,10650,10659,10660,10663,10681,10692,10710,10754,10894,10924,10941,10969,11041,11065,11083,11091,11098,11106,11122,11127,11143,11151,11157,11163,11209,11226,11229,11235,11258,11289,11295,11309,11407,11416,11497,11505,11585,11587,11614,11706,11721,11727,11839,11867,11875,11904,11907,11915,11934,11987,12002,12018,12038,12040,12046,12091,12098,12109,12133,12306,12334,12412,12449,12590,12651,12652,12664,12673,12735,12743,12841,12848,12857,12903,12916,12991,13037,13090,13130,13141,13187,13198,13285,13290,13331,13346,13418,13425,13426,13430,13455,13505,13506,13528,13552,13556,13558,13588,13595,13611,13627,13677,13697,13777,13884,13951,14073,14080,14095,14097,14104,14108,14110,14114,14118,14146,14150,14177,14189,14193,14195,14196,14218,14222,14224,14227,14234,14236,14240,14244,14261,14267,14276,14278,14318,14353,14367,14383,14388,14440,14445,14448,14469,14524,14528,14533,14563,14574,14622,14632,14681,14701,14726,14745,14747,14748,14750,14765,14770,14773,14792,14799,14827,14842,14870,14871,14899,14914,14943,14949,14957,14960,14969,14978,15006,15048,15049,15069,15116,15146,15166,15175,15178,15206,15247,15251,15302,15303,15319,15321,15333,15335,15338,15390,15432,15438,15453,15482,15490,15500,15503,15518,15521,15533,15542,15560,15565,15578,15628,15631,15641,15647,15655,15667,15668,15678,15693,15705,15720,15723,15731,15746,15761,15770,15777,15780,15784,15808,15813,15840,15878,15896,15912,15938,15954,15993,16008,16024,16028,16036,16048,16053,16141,16165,16169,16181,16219,16231,16233,16288,16316,16344,16354,16356,16372,16377,16378,16389,16415,16442,16458,16461,16471,16475,16515,16520,16640,16645,16653,16666,16688,16768,16770,16822,16827,16846,16850,16861,16864,16886,16900,16908,16917,16946,16958,16967,17063,17096,17130,17136,17160,17170,17172,17190,17214,17221,17227,17228,17243,17275,17277,17299,17344,17380,17396,17400,17436,17437,17488,17573,17583,17584,17600,17602,17629,17634,17643,17644,17645,17652,17668,17679,17680,17699,17701,17707,17709,17716,17718,17724,17738,17756,17766,17778,17785,17798,17809,17810,17817,17822,17852,17862,17869,17874,17886,17888,17905,17923,17938,17946,17957,17959,17965,17966,17976,17977,17991,18006,18021,18035,18036,18123,18138,18151,18156,18168,18171,18185,18191,18241,18248,18253,18259,18261,18303,18308,18347,18354,18356,18370,18396,18404,18413,18418,18426,18445,18451,18453,18473,18491,18497,18500,18505,18518,18524,18528,18530,18537,18540,18541,18550,18564,18575,18580,18584,18595,18599,18603,18610,18619,18635,18638,18668,18686,18694,18746,18751,18753,18766,18775,18786,18790,18793,18795,18813,18828,18829,18832,18852,18853,18861,18868,18872,18874,18878,18917,18918,18940,18941,18948,18966,18972,18973,18985,18987,19003,19005,19007,19034,19041,19061,19076,19079,19082,19100,19117,19173,19175,19217,19223,19242,19267,19288,19301,19310,19312,19318,19320,19322,19353,19358,19371,19382,19390,19417,19432,19436,19473,19479,19484,19495,19503,19519,19531,19561,19566,19567,19571,19575,19591,19594,19602,19604,19643,19645,19646,19671,19674,19684,19696,19701,19710,19723,19728,19751,19764,19769,19780,19787,19792,19824,19829,19832,19876,19882,19905,19906,19939,19943,19952,19962,19974,19982,19988,19989,20000,20017,20019,20020,20062,20123,20131,20133,20145,20149,20150,20176,20187,20188,20193,20211,20213,20259,20264,20277,20279,20281,20298,20307,20310,20323,20326,20340,20343,20367,20380,20391,20399,20401,20405,20408,20410,20421,20441,20442,20444,20472,20481,20484,20488,20504,20517,20527,20541,20550,20567,20572,20587,20601,20611,20629,20630,20641,20648,20658,20705,20709,20713,20714,20716,20727,20729,20730,20731,20752,20753,20776,20787,20797,20808,20813,20820,20830,20865,20866,20871,20875,20877,20881,20884,20907,20910,20920,20923,20925,20942,20954,20962,20973,20990,20993,20999,21002,21021,21033,21040,21042,21047,21050,21059,21063,21069,21070,21080,21084,21090,21101,21107,21132,21134,21142,21145,21159,21165,21169,21186,21204,21209,21230,21245,21262,21273,21288,21296,21308,21312,21323,21343,21351,21397,21402,21410,21413,21420,21425,21429,21436,21437,21458,21466,21474,21477,21485,21486,21491,21498,21504,21512,21519,21541,21543,21544,21547,21554,21560,21563,21566,21574,21578,21581,21585,21610,21611,21616,21618,21627,21637,21640,21641,21650,21660,21670,21683,21688,21690,21699,21700,21703,21734,21738,21755,21756,21758,21764,21800,21810,21820,21837,21851,21853,21864,21871,21882,21886,21897,21902,21921,21926,21960,21976,21977,22002,22015,22017,22023,22034,22050,22051,22064,22073,22081,22084,22085,22092,22100,22112,22124,22136,22162,22164,22165,22171,22188,22198,22204,22214,22237,22242,22243,22247,22252,22271,22278,22281,22285,22290,22292,22296,22305,22321,22322,22326,22337,22339,22341,22353,22365,22394,22405,22406,22408,22439,22469,22478,22480,22500,22502,22509,22514,22522,22544,22545,22557,22558,22564,22577,22590,22606,22608,22610,22614,22646,22658,22690,22707,22716,22725,22737,22741,22745,22757,22759,22767,22794,22803,22816,22838,22854,22871,22885,22894,22935,22946,22955,22968,22970,22971,22988,22991,22997,23003,23017,23033,23035,23038,23046,23051,23061,23063,23070,23079,23085,23095,23097,23117,23132,23135,23136,23148,23188,23201,23203,23209,23216,23217,23239,23253,23257,23265,23280,23285,23295,23299,23302,23305,23317,23320,23342,23345,23348,23349,23351,23352,23383,23396,23419,23420,23437,23442,23459,23512,23521,23528,23551,23556,23560,23571,23582,23585,23595,23602,23605,23606,23609,23615,23626,23631,23649,23662,23670,23679,23680,23681,23685,23697,23712,23736,23759,23772,23777,23800,23803,23806,23811,23813,23814,23826,23847,23851,23852,23854,23898,23915,23945,23951,23953,23956,23961,23963,23968,23975,23985,23989,23999,24008,24020,24045,24054,24055,24061,24087,24112,24120,24124,24127,24139,24165,24169,24180,24181,24189,24196,24202,24203,24204,24206,24213,24223,24238,24244,24245,24246,24250,24265,24295,24304,24307,24316,24325,24333,24348,24352,24359,24385,24386,24401,24410,24414,24425,24426,24429,24433,24440,24456,24458,24483,24502,24513,24525,24532,24549,24560,24566,24574,24580,24583,24616,24628,24632,24644,24645,24651,24660,24664,24679,24681,24691,24694,24707,24709,24730,24748,24750,24768,24775,24782,24789,24794,24796,24800,24803,24824,24830,24848,24861,24865,24867,24875,24877,24878,24895,24896,24907,24924,24925,24941,24966,24967,24969,24973,24977,24988,25001,25021,25025,25030,25031,25046,25053,25057,25061,25080,25089,25101,25118,25123,25127,25129,25139,25144,25147,25155,25171,25194,25204,25206,25209,25210,25224,25241,25243,25263,25269,25277,25287,25296,25344,25351,25369,25372,25374,25376,25378,25396,25399,25407,25412,25418,25424,25436,25440,25451,25458,25460,25465,25478,25491,25492,25499,25503,25516,25517,25520,25523,25524,25525,25528,25531,25534,25536,25538,25541,25551,25552,25554,25556,25559,25563,25566,25568,25569,25582,25590,25591,25596,25649,25686,25690,25702,25755,25775,25779,25781,25817,25844,25873,25874,25888,25941,25960,25962,25974,25983,25990,26033,26044,26082,26147,26161,26164,26172,26201,26234,26241,26249,26256,26271,26274,26283,26296,26318,26320,26344,26346,26347,26351,26354,26362,26366,26414,26548,26563,26588,26613,26685,26689,26694,26728,26734,26756,26796,26814,26815,26827,26861,26863,26901,26964,26986,26999,27048,27059,27086,27104,27119,27124,27128,27139,27156,27171,27242,27252,27261,27302,27314,27330,27367,27369,27404,27405,27423,27425,27472,27542,27551,27567,27601,27622,27625,27655,27656,27663,27683,27692,27695,27736,27758,27801,27803,27806,27818,27860,27871,27875,27887,27903,27958,27999,28030,28067,28117,28248,28254,28281,28328,28343,28402,28416,28423,28429,28458,28463,28504,28511,28530,28535,28547,28555,28575,28619,28683,28691,28703,28712,28718,28736,28807,28809,28840,28973,28984,28992,29003,29004,29005,29021,29034,29037,29108,29159,29201,29221,29250,29281,29298,29320,29332,29355,29444,29450,29476,29489,29516,29619,29694,29716,29810,29824,29868,29873,30284,30414,30696,31116,31510,31519,31623,31624,31663,31758,32182,32642,32643,32679,32813,33099,33115,33178,33179,33181,33274,33416,33421,33559,33592,33874,33951,34024,34066,34069,34079,34080,34086,34120,34131,34155,34177,34205,34210,34222,34223,34230,34231,34239,34240,34255,34261,34283,34296,34304,34308,34335,34346,34356,34417,34489,34573,34639,34690,34888,35285,35300,35498,35517,35657,35676,35722,35740,35752,35768,35792,35837,35851,35875,35895,35936,35959,36049,36050,36056,36100,36270,36298,36459,36499,36548,36630,36813,36832,36837,36863,36990,37143,37311,37329,37363,37364,37409,37440,37512,37561,37639,37695,37696,37702,37709,37843,38034,38223,38224,38225,38235,38328,38579,38701,38750,38798,38807,38833,38961,39333,39361,39383,39451,39594,39602,39615,39642,39652,39711,39775,39870,39916,39922,39933,40034,40072,40116,40145,40146,40147,40198,40207,40260,40271,40339,40370,40388,40390,40516,40560,40578,40583,40584,40682,40734,40824,40852,40984,40995,41089,41094,41102,41118,41119,41185,41197,41236,41253,41270,41304,41327,41364,41393,41409,41411,41447,41463,41474,41536,41672,41703,41841,41860,41868,41898,41917,41942,41943,41944,41991,42003,42017,42045,42055,42071,42092,42096,42098,42126,42152,42270,42296,42318,42342,42360,42376,42457,42585,42674,42690,42716,42742,42767,42787,42801,42820,42826,42899,42900,42908,42920,43003,43013,43053,43122,43144,43204,43223,43250,43293,43363,43451,43581,43607,43621,43668,43693,43740,43754,43828,43830,43831,43887,43906,43913,43979,44038,44066,44082,44095,44112,44113,44116,44162,44217,44220,44314,44396,44426,44506,44509,44527,44545,44569,44572,44682,44787,44830,44846,44928,44938,45000,45066,45089,45090,45091,45092,45093,45094,45095,45128,45203)
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 | 1974 | 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.86 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.36 ms |
System lock | 0.02 ms |
optimizing | 0.13 ms |
statistics | 2.96 ms |
preparing | 1.55 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 10.05 ms |
end | 0.03 ms |
query end | 0.03 ms |
closing tables | 0.02 ms |
freeing items | 0.15 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 |