Tiempo de la consulta: 9.67 ms Después de la última consulta: 2.41 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 <= '2026-01-09 16:30:45' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-01-09 16:30:45' )
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 (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,37565,37605,37606,37609,37638,37639,37645,37769,37819,37841,37947,37959,38017,38048,38122,38127,38133,38141,38289,38369,38382,38389,38520,38567,38590,38808,38810,38818,38856,38870,38873,38882,38890,38893,38939,38952,38961,38967,38996,39038,39061,39080,39085,39066,39113,39117,39124,39149,39182,39193,39195,39210,39223,39234,39268,39282,39287,39336,39339,39370,39376,39377,39407,39410,39417,39419,39437,39439,39464,39482,39490,39554,39556,39565,39566,39585,39587,39600,39623,39624,39627,39629,39648,39659,39661,39686,39687,39710,39738,39778,39808,39812,39822,39829,39842,39846,39852,39868,39878,39895,39932,39933,39948,39953,39956,39959,39967,39997,39999,40007,40019,40021,40043,40058,40061,40098,40121,40129,40148,40152,40167,40172,40213,40232,40233,40258,40259,40261,40265,40268,40276,40277,40309,40311,40318,40321,40323,40328,40332,40342,40353,40375,40431,40437,40446,40452,40458,40488,40499,40512,40519,40524,40516,40537,40540,40546,40548,40552,40577,40578,40590,40625,40642,40650,40672,40685,40695,40703,40704,40714,40720,40721,40735,40741,40750,40758,40772,40825,40832,40834,40859,40897,40919,40930,40933,40937,40947,40955,40962,40975,40977,40978,40992,41011,41021,41030,41042,41055,41054,41066,41069,41070,41115,41127,41134,41136,41146,41150,41153,41166,41172,41176,41180,41206,41209,41213,41218,41220,41223,41238,41239,41248,41261,41276,41277,41278,41288,41296,41292,41299,41330,41350,41357,41378,41383,41388,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,36804,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,38157,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,38317,38322,38326,38329,38334,38345,38347,38350,38354,38359,38367,38371,38383,38388,38392,38395,38397,38408,38417,38419,38420,38426,38455,38461,38475,38478,38481,38487,38491,38502,38499,38512,38519,38526,38528,38533,38535,38556,38558,38568,38571,38576,38580,38581,38593,38589,38597,38601,38604,38615,38629,38636,38642,38644,38645,38651,38656,38660,38670,38676,38681,38684,38685,38688,38696,38698,38701,38708,38716,38723,38733,38735,38745,38765,38767,38773,38777,38785,38788,38791,38795,38805,38811,38820,38830,38867,38869,38875,38885,38903,38917,38918,38922,38953,38969,38982,38984,38987,39002,39004,39016,39034,39041,39073,39074,39076,39082,39083,39084,39103,39122,39131,39154,39181,39183,39185,39212,39213,39214,39216,39219,39239,39265,39295,39296,39298,39317,39316,39349,39361,39365,39380,39403,39438,39442,39466,39472,39475,39486,39510,39519,39522,39527,39531,39532,39551,39569,39571,39591,39596,39619,39625,39638,39655,39679,39684,39688,39717,39760,39766,39770,39775,39789,39791,39824,39832,39838,39864,39871,39883,39905,39917,39945,39994,40006,40008,40009,40041,40044,40046,40051,40089,40115,40156,40201,40235,40263,40301,40362,40365,40380,40384,40460,40480,40490,40500,40509,40538,40542,40543,40572,40573,40587,40601,40604,40621,40640,40645,39235,40655,40656,40657,40692,40698,40744,40753,40775,40785,40790,40824,40837,40844,40917,40922,40961,41009,41015,41044,41059,41076,41081,41085,41087,41090,41095,41096,41101,41102,41114,41116,41117,41141,41144,41149,41170,41181,41192,41204,41207,41211,41221,41235,41240,41251,41291,41302,41323,41347,41379,871,2823,3304,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,37236,37237,37533,37594,37650,38243,38287,38332,38365,38531,38631,38980,39032,39190,39291,39345,39451,39653,39814,39850,39890,39926,39927,39937,39947,40100,40247,40336,40407,40477,40525,40616,40673,40682,40705,40719,40728,40761,40895,41391,926,934,1558,1859,2235,2243,3482,3569,5386,5514,11455,11772,12226,12336,16293,18281,35798,36000,36068,36123,36140,36523,36526,36724,36727,37063,37099,37894,38135,38180,38186,38240,38247,38249,38497,38525,38530,38740,38768,38770,38799,38861,38865,38883,38884,38937,38958,38978,39070,39120,39143,39285,39334,39342,39388,39436,39463,39525,39731,39737,39767,40002,40130,40303,40330,40354,40413,40520,40627,40679,40689,40738,40794,40807,40841,40905,41097,41191,41203,41241,41247,41249,41252,41398,959,4494,35853,35872,36322,36787,37268,37391,37557,37641,37657,37922,37931,37965,38294,38297,38318,38336,38372,38434,38436,38463,38482,38592,38646,38827,38855,38924,39077,39175,39228,39277,39341,39354,39355,39359,39396,39435,39483,39564,39592,39660,39662,39745,39768,39776,39790,39820,39889,40022,40033,40066,40083,40104,40122,40171,40236,40281,40316,40359,40373,40385,40402,40433,40440,40434,40465,40482,40556,40580,40582,40615,40737,40804,40822,41154,41174,41336,41344,41359,1054,1669,1782,2151,2199,3085,4002,4495,5652,5900,6489,6659,9600,32733,36317,36401,36445,36448,36656,36696,36720,36747,37379,37409,37633,37693,38072,38068,38086,38172,38183,38206,38251,38264,38296,38315,38352,38410,38421,38492,38552,38744,38854,38929,39014,39081,39125,39158,39194,39248,39280,39289,39294,39343,39346,39375,39383,39386,39390,39391,39401,39420,39425,39440,39443,39460,39474,39489,39499,39508,39511,39514,39518,39530,39533,39552,39561,39593,39594,39595,39598,39601,39631,39633,39635,39636,39641,39669,39685,39711,39718,39728,39732,39734,39739,39741,39744,39777,39803,39806,39810,39817,39821,39823,39830,39851,39855,39862,39865,39866,39867,39870,39874,39875,39903,39908,39930,39919,39939,39944,39946,39949,39950,39954,39988,39989,39995,39998,40003,40004,40005,40016,40017,40018,40020,40024,40040,40055,40056,40062,40068,40081,40095,40101,40112,40113,40119,40125,40135,40136,40137,40157,40158,40207,40208,40222,40224,40230,40240,40249,40250,40269,40270,40271,40279,40278,40282,40310,40312,40313,40320,40335,40338,40344,40355,40357,40374,40387,40396,40397,40400,40411,40412,40414,40416,40432,40443,40447,40451,40457,40469,40471,40472,40473,40474,40493,40494,40495,40508,40518,40532,40533,40534,40551,40553,40558,40568,40569,40591,40592,40594,40598,40603,40618,40623,40624,40628,40675,40693,40694,40715,40716,40717,40718,40726,40729,40754,40755,40756,40757,40759,40763,40764,40771,40780,40781,40799,40803,40805,40809,40810,40811,40818,40823,40827,40829,40848,40849,40886,40891,40899,40906,40907,40923,40924,40927,40929,40936,40942,40957,40960,40968,40972,40976,40981,40989,40993,40999,41000,41006,41008,41017,41018,41019,41027,41032,41033,41036,41037,41040,41063,41064,41065,41073,41078,41088,41105,41106,41113,41122,41128,41132,41138,41155,41173,41187,41219,41216,41225,41246,41256,41259,41275,41293,41297,41308,41309,41316,41332,41333,41337,41348,41355,41356,41373,41381,41386,41390,41399,1150,2333,4068,4111,6233,6466,7096,7486,8437,9103,10713,11194,16999,32874,38092,38265,38559,40463,40491,40611,40708,40733,40996,41025,41075,41098,1361,1507,1851,2249,2268,2275,2276,2359,2506,2656,2669,2732,2803,2857,2858,2950,3041,3245,3821,3992,4137,4184,4205,4270,4287,4498,4595,4600,4684,4933,4945,5103,5326,5710,5732,5839,5844,5858,6086,6110,6246,6746,6780,6788,6814,6845,7001,7101,7119,7194,7318,7426,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,35815,35788,35843,35844,35866,35925,35945,35962,35993,36045,36178,36194,36201,36312,36347,36380,36396,36471,36473,36489,36491,36492,36494,36499,36549,36555,36559,36581,36602,36603,36610,36613,36614,36605,36632,36633,36641,36719,36721,36737,36750,36749,36786,36785,36790,36791,36813,36824,36844,36845,36846,36847,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,37356,37366,37399,37398,37426,37433,37436,37477,37487,37494,37501,37508,37509,37515,37559,37580,37612,37622,37636,37654,37660,37670,37673,37677,37713,37760,37765,37768,37772,37785,37787,37790,37796,37802,37863,37866,37888,37926,37950,37952,37972,37978,38010,38016,38014,38022,38045,38047,38054,38161,38164,38156,38193,38204,38209,38268,38273,38298,38320,38316,38335,38338,38349,38361,38381,38385,38394,38411,38415,38423,38431,38458,38477,38500,38539,38557,38632,38678,38697,38706,38707,38709,38710,38727,38734,38757,38771,38815,38849,38888,38889,38895,38897,38912,38911,38949,39000,39036,39105,39126,39161,39220,39238,39275,39281,39368,39374,39379,39397,39427,39469,39467,39479,39589,39590,39610,39612,39613,39614,39649,39651,39676,39677,39692,39704,39713,39715,39733,39773,39788,39800,39835,39836,39856,39872,39869,39885,39914,39920,39921,39952,39957,39960,39961,40029,40049,40050,40053,40078,40086,40120,40155,40160,40168,40169,40180,40182,40234,40244,40252,40275,40280,40295,40298,40299,40300,40304,40363,40376,40404,40461,40481,40483,40496,40505,40530,40550,40561,40654,40660,40666,40687,40727,40746,40749,40762,40801,40815,40816,40847,40851,40855,40856,40857,40858,40880,40887,40888,40931,40956,40984,40988,41003,41004,41029,41084,41110,41143,41163,41171,41175,41185,41189,41195,41254,41282,41294,41317,41318,41319,41321,41328,41340,41352,41353,41365,41371,41372,41377,41380,41392,1497,3183,6915,10190,36452,36463,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,39040,39072,39696,39899,40614,41394,2417,5536,5719,6530,7098,36442,36736,39909,39924,40248,2575,2749,2964,4281,4438,4698,4873,4930,5036,5063,5765,5937,6350,8050,10352,10698,11078,36821,36826,36855,36917,36959,39337,39384,39392,39429,39433,39468,39471,39697,40267,40358,40439,40797,41214,5748,36582,36966,37935,38321,38541,38807,40333,40985,2903,4740,8084,8112,8620,9122,9303,9433,9621,11774,12774,14223,37958,38566,38956,39262,41179,5754,7703,17954,29882,35980,36533,36805,36853,37274,37881,38202,38578,38720,39039,39257,39256,39694,39725,40205,40242,40747,40817,36011,36245,37067,40833,40884,40913)
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 | 128 | 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.03 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 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.23 ms |
| init | 0.65 ms |
| optimizing | 0.39 ms |
| statistics | 3.34 ms |
| preparing | 2.94 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.54 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.08 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.02 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.01 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 |