Tiempo de la consulta: 8.44 ms Después de la última consulta: 0.50 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 <= '2025-05-22 12:10:22' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-05-22 12:10:22' )
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 (944,1018,1061,1161,1203,1242,1306,1369,1406,1527,1802,1898,1943,2007,2071,2150,2154,2246,2329,2349,2385,2402,2406,2412,2470,2490,2512,2535,2545,2576,2582,2645,2671,2692,2695,2707,2716,2787,2825,2863,2864,2911,2940,2954,3011,3015,3145,3177,3189,3249,3297,3414,3526,3644,3662,3897,3915,3978,3993,3994,3995,4047,4073,4079,4119,4141,4229,4259,4264,4296,4348,4381,4386,4497,4533,4560,4598,4609,4668,4714,4810,4814,4861,4867,4940,4942,4975,5037,5137,5172,5213,5257,5272,5383,5440,5447,5466,5507,5512,5524,5613,5642,5692,5699,5772,5803,5938,5976,6003,6015,6028,6065,6094,6135,6141,6171,6172,6197,6224,6357,6380,6418,6424,6446,6448,6466,6501,6543,6568,6576,6577,6619,6631,6664,6718,6756,6822,6836,6840,6843,6839,6884,6885,6887,6959,7030,7050,7052,7099,7226,7230,7256,7270,7275,7332,7429,7435,7459,7567,7572,7585,7642,7669,7679,7687,7704,7713,7733,7763,7781,7789,7800,7806,7893,7907,7918,7935,7936,7976,7997,8046,8061,8111,8149,8153,8239,8272,8274,8326,8347,8367,8416,8558,8631,8650,8660,8691,8787,8829,8867,8968,8979,9194,9222,9234,9248,9249,9266,9284,9335,9366,9387,9403,9452,9463,9465,9466,9474,9531,9561,9663,9673,9964,10093,10116,10132,10231,10260,10527,10546,10588,10626,12231,13003,13199,16618,16738,17093,17104,955,982,1035,1064,1201,1202,1385,1445,1496,1499,1604,1621,1704,1723,1751,1755,1782,1817,1884,1897,2028,2069,2078,2125,2151,2187,2233,2304,2423,2443,2466,2491,2493,2514,2510,2546,2550,2559,2611,2622,2633,2651,2664,2669,2673,2702,2758,2760,2780,2789,2824,2847,2851,2867,2872,2874,2884,2908,2970,2971,2973,2976,2990,3018,3074,3080,3083,3086,3144,3156,3159,3169,3180,3183,3230,3238,3245,3253,3300,3319,3357,3369,3399,3416,3438,3450,3454,3460,3479,3489,3493,3501,3527,3534,3544,3545,3556,3580,3585,3602,3625,3630,3635,3697,3701,3718,3736,3737,3742,3747,3748,3751,3753,3768,3782,3791,3792,3797,3806,3813,3834,3878,3880,3903,3923,3962,4048,4060,4118,4179,4190,4228,4270,4279,4318,4333,4345,4372,4396,4415,4420,4437,4510,4542,4573,4584,4600,4675,4677,4711,4721,4818,4870,4882,4908,4928,4994,5207,5255,5345,5385,5398,5409,5415,5437,5484,5506,5522,5670,5702,5814,5815,5828,5838,5937,5971,6032,6049,6066,6129,6169,6396,6417,6575,6629,6658,6672,6678,6735,6773,6788,6814,6825,6910,7059,7086,7118,7183,7189,7379,7407,8643,8964,9253,9482,9599,9610,9693,9759,9780,9799,9890,9925,10013,10243,10270,10283,10611,10674,10763,1052,1296,1401,1412,1544,1584,1626,1650,1662,1730,1959,2572,2690,2819,3092,3204,3282,3367,3911,4001,4244,4467,4487,4568,4580,4591,4806,5003,5111,5240,5314,5362,5377,5381,5390,5402,5449,5465,5486,5517,5654,5727,6371,6761,6886,7665,7989,8070,8506,8695,8745,8775,8906,9302,9340,9388,9670,9731,9742,9748,9839,9957,10045,10227,10606,10647,10656,10690,10832,10833,10879,10933,11242,11328,11370,11378,11975,12268,12327,12653,12947,14620,15055,15088,15727,16096,16324,16718,16786,16913,16919,17244,17491,17854,18122,18383,18785,19315,19401,19555,19763,19778,20478,21495,21506,21823,22015,23460,24564,24600,24777,24853,24898,25065,25496,25779,25990,26211,26269,26365,26860,26888,26915,27051,27177,27409,27458,27785,28508,28658,29003,29113,29544,30049,30080,30651,31466,32556,32680,32689,33566,33621,34049,34052,34102,34194,34717,35045,35307,35379,35445,35481,1373,3041,3154,4543,10262,12571,2124,2359,2705,2887,4198,5158,5487,6795,7569,10413,2136,2557,5064,7703,8154,9458,10815,5088)
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 | 311 | Using where |
1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | admin_ddpue3.i.catid | 1 | Using where |
Status | Duration |
---|
starting | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
checking query cache for query | 0.23 ms |
checking permissions | 0.01 ms |
checking permissions | 0.00 ms |
Opening tables | 0.01 ms |
After opening tables | 0.01 ms |
System lock | 0.00 ms |
Table lock | 0.00 ms |
After table lock | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
After table lock | 0.05 ms |
init | 0.12 ms |
optimizing | 0.07 ms |
statistics | 0.65 ms |
preparing | 0.44 ms |
executing | 0.01 ms |
Sorting result | 0.02 ms |
Sending data | 2.12 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 4.49 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 0.02 ms |
end | 0.01 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.01 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.00 ms |
updating status | 0.00 ms |
storing result in query cache | 0.00 ms |
cleaning up | 0.01 ms |
# | 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 |