Joomla! hibakereső konzol

39 naplózott lekérdezés

1. SELECT `data`
  FROM `wvb4o_session`
  WHERE `session_id` = 'ojbepni711529qrurctqg4oit2'
2. DELETE
  FROM `wvb4o_session`
  WHERE `time` < '1574093591'
3. SELECT `session_id`
  FROM `wvb4o_session`
  WHERE `session_id` = 'ojbepni711529qrurctqg4oit2'
  LIMIT 0, 1
4. INSERT INTO `wvb4o_session` (`session_id`, `client_id`, `time`)
  VALUES ('ojbepni711529qrurctqg4oit2', 0, '1574453591')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wvb4o_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM wvb4o_usergroups AS a
  LEFT JOIN wvb4o_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `wvb4o_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM wvb4o_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wvb4o_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. SELECT *
  FROM wvb4o_vflow_conf
11. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wvb4o_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
12. SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM wvb4o_menu AS m
  LEFT JOIN wvb4o_extensions AS e
  ON m.component_id = e.extension_id
  WHERE m.published = 1
  AND m.parent_id > 0
  AND m.client_id = 0
  ORDER BY m.lft
13. SELECT id, home, template, s.params
  FROM wvb4o_template_styles as s
  LEFT JOIN wvb4o_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
14. SELECT *
  FROM wvb4o_languages
  WHERE published=1
  ORDER BY ordering ASC
15. SELECT extension_id AS id, element AS "option", params, enabled
  FROM wvb4o_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
16. SELECT a.rules
  FROM wvb4o_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
17. SELECT b.rules
  FROM wvb4o_assets AS a
  LEFT JOIN wvb4o_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_content' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
18. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM wvb4o_content AS a
  LEFT JOIN wvb4o_categories AS c
  ON c.id = a.catid
  LEFT JOIN wvb4o_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN wvb4o_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM wvb4o_contact_details AS contact
  WHERE contact.published = 1
  GROUP BY contact.user_id, contact.language) AS contact
  ON contact.user_id = a.created_by
  LEFT JOIN wvb4o_categories as parent
  ON parent.id = c.parent_id
  LEFT JOIN wvb4o_content_rating AS v
  ON a.id = v.content_id
  LEFT
  OUTER JOIN (SELECT cat.id as id
  FROM wvb4o_categories AS cat JOIN wvb4o_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id ) AS badcats
  ON badcats.id = c.id
  INNER JOIN wvb4o_content_frontpage AS fp
  ON fp.content_id = a.id
  WHERE a.access IN (1,1)
  AND c.access IN (1,1)
  AND
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-11-22 20:13:11')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-11-22 20:13:11')
  GROUP BY a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, a.created, a.modified, a.modified_by, uam.name, a.publish_up, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.fulltext, a.state, a.publish_down, badcats.id, c.title, c.path, c.access, c.alias, uam.id, ua.name, ua.email, contact.id, parent.title, parent.id, parent.path, parent.alias, v.rating_sum, v.rating_count, c.published, c.lft, a.ordering, parent.lft, fp.ordering, c.id, a.images, a.urls
  ORDER BY c.lft, fp.ordering, a.created DESC
19. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM wvb4o_modules AS m
  LEFT JOIN wvb4o_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN wvb4o_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
  WHERE m.published = 1
  AND e.enabled = 1
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-11-22 20:13:11')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-11-22 20:13:11')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 435 OR mm.menuid <= 0)
  ORDER BY m.position, m.ordering
20. SELECT id,parent_id
  FROM wvb4o_menu
  WHERE id = 435
21. SELECT id,parent_id
  FROM wvb4o_menu
  WHERE id = 1
22. SELECT distinct(m.id), title, module, position, content, showtitle, params
  FROM wvb4o_modules AS m
  LEFT JOIN wvb4o_modules_menu AS mm
  ON mm.moduleid = m.id
  WHERE m.id in(197)
  AND m.published > 0
  ORDER BY position, ordering
23. SELECT id
  FROM wvb4o_k2_categories
  WHERE parent IN (46)
  AND id NOT IN (46)
  AND published=1
  AND trash=0
  AND access IN(1,1)
24. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM wvb4o_k2_items as i RIGHT JOIN wvb4o_k2_categories c
  ON c.id = i.catid
  LEFT JOIN wvb4o_k2_additional_categories AS ca
  ON ca.itemID = i.id
  WHERE i.published = 1
  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.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-22 20:13:11' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-22 20:13:11' )
  AND (i.catid IN (46) OR ca.catid IN (46))
  ORDER BY i.created DESC
  LIMIT 0, 10
25. SELECT id
  FROM wvb4o_k2_categories
  WHERE parent IN (48)
  AND id NOT IN (48)
  AND published=1
  AND trash=0
  AND access IN(1,1)
26. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM wvb4o_k2_items as i RIGHT JOIN wvb4o_k2_categories c
  ON c.id = i.catid
  LEFT JOIN wvb4o_k2_additional_categories AS ca
  ON ca.itemID = i.id
  WHERE i.published = 1
  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.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-22 20:13:11' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-22 20:13:11' )
  AND (i.catid IN (48) OR ca.catid IN (48))
  ORDER BY i.created DESC
  LIMIT 0, 20
27. SELECT i.id
  FROM wvb4o_k2_items as i
  LEFT JOIN wvb4o_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 <= '2019-11-22 20:13:11' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-22 20:13:11' )
  AND i.trash=0
  AND i.access IN(1,1)
  AND c.published=1
  AND c.trash=0
  AND c.access IN(1,1)
  AND i.catid IN(44,46,48)
28. SELECT tag.name, tag.id
  FROM wvb4o_k2_tags as tag
  LEFT JOIN wvb4o_k2_tags_xref AS xref
  ON xref.tagID = tag.id
  WHERE xref.itemID IN (193,194,195,197,202,215,220,226,273,326,642,988,205,206,209,210,211,213,214,218,221,222,227,231,236,237,238,239,265,266,267,360,357,271,272,346,276,279,282,285,287,290,293,295,345,301,304,305,308,311,319,320,323,325,327,358,329,333,356,337,338,339,351,353,362,364,367,371,370,373,376,378,380,382,383,386,390,392,395,399,401,402,409,407,412,413,414,416,418,421,428,431,433,438,442,444,448,450,451,452,455,453,457,459,460,463,465,470,474,475,477,479,484,499,516,518,521,525,526,527,530,532,536,539,545,546,547,549,551,554,555,556,561,562,563,566,567,568,571,572,575,577,582,585,588,589,766,767,634,610,615,618,619,624,625,627,632,636,639,643,646,648,650,651,656,663,664,669,671,673,678,682,683,686,690,692,693,696,697,706,707,708,710,715,717,723,724,725,727,731,742,733,734,736,738,740,746,747,750,752,754,756,759,760,763,772,776,779,780,796,800,807,811,813,814,816,817,821,822,824,827,829,833,834,839,845,851,853,854,857,864,866,869,874,876,877,878,885,886,887,888,891,896,907,911,914,915,917,919,920,922,925,927,929,936,937,940,944,946,947,951,954,957,958,963,965,966,967,968,971,977,980,983,985,987,990,993,995,997,998,1001,1002,1004,1005,1007,1010,1011,1014,1015,1017,1019,1020,1021,1022,1025,1028,1030,1035,1038,1040,1041,1048,1052,1053,1055,1059,1065,1067,1069,1076,1077,1079,1281,1081,1084,1089,1093,1094,1096,1103,1105,1108,1109,1111,1112,1113,1115,1119,1122,1124,1126,1128,1132,1136,1140,1142,1144,1146,1149,1153,1155,1157,1161,1498,1165,1173,1177,1179,1181,1184,1188,1189,1193,1194,1195,1199,1202,1204,1206,1209,1212,1215,1218,1222,1223,1228,1231,1233,1234,1238,1240,1243,1245,1246,1254,1255,1259,1260,1261,1262,1266,1268,1272,1274,1277,1474,1284,1286,1287,1290,1292,1296,1299,1302,1309,1312,1313,1318,1320,1321,1322,1324,1326,1327,1331,1333,1336,1339,1340,1342,1346,1347,1353,1355,1356,1358,1359,1361,1362,1363,1364,1365,1369,1373,1374,1377,1379,1382,1389,1392,1394,1395,1397,1398,1400,1401,1403,1404,1407,1410,1412,1416,1420,1422,1424,1426,1428,1430,1431,1434,1435,1436,1437,1438,1441,1443,1444,1445,1448,1449,1452,1455,1456,1457,1461,1463,1464,1466,1470,1473,1475,1476,1477,1478,1479,1486,1487,1489,1490,1491,1495,1497,1501,1510,1515,1519,1520,1521,1526,1528,1531,1532,1536,1539,1542,1545,1547,1549,1550,1551,1555,1558,1560,1563,1567,1572,1573,1575,1577,1578,1580,1582,1583,1585,1587,1586,1589,1591,1593,1594,1596,1597,1600,1601,1602,1603,1605,1608,1612,1616,1617,1619,1621,1626,1628,1630,1632,1634,1636,1637,1641,1642,1645,1647,1651,1652,1653,1669,1662,1663,1668,1670,1674,1675,1676,1678,1679,1680,1683,1684,1691,1692,1694,1701,1704,1706,1711,1714,1720,1723,1724,1725,1727,1730,1732,1736,1737,1738,1741,1743,1744,1748,1750,1755,1756,1759,1830,1760,1765,1767,1775,1776,1779,1787,1794,1797,1805,1809,1810,1811,1813,1816,1819,1822,1824,1826,1828,1832,1833,1836,1841,1843,1846,1848,1849,1850,1851,1853,1855,1858,1861,1872,1864,1865,1873,1876,1877,1878,1880,1884,1890,1893,1897,1903,1904,1910,1907,1911,1913,1914,1916,1919,1922,1923,1925,1926,1927,1929,1932,1934,1936,1937,1940,1942,1944,1945,1946,1948,1949,1951,1952,1953,1956,1960,1963,1965,1970,1971,1972,1978,1980,1981,1984,1983,223,224,225,229,230,232,233,347,234,235,348,268,270,286,274,278,280,281,283,284,288,289,292,294,297,298,299,300,302,303,344,306,310,312,314,315,316,343,317,318,321,342,322,324,355,354,328,359,334,335,340,349,352,361,365,366,368,369,372,374,375,377,379,381,384,385,389,388,391,393,394,396,397,398,400,403,404,405,410,411,415,417,419,420,422,423,424,425,426,427,429,430,432,434,435,436,437,439,440,441,443,445,446,447,449,454,456,458,461,462,464,466,467,469,471,472,660,476,478,480,473,481,482,483,485,514,515,517,519,520,522,523,524,542,528,529,531,533,534,535,537,538,540,541,543,544,548,550,552,553,557,558,559,560,565,569,570,573,576,578,579,580,581,583,584,586,587,590,592,593,633,635,1282,605,611,753,614,616,620,621,622,623,626,628,629,630,631,637,638,641,644,647,649,654,655,657,658,659,661,662,666,667,668,670,672,674,675,684,677,685,687,688,689,691,694,699,700,701,703,704,705,709,711,713,714,716,718,719,721,722,726,728,730,735,737,739,741,743,744,745,748,749,751,757,758,761,762,764,765,788,768,769,770,771,773,774,777,785,781,782,783,784,786,789,791,795,799,804,810,812,815,818,820,823,825,826,828,831,832,835,836,837,841,838,840,842,844,848,847,846,849,850,852,855,856,858,859,860,861,862,863,865,867,868,870,871,872,879,880,881,882,883,884,889,890,892,893,894,895,897,905,938,906,909,910,912,913,916,918,921,923,924,926,928,930,931,932,933,934,935,939,941,943,945,948,949,950,952,953,955,956,959,960,962,964,978,979,981,982,984,986,989,991,992,994,996,999,1000,1003,1008,1009,1012,1013,1016,1018,1023,1024,1026,1029,1031,1032,1033,1034,1036,1037,1039,1043,1044,1045,1046,1047,1049,1050,1051,1054,1056,1057,1058,1060,1061,1062,1063,1064,1066,1068,1070,1074,1075,1078,1080,1082,1083,1085,1086,1087,1088,1090,1091,1092,1095,1097,1098,1099,1100,1101,1102,1104,1106,1107,1110,1114,1116,1117,1118,1120,1121,1123,1125,1129,1130,1131,1133,1134,1135,1138,1139,1141,1143,1145,1147,1148,1150,1151,1152,1154,1156,1158,1162,1169,1163,1164,1166,1168,1171,1172,1174,1175,1176,1178,1180,1182,1183,1185,1186,1187,1190,1191,1192,1196,1197,1198,1200,1201,1203,1205,1207,1208,1210,1211,1213,1214,1216,1217,1219,1220,1221,1224,1225,1226,1227,1229,1230,1232,1236,1237,1239,1241,1242,1244,1247,1248,1249,1251,1252,1253,1256,1257,1258,1263,1264,1265,1267,1269,1270,1271,1273,1275,1278,1280,1283,1285,1289,1294,1291,1293,1295,1297,1300,1301,1304,1305,1307,1308,1310,1311,1314,1315,1317,1319,1323,1325,1328,1329,1330,1332,1334,1335,1337,1338,1341,1343,1344,1345,1348,1349,1350,1351,1352,1354,1368,1357,1360,1366,1367,1370,1371,1372,1375,1376,1378,1380,1381,1383,1384,1385,1386,1387,1388,1390,1391,1393,1396,1399,1405,1402,1406,1408,1409,1411,1413,1414,1415,1417,1418,1419,1421,1423,1425,1427,1429,1432,1433,1439,1440,1442,1446,1447,1450,1451,1453,1454,1458,1459,1462,1465,1467,1468,1471,1472,1480,1481,1482,1484,1485,1488,1492,1493,1494,1499,1500,1502,1503,1504,1505,1506,1507,1508,1509,1511,1513,1514,1516,1517,1518,1522,1523,1524,1525,1527,1529,1530,1534,1535,1537,1540,1541,1543,1544,1546,1548,1552,1553,1554,1556,1557,1559,1561,1562,1564,1565,1566,1568,1569,1570,1571,1576,1579,1581,1584,1588,1590,1592,1595,1599,1606,1607,1614,1609,1610,1611,1613,1615,1618,1620,1623,1624,1625,1627,1629,1631,1633,1635,1638,1639,1640,1643,1644,1648,1870,1649,1650,1654,1655,1667,1656,1657,1658,1659,1660,1661,1664,1665,1666,1672,1671,1673,1677,1681,1682,1685,1686,1687,1688,1689,1693,1695,1696,1697,1698,1699,1702,1703,1705,1710,1712,1713,1715,1791,1719,1721,1722,1726,1728,1729,1731,1734,1735,1739,1740,1742,1745,1746,1747,1749,1751,1752,1753,1754,1757,1761,1762,1763,1764,1766,1769,1770,1771,1772,1773,1774,1777,1778,1780,1781,1782,1783,1784,1786,1788,1789,1790,1792,1798,1793,1795,1796,1799,1800,1801,1802,1803,1804,1806,1807,1808,1812,1814,1815,1817,1818,1820,1823,1825,1891,1827,1829,1831,1834,1835,1837,1838,1839,1842,1844,1845,1847,1852,1854,1856,1860,1862,1863,1866,1867,1868,1869,1874,1879,1881,1882,1883,1885,1886,1887,1888,1892,1894,1895,1896,1898,1899,1900,1901,1902,1905,1906,1908,1909,1912,1917,1915,1918,1920,1921,1924,1928,1930,1931,1933,1935,1938,1939,1941,1943,1947,1950,1954,1955,1957,1958,1959,1961,1962,1964,1968,1966,1967,1969,1973,1974,1975,1976,1977,1979,1982,1986)
  AND tag.published = 1
  ORDER BY tag.name asc
29. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM wvb4o_k2_items as i RIGHT JOIN wvb4o_k2_categories c
  ON c.id = i.catid
  LEFT JOIN wvb4o_k2_additional_categories AS ca
  ON ca.itemID = i.id
  WHERE i.published = 1
  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.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-22 20:13:11' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-22 20:13:11' )
  AND (c.id IN (47) OR ca.catid IN (47))
  ORDER BY i.id DESC
  LIMIT 0, 5
30. SELECT id
  FROM wvb4o_k2_categories
  WHERE parent IN (54)
  AND id NOT IN (54)
  AND published=1
  AND trash=0
  AND access IN(1,1)
31. SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM wvb4o_k2_items as i RIGHT JOIN wvb4o_k2_categories c
  ON c.id = i.catid
  LEFT JOIN wvb4o_k2_additional_categories AS ca
  ON ca.itemID = i.id
  WHERE i.published = 1
  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.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-11-22 20:13:11' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-11-22 20:13:11' )
  AND (i.catid IN (54) OR ca.catid IN (54))
  ORDER BY i.created DESC
  LIMIT 0, 15
32. SELECT c.id,c.title,c.introtext,c.fulltext
  FROM wvb4o_content AS c
  WHERE c.state = '1'
  AND c.catid ='79'
  AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2019-11-22 20:13:11')
  AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2019-11-22 20:13:11')
  AND c.access IN(1,1)
  ORDER BY c.id ASC
33. SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM wvb4o_categories as c
  LEFT JOIN wvb4o_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM wvb4o_categories AS cat JOIN wvb4o_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
  WHERE parent.extension = 'com_content'
  AND parent.published != 1
  GROUP BY cat.id) AS badcats
  ON badcats.id = c.id
  WHERE (c.extension='com_content' OR c.extension='system')
  AND c.access IN (1,1)
  AND c.published = 1
  AND s.id=79
  AND badcats.id is null
  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id
  ORDER BY c.lft
34. SELECT id,parent_id
  FROM wvb4o_menu
  WHERE id = 435
35. SELECT id,parent_id
  FROM wvb4o_menu
  WHERE id = 1
36. SELECT id,parent_id
  FROM wvb4o_menu
  WHERE id = 435
37. SELECT id,parent_id
  FROM wvb4o_menu
  WHERE id = 1
38. SELECT *
  from wvb4o_xtcronjob_tasks
  WHERE ran_at < '2019-11-22 20:13:14'
  AND published=1
39. UPDATE `wvb4o_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1574453591;s:18:\"session.timer.last\";i:1574453591;s:17:\"session.timer.now\";i:1574453591;s:24:\"session.client.forwarded\";s:13:\"35.172.195.49\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:5:\"style\";s:7:\"default\";}' , `time` = '1574453594'
  WHERE `session_id` = 'ojbepni711529qrurctqg4oit2'

