11 Queries Logged

1. DELETE
  FROM `j25_session`
  WHERE `time` < '1747349637'
2. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = 'a75ad49b8c14202576ad191c019a07af'
  LIMIT 0, 1
3. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('a75ad49b8c14202576ad191c019a07af', 0, '1747352337')
4. SELECT b.id
  FROM j25_usergroups AS a
  LEFT JOIN j25_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
5. SELECT id, rules
  FROM `j25_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 j25_menu AS m
  LEFT JOIN j25_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. SELECT `params`
  FROM `j25_discuss_configs`
  WHERE `name`='config'
8. SELECT `id`
  FROm `j25_discuss_users`
  WHERE `alias` = 'smroy'
9. SHOW FULL COLUMNS
  FROM `j25_users`
10. SELECT *
  FROM `j25_users`
  WHERE `id` = 1453
11. SELECT `g`.`id`,`g`.`title`
  FROM `j25_usergroups` AS g
  INNER JOIN `j25_user_usergroup_map` AS m
  ON m.group_id = g.id
  WHERE `m`.`user_id` = 1453

11 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 1 × SELECT `id`
  FROm `j25_discuss_users`
2. 1 × SELECT *
  FROM `j25_users`
3. 1 × SELECT `g`.`id`,`g`.`title`
  FROM `j25_usergroups` AS g
  INNER JOIN `j25_user_usergroup_map` AS m
  ON m.group_id = g.id
4. 1 × SELECT `params`
  FROM `j25_discuss_configs`
5. 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 j25_menu AS m
  LEFT JOIN j25_extensions AS e
  ON m.component_id = e.extension_id
6. 1 × SELECT b.id
  FROM j25_usergroups AS a
  LEFT JOIN j25_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
7. 1 × SELECT id, rules
  FROM `j25_viewlevels
8. 1 × SELECT `session_id`
  FROM `j25_session`

OTHER Tables:

1. 1 × SHOW FULL COLUMNS
  FROM `j25_users
2. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('a75ad49b8c14202576ad191c019a07af', 0, '1747352337'
3. 1 × DELETE
  FROM `j25_session`