Tiempo de la consulta: 353.12 ms Después de la última consulta: 0.99 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-10-13 09:24:02' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-10-13 09:24:02' )
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 (15187,15286,15560,17855,18257,18416,18619,18669,18978,19304,19534,19637,19657,19668,19686,19849,19904,19907,19934,19940,19937,19946,19954,20020,20050,20058,20090,20107,20121,20138,20175,20194,20204,20225,20232,20285,20304,20311,20312,20336,20338,20369,20380,20397,20399,20417,20425,20432,20460,20473,20486,20507,20521,20541,20543,20547,20561,20578,20580,20583,20584,20591,20595,20597,20613,20625,20638,20652,20655,20680,20690,20701,20715,20719,20722,20739,20756,20770,20781,20795,20799,20811,20814,20833,20842,20862,20875,20877,20885,20887,20907,20938,20949,20966,20970,20992,20994,21005,21014,21030,21035,21047,21084,21119,21129,21140,21158,21171,21185,21206,21211,21274,21285,21299,21312,21309,21321,21324,21337,21351,21355,21383,21386,21397,21404,21413,21425,21430,21440,21470,21498,21502,21525,21528,21538,21541,21560,21573,21577,21578,21587,21610,21617,21638,21651,21662,21693,21701,21707,21719,21722,21734,21744,21775,21785,21799,21800,21813,21824,21829,21848,21867,21881,21934,21950,21965,21994,22003,22031,22038,22060,22091,22093,22104,22124,22135,22146,22165,22177,22191,22204,22211,22227,22239,22253,22265,22263,22269,22280,22293,22318,22333,22347,22384,22395,22420,22428,22456,22467,22481,22485,22511,22525,22527,22536,22551,22555,22600,22634,22653,22670,22682,22693,22704,22742,22764,22786,22792,22802,22819,22823,22844,22857,22863,22867,22871,22876,22899,22925,22959,22993,22997,23028,23156,23225,23255,23273,23291,23290,23304,23316,23327,23355,23356,23368,23381,23400,23411,23416,23429,23432,23444,23446,23445,23454,23463,23470,23477,23493,23503,23512,23513,23518,23526,23547,23556,23571,23580,23591,23595,23606,23607,23622,23634,23641,23645,23658,23684,23693,23725,23733,23756,23776,23790,23802,23814,23827,23837,23862,23869,23885,23893,23906,23915,23928,23937,23941,23952,23962,23984,23998,24009,24023,24043,24053,24072,24079,24086,24108,24112,24123,24127,24143,24151,24171,24179,24185,24198,24199,24213,24215,24226,24228,24248,24249,24255,24270,24285,24298,24299,24307,24314,24328,24345,24349,24369,24386,24397,24407,24422,24417,24423,24436,24446,24463,24474,24490,24498,24507,24521,24534,24559,24569,24583,24592,24603,24620,24636,24642,24651,24662,24678,24710,24717,24739,24754,24766,24775,24780,24795,24802,24817,24832,24841,24854,24871,24884,24892,24901,24904,24907,24908,24948,24962,24959,24975,24997,25002,25004,25007,25013,25015,25027,25032,25039,25042,25046,25053,25066,25074,25076,25079,25091,25115,25127,25139,25148,25170,25179,25192,25197,25202,25200,25214,25216,25217,25238,25239,25241,25244,25257,25254,25267,25270,25277,25297,25298,25310,25321,25360,25374,25383,25400,25402,25408,25410,25419,25431,25436,25440,25451,25468,25476,25518,25532,25536,25550,25554,25555,25557,25563,25564,25572,25573,25587,25588,25600,25608,25613,25633,25649,25672,25677,25692)
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 | 464 | 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 |