Query Time: 2.43 ms After last query: 0.63 ms
SELECT i.*, c.alias as categoryalias
FROM op4k6_k2_items as i
LEFT JOIN op4k6_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-06-19 15:57:50' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-06-19 15:57:50' )
AND i.access IN(1,1)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1)
AND c.trash = 0
AND (i.id) IN (25,27,157,204,219,341,343,344,350,351,352,353,363,377,378,379,380,381,382,383,390,418,429,430,457,469,470,473,476,475,480,481,482,483,484,486,487,488,489,490,491,493,495,497,503,504,506,508,507,510,511,512,513,515,517,520,521,522,523,528,536,537,538,540,541,542,543,544,547,548,549,550,557,560,561,565,566,582,592,593,595,596,598,607,608,611,612,613,614,615,616,617,618,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,643,644,647,656,658,657,660,663,661,664,675,676,679,681,680,682,685,686,688,691,692,694,695,696,700,701,707,708,709,711,712,714,719,720,722,723,731,734,742,743,746,749,750,751,752,753,758,771,772,773,776,778,782,785,788,789,791,793,794,796,808,811,815,817,816,819,820,821,834,837,842,841,844,846,847,859,860,861,888,889,895,898,899,900,916,917,921,926,928,927,929,948,949,952,954,955,956,957,958,959,965,966,967,968,969,970,971,972,978,980,981,983,984,992,993,998,1003,1004,1005,1007,1008,1009,1011,1012,1014,1016,1017,1018,1019,1025,1015,1040,1048,1058,1059,1060,1061,1066,1067,1068,1069,1075,1076,1087,1091,1095,1096,1097,1099,1103,1109,1110,1112,1113,1114,1116,1120,1122,1130,1131,1132,1133,1136,1135,1137,1139,1141,1159,1162,1164,1165,1170,1171,1177,1188,1189,1191,1197,1198,1202,1203,1210,1213,1220,1222,1225,1235,1236,1238,1243,1244,1248,1245,1249,1260,1261,1262,1269,1271,1276,1277,1281,1310,1321,1322,1323,1324,1325,1328,1329,1343,1345,1346,1347,1349,1351,1360,1359,1361,1363,1365,1366,1371,1374,1380,1381,1382,1394,1395,1398,1400,1399,1401,1402,1403,1404,1405,1407,1408,1409,1410,1412,1414,1427,1438,1439,1440,1452,1453,1461,1469,1467,1429,1471,1470,1472,1473,1474,1475,1476,1477,1479,1480,1482,1494,1495,1498,1500,1501,1503,1505,1506,1507,1519,1523,1522,1524,1525,1529,1530,1535,1536,1537,1538,1539,1540,1541,1545,1558,1559,1563,1567,1572,1573,1577,53,20,115,221,224,300,301,802,824,835,848,855,875,885,887,904,907,912,914,1033,1044,1074,1077,1083,1118,1140,1149,1180,1186,1192,1204,1211,1221,1263,1288,1289,1290,1291,1292,1293,1300,1315,1318,1326,1332,1358,1397,1425,1487,1547,225,227,229,230,231,232,233,234,236,241,242,243,244,248,249,250,251,252,253,254,258,260,262,263,265,266,267,268,269,270,271,275,276,277,278,279,281,282,283,284,285,287,288,289,290,291,292,302,310,321,331,332,333,334,335,336,337,338,339,340,346,347,348,359,364,365,366,367,371,372,389,410,409,440,444,445,448,449,456,466,471,477,479,496,505,514,530,529,531,532,533,534,535,551,552,553,569,570,572,575,594,599,601,602,603,604,605,645,648,649,651,650,652,653,654,655,666,669,704,718,727,741,745,747,756,757,760,767,768,770,774,779,799,804,812,813,818,833,838,857,858,865,896,906,908,937,964,973,974,975,991,1000,1037,1038,1039,1041,1042,1043,1071,1078,1080,1081,1082,1092,1146,1147,1152,1155,1154,1163,1167,1181,1183,1190,1207,1215,1232,1237,1241,1255,1267,1268,1275,1296,1297,1302,1338,1353,1420,1421,1422,1423,1430,1444,1449,1510,1514,1546,1552,1560,1561,1571,1596,1597,1598,945,1022,1023,1024,1111,1193,1342,1373,1534,1543,1484,1483,1485,1486,1488,1489,1490)
ORDER BY i.created DESC
LIMIT 0, 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | i | index | PRIMARY,item,catid | created | 5 | NULL | 22 | 40.12 | Using where |
| 1 | SIMPLE | c | eq_ref | PRIMARY,category,published,access,trash | PRIMARY | 4 | u944685417_mundoferretero.i.catid | 1 | 51.52 | Using index condition; Using where |
No SHOW PROFILE (maybe because there are more than 100 queries)
JROOT/components/com_k2/models/itemlist.php:969
JROOT/components/com_k2/views/item/view.html.php:290
JROOT/libraries/legacy/controller/legacy.php:693
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
