Χρόνος επερώτησης:10.80 ms Μετά την τελευταία επερώτηση:0.88 ms Μνήμη με επερώτηση: 0.152 MB Μνήμη πριν την επερώτηση: 6.669 MB Σειρές που επιστράφηκαν:1661
SELECT tag.name, tag.id
FROM mmp_jos_k2_tags as tag
LEFT JOIN mmp_jos_k2_tags_xref AS xref
ON xref.tagID = tag.id
WHERE xref.itemID IN (153,154,155,156,177,1780,1591,1673,203,211,213,214,215,220,226,227,228,246,247,249,251,252,253,256,262,264,271,283,292,293,370,1681,392,393,399,400,407,411,1514,422,423,426,428,429,433,443,444,445,470,471,485,490,491,492,497,499,500,501,502,508,509,519,521,522,526,540,541,542,543,544,545,561,564,580,595,599,605,611,621,623,648,674,676,677,678,679,680,683,684,689,690,691,698,699,701,702,743,744,745,755,756,757,761,762,763,773,777,780,782,783,787,805,806,807,808,812,819,826,827,828,833,834,842,843,844,845,857,871,872,875,876,877,878,880,884,932,934,935,936,940,945,949,950,954,955,959,961,966,967,970,976,984,992,993,999,1001,1005,1006,1007,1008,1023,1029,1044,1059,1079,1085,1086,1087,1088,1089,1090,1101,1120,1132,1134,1156,1157,1171,1181,1182,1183,1184,1185,1190,1194,1202,1276,1295,1296,1307,1311,1317,1318,1347,1348,1351,1352,1354,1355,1356,1357,1359,1360,1361,1373,1382,1383,1390,1402,1403,1413,1424,1426,1459,1484,1485,1486,1556,1550,1551,1575,1589,1586,1592,1617,1618,1611,1612,1572,1173,1174,1192,1212,1213,1234,1271,1284,1321,1324,1340,1341,1375,1435,1436,1454,1513,1536,1555,1568,1599,1609,1629,1658,1645,1789,1817,1886,1862,1910,1944,1955,1962,1963,2080,2179,2227,2260,2316,2323,2338,2348,2455,2456,2487,2501,371,372,377,379,387,391,395,406,413,421,434,435,441,442,451,475,478,479,484,495,498,506,510,512,513,533,537,539,547,553,557,569,575,593,601,602,614,615,649,652,653,657,658,670,673,681,692,694,704,709,711,713,714,716,723,725,727,729,735,737,746,747,759,765,767,778,788,802,815,821,829,831,836,846,853,858,864,873,882,894,903,919,922,923,927,938,947,951,956,962,971,973,978,987,990,1003,1017,1026,1030,1037,1040,1042,1053,1057,1075,1081,1127,1128,1142,1144,1146,1164,1204,1217,2011,1794,2007,2008,1469,2009,1470,2013,1825,2014,1584,1672,2016,2017,2018,1471,1820,2019,1478,2020,1827,1822,1991,2021,1474,1515,1480,1787,1786,1096,1097,1098,1099,1100,1102,1103,1104,1105,1106,1107,1108,1109,1110,1111,1112,1113,1114,1115,1116,1117,1118,1119,1121,1122,1129,1131,1133,1135,1136,1137,1138,1139,1154,1158,1159,1160,1161,1162,1166,1168,1169,1170,1172,1186,1187,1188,1189,1191,1199,1200,1201,1205,1206,1207,1208,1209,1210,1215,1216,1220,1222,1223,1224,1225,1229,1230,1232,1236,1237,1238,1239,1244,1245,1246,1247,1248,1249,1250,1251,1252,1254,1255,1258,1259,1262,1266,1268,1270,1272,1273,1274,1275,1277,1279,1282,1287,1288,1289,1290,1293,1294,1297,1298,1299,1300,1302,1304,1305,1306,1309,1314,1315,1316,1319,1322,1323,1327,1328,1330,1331,1333,1335,1336,1337,1338,1346,1349,1353,1363,1364,1368,1369,1370,1371,1372,1374,1378,1380,1381,1384,1385,1386,1387,1388,1391,1392,1393,1396,1397,1398,1400,1401,1404,1406,1407,1408,1409,1410,1411,1412,1414,1415,1418,1422,1423,1429,1430,1432,1437,1438,1439,1440,1441,1443,1444,1445,1446,1447,1450,1451,1452,1453,1456,1457,1458,1460,1464,1465,1466,1467,1468,1481,1537,1505,1488,1489,1491,1490,1492,1494,1495,1496,1497,1499,1511,1504,1509,1516,1563,1529,1678,1558,1543,1544,1546,1547,1548,1554,1560,1561,1562,1564,1566,1600,1585,1570,1574,1594,1576,1587,1619,1621,1738,1626,1615,1684,1624,1622,1688,1674,1675,1679,1682,1686,1683,1689,1630,1718,1734,1729,1716,1714,1706,1664,1655,1705,1634,1660,1661,1649,1736,1656,1657,1720,1643,1726,1636,1722,1781,1666,1665,1650,1687,1641,1709,1744,1647,1640,1648,1723,1725,1749,1750,1751,1755,1754,1759,1756,1757,1758,1779,1765,1782,1766,1767,1785,1768,2000,1776,1770,1777,1998,1788,1790,1791,1793,1795,1796,1810,1798,1799,1800,1801,1802,1804,1805,1806,1807,1851,1808,1811,1812,1990,1813,1816,1841,1823,1824,1829,1830,1840,1837,1832,1833,1834,1846,1842,1848,1847,1858,1873,1849,1853,1914,1850,1890,1852,1854,1855,1856,1857,1889,1859,1860,1863,1864,1872,1877,1999,1880,1992,1887,1883,1997,1891,1900,1892,1899,1894,1895,1897,1898,1913,1905,1934,1908,1909,1915,1916,1917,1918,1919,1921,1932,1960,1958,1940,1933,1923,1924,1925,1926,1927,1928,1929,1952,1954,1936,1937,1939,1941,1959,1951,1947,1949,1956,1993,2010,1965,1989,1968,1970,1971,1972,1973,1974,1975,1977,1978,1979,1981,1982,1985,1986,1988,2022,2023,2024,2025,2028,2029,2030,2031,2033,2034,2035,2036,2039,2041,2042,2043,2044,2045,2046,2047,2048,2049,2050,2051,2052,2053,2054,2055,2056,2059,2060,2061,2062,2066,2067,2070,2071,2072,2073,2074,2075,2076,2081,2086,2087,2088,2089,2090,2092,2094,2095,2096,2097,2100,2101,2103,2104,2106,2107,2108,2109,2110,2111,2112,2116,2117,2118,2119,2121,2122,2123,2126,2128,2129,2130,2131,2132,2133,2134,2135,2136,2137,2139,2140,2141,2142,2143,2144,2145,2148,2149,2150,2151,2152,2159,2163,2165,2166,2167,2169,2171,2170,2172,2173,2174,2176,2177,2178,2181,2182,2184,2185,2186,2187,2188,2189,2190,2192,2193,2194,2196,2197,2198,2200,2201,2202,2203,2204,2205,2207,2208,2209,2211,2212,2214,2222,2223,2224,2225,2226,2228,2229,2230,2231,2232,2236,2237,2238,2239,2240,2241,2244,2245,2246,2247,2248,2251,2252,2253,2254,2255,2256,2257,2258,2263,2264,2265,2267,2268,2269,2271,2273,2274,2275,2279,2280,2281,2282,2283,2284,2285,2286,2288,2289,2290,2291,2292,2293,2294,2295,2296,2297,2298,2303,2304,2305,2306,2307,2308,2310,2311,2313,2314,2318,2320,2321,2325,2326,2327,2328,2329,2330,2331,2332,2333,2334,2335,2336,2341,2342,2343,2349,2350,2353,2354,2355,2356,2357,2359,2360,2361,2363,2364,2365,2366,2367,2368,2369,2373,2370,2371,2372,2374,2375,2376,2379,2380,2381,2382,2383,2384,2385,2386,2387,2388,2389,2390,2392,2395,2396,2398,2400,2401,2402,2404,2405,2406,2407,2408,2410,2411,2412,2413,2414,2415,2416,2419,2420,2421,2422,2423,2424,2425,2426,2427,2428,2429,2430,2431,2432,2433,2434,2435,2436,2441,2442,2444,2446,2447,2448,2449,2451,2452,2457,2458,2460,2463,2465,2466,2467,2476,2478,2479,2480,2481,2482,2483,2484,2485,2488,2489,2490,2491,2493,2495,2496,2499,2502,2505,2506,2507,2508,2510,2511,2512,2515,2516,2518,2519,2520,2521,2522,2523,2525,2527,2528,2530,2531,2532,2533,2535,2536,2006,2012,1775,1475,1667,1479,920,924,926,928,939,948,952,957,963,972,974,977,979,988,991,1018,1068,1123,1124,1125,1130,1140,1141,1143,1145,1147,1148,1149,1150,1151,1152,1153,1163,1165,1167,1175,1176,1177,1178,1179,1180,1195,1196,1197,1198,1203,1211,1218,1219,1221,1227,1228,1233,1241,1242,1243,1253,1256,1257,1261,1263,1267,1278,1280,1281,1283,1285,1286,1291,1292,1301,1303,1308,1310,1312,1313,1320,1325,1332,1334,1339,1343,1344,1350,1358,1365,1366,1367,1376,1377,1379,1389,1394,1399,1405,1416,1417,1419,1420,1421,1425,1427,1431,1433,1442,1448,1449,1455,1461,1462,1538,1483,1487,1502,1506,1498,1500,1501,1503,1512,1527,1559,1539,1549,1565,1567,1573,1571,1721,1602,1595,1601,1596,1597,1598,1608,1616,1680,1625,1677,1676,1690,1685,1646,1748,1730,1628,1631,1732,1708,1731,1717,1741,1715,1712,1710,1707,1719,1670,1743,1747,1635,1651,1659,1642,1637,1669,1668,1652,1653,1728,1727,1745,1746,1762,1753,1761,1769,1792,1809,1836,1814,1819,1815,1818,1826,1828,1838,1870,1888,1871,1876,1861,1865,1867,1868,1869,1901,1875,2005,1879,1996,1881,1903,1893,1896,1902,1967,1911,1912,1966,1920,1922,1930,1931,1938,1942,1943,1945,1946,1948,1953,1957,1961,1969,1976,1980,1983,1984,2026,2027,2032,2037,2038,2063,2064,2065,2068,2069,2077,2078,2082,2091,2093,2113,2114,2115,2120,2124,2127,2138,2153,2154,2155,2156,2160,2161,2162,2168,2180,2191,2195,2199,2206,2210,2213,2242,2243,2249,2250,2259,2262,2266,2270,2272,2287,2299,2301,2302,2309,2312,2315,2319,2322,2324,2337,2339,2347,2351,2352,2358,2362,2378,2391,2393,2394,2397,2399,2417,2440,2443,2445,2453,2454,2459,2464,2477,2486,2492,2494,2497,2498,2500,2503,2504,2513,2514,2517,2524,2529,2534,2538,1784,1671,1763,1704,1482,1510,1552,1569,1577,1593,1623,1627,1632,1733,1742,1724,1740,1752,1760,1764,1778,1821,1797,2015,1839,1831,1835,1845,1994,1907,1874,1882,1904,2003,1935,1950,2002,2004,1987,2040,2057,2058,2083,2084,2085,2098,2099,2105,2125,2146,2157,2175,2183,2217,2218,2219,2220,2221,2233,2235,2278,2300,2340,2346,2377,2403,2418,2469,2470,2471,2472,2473,2475,1472,1477,1476,1772,1773,1774,2216,1507,1508,2215,2234,2474,1473,1531,1530,1532,1517,1533,1518,1519,1520,1521,1522,1523,1524,1525,1526,1528,1534,1535,1545,1588,1604,1590,1578,1580,1581,1582,1583,1603,1606,1605,1607,1884,1885,1906,2147)
AND tag.published = 1
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|
1 | PRIMARY | tag | ALL | PRIMARY,published | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 68 | Using where |
1 | PRIMARY | xref | ref | tagID,itemID | tagID | 4 | saintpaul.tag.id | 34 | |
1 | PRIMARY | <subquery2> | eq_ref | distinct_key | distinct_key | 4 | func | 1 | |
2 | MATERIALIZED | <derived3> | ALL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | 1644 | |
3 | DERIVED | NULL | NULL | NULL | ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ | NULL | NULL | NULL | No tables used |
Status | Duration |
---|
Starting | 1.10 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.51 ms |
Optimizing | 0.42 ms |
Statistics | 0.10 ms |
Preparing | 0.07 ms |
Executing | 0.01 ms |
Sending data | 0.46 ms |
Removing tmp table | 0.01 ms |
Sending data | 7.75 ms |
End of update loop | 0.01 ms |
Removing tmp table | 0.01 ms |
End of update loop | 0.00 ms |
Query end | 0.00 ms |
closing tables | 0.00 ms |
Removing tmp table | 0.00 ms |
closing tables | 0.00 ms |
Unlocking tables | 0.00 ms |
closing tables | 0.01 ms |
Query end | 0.01 ms |
Starting cleanup | 0.00 ms |
Freeing items | 0.04 ms |
Updating status | 0.02 ms |
Reset for next command | 0.01 ms |
# | Καλών | Αρχείο και αριθμός σειράς |
---|
22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
21 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_k2_tools/helper.php:287 |
20 | modK2ToolsHelper::tagCloud() | JROOT/modules/mod_k2_tools/mod_k2_tools.php:85 |
19 | include JROOT/modules/mod_k2_tools/mod_k2_tools.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
18 | Joomla\CMS\Helper\ModuleHelper::renderModule() | Το ίδιο όπως κλήθηκε στην παρακάτω σειρά. |
17 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
16 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:617 |
15 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95 |
14 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/templates/gravity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92 |
13 | Warp\Joomla\Helper\WidgetsHelper->load() | JROOT/templates/gravity/warp/systems/joomla/layouts/widgets.php:10 |
12 | include JROOT/templates/gravity/warp/systems/joomla/layouts/widgets.php | JROOT/templates/gravity/warp/src/Warp/Helper/TemplateHelper.php:49 |
11 | Warp\Helper\TemplateHelper->render() | JROOT/templates/gravity/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69 |
10 | Warp\Joomla\Helper\WidgetsHelper->render() | JROOT/templates/gravity/layouts/theme.php:144 |
9 | include JROOT/templates/gravity/layouts/theme.php | JROOT/templates/gravity/warp/src/Warp/Helper/TemplateHelper.php:49 |
8 | Warp\Helper\TemplateHelper->render() | JROOT/templates/gravity/index.php:10 |
7 | require JROOT/templates/gravity/index.php | JROOT/libraries/src/Document/HtmlDocument.php:678 |
6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:740 |
5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:555 |
4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1098 |
3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:778 |
2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:231 |
1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |