Daten & Fakten

Wissenswertes

Eröffnung: 24. März 2005

Erweiterung:

2011 Liegen- und Ruheräume, Saunalandschaft außen, Familienbad

2012 Saunaumkleidetrakt

2014 AlpenSole Caldarium

2017 PartnerSpa WellnessCenter

2018 AlpenSole Whirlpool, AlpenSole Dampfbad im Bereich der Solegrotte

2020/21 Kristallsauna im Außenbereich Sauna

2020/21 Erweiterung Außenbecken Thermenlandschaft

Investitionsvolumen: 60 Millionen Euro

Betreiber: Bayer. Staatsbad Bad Reichenhall/Bayer. Gmain GmbH
Gesellschafter: Freistaat Bayern, Stadt Bad Reichenhall, Gemeinde Bayerisch Gmain
Geschäftsleitung: Geschäftsführer Dirk Sasse
Mitarbeiter/innen: 90
Besucher pro Jahr: 500.000 Besucher

Einzugsgebiet: regionaler Radius bis 100 km um Bad Reichenhall/Bayerisch Gmain, die Stadt Salzburg die Region Salzburger Land. Überregional: Gäste des Bayerischen Staatsbades Bad Reichenhall in Verbindung mit Pauschalangeboten und in enger Kooperation mit heimischen Hotels und Pensionen

Positionierung: Gesundheit, Wellness, Familie

Angebotsbereiche: Therme und Familie

Alleinstellungsmerkmal: AlpenSole, AlpenSalz, Laist

Flächenangaben:

24.351 m² Grundstücksfläche
18.891 m² Netto-Grundfläche
12.526 m² Hauptnutzfläche
1.730 m² Wasserfläche gesamt

Sole-Gehalt in den Becken: 2% - 12%
Sole-Indikationen: Entspannung des gesamten Organismus,
Belebung und Regeneration der Haut, Entlastung
des Bewegungsapparates und der Muskeln,
allgemeine mentale und körperliche Regeneration

Wassertemperatur: 18° C - 40 ° C
Kapazität gleichzeitig anwesende Gäste: 1.020

Therme 320

Sauna 280

Familienbad 420

behindertengerechte Anlage

AlpenSole ThermenLandschaft

Die AlpenSole ThermenLandschaft bietet Ihnen auf einer Gesamt-Wasserfläche von 850 m² pure Wellness und Entspannung.

INNENBEREICH

Umkleiden

* 320 Umkleideschränke mit Wechselkabinen

Der Innenbereich der ThermenLandschaft erstreckt sich über eine Gesamt-Wasserfläche von 350 m².

1. Obergeschoß
* Aktivbecken 126 m² mit 34° -36° C, 2% Solegehalt, Wassertiefe 1,35 m
* Liegebecken 56 m² mit 34° - 36° C, 2% Solegehalt, Wassertiefe 0,95 m
* Sitzbecken 16 m² mit 34° - 36° C, 2% Solegehalt

Galerie
* Whirlpool 36° - 37° C, 4% Solegehalt, 21 m² Wasserfläche, Wassertiefe 0,75 m
* Warmbecken 38° - 40° C, Süßwasser, 16 m² Wasserfläche, Wassertiefe 0,75 m
* Kaltbecken 18° C, Süßwasser, 3 m² Wasserfläche, Wassertiefe 0,90 m

Erd- und Untergeschoß
* Solegrotte, 44 m² Wasserfläche
davon Soleschwebebecken 36° - 37° C, 12% Solegehalt, 31 m² Wasserfläche, Wassertiefe 0,71 m
davon AlpenSole-Whirlpool 36° C, 4% Solegehalt, 10 m² Wasserfläche, Wassertiefe 0,90 m
* AlpenSoleDampfbad mit 12 Sitzplätzen und Solevernebelung, Temperatur 45° - 55° C, Luftfeuchtigkeit 80 - 100 %, Solegehalt 5 %
* Soledampfbad mit 5 Sitzplätzen
* Präventionsbecken 32° C, 2% Solegehalt, 75 m² Wasserfläche, Wassertiefe 1,25 - 1,35 m

AUßENBEREICH

Der Außenbereich der ThermenLandschaft erstreckt sich über eine Gesamt-Wasserfläche von 850 m². (500 m² außen, 350 m² innen)

Außenbecken

* Relaxbecken 34° - 36° C, 3% Solegehalt, 484 m² Wasserfläche
* Whirlbecken 34° - 36° C, 3% Solegehalt, 14 m² Wasserfläche

* 2 Hot-Whirlbecken 36° - 38° C, 3% Solegehalt

Diverse Features (teilweise in den einzelnen Becken)
* Luftsprudelliegen
* Luftsprudelsitze
* Massagedüsen
* Schwallduschen
* Bodenbrodler
* Strömungskanal mit Whirlpool im Außenbecken
* Dampfbad mit SalzAbrieb
* Poolbar vom Wasser aus zugänglich
* Eingebaute Liegen im Pool

Entspannung, Gastronomie
* großzügige Liegebereiche (höhe Thermenrestaurant)
* ThermenRestaurant mit Sonnenterrasse 130 Sitzplätze
* Poolbar im Außenbecken mit Sitzbereich
* Außenliegenterrasse mit Bergpanorama
* Ergoline-Hochleistungssolarium

Ausstattung Alpine SaunaLandschaft

Auf 970 m² Gesamtnutzungsfläche im Gebäude die sich über zwei Etagen erstrecken kommt der Saunagenießer auf seine Kosten, zusätzlich stehen 172 m² Wasserfläche zur Verfügung.

