Tiempo de la consulta: 494.24 ms Después de la última consulta: 1.33 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-27 04:23:32' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-11-27 04:23:32' )
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 (986,2978,2989,3069,3086,3117,3175,3328,3538,3976,4548,4935,5123,5130,5781,6836,7266,8410,8426,8703,8819,8841,8861,8954,9183,9552,10737,11213,11354,11453,11448,11467,11477,11478,11549,11589,11637,11817,11852,11853,11860,11865,11866,11905,12005,12006,12021,12027,12045,12057,12073,12098,12104,12108,12111,12122,12141,12144,12146,12165,12177,12178,12181,12184,12190,12201,12204,12222,12228,12240,12244,12250,12251,12262,12265,12277,12297,12298,12304,12330,12345,12387,12406,12408,12414,12417,12425,12440,12456,12458,12459,12473,12491,12495,12508,12510,12521,12524,12536,12544,12546,12552,12556,12570,12571,12576,12565,12590,12599,12615,12619,12625,12629,12647,12660,12661,12665,12666,12671,12704,12706,12708,12719,12738,12750,12782,12783,12788,12800,12828,12830,12833,12841,12849,12850,12854,12869,12893,12910,12929,12990,12992,13004,13015,13023,13025,13039,13059,13119,13135,13164,13165,13175,13176,13188,13212,13214,13218,13227,13237,13249,13256,13259,13345,13347,13356,13351,13366,13367,13368,13375,13377,13378,13384,13387,13414,13419,13437,13445,13451,13457,13467,13468,13475,13489,13493,13498,13505,13506,13508,13518,13559,13573,13600,13602,13626,13629,13635,13646,13652,13669,13677,13679,13682,13696,13706,13709,13722,13723,13725,13733,13736,13738,13743,13767,13773,13779,13794,13803,13821,13822,13830,13841,13849,13859,13868,13872,13880,13889,13907,13920,13930,13946,13960,13969,13987,14010,14029,14038,14058,14067,14080,14084,14097,14107,14118,14129,14144,14186,14208,14247,14251,14279,14286,14313,14329,14341,14386,14392,14407,14418,14421,14439,14440,14488,14526,14568,14573,14584,14598,14600,14603,14609,14623,14625,14631,14644,14664,14668,14674,14684,14690,14705,14712,14714,14720,14722,14738,14745,14756,14763,14764,14770,14790,14799,14804,14811,14834,14865,14868,14884,14885,14886,14941,14982,14990,14994,15024,15008,15034,15045,15051,15088,15103,15117,15120,15136,15167,15176,15185,15243,15257,15271,15276,15285,15292,15322,15334,15381,15382,15448,15453,15503,15544,15558,15566,15569,15577,15581,15582,15585,15586,15597,15618,15627,15628,15644,15667,15686,15692,15703,15714,15716,15726,15729,15742,15755,15766,15778,15800,15808,15824,15834,15842,15887,15923,15926,15927,15947,15979,15994,15998,16007,16010,16038,16040,16042,16045,16059,16066,16074,16087,16089,16101,16108,16125,16130,16136,16155,16164,16165,16174,16179,16185,16198,16218,16228,16248,16254,16256,16276,16279,16287,16289,16308,16323,16343,16359,16361,16376,16382,16384,16408,16412,16419,16421,16441,16449,16450,16468,16471,16475,16480,16501,16502,16514,16531,16537,16545,16557,16563,16566,16570,16574,16579,16582,16611,16619,16620,16632,16652,16653,16654,16679,16680,16688,16691,16693,16700,16701,16710,16713,16740,16742,16750,16752,16755,16769,16780,16784,16789,16790,16806,16815,16821,16825,16832,16843,16847,16851,16859,16861,16862,16890,16894,16903,16909,16915,16920,16924,16927,16963,16964,16988,17003,17030,17041,17050,17059,17062,17063,17073,17075,17098,17111,17122,17130,17137,17144,17145,17173,17200,17211,17216,17228,17259,17260,17277,17280,17285,17291,17307,17304,17322,17334,17340,17343,17354,17366,17383,17385,17402,17408,17409,17416,17424,17446,17452,17463,17465,17476,17477,17489,17483,17495,17518,17527,17528,17536,17545,17546,17552,17556,17603,17613,17630,17634,17642,17646,17650,17675,17680,17691,17717,17745,17756,17772,17793,17818,17821,17826,17834,17836,17839,17858,17869,17872,17909,17919,17922,17935,17944,17949,17957,17972,17988,17997,18023,18028,18040,18065,18087,18108,18135,18143,18171,18183,18202,18212,18266,18274,18321,18397,18406,18419,18435,18465,18478,18494,18507,18535,18542,18566,18578,18585,18694,19554)
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 | 293 | 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 |