Lekérdezés ideje: 7.14 ms Utolsó lekérdezés után: 1.27 ms Memória lekérdezése: 0.045 MB memória a lekérdezés előtt: 8.328 MB Visszaadott sorok: 450
SELECT tag.name, tag.id
FROM slib0_k2_tags as tag
LEFT JOIN slib0_k2_tags_xref AS xref
ON xref.tagID = tag.id
WHERE xref.itemID IN (455,546,723,241,259,7,8,1151,30,1706,49,51,81,431,432,142,418,202,540,438,429,1722,446,464,463,404,477,879,873,871,2134,2136,2138,2140,473,1704,462,286,288,406,466,440,472,405,313,2287,416,449,451,452,1287,1182,1065,331,337,338,339,343,345,359,390,1447,1853,1855,1856,1857,410,491,494,497,498,501,504,519,508,509,524,528,530,531,532,534,541,545,549,551,552,554,558,559,561,568,570,571,572,576,579,580,582,590,592,596,602,603,604,609,610,620,628,629,632,638,639,642,646,650,665,666,671,673,674,676,679,681,684,687,689,694,696,700,702,710,713,714,718,721,724,726,727,731,736,738,743,747,748,753,762,763,764,773,775,777,781,787,788,789,791,797,802,812,813,815,820,823,824,844,845,848,858,863,864,865,867,870,874,876,877,881,883,884,935,1018,902,894,897,898,904,905,906,907,909,910,911,917,918,929,934,936,938,942,1060,945,948,950,956,960,962,963,964,965,966,995,971,990,973,975,978,979,980,985,986,997,1002,1004,1016,1020,1022,1028,1029,1035,1036,1041,1042,1044,1045,1047,1049,1051,1052,1054,1055,1062,1063,1066,1067,1073,1075,1082,1076,1079,1083,1085,1090,1091,1094,1096,1097,1098,1101,1105,1106,1111,1112,1115,1120,1123,1131,1132,1134,1140,1175,1141,1147,1149,1150,1167,1169,1170,1177,1181,1183,1185,1190,1196,1197,1198,1200,1201,1203,1207,1209,1213,1215,1217,1228,1226,1230,1231,1232,1236,1237,1239,1277,1244,1245,1270,1249,1252,1255,1259,1260,1261,1264,1266,1271,1273,1276,1279,1281,1282,1283,1284,1308,1296,1300,1303,1305,1309,1310,1315,1316,1317,1322,1327,1329,1331,1333,1334,1339,1342,1344,1346,1348,1352,1357,1360,1361,1363,1367,1369,1370,1373,1376,1377,1378,1382,1385,1386,1387,1388,1390,1391,1393,1396,1400,1403,1405,1413,1407,1414,1427,1419,1420,1422,1432,1433,1457,1438,1440,1441,1443,1448,1449,1453,1454,1455,1462,1459,1464,1477,1467,1468,1469,1470,1543,1473,1474,1479,1480,1481,1483,1484,1485,1486,1487,1488,1489,1491,1492,1495,1496,1499,1501,1502,1506,1508,1509,1528,1585,1515,1516,1517,1518,1519,1520,1521,1522,1524,1525,1530,1534,1532,1533,1539,1556,1541,1544,1546,1575,1547,1548,1550,1552,1553,1557,1561,1562,1563,1564,1567,1568,1570,1572,1573,1576,1577,1578,1588,1584,1712,1600,1586,1587,1589,1590,1593,1596,1597,1598,1599,1601,1602,1604,1606,1607,1609,1611,1619,1613,1616,1624,1625,1627,1644,1632,1639,1643,1645,1647,1649,1651,1653,1655,1674,1657,1659,1663,1678,1665,1850,1667,1671,1672,1675,1679,1680,1681,1682,1683,1686,1701,1691,1692,1696,1697,1698,1700,1756,1754,1702,1703,1713,1711,1735,1714,1721,1715,1716,1719,1731,1732,1738,1751,1744,1747,1748,1749,1750,1755,1772,1770,1757,1760,1771,1779,1776,1782,1783,1784,1785,1787,1786,1790,1791,1792,1793,1796,1794,1797,1798,1800,1801,1802,1803,1806,1808,1809,1812,1813,1814,1819,1818,1822,1823,1878,1832,1835,1836,1837,1838,1852,1841,1843,1849,1862,1864,1866,1868,1869,1877,1880,1881,1884,1887,1891,1893,1894,1895,1897,1898,1980,1902,1904,1906,1909,1911,1912,1913,1919,1923,1925,1929,1930,1931,1937,1933,1935,1938,1939,1941,1942,1946,1985,1949,1953,1955,1956,2021,1959,1961,1965,1969,1975,1972,1976,1977,1978,1979,1981,1983,1996,1986,1995,1987,1991,1994,1998,1999,2001,2002,2003,2004,2005,2006,2007,2016,2017,2018,2019,2020,2024,2025,2026,2027,2030,2032,2031,2033,2035,2036,2038,2039,2041,2045,2047,2049,2051,2056,2060,2061,2064,2065,2066,2068,2069,2070,2072,2073,2076,2079,2081,2083,2084,2089,2091,2092,2095,2096,2097,2099,2100,2101,2102,2104,2105,2106,2107,2108,2112,2114,2115,2119,2120,2122,2123,2128,2131,2142,2144,2147,2158,2148,2149,2152,2154,2155,2156,2157,2159,2160,2162,2163,2164,2166,2167,2170,2171,2173,2174,2175,2176,2177,2180,2181,2182,2183,2184,2187,2188,2189,2190,2191,2192,2193,2194,2198,2200,2201,2202,2203,2205,2207,2208,2209,2213,2214,2217,2218,2221,2227,2231,2232,2236,2238,2239,2241,2243,2244,2248,2250,2251,2252,2253,2255,2257,2260,2262,2263,2264,2266,2267,2269,2270,2272,2273,2274,2275,2278,2280,2281,2286,2293,2294,2295,2296,2301,2303,2304,2305,2307,2308,2309,2311,2312,2314,2318,2319,2320,2322,2323,2326,2327,2329,2330,2331,2332,2333,2338,2339,2341,2343,2344,2349,2353,2356,2357,2358,2359,2360,2361,2363,2364,2365,2368,2369,2376,2378,2383,2387,2389,2390,2394,2395,2396,2399,2402,2403,2404,2405,2408,408,52,53,77,78,484,2135,480,691,697,888,933,940,969,982,993,1007,1023,1032,1050,1072,1092,1126,1133,1135,1153,1180,1199,1210,1320,1298,1299,1355,1356,1417,1418,1426,1431,1458,1571,1594,1652,1656,1658,1669,1684,1687,1710,1717,1723,1728,1736,1753,1775,1827,1889,1903,1918,1963,2012,2028,2087,2118,2124,2130,2259,2298,2299,2384,2388,2397,10,11,12,35,103,471,204,2141,474,447,456,495,506,507,516,529,578,616,619,648,709,720,744,779,780,847,857,860,880,887,916,896,957,1012,1017,1024,1037,1070,1087,1119,1130,1148,1161,1189,1192,1247,1290,1526,1527,1640,1641,1767,1773,1859,1833,1892,2146,2235,2242,2249,2277,2324,2328,2342,2347,2371,2382,2386,2401,13,14,16,17,18,487,2139,287,291,465,566,340,341,342,488,409,511,520,521,543,588,569,581,600,606,622,623,626,636,653,654,655,677,708,725,730,735,746,757,758,761,2313,790,782,792,794,795,796,798,799,800,801,811,814,826,849,852,882,891,899,913,937,920,921,922,924,925,926,927,932,939,959,946,955,977,998,1000,1001,1027,1030,1031,1034,1038,1057,1058,1064,1068,1069,1100,1103,1117,1121,1122,1129,1158,1159,1168,1188,1205,1214,1221,1222,1225,1229,1248,1251,1253,1258,1424,1278,1292,1294,1295,1345,1304,1306,1326,1328,1337,1338,1392,1353,1362,1368,1372,1375,1383,1399,1402,1408,1423,1437,1500,1505,1512,1513,1536,1558,1559,1560,1565,1566,1605,1615,1617,1622,1623,1660,1666,1677,1688,1693,1699,1831,1733,1769,1778,1821,1815,1824,1828,1839,1863,1865,1867,1874,1876,1917,1908,1910,1934,1947,1964,1968,2011,2013,2048,2053,2059,2126,2145,2150,2151,2165,2186,2199,2212,2224,2228,2229,2230,2233,2247,2256,2261,2268,2284,2290,2291,2297,2310,2315,2316,2317,2340,2348,2350,2351,2352,2366,2367,2372,2391,2392,2393,2400,55,56,57,58,59,60,69,70,71,79,83,95,461,2222,1243,1220,347,397,398,492,499,514,527,537,538,550,589,614,599,615,621,649,685,692,712,759,785,819,822,829,830,842,851,861,885,908,915,928,947,949,951,961,1048,970,976,987,989,996,1005,1019,1056,1071,1074,1125,1156,1145,1146,1154,1166,1179,1184,1250,1235,1269,1275,1286,1297,1311,1341,1343,1350,1366,1381,1406,1411,1416,1428,1442,1452,1456,1466,1476,1482,1494,1510,1529,1540,1542,1569,1583,1595,1618,1630,1634,1650,1654,1664,1670,1705,1685,1690,1720,1729,1740,1741,1752,1766,1781,1805,1830,1848,1861,1871,1872,1873,1885,1890,1900,1901,1907,1916,1926,1932,1944,1966,1971,1984,1989,1990,2008,2022,2037,2042,2052,2058,2063,2075,2080,2088,2109,2172,2179,2197,2211,2223,2226,2245,2246,2254,2271,2279,2289,2292,2300,2302,2306,2325,2336,2354,2355,2379,2380,2381,2385,2398,2406,2407,24,583,573,174,412,481,1191,423,1212,459,344,392,415,517,518,560,631,637,688,660,682,670,707,704,739,952,809,821,834,841,853,862,875,878,890,895,901,919,943,967,972,991,1009,1013,1059,1077,1084,1102,1137,1144,1163,1173,1216,1223,1227,1240,1256,1301,1313,1336,1612,1724,1742,2074,381,380,379,378,25,26,387,386,385,384,377,63,64,65,66,382,383,482,436,437,96,187,435,479,460,476,475,1139,346,388,389,1851,1854,496,505,510,522,525,526,535,536,547,548,608,564,565,617,635,575,584,586,597,598,607,611,612,618,633,634,641,644,647,652,656,659,664,667,668,669,672,675,678,680,683,767,693,695,703,722,734,705,711,715,716,741,749,751,755,756,765,768,769,770,776,783,784,807,817,818,827,828,831,832,840,854,855,856,889,912,914,930,931,953,954,1025,968,981,992,1010,1003,1006,1039,1040,1089,1093,1114,1116,1118,1124,1128,1138,1142,1143,1157,1155,1162,1164,1165,1171,1186,1187,1193,1202,1204,1206,1208,1211,1218,1219,1233,1234,1241,1242,1246,1267,1268,1274,1285,1288,1289,1293,1302,1312,1321,1314,1318,1319,1323,1324,1325,1330,1332,1340,1349,1351,1354,1359,1364,1371,1379,1380,1389,1394,1395,1397,1401,1404,1409,1410,1415,1425,1514,1434,1435,1439,1444,1450,1451,1460,1461,1498,1463,1465,1472,1475,1478,1493,1497,1503,1504,1507,1511,1523,1531,1535,1537,1545,1551,1555,1579,1580,1581,1582,1603,1633,1608,1620,1635,1637,1638,1648,1661,1689,1694,1695,1709,1718,1727,1737,1758,1762,1763,1764,1765,1774,1780,1788,1789,1799,1820,1825,1826,1829,1840,1844,1845,1847,1858,1860,1870,1875,1879,1886,1899,1905,1915,1920,1921,1922,1924,1927,1928,1936,1943,1945,1948,1951,1957,1962,1967,1970,1973,1974,1982,1988,1992,1997,2009,2015,2029,2040,2044,2046,2050,2054,2057,2067,2071,2078,2082,2094,2103,2110,2111,2161,2168,2169,2178,2196,2204,2210,2219,2220,2225,2282,2334,2337,2345,2362,2373,2409,1358,490,67,72,2137,503,732,737,740,742,754,766,808,866,886,893,984,999,1014,1008,1015,1033,1043,1053,1086,1108,1176,1178,1254,1335,1365,1374,1398,1412,1436,1538,1554,1574,1621,1628,1631,1646,1668,1662,1673,1761,1804,1810,1816,1842,1846,1882,1883,1888,1896,1940,1952,1954,1993,2000,2010,2014,2023,2043,2055,2062,2077,2133,2195,2258,2265,2276,2283,2285,2288,2321,2335,2346,2374,2375,2377,15,31,32,33,34,376,439,454,651,733,833,1081,1095,1099,1104,1107,1110,1113,1136,1224,1291,1257,1262,1272,1280,1429,1430,1446,1471,1626,1730,1811,73,512,544,553,567,574,577,613,661,690,786,944,1195,1614,1817,84,1160,1263,1347,1610,29,43,44,45,46,47,48,361,393,401,502,587,640,101,102,104,105,106,107,108,144,486,485,143,324,1127,97,453,151,154,500,562,585,601,663,838,1759,161,162,190,191,869,167,168,433,173,189,192,563,630,2085,2086,178,179,180,594,2098,193,194,195,196,197,198,240,701,1642,201,407,428,217,478,298,315,322,333,334,394,395,593,643,657,698,699,717,859,868,900,994,1046,1088,1172,1549,1636,1676,1708,1734,1768,1950,2034,2240,2370,469,289,290,292,294,297,299,300,316,414,422,591,625,645,658,835,988,489,444,295,467,311,312,448,336,400,523,662,1707,1777,2116,2121,2127,2132,2185,317,318,427,205,296,320,323,335,349,557,595,706,719,804,805,810,836,837,892,941,983,1061,1194,2090,2129,2234,375,177,396,399,533,556,728,729,803,850,958,325,326,391,2215,2216,100,445)
AND tag.published = 1| id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra |
|---|
| 1 | SIMPLE | xref | NULL | ALL | tagID,itemID | NEM LEHETETT INDEXKULCSOT HASZNÁLNI | NULL | NULL | 520 | 100.00 | Using where |
| 1 | SIMPLE | tag | NULL | eq_ref | PRIMARY,published | PRIMARY | 4 | oyabun_info.xref.tagID | 1 | 99.74 | Using where |
| Status | Duration |
|---|
| starting | 1.09 ms |
| Executing hook on transaction | 0.02 ms |
| starting | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.33 ms |
| init | 0.01 ms |
| System lock | 0.02 ms |
| optimizing | 0.22 ms |
| statistics | 2.75 ms |
| preparing | 0.28 ms |
| executing | 1.69 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| waiting for handler commit | 0.02 ms |
| closing tables | 0.04 ms |
| freeing items | 0.20 ms |
| cleaning up | 0.04 ms |
| # | Hívó | Fájl és sorok száma |
|---|
| 13 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1701 |
| 12 | JDatabaseDriver->loadObjectList() | JROOT/modules/mod_k2_tools/helper.php:287 |
| 11 | modK2ToolsHelper::tagCloud() | JROOT/modules/mod_k2_tools/mod_k2_tools.php:85 |
| 10 | include JROOT/modules/mod_k2_tools/mod_k2_tools.php | JROOT/libraries/src/Helper/ModuleHelper.php:200 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:511 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:803 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:577 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1112 |
| 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:57 |
Padlás - még kapható a jegyek