8 naplózott lekérdezés

1. SELECT `data`
  FROM `termesze_session`
  WHERE `session_id` = 'eldmt53h51aftg3ou4a3pelot5'
2. DELETE
  FROM `termesze_session`
  WHERE `time` < '1770410469'
3. SELECT `session_id`
  FROM `termesze_session`
  WHERE `session_id` = 'eldmt53h51aftg3ou4a3pelot5'
  LIMIT 0, 1
4. INSERT INTO `termesze_session` (`session_id`, `client_id`, `time`)
  VALUES ('eldmt53h51aftg3ou4a3pelot5', 0, '1770411369')
5. 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
6. SELECT id, rules
  FROM `termesze_viewlevels`
7. 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
8. UPDATE `termesze_session`
  SET `data` = 'GeEytKmZqRchHNlrvXQHMWHGlZvFwmUuO8q8y_ljIJpubfDfr4Kuyy840gMrOga377CvGXs4IXpnM3-SI871L-xcEd0lW_14w5iSymrP11eeP_hHN54l4fs1ignozhKxuaxDCFFwY_aF7zFaGlt-f_41ss85ujPGEeiTNcctOq_kFl-xgivbtaKs3sDVUMmzYmcnif9UQ6sHRByHGzMXW4ZqAU-MeRO7ARoFwk4yuzNo9J4pD-GHohgcYl8K3DNpm3bzkO_Q-1dNYPO1xub3BgesK_MgvZFIOkvqYs2TMR7hejkn3aKN9U9qdRnBeUNYvney7hNIppBZsndJBAOdohcP8s5Idy7MQAYUd1mnhFsr2o9Ug7rMqIAUROg9cl76GDJTOU0PFgEm2YTLFrb_KboAWJWzTG-ciIgUrS2KvXzDuij-7lGXRmfbFKsRdcKJ3uTjRNARfCCX7KP3-ccEf5FJtJ8g5usuJeQ9FojLnR6ZcWMCS99C5kgBv9yV6sN9l6ONUHbnxGq-qFbI6Iyjt5vLecI4ebH3U7O_7Cugsxpxye3fADiOuUI-JrbHRnNHNOYjGrcGhQmUTviWK5DqQlnByfNfp1x2SmKjlc1n8xvToLNOo7sK7e-Lzj7wiIBcezhCgFPyDHVp4dfi_K9hnMPYYSLfcOzO7ich2qCpT0eOQ2cnzuF3orlIYi6cipbjF0lzMnmhvuDEmokCNB2M4lGC8Xtbs79Yd4s2ASqBHz2kstYWi9euqIPIzZY2AMkwCjYgZFcO-A_5TibfeoZJaEv6e8kn3DOe2zim4Ikld_ZQ-SmBNEfdpK2JoqzFlKlQcDy0NwWR0fji5XNabb1pTaEKKPlYIyXXWq4XX83NVCr8s-rBcHuU5HNH6WTCZbPn0-EdeY3i8LfhEOBV9SqG8YXe_xGc7h5vGOX_pDOp7JRPbxmpzornDo88aJ4Q_oX_lrx3EVL-T1vGfICoWi-dfFd4HnOGxnu6TdGq0FVSInsJSVg4CgLC5ZcaxUNDLWhf8L2TE4fzW9XJ32tcSW-_rtcf4Cq_Wi_BULacp46JWMgwWF1pZmj0nfbAPksfHe8ECSauEyIQ5bc2AiJquTwButIN6VEeFMNlc4N-VKuFJOFQGbn1thjT-6s-Olqnl2XQjZ7Mx0EeAeBBBYAlmvFtj3-I8jNwtHDegz84MmXn11rAmWzO71Pv7JiZdJP4MGwjBp4p3tXDbi2urxMw1ZpGsabS6fGRz9iqf7v5vJ4hW19HdomzYztuFglunqS_6cF7J-NGafGYNj3B8oAr_Cqd60nG8SE3guiMLAXVqQ1QJ0P2LEIwQ2o6TnmxbDrDmGWLLo2KUnhUmfLh0zxrJoVLFg02Wf8kejGmM0UfUw_h4fw.' , `time` = '1770411369'
  WHERE `session_id` = 'eldmt53h51aftg3ou4a3pelot5'

