Tiempo de la consulta: 5.77 ms Después de la última consulta: 2.93 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-20 23:23:02' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-02-20 23:23:02' )
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 (85,1063,1596,1680,3306,3853,4365,4449,4563,5182,5830,6707,10047,10125,26981,29889,30279,32235,35784,35817,35857,35906,35970,35981,36071,36141,36418,36559,36591,37274,37307,37320,37514,37516,37525,37528,37533,37565,37599,37655,37784,37797,37893,37924,37950,37984,37991,38006,38022,38376,38498,38555,38569,38591,38631,38680,38769,38795,38806,38822,38853,38907,38922,38935,38941,38952,38961,38998,39119,39117,39167,39216,39288,39418,39426,39468,39490,39498,39517,39612,39661,39689,39695,39700,39760,39790,39796,39816,39876,39929,39961,40100,40127,40157,40241,40369,40483,40496,40520,40551,40567,40680,40682,40686,40703,40724,40761,40765,40779,40807,40818,40837,40838,40922,40999,41014,41056,41075,41096,41117,41181,41215,41237,41255,41294,41346,41353,41367,41368,41390,41396,41433,41448,41515,41531,41539,41566,41633,41669,41701,41730,41789,41792,41809,41933,41961,41962,41975,42007,42039,42044,42049,42064,42111,42115,42119,42154,42161,42195,42204,42224,42241,42248,42272,42278,42286,42319,42341,42343,42346,42399,42413,42424,42425,42428,42433,42454,42457,42459,42467,42485,42497,42549,42556,853,891,939,951,957,981,1040,1049,1220,1256,1233,1384,1451,1600,1681,1700,1707,1720,1757,1810,1847,1862,1883,1892,1942,1970,2137,2316,2429,2450,2468,2494,2512,2515,2524,2535,2544,2558,2560,2690,2711,2716,2770,3032,3158,3296,3343,3345,3390,3455,3662,4070,4079,4126,4383,4500,4761,4843,4854,4902,4969,4986,5026,5212,5512,5698,5704,6053,6657,7403,7571,7598,7656,7961,8455,8586,8632,8712,9141,9408,9585,9850,10180,10478,10651,10652,11228,12771,12795,13095,13267,13539,13740,14619,14665,15046,15382,15482,15851,16488,16490,16496,16561,17165,17511,17754,17765,18289,19252,19970,20146,20329,20469,21624,21814,21967,23124,23855,25432,26583,26831,26869,27165,27180,27200,27445,27586,28114,30628,30795,32401,33071,33409,33800,34565,34662,35726,35847,36209,36307,36771,36802,36962,37066,37150,37202,37203,37224,37242,37277,37289,37294,37316,37317,37354,37353,37369,37394,37399,37410,37426,37429,37447,37473,37475,37513,37519,37549,37585,37617,37618,37641,37703,37725,37773,37774,37847,37848,37873,37920,38033,38044,38047,38053,38081,38118,38129,38136,38165,38168,38172,38199,38209,38225,38238,38264,38270,38275,38302,38306,38315,38337,38355,38370,38385,38391,38393,38399,38398,38418,38465,38486,38489,38504,38511,38539,38606,38610,38637,38646,38658,38672,38695,38700,38710,38726,38732,38737,38742,38758,38762,38783,38787,38793,38813,38872,38876,38887,38892,38911,38919,38938,38960,39001,39008,39031,39075,39079,39108,39166,39175,39173,39197,39202,39215,39217,39224,39248,39264,39279,39289,39297,39315,39322,39326,39316,39353,39381,39384,39393,39424,39452,39454,39492,39568,39572,39626,39628,39650,39720,39730,39781,39794,39805,39839,39840,39841,39894,39908,39966,39970,40069,40070,40087,40108,40133,40134,40221,40238,40283,40312,40360,40448,40526,40528,40570,40575,40583,40610,40611,40652,40658,40691,40787,40814,40845,40885,40914,40967,41038,41041,41057,41068,41071,41104,41132,41174,41230,41264,41287,41295,41321,41359,41362,41365,41408,41442,41508,41695,41726,41747,41758,41816,41831,41918,41957,42034,42062,42074,42080,42102,42144,42170,42244,42325,42326,42345,42402,42449,42479,42499,42511,42555,885,990,987,1035,1123,1190,1199,1301,1311,1643,2028,2122,2390,2698,2724,2757,2932,2938,2986,3308,3409,3461,3501,3525,3527,3732,4069,4094,4100,4677,5090,5100,5346,5798,6109,6154,6205,6212,6704,6866,7016,7377,7463,7594,7640,7693,10682,11244,11325,11585,15614,31276,38915,39558,39586,39589,39605,39608,39613,39675,39683,39696,39712,39797,39809,39843,39848,39882,39900,39921,39939,39947,39990,39993,40028,40035,40089,40114,40120,40149,40161,40174,40203,40231,40245,40252,40267,40290,40300,40306,40386,40390,40456,40464,40476,40481,40504,40509,40530,40544,40550,40589,40614,40641,40660,40665,40678,40687,40702,40712,40746,40760,40794,40810,40831,40847,40848,40849,40851,40858,40879,40887,40889,40911,40920,40925,40938,40946,40954,40983,41064,41086,41089,41100,41109,41110,41118,41128,41130,41177,41178,41182,41188,41193,41195,41292,41298,41305,41318,41324,41385,41402,41437,41458,41471,41479,41487,41517,41551,41572,41618,41623,41644,41672,41693,41696,41704,41722,41725,41738,41746,41760,41765,41811,41824,41826,41842,41865,41869,41880,41890,41926,41972,42002,42014,42018,42023,42055,42085,42096,42131,42188,42213,42216,42220,42227,42237,42263,42277,42293,42312,42338,42352,42358,42363,42365,42391,42406,42444,42484,1181,2285,2289,2348,2374,2714,2790,3510,3537,3545,3687,3928,3935,4212,4919,4981,5028,11577,25740,40581,40815,41079,41217,41857,1445,2973,5861,10172,10959,17863,35911,36118,36568,36580,36662,37092,37209,37793,38137,38372,38369,38389,38480,38708,39332,39654,40001,40045,40179,40314,40377,40453,40582,40783,41017,41530,41576,41627,41643,41679,41691,42331,1512,1823,5347,5747,5876,10151,14609,14654,16545,25666,25944,26313,26329,28807,28818,28824,28837,29178,29354,29386,29500,30883,30931,31947,31978,33354,34381,36897,37396,37986,38091,38130,38189,40033,40058,40546,40640,7637,27123,2785,3031,6421,14352,31428,35982,36146,36280,37060,37098,37361,38269,38594,39456,39610,39621,39666,40076,40376,40439,40576,40626,40666,41090,41342,41441,41447,41675,41680,41697,41703,41723,41833,42001,42229,42235,42332,42491,5513,6379,39413,7977,8192,10245,30009,36488,37359,37869,38499,39016,39359,39433,39789,39903,40825,41011,41183,41198,41702,41823,41840,41862,42211,42257,42283,42323,42536,8504,37881,16032,27142,37091,37348,37488,40320,41504,42296,42360,42443,36667,36880,40409,41224)
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 | 305 | 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.59 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.00 ms |
| After table lock | 0.01 ms |
| init | 0.29 ms |
| optimizing | 0.21 ms |
| statistics | 1.84 ms |
| preparing | 1.56 ms |
| executing | 0.03 ms |
| Sorting result | 0.01 ms |
| Sending data | 1.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 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 |