INNENBEREICH

Umkleiden

* 280 Umkleideschränke

Schwitzen
* Predigtstuhlsaunarium mit Bergpanorama (Luftfeuchtigkeit 30 - 40 %) 65° C
* StaufenSauna (reine Damensauna) Farblicht 80° C
* UntersbergSauna mit automatisierten Aufgüssen (Kapazität 30 Personen, Luftfeuchtigkeit 10-20 %) 90° - 95° C
* AlpenSole Caldarium mit Anwendungen (Luftfeuchtigkeit 90 %) 40 - 50 ° C

Abkühlen
* Tauchbecken 2 m², 18° C, Süßwasser, Wassertiefe 1,35 m
* Kaltduschen
* Eiswürfelbrunnen

Entspannen
* Whirlpool 30 m², Süßwasser 36° - 37° C, Wassertiefe 0,95 m
* Fußbecken
* Kaminzimmer mit holzbefeuertem Kamin
* Ruheraum mit Panoramablick
* Ergoline-Hochleistungssolarien
* SaunaBar mit 50 Sitzplätzen
* SaunaRestaurant mit Sonnenterrasse mit 80 Sitzplätzen

AUßENBEREICH

Hier stehen dem Besucher der SaunaLandschaft 3.300 m² pures Saunavergnügen zur Verfügung.

Schwitzen
* Holzbefeuerte Erdsauna 95° - 100 ° C, Luftfeuchtigkeit 5 - 10 %
* Doppelstöckige Finnische TempelaufgussSauna, Kapazität 50 Personen, 85° - 90° C mit persolainitiierten Aufgüssen, Luftfeuchtigkeit 10 - 20 %
* Laist - Salzzentrum mit Laist - Sole Dampfbad 50 Sitzplätze (Laist, AlpenSalz, Latschenkiefernöl-Anwendungen) 40° C, Luftfeuchtigkeit 90 - 100 %

* Alpinedampfbad, 45° - 55° C, Luftfeuchtigkeit 80 -100 %

* Salz - StollenSauna 85° - 90° C, 20 Sitzplätze (Salzabrieb), Luftfeuchtigkeit 10 -20 %

* Caldarium, 40° - 50° C, Luftfeuchtigkeit 90 %

* Predigtstuhlsauna, 60 - 65° C, Luftfeuchtigkeit 30 - 40 %

* Staufensauna, Damensauna, 80 - 85° C, Luftfeuchtigkeit 20 - 30 %

* Untersbergsauna, 90 - 95° C, Luftfeuchtigkeit 10 -20 %

* KristallSauna 85 - 90° C, 40 Sitzplätze

Abkühlen
* Kaltwasserbecken 21 m² 18° C, Süßwasser, Wassertiefe 1,35 m
* windgeschützter Außenduschbereich
* Eiswürfelbrunnen

Entspannen
* großzügige Liegebereiche (höhe Saunarestaurant)
* Panoramaruheraum im OG der TempelaufgussSauna, holzbefeuerter Kamin
* idyllischer Naturteich
* Warmwasserpool 119 m² 32° - 34° C, Süßwasser, Wassertiefe 1,35
* Alpiner Saunagarten mit terrassierten Liegedecks

FitnessCenter

Auf einer Gesamtfläche von 565 qm trainieren Sie in einer angenehmen und stilvollen Atmosphäre.

Trainingsbereiche
* Cardiotrainingsfläche EG ca. 85 m²
* Gerätetrainingsfläche UG ca. 300 m²
* Klimatisierter Aerobic - Kursraum UG ca. 118 m²
* Klimatisierter Funktionalraum UG ca. 64m²
* AquaTraining Pool 75 m², 32° C und 2% Solegehalt
* Ergoline Hochleistungssolarium
* Bar & Lounge mit Sonnenterrasse
* Ausstattung mit modernsten TechnoGym Cardio- und Kraftgeräten

Trainingsangebote
* Muskel - Training
* Herz-Kreislauf-Training
* Entspannungs-Training
* Fitnesskurse, AquaTraining

* Gesundheitskurse in Zusammenarbeit mit Krankenkassen

Beratung & Service
* InBody und Zellcheck-Testzentrum mit umfangreichen, computer-unterstützten Test- und
Analyseverfahren, Grundlage für eine individuelle, ganzheitliche Trainingsplanung
* Körperfett-Analyse
* Herz-Kreislauf- und Muskelfunktionstest
* Ernährungsberatung
* sportmedizinische Betreuung und Beratung Dr. Paa
* Betreuung durch Fitnesstrainer, Sport- und Gymnastiklehrer

WellnessCenter

Auf 240 m² klimatisierte Gesamtnutzungsfläche erwarten Sie Schönheits- und Entspannungsbehandlungen mit den Alpenschätzen AlpenSalz und Laist - Mineralsoleschlick

Ausstattung

* 4 Trockenmassageräume
* 2 Nassmassageräume
* 1 Partnermassageraum
* 1 PartnerSpa mit Erlebnis-Regenwalddusche und Massageliegen
* 1 Kosmetikraum
* RuheLounge
* Empfangs- und Terminierungsbereich

Angebote

* Spa Wellnesspackage
* Partnerpackages
* SpaZeit (Wellnessbehandlungen zur Auswahl)
* Packungen, Peelings
* Klassische Massagen
* Nassmassagen
* Fußspezialbehandlungen

THERAPIE
(durch das Kurmittelhaus der Moderne)

Ausstattung

