Tiempo de la consulta: 13.73 ms Después de la última consulta: 2.92 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-12-12 05:14:38' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-12 05:14:38' )
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 (1680,2775,2795,4115,4281,4364,4598,7408,7571,7758,8341,35895,36247,36285,36315,36320,36355,36375,36415,36420,36460,36485,36554,36558,36559,36589,36636,36722,36817,36821,36836,36853,36855,36910,36912,36917,36936,36943,36984,37014,37041,37048,37063,37099,37128,37246,37308,37409,37428,37440,37480,37528,37556,37577,37613,37614,37654,37792,37802,37896,37923,37931,38111,38116,38177,38180,38181,38186,38208,38211,38212,38231,38237,38239,38240,38247,38248,38267,38308,38325,38330,38346,38349,38358,38361,38373,38381,38390,38400,38406,38414,38415,38423,38434,38453,38456,38477,38480,38483,38488,38495,38498,38513,38518,38525,38536,38540,38551,38553,38569,38574,38630,38634,38635,38642,38664,38674,38687,38704,38709,38710,38717,38720,38721,38734,38736,38738,38751,38752,38753,38754,38761,38764,38773,38774,38784,38798,38806,38823,38876,38894,38898,38906,38911,38935,38936,38966,38984,39036,39067,39082,39118,39126,39132,39188,39200,39201,39227,39237,39258,39270,39282,39290,39356,39396,39402,39417,39418,39432,39447,39468,39467,39490,39491,39498,39521,39528,39533,39534,39552,39559,39562,39626,39630,39640,39660,39662,39690,39693,39694,39695,39697,39702,39716,39719,39725,39726,39763,39771,39788,39799,39805,39818,39825,39828,39848,39855,39875,39891,39906,39908,39915,39929,39958,39961,39968,40001,40023,40029,40066,40089,40093,40083,40112,40124,40149,40151,40171,40203,40209,40213,40231,40241,40242,40245,40252,40267,40268,40273,40278,40286,40290,40298,40315,40316,40325,40339,40366,40368,40372,40379,40399,40408,40415,40402,40441,40442,40446,40450,40455,40462,40463,40464,40468,40469,40472,40477,40491,40493,40504,40513,40514,40521,40544,40545,40550,40567,40574,40582,40585,40586,40587,40628,40669,40676,40680,40681,40686,40687,40688,40690,40708,40740,40747,40794,40799,918,954,956,1149,1161,1208,1213,1220,1233,1527,1681,1700,1720,1760,1769,1786,1802,1805,1807,1830,1847,1861,1862,1879,1916,1931,1979,2005,1965,2102,2129,2056,2150,2197,2155,2334,2338,2350,2384,2437,2456,2504,2512,2535,2556,2560,2582,2584,2644,2671,2683,2713,2744,2772,2825,2829,2862,2863,2926,2931,2983,2992,2993,2999,3032,3087,3127,3177,3198,3231,3295,3343,3345,3434,3477,3512,3616,3654,3662,3762,3807,3862,3886,3940,3994,4011,4091,4110,4155,4198,4254,4277,4384,4414,4524,4602,4667,4833,4854,4882,4885,4967,4986,5026,5050,5148,5149,5154,5217,5273,5287,5302,5339,5350,5562,5594,5631,5649,5698,5747,5759,5784,5803,5809,5896,5982,6005,6007,6013,6053,6350,6365,6453,6607,6626,6657,6692,6710,6811,6812,6835,6964,7026,7092,7267,7443,7490,7679,7931,8232,8242,8272,8292,8406,8455,8485,8492,8535,8558,8627,8637,8646,8649,8658,8875,9097,9222,9362,9434,9514,9579,9585,9684,10035,10093,10191,10203,10260,10473,10478,10515,10651,10652,11238,11243,11618,11619,11642,11884,11955,11959,11969,12001,12268,12563,12630,12702,12855,12896,13282,13846,13857,13966,13986,14397,14536,14607,14665,14918,15046,15535,15552,15590,15603,15629,15705,15735,16371,16418,16488,16490,17511,18873,19310,21182,21624,21948,21967,22629,23124,23762,23779,24235,24325,24625,25012,25056,25081,25113,25220,25313,25439,25441,25466,25481,25811,26100,26567,26609,26701,26879,27530,27586,27711,27774,27794,27825,27835,28114,28659,28706,28711,28718,28750,29186,29237,29483,29498,29680,30100,30709,30758,30795,30839,30873,31025,31056,31087,31232,31265,31730,31813,32059,32137,32401,32439,33042,33071,33138,33800,34553,35745,35900,35991,36050,36307,36374,36666,36693,36760,36823,36877,36957,36961,36969,37010,37030,37079,37115,37150,37175,37189,37192,37202,37203,37216,37264,37270,37307,37316,37329,37344,37345,37352,37363,37368,37379,37407,37429,37435,37472,37478,37495,37519,37523,37525,37529,37532,37589,37596,37602,37637,37652,37659,37682,37694,37722,37757,37762,37763,37772,37784,37785,37797,37801,37822,37831,37843,37846,37848,37857,37859,37868,37895,37900,37927,37940,37947,37960,37961,37982,37986,37991,38015,38021,38026,38041,38044,38047,38051,38064,38077,38109,38113,38117,38123,38130,38143,38146,38164,38156,38168,38169,38193,38213,38218,38229,38235,38246,38274,38277,38302,38303,38309,38317,38324,38335,38348,38360,38376,38386,38387,38385,38398,38462,38485,38490,38509,38521,38522,38559,38572,38573,38575,38578,38580,38581,38591,38594,38603,38614,38640,38641,38658,38662,38667,38714,38725,38741,38755,38758,38780,38847,38861,38863,38884,38891,38901,38904,38928,38953,38954,38957,38958,38950,38965,38971,38985,38993,39003,39006,39024,39015,39026,39029,39033,39035,39039,39058,39064,39069,39071,39076,39105,39110,39107,39119,39145,39157,39167,39179,39186,39215,39221,39225,39228,39240,39246,39241,39250,39261,39263,39278,39297,39320,39316,39337,39341,39348,39354,39355,39390,39408,39430,39434,39445,39477,39511,39512,39553,39554,39583,39578,39592,39602,39605,39606,39621,39625,39649,39650,39663,39680,39687,39691,39730,39735,39745,39761,39776,39774,39794,39796,39808,39809,39836,39837,39869,39901,39930,39919,39954,39955,39957,39964,39984,40022,40026,40034,40045,40046,40047,40054,40055,40079,40085,40123,40133,40153,40175,40176,40179,40180,40211,40220,40237,40239,40246,40307,40308,40354,40359,40403,40409,40433,40444,40390,40461,40465,40509,40511,40515,40561,40527,40566,40575,40579,40583,40610,40611,40621,40670,40674,40705,40736,40737,40738,40743,40751,40760,40764,40765,40772,40773,40779,856,863,1908,1983,3607,4584,5150,5173,6080,10624,11317,36494,36816,37249,38232,38777,39500,39506,39909,39914,39966,40528,40570,40589,40614,40685,40759,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,35798,35815,35788,35843,35844,35866,35925,35945,35962,35993,36045,36178,36194,36201,36312,36347,36380,36396,36471,36473,36489,36491,36492,36499,36549,36555,36581,36599,36602,36603,36604,36610,36613,36614,36605,36632,36633,36641,36669,36692,36719,36721,36717,36737,36747,36750,36749,36786,36785,36790,36791,36792,36813,36824,36844,36845,36846,36847,36881,36883,36885,36905,36916,36927,36928,36935,36934,36951,36954,36979,36980,36981,36988,37002,37005,37003,37058,37056,37061,37062,37074,37087,37095,37101,37108,37144,37145,37152,37177,37198,37206,37207,37223,37232,37266,37263,37267,37303,37300,37322,37323,37333,37351,37356,37366,37391,37399,37398,37408,37426,37433,37436,37463,37477,37487,37494,37498,37501,37508,37509,37515,37555,37559,37580,37609,37612,37622,37636,37639,37660,37670,37673,37677,37706,37713,37760,37765,37768,37769,37787,37790,37796,37819,37844,37863,37866,37888,37926,37950,37952,37972,37978,38010,38016,38014,38022,38045,38050,38054,38067,38068,38086,38133,38161,38174,38175,38204,38209,38265,38268,38273,38293,38298,38318,38320,38316,38338,38352,38359,38369,38382,38389,38394,38411,38431,38458,38491,38500,38520,38539,38557,38567,38592,38632,38670,38678,38697,38706,38707,38727,38757,38771,38810,38815,38849,38870,38882,38888,38889,38895,38897,38912,38922,38949,38952,38969,39000,39038,39084,39154,39161,39185,39210,39220,39234,39238,39265,39275,39281,39359,39368,39374,39379,39397,39419,39427,39436,39439,39460,39464,39466,39469,39479,39518,39525,39527,39532,39589,39590,39600,39610,39612,39613,39614,39627,39635,39651,39659,39676,39677,39686,39692,39704,39713,39715,39728,39733,39773,39800,39824,39835,39851,39852,39856,39866,39871,39872,39868,39878,39885,39889,39895,39920,39921,39945,39952,39960,39967,39997,39999,40003,40004,40005,40017,40043,40049,40050,40053,40062,40078,40086,40104,40120,40155,40158,40160,40168,40169,40172,40182,40234,40244,40269,40275,40276,40280,40295,40299,40300,40304,40309,40323,40353,40357,40363,40365,40376,40404,40432,40443,40451,40481,40483,40488,40496,40499,40505,40508,40530,40532,40552,40558,40572,40577,40578,40601,40603,40624,40642,40650,40654,40660,40666,40672,40703,40704,40714,40715,40720,40727,40741,40746,40749,40758,40762,40780,40810,1373,2718,2776,2778,9125,36326,36379,36414,36398,36433,36440,36452,36534,36574,37034,37096,37123,37286,37638,37688,37701,37704,37712,37719,37723,37764,37799,37874,37894,37897,37979,38017,38032,38079,38135,38183,38185,38188,38217,38219,38292,38321,38353,38372,38412,38428,38457,38464,38527,38595,38611,38739,38740,38808,38856,38865,38900,38937,38940,38942,38970,38983,39061,39070,39078,39066,39152,39158,39160,39233,39243,39242,39248,39280,39289,39294,39342,39343,39346,39349,39360,39367,39375,39383,39386,39388,39391,39401,39410,39414,39415,39420,39425,39463,39474,39499,39508,39514,39524,39530,39561,39564,39593,39594,39595,39601,39624,39631,39633,39636,39641,39648,39669,39685,39711,39718,39731,39732,39739,39741,39744,39737,39767,39777,39803,39806,39810,39814,39817,39821,39823,39830,39850,39862,39865,39870,39874,39899,39923,39934,39936,39939,39944,39946,39949,39950,39988,39989,39994,39995,39998,40002,40016,40018,40020,40021,40024,40031,40040,40056,40065,40068,40081,40095,40101,40113,40119,40125,40130,40131,40135,40136,40137,40157,40164,40207,40208,40222,40224,40230,40240,40249,40250,40260,40270,40271,40279,40282,40303,40310,40311,40312,40313,40320,40330,40333,40335,40338,40344,40355,40374,40396,40397,40411,40412,40413,40414,40416,40437,40447,40457,40471,40473,40474,40494,40495,40502,40518,40519,40520,40533,40534,40551,40553,40569,40591,40592,40594,40598,40618,40623,40627,40651,40679,40689,40693,40694,40706,40716,40717,40718,40726,40754,40755,40756,40757,40763,40771,40803,40805,40807,40809,40811,1500,1665,5226,5685,6276,6951,12302,13024,18161,35725,35823,35983,36321,36387,36564,36621,36672,36691,36736,37365,37520,37680,37711,38012,38141,38336,38363,38492,38506,38760,38829,38915,38925,38956,39120,39129,39182,39192,39203,39438,39497,39560,39698,39738,39812,39847,39879,39948,40041,40106,40115,40364,40466,40535,40590,40713,40721,40729,2053,6839,36249,36278,36314,36584,37043,38027,38532,39155,39260,39452,39501,39674,39887,40032,40042,40181,40617,2086,3528,5933,36454,38820,38967,39184,39813,39990,40070,40161,40314,40549,2404,2592,2771,3006,7145,8853,9120,9608,10991,12981,13501,17683,17704,35878,35985,36209,36413,36417,36787,36901,37178,37470,37586,37592,37603,37620,37771,37842,37856,38171,38176,38269,38602,38742,38860,38926,39030,39159,39247,39487,39609,39620,39721,39795,39831,39845,39853,39884,39924,39963,40000,40025,40030,40202,40337,40470,40675,40697,40710,40711,40730,40748,40778,2417,5536,5719,6530,7098,36442,40248,2903,2965,4374,11112,38162,38241,38250,38436,38542,38796,38807,38814,38858,39580,39586,39681,40319,40326,40371,40392,40395,40501,40536,40600,40733,3395,3634,3815,6593,11075,13046,38514,40217,5464,6407,9192,10688,13021,13624,15275,15581,15997,16206,16454,16461,16885,17272,18212,18218,18731,19704,20150,20166,20595,21669,21758,22396,22853,24863,25464,27211,27540,27787,30519,31153,35331,37292,37558,38080,38092,38095,38205,38989,38997,6232,7112,8129,33197,36461,37852,38686,10100,16460,16756,29072,30128,31936,32116,33494,33630,33757,34174,36399,38065,38207,39364,39598,36953,37006,37444,37507,37672,37789,37800,37975,37980,38096,38433,38628,38772,39150,39618,39652,40111,40369,40774,40792,40800)
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 | 117 | 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 |
