Tiempo de la consulta: 10.99 ms Después de la última consulta: 2.66 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-27 23:32:08' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-27 23:32:08' )
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 (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,36954,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,37267,37275,37276,37283,37302,37304,37326,37331,37359,37361,37362,37365,37373,37375,37377,37390,37392,37393,37422,37434,37445,37463,37469,37471,37486,37490,37502,37504,37518,37519,37530,37555,37556,37575,37583,37587,37606,37608,37610,37615,37634,37635,37637,37639,37645,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,37841,37844,37845,37861,37864,37867,37886,37891,37901,37902,37903,37932,37933,37934,37936,37937,37938,37939,37951,37954,37959,37974,37976,37977,37981,38008,38013,38029,38031,38048,38050,38052,38060,38067,38011,38078,38087,38090,38093,38121,38122,38123,38124,38127,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,38382,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,38590,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,38873,38875,38885,38890,38893,38903,38917,38918,38922,38939,38952,38953,38961,38967,38969,38982,38984,38987,38996,39002,39004,39016,39034,39038,39041,39073,39074,39076,39080,39082,39083,39084,39085,39103,39113,39122,39117,39124,39131,39149,39154,39181,39182,39183,39185,39195,39210,39212,39213,39214,39216,39219,39223,39235,39239,39265,39268,39287,39295,39296,39298,39317,39316,39336,39339,39349,39361,39365,39370,39376,39377,39380,39403,39407,39419,39437,39438,39439,39442,39464,39466,39472,39475,39482,39486,39490,39510,39519,39522,39527,39531,39532,39551,39556,39565,39566,39569,39571,39585,39587,39591,39596,39619,39623,39625,39629,39638,39655,39659,39661,39679,39684,39686,39687,39688,39717,39738,39760,39766,39770,39775,39789,39791,39808,39824,39829,39832,39838,39846,39864,39871,39868,39878,39883,39905,39917,39933,39945,39953,39956,39959,39994,40006,40007,40008,40009,40019,40041,40044,40046,40051,40058,40061,40089,40098,40115,40121,40129,40148,40152,40156,40167,40172,40201,40213,40232,40233,40235,40258,40259,40261,40263,40265,40277,40301,40309,40318,40321,40328,40332,40342,40362,1136,3820,3919,5103,36412,36563,37118,37508,38054,38273,38828,38937,38978,39508,39589,1154,8464,40268,1155,1353,2159,2388,2499,4164,4498,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,39711,39948,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,4595,4600,4684,4933,4945,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,35798,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,36599,36602,36603,36604,36610,36613,36614,36605,36632,36633,36641,36669,36719,36721,36717,36737,36747,36750,36749,36786,36785,36790,36791,36813,36824,36844,36845,36846,36847,36881,36883,36885,36905,36916,36927,36928,36935,36934,36951,36979,36980,36981,36988,37002,37005,37003,37010,37014,37041,37058,37056,37061,37062,37074,37087,37095,37101,37108,37144,37145,37152,37198,37206,37223,37232,37249,37266,37263,37303,37300,37322,37323,37329,37333,37344,37351,37356,37366,37391,37399,37398,37408,37426,37433,37436,37477,37487,37494,37498,37501,37509,37515,37559,37580,37609,37612,37622,37636,37654,37660,37670,37673,37677,37713,37760,37765,37768,37769,37772,37785,37787,37790,37796,37802,37819,37863,37866,37888,37926,37950,37952,37972,37978,38010,38016,38014,38022,38045,38047,38068,38086,38133,38161,38164,38156,38193,38204,38209,38265,38268,38298,38318,38320,38316,38335,38338,38349,38352,38361,38369,38381,38385,38389,38394,38411,38415,38423,38431,38458,38477,38500,38520,38525,38539,38559,38557,38567,38592,38632,38678,38697,38706,38707,38709,38710,38727,38734,38757,38771,38810,38815,38849,38870,38882,38888,38889,38895,38897,38912,38911,38949,39000,39036,39105,39126,39161,39220,39234,39238,39275,39281,39355,39359,39368,39374,39379,39397,39417,39427,39436,39460,39469,39467,39479,39518,39525,39590,39600,39610,39612,39613,39614,39627,39635,39649,39651,39676,39677,39692,39704,39713,39715,39728,39733,39773,39776,39788,39800,39835,39836,39851,39852,39856,39866,39872,39869,39885,39889,39895,39914,39920,39921,39952,39957,39960,39961,39967,39997,39999,40003,40004,40005,40017,40029,40043,40049,40050,40053,40062,40078,40086,40104,40120,40155,40158,40160,40168,40169,40180,40182,40234,40244,40252,40269,40275,40276,40280,40295,40298,40299,40300,40304,40323,40353,40354,40357,40363,1373,2718,2776,2778,9125,36326,36379,36414,36398,36433,36440,36452,36534,36574,36693,36816,36912,37034,37063,37096,37123,37286,37638,37688,37701,37704,37712,37719,37723,37764,37799,37874,37894,37897,37979,38017,38032,38079,38135,38183,38185,38186,38188,38212,38217,38219,38292,38321,38353,38372,38412,38428,38457,38464,38527,38595,38611,38739,38740,38808,38856,38865,38891,38900,38940,38942,38970,38983,39061,39070,39078,39066,39152,39158,39160,39233,39243,39242,39248,39280,39282,39289,39294,39342,39343,39346,39360,39367,39375,39383,39386,39388,39391,39401,39410,39414,39415,39420,39425,39463,39474,39499,39511,39514,39524,39530,39552,39561,39564,39593,39594,39595,39601,39624,39631,39633,39636,39641,39648,39669,39685,39718,39731,39732,39739,39741,39744,39737,39767,39777,39803,39806,39810,39814,39817,39821,39823,39830,39850,39855,39862,39865,39870,39874,39875,39899,39923,39934,39936,39939,39944,39946,39949,39950,39988,39989,39995,39998,40002,40016,40018,40020,40021,40024,40031,40040,40055,40056,40065,40066,40068,40081,40093,40095,40101,40113,40119,40125,40130,40131,40135,40136,40137,40149,40157,40164,40207,40208,40222,40224,40230,40240,40245,40249,40250,40260,40270,40271,40279,40282,40303,40310,40311,40312,40313,40316,40320,40330,40333,40335,40338,40344,40355,1497,3183,6915,10190,36463,36523,36600,36601,36725,36939,37225,37561,37593,38020,38081,38084,38171,38289,38686,38979,39040,39072,39435,39696,39842,1500,1665,2931,5226,5685,6276,6951,12302,13024,18161,35725,35823,35983,36321,36387,36564,36621,36672,36691,36736,37520,37711,38012,38141,38240,38336,38363,38492,38506,38578,38760,38829,38915,38925,38956,38957,39039,39120,39129,39192,39203,39227,39497,39560,39698,39725,39812,39847,39879,40106,40364,40368,1787,2502,3232,3233,7033,7356,8158,9594,30358,35980,35981,36317,36417,36459,36447,36650,36666,36780,36961,36965,37046,37079,37109,37113,37216,37247,37274,37301,37352,37516,37842,37995,38210,38285,38348,38409,38486,38543,38630,38821,38887,38902,39005,39237,39318,39321,39362,39471,39516,39562,39606,39668,39690,39691,39699,39724,39769,39798,39831,39843,39845,39848,39849,39853,39886,39897,39990,39991,39992,40035,40052,40075,40094,40107,40150,40154,40287,40290,40326,40337,40345,2417,5536,5719,6530,7098,36442,39909,39924,40248,2708,2780,3136,3358,3405,3876,3980,4340,4355,4547,4603,4635,5200,5428,5481,5694,5790,6031,6067,6489,7247,7909,8237,8534,9550,9621,10503,10571,10779,11031,11221,11237,11315,11564,13207,13790,14973,15898,15988,16009,16013,16027,16041,16077,16140,16242,16309,22080,26484,29858,30014,30096,30213,30278,30297,30473,30501,30525,30557,30815,30846,31099,32603,32658,32819,33592,33846,34127,34178,34638,34826,35296,35455,35629,35719,35783,35924,36010,36013,36037,36041,36054,36085,36128,36169,36173,36195,36208,36248,36269,36284,36287,36300,36301,36348,36349,36365,36430,36453,36461,36518,36568,36569,36655,36826,37179,37958,3482,4740,8084,8112,8620,9122,9303,9433,11774,12774,14223,36475,38566,39262,5754,7703,9600,17954,29882,32733,36533,36805,36853,37881,38202,38720,39257,39256,39694,39903,39932,40112,40205,40242,6062,12983,15628,37962,38826,39722,40315,39030)
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 | 148 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | admin_ddpue3.i.catid | 1 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | 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 |