Beckengröße 75 qm²
Wassertiefe 1,25 Meter - 1,35 Meter
Solegehalt 2 %
Wassertemperatur 32° C
Ausstattung Behinderten gerecht (Poollift bis 120 KG)

Angebote

Von ausgebildeten Physiotherapeuten und Masseuren / medizinischen Bademeistern werden folgende Therapien abgegeben:

Heilmittelverordnung:

* Krankengymnastik im Bewegungsbad Einzel/Gruppe
* Übungsbehandlung im Bewegeungsbad Einzel/Gruppe

Verordnung des Kurarztes:

* Krankengymnastik im Solebewegungsbad Einzel/Gruppe
* Entspannungstechniken, Bewegungstherapie

Ausstattung FamilienBad

Das FamilienBad bietet Ihnen auf einer Gesamt-Wasserfläche von ca. 700 m² Spaß und Sport mit der ganzen Familie.

FAMILIENBEREICH

Umkleiden

* 420 Umkleideschränke mit Wechselkabinen

Der Familienbereich erstreckt sich über eine Wasserfläche von 322 m².

* Familienbecken 32° - 34° C, Wassertiefe 0,70 m bis 1,10 m, Wasserfläche 148 qm
* Lehrschwimmbecken 32° - 34° C, Wassertiefe 0,70 m bis 1,10 m, Wasserfläche 132 qm
* Kleinkindbecken 34° - 36° C, Wassertiefe 0,12 m bis 0,30 m, Wasserfläche 42 qm
* Wellenbreitrutsche 12 m
* Reifenrutsche 120 m mit Zeitmessanlage
* Strömungskanal mit Sprudelsitzbecken
* 3 Schwallduschen
* Kleinkind - Trockenspielraum

* Brotzeitraum, hier können mitgebrachte Speisen /Getränke verzehrt werden

SPORTBEREICH

Der Sportbereich erstreckt sich über eine Wasserfläche von 375 m².

* Wettkampfgerechtes Sportbecken 25 x15m, 6 Bahnen, Wassertiefe 1,80m bis 2,20 m Wasserfläche 375 qm, Wassertemperatur 27° - 30° C

Entspannung, Gastronomie

