Datenbankabfragen
20 ausgeführte Abfragen
SELECT `data` 
  FROM `f8h27_session` 
  WHERE `session_id` = '8d98ca245df6af97d007c8a47d399c24'
DELETE 
  FROM `f8h27_session` 
  WHERE `time` < '1378576371'
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM f8h27_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_languages'
SELECT b.id 
  FROM f8h27_user_usergroup_map AS map 
  LEFT JOIN f8h27_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN f8h27_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt 
  WHERE map.user_id = 844
SELECT id, rules 
  FROM `f8h27_viewlevels`
SELECT folder AS type, element AS name, params 
  FROM f8h27_extensions 
  WHERE enabled >= 1 
  AND type ='plugin' 
  AND state >= 0 
  AND access IN (1,1,2,3) 
  ORDER BY ordering
SELECT template, s.params 
  FROM f8h27_template_styles as s 
  LEFT JOIN f8h27_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id 
  WHERE s.client_id = 1 
  AND home = 1 
  ORDER BY home
SELECT extension_id AS id, element AS "option", params, enabled 
  FROM f8h27_extensions 
  WHERE `type` = 'component' 
  AND `element` = 'com_cpanel'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM f8h27_modules AS m 
  LEFT JOIN f8h27_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN f8h27_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id 
  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2013-09-07 18:37:51') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-09-07 18:37:51') 
  AND m.access IN (1,1,2,3) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0) 
  ORDER BY m.position, m.ordering
SELECT s.time, s.client_id, u.id, u.name, u.username 
  FROM f8h27_session AS s 
  LEFT JOIN f8h27_users AS u 
  ON s.userid = u.id 
  WHERE s.guest = 0 
  LIMIT 0, 5
SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name 
  FROM f8h27_content AS a 
  LEFT JOIN `f8h27_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN f8h27_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN f8h27_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN f8h27_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN f8h27_users AS ua 
  ON ua.id = a.created_by 
  ORDER BY a.hits DESC
SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name 
  FROM f8h27_content AS a 
  LEFT JOIN `f8h27_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN f8h27_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN f8h27_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN f8h27_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN f8h27_users AS ua 
  ON ua.id = a.created_by 
  ORDER BY a.hits DESC 
  LIMIT 0, 5
SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name 
  FROM f8h27_content AS a 
  LEFT JOIN `f8h27_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN f8h27_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN f8h27_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN f8h27_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN f8h27_users AS ua 
  ON ua.id = a.created_by 
  ORDER BY created DESC
SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name 
  FROM f8h27_content AS a 
  LEFT JOIN `f8h27_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN f8h27_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN f8h27_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN f8h27_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN f8h27_users AS ua 
  ON ua.id = a.created_by 
  ORDER BY created DESC 
  LIMIT 0, 5
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native 
  FROM f8h27_menu_types AS a 
  LEFT JOIN f8h27_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0 
  LEFT JOIN f8h27_languages AS l 
  ON l.lang_code = language 
  WHERE (b.client_id = 0 OR b.client_id IS NULL) 
  GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM f8h27_menu AS m 
  LEFT JOIN f8h27_extensions AS e 
  ON m.component_id = e.extension_id 
  WHERE m.client_id = 1 
  AND e.enabled = 1 
  AND m.id > 1 
  ORDER BY m.lft
SELECT COUNT(*) 
  FROM f8h27_messages 
  WHERE state = 0 
  AND user_id_to = 844
SELECT COUNT(session_id) 
  FROM f8h27_session 
  WHERE guest = 0 
  AND client_id = 1
SELECT COUNT(session_id) 
  FROM f8h27_session 
  WHERE guest = 0 
  AND client_id = 0
UPDATE `f8h27_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1378579059;s:18:\"session.timer.last\";i:1378579070;s:17:\"session.timer.now\";i:1378579071;s:24:\"session.client.forwarded\";s:12:\"79.237.65.51\";s:22:\"session.client.browser\";s:64:\"Opera/9.80 (Windows NT 6.1; WOW64) Presto/2.12.388 Version/12.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"844\";s:4:\"name\";s:13:\"Jonas Reinsch\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:18:\"admin@nicething.de\";s:8:\"password\";s:65:\"ed4b39c4888258360cc4f10a89e232f1:eXIZ2PMPGTZX9fCAvS2KxkrZNnS72uoM\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-09-09 22:48:20\";s:13:\"lastvisitDate\";s:19:\"2013-09-06 22:46:45\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f1651c2ce3b5ec1b5965da3f781b4dc4\";}' , `time` = '1378579071' 
  WHERE `session_id` = '8d98ca245df6af97d007c8a47d399c24'
16 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name 
  FROM f8h27_content AS a 
  LEFT JOIN `f8h27_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN f8h27_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN f8h27_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN f8h27_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN f8h27_users AS ua 
  ON ua.id = a.created_by
2 × SELECT a.id, a.title, a.checked_out, a.checked_out_time, a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name 
  FROM f8h27_content AS a 
  LEFT JOIN `f8h27_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN f8h27_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN f8h27_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN f8h27_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN f8h27_users AS ua 
  ON ua.id = a.created_by
2 × SELECT COUNT(session_id) 
  FROM f8h27_session
2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM f8h27_extensions
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native 
  FROM f8h27_menu_types AS a 
  LEFT JOIN f8h27_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0 
  LEFT JOIN f8h27_languages AS l 
  ON l.lang_code = language
1 × SELECT COUNT(*) 
  FROM f8h27_messages
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM f8h27_menu AS m 
  LEFT JOIN f8h27_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM f8h27_modules AS m 
  LEFT JOIN f8h27_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN f8h27_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT id, rules 
  FROM `f8h27_viewlevels
1 × SELECT b.id 
  FROM f8h27_user_usergroup_map AS map 
  LEFT JOIN f8h27_usergroups AS a 
  ON a.id = map.group_id 
  LEFT JOIN f8h27_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt
1 × SELECT folder AS type, element AS name, params 
  FROM f8h27_extensions
1 × SELECT template, s.params 
  FROM f8h27_template_styles as s 
  LEFT JOIN f8h27_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id
1 × SELECT `data` 
  FROM `f8h27_session`
1 × SELECT s.time, s.client_id, u.id, u.name, u.username 
  FROM f8h27_session AS s 
  LEFT JOIN f8h27_users AS u 
  ON s.userid = u.id
Andere Tabellen:
1 × UPDATE `f8h27_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:4;s:19:\"session.timer.start\";i:1378579059;s:18:\"session.timer.last\";i:1378579070;s:17:\"session.timer.now\";i:1378579071;s:24:\"session.client.forwarded\";s:12:\"79.237.65.51\";s:22:\"session.client.browser\";s:64:\"Opera/9.80 (Windows NT 6.1; WOW64) Presto/2.12.388 Version/12.16\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:3:\"844\";s:4:\"name\";s:13:\"Jonas Reinsch\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:18:\"admin@nicething.de\";s:8:\"password\";s:65:\"ed4b39c4888258360cc4f10a89e232f1:eXIZ2PMPGTZX9fCAvS2KxkrZNnS72uoM\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-09-09 22:48:20\";s:13:\"lastvisitDate\";s:19:\"2013-09-06 22:46:45\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f1651c2ce3b5ec1b5965da3f781b4dc4\";}' , `time` = '1378579071'
1 × DELETE 
  FROM `f8h27_session`