Tiempo de la consulta: 53.72 ms Después de la última consulta: 2.67 ms Consulta a la memoria: 7.416 MB memoria antes de la consulta: 4.537 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-04 05:27:38')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 05:27:38')
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(21,49,136,140,141,142,143,144,145,146,178,179,271,489,686,723,773,907,964,986,1044,1047,1066,1080,1130,1143,1158,1207,1252,1253,1256,1302,1339,1368,1401,1591,1660,1664,1694,1810,1852,1902,2013,2215,2216,2383,2418,2477,2601,2742,2747,3013,3123,3126,3194,3223,3301,3335,3518,3607,3669,3687,3922,4239,4378,4383,4705,4747,4765,4989,5078,5496,5647,5659,5680,5696,5757,5796,5814,5830,5860,5969,6073,6162,6173,6316,6367,6452,6470,6538,6573,6828,6965,6966,6968,6989,7016,7043,7075,7161,7190,7196,7291,7295,7366,7380,7387,7390,7401,7403,7405,7414,7427,7463,7488,7508,7546,7551,7730,7751,7831,7867,7950,7957,7983,7989,8007,8022,8056,8108,8170,8193,8327,8356,8460,8551,8554,8670,8854,8950,9055,9091,9203,9239,9288,9338,9429,9477,9664,9721,9756,9765,9791,9880,10028,10064,10120,10156,10197,10198,10355,10356,10415,10427,10622,10777,10803,10835,10916,10928,11091,11134,11192,11249,11260,11310,11377,11430,11498,11506,11557,11588,11612,11696,11808,11816,11841,11863,11933,11965,11989,12024,12042,12068,12112,12137,12147,12156,12160,12174,12204,12331,12362,12374,12401,12427,12430,12473,12492,12519,12528,12535,12579,12609,12625,12650,12681,12709,12745,12806,12809,12842,12932,12940,12942,12978,12990,13004,13034,13036,13048,13076,13123,13213,13216,13221,13276,13309,13310,13345,13362,13445,13456,13461,13476,13492,13500,13580,13637,13646,13666,13696,13704,13716,13729,13778,13798,13818,13819,13837,13839,13852,13880,13893,13902,13922,13937,13976,14011,14035,14103,14105,14112,14116,14124,14160,14166,14217,14257,14258,14289,14407,14422,14426,14446,14471,14545,14578,14601,14676,14707,14739,14759,14776,14805,14854,14867,14885,14911,14939,14986,14988,14992,15058,15086,15092,15104,15173,15205,15256,15286,15327,15329,15332,15408,15568,15569,15572,15586,15593,15595,15629,15672,15732,15760,15898,15899,15904,15936,16030,16054,16110,16112,16133,16148,16180,16209,16278,16360,16362,16381,16387,16390,16417,16420,16444,16467,16523,16542,16546,16596,16604,16622,16657,16675,16681,16698,16739,16748,16831,16850,16865,16876,16932,16952,16966,17030,17040,17057,17059,17096,17120,17142,17144,17202,17209,17239,17248,17258,17263,17295,17332,17336,17341,17356,17410,17414,17423,17427,17449,17460,17463,17559,17579,17599,17604,17632,17688,17695,17711,17712,17734,17740,17784,17786,17814,17870,17883,17894,17933,17941,17954,17987,17997,18006,18024,18033,18074,18078,18089,18140,18164,18196,18201,18246,18292,18301,18320,18333,18363,18374,18381,18384,18455,18463,18480,18485,18520,18524,18525,18534,18535,18552,18622,18623,18631,18658,18668,18693,18702,18749,18750,18761,18772,18808,18809,18810,18811,18817,18830,18838,18844,18846,18849,18872,18873,18879,18893,18894,18898,18920,18959,18979,18984,18996,19003,19044,19054,19099,19129,19134,19145,19157,19159,19203,19230,19237,19238,19280,19296,19308,19311,19344,19356,19381,19391,19424,19439,19460,19467,19497,19514,19521,19526,19536,19572,19622,19624,19649,19675,19729,19733,19779,19839,19848,19851,19915,19982,19984,19993,20042,20046,20082,20104,20129,20148,20159,20163,20182,20189,20199,20254,20276,20286,20311,20314,20329,20345,20358,20368,20382,20417,20438,20456,20473,20474,20500,20515,20576,20582,20652,20676,20677,20708,20752,20762,20767,20774,20778,20820,20825,20835,20862,20869,20875,20885,20911,20913,20915,20940,20948,20950,20960,20969,20981,20992,21060,21075,21085,21091,21184,21215,21247,21293,21304,21309,21321,21326,21337,21350,21364,21374,21388,21392,21398,21458,21489,21501,21521,21530,21572,21577,21611,21644,21686,21692,21725,21775,21824,21848,21862,21863,21869,21895,21922,21923,21928,21940,21941,21961,21983,22021,22024,22039,22072,22079,22104,22107,22130,22133,22145,22154,22155,22192,22200,22207,22237,22255,22326,22345,22349,22363,22371,22382,22395,22407,22436,22437,22443,22462,22488,22556,22598,22607,22624,22628,22659,22693,22698,22709,22740,22754,22766,22793,22798,22804,22827,22840,22893,22934,22989,23030,23038,23050,23077,23080,23087,23126,23178,23250,23274,23279,23289,23290,23332,23367,23368,23390,23397,23407,23409,23444,23481,23505,23513,23527,23531,23535,23548,23555,23597,23635,23651,23652,23665,23677,23693,23709,23711,23716,23738,23739,23773,23776,23787,23828,23833,23869,23920,23937,23965,23969,24001,24003,24016,24033,24066,24090,24115,24122,24137,24158,24164,24170,24189,24270,24284,24300,24309,24336,24358,24427,24441,24461,24481,24516,24520,24535,24625,24710,24720,24754,24755,24758,24775,24795,24816,24851,24865,24976,24988,24995,25002,25018,25026,25033,25037,25082,25090,25109,25132,25143,25164,25192,25200,25222,25229,25316,25395,25398,25400,25408,25409,25430,25432,25454,25455,25477,25484,25511,25517,25519,25535,25575,25577,25594,25595,25601,25607,25623,25626,25629,25664,25672,25707,25720,25728,25734,25736,25740,25745,25794,25796,25801,25866,25875,25878,25888,25892,25893,25906,25930,25936,25944,25952,25975,25976,25980,25997,25999,26001,26004,26005,26006,26007,26020,26021,26059,26083,26090,26091,26096,26098,26106,26123,26128,26129,26130,26132,26151,26165,26181,26195,26197,26200,26210,26237,26243,26264,26267,26281,26291,26304,26324,26326,26329,26330,26338,26384,26396,26421,26450,26458,26478,26481,26487,26488,26503,26521,26547,26561,26591,26596,26598,26599,26602,26628,26637,26645,26649,26660,26672,26676,26678,26716,26739,26774,26775,26776,26781,26783,26792,26795,26799,26805,26824,26851,26855,26856,26862,26867,26886,26888,26891,26902,26903,26907,26914,26917,26925,26941,26970,26984,26992,27039,27052,27053,27077,27098,27099,27105,27106,27111,27114,27140,27142,27144,27145,27159,27163,27164,27165,27166,27168,27178,27179,27182,27191,27193,27201,27203,27205,27208,27226,27227,27233,27238,27241,27253,27254,27255,27257,27265,27278,27285,27289,27297,27299,27305,27309,27316,27329,27334,27336,27343,27346,27358,27359,27370,27384,27387,27388,27409,27413,27414,27428,27429,27430,27447,27451,27456,27457,27462,27467,27469,27482,27484,27488,27491,27500,27503,27508,27509,27511,27519,27537,27553,27569,27574,27598,27599,27603,27631,27634,27652,27663,27667,27674,27682,27700,27720,27729,27751,27756,27760,27784,27787,27792,27814,27815,27817,27831,27840,27844,27855,27862,27865,27869,27888,27896,27906,27934,27941,27951,27952,27960,27980,27989,27991,27993,28001,28007,28014,28015,28025,28028,28029,28038,28040,28044,28050,28056,28063,28068,28077,28084,28093,28096,28101,28113,28121,28122,28124,28125,28132,28134,28138,28141,28149,28150,28151,28156,28169,28172,28182,28199,28201,28208,28210,28216,28224,28235,28245,28253,28268,28278,28292,28295,28307,28316,28317,28349,28357,28369,28370,28372,28377,28389,28393,28394,28405,28417,28428,28448,28449,28478,28480,28488,28489,28490,28502,28503,28523,28564,28580,28584,28590,28602,28613,28648,28649,28667,28696,28697,28699,28705,28742,28752,28762,28770,28775,28782,28783,28794,28796,28798,28806,28811,28813,28816,28832,28861,28862,28864,28881,28885,28891,28901,28927,28957,28968,28976,28981,28988,29007,29016,29030,29042,29051,29058,29059,29060,29062,29072,29085,29092,29096,29102,29103,29106,29110,29114,29116,29128,29138,29146,29148,29149,29161,29162,29168,29175,29176,29181,29184,29185,29188,29191,29192,29198,29199,29203,29204,29206,29210,29211,29214,29217,29219,29220,29228,29230,29240,29246,29255,29259,29269,29270,29278,29282,29283,29286,29287,29296,29305,29309,29316,29317,29339,29353,29368,29390,29395,29401,29408,29409,29421,29428,29430,29432,29453,29455,29458,29469,29471,29481,29484,29493,29496,29510,29511,29512,29514,29521,29522,29541,29546,29555,29561,29562,29564,29565,29566,29578,29585,29599,29600,29614,29626,29627,29628,29638,29641,29663,29664,29669,29670,29674,29675,29684,29688,29690,29694,29700,29713,29737,29744,29762,29763,29767,29793,29794,29796,29797,29808,29821,29850,29860,29867,29876,29880,29881,29891,29902,29916,29921,29929,29932,29934,29947,29954,29959,29964,29970,29979,29981,29983,29989,30003,30004,30011,30012,30021,30030,30041,30048,30053,30057,30060,30066,30067,30094,30096,30122,30124,30128,30134,30145,30156,30167,30174,30196,30200,30227,30257,30264,30270,30277,30300,30319,30321,30326,30328,30330,30338,30341,30342,30343,30346,30362,30369,30380,30383,30393,30394,30399,30425,30435,30440,30459,30506,30511,30513,30518,30526,30542,30543,30544,30551,30557,30558,30559,30561,30563,30565,30566,30567,30593,30594,30603,30607,30608,30610,30618,30621,30629,30630,30635,30639,30648,30649,30652,30653,30661,30671,30672,30676,30679,30683,30684,30686,30694,30695,30704,30705,30711,30712,30718,30719,30720,30722,30749,30762,30763,30767,30771,30774,30777,30785,30800,30805,30814,30815,30832,30851,30867,30880,30882,30883,30890,30903,30904,30910,30911,30912,30919,30920,30931,30932,30934,30942,30943,30946,30951,30960,30975,30976,30992,31003,31004,31006,31007,31013,31022,31025,31027,31033,31040,31041,31042,31053,31058,31063,31065,31067,31074,31112,31119,31134,31138,31162,31190,31195,31196,31202,31203,31209,31213,31215,31221,31282,31283,31284,31286,31289,31292,31293,31338,31339,31381,31392,31394,31399,31408,31410,31411,31412,31421,31424,31437,31452,31471,31476,31489,31518,31554,31559,31568,31571,31576,31583,31585,31645,31673,31680,31686,31693,31694,31720,31737,31768,31774,31786,31794,31800,31810,31822,31839,31849,31856,31864,31878,31880,31881,31893,31894,31898,31936,31947,31965,31966,31980,31982,31985,31986,31997,31998,32004,32005,32013,32016,32022,32036,32037,32045,32054,32069,32071,32077,32095,32100,32124,32183,32191,32196,32208,32210,32215,32221,32224,32227,32229,32237,32249,32304,32325,32328,32329,32331,32334,32335,32387,32413,32432,32440,32441,32444,32446,32457,32493,32510,32513,32518,32532,32549,32565,32568,32569,32574,32579,32585,32589,32653,32658,32677,32693,32700,32701,32717,32746,32771,32778,32783,32784,32796,32812,32814,32823,32831,32856,32858,32859,32869,32883,32892,32895,32914,32946,32947,32948,32949,32950,32951,32952,32953,32954,32955,33004,33007,33014,33020,33034,33042,33047,33071,33092,33103,33106,33123,33135,33166,33178,33179,33180,33181,33236,33237,33254,33260,33270,33271,33275,33283,33299,33347,33403,33411,33433,33434,33445,33459,33491,33499,33500,33506,33511,33519,33523,33524,33530,33557,33558,33585,33610,33612,33613,33617,33667,33686,33703,33787,33929,33937,33944,33994,34004,34009,34045,34052,34077,34085,34108,34112,34116,34120,34146,34157,34201,34236,34241,34242,34247,34281,34282,34312,34319,34323,34347,34364,34393,34394,34411,34415,34418,34422,34436,34449,34450,34458,34462,34484,34491,34492,34508,34511,34522,34525,34527,34537,34544,34545,34555,34560,34564,34567,34575,34577,34583,34597,34598,34599,34604,34608,34630,34640,34658,34662,34666,34670,34675,34679,34683,34686,34688,34700,34703,34706,34713,34726,34729,34730,34733,34740,34760,34761,34767,34787,34798,34820,34829,34837,34839,34840,34842,34850,34854,34857,34859,34860,34876,34879,34886,34896,34900,34901,34904,34909,34910,34917,34923,34928,34930,34933,34936,34937,34939,34941,34949,34952,34954,34955,34958,34965,34966,34972,34973,34974,34978,34979,34983,34986,34998,35005,35012,35022,35024,35030,35033,35038,35042,35043,35048,35050,35054,35061,35065,35078,35093,35105,35112,35118,35119,35122,35124,35128,35130,35170,35179,35209,35210,35218,35228,35244,35247,35254,35256,35308,35309,35324,35329,35331,35343,35373,35390,35394,35402,35406,35407,35415,35436,35448,35472,35475,35481,35498,35503,35505,35521,35529,35544,35584,35587,35606,35607,35609,35619,35626,35628,35631,35632,35636,35638,35647,35659,35662,35666,35667,35690,35692,35712,35717,35719,35727,35730,35739,35775,35783,35784,35786,35788,35795,35800,35803,35812,35815,35820,35830,35840,35853,35863,35866,35867,35873,35875,35877,35889,35892,35903,35904,35905,35906,35930,35945,35953,35960,35984,35992,35993,36009,36019,36020,36023,36025,36031,36036,36056,36064,36065,36073,36076,36082,36083,36090,36097,36099,36101,36106,36108,36112,36119,36123,36131,36138,36147,36157,36158,36161,36164,36171,36174,36184,36192,36204,36205,36208,36217,36221,36222,36223,36253,36255,36304,36310,36321,36328,36329,36342,36345,36362,36410,36411,36418,36433,36435,36449,36450,36460,36470,36479,36481,36515,36520,36526,36535,36547,36557,36573,36577,36593,36609,36622,36625,36634,36646,36652,36685,36689,36690,36699,36716,36717,36728,36732,36734,36735,36736,36748,36749,36755,36756,36783,36804,36805,36809,36821,36832,36839,36850,36853,36858,36864,36868,36869,36870,36871,36873,36875,36882,36884,36886,36892,36899,36908,36920,36922,36937,36949,36953,36958,36999,37006,37019,37021,37048,37049,37050,37051,37055,37077,37085,37096,37106,37110,37118,37146,37148,37149,37165,37172,37178,37179,37249,37256,37261,37273,37325,37327,37358,37374,37385,37405,37407,37414,37427,37429,37430,37434,37445,37447,37459,37479,37492,37498,37500,37511,37513,37522,37542,37546,37552,37553,37559,37564,37575,37581,37620,37625,37638,37649,37660,37685,37690,37694,37756,37764,37773,37776,37781,37784,37795,37810,37811,37812,37815,37818,37846,37866,37867,37888,37895,37901,37905,37915,37920,37934,37937,37938,37943,37944,37945,37956,37977,37983,37985,37997,38003,38008,38029,38043,38076,38077,38081,38084,38086,38095,38102,38115,38124,38137,38141,38157,38174,38176,38187,38205,38207,38208,38209,38210,38217,38227,38229,38239,38255,38259,38260,38263,38264,38268,38269,38270,38271,38272,38281,38282,38290,38294,38295,38296,38297,38298,38299,38314,38342,38349,38351,38357,38368,38369,38378,38387,38389,38400,38412,38414,38424,38425,38478,38491,38504,38514,38531,38537,38540,38559,38576,38587,38604,38633,38639,38649,38651,38655,38656,38667,38668,38672,38674,38684,38686,38694,38703,38722,38724,38729,38748,38759,38764,38776,38781,38789,38794,38808,38813,38822,38827,38830,38835,38842,38859,38863,38876,38884,38892,38894,38898,38946,38947,38951,38969,38972,38979,39043,39045,39065,39079,39101,39105,39107,39147,39173,39182,39229,39262,39280,39288,39289,39294,39311,39312,39314,39327,39340,39352,39353,39355,39373,39386,39401,39402,39422,39428,39432,39435,39441,39464,39477,39487,39492,39506,39562,39585,39588,39589,39591,39594,39607,39612,39619,39629,39648,39653,39655,39664,39708,39725,39729,39733,39741,39768,39777,39797,39813,39814,39824,39852,39866,39868,39877,39885,39886,39899,39939,39941,39945,39946,39954,39961,39983,39984,39986,40006,40032,40057,40058,40066,40070,40075,40103,40106,40111,40121,40122,40123,40124,40125,40128,40130,40140,40151,40174,40175,40180,40186,40187,40200,40201,40204,40206,40212,40216,40218,40220,40225,40230,40234,40235,40237,40239,40250,40255,40256,40257,40262,40268,40269,40280,40283,40307,40321,40331,40336,40340,40351,40354,40359,40369,40376,40380,40383,40391,40392,40395,40433,40450,40469,40471,40472,40476,40490,40501,40506,40520,40529,40551,40565,40609,40610,40611,40612,40628,40631,40636,40652,40662,40665,40666,40669,40672,40677,40678,40687,40706,40711,40719,40742,40747,40749,40764,40766,40840,40843,40844,40845,40846,40854,40876,40877,40880,40890,40893,40898,41002,41024,41029,41044,41053,41069,41082,41107,41127,41132,41138,41145,41146,41154,41156,41159,41168,41195,41221,41234,41247,41248,41252,41285,41291,41296,41315,41346,41389,41414,41425,41428,41439,41488,41508,41511,41527,41533,41553,41554,41558,41574,41598,41603,41609,41639,41646,41647,41666,41667,41712,41715,41743,41748,41750,41754,41777,41780,41787,41809,41829,41837,41850,41869,41873,41905,41909,41916,41921,41924,41931,41938,41982,41996,42002,42009,42011,42016,42025,42028,42032,42041,42048,42063,42076,42082,42151,42153,42157,42191,42202,42203,42239,42254,42298,42321,42332,42333,42352,42400,42405,42439,42445,42449,42451,42472,42476,42528,42539,42545,42552,42556,42558,42566,42586,42587,42598,42607,42616,42620,42633,42645,42646,42648,42649,42663,42667,42668,42685,42688,42699,42706,42707,42733,42738,42751,42755,42779,42786,42791,42804,42844,42856,42862,42895,42904,42905,42913,42925,42927,42937,42962,42966,42985,43007,43030,43066,43089,43122,43128,43138,43147,43149,43151,43161,43162,43166,43170,43173,43178,43182,43184,43189,43261,43305,43314,43334,43338,43346,43362,43364,43385,43400,43402,43403,43410,43439,43444,43445,43499,43533,43538,43547,43556,43579,43580,43582,43603,43622,43644,43652,43658,43672,43710,43711,43720,43748,43760,43762,43764,43774,43788,43797,43798,43818,43824,43845,43869,43891,43892,43894,43905,43913,43922,43926,43928,43936,43939,43965,43984,43997,44010,44019,44024,44025,44028,44036,44053,44055,44074,44078,44084,44086,44087,44097,44102,44126,44153,44154,44155,44169,44178,44190,44199,44237,44238,44247,44248,44255,44256,44277,44279,44280,44281,44284,44285,44286,44288,44291,44296,44301,44311,44315,44316,44321,44322,44332,44347,44357,44360,44376,44398,44401,44407,44413,44419,44433,44478,44531,44555,44561,44567,44592,44604,44626,44631,44665,44670,44681,44690,44710,44742,44758,44771,44803,44805,44806,44812,44822,44831,44861,44865,44872,44882,44891,44892,44930,44939,44946,44962,44978,44979,44985,44990,45004,45005,45007,45017,45037,45048,45062,45077,45098,45102,45110,45116,45117,45118,45130,45133,45142,45146,45176,45184,45188,45194,45197,45207,45215,45218,45221,45261,45262,45268,45269,45270,45277,45278,45284,45299,45314,45315)
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 | 2834 | 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.36 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.53 ms |
System lock | 0.02 ms |
optimizing | 0.17 ms |
statistics | 4.37 ms |
preparing | 2.21 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 40.91 ms |
end | 0.03 ms |
query end | 0.10 ms |
closing tables | 0.03 ms |
freeing items | 0.18 ms |
cleaning up | 0.06 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 |