Query Time: 2.73 ms After last query: 0.51 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 22:38:30' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-06-19 22:38:30' )
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 (53,20,115,221,224,300,301,802,824,835,848,855,875,885,887,888,904,907,912,914,981,1009,1033,1044,1074,1075,1076,1077,1083,1096,1118,1120,1122,1140,1149,1171,1180,1186,1192,1204,1211,1221,1222,1263,1288,1289,1291,1292,1293,1300,1315,1318,1326,1332,1345,1358,1360,1397,1425,1469,1480,1481,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,341,346,347,348,359,364,365,366,367,371,372,381,389,410,409,440,444,445,448,449,456,457,466,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,551,552,553,569,570,572,575,592,593,594,599,601,602,603,604,605,645,648,649,651,650,652,653,654,655,656,666,669,695,704,718,727,741,742,745,747,756,757,760,767,768,770,772,773,774,779,799,804,811,812,813,818,833,838,857,858,865,896,906,908,937,949,964,973,974,975,991,992,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,1236,1237,1241,1255,1267,1268,1275,1296,1297,1302,1338,1353,1401,1408,1410,1420,1421,1422,1423,1430,1444,1449,1510,1514,1519,1537,1540,1541,1546,1552,1560,1561,1571,1596,1597,1598,673,667,674,702,706,715,716,717,719,720,721,722,723,725,724,726,728,729,730,731,733,735,736,737,740,743,746,753,754,759,763,761,762,764,765,766,769,777,778,781,783,784,785,786,792,798,801,800,808,823,826,827,830,829,831,834,840,846,845,861,862,863,864,867,868,878,879,886,892,894,905,903,925,926,931,932,933,934,940,941,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,1063,1064,1065,1066,1067,1068,1069,1070,1072,1073,1079,1085,1087,1088,1089,1090,1091,1093,1094,1095,1098,1099,1101,1103,1102,1106,1108,1107,1109,1110,1111,1115,1121,1125,1126,1127,1130,1131,1134,1138,1143,1144,1150,1161,1168,1169,1178,1179,1195,1196,1197,1199,1205,1209,1212,1214,1218,1224,1223,1225,1228,1227,1226,1230,1231,1233,1234,1247,1250,1252,1251,1254,1257,1258,1273,1274,1284,1285,1286,1287,1294,1298,1299,1304,1305,1314,1316,1317,1319,1320,1330,1333,1334,1335,1350,1351,1361,1367,1368,1369,1370,1382,1389,1391,1390,1392,1393,1394,1395,1396,1400,1414,1419,1424,1426,1427,1428,1429,1431,1432,1436,1437,1443,1447,1446,1445,1448,1453,1455,1475,1457,1462,1463,1465,1471,1478,1482,1488,1490,1491,1500,1508,1512,1513,1515,1516,1517,1521,1527,1528,1548,1554,1553,1555,1556,1564,1573,1575,1577,1579,1581,1590,1295,1301,1303,1306,1307,1308,1309,1310,1311,1312,1313)
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 | 25 | 35.99 | 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
