Tiempo de la consulta: 18.27 ms Después de la última consulta: 0.66 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-07 06:34:54' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-07 06:34:54' )
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 (902,1677,1963,2823,3009,3082,5160,5401,5417,5531,6436,7075,9445,9473,13714,14190,36385,36493,36908,37375,38043,38303,38328,38414,38420,38479,38521,39081,39147,39219,39343,39420,39529,39564,39593,39646,39718,39739,39777,39865,39949,40003,40004,40016,40018,40074,40098,40247,40321,40327,40394,40477,967,1070,1165,1255,1614,1791,1928,2191,2527,3955,4802,8268,9515,31418,33132,36141,36309,36381,36834,36852,36963,37033,37037,37047,37250,37430,37679,37762,37936,37975,38021,38011,38213,38243,38416,38425,38457,38549,38599,38658,38683,38702,38715,38797,38814,38876,38919,39193,39259,39266,39339,39347,39489,39584,39617,39647,39695,39792,39805,39828,39876,39910,39997,39998,40029,40159,40171,40229,40264,40322,40359,40452,40468,40546,40553,40584,40586,40609,1465,3315,8875,26598,35706,35822,35855,36989,37236,37700,38395,38466,38634,39280,39925,40281,1134,2461,2745,4736,5489,6216,7216,9385,10250,36233,36289,36447,36583,37112,37131,37284,37401,37505,37514,37655,37674,37973,37991,38173,38999,39032,39115,39178,39190,39288,39293,39316,39376,39515,39531,39554,39556,39567,39579,39629,39658,39799,39891,40204,40438,40503,40525,40545,1340,1455,1459,1483,1518,1521,1538,1539,1564,1550,5791,5807,5830,5844,5845,5876,5887,10247,10257,10277,14298,17695,21615,21664,21792,25097,25163,25189,29331,29386,33142,33296,33304,33331,33350,38631,38699,38753,38776,38852,38853,38962,38993,38995,39001,39020,39153,39209,39291,39308,39317,39373,39407,39410,39418,39419,39430,39445,39447,39451,39453,39470,39475,39482,39483,39484,39486,39488,39509,39516,39518,39522,39525,39527,39532,39546,39551,39552,39553,39566,39569,39585,39591,39628,39659,39703,39915,1453,1652,39415,39449,39664,40128,2117,3660,6477,6880,7897,12211,12368,27035,37244,37986,37987,38041,38153,38161,38162,38163,38156,38169,38306,39472,40033,40080,40114,40120,40123,2087,2088,2090,2501,3540,4916,5334,6205,6290,6300,6397,6419,6938,9132,9781,9852,9865,9869,9872,9891,10082,10113,10121,11236,11810,12111,15512,20673,20773,21549,22002,22469,25336,25919,26580,27340,28165,29063,31276,34405,34411,34426,34654,35993,36037,36173,36208,36479,36508,36520,36529,36599,36899,36937,37263,38536,38949,2318,7130,36527,37044,37204,38906,10101,30256,32052,37110,37839,38365,38512,38615,39789,39878,39905,40169,40380,40456,40607,32156,36277,36350,36655,36671,36722,36737,37358,37964,38368,38668,38774,39177,39211,39255,39414,39448,39666,39669,39968,40095,40378,40389,40600,36287,36832,36998,37339,37337,39442,40236,40548,39665)
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 | 423 | 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.27 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.11 ms |
| init | 0.16 ms |
| optimizing | 0.10 ms |
| statistics | 0.77 ms |
| preparing | 0.57 ms |
| executing | 0.01 ms |
| Sorting result | 15.53 ms |
| Sending data | 0.21 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.17 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 |