Tiempo de la consulta: 15.60 ms Después de la última consulta: 2.40 ms
SELECT i.*, c.alias as categoryalias
FROM qgn06_k2_items as i
LEFT JOIN qgn06_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2025-11-30 10:29:26' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-30 10:29:26' )
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND (i.id) IN (16,18,958,1039,1670,1849,1960,2069,2134,2157,2171,2341,2524,2623,2662,2874,2987,3294,3304,3366,3493,3572,4260,4495,4925,5446,5646,6041,6092,6152,6233,6629,6814,7033,7426,7469,8270,9458,10465,11166,25397,35831,36470,37772,38405,38489,38520,38559,38614,38642,38659,38718,38859,38891,38900,38937,38939,38951,38961,38969,39040,39061,39142,39195,39248,39249,39282,39661,39763,39788,39823,39874,39875,39894,39934,40019,40031,40076,40085,85,1063,1596,1680,3306,3853,4365,4449,4563,5182,5830,6707,10047,10125,26981,29889,30279,32235,35784,35817,35857,35906,35970,35981,36071,36141,36418,36559,36591,37274,37307,37320,37514,37516,37525,37528,37533,37565,37599,37655,37784,37797,37893,37924,37950,37984,37991,38006,38022,38376,38498,38555,38569,38591,38631,38680,38769,38795,38806,38822,38853,38907,38922,38935,38941,38998,39119,39117,39167,39216,39288,39418,39426,39468,39490,39498,39517,39612,39689,39695,39700,39760,39790,39796,39816,39876,39929,39961,40100,40127,40157,40241,40369,851,1548,3448,3451,4454,5670,6342,8670,11895,31342,35872,36257,36880,38985,39178,39419,39531,39799,39828,39890,39902,40029,40060,40151,863,908,1338,1539,2017,2148,2296,2365,2669,2787,2946,2966,3020,3309,3754,4498,5293,6261,6488,6542,7071,7224,7290,7688,8576,9063,9547,11192,12829,15857,26479,35401,35971,36016,36036,36261,36312,36416,36433,36461,36528,36582,36585,36755,36804,36833,37015,37072,37097,37119,37129,37420,37458,37487,37595,37596,37613,37692,37713,37714,37760,37823,37829,37828,37888,38041,38157,38181,38190,38317,38359,38378,38379,38394,38411,38419,38420,38452,38457,38512,38552,38589,38643,38644,38676,38696,38809,38850,38856,38861,38863,38866,38882,38897,38920,38927,38932,38963,38978,38984,39007,39018,39028,39042,39081,39107,39128,39162,39179,39191,39203,39218,39240,39246,39239,39265,39275,39295,39324,39360,39366,39373,39398,39478,39479,39495,39520,39564,39600,39613,39614,39641,39666,39669,39677,39696,39712,39744,39900,39901,39904,39921,39932,39936,39948,39951,39957,40001,40008,40041,40054,40098,40117,40186,40225,40237,40243,40258,40294,40301,40321,40361,40386,40406,854,1373,36321,36431,36488,36575,36576,36599,36600,36607,36655,36717,36768,36803,36816,36828,36860,36928,36937,36934,36954,36985,37005,37034,37095,37096,37126,37146,37198,37267,37310,37326,37339,37351,37358,37375,37392,37393,37408,37422,37463,37465,37469,37471,37498,37504,37521,37555,37605,37606,37609,37638,37639,37645,37769,37819,37841,37947,37959,38017,38048,38122,38127,38133,38141,38289,38369,38382,38389,38567,38590,38808,38810,38818,38870,38873,38890,38893,38967,38996,39038,39080,39085,39066,39113,39124,39149,39182,39193,39210,39223,39234,39268,39287,39336,39339,39370,39376,39377,39407,39410,39417,39437,39439,39464,39482,39554,39556,39565,39566,39585,39587,39623,39624,39627,39629,39648,39659,39686,39687,39710,39738,39778,39808,39812,39822,39829,39842,39846,39852,39868,39878,39895,39933,39953,39956,39959,39967,39997,39999,40007,40021,40043,40058,40061,40121,40129,40148,40152,40167,40172,40213,40232,40233,40259,40261,40265,40268,40276,40277,40309,40311,40318,40323,40328,40332,40342,40353,40375,861,2055,3157,4471,4626,4743,5499,6547,8077,35902,35946,35963,35965,35968,36532,36562,36565,36651,36659,36660,36664,36692,36733,36734,36744,36754,36751,36778,36792,36793,36827,36843,36854,36952,36953,36955,36982,37004,37032,37035,37036,37038,37039,37042,37049,37059,37069,37094,37110,37130,37147,37156,37148,37177,37195,37199,37201,37207,37210,37213,37234,37240,37275,37276,37283,37302,37304,37331,37359,37361,37362,37365,37373,37377,37390,37434,37445,37486,37490,37502,37518,37519,37530,37556,37575,37583,37587,37608,37610,37615,37634,37635,37637,37656,37665,37667,37671,37675,37680,37683,37684,37699,37702,37706,37707,37716,37720,37721,37724,37757,37758,37766,37770,37803,37804,37805,37806,37807,37808,37824,37825,37827,37837,37839,37844,37845,37861,37864,37867,37886,37891,37901,37902,37903,37932,37933,37934,37936,37937,37938,37939,37951,37954,37974,37976,37977,37981,38008,38013,38029,38031,38050,38052,38060,38067,38011,38078,38087,38090,38093,38121,38123,38124,38134,38138,38152,38163,38166,38174,38175,38177,38178,38179,38201,38203,38207,38208,38227,38230,38233,38235,38237,38239,38248,38245,38266,38271,38286,38290,38293,38299,38304,38308,38319,38322,38326,38329,38334,38345,38347,38350,38354,38367,38371,38383,38388,38392,38395,38397,38408,38417,38426,38455,38461,38475,38478,38481,38487,38491,38502,38499,38519,38526,38528,38533,38535,38556,38558,38568,38571,38576,38580,38581,38593,38597,38601,38604,38615,38629,38636,38645,38651,38656,38660,38670,38681,38684,38685,38688,38698,38701,38708,38716,38723,38733,38735,38745,38765,38767,38773,38777,38785,38788,38791,38805,38811,38820,38830,38867,38869,38875,38885,38903,38917,38918,38953,38982,38987,39002,39004,39016,39034,39041,39073,39074,39076,39082,39083,39084,39103,39122,39131,39154,39181,39183,39185,39212,39213,39214,39219,39235,39296,39298,39317,39316,39349,39361,39365,39380,39403,39438,39442,39466,39472,39475,39486,39510,39519,39522,39527,39532,39551,39569,39571,39591,39596,39619,39625,39638,39655,39679,39684,39688,39717,39766,39770,39775,39789,39791,39824,39832,39838,39864,39871,39883,39905,39917,39945,39994,40006,40009,40044,40046,40051,40089,40115,40156,40201,40235,40263,40362,40365,40380,40384,867,1253,2084,2188,2407,3501,3922,4474,5673,6404,6517,7157,7718,10405,11813,12446,15499,35706,35801,35822,35834,35859,35855,35951,36316,36381,36435,36464,36447,36493,36578,36648,36989,37142,37236,37401,37467,37551,37554,37579,37581,37594,37620,37650,37679,37700,37762,37795,37859,37860,38155,38173,38213,38243,38301,38377,38384,38425,38466,38482,38570,38761,38776,38797,38829,38962,38993,38999,39020,39043,39120,39147,39198,39201,39221,39277,39285,39293,39383,39415,39451,39456,39488,39489,39509,39529,39553,39559,39579,39592,39617,39633,39657,39703,39709,39719,39735,39761,39776,39794,39798,39803,39857,39862,39888,39913,39916,39922,39988,39998,40047,40092,40102,40114,40128,40158,40159,40166,40171,40204,40208,40245,40264,40273,40313,40336,40354,40370,40407,40412,871,2823,4192,36366,36372,36371,36397,36411,36412,36446,36454,36456,36475,36455,36546,36563,36564,36561,36547,36604,36606,36618,36608,36638,36650,36653,36661,36669,36670,36690,36691,36705,36706,36715,36743,36752,36753,36829,36842,36849,36903,36904,36905,36906,36926,36925,36927,36983,36984,36986,37040,37070,37073,37076,37118,37237,38287,38332,38365,38531,38980,39032,39190,39291,39345,39653,39814,39850,39926,39927,39937,39947,40247,927,1138,1156,2121,2398,2443,2780,2836,5195,5353,6759,6939,7468,10644,11018,11272,11284,11665,13133,36410,37517,37624,37929,37983,38046,38092,38095,38303,38534,38542,38641,39343,39344,39346,39367,39420,39508,39656,39711,39718,39739,39777,39807,39810,39815,39817,39865,39949,39958,40003,40004,40018,40105,40200,40288,40325,40331,40405,40404,40410,959,1859,4494,35853,36322,36787,37268,37391,37557,37641,37657,37922,37931,37965,38294,38297,38318,38336,38372,38434,38436,38463,38592,38646,38827,38855,38924,39077,39175,39228,39341,39354,39355,39359,39396,39435,39483,39660,39662,39745,39768,39820,39889,40022,40033,40066,40083,40104,40122,40236,40281,40316,40359,40373,40385,40402,1038,2546,3962,6159,6453,10530,17898,35795,36405,36796,36966,36967,37091,37141,37253,37246,37270,37352,37356,37461,37682,37791,37847,37872,38014,38168,38214,38229,38298,38518,38578,38672,38753,38887,39005,39108,39158,39189,39199,39215,39224,39294,39319,39327,39337,39350,39356,39406,39446,39447,39481,39597,39631,39650,39654,39663,39722,39779,39809,39825,39831,39892,39950,40028,40096,40119,40150,40231,40287,40320,40377,40413,1120,2420,10098,35714,35828,36127,39363,1135,6502,36537,37265,39394,1155,1353,2159,2388,2499,3820,3919,4164,5091,5396,9314,10147,10161,10330,10632,10687,10899,10922,10943,11017,11037,11146,11167,11177,11187,11231,11368,11374,11382,11556,13350,13641,14269,14314,16547,17452,21065,22718,25231,26786,29585,31221,33868,33947,34347,34348,34539,34873,36376,36931,37374,37508,1186,4632,6555,11138,11653,36399,36959,37044,37155,37940,38030,38070,38083,38113,38117,38267,38295,38396,38493,39533,39598,40401,1211,5594,35830,35854,36146,36291,36492,36617,36799,36822,36847,36944,36994,36997,37312,37313,37488,37493,37499,37552,37625,37709,37765,37838,38024,38532,38648,38758,38774,38888,38929,38956,39114,39155,39340,39639,39665,39873,39923,40064,40069,40084,40091,40131,40174,40274,40364,1284,1899,2473,2636,2661,2674,2725,2846,3414,4721,4759,4830,5084,5132,5917,6016,6104,6744,7010,7295,8046,9140,9202,9538,9707,11003,12766,12798,27045,27340,30513,30739,35692,36443,36765,37280,37457,38530,38613,38775,38803,39358,40015,40207,40340,1310,2820,3085,37558,39558,1361,1507,1851,2249,2268,2275,2276,2359,2506,2656,2732,2803,2857,2858,2950,3041,3245,3821,3992,4137,4184,4205,4270,4287,4595,4600,4684,4933,4945,5103,5326,5710,5732,5839,5844,5858,6086,6110,6246,6746,6780,6788,6845,7001,7101,7119,7194,7318,7589,7900,8091,8098,8177,8184,8315,8321,8421,8451,8696,8833,8951,9330,9355,9474,9775,9879,10322,11356,12078,13398,13693,13923,13987,31584,31633,35715,35789,35797,35798,35815,35788,35843,35844,35866,35925,35945,35962,35993,36045,36178,36194,36201,36347,36380,36396,36471,36473,36489,36491,36494,36499,36549,36555,36581,36602,36603,36610,36613,36614,36605,36632,36633,36641,36719,36721,36737,36747,36750,36749,36786,36785,36790,36791,36813,36824,36844,36845,36846,36881,36883,36885,36916,36935,36951,36979,36980,36981,36988,37002,37003,37010,37014,37041,37058,37056,37061,37062,37074,37087,37101,37108,37144,37145,37152,37206,37223,37232,37249,37266,37263,37303,37300,37322,37323,37329,37333,37344,37366,37399,37398,37426,37433,37436,37477,37494,37501,37509,37515,37559,37580,37612,37622,37636,37654,37660,37670,37673,37677,37768,37785,37787,37790,37796,37802,37863,37866,37926,37952,37972,37978,38010,38016,38045,38047,38054,38068,38086,38161,38164,38156,38193,38204,38209,38265,38268,38273,38320,38316,38335,38338,38349,38352,38361,38381,38385,38415,38423,38431,38458,38477,38500,38525,38539,38557,38632,38678,38697,38706,38707,38709,38710,38727,38734,38757,38771,38815,38849,38889,38895,38912,38911,38949,39000,39036,39105,39126,39161,39220,39238,39281,39368,39374,39379,39397,39427,39436,39460,39469,39467,39518,39525,39589,39590,39610,39635,39649,39651,39676,39692,39704,39713,39715,39728,39733,39773,39800,39835,39836,39851,39856,39866,39872,39869,39885,39914,39920,39952,39960,40005,40017,40049,40050,40053,40062,40078,40086,40120,40155,40160,40168,40169,40180,40182,40234,40244,40252,40269,40275,40280,40295,40298,40299,40300,40304,40357,40363,40376,1497,3183,6915,10190,36452,36463,36523,36534,36574,36601,36693,36725,36939,37225,37561,37593,37979,38020,38032,38079,38081,38084,38171,38185,38217,38292,38412,38464,38686,38739,38942,38979,39072,39499,39561,39899,1505,1546,1949,1963,2135,2310,4272,4511,7525,7888,35979,36756,36911,39470,1525,1749,5117,6455,6518,6570,6622,6703,6961,8338,9311,1543,2918,3329,5896,35974,36017,36302,36403,36432,36704,36879,36930,37876,38212,38228,38285,38357,38460,38541,38579,38647,38712,39064,39068,39111,39357,39432,39560,39708,39736,39772,39834,39861,40063,40124,40368,1599,1613,1649,1816,2142,2490,2528,2587,2851,3394,3488,3558,3625,3913,3979,4432,5127,5837,5840,6358,6849,7594,8604,8752,9996,10281,10535,11090,13901,14987,19575,32205,35731,35785,35824,35835,35829,35851,35850,35876,35914,35904,35948,35949,35977,35985,35973,36303,36383,36408,36503,36856,37247,37286,37371,37400,37529,37589,37614,37652,37676,37710,37718,37767,37890,37898,38065,38080,38128,38183,38188,38191,38291,38325,38390,38402,38407,38438,38456,38529,38527,38596,38673,38682,38752,38792,38970,39070,39148,39232,39233,39474,39487,39497,39607,39630,39632,39636,39640,39646,39732,39737,39843,39853,39938,40034,40082,40090,40101,40135,40230,40394,1941,2658,3315,4834,11496,35716,36122,36304,36476,36677,37029,37500,37649,37678,38496,38538,38817,39065,39244,39270,39283,39448,39496,39570,39658,39724,39867,39884,40272,40393,1980,2501,2502,2954,3967,4228,4296,4308,4348,6006,6501,6565,7317,7494,8350,8894,11584,11907,13152,13828,35721,35871,36106,36483,36484,36933,36941,36999,37233,37466,37646,37786,37830,37956,37960,38205,38250,38307,38422,38492,38741,38770,38883,38884,38931,38946,38965,38986,39003,39029,39033,39112,39186,39261,39611,39675,39797,39954,39968,39993,40035,40052,40057,40079,40330,40390,2007,2500,2596,2631,2864,3443,4381,4833,4868,6070,6141,6543,6704,6983,7572,8161,8274,8367,8629,8650,11026,14879,38577,38720,38743,38958,39197,39217,39267,39279,39323,39326,39384,39424,39429,39513,39572,39726,39780,39781,40081,40133,40134,40240,40283,40355,40360,2079,2768,3262,7245,9091,30714,35728,35816,35845,35880,35944,36060,36200,36202,36223,36278,36311,36318,36370,36387,36386,36400,36406,36445,36440,36460,36467,36477,36500,36520,36525,36571,36598,36609,36639,36676,36758,36764,36767,36815,36862,36898,36918,36936,36987,37012,37079,37109,37140,37235,37248,37244,37273,37314,37368,37379,37435,37464,37522,37524,37584,37591,37621,37626,37627,37632,37648,37666,37719,37761,37794,37801,37842,37843,37858,37889,37892,38009,38021,38051,38058,38061,38077,38184,38274,38277,38321,38324,38386,38462,38485,38611,38657,38667,38674,38719,38760,38804,38851,38868,38871,38896,38904,38959,39019,39022,39015,39069,39115,39225,39274,39276,39333,39369,39399,39449,39524,39681,39707,39762,39844,39880,39903,39924,39955,40023,40027,40042,40059,40077,40095,40112,40175,40203,40206,40210,40246,40341,40387,40392,40415,2248,35846,36385,36401,36448,36434,36522,36579,36620,36646,36696,36831,37007,37033,37100,37120,37158,37208,37217,37226,37285,37325,37342,37346,37378,37427,37441,37485,37512,37550,37553,37563,37590,37661,37690,37693,37701,37712,37723,37764,37865,37949,38064,38109,38218,38276,38346,38373,38391,38430,38454,38480,38523,38549,38551,38669,38679,38738,38749,38782,38798,38823,38892,38905,38925,38948,39062,39067,39156,39188,39209,39226,39243,39256,39331,39332,39347,39402,39431,39485,39512,39534,39555,39588,39605,39637,39667,39694,39705,39730,39811,39818,39915,39931,39991,39995,40065,40099,40149,40242,40292,40307,40317,40344,40372,40379,40408,2320,10241,13644,36044,2417,5536,5719,6530,7098,36442,36736,39909,40248,2603,2955,5417,5468,5483,5522,5604,8249,8450,8463,9777,10367,15316,33321,35012,35645,35691,35717,35729,35725,35832,35980,35984,35996,36103,36121,36186,36526,36723,36917,37194,37251,37987,38543,38666,38731,38748,38814,38865,38908,39027,39110,39284,39334,39348,39476,39480,39507,39697,39767,40080,40282,40289,40303,2762,8189,10607,35892,36144,2903,5419,5504,39342,39615,40163,6585,17497,19469,25623,30954,31101,31109,31130,31147,35819,35827,35860,35891,35908,35994,36082,36083,36100,36119,36193,36242,36244,36249,36273,36485,36535,36577,36716,36848,39157,39769,36011)
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | index | PRIMARY,item,catid | created | 8 | NULL | 60 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | admin_ddpue3.i.catid | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 1.63 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| After table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| After table lock | 0.44 ms |
| init | 1.02 ms |
| optimizing | 0.61 ms |
| statistics | 5.31 ms |
| preparing | 4.75 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 1.07 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.22 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.07 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.01 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Comunicador | Archivo y número de línea | | 14 | JDatabaseDriverMysql->execute() | JROOT/libraries/joomla/database/driver.php:1692 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:975 |
| 12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:305 |
| 11 | K2ViewItem->display() | JROOT/libraries/legacy/controller/legacy.php:690 |
| 10 | JControllerLegacy->display() | JROOT/components/com_k2/controllers/controller.php:20 |
| 9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:80 |
| 8 | K2ControllerItem->display() | JROOT/libraries/legacy/controller/legacy.php:728 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_k2/k2.php:63 |
| 6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:257 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |