Tiempo de la consulta: 5.53 ms Después de la última consulta: 1.13 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-02-06 19:57:57' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-02-06 19:57:57' )
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,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,41341,41350,41357,41378,41383,41388,41401,41403,41406,41416,41419,41446,41453,41456,41462,41466,41479,41484,41494,41511,41538,41542,41543,41573,41612,41622,41627,41634,41637,41649,41650,41673,41676,41677,41707,41731,41741,41776,41779,41780,41786,41804,41840,41868,41873,41884,41929,41969,41973,42007,42043,42040,42049,42076,42079,42082,42084,42086,864,1840,2732,3678,3983,4267,4400,6078,6902,6965,7351,7516,8184,8355,8475,8565,8623,8802,8997,36556,36786,36883,38068,38090,38500,38739,38942,39281,39696,40104,40180,40244,40550,40614,40749,41577,41628,41633,1037,1074,1755,2703,6094,6688,6997,7938,39416,39468,40062,40527,40917,41554,41619,42053,1361,1507,1851,2249,2268,2275,2276,2359,2506,2656,2669,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,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,36602,36603,36604,36610,36613,36614,36605,36632,36633,36641,36669,36692,36719,36721,36737,36747,36750,36749,36785,36790,36791,36792,36813,36824,36844,36845,36846,36847,36881,36885,36905,36916,36927,36935,36951,36979,36980,36981,36988,37002,37003,37010,37014,37041,37058,37056,37061,37062,37074,37087,37101,37108,37144,37145,37152,37177,37206,37207,37223,37232,37249,37266,37263,37303,37300,37322,37323,37329,37333,37344,37356,37366,37391,37399,37398,37426,37433,37436,37477,37487,37494,37501,37508,37509,37515,37559,37580,37612,37622,37636,37654,37660,37670,37673,37677,37706,37713,37760,37765,37768,37772,37785,37787,37790,37796,37802,37844,37863,37866,37888,37926,37950,37952,37972,37978,38010,38016,38014,38022,38045,38047,38050,38054,38067,38086,38161,38164,38156,38174,38175,38193,38204,38209,38265,38268,38273,38293,38298,38318,38320,38316,38335,38338,38349,38352,38359,38361,38381,38385,38394,38411,38415,38423,38431,38458,38477,38491,38525,38539,38559,38557,38592,38632,38670,38678,38697,38706,38707,38709,38710,38727,38734,38757,38771,38815,38849,38888,38889,38895,38897,38912,38911,38922,38949,38969,39000,39036,39084,39105,39126,39154,39161,39185,39220,39238,39265,39275,39355,39359,39368,39374,39379,39397,39427,39436,39460,39466,39469,39467,39479,39518,39525,39527,39532,39589,39590,39610,39612,39613,39614,39635,39649,39651,39676,39677,39692,39704,39713,39715,39728,39733,39773,39776,39788,39800,39824,39835,39836,39851,39856,39866,39871,39872,39869,39885,39889,39914,39920,39921,39945,39952,39957,39960,39961,40003,40004,40005,40017,40029,40049,40050,40053,40078,40086,40120,40155,40158,40160,40168,40169,40182,40234,40252,40269,40275,40280,40295,40298,40299,40300,40304,40354,40357,40363,40365,40376,40404,40432,40443,40451,40461,40463,40472,40477,40481,40483,40496,40505,40508,40530,40532,40561,40558,40572,40601,40603,40624,40654,40660,40666,40687,40708,40715,40727,40738,40746,40762,40780,40794,40801,40810,40815,40816,40818,40823,40847,40848,40851,40855,40856,40857,40858,40880,40887,40888,40907,40931,40956,40984,40988,40993,40996,41003,41004,41009,41025,41029,41064,41084,41088,41096,41110,41116,41132,41143,41163,41171,41175,41185,41189,41195,41219,41246,41249,41252,41254,41282,41294,41317,41318,41319,41321,41328,41333,41340,41352,41353,41359,41365,41371,41372,41377,41380,41392,41409,41418,41421,41436,41444,41455,41486,41487,41508,41519,41522,41546,41547,41548,41552,41562,41569,41574,41578,41580,41581,41591,41593,41594,41623,41638,41643,41661,41664,41665,41672,41671,41674,41675,41692,41697,41704,41708,41711,41714,41721,41727,41734,41738,41744,41749,41756,41773,41784,41785,41809,41818,41819,41825,41829,41836,41847,41858,41872,41886,41899,41904,41914,41927,41932,41934,41939,41945,41953,41966,41968,41994,41997,42000,42024,42048,42062,42071,42077,42097,42100,42109,42112,42113,42114,42128,42139,42138,1497,3183,6915,10190,36452,36463,36523,36534,36574,36601,36693,36725,36939,37225,37561,37593,37979,38020,38032,38011,38079,38081,38084,38171,38185,38217,38292,38372,38412,38464,38686,38979,39040,39072,39435,39499,39561,39899,40905,41309,41394,41516,41565,41757,41857,41974,2122,3242,3241,3555,4340,4502,4603,4708,4724,4817,5081,5109,5142,5301,5329,6338,7030,9663,10145,10779,11315,11417,11462,13790,13820,17608,17953,24252,24646,24994,25029,25831,28635,29104,29953,30694,30695,30991,31180,31212,31795,32617,32941,34178,36013,36123,36241,36287,36826,38162,38891,2386,2604,3084,3321,3454,4120,4440,4885,4967,5663,6043,6504,6630,7007,8135,9183,10085,10590,11273,11444,12346,14668,35698,35833,35870,36016,36518,36664,36933,37090,37336,37591,37607,37794,38337,38420,38422,38427,38428,38463,38532,38552,38575,38612,38858,38955,39211,39222,39338,39388,39615,39681,39908,40022,40136,40306,40648,40747,40748,40754,40787,40899,40941,40990,41041,41112,41264,41432,41433,41524,41525,41686,41888,41889,41930,41967,42021,42035,42074,4484,6866,6923,7054,7494,9358,9890,30014,30213,30278,30525,30657,30815,30846,32603,32658,32819,33846,34127,34638,35296,35924,36037,36173,36284,36349,36365,36442,37179,37958,38927,39104,39151,39387,39712,41014,41177,8195,37632,39276,40154,40433,40670,41035,41237,41253,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 | 201 | 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.02 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.53 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.14 ms |
| init | 0.29 ms |
| optimizing | 0.18 ms |
| statistics | 1.60 ms |
| preparing | 1.31 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 1.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.07 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.01 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 |