Tiempo de la consulta: 11.02 ms Después de la última consulta: 2.74 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-03-07 04:30:28' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-03-07 04:30:28' )
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 (889,36817,37961,38603,38614,39006,39064,39355,39501,40085,40278,40446,40561,41380,41394,41646,41848,42131,42589,958,1383,1400,1430,1645,3051,3080,3366,3769,3913,3993,4549,4640,4838,5435,5991,7033,7731,8018,8265,9978,10082,11945,12495,13458,13806,16501,18387,30519,35972,37524,38054,38244,38295,38308,38574,38605,39030,39118,39273,39324,39343,39375,39397,39408,39530,39614,39633,39680,39779,39834,39837,39892,39922,40018,40077,40099,40295,40298,40341,40342,40377,40411,40459,40512,40543,40642,40700,40906,40923,40932,41373,41677,41857,42246,42572,42799,42840,1057,1356,1480,1573,2142,2160,2183,2552,2559,2696,3682,3689,3694,3924,3938,4266,4323,4868,4911,4972,6005,6008,6086,6230,6362,7659,9048,9417,10452,11302,11569,11811,13046,14240,16711,18370,27049,30610,33466,33612,35704,35821,35831,36176,36225,36454,36460,37057,37350,37398,37468,37861,37885,38186,38741,38829,38932,38963,38997,39272,39322,39416,39497,39524,39558,39583,39632,39639,39875,39898,39904,39938,40002,40074,40163,40170,40802,40889,40916,40942,41471,41560,42040,42067,42193,42207,42240,42255,42322,42477,42495,42845,42880,42944,1074,3990,6111,36470,36487,37680,37710,37869,37892,37955,38298,38815,38896,39282,39670,40162,40693,42162,42340,42520,42567,42677,42698,42701,42753,42763,42809,42893,42913,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,36497,36549,36671,36677,36955,37091,37175,37270,37352,37368,37390,37461,37529,37682,37832,37900,37974,38168,38216,38273,38467,38518,38520,38526,38528,38523,38532,38686,38806,38822,38824,38953,38954,38984,39024,39157,39202,39279,39337,39356,39406,39446,39481,39689,39722,39735,39822,39828,39843,39849,39870,39876,39877,39897,39936,39950,39992,40054,40066,40094,40097,40287,40369,40415,40469,40541,40527,40576,40705,40718,40814,40822,40881,40911,40917,41040,41117,41300,41318,41342,41447,41448,41457,41496,41572,41723,41730,41784,41823,41840,41907,41957,41965,42075,42084,42094,42118,42250,42296,42316,42395,42406,42450,42536,42651,42659,42696,42721,42722,42746,42757,42762,42778,42894,42942,42945,1373,3041,3154,4543,6093,9693,10262,12571,35968,35981,36496,36548,36932,37107,37141,37337,37503,37623,37632,37684,38016,38059,38214,38367,38452,38477,38555,38648,38712,38747,38922,39570,39631,39654,39846,39894,39939,40089,40116,40154,40206,40259,40328,40483,40670,40696,40728,40795,40898,41183,41253,41368,41393,41433,41540,41569,41859,41889,41935,42007,42042,42052,42158,42235,42237,42241,42248,42286,42479,42593,42641,42652,42815,42875,42937,1473,1496,1600,2095,2171,2181,3397,3768,4030,4056,4154,4478,4488,5095,5188,5275,5286,5477,5728,5782,6520,6606,6759,6938,6968,7557,8149,8254,8568,9750,9782,10052,10133,10510,10796,11586,11853,14196,14351,15810,17287,21058,24413,27929,28128,28944,32928,33886,39086,40585,42710,1822,1937,2116,2196,2727,3950,4760,5271,5740,6766,6990,7334,7477,7889,8263,10942,11560,14065,36521,37239,37429,37644,37762,38116,38422,38559,38758,39184,39366,39701,39854,40134,40209,40268,40322,40432,40468,40481,40601,40609,40724,40918,40952,40980,41028,41089,41396,41504,41515,41576,41586,41645,41654,41805,41949,42001,42004,42058,42115,42135,42188,42281,42481,42507,42533,42666,42703,42800,42811,42838,1889,2493,2633,2705,2756,2896,2928,2953,3012,3207,3253,3308,4386,4850,5339,7186,10823,20518,30714,35726,35835,35853,36608,36656,36818,36900,36919,36939,36964,36967,36990,37344,37356,37492,37605,37610,37624,37652,37687,37761,37788,37946,37962,37972,38093,38095,38127,38205,38396,38402,38409,38420,38548,38552,38553,38571,38572,38573,38630,38639,38682,38792,38859,38870,38908,38946,38961,38967,38980,38983,39081,39107,39113,39128,39216,39232,39244,39327,39346,39392,39413,39417,39463,39468,39508,39607,39618,39621,39636,39641,39650,39666,39669,39683,39709,39721,39739,39744,39775,39814,39823,39831,39862,39864,39891,39932,39937,39948,39991,40076,40098,40104,40151,40201,40200,40315,40320,40325,40363,40394,40406,40413,40435,40457,40482,40495,40534,40551,40554,40567,40582,40594,40597,40625,40742,40765,40776,40783,40818,40831,40847,41002,41009,41027,41029,41043,41064,41075,41090,41099,41305,41322,41328,41377,41385,41387,41412,41437,41518,41530,41546,41550,41557,41561,41582,41595,41625,41642,41661,41674,41682,41697,41700,41737,41760,41790,41808,41815,41834,41842,41882,41930,42008,42053,42138,42167,42223,42247,42258,42279,42311,42318,42329,42354,42356,42414,42458,42466,42516,42519,42534,42530,42586,42647,42690,42760,42776,42779,42832,42847,42943,2495,11700,30629,34808,35713,35888,35895,36455,36530,36532,36575,36582,36703,36735,36802,36822,36849,36884,36944,36966,36994,37027,37070,37123,37148,37176,37312,37341,37467,37493,37499,37521,37692,37792,37936,37948,37985,38046,38058,38060,38145,38188,38211,38336,38373,38411,38414,38434,38453,38457,38480,38483,38497,38536,38541,38576,38719,38781,38798,38875,38936,39155,39231,39239,39399,39400,39404,39428,39601,39634,39653,39762,39791,39927,39946,39997,40008,40032,40064,40082,40084,40091,40117,40204,40294,40297,40323,40335,40379,40466,40548,40557,40659,40669,40683,40685,40719,40725,40750,40773,40782,40799,40804,40828,40894,41001,41126,41187,41383,41543,41825,41827,41852,41946,41997,42005,42125,42126,42127,42217,42252,42256,42323,42334,42358,42432,42464,42532,42537,42569,42592,42594,42661,42695,42702,42709,42755,42817,42823,42935,42936,2660,3078,6453,7733,8269,10419,37722,37987,38043,38213,38241,38309,38360,38358,38628,38921,39427,39596,39617,40021,40080,40136,40397,40603,40624,40656,40716,41349,41888,42161,42671,42714,42787,42931,2965,4374,11112,36471,37115,38162,38250,38274,38436,38485,38521,38542,38667,38674,38709,38780,38796,38807,38814,38858,38863,38884,38891,38901,38904,38928,38950,38965,38971,39015,39029,39039,39069,39071,39110,39179,39186,39221,39225,39240,39246,39261,39278,39320,39341,39348,39390,39396,39432,39477,39512,39553,39580,39586,39626,39630,39640,39649,39660,39681,39691,39716,39719,39726,39776,39794,39836,39869,39901,39906,39930,39919,39954,39955,39957,39961,40001,40022,40026,40047,40079,40083,40112,40123,40153,40175,40179,40211,40237,40246,40273,40319,40308,40326,40354,40371,40392,40395,40402,40433,40461,40501,40579,40600,40610,40676,40708,40733,40743,40751,40760,40772,40779,40794,40801,40821,40854,40912,40949,40970,40990,41017,41023,41033,41035,41067,41077,41098,41109,41177,41186,41196,41203,41230,41237,41281,41295,41301,41315,41343,41372,41405,41408,41439,41455,41485,41506,41574,41587,41614,41621,41635,41667,41681,41704,41710,41713,41725,41731,41734,41738,41746,41765,41768,41773,41810,41860,41893,41968,42017,42050,42078,42150,42191,42206,42209,42222,42231,42242,42254,42273,42315,42401,42419,42448,42514,42525,42553,42562,42607,42621,42644,42663,42715,42720,42835,42860,42892,42923,5464,6407,8951,9192,10688,13021,13624,15275,15581,15997,16206,16454,16461,16885,17272,18212,18218,18731,19704,20150,20166,20595,21669,21758,22396,22853,24863,25464,27211,27540,27787,31153,35331,37150,37292,37307,37308,37316,37329,37345,37379,37435,37472,37495,37525,37558,37589,37596,37602,37613,37614,37659,37772,37785,37802,37801,37843,37846,37848,37857,37895,37927,37931,37940,37960,38051,38080,38092,38113,38117,38180,38277,38324,38387,38462,38594,38641,38642,38861,38958,38989,39003,39035,39145,39250,40034,40583,41754)
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 | 199 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | admin_ddpue3.i.catid | 1 | Using where |
| Status | Duration |
|---|
| starting | 1.05 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 |
| init | 0.54 ms |
| optimizing | 0.38 ms |
| statistics | 3.24 ms |
| preparing | 2.91 ms |
| executing | 0.01 ms |
| Sorting result | 0.02 ms |
| Sending data | 2.43 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| updating status | 0.02 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 |