Tiempo de la consulta: 7.04 ms Después de la última consulta: 1.53 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-04 22:54:28' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-02-04 22:54:28' )
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 (1038,2546,3962,4563,6159,6453,10125,10530,17898,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,38952,38969,38980,38998,39005,39016,39080,39084,39108,39117,39158,39167,39178,39189,39199,39215,39216,39224,39282,39294,39319,39327,39337,39350,39356,39366,39398,39406,39418,39446,39447,39481,39517,39522,39597,39614,39631,39650,39654,39661,39662,39663,39695,39700,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,40096,40100,40119,40150,40231,40232,40241,40247,40287,40313,40320,40328,40336,40377,40407,40413,40444,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,40837,40881,40895,40922,40924,40927,40938,40951,40961,40991,41002,41004,41011,41035,41062,41087,41089,41090,41096,41117,41147,41155,41165,41167,41168,41181,41183,41187,41196,41198,41204,41205,41206,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,41731,41744,41784,41789,41808,41809,41816,41823,41833,41845,41861,41889,41906,41907,41910,41913,41917,41924,41933,41962,42007,42030,42034,42048,42049,42052,42058,42064,42075,1184,1930,3532,3979,4403,4490,4770,4853,4893,4900,5838,6210,6669,7414,8289,8502,9120,9308,9493,9775,9835,10000,10156,11464,11470,12510,12610,12732,13355,13825,15001,15342,16430,20750,29243,31573,31841,32008,32724,32727,33131,33466,34973,35342,35729,35984,35973,36186,36192,36279,36303,36382,36478,36527,36728,36783,36815,36882,37009,37080,37090,37111,37128,37143,37211,37212,37214,37218,37251,37254,37269,37275,37315,37338,37349,37350,37358,37370,37371,37397,37428,37439,37448,37462,37465,37473,37481,37487,37492,37500,37523,37529,37564,37582,37588,37607,37614,37625,37664,37681,37704,37705,37710,37714,37718,37756,37759,37760,37763,37793,37798,37817,37826,37828,37830,37831,37832,37862,37889,37890,37898,37930,37946,37947,37948,37957,37963,37964,37993,38009,38015,38041,38049,38056,38059,38061,38065,38070,38083,38086,38115,38128,38131,38140,38143,38153,38155,38169,38178,38183,38190,38191,38216,38220,38226,38231,38236,38247,38267,38271,38291,38296,38323,38334,38336,38345,38348,38351,38356,38368,38396,38407,38408,38415,38427,38430,38432,38435,38453,38454,38462,38463,38493,38501,38499,38503,38517,38525,38529,38531,38543,38545,38574,38575,38600,38605,38613,38640,38647,38668,38671,38673,38675,38679,38682,38705,38714,38719,38727,38731,38740,38744,38759,38768,38772,38789,38797,38821,38825,38866,38893,38898,38899,38908,38926,38957,38968,38979,38994,39002,39017,39021,39023,39027,39030,39037,39041,39062,39070,39120,39152,39160,39177,39187,39198,39201,39233,39255,39274,39284,39318,39334,39394,39396,39400,39404,39405,39414,39428,39436,39438,39444,39450,39453,39476,39483,39484,39507,39509,39516,39526,39533,39562,39565,39570,39581,39588,39596,39607,39611,39620,39630,39632,39634,39637,39656,39664,39667,39668,39670,39689,39697,39701,39705,39709,39724,39727,39729,39730,39733,39762,39764,39774,39793,39801,39807,39815,39820,39844,39847,39854,39856,39879,39880,39884,39888,39898,39922,39931,39935,39946,39963,39967,39969,39992,39996,40030,40032,40045,40048,40052,40053,40057,40067,40075,40082,40090,40093,40099,40101,40103,40105,40106,40116,40120,40122,40153,40166,40170,40176,40178,40182,40202,40205,40219,40223,40200,40251,40262,40264,40286,40288,40293,40296,40299,40317,40327,40339,40352,40366,40372,40375,40378,40385,40386,40391,40398,40408,40410,40436,40438,40467,40470,40478,40479,40511,40530,40516,40539,40559,40574,40596,40597,40603,40605,40612,40613,40616,40620,40622,40627,40643,40646,40652,40667,40677,40681,40696,40700,40701,40722,40725,40728,40732,40745,40756,40766,40774,40778,40792,40796,40798,40800,40806,40830,40835,40840,40850,40878,40883,40894,40898,40935,40939,40948,40965,40974,40988,40994,40997,40998,41000,41010,41029,41042,41124,41126,41139,41141,41151,41156,41169,41190,41210,41212,41303,41343,41358,41389,41393,41400,41407,41412,41417,41439,41456,41471,41472,41475,41488,41493,41514,41521,41523,41526,41527,41532,41553,41561,41587,41595,41614,41625,41636,41650,41656,41674,41676,41678,41705,41706,41709,41724,41720,41745,41747,41759,41761,41767,41776,41778,41826,41834,41839,41841,41846,41850,41851,41877,41879,41900,41912,41923,41940,41949,42020,42028,42029,42031,42042,42046,42063,2233,2459,3431,4483,5296,5669,5857,6944,7014,7269,7574,8534,8629,9534,9598,10046,10065,10172,11597,12132,12311,13262,14637,16468,18196,18336,19696,20498,20857,21944,22729,27228,30476,31244,31870,32187,32483,32565,32629,33097,33106,35924,36241,36287,36580,36588,36602,37096,37612,37953,37990,37995,38017,38077,38464,38565,38810,39359,39796,40163,40244,40304,40323,40363,40390,40614,40749,40931,41014,41146,41377,41490,41516,41577,41664,41765,41770,41836,42071,2603,2955,5417,5468,5483,5522,5604,8077,8249,8450,8463,9777,10367,15316,33321,35012,35645,35691,35717,35725,35832,35850,35980,35996,36103,36121,36403,36491,36526,36579,36723,36917,37194,37464,37524,37987,38438,38481,38520,38535,38666,38748,38814,38865,38986,39110,39348,39368,39480,39767,39917,40034,40044,40080,40252,40282,40289,40303,40394,40480,40674,40802,41034,41098,41111,41118,41176,41247,41544,41648,41727,41944,41946,42005,42054,36253,39051)
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 | 281 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | admin_ddpue3.i.catid | 1 | Using where |
No 'Mostrar perfil' (seguramente porque se realizan más de 100 consultas)
| # | 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 |
