Tiempo de la consulta: 3.73 ms Después de la última consulta: 0.54 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 <= '2025-12-03 15:58:19' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-03 15:58:19' )
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,36755,36804,36833,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,955,5521,36535,37307,40446,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,1423,1837,2704,3187,4094,4459,4461,4469,6716,10358,11317,12530,12764,13156,14507,21500,25265,26355,31196,35706,35717,35975,36373,36371,36610,36635,36695,37046,37077,37345,37363,37389,37666,37846,38485,38494,38510,38645,38718,38751,38781,38875,39127,39182,39199,39212,39231,39273,39285,39286,39426,39557,39571,39577,39591,39616,39634,39653,39698,39737,39837,39843,39872,39917,39918,39922,39944,39961,39990,40002,40044,40127,40137,40334,40413,1476,2773,3175,3639,5078,6092,6506,8482,11592,12133,12632,13909,29542,35818,36529,36587,36590,37101,37498,37690,37831,37884,37961,38331,38361,38397,38747,38750,38758,39024,39030,39064,39129,39157,39164,39192,39215,39234,39372,39391,39408,39438,39492,39511,39513,39515,39523,39526,39530,39684,39769,39773,39821,39823,39828,39830,39876,39877,40298,40313,40342,40396,40463,40468,40511,1980,2501,2502,2954,3967,4228,4296,4308,4348,6006,6501,6565,7317,7494,8350,8894,11584,11907,13152,13828,35721,35871,36106,36456,36483,36484,36488,36765,36749,36799,36881,36904,36933,36941,36999,37042,37059,37062,37233,37344,37457,37466,37565,37606,37646,37683,37707,37786,37830,37861,37956,37960,38080,38191,38205,38250,38307,38334,38455,38492,38530,38527,38556,38569,38571,38576,38613,38660,38716,38741,38765,38767,38803,38808,38822,38869,38873,38883,38884,38885,38931,38935,38946,38965,38986,39003,39029,39033,39083,39112,39131,39186,39189,39261,39361,39403,39589,39611,39639,39655,39675,39679,39717,39733,39775,39776,39797,39878,39954,39968,39993,40006,40009,40015,40035,40052,40057,40061,40079,40150,40235,40252,40330,40354,40362,40456,2326,4905,5807,37435,37801,38179,38324,38519,39610,40112,4091)
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 | 509 | 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.02 ms |
| Waiting for query cache lock | 0.00 ms |
| checking query cache for query | 0.24 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 |
| Waiting for query cache lock | 0.00 ms |
| After table lock | 0.06 ms |
| init | 0.14 ms |
| optimizing | 0.09 ms |
| statistics | 0.70 ms |
| preparing | 0.50 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 1.42 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.31 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.02 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.00 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 |