23 ausgeführte Abfragen

1. SELECT `data`
  FROM `yofqw_session`
  WHERE `session_id` = '2474aed90e87e10931f795c51be6342b'
2. DELETE
  FROM `yofqw_session`
  WHERE `time` < '1779390125'
3. SELECT `session_id`
  FROM `yofqw_session`
  WHERE `session_id` = '2474aed90e87e10931f795c51be6342b'
  LIMIT 0, 1
4. INSERT INTO `yofqw_session` (`session_id`, `client_id`, `time`)
  VALUES ('2474aed90e87e10931f795c51be6342b', 0, '1779391025')
5. SELECT extension_id AS id, element AS "option", params, enabled
  FROM yofqw_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_users'
6. SELECT b.id
  FROM yofqw_usergroups AS a
  LEFT JOIN yofqw_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
7. SELECT id, rules
  FROM `yofqw_viewlevels`
8. SELECT folder AS type, element AS name, params
  FROM yofqw_extensions
  WHERE enabled >= 1
  AND type ='plugin'
  AND state >= 0
  AND access IN (1,1)
  ORDER BY ordering
9. SELECT *
  FROM yofqw_languages
  WHERE published=1
  ORDER BY ordering ASC
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM yofqw_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_languages'
11. 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 yofqw_menu AS m
  LEFT JOIN yofqw_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
12. SELECT extension_id AS id, element AS "option", params, enabled
  FROM yofqw_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_search'
13. SELECT extension_id AS id, element AS "option", params, enabled
  FROM yofqw_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_menus'
14. SELECT id, home, template, s.params
  FROM yofqw_template_styles as s
  LEFT JOIN yofqw_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id
  WHERE s.client_id = 0
  AND e.enabled = 1
15. SELECT a.title, a.description AS text, "" AS created, "2" AS browsernav, a.id AS catid,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM yofqw_categories AS a
  WHERE (a.title LIKE '%callto:%' OR a.description LIKE '%callto:%')
  AND a.published IN (1,2)
  AND a.extension = 'com_content'
  AND a.access IN (1,1)
  AND a.language in ('de-DE','*')
  GROUP BY a.id
  ORDER BY a.title DESC
  LIMIT 0, 50
16. SELECT a.name AS title, '' AS created, a.con_position, a.misc,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Kontakte', c.title) AS section,'2' AS browsernav
  FROM yofqw_contact_details AS a
  INNER JOIN yofqw_categories AS c
  ON c.id = a.catid
  WHERE (a.name LIKE '%callto:%'OR a.misc LIKE '%callto:%'OR a.con_position LIKE '%callto:%'OR a.address LIKE '%callto:%'OR a.suburb LIKE '%callto:%'OR a.state LIKE '%callto:%'OR a.country LIKE '%callto:%'OR a.postcode LIKE '%callto:%'OR a.telephone LIKE '%callto:%'OR a.fax LIKE '%callto:%')
  AND a.published IN (1,2)
  AND c.published=1
  AND a.access IN (1,1)
  AND c.access IN (1,1)
  AND a.language in ('de-DE','*')
  AND c.language in ('de-DE','*')
  GROUP BY a.id, a.con_position, a.misc
  ORDER BY a.name DESC
  LIMIT 0, 50
17. SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav
  FROM yofqw_content AS a
  INNER JOIN yofqw_categories AS c
  ON c.id=a.catid
  WHERE ((a.title LIKE '%callto:%' OR a.introtext LIKE '%callto:%' OR a.fulltext LIKE '%callto:%' OR a.metakey LIKE '%callto:%' OR a.metadesc LIKE '%callto:%'))
  AND a.state=1
  AND c.published = 1
  AND a.access IN (1,1)
  AND c.access IN (1,1)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-21 19:17:05')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-21 19:17:05')
  AND a.language in ('de-DE','*')
  AND c.language in ('de-DE','*')
  GROUP BY a.id, a.title, a.metadesc, a.metakey, a.created, a.introtext, a.fulltext, c.title, a.alias, c.alias, c.id
  ORDER BY a.created DESC
  LIMIT 0, 50
18. SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext,a.fulltext) AS text,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, c.title AS section, '2' AS browsernav
  FROM yofqw_content AS a
  INNER JOIN yofqw_categories AS c
  ON c.id=a.catid
  AND c.access IN (1,1)
  WHERE ((a.title LIKE '%callto:%' OR a.introtext LIKE '%callto:%' OR a.fulltext LIKE '%callto:%' OR a.metakey LIKE '%callto:%' OR a.metadesc LIKE '%callto:%'))
  AND a.state = 2
  AND c.published = 1
  AND a.access IN (1,1)
  AND c.access IN (1,1)
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-05-21 19:17:05')
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-05-21 19:17:05')
  AND a.language in ('de-DE','*')
  AND c.language in ('de-DE','*')
  ORDER BY a.created DESC
  LIMIT 0, 50
