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

Menü
  • Unternehmen
  • Leistungen
    • Geologie
    • Bauüberwachung
    • Planung
    • Bauvorlageberechtigter
  • Referenzen
  • Kontakt
  • Jobs
    • Offene Jobs in Karlsruhe
      • Bauingenieure, Bautechniker, Geologen, BÜ Mitarbeiter
    • Offene Jobs in Freilassing
      • Projektingenieur*in / Geologe/in (m/w/d)
      • BIM-Ingenieur*in (m/w/d)
      • Bauüberwacher*in (m/w/d)
      • Bauzeichner*in und staatl. geprüfte/r Techniker*in (m/w/d)
      • Werkstudent*in / Praktikant*in (m/w/d)
    • Offene Jobs in Erfurt
      • Projektingenieur/ Projektleiter (m/w/d)
      • Bauzeichner (m/w/d) und staatlich geprüfte Bautechniker (m/w/d)
    • Datenverarbeitung

Impressum

Prof. D. L. Müller + Dipl. – Ing. A. Hereth
Ingenieurbüro für Tunnel- und Felsbau GmbH

Laufener Straße 16

D-83395 Freilassing

Deutschland

 
Kontakt

Telefon: +49 (0) 8654 6011 -0

Fax: +49 (0) 8654 6011-33

E-Mail: office.freilassing@mueller-hereth.com

Internet: www.mueller-hereth.com


Geschäftsführung:  Dipl.-Ing. Sebastian Schwaiger, Dipl.-Ing. Martin Wagner

Registergericht: Amtsgericht Traunstein
Registernummer: HRB 3009
UStIDNr.: DE132362101
Angaben nach §6 TDG: HOAI Honorarordnung für Architekten und Ingenieure, IngG Ingenieurgesetz, VgV Vergabeverordnung 

 

Haftung für Inhalte

Die Inhalte unserer Seiten wurden mit größter Sorgfalt erstellt. Für die Richtigkeit, Vollständigkeit und Aktualität der Inhalte können wir jedoch keine Gewähr übernehmen. Als Diensteanbieter sind wir gemäß § 7 Abs.1 TMG für eigene Inhalte auf diesen Seiten nach den allgemeinen Gesetzen verantwortlich. Nach §§ 8 bis 10 TMG sind wir als Diensteanbieter jedoch nicht verpflichtet, übermittelte oder gespeicherte fremde Informationen zu überwachen oder nach Umständen zu forschen, die auf eine rechtswidrige Tätigkeit hinweisen. Verpflichtungen zur Entfernung oder Sperrung der Nutzung von Informationen nach den allgemeinen Gesetzen bleiben hiervon unberührt. Eine diesbezügliche Haftung ist jedoch erst ab dem Zeitpunkt der Kenntnis einer konkreten Rechtsverletzung möglich. Bei Bekanntwerden von entsprechenden Rechtsverletzungen werden wir diese Inhalte umgehend entfernen.

 

Haftung für Links

Unser Angebot enthält Links zu externen Webseiten Dritter, auf deren Inhalte wir keinen Einfluss haben. Deshalb können wir für diese fremden Inhalte auch keine Gewähr übernehmen. Für die Inhalte der verlinkten Seiten ist stets der jeweilige Anbieter oder Betreiber der Seiten verantwortlich. Die verlinkten Seiten wurden zum Zeitpunkt der Verlinkung auf mögliche Rechtsverstöße überprüft. Rechtswidrige Inhalte waren zum Zeitpunkt der Verlinkung nicht erkennbar. Eine permanente inhaltliche Kontrolle der verlinkten Seiten ist jedoch ohne konkrete Anhaltspunkte einer Rechtsverletzung nicht zumutbar. Bei Bekanntwerden von Rechtsverletzungen werden wir derartige Links umgehend entfernen.

 

 

Urheberrecht

