Tiempo de la consulta: 8.96 ms Después de la última consulta: 0.46 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-11-05 21:17:08' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-11-05 21:17:08' )
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 (879,1036,1056,3384,3429,3807,6369,6568,6573,6576,7148,7658,7833,9174,10133,10861,10936,11365,12016,12126,12261,12809,13368,14325,15700,15938,20695,20850,20852,20922,21226,21266,21290,21394,21500,21663,21825,21978,22346,22529,22538,22845,22864,22898,22908,22919,22970,23029,23305,23354,23708,23731,23801,23850,23892,23956,23990,24028,24062,24095,24128,24142,24162,24214,24284,24295,24304,24317,24348,24362,24385,24411,24436,24494,24533,24547,24602,24619,24633,24634,24684,24711,24718,24767,24849,24856,24889,24891,24896,25014,25031,25059,25072,25094,25145,25147,25178,25208,25213,25224,25275,25292,25309,25320,25336,25373,25382,25399,25437,25475,25504,25533,25553,25570,25607,25620,25662,25714,25751,25812,25847,25924,26235,26252,26355,26440,26448,26562,26578,26591,26913,26927,27030,27077,27110,26942,26955,26960,26974,26999,27025,27190,27480,27559,27815,28204,28269,28308,28442,28443,28488,28585,28693,28817,28819,29246,29271,29383,29424,29505,29521,29663,29710,29739,29858,29915,30061,30082,30117,30222,30273,30303,30377,30481,30506,30541,30546,30555,30577,30642,30647,30658,30659,30714,30738,30766,30775,30803,30869,30879,30880,30894,30897,30916,30924,30938,31012,31044,31159,31224,31726,31735,31928,31937,32015,32358,32386,32412,32611,32666,33130,33932,34342,34532,34581,35354,35427,35621,35629,35658,35831,36292,36609,36802,36820,37074,37643,37733,37757,37788,38128,38161,38226,38592,38666,38670,38761,38955,39165,39192,39255,39379,926,934,1558,1859,2235,2243,3482,3569,5386,5514,11455,11772,12226,12336,16293,18281,35798,36068,36123,36140,36523,36526,36724,36727,37063,37099,37639,37706,37841,37894,38048,38135,38141,38180,38186,38240,38247,38249,38289,38497,38525,38530,38651,38740,38768,38770,38799,38808,38818,38856,38861,38865,38883,38884,38890,38937,38958,38978,39070,39066,39120,39143,39182,39285,39334,39342,39388,39407,39417,39436,39437,39439,39463,39464,39525,976,1723,3699,5101,16935,27602,36272,36351,36798,36959,37420,37790,38219,39176,1604,1703,3399,3409,4228,5436,8463,36582,36612,36663,36833,37145,37252,37397,37506,37679,37792,38187,38697,38748,38889,4179,5853,6006,6020,9050,12806,26530,29301,33460,35955,35996,36933,36941,36945,38406,38476,38506,38566,38888,39161,39236,39632,5707,7870,12494,13952,14865,14921,16077,17521,20153,20506,28812,31681,32308,35983,35984,36024,36960,37611,37875,38158,38211,38365,38711,38727,38804,38809,38819,38826,38828,38842,38850,38851,38857,38862,38871,38881,38897,38899,38900,38908,38923,38927,38930,38932,38936,38942,38956,38959,38963,38968,38981,38986,39007,39009,39018,39022,39028,39033,39042,39062,39068,39104,39111,39112,39125,39130,39151,39155,39162,39242,39319,39324,39347,39357,39360,39369,39387,39586,39608,35990,36002,36005,36086,36134,37483,37692,39399)
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 | 497 | 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.01 ms |
| checking query cache for query | 0.42 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 |
| Waiting for query cache lock | 0.01 ms |
| After table lock | 0.07 ms |
| init | 0.17 ms |
| optimizing | 0.11 ms |
| statistics | 0.83 ms |
| preparing | 0.68 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 4.25 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 1.98 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.01 ms |
| updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.01 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 |