Tiempo de la consulta: 29.69 ms Después de la última consulta: 0.62 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-20 03:07:18' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-01-20 03:07:18' )
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 (889,989,991,2450,5935,6043,6236,7803,8806,38854,39780,947,1551,2142,3076,3377,3654,3816,4446,6480,7441,7513,8017,8626,10340,11037,12365,12717,12745,27438,37381,37712,37919,37946,38046,38096,38309,38611,38652,38807,38921,39350,39404,39428,39476,39580,40357,40490,40491,40733,40804,40817,40819,40942,41502,1030,1956,2713,3514,4964,5625,5703,7360,8157,9718,38662,38707,38736,38755,38913,38966,39081,39142,39322,39343,39344,39465,39491,39578,39715,40020,40275,40506,1246,1223,1273,1344,2119,2225,2228,2229,2271,3069,3086,3427,3538,4017,4069,4085,4095,5106,5123,6432,6440,6587,7266,9808,10682,11171,12125,37663,1326,1908,2106,4238,8247,10935,25272,35851,35873,35894,35895,35901,36433,36619,36953,37176,37186,37187,37180,37238,37426,38156,38267,38481,38482,38489,38535,38633,38761,38762,38783,38787,38812,39034,39234,39277,39315,39410,39479,39614,39646,39776,39779,39878,39891,39928,40017,40028,40108,40123,40153,40161,40267,40283,40295,40296,40360,40392,40557,40578,40602,40658,40660,40683,40751,40787,40806,40916,40962,40979,40988,41110,41174,41176,41189,41388,41575,1473,1496,1600,2095,2171,2181,3397,3768,4030,4056,4154,4478,4488,5095,5188,5275,5286,5477,5728,5782,6520,6606,6759,6938,6968,7557,8149,8254,8568,9750,9782,10052,10133,10510,10796,11586,11853,14196,14351,15810,17287,21058,24413,27929,28128,28944,32928,33886,39006,39064,40446,40536,40561,40585,41646,2585,30058,9095,14363,14383,17596,29883,31730,32035,37526,39159,41057,41072,12966,30392,28223)
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 | 259 | 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.30 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.03 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.16 ms |
| optimizing | 0.10 ms |
| statistics | 0.65 ms |
| preparing | 0.46 ms |
| executing | 0.01 ms |
| Sorting result | 26.82 ms |
| Sending data | 0.35 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.12 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.20 ms |
| updating status | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.03 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.02 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 |