7 naplózott lekérdezés

1. SELECT `data`
  FROM `termesze_session`
  WHERE `session_id` = 'cf78ebtn28dfmk20fhb12eer84'
2. SELECT `session_id`
  FROM `termesze_session`
  WHERE `session_id` = 'cf78ebtn28dfmk20fhb12eer84'
  LIMIT 0, 1
3. INSERT INTO `termesze_session` (`session_id`, `client_id`, `time`)
  VALUES ('cf78ebtn28dfmk20fhb12eer84', 0, '1775845178')
4. SELECT b.id
  FROM termesze_usergroups AS a
  LEFT JOIN termesze_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
5. SELECT id, rules
  FROM `termesze_viewlevels`
6. 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 termesze_menu AS m
  LEFT JOIN termesze_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
7. UPDATE `termesze_session`
  SET `data` = 'PKax4J9GclJHZ9bodmv52Ka_hLOqgpfJAGCul3YqtpqI29tbYn6PSF6Gmopklc_kpT6LT0RFSj4gysQyfwT9UJkRSHS245zkjBM5RIFoTOzUd6pv12LV6XAKwieLBFQ9SlwoyafH1Y_fsD97B622BgWrnIL5TDwW4Lq89rxMdBz1gcYNVgVbIpBdjua8nk3jBfenmglcCHTDxm4-CpJZ6JFNZTeKhrwECT8K4PwS46FfJZAgZsyDstfyLXr7k66Kno4XZtUc_uao_lL9jAW28porrfC3-zPOG1JhsOCukVReYp7OsbbuA17dsDgJiES84IY088bRDm_JF0eIENh1tKvacdkY5DKLE29OYBZ19EBTX9-aBc_oMfhN4o-Mznc_LvKdOXYaF3q6wWV54gwPOylrjxRh9aGNhOzg1J0qfy-lPbrVeZs62DlMta0Se3GwODqfslVMdSlHLImrDv5w2AjwlNvclUuyFhdTlf4_ZdS9T86nrDgdlqQP3LnI1AgR72-qEqYn9BWd6THdwGCBUzN9C72CGI_QnowzlTxtjspKjCAqoaY9hida1qw5GEaw8J5jUiBG1P0mX7zmYH_hBBZByQqJKGgClGR_oU_poI7RSpfIdOWE4K104CO28hDgPJKvEco2Hjyb7KCdKv9yFEwkhOejE9OvGNZHUw4HviIutxzY6cBdZXI5YHpu-cCO05z4URGUYwKPpdRssaPguUmN_b2s_JY-S96sHEF2m6fITeCmxGrrk6dZqgn78146jNY5J_jLoE93QJJZskiWX-4KO-813baKKuXBxt407G5icBPmsYIeaWebqKtIf9HjHZWbX2SNkQNAa-8loxXCLOAnvMLIztevaXUyX8SmHr7WeIeiF2DmhNUQxvhd-rDytVJq79hpfgzCThkOgln_mVf0oxK6Ru4Wru1eJY4eNxgnyVJDfDU9d4qQxCh7x1HaKD7IEH-AZ3EZs1MTejcH5Bwo9pUOa8YNHzPBFjEOvMBOXvT77pK07r6QufXteVYZ0P6SeqVb6UN2UChTYkoKwKfSWPZC8CoJqMHi_ah9CXJUrm_vjFeb6lllxifi2OJyX8zElFd4LBdHU4ivl8STzK0aqOBCYW4NhxC2A62QAo1JHpsgfw3dirZtzOlOnBxHiJy4FnAsXc8GbZIf2bXP7sex1u1kRU-3Ogq5ptWSyBqO2Qr6nLvLw_G3WYbt9oHXSaY6FcBkyaRz31AJf3a9v7Cc3zT6dl0ePdNSWkt1qBGQmQmZimZeIFSlgATqf4O6gRgBDyc0yQ0YEZviC59H5s6c2DIg8JJD80pNpz9uoDZevZpmuVDX8shIFT1louuZbYvTUgtfpe3yj24FoUfK2y9SIQmOl1IjBunnOh-jNhc.' , `time` = '1775845179'
  WHERE `session_id` = 'cf78ebtn28dfmk20fhb12eer84'

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

