Tiempo de la consulta: 50.41 ms Después de la última consulta: 2.61 ms Consulta a la memoria: 7.401 MB memoria antes de la consulta: 4.591 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 22:28:25')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-08 22:28:25')
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(1,14,17,19,20,21,22,23,24,25,26,27,28,29,30,31,32,44,45,46,47,48,49,50,51,52,53,56,57,58,59,61,71,72,75,83,127,131,133,134,135,136,137,138,148,165,174,175,180,190,200,204,205,206,222,225,247,250,253,255,262,263,271,272,282,294,308,311,321,323,324,325,327,329,334,353,368,370,385,387,388,390,392,393,395,397,398,400,402,403,404,405,408,410,411,433,435,436,437,438,442,443,445,448,451,454,455,458,460,462,481,484,485,505,507,511,512,520,527,529,531,537,542,547,550,551,560,566,567,583,589,607,608,609,611,667,669,686,690,701,705,708,709,710,711,712,713,723,756,760,783,801,806,808,816,850,856,882,886,892,895,897,907,917,922,933,952,961,968,973,977,986,1018,1036,1044,1047,1059,1069,1078,1080,1101,1112,1124,1130,1133,1134,1169,1183,1185,1193,1198,1204,1207,1216,1226,1233,1236,1238,1265,1277,1285,1290,1317,1329,1330,1339,1347,1353,1401,1414,1434,1459,1476,1491,1492,1538,1555,1587,1591,1594,1600,1617,1645,1664,1685,1697,1698,1766,1768,1787,1788,1808,1813,1835,1924,1978,2024,2150,2162,2181,2195,2250,2290,2293,2338,2353,2371,2394,2482,2485,2552,2569,2637,2688,2726,2732,2733,2755,2758,2759,2780,2797,2859,2958,2961,2967,3071,3089,3099,3114,3126,3193,3208,3279,3306,3353,3379,3409,3425,3442,3491,3495,3520,3592,3607,3626,3634,3641,3668,3684,3696,3769,3819,3825,3832,3837,3884,3898,3940,3951,3984,3993,4004,4035,4046,4063,4092,4116,4153,4249,4263,4292,4301,4309,4353,4378,4383,4409,4410,4436,4445,4452,4453,4471,4487,4515,4516,4580,4583,4631,4640,4641,4688,4692,4710,4732,4765,4808,4931,4973,4992,5001,5051,5078,5084,5085,5154,5176,5206,5292,5333,5365,5424,5451,5472,5480,5515,5564,5576,5584,5634,5647,5660,5680,5700,5726,5727,5730,5757,5785,5798,5811,5833,5870,5894,6058,6062,6141,6150,6186,6215,6221,6245,6254,6270,6278,6279,6315,6331,6339,6367,6381,6393,6395,6415,6448,6463,6470,6473,6475,6476,6477,6503,6534,6537,6546,6548,6577,6598,6600,6604,6605,6616,6643,6666,6669,6673,6681,6684,6686,6691,6708,6744,6752,6764,6775,6783,6793,6799,6806,6809,6828,6888,6889,6913,6916,6939,6941,6942,6965,6988,6994,7014,7023,7056,7101,7105,7121,7153,7173,7185,7194,7212,7243,7245,7269,7276,7290,7291,7343,7368,7405,7407,7413,7418,7421,7430,7432,7451,7461,7462,7463,7476,7484,7486,7492,7499,7516,7546,7551,7567,7580,7589,7591,7594,7596,7597,7615,7618,7621,7652,7680,7711,7718,7719,7720,7722,7730,7741,7744,7761,7801,7802,7804,7837,7840,7950,7955,7965,7966,7967,7980,7981,7987,7994,8002,8022,8027,8053,8054,8073,8082,8106,8177,8250,8258,8304,8327,8328,8351,8406,8413,8437,8440,8442,8445,8447,8530,8551,8565,8566,8568,8587,8610,8613,8663,8679,8689,8692,8728,8760,8819,8864,8909,8910,8911,8939,8941,8943,8950,9063,9073,9091,9109,9115,9199,9218,9239,9253,9257,9323,9351,9370,9412,9416,9472,9473,9531,9532,9580,9620,9734,9745,9747,9756,9757,9772,9779,9792,9820,9848,9924,9934,9945,10006,10008,10024,10050,10051,10077,10079,10092,10120,10180,10197,10198,10216,10237,10248,10260,10266,10278,10282,10290,10303,10348,10350,10354,10355,10369,10385,10414,10415,10478,10486,10499,10518,10530,10554,10557,10563,10666,10686,10690,10731,10765,10806,10831,10857,10869,10888,10912,10927,10955,10971,11006,11062,11064,11080,11087,11091,11114,11123,11147,11182,11206,11207,11273,11290,11320,11328,11330,11374,11388,11417,11419,11438,11441,11447,11468,11471,11487,11494,11533,11542,11552,11557,11560,11581,11651,11662,11692,11704,11753,11762,11840,11841,11848,11857,11880,11900,11921,11925,11937,11965,12024,12025,12032,12079,12080,12084,12108,12113,12126,12162,12186,12189,12201,12204,12207,12213,12216,12237,12244,12248,12251,12274,12281,12297,12338,12362,12363,12366,12369,12415,12430,12443,12463,12474,12475,12477,12482,12490,12493,12535,12537,12557,12564,12608,12624,12625,12628,12668,12672,12685,12704,12723,12745,12750,12757,12786,12802,12808,12810,12868,12887,12902,12913,12920,12935,12942,12963,12965,12973,12977,12983,12986,12999,13004,13020,13036,13044,13086,13112,13143,13152,13176,13188,13190,13191,13235,13246,13259,13269,13277,13279,13287,13309,13318,13348,13364,13387,13420,13434,13456,13479,13543,13553,13560,13573,13600,13609,13621,13631,13635,13637,13646,13651,13662,13672,13673,13674,13678,13695,13702,13707,13710,13713,13715,13718,13725,13729,13775,13798,13813,13838,13860,13867,13900,13920,13929,13933,13950,13985,13986,13994,13997,14005,14011,14052,14061,14062,14069,14083,14105,14109,14139,14149,14183,14184,14186,14197,14205,14226,14227,14232,14252,14264,14273,14278,14282,14289,14301,14339,14348,14368,14393,14408,14426,14433,14434,14451,14456,14471,14486,14516,14557,14583,14591,14596,14600,14602,14610,14624,14652,14657,14674,14675,14684,14687,14690,14692,14694,14701,14722,14774,14778,14794,14796,14800,14809,14815,14840,14860,14862,14864,14890,14892,14895,14906,14926,14927,14941,14954,14979,14980,15027,15028,15031,15032,15038,15065,15074,15108,15109,15114,15120,15144,15147,15196,15215,15227,15243,15245,15256,15263,15266,15297,15304,15323,15356,15370,15402,15411,15439,15441,15445,15455,15456,15458,15464,15475,15476,15477,15485,15489,15497,15500,15521,15523,15546,15548,15551,15562,15572,15588,15596,15604,15615,15632,15633,15640,15664,15674,15703,15706,15709,15725,15728,15747,15755,15760,15763,15766,15774,15782,15789,15832,15834,15837,15841,15863,15866,15873,15877,15884,15890,15892,15893,15901,15904,15945,15955,15964,15966,15972,15991,16005,16014,16020,16029,16037,16050,16053,16054,16059,16088,16093,16108,16125,16140,16148,16153,16157,16166,16176,16187,16192,16195,16202,16257,16269,16277,16320,16328,16342,16349,16359,16361,16369,16370,16375,16387,16390,16410,16417,16444,16451,16470,16481,16488,16505,16507,16508,16513,16539,16542,16546,16550,16554,16558,16596,16604,16605,16607,16609,16619,16635,16641,16642,16644,16663,16678,16691,16698,16700,16706,16717,16722,16739,16815,16817,16825,16829,16831,16843,16845,16850,16867,16872,16876,16877,16892,16894,16909,16928,16936,16964,16996,17001,17005,17008,17014,17043,17048,17059,17071,17087,17089,17104,17114,17115,17117,17128,17131,17132,17135,17139,17142,17148,17149,17153,17177,17178,17184,17185,17186,17189,17194,17202,17243,17244,17248,17251,17257,17277,17280,17291,17299,17300,17307,17322,17328,17336,17337,17338,17339,17341,17354,17360,17364,17373,17381,17392,17403,17407,17417,17420,17424,17427,17432,17437,17438,17458,17463,17464,17465,17493,17500,17517,17533,17543,17552,17557,17569,17580,17592,17596,17597,17598,17608,17611,17617,17623,17626,17629,17630,17631,17644,17650,17688,17689,17690,17695,17703,17729,17730,17746,17747,17748,17751,17753,17759,17766,17772,17775,17781,17784,17785,17786,17811,17824,17852,17862,17870,17875,17883,17889,17890,17895,17907,17908,17912,17918,17924,17952,17954,17980,17987,17990,18001,18003,18007,18027,18031,18038,18042,18057,18072,18074,18078,18100,18107,18116,18134,18140,18158,18160,18166,18169,18176,18193,18200,18202,18212,18216,18217,18231,18239,18260,18262,18263,18290,18292,18300,18304,18311,18314,18316,18322,18331,18337,18352,18355,18359,18361,18368,18382,18384,18402,18403,18407,18419,18422,18425,18427,18430,18431,18436,18440,18452,18455,18457,18464,18467,18481,18482,18485,18492,18493,18498,18503,18514,18520,18524,18527,18534,18535,18543,18547,18552,18562,18565,18566,18569,18576,18581,18586,18591,18602,18611,18619,18620,18622,18642,18644,18646,18648,18649,18659,18668,18669,18679,18687,18702,18703,18705,18716,18738,18761,18764,18765,18781,18791,18793,18808,18809,18837,18839,18847,18850,18853,18879,18880,18891,18898,18914,18930,18937,18951,18957,18978,18986,18991,18996,18997,19013,19048,19049,19050,19053,19054,19059,19060,19063,19065,19073,19078,19083,19096,19120,19125,19134,19145,19168,19180,19184,19188,19208,19217,19219,19222,19237,19249,19251,19270,19271,19276,19290,19292,19293,19303,19304,19308,19313,19318,19329,19331,19364,19377,19383,19411,19413,19415,19419,19427,19429,19433,19437,19439,19440,19448,19453,19455,19457,19482,19484,19494,19497,19504,19505,19514,19518,19519,19522,19526,19535,19541,19552,19553,19554,19556,19562,19565,19566,19575,19578,19593,19595,19596,19604,19612,19623,19625,19645,19646,19649,19651,19652,19655,19664,19670,19682,19699,19700,19703,19705,19716,19718,19729,19730,19733,19741,19759,19763,19766,19776,19779,19806,19811,19820,19823,19841,19864,19894,19942,19952,19953,19955,19970,19973,19983,19987,19999,20002,20007,20012,20016,20023,20027,20029,20042,20045,20046,20048,20054,20055,20076,20082,20083,20091,20094,20100,20104,20113,20117,20130,20133,20137,20146,20153,20154,20159,20160,20167,20181,20182,20199,20208,20226,20229,20236,20251,20271,20276,20279,20295,20311,20315,20323,20329,20332,20349,20352,20362,20394,20402,20403,20408,20422,20425,20427,20432,20438,20452,20456,20468,20472,20479,20503,20510,20524,20533,20543,20559,20574,20577,20595,20605,20619,20621,20630,20643,20649,20652,20677,20684,20691,20710,20714,20721,20724,20726,20738,20744,20748,20753,20761,20765,20767,20769,20774,20776,20795,20799,20800,20807,20809,20817,20824,20826,20835,20858,20880,20885,20890,20896,20906,20911,20915,20933,20940,20950,20960,20969,20980,20981,20992,20996,21017,21040,21044,21060,21061,21064,21068,21073,21075,21081,21089,21093,21105,21110,21115,21116,21129,21136,21149,21152,21156,21162,21171,21181,21184,21188,21198,21205,21213,21227,21235,21242,21248,21251,21264,21274,21280,21289,21293,21304,21309,21310,21326,21331,21335,21341,21349,21357,21366,21378,21388,21403,21408,21414,21415,21421,21429,21430,21452,21455,21456,21459,21465,21472,21480,21481,21482,21494,21502,21518,21528,21538,21539,21540,21552,21565,21567,21576,21586,21589,21594,21606,21609,21611,21619,21622,21644,21645,21659,21662,21668,21669,21702,21704,21709,21711,21714,21728,21734,21748,21749,21763,21766,21775,21777,21781,21782,21790,21801,21815,21819,21826,21830,21834,21840,21849,21851,21864,21871,21895,21916,21922,21941,21952,21962,21984,21995,22021,22029,22038,22045,22048,22057,22065,22066,22072,22087,22089,22099,22110,22126,22153,22154,22166,22177,22191,22192,22200,22216,22223,22225,22238,22244,22245,22246,22248,22268,22286,22289,22294,22295,22299,22309,22315,22334,22336,22342,22345,22350,22356,22366,22371,22373,22377,22378,22382,22385,22388,22395,22398,22402,22411,22419,22422,22431,22438,22458,22476,22477,22500,22502,22503,22507,22509,22530,22534,22537,22543,22556,22559,22587,22589,22602,22607,22666,22693,22702,22704,22708,22709,22715,22723,22736,22738,22740,22741,22753,22761,22766,22786,22792,22793,22802,22804,22827,22843,22850,22854,22875,22876,22878,22888,22889,22891,22893,22899,22903,22906,22920,22921,22924,22931,22933,22934,22935,22943,22962,22976,22978,22988,22992,23002,23006,23014,23015,23017,23019,23023,23028,23035,23042,23050,23063,23064,23073,23077,23080,23082,23103,23104,23106,23107,23110,23116,23119,23122,23126,23131,23134,23145,23151,23153,23178,23196,23210,23213,23219,23229,23236,23250,23258,23260,23269,23271,23273,23287,23295,23299,23312,23317,23319,23332,23338,23343,23353,23354,23364,23365,23373,23380,23382,23396,23397,23409,23417,23424,23426,23428,23430,23434,23441,23445,23457,23466,23469,23474,23477,23489,23495,23505,23512,23513,23518,23520,23524,23541,23543,23544,23567,23569,23575,23590,23592,23594,23607,23613,23646,23648,23649,23651,23657,23659,23665,23666,23668,23672,23676,23677,23685,23693,23695,23708,23711,23719,23722,23729,23732,23740,23749,23761,23768,23776,23782,23792,23793,23806,23811,23815,23816,23827,23828,23833,23850,23855,23859,23861,23869,23872,23874,23899,23906,23914,23935,23944,23948,23952,23965,23967,23973,23984,23987,23995,23998,24001,24059,24068,24088,24105,24108,24111,24135,24158,24166,24171,24172,24176,24189,24195,24198,24202,24207,24212,24224,24228,24229,24233,24258,24260,24271,24273,24282,24289,24299,24309,24315,24330,24332,24336,24365,24368,24373,24375,24380,24391,24427,24437,24438,24439,24442,24443,24445,24447,24470,24475,24477,24498,24511,24518,24527,24535,24536,24543,24565,24607,24608,24612,24617,24625,24630,24636,24642,24658,24659,24665,24672,24708,24710,24713,24718,24722,24725,24754,24763,24765,24780,24784,24790,24793,24806,24814,24819,24823,24838,24843,24851,24853,24857,24868,24881,24905,24922,24924,24927,24942,24944,24954,24958,24960,24964,24974,24995,24998,25014,25018,25022,25039,25048,25064,25082,25090,25093,25104,25116,25119,25131,25134,25141,25143,25155,25170,25183,25193,25195,25199,25200,25205,25207,25252,25260,25268,25281,25286,25312,25314,25316,25342,25345,25349,25353,25356,25365,25366,25394,25397,25400,25415,25417,25421,25435,25449,25470,25471,25474,25486,25488,25490,25502,25506,25511,25512,25528,25541,25548,25553,25557,25595,25599,25609,25615,25616,25621,25623,25635,25648,25650,25668,25693,25703,25706,25707,25717,25725,25736,25740,25745,25778,25797,25833,25834,25847,25860,25866,25870,25885,25886,25936,25944,25958,25969,26002,26017,26020,26028,26043,26048,26091,26101,26103,26130,26132,26154,26159,26165,26166,26178,26179,26205,26215,26218,26238,26246,26249,26255,26257,26264,26281,26282,26293,26305,26317,26324,26328,26338,26360,26363,26369,26375,26389,26396,26403,26405,26412,26431,26458,26464,26479,26508,26513,26541,26550,26564,26570,26574,26589,26590,26591,26599,26605,26636,26637,26646,26654,26672,26726,26742,26744,26776,26779,26792,26824,26835,26842,26843,26846,26857,26860,26864,26874,26885,26897,26905,26907,26916,26918,26933,26939,26944,26945,26947,26959,26967,27000,27008,27015,27020,27024,27030,27055,27059,27076,27083,27084,27091,27093,27101,27105,27106,27130,27131,27142,27143,27144,27149,27164,27174,27178,27179,27197,27201,27203,27248,27265,27293,27294,27295,27305,27343,27356,27362,27363,27409,27420,27438,27453,27457,27458,27477,27482,27497,27518,27526,27552,27566,27572,27574,27582,27584,27611,27630,27632,27646,27707,27717,27720,27724,27726,27737,27786,27805,27809,27820,27822,27832,27833,27846,27855,27878,27911,27918,27921,27923,27924,27926,27934,27938,27949,27951,27952,27978,27991,27999,28005,28033,28063,28078,28107,28114,28128,28208,28275,28303,28316,28318,28349,28372,28419,28436,28480,28559,28600,28614,28615,28621,28643,28714,28763,28764,28771,28773,28845,28872,28889,28901,28910,28922,28943,28950,28992,29012,29023,29054,29088,29123,29172,29210,29223,29235,29244,29286,29290,29358,29372,29378,29380,29438,29459,29464,29466,29469,29486,29499,29509,29510,29511,29512,29540,29584,29611,29625,29626,29641,29653,29777,29814,29832,29834,29846,29849,29863,29864,29909,30111,30280,30393,30394,30433,30434,30484,30511,30621,30676,30805,30815,30932,30940,31437,31560,31640,31697,31890,31908,31937,32136,32304,32520,32579,32592,32796,32895,33270,33547,33932,34052,34160,34415,34428,34449,34525,34560,34565,34795,34850,34876,34923,34949,34978,35000,35195,35324,35373,35436,35474,35503,35521,35609,35626,35628,35632,35638,35660,35661,35667,35713,35719,35727,35730,35741,35744,35759,35777,35783,35784,35803,35811,35812,35814,35850,35861,35877,35882,35909,35921,35926,35953,35989,36017,36041,36108,36158,36160,36174,36192,36204,36222,36235,36238,36310,36410,36411,36439,36450,36479,36515,36633,36736,36780,36798,36804,36821,36850,36889,36893,36949,36958,37333,37497,37535,37536,37537,37549,37550,37551,37649,37690,37901,37942,38029,38263,38314,38357,38387,38436,38631,38646,38668,38748,38800,38852,38884,38885,38887,38898,38916,38917,38932,38960,38985,39062,39107,39114,39178,39242,39271,39283,39318,39333,39342,39369,39432,39464,39465,39483,39527,39588,39600,39612,39653,39698,39710,39729,39846,39858,39866,39886,39941,39998,40015,40048,40050,40064,40110,40111,40116,40187,40212,40214,40218,40224,40225,40237,40239,40259,40332,40355,40392,40414,40490,40515,40588,40651,40665,40672,40684,40706,40786,40875,40877,40905,40983,41058,41059,41069,41146,41156,41239,41292,41296,41337,41363,41376,41532,41794,41909,42030,42066,42181,42202,42237,42407,42445,42502,42503,42844,43178,43305,43637,43710,43711,43905,44255,44277,44288,44433,45029,45065,45118,45148,45268,45269,45270)
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 | 2739 | 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 | 1.25 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.04 ms |
init | 0.47 ms |
System lock | 0.02 ms |
optimizing | 0.20 ms |
statistics | 4.06 ms |
preparing | 2.14 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 40.48 ms |
end | 0.03 ms |
query end | 0.04 ms |
closing tables | 0.02 ms |
freeing items | 0.16 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 |