Tiempo de la consulta: 18.57 ms Después de la última consulta: 2.95 ms Consulta a la memoria: 1.276 MB memoria antes de la consulta: 4.492 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-07 16:43:03')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-05-07 16:43:03')
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(2,5,9,21,64,157,185,193,218,257,274,275,311,331,401,466,471,480,482,499,543,560,594,610,635,643,661,680,685,692,700,703,709,713,736,761,772,783,786,859,868,960,968,984,998,1024,1032,1034,1042,1048,1066,1079,1081,1098,1106,1127,1138,1142,1150,1151,1172,1175,1192,1194,1226,1248,1252,1253,1255,1269,1271,1279,1280,1295,1305,1322,1328,1349,1360,1375,1377,1393,1420,1421,1425,1433,1435,1441,1444,1445,1447,1454,1455,1460,1466,1476,1481,1484,1526,1534,1553,1586,1595,1624,1664,1666,1785,1811,1812,1841,1852,1855,1870,1903,1906,1984,2001,2033,2077,2101,2125,2148,2177,2193,2199,2301,2324,2359,2394,2397,2408,2432,2469,2477,2480,2494,2601,2605,2629,2631,2654,2671,2688,2691,2724,2742,2747,2773,2964,2989,3001,3056,3110,3119,3123,3193,3202,3278,3355,3364,3468,3513,3563,3590,3594,3663,3704,3750,3797,3836,3854,3872,3894,3920,3938,3942,3983,3992,4075,4101,4132,4144,4168,4176,4197,4227,4246,4247,4252,4271,4339,4342,4467,4477,4492,4523,4524,4525,4539,4558,4580,4581,4585,4586,4587,4605,4665,4758,4795,4809,4822,4845,4874,4882,4892,4919,4960,4989,5008,5014,5035,5049,5076,5079,5143,5157,5166,5226,5250,5435,5496,5507,5508,5512,5534,5609,5628,5642,5659,5697,5700,5796,5876,5936,5990,6007,6064,6065,6068,6133,6162,6200,6202,6209,6217,6257,6308,6316,6323,6328,6354,6358,6369,6396,6407,6421,6452,6461,6464,6512,6520,6533,6553,6589,6596,6608,6648,6663,6667,6678,6707,6709,6726,6762,6778,6789,6807,6808,6835,6840,6842,6863,6932,7064,7182,7200,7237,7277,7320,7358,7367,7376,7390,7405,7421,7435,7439,7449,7463,7488,7611,7625,7626,7659,7688,7709,7748,7765,7769,7802,7824,7830,7834,7839,7845,7860,7868,7870,7878,7931,7946,7951,7953,8007,8018,8056,8069,8091,8099,8108,8153,8179,8184,8193,8206,8230,8267,8283,8341,8361,8368,8400,8449,8518,8566,8623,8627,8695,8721,8750,8778,8794,8854,8889,8900,8907,8938,8944,9055,9057,9108,9122,9132,9208,9236,9252,9255,9288,9382,9390,9449,9462,9495,9527,9548,9562,9647,9664,9675,9690,9717,9721,9736,9765,9776,9815,9879,9932,9999,10060,10111,10122,10175,10195,10235,10312,10316,10371,10373,10437,10477,10501,10529,10616,10725,10736,10775,10834,10839,10851,10926,10928,10933,11134,11156,11187,11195,11223,11314,11347,11428,11433,11612,11705,11744,11761,11792,11795,11842,11859,11885,11989,12089,12137,12156,12170,12191,12238,12248,12274,12334,12439,12440,12473,12493,12508,12519,12528,12602,12746,12809,12816,12822,12826,12842,12946,12976,12978,12994,13006,13029,13078,13117,13123,13160,13188,13231,13258,13266,13272,13297,13309,13310,13316,13344,13428,13436,13437,13438,13458,13467,13478,13479,13480,13481,13482,13502,13503,13525,13544,13546,13557,13573,13580,13589,13597,13660,13669,13698,13703,13712,13784,13794,13797,13818,13819,13824,13839,13861,13902,13968,14011,14103,14114,14140,14153,14177,14188,14205,14217,14279,14283,14309,14311,14420,14429,14432,14467,14490,14493,14506,14545,14546,14641,14646,14683,14710,14711,14731,14765,14856,14864,14874,14901,14958,15058,15063,15071,15092,15109,15138,15147,15159,15216,15229,15297,15329,15337,15357,15359,15376,15420,15456,15464,15479,15543,15551,15577,15586,15598,15620,15626,15632,15644,15645,15681,15722,15759,15899,15909,15928,15932,15935,15936,15959,15973,15981,15982,15988,16052,16085,16112,16190,16216,16258,16266,16289,16325,16348,16360,16374,16386,16420,16423,16449,16452,16466,16478,16489,16529,16569,16586,16603,16606,16607,16629,16634,16638,16658,16681,16733,16734,16748,16774,16780,16791,16836,16859,16913,16987,17057,17069,17121,17126,17131,17177,17224,17267,17282,17285,17355,17383,17384,17423,17478,17555,17572,17579,17604,17645,17658,17660,17667,17699,17742,17780,17799,17892,17910,17921,17927,17952,18006,18013,18037,18039,18055,18152,18160,18174,18181,18201,18202,18226,18279,18284,18290,18295,18332,18333,18354,18382,18409,18431,18446,18455,18466,18480,18493,18520,18521,18540,18550,18653,18660,18679,18707,18714,18739,18749,18772,18811,18813,18898,18901,18916,18920,18951,18993,19004,19043,19044,19099,19115,19135,19155,19157,19158,19159,19196,19207,19217,19227,19238,19307,19335,19343,19383,19407,19412,19502,19505,19596,19612,19624,19640,19704,19755,19761,19762,19768,19773,19797,19815,19816,19832,19853,19855,19867,19884,19933,19961,19963,19979,20004,20043,20051,20056,20142,20181,20202,20208,20217,20242,20265,20375,20379,20400,20404,20452,20468,20480,20568,20569,20579,20602,20730,20739,20757,20771,20773,20796,20803,20812,20820,20849,20871,20875,20885,20933,20948,21051,21069,21085,21189,21197,21205,21280,21284,21309,21397,21408,21411,21437,21438,21491,21527,21530,21601,21611,21620,21644,21691,21743,21779,21821,21926,21940,21957,22011,22019,22052,22092,22097,22107,22113,22130,22155,22173,22192,22229,22261,22343,22400,22415,22416,22464,22477,22489,22600,22624,22625,22653,22710,22714,22722,22756,22848,22864,22872,23016,23031,23032,23039,23040,23101,23114,23221,23277,23284,23296,23313,23344,23360,23394,23406,23453,23547,23592,23593,23634,23638,23647,23654,23691,23695,23701,23715,23722,23737,23747,23769,23860,23868,23954,24017,24052,24170,24198,24270,24288,24312,24340,24388,24392,24407,24441,24447,24450,24455,24479,24524,24531,24565,24599,24726,24784,24819,24838,24875,24884,24910,24966,24977,25010,25039,25096,25133,25141,25172,25197,25222,25229,25256,25278,25282,25284,25292,25317,25326,25340,25406,25413,25417,25430,25454,25542,25575,25577,25580,25595,25609,25621,25631,25638,25655,25693,25705,25717,25720,25728,25734,25736,25747,25771,25787,25792,25796,25816,25832,25835,25845,25852,25878,25881,25888,25893,25896,25936,25943,25952,25963,25964,25968,25969,25976,25979,25980,25997,25999,26001,26004,26005,26006,26059,26061,26070,26083,26096,26109,26128,26151,26154,26166,26167,26171,26181,26195,26197,26200,26202,26243,26256,26261,26267,26326,26328,26329,26330,26348,26353,26378,26384,26410,26429,26433,26438,26439,26450,26468,26471,26478,26481,26488,26492,26529,26530,26570,26598,26645,26660,26670,26679,26681,26712,26722,26724,26733,26753,26763,26766,26770,26774,26781,26783,26795,26797,26799,26807,26808,26851,26852,26855,26856,26862,26866,26873,26894,26905,26908,26909,26910,26925,26944,26945,26950,26951,26970,26980,26984,26991,26992,27018,27035,27036,27046,27054,27071,27077,27098,27099,27105,27111,27118,27120,27133,27138,27140,27159,27163,27168,27182,27185,27193,27205,27208,27219,27226,27227,27235,27237,27238,27241,27253,27254,27255,27257,27266,27274,27278,27280,27285,27287,27292,27299,27309,27311,27314,27316,27322,27329,27334,27336,27358,27359,27370,27375,27383,27388,27406,27413,27414,27415,27416,27428,27429,27447,27450,27456,27462,27465,27467,27469,27475,27484,27488,27491,27500,27503,27508,27511,27519,27535,27537,27550,27553,27569,27576,27580,27598,27603,27610,27631,27652,27654,27674,27682,27713,27715,27727,27729,27731,27742,27751,27756,27760,27767,27772,27779,27784,27787,27792,27815,27831,27833,27837,27840,27844,27859,27865,27888,27896,27906,27941,27944,27947,27960,27974,27980,27989,28001,28012,28015,28025,28028,28029,28034,28039,28062,28074,28077,28081,28086,28093,28096,28099,28100,28101,28121,28123,28125,28126,28134,28138,28150,28151,28156,28169,28170,28180,28181,28182,28189,28210,28216,28228,28231,28233,28245,28253,28268,28278,28292,28306,28310,28313,28317,28318,28320,28352,28364,28381,28401,28418,28439,28451,28469,28471,28486,28492,28509,28523,28528,28564,28572,28580,28588,28598,28602,28603,28613,28628,28630,28644,28645,28648,28650,28659,28667,28705,28708,28716,28719,28737,28742,28743,28746,28752,28760,28762,28770,28775,28779,28782,28783,28798,28802,28813,28816,28831,28832,28838,28861,28864,28875,28885,28891,28927,28934,28956,28957,28963,28965,28977,28981,28990,28991,28996,29007,29016,29030,29042,29045,29051,29062,29070,29072,29081,29085,29092,29096,29100,29103,29110,29114,29116,29125,29128,29138,29146,29148,29150,29162,29167,29168,29170,29174,29179,29181,29187,29190,29191,29198,29200,29203,29206,29207,29217,29220,29225,29228,29230,29236,29239,29240,29245,29246,29254,29255,29259,29267,29268,29270,29273,29276,29278,29282,29287,29292,29296,29304,29306,29313,29314,29316,29330,29334,29336,29338,29339,29340,29344,29353,29356,29364,29373,29390,29393,29395,29401,29409,29424,29442,29453,29458,29479,29496,29501,29521,29522,29548,29554,29564,29565,29583,29603,29605,29614,29628,29638,29651,29652,29664,29667,29673,29675,29684,29685,29687,29700,29710,29713,29735,29737,29754,29755,29784,29793,29808,29818,29820,29838,29843,29845,29850,29860,29864,29867,29871,29876,29878,29879,29882,29891,29900,29902,29913,29916,29921,29922,29929,29932,29947,29949,29952,29954,29958,29959,29964,29970,29981,29989,30003,30004,30011,30012,30014,30019,30020,30030,30041,30048,30053,30057,30059,30066,30067,30096,30105,30122,30124,30134,30145,30156,30165,30167,30174,30178,30198,30200,30227,30246,30257,30264,30270,30277,30300,30321,30326,30328,30341,30343,30362,30370,30383,30396,30399,30411,30426,30435,30459,30460,30462,30505,30513,30518,30556,30557,30562,30565,30566,30577,30579,30593,30594,30609,30618,30629,30630,30635,30639,30648,30649,30652,30653,30661,30669,30683,30689,30694,30695,30704,30705,30722,30747,30749,30753,30755,30762,30771,30773,30777,30785,30794,30804,30814,30820,30821,30827,30832,30851,30854,30861,30867,30880,30903,30904,30908,30910,30911,30912,30919,30920,30931,30934,30942,30946,30952,30960,30975,30976,30992,31003,31004,31005,31013,31027,31033,31040,31063,31074,31112,31134,31162,31170,31190,31191,31194,31195,31196,31203,31221,31269,31277,31292,31309,31339,31384,31393,31424,31427,31429,31438,31439,31471,31476,31489,31501,31538,31546,31547,31548,31549,31559,31562,31571,31585,31588,31645,31656,31660,31672,31673,31677,31678,31680,31686,31689,31694,31774,31786,31790,31800,31810,31816,31817,31822,31823,31826,31839,31841,31851,31874,31879,31881,31894,31936,31944,31947,31965,31966,31997,32003,32032,32054,32063,32077,32117,32124,32180,32196,32210,32213,32218,32227,32238,32246,32253,32261,32262,32263,32303,32305,32323,32376,32413,32432,32433,32435,32457,32511,32512,32518,32524,32525,32530,32533,32549,32550,32569,32570,32589,32653,32677,32700,32702,32746,32778,32783,32800,32803,32810,32814,32823,32855,32859,32868,32892,32919,32923,32946,32947,32948,32949,32950,32951,32952,32953,32954,32955,32981,33008,33034,33042,33048,33088,33123,33132,33135,33136,33144,33177,33226,33236,33283,33345,33379,33411,33431,33439,33459,33460,33491,33510,33511,33530,33552,33568,33588,33604,33621,33709,33757,33805,33806,33807,33809,33834,33866,33929,33950,34005,34026,34042,34103,34116,34162,34174,34211,34217,34237,34241,34264,34271,34282,34289,34297,34322,34350,34378,34402,34410,34414,34433,34440,34454,34456,34461,34462,34486,34491,34509,34515,34524,34576,34584,34606,34613,34617,34627,34642,34650,34654,34673,34676,34678,34682,34686,34707,34725,34753,34758,34778,34788,34801,34819,34834,34837,34856,34886,34896,34909,34910,34917,34927,34928,34930,34932,34933,34936,34938,34941,34952,34954,34958,34961,34963,34972,34973,34974,34979,34986,34994,34996,35005,35020,35022,35026,35030,35033,35042,35043,35049,35050,35052,35054,35056,35061,35065,35081,35082,35083,35085,35093,35102,35105,35109,35119,35121,35124,35125,35126,35128,35129,35146,35151,35152,35154,35166,35170,35172,35194,35204,35212,35213,35215,35226,35230,35243,35248,35258,35259,35276,35299,35305,35320,35337,35360,35379,35381,35398,35430,35434,35442,35498,35502,35505,35512,35515,35518,35547,35563,35567,35583,35596,35599,35601,35625,35636,35650,35659,35677,35678,35686,35717,35718,35742,35766,35773,35775,35780,35788,35794,35796,35803,35806,35812,35815,35816,35825,35830,35853,35855,35865,35888,35890,35893,35904,35905,35907,35911,35914,35920,35930,35940,35977,35998,35999,36011,36022,36025,36031,36038,36040,36069,36085,36096,36097,36098,36120,36131,36147,36153,36158,36186,36197,36200,36207,36208,36211,36215,36221,36223,36237,36241,36244,36249,36253,36255,36257,36271,36272,36273,36281,36287,36292,36297,36307,36312,36318,36327,36331,36342,36351,36352,36358,36362,36433,36434,36435,36440,36441,36443,36444,36451,36460,36468,36485,36487,36490,36504,36509,36510,36517,36518,36545,36551,36563,36568,36597,36621,36641,36675,36712,36718,36745,36751,36770,36779,36782,36786,36809,36814,36817,36841,36882,36895,36898,36908,36927,36934,36937,36939,36961,36976,37005,37006,37017,37025,37034,37040,37042,37048,37049,37050,37051,37062,37063,37070,37076,37077,37087,37091,37107,37110,37112,37114,37116,37148,37150,37153,37167,37170,37204,37230,37309,37327,37374,37397,37403,37405,37407,37430,37439,37454,37459,37496,37511,37519,37540,37564,37588,37596,37618,37620,37663,37703,37706,37761,37773,37776,37789,37792,37793,37802,37807,37841,37852,37866,37867,37873,37893,37895,37896,37897,37898,37900,37915,37919,37937,37938,37944,37945,37973,37977,37985,37997,38002,38003,38005,38006,38024,38025,38026,38027,38076,38081,38084,38088,38092,38093,38103,38110,38111,38114,38119,38122,38124,38128,38140,38166,38173,38175,38179,38187,38189,38190,38191,38198,38205,38207,38208,38209,38214,38217,38219,38221,38229,38239,38248,38252,38253,38254,38255,38259,38260,38264,38284,38285,38292,38294,38295,38296,38297,38298,38299,38305,38310,38313,38315,38319,38340,38342,38343,38368,38369,38398,38440,38446,38447,38450,38452,38476,38500,38502,38530,38548,38549,38559,38576,38584,38591,38600,38633,38654,38662,38667,38672,38674,38684,38686,38690,38694,38711,38724,38729,38759,38776,38784,38813,38835,38839,38863,38879,38905,38917,38947,38950,38982,38983,38994,39027,39052,39059,39150,39163,39167,39173,39176,39182,39193,39245,39261,39276,39279,39288,39289,39294,39296,39311,39315,39319,39327,39347,39367,39375,39389,39391,39407,39422,39444,39455,39475,39477,39487,39492,39510,39589,39594,39607,39609,39622,39659,39706,39708,39722,39747,39749,39777,39797,39802,39823,39824,39852,39864,39868,39924,39946,39948,39983,40018,40043,40057,40058,40068,40070,40089,40091,40108,40140,40151,40174,40175,40177,40231,40252,40262,40276,40309,40321,40336,40340,40383,40398,40421,40423,40433,40436,40438,40460,40465,40469,40473,40485,40497,40520,40535,40553,40554,40555,40556,40562,40586,40604,40614,40631,40662,40667,40669,40688,40689,40692,40748,40774,40805,40811,40817,40840,40854,40881,40884,40892,40894,40925,40931,40954,40957,40958,40959,40981,40988,41040,41054,41068,41077,41107,41138,41141,41150,41220,41228,41232,41246,41247,41266,41286,41288,41321,41322,41359,41405,41418,41430,41436,41484,41499,41527,41533,41555,41570,41573,41576,41592,41594,41595,41599,41624,41635,41649,41650,41660,41712,41724,41728,41764,41782,41797,41800,41806,41807,41829,41834,41839,41865,41871,41879,41888,41896,41927,41950,41956,41957,41992,42002,42004,42011,42032,42040,42054,42057,42065,42076,42082,42091,42117,42134,42144,42150,42153,42154,42163,42174,42188,42212,42218,42262,42292,42304,42314,42328,42366,42405,42431,42439,42448,42472,42490,42496,42509,42511,42529,42538,42542,42545,42572,42586,42587,42608,42649,42652,42685,42689,42691,42703,42729,42733,42741,42765,42787,42800,42804,42806,42863,42904,42934,42937,42945,42960,42975,42997,43007,43009,43042,43066,43073,43089,43115,43122,43136,43143,43145,43148,43149,43151,43166,43173,43198,43202,43203,43222,43229,43234,43244,43251,43259,43261,43290,43294,43314,43327,43334,43345,43362,43367,43387,43389,43402,43403,43407,43433,43444,43459,43487,43499,43508,43509,43530,43534,43538,43539,43550,43556,43565,43580,43582,43596,43601,43605,43610,43615,43622,43658,43663,43682,43686,43687,43715,43727,43789,43794,43807,43838,43844,43846,43852,43868,43869,43901,43920,43965,43979,44026,44055,44074,44124,44125,44126,44154,44155,44177,44184,44238,44255,44256,44262,44299,44301,44315,44340,44346,44351,44357,44365,44376,44398,44400,44407,44431,44484,44491,44498,44501,44531,44544,44561,44565,44578,44588,44606,44607,44608,44611,44613,44637,44643,44655,44665,44670,44698,44701,44710,44741,44742,44771,44779,44791,44803,44805,44806,44812,44818,44836,44864,44869,44872,44892,44894,44908,44939,44941,44946,44955,44978,44979,44990,45007,45048,45051,45062,45077,45098,45102,45116,45118,45122,45133,45136,45142,45146,45147,45157,45166,45176,45191,45194,45197,45201,45221,45230,45234,45240,45241,45262,45277,45278,45287,45302,45303)
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 | 2728 | 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.32 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
init | 0.47 ms |
System lock | 0.02 ms |
optimizing | 0.17 ms |
statistics | 4.11 ms |
preparing | 2.10 ms |
Sorting result | 0.02 ms |
executing | 0.01 ms |
Sending data | 8.58 ms |
end | 0.01 ms |
query end | 0.40 ms |
closing tables | 0.02 ms |
freeing items | 0.52 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 |