Query Time: 2.23 ms After last query: 0.60 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 20:26:16' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-06-19 20:26:16' )
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 (93,57,84,54,98,89,138,145,146,153,155,238,280,302,303,307,313,318,325,351,387,388,390,393,394,395,397,412,411,413,451,453,454,465,466,467,468,474,495,497,499,500,501,502,516,519,547,548,550,553,551,554,555,556,560,565,567,568,573,580,583,584,585,586,588,589,590,591,595,597,606,645,646,653,656,670,671,672,691,692,693,694,699,705,706,723,725,730,741,746,760,761,764,765,778,801,800,809,826,833,834,879,881,976,993,1035,1043,1057,1063,1064,1091,1095,1096,1099,1134,1153,1167,1184,1188,1189,1193,1205,1214,1234,1240,1246,1254,1261,1272,1287,1297,1298,1301,1305,1317,1333,1344,1465,1462,1463,1485,1504,1516,1517,1518,1526,1533,1552,1565,1582,74,108,194,214,222,226,232,233,245,246,247,251,252,282,293,294,295,301,305,306,317,321,323,326,329,374,648,649,651,650,654,655,666,724,781,836,840,882,932,933,940,941,1034,1042,1073,1126,1152,1157,1233,1257,1275,1343,1415,1417,1432,1433,1441,1448,1455,1510,1553,1566,1574,221,224,225,227,229,230,231,234,236,241,242,243,244,248,249,250,253,254,258,260,262,263,265,266,267,268,269,270,271,275,276,277,278,279,281,283,284,285,287,288,289,290,291,292,310,331,332,333,334,335,336,337,338,339,340,341,346,347,348,359,364,365,366,367,371,372,381,389,410,409,440,444,445,448,449,456,457,469,470,471,477,479,480,481,482,483,484,486,489,496,503,504,505,506,507,514,515,520,521,528,530,529,531,532,533,534,535,536,537,538,552,569,570,572,575,592,593,594,599,601,602,603,604,605,652,669,695,704,718,727,742,745,747,756,757,767,768,770,772,773,774,779,799,802,804,811,812,813,818,824,835,838,848,857,858,865,875,885,896,904,907,906,908,912,937,949,964,973,974,975,991,992,1000,1037,1038,1039,1041,1044,1071,1074,1078,1077,1080,1081,1082,1092,1118,1146,1147,1155,1154,1163,1181,1183,1186,1190,1207,1215,1221,1222,1232,1236,1237,1241,1267,1268,1288,1290,1296,1302,1318,1338,1353,1397,1401,1408,1410,1420,1421,1422,1423,1430,1444,1449,1480,1481,1487,1514,1519,1537,1540,1541,1546,1560,1561,1571,1596,1597,1598,673,667,674,702,715,716,717,719,720,721,722,726,728,729,731,733,735,736,737,740,743,753,754,759,763,762,766,769,777,783,784,785,786,792,798,808,823,827,830,829,831,846,845,861,862,863,864,867,868,878,886,892,894,905,903,914,925,926,931,934,943,945,948,952,953,959,963,960,979,980,983,984,987,986,985,988,990,995,999,1001,1002,1010,1013,1015,1016,1017,1018,1019,1021,1023,1024,1026,1028,1029,1030,1027,1025,1022,1020,1014,1045,1046,1047,1049,1050,1059,1060,1061,1065,1066,1067,1068,1069,1070,1072,1076,1079,1085,1087,1088,1089,1090,1093,1094,1098,1101,1103,1102,1106,1108,1107,1109,1110,1111,1115,1121,1125,1127,1130,1131,1138,1140,1143,1144,1150,1161,1168,1169,1178,1179,1195,1196,1197,1199,1209,1211,1212,1218,1224,1223,1225,1228,1227,1226,1230,1231,1247,1250,1252,1251,1258,1273,1274,1284,1285,1286,1294,1293,1292,1291,1289,1299,1300,1304,1314,1316,1319,1320,1330,1332,1334,1335,1350,1351,1361,1367,1368,1369,1370,1382,1389,1391,1390,1392,1393,1394,1395,1396,1400,1414,1419,1425,1424,1426,1427,1428,1429,1431,1436,1437,1443,1447,1446,1445,1453,1475,1457,1471,1478,1482,1488,1490,1491,1500,1508,1512,1513,1515,1521,1527,1528,1547,1548,1554,1555,1556,1564,1573,1575,1577,1579,1581,1590,1253,1256,1259,1262,1264,1263,1265,1266,1269,1270,1271,1276,1277,1281,1283,1282)
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 | 21 | 42.47 | 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