Die durch die Seitenbetreiber erstellten Inhalte und Werke auf diesen Seiten unterliegen dem deutschen Urheberrecht. Die Vervielfältigung, Bearbeitung, Verbreitung und jede Art der Verwertung außerhalb der Grenzen des Urheberrechtes bedürfen der schriftlichen Zustimmung des jeweiligen Autors bzw. Erstellers. Downloads und Kopien dieser Seite sind nur für den privaten, nicht kommerziellen Gebrauch gestattet. Soweit die Inhalte auf dieser Seite nicht vom Betreiber erstellt wurden, werden die Urheberrechte Dritter beachtet. Insbesondere werden Inhalte Dritter als solche gekennzeichnet. Sollten Sie trotzdem auf eine Urheberrechtsverletzung aufmerksam werden, bitten wir um einen entsprechenden Hinweis. Bei Bekanntwerden von Rechtsverletzungen werden wir derartige Inhalte umgehend entfernen.

 

Programmierung, Design und Realisierung

makrohaus AG, crossmedia
Getreidegasse 9

83435 Bad Reichenhall
Tel: +49(0)865176666-0 Fax: -40
info@makrohaus.de
www.makrohaus.de

Kontaktadresse

Prof. Dr. L. Müller + Dipl. – Ing. A. Hereth
Ingenieurbüro für Tunnel- und Felsbau GmbH

Laufener Straße 16

83395 Freilassing

Tel.: +49 (0) 8654 6011 -0

office.freilassing@mueller-hereth.com

Links

Kontakt interner Bereich

Informationen

Impressum Datenschutz

