Query Time: 45.28 ms After last query: 0.63 ms Query memory: 0.056 MB Memory before query: 3.871 MB Rows returned: 5
SELECT i.*, c.alias AS categoryalias
FROM o7aim_k2_items AS i
LEFT JOIN o7aim_k2_categories AS c
ON c.id = i.catid
WHERE i.published = 1
AND i.trash = 0
AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-04-26 23:19:51')
AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-04-26 23:19:51')
AND i.access IN(1,1)
AND c.access IN(1,1)
AND c.published = 1
AND c.trash = 0
AND i.id IN(4,5,11,12,18,23,24,36,48,49,53,54,56,64,68,72,75,82,83,94,103,107,108,111,112,118,119,122,125,128,134,143,144,159,160,164,166,167,170,171,173,178,181,182,184,186,188,190,194,198,199,201,216,226,227,229,232,242,247,249,254,255,257,259,261,263,264,265,267,269,270,272,273,274,278,280,282,285,286,288,290,294,295,300,301,302,304,308,309,312,313,314,317,318,332,333,336,337,338,341,343,345,348,349,350,357,358,359,360,363,364,367,368,369,370,371,372,379,381,382,383,384,386,387,388,391,392,393,396,397,398,399,406,407,408,410,411,413,414,415,416,418,419,421,422,423,424,425,426,428,431,432,433,438,439,440,441,444,445,446,447,448,450,451,453,454,455,460,461,462,468,469,470,471,475,479,482,483,484,487,488,489,491,492,493,494,495,498,499,500,504,505,506,507,511,512,513,514,516,517,518,523,525,526,527,528,529,531,532,533,535,536,538,543,544,545,547,548,550,553,555,556,557,558,559,562,563,564,568,569,570,576,577,578,579,582,583,584,586,587,589,591,592,593,600,601,602,603,605,606,607,608,611,612,613,615,616,617,619,620,621,624,625,626,627,628,630,632,633,635,636,637,640,641,642,643,648,649,650,652,653,655,656,659,660,661,662,668,669,670,675,676,677,681,682,683,685,686,688,689,690,691,692,697,698,701,702,703,704,706,710,711,712,713,715,716,720,721,722,727,728,729,734,735,738,739,741,743,748,749,752,754,755,758,760,761,763,764,765,769,770,771,774,775,776,777,781,782,784,788,789,790,793,795,796,799,800,804,807,814,815,816,818,819,823,825,826,827,830,832,833,837,838,842,843,844,846,849,850,851,853,854,857,858,859,863,864,868,869,872,873,874,877,880,881,883,884,886,887,889,890,892,893,895,896,899,902,904,906,909,910,911,915,916,919,925,926,932,933,934,935,936,939,940,941,942,946,947,950,953,954,956,958,959,961,962,964,966,967,972,973,977,979,980,981,982,983,990,992,993,994,995,996,997,999,1000,1002,1003,1005,1008,1009,1012,1015,1017,1018,1019,1021,1022,1024,1025,1026,1027,1032,1033,1035,1039,1040,1042,1044,1045,1046,1047,1050,1051,1055,1056,1060,1061,1066,1067,1068,1069,1070,1071,1073,1075,1077,1078,1079,1082,1083,1084,1085,1086,1088,1089,1092,1093,1094,1095,1101,1103,1104,1107,1108,1109,1110,1111,1113,1114,1115,1116,1120,1121,1122,1123,1127,1128,1130,1133,1134,1135,1137,1143,1144,1145,1149,1151,1152,1154,1155,1156,1157,1160,1161,1166,1169,1170,1171,1173,1176,1181,1182,1183,1184,1190,1191,1194,1195,1196,1197,1202,1205,1207,1209,1211,1218,1219,1220,1222,1224,1225,1227,1232,1234,1236,1242,1247,1252,1257,1259,1260,1265,1271,1273,1276,1277,1279,1282,1284,1286,1290,1292,1293,1298,1299,1303,1305,1307,1310,1312,1316,1317,1322,1326,1328,1329,1330,1333,1334,1340,1341,1351,1362,1366,1371,1374,1375,1378,1379,1380,1382,1383,1384,1388,1391,1395,1396,1398,1399,1400,1401,1403,1406,1407,1409,1410,1412,1414,1419,1421,1424,1425,1429,1430,1431,1432,1434,1443,1444,1445,1448,1449,1450,1452,1456,1457,1462,1463,1466,1470,1473,1479,1480,1481,1483,1484,1485,1486,1488,1489,1493,1497,1499,1500,1504,1506,1507,1509,1513,1514,1520,1521,1525,1528,1529,1540,1543,1547,1548,1557,1559,1566,1567,1568,1570,1575,1585,1603,1604,1610,1611,1613,1618,1619,1624,1625,1626,1639,1640,1641,1652,1655,1657,1659,1660,1666,1667,1679,1680,1687,1696,1699,1700,1715,1716,1720,1721,1727,1737,1738,1747,1748,1755,1756,1757,1759,1760,1762,1763,1786,1791,1794,1797,1801,1808,1823,1830,1835,1837,1840,1841,1842,1844,1848,1849,1854,1864,1871,1873,1874,1880,1881,1883,1888,1890,1891,1894,1899,1900,1905,1906,1908,1916,1917,1921,1926,1930,1938,1939,1942,1943,1948,1949,1953,1957,1958,1962,1963,1964,1968,1971,1972,1978,1979,1980,1982,1983,1984,1986,1987,1992,1994,1995,1998,1999,2001,2002,2004,2005,2009,2018,2019,2020,2023,2025,2030,2031,2032,2038,2039,2040,2044,2048,2049,2050,2058,2059,2060,2068,2076,2077,2078,2079,2080,2083,2084,2085,2093,2099,2100,2105,2108,2110,2112,2113,2117,2119,2120,2123,2124,2125,2130,2132,2134,2135,2136,2141,2143,2144,2149,2151,2153,2156,2160,2161,2162,2163,2172,2180,2186,2187,2200,2201,2202,2203,2208,2213,2219,2222,2225,2226,2228,2231,2235,2236,2237,2240,2244,2245,2247,2249,2251,2256,2257,2263,2267,2269,2274,2284,2286,2287,2290,2292,2294,2297,2298,2301,2305,2308,2310,2311,2312,2314,2315,2321,2335,2339,2340,2366,2373,2382,2385,2386,2388,2389,2398,2399,2406,2425,2429,2430,2431,2440,2443,2444,2446,2450,2451,2454,2465,2466,2469,2473,2474,2475,2478,2491,2510,2517,2524,2525,2526,2531,2536,2537,2541,2542,2546,2550,2555,2558,2559,2560,2567,2570,2574,2575,2576,2577,2578,2580,2581,2596,2600,2601,2603,2607,2610,2611,2613,2616,2621,2623,2625,2626,2633,2638,2649,2650,2652,2666,2669,2670,2671,2675,2679,2681,2683,2688,2690,2691,2692,2701,2703,2705,2711,2716,2717,2723,2724,2734,2744,2771,2785,2797,2800,2801,2805,2806,2808,2814,2816,2817,2820,2825,2829,2835,2840,2846,2851,2852,2856,2863,2875,2878,2880,2897,2900,2901,2903,2904,2909,2916,2952,2967,2969,2974,2984,3003,3011,3013,3014,3032,3038,3044,3047,3053,3060,3072,3075,3076,3082,3089,3102,3112,3128,3136,3175,3179,3180,3187,3188,3190,3198,3202,3210,3222,3224,3225,3230,3234,3237,3242,3244,3246,3251,3254,3257,3264,3265,3273,3276,3285,3288,3294,3296,3299,3304,3317,3319,3328,3329,3347,3350,3352,3356,3358,3363,3366,3367,3371,3372,3373,3376,3386,3388,3389,3395,3397,3398,3401,3404,3411,3415,3418,3427,3428,3433,3446,3449,3474,3483,3486,3489,3490,3501,3502,3513,3514,3516,3528,3540,3544,3545,3554,3558,3561,3569,3570,3574,3576,3586,3601,3608,3609,3615,3616,3617,3623,3627,3631,3632,3635,3643,3644,3645,3652,3668,3674,3697,3698,3699,3704,3718,3722,3724,3731,3733,3735,3744,3749,3763,3772,3776,3779,3787,3796,3800,3806,3807)
ORDER BY i.id DESC
LIMIT 0, 5
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | c | ref | PRIMARY,category,published,access,trash | category | 2 | const | 23 | Using index condition; Using temporary; Using filesort |
1 | PRIMARY | i | ref | PRIMARY,catid,idx_item | catid | 4 | thebrief_joomla.c.id | 49 | Using index condition; Using where |
1 | PRIMARY | <subquery2> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
2 | MATERIALIZED | <derived3> | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 1191 | |
3 | DERIVED | NULL | NULL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 0.32 ms |
Checking permissions | 0.01 ms |
Opening tables | 0.02 ms |
After opening tables | 0.01 ms |
System lock | 0.01 ms |
Table lock | 0.01 ms |
Init | 0.16 ms |
Optimizing | 0.22 ms |
Statistics | 0.15 ms |
Preparing | 0.05 ms |
Creating tmp table | 0.09 ms |
Sorting result | 0.01 ms |
Executing | 0.01 ms |
Sending data | 0.22 ms |
Removing tmp table | 0.01 ms |
Sending data | 28.13 ms |
Creating sort index | 3.09 ms |
Removing tmp table | 12.46 ms |
Creating sort index | 0.05 ms |
End of update loop | 0.01 ms |
Removing tmp table | 0.01 ms |
End of update loop | 0.01 ms |
Query end | 0.01 ms |
Commit | 0.01 ms |
Closing tables | 0.01 ms |
Removing tmp table | 0.01 ms |
Closing tables | 0.01 ms |
Unlocking tables | 0.01 ms |
Closing tables | 0.02 ms |
Starting cleanup | 0.01 ms |
Freeing items | 0.07 ms |
Updating status | 0.04 ms |
Reset for next command | 0.01 ms |
# | Caller | File and line number |
---|
14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
13 | JDatabaseDriver->loadObjectList() | JROOT/components/com_k2/models/itemlist.php:664 |
12 | K2ModelItemlist->getRelatedItems() | JROOT/components/com_k2/views/item/view.html.php:278 |
11 | K2ViewItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:664 |
10 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_k2/controllers/controller.php:20 |
9 | K2Controller->display() | JROOT/components/com_k2/controllers/item.php:78 |
8 | K2ControllerItem->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:702 |
7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_k2/k2.php:64 |
6 | require_once JROOT/components/com_k2/k2.php | JROOT/libraries/src/Component/ComponentHelper.php:402 |
5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:377 |
4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:225 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |