Tiempo de la consulta: 12.54 ms Después de la última consulta: 1.12 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-08-07 23:10:19' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-08-07 23:10:19' )
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 (853,879,892,1017,1080,1123,1228,1327,1400,1431,1435,1439,1608,1659,1699,1893,2010,2027,2031,2122,2183,2155,2271,2371,2437,2558,2940,3048,3121,3348,3363,3367,3455,3458,3520,3663,3692,3699,3752,3933,4024,4093,4101,4151,4196,4244,4216,4275,4366,4412,4358,4462,4463,4436,4519,4551,4576,4597,4639,4665,4690,4806,4846,4872,5016,5228,5257,5272,5276,5319,5320,5359,5363,5394,5404,5449,5463,5465,5482,5507,5533,5501,5594,5752,5807,5811,5837,5842,5915,5992,6193,6280,6418,6430,6607,6635,6782,6799,6834,6870,6886,6940,6954,6994,7002,7016,7038,7045,7134,7251,7258,7418,7452,7601,7680,7711,7833,7890,8058,8209,8253,8270,8298,8396,8626,8646,8687,8610,8777,8902,8906,9110,9382,9354,9670,9956,9967,9996,10051,10207,10245,10212,10465,10517,10606,10935,10977,11097,11256,11409,11421,11447,11487,11635,11739,11753,11788,11831,11887,11889,11990,11992,12047,12105,12191,12230,12236,12249,12314,12444,12516,12539,12639,12836,12949,12998,13240,13344,13565,14042,14289,14557,14660,14794,14821,14848,14861,14882,14932,15002,15042,15086,15202,15562,15641,15705,15756,15767,15799,15955,15963,16016,16049,16078,16337,16405,16413,16425,16467,16586,16765,17262,17381,17404,17582,17729,17933,18059,18239,18717,19147,19197,19424,19426,19445,19549,19585,19746,20009,20500,20768,21421,21620,21631,21702,21914,22037,22101,22121,22349,22865,23485,23523,23772,23783,24577,24829,24870,24977,25023,25051,25413,25569,26073,26193,26628,26700,26715,26831,26894,26946,27211,27673,27837,28441,29308,29752,29755,29803,30147,30767,31020,31261,31298,31699,31967,31971,31976,31984,32085,32148,32357,32556,32571,32889,34158,34352,34590,34717,34827,34908,35339,36181,36584,37021,37078,2163,2244,2331,2352,2424,2766,2878,2994,3005,3106,3133,3162,3361,3400,3437,3557,3589,3610,3655,3930,3997,4066,4472,4612,4646,4790,4892,4929,4982,5085,5104,5133,5151,5216,5230,5256,5266,7065,7139,7222,7255,7419,7442,7455,7492,7508,7517,7560,7587,7603,7633,7645,7672,7715,7768,7780,7894,7911,7937,7946,8068,8199,8205,8329,8519,8537,8605,8671,8795,8821,8839,8929,8959,8970,8985,9003,9014,9027,9054,9080,9092,9128,9144,9169,9179,9210,9252,9270,9340,9390,9423,9457,9564,9620,9631,10850,13363,13487,15510,15744,15904,15968,15981,16053,16095,17177,17569,17606,18070,18310,19016,19074,19241,19526,19560,19703,19716,19727,19738,19793,19880,19888,19931,19941,19957,19968,19969,19987,20036,20100,20155,20192,20291,20314,20331,20337,20424,20439,20490,20575,20608,20627,20670,20711,20796,20866,21698,21923,23232,23239,23312,23371,23483,23509,23560,23584,23624,23637,23651,23677,23691,23763,23810,23836,24337,26971,27188,27201,27232,27246,27301,27407,27485,27641,27710,27810,27860,27896,27961,27963,28026,28202,28235,28287,28341,28388,28454,28508,28528,28552,28606,28615,28751,28798,29196,29901,30934,31049,31197,31278,31300,31450,31484,31528,31548,31590,31623,31640,31802,31827,31912,31949,31979,32021,32250,32400,32453,32467,35051,35097,35195,35229,35256,35274,35333,35345,35350,35361,35405,35437,35461,35522,35561,35587,35755,35812,36042,36048,36240,36295,36357,36423,36450,36625,36810,3829)
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 | 395 | 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.38 ms |
checking permissions | 0.00 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.04 ms |
Table lock | 0.00 ms |
After table lock | 0.00 ms |
Waiting for query cache lock | 0.00 ms |
After table lock | 0.10 ms |
init | 0.23 ms |
optimizing | 0.15 ms |
statistics | 1.06 ms |
preparing | 0.85 ms |
executing | 0.00 ms |
Sorting result | 0.04 ms |
Sending data | 3.54 ms |
Waiting for query cache lock | 0.00 ms |
Sending data | 0.07 ms |
Waiting for query cache lock | 0.01 ms |
Sending data | 5.63 ms |
end | 0.00 ms |
query end | 0.01 ms |
closing tables | 0.01 ms |
freeing items | 0.02 ms |
updating status | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
updating status | 0.03 ms |
Waiting for query cache lock | 0.01 ms |
updating status | 0.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.03 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 |