SELECT táblák:

1. 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 termesze_menu AS m
  LEFT JOIN termesze_extensions AS e
  ON m.component_id = e.extension_id
2. 1 × SELECT id, rules
  FROM `termesze_viewlevels
3. 1 × SELECT b.id
  FROM termesze_usergroups AS a
  LEFT JOIN termesze_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
4. 1 × SELECT `session_id`
  FROM `termesze_session`
5. 1 × SELECT `data`
  FROM `termesze_session`

EGYÉB táblák:

1. 1 × UPDATE `termesze_session`
  SET `data` = 'PKax4J9GclJHZ9bodmv52Ka_hLOqgpfJAGCul3YqtpqI29tbYn6PSF6Gmopklc_kpT6LT0RFSj4gysQyfwT9UJkRSHS245zkjBM5RIFoTOzUd6pv12LV6XAKwieLBFQ9SlwoyafH1Y_fsD97B622BgWrnIL5TDwW4Lq89rxMdBz1gcYNVgVbIpBdjua8nk3jBfenmglcCHTDxm4-CpJZ6JFNZTeKhrwECT8K4PwS46FfJZAgZsyDstfyLXr7k66Kno4XZtUc_uao_lL9jAW28porrfC3-zPOG1JhsOCukVReYp7OsbbuA17dsDgJiES84IY088bRDm_JF0eIENh1tKvacdkY5DKLE29OYBZ19EBTX9-aBc_oMfhN4o-Mznc_LvKdOXYaF3q6wWV54gwPOylrjxRh9aGNhOzg1J0qfy-lPbrVeZs62DlMta0Se3GwODqfslVMdSlHLImrDv5w2AjwlNvclUuyFhdTlf4_ZdS9T86nrDgdlqQP3LnI1AgR72-qEqYn9BWd6THdwGCBUzN9C72CGI_QnowzlTxtjspKjCAqoaY9hida1qw5GEaw8J5jUiBG1P0mX7zmYH_hBBZByQqJKGgClGR_oU_poI7RSpfIdOWE4K104CO28hDgPJKvEco2Hjyb7KCdKv9yFEwkhOejE9OvGNZHUw4HviIutxzY6cBdZXI5YHpu-cCO05z4URGUYwKPpdRssaPguUmN_b2s_JY-S96sHEF2m6fITeCmxGrrk6dZqgn78146jNY5J_jLoE93QJJZskiWX-4KO-813baKKuXBxt407G5icBPmsYIeaWebqKtIf9HjHZWbX2SNkQNAa-8loxXCLOAnvMLIztevaXUyX8SmHr7WeIeiF2DmhNUQxvhd-rDytVJq79hpfgzCThkOgln_mVf0oxK6Ru4Wru1eJY4eNxgnyVJDfDU9d4qQxCh7x1HaKD7IEH-AZ3EZs1MTejcH5Bwo9pUOa8YNHzPBFjEOvMBOXvT77pK07r6QufXteVYZ0P6SeqVb6UN2UChTYkoKwKfSWPZC8CoJqMHi_ah9CXJUrm_vjFeb6lllxifi2OJyX8zElFd4LBdHU4ivl8STzK0aqOBCYW4NhxC2A62QAo1JHpsgfw3dirZtzOlOnBxHiJy4FnAsXc8GbZIf2bXP7sex1u1kRU-3Ogq5ptWSyBqO2Qr6nLvLw_G3WYbt9oHXSaY6FcBkyaRz31AJf3a9v7Cc3zT6dl0ePdNSWkt1qBGQmQmZimZeIFSlgATqf4O6gRgBDyc0yQ0YEZviC59H5s6c2DIg8JJD80pNpz9uoDZevZpmuVDX8shIFT1louuZbYvTUgtfpe3yj24FoUfK2y9SIQmOl1IjBunnOh-jNhc.' , `time` = '1775845179'
2. 1 × INSERT INTO `termesze_session` (`session_id`, `client_id`, `time`)
  VALUES ('cf78ebtn28dfmk20fhb12eer84', 0, '1775845178'