Tiempo de la consulta: 9.91 ms Después de la última consulta: 2.39 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-14 03:43:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-12-14 03:43:59' )
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 (927,1138,1156,2121,2398,2443,2780,2836,5195,5353,6759,6939,7468,10644,11018,11272,11284,11665,13133,36410,37517,37624,37772,37929,37983,38046,38095,38207,38303,38359,38534,38542,38559,38641,38718,38922,38939,38952,38961,38967,38969,39034,39038,39081,39131,39149,39212,39223,39268,39287,39295,39343,39344,39346,39349,39365,39367,39377,39380,39403,39420,39508,39564,39641,39656,39669,39711,39718,39739,39744,39777,39807,39810,39815,39817,39850,39865,39949,39958,40003,40004,40018,40098,40105,40200,40288,40325,40331,40405,40404,40410,40495,39235,40660,40723,40732,40742,40792,40796,40847,40848,40849,40858,930,1080,1334,1844,1937,1995,2014,2133,2187,2806,2812,2952,3031,3058,3066,3070,3080,3112,3132,3321,3910,4215,4363,4435,4501,4781,4805,4924,4952,5015,5028,5193,5242,5461,5503,5634,5710,5766,5849,5947,6054,6692,6739,6778,6794,7282,7635,7825,7986,8215,8301,8306,8592,9010,9033,9265,9444,9711,9720,10044,11722,11723,13209,14411,14525,15341,16663,17448,25048,25261,25272,30824,31501,31928,32246,35565,36207,36285,36325,36354,36380,36479,36492,36497,36529,36533,36553,36574,36657,36753,36761,36766,36832,36847,36850,36886,36898,36931,37026,37040,37075,37087,37092,37114,37123,37185,37209,37237,37262,37283,37308,37322,37324,37356,37467,37501,37521,37555,37558,37586,37591,37598,37604,37611,37619,37626,37651,37678,37687,37693,37720,37785,37799,37838,37885,37887,37892,37895,37898,37955,37959,38010,38023,38058,38085,38117,38244,38287,38329,38363,38357,38361,38384,38386,38401,38428,38436,38475,38491,38496,38500,38502,38521,38528,38540,38554,38579,38592,38595,38612,38657,38661,38666,38684,38704,38764,38830,38886,38903,38925,38966,39065,39064,39109,39145,39148,39214,39222,39285,39290,39294,39320,39333,39408,39415,39432,39448,39465,39491,39497,39514,39553,39560,39583,39578,39594,39599,39633,39635,39649,39651,39663,39680,39704,39707,39736,39776,39790,39812,39824,39838,39864,39892,39989,40005,40022,40033,40077,40081,40115,40160,40177,40224,40253,40259,40267,40269,40270,40271,40273,40276,40280,40284,40286,40295,40296,40298,40299,40305,40310,40317,40327,40338,40393,40395,40435,40443,40460,40471,40493,40509,40531,40535,40543,40560,40561,40591,40600,40601,40602,40628,40651,40683,40698,40702,40706,40714,40735,40751,40753,40763,40764,40771,40797,40828,40839,970,1057,2185,2696,3099,4393,4539,4786,5460,5476,7907,9440,11302,12812,12990,13041,13067,13091,15235,23464,29431,33621,34544,34704,37398,37931,38667,38987,39832,40237,1150,2333,4068,4111,6233,6466,7096,7486,8437,9103,10713,11194,16999,32874,38265,39185,39466,40309,40463,40491,40552,40611,40708,40733,40737,1186,4632,6555,11138,11653,36399,36829,36959,37044,37155,37461,37940,38014,38030,38070,38083,38113,38267,38293,38295,38396,38493,39447,39533,39598,39631,39717,40320,40401,40433,40461,40464,40496,40544,40545,40607,40657,40745,40826,1310,2820,5233,5608,5667,10425,39655,1421,1950,26865,33438,36057,37326,37637,37721,37900,38202,38277,38290,38305,38642,38677,38777,38816,39195,39523,39738,40587,1584,1895,5550,6839,6959,33603,35949,36223,36278,36314,36387,36414,36584,36785,36929,37115,37364,37761,37804,38027,38192,38215,38484,38532,38804,38826,38862,38916,39066,39211,39260,39276,39338,39375,39416,39590,39674,39765,39768,39889,40027,40042,40175,40210,40345,40555,40580,40621,40674,40691,40704,40743,40760,1823,1917,2015,2060,2432,3316,3596,3780,4388,5978,6210,6910,7292,9643,10178,10680,10759,12847,20178,35728,35804,35788,35848,35854,35869,35879,35909,35915,35944,35946,35971,36012,36014,36036,36123,36200,36256,36286,36351,36616,36663,36721,36723,36818,36857,36945,37072,37122,37132,37213,37314,37334,37335,37459,37531,37595,37685,37686,37829,37830,37890,38029,38378,38419,38512,38643,38644,38676,38739,38809,38818,38857,38861,38863,38866,38867,38881,38888,38897,38899,38900,38904,38920,38928,38932,38942,38946,38955,38963,38968,38971,38978,38979,38986,39018,39019,39042,39068,39110,39125,39179,39187,39225,39232,39236,39240,39246,39250,39259,39261,39269,39275,39319,39325,39348,39357,39360,39398,39558,39563,39658,39675,39681,39696,39708,39740,39861,39900,39901,39913,39915,39948,39957,40048,40052,40063,40121,40169,40300,40361,40468,40517,40573,40625,40666,40678,40690,40724,2021,3797,3983,4618,5519,6415,10039,10920,13445,16642,35872,37479,38172,38206,38377,38409,39173,39384,39418,39527,39606,39931,40278,40392,40469,40821,40856,2079,2768,3262,7245,9091,30714,35831,35816,35845,35880,35973,36060,36202,36291,36311,36318,36370,36386,36400,36406,36412,36416,36445,36446,36440,36460,36467,36477,36455,36500,36520,36525,36555,36571,36598,36609,36639,36676,36747,36758,36764,36767,36749,36815,36844,36846,36862,36918,36936,36985,36987,37012,37079,37109,37140,37156,37235,37248,37244,37273,37329,37339,37352,37368,37379,37390,37420,37435,37458,37457,37464,37500,37516,37522,37524,37584,37621,37627,37632,37648,37666,37676,37682,37709,37719,37757,37760,37794,37801,37842,37843,37858,37889,37950,37960,38009,38021,38051,38061,38077,38184,38229,38274,38321,38324,38379,38462,38485,38526,38552,38589,38596,38611,38629,38645,38673,38674,38678,38685,38696,38719,38760,38815,38851,38856,38868,38871,38875,38891,38896,38959,38958,39022,39015,39028,39069,39115,39122,39191,39213,39218,39274,39366,39369,39394,39399,39449,39488,39510,39517,39520,39524,39607,39611,39613,39623,39632,39650,39665,39666,39677,39695,39710,39712,39737,39762,39778,39791,39823,39844,39873,39880,39903,39904,39924,39927,39932,39936,39951,39955,39956,40001,40023,40031,40046,40059,40064,40066,40076,40089,40095,40112,40114,40117,40174,40203,40206,40236,40246,40252,40265,40294,40328,40341,40362,40364,40376,40377,40386,40387,40406,40415,40437,40453,40456,40459,40477,40501,40515,40522,40524,40530,40541,40550,40581,40606,40612,40614,40617,40630,40668,40673,40713,40740,40782,40791,40810,40836,40838,2605,3979,4114,8055,8201,9417,32313,36192,36730,36735,36878,37023,37090,37143,38080,38531,38640,38748,40727,2734,4310,4410,4507,4538,4598,4935,5186,5285,5799,6083,7766,8782,11673,28342,35488,35692,35699,35701,35713,35714,35724,35747,35794,35802,35860,35847,35868,35882,35891,35892,35887,35922,35945,35986,35992,35998,36015,36032,36045,36071,36073,36088,36084,36148,36168,36178,36201,36188,36215,36230,36252,36271,36306,36312,36350,36367,36369,36378,36418,36398,36433,36439,36471,36473,36478,36489,36499,36550,36554,36556,36559,36581,36587,36590,36591,36619,36635,36697,36724,36731,36737,36765,36780,36790,36797,36805,36836,36831,36851,36880,36881,36900,36912,36914,36933,37008,37027,37032,37043,37045,37048,37062,37064,37084,37159,37175,37194,37216,37220,37234,37249,37292,37371,37374,37389,37405,37432,37466,37488,37508,37549,37652,37655,37713,37784,37826,37831,37860,37868,37872,37878,37881,37883,37893,37939,37961,37981,37982,37991,38022,38054,38062,38068,38109,38111,38116,38133,38145,38155,38161,38156,38170,38212,38240,38246,38291,38318,38327,38335,38360,38381,38402,38407,38422,38452,38466,38482,38488,38510,38513,38518,38525,38548,38569,38594,38769,38785,38803,38828,38850,38884,38915,38923,38927,38937,38984,38991,38993,39033,39061,39112,39130,39143,39151,39176,39189,39220,39227,39257,39292,39345,39358,39363,39387,39426,39478,39500,39586,39589,39605,39608,39628,39683,39797,39809,39843,39848,39876,39882,39921,39939,39947,39990,39993,40028,40035,40120,40149,40161,40231,40241,40245,40290,40306,40390,40476,40481,40483,40504,40575,40641,40665,40680,40687,40712,40746,3083,3357,4279,5237,6261,35698,39007,3170,5860,5867,6946,7868,9295,9381,9535,10954,15212,33353,35354,35977,36175,37469,37675,37699,38159,39732,39846,40556,5464,6407,8951,9192,10688,13021,13624,15275,15581,15997,16206,16454,16461,16885,17272,18212,18218,18731,19704,20150,20166,20595,21669,21758,22396,22853,24863,25464,27211,27540,27787,30519,31153,35331,37150,37307,37316,37344,37345,37429,37472,37495,37525,37589,37596,37602,37613,37614,37659,37722,37802,37846,37848,37857,37927,37972,38162,38180,38205,38241,38250,38309,38358,38387,38414,38603,38614,38709,38741,38758,38780,38814,38858,38901,38950,38965,38989,38997,39003,39006,39029,39035,39039,39071,39107,39186,39221,39278,39341,39390,39396,39477,39512,39614,39626,39630,39640,39660,39691,39716,39719,39726,39735,39794,39836,39869,39906,39930,39919,39954,39961,40026,40034,40047,40054,40079,40083,40123,40153,40179,40211,40319,40308,40326,40354,40371,40402,40536,40527,40579,40582,40583,40610,40670,40676,40772,40779,40794,40801,40854,12779,36379,39162,39203,39277,39425,39800,39885,40400,40516,40618,36383,36548,36549,36656,36725,36786,37215,37425,37677,38708,38797,38982,39612,39722,39730,39866,40697)
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 | 186 | 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.04 ms |
| Waiting for query cache lock | 0.01 ms |
| checking query cache for query | 0.97 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.05 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.22 ms |
| init | 0.64 ms |
| optimizing | 0.37 ms |
| statistics | 3.06 ms |
| preparing | 2.68 ms |
| executing | 0.01 ms |
| Sorting result | 0.01 ms |
| Sending data | 0.97 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.30 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.03 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.01 ms |
| freeing items | 0.05 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.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 |