Query Time: 3.61 ms After last query: 0.87 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:25:11' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2025-06-19 20:25:11' )
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,221,223,224,225,227,228,229,230,231,232,233,234,236,239,240,241,243,242,244,248,249,250,251,252,253,254,258,260,262,263,265,264,266,268,267,269,270,271,273,275,276,277,278,279,281,282,283,284,285,287,288,289,290,291,292,293,294,295,301,302,310,314,321,322,326,329,331,332,333,334,335,336,337,338,339,340,341,343,344,346,345,347,348,350,351,352,353,354,355,359,363,364,365,366,367,371,372,375,376,377,378,379,381,380,382,383,386,387,388,389,390,394,395,396,397,406,407,408,410,409,412,418,429,430,439,440,441,442,443,444,445,446,448,449,450,452,454,456,457,466,469,467,468,470,471,473,476,475,477,479,480,481,482,483,486,484,487,488,489,490,491,493,495,496,497,499,500,501,502,503,504,505,506,508,507,509,510,511,512,513,514,515,517,520,521,522,523,524,525,526,527,528,530,529,531,532,533,536,534,535,537,538,540,541,542,543,544,547,548,549,550,551,552,553,557,560,559,558,561,562,564,565,566,569,570,572,575,582,584,592,593,594,595,596,598,599,601,603,602,604,605,608,606,607,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,645,647,648,649,651,650,652,653,654,655,656,658,657,663,660,661,664,666,668,669,672,673,674,675,676,679,677,681,680,682,685,686,688,689,690,691,692,693,694,695,696,697,698,699,700,704,701,707,708,709,711,710,712,714,716,717,718,719,720,722,721,723,726,727,731,734,738,739,741,742,743,746,744,745,747,749,750,751,752,753,756,757,758,760,767,768,770,771,772,773,776,774,775,778,780,779,782,783,784,785,786,787,789,788,791,793,794,796,799,802,804,803,806,807,808,811,809,810,812,813,815,817,816,818,819,820,821,824,833,834,835,837,838,839,842,841,844,846,847,848,857,858,859,860,861,865,863,875,880,881,882,884,883,885,888,889,895,896,897,898,899,900,901,903,904,906,907,908,911,912,913,916,915,917,918,920,921,924,923,922,926,928,927,929,936,937,938,939,944,946,947,948,949,952,954,955,956,957,958,959,964,965,966,967,968,969,970,971,972,973,974,975,978,976,977,979,980,981,983,984,991,992,993,994,998,999,1000,1003,1004,1005,1007,1008,1009,1011,1012,1014,1015,1016,1017,1018,1019,1025,1032,1037,1038,1039,1040,1041,1042,1043,1044,1048,1052,1058,1059,1060,1061,1062,1066,1067,1068,1069,1071,1073,1074,1075,1076,1078,1077,1080,1081,1082,1087,1088,1091,1092,1094,1095,1096,1097,1099,1103,1109,1110,1112,1114,1113,1116,1118,1120,1121,1122,1130,1131,1132,1133,1136,1135,1137,1139,1141,1146,1147,1152,1153,1155,1154,1156,1157,1158,1159,1160,1162,1163,1165,1164,1167,1169,1170,1171,1177,1181,1183,1186,1187,1188,1189,1190,1191,1197,1198,1202,1203,1206,1207,1208,1209,1210,1213,1214,1215,1220,1221,1222,1225,1228,1232,1236,1235,1237,1238,1239,1241,1243,1244,1248,1245,1249,1253,1255,1259,1260,1261,1262,1263,1266,1267,1268,1269,1271,1275,1276,1277,1281,1287,1288,1290,1296,1297,1301,1302,1306,1307,1310,1311,1312,1313,1315,1318,1321,1322,1323,1324,1325,1328,1327,1329,1333,1339,1338,1335,1343,1345,1346,1347,1349,1351,1353,1358,1360,1359,1363,1361,1364,1365,1366,1369,1371,1374,1378,1380,1381,1382,1383,1389,1393,1394,1395,1397,1398,1400,1399,1401,1402,1403,1405,1404,1407,1408,1410,1409,1412,1414,1415,1420,1421,1422,1423,1425,1427,1426,1429,1430,1432,1434,1435,1436,1439,1438,1440,1441,1444,1448,1449,1452,1453,1454,1456,1461,1469,1467,1471,1470,1472,1473,1474,1475,1476,1477,1479,1480,1481,1484,1482,1487,1490,1494,1495,1496,1498,1500,1501,1503,1502,1505,1506,1507,1509,1510,1514,1517,1521,1519,1523,1522,1524,1525,1527,1526,1529,1530,1531,1532,1533,1534,1535,1536,1537,1538,1539,1541,1542,1543,1544,1545,1546,1547,1548,1550,1552,1557,1558,1559,1560,1561,1563,1566,1567,1569,1570,1571,1572,1573,1574,1577,1581,1596,1597,1598)
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 | 48.83 | 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 |
| Status | Duration |
|---|
| Starting | 0.1 ms |
| checking permissions | 0.0 ms |
| Opening tables | 0.0 ms |
| After opening tables | 0.0 ms |
| System lock | 0.0 ms |
| table lock | 0.0 ms |
| init | 0.0 ms |
| Optimizing | 0.0 ms |
| Statistics | 0.1 ms |
| Preparing | 0.0 ms |
| Sorting result | 0.0 ms |
| Executing | 0.0 ms |
| Sending data | 0.2 ms |
| End of update loop | 0.0 ms |
| Query end | 0.0 ms |
| closing tables | 0.0 ms |
| Unlocking tables | 0.0 ms |
| closing tables | 0.0 ms |
| Query end | 0.0 ms |
| Starting cleanup | 0.0 ms |
| Freeing items | 0.0 ms |
| Updating status | 0.0 ms |
| Reset for next command | 0.0 ms |
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
