Tiempo de la consulta: 16.07 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-15 15:14:14' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-15 15:14:14' )
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 (1075,1194,1249,1216,1279,1349,1481,1646,1753,1819,1930,2179,2377,2416,2464,2539,2657,2720,2853,2892,2991,3124,3237,3467,3611,3661,3803,3949,4341,4401,4479,4570,4893,5817,6121,6649,6745,7078,7262,7608,7663,8542,8722,8961,9430,9713,10000,10253,10266,10315,10567,10669,11357,11412,11971,12585,12616,13058,13141,13446,14077,14209,14219,14612,14629,14975,15050,15056,20556,20595,21724,23839,25843,26870,29540,30039,32373,32737,33003,35381,36087,37620,38122,38782,39502,1253,1317,1617,2644,2795,2856,3057,3484,3566,3893,5065,5075,5305,5480,5697,5944,6133,6525,6612,6689,6758,7354,8267,9838,10899,10911,11017,11288,11783,12053,13448,13875,14350,14866,15033,15327,15372,15385,15438,15466,15664,16631,17186,17249,17265,17392,17991,19831,24098,25800,25929,26257,27938,28230,28762,30500,30559,30746,30747,30911,30993,31854,32155,32574,35111,36094,36401,36507,37309,37445,37875,37993,38706,38776,39618,39691,39850,39874,39887,39934,40274,40340,40411,40416,40580,40729,1919,2592,4865,5563,7437,10374,35802,37040,37311,37358,37421,37563,37712,37720,37859,38042,38577,38663,38700,38732,38775,38812,38887,38906,39109,39243,39331,39592,39609,39668,39693,39818,39881,40033,40065,40077,40151,40177,40221,40224,40241,40245,40260,40306,40307,40316,40372,40381,40399,40402,40440,40514,40554,40674,40777,40834)
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | i | range | PRIMARY,item,catid | PRIMARY | 4 | NULL | 227 | Using where; Usando 'filesort' |
| 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.21 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.06 ms |
| init | 0.18 ms |
| optimizing | 0.08 ms |
| statistics | 0.48 ms |
| preparing | 0.54 ms |
| executing | 0.01 ms |
| Sorting result | 13.67 ms |
| Sending data | 0.28 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.16 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 |