Tiempo de la consulta: 11.93 ms Después de la última consulta: 1.02 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-09-08 00:20:23' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-09-08 00:20:23' )
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 (881,895,914,926,1001,1052,1069,1103,1115,1121,1127,1129,1133,1135,1136,1142,1150,1166,1184,1187,1196,1210,1258,1305,1300,1320,1331,1336,1341,1352,1351,1389,1408,1429,1443,1450,1455,1538,1576,1607,1680,1728,1735,1739,1746,1766,1776,1780,1823,1824,1864,1882,1975,2000,2008,2029,2034,2074,2089,2107,2114,2149,2156,2169,2171,2235,2238,2239,2291,2344,2383,2408,2415,2430,2508,2532,2583,2661,2664,2674,2678,2680,2725,2742,2754,2788,2816,2817,2839,2903,2920,2950,2961,2975,2981,3013,3022,3029,3053,3073,3089,3096,3131,3163,3149,3184,3202,3278,3356,3367,3380,3423,3438,3474,3482,3504,3530,3542,3554,3569,3582,3594,3633,3666,3670,3677,3685,3780,3787,3798,3811,3823,3855,3883,3947,3988,3999,4026,4005,4038,4045,4068,4075,4098,4102,4120,4111,4133,4157,4167,4188,4189,4209,4223,4231,4257,4271,4278,4432,4453,4465,4672,4729,4744,4756,4795,4803,4835,4852,4863,4898,4922,4960,4988,5113,5114,5178,5180,5200,5239,5252,5270,5307,5316,5379,5505,5566,5561,5586,5606,5605,5625,5652,5658,5674,5685,5689,5751,5808,5827,5830,5863,5899,5927,5880,6004,6016,6104,6117,6213,6250,6324,6361,6383,6455,6461,6518,6528,6529,6535,6564,6567,6696,6697,6767,6781,6829,6846,6928,6945,6960,6962,6969,6975,6976,7000,7029,7049,7070,7185,7194,7208,7274,7301,7309,7318,7319,7339,7346,7369,7376,7384,7386,7420,7438,7448,7556,7561,7595,7612,7614,7617,7629,7655,7671,7698,7724,7760,7772,7774,7799,7803,7817,7845,7866,7881,7887,7928,7933,7951,7969,7985,8022,8043,8057,8060,8066,8086,8109,8133,8147,8148,8169,8184,8192,8195,8201,8202,8220,8276,8288,8305,8320,8321,8335,8381,8415,8434,8462,8490,8493,8498,8507,8523,8527,8536,8540,8563,8575,8576,8583,8587,8588,8591,8593,8601,8613,8614,8620,8638,8641,8731,8766,8891,8946,8981,9032,9052,9077,9084,9114,9170,9189,9202,9204,9218,9227,9303,9305,9433,9462,9487,9495,9555,9593,9629,9658,9674,9686,9693,9702,9779,9899,9904,9914,9928,9938,9981,10512,10567,10911,11297,11350,11372,11398,11410,11504,11566,11603,11617,11645,11681,11689,11702,11722,11730,11772,11798,11882,12234,12282,12412,12559,12594,12766,12798,13034,13062,13085,13113,13156,13216,13297,13382,13402,13481,13594,13651,13657,13722,13863,13946,13973,14004,14107,14179,14550,14774,15356,16092,16534,17614,17707,17895,18228,18734,19362,19451,19811,20159,20178,20315,20453,20718,20821,21372,21664,21678,21695,21822,21831,21896,21904,21911,21933,21958,21986,22001,22119,22144,22404,22558,22599,22843,23247,23839,24564,24768,25080,25145,25265,25424,25451,25517,25627,25781,26093,26768,26772,26847,27082,27098,27248,27302,27469,27924,28018,28477,29292,29668,29833,29996,30459,30702,31497,31514,31582,31625,31629,31641,31654,31660,31711,32335,32383,32589,32665,32672,2433,2965,3135,3638,3681,5715,6020,6555,7068,7961,8159,8604,8624,8863,9088,9676,10228,10281,11411,11555,12786,12806,12829,12886,13053,13063,13089,13110,13221,13664,13688,14532,14649,14761,14777,14807,14852,14940,14969,15024,15038,15108,15156,15212,15222,15261,15288,15366,15407,15499,15564,15577,15599,15621,16129,16142,16200,16210,16298,16388,16456,16504,16525,16628,16681,16735,16948,16997,17015,17091,17162,17178,17230,17254,17297,17321,17342,17363,17499,17669,17681,17809,17901,18015,18041,18054,18096,18128,18208,18220,18285,18299,18312,18591,18601,18735,18815,18883,18969,19039,19186,19232,19280,20207,20241,20252,20809,21667,23975,24219,24422,25060,25346,25828,25957,26029,26217,26339,26358,26516,26523,26862,26997,27040,27182,27269,27341,27357,28116,28168,28181,28229,28268,28497,28512,28963,29004,29277,29359,29561,29582,29591,29713,29789,29860,29891,30003,30126,30236,30386,30502,30512,30537,30609,31477,31607,32026,32154,32292,32346,32534,32551,32582,32613,32683,32693,26203,26253,26556,26717,27419,27451,27646,27673,27683,27708,27744,27761,27776,27871,27910,28021,28031,28086,28098,28142,28257,28267,28336,28369,28393,28397,28446,28463,28470,28483,28532,28550,28631,28672,28748,28777,28793,28807,28837,28876,28891,28945,28978,29056,29100,29156,29177,29214,29231,29268,29270,29272,29351,29393,29425,29472,29530,29546,29578,29626,29682,29726,29747,29775,29777,29818,29827,29878,29974,30000,30067,30103,30115,30142,30226,30252,30314,30330,30331,30378,30390,30447,30478,30485,30552,30580,30584,30620,30643,30648,30706,30717,30724,30725,30728,30744,30764,30781,30816,31457,31510,31761,31804,31849,31871,31942,31964,31975,31994,32002,32040,32046,32082,32114,32142,32168,32181,32192,32204,32240,32255,32423,32457,32484,32637,32707,32718)
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 | 242 | 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 |