8 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` = 'GeEytKmZqRchHNlrvXQHMWHGlZvFwmUuO8q8y_ljIJpubfDfr4Kuyy840gMrOga377CvGXs4IXpnM3-SI871L-xcEd0lW_14w5iSymrP11eeP_hHN54l4fs1ignozhKxuaxDCFFwY_aF7zFaGlt-f_41ss85ujPGEeiTNcctOq_kFl-xgivbtaKs3sDVUMmzYmcnif9UQ6sHRByHGzMXW4ZqAU-MeRO7ARoFwk4yuzNo9J4pD-GHohgcYl8K3DNpm3bzkO_Q-1dNYPO1xub3BgesK_MgvZFIOkvqYs2TMR7hejkn3aKN9U9qdRnBeUNYvney7hNIppBZsndJBAOdohcP8s5Idy7MQAYUd1mnhFsr2o9Ug7rMqIAUROg9cl76GDJTOU0PFgEm2YTLFrb_KboAWJWzTG-ciIgUrS2KvXzDuij-7lGXRmfbFKsRdcKJ3uTjRNARfCCX7KP3-ccEf5FJtJ8g5usuJeQ9FojLnR6ZcWMCS99C5kgBv9yV6sN9l6ONUHbnxGq-qFbI6Iyjt5vLecI4ebH3U7O_7Cugsxpxye3fADiOuUI-JrbHRnNHNOYjGrcGhQmUTviWK5DqQlnByfNfp1x2SmKjlc1n8xvToLNOo7sK7e-Lzj7wiIBcezhCgFPyDHVp4dfi_K9hnMPYYSLfcOzO7ich2qCpT0eOQ2cnzuF3orlIYi6cipbjF0lzMnmhvuDEmokCNB2M4lGC8Xtbs79Yd4s2ASqBHz2kstYWi9euqIPIzZY2AMkwCjYgZFcO-A_5TibfeoZJaEv6e8kn3DOe2zim4Ikld_ZQ-SmBNEfdpK2JoqzFlKlQcDy0NwWR0fji5XNabb1pTaEKKPlYIyXXWq4XX83NVCr8s-rBcHuU5HNH6WTCZbPn0-EdeY3i8LfhEOBV9SqG8YXe_xGc7h5vGOX_pDOp7JRPbxmpzornDo88aJ4Q_oX_lrx3EVL-T1vGfICoWi-dfFd4HnOGxnu6TdGq0FVSInsJSVg4CgLC5ZcaxUNDLWhf8L2TE4fzW9XJ32tcSW-_rtcf4Cq_Wi_BULacp46JWMgwWF1pZmj0nfbAPksfHe8ECSauEyIQ5bc2AiJquTwButIN6VEeFMNlc4N-VKuFJOFQGbn1thjT-6s-Olqnl2XQjZ7Mx0EeAeBBBYAlmvFtj3-I8jNwtHDegz84MmXn11rAmWzO71Pv7JiZdJP4MGwjBp4p3tXDbi2urxMw1ZpGsabS6fGRz9iqf7v5vJ4hW19HdomzYztuFglunqS_6cF7J-NGafGYNj3B8oAr_Cqd60nG8SE3guiMLAXVqQ1QJ0P2LEIwQ2o6TnmxbDrDmGWLLo2KUnhUmfLh0zxrJoVLFg02Wf8kejGmM0UfUw_h4fw.' , `time` = '1770411369'
2. 1 × INSERT INTO `termesze_session` (`session_id`, `client_id`, `time`)
  VALUES ('eldmt53h51aftg3ou4a3pelot5', 0, '1770411369'
3. 1 × DELETE
  FROM `termesze_session`