Tiempo de la consulta: 134.02 ms Después de la última consulta: 0.89 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-04-04 18:36:49' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-04-04 18:36:49' )
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 (953,1001,1052,1069,1099,1116,1119,1127,1129,1133,1135,1136,1142,1150,1166,1205,1210,1305,1300,1331,1341,1352,1408,1580,1627,1660,1739,1749,1780,1823,1864,1910,2054,2089,2107,2114,2149,2238,2408,2418,2477,2508,2583,2587,2591,2636,2661,2709,2742,2920,2973,3197,3216,3347,3380,3428,3438,3542,3582,3633,3666,3811,3883,3947,3988,4045,4098,4111,4157,4186,4188,4209,4223,4317,4360,4390,4432,4624,4729,4788,4852,5049,5159,5180,5307,5316,5330,5379,5505,5566,5561,5674,5685,5751,5827,5880,6004,6189,6271,6315,6545,6559,6565,6734,6747,6781,7000,7194,7208,7216,7301,7369,7376,7484,7772,8148,8575,8807,8870,9052,9227,9315,9462,9487,9658,959,988,996,995,1095,1098,1106,1109,1122,1130,1164,1229,1239,1244,1245,1528,1606,1638,1639,1730,1778,1903,1919,1964,1995,2097,2145,2236,2258,2359,2389,2432,2480,2483,2533,2604,2921,3100,3601,3820,4498,4595,4737,4762,5479,7047,10009,1223,1358,3251,3205,3513,3604,3861,4216,4436,4971,5022,5667,5672,6360,6899,7020,8808,9221,10212,10631,10928,11015,13149,13855,15612,17205,19456,20485,21147,21280,21304,21500,22008,22434,22775,22794,23238,23434,23517,23611,23665,23711,23748,23976,24277,24301,24429,24438,24455,24469,24491,24512,24563,24574,24621,24667,24681,24833,25090,25141,25160,25226,25287,25757,25912,25939,26021,26077,26193,26540,26607,26700,26841,27305,27548,27605,27739,27750,27828,27885,27974,28027,28064,28139,28154,28236,28351,28513,28856,28909,29134,29734,29793,29863,29912,29968,29998,30026,30131,30178,30215,30299,30366,30376,30599,30650,30658,30659,30758,30976,31044,31159,31287,31431,31580,31673,31818,31890,31907,32044,32057,32137,32404,32778,32814,32838,33091,33123,33310,33508,33794,14376,18391,20918,21031,21344,21375,32774,9267,10349,10404,10691)
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 | 377 | 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.04 ms |
Waiting for query cache lock | 0.01 ms |
checking query cache for query | 0.38 ms |
checking permissions | 0.01 ms |
checking permissions | 0.01 ms |
Opening tables | 0.03 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
After table lock | 0.01 ms |
Waiting for query cache lock | 0.01 ms |
After table lock | 0.09 ms |
init | 0.18 ms |
optimizing | 0.12 ms |
statistics | 0.88 ms |
preparing | 0.64 ms |
executing | 0.01 ms |
Sorting result | 0.01 ms |
Sending data | 81.90 ms |
Waiting for query cache lock | 0.02 ms |
Sending data | 29.58 ms |
Waiting for query cache lock | 0.02 ms |
Sending data | 13.76 ms |
Waiting for query cache lock | 0.02 ms |
Sending data | 1.86 ms |
end | 0.02 ms |
query end | 0.01 ms |
closing tables | 0.02 ms |
freeing items | 0.04 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.03 ms |
updating status | 0.01 ms |
storing result in query cache | 0.01 ms |
cleaning up | 0.02 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 |