Tiempo de la consulta: 5.68 ms Después de la última consulta: 2.67 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-26 21:29:46' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-26 21:29:46' )
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,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,871,2823,3304,4192,36366,36372,36371,36397,36411,36412,36446,36454,36456,36475,36455,36546,36562,36563,36564,36565,36561,36547,36604,36606,36618,36608,36638,36650,36651,36653,36659,36660,36661,36669,36670,36690,36691,36705,36706,36715,36733,36734,36743,36744,36752,36753,36754,36751,36778,36793,36829,36842,36843,36849,36854,36903,36904,36905,36906,36926,36925,36927,36953,36955,36982,36983,36984,36986,37004,37035,37036,37038,37039,37040,37049,37059,37069,37070,37073,37076,37094,37118,37147,37148,37195,37199,37201,37207,37213,37236,37237,37240,37275,37276,37283,37302,37304,37331,37359,37361,37362,37365,37373,37377,37434,37445,37486,37490,37502,37518,37530,37533,37556,37575,37583,37587,37594,37608,37610,37615,37634,37635,37637,37650,37656,37665,37667,37671,37675,37680,37683,37684,37699,37702,37707,37720,37721,37724,37757,37758,37766,37770,37803,37804,37805,37806,37807,37808,37824,37825,37827,37837,37839,37845,37864,37867,37886,37891,37901,37903,37932,37933,37934,37936,37938,37951,37954,37974,37976,37977,38008,38029,38031,38050,38052,38060,38067,38078,38087,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,38243,38266,38271,38286,38287,38290,38293,38299,38304,38319,38322,38326,38329,38332,38334,38345,38347,38350,38354,38359,38365,38367,38371,38383,38388,38392,38397,38408,38417,38419,38420,38426,38455,38461,38475,38478,38481,38487,38502,38499,38512,38519,38526,38528,38531,38533,38535,38556,38558,38568,38571,38576,38593,38589,38597,38601,38604,38615,38629,38631,38636,38644,38645,38651,38656,38660,38676,38681,38684,38688,38698,38701,38708,38716,38723,38733,38735,38745,38765,38767,38773,38777,38788,38791,38795,38805,38811,38820,38830,38867,38869,38875,38885,38903,38917,38918,38922,38969,38980,38987,39002,39032,39034,39073,39074,39076,39082,39083,39084,39122,39131,39154,39181,39183,39185,39190,39212,39213,39214,39216,39219,39239,39265,39291,39295,39296,39298,39317,39345,39361,39365,39380,39403,39442,39451,39466,39475,39486,39510,39519,39522,39527,39531,39532,39551,39569,39571,39591,39619,39625,39638,39653,39655,39679,39684,39688,39717,39760,39766,39775,39814,39824,39832,39838,39850,39871,39883,39890,39905,39917,39926,39927,39937,39945,39947,40006,40008,40009,40041,40044,40051,40100,40115,40201,40235,40247,40263,40301,40336,40380,40384,40407,40460,40477,40480,40490,40500,40525,40538,40542,40543,40572,40573,40587,40616,40640,40645,39235,40655,40656,40657,40673,40682,40692,40698,40705,40719,40728,40744,40753,40761,40775,40785,40790,40824,40837,40844,40895,40917,40922,40961,41009,41015,41044,41059,41076,41081,41087,41090,41095,41101,41102,41114,41116,41117,41141,1068,1132,1528,1657,1848,2552,4072,5010,5231,5937,6379,7994,8183,8322,9923,10233,10452,10500,10916,10986,11767,11803,12052,12697,14162,14838,15114,15236,15423,17604,18251,18475,20174,20731,26897,27014,28195,31036,32606,34897,37060,37270,37352,37368,37529,37716,37982,37986,38054,38273,38298,38380,38427,38518,38806,38822,38824,38850,38953,39001,39215,39356,39406,39408,39722,39735,39773,39936,39950,40054,40066,40097,40287,40369,40469,40504,40678,40718,40881,40936,1317,1782,2083,2097,2230,2392,2444,2526,2706,2741,2783,3271,3571,5327,5329,6380,9763,11108,11154,13153,15613,21418,25546,34658,35982,36146,36405,36470,36497,36549,36671,36677,37091,37175,37390,37461,37682,37832,37900,38168,38216,38467,38523,38532,38686,38954,38984,39024,39157,39202,39279,39337,39446,39481,39670,39689,39828,39843,39849,39870,39876,39877,39897,39992,40002,40094,40377,40415,40536,40541,40527,40576,40700,40814,40822,40911,41040,1920,2057,2414,2704,3016,3041,3583,3664,4131,4498,5089,5704,8351,10975,35715,35911,35925,36384,36484,36502,36535,36580,36645,36884,36907,36916,37084,37293,37428,37436,37520,37790,37793,38013,38112,38137,38170,38479,38632,39358,39395,39589,39613,39651,39676,39685,39692,39713,39789,39990,40004,40154,40220,40224,40246,40306,40354,40362,40432,40453,40532,40598,40604,40654,40665,40666,40795,40817,40818,40851,40920,40925,41023,1941,2658,3315,4834,11496,35716,36122,36304,36476,37029,37500,37649,37678,37762,38496,38538,38569,38570,38578,38817,38999,39065,39244,39270,39283,39448,39496,39560,39570,39658,39724,39867,39884,40272,40274,40299,40393,40459,40468,40471,40602,40620,40659,40683,40725,40729,40784,40797,40950,41020,2007,2500,2596,2631,2864,2954,3414,3443,4381,4833,4868,5710,6070,6141,6543,6704,6983,7572,8161,8274,8367,8629,8650,11026,14879,38577,38659,38672,38720,38743,38929,38958,39108,39126,39197,39217,39248,39267,39323,39326,39384,39424,39429,39513,39572,39726,39780,39781,40081,40133,40134,40207,40240,40283,40355,40357,40360,40448,40491,40526,40557,40570,40583,40608,40658,40787,40845,40855,40941,40976,41008,41038,41086,2028,2848,3301,3855,5614,5746,9237,10030,36695,36798,36825,36859,36909,38247,38321,38361,38493,38517,39599,40158,40161,40333,40411,40457,40475,40942,41125,2239,2250,2787,2807,2858,2946,3129,3142,3479,3847,4157,4628,4670,4685,4717,5064,5239,5523,5608,6077,7103,7221,7274,7359,9256,9331,11250,12726,12752,13431,16015,16876,34040,34399,35597,35848,36200,36273,36285,36409,36644,36758,36930,36936,37159,37166,37309,37332,37427,37464,37503,37591,37595,37647,37685,37700,37799,37927,38308,38336,38379,38415,38422,38431,38462,38485,38529,38572,38573,38579,38605,38643,38666,38703,38714,38739,38741,38756,38855,38896,38914,38926,38979,38990,39019,39128,39179,39362,39366,39489,39517,39596,39616,39650,39660,39696,39698,39703,39723,39734,39740,39816,39863,39864,39879,39913,39928,39988,40015,40059,40076,40122,40125,40166,40174,40210,40222,40223,40236,40386,40441,40473,40478,40484,40497,40510,40522,40530,40589,40596,40601,40606,40615,40644,40669,40671,40702,40734,40746,40748,40791,40800,40826,40827,40854,40883,40900,40907,40912,40918,40979,40983,41027,41083,41135,2804,3272,36417,36437,36438,36444,36457,36611,36756,36762,36913,36987,37011,37123,37221,37239,37245,37248,37273,37287,37286,37442,37470,37527,37688,37711,37767,37875,37877,37899,37964,37983,38007,38144,38182,38183,38188,38189,38296,38306,38325,38433,38483,38527,38611,38612,38668,38671,38774,38784,38821,38857,38868,38871,38902,38959,38962,38970,38983,39115,39177,39187,39249,39255,39369,39372,39467,39521,39523,39528,39533,39562,39595,39617,39618,39665,39719,39733,39798,39819,39845,39898,39924,39925,39958,40074,40101,40102,40113,40132,40165,40170,40206,40252,40325,40326,40387,40401,40467,40498,40575,40687,40716,40777,40778,40893,40894,40898,40921,40934,40953,40974,40990,41007,41022,41031,41103,41118,5748,36582,36602,36605,36966,37935,38171,38541,38807,40244,40312,40888,40931,40985,6493,37214,40405,19469,25623,30954,31101,31109,31130,31147,35714,35819,35827,35860,35866,35891,35892,35908,35902,35946,35963,35965,35968,35994,36082,36083,36100,36106,36119,36127,36193,36242,36244,36249,36302,36303,36443,36485,36537,36577,36716,36792,36804,36848,37110,37246,37265,37467,37499,37508,37902,38090,39331,39769,36057,36598)
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 | 122 | 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 | 0.52 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.00 ms |
| After table lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| After table lock | 0.11 ms |
| init | 0.33 ms |
| optimizing | 0.18 ms |
| statistics | 1.68 ms |
| preparing | 1.53 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.89 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.09 ms |
| end | 0.06 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.00 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 |