Tiempo de la consulta: 2.71 ms Después de la última consulta: 0.44 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-01-25 09:03:25' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-01-25 09:03:25' )
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 (851,863,908,1338,1539,2017,2148,2296,2365,2669,2787,2946,2966,3020,3309,3754,4498,5293,6261,6488,6542,7071,7224,7290,7688,8576,9063,9547,11192,12829,15857,26479,35401,35971,36016,36036,36261,36312,36416,36433,36461,36528,36582,36585,36755,36804,37015,37072,37097,37119,37129,37420,37458,37487,37595,37596,37613,37692,37713,37714,37760,37823,37829,37828,37888,38041,38157,38181,38190,38317,38359,38378,38379,38394,38411,38419,38420,38452,38457,38512,38552,38559,38591,38589,38643,38644,38676,38696,38809,38850,38856,38861,38863,38866,38882,38897,38900,38920,38927,38932,38941,38952,38963,38978,38984,39007,39018,39028,39042,39081,39107,39128,39162,39179,39191,39203,39218,39240,39246,39239,39265,39275,39295,39324,39360,39366,39373,39398,39478,39479,39495,39520,39564,39600,39613,39614,39641,39666,39669,39677,39696,39712,39744,39900,39901,39904,39921,39932,39936,39948,39951,39957,40001,40008,40041,40054,40098,40117,40186,40225,40237,40243,40258,40294,40301,40321,40361,40386,40406,40433,40437,40451,40452,40453,40473,40482,40496,40497,40500,40530,40533,40540,40573,40579,40581,40589,40601,40607,40630,40648,40649,40665,40668,40684,40712,40744,40750,40755,40760,40766,40782,40815,40836,40849,40851,40892,40897,40919,40937,40991,41015,41056,41054,41063,41070,41080,41098,41105,41113,41115,41123,41130,41135,41146,41164,41166,41175,41178,41182,41188,41189,41193,41214,41224,41238,41251,41253,41282,41294,41296,41299,41301,41304,41305,41339,41340,41351,41370,41396,41404,41411,41443,41467,41506,41528,41532,41549,41551,41552,41557,41558,41560,41614,41620,41671,41712,41745,41746,41785,1210,1660,2546,2650,2784,2815,2987,3041,3142,4131,4172,35728,35887,35913,35902,36046,36172,36326,36352,36565,36706,36936,36997,37201,37252,37280,37357,37438,37472,37492,37518,37525,37615,37643,37794,37857,38066,38210,38297,38358,38387,38422,38488,38499,38543,38544,38558,38568,38640,38642,38651,38661,38732,38745,38770,38773,38819,38828,38881,38917,38947,38987,39068,39076,39082,39124,39353,39389,39441,39463,39474,39512,39660,39701,39855,39934,39956,40236,40297,40308,40356,40380,40388,40390,40605,40822,41028,41065,41077,41111,41151,41186,41199,41280,41288,41384,41405,41416,41441,41445,41484,41517,41537,41546,41545,41562,41596,41683,41731,41737,41768,41769,41775,1531,14376,18391,20918,21031,21344,21375,32774,35547,36543,36636,37506,37889,37955,38915,40719,1604,1703,3399,3409,4228,5436,8463,36000,36612,36663,37145,37397,37679,37792,38187,38697,38748,38889,39678,39767,39834,39926,40498,40896,41100,41197,41256,41275,41336,41654,41765,5391,5506,5965,7987,9849,15011,15281,26753,27025,27468,28730,29071,32143,35021,36672,37744,39310,40032,10328,39872,40585,41068)
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 | 454 | 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.01 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.19 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.01 ms |
| After table lock | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| After table lock | 0.08 ms |
| init | 0.14 ms |
| optimizing | 0.07 ms |
| statistics | 0.56 ms |
| preparing | 0.44 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.75 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.20 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.01 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 |