57 Queries Logged

1. SELECT `data`
  FROM `pf9ob_session`
  WHERE `session_id` = '89n6o4khvc664m3vo88clsgmn1'
2. SELECT `session_id`
  FROM `pf9ob_session`
  WHERE `session_id` = '89n6o4khvc664m3vo88clsgmn1'
  LIMIT 0, 1
3. INSERT INTO `pf9ob_session` (`session_id`, `client_id`, `time`)
  VALUES ('89n6o4khvc664m3vo88clsgmn1', 0, '1579854164')
4. SELECT extension_id AS id, element AS "option", params, enabled
  FROM pf9ob_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
5. SELECT b.id
  FROM pf9ob_usergroups AS a
  LEFT JOIN pf9ob_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
6. SELECT id, rules
  FROM `pf9ob_viewlevels`
7. SELECT folder AS type, element AS name, params
  FROM pf9ob_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
8. SELECT *
  FROM pf9ob_languages
  WHERE published=1
  ORDER BY ordering ASC
9. SELECT extension_id AS id, element AS "option", params, enabled
  FROM pf9ob_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
10. 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 pf9ob_menu AS m
  LEFT JOIN pf9ob_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
11. SELECT id, home, template, s.params
  FROM pf9ob_template_styles as s
  LEFT JOIN pf9ob_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
12. SELECT extension_id AS id, element AS "option", params, enabled
  FROM pf9ob_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_k2'
13. SELECT time
  FROM pf9ob_vvisit_counter USE INDEX(time)
  ORDER BY time DESC
  LIMIT 1;
14. UPDATE pf9ob_vvisit_counter
  SET visits=visits+1, bots=bots+1
  WHERE time=1579860000;
15. SELECT a.rules
  FROM pf9ob_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
16. SELECT b.rules
  FROM pf9ob_assets AS a
  LEFT JOIN pf9ob_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_k2' OR a.parent_id=0)
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
17. SELECT id
  FROM pf9ob_k2_categories
  WHERE published=1
  AND trash=0
  AND access IN(1,1)
18. SHOW FULL COLUMNS
  FROM `pf9ob_k2_categories`
19. SELECT *
  FROM pf9ob_k2_categories
  WHERE id = '54'
20. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=54
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN('en-GB', '*')
  ORDER BY id ASC
21. SELECT id
  FROM pf9ob_k2_categories
  WHERE parent IN (54)
  AND id NOT IN (54)
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN('en-GB', '*')
22. 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 pf9ob_k2_items as i
  LEFT JOIN pf9ob_k2_categories AS c
  ON c.id = i.catid
  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 c.language IN ('en-GB','*')
  AND i.language IN ('en-GB','*')
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-01-24 08:22:44' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-01-24 08:22:44' )
  AND c.id IN (54)
  ORDER BY i.id DESC
  LIMIT 0, 14
23. SELECT COUNT(*)
  FROM pf9ob_k2_items as i
  LEFT JOIN pf9ob_k2_categories c
  ON c.id = i.catid
  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 c.language IN ('en-GB','*')
  AND i.language IN ('en-GB','*')
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2020-01-24 08:22:44' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-01-24 08:22:44' )
  AND c.id IN (54)
24. SELECT tag.*
  FROM pf9ob_k2_tags AS tag JOIN pf9ob_k2_tags_xref AS xref
  ON tag.id = xref.tagID
  WHERE tag.published=1
  AND xref.itemID = 372
  ORDER BY xref.id ASC
25. SHOW FULL COLUMNS
  FROM `pf9ob_users`
26. SELECT *
  FROM `pf9ob_users`
  WHERE `id` = 322
