Tiempo de la consulta: 80.39 ms Después de la última consulta: 1.08 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 <= '2024-11-22 18:36:00' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-22 18:36:00' )
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 (853,879,892,1017,1080,1123,1228,1327,1400,1431,1435,1439,1608,1659,1699,1893,2010,2027,2031,2122,2183,2155,2271,2371,2437,2558,2940,3048,3121,3348,3363,3367,3455,3458,3520,3663,3692,3699,3752,3933,4024,4093,4101,4151,4196,4244,4216,4275,4366,4412,4358,4462,4463,4436,4519,4551,4576,4597,4639,4665,4690,4806,4846,4872,5016,5228,5257,5272,5276,5319,5320,5359,5363,5394,5404,5449,5463,5465,5482,5507,5533,5501,5594,5752,5807,5811,5837,5842,5915,5992,6193,6280,6418,6430,6607,6635,6782,6799,6834,6870,6886,6954,6994,7002,7016,7038,7045,7134,7251,7258,7418,7452,7601,7680,7711,7833,7890,8058,8209,8253,8270,8298,8396,8626,8646,8687,8610,8777,8902,8906,9110,9382,9354,9670,9956,9967,9996,10051,10207,10245,10212,10465,10517,10606,10935,10977,11097,11256,11409,11421,11447,11487,11635,11739,11753,11788,11831,11887,11889,11990,11992,12047,12105,12191,12230,12236,12249,12314,12444,12516,12539,12639,12836,12949,12998,13240,13344,13565,14042,14289,14557,14660,14794,14821,14848,14861,14882,14932,15002,15042,15086,15202,15562,15641,15705,15756,15767,15799,15955,15963,16016,16049,16078,16337,16405,16413,16425,16467,16586,16765,17262,17381,17404,17582,17729,17933,18059,18239,18717,19147,19197,19424,19426,19445,19549,19585,19746,20009,20500,20768,21421,21620,21631,21702,21914,22037,22101,22121,22349,22865,23485,23523,23772,23783,24577,24829,24870,24977,25023,25051,25413,25569,26073,26193,26628,26700,26715,26831,26894,26946,27211,27673,27837,28441,29308,29752,29755,29803,30147,30767,31020,31261,31298,31699,31967,31971,31976,31984,32085,32148,32357,32556,32571,32889,854,855,868,990,1005,1020,1022,1039,1060,1081,1125,1170,1172,1183,1221,1243,1223,1330,1394,1469,1498,1552,1553,1577,1586,1663,1682,1788,1793,1797,1821,1853,1869,1888,1914,1956,1959,1961,1982,1996,1998,2053,2059,2070,2156,2164,2171,2205,2228,2332,2346,2374,2391,2395,2513,2547,2562,2634,2691,2713,2714,2782,2790,2804,2876,2880,2883,2906,2907,2931,2932,2949,2951,2962,2987,3011,3014,3034,3047,3050,3077,3084,3128,3160,3185,3191,3221,3240,3251,3268,3281,3293,3294,3302,3303,3311,3349,3374,3382,3394,3413,3464,3470,3472,3510,3524,3538,3618,3631,3646,3667,3676,3736,3884,3907,3928,3935,3965,3969,3992,4004,4085,4113,4115,4117,4123,4128,4146,4165,4166,4224,4255,4268,4284,4369,4371,4433,4450,4477,4598,4656,4664,4673,4726,4730,4739,4816,4827,4851,4880,4881,4884,4891,4924,4926,4927,4939,4943,4944,4946,4959,4919,4970,4978,4980,4990,5025,5062,5080,5083,5125,5129,5130,5148,5149,5156,5147,5193,5199,5222,5229,5235,5234,5269,5271,5284,5290,5291,5321,5331,5335,5346,5348,5352,5358,5446,5551,5564,5574,5578,5606,5633,5687,5689,5700,5701,5727,5750,5787,5821,5835,5836,5902,5928,5935,5940,5949,5989,6042,6051,6082,6090,6095,6096,6109,6126,6133,6134,6192,6240,6255,6372,6385,6407,6419,6424,6442,6520,6525,6540,6553,6587,6601,6628,6640,6654,6656,6680,6694,6704,6705,6724,6739,6797,6815,6818,6823,6869,6885,6916,6930,6955,6979,6995,7114,7133,7135,7136,7149,7190,7202,7236,7312,7313,7366,7367,7380,7388,7389,7453,7469,7513,7519,7538,7661,7681,7710,7714,7812,7903,7924,8028,8173,8186,8257,8290,8323,8328,8345,8365,8379,8444,8627,8645,8684,8703,8728,8782,8830,8841,8866,9001,9161,9186,9286,9300,9365,9394,9485,9590,9600,9601,9656,9826,9891,10006,10220,10244,10246,10285,10287,10418,10492,10572,10826,11267,11307,11392,11467,11486,11503,11537,11543,11559,11636,11648,11824,11859,11888,11915,11998,12176,12206,12219,12263,12359,12367,12628,12674,12701,12863,12923,12989,13328,13513,13820,13995,14045,14050,14062,14139,14524,14819,14862,14944,14949,15195,15244,15427,16156,16219,16252,16406,16621,16645,16671,16884,17002,17208,17958,18174,21590,21811,22164,23821,23859,24017,24181,24729,24992,25585,25740,26090,27799,28277,29744,29909,30112,30316,30559,31216,4899,4981,5728,6166,6208,6212,6406,6415,6541,7115,7148,7209,7213,7297,7597,7695,7832,7917,8143,8242,8548,969,1085,1126,1329,2750,2891,2901,2968,3069,3117,3298,3384,3395,3471,3543,3600,3634,3668,3756,3856,3929,4316,4354,4550,4854,5079,5599,5623,5651,5900,6077,6253,6307,6326,6339,6425,6817,6836,6850,6871,6893,6924,6925,7015,7021,7026,7066,7226,7270,7360,7451,7529,7566,7611,7721,7722,7808,7822,7880,7904,7942,8119,8142,8188,8211,8227,8269,8322,8343,8349,8363,8364,8383,8443,8503,8586,8587,8679,8688,8712,8787,8793,8810,8819,8842,8854,8965,8982,9020,9082,9124,9138,9143,9191,9206,9223,9241,9263,9284,9298,9316,9328,9357,9366,9426,9452,9465,9614,9617,9625,9645,9647,9648,9654,9669,9717,9738,9747,9783,9800,9801,9870,9915,9963,10019,10083,10127,10231,10259,10306,10359,10410,10436,10458,10475,10508,10546,10549,10576,10590,10657,10661,10673,10686,10690,10692,10760,10815,10827,10836,10874,10955,10966,10984,11030,11134,11136,11153,11181,11210,11215,11217,11233,11250,11255,11280,11283,11302,11320,11322,11340,11353,11366,11373,11396,11442,11474,11508,11558,11565,11610,11669,11720,11725,11737,11738,11744,11751,11755,11752,11769,11770,11771,11795,11806,11809,11843,11853,11857,11901,11982,12014,12035,12051,12119,12129,12148,12186,12203,12225,12231,12238,12239,12272,12381,12392,12396,12398,12427,12470,12475,12541,12620,12672,12697,12702,12717,12772,12792,12832,12835,12915,12925,12946,12974,12975,13009,13012,13013,13033,13038,13076,13112,13124,13126,13131,13145,13146,13223,13378,13393,13413,13438,13474,13494,13503,13504,13505,13621,13624,13645,13682,13683,13689,13706,13766,13792,13803,13810,13843,13854,13917,14002,14010,14018,14054,14108,14115,14157,14197,14211,14231,14248,14290,14301,14304,14310,14321,14339,14348,14349,14431,14452,14488,14497,14512,14529,14536,14541,14558,14568,14580,14585,14589,14590,14614,14615,14616,14646,14665,14676,14718,14790,14877,14896,14897,14916,14948,14964,15006,15029,15052,15070,15074,15076,15089,15118,15134,15168,15224,15239,15274,15301,15318,15347,15365,15374,15386,15399,15504,15517,15535,15536,15547,15571,15605,15655,15682,15693,15717,15733,15735,15747,15761,15790,15839,15862,15869,15895,15896,15897,15924,16040,16050,16061,16072,16109,16122,16167,16187,16223,16230,16263,16280,16289,16290,16305,16322,16326,16327,16350,16351,16353,16366,16367,16373,16423,16454,16461,16468,16474,16498,16499,16517,16530,16535,16536,16550,16555,16569,16570,16592,16605,16625,16633,16646,16706,16708,16748,16814,16823,16885,16893,16907,16938,16970,16977,16984,16990,17011,17052,17060,17086,17095,17154,17183,17196,17204,17205,17223,17261,17285,17290,17291,17295,17299,17332,17364,17395,17433,17445,17596,17653,17662,17670,17685,17758,17801,17882,17889,17903,17906,17918,17949,17953,17955,17957,18102,18129,18237,18266,18292,18449,18460,18472,18484,18498,18508,18519,18529,18555,18595,18609,18756,18773,18802,18804,18810,18843,18877,18891,18897,18919,18935,18952,18967,18973,18997,19008,19130,19180,19218,19330,19418,19491,19513,19689,19731,19756,19812,19845,19906,20039,20057,20093,20102,20150,20177,20195,20245,20306,20347,20363,20414,20436,20442,20463,20542,20544,20554,20579,20622,20633,20636,20646,20665,20666,20688,20696,20707,20723,20823,20834,20894,20897,20925,20933,21000,21020,21099,21100,21113,21152,21310,21320,21482,21588,21624,21669,21674,21706,21862,21876,21882,21932,21960,22132,22190,22365,22438,22439,22457,22459,22494,22534,22574,22601,22689,22707,22715,22750,22754,22755,22770,22771,22783,22788,22802,22826,22828,22832,22853,22979,23137,23193,23303,23474,23793,23849,24267,24291,24318,24331,24341,24419,24420,24475,24486,24531,24584,24638,24741,24774,24785,24805,24893,25268,25293,25464,25672,26070,26074,26118,27024,28806,29097,29157,30694,30695,31017,1257,1299,1578,2366,2426,2882,2939,2963,2969,3142,3201,3392,3469,3619,3712,3723,3725,3870,3887,4030,4057,4070,4079,4160,4217,4240,4410,4538,4548,4558,4604,4745,4869,4948,5009,5028,5029,5072,5086,5100,5126,5172,5176,5187,5194,5186,5209,5214,5244,5248,5253,5274,5267,5279,5285,5289,5306,5336,5434,5443,5475,5531,5625,5629,5632,5667,5671,5675,5678,5711,5722,5768,5781,5799,5800,5813,5868,5874,5908,5921,5931,5952,6036,6070,6072,6178,6237,6286,6287,6376,6386,6432,6449,6497,6547,6634,6647,6675,6686,6814,6948,7035,7096,7102,7173,7424,7463,7470,7493,7507,7533,7531,7589,7606,7647,7670,7706,7707,7737,7766,7888,7982,7996,8006,8008,8038,8051,8235,8280,8356,8390,8398,8436,8496,8552,8557,8565,8568,8611,8619,8603,8732,8767,8792,8809,8861,8903,8932,9183,9193,9271,9395,9425,9459,9471,9498,9510,9567,9578,9582,9602,9606,9610,9705,9715,9728,9769,9798,9892,9952,10052,10055,10082,10098,10292,10329,10524,10769,10881,10963,10970,10978,11070,11182,11213,11220,11261,11275,11306,11354,11419,11477,11478,11539,11540,11544,11573,11577,11585,11612,11621,11647,11672,11677,11773,11782,11864,11870,11944,12018,12159,12162,12262,12350,12356,12556,12589,12649,12650,12706,12708,12718,12756,12967,13044,13105,13532,13534,13737,13991,14066,14090,14110,14214,14471,14662,14703,15016,15120,15204,15268,15656,15728,15753,16100,16338,16543,16619,17081,17303,17329,17338,17448,17450,17502,17503,17543,17556,17665,17684,17890,17929,18014,18148,18153,18537,18734,19060,19203,19318,19372,19420,19522,19671,19811,19855,19890,19929,20073,20375,20551,20555,21838,23491,23626,23739,23744,24104,24120,24122,24132,24246,24652,24764,24936,25190,25925,25993,26024,26121,26149,26249,26352,26408,26699,27129,27857,27989,28018,28389,28428,28762,28776,28813,28867,28916,29337,29372,29399,29623,29633,29675,29676,29855,29982,30183,30259,30483,30645,31217,31565,31662,31758,32846,32971,33018,1526,1777,3310,4116,4129,5018,5246,6019,6681,6711,6862,6894,6950,6980,7349,7358,7539,7543,7574,7607)
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 | 118 | 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 |