Tiempo de la consulta: 7.29 ms Después de la última consulta: 1.84 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-02-11 11:24:36' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-02-11 11:24:36' )
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 (854,1373,36321,36431,36488,36575,36576,36599,36600,36607,36655,36717,36768,36803,36816,36828,36860,36928,36937,36934,36954,36985,37005,37034,37095,37096,37126,37146,37198,37267,37310,37326,37339,37351,37358,37375,37392,37393,37408,37422,37463,37465,37469,37471,37498,37504,37521,37555,37565,37605,37606,37609,37638,37639,37645,37769,37819,37841,37947,37959,38017,38048,38122,38127,38133,38141,38289,38369,38382,38389,38520,38567,38590,38808,38810,38818,38856,38870,38873,38882,38890,38893,38939,38952,38961,38967,38996,39038,39061,39080,39085,39066,39113,39117,39124,39149,39182,39193,39195,39210,39223,39234,39268,39282,39287,39336,39339,39370,39376,39377,39407,39410,39417,39419,39437,39439,39464,39482,39490,39554,39556,39565,39566,39585,39587,39600,39623,39624,39627,39629,39648,39659,39661,39686,39687,39710,39738,39778,39808,39812,39822,39829,39842,39846,39852,39868,39878,39895,39932,39933,39948,39953,39956,39959,39967,39997,39999,40007,40019,40021,40043,40058,40061,40098,40121,40129,40148,40152,40167,40172,40213,40232,40233,40258,40259,40261,40265,40268,40276,40277,40309,40311,40318,40321,40323,40328,40332,40342,40353,40375,40431,40437,40446,40452,40458,40488,40499,40512,40519,40524,40516,40537,40540,40546,40548,40552,40577,40578,40590,40625,40642,40650,40672,40685,40695,40703,40704,40714,40720,40721,40735,40741,40750,40758,40772,40825,40832,40834,40859,40897,40919,40930,40933,40937,40947,40955,40962,40975,40977,40978,40992,41011,41021,41030,41042,41055,41054,41066,41069,41070,41115,41127,41134,41136,41146,41150,41153,41166,41172,41176,41180,41206,41209,41213,41218,41220,41223,41238,41239,41248,41261,41276,41277,41278,41288,41296,41292,41299,41330,41341,41350,41357,41378,41383,41388,41401,41403,41406,41416,41419,41446,41453,41456,41462,41466,41479,41484,41494,41511,41538,41542,41543,41573,41612,41622,41627,41634,41637,41649,41650,41673,41676,41677,41707,41731,41741,41776,41779,41780,41786,41804,41840,41868,41873,41884,41929,41969,41973,42007,42043,42040,42049,42076,42079,42082,42084,42086,42155,42194,42196,42210,42215,42218,42224,42245,42256,42257,856,863,39317,39522,39569,42070,967,1070,1165,1255,2439,2527,2642,3396,4900,36233,36752,36989,37361,38425,38999,39489,39695,39792,39892,40159,40209,40281,40640,40793,40961,41469,41758,41962,1038,2546,3962,4563,6159,6453,10125,10530,17898,35795,35853,36405,36796,36966,36967,37091,37141,37253,37246,37270,37352,37356,37390,37461,37516,37682,37784,37791,37847,37872,38014,38022,38168,38214,38229,38298,38329,38367,38466,38518,38528,38552,38569,38578,38631,38672,38753,38769,38795,38887,38969,38980,38998,39005,39016,39084,39108,39158,39167,39178,39189,39199,39215,39216,39224,39294,39319,39327,39337,39350,39356,39366,39398,39406,39418,39446,39447,39481,39517,39597,39614,39631,39650,39654,39662,39663,39700,39722,39760,39776,39777,39779,39791,39799,39809,39825,39828,39831,39875,39876,39902,39913,39921,39936,39950,39961,40001,40003,40028,40046,40054,40066,40089,40096,40100,40119,40150,40231,40241,40247,40287,40313,40320,40336,40377,40407,40413,40444,40469,40481,40482,40483,40515,40517,40549,40551,40567,40594,40598,40608,40626,40644,40655,40666,40670,40678,40680,40698,40702,40718,40723,40742,40748,40755,40765,40777,40779,40783,40795,40803,40807,40837,40881,40895,40922,40924,40927,40938,40951,40991,41002,41004,41035,41062,41087,41089,41090,41096,41117,41147,41155,41165,41167,41168,41181,41183,41187,41196,41198,41204,41205,41207,41237,41253,41258,41294,41295,41297,41300,41301,41329,41342,41346,41365,41368,41381,41397,41420,41448,41496,41502,41528,41530,41540,41557,41566,41569,41582,41657,41669,41671,41682,41697,41722,41723,41730,41744,41784,41789,41808,41809,41816,41823,41833,41845,41861,41889,41906,41907,41910,41913,41917,41924,41933,42030,42034,42048,42052,42058,42064,42075,42091,42094,42105,42111,42115,42141,42143,42161,42186,42195,42207,42229,42235,42241,42248,42250,42268,1047,1144,1607,1680,2618,2781,3353,3380,3632,4189,4670,5030,5488,5677,5820,5829,5865,6130,6259,6260,6717,6725,6928,8204,9032,9034,9148,9462,9560,9968,14150,14275,14522,14906,15177,18075,21293,21360,24871,31363,32156,32173,32201,32344,32501,32549,32760,33424,35085,37797,37893,38806,39947,1392,3061,1792,2476,4445,7340,9426,15928,38251,38270,38405,39616,40531,40583,40584,41057,2516,3922,5954,7157,7977,35691,35706,35822,35834,35859,35855,35950,35979,35951,36381,36435,36493,36503,36552,36578,36583,36612,36615,36637,36667,36665,36729,36789,36795,36832,36911,36960,36963,36996,37044,37047,37112,37133,37142,37204,37236,37269,37311,37347,37401,37430,37467,37505,37514,37528,37551,37554,37579,37620,37650,37679,37700,37762,37818,37859,37860,37924,37937,37991,38021,38027,38028,38043,38173,38187,38213,38243,38301,38377,38384,38395,38537,38570,38604,38658,38683,38715,38761,38775,38776,38853,38919,38941,38962,38964,38993,39032,39147,39190,39245,39259,39288,39296,39331,39340,39347,39380,39383,39415,39451,39456,39472,39488,39509,39529,39531,39567,39579,39617,39658,39703,39770,39803,39816,39843,39857,39886,39890,39916,39998,40029,40047,40060,40092,40128,40173,40204,40245,40264,40272,40274,40340,40366,40367,40370,40464,40465,40468,40503,40511,40525,40545,40553,40586,40619,40684,40690,40724,40729,40740,40827,40896,40946,40950,40968,40989,41005,41026,41039,41075,41094,41194,41212,41376,41438,41458,41481,41539,41552,41645,41647,41719,41788,41865,41916,41919,42103,42129,42147,42262,3148,32981,37359,39568,41251,4336,4454,5688,6014,6759,8042,8211,8295,8311,8826,10060,10167,10707,11151,11685,11917,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,32364,32437,32829,33283,33619,34098,34117,34693,34696,35020,35505,35537,35970,36036,36041,36223,36396,36506,36788,37149,37677,37744,37786,38115,38744,38809,38832,38831,38851,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,39863,40050,40130,40208,40296,40400,40643,40728,40880,41159,41289,41581,41740,41955,42033,42246,4403,4655,6365,10472,11223,13094,24119,24325,25466,26284,27835,30873,31813,34261,37491,37526,37618,37922,38072,38192,38348,38366,38509,38522,39127,39326,39435,39682,39743,39763,39804,39903,40971,41197,42035,6049,8113,8114,36419,36436,36490,36495,36553,36618,36638,36731,36746,36759,36763,36764,36797,36835,36880,36919,36957,36968,36998,37066,37121,37125,37222,37261,37284,38032,38332,38365,38555,38991,40151,40369,40999,41006,41201,41255,41703,41792,42044,32649,39008,39166,33987,35801,35857,35886,36199,36302,36366,36388,36496,36671,36801,37116,37184,37251,37275,37337,37594,37623,37952,38006,38093,38550,38726,38747,38935,39078,39152,39160,39233,39293,39670,39741,39882,39955,39996,40024,40103,40106,40628,40667,41656,41724,42096,42113,38755,40182,40219,41132)
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 | 210 | 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.68 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| After table lock | 0.04 ms |
| init | 0.45 ms |
| optimizing | 0.29 ms |
| statistics | 2.34 ms |
| preparing | 2.13 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 1.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.04 ms |
| updating status | 0.03 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 |