Tiempo de la consulta: 7.66 ms Después de la última consulta: 1.43 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-26 21:56:35' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-01-26 21:56:35' )
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 (865,1503,1543,1985,2314,2372,2948,3114,3135,3686,4034,4185,4591,4834,4862,5042,6521,6528,6537,7884,7986,8531,8535,9077,9228,10841,10948,11138,11590,21731,24160,26798,31067,31398,35697,35852,35906,35978,36016,36047,36119,36121,36370,36432,36434,36476,36678,36691,36705,36721,36755,36824,36965,37130,37129,37215,37223,37238,37251,37346,37355,37365,37579,37586,37633,37641,37665,37903,38285,38490,38557,38596,38684,38979,39028,39181,39336,39407,39473,39480,39494,39520,39524,39646,39667,40274,40322,40450,40480,40535,40605,40606,40645,40648,40697,40717,40745,40930,40957,41019,41070,41083,41085,41102,41113,41139,41166,41167,41178,41202,41279,41294,41304,41324,41327,41331,41332,41336,41339,41347,41351,41369,41370,41378,41386,41388,41407,41435,41469,41497,41525,41532,41544,41549,41558,41650,891,1080,1193,1195,1202,1266,1299,1396,1412,1473,1475,1537,1542,1560,1567,1578,1598,1616,1625,1681,1686,1696,1868,2120,2139,2343,2397,2424,2487,2638,2789,3075,3139,3231,3256,3263,3325,3386,3390,3402,3403,3486,3492,3538,3625,3659,3698,3704,3903,3943,3983,4058,4118,4147,4197,4213,4253,4279,4417,4534,4576,4594,4611,4614,4699,4702,4710,4721,4761,4821,4825,4915,4926,4954,4956,4968,5031,5045,5059,5069,5084,5100,5109,5166,5206,5281,5320,5378,5380,5435,5440,5464,5466,5482,5521,5524,5592,5638,5673,5693,5698,5709,5783,5789,5825,5876,5950,5996,6057,6108,6137,6231,6356,6400,6446,6462,6497,6623,6653,6693,6695,6711,6735,6783,6793,6817,6866,6898,6942,6970,6973,7164,7226,7250,7257,7272,7314,7328,7338,7356,7379,7395,7408,7442,7444,7471,7486,7541,7567,7621,7692,7693,7701,7722,7752,7761,7771,7802,7892,7931,7971,8030,8031,8078,8156,8157,8185,8187,8190,8207,8242,8270,8285,8348,8468,8503,8570,8637,8710,8725,8778,8787,8817,8825,8835,8842,8858,8896,8909,8951,8962,8979,9053,9079,9099,9101,9192,9203,9236,9320,9345,9359,9364,9382,9473,9564,9571,9608,9645,9652,9684,9705,9758,9791,9804,9926,9960,9974,10050,10110,10188,10207,10387,10422,10425,10464,10499,10604,10610,10642,10688,10827,10845,10848,10918,11316,11389,11507,11715,11856,11892,11915,11943,12026,12106,12140,12143,12147,12188,12323,12328,12378,12416,12418,12423,12465,12530,12539,12564,12573,12604,12744,12822,12876,13021,13027,13036,13092,13315,13534,13544,13624,13756,13856,13978,14036,14525,14604,14638,14688,14708,15052,15149,15275,15280,15374,15380,15505,15581,15591,15604,15636,15895,15997,16195,16454,16460,16461,16618,16759,17382,17525,17537,17689,18212,18366,18446,18731,19100,19297,19336,19606,19767,19768,20354,20595,21656,22771,23741,24354,24627,24902,25154,25207,25306,25392,25375,25446,25489,25542,25885,26073,26126,26154,26304,26336,26367,26511,26661,26696,26711,26712,26729,26740,26760,26807,26916,26920,27105,27004,27173,27331,27363,27381,27770,27977,28540,28611,28640,28889,29139,29644,29752,29850,29868,30392,30464,30498,30569,31160,31163,31164,31227,31257,31380,31463,31606,31695,31733,32365,32754,32786,32853,32867,32993,33004,33847,33968,34035,34595,35083,35339,36114,36640,36850,37525,37652,37654,37674,37972,38047,38327,38358,38462,38542,38548,38641,38642,38746,38785,38993,38995,39355,39396,39418,39427,39512,39592,39660,39675,39691,39745,39771,39776,39794,39869,39876,40022,40023,40026,40034,40047,40083,40151,40307,40354,40372,40402,40461,40462,40544,40527,40582,40647,40730,40738,40946,40952,40996,41269,41346,41368,41433,41455,41486,41550,41571,41635,1002,1010,960,1204,1501,1724,2300,2814,3150,4379,4725,5077,9006,9196,9856,12338,12790,15955,16835,21596,24217,31420,33042,36763,37049,37602,38940,39221,39779,39837,40521,41295,41438,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,39147,39163,39193,39259,39266,39339,39347,39489,39584,39617,39647,39695,39792,39805,39828,39910,39997,39998,40029,40159,40171,40229,40264,40359,40452,40468,40546,40553,40584,40586,40609,40690,40793,40827,41026,41055,41130,41145,41277,41376,41499,41793,1085,1863,2902,1282,2726,2970,4361,8752,36785,36929,37490,37554,37621,37948,38212,38499,39260,39285,39800,39806,40041,40115,40119,40136,40210,40212,40243,40270,40281,40396,40531,40573,40600,40603,40668,40714,40757,40995,41015,41020,41042,41076,41325,41463,41464,41493,41552,41749,41776,41805,41817,1437,4781,38778,38966,39217,39781,41320,41362,1535,1957,5243,35877,36453,36586,36674,37123,37286,37312,37496,37657,37767,38183,38188,38970,38983,39510,39844,40030,40031,40082,40784,40834,40912,41124,41245,41344,1702,39683,5710,6293,7126,11861,36898,37959,38502,40273,40304,40435,40698,40753,41668,3343,3463,3477,4091,6444,12630,15497,16427,17151,31358,34037,37553,37870,37928,38019,38082,38302,38522,39301,39491,39578,39896,40511,41148,41640,3766,7837,38154,37380,40221,41243,37708)
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 | 251 | 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.06 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.68 ms |
| checking permissions | 0.02 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.02 ms |
| Waiting for query cache lock | 0.01 ms |
| After table lock | 0.15 ms |
| init | 0.41 ms |
| optimizing | 0.24 ms |
| statistics | 2.06 ms |
| preparing | 1.65 ms |
| executing | 0.02 ms |
| Sorting result | 0.02 ms |
| Sending data | 0.77 ms |
| Waiting for query cache lock | 0.06 ms |
| Sending data | 0.70 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 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 |