12 Queries Logged

1. SELECT `session_id`
  FROM `j25_session`
  WHERE `session_id` = '72ad79fd980706b228d2fc9df9ec0c60'
  LIMIT 0, 1
2. 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
3. SELECT id, rules
  FROM `j25_viewlevels`
4. 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
5. SHOW FULL COLUMNS
  FROM `j25_easyblog_configs`
6. SELECT *
  FROM j25_easyblog_configs
  WHERE `name` = 'config'
7. SHOW FULL COLUMNS
  FROM `j25_easyblog_category`
8. SELECT id
  FROM j25_easyblog_category
  WHERE alias='listings'
9. SELECT id
  FROM j25_easyblog_category
  WHERE alias='listings'
10. SELECT id
  FROM j25_easyblog_category
  WHERE alias='data-bases'
11. SELECT *
  FROM j25_easyblog_category
  WHERE `id` = '13'
12. SELECT COUNT(1)
  FROM `j25_easyblog_category`
  WHERE `alias`='data-bases'
  AND `id`!='13'

10 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 3 × SELECT id
  FROM j25_easyblog_category
2. 1 × SELECT *
  FROM j25_easyblog_category
3. 1 × SELECT COUNT(1)
  FROM `j25_easyblog_category`
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_easyblog_category
2. 1 × SHOW FULL COLUMNS
  FROM `j25_easyblog_configs