12 Queries Logged

1. DELETE
  FROM `j25_session`
  WHERE `time` < '1738411223'
2. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = '56c55dbd7b86b34e4ef5e9ea475ff440'
  LIMIT 0, 1
3. INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('56c55dbd7b86b34e4ef5e9ea475ff440', 0, '1738413923')
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. SHOW FULL COLUMNS
  FROM `j25_easyblog_configs`
8. SELECT *
  FROM j25_easyblog_configs
  WHERE `name` = 'config'
9. SELECT `id`
  FROM `j25_easyblog_users`
  WHERE `permalink`='fadeout'
10. SHOW FULL COLUMNS
  FROM `j25_users`
11. SELECT *
  FROM `j25_users`
  WHERE `id` = 65
12. 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` = 65

12 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 1 × SELECT `id`
  FROM `j25_easyblog_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 *
  FROM j25_easyblog_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 × SHOW FULL COLUMNS
  FROM `j25_easyblog_configs
3. 1 × INSERT INTO `j25_session` (`session_id`, `client_id`, `time`)
  VALUES ('56c55dbd7b86b34e4ef5e9ea475ff440', 0, '1738413923'
4. 1 × DELETE
  FROM `j25_session`