Abfragezeit: 1.78 ms Nach letzter Abfrage: 5.81 msAbfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.378 MBZeilen zurückgegeben: 37
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `d8h3u_extensions`
WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1
Abfragezeit: 3.57 ms Nach letzter Abfrage: 3.32 msAbfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.484 MBZeilen zurückgegeben: 84
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROMd8h3u_extensions WHERE enabled = 1 AND type = 'plugin' AND state IN (0,1) AND access IN (1,1,5)
ORDERBY ordering
„EXPLAIN“ unmöglich für Abfrage: UPDATE `d8h3u_extensions`
SET `params` = '{\"mediaversion\":\"37b5335b3fd241b9c20e31dd5aefe686\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
Abfragezeit: 1.28 ms Nach letzter Abfrage: 4.41 msAbfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.544 MBZeilen zurückgegeben: 3
SELECT id, home, template, s.params
FROMd8h3u_template_styles as s
LEFTJOINd8h3u_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
SELECT a.id AS artist_id, a.title AS artist_title, ao.* FROMd8h3u_as_artobjects ao INNERJOINd8h3u_as_artobjects_artists aoa ON ao.id = aoa.as_artobject_id INNERJOINd8h3u_as_artists a ON aoa.as_artist_id = a.id WHERE ao.published = 1 AND ao.id IN (3740,2885,2826,2835,2109,2073,2816,3102,2903,562,2050,3112,2265,2435,2815,3111) ORDERBYFIND_IN_SET(ao.id, '3740,2885,2826,2835,2109,2073,2816,3102,2903,562,2050,3112,2265,2435,2815,3111')
SELECT a.id AS artist_id, a.title AS artist_title, ao.* FROMd8h3u_as_artobjects ao INNERJOINd8h3u_as_artobjects_artists aoa ON ao.id = aoa.as_artobject_id INNERJOINd8h3u_as_artists a ON aoa.as_artist_id = a.id WHERE ao.published = 1 AND ao.id IN (3740,2885,2826,2835,2109,2073,2816,3102,2903,562,2050,3112,2265,2435,2815,3111) ORDERBYFIND_IN_SET(ao.id, '3740,2885,2826,2835,2109,2073,2816,3102,2903,562,2050,3112,2265,2435,2815,3111')
SELECTCOUNT(*) AS cnt FROMd8h3u_as_artobjects ao INNERJOINd8h3u_as_artobjects_artists aoa ON ao.id = aoa.as_artobject_id INNERJOINd8h3u_as_artists a ON aoa.as_artist_id = a.id WHERE ao.published = 1
SELECTCOUNT(*) AS cnt FROMd8h3u_as_artobjects ao INNERJOINd8h3u_as_artobjects_artists aoa ON ao.id = aoa.as_artobject_id INNERJOINd8h3u_as_artists a ON aoa.as_artist_id = a.id WHERE ao.published = 1
Abfragezeit: 10.40 ms Nach letzter Abfrage: 3.07 msAbfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 3.533 MBZeilen zurückgegeben: 0
SELECT `c2`.`language`,`c2`.`id`
FROM `d8h3u_menu` AS `c`
INNERJOIN `d8h3u_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item'
INNERJOIN `d8h3u_associations` AS `a2` ON `a`.`key` = `a2`.`key`
INNERJOIN `d8h3u_menu` AS `c2` ON a2.id = c2.`id`
WHERE c.id = 114
Abfragezeit: 3.13 ms Nach letzter Abfrage: 12.60 msAbfragespeichernutzung: 0.103 MB Speichernutzung vor Abfrage: 3.657 MBZeilen zurückgegeben: 65
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROMd8h3u_modulesAS m
LEFTJOINd8h3u_modules_menuAS mm ON mm.moduleid = m.id
LEFTJOINd8h3u_extensionsAS 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 <= '2025-12-08 13:46:30') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-08 13:46:30') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 114 OR mm.menuid <= 0) AND m.language IN ('de-DE','*')
ORDERBY m.position, m.ordering
29 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
32 × SELECT alias FROMd8h3u_as_artobjects
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `d8h3u_extensions`
2 × SELECT results FROMd8h3u_as_cache
2 × SELECT a.id AS artist_id, a.title AS artist_title, ao.* FROMd8h3u_as_artobjects ao INNERJOINd8h3u_as_artobjects_artists aoa ON ao.id = aoa.as_artobject_id INNERJOINd8h3u_as_artists a ON aoa.as_artist_id = a.id
2 × SELECTCOUNT(*) AS cnt FROMd8h3u_as_artobjects ao INNERJOINd8h3u_as_artobjects_artists aoa ON ao.id = aoa.as_artobject_id INNERJOINd8h3u_as_artists a ON aoa.as_artist_id = a.id
2 × SELECT id,title FROMd8h3u_as_artists
2 × SELECT id,title FROMd8h3u_as_types
2 × SELECT id,title FROMd8h3u_as_genres
2 × SELECT id,title FROMd8h3u_as_formats
2 × SELECT id,title FROMd8h3u_as_colors
2 × SELECT id,title FROMd8h3u_as_materials
2 × SELECT id,title FROMd8h3u_as_techniques
2 × SELECT id,title FROMd8h3u_as_styles
2 × SELECT id,title FROMd8h3u_as_statuss
1 × SELECT `data` FROM `d8h3u_session`
1 × SELECT `session_id` FROM `d8h3u_session`
1 × SELECT id, rules FROM `d8h3u_viewlevels
1 × SELECT b.id FROMd8h3u_usergroupsAS a LEFTJOINd8h3u_usergroupsAS b ON b.lft <= a.lft AND b.rgt >= a.rgt
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROMd8h3u_extensions
1 × SELECT* FROMd8h3u_languages
1 × SELECT `element`,`name`,`client_id`,`extension_id` FROM `d8h3u_extensions`
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 FROMd8h3u_menuAS m LEFTJOINd8h3u_extensionsAS e ON m.component_id = e.extension_id
1 × SELECT id, home, template, s.params FROMd8h3u_template_styles as s LEFTJOINd8h3u_extensions as e ON e.element=s.template AND e.type='template' AND e.client_id=s.client_id
1 × SELECT language,id FROM `d8h3u_menu`
1 × SELECT `c2`.`language`,`c2`.`id` FROM `d8h3u_menu` AS `c` INNERJOIN `d8h3u_associations` AS `a` ON a.id = c.`id` AND a.context='com_menus.item' INNERJOIN `d8h3u_associations` AS `a2` ON `a`.`key` = `a2`.`key` INNERJOIN `d8h3u_menu` AS `c2` ON a2.id = c2.`id`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROMd8h3u_modulesAS m LEFTJOINd8h3u_modules_menuAS mm ON mm.moduleid = m.id LEFTJOINd8h3u_extensionsAS e ON e.element = m.module AND e.client_id = m.client_id