Tiempo de la consulta: 10.25 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 <= '2025-12-18 06:44:54' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-18 06:44: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 (912,1037,1125,1620,1797,1911,2205,2206,2399,2626,2737,2750,2806,2812,2821,2870,2985,3134,3316,3393,3394,3413,3470,3892,3992,4211,4494,4573,5229,5514,5701,5769,5811,6006,6078,6340,6383,6391,6399,6979,7424,7524,7593,8301,8567,8958,9063,9219,9330,9355,9508,9915,9954,10020,10543,10750,11035,11106,11315,11446,11453,11621,11628,12645,12708,12739,12796,13028,13396,13588,13853,13991,14014,14144,14277,14584,14764,14770,14776,15142,15162,15931,16190,16792,16828,16917,16918,17438,18055,18293,18457,19231,19332,19638,19977,21083,21138,21140,22084,24307,24380,24520,25076,25130,25178,25181,25692,25752,26934,27772,27789,28093,28232,28390,29140,29270,29475,29697,29758,29826,29845,29859,29988,30157,30357,30404,30577,30628,30773,31519,31667,31899,31910,31931,32002,32003,32288,32412,33083,33182,33183,33189,33553,34237,34562,35695,35832,35867,36002,36036,36167,36311,36396,36437,36477,36500,36515,36620,36646,36668,36767,36799,36832,36945,37045,37066,37187,37252,37343,37349,37642,37677,37700,37718,37786,37898,37929,38065,38217,38432,38452,38553,38557,38682,38772,38868,38902,38991,39021,39032,39167,39192,39232,39247,39284,39309,39343,39657,39674,39699,39724,39817,39852,39853,39888,39949,39996,40050,40097,40106,40176,40398,40517,40620,40671,40677,40798,1414,2233,4368,5569,5909,8349,8776,9341,12146,12542,12947,13110,13987,14907,15007,18551,18745,18775,23655,25667,26138,27527,27581,28466,33112,34492,35066,35132,35139,35785,35914,36155,36157,36168,36172,36324,36374,36474,36558,36586,36677,36802,36830,36886,36902,36967,37031,37079,37098,37116,37160,37219,37254,37285,37479,37481,37503,37534,37559,37598,37625,37660,37833,37983,37990,37995,38070,38140,38188,38216,38249,38356,38427,38503,38605,38687,38764,38786,38896,38912,38940,38990,39062,39129,39160,39198,39244,39286,39346,39362,39509,39656,39662,39702,39798,39886,39897,39928,40049,40075,40105,40166,40352,40389,40515,40638,40725,40830,3653,4028,5058,5345,5364,5373,5375,5455,5538,5616,5656,6296,6554,7405,7700,8578,8797,8864,9064,9195,9405,9526,10376,10408,10411,10612,10702,10820,12826,13078,13122,13361,13395,13543,14582,14809,14974,23950,24265,26949,27779,31320,36105,36208,38771,4336,4454,5688,6014,6759,8042,8211,8295,8311,8826,10060,10167,10707,11151,11685,12057,12200,12245,13952,16612,17521,17803,18608,19579,19706,19798,19857,21225,23398,24210,24437,25013,26491,26472,26844,27524,27620,28542,29481,30213,30480,30623,30836,31131,31205,31347,31594,31867,32156,32364,32437,32829,33283,33619,34098,34117,34693,34696,35020,35505,35537,35970,36041,36223,36506,36788,37149,37744,38115,38744,38809,38818,38832,38831,38851,38856,38857,38861,38865,38888,38923,38930,38942,38956,38959,38997,39007,39028,39044,39055,39112,39130,39165,39260,39276,39305,39342,39379,39586,39677,39740,39842,39863,39902,40130,40208,40296,40366,40400,40643,40680,40728,40880)
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 | 361 | 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.23 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.04 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.00 ms |
| After table lock | 0.06 ms |
| init | 0.13 ms |
| optimizing | 0.08 ms |
| statistics | 0.70 ms |
| preparing | 0.49 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 8.09 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.15 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.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 |