Tiempo de la consulta: 9.91 ms Después de la última consulta: 2.57 ms Consulta a la memoria: 0.057 MB memoria antes de la consulta: 4.383 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 01:46:19')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-04 01:46: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(206,3504,3937,4215,4226,4381,4494,5087,7460,8639,9114,9893,10207,11979,14206,15954,20841,24501,25415,25416,25432,25443,25549,25580,25599,25603,25619,25623,25624,25626,25629,25630,25634,25707,25751,25773,25803,25814,25831,25842,25843,25851,25860,25872,25892,25919,25924,25927,25930,25931,25935,25938,25939,25940,25944,25954,25957,25985,25986,25989,25990,25993,26009,26018,26021,26031,26038,26041,26052,26065,26070,26090,26097,26107,26119,26121,26122,26123,26124,26125,26129,26131,26132,26136,26152,26161,26163,26165,26169,26170,26178,26180,26206,26210,26211,26212,26219,26220,26222,26223,26224,26233,26237,26255,26259,26290,26291,26297,26311,26312,26315,26316,26317,26320,26322,26323,26324,26325,26338,26358,26360,26377,26389,26397,26398,26399,26400,26403,26426,26430,26441,26454,26457,26458,26463,26474,26475,26477,26485,26493,26494,26495,26496,26501,26503,26513,26527,26539,26540,26542,26545,26563,26569,26574,26580,26583,26585,26589,26591,26600,26604,26610,26615,26616,26630,26631,26661,26665,26675,26682,26686,26705,26711,26712,26717,26726,26733,26737,26764,26765,26772,26773,26776,26794,26798,26803,26805,26806,26812,26820,26821,26824,26825,26832,26833,26834,26843,26848,26850,26852,26853,26854,26858,26863,26865,26867,26872,26883,26888,26892,26899,26901,26907,26912,26914,26917,26920,26923,26930,26931,26932,26941,26946,26952,26968,26987,26988,26993,26994,26995,27002,27004,27026,27032,27033,27051,27061,27069,27072,27090,27092,27113,27116,27120,27121,27127,27131,27135,27136,27146,27147,27149,27150,27155,27162,27169,27170,27175,27184,27195,27202,27210,27218,27221,27232,27239,27248,27264,27273,27277,27284,27297,27304,27306,27318,27332,27333,27335,27341,27343,27346,27348,27355,27356,27362,27363,27366,27372,27377,27380,27409,27410,27416,27418,27424,27431,27443,27452,27455,27471,27472,27481,27489,27490,27504,27507,27513,27520,27528,27529,27539,27546,27561,27575,27581,27590,27594,27596,27610,27620,27645,27646,27659,27662,27669,27683,27693,27719,27723,27728,27736,27738,27740,27742,27755,27757,27768,27781,27795,27796,27797,27812,27813,27816,27824,27825,27830,27832,27845,27858,27869,27876,27885,27897,27914,27915,27917,27919,27925,27942,27945,27959,27962,27977,27979,27986,27987,27988,27991,27993,27996,28006,28008,28009,28011,28014,28041,28055,28064,28065,28082,28083,28084,28122,28124,28132,28136,28140,28159,28172,28176,28179,28196,28197,28205,28209,28212,28261,28266,28282,28287,28289,28296,28297,28302,28307,28316,28319,28326,28341,28378,28380,28381,28385,28387,28389,28395,28400,28406,28419,28421,28426,28427,28433,28434,28443,28446,28449,28460,28474,28475,28482,28490,28494,28497,28500,28501,28506,28508,28512,28513,28516,28518,28519,28522,28530,28571,28584,28589,28605,28606,28612,28641,28646,28659,28670,28671,28696,28720,28723,28729,28732,28740,28753,28758,28761,28769,28772,28788,28790,28797,28800,28804,28820,28841,28842,28856,28862,28871,28883,28906,28913,28915,28942,28948,28953,28958,28969,28975,28976,28983,28995,28997,29008,29041,29043,29060,29069,29076,29080,29082,29102,29113,29119,29122,29129,29133,29135,29156,29160,29161,29175,29176,29182,29184,29185,29196,29199,29202,29211,29224,29227,29249,29271,29309,29310,29315,29333,29351,29421,29428,29431,29432,29436,29457,29493,29497,29513,29514,29524,29525,29526,29538,29549,29573,29579,29609,29620,29632,29633,29636,29637,29657,29665,29680,29690,29691,29693,29702,29717,29728,29748,29749,29752,29761,29762,29766,29782,29784,29786,29789,29795,29796,29797,29798,29816,29821,29823,29825,29828,29851,29854,29858,29861,29869,29877,29893,29927,29944,29968,29975,29982,30029,30038,30094,30112,30115,30118,30128,30139,30140,30142,30144,30146,30147,30152,30159,30163,30181,30226,30233,30240,30245,30255,30256,30282,30306,30330,30338,30347,30348,30350,30351,30369,30375,30390,30397,30412,30413,30416,30425,30474,30476,30482,30483,30485,30493,30496,30497,30498,30502,30519,30545,30551,30568,30569,30585,30586,30603,30607,30610,30623,30672,30675,30702,30707,30712,30761,30779,30794,30826,30855,30860,30861,30863,30873,30875,30887,30889,30908,30944,30964,30966,31022,31041,31042,31054,31058,31062,31065,31067,31090,31100,31122,31169,31186,31187,31188,31189,31192,31206,31216,31218,31222,31230,31234,31236,31237,31267,31275,31284,31289,31305,31306,31310,31312,31337,31341,31372,31381,31392,31413,31414,31422,31425,31428,31469,31474,31494,31500,31520,31539,31542,31543,31580,31622,31661,31682,31685,31687,31699,31702,31705,31714,31718,31732,31778,31785,31791,31823,31829,31830,31831,31834,31835,31836,31838,31842,31849,31865,31872,31879,31898,31930,31939,31940,31954,31960,31961,31964,31980,31994,31995,32005,32012,32013,32016,32018,32020,32022,32024,32033,32036,32037,32046,32070,32095,32096,32143,32150,32161,32166,32173,32174,32193,32206,32223,32246,32248,32261,32271,32278,32279,32294,32300,32319,32323,32334,32335,32433,32440,32441,32446,32448,32473,32509,32511,32512,32528,32554,32562,32570,32646,32651,32713,32754,32786,32794,32797,32800,32815,32830,32831,32833,32834,32844,32854,32857,32858,32860,32863,32907,32911,32913,32914,32934,32940,33011,33032,33041,33054,33055,33068,33071,33074,33093,33100,33101,33102,33117,33119,33141,33144,33153,33178,33179,33180,33181,33227,33228,33229,33235,33260,33267,33270,33271,33287,33300,33341,33379,33402,33409,33445,33456,33457,33461,33478,33480,33500,33505,33507,33509,33522,33524,33525,33540,33569,33599,33613,33622,33646,33650,33651,33658,33668,33673,33686,33689,33704,33713,33717,33734,33748,33753,33760,33784,33785,33832,33851,33860,33865,33867,33869,33872,33903,33919,33944,33945,33982,33990,33991,33994,33995,34005,34010,34035,34041,34045,34049,34050,34056,34065,34070,34073,34075,34076,34077,34083,34084,34085,34088,34090,34091,34094,34105,34106,34108,34125,34126,34127,34145,34156,34157,34158,34170,34172,34182,34185,34186,34189,34191,34197,34200,34207,34221,34226,34227,34233,34238,34252,34260,34267,34287,34290,34291,34300,34301,34303,34305,34308,34315,34316,34318,34322,34323,34331,34339,34342,34364,34365,34366,34367,34371,34381,34384,34385,34397,34405,34425,34430,34442,34452,34485,34487,34493,34497,34498,34503,34505,34506,34516,34522,34523,34553,34554,34559,34564,34565,34568,34570,34575,34577,34582,34583,34587,34590,34606,34607,34609,34613,34618,34622,34623,34626,34630,34632,34634,34650,34655,34662,34664,34669,34670,34677,34679,34680,34683,34685,34687,34688,34689,34691,34697,34702,34704,34708,34709,34710,34715,34720,34722,34727,34729,34731,34734,34735,34738,34739,34743,34746,34761,34774,34780,34806,34822,34823,34831,34832,34835,34844,34848,34853,34854,34855,34859,34860,34863,34867,34894,34897,34899,34900,34904,34907,34915,34916,34919,34922,34929,34935,34943,34945,34950,34951,34953,34957,34960,34961,34962,34975,34976,34981,34983,34984,34989,34990,34994,35002,35006,35008,35010,35011,35012,35016,35017,35019,35023,35026,35031,35032,35033,35034,35035,35036,35037,35040,35044,35045,35051,35057,35058,35064,35068,35069,35071,35072,35073,35088,35094,35097,35104,35108,35111,35117,35120,35122,35123,35130,35131,35132,35133,35134,35140,35142,35143,35144,35148,35158,35159,35161,35162,35163,35180,35183,35184,35188,35193,35204,35205,35217,35218,35221,35222,35223,35224,35227,35228,35237,35239,35244,35246,35251,35254,35262,35269,35271,35272,35274,35275,35279,35280,35281,35283,35285,35288,35289,35293,35298,35299,35301,35302,35303,35304,35314,35315,35317,35318,35324,35327,35328,35334,35335,35336,35337,35338,35341,35350,35351,35354,35356,35364,35367,35370,35371,35386,35390,35392,35397,35400,35401,35402,35406,35407,35408,35421,35422,35427,35428,35429,35430,35432,35437,35441,35443,35449,35451,35454,35460,35467,35471,35483,35489,35492,35493,35496,35498,35499,35516,35517,35521,35524,35525,35529,35531,35532,35534,35535,35536,35537,35538,35542,35553,35557,35569,35572,35573,35587,35589,35606,35607,35610,35620,35622,35623,35627,35629,35631,35634,35635,35645,35655,35661,35673,35679,35681,35682,35688,35699,35701,35703,35706,35707,35709,35711,35714,35716,35721,35725,35734,35745,35765,35767,35770,35779,35781,35785,35786,35793,35802,35804,35805,35807,35813,35817,35820,35825,35827,35835,35847,35854,35856,35863,35868,35872,35873,35874,35875,35876,35879,35883,35889,35896,35898,35902,35906,35907,35916,35917,35918,35929,35931,35932,35933,35934,35949,35959,35960,35962,35964,35967,35970,35973,35975,35977,35978,35982,35990,35993,35994,35995,35996,36001,36002,36005,36009,36011,36020,36031,36032,36033,36037,36044,36045,36048,36054,36055,36057,36058,36059,36064,36065,36072,36074,36075,36076,36087,36088,36092,36094,36096,36100,36104,36105,36107,36109,36110,36111,36112,36117,36118,36132,36134,36136,36140,36141,36144,36146,36156,36165,36167,36170,36175,36178,36180,36182,36206,36213,36229,36230,36232,36233,36234,36239,36240,36242,36247,36250,36259,36282,36284,36303,36306,36311,36312,36314,36329,36350,36354,36370,36384,36391,36393,36412,36415,36417,36433,36436,36437,36442,36448,36449,36452,36453,36467,36468,36469,36488,36491,36494,36495,36500,36501,36505,36513,36520,36524,36526,36527,36530,36535,36540,36554,36558,36574,36579,36582,36589,36595,36604,36605,36606,36610,36614,36626,36627,36650,36651,36653,36662,36669,36670,36673,36687,36688,36689,36691,36696,36697,36699,36704,36705,36712,36720,36723,36729,36732,36738,36747,36754,36755,36759,36761,36766,36767,36774,36788,36790,36791,36792,36793,36798,36811,36812,36820,36822,36825,36826,36827,36839,36843,36845,36846,36852,36865,36879,36883,36886,36888,36889,36890,36893,36916,36918,36922,36929,36959,36963,36964,36966,36996,36997,37003,37015,37024,37038,37043,37044,37052,37057,37071,37072,37082,37089,37090,37092,37096,37098,37105,37117,37154,37166,37171,37173,37174,37175,37177,37196,37205,37208,37209,37220,37221,37222,37223,37224,37231,37234,37253,37254,37257,37266,37270,37280,37292,37319,37344,37355,37358,37367,37377,37390,37409,37424,37425,37432,37442,37443,37447,37457,37460,37461,37462,37463,37464,37465,37466,37474,37481,37491,37502,37504,37507,37509,37518,37521,37522,37525,37530,37538,37543,37544,37553,37554,37555,37562,37576,37604,37616,37622,37625,37631,37633,37634,37662,37675,37678,37682,37685,37704,37710,37724,37739,37740,37753,37767,37776,37783,37786,37794,37803,37818,37826,37838,37839,37840,37842,37843,37849,37855,37859,37860,37862,37871,37872,37874,37908,37910,37911,37914,37918,37922,37930,37933,37943,37960,37967,37969,37980,37996,37999,38001,38029,38033,38038,38039,38040,38041,38042,38047,38057,38060,38066,38073,38080,38082,38083,38085,38101,38116,38117,38138,38142,38143,38149,38150,38158,38165,38178,38201,38203,38204,38206,38210,38213,38218,38234,38240,38242,38243,38246,38247,38248,38249,38258,38262,38263,38265,38266,38274,38278,38302,38304,38311,38317,38323,38345,38348,38361,38370,38371,38373,38389,38391,38395,38397,38399,38403,38405,38412,38416,38421,38429,38430,38439,38441,38442,38444,38449,38453,38465,38466,38478,38479,38490,38505,38506,38510,38511,38512,38515,38516,38524,38526,38528,38531,38537,38543,38554,38564,38577,38580,38588,38590,38596,38606,38611,38623,38624,38626,38629,38630,38635,38638,38641,38645,38650,38656,38669,38671,38675,38676,38677,38679,38680,38685,38688,38700,38704,38710,38713,38716,38717,38720,38727,38733,38734,38741,38747,38752,38753,38764,38765,38768,38773,38775,38781,38789,38794,38795,38797,38799,38808,38809,38812,38821,38823,38826,38828,38829,38837,38838,38851,38885,38888,38893,38895,38896,38898,38900,38912,38915,38920,38925,38926,38936,38938,38941,38948,38955,38956,38963,38970,38972,38981,38993,39008,39019,39023,39024,39028,39043,39044,39045,39054,39065,39070,39079,39084,39086,39100,39103,39104,39105,39117,39133,39139,39140,39149,39151,39154,39155,39160,39162,39168,39177,39183,39184,39189,39198,39201,39203,39205,39215,39228,39229,39233,39236,39244,39256,39257,39277,39292,39307,39308,39309,39310,39313,39325,39329,39337,39343,39344,39346,39350,39351,39357,39358,39363,39364,39377,39388,39390,39421,39443,39445,39449,39471,39473,39486,39503,39504,39509,39521,39522,39534,39538,39540,39545,39546,39547,39548,39549,39553,39554,39560,39566,39567,39573,39582,39585,39591,39595,39619,39620,39621,39625,39633,39660,39662,39664,39676,39678,39692,39709,39710,39720,39731,39735,39754,39756,39757,39758,39765,39767,39772,39778,39792,39793,39804,39810,39825,39828,39829,39836,39838,39840,39852,39853,39864,39882,39898,39908,39912,39914,39915,39920,39921,39925,39930,39934,39937,39947,39974,39976,39999,40000,40003,40017,40019,40031,40042,40055,40081,40088,40091,40103,40105,40138,40152,40157,40176,40194,40222,40249,40253,40266,40288,40289,40295,40302,40306,40312,40313,40314,40315,40320,40323,40338,40350,40360,40371,40375,40378,40379,40394,40395,40397,40410,40428,40439,40459,40467,40471,40507,40508,40531,40539,40541,40542,40543,40568,40574,40581,40589,40590,40612,40619,40621,40627,40632,40644,40676,40680,40686,40690,40700,40709,40712,40713,40743,40744,40750,40758,40763,40767,40776,40779,40782,40791,40795,40801,40804,40807,40816,40819,40825,40826,40833,40853,40856,40858,40866,40879,40882,40890,40895,40897,40900,40904,40912,40915,40916,40926,40927,40952,40953,40965,40971,40980,40986,40992,40996,41012,41022,41024,41029,41032,41041,41045,41051,41062,41063,41099,41110,41111,41124,41137,41142,41144,41162,41178,41179,41190,41194,41216,41218,41233,41249,41263,41275,41276,41284,41291,41294,41303,41335,41352,41358,41367,41369,41371,41382,41390,41402,41403,41407,41413,41417,41420,41423,41424,41433,41445,41446,41450,41451,41453,41458,41466,41473,41479,41494,41508,41512,41514,41524,41530,41535,41544,41549,41562,41563,41569,41571,41572,41575,41590,41616,41620,41626,41629,41637,41663,41675,41684,41713,41729,41738,41752,41755,41756,41760,41770,41789,41794,41795,41801,41811,41813,41817,41835,41836,41838,41843,41849,41851,41858,41870,41873,41884,41885,41890,41892,41897,41908,41921,41922,41928,41939,41947,41954,41961,41973,41976,41980,41982,41989,42006,42008,42015,42019,42047,42056,42058,42072,42078,42086,42090,42091,42100,42113,42118,42119,42121,42122,42129,42140,42141,42172,42179,42191,42195,42215,42216,42220,42221,42222,42227,42229,42230,42232,42233,42234,42250,42253,42258,42266,42267,42278,42283,42285,42303,42312,42316,42317,42323,42327,42329,42339,42352,42355,42363,42365,42370,42373,42383,42399,42406,42413,42427,42436,42466,42470,42489,42492,42497,42501,42505,42516,42525,42528,42537,42538,42544,42547,42550,42554,42559,42560,42561,42566,42609,42610,42611,42619,42625,42632,42642,42647,42660,42681,42682,42687,42695,42696,42706,42707,42711,42712,42717,42721,42728,42731,42736,42746,42754,42783,42788,42793,42796,42798,42800,42821,42823,42830,42840,42848,42861,42862,42866,42867,42871,42874,42876,42877,42878,42879,42882,42883,42884,42889,42907,42909,42911,42912,42928,42930,42936,42942,42954,42955,42962,42979,42980,42981,42983,42985,42995,43011,43015,43019,43021,43022,43029,43033,43036,43044,43058,43065,43075,43083,43086,43091,43116,43121,43127,43135,43142,43146,43147,43154,43161,43165,43181,43190,43218,43225,43226,43227,43228,43237,43242,43254,43257,43265,43277,43283,43286,43287,43288,43289,43290,43295,43299,43307,43312,43319,43331,43332,43333,43337,43339,43340,43343,43344,43346,43349,43361,43380,43381,43400,43411,43415,43416,43423,43434,43439,43442,43443,43455,43476,43482,43484,43485,43486,43493,43494,43502,43512,43515,43533,43535,43536,43540,43544,43548,43551,43554,43558,43559,43567,43572,43573,43577,43578,43588,43591,43597,43598,43605,43611,43613,43617,43626,43632,43638,43643,43648,43661,43677,43679,43680,43684,43692,43694,43695,43696,43697,43699,43701,43702,43703,43705,43706,43707,43713,43718,43721,43723,43724,43729,43730,43742,43743,43758,43762,43763,43766,43768,43772,43776,43782,43790,43793,43799,43800,43812,43820,43824,43825,43826,43827,43832,43836,43838,43844,43845,43847,43858,43865,43876,43877,43883,43904,43906,43913,43914,43915,43917,43919,43923,43925,43929,43930,43934,43938,43953,43955,43957,43982,43994,43998,44003,44005,44007,44012,44016,44027,44028,44031,44033,44035,44041,44043,44065,44069,44071,44075,44080,44098,44107,44108,44111,44117,44118,44133,44146,44152,44153,44158,44164,44168,44170,44192,44193,44232,44247,44248,44259,44261,44276,44281,44293,44295,44296,44298,44300,44320,44337,44340,44341,44343,44358,44394,44410,44413,44414,44423,44428,44430,44439,44466,44483,44497,44552,44555,44559,44576,44581,44592,44596,44598,44599,44600,44603,44604,44620,44623,44624,44626,44630,44649,44652,44657,44658,44667,44668,44675,44681,44692,44697,44699,44700,44727,44728,44731,44732,44733,44738,44747,44748,44751,44753,44765,44768,44802,44810,44821,44837,44843,44854,44859,44865,44876,44882,44891,44897,44898,44904,44917,44918,44931,44934,44949,44952,44953,44960,44963,44982,44983,45003,45010,45012,45014,45027,45031,45034,45055,45056,45063,45078,45083,45104,45113,45115,45125,45130,45149,45151,45155,45159,45160,45162,45167,45169,45171,45177,45190,45193,45206,45220,45225,45232,45233,45236,45239,45265,45280,45285,45301,45308,45310)
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 | 2792 | 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.33 ms |
preparing | 2.14 ms |
Sorting result | 0.02 ms |
executing | 0.02 ms |
Sending data | 0.38 ms |
end | 0.01 ms |
query end | 0.02 ms |
closing tables | 0.01 ms |
freeing items | 0.08 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 |