Tiempo de la consulta: 5.25 ms Después de la última consulta: 1.19 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-10-09 07:35:37' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-10-09 07:35:37' )
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 (850,2155,3513,36386,36404,36414,36430,36432,36441,36440,36557,36578,36598,36616,36660,36662,36667,36722,36755,36793,36804,36813,36912,36931,36935,37006,37074,37278,37356,37407,37530,37595,37681,37720,37791,37804,37838,37927,37952,38028,38116,38181,38212,38230,38276,38327,38336,38349,38367,38369,38376,38380,38458,38460,38463,38467,38477,38493,38495,38516,38519,38580,38581,38630,38633,38647,38657,38679,38705,38713,38763,867,912,1927,2045,2168,2334,2346,2368,2466,2812,3085,3561,3732,3746,3807,4194,4259,4336,4615,4979,4989,5988,7825,7968,8112,8673,8692,9522,9675,10093,10698,12231,13112,16326,23986,31107,33440,35911,35983,35994,36208,36285,36313,36411,36492,36529,36550,36574,36613,36641,36692,37092,37185,37237,37498,37532,37552,37598,37604,37619,37643,37651,38010,38023,38094,38132,38290,38299,38394,38428,38475,38502,38520,38539,38579,38612,38646,38658,38697,1373,2718,2776,2778,9125,36326,36398,36433,36452,36534,36693,36717,36750,36791,36816,36928,36951,36979,36980,36981,37002,37003,37010,37014,37034,37058,37056,37061,37063,37087,37096,37108,37123,37144,37145,37152,37223,37232,37266,37263,37286,37303,37300,37323,37333,37351,37366,37391,37408,37433,37477,37487,37509,37515,37559,37580,37609,37612,37636,37638,37654,37670,37673,37677,37688,37701,37704,37706,37712,37719,37723,37764,37765,37768,37769,37787,37799,37819,37844,37863,37866,37874,37888,37894,37897,37926,37978,37979,38016,38017,38032,38045,38079,38133,38135,38161,38164,38183,38185,38186,38188,38193,38204,38217,38219,38265,38268,38273,38292,38298,38316,38321,38338,38352,38353,38361,38372,38385,38389,38412,38423,38457,38464,38491,38500,38527,38567,38592,38595,38611,38632,38734,38739,38740,38757,1500,1665,2931,5226,5685,6276,6951,12302,13024,18161,35725,35823,36321,36387,36494,36564,36621,36672,36691,36736,37101,37207,37365,37520,37680,37711,38012,38141,38239,38240,38363,38492,38506,38578,38760,1773,2255,2307,5330,8576,12381,35972,36673,36824,36941,36944,37012,37079,37398,37620,37622,37676,37678,37858,37960,38184,38244,38390,38462,38642,38644,38648,38677,38761,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,36371,36400,36437,36472,36483,36493,36500,36551,36614,36617,36620,36646,36651,36668,36677,36796,36819,36964,36965,36967,36984,37073,37077,37109,37129,37160,37248,37252,37280,37331,37438,37492,37524,37529,37581,37599,37615,37648,37713,37759,37806,37822,37827,37831,37840,37899,37990,38009,38015,38059,38210,38287,38317,38323,38368,38426,38427,38501,38526,38529,38531,38543,38545,38593,38682,2502,3123,4306,4666,4694,4764,4962,6536,37203,37295,2624,2992,6166,37253,38220,38750,5114,5776,35695,35696,35948,36249,36576,36783,37149,37217,37219,37444,37462,37614,37621,37641,37664,37705,37760,37826,37903,37947,37980,38007,38113,38178,38226,38291,38613,38671,28825,34946,35797,36262,36354,37041,38415,38525,36846,36850,37026,37322,37501,37586,37785,38092,38357)
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 | 366 | 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.03 ms |
Waiting for query cache lock | 0.01 ms |
checking query cache for query | 0.41 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.17 ms |
init | 0.25 ms |
optimizing | 0.16 ms |
statistics | 1.15 ms |
preparing | 0.99 ms |
executing | 0.01 ms |
Sorting result | 0.02 ms |
Sending data | 1.25 ms |
Waiting for query cache lock | 0.02 ms |
Sending data | 0.30 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.03 ms |
updating status | 0.01 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 |