Tiempo de la consulta: 9.17 ms Después de la última consulta: 1.82 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-27 03:54:50' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-01-27 03:54:50' )
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 (911,963,977,976,1020,1032,1183,1268,1347,1366,1428,1442,1439,1608,1651,2031,2155,2371,2515,2612,2929,2969,2993,3040,3282,3341,3367,3400,3502,3510,3574,3654,3699,3801,3856,3933,4018,4035,4195,4384,4405,4436,4519,4888,4895,5070,5276,5501,5672,5881,5960,5913,6388,6441,6445,6685,6908,6899,7062,7251,7400,7552,7568,7601,8046,8225,8483,8508,8532,8609,8610,8759,8864,9165,9325,9354,9956,10051,10212,10359,10410,10489,10610,11031,11015,11168,11250,11255,12236,12238,12516,12603,12755,13684,13690,13780,14088,14660,14701,15271,16065,16644,17381,17404,17903,17960,18218,18471,19424,20229,20669,20975,22087,23130,23485,23642,23772,24085,24289,24581,24870,24911,25023,25507,25531,25557,25569,26193,26277,26298,26513,26700,26851,27251,27760,28034,28041,28772,28910,29324,29608,30945,31002,31033,31165,31263,31298,31498,31939,31946,32108,32554,32583,32691,32930,33010,33041,33116,33824,34323,34457,34559,34740,34827,35113,35243,35339,35758,35774,35885,36181,36451,36693,37528,37566,37843,37940,38292,38621,38858,38891,38901,38928,38958,38965,38976,38989,38997,39003,39015,39107,39179,39225,39240,39246,39261,39292,39327,39348,39563,39617,39681,39901,40168,40211,40216,40246,40371,40484,40853,41218,41235,41392,41409,41540,41768,41773,868,1770,2386,2437,2600,2824,2875,3556,3880,4007,4343,4570,4795,4850,5197,5287,5909,8276,14941,15741,16996,32227,34995,35860,36012,36014,36312,36325,36350,36405,36420,36857,37045,37222,37246,37334,37432,37437,37488,37611,37686,37791,37857,37927,38062,38216,38406,38422,38452,38510,38852,39014,39128,39319,39447,39621,39678,39700,39802,39834,39845,39863,39926,39955,40024,40035,40096,40220,40231,40300,40444,40498,40504,40576,40705,40751,40837,40879,41028,41078,41117,41207,41504,41654,41675,41679,41680,41723,41842,1038,2546,3962,4563,6159,6453,10125,10530,17898,35795,35853,36796,36966,36967,37091,37141,37253,37270,37352,37356,37390,37461,37516,37682,37784,37847,37872,38014,38022,38168,38214,38229,38298,38329,38367,38466,38518,38528,38552,38569,38578,38631,38672,38753,38769,38795,38887,38952,38969,38980,38998,39005,39016,39080,39084,39108,39117,39158,39167,39178,39189,39199,39215,39216,39224,39282,39294,39337,39350,39356,39366,39398,39406,39418,39446,39481,39517,39522,39597,39614,39631,39650,39654,39661,39662,39663,39695,39722,39760,39776,39777,39779,39791,39799,39809,39812,39825,39828,39831,39875,39876,39892,39902,39913,39921,39936,39950,39959,39961,40001,40003,40028,40046,40054,40066,40089,40100,40119,40150,40232,40241,40247,40287,40313,40320,40328,40336,40377,40407,40413,40469,40481,40482,40483,40515,40517,40540,40549,40551,40567,40594,40598,40608,40625,40626,40644,40655,40666,40670,40678,40680,40698,40702,40703,40718,40723,40742,40748,40755,40765,40777,40779,40783,40795,40803,40807,40881,40895,40922,40924,40927,40938,40951,40961,40991,41002,41004,41011,41035,41062,41087,41089,41090,41096,41147,41155,41165,41167,41168,41181,41183,41187,41196,41198,41204,41205,41206,41237,41253,41258,41294,41295,41297,41300,41301,41329,41342,41346,41365,41368,41381,41397,41420,41448,41496,41502,41528,41530,41557,41566,41569,41582,41657,41669,41671,41682,41697,41722,41730,41731,41744,41784,41789,41808,41809,41816,41823,41833,1573,1976,2023,2148,2176,3420,4904,4952,6458,7055,8186,36632,36951,37492,37883,38015,38086,38129,38575,39124,39276,39336,39392,39454,39570,39606,39835,39907,39910,39965,40023,40124,40820,40900,40998,41457,41503,1748,1887,1997,2758,3154,3718,4773,6235,6252,9643,14311,35835,36471,36571,36657,36663,36933,36945,36959,37062,37072,37122,37132,37359,37626,37685,37869,37878,38111,38224,38713,38782,38931,38954,39063,39148,39275,39325,39413,39714,40062,40169,40496,40675,40746,40815,41135,41199,41200,41547,41618,41656,1823,1917,2015,2060,2432,3316,3596,3780,4388,5978,6210,6910,7292,10178,10680,10759,12847,20178,35728,35804,35788,35848,35854,35869,35879,35909,35915,35944,35946,35971,36036,36123,36200,36256,36286,36351,36616,36721,36723,36818,37213,37314,37335,37459,37531,37558,37595,37829,37830,37890,38029,38092,38277,38357,38378,38419,38512,38643,38644,38676,38739,38809,38818,38826,38857,38861,38863,38866,38867,38881,38888,38897,38899,38900,38904,38920,38932,38942,38946,38955,38963,38968,38971,38978,38979,38986,39018,39019,39042,39068,39109,39110,39125,39187,39232,39236,39250,39259,39269,39295,39357,39360,39558,39658,39675,39696,39708,39740,39861,39900,39915,39948,39957,40048,40052,40063,40098,40121,40210,40361,40468,40573,40600,40690,40724,40964,40977,41128,41164,41221,41401,41441,41467,41558,41645,41713,41727,41746,41754,41760,2200,3870,3929,3941,3976,4113,4376,4379,5188,5192,5202,5234,5348,5541,6030,6269,6706,7873,7982,8001,8626,9238,9398,11285,12921,15539,16576,19867,30050,30051,33264,35259,36209,36276,36467,36573,36900,37143,37428,37599,38184,38368,38426,38793,38938,39471,39498,39582,40000,40516,40537,41264,41490,6544,11155,35724,37348,37421,37457,38070,38083,38365,38485,38494,38506,38566,38704,39160,39271,39660,39890,39903,39906,40302,40439,40442,40585,40754,40800,40830,40918,40952,41169,6161,37357,37775,41464,36651,40878,41384,36703,37248,37513,39289,39235,41461,41560)
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 | 235 | 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.75 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.23 ms |
| init | 0.39 ms |
| optimizing | 0.28 ms |
| statistics | 1.97 ms |
| preparing | 1.73 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 1.75 ms |
| Waiting for query cache lock | 0.02 ms |
| Sending data | 1.36 ms |
| end | 0.02 ms |
| query end | 0.06 ms |
| closing tables | 0.02 ms |
| freeing items | 0.04 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 |