Tiempo de la consulta: 3.29 ms Después de la última consulta: 0.68 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-03 02:49:08' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-03 02:49: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 (1224,1854,31921,39157,39650,1361,1507,1851,2249,2268,2275,2276,2359,2506,2656,2669,2732,2803,2857,2858,2950,3041,3245,3821,3992,4137,4184,4205,4270,4287,4498,4595,4600,4684,4933,4945,5103,5326,5710,5732,5839,5844,5858,6086,6110,6246,6746,6780,6788,6814,6845,7001,7101,7119,7194,7318,7426,7589,7900,8091,8098,8177,8184,8315,8321,8421,8451,8696,8833,8951,9330,9355,9474,9775,9879,10322,11356,12078,13398,13693,13923,13987,31584,31633,35715,35789,35797,35798,35815,35788,35843,35844,35866,35925,35945,35962,35993,36045,36178,36194,36201,36312,36347,36380,36396,36471,36473,36489,36491,36492,36494,36499,36549,36555,36559,36581,36599,36602,36603,36604,36610,36613,36605,36632,36633,36641,36669,36692,36719,36721,36717,36737,36747,36750,36749,36786,36785,36790,36791,36792,36813,36824,36844,36845,36846,36847,36881,36883,36885,36905,36916,36927,36928,36935,36934,36951,36954,36979,36980,36981,36988,37002,37005,37003,37010,37014,37041,37058,37056,37061,37062,37074,37087,37095,37101,37108,37144,37145,37152,37177,37198,37206,37207,37223,37232,37249,37266,37263,37267,37303,37300,37322,37323,37329,37333,37344,37351,37356,37366,37391,37399,37398,37408,37426,37433,37436,37463,37477,37487,37494,37498,37501,37508,37509,37515,37555,37559,37580,37609,37612,37622,37636,37639,37654,37660,37670,37673,37677,37706,37713,37760,37765,37768,37769,37772,37785,37787,37790,37796,37802,37819,37844,37863,37866,37888,37926,37950,37952,37972,37978,38010,38016,38014,38022,38045,38047,38050,38054,38067,38068,38086,38133,38161,38164,38156,38174,38175,38193,38204,38209,38265,38268,38273,38293,38298,38318,38320,38316,38335,38338,38349,38352,38359,38361,38369,38381,38382,38385,38389,38394,38411,38415,38423,38431,38458,38477,38491,38500,38520,38525,38539,38559,38557,38567,38592,38632,38670,38678,38697,38706,38707,38709,38710,38727,38734,38757,38771,38810,38815,38849,38870,38882,38888,38889,38895,38897,38912,38911,38922,38949,38952,38969,39000,39036,39038,39084,39105,39126,39154,39161,39185,39210,39220,39234,39238,39265,39275,39281,39355,39359,39368,39374,39379,39397,39417,39419,39427,39436,39439,39460,39464,39466,39469,39467,39479,39518,39525,39527,39532,39589,39590,39600,39610,39612,39613,39614,39627,39635,39649,39651,39659,39676,39677,39686,39692,39704,39713,39715,39728,39733,39773,39776,39788,39800,39824,39835,39836,39851,39852,39856,39866,39871,39872,39869,39868,39878,39885,39889,39895,39914,39920,39921,39945,39952,39957,39960,39961,39967,39997,39999,40003,40004,40005,40017,40029,40043,40049,40050,40053,40062,40078,40086,40104,40120,40155,40158,40160,40168,40169,40172,40180,40182,40234,40244,40252,40268,40269,40275,40276,40280,40295,40298,40299,40300,40304,40309,40323,40353,40354,40357,40363,40365,40376,40404,40432,40443,40451,40461,40463,40472,40477,40481,40483,40488,40496,40499,40505,40508,2255,2789,6049,11363,36405,36437,36671,36818,36964,36990,38758,39813,39939,40028,40056,2377,2558,2835,2868,2892,2900,2991,3098,3675,3874,3899,4021,4085,4634,5048,5191,6186,6190,7361,8319,8380,8783,9427,9529,10429,10990,11088,12154,12980,13829,17569,29830,30738,30818,32107,33102,35985,35974,36064,36070,36105,36118,36145,36224,36258,36276,36271,36317,36327,36374,36379,36371,36400,36472,36483,36493,36500,36551,36578,36617,36620,36646,36651,36668,36677,36736,36796,36819,36965,36967,36984,37073,37077,37109,37129,37160,37248,37252,37280,37331,37438,37492,37524,37529,37581,37599,37604,37615,37620,37648,37676,37759,37806,37822,37827,37831,37840,37858,37899,37990,38009,38015,38059,38184,38188,38210,38244,38287,38317,38323,38368,38426,38427,38501,38526,38529,38531,38543,38545,38593,38682,38789,38824,38902,38941,38954,38970,38992,39017,39021,39023,39247,39375,39405,39443,39446,39498,39520,39521,39570,39597,39639,39735,39763,39771,39812,39853,39897,40075,40125,40176,2594,3357,3556,3727,3735,4585,6537,7423,7998,8154,8278,12314,12629,28215,35731,35830,35981,36299,36419,36436,36441,36459,36469,36490,36571,36618,36835,36932,36957,36958,36966,36968,37246,37276,37390,37395,37425,37716,37884,38021,38321,38331,38401,38505,38518,38600,38611,38713,38792,38829,39128,39158,39182,39186,39191,39377,39413,39598,39669,39685,39737,39802,40066,40157,40231,40246,40287,40294,40302,40413,40439,40442,40521,3673,5043,7922,12340,37883,38575,38906,38953,39014,39296,39481,39701,39803,39849,39916,39929,39995,40281,40290,40372,40455,8264,35904,37306,37397,38407,38774,39404,39691,35030,37584,38396,40444)
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 | 340 | 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.30 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.01 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.08 ms |
| init | 0.19 ms |
| optimizing | 0.11 ms |
| statistics | 0.93 ms |
| preparing | 0.68 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.56 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.13 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.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 |