Tiempo de la consulta: 20.04 ms Después de la última consulta: 1.09 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-25 08:47:00' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-25 08:47: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 (891,1080,1193,1195,1202,1266,1299,1396,1412,1473,1475,1537,1542,1560,1567,1578,1598,1616,1625,1681,1686,1696,1868,2120,2139,2343,2397,2424,2487,2638,2789,3075,3139,3231,3256,3263,3325,3386,3390,3402,3403,3486,3492,3538,3625,3659,3698,3704,3903,3943,3983,4058,4118,4147,4197,4213,4253,4279,4417,4534,4576,4594,4611,4614,4699,4702,4710,4721,4761,4821,4825,4915,4926,4954,4956,4968,5031,5045,5059,5069,5084,5100,5109,5166,5206,5281,5320,5378,5380,5435,5440,5464,5466,5482,5521,5524,5592,5638,5673,5693,5698,5709,5783,5789,5825,5876,5950,5996,6057,6108,6137,6231,6356,6400,6446,6462,6497,6623,6653,6693,6695,6711,6735,6783,6793,6866,6898,6942,6970,6973,7164,7226,7250,7257,7272,7314,7328,7338,7356,7379,7395,7408,7442,7444,7471,7486,7541,7567,7621,7692,7693,7701,7722,7752,7761,7771,7802,7892,7931,7971,8030,8031,8078,8156,8157,8185,8187,8190,8207,8242,8270,8285,8348,8468,8503,8570,8637,8710,8725,8778,8787,8817,8825,8835,8842,8858,8896,8909,8951,8962,8979,9053,9079,9099,9101,9192,9203,9236,9320,9345,9359,9364,9382,9473,9564,9571,9608,9645,9652,9684,9705,9758,9791,9804,9926,9960,9974,10050,10110,10188,10207,10387,10422,10425,10464,10499,10604,10610,10642,10688,10827,10845,10848,10918,11316,11389,11507,11715,11856,11892,11915,11943,12026,12106,12140,12143,12147,12188,12323,12328,12378,12416,12418,12423,12465,12530,12539,12564,12573,12604,12744,12822,12876,13021,13027,13036,13092,13315,13534,13544,13624,13756,13856,13978,14036,14525,14604,14638,14688,14708,15052,15149,15275,15280,15374,15380,15505,15581,15591,15604,15636,15895,15997,16195,16454,16460,16461,16618,16759,17382,17525,17537,17689,18212,18366,18446,18731,19100,19297,19336,19606,19767,19768,20354,20595,21656,22771,23741,24354,24627,24902,25154,25207,25306,25392,25375,25446,25489,25542,25885,26073,26126,26154,26304,26336,26367,26511,26661,26696,26711,26712,26729,26740,26760,26807,26916,26920,27105,27004,27173,27331,27363,27381,27770,27977,28540,28611,28640,28889,29139,29644,29752,29850,29868,30392,30464,30498,30569,31160,31163,31164,31227,31257,31380,31463,31606,31695,31733,32365,32754,32786,32853,32867,32993,33004,969,1085,1126,1329,2750,2876,2891,2901,2968,3069,3084,3117,3298,3384,3395,3413,3471,3543,3600,3631,3634,3667,3668,3756,3856,3929,3935,4128,4275,4316,4354,4550,4846,4854,4919,5079,5599,5623,5633,5651,5900,6077,6253,6307,6326,6339,6425,6607,6836,6850,6871,6893,6924,6925,6940,7015,7021,7026,7066,7270,7312,7360,7451,7452,7529,7566,7597,7611,7721,7808,7822,7880,7903,7904,7942,8119,8142,8188,8209,8211,8227,8269,8322,8343,8349,8363,8364,8383,8443,8586,8587,8679,8684,8688,8712,8793,8810,8819,8854,8965,8982,9001,9020,9082,9110,9124,9138,9143,9191,9206,9223,9241,9263,9284,9298,9316,9328,9357,9366,9426,9452,9465,9601,9614,9617,9625,9647,9648,9654,9669,9670,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,10826,10836,10874,10935,10955,10966,10984,11030,11097,11134,11136,11153,11181,11210,11215,11217,11233,11250,11255,11280,11283,11302,11320,11322,11340,11353,11366,11373,11396,11421,11442,11447,11474,11487,11508,11558,11565,11610,11635,11669,11720,11725,11737,11738,11739,11744,11751,11753,11755,11752,11769,11770,11771,11795,11806,11809,11843,11853,11857,11889,11901,11982,12014,12035,12051,12119,12129,12148,12186,12203,12225,12231,12236,12238,12239,12272,12314,12381,12392,12396,12398,12427,12444,12470,12475,12541,12620,12672,12697,12702,12717,12772,12792,12832,12835,12863,12915,12925,12946,12974,12975,12998,13009,13012,13013,13033,13038,13076,13112,13124,13126,13131,13145,13146,13223,13344,13378,13393,13413,13438,13474,13494,13503,13504,13505,13565,13621,13645,13682,13683,13689,13706,13766,13792,13803,13810,13820,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,14848,14861,14877,14896,14897,14916,14932,14948,14964,15006,15029,15042,15070,15074,15076,15086,15089,15118,15134,15168,15224,15239,15274,15301,15318,15347,15365,15386,15399,15504,15517,15535,15536,15547,15562,15571,15605,15641,15655,15682,15693,15705,15717,15733,15735,15747,15756,15761,15790,15799,15839,15862,15869,15896,15897,15924,16040,16049,16050,16061,16072,16109,16122,16167,16187,16223,16230,16263,16280,16289,16290,16305,16322,16326,16327,16350,16351,16353,16366,16367,16373,16405,16423,16467,16468,16474,16498,16499,16517,16530,16535,16536,16550,16555,16569,16570,16592,16605,16625,16633,16646,16671,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,18059,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,19197,19218,19330,19418,19491,19513,19689,19731,19756,19812,19845,19906,20009,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,20768,20823,20834,20894,20897,20925,20933,21000,21020,21099,21100,21113,21152,21310,21320,21482,21588,21620,21624,21669,21674,21702,21706,21862,21876,21882,21932,21960,22037,22121,22132,22190,22365,22438,22439,22457,22459,22494,22534,22574,22601,22689,22707,22715,22750,22754,22755,22770,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,1084,1237,1415,1577,1774,1956,2069,2112,2223,2757,2963,3076,3155,3525,3638,4046,4337,4412,4520,4597,4669,4673,4691,4768,4872,4977,5016,5028,5077,5135,5140,5193,5210,5245,5303,5405,5438,5475,5565,5663,5675,5819,5885,5886,5917,6341,6405,6536,6642,6663,6699,6704,6743,6895,6995,7170,7402,7513,7619,7640,7643,7769,7908,7959,8094,8253,8365,8379,8382,8557,8577,8612,8626,8640,8646,8660,8670,8721,8902,8932,9045,9493,10099,10285,10511,11295,11305,11321,11525,11529,11534,11608,11624,11636,11807,12131,12165,12425,12519,12556,12624,12649,12650,12673,12678,12782,12959,13007,13653,16334,17135,18535,18537,19296,19317,19318,19341,19372,19450,19615,19645,19729,19732,19745,19830,20455,20737,21621,21836,22254,22322,24863,25294,25396,25583,26117,26297,26352,26456,26464,26694,26699,26715,26776,26780,26806,26968,27704,27799,28408,29858,31174,31703,1327,2001,3430,6384,11194,12487,13244,13555,14804,17272,18657,19395,19464,19511,19531,19632,19905,19998,20000,20128,20171,20341,20476,20561,20565,20592,20675,20710,21195,21237,21752,22766,24390,24947,24963,24978,25038,25041,25248,25764,25783,25938,25988,27160,27178,27621,29032,29244,30041)
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 | 159 | 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 |