27. SELECT `g`.`id`,`g`.`title`
  FROM `pf9ob_usergroups` AS g
  INNER JOIN `pf9ob_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 322
28. SELECT id, gender, description, image, url, `
  group`, plugins
  FROM pf9ob_k2_users
  WHERE userID=322
29. SELECT COUNT(*)
  FROM pf9ob_k2_comments
  WHERE itemID=372
  AND published=1
30. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM pf9ob_modules AS m
  LEFT JOIN pf9ob_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN pf9ob_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 <= '2020-01-24 08:22:44')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-01-24 08:22:44')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 700 OR mm.menuid <= 0)
  AND m.language IN ('en-GB','*')
  ORDER BY m.position, m.ordering
31. SELECT extension_id AS id, element AS "option", params, enabled
  FROM pf9ob_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
32. 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 pf9ob_k2_items as i
  LEFT JOIN pf9ob_k2_categories c
  ON c.id = i.catid
  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 <= '2020-01-24 08:22:44' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-01-24 08:22:44' )
  AND c.language IN ('en-GB', '*')
  AND i.language IN ('en-GB', '*')
  ORDER BY i.hits DESC
  LIMIT 0, 5
33. 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 pf9ob_k2_items as i
  LEFT JOIN pf9ob_k2_categories c
  ON c.id = i.catid
  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 <= '2020-01-24 08:22:44' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-01-24 08:22:44' )
  AND c.language IN ('en-GB', '*')
  AND i.language IN ('en-GB', '*')
  ORDER BY i.publish_up DESC
  LIMIT 0, 5
34. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=17
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
35. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=38
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
36. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=39
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
37. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=41
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
38. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=40
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
39. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=42
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
40. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=33
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
41. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=35
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
42. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=47
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
43. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=36
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
44. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=43
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
45. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=45
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
46. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=46
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
47. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=55
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
48. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=43
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
49. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=45
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
50. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=46
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
51. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=37
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
  ORDER BY ordering
52. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=48
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
53. SELECT *
  FROM pf9ob_k2_categories
  WHERE parent=49
  AND published=1
  AND trash=0
  AND access IN(1,1)
  AND language IN ('en-GB', '*')
54. SELECT i.id
  FROM pf9ob_k2_items as i
  LEFT JOIN pf9ob_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 <= '2020-01-24 08:22:44' )
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2020-01-24 08:22:44' )
  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(17,38,39,41,40,42,33,35,47,36,43,45,46,55,37,48,49)
  AND c.language IN ('en-GB', '*')
  AND i.language IN ('en-GB', '*')
55. SELECT tag.name, tag.id
  FROM pf9ob_k2_tags as tag
  LEFT JOIN pf9ob_k2_tags_xref AS xref
  ON xref.tagID = tag.id
  WHERE xref.itemID IN (107,112,114,120,2227,1782,108,113,131,132,2134,2136,2138,1779,1781,2135,308,714,779,1933,2022,2026,2092,2098,2111,2116,2118,2131,2146,2168,2194,2208,173,172,171,167,162,164,129,2143,2063,2001,1998,2018,1975,175,176,177,178,179,180,181,185,186,187,188,189,190,191,192,193,194,195,196,197,198,294,258,1674,260,262,280,290,298,305,364,391,428,462,827,627,559,668,705,799,783,830,854,855,889,890,1664,891,892,893,894,895,910,944,945,982,986,992,1000,1003,1027,1052,1054,1057,1058,1062,1119,1085,1095,1096,1097,1121,1123,1129,1132,1191,1252,1274,1981,1297,1371,1396,1397,1417,1418,1433,1443,1460,1466,1468,1470,1478,1480,1481,1488,1489,1491,1493,1514,1566,1565,1584,1594,1596,1606,1607,1608,1610,1611,1613,1617,1663,1665,1677,1682,1693,1710,1741,1763,1764,1766,1770,1799,1800,1822,1826,2000,1830,1833,1868,1838,1841,1845,1842,1843,1846,1847,1901,1924,1954,1972,1979,1995,2009,2024,2149,2150,2152,2155,2172,2173,2176,2177,2178,2216,130,227,245,246,247,248,249,250,251,252,253,254,265,266,267,268,269,270,271,272,273,274,275,276,277,281,288,295,440,119,337,586,1685,1686,1691,1793,1798,165,126,141,207,236,241,304,323,1016,1137,1147,1254,1256,1257,1259,1270,1271,1273,1289,1615,1669,160,159,166,170,169,499,168,163,154,155,156,492,144,138,2160,2161,2061,2062,2064,2053,2010,1997,2004,2006,2007,1964,1500,1048,143,2073,867,868,1973,2119,2072,136,2040,2029,1985,765,754,452,146,147,149,151,153,139,140,203,209,210,212,215,216,217,218,219,222,224,228,231,619,233,234,282,239,240,244,293,605,1752,257,355,1505,1414,491,259,261,1746,1747,278,292,283,284,286,287,289,297,299,302,363,303,306,307,309,312,313,320,321,344,324,325,326,329,330,334,335,336,865,339,340,343,345,346,348,349,351,352,353,354,356,357,358,360,362,365,366,368,376,377,378,379,381,383,384,385,386,387,388,389,394,395,397,420,407,399,401,405,406,408,409,410,411,412,414,415,416,421,423,425,427,429,430,432,434,436,437,455,441,442,444,445,447,448,449,450,454,457,458,459,461,464,465,466,467,472,468,1535,470,471,473,474,475,476,477,480,484,486,487,489,490,494,495,496,501,502,508,509,549,516,521,522,523,899,525,604,526,601,530,531,532,533,535,548,544,550,547,551,554,558,562,565,567,570,571,572,573,574,576,580,581,587,589,590,593,595,600,603,608,1172,1814,1802,609,614,616,620,1803,759,626,775,776,800,764,767,768,628,629,631,633,634,635,665,638,640,641,642,643,644,645,646,648,649,654,655,658,659,660,661,662,663,664,857,666,829,667,669,742,670,671,681,672,673,675,676,677,678,679,680,753,682,683,684,685,687,748,688,828,689,690,1504,694,699,695,696,697,700,747,702,703,704,706,711,713,715,716,726,729,730,732,733,736,738,740,743,744,745,749,751,756,757,782,760,761,762,769,780,781,784,785,786,793,806,807,808,809,810,812,813,814,815,816,818,817,819,820,826,821,823,824,825,832,833,834,835,836,837,840,843,846,849,850,851,852,856,859,860,861,862,863,864,870,965,871,872,874,875,876,877,878,879,880,882,883,885,887,888,897,898,1582,903,905,906,907,908,909,911,912,913,915,916,918,920,921,922,923,924,925,927,928,930,931,934,935,936,937,938,1140,940,942,943,946,948,949,950,951,953,956,957,960,963,964,966,967,968,969,971,1268,1411,1083,974,979,977,978,994,981,983,984,985,988,989,990,991,993,995,996,998,999,1001,1002,1004,1005,1007,1008,1009,1012,1013,1018,1076,1019,1020,1021,1022,1023,1025,1029,1030,1031,1033,1034,1035,1036,1038,1039,1040,1041,1042,1043,1044,1045,1046,1047,1051,1049,1066,1050,1053,1055,1056,1060,1061,1064,1065,1067,1069,1070,1072,1245,1074,1075,1077,1078,1079,1080,1084,1117,1093,1092,1098,1099,1100,1101,1102,1142,1105,1106,1109,1110,1112,1113,1114,1115,1116,1498,1122,1118,2079,2075,2027,1120,1143,1124,1125,1127,1128,1497,1130,1131,1166,1496,1133,1134,1136,1138,1139,2078,1141,1144,1148,1146,1149,1150,1151,1153,1155,1156,1157,1158,1159,1160,1162,1163,1164,1167,1168,1169,1170,1173,1174,1175,1176,1177,1184,1188,1189,1190,1192,1194,1195,1197,1198,1207,1201,1202,1203,1204,1205,1209,1210,1211,1215,1216,1219,1220,1221,1222,1224,1223,1225,1229,1231,1233,1234,1237,1238,1240,1242,1243,1244,1246,1247,1248,1249,1251,2057,1258,1261,1262,1263,1264,1265,1266,1267,1269,1272,2028,1276,1277,1278,1410,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1290,1291,1292,1293,1294,1295,1296,1298,1299,1300,1301,1415,1407,1401,1302,1303,1304,1305,1306,1307,1308,1309,1310,1311,1312,1313,1315,1316,1317,1319,1321,1323,1324,1325,1327,1328,1330,1331,1332,1333,1335,1336,1337,1338,1339,1340,1342,1343,1344,1345,1346,1347,1363,1348,1349,1350,1351,1352,1353,1354,1355,1356,1357,1359,1360,1361,1364,1366,1368,1369,1370,1376,1372,1373,1374,1377,1378,1380,1381,1383,1385,1386,1387,1388,1389,1390,1391,1393,1394,1987,1399,1404,2038,2039,1400,1402,1403,1406,1408,1409,1412,1413,1416,1419,1420,1422,1423,1424,1425,1426,1427,1428,1429,1430,1431,1432,1434,1435,1436,1437,1439,1440,1441,1442,1444,1445,1446,1456,1448,1449,1450,1451,1452,1453,1454,1455,1930,1567,1457,1458,1459,1461,1462,1463,1464,1465,1467,1469,1472,1471,1473,1474,1475,1476,1477,1479,1482,1483,1484,1485,1486,1487,1490,1492,1795,1494,1495,1499,1501,1503,1502,1507,1508,1509,1510,1511,1512,1515,1516,1517,1518,1519,1520,1521,1522,1523,1524,1525,1526,1531,1527,1529,1530,1532,1533,2205,1534,1561,1546,1536,1537,1745,1538,1539,1540,1541,1542,1543,1544,1545,1547,1548,1549,1550,1551,1552,1553,1554,1555,1556,1557,1560,1562,1563,1564,1569,1570,1626,1571,1572,1573,1574,1575,1576,1578,1580,1583,1585,1586,1587,1588,1589,1599,1590,1591,1592,1593,1595,1597,1598,1600,1601,1602,1603,1604,1605,1609,1612,1614,1616,1618,1619,1620,1673,1622,1623,1624,1625,1627,1628,1630,1631,1632,1633,1635,1636,1637,1638,1639,1640,1641,1642,1643,1644,1646,1647,1648,1649,1650,1651,1652,1653,1654,1655,1656,1657,1658,1659,1660,1662,1666,1667,1668,1670,1671,1672,1675,1676,2008,1678,1679,1680,1681,1697,1692,2059,1931,1684,1687,1688,1689,1690,1694,1695,1698,1699,1700,1701,1703,1706,1707,1704,1705,1708,1709,2016,2003,1711,1715,1712,1716,1717,1718,1719,1720,1721,1722,1723,1724,1725,1726,1729,1731,1732,1733,1734,1735,1736,1737,1740,1742,1743,1748,1749,1750,1751,1753,1754,1773,1756,1757,1758,1759,1760,1761,1762,1767,1768,1769,1771,1772,1774,1775,1777,1778,1783,1784,1785,1786,1787,1796,1788,1789,1791,1790,1792,1794,2034,1801,1966,1804,1806,1808,1809,1810,1811,1812,1813,1815,1816,1817,1818,1819,1823,1824,1825,2060,2065,2071,1986,1983,1828,1831,1832,1835,1867,2165,1869,1870,2130,1836,1875,1876,1877,1878,1854,1837,1839,1840,1844,1848,1852,1855,1874,1873,1872,1856,1857,1858,1859,1860,1871,1862,1863,1864,1865,1866,1879,1880,1881,1882,1883,1884,1885,1886,1887,1888,1889,1890,1891,1892,1893,1894,1895,1896,1897,1898,1899,1900,2199,2203,2005,1902,1904,1905,1906,1907,1908,1909,1910,1911,1912,1913,1914,1915,1916,1917,1918,1919,1920,1923,2017,2183,1925,1936,1928,1991,1990,1938,1941,1935,1937,1939,1942,1943,1944,1945,1946,1947,1948,1949,1950,1951,1955,1956,1957,1958,1959,1960,1961,2076,1962,1963,1965,1967,1976,1968,1969,1970,2035,1971,1974,1977,1978,1980,1982,1993,1988,1989,1994,1996,2011,2014,2015,2019,2021,2023,2025,2031,2030,2032,2036,2037,2046,2041,2047,2042,2043,2045,2058,2049,2050,2052,2055,2056,2068,2070,2077,2074,2080,2096,2081,2082,2084,2085,2086,2095,2088,2090,2091,2093,2099,2100,2102,2104,2105,2106,2107,2108,2110,2112,2113,2114,2115,2120,2121,2122,2124,2123,2125,2129,2127,2128,2132,2185,2186,2139,2142,2145,2153,2154,2156,2157,2158,2159,2162,2163,2166,2167,2169,2170,2171,2175,2179,2180,2181,2182,2184,2187,2188,2189,2190,2191,2192,2193,2195,2196,2202,2197,2198,2204,2206,2207,2209,2211,2212,2217,2218,2219,2220,2221,2224,2225,2226,2228,2229,2230,2232,161,158,135,183,199,205,221,232,237,243,256,630,263,331,347,396,463,479,485,493,513,514,527,536,543,552,553,561,563,564,568,584,588,591,592,596,599,611,618,623,771,778,632,637,651,652,674,701,708,720,722,723,725,746,755,804,805,838,844,853,869,941,947,952,961,962,975,987,1006,1011,1032,1087,1161,1179,1183,1185,1200,1217,1227,1326,1358,1362,1365,1727,1805,766,152,142,208,230,238,322,255,1506,279,300,301,310,311,314,315,316,317,318,319,327,328,332,333,866,498,338,341,359,367,380,382,398,400,402,403,404,413,417,418,419,424,426,431,433,446,451,453,460,478,481,482,483,488,500,503,504,505,507,510,511,512,515,517,518,519,520,524,577,602,528,529,534,537,539,538,540,541,542,545,546,555,557,560,566,575,578,579,582,583,585,606,607,621,610,612,613,615,617,622,774,636,639,647,650,653,657,693,692,707,709,712,717,718,719,721,727,728,731,734,735,737,739,741,752,758,763,789,790,791,792,796,801,802,803,811,822,831,839,841,842,845,847,848,858,919,873,881,884,886,901,914,917,1375,929,932,933,939,954,955,958,959,972,976,980,1010,1014,1015,1024,1028,1037,1091,1086,1063,1068,1071,1073,1082,1088,1090,1111,1135,1145,1152,1154,1165,1171,1178,1180,1182,1186,1187,1193,1196,1199,1206,1212,1208,1213,1214,1218,1226,1228,1232,1235,1236,1239,1241,1250,1253,1255,1260,1275,1405,1314,1329,1334,1367,1379,1382,1384,1398,1395,1421,1438,1447,1568,1528,1558,1559,1577,1579,1581,1621,1629,1634,1661,1683,1696,1702,2002,1714,1739,1744,1755,1765,1780,1797,1807,1820,1821,1827,1829,1834,2164,1853,1861,1921,2200,2201,1903,1922,1926,1929,1932,1984,1992,1999,2012,2013,2020,2048,2051,2054,2066,2067,2069,2083,2087,2089,2094,2101,2097,2103,2109,2117,2126,2133,2140,2141,2144,2147,2151,2174,145,148,184,201,202,206,213,220,223,342,390,624,625,1645,1728,1730,182,211,225,226,264,556,569,597,772,698,724,157,150,200,204,214,229,242,285,598,691,710,787,1081,1108,1392,2231,2233)
  AND tag.published = 1
56. SELECT SUM(visits) AS visits
  FROM pf9ob_vvisit_counter
  WHERE '1=1'
  AND time > 1579798800
57. UPDATE `pf9ob_session`
  SET `data` = 'BFYlBPYpIcmiRlJGaoWep4zd5xJHfZdeW91ixuV2-FbN0d1w7TX_-FEebsfzu4XvPNrta3WNpuKK5d7elefaIu9INUquFj_5v0gUCmSWFCIpglIu27v3G9nqYSxo1O5xN9PWDL6uehh0YpQQRuxthfp4tMfnMcxHXOMZglFwBlcebFld0EMrRuBoJ2ttLuR31-dVOFEPlIWPvLwRey0LSv-AtpU2zupQ0LUyf-eANPR5ziWTOGZnVejF-p4J46flXNqbieIEMuP5R7eMzymmW-KpvJ7leP5GgXeIRGLinyuP1KkxqNPCk4XyGkNyJHoFqz6g8BCQ29LRzB3xJE0Kh0bduJW4DKUinZ5duPRXShjwBKLUs2wU1rkXo9GknNcganv0vd6_Lsnt8ukxomCGSClM6HDfPBcVTlatmLAQwLY5G9QwdRiiRGpx7bDb70bpjz07prjf1kS7QzvO9nVGyzi0Hp6avVAx1pDkDWtLio1X0RdQZ7udSgNT6GW1HUDlKdIZvRhmUfkD9LrPUj53ztVEbo3f8MrWjW-wb7wnfnA3XOsTP0_eOMEiAgiH3Xc9Q5_sJQgmJx3hqFR3tHSSlAaSTjCBoYI0QOx4VfVHbQqUyWvOoawGNjAwz3TCDFBB3zcgf9HbNMJo9nWzhW9DFovVGoEak556dQsSK9LKSUusbGNRVUiQKGHcU1jgLhWCUQwH0pEF_PW2qpIChMXY0YTHvPzqa8ECE7UUpoCgZSHxPej2w0-W8d1jSX1oeg1Dz70LK7PPmx5cQoVf8Jf9oCkWE9BFLR7-2zijRJxfu8CCYqkXwXU7adTwq--GiTobmMiM8fFN9KgMRjhfXMQA0zAV0Hk6G15fk3tyrvP0K54_xqpTNNWpL1kqZKL7QLlPTC5ksMsaeZ1_aVyjXerBJWH5kKlbD0x6NxbJf0JeRLkhqjuapwlT2Ix7vvuz2uhI8RhYndwGgHqlIS62SEw113zOaCk7YUz7Z-SQRczkpSRVMSgE3XVIybRIAbJ8fBUFYjXyheCL5pLUQ5JpGP5kJbWpCCCGY32rxWhU9H07cH7kJQVJNZbxz1VU1oo3gOsdO6kTuh6e4vyS5FcBD-BbM0DaK8Ug2vmhKhMiGb4q2-kEuInv1bilnhgRKd0Zxpp7QbacNhehIjsXpEFp3b5RC1RN1CnT3v4ctc5gI3gBWPsjSbKGQm_MPf0Xz6PWHogZ3-BxkrhfbNZfzGz4YL4a10NiE5X2fhB2FeA_0hegR3E.' , `time` = '1579854164'
  WHERE `session_id` = '89n6o4khvc664m3vo88clsgmn1'

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 22 × SELECT *
  FROM pf9ob_k2_categories
2. 4 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM pf9ob_extensions
3. 2 × 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 pf9ob_k2_items as i
  LEFT JOIN pf9ob_k2_categories c
  ON c.id = i.catid
4. 1 × SELECT `g`.`id`,`g`.`title`
  FROM `pf9ob_usergroups` AS g
  INNER JOIN `pf9ob_user_usergroup_map` AS m
  ON m.group_id = g.id
5. 1 × SELECT *
  FROM `pf9ob_users`
6. 1 × SELECT tag.*
  FROM pf9ob_k2_tags AS tag JOIN pf9ob_k2_tags_xref AS xref
  ON tag.id = xref.tagID
7. 1 × SELECT COUNT(*)
  FROM pf9ob_k2_items as i
  LEFT JOIN pf9ob_k2_categories c
  ON c.id = i.catid
8. 1 × SELECT id, gender, description, image, url, `
  group`, plugins
  FROM pf9ob_k2_users
9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM pf9ob_modules AS m
  LEFT JOIN pf9ob_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN pf9ob_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
10. 1 × SELECT SUM(visits) AS visits
  FROM pf9ob_vvisit_counter
11. 1 × SELECT tag.name, tag.id
  FROM pf9ob_k2_tags as tag
  LEFT JOIN pf9ob_k2_tags_xref AS xref
  ON xref.tagID = tag.id
12. 1 × SELECT i.id
  FROM pf9ob_k2_items as i
  LEFT JOIN pf9ob_k2_categories c
  ON c.id = i.catid
13. 1 × 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 pf9ob_k2_items as i
  LEFT JOIN pf9ob_k2_categories AS c
  ON c.id = i.catid
14. 1 × SELECT COUNT(*)
  FROM pf9ob_k2_comments
15. 1 × SELECT `data`
  FROM `pf9ob_session`
16. 1 × SELECT *
  FROM pf9ob_languages
17. 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 pf9ob_menu AS m
  LEFT JOIN pf9ob_extensions AS e
  ON m.component_id = e.extension_id
18. 1 × SELECT folder AS type, element AS name, params
  FROM pf9ob_extensions
19. 1 × SELECT id, rules
  FROM `pf9ob_viewlevels
