Tiempo de la consulta: 3.67 ms Después de la última consulta: 0.79 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-31 19:34:41' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-31 19:34:41' )
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 (47,1240,1438,1535,1664,2020,2118,2491,2803,2970,3512,3794,4090,4976,5127,5155,5542,5594,5685,6430,6457,7237,7331,7375,8166,10655,12169,12641,14877,15221,24154,27341,28585,30321,30714,35713,35727,35732,35831,35823,35816,35849,35848,35854,35909,35910,35924,35972,35973,35997,36387,36407,36477,36703,36720,36780,37012,37073,37089,37111,37119,37140,37153,37178,37190,37194,37214,37235,37321,37335,37336,37371,37379,37420,37435,37460,37486,37489,37493,37582,37621,37632,37692,37693,37699,37704,37709,37756,37792,37801,37804,37840,37846,37874,37892,37962,37985,37992,38012,38014,38024,38051,38069,38175,38181,38200,38211,38212,38228,38230,38274,38277,38285,38295,38298,38324,38327,38336,38378,38407,38420,38421,38457,38476,38495,38525,38532,38541,38542,38549,38566,38574,38576,38578,38596,38605,38608,38607,38640,38641,38642,38648,38674,38705,38712,38719,38829,38888,38896,38900,38925,38936,38946,38984,39022,39027,39035,39042,39065,39078,39066,39103,39145,39155,39160,39162,39164,39176,39192,39201,39230,39274,39285,39324,39325,39378,39403,39474,39494,39495,39496,39515,39520,39521,39558,39601,39610,39623,39648,39674,39678,39697,39728,39732,39744,39767,39776,39790,39844,39872,39873,39879,39880,39904,39918,39921,39923,39927,39935,39988,40000,40027,40031,40042,40047,40062,40064,40075,40084,40091,40095,40098,40103,40106,40112,40118,40119,40121,40131,40137,40174,40175,40243,40288,40294,40315,40324,40335,40337,40338,40345,40364,40404,40406,40411,40415,40453,40466,40474,40481,40494,40501,40523,40524,40541,40606,40607,40613,40621,40628,40668,40669,40677,40691,40712,40713,40722,40736,40743,40747,40751,40766,40772,40782,40796,40822,40831,40836,40841,40847,40889,40890,40895,40902,40916,40926,40963,40966,40987,40994,41003,41020,41036,41040,41062,41065,41083,41098,41102,41109,41118,41119,41121,41149,41153,41172,41173,41182,41190,41202,41200,41210,41220,1373,2718,2776,2778,9125,36326,36379,36414,36398,36433,36440,36452,36534,36574,36692,36693,36717,36750,36791,36816,36912,36928,36935,36951,36979,36980,36981,37002,37003,37010,37014,37034,37058,37056,37061,37063,37087,37096,37108,37123,37144,37145,37152,37223,37232,37266,37263,37286,37303,37300,37323,37333,37351,37366,37391,37408,37433,37477,37487,37509,37515,37559,37580,37609,37612,37636,37638,37654,37670,37673,37677,37688,37701,37706,37712,37719,37723,37764,37765,37768,37769,37787,37799,37819,37844,37863,37866,37888,37894,37897,37926,37978,37979,38016,38017,38032,38045,38079,38133,38135,38161,38164,38183,38185,38186,38188,38193,38204,38217,38219,38265,38268,38273,38292,38316,38321,38338,38349,38352,38361,38372,38369,38385,38389,38394,38412,38423,38428,38458,38464,38477,38491,38500,38520,38527,38567,38592,38595,38611,38632,38697,38734,38739,38740,38757,38771,38808,38810,38856,38865,38882,38889,38891,38895,38912,38937,38940,38942,38949,38970,39000,38983,39036,39061,39070,39105,39152,39158,39233,39234,39243,39238,39242,39248,39280,39281,39282,39289,39294,39342,39343,39346,39349,39359,39360,39367,39374,39375,39379,39383,39386,39388,39391,39401,39410,39414,39415,39420,39425,39460,39463,39469,39467,39479,39499,39508,39511,39514,39518,39524,39525,39530,39552,39561,39564,39590,39593,39594,39595,39600,39612,39624,39631,39633,39635,39636,39641,39669,39685,39711,39715,39718,39731,39739,39741,39737,39777,39803,39806,39810,39814,39817,39821,39823,39830,39835,39850,39851,39852,39855,39856,39862,39865,39866,39870,39874,39875,39895,39899,39914,39920,39934,39936,39939,39944,39946,39949,39950,39952,39960,39967,39989,39994,39995,39997,39998,39999,40002,40003,40004,40005,40016,40017,40018,40020,40021,40024,40040,40043,40049,40055,40056,40065,40066,40068,40078,40081,40093,40101,40104,40113,40125,40130,40135,40136,40149,40157,40158,40164,40168,40207,40208,40222,40224,40230,40240,40245,40244,40249,40250,40260,40268,40269,40270,40271,40276,40279,40282,40303,40304,40310,40311,40312,40313,40316,40320,40330,40333,40344,40353,40355,40365,40374,40396,40397,40412,40413,40414,40416,40432,40437,40443,40447,40457,40463,40471,40472,40473,40488,40493,40495,40499,40502,40505,40508,40514,40518,40519,40520,40532,40533,40534,40551,40553,40558,40569,40574,40577,40591,40592,40594,40598,40603,40614,40618,40623,40624,40627,40650,40651,40654,40679,40689,40693,40694,40703,40704,40706,40715,40716,40717,40718,40726,40738,40749,40754,40755,40756,40757,40758,40759,40762,40763,40764,40765,40771,40780,40799,40801,40803,40805,40807,40809,40811,40816,40818,40825,40829,40834,40839,40844,40848,40880,40886,40891,40899,40905,40906,40907,40924,40927,40929,40936,40956,40957,40960,40968,40972,40976,40988,40989,40993,40997,40999,41008,41025,41027,41029,41033,41037,41063,41066,41078,41088,41097,41122,41127,41128,41133,41136,41138,41146,41156,41163,41171,41177,41180,41185,41187,41189,41191,41201,41214,41218,41219,1618,2233,2556,2607,2987,3135,3142,5056,5426,5552,5622,6294,6659,8776,9224,10553,10632,14311,16011,17452,30984,31928,35708,35859,35913,35944,36271,36380,36575,37000,37101,37282,37403,37457,37498,38006,38308,38515,38518,38958,39257,39396,39954,40729,41017,2790,6436,36509,36694,36731,38962,40029,41026,41056,3522,4870,12105,12549,16879,28375,36019,36279,36549,36725,38025,38367,39945,41095,8764,17053,37040,37044,37037,37080,37127,37215,37595,37610,38533,38982,39691,39694,40124,40648,40950,10151,36289,36673,40171,40236,40513,36310,36914,37516,37876,38071,38330,38467,38481,38535,38666,38699,38995,39470,39828,40390,40503,41059,41176,40099,41035,38557)
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 | 179 | 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 |