Telefon

Freilassing: +49 (0) 86 54 / 60 11-0

Karlsruhe: +49 (0) 721 / 354 61-0

Erfurt: +49 (0) 361 / 65 75 360-0

E-Mail

Freilassing: E-Mail

Karlsruhe: E-Mail

Erfurt: E-Mail

Zur Verstärkung unseres Teams in Freilassing suchen wir:

**BIM-Ingenieur*in für Tunnel- und Ingenieurtiefbau (m/w/d)**

Unser Ingenieurbüro befasst sich seit über 50 Jahren mit allen Fragestellungen des Hohlraumbaus. Unsere Haupttätigkeiten liegen in der Planung und Überwachung von Tunnelbauwerken und Ingenieurtiefbauten im In- und Ausland. Wesentlicher Bestandteil unserer Philosophie ist das Zusammenwirken von Geologen, Geotechnikern und Ingenieuren im eigenen Haus.

Einsatzort: Freilassing (Bayern, bei Salzburg)

Ihre Aufgaben

Anwendung der BIM-Methode in der Objektplanung und Tragwerksplanung im Tunnelbau und in der Geotechnik in allen Leistungs- und Planungsphasen,
Unterstützung der Konzeption und Koordination der 3D-Modellierung,
Integration der BIM-Methode in eine Termin-, kosten- und qualitätsgerechte Planung komplexer Tunnel- und Ingenieurbauwerke in allen Planungsphasen,
Entwicklung von innovativen Lösungen für die digitale Projektbearbeitung mit BIM.

Ihr Profil

Abgeschlossenes Studium des Bauingenieurwesens oder vergleichbare Qualifikation,
Interesse an 3D-Modellierung (BIM) und Programmierarbeit,
Grundlegende Softwarekenntnisse von AutoCAD und Autodesk Revit, idealerweise bereits erste Erfahrungen mit den Statikprogrammen SOFiSTiK und FIDES und/oder der Ausschreibungssoftware iTwo.
Programmierkenntnisse zur Optimierung bzw. Automatisierung von Arbeitsabläufen im BIM-Umfeld sind von Vorteil (z.B. Python, Dynamo, Power BI, C++)
gute Deutschkenntnisse in Wort und Schrift,
Teamfähigkeit und Kommunikationsfähigkeit,
Bereitschaft sich in neue Themen einzuarbeiten.

Unsere Benefits

Interessantes und anspruchsvolles Tätigkeitsfeld
Work-Life-Balance - flexible Arbeitszeiten, 30 Tage Urlaub sowie Überstundenausgleich und attraktive Arbeitsumgebung, hervorragendes Betriebsklima
Weiterbildungsangebote
Erweiterter Krankenversicherungsschutz
Mobilitätszuschuss - gefördertes Fahrradleasing über JobRad und das Deutschlandticket zu den aktuellen Konditionen

Kontakt

Überzeugt? Wunderbar!

Now it's your turn - bewerben Sie sich noch heute. Wir freuen uns auf Ihre Bewerbung, gerne auch per Email an:
mh.personal@mueller-hereth.com

Müller + Hereth
Ingenieurbüro für Tunnel- und Felsbau GmbH

Laufener Straße 16
D-83395 Freilassing

Tel. + 49 (0) 8654 6011-0
Fax + 49 (0) 8654 6011-33

www.mueller-hereth.com

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentca40b5f22cf3d88f707fb259b2686ed4
  time1747259552
  countdown10
  languagede
====
Request
+
Request

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  0126
- ids(array)
  Menu126
  Content(null)
  Language1
- route(array)
  id328
  hashff94d6b03df374944f480c79882da3e2
  created2024-12-18 11:20:37
  updated2024-12-18 11:22:32
  modelMenu
  foreign_key126
  base/offene-jobs-in-freilassing/
  aliasbim-ingenieur-in-m-w-d
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id312
  lft113
  rght116
  route/offene-jobs-in-freilassing/bim-ingenieur-in-m-w-d
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  plugin(null)
  actionindex
