Tiempo de la consulta: 30.07 ms Después de la última consulta: 1.11 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 <= '2024-11-22 19:11:39' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-22 19:11:39' )
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,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,1060,1081,1085,1126,1170,1257,1299,1578,1663,1893,1996,2070,2156,2171,2366,2426,2713,2750,2790,2876,2882,2906,2932,2939,2963,3077,3142,3185,3201,3251,3298,3384,3392,3469,3543,3619,3631,3712,3723,3725,3752,3756,3870,3884,3887,3929,3935,4030,4057,4070,4079,4115,4128,4160,4166,4196,4217,4240,4275,4354,4366,4410,4433,4538,4548,4550,4558,4604,4745,4854,4869,4926,4948,4919,4980,4981,4990,5009,5028,5029,5072,5079,5086,5100,5126,5130,5172,5176,5187,5194,5186,5209,5214,5235,5234,5244,5248,5253,5271,5274,5267,5279,5285,5289,5306,5336,5346,5434,5443,5446,5475,5531,5623,5625,5629,5632,5633,5651,5667,5671,5675,5678,5687,5689,5701,5711,5722,5768,5781,5799,5800,5811,5813,5836,5868,5874,5908,5921,5931,5952,6036,6070,6072,6077,6082,6095,6178,6192,6237,6286,6287,6307,6326,6339,6376,6386,6407,6432,6449,6497,6547,6628,6634,6647,6675,6686,6797,6814,6818,6850,6885,6940,6948,6955,7015,7035,7096,7102,7114,7135,7173,7190,7236,7312,7313,7388,7424,7463,7469,7470,7493,7507,7533,7531,7589,7606,7647,7670,7706,7707,7737,7766,7888,7982,7996,8006,8008,8028,8038,8051,8235,8253,8257,8280,8356,8363,8383,8390,8398,8436,8496,8552,8557,8565,8568,8611,8619,8627,8603,8679,8728,8732,8767,8792,8809,8861,8903,8932,9183,9193,9271,9395,9425,9426,9459,9471,9498,9510,9567,9578,9582,9600,9602,9606,9610,9705,9715,9728,9769,9798,9891,9892,9952,10019,10052,10055,10082,10098,10292,10329,10458,10524,10769,10836,10881,10963,10970,10978,11070,11182,11213,11220,11261,11275,11306,11354,11419,11467,11477,11478,11537,11539,11540,11543,11544,11573,11577,11585,11612,11621,11647,11669,11672,11677,11755,11773,11782,11864,11870,11888,11944,12018,12159,12162,12219,12262,12350,12356,12556,12589,12649,12650,12706,12708,12718,12756,12967,13044,13105,13532,13534,13737,13991,14066,14090,14110,14139,14214,14471,14662,14703,14949,15006,15016,15120,15204,15268,15656,15728,15753,16100,16109,16338,16543,16619,16884,17002,17081,17303,17329,17338,17364,17448,17450,17502,17503,17543,17556,17665,17684,17890,17929,18014,18148,18153,18449,18537,18734,19060,19203,19218,19318,19372,19420,19522,19671,19731,19811,19855,19890,19929,20073,20375,20551,20555,21838,23491,23626,23739,23744,24104,24120,24122,24132,24246,24652,24764,24893,24936,25190,25740,25925,25993,26024,26121,26149,26249,26352,26408,26699,27129,27857,27989,28018,28389,28428,28762,28776,28813,28867,28916,29337,29372,29399,29623,29633,29675,29676,29855,29982,30183,30259,30483,30645,31217,31565,31662,31758,32846,32971,33018,1469,1834,2485,2631,2866,2901,3228,3229,3464,3496,3519,3525,3778,4107,4613,4836,5362,5611,5783,6107,6251,6291,6384,6395,6627,6638,6954,7106,7246,7267,7453,7639,7651,7711,7797,7800,7807,7863,7942,8058,8143,8183,8224,8608,8638,8705,8793,8815,8825,8871,8916,8922,8944,9021,9124,9139,9145,9155,9177,9188,9241,9262,9318,9359,9388,9435,9497,9541,9557,9591,9645,9688,9717,9738,9750,9754,9783,9794,9835,9874,9885,9900,9909,9921,9972,9985,10008,10036,10132,10194,10207,10230,10231,10233,10238,10245,10339,10443,10551,10560,10566,10581,10592,10627,10656,10660,10676,10692,10739,10741,10760,10794,10807,10827,10839,10846,10852,10870,10871,10920,10996,11067,11085,11120,11156,11162,11352,11396,11475,11546,11593,11619,11654,11726,11740,11741,11762,11831,11922,11936,11963,11981,12023,12051,12078,12160,12179,12203,12384,12398,12405,12443,12539,12568,12580,12608,12651,12652,12659,12660,12697,12698,12721,12742,12835,12864,12924,12933,12934,12946,13033,13121,13240,13280,13315,13326,13425,13464,13523,13590,13607,13639,13668,13705,13924,13953,13978,13989,13990,14023,14145,14183,14228,14246,14410,14453,14810,14831,14981,15118,15169,15235,15572,15612,15683,15852,15925,16190,16241,16302,16369,16381,16459,16467,16561,16642,17112,17257,17287,17313,17481,17539,17553,17608,17627,18056,18252,18289,18404,18495,18497,19243,19341,19513,19523,19776,19911,19933,20209,20646,20688,20807,20915,21058,21082,21250,21294,21875,21968,21998,22210,22522,22885,23663,24091,24308,24319,24346,24410,24451,24741,24934,24993,24994,25521,25567,25568,25598,25702,25774,25808,26008,26014,26094,26552,26564,26572,26587,26673,26694,26719,26770,26831,26880,26933,26961,26995,27010,27021,27074,27151,27157,27173,27252,27268,27279,27322,27352,27496,27680,27704,27741,27806,27869,27875,27976,28091,28106,28327,28635,29543,29746,30130,30896,30966,31656,31736,31768,31780,31798,31971,32739,32742,32902,1702,2462,3310,4334,4937,5405,5425,5472,5851,5948,6966,7055,9543,10761,28903,3457,4313,4500,5435,6529,6710,7392,7393,7772,9441,12990,13191,14310,16357,17632,18637,18805,19631)
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 | 222 | 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 |