19. SELECT a.name AS title, "" AS created, a.link AS text,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Newsfeeds', c.title) AS section,"1" AS browsernav
  FROM yofqw_newsfeeds AS a
  INNER JOIN yofqw_categories as c
  ON c.id = a.catid
  WHERE ((a.name LIKE '%callto:%' OR a.link LIKE '%callto:%'))
  AND a.published IN (1,2)
  AND c.published = 1
  AND c.access IN (1,1)
  AND a.language in ('de-DE','*')
  AND c.language in ('de-DE','*')
  ORDER BY a.name ASC
  LIMIT 0, 50
20. SELECT a.title AS title, a.description AS text, a.created AS created, a.url,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(' / ', 'Suche - Weblinks', c.title) AS section, '1' AS browsernav
  FROM yofqw_weblinks AS a
  INNER JOIN yofqw_categories AS c
  ON c.id = a.catid
  WHERE ((a.url LIKE '%callto:%' OR a.description LIKE '%callto:%' OR a.title LIKE '%callto:%'))
  AND a.state in (1,2)
  AND c.published=1
  AND c.access IN (1,1)
  AND a.language in ('de-DE','*')
  AND c.language in ('de-DE','*')
  ORDER BY a.created DESC
  LIMIT 0, 50
21. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM yofqw_modules AS m
  LEFT JOIN yofqw_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN yofqw_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 <= '2026-05-21 19:17:05')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-05-21 19:17:05')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 0 OR mm.menuid <= 0)
  AND m.language IN ('de-DE','*')
  ORDER BY m.position, m.ordering
22. SELECT extension_id AS id, element AS "option", params, enabled
  FROM yofqw_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
23. UPDATE `yofqw_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1779391025;s:18:\"session.timer.last\";i:1779391025;s:17:\"session.timer.now\";i:1779391025;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1779391025'
  WHERE `session_id` = '2474aed90e87e10931f795c51be6342b'

19 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

1. 5 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM yofqw_extensions
2. 1 × SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created,CONCAT(a.introtext,a.fulltext) AS text,c.title AS section,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, '2' AS browsernav
  FROM yofqw_content AS a
  INNER JOIN yofqw_categories AS c
  ON c.id=a.catid
3. 1 × SELECT a.name AS title, '' AS created, a.con_position, a.misc,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(',', a.name, a.con_position, a.misc) AS text,CONCAT_WS(' / ', 'Kontakte', c.title) AS section,'2' AS browsernav
  FROM yofqw_contact_details AS a
  INNER JOIN yofqw_categories AS c
  ON c.id = a.catid
4. 1 × SELECT a.title AS title, a.metadesc, a.metakey, a.created AS created, CONCAT(a.introtext,a.fulltext) AS text,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, c.title AS section, '2' AS browsernav
  FROM yofqw_content AS a
  INNER JOIN yofqw_categories AS c
  ON c.id=a.catid
  AND c.access IN (1,1)
5. 1 × SELECT a.title AS title, a.description AS text, a.created AS created, a.url,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, CONCAT_WS(' / ', 'Suche - Weblinks', c.title) AS section, '1' AS browsernav
  FROM yofqw_weblinks AS a
  INNER JOIN yofqw_categories AS c
  ON c.id = a.catid
6. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM yofqw_modules AS m
  LEFT JOIN yofqw_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN yofqw_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
7. 1 × SELECT a.title, a.description AS text, "" AS created, "2" AS browsernav, a.id AS catid,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug
  FROM yofqw_categories AS a
8. 1 × SELECT a.name AS title, "" AS created, a.link AS text,
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,CONCAT_WS(' / ', 'Newsfeeds', c.title) AS section,"1" AS browsernav
  FROM yofqw_newsfeeds AS a
  INNER JOIN yofqw_categories as c
  ON c.id = a.catid
9. 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 yofqw_menu AS m
  LEFT JOIN yofqw_extensions AS e
  ON m.component_id = e.extension_id
10. 1 × SELECT b.id
  FROM yofqw_usergroups AS a
  LEFT JOIN yofqw_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
11. 1 × SELECT `session_id`
  FROM `yofqw_session`
12. 1 × SELECT id, rules
  FROM `yofqw_viewlevels
13. 1 × SELECT folder AS type, element AS name, params
  FROM yofqw_extensions
14. 1 × SELECT `data`
  FROM `yofqw_session`
15. 1 × SELECT *
  FROM yofqw_languages
16. 1 × SELECT id, home, template, s.params
  FROM yofqw_template_styles as s
  LEFT JOIN yofqw_extensions as e
  ON e.element=s.template
  AND e.type='template'
  AND e.client_id=s.client_id

Andere Tabellen:

1. 1 × UPDATE `yofqw_session`
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1779391025;s:18:\"session.timer.last\";i:1779391025;s:17:\"session.timer.now\";i:1779391025;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";N;s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}' , `time` = '1779391025'
2. 1 × INSERT INTO `yofqw_session` (`session_id`, `client_id`, `time`)
  VALUES ('2474aed90e87e10931f795c51be6342b', 0, '1779391025'
3. 1 × DELETE
  FROM `yofqw_session`