7 naplózott lekérdezés

1. SELECT `data`
  FROM `termesze_session`
  WHERE `session_id` = '7f79so0kph7e6gm8mbfja9b0d7'
2. SELECT `session_id`
  FROM `termesze_session`
  WHERE `session_id` = '7f79so0kph7e6gm8mbfja9b0d7'
  LIMIT 0, 1
3. INSERT INTO `termesze_session` (`session_id`, `client_id`, `time`)
  VALUES ('7f79so0kph7e6gm8mbfja9b0d7', 0, '1774810166')
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` = 'WHBSSq64BTssIs9nPvcc3PnhgBoTuF5hS1dwMG5hk8ISiOC53LEJwJUiDaaG-QwZMATBuEMn0R0GBx6tnyIecvmPVDGq22rpucgUtfL7HYiPsxGLTC5pfTw2B8A7cPA1Sdxi2glWBbUqFB395YW1WahtEREnBdTmwbgsYCHL1T3pWbRLRT8XO3-tY7sWGXLkk7yt3Z9ANXbTZhcZe0EabR486f6wkBaASrADDt2jqUWRSjheFc3vzUek5RIci-khD0vmcv9MLRMHMFxDV7WaR8VdS612WykCbVRrBe_X5w6jb2pbkB5XldStkd9O_9yOfDO23Zx4t20b7QzqRePdtFAMXCcRkkkYXtSM1_0OB7d1DIaw4858qW9rYHH5wdgE6V-DhQbg-aws6duXR-D25Xh5460IRLU3I3BdeO0IQ-wUIbXqWFFMIiVZ1qRJ3BbPYGqzypqUcYG7TMlf9P2Ct_YmJOhnM8rOBKpWQJUKSDt90yGPdFm8Yi5Ul5R515DP5FK7H-aT8rJo4Kp3dWXv568OpKnXjlgxN3wm6ufOz_o_y3S71KEDOkM_sm5c3AfzxxQlZYGtUlX8mOeAFViFQk161XkPndLkYlBac3eAlSxLdHYhDtYsADGxm8YEaELqaeo0CzKtcgvjXsN8VuYlgj8agCftmZBBsczsiSXUtKpDoZstNM5hk-pGQehD6_PvBODoke4tH6kjO57JgTMFdDcdrmbORDz_5iGm8mok0gVzcoMm_87VEADKx5Rm9kYp66GURrl4BsIpmyDprL2K-QQEUTcKGwA4ol7NZ9oYy3WzDOPMRUZZTHPqHY4pDZ0CL_mxh5ke3_goyeQARmgTSwim5u77LCGS9TH-QLTpaKSBwdAfvNMPmpN94sqNytMngiY8-UgHgDgLQBos12hSsD0N6izUszmdSbhTWeLA7O62dyY1DeIfF7UPktwgR0h3Sbkvtmi6GIfkKSlVb1kFU1jusbcGMykfkI8UaAvnR9pLqq3C9uZDXgqxkm_YvX7HdM48OJKueU-J61zDVyNEJh5YMNx5LnAKRCrTxgPTZYlO6cfBlJdtebqn9nVHxBN9rZva50K-nG34yBy18DYfiEp5uEejqAVnGpB1bWrb_QsZhiATNV57qb9lJUk8fQh_y-geAYI6s2hMYtdozpyR_jgNQbIs5z6Q4dTyd5MVqyInuXGMITCnciwrXtgmjokxihQp4iDTrzaNqFm4PWCGtGxBLhxWjCRBFb_N5I8pkZAkUkNWFA0hRf2ndINER_wEG_KvGZqlI38JwfPa-JM7Dw0H2C9rIQ7JLiWgUXFfhdUcGhAbjPpAjtM5uqRMdDbcnPLxscrU55AaYch93EhhO6J3EbESzi9eDr3qD5r98qw.' , `time` = '1774810166'
  WHERE `session_id` = '7f79so0kph7e6gm8mbfja9b0d7'

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` = 'WHBSSq64BTssIs9nPvcc3PnhgBoTuF5hS1dwMG5hk8ISiOC53LEJwJUiDaaG-QwZMATBuEMn0R0GBx6tnyIecvmPVDGq22rpucgUtfL7HYiPsxGLTC5pfTw2B8A7cPA1Sdxi2glWBbUqFB395YW1WahtEREnBdTmwbgsYCHL1T3pWbRLRT8XO3-tY7sWGXLkk7yt3Z9ANXbTZhcZe0EabR486f6wkBaASrADDt2jqUWRSjheFc3vzUek5RIci-khD0vmcv9MLRMHMFxDV7WaR8VdS612WykCbVRrBe_X5w6jb2pbkB5XldStkd9O_9yOfDO23Zx4t20b7QzqRePdtFAMXCcRkkkYXtSM1_0OB7d1DIaw4858qW9rYHH5wdgE6V-DhQbg-aws6duXR-D25Xh5460IRLU3I3BdeO0IQ-wUIbXqWFFMIiVZ1qRJ3BbPYGqzypqUcYG7TMlf9P2Ct_YmJOhnM8rOBKpWQJUKSDt90yGPdFm8Yi5Ul5R515DP5FK7H-aT8rJo4Kp3dWXv568OpKnXjlgxN3wm6ufOz_o_y3S71KEDOkM_sm5c3AfzxxQlZYGtUlX8mOeAFViFQk161XkPndLkYlBac3eAlSxLdHYhDtYsADGxm8YEaELqaeo0CzKtcgvjXsN8VuYlgj8agCftmZBBsczsiSXUtKpDoZstNM5hk-pGQehD6_PvBODoke4tH6kjO57JgTMFdDcdrmbORDz_5iGm8mok0gVzcoMm_87VEADKx5Rm9kYp66GURrl4BsIpmyDprL2K-QQEUTcKGwA4ol7NZ9oYy3WzDOPMRUZZTHPqHY4pDZ0CL_mxh5ke3_goyeQARmgTSwim5u77LCGS9TH-QLTpaKSBwdAfvNMPmpN94sqNytMngiY8-UgHgDgLQBos12hSsD0N6izUszmdSbhTWeLA7O62dyY1DeIfF7UPktwgR0h3Sbkvtmi6GIfkKSlVb1kFU1jusbcGMykfkI8UaAvnR9pLqq3C9uZDXgqxkm_YvX7HdM48OJKueU-J61zDVyNEJh5YMNx5LnAKRCrTxgPTZYlO6cfBlJdtebqn9nVHxBN9rZva50K-nG34yBy18DYfiEp5uEejqAVnGpB1bWrb_QsZhiATNV57qb9lJUk8fQh_y-geAYI6s2hMYtdozpyR_jgNQbIs5z6Q4dTyd5MVqyInuXGMITCnciwrXtgmjokxihQp4iDTrzaNqFm4PWCGtGxBLhxWjCRBFb_N5I8pkZAkUkNWFA0hRf2ndINER_wEG_KvGZqlI38JwfPa-JM7Dw0H2C9rIQ7JLiWgUXFfhdUcGhAbjPpAjtM5uqRMdDbcnPLxscrU55AaYch93EhhO6J3EbESzi9eDr3qD5r98qw.' , `time` = '1774810166'
2. 1 × INSERT INTO `termesze_session` (`session_id`, `client_id`, `time`)
  VALUES ('7f79so0kph7e6gm8mbfja9b0d7', 0, '1774810166'