Query Time: 4.51 ms After last query: 0.53 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:36:59' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-06-19 20:36:59' )
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 (13,41,44,24,25,27,15,157,204,219,220,259,341,343,344,350,351,352,353,363,368,373,377,378,379,380,381,382,383,390,418,429,430,432,452,455,457,466,469,470,471,473,476,475,480,481,482,483,484,486,493,487,488,489,490,491,495,497,503,504,506,508,507,510,511,512,513,515,517,520,521,522,523,528,536,535,537,538,540,541,542,543,544,547,548,549,550,551,557,560,561,565,566,575,582,589,590,592,593,594,595,596,597,598,602,607,608,611,612,613,614,615,616,617,618,621,622,623,624,625,626,627,628,629,630,631,632,633,636,634,635,637,638,639,640,641,643,644,647,648,649,654,656,658,657,660,663,661,664,668,667,671,673,674,675,676,679,678,681,680,682,683,684,685,686,688,691,692,694,695,696,700,701,702,706,707,708,709,711,712,713,714,715,716,717,719,720,722,721,723,725,724,726,727,728,729,730,731,733,735,734,736,737,740,741,742,743,746,749,750,753,751,752,754,759,758,760,763,761,762,764,765,766,768,769,771,772,773,776,774,777,778,781,783,782,784,785,786,788,789,791,792,793,794,796,798,799,801,800,802,808,811,815,817,816,818,819,820,821,823,826,827,830,829,831,834,837,840,842,841,844,846,845,847,859,860,861,862,863,864,867,868,878,879,886,888,889,892,894,895,898,899,900,905,903,914,916,919,917,921,925,926,928,927,929,931,932,933,934,937,940,941,943,945,948,949,952,954,953,956,955,957,958,959,963,960,965,966,967,968,969,970,971,972,978,979,980,981,983,984,987,986,985,988,990,991,992,993,995,998,999,1001,1002,1003,1004,1005,1007,1008,1009,1011,1010,1012,1014,1013,1015,1016,1017,1018,1019,1021,1023,1024,1025,1026,1028,1029,1030,1027,1022,1020,1038,1039,1040,1044,1045,1046,1048,1047,1049,1050,1058,1059,1060,1061,1063,1064,1065,1066,1067,1068,1069,1071,1070,1072,1073,1074,1075,1076,1079,1085,1086,1087,1088,1089,1090,1091,1093,1094,1095,1096,1097,1099,1098,1101,1103,1102,1106,1108,1107,1109,1110,1112,1111,1113,1114,1115,1116,1120,1121,1122,1125,1126,1127,1130,1131,1133,1132,1134,1136,1135,1137,1139,1138,1140,1141,1143,1144,1150,1159,1161,1162,1164,1165,1168,1169,1170,1171,1177,1178,1179,1188,1189,1191,1192,1195,1196,1197,1198,1199,1202,1203,1205,1209,1211,1210,1212,1213,1214,1215,1218,1220,1221,1222,1224,1223,1225,1228,1227,1226,1232,1230,1231,1233,1234,1235,1236,1238,1241,1243,1244,1248,1245,1247,1249,1250,1252,1251,1254,1255,1257,1258,1260,1261,1262,1269,1271,1273,1274,1276,1277,1281,1284,1285,1286,1287,1290,1294,1293,1292,1291,1289,1298,1299,1300,1304,1305,1308,1310,1311,1313,1314,1315,1316,1317,1319,1320,1321,1322,1323,1324,1325,1328,1329,1330,1332,1333,1334,1335,1343,1345,1346,1347,1349,1350,1351,1352,1353,1354,1356,1355,1357,1358,1360,1359,1363,1362,1364,1365,1366,1367,1368,1369,1371,1370,1374,1378,1380,1381,1382,1389,1391,1390,1392,1393,1394,1395,1396,1398,1400,1399,1401,1402,1403,1405,1404,1407,1408,1409,1410,1412,1414,1419,1421,1422,1423,1425,1424,1427,1426,1428,1429,1431,1432,1436,1437,1438,1439,1440,1444,1443,1447,1446,1445,1448,1452,1453,1456,1455,1475,1457,1461,1462,1463,1465,1469,1467,1471,1470,1472,1473,1474,1476,1477,1478,1479,1480,1481,1482,1488,1490,1491,1494,1495,1498,1500,1501,1503,1505,1506,1507,1508,1509,1510,1512,1513,1514,1515,1516,1517,1519,1521,1523,1522,1524,1525,1527,1528,1529,1530,1535,1536,1537,1538,1539,1540,1541,1545,1546,1547,1548,1550,1551,1554,1553,1552,1555,1556,1558,1559,1563,1564,1567,1572,1573,1574,1575,1577,1579,1581,1590)
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 | 20 | 43.00 | 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