Login: Interner Bereich

  • CakePHP
  • History
    +

    Request History

    4 previous requests available
    • Restore to current request
    • tunnel-agnesburg
    • sitemap_index.xml
    • kontaktadresse
    • foerderstollen-diabaswerk-saalfelden
    ====
  • Session
    +

    Session

    • Config(array)
      • userAgentca40b5f22cf3d88f707fb259b2686ed4
      • time1750452955
      • countdown10
      • languagede
    ====
  • Request
    +

    Request

    Cake Params

    • pluginFrontendMenus
    • controllerFrontendMenus
    • actioncontent
    • named(empty)
    • pass(array)
      • 018
    • ids(array)
      • Menu18
      • Content(null)
      • Language1
    • route(array)
      • id19
      • hasha226c5869a64d9908d541320fff27269
      • created2019-05-13 13:36:21
      • updated2019-12-04 11:35:37
      • modelMenu
      • foreign_key18
      • base/
      • aliasimpressum
      • controllerFrontendMenus.FrontendMenus
      • actioncontent
      • parent_id18
      • lft158
      • rght161
      • route/impressum
    • 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: 98 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`))) = '/impressum' LIMIT 1 1 1 0
    SELECT `Route`.`model`, `Route`.`foreign_key` FROM `mueller_hereth`.`routes` AS `Route` WHERE `Route`.`lft` <= 158 AND `Route`.`rght` >= 161 ORDER BY `Route`.`lft` asc 4 4 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` = 18 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` = 18 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` = 18 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` = 18 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` = 18 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` = 18 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` = (18) 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` = (18) 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 (86, 87, 88, 89, 90) 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` = 18 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` = 18 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` = (18) 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` = 37 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` = 18 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` = 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` = 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 `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` = 18 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`))) = '/impressum/impressum' LIMIT 1 1 1 0
    SELECT `Route`.`model`, `Route`.`foreign_key` FROM `mueller_hereth`.`routes` AS `Route` WHERE `Route`.`lft` <= 159 AND `Route`.`rght` >= 160 ORDER BY `Route`.`lft` asc 5 5 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` = 37 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` = 190 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 19.11 MB

    Message Memory use
    Component initialization 7.36 MB
    Controller action start 10.92 MB
    Controller render start 11.14 MB
    Component initialization #2 15.01 MB
    Controller action start #2 15.20 MB
    Controller render start #2 15.35 MB
    View render complete 16.40 MB

    Timers

    Total Request Time: 558 (ms)

    Message Time in ms Graph
    Core Processing (Derived from $_SERVER["REQUEST_TIME"]) 152.68
    Event: Controller.initialize 95.64
    Event: Controller.startup 8.88
    Controller action 9.49
    Event: Controller.beforeRender 100.76
    » Processing toolbar data 21.37
    Rendering View 87.46
    » Event: View.beforeRender 0.08
    » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php 52.25
    » » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php 51.29
    » » » Event: Controller.initialize #2 8.64
    » » » Event: Controller.startup #2 0.43
    » » » Controller action #2 5.20
    » » » Event: Controller.beforeRender #2 17.36
    » » » » Processing toolbar data #2 16.92
    Rendering View #2 0.00
    » » » » Event: View.beforeRender #2 0.10
    » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php 4.83
    » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php 0.67
    » » » » Event: View.afterRender 0.06
    » » » » Event: Controller.shutdown 0.04
    » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #2 0.40
    » » Event: View.afterRender #2 2.12
    » » Event: View.beforeLayout 0.05
    » » Rendering APP/View/Layouts/index.php 29.17
    » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php 11.98
    » » » Rendering APP/View/Elements/header.php 7.62
    » » » » Rendering APP/View/Elements/navigation.php 4.49
    » » » » » Rendering APP/View/Elements/contactlabel.php 1.07
    » » » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/header-slider.php 1.39
    » » » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/header-slider-captions.php 0.34
    » » » Rendering APP/View/Elements/footer.php 0.67
    » » » Rendering APP/Plugin/FrontendMembers/View/Elements/login.php 4.93
    Event: View.afterLayout 0.00
    ====
  • Log
    +

    Logs

    There were no log entries made this request

    ====
  • Variables
    +

    View Variables

    • row(array)
      • Menu(array)
        • id18
        • hash7dd882caec420741fb76e52400fa77a3
        • created2019-05-13 13:36:21
        • updated2019-12-04 11:35:37
        • parent_id17
        • lft61
        • rght62
        • language_id1
        • typecontent
        • titleImpressum
        • previous_urlhttps://www.mueller-hereth.com/homepage/#kontakt
        • url(null)
        • target_blank(false)
        • label_title(null)
        • label_url(null)
        • label_mail(null)
        • label_tooltipp(null)
        • label_text
      • Seo(array)
        • id18
        • hashc85bdefd23215c33333a861b1ffcb49f
        • created2019-05-13 13:36:21
        • updated2019-12-04 11:35:37
        • modelMenu
        • foreign_key18
        • titleMüller und Hereth - Impressum
        • descriptionHier finden Sie unser Impressum.
        • internal_keywords
        • author
        • tw_creator
        • fb_author
        • robots3
        • ImageMedia(empty)
      • Content(array)
        • 0(array)
          • id37
          • hash6acad0d4dc8e21f7dc250ca52950a124
          • created2019-11-12 12:29:59
          • updated2019-11-12 12:29:59
          • menu_id18
          • position1
          • typearticle
          • statusactive
          • titleImpressum
          • layoutcol12
          • sidebar(false)
          • language_id1
          • article_content<h1>Impressum</h1> <p><strong>Prof. D. L. Müller + Dipl. – Ing. A. Hereth<br /> Ingenieurbüro für Tunnel- und Felsbau GmbH</strong></p> <p>Laufener Straße 16</p> <p>D-83395 Freilassing</p> <p>Deutschland</p> <div> </div> <div><strong>Kontakt</strong></div> <p>Telefon: +49 (0) 8654 6011 -0</p> <p>Fax: +49 (0) 8654 6011-33</p> <p>E-Mail: office.freilassing@mueller-hereth.com</p> <p>Internet: www.mueller-hereth.com</p> <p><br /> <strong>Geschäftsführung</strong>:  Dipl.-Ing. Sebastian Schwaiger, Dipl.-Ing. Martin Wagner<br /> <br /> <strong>Registergericht</strong>: Amtsgericht Traunstein<br /> <strong>Registernummer</strong>:<strong> </strong>HRB 3009<br /> <strong>UStIDNr</strong>.: DE132362101<br /> <strong>Angaben nach §6 TDG</strong>: HOAI Honorarordnung für Architekten und Ingenieure, IngG Ingenieurgesetz, VgV Vergabeverordnung </p> <p> </p> <p><strong>Haftung für Inhalte</strong></p> <p>Die Inhalte unserer Seiten wurden mit größter Sorgfalt erstellt. Für die Richtigkeit, Vollständigkeit und Aktualität der Inhalte können wir jedoch keine Gewähr übernehmen. Als Diensteanbieter sind wir gemäß § 7 Abs.1 TMG für eigene Inhalte auf diesen Seiten nach den allgemeinen Gesetzen verantwortlich. Nach §§ 8 bis 10 TMG sind wir als Diensteanbieter jedoch nicht verpflichtet, übermittelte oder gespeicherte fremde Informationen zu überwachen oder nach Umständen zu forschen, die auf eine rechtswidrige Tätigkeit hinweisen. Verpflichtungen zur Entfernung oder Sperrung der Nutzung von Informationen nach den allgemeinen Gesetzen bleiben hiervon unberührt. Eine diesbezügliche Haftung ist jedoch erst ab dem Zeitpunkt der Kenntnis einer konkreten Rechtsverletzung möglich. Bei Bekanntwerden von entsprechenden Rechtsverletzungen werden wir diese Inhalte umgehend entfernen.</p> <p> </p> <p><strong>Haftung für Links</strong></p> <p>Unser Angebot enthält Links zu externen Webseiten Dritter, auf deren Inhalte wir keinen Einfluss haben. Deshalb können wir für diese fremden Inhalte auch keine Gewähr übernehmen. Für die Inhalte der verlinkten Seiten ist stets der jeweilige Anbieter oder Betreiber der Seiten verantwortlich. Die verlinkten Seiten wurden zum Zeitpunkt der Verlinkung auf mögliche Rechtsverstöße überprüft. Rechtswidrige Inhalte waren zum Zeitpunkt der Verlinkung nicht erkennbar. Eine permanente inhaltliche Kontrolle der verlinkten Seiten ist jedoch ohne konkrete Anhaltspunkte einer Rechtsverletzung nicht zumutbar. Bei Bekanntwerden von Rechtsverletzungen werden wir derartige Links umgehend entfernen.</p> <p> </p> <p>  <p><strong>Urheberrecht</strong></p> </p> <p>Die durch die Seitenbetreiber erstellten Inhalte und Werke auf diesen Seiten unterliegen dem deutschen Urheberrecht. Die Vervielfältigung, Bearbeitung, Verbreitung und jede Art der Verwertung außerhalb der Grenzen des Urheberrechtes bedürfen der schriftlichen Zustimmung des jeweiligen Autors bzw. Erstellers. Downloads und Kopien dieser Seite sind nur für den privaten, nicht kommerziellen Gebrauch gestattet. Soweit die Inhalte auf dieser Seite nicht vom Betreiber erstellt wurden, werden die Urheberrechte Dritter beachtet. Insbesondere werden Inhalte Dritter als solche gekennzeichnet. Sollten Sie trotzdem auf eine Urheberrechtsverletzung aufmerksam werden, bitten wir um einen entsprechenden Hinweis. Bei Bekanntwerden von Rechtsverletzungen werden wir derartige Inhalte umgehend entfernen.</p> <p> </p> <p><strong>Programmierung, Design und Realisierung</strong></p> <p>makrohaus AG, crossmedia<br /> Getreidegasse 9</p> <p>83435 Bad Reichenhall<br /> Tel: +49(0)865176666-0 Fax: -40<br /> <a class="extern external" href="http://www.makrohaus.de" target="_blank" title="http://www.makrohaus.de">info@makrohaus.de<br /> www.makrohaus.de</a></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)
            • id195
            • hashf9d8920a4e19cea8cd4521a791776421
            • created2019-11-12 12:29:59
            • updated2019-11-12 12:29:59
            • modelContent
            • foreign_key37
            • base/impressum/
            • aliasimpressum
            • controllerFrontendContents.FrontendContents
            • actionarticle
            • parent_id19
            • lft159
            • rght160
            • route/impressum/impressum
    • $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 aFWSm@NeVMmKgJEG5gK@TwAAAgg
    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 aFWSm@NeVMmKgJEG5gK@TwAAAgg
    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 aFWSm@NeVMmKgJEG5gK@TwAAAgg
    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.82
    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 Sun, 16 Mar 2025 13:17:37 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.82
    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 43208
    Redirect Url /webroot/impressum
    Gateway Interface CGI/1.1
    Server Protocol HTTP/1.0
    Request Method GET
    Query String
    Request Uri /impressum
    Script Name /webroot/index.php
    Php Self /webroot/index.php
    Request Time Float 1750438555.0848
    Request Time 1750438555
    ====
  • 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
    ====