- template/*
====

Sql Log

Sql Logs

default

Total Time: 4 ms
Total Queries: 100 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `mueller_hereth`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/offene-jobs-in-freilassing/bim-ingenieur-in-m-w-d' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `mueller_hereth`.`routes` AS `Route` WHERE `Route`.`lft` <= 113 AND `Route`.`rght` >= 116 ORDER BY `Route`.`lft` asc	5	5	0
SELECT `Menu`.`id`, `Language`.`id` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 126 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `mueller_hereth`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL LIMIT 1	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `mueller_hereth`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 126 AND `Route`.`model` = 'Menu'	1	1	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `mueller_hereth`.`seo` AS `Seo` WHERE `Seo`.`foreign_key` = 126 AND `Seo`.`model` = 'Menu'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 319 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`well` FROM `mueller_hereth`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 126 AND `Teaser`.`model` = 'Menu'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 319 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (126) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `mueller_hereth`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (126)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (626, 627, 628, 629, 630) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `HeaderImagesMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 126 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Language`.`langid` FROM `mueller_hereth`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 126 LIMIT 1	1	1	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`sidebar`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`placeholder_text`, `Content`.`member_group_id`, `Content`.`gallery_mosaic_layout`, `Content`.`gallery_mosaic_image_number`, `Content`.`info_boxes_heading`, `Content`.`info_boxes_title_1`, `Content`.`info_boxes_title_2`, `Content`.`info_boxes_title_3`, `Content`.`info_boxes_title_4`, `Content`.`info_boxes_title_5`, `Content`.`info_boxes_title_6`, `Content`.`info_boxes_text_1`, `Content`.`info_boxes_text_2`, `Content`.`info_boxes_text_3`, `Content`.`info_boxes_text_4`, `Content`.`info_boxes_text_5`, `Content`.`info_boxes_text_6`, `Content`.`info_boxes_external_url_1`, `Content`.`info_boxes_external_url_2`, `Content`.`info_boxes_external_url_3`, `Content`.`info_boxes_external_url_4`, `Content`.`info_boxes_external_url_5`, `Content`.`info_boxes_external_url_6`, `Content`.`info_boxes_external_target_1`, `Content`.`info_boxes_external_target_2`, `Content`.`info_boxes_external_target_3`, `Content`.`info_boxes_external_target_4`, `Content`.`info_boxes_external_target_5`, `Content`.`info_boxes_external_target_6`, `Content`.`info_boxes_menu_id_1`, `Content`.`info_boxes_menu_id_2`, `Content`.`info_boxes_menu_id_3`, `Content`.`info_boxes_menu_id_4`, `Content`.`info_boxes_menu_id_5`, `Content`.`info_boxes_menu_id_6`, `Content`.`info_boxes_button_text_1`, `Content`.`info_boxes_button_text_2`, `Content`.`info_boxes_button_text_3`, `Content`.`info_boxes_button_text_4`, `Content`.`info_boxes_button_text_5`, `Content`.`info_boxes_button_text_6`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (`Content`.`status` = "active") AS `Content__isActive` FROM `mueller_hereth`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (126) ORDER BY `Content`.`position` asc	1	1	1
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `mueller_hereth`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 75 AND `Route`.`model` = 'Content'	1	1	0
SELECT *, Language.id FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `mueller_hereth`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`well` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `mueller_hereth`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `mueller_hereth`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (1)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1, 2, 3, 4, 5) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `mueller_hereth`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (187) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `HeaderImagesMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `mueller_hereth`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'meta-a' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 46 ORDER BY `Menu`.`lft` asc	21	21	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `mueller_hereth`.`languages` AS `Language` LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `mueller_hereth`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `mueller_hereth`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 126 LIMIT 1	1	1	0
SELECT *, Language.id FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `mueller_hereth`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-contact' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`well` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 13 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (13) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `mueller_hereth`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (13)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (61, 62, 63, 64, 65) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `HeaderImagesMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`sidebar`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`placeholder_text`, `Content`.`member_group_id`, `Content`.`gallery_mosaic_layout`, `Content`.`gallery_mosaic_image_number`, `Content`.`info_boxes_heading`, `Content`.`info_boxes_title_1`, `Content`.`info_boxes_title_2`, `Content`.`info_boxes_title_3`, `Content`.`info_boxes_title_4`, `Content`.`info_boxes_title_5`, `Content`.`info_boxes_title_6`, `Content`.`info_boxes_text_1`, `Content`.`info_boxes_text_2`, `Content`.`info_boxes_text_3`, `Content`.`info_boxes_text_4`, `Content`.`info_boxes_text_5`, `Content`.`info_boxes_text_6`, `Content`.`info_boxes_external_url_1`, `Content`.`info_boxes_external_url_2`, `Content`.`info_boxes_external_url_3`, `Content`.`info_boxes_external_url_4`, `Content`.`info_boxes_external_url_5`, `Content`.`info_boxes_external_url_6`, `Content`.`info_boxes_external_target_1`, `Content`.`info_boxes_external_target_2`, `Content`.`info_boxes_external_target_3`, `Content`.`info_boxes_external_target_4`, `Content`.`info_boxes_external_target_5`, `Content`.`info_boxes_external_target_6`, `Content`.`info_boxes_menu_id_1`, `Content`.`info_boxes_menu_id_2`, `Content`.`info_boxes_menu_id_3`, `Content`.`info_boxes_menu_id_4`, `Content`.`info_boxes_menu_id_5`, `Content`.`info_boxes_menu_id_6`, `Content`.`info_boxes_button_text_1`, `Content`.`info_boxes_button_text_2`, `Content`.`info_boxes_button_text_3`, `Content`.`info_boxes_button_text_4`, `Content`.`info_boxes_button_text_5`, `Content`.`info_boxes_button_text_6`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (`Content`.`status` = "active") AS `Content__isActive`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`well` FROM `mueller_hereth`.`contents` AS `Content` LEFT JOIN `mueller_hereth`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `mueller_hereth`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 13 LIMIT 1	1	1	2	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ArticleContentMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `GalleryMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InfoBoxesImg1Media`.`id`, `InfoBoxesImg1Media`.`hash`, `InfoBoxesImg1Media`.`created`, `InfoBoxesImg1Media`.`updated`, `InfoBoxesImg1Media`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InfoBoxesImg1Media`.`id`) AS `InfoBoxesImg1Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `InfoBoxesImg1Media` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `InfoBoxesImg1Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'info_boxes_img_1' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InfoBoxesImg2Media`.`id`, `InfoBoxesImg2Media`.`hash`, `InfoBoxesImg2Media`.`created`, `InfoBoxesImg2Media`.`updated`, `InfoBoxesImg2Media`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InfoBoxesImg2Media`.`id`) AS `InfoBoxesImg2Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `InfoBoxesImg2Media` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `InfoBoxesImg2Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'info_boxes_img_2' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InfoBoxesImg3Media`.`id`, `InfoBoxesImg3Media`.`hash`, `InfoBoxesImg3Media`.`created`, `InfoBoxesImg3Media`.`updated`, `InfoBoxesImg3Media`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InfoBoxesImg3Media`.`id`) AS `InfoBoxesImg3Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `InfoBoxesImg3Media` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `InfoBoxesImg3Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'info_boxes_img_3' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InfoBoxesImg4Media`.`id`, `InfoBoxesImg4Media`.`hash`, `InfoBoxesImg4Media`.`created`, `InfoBoxesImg4Media`.`updated`, `InfoBoxesImg4Media`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InfoBoxesImg4Media`.`id`) AS `InfoBoxesImg4Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `InfoBoxesImg4Media` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `InfoBoxesImg4Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'info_boxes_img_4' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InfoBoxesImg5Media`.`id`, `InfoBoxesImg5Media`.`hash`, `InfoBoxesImg5Media`.`created`, `InfoBoxesImg5Media`.`updated`, `InfoBoxesImg5Media`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InfoBoxesImg5Media`.`id`) AS `InfoBoxesImg5Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `InfoBoxesImg5Media` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `InfoBoxesImg5Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'info_boxes_img_5' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `InfoBoxesImg6Media`.`id`, `InfoBoxesImg6Media`.`hash`, `InfoBoxesImg6Media`.`created`, `InfoBoxesImg6Media`.`updated`, `InfoBoxesImg6Media`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `InfoBoxesImg6Media`.`id`) AS `InfoBoxesImg6Media__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `InfoBoxesImg6Media` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `InfoBoxesImg6Media`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'info_boxes_img_6' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `PlaceholderImageMedia`.`id`, `PlaceholderImageMedia`.`hash`, `PlaceholderImageMedia`.`created`, `PlaceholderImageMedia`.`updated`, `PlaceholderImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) AS `PlaceholderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `PlaceholderImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `PlaceholderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'placeholder_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `TeaserIndex`.`id`, `TeaserIndex`.`hash`, `TeaserIndex`.`created`, `TeaserIndex`.`updated`, `TeaserIndex`.`parent_id`, `TeaserIndex`.`lft`, `TeaserIndex`.`rght`, `TeaserIndex`.`language_id`, `TeaserIndex`.`type`, `TeaserIndex`.`title`, `TeaserIndex`.`previous_url`, `TeaserIndex`.`url`, `TeaserIndex`.`target_blank`, `TeaserIndex`.`label_title`, `TeaserIndex`.`label_url`, `TeaserIndex`.`label_mail`, `TeaserIndex`.`label_tooltipp`, `TeaserIndex`.`label_text`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `mueller_hereth`.`menus` AS `TeaserIndex` JOIN `mueller_hereth`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 5 AND `ContentsMenu`.`menu_id` = `TeaserIndex`.`id`) ORDER BY `ContentsMenu`.`position` ASC	0	0	0
SELECT *, Language.id FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `mueller_hereth`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-links' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`well` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 14 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 14 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 14 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (14) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `mueller_hereth`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (14)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (66, 67, 68, 69, 70) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `HeaderImagesMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 14 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`well` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 14 ORDER BY `Menu`.`lft` ASC	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (15) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `mueller_hereth`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (15)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (71, 72, 73, 74, 75) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `HeaderImagesMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT *, Language.id FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `mueller_hereth`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-links2' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`well` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 17 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 17 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 17 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (17) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `mueller_hereth`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (17)	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (81, 82, 83, 84, 85) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `HeaderImagesMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 17 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`well` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `mueller_hereth`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 17 ORDER BY `Menu`.`lft` ASC	2	2	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 18 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 189 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 18 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 189 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (18, 101) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `mueller_hereth`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` IN (18, 101)	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (86, 87, 88, 89, 90, 501, 502, 503, 504, 505) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `mueller_hereth`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (15) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `HeaderImagesMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (18, 101) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `mueller_hereth`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-partner' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `mueller_hereth`.`menus` AS `Menu` LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 67 AND `Menu`.`rght` < 70 ORDER BY `Menu`.`lft` asc	1	1	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (20) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `mueller_hereth`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'contact-label' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`label_title`, `Menu`.`label_url`, `Menu`.`label_mail`, `Menu`.`label_tooltipp`, `Menu`.`label_text` FROM `mueller_hereth`.`menus` AS `Menu` WHERE `Menu`.`lft` > 47 AND `Menu`.`rght` < 52 ORDER BY `Menu`.`lft` asc	2	2	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `mueller_hereth`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (10, 11) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title` FROM `mueller_hereth`.`header_images` AS `HeaderImage` WHERE `model` = 'Menu' AND `foreign_key` = 126	5	5	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `mueller_hereth`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/offene-jobs-in-freilassing/bim-ingenieur-in-m-w-d/bim-ingenieur-in-m-w-d' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `mueller_hereth`.`routes` AS `Route` WHERE `Route`.`lft` <= 114 AND `Route`.`rght` >= 115 ORDER BY `Route`.`lft` asc	6	6	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`sidebar`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`placeholder_text`, `Content`.`member_group_id`, `Content`.`gallery_mosaic_layout`, `Content`.`gallery_mosaic_image_number`, `Content`.`info_boxes_heading`, `Content`.`info_boxes_title_1`, `Content`.`info_boxes_title_2`, `Content`.`info_boxes_title_3`, `Content`.`info_boxes_title_4`, `Content`.`info_boxes_title_5`, `Content`.`info_boxes_title_6`, `Content`.`info_boxes_text_1`, `Content`.`info_boxes_text_2`, `Content`.`info_boxes_text_3`, `Content`.`info_boxes_text_4`, `Content`.`info_boxes_text_5`, `Content`.`info_boxes_text_6`, `Content`.`info_boxes_external_url_1`, `Content`.`info_boxes_external_url_2`, `Content`.`info_boxes_external_url_3`, `Content`.`info_boxes_external_url_4`, `Content`.`info_boxes_external_url_5`, `Content`.`info_boxes_external_url_6`, `Content`.`info_boxes_external_target_1`, `Content`.`info_boxes_external_target_2`, `Content`.`info_boxes_external_target_3`, `Content`.`info_boxes_external_target_4`, `Content`.`info_boxes_external_target_5`, `Content`.`info_boxes_external_target_6`, `Content`.`info_boxes_menu_id_1`, `Content`.`info_boxes_menu_id_2`, `Content`.`info_boxes_menu_id_3`, `Content`.`info_boxes_menu_id_4`, `Content`.`info_boxes_menu_id_5`, `Content`.`info_boxes_menu_id_6`, `Content`.`info_boxes_button_text_1`, `Content`.`info_boxes_button_text_2`, `Content`.`info_boxes_button_text_3`, `Content`.`info_boxes_button_text_4`, `Content`.`info_boxes_button_text_5`, `Content`.`info_boxes_button_text_6`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, (1=1) AS `Content__isActive`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `mueller_hereth`.`contents` AS `Content` LEFT JOIN `mueller_hereth`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 75 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `mueller_hereth`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `mueller_hereth`.`media` AS `ImageMedia` JOIN `mueller_hereth`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 320 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT *, Language.id FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `mueller_hereth`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `mueller_hereth`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'data-protection' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `mueller_hereth`.`settings` AS `Setting` LEFT JOIN `mueller_hereth`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	19	19	0
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `mueller_hereth`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 14, 15, 16, 17, 18, 34, 35, 36, 37) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `mueller_hereth`.`mount_points` AS `MountPoint` LEFT JOIN `mueller_hereth`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `mueller_hereth`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1	0

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 20.17 MB

Message	Memory use
Component initialization	7.36 MB
Controller action start	10.87 MB
Controller render start	11.09 MB
Component initialization #2	15.02 MB
Controller action start #2	15.20 MB
Controller render start #2	15.36 MB
View render complete	16.41 MB

Timers

Total Request Time: 540 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	156.82
Event: Controller.initialize	86.14
Event: Controller.startup	7.32
Controller action	7.22
Event: Controller.beforeRender	97.11
» Processing toolbar data	21.42
Rendering View	76.93
» Event: View.beforeRender	0.08
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	45.02
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	44.11
» » » Event: Controller.initialize #2	7.33
» » » Event: Controller.startup #2	0.44
» » » Controller action #2	4.73
» » » Event: Controller.beforeRender #2	15.76
» » » » Processing toolbar data #2	15.53
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.06
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	3.43
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.55
» » » » Event: View.afterRender	0.05
» » » » Event: Controller.shutdown	0.04
» » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #2	0.38
» » Event: View.afterRender #2	1.84
» » Event: View.beforeLayout	0.04
» » Rendering APP/View/Layouts/index.php	26.44
» » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	11.84
» » » Rendering APP/View/Elements/header.php	5.42
» » » » Rendering APP/View/Elements/navigation.php	4.59
» » » » » Rendering APP/View/Elements/contactlabel.php	1.17
» » » Rendering APP/View/Elements/footer.php	0.73
» » » Rendering APP/Plugin/FrontendMembers/View/Elements/login.php	4.70
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id126
  hash32c824182ba8241c01839babf7433be6
  created2024-12-18 11:20:37
  updated2024-12-18 11:22:32
  parent_id116
  lft28
  rght29
  language_id1
  typecontent
  titleBIM-Ingenieur*in (m/w/d)
  previous_url(null)
  url(null)
  target_blank(false)
  label_title(null)
  label_url(null)
  label_mail(null)
  label_tooltipp(null)
  label_text<p>Zur Verstärkung unseres Teams in Freilassing suchen wir:</p> <p> </p> <p><strong>Planungsingenieur / Geotechniker / Geologe</strong></p> <p>Wir arbeiten an der Umsetzung von Zukunftsprojekten ...</p> <p>… und schaffen nachhaltige Infrastruktur von morgen. Seit über 50 Jahren spielen Ingenieurinnen und Ingenieure von Müller+Hereth eine entscheidende Rolle, wenn es um die erfolgreiche Realisierung von Hohlraumbauten für Verkehrsinfrastruktur, Energieversorgung, und Hochwasserschutz geht. Mit unseren rund 55 Mitarbeitenden sind wir seit über 50 Jahren vorwiegend im deutschsprachigen Raum, in Europa, aber auch im ferneren Ausland tätig. Insgesamt haben wir mehr als 1700 Projekten erfolgreich abgewickelt.</p> <p>Innerhalb unserer Kernkompetenz, der Planung, Beratung und Überwachung von Tunnelbauwerken arbeiten wir sehr erfolgreich an interessanten Projekten. So durften wir in den letzten Jahren unter anderem einen wesentlichen Teil der Brenner Zulaufstrecke planen und Überwachen, bei der Realisierung von Stuttgart 21 an mehreren Losen mitwirken, an der Planung und Überwachung an allen Tunneln im Garmisch-Partenkirchener Talkessel planen und überwachen. Seit beinahe 10 Jahren planen wir in Arbeitsgemeinschaft mit mehreren Partnerbüros an der Umsetzung des zukünftig längsten Eisenbahntunnels der Welt, dem Brenner Basistunnel.</p> <p>Neben dem eigentlichen Tunnelbau beschäftigen uns viele Aufgaben des Spezialtiefbaues, Beratung von Bauherrn und ausführenden Firmen in technischer und vertraglicher Hinsicht und natürlich alle geologischen und geotechnischen Fragestellungen.</p> <p> </p> <p>Sie passen in unser Team, wenn Sie Spaß an anspruchsvollen und Abwechslungsreichen Tätigkeiten haben, eine lösungsorientierte Denkweise haben und mit Ihrer Hands-On-Mentalität Dynamik schaffen. Sie zeichnet eine strukturierte Arbeitsweise aus und Sie behalten jederzeit die wesentlichen Meilensteine und Deadlines im Auge.</p> <p><strong>Einsatzort: </strong>Freilassing (Bayern, bei Salzburg)</p> <p> </p> <p><strong>Ihre Aufgaben</strong></p> <p>Mitarbeit, später Leitung von interdisziplinären Projekten im Bereich zyklischer- und kontinuierlicher Tunnelbau. (Objektplanung, Tragwerksplanung, Geologie, Geotechnik, Beratung, Vertragserstellung etc.)</p> <p> </p> <p><strong>Ihr Profil</strong></p> <p>Abgeschlossenes Studium im Bereich Ingenieurwesen, oder</p> <p>Geologie, oder</p> <p>Geotechnik oder Bodenmechanik oder in einer vergleichbaren Fachrichtung</p> <p>Erfahrungen im jeweiligen Fachgebiet erwünscht, aber keine Voraussetzung</p> <p>Verhandlungssichere Deutschkenntnisse</p> <p>Teamfähigkeit, Kommunikationsfähigkeit und Belastbarkeit,</p> <p>Bereitschaft sich in neue Themen einzuarbeiten.</p> <p> </p> <p><strong>Unsere Benefits</strong></p> <p>Interessantes und anspruchsvolles Tätigkeitsfeld</p> <p>Work-Life-Balance - flexible Arbeitszeiten, 30 Tage Urlaub sowie Überstundenausgleich und attraktive Arbeitsumgebung, hervorragendes Betriebsklima</p> <p>Weiterbildungsangebote</p> <p>Erweiterter Krankenversicherungsschutz</p> <p>Mobilitätszuschuss - gefördertes Fahrradleasing über JobRad und das Deutschlandticket zu den aktuellen Konditionen</p> <p>Weitere Benefits - unbefristete Festanstellung, Kaffee Flat, Sommer- und Weihnachtsfeiern</p> <p> </p> <p><strong>Kontakt</strong></p> <p>Überzeugt? Wunderbar!</p> <p>Now it's your turn - bewerben Sie sich noch heute. Wir freuen uns auf Ihre Bewerbung, gerne auch per Email an:<br /> mh.personal@mueller-hereth.com</p> <p> </p> <p><strong>Müller + Hereth</strong><br /> <strong>Ingenieurbüro für Tunnel- und Felsbau GmbH</strong></p> <p>Laufener Straße 16<br /> D-83395 Freilassing</p> <p>Tel. + 49 (0) 8654 6011-0<br /> Fax + 49 (0) 8654 6011-33</p> <p>www.mueller-hereth.com</p>
  Seo(array)
  id319
  hashf9cb0d7aba4c3568ecc8cbae0ef9f775
  created2024-12-18 11:20:37
  updated2024-12-18 11:22:32
  modelMenu
  foreign_key126
  title
  description
  internal_keywords
  author
  tw_creator
  fb_author
  robots3
  ImageMedia(empty)
  Content(array)
  0(array)
  id75
  hashafd386907a9bac2c379283eaf43ded77
  created2024-12-18 11:25:47
  updated2024-12-18 11:31:20
  menu_id126
  position1
  typearticle
  statusactive
  titleBIM-Ingenieur*in (m/w/d)
  layoutcol12
  sidebar(false)
  language_id1
  article_content<p>Zur Verstärkung unseres Teams in Freilassing suchen wir:</p> <p> </p> <div> <div> <div> <div> <div> <h2 style="text-align:center"><strong>BIM-Ingenieur*in für Tunnel- und Ingenieurtiefbau (m/w/d)</strong></h2> <p> </p> <p>Unser Ingenieurbüro befasst sich seit über 50 Jahren mit allen Fragestellungen des Hohlraumbaus. Unsere Haupttätigkeiten liegen in der Planung und Überwachung von Tunnelbauwerken und Ingenieurtiefbauten im In- und Ausland. Wesentlicher Bestandteil unserer Philosophie ist das Zusammenwirken von Geologen, Geotechnikern und Ingenieuren im eigenen Haus.</p> <p> </p> <p><strong>Einsatzort: </strong>Freilassing (Bayern, bei Salzburg)</p> </div> </div> </div> </div> </div> <div> <h4> </h4> <h4><strong>Ihre Aufgaben</strong></h4> <ul> <li>Anwendung der BIM-Methode in der Objektplanung und Tragwerksplanung im Tunnelbau und in der Geotechnik in allen Leistungs- und Planungsphasen,</li> <li>Unterstützung der Konzeption und Koordination der 3D-Modellierung,</li> <li>Integration der BIM-Methode in eine Termin-, kosten- und qualitätsgerechte Planung komplexer Tunnel- und Ingenieurbauwerke in allen Planungsphasen,</li> <li>Entwicklung von innovativen Lösungen für die digitale Projektbearbeitung mit BIM.</li> </ul> <h4> </h4> <h4><strong>Ihr Profil</strong></h4> <div> <ul> <li>Abgeschlossenes Studium des Bauingenieurwesens oder vergleichbare Qualifikation,</li> <li>Interesse an 3D-Modellierung (BIM) und Programmierarbeit,</li> <li>Grundlegende Softwarekenntnisse von AutoCAD und Autodesk Revit, idealerweise bereits erste Erfahrungen mit den Statikprogrammen SOFiSTiK und FIDES und/oder der Ausschreibungssoftware iTwo.</li> <li>Programmierkenntnisse zur Optimierung bzw. Automatisierung von Arbeitsabläufen im BIM-Umfeld sind von Vorteil (z.B. Python, Dynamo, Power BI, C++)</li> <li>gute Deutschkenntnisse in Wort und Schrift,</li> <li>Teamfähigkeit und Kommunikationsfähigkeit,</li> <li>Bereitschaft sich in neue Themen einzuarbeiten.</li> </ul> </div> <h4> </h4> <h4><strong>Unsere Benefits</strong></h4> <div> <ul> <li>Interessantes und anspruchsvolles Tätigkeitsfeld</li> <li>Work-Life-Balance - flexible Arbeitszeiten, 30 Tage Urlaub sowie Überstundenausgleich und attraktive Arbeitsumgebung, hervorragendes Betriebsklima</li> <li>Weiterbildungsangebote</li> <li>Erweiterter Krankenversicherungsschutz</li> <li>Mobilitätszuschuss - gefördertes Fahrradleasing über JobRad und das Deutschlandticket zu den aktuellen Konditionen</li> </ul> <h4> </h4> <h4><strong>Kontakt</strong></h4> <div> <div> <p>Überzeugt? Wunderbar!</p> <p>Now it's your turn - bewerben Sie sich noch heute. Wir freuen uns auf Ihre Bewerbung, gerne auch per Email an:<br /> mh.personal@mueller-hereth.com</p> <p> </p> <p><strong>Müller + Hereth</strong><br /> <strong>Ingenieurbüro für Tunnel- und Felsbau GmbH</strong></p> <p>Laufener Straße 16<br /> D-83395 Freilassing</p> <p>Tel. + 49 (0) 8654 6011-0<br /> Fax + 49 (0) 8654 6011-33</p> <p><a href="http://www.mueller-hereth.com/" target="_blank">www.mueller-hereth.com</a></p> </div> </div> </div> </div> <p> </p>
  contact_content(null)
  contact_email(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  placeholder_text(null)
  member_group_id0
  gallery_mosaic_layoutmain_left
  gallery_mosaic_image_numberone_four-5
  info_boxes_heading(null)
  info_boxes_title_1(null)
  info_boxes_title_2(null)
  info_boxes_title_3(null)
  info_boxes_title_4(null)
  info_boxes_title_5(null)
  info_boxes_title_6(null)
  info_boxes_text_1(null)
  info_boxes_text_2(null)
  info_boxes_text_3(null)
  info_boxes_text_4(null)
  info_boxes_text_5(null)
  info_boxes_text_6(null)
  info_boxes_external_url_1(null)
  info_boxes_external_url_2(null)
  info_boxes_external_url_3(null)
  info_boxes_external_url_4(null)
  info_boxes_external_url_5(null)
  info_boxes_external_url_6(null)
  info_boxes_external_target_1(null)
  info_boxes_external_target_2(null)
  info_boxes_external_target_3(null)
  info_boxes_external_target_4(null)
  info_boxes_external_target_5(null)
  info_boxes_external_target_6(null)
  info_boxes_menu_id_1(null)
  info_boxes_menu_id_2(null)
  info_boxes_menu_id_3(null)
  info_boxes_menu_id_4(null)
  info_boxes_menu_id_5(null)
  info_boxes_menu_id_6(null)
  info_boxes_button_text_1(null)
  info_boxes_button_text_2(null)
  info_boxes_button_text_3(null)
  info_boxes_button_text_4(null)
  info_boxes_button_text_5(null)
  info_boxes_button_text_6(null)
  gmap
  published1
  isActive1
  Route(array)
  id329
  hash93b970418a4761caa2e94e962a34b0ec
  created2024-12-18 11:25:47
  updated2024-12-18 11:31:20
  modelContent
  foreign_key75
  base/offene-jobs-in-freilassing/bim-ingenieur-in-m-w-d/
  aliasbim-ingenieur-in-m-w-d
  controllerFrontendContents.FrontendContents
  actionarticle
  parent_id328
  lft114
  rght115
  route/offene-jobs-in-freilassing/bim-ingenieur-in-m-w-d/bim-ingenieur-in-m-w-d
- $request->data(empty)
- $this->validationErrors(array)
  Route(empty)
  MountPoint(empty)
  Redirect(empty)
  Language(empty)
  Menu(empty)
  MemberGroup(empty)
  Member(empty)
  Parent(empty)
  HeaderImagesMedia(empty)
  MediaEntity(empty)
  Seo(empty)
  ImageMedia(empty)
  Teaser(empty)
  HeaderImage(empty)
  Content(empty)
  ArticleContentMedia(empty)
  GalleryMedia(empty)
  InfoBoxesImg1Media(empty)
  InfoBoxesImg2Media(empty)
  InfoBoxesImg3Media(empty)
  InfoBoxesImg4Media(empty)
  InfoBoxesImg5Media(empty)
  InfoBoxesImg6Media(empty)
  PlaceholderImageMedia(empty)
  TeaserIndex(empty)
  FileUpload(empty)
  LogoUpload(empty)
  FlagUpload(empty)
  ContentsMenu(empty)
- Loaded Helpers(array)
  0Html
  1Tree
  2Upload
  3Media
  4Route
  5Bs3Html
  6Form
  7SocialMedia
  8Embed
  9Layout
  10CookieBar
  11Maps
  12Number
  13SimpleGraph
  14DebugTimer
  15Toolbar
  16Session
  17Js
  18HtmlToolbar
====

Environment

App Constants

Constant	Value
MH
MH_IP
BACKEND_APP_DIR	contrance
UPLOADS_APP	/var/www/vhosts/mueller-hereth.com/httpdocs/contrance/
UPLOAD_TMP_DIR	tmp/uploads/

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/mueller-hereth.com/httpdocs/
APP_DIR	httpdocs
APPLIBS	/var/www/vhosts/mueller-hereth.com/httpdocs/Lib/
CACHE	/var/www/vhosts/mueller-hereth.com/httpdocs/tmp/cache/
CAKE	/var/www/vhosts/mueller-hereth.com/httpdocs/contrance/Vendor/Cake/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/mueller-hereth.com/httpdocs/contrance/Vendor/Cake/lib
CORE_PATH	/var/www/vhosts/mueller-hereth.com/httpdocs/contrance/Vendor/Cake/lib/
CAKE_VERSION	2.9.0
CSS	/var/www/vhosts/mueller-hereth.com/httpdocs/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.mueller-hereth.com
IMAGES	/var/www/vhosts/mueller-hereth.com/httpdocs/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/mueller-hereth.com/httpdocs/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/mueller-hereth.com/httpdocs/tmp/logs/
ROOT	/var/www/vhosts/mueller-hereth.com
TESTS	/var/www/vhosts/mueller-hereth.com/httpdocs/Test/
TMP	/var/www/vhosts/mueller-hereth.com/httpdocs/tmp/
VENDORS	/var/www/vhosts/mueller-hereth.com/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/mueller-hereth.com/httpdocs/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.5.38
User	u32478927492
Home	/var/www/vhosts/mueller-hereth.com
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	aCTYYA8-vT1tE9wFJOoxhQAAARg
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Passenger Compile Native Support Binary	0
Redirect Redirect Passenger Download Native Support Binary	0
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	aCTYYA8-vT1tE9wFJOoxhQAAARg
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Passenger Compile Native Support Binary	0
Redirect Passenger Download Native Support Binary	0
Redirect Https	on
Redirect Status	200
Unique Id	aCTYYA8-vT1tE9wFJOoxhQAAARg
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Passenger Compile Native Support Binary	0
Passenger Download Native Support Binary	0
Https	on
Proxy-nokeepalive	1
Http Host	www.mueller-hereth.com
Http X Real Ip	18.97.14.89
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http If Modified Since	Thu, 16 Jan 2025 15:35:38 GMT
Http Accept Encoding	br,gzip
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.mueller-hereth.com
Server Addr	62.116.174.136
Server Port	443
Remote Addr	18.97.14.89
Document Root	/var/www/vhosts/mueller-hereth.com/httpdocs
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/mueller-hereth.com/httpdocs
Server Admin	root@localhost
Script Filename	/var/www/vhosts/mueller-hereth.com/httpdocs/webroot/index.php
Remote Port	36346
Redirect Url	/webroot/offene-jobs-in-freilassing/bim-ingenieur-in-m-w-d
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/offene-jobs-in-freilassing/bim-ingenieur-in-m-w-d
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1747245152.7509
Request Time	1747245152

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/5.5/share/pear
- 2-> /var/www/vhosts/mueller-hereth.com/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Behavior(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
  Cache(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
  1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
  2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
  Component(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/AuthComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/contrance/Config/database.php
  5APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  Error(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
  1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
  I18n(array)
  0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
  1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
  Log(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
  1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
  2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
  3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
  4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
  4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
  Network(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
  1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  Routing(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
  1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
  2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
  3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
  4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
  5APP/Lib/Routing/Route/AliasRoute.php
  6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
  Utility(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
  1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
  2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/ListBehavior.php
  11BaseData/Model/Behavior/HabtmBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Contents(array)
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  FrontendContents(array)
  Config(array)
  0FrontendContents/Config/routes.php
  FrontendMembers(array)
  Config(array)
  0FrontendMembers/Config/routes.php
  FrontendMenus(array)
  Controller(array)
  0FrontendMenus/Controller/FrontendMenusController.php
  1FrontendMenus/Controller/FrontendMenusAppController.php
  FrontendUploads(array)
  Config(array)
  0FrontendUploads/Config/routes.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  HeaderImages(array)
  Behavior(array)
  0HeaderImages/Model/Behavior/HeaderImageBehavior.php
  Model(array)
  0HeaderImages/Model/HeaderImage.php
  1HeaderImages/Model/HeaderImagesAppModel.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  Members(array)
  Model(array)
  0Members/Model/MemberGroup.php
  1Members/Model/MembersAppModel.php
  2Members/Model/Member.php
  Menus(array)
  Model(array)
  0Menus/Model/Menu.php
  1Menus/Model/MenusAppModel.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  Pdf(array)
  Config(array)
  0Pdf/Config/bootstrap.php
  1Pdf/Config/routes.php
  Plugin(array)
  0Pdf/Vendor/autoload.php
  1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
  2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
  3Pdf/Vendor/autoloader/Autoloader.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  Uploads(array)
  Config(array)
  0Uploads/Config/bootstrap.php
  Behavior(array)
  0Uploads/Model/Behavior/UploadBehavior.php
  1Uploads/Model/Behavior/TransformationBehavior.php
  Model(array)
  0Uploads/Model/Upload.php
  1Uploads/Model/UploadsAppModel.php
====

BIM-Ingenieur*in für Tunnel- und Ingenieurtiefbau (m/w/d)

Ihre Aufgaben

Ihr Profil

Unsere Benefits

Kontakt

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 4 ms Total Queries: 100 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

**BIM-Ingenieur*in für Tunnel- und Ingenieurtiefbau (m/w/d)**

Total Time: 4 ms
Total Queries: 100 queries