* 188 Liegeplätze
* Bistro 45 Sitzplätze
* Snack-, Getränke- & Kaffeeautomat

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 `rupertustherme`.`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`))) = '/service/daten-fakten' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 349 AND `Route`.`rght` >= 366 ORDER BY `Route`.`lft` asc	5	5	1	maybe slow
SELECT `Menu`.`id`, `Language`.`id` FROM `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 134 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`blockcard_group_id`) FROM blockcard_groups_menus AS AuthorizedFor JOIN `rupertustherme`.`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	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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 134 AND `Route`.`model` = 'Menu'	1	1	1
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 `rupertustherme`.`seo` AS `Seo` WHERE `Seo`.`foreign_key` = 134 AND `Seo`.`model` = 'Menu'	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 171 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` FROM `rupertustherme`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 134 AND `Teaser`.`model` = 'Menu'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 171 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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (134) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	1	maybe slow
SELECT `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `rupertustherme`.`media` AS `HeaderImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 134 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	1
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 `rupertustherme`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (30) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	1	maybe slow
SELECT `Language`.`langid` FROM `rupertustherme`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `rupertustherme`.`settings` AS `Setting` LEFT JOIN `rupertustherme`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	45	45	1
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 `rupertustherme`.`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, 27, 29, 30, 31, 32, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	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`.`target_modal`, `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 `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') WHERE `Menu`.`id` = 134 LIMIT 1	1	1	1
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` WHERE `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (134) ORDER BY `Content`.`position` asc	8	8	1	maybe slow
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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 132 AND `Route`.`model` = 'Content'	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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 133 AND `Route`.`model` = 'Content'	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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 134 AND `Route`.`model` = 'Content'	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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 135 AND `Route`.`model` = 'Content'	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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 136 AND `Route`.`model` = 'Content'	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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 137 AND `Route`.`model` = 'Content'	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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 138 AND `Route`.`model` = 'Content'	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 `rupertustherme`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 139 AND `Route`.`model` = 'Content'	1	1	1
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 `rupertustherme`.`languages` AS `Language` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `Language`.`id` = 1 LIMIT 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 `rupertustherme`.`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	0	0	0
SELECT *, Language.id FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`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`.`target_modal`, `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` FROM `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`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	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 `rupertustherme`.`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 `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `rupertustherme`.`media` AS `HeaderImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_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 `rupertustherme`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (381) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`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`.`target_modal`, `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 `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 56 ORDER BY `Menu`.`lft` asc	26	26	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'subnavigation-left' 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`.`target_modal`, `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 `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 58 AND `Menu`.`rght` < 69 ORDER BY `Menu`.`lft` asc	5	5	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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (144, 145, 187, 146, 185) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	5	5	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'subnavigation-right' 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`.`target_modal`, `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 `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 70 AND `Menu`.`rght` < 105 ORDER BY `Menu`.`lft` asc	17	17	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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (6, 160, 126, 127, 128, 164, 129, 130, 131, 132, 133, 134, 135, 136, 165, 194, 196) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-navigation-1' 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`.`target_modal`, `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 `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 110 AND `Menu`.`rght` < 121 ORDER BY `Menu`.`lft` asc	5	5	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-navigation-2' 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`.`target_modal`, `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 `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 122 AND `Menu`.`rght` < 141 ORDER BY `Menu`.`lft` asc	9	9	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social' 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`.`target_modal` FROM `rupertustherme`.`menus` AS `Menu` WHERE `Menu`.`lft` > 142 AND `Menu`.`rght` < 151 ORDER BY `Menu`.`lft` asc	4	4	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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (30, 32, 33, 34) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'awards' 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`.`target_modal` FROM `rupertustherme`.`menus` AS `Menu` WHERE `Menu`.`lft` > 152 AND `Menu`.`rght` < 165 ORDER BY `Menu`.`lft` asc	6	6	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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (36, 37, 38, 179, 199, 204) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = '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`.`target_modal` FROM `rupertustherme`.`menus` AS `Menu` WHERE `Menu`.`lft` > 166 AND `Menu`.`rght` < 171 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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (41, 44) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	2	2	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`.`target_modal` FROM `rupertustherme`.`menus` AS `Menu` WHERE `Menu`.`id` = 134 LIMIT 1	1	1	1
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`.`target_modal`, `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 `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` <= 92 AND `Menu`.`rght` >= 93 AND `Menu`.`type` = 'content' ORDER BY `Menu`.`lft` asc	2	2	1	maybe slow
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`.`target_modal`, `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` FROM `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE 1 = 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`.`target_modal` FROM `rupertustherme`.`menus` AS `Menu` WHERE `id` = 134 LIMIT 1	1	1	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 `rupertustherme`.`languages` AS `Language` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' AND `Language`.`langid` = 'de' LIMIT 1	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`.`target_modal`, `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 `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc	0	0	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 `rupertustherme`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Menu' AND `Seo`.`foreign_key` = 134 LIMIT 1	1	1	0
SELECT *, Language.id FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-address' 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`.`target_modal`, `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` FROM `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 15 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 19 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 19 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 `rupertustherme`.`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 `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `rupertustherme`.`media` AS `HeaderImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_image' 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`.`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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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`.`target_modal`, `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` FROM `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 15 LIMIT 1	1	1	2	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 20 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 20 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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Content' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (5) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `LinkPdfUpload`.`id`, `LinkPdfUpload`.`hash`, `LinkPdfUpload`.`created`, `LinkPdfUpload`.`updated`, `LinkPdfUpload`.`model`, `LinkPdfUpload`.`field`, `LinkPdfUpload`.`foreign_key`, `LinkPdfUpload`.`alias`, `LinkPdfUpload`.`thumbnail`, `LinkPdfUpload`.`parent_id`, `LinkPdfUpload`.`file`, `LinkPdfUpload`.`size`, `LinkPdfUpload`.`ext`, `LinkPdfUpload`.`mime`, `LinkPdfUpload`.`width`, `LinkPdfUpload`.`height` FROM `rupertustherme`.`uploads` AS `LinkPdfUpload` WHERE `LinkPdfUpload`.`model` = 'Content' AND `LinkPdfUpload`.`field` = 'link_pdf' AND `LinkPdfUpload`.`foreign_key` = (5) ORDER BY FIELD(COALESCE(`LinkPdfUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `MenusManually`.`id`, `MenusManually`.`hash`, `MenusManually`.`created`, `MenusManually`.`updated`, `MenusManually`.`parent_id`, `MenusManually`.`lft`, `MenusManually`.`rght`, `MenusManually`.`language_id`, `MenusManually`.`type`, `MenusManually`.`title`, `MenusManually`.`previous_url`, `MenusManually`.`url`, `MenusManually`.`target_blank`, `MenusManually`.`target_modal`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `rupertustherme`.`menus` AS `MenusManually` JOIN `rupertustherme`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 5 AND `ContentsMenu`.`menu_id` = `MenusManually`.`id`) ORDER BY `ContentsMenu`.`position` ASC	0	0	0
SELECT `NewsManually`.`id`, `NewsManually`.`hash`, `NewsManually`.`created`, `NewsManually`.`updated`, `NewsManually`.`title`, `NewsManually`.`pubdate`, `NewsManually`.`menu_id`, `NewsManually`.`subtitle`, `NewsManually`.`news_target`, `NewsManually`.`teaser_type`, `NewsManually`.`teaser_external_url`, `NewsManually`.`content`, `NewsManually`.`teaser_menu_id`, `NewsManually`.`introduction`, `NewsManually`.`release`, `NewsManually`.`hide`, `NewsManually`.`status`, (NOW() BETWEEN COALESCE(`NewsManually`.`release`, NOW()) AND COALESCE(`NewsManually`.`hide`, NOW())) AS `NewsManually__published`, `ContentsNews`.`id`, `ContentsNews`.`content_id`, `ContentsNews`.`news_id`, `ContentsNews`.`position` FROM `rupertustherme`.`news` AS `NewsManually` JOIN `rupertustherme`.`contents_news` AS `ContentsNews` ON (`ContentsNews`.`content_id` = 5 AND `ContentsNews`.`news_id` = `NewsManually`.`id`) ORDER BY `ContentsNews`.`position` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ArticleContentMedia` JOIN `rupertustherme`.`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 `rupertustherme`.`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 `rupertustherme`.`media` AS `GalleryMedia` JOIN `rupertustherme`.`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 `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MediaMedia`.`id`, `MediaMedia`.`hash`, `MediaMedia`.`created`, `MediaMedia`.`updated`, `MediaMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `MediaMedia`.`id`) AS `MediaMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `rupertustherme`.`media` AS `MediaMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `MediaMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'media' 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`.`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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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`.`target_modal`, `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` FROM `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 134 AND `status` = 'active'	8	8	5	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 280 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 281 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 282 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 283 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 284 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 285 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 286 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 287 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 282 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 283 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 284 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 285 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 286 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 287 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 288 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 289 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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Content' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (132, 133, 134, 135, 136, 137, 138, 139) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `LinkPdfUpload`.`id`, `LinkPdfUpload`.`hash`, `LinkPdfUpload`.`created`, `LinkPdfUpload`.`updated`, `LinkPdfUpload`.`model`, `LinkPdfUpload`.`field`, `LinkPdfUpload`.`foreign_key`, `LinkPdfUpload`.`alias`, `LinkPdfUpload`.`thumbnail`, `LinkPdfUpload`.`parent_id`, `LinkPdfUpload`.`file`, `LinkPdfUpload`.`size`, `LinkPdfUpload`.`ext`, `LinkPdfUpload`.`mime`, `LinkPdfUpload`.`width`, `LinkPdfUpload`.`height` FROM `rupertustherme`.`uploads` AS `LinkPdfUpload` WHERE `LinkPdfUpload`.`model` = 'Content' AND `LinkPdfUpload`.`field` = 'link_pdf' AND `LinkPdfUpload`.`foreign_key` IN (132, 133, 134, 135, 136, 137, 138, 139) ORDER BY FIELD(COALESCE(`LinkPdfUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `MenusManually`.`id`, `MenusManually`.`hash`, `MenusManually`.`created`, `MenusManually`.`updated`, `MenusManually`.`parent_id`, `MenusManually`.`lft`, `MenusManually`.`rght`, `MenusManually`.`language_id`, `MenusManually`.`type`, `MenusManually`.`title`, `MenusManually`.`previous_url`, `MenusManually`.`url`, `MenusManually`.`target_blank`, `MenusManually`.`target_modal`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `rupertustherme`.`menus` AS `MenusManually` JOIN `rupertustherme`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` IN (132, 133, 134, 135, 136, 137, 138, 139) AND `ContentsMenu`.`menu_id` = `MenusManually`.`id`) ORDER BY `ContentsMenu`.`position` ASC	0	0	1	maybe slow
SELECT `NewsManually`.`id`, `NewsManually`.`hash`, `NewsManually`.`created`, `NewsManually`.`updated`, `NewsManually`.`title`, `NewsManually`.`pubdate`, `NewsManually`.`menu_id`, `NewsManually`.`subtitle`, `NewsManually`.`news_target`, `NewsManually`.`teaser_type`, `NewsManually`.`teaser_external_url`, `NewsManually`.`content`, `NewsManually`.`teaser_menu_id`, `NewsManually`.`introduction`, `NewsManually`.`release`, `NewsManually`.`hide`, `NewsManually`.`status`, (NOW() BETWEEN COALESCE(`NewsManually`.`release`, NOW()) AND COALESCE(`NewsManually`.`hide`, NOW())) AS `NewsManually__published`, `ContentsNews`.`id`, `ContentsNews`.`content_id`, `ContentsNews`.`news_id`, `ContentsNews`.`position` FROM `rupertustherme`.`news` AS `NewsManually` JOIN `rupertustherme`.`contents_news` AS `ContentsNews` ON (`ContentsNews`.`content_id` IN (132, 133, 134, 135, 136, 137, 138, 139) AND `ContentsNews`.`news_id` = `NewsManually`.`id`) ORDER BY `ContentsNews`.`position` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ArticleContentMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (132, 133, 134, 135, 136, 137, 138, 139) 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `GalleryMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (132, 133, 134, 135, 136, 137, 138, 139) AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (132, 133, 134, 135, 136, 137, 138, 139) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MediaMedia`.`id`, `MediaMedia`.`hash`, `MediaMedia`.`created`, `MediaMedia`.`updated`, `MediaMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `MediaMedia`.`id`) AS `MediaMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `rupertustherme`.`media` AS `MediaMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (132, 133, 134, 135, 136, 137, 138, 139) AND `MediaEntity`.`media_id` = `MediaMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'media' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'sidebar' 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`.`target_modal` FROM `rupertustherme`.`menus` AS `Menu` WHERE `Menu`.`lft` > 173 AND `Menu`.`rght` < 184 ORDER BY `Menu`.`lft` asc	5	5	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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (89, 137, 138, 139, 140) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT *, Language.id FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'sidebar-prices' 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`.`target_modal`, `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` FROM `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 89 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 105 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 104 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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (89) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `rupertustherme`.`media` AS `HeaderImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 89 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_image' 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`.`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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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`.`target_modal`, `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` FROM `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 89 LIMIT 1	1	1	2	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 108 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 107 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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Content' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (15) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `LinkPdfUpload`.`id`, `LinkPdfUpload`.`hash`, `LinkPdfUpload`.`created`, `LinkPdfUpload`.`updated`, `LinkPdfUpload`.`model`, `LinkPdfUpload`.`field`, `LinkPdfUpload`.`foreign_key`, `LinkPdfUpload`.`alias`, `LinkPdfUpload`.`thumbnail`, `LinkPdfUpload`.`parent_id`, `LinkPdfUpload`.`file`, `LinkPdfUpload`.`size`, `LinkPdfUpload`.`ext`, `LinkPdfUpload`.`mime`, `LinkPdfUpload`.`width`, `LinkPdfUpload`.`height` FROM `rupertustherme`.`uploads` AS `LinkPdfUpload` WHERE `LinkPdfUpload`.`model` = 'Content' AND `LinkPdfUpload`.`field` = 'link_pdf' AND `LinkPdfUpload`.`foreign_key` = (15) ORDER BY FIELD(COALESCE(`LinkPdfUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `MenusManually`.`id`, `MenusManually`.`hash`, `MenusManually`.`created`, `MenusManually`.`updated`, `MenusManually`.`parent_id`, `MenusManually`.`lft`, `MenusManually`.`rght`, `MenusManually`.`language_id`, `MenusManually`.`type`, `MenusManually`.`title`, `MenusManually`.`previous_url`, `MenusManually`.`url`, `MenusManually`.`target_blank`, `MenusManually`.`target_modal`, `ContentsMenu`.`id`, `ContentsMenu`.`content_id`, `ContentsMenu`.`menu_id`, `ContentsMenu`.`position` FROM `rupertustherme`.`menus` AS `MenusManually` JOIN `rupertustherme`.`contents_menus` AS `ContentsMenu` ON (`ContentsMenu`.`content_id` = 15 AND `ContentsMenu`.`menu_id` = `MenusManually`.`id`) ORDER BY `ContentsMenu`.`position` ASC	0	0	0
SELECT `NewsManually`.`id`, `NewsManually`.`hash`, `NewsManually`.`created`, `NewsManually`.`updated`, `NewsManually`.`title`, `NewsManually`.`pubdate`, `NewsManually`.`menu_id`, `NewsManually`.`subtitle`, `NewsManually`.`news_target`, `NewsManually`.`teaser_type`, `NewsManually`.`teaser_external_url`, `NewsManually`.`content`, `NewsManually`.`teaser_menu_id`, `NewsManually`.`introduction`, `NewsManually`.`release`, `NewsManually`.`hide`, `NewsManually`.`status`, (NOW() BETWEEN COALESCE(`NewsManually`.`release`, NOW()) AND COALESCE(`NewsManually`.`hide`, NOW())) AS `NewsManually__published`, `ContentsNews`.`id`, `ContentsNews`.`content_id`, `ContentsNews`.`news_id`, `ContentsNews`.`position` FROM `rupertustherme`.`news` AS `NewsManually` JOIN `rupertustherme`.`contents_news` AS `ContentsNews` ON (`ContentsNews`.`content_id` = 15 AND `ContentsNews`.`news_id` = `NewsManually`.`id`) ORDER BY `ContentsNews`.`position` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ArticleContentMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `GalleryMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MediaMedia`.`id`, `MediaMedia`.`hash`, `MediaMedia`.`created`, `MediaMedia`.`updated`, `MediaMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `MediaMedia`.`id`) AS `MediaMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `rupertustherme`.`media` AS `MediaMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 AND `MediaEntity`.`media_id` = `MediaMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'media' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT *, Language.id FROM `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `rupertustherme`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'disturber' 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`.`target_modal`, `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` FROM `rupertustherme`.`menus` AS `Menu` LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 197 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 474 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 `rupertustherme`.`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 `rupertustherme`.`media` AS `ImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 459 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 `rupertustherme`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Menu' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (197) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImageMedia`.`id`, `HeaderImageMedia`.`hash`, `HeaderImageMedia`.`created`, `HeaderImageMedia`.`updated`, `HeaderImageMedia`.`title`, (SELECT COUNT(1) FROM `rupertustherme`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) AS `HeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `rupertustherme`.`media` AS `HeaderImageMedia` JOIN `rupertustherme`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 197 AND `MediaEntity`.`media_id` = `HeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_image' 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`.`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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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`.`target_modal`, `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` FROM `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `rupertustherme`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `rupertustherme`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `menu_id` = 197 AND `status` = 'active' LIMIT 1	0	0	1	maybe slow
SELECT `Popup`.`id`, `Popup`.`hash`, `Popup`.`created`, `Popup`.`updated`, `Popup`.`title`, `Popup`.`content`, `Popup`.`release`, `Popup`.`hide`, `Popup`.`status`, (NOW() BETWEEN COALESCE(`Popup`.`release`, NOW()) AND COALESCE(`Popup`.`hide`, NOW())) AS `Popup__published` FROM `rupertustherme`.`popups` AS `Popup` WHERE `Popup`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Popup`.`release`, NOW()) AND COALESCE(`Popup`.`hide`, NOW())) = '1' ORDER BY `Popup`.`release` DESC LIMIT 1	0	0	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 `rupertustherme`.`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`))) = '/service/daten-fakten/ueberschrift' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 350 AND `Route`.`rght` >= 351 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 132 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	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 `rupertustherme`.`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`))) = '/service/daten-fakten/wissenswertes' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 352 AND `Route`.`rght` >= 353 ORDER BY `Route`.`lft` asc	6	6	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 133 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	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 `rupertustherme`.`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`))) = '/service/daten-fakten/alpensole-thermenlandschaft' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 354 AND `Route`.`rght` >= 355 ORDER BY `Route`.`lft` asc	6	6	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 134 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	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 `rupertustherme`.`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`))) = '/service/daten-fakten/ausstattung-alpine-saunalandschaft' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 356 AND `Route`.`rght` >= 357 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 135 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	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 `rupertustherme`.`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`))) = '/service/daten-fakten/fitnesscenter' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 358 AND `Route`.`rght` >= 359 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 136 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	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 `rupertustherme`.`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`))) = '/service/daten-fakten/wellnesscenter' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 360 AND `Route`.`rght` >= 361 ORDER BY `Route`.`lft` asc	6	6	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 137 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	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 `rupertustherme`.`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`))) = '/service/daten-fakten/therapie' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 362 AND `Route`.`rght` >= 363 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 138 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	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 `rupertustherme`.`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`))) = '/service/daten-fakten/ausstattung-familienbad' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `rupertustherme`.`routes` AS `Route` WHERE `Route`.`lft` <= 364 AND `Route`.`rght` >= 365 ORDER BY `Route`.`lft` asc	6	6	1	maybe slow
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `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`.`image_left`, `Content`.`360deg_url`, `Content`.`heat_ticket`, `Content`.`area_title_1`, `Content`.`area_subtitle_1`, `Content`.`area_title_2`, `Content`.`area_subtitle_2`, `Content`.`area_title_3`, `Content`.`area_subtitle_3`, `Content`.`area_title_4`, `Content`.`area_subtitle_4`, `Content`.`area_title_5`, `Content`.`area_subtitle_5`, `Content`.`area_title_6`, `Content`.`area_subtitle_6`, `Content`.`conversion_type`, `Content`.`placeholder_text`, `Content`.`faq_question`, `Content`.`faq_answer`, `Content`.`foil_modal`, `Content`.`foil_video`, `Content`.`360deg_text`, `Content`.`no_answer`, (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 `rupertustherme`.`contents` AS `Content` LEFT JOIN `rupertustherme`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 139 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' LIMIT 1	1	1	1
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 `rupertustherme`.`mount_points` AS `MountPoint` LEFT JOIN `rupertustherme`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `rupertustherme`.`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

Message	Memory use
Component initialization	1.94 MB
Controller action start	3.35 MB
Controller render start	3.54 MB
Component initialization #2	5.22 MB
Controller action start #2	5.25 MB
Controller render start #2	5.37 MB
Component initialization #3	5.54 MB
Controller action start #3	5.55 MB
Controller render start #3	5.68 MB
Component initialization #4	5.81 MB
Controller action start #4	5.83 MB
Controller render start #4	5.96 MB
Component initialization #5	6.09 MB
Controller action start #5	6.11 MB
Controller render start #5	6.24 MB
Component initialization #6	6.37 MB
Controller action start #6	6.39 MB
Controller render start #6	6.51 MB
Component initialization #7	6.64 MB
Controller action start #7	6.66 MB
Controller render start #7	6.78 MB
Component initialization #8	6.91 MB
Controller action start #8	6.93 MB
Controller render start #8	7.05 MB
Component initialization #9	7.18 MB
Controller action start #9	7.20 MB
Controller render start #9	7.32 MB
View render complete	7.46 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	63.45
Event: Controller.initialize	32.39
Event: Controller.startup	2.26
Controller action	9.66
Event: Controller.beforeRender	232.60
» Processing toolbar data	49.24
Rendering View	1154.81
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	1140.72
» » Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	1140.12
» » » Event: Controller.initialize #2	1.65
» » » Event: Controller.startup #2	0.16
» » » Controller action #2	1.72
» » » Event: Controller.beforeRender #2	126.33
» » » » Processing toolbar data #2	5.18
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.03
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php	1.11
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.33
» » » » Event: View.afterRender	0.02
» » » » Event: Controller.shutdown	0.02
» » » » Event: Controller.initialize #3	1.69
» » » » Event: Controller.startup #3	0.12
» » » » Controller action #3	1.60
» » » » Event: Controller.beforeRender #3	143.43
» » » » » Processing toolbar data #3	4.35
Rendering View #3	0.00
» » » » » Event: View.beforeRender #3	0.03
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #2	1.45
» » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #2	0.36
» » » » » Event: View.afterRender #2	0.02
» » » » » Event: Controller.shutdown #2	0.02
» » » » » Event: Controller.initialize #4	1.64
» » » » » Event: Controller.startup #4	0.12
» » » » » Controller action #4	1.51
» » » » » Event: Controller.beforeRender #4	135.14
» » » » » » Processing toolbar data #4	4.08
Rendering View #4	0.00
» » » » » » Event: View.beforeRender #4	0.03
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #3	1.50
» » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #3	0.38
» » » » » » Event: View.afterRender #3	0.02
» » » » » » Event: Controller.shutdown #3	0.02
» » » » » » Event: Controller.initialize #5	1.91
» » » » » » Event: Controller.startup #5	0.17
» » » » » » Controller action #5	1.82
» » » » » » Event: Controller.beforeRender #5	131.90
» » » » » » » Processing toolbar data #5	4.68
Rendering View #5	0.00
» » » » » » » Event: View.beforeRender #5	0.05
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #4	2.34
» » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #4	0.43
» » » » » » » Event: View.afterRender #4	0.03
» » » » » » » Event: Controller.shutdown #4	0.03
» » » » » » » Event: Controller.initialize #6	2.27
» » » » » » » Event: Controller.startup #6	0.18
» » » » » » » Controller action #6	2.39
» » » » » » » Event: Controller.beforeRender #6	134.78
» » » » » » » » Processing toolbar data #6	6.85
Rendering View #6	0.00
» » » » » » » » Event: View.beforeRender #6	0.03
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #5	1.12
» » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #5	0.39
» » » » » » » » Event: View.afterRender #5	0.02
» » » » » » » » Event: Controller.shutdown #5	0.02
» » » » » » » » Event: Controller.initialize #7	1.81
» » » » » » » » Event: Controller.startup #7	0.13
» » » » » » » » Controller action #7	1.59
» » » » » » » » Event: Controller.beforeRender #7	126.98
» » » » » » » » » Processing toolbar data #7	4.27
Rendering View #7	0.00
» » » » » » » » » Event: View.beforeRender #7	0.04
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #6	0.97
» » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #6	0.32
» » » » » » » » » Event: View.afterRender #6	0.02
» » » » » » » » » Event: Controller.shutdown #6	0.02
» » » » » » » » » Event: Controller.initialize #8	2.31
» » » » » » » » » Event: Controller.startup #8	0.20
» » » » » » » » » Controller action #8	1.78
» » » » » » » » » Event: Controller.beforeRender #8	124.38
» » » » » » » » » » Processing toolbar data #8	5.10
Rendering View #8	0.00
» » » » » » » » » » Event: View.beforeRender #8	0.05
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #7	1.34
» » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #7	0.45
» » » » » » » » » » Event: View.afterRender #7	0.03
» » » » » » » » » » Event: Controller.shutdown #7	0.03
» » » » » » » » » » Event: Controller.initialize #9	2.31
» » » » » » » » » » Event: Controller.startup #9	0.19
» » » » » » » » » » Controller action #9	2.20
» » » » » » » » » » Event: Controller.beforeRender #9	134.92
» » » » » » » » » » » Processing toolbar data #9	5.98
Rendering View #9	0.00
» » » » » » » » » » » Event: View.beforeRender #9	0.03
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/article.php #8	1.32
» » » » » » » » » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php #8	0.33
» » » » » » » » » » » Event: View.afterRender #8	0.02
» » » » » » » » » » » Event: Controller.shutdown #8	0.02
» » » » » » » » » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #9	0.29
» » » » » » » » » Event: View.afterRender #9	0.28
» » » » » » » » » Event: View.beforeLayout	0.02
» » » » » » » » » Rendering APP/View/Layouts/index.php	11.65
» » » » » » » » » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.07
» » » » » » » » » » Rendering APP/View/Elements/popup.php	0.30
» » » » » » » » » » Rendering APP/View/Elements/subnavigation.php	0.40
» » » » » » » » » » Rendering APP/View/Elements/navigation.php	1.26
» » » » » » » » » » Rendering APP/View/Elements/header.php	1.79
» » » » » » » » » » » Rendering APP/View/Elements/svgs/logo.php	0.36
» » » » » » » » » » » Rendering APP/View/Elements/disturber.php	0.22
» » » » » » » » » » Rendering APP/View/Elements/fixed-sidebar.php	1.48
» » » » » » » » » » » Rendering APP/View/Elements/load.php	0.30
» » » » » » » » » » » Rendering APP/View/Elements/load.php #2	0.26
» » » » » » » » » » Rendering APP/View/Elements/footer.php	1.90
Event: View.afterLayout	0.00

Constant	Value
MH
MH_IP
BACKEND_APP_DIR	contrance
UPLOADS_APP	/var/www/vhosts/rupertustherme.de/httpdocs/contrance/
UPLOAD_TMP_DIR	tmp/uploads/

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

Daten & Fakten

Wissenswertes

AlpenSole ThermenLandschaft

Ausstattung Alpine SaunaLandschaft

FitnessCenter

WellnessCenter

THERAPIE
(durch das Kurmittelhaus der Moderne)

Ausstattung FamilienBad

default

Total Time: 51 ms
Total Queries: 157 queries

Query Explain:

Memory

Timers

Environment Variable	Value
Php Version	7.2.34
User	u3298473294789
Home	/var/www/vhosts/rupertustherme.de
Script Name	/webroot/index.php
Request Uri	/service/daten-fakten
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/service/daten-fakten
Remote Port	52034
Script Filename	/var/www/vhosts/rupertustherme.de/httpdocs/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/rupertustherme.de/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/rupertustherme.de/httpdocs
Remote Addr	216.73.217.54
Server Port	443
Server Addr	62.116.174.136
Server Name	www.rupertustherme.de
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Accept Encoding	gzip, br, zstd, deflate
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Http Connection	close
Http X Accel Internal	/internal-nginx-static-location
Http X Real Ip	216.73.217.54
Http Host	www.rupertustherme.de
Proxy-nokeepalive	1
Ssl Tls Sni	www.rupertustherme.de
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Script Uri	https://www.rupertustherme.de/service/daten-fakten
Script Url	/service/daten-fakten
Unique Id	apHZTlgaXH2jdC8zB6qOOQAAAgQ
Redirect Status	200
Redirect Ssl Tls Sni	www.rupertustherme.de
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Script Uri	https://www.rupertustherme.de/service/daten-fakten
Redirect Script Url	/service/daten-fakten
Redirect Unique Id	apHZTlgaXH2jdC8zB6qOOQAAAgQ
Redirect Redirect Status	200
Redirect Redirect Ssl Tls Sni	www.rupertustherme.de
Redirect Redirect Https	on
Redirect Redirect Passenger Download Native Support Binary	0
Redirect Redirect Passenger Compile Native Support Binary	0
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Script Uri	https://www.rupertustherme.de/service/daten-fakten
Redirect Redirect Script Url	/service/daten-fakten
Redirect Redirect Unique Id	apHZTlgaXH2jdC8zB6qOOQAAAgQ
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1787943246.7613
Request Time	1787943246

Daten & Fakten

Wissenswertes

AlpenSole ThermenLandschaft

Ausstattung Alpine SaunaLandschaft

FitnessCenter

WellnessCenter

THERAPIE (durch das Kurmittelhaus der Moderne)

Ausstattung FamilienBad

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 51 ms Total Queries: 157 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

THERAPIE
(durch das Kurmittelhaus der Moderne)

Total Time: 51 ms
Total Queries: 157 queries