26 naplózott lekérdezéstípus, rendezés előfordulás szerint

SELECT táblák:

1. 6 × SELECT id,parent_id
  FROM wvb4o_menu
2. 4 × SELECT i.*,
  CASE WHEN i.modified = 0 THEN i.created ELSE i.modified END as lastChanged, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
  FROM wvb4o_k2_items as i RIGHT JOIN wvb4o_k2_categories c
  ON c.id = i.catid
  LEFT JOIN wvb4o_k2_additional_categories AS ca
  ON ca.itemID = i.id
3. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM wvb4o_extensions
4. 3 × SELECT id
  FROM wvb4o_k2_categories
5. 1 × SELECT distinct(m.id), title, module, position, content, showtitle, params
  FROM wvb4o_modules AS m
  LEFT JOIN wvb4o_modules_menu AS mm
  ON mm.moduleid = m.id
6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM wvb4o_modules AS m
  LEFT JOIN wvb4o_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN wvb4o_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
7. 1 × SELECT tag.name, tag.id
  FROM wvb4o_k2_tags as tag
  LEFT JOIN wvb4o_k2_tags_xref AS xref
  ON xref.tagID = tag.id
8. 1 × SELECT *
  from wvb4o_xtcronjob_tasks
9. 1 × SELECT c.*,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
  FROM wvb4o_categories as c
  LEFT JOIN wvb4o_categories AS s
  ON (s.lft <= c.lft
  AND s.rgt >= c.rgt) OR (s.lft > c.lft
  AND s.rgt < c.rgt)
  LEFT JOIN (SELECT cat.id as id
  FROM wvb4o_categories AS cat JOIN wvb4o_categories AS parent
  ON cat.lft BETWEEN parent.lft
  AND parent.rgt
10. 1 × SELECT c.id,c.title,c.introtext,c.fulltext
  FROM wvb4o_content AS c
11. 1 × SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
  CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = 0 THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,contact.id as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
  FROM wvb4o_content AS a
  LEFT JOIN wvb4o_categories AS c
  ON c.id = a.catid
  LEFT JOIN wvb4o_users AS ua
  ON ua.id = a.created_by
  LEFT JOIN wvb4o_users AS uam
  ON uam.id = a.modified_by
  LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language
  FROM wvb4o_contact_details AS contact
12. 1 × SELECT i.id
  FROM wvb4o_k2_items as i
  LEFT JOIN wvb4o_k2_categories c
  ON c.id = i.catid
13. 1 × SELECT b.rules
  FROM wvb4o_assets AS a
  LEFT JOIN wvb4o_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
14. 1 × SELECT folder AS type, element AS name, params
  FROM wvb4o_extensions
15. 1 × SELECT id, rules
  FROM `wvb4o_viewlevels
16. 1 × SELECT b.id
  FROM wvb4o_usergroups AS a
  LEFT JOIN wvb4o_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
17. 1 × SELECT `session_id`
  FROM `wvb4o_session`
18. 1 × SELECT *
  FROM wvb4o_vflow_con
19. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
  FROM wvb4o_menu AS m
  LEFT JOIN wvb4o_extensions AS e
  ON m.component_id = e.extension_id
20. 1 × SELECT a.rules
  FROM wvb4o_assets AS a
21. 1 × SELECT *
  FROM wvb4o_languages
22. 1 × SELECT id, home, template, s.params
  FROM wvb4o_template_styles as s
  LEFT JOIN wvb4o_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
23. 1 × SELECT `data`
  FROM `wvb4o_session`

EGYÉB táblák:

1. 1 × UPDATE `wvb4o_session`
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1574453591;s:18:\"session.timer.last\";i:1574453591;s:17:\"session.timer.now\";i:1574453591;s:24:\"session.client.forwarded\";s:13:\"35.172.195.49\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:5:\"style\";s:7:\"default\";}' , `time` = '1574453594'
2. 1 × INSERT INTO `wvb4o_session` (`session_id`, `client_id`, `time`)
  VALUES ('ojbepni711529qrurctqg4oit2', 0, '1574453591'
3. 1 × DELETE
  FROM `wvb4o_session`