Query Time: 3.82 ms After last query: 0.89 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:39:04' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-06-19 15:39:04' )
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 (74,108,194,214,222,226,232,233,245,246,247,251,252,282,293,294,295,301,305,306,307,317,321,323,325,326,329,374,645,646,648,649,651,650,653,654,655,666,670,724,760,761,781,836,840,881,882,932,933,940,941,1034,1035,1042,1073,1126,1134,1152,1153,1157,1233,1257,1255,1275,1343,1344,1415,1417,1432,1433,1441,1455,1463,1510,1516,1517,1553,1565,1566,1574,221,223,228,230,239,240,241,243,248,250,264,268,273,281,288,291,292,314,322,336,340,345,348,354,355,371,372,375,376,377,378,382,386,387,388,389,394,395,396,397,406,407,408,412,429,430,439,440,441,442,443,444,445,446,449,450,452,454,457,467,468,486,488,493,496,499,500,501,502,503,504,506,508,509,520,524,525,526,527,531,532,533,534,540,541,542,543,544,549,550,552,557,559,558,562,564,565,582,584,593,595,596,598,599,601,603,604,605,608,606,621,622,623,624,625,626,627,628,629,630,631,632,633,634,635,636,637,638,639,640,641,643,644,647,652,656,657,658,663,660,664,668,669,672,673,674,676,677,679,680,681,682,685,688,689,690,692,693,694,695,696,697,698,699,700,709,711,710,712,716,717,720,721,726,727,738,739,746,744,749,750,751,752,753,771,772,773,774,775,776,778,780,779,783,784,785,786,787,789,788,791,793,794,796,803,806,807,808,809,810,815,816,817,819,820,821,834,835,837,839,841,842,844,846,847,859,860,861,863,880,884,883,889,897,898,895,899,900,901,903,906,911,913,916,915,917,918,920,921,924,923,922,926,928,927,929,936,938,939,944,946,947,948,949,952,954,955,956,957,958,959,965,966,967,968,969,970,971,972,973,974,975,978,976,977,979,980,981,984,992,993,994,998,999,1003,1004,1005,1007,1008,1011,1012,1014,1015,1016,1017,1018,1019,1025,1032,1009,1040,1043,1048,1052,1058,1059,1060,1061,1062,1066,1067,1068,1069,1075,1076,1082,1087,1088,1091,1092,1094,1095,1096,1097,1099,1103,1109,1110,1114,1116,1120,1121,1122,1130,1131,1132,1133,1136,1137,1139,1141,1154,1155,1156,1158,1159,1160,1162,1163,1165,1164,1169,1170,1171,1177,1187,1188,1189,1197,1198,1202,1203,1206,1207,1208,1209,1213,1214,1220,1221,1222,1225,1228,1235,1236,1237,1238,1239,1243,1244,1248,1249,1253,1259,1261,1262,1263,1266,1268,1269,1276,1277,1281,1287,1301,1306,1307,1311,1312,1313,1315,1322,1323,1324,1325,1327,1328,1329,1333,1339,1335,1346,1347,1349,1358,1363,1364,1365,1366,1369,1371,1378,1380,1381,1383,1389,1393,1394,1395,1398,1399,1400,1401,1403,1405,1404,1407,1408,1409,1412,1414,1425,1426,1429,1434,1435,1436,1439,1438,1440,1449,1454,1456,1461,1469,1467,1452,1470,1474,1475,1476,1484,1487,1490,1495,1496,1501,1502,1505,1506,1507,1509,1521,1523,1524,1525,1527,1526,1529,1530,1532,1535,1536,1537,1538,1539,1540,1541,1545,1548,1550,1557,1558,1560,1563,1567,1569,1570,1571,1572,1573,1577,1581,419,420,421,422,425,426,428,432,433,435,451,453,458,461,462,463,465,474,743,1056,1348,1447,1528,1542,1582,667,702,706,715,719,722,723,725,728,729,730,731,733,735,736,737,740,741,754,759,763,762,764,765,766,768,769,777,792,798,799,801,800,802,823,826,827,830,829,831,845,862,864,867,868,878,879,886,892,894,905,914,925,931,934,937,943,945,953,963,960,983,987,986,985,988,990,991,995,1001,1002,1010,1013,1021,1023,1024,1026,1028,1029,1030,1027,1022,1020,1044,1045,1046,1047,1049,1050,1063,1064,1065,1071,1070,1072,1074,1079,1085,1089,1090,1093,1098,1101,1102,1106,1108,1107,1111,1115,1125,1127,1138,1140,1143,1144,1150,1161,1168,1178,1179,1195,1196,1199,1205,1211,1212,1218,1224,1223,1227,1226,1232,1230,1231,1234,1247,1250,1252,1251,1254,1258,1273,1274,1284,1285,1286,1290,1294,1293,1292,1291,1289,1298,1299,1300,1304,1305,1314,1316,1317,1319,1320,1330,1332,1334,1350,1351,1361,1367,1368,1370,1382,1391,1390,1392,1396,1410,1419,1421,1422,1423,1424,1427,1428,1431,1437,1444,1443,1446,1445,1453,1457,1462,1465,1471,1478,1482,1488,1491,1500,1508,1512,1513,1514,1515,1546,1547,1554,1552,1555,1556,1564,1575,1579,1590,1442,1451,1450,1459)
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 | 18 | 49.30 | 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