20. 1 × SELECT b.id
  FROM pf9ob_usergroups AS a
  LEFT JOIN pf9ob_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
21. 1 × SELECT id, home, template, s.params
  FROM pf9ob_template_styles as s
  LEFT JOIN pf9ob_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
22. 1 × SELECT time
  FROM pf9ob_vvisit_counter USE INDEX(time)
23. 1 × SELECT `session_id`
  FROM `pf9ob_session`
24. 1 × SELECT id
  FROM pf9ob_k2_categories
25. 1 × SELECT b.rules
  FROM pf9ob_assets AS a
  LEFT JOIN pf9ob_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
26. 1 × SELECT a.rules
  FROM pf9ob_assets AS a
27. 1 × SELECT id
  FROM pf9ob_k2_categories

OTHER Tables:

1. 1 × UPDATE `pf9ob_session`
  SET `data` = 'BFYlBPYpIcmiRlJGaoWep4zd5xJHfZdeW91ixuV2-FbN0d1w7TX_-FEebsfzu4XvPNrta3WNpuKK5d7elefaIu9INUquFj_5v0gUCmSWFCIpglIu27v3G9nqYSxo1O5xN9PWDL6uehh0YpQQRuxthfp4tMfnMcxHXOMZglFwBlcebFld0EMrRuBoJ2ttLuR31-dVOFEPlIWPvLwRey0LSv-AtpU2zupQ0LUyf-eANPR5ziWTOGZnVejF-p4J46flXNqbieIEMuP5R7eMzymmW-KpvJ7leP5GgXeIRGLinyuP1KkxqNPCk4XyGkNyJHoFqz6g8BCQ29LRzB3xJE0Kh0bduJW4DKUinZ5duPRXShjwBKLUs2wU1rkXo9GknNcganv0vd6_Lsnt8ukxomCGSClM6HDfPBcVTlatmLAQwLY5G9QwdRiiRGpx7bDb70bpjz07prjf1kS7QzvO9nVGyzi0Hp6avVAx1pDkDWtLio1X0RdQZ7udSgNT6GW1HUDlKdIZvRhmUfkD9LrPUj53ztVEbo3f8MrWjW-wb7wnfnA3XOsTP0_eOMEiAgiH3Xc9Q5_sJQgmJx3hqFR3tHSSlAaSTjCBoYI0QOx4VfVHbQqUyWvOoawGNjAwz3TCDFBB3zcgf9HbNMJo9nWzhW9DFovVGoEak556dQsSK9LKSUusbGNRVUiQKGHcU1jgLhWCUQwH0pEF_PW2qpIChMXY0YTHvPzqa8ECE7UUpoCgZSHxPej2w0-W8d1jSX1oeg1Dz70LK7PPmx5cQoVf8Jf9oCkWE9BFLR7-2zijRJxfu8CCYqkXwXU7adTwq--GiTobmMiM8fFN9KgMRjhfXMQA0zAV0Hk6G15fk3tyrvP0K54_xqpTNNWpL1kqZKL7QLlPTC5ksMsaeZ1_aVyjXerBJWH5kKlbD0x6NxbJf0JeRLkhqjuapwlT2Ix7vvuz2uhI8RhYndwGgHqlIS62SEw113zOaCk7YUz7Z-SQRczkpSRVMSgE3XVIybRIAbJ8fBUFYjXyheCL5pLUQ5JpGP5kJbWpCCCGY32rxWhU9H07cH7kJQVJNZbxz1VU1oo3gOsdO6kTuh6e4vyS5FcBD-BbM0DaK8Ug2vmhKhMiGb4q2-kEuInv1bilnhgRKd0Zxpp7QbacNhehIjsXpEFp3b5RC1RN1CnT3v4ctc5gI3gBWPsjSbKGQm_MPf0Xz6PWHogZ3-BxkrhfbNZfzGz4YL4a10NiE5X2fhB2FeA_0hegR3E.' , `time` = '1579854164'
2. 1 × SHOW FULL COLUMNS
  FROM `pf9ob_users
3. 1 × SHOW FULL COLUMNS
  FROM `pf9ob_k2_categories
4. 1 × UPDATE pf9ob_vvisit_counter
  SET visits=visits+1, bots=bots+1
5. 1 × INSERT INTO `pf9ob_session` (`session_id`, `client_id`, `time`)
  VALUES ('89n6o4khvc664m3vo88clsgmn1', 0, '1579854164'