Chamanna d'Es-cha
Bernina Gruppe, 2.594 m
Stützpunkt in den Albula Alpen

Die Chamanna d’Es-Cha ist eine Schweizer Schutzhütte in den Bündner Alpen. Die Hütte der Sektion Bernina genießt man einen traumhaften Blick über die Gebirgszüge der namensgebenden Gebirgsregion Bernina, welche nach Süden hin eindrücklich in der Ferne thront. Die Verpflegung ist hervorragend und serviert werden regionale Spezialitäten. Die gemütliche Gaststube ist ein hervorragender Platz, um zu verweilen und entspannte Stunden auf der Berghütte zu verbringen. Die Wirtsleute sind ausgesprochen gastfreundlich und bei einem Aufenthalt bleiben keine Wünsche offen. Von der Hütte aus sind zahlreiche Wanderungen, Bergtouren, Trekkingtouren und im Winter Ski- und Schneeschuhtouren möglich. Unsere Bergführer nutzen die Chamanna d’Es-Cha für geführte Touren in den Berner Alpen.

Alle 15 Fotos ansehen

Öffnungszeiten

Jan

Feb

Mar

Apr

Mai

Jun

Jul

Aug

Sep

Okt

Nov

Dez

Ausstattung

Waschmöglichkeit

Handyempfang

Vegetarische Speisen

Mehrbettzimmer

Matratzenlager

Trockenraum

Währung & Bezahlung

Barzahlung

CHF

Währung: Schweizer Franken

Standort der Unterkunft

Reisen mit der Unterkunft Chamanna d'Es-cha Diese Unterkunft besuchen wir auf folgenden Reisen

Rund um den Piz Bernina | Wandern auf dem Bernina Trek

Im Angesicht von Eis und Schnee, umgeben von Eisriesen wie Piz Palü und Piz Bernina, dem einzigen Viertausender der Ostalpen. Wanderwoche in der Bernina auf dem Bernina Trek in der Schweiz - eine der eindrücklichsten Weitwanderungen Graubündens.

Cookie Einstellungen

Wir setzen automatisiert nur technisch notwendige Cookies, deren Daten von uns nicht weitergegeben werden und ausschließlich zur Bereitstellung der Funktionalität dieser Seite dienen.

Außerdem verwenden wir Cookies, die Dein Verhalten beim Besuch der Webseiten messen, um das Interesse unserer Besucher besser kennen zu lernen. Wir erheben dabei nur pseudonyme Daten, eine Identifikation Deiner Person erfolgt nicht.

Weitere Informationen findest Du in unserer Datenschutzerklärung.

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentbb9a308b4a34371b6683a620bd245ed7
  time1730434690
  countdown10
- _Token(array)
  key0027b35ccc4a5aec75e133fd06d97df20e81e7f59676c60b9fc59d1025e238e3c9cd6d79b35d8973e627c4d35a4be868c51117c16a7e2887da7ddd560623a224
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  0027b35ccc4a5aec75e133fd06d97df20e81e7f59676c60b9fc59d1025e238e3c9cd6d79b35d8973e627c4d35a4be868c51117c16a7e2887da7ddd560623a2241730422090
====
Request
+
Request

Cake Params
- pluginFrontendAccomodations
- controllerFrontendAccomodations
- actionaccomodation
- named(empty)
- pass(array)
  066
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  Accomodation66
- route(array)
  id4217
  hashedb65e1066522adf85fd54161e4bb782
  created2020-08-20 12:05:41
  updated2024-07-18 16:15:21
  modelAccomodation
  foreign_key66
  base/
  aliaschamanna-d-es-cha
  controllerFrontendAccomodations.FrontendAccomodations
  actionaccomodation
  parent_id(null)
  lft6181
  rght6182
  route/chamanna-d-es-cha
- isAjax(false)
- _Token(array)
  key0027b35ccc4a5aec75e133fd06d97df20e81e7f59676c60b9fc59d1025e238e3c9cd6d79b35d8973e627c4d35a4be868c51117c16a7e2887da7ddd560623a224
  unlockedFields(empty)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

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

Sql Log

Sql Logs

default

Total Time: 25 ms
Total Queries: 142 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`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`))) = '/chamanna-d-es-cha' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 6181 AND `Route`.`rght` >= 6182 ORDER BY `Route`.`lft` asc	1	1	3	maybe slow
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `alpinewelten`.`settings` AS `Setting` LEFT JOIN `alpinewelten`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	52	52	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 `alpinewelten`.`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, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`languages` AS `Language` WHERE `Language`.`title` = 'www.alpinewelten.com' LIMIT 1	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'faq' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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 `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 87 AND `Menu`.`rght` < 88 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'down_payment_reminder' LIMIT 1	0	0	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'remaining_payment_reminder' LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 16 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'EmailTemplate' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'default' AND `EmailTemplate`.`status_value` = 'warning' LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 26 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'EmailTemplate' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT `Accomodation`.`id`, `Accomodation`.`hash`, `Accomodation`.`created`, `Accomodation`.`updated`, `Accomodation`.`number`, `Accomodation`.`name`, `Accomodation`.`type`, `Accomodation`.`owners`, `Accomodation`.`phone_cabin`, `Accomodation`.`phone_valley`, `Accomodation`.`mobile`, `Accomodation`.`fax`, `Accomodation`.`email`, `Accomodation`.`url`, `Accomodation`.`zip`, `Accomodation`.`city`, `Accomodation`.`street`, `Accomodation`.`country`, `Accomodation`.`region_area_id`, `Accomodation`.`remark`, `Accomodation`.`geopoint_lat`, `Accomodation`.`geopoint_long`, `Accomodation`.`cancellation_period`, `Accomodation`.`tighter_cancellation_period`, `Accomodation`.`status`, `Accomodation`.`subline`, `Accomodation`.`height`, `Accomodation`.`video_url`, `Accomodation`.`opening_hours`, `Accomodation`.`premises`, `Accomodation`.`equipment`, `Accomodation`.`currency`, `Accomodation`.`detail_description`, `Accomodation`.`days_before_to_send_participant_list`, `Accomodation`.`country_id`, `Accomodation`.`url_booking_system`, `Accomodation`.`importance`, `Accomodation`.`participant_list_necessary`, `Accomodation`.`reservation_through_agency`, `Accomodation`.`reduction_not_necessary`, (CONCAT_WS (',',`Accomodation`.`geopoint_lat`,`Accomodation`.`geopoint_long`)) AS `Accomodation__geopoint`, `RegionArea`.`id`, `RegionArea`.`hash`, `RegionArea`.`created`, `RegionArea`.`updated`, `RegionArea`.`title`, `RegionArea`.`region_id`, `Country`.`id`, `Country`.`hash`, `Country`.`created`, `Country`.`updated`, `Country`.`title`, `Country`.`abbreviation`, `Country`.`subtitle`, `Country`.`link_embassy_german`, `Country`.`link_embassy_austrian`, `Country`.`link_embassy_swiss`, `Country`.`link_embassy_italian`, `Country`.`best_travel_season`, `Country`.`general`, `Country`.`security`, `Country`.`nature_climate`, `Country`.`travel_info`, `Country`.`entry_customs`, `Country`.`visa`, `Country`.`health`, `Country`.`tours_summer`, `Country`.`tours_winter`, `Country`.`microsite_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`, `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`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`accomodations` AS `Accomodation` LEFT JOIN `alpinewelten`.`region_areas` AS `RegionArea` ON (`Accomodation`.`region_area_id` = `RegionArea`.`id`) LEFT JOIN `alpinewelten`.`countries` AS `Country` ON (`Accomodation`.`country_id` = `Country`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Accomodation`.`id` AND `Route`.`model` = 'Accomodation') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Accomodation`.`id` AND `Seo`.`model` = 'Accomodation') WHERE `Accomodation`.`id` = 66 LIMIT 1	1	1	4	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 182 AND `Route`.`model` = 'Country'	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 `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Country' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (182) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TeaserMedia`.`id`, `TeaserMedia`.`hash`, `TeaserMedia`.`created`, `TeaserMedia`.`updated`, `TeaserMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserMedia`.`id`) AS `TeaserMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 66 AND `MediaEntity`.`media_id` = `TeaserMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'teaser' 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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9791) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	1	maybe slow
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `GalleryMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 66 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	15	15	1	maybe slow
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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (9791, 9778, 9781, 9783, 9779, 9790, 9786, 9784, 9780, 9789, 9777, 9782, 9785, 9787, 9788) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	109	109	3
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 66 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Accomodation' AND `TagEntity`.`field` = 'tags'	0	0	1	maybe slow
SELECT `TravelReport`.`id`, `TravelReport`.`hash`, `TravelReport`.`created`, `TravelReport`.`updated`, `TravelReport`.`title`, `TravelReport`.`status`, `TravelReport`.`release`, `TravelReport`.`hide`, `TravelReport`.`alias`, `TravelReport`.`country_id`, `TravelReport`.`tour_id`, `TravelReport`.`user_id`, `TravelReport`.`publishing_date`, `TravelReport`.`menu_id`, `TravelReport`.`category`, `TravelReport`.`external_url`, `TravelReport`.`hide_publication`, (NOW() BETWEEN COALESCE(`TravelReport`.`release`, NOW()) AND COALESCE(`TravelReport`.`hide`, NOW())) AS `TravelReport__published`, `AccomodationsTravelReport`.`id`, `AccomodationsTravelReport`.`accomodation_id`, `AccomodationsTravelReport`.`travel_report_id`, `AccomodationsTravelReport`.`position` FROM `alpinewelten`.`travel_reports` AS `TravelReport` JOIN `alpinewelten`.`accomodations_travel_reports` AS `AccomodationsTravelReport` ON (`AccomodationsTravelReport`.`accomodation_id` = 66 AND `AccomodationsTravelReport`.`travel_report_id` = `TravelReport`.`id`) ORDER BY `TravelReport`.`publishing_date` DESC	0	0	0
SELECT `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, `Tour`.`covid_note`, `Tour`.`importance`, `Tour`.`internal_mark`, `Tour`.`responsible_user_id`, `Tour`.`is_service_event`, `Tour`.`partner_title`, `Tour`.`pay_later_hint`, `Tour`.`event_duration`, `Tour`.`distance`, `Tour`.`ascent`, `Tour`.`descent`, `Tour`.`destination_menu_id`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight`, `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview`, `TourTexts`.`ws_text_advantages`, `TourTexts`.`ws_text_detail_description_new`, `TourTexts`.`ws_text_information_new`, `TourTexts`.`ws_text_accomodation_new`, `TourTexts`.`ws_text_arrival`, `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 `alpinewelten`.`tours` AS `Tour` LEFT JOIN `alpinewelten`.`tour_texts` AS `TourTexts` ON (`TourTexts`.`tour_id` = `Tour`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Tour`.`id` AND `Route`.`model` = 'Tour') JOIN `alpinewelten`.`accomodations_tours` AS `AccomodationTours` ON (`AccomodationTours`.`accomodation_id` = '66' AND `AccomodationTours`.`tour_id` = `Tour`.`id`) WHERE 1 = 1 GROUP BY `Tour`.`id` ORDER BY (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) DESC	1	1	3	maybe slow
SELECT `Types`.`id`, `Types`.`hash`, `Types`.`created`, `Types`.`updated`, `Types`.`title`, `Types`.`oa_categories`, `Types`.`use_for_mountain_guide_tour_search`, `Types`.`tour_main_type_id`, (SELECT COUNT(1) FROM tour_types_tours AS TourTypeCrossTab WHERE `TourTypeCrossTab`.`tour_type_id` = `Types`.`id`) AS `Types__tour_count`, `TourTypesTour`.`id`, `TourTypesTour`.`tour_id`, `TourTypesTour`.`tour_type_id` FROM `alpinewelten`.`tour_types` AS `Types` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = 147 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	1	1	0
SELECT `TourMainType`.`id`, `TourMainType`.`hash`, `TourMainType`.`created`, `TourMainType`.`updated`, `TourMainType`.`title`, `TourMainType`.`position`, `TourMainType`.`packing_list_text_start`, `TourMainType`.`packing_list_text_end` FROM `alpinewelten`.`tour_main_types` AS `TourMainType` WHERE `TourMainType`.`id` = 3	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'TourMainType' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (3) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 147 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (9181) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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 `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 252 AND `Menu`.`rght` < 311 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	29	29	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (6, 649, 652, 656, 127, 701, 106, 655, 648, 966, 91, 884, 885, 663, 670, 669, 668, 667, 666, 664, 750, 752, 751, 761, 847, 848, 849, 851, 972) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_more' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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 `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 312 AND `Menu`.`rght` < 325 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	6	6	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (34, 35, 36, 37, 38, 94) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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 `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Firm`.`id`, `Firm`.`hash`, `Firm`.`created`, `Firm`.`updated`, `Firm`.`title`, `Firm`.`abbreviation`, `Firm`.`oa_offerer_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` FROM `alpinewelten`.`languages` AS `Language` LEFT JOIN `alpinewelten`.`firms` AS `Firm` ON (`Language`.`firm_id` = `Firm`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	4	4	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 `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2, 3, 4) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	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`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Accomodation' AND `Seo`.`foreign_key` = 66 LIMIT 1	1	1	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4057 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	1
SELECT `TourType`.`id`, `TourType`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) WHERE 1 = 1 GROUP BY `TourType`.`id` ORDER BY `TourType`.`title` ASC	40	40	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_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`, `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`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`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 `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 204 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3217) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2312) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 1 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'text_search' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_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`, `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`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 7 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 210 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 `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 9 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 7 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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 `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 38 AND `Menu`.`rght` < 167 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	40	40	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (690, 774, 775, 864, 842, 843, 853, 854, 855, 856, 857, 858, 844, 867, 845, 875, 861, 776, 797, 795, 796, 801, 802, 803, 777, 872, 869, 873, 874, 778, 779, 859, 781, 780, 783, 881, 882, 608, 607, 606) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	5	5	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'tour_list' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 168 AND `Menu`.`rght` < 251 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	41	41	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (8, 9, 20, 637, 19, 27, 10, 559, 580, 753, 968, 12, 13, 14, 21, 22, 30, 29, 521, 31, 53, 72, 588, 73, 23, 75, 76, 484, 15, 16, 17, 18, 49, 50, 51, 841, 68, 63, 58, 57, 600) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	37	37	0
SELECT `Highlight`.`id`, `Highlight`.`hash`, `Highlight`.`created`, `Highlight`.`updated`, `Highlight`.`status`, `Highlight`.`type`, `Highlight`.`tour_id`, `Highlight`.`manually_title`, `Highlight`.`manually_text`, `Highlight`.`manually_button_label`, `Highlight`.`manually_link`, `Highlight`.`position`, `Highlight`.`language_id`, `Highlight`.`manually_target_blank`, `Highlight`.`menu_id`, `Highlight`.`teaser_home_header`, `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, `Tour`.`covid_note`, `Tour`.`importance`, `Tour`.`internal_mark`, `Tour`.`responsible_user_id`, `Tour`.`is_service_event`, `Tour`.`partner_title`, `Tour`.`pay_later_hint`, `Tour`.`event_duration`, `Tour`.`distance`, `Tour`.`ascent`, `Tour`.`descent`, `Tour`.`destination_menu_id`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight` FROM `alpinewelten`.`highlights` AS `Highlight` LEFT JOIN `alpinewelten`.`tours` AS `Tour` ON (`Highlight`.`tour_id` = `Tour`.`id`) WHERE `Highlight`.`type` = 'tour' AND `Highlight`.`teaser_home_header` = '1' AND `Highlight`.`language_id` = 1 ORDER BY `position` ASC	10	10	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 25 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (65) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 217 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 217 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (12264) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 544 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 544 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (14258) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 219 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 219 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (841) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	15	15	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 73 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 73 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4175) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 253 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 253 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4120) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 204 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 204 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4804) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 213 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 213 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (12889) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 470 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 470 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3964) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	19	19	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 `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 28 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 28 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_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 `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (612) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `TourMainTypes`.`id`, `TourMainTypes`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) JOIN `alpinewelten`.`tour_main_types` AS `TourMainTypes` ON (`TourMainTypes`.`id` = `TourType`.`tour_main_type_id`) WHERE 1 = 1 ORDER BY `TourMainTypes`.`position` ASC	604	604	0
SELECT `Microsite`.`id`, `Microsite`.`hash`, `Microsite`.`created`, `Microsite`.`updated`, `Microsite`.`status`, `Microsite`.`title`, `Microsite`.`url`, `Microsite`.`position`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`microsites` AS `Microsite` LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Microsite`.`id` AND `Teaser`.`model` = 'Microsite') WHERE 1 = 1	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2951 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (52) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2952 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (459) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2953 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (688) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2954 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5427) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2955 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2275) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_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`, `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`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 774 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5685 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 `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4208 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (774) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (774) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 774 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 774 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `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`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 89 AND `Menu`.`rght` < 166 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	38	38	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (775, 864, 842, 843, 853, 854, 855, 856, 857, 858, 844, 867, 845, 875, 861, 776, 797, 795, 796, 801, 802, 803, 777, 872, 869, 873, 874, 778, 779, 859, 781, 780, 783, 881, 882, 608, 607, 606) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage_mountainguides' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_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`, `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`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 796 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5712 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 `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4235 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (796) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (796) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 796 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 796 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_partner' AND `Language`.`langid` = 'aw' LIMIT 1	0	0	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'search' AND `Language`.`langid` = 'aw' 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`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_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`, `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`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 11 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 218 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (471) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`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 `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 17 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 11 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 11 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'accomodations_index' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' 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	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`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'myclimate' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'travel_reports_index' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 21.97 MB

Message	Memory use
Component initialization	2.41 MB
Controller action start	3.46 MB
Controller render start	7.81 MB
View render complete	11.70 MB

Timers

Total Request Time: 475 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	25.26
Event: Controller.initialize	14.64
Event: Controller.startup	1.13
Controller action	98.48
Event: Controller.beforeRender	136.92
» Processing toolbar data	79.64
Rendering View	80.09
» Event: View.beforeRender	0.05
» Rendering APP/Plugin/FrontendAccomodations/View/FrontendAccomodations/accomodation.php	21.85
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php	1.38
» » Rendering APP/View/Elements/icon.php	1.33
» » Rendering APP/Plugin/FrontendContents/View/Elements/gallery_mosaic.php	1.19
» » Rendering APP/View/Elements/icon.php #2	1.33
» » Rendering APP/View/Elements/icon.php #3	1.23
» » Rendering APP/View/Elements/icon.php #4	1.18
» » Rendering APP/View/Elements/icon.php #5	1.27
» » Rendering APP/View/Elements/icon.php #6	1.13
» » Rendering APP/View/Elements/icon.php #7	1.07
» » Rendering APP/View/Elements/icon.php #8	1.06
» » Rendering APP/Plugin/FrontendTours/View/Elements/teaser_slider.php	5.54
» » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php	1.12
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php	0.30
» » » Rendering APP/View/Elements/icon.php #9	1.56
» » » Rendering APP/View/Elements/icon.php #10	0.41
» » » Rendering APP/View/Elements/icon.php #11	1.58
» Event: View.afterRender	0.14
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/1.php	55.89
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.82
» » Rendering APP/View/Elements/header/header.php	32.34
» » » Rendering APP/View/Elements/header/header_navbar.php	32.06
» » » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.13
» » » » Rendering APP/View/Elements/navigation_secondary.php	6.51
» » » » » Rendering APP/View/Elements/icon.php #12	1.74
» » » » » Rendering APP/View/Elements/icon.php #13	0.39
» » » » » Rendering APP/View/Elements/icon.php #14	0.37
» » » » » Rendering APP/View/Elements/icon.php #15	1.71
» » » » Rendering APP/View/Elements/navigation.php	22.74
» » » » » Rendering APP/View/Elements/icon.php #16	0.40
» » » » » Rendering APP/View/Elements/icon.php #17	0.37
» » » » » Rendering APP/View/Elements/icon.php #18	0.36
» » » » » Rendering APP/View/Elements/icon.php #19	0.36
» » » » » Rendering APP/View/Elements/icon.php #20	0.49
» » » » » Rendering APP/View/Elements/icon.php #21	0.35
» » » » » Rendering APP/View/Elements/icon.php #22	0.41
» » » » » Rendering APP/View/Elements/icon.php #23	0.31
» » » » » Rendering APP/View/Elements/icon.php #24	0.31
» » » » » Rendering APP/View/Elements/icon.php #25	0.30
» » » » » Rendering APP/View/Elements/icon.php #26	0.49
» » » » » Rendering APP/View/Elements/icon.php #27	0.32
» » » » » Rendering APP/View/Elements/icon.php #28	0.32
» » » » » Rendering APP/View/Elements/icon.php #29	0.44
» » » » » Rendering APP/View/Elements/icon.php #30	0.33
» » » » » Rendering APP/View/Elements/icon.php #31	0.38
» » » » » Rendering APP/View/Elements/icon.php #32	0.32
» » » » » Rendering APP/View/Elements/icon.php #33	0.39
» » » » » Rendering APP/View/Elements/icon.php #34	0.32
» » » » » Rendering APP/View/Elements/icon.php #35	0.39
» » » » » Rendering APP/View/Elements/icon.php #36	0.31
» » » » » Rendering APP/View/Elements/icon.php #37	0.41
» » » » » Rendering APP/View/Elements/icon.php #38	0.34
» » » » » Rendering APP/View/Elements/icon.php #39	0.34
» » » » » Rendering APP/View/Elements/icon.php #40	0.31
» » » » » Rendering APP/View/Elements/icon.php #41	0.32
» » » » » Rendering APP/View/Elements/icon.php #42	0.32
» » » » » Rendering APP/View/Elements/icon.php #43	0.33
» » » » » Rendering APP/View/Elements/icon.php #44	0.41
» » » » » Rendering APP/View/Elements/icon.php #45	0.32
» » » » » Rendering APP/View/Elements/icon.php #46	0.38
» » » » » Rendering APP/View/Elements/icon.php #47	0.32
» » » » » Rendering APP/View/Elements/icon.php #48	0.42
» » » » » Rendering APP/View/Elements/icon.php #49	0.33
» » » » » Rendering APP/View/Elements/icon.php #50	0.40
» » » » » Rendering APP/View/Elements/icon.php #51	0.32
» » » » » Rendering APP/View/Elements/icon.php #52	0.44
» » » » » Rendering APP/View/Elements/icon.php #53	0.34
» » » » » Rendering APP/View/Elements/icon.php #54	0.35
» » » » » Rendering APP/View/Elements/icon.php #55	0.47
» » » » » Rendering APP/View/Elements/icon.php #56	0.33
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php #2	0.96
» » Rendering APP/View/Elements/footer/footer.php	11.16
» » » Rendering APP/View/Elements/icon.php #57	1.49
» » » Rendering APP/View/Elements/icon.php #58	1.49
» » » Rendering APP/View/Elements/logos/logo-instagram.php	0.13
» » » Rendering APP/View/Elements/logos/logo-youtube.php	0.11
» » » Rendering APP/View/Elements/logos/logo-facebook.php	0.12
» » » Rendering APP/View/Elements/logos/logo-alpine-welten.php #2	0.11
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php	0.12
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php	0.12
» » » Rendering APP/View/Elements/footer/footer_newsletter_subscribe.php	0.31
» » » Rendering APP/View/Elements/logos/logo-adidas-terrex.php	0.11
» » » Rendering APP/View/Elements/logos/logo-adidas-eyewear.php	0.21
» » » Rendering APP/View/Elements/logos/logo-petzl.php	0.09
» » » Rendering APP/View/Elements/logos/logo-pieps.php	0.08
» » » Rendering APP/View/Elements/logos/logo-kaestle.php	0.08
» » » Rendering APP/View/Elements/logos/logo-diamir.php	0.08
» » » Rendering APP/View/Elements/logos/logo-komperdell.php	0.22
» » » Rendering APP/View/Elements/logos/logo-scarpa.php	0.10
» » » Rendering APP/View/Elements/logos/logo-exped.php	0.10
» » » Rendering APP/View/Elements/logos/logo-abs.php	0.08
» » » Rendering APP/View/Elements/logos/logo-hilleberg.php	0.08
» » Rendering APP/View/Elements/contact_widget.php	6.60
» » » Rendering APP/View/Elements/icon.php #59	1.28
» » » Rendering APP/View/Elements/icon.php #60	1.08
» » » Rendering APP/View/Elements/icon.php #61	1.15
» » » Rendering APP/View/Elements/icon.php #62	1.05
» » » Rendering APP/View/Elements/icon.php #63	1.16
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- accomodation(array)
 Accomodation(array)
 id66
 hashd84d3d95248ec17b4912cdb9e3c42fa2
 created2015-12-02 09:27:03
 updated2024-07-18 16:15:21
 number900066
 nameChamanna d'Es-cha
 typecabin
 ownersSilvana Ulmann, Nicola Schwab
 phone_cabin+41 81 854 17 55
 phone_valleyA
 mobile+41 79 336 25 55
 fax
 emailinfo@es-cha.ch
 urlhttp://www.es-cha.com/
 zip6143
 cityOhmstal
 streetHübeli
 countryCH
 region_area_id25
 remarkinfo@es-cha.ch
 geopoint_lat46.611446
 geopoint_long9.902907
 cancellation_period3
 tighter_cancellation_period(false)
 statusactive
 sublineStützpunkt in den Albula Alpen
 height2.594
 video_url
 opening_hours1006
 premisesDie Chamanna d’Es-Cha ist eine Schweizer Schutzhütte in den Bündner Alpen. Die Hütte der Sektion Bernina genießt man einen traumhaften Blick über die Gebirgszüge der namensgebenden Gebirgsregion Bernina, welche nach Süden hin eindrücklich in der Ferne thront. Die Verpflegung ist hervorragend und serviert werden regionale Spezialitäten. Die gemütliche Gaststube ist ein hervorragender Platz, um zu verweilen und entspannte Stunden auf der Berghütte zu verbringen. Die Wirtsleute sind ausgesprochen gastfreundlich und bei einem Aufenthalt bleiben keine Wünsche offen. Von der Hütte aus sind zahlreiche Wanderungen, Bergtouren, Trekkingtouren und im Winter Ski- und Schneeschuhtouren möglich. Unsere Bergführer nutzen die Chamanna d’Es-Cha für geführte Touren in den Berner Alpen.
 equipment13837
 currency2
 detail_description
 days_before_to_send_participant_list(null)
 country_id182
 url_booking_systemhttps://www.alpsonline.org/reservation/calendar?hut_id=25&lang=de_CH&header=yes
 importancenone
 participant_list_necessary(false)
 reservation_through_agency(false)
 reduction_not_necessary(false)
 geopoint46.611446,9.902907
 RegionArea(array)
 id25
 hashb9fda5d665c22286f2f6bcd3cf617003
 created2015-11-30 19:51:37
 updated2018-11-28 16:17:07
 titleBernina Gruppe
 region_id4
 Country(array)
 id182
 hashddc767fea0846fa09b0aac1adb571630
 created2016-06-01 17:35:19
 updated2024-08-15 14:28:17
 titleSchweiz
 abbreviationCH
 subtitleZwischen wildromantischen Tälern und mächtigen Viertausendern
 link_embassy_germanhttps://www.auswaertiges-amt.de/de/aussenpolitik/laender/schweiz-node/schweizsicherheit/206208
 link_embassy_austrianhttps://www.bmeia.gv.at/reise-aufenthalt/reiseinformation/land/schweiz/
 link_embassy_swisshttps://www.eda.admin.ch/eda/de/home.html
 link_embassy_italianhttp://www.viaggiaresicuri.mae.aci.it/country/CHE
 best_travel_season3071
 generalStand: 12.08.2020 <h2 style="text-align:center">Allgemeines</h2> Die Schweiz liegt in der Mitte Europas und ist eingerahmt von Deutschland im Norden, Österreich und Liechtenstein im Osten, Italien im Süden sowie Ungarn und Frankreich im Westen. Mit einer Fläche von gut 41.000 Quadratkilometern und ca. 8,6 Millionen Einwohnern ist die Schweiz relativ dicht besiedelt. Ausnahmen bilden hier jedoch die Bergregionen, die in der Schweiz bis auf über 4.600 m aufragen und deren ungenutzte Fläche insgesamt ein Viertel der gesamten Landesfläche ausmacht. Die bekanntesten Gipfel der Schweizer Alpen sind allen voran sicherlich das Matterhorn (4.478 m) in Zermatt sowie das Berner Dreigestirn Eiger (3.970 m), Mönch (4.107 m) und Jungfrau (4.158 m) im Berner Oberland. Die höchsten Gipfel der Schweiz liegen jedoch im Wallis, der höchste ist mit 4.637 m die Dufourspitze im Monte Rosa Massiv. So wie im "Goldenen Zeitalter des Alpinismus" Mitte des 19. Jahrhunderts, ziehen die hohen Schweizer Berge aber auch heute noch Bergsteiger aus der ganzen Welt in ihren Bann - Jahr für Jahr, sommers wie winters. In der Schweiz wird - je nach Region - neben Deutsch auch vorwiegend Französisch und Italienisch gesprochen sowie in Graubünden Rätoromanisch. Alle vier Sprachen sind Amtssprachen in der Schweiz. Die größte Stadt ist Zürich mit ca. 415.000 Einwohnern, Hauptstadt der föderalen Republik ist jedoch Bern - mit ca. 134.000 Einwohnern deutlich kleiner. Nationalfeiertag ist der Gründungstag der Schweizerischen Eidgenossenschaft am 01. August. <h3 style="text-align:center">Währung & Bezahlung</h3> Die Schweiz gehört nicht zur EU, jedoch zum Schengen Raum. Die Schweizer Landeswährung ist der Schweizer Franken (CHF). Es kann manchmal auch in Euro gezahlt werden, das Wechselgeld erfolgt dann jedoch in Franken. Normalerweise kann man fast überall mit einer EC-Karte am Geldautomaten Bargeld abheben oder elektronisch mit EC-Karte oder Kreditkarte bezahlen. Auf Berghütten gilt dies jedoch meist nicht und es ist nur Barzahlung möglich. Daher sollte auf Bergtouren in der Schweiz immer genügend Bargeld - und zwar in Schweizer Franken - in der Tasche sein. Hier findest Du einen <a href="https://www1.oanda.com/lang/de/currency/converter/" target="_blank">Währungsrechner</a>.
 security<h2 style="text-align:center">Sicherheit</h2> Generell ist die Schweiz ein sehr sicheres Reiseland im Schengen Raum. Die Kriminalität ist als GERING einzustufen.
 nature_climate<h2 style="text-align:center">Natur & Klima</h2> Aufgrund ihrer Topographie und ihrer geographischen Lage gibt es zahlreiche außergewöhnliche Naturschauplätze in der Schweiz. Flora und Fauna sind sehr vielfältig und artenreich. Wälder überziehen etwa ein Drittel der Schweizer Landesfläche. In den Niederungen sind dies Laub- und Mischwälder, während in den Alpen Nadelwälder dominieren, die dort die wichtige Aufgabe haben, vor Lawinen und Hochwasser zu schützen. Idyllische Seen, tosende Flüsse, Schluchten und Wasserfälle sowie die einzigartige Berg- und Gletscherwelt prägen die Natur der Schweiz. Einige davon sind sogar auf der UNESCO Weltnaturerbeliste, wie z. B. die Aletschgletscher- und Jungfrauregion oder das wild-romantische Val Müstair. Die Schweiz gehört zwar generell zur gemäßigten Klimazone, aufgrund der Topographie des Landes und damit verbundener großer Höhenunterschiede können sich die klimatischen Bedingungen jedoch sehr unterscheiden. Das Schweizer Klima wird jedoch nicht nur von den Alpen geprägt, sondern auch vom Atlantik und Mittelmeer. Der Atlantik bringt feuchte, milde Strömungen in die Regionen nördlich der Alpen. Am Alpenkamm können sich im Sommer häufig Gewitter bilden. Die Alpensüdseite hingegen wird hauptsächlich vom Mittelmeer beeinflusst und hat somit ein mediterranes Klima mit milderen Wintern. Somit bilden die Alpen quasi eine Klimascheide zwischen Nord- und Südschweiz. Dadurch fällt in den inneralpinen Tälern ganzjährig eher wenig Niederschlag und bildet so relativ trockene Regionen. Zu diesen trockenen Tälern zählen zum Beispiel das Wallis oder das Engadin. Im Winter fällt der Niederschlag in Höhen ab 1.500 m Höhe vorwiegend als Schnee, während das Flachland weitestgehend schneefrei bleibt. Die Winter im Gebirge sind sehr kalt und schneereich. Auf vielen Schweizer Bergen liegt ganzjährig Schnee. Der Föhn, der warme Fallwinde und milde Temperaturen bringt, tritt hauptsächlich von Herbst bis ins Frühjahr auf. Auch Nebel ist eine häufige Erscheinung in der kalten Jahreshälfte. Bei Hochnebel können oft Inversionen entstehen, was bedeutet, dass es z. B. im Gebirge über der Hochnebeldecke wärmer ist als darunter. Verschiedene Wetterdienste geben einen ganz guten Überblick über das aktuelle Bergwetter in der Schweiz. Sie können Dir dabei helfen, Dich auf Deine Bergtour in der Schweiz entsprechend vorzubereiten: <ul> <li style="text-align:justify"><a href="https://www.meteoschweiz.admin.ch/home.html?tab=overview" target="_blank">MeteoSchweiz</a></li> <li style="text-align:justify"><a href="https://www.alpenverein.de/DAV-Services/Bergwetter/Berner-Oberland-Appenzeller-Land-Glarner-Alpen/#2020-07-20|weatherLayer" target="_blank">DAV Bergwetter</a></li> <li style="text-align:justify"><a href="https://www.bergfex.ch/schweiz/wetter/" target="_blank">Bergfex Bergwetter</a></li> </ul>
 travel_info
 entry_customs<h2 style="text-align:center">Einreise & Zoll</h2> Bei Grenzübertritten sind stichprobenartige Personen- und Fahrzeugkontrollen möglich. Ansonsten sind Einschränkungen bei der Einreise generell als gering einzustufen. Auf Schweizer Autobahnen gilt Vignettenpflicht! Verkehrsverstöße (z. B. fehlende Vignette, überhöhte Geschwindigkeit) werden mit hohen Strafen belegt. Der öffentliche Personenfern- und -nahverkehr mit Bussen und Bahnen ist in der Schweiz sehr gut ausgebaut. Da die Schweiz nicht zur EU gehört, gilt die Grenze zur Schweiz als EU-Außengrenze und unterliegt entsprechenden Bestimmungen zur Warenein- und -ausfuhr. Informationen dazu liefert die <a href="https://www.ezv.admin.ch/ezv/de/home/information-private.html" target="_blank">Eidgenössische Zollverwaltung EZV</a>. <ul> <li style="text-align:justify">Tipp: <a href="https://www.bundesfinanzministerium.de/Web/DE/Service/Apps_Rechner/Zoll-Reise-App/zoll-reise-app.html" target="_blank">App „Zoll und Reise“</a></li> </ul> <h3 style="text-align:center">Reisedokumente</h3> Die Einreise ist für Staatsangehörige D | A | I mit folgenden Dokumenten möglich. <ul> <li style="text-align:justify">Personalausweis</li> <li style="text-align:justify">Reisepass</li> </ul> (!) Reisedokumente müssen für die gesamte Dauer des Aufenthalts gültig sein!
 visa<h2 style="text-align:center">Visum</h2> Staatsangehörige D | A | I können ohne Visum in die Schweiz einreisen. Informationen zu den aktuellen Einreisebestimmungen für eine Reise in die Schweiz findest Du auch beim <a href="https://www.eda.admin.ch/eda/de/home.html" target="_blank">Eidgenössischen Departement für auswärtige Angelegenheiten EDA</a>. Staatsangehörige mit anderen Nationalitäten Detaillierte Informationen zu den jeweiligen Einreise- und Visabestimmungen stellen wir zur Verfügung, sobald uns Deine Nationalität bekannt ist.
 health<h2 style="text-align:center">Gesundheit</h2> Die medizinische Versorgung ist in der Schweiz generell sehr gut. Die zentrale Notrufnummer in der Schweiz lautet 112, auch für die alpine Bergrettung. Über die 144 erreicht man den Rettungsdienst bei medizinischen Notfällen. Die Schweizer Rettungsflugwacht Rega kann innerhalb der Schweiz über die 1414 kontaktiert werden bzw. mit einer SIM-Karte eines nicht-schweizerischen Netzbetreibers über +41 333 333 333. <h3 style="text-align:center">Impfungen</h3> Für die Einreise in die Schweiz gibt es keine Pflichtimpfungen! Grundsätzlich empfehlen sich für weltweite Bergreisen eine Immunisierung gegen Polio, Diphtherie, Keuchhusten und Tetanus. Für weiterführende Informationen zur Reisemedizin empfehlen wir das <a href="https://www.crm.de/aktuell/" target="_blank">Centrum für Reisemedizin (CRM)</a>.
 tours_summer<h2 style="text-align:center">Tourenmöglichkeiten im Sommer</h2> Die Schweiz bietet im Sommer eine Spielwiese für nahezu alle Bergsportarten! Auch das Bergwegenetz ist sehr gut ausgebaut. Aber nicht nur <a href="https://www.alpinewelten.com/hoehenweg-zermatt?step=tour" target="_blank">Bergwanderungen</a>, sondern insbesondere die hohen 4.000-er reizen mit <a href="https://www.alpinewelten.com/alpinschule/hochtouren" target="_blank">Hochtouren aller Schwierigkeitsgrade</a> und lassen das Bergsteigerherz höher schlagen! Einmalige Bergerlebnisse und Bergabenteuer sind in der Schweiz Programm und wer einmal ganz hoch hinaus will, findet hier seine Erfüllung.
 tours_winter<h2 style="text-align:center">Tourenmöglichkeiten im Winter</h2> Auch im Winter zieht es uns Bergführer sowie viele Bergsteiger und Wintersportbegeisterte in die Schweiz. Insbesondere Skitouren und Skidurchquerungen - sowohl für Genießer als auch für Könner - begeistern mit dem einzigartigen Bergpanorama der hohen 4.000-er. Auch zahlreiche <a href="https://www.alpinewelten.com/gefuehrte-reisen/freeride-tiefschneefahren" target="_blank">Top Spots zum Freeriden</a> sind in der Schweiz zu finden und die mächtigen gefrorenen Wasserfälle laden zum <a href="https://www.alpinewelten.com/gefuehrte-reisen/eisklettern" target="_blank">Abenteuer Eisklettern</a> ein, insbesondere das <a href="https://www.alpinewelten.com/eisklettern-in-der-schweiz-kandersteg?step=tour" target="_blank">Eiskletter-Mekka in Kandersteg</a>.
 microsite_id(null)
 Route(array)
 id4087
 hash7639d80054386fa387b65184c6aad49a
 created2020-07-20 10:21:53
 updated2024-08-15 14:28:17
 modelCountry
 foreign_key182
 base/
 aliasreisen-schweiz
 controllerFrontendCountries.FrontendCountries
 actioncountry
 parent_id(null)
 lft6065
 rght6066
 route/reisen-schweiz
 FlagUpload(array)
 0(array)
 id397014
 hash11b6df42bcf2f9c354534ea25e3c7da3
 created2020-09-14 08:51:43
 updated2020-09-14 08:51:54
 modelCountry
 fieldflag
 foreign_key182
 aliasflagge-schweiz.png
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Country/Flag/5f5f130a9562b.png
 size1745
 ext.png
 mimeimage/png
 width550
 height550
 Route(array)
 id4217
 hashedb65e1066522adf85fd54161e4bb782
 created2020-08-20 12:05:41
 updated2024-07-18 16:15:21
 modelAccomodation
 foreign_key66
 base/
 aliaschamanna-d-es-cha
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft6181
 rght6182
 route/chamanna-d-es-cha
 Seo(array)
 id4057
 hash4ce48639f0e69ddab9fc911d976257e8
 created2020-08-20 12:05:41
 updated2022-02-22 13:48:35
 modelAccomodation
 foreign_key66
 titleChamanna d’Es-Cha | Bündner Alpen
 descriptionDie Chamanna d’Es-Cha ist eine Schweizer Schutzhütte in den Bündner Alpen. Die Hütte der Sektion Bernina genießt man einen traumhaften Blick über die Gebirgszüge der namensgebenden Gebirgsregion Bernina, welche nach Süden hin eindrücklich in der Ferne thront. Die Verpflegung ist hervorragend.
 internal_keywords
 author
 tw_creator
 fb_author
 robots3
 sitemap_priority0.5
 TeaserMedia(array)
 0(array)
 id9791
 hash7e472d9054975f8e29751640d51382bf
 created2020-11-23 12:08:40
 updated2020-11-23 12:08:40
 titleEs_Cha_Huette
 cross_reference_count3
 MediaEntity(array)
 id452978
 pos1
 media_id9791
 modelAccomodation
 fieldteaser
 foreign_key66
 FileUpload(array)
 0(array)
 id509139
 hash6823826c0dde704c3162592302d1719a
 created2020-11-23 12:08:37
 updated2020-11-23 12:08:40
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb98383d139.jpg
 size174431
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609808
 hashd33536ead6e20cb1ffc5e6e05850932d
 created2022-02-22 13:48:31
 updated2022-02-22 13:48:31
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id509139
 filewebroot/files/Media/File/ThAccomodationTeaserImage/6214db9f73053.jpg
 size67725
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id609809
 hash41f589d6f08567a50bd29f9bb0e26bc9
 created2022-02-22 13:48:31
 updated2022-02-22 13:48:31
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509139
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214db9facdc0.jpg
 size159866
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id609824
 hash1eaace92a8dfb699ed87333485dcdfb0
 created2022-02-22 13:48:35
 updated2022-02-22 13:48:35
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id509139
 filewebroot/files/Media/File/ThSeoImageFacebook/6214dba304561.png
 size484137
 ext.png
 mimeimage/png
 width720
 height405
 4(array)
 id609825
 hash97b6a6f1237ca13cb4a2cb9fb47901f7
 created2022-02-22 13:48:35
 updated2022-02-22 13:48:35
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id509139
 filewebroot/files/Media/File/ThSeoImageGoogle/6214dba342c7e.png
 size484137
 ext.png
 mimeimage/png
 width720
 height405
 5(array)
 id609826
 hashd2aa834cd2fa6b8628c9d65cbc0f5136
 created2022-02-22 13:48:35
 updated2022-02-22 13:48:35
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id509139
 filewebroot/files/Media/File/ThSeoImageTwitter/6214dba383aad.png
 size146122
 ext.png
 mimeimage/png
 width375
 height210
 6(array)
 id509140
 hash4b739efbfe0d9c57d4b19ea1b4a21125
 created2020-11-23 12:08:40
 updated2020-11-23 12:08:40
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509139
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb98383e014.jpg
 size14490
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 7(array)
 id509141
 hash38a89f13a6c9b0bddeda415c84c98d0f
 created2020-11-23 12:08:40
 updated2020-11-23 12:08:40
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509139
 filewebroot/files/Media/File/CkeditorXs/5fbb98386edd1.jpg
 size4559
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 8(array)
 id509142
 hash038acd7111b004a2d27f65831cccf8fc
 created2020-11-23 12:08:40
 updated2020-11-23 12:08:40
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509139
 filewebroot/files/Media/File/CkeditorSm/5fbb9838b3176.jpg
 size14490
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 9(array)
 id509143
 hash1b012e5e7757f2aacb8dd96fc471e7b9
 created2020-11-23 12:08:41
 updated2020-11-23 12:08:41
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509139
 filewebroot/files/Media/File/CkeditorMd/5fbb9838e8088.jpg
 size22907
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 10(array)
 id509144
 hash3a48abe8d78b3acd0d447f547d78f489
 created2020-11-23 12:08:41
 updated2020-11-23 12:08:41
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509139
 filewebroot/files/Media/File/CkeditorLg/5fbb983921f91.jpg
 size49648
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 GalleryMedia(array)
 0(array)
 id9791
 hash7e472d9054975f8e29751640d51382bf
 created2020-11-23 12:08:40
 updated2020-11-23 12:08:40
 titleEs_Cha_Huette
 cross_reference_count3
 MediaEntity(array)
 id452979
 pos1
 media_id9791
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509139
 hash6823826c0dde704c3162592302d1719a
 created2020-11-23 12:08:37
 updated2020-11-23 12:08:40
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb98383d139.jpg
 size174431
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609808
 hashd33536ead6e20cb1ffc5e6e05850932d
 created2022-02-22 13:48:31
 updated2022-02-22 13:48:31
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id509139
 filewebroot/files/Media/File/ThAccomodationTeaserImage/6214db9f73053.jpg
 size67725
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id609809
 hash41f589d6f08567a50bd29f9bb0e26bc9
 created2022-02-22 13:48:31
 updated2022-02-22 13:48:31
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509139
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214db9facdc0.jpg
 size159866
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id609824
 hash1eaace92a8dfb699ed87333485dcdfb0
 created2022-02-22 13:48:35
 updated2022-02-22 13:48:35
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id509139
 filewebroot/files/Media/File/ThSeoImageFacebook/6214dba304561.png
 size484137
 ext.png
 mimeimage/png
 width720
 height405
 4(array)
 id609825
 hash97b6a6f1237ca13cb4a2cb9fb47901f7
 created2022-02-22 13:48:35
 updated2022-02-22 13:48:35
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id509139
 filewebroot/files/Media/File/ThSeoImageGoogle/6214dba342c7e.png
 size484137
 ext.png
 mimeimage/png
 width720
 height405
 5(array)
 id609826
 hashd2aa834cd2fa6b8628c9d65cbc0f5136
 created2022-02-22 13:48:35
 updated2022-02-22 13:48:35
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id509139
 filewebroot/files/Media/File/ThSeoImageTwitter/6214dba383aad.png
 size146122
 ext.png
 mimeimage/png
 width375
 height210
 6(array)
 id509140
 hash4b739efbfe0d9c57d4b19ea1b4a21125
 created2020-11-23 12:08:40
 updated2020-11-23 12:08:40
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509139
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb98383e014.jpg
 size14490
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 7(array)
 id509141
 hash38a89f13a6c9b0bddeda415c84c98d0f
 created2020-11-23 12:08:40
 updated2020-11-23 12:08:40
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509139
 filewebroot/files/Media/File/CkeditorXs/5fbb98386edd1.jpg
 size4559
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 8(array)
 id509142
 hash038acd7111b004a2d27f65831cccf8fc
 created2020-11-23 12:08:40
 updated2020-11-23 12:08:40
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509139
 filewebroot/files/Media/File/CkeditorSm/5fbb9838b3176.jpg
 size14490
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 9(array)
 id509143
 hash1b012e5e7757f2aacb8dd96fc471e7b9
 created2020-11-23 12:08:41
 updated2020-11-23 12:08:41
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509139
 filewebroot/files/Media/File/CkeditorMd/5fbb9838e8088.jpg
 size22907
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 10(array)
 id509144
 hash3a48abe8d78b3acd0d447f547d78f489
 created2020-11-23 12:08:41
 updated2020-11-23 12:08:41
 modelMedia
 fieldfile
 foreign_key9791
 aliases-cha-huette-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509139
 filewebroot/files/Media/File/CkeditorLg/5fbb983921f91.jpg
 size49648
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 1(array)
 id9778
 hashe560854da94ccfacfbd84531f0361c53
 created2020-11-23 12:02:24
 updated2020-11-23 12:02:24
 titleEs_Cha_Huette_Ansicht
 cross_reference_count1
 MediaEntity(array)
 id452980
 pos2
 media_id9778
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509061
 hashc1acc06bc55f205aff3c52a4ba452a70
 created2020-11-23 12:02:23
 updated2020-11-23 12:02:24
 modelMedia
 fieldfile
 foreign_key9778
 aliases-cha-huette-ansicht.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb96c0a61ff.jpg
 size209006
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609810
 hash5e9efd9f8b67a613764f071267cfadba
 created2022-02-22 13:48:32
 updated2022-02-22 13:48:32
 modelMedia
 fieldfile
 foreign_key9778
 aliases-cha-huette-ansicht-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509061
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214db9fe3e2d.jpg
 size197125
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509062
 hashbba3813cc24bb820def27639bdc9fef4
 created2020-11-23 12:02:24
 updated2020-11-23 12:02:24
 modelMedia
 fieldfile
 foreign_key9778
 aliases-cha-huette-ansicht-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509061
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb96c0a6d7d.jpg
 size15777
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509063
 hashb51c9185874fb25285171781ef6a08f5
 created2020-11-23 12:02:25
 updated2020-11-23 12:02:25
 modelMedia
 fieldfile
 foreign_key9778
 aliases-cha-huette-ansicht-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509061
 filewebroot/files/Media/File/CkeditorXs/5fbb96c0dd669.jpg
 size4756
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509064
 hash3bf25efd198bd030cf187d22acd80ee0
 created2020-11-23 12:02:25
 updated2020-11-23 12:02:25
 modelMedia
 fieldfile
 foreign_key9778
 aliases-cha-huette-ansicht-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509061
 filewebroot/files/Media/File/CkeditorSm/5fbb96c12aa09.jpg
 size15777
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509065
 hash7d49705ba6e001920a134352ef77cb77
 created2020-11-23 12:02:25
 updated2020-11-23 12:02:25
 modelMedia
 fieldfile
 foreign_key9778
 aliases-cha-huette-ansicht-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509061
 filewebroot/files/Media/File/CkeditorMd/5fbb96c15bcfc.jpg
 size25535
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509066
 hashbc32caa84dadab25feea986d87a923cf
 created2020-11-23 12:02:25
 updated2020-11-23 12:02:25
 modelMedia
 fieldfile
 foreign_key9778
 aliases-cha-huette-ansicht-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509061
 filewebroot/files/Media/File/CkeditorLg/5fbb96c18985d.jpg
 size55896
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 2(array)
 id9781
 hash7912bff897297421805f03846244f4ea
 created2020-11-23 12:03:50
 updated2020-11-23 12:03:50
 titleEs_Cha_Huette_Bergblick
 cross_reference_count1
 MediaEntity(array)
 id452981
 pos3
 media_id9781
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509079
 hash28e181dce186d2cbba5a5d15b09c686c
 created2020-11-23 12:03:49
 updated2020-11-23 12:03:50
 modelMedia
 fieldfile
 foreign_key9781
 aliases-cha-huette-bergblick.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb971682ebe.jpg
 size184762
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609811
 hash9e96d6fa0e7ec5fbfa2389dc79c68051
 created2022-02-22 13:48:32
 updated2022-02-22 13:48:32
 modelMedia
 fieldfile
 foreign_key9781
 aliases-cha-huette-bergblick-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509079
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba027a17.jpg
 size100476
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509080
 hash6bfe970a89b4ef978fb6620f4c48cc11
 created2020-11-23 12:03:50
 updated2020-11-23 12:03:50
 modelMedia
 fieldfile
 foreign_key9781
 aliases-cha-huette-bergblick-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509079
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb971683deb.jpg
 size19296
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509081
 hashd53b8ef87b2ea82805ca6df470431573
 created2020-11-23 12:03:51
 updated2020-11-23 12:03:51
 modelMedia
 fieldfile
 foreign_key9781
 aliases-cha-huette-bergblick-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509079
 filewebroot/files/Media/File/CkeditorXs/5fbb9716b7eff.jpg
 size6322
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509082
 hash9a54df9dacddab86479a6f68155ec181
 created2020-11-23 12:03:51
 updated2020-11-23 12:03:51
 modelMedia
 fieldfile
 foreign_key9781
 aliases-cha-huette-bergblick-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509079
 filewebroot/files/Media/File/CkeditorSm/5fbb971708738.jpg
 size19296
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509083
 hash9c0e295cabe3a30843bf2d560f7f5662
 created2020-11-23 12:03:51
 updated2020-11-23 12:03:51
 modelMedia
 fieldfile
 foreign_key9781
 aliases-cha-huette-bergblick-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509079
 filewebroot/files/Media/File/CkeditorMd/5fbb97173f43d.jpg
 size30743
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509084
 hashb6de0eda98b10e865e61574730b3b48c
 created2020-11-23 12:03:51
 updated2020-11-23 12:03:51
 modelMedia
 fieldfile
 foreign_key9781
 aliases-cha-huette-bergblick-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509079
 filewebroot/files/Media/File/CkeditorLg/5fbb9717748c9.jpg
 size65109
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 3(array)
 id9783
 hash1b1be71c9408a3c57bd078b5002ff46d
 created2020-11-23 12:04:44
 updated2020-11-23 12:04:44
 titleEs_Cha_Huette_Fruehling
 cross_reference_count1
 MediaEntity(array)
 id452982
 pos4
 media_id9783
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509091
 hash86339af35acc4d6e8e0559c01a248804
 created2020-11-23 12:04:43
 updated2020-11-23 12:04:44
 modelMedia
 fieldfile
 foreign_key9783
 aliases-cha-huette-fruehling.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb974c9831f.jpg
 size204379
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609812
 hash184b84369ed52322c001c4d2426f1dae
 created2022-02-22 13:48:32
 updated2022-02-22 13:48:32
 modelMedia
 fieldfile
 foreign_key9783
 aliases-cha-huette-fruehling-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509091
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba060c7b.jpg
 size179135
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509092
 hashb1e4c8f16cb672e14f48113d3577790d
 created2020-11-23 12:04:44
 updated2020-11-23 12:04:44
 modelMedia
 fieldfile
 foreign_key9783
 aliases-cha-huette-fruehling-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509091
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb974c99005.jpg
 size14762
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509093
 hashe2d1f27fef5480c23046606dd5a2e42c
 created2020-11-23 12:04:45
 updated2020-11-23 12:04:45
 modelMedia
 fieldfile
 foreign_key9783
 aliases-cha-huette-fruehling-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509091
 filewebroot/files/Media/File/CkeditorXs/5fbb974ccca66.jpg
 size4576
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509094
 hashf10054e296c99d0a3d02b70c0afbfad6
 created2020-11-23 12:04:45
 updated2020-11-23 12:04:45
 modelMedia
 fieldfile
 foreign_key9783
 aliases-cha-huette-fruehling-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509091
 filewebroot/files/Media/File/CkeditorSm/5fbb974d1af95.jpg
 size14762
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509095
 hash5b4a82b6e22ced1b146111a5563e8d3a
 created2020-11-23 12:04:45
 updated2020-11-23 12:04:45
 modelMedia
 fieldfile
 foreign_key9783
 aliases-cha-huette-fruehling-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509091
 filewebroot/files/Media/File/CkeditorMd/5fbb974d4da2a.jpg
 size23460
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509096
 hash3af48b421a49866a39816e369fd1229f
 created2020-11-23 12:04:45
 updated2020-11-23 12:04:45
 modelMedia
 fieldfile
 foreign_key9783
 aliases-cha-huette-fruehling-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509091
 filewebroot/files/Media/File/CkeditorLg/5fbb974d78ed4.jpg
 size51540
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 4(array)
 id9779
 hash7a337609ece1226be5c914189a27eeff
 created2020-11-23 12:02:51
 updated2020-11-23 12:02:51
 titleEs_Cha_Huette_Ausblick
 cross_reference_count1
 MediaEntity(array)
 id452983
 pos5
 media_id9779
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509067
 hashd625427dd5da135617c839f9d3ce2486
 created2020-11-23 12:02:50
 updated2020-11-23 12:02:51
 modelMedia
 fieldfile
 foreign_key9779
 aliases-cha-huette-ausblick.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb96db6d8f4.jpg
 size185526
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609813
 hash5a5d16e85dc5ef9eeac3913bb575657f
 created2022-02-22 13:48:33
 updated2022-02-22 13:48:33
 modelMedia
 fieldfile
 foreign_key9779
 aliases-cha-huette-ausblick-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509067
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba0a1bda.jpg
 size106600
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509068
 hashcd59e3fe949d6ea7c3a2c87ad8b5a72e
 created2020-11-23 12:02:51
 updated2020-11-23 12:02:51
 modelMedia
 fieldfile
 foreign_key9779
 aliases-cha-huette-ausblick-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509067
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb96db6e878.jpg
 size20719
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509069
 hash365be2bd4e0a776c70d405299cdbb1c4
 created2020-11-23 12:02:51
 updated2020-11-23 12:02:51
 modelMedia
 fieldfile
 foreign_key9779
 aliases-cha-huette-ausblick-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509067
 filewebroot/files/Media/File/CkeditorXs/5fbb96dba580e.jpg
 size7032
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509070
 hash3a47995b31372a1eb78cd8f798ea6f7e
 created2020-11-23 12:02:52
 updated2020-11-23 12:02:52
 modelMedia
 fieldfile
 foreign_key9779
 aliases-cha-huette-ausblick-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509067
 filewebroot/files/Media/File/CkeditorSm/5fbb96dbe7447.jpg
 size20719
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509071
 hash2ff5d2e8d6554f891ae4b9e562c9789c
 created2020-11-23 12:02:52
 updated2020-11-23 12:02:52
 modelMedia
 fieldfile
 foreign_key9779
 aliases-cha-huette-ausblick-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509067
 filewebroot/files/Media/File/CkeditorMd/5fbb96dc269b1.jpg
 size32408
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509072
 hash2bb455cead3362397bdba5df41842132
 created2020-11-23 12:02:52
 updated2020-11-23 12:02:52
 modelMedia
 fieldfile
 foreign_key9779
 aliases-cha-huette-ausblick-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509067
 filewebroot/files/Media/File/CkeditorLg/5fbb96dc54071.jpg
 size66307
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 5(array)
 id9790
 hash6f0176c85e0cd2ba9c7d917d0f842024
 created2020-11-23 12:08:06
 updated2020-11-23 12:08:06
 titleEs_Cha_Huette_Winter
 cross_reference_count1
 MediaEntity(array)
 id452984
 pos6
 media_id9790
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509133
 hash7d1d4fe317559eaee65b1b5f6db450c6
 created2020-11-23 12:08:05
 updated2020-11-23 12:08:06
 modelMedia
 fieldfile
 foreign_key9790
 aliases-cha-huette-winter.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb981685beb.jpg
 size238456
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609814
 hash6c694151b741424ce1c7133778482ede
 created2022-02-22 13:48:33
 updated2022-02-22 13:48:33
 modelMedia
 fieldfile
 foreign_key9790
 aliases-cha-huette-winter-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509133
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba118548.jpg
 size113928
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509134
 hash5ce3d2579a0ac5d6f45cb10daecf2f3b
 created2020-11-23 12:08:06
 updated2020-11-23 12:08:06
 modelMedia
 fieldfile
 foreign_key9790
 aliases-cha-huette-winter-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509133
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb98168681e.jpg
 size17768
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509135
 hashf14885b3c5362511ddbb5b537f31eff3
 created2020-11-23 12:08:07
 updated2020-11-23 12:08:07
 modelMedia
 fieldfile
 foreign_key9790
 aliases-cha-huette-winter-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509133
 filewebroot/files/Media/File/CkeditorXs/5fbb9816bd021.jpg
 size6300
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509136
 hash5dfaa6972ee6962fcdb5a33d57a85de5
 created2020-11-23 12:08:07
 updated2020-11-23 12:08:07
 modelMedia
 fieldfile
 foreign_key9790
 aliases-cha-huette-winter-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509133
 filewebroot/files/Media/File/CkeditorSm/5fbb98170eacd.jpg
 size17768
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509137
 hash4b2daeb3db79b2f21b803c9b59158c74
 created2020-11-23 12:08:07
 updated2020-11-23 12:08:07
 modelMedia
 fieldfile
 foreign_key9790
 aliases-cha-huette-winter-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509133
 filewebroot/files/Media/File/CkeditorMd/5fbb98174a155.jpg
 size28007
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509138
 hashe68fad1dfaa9a05d669d109b1839a93d
 created2020-11-23 12:08:07
 updated2020-11-23 12:08:07
 modelMedia
 fieldfile
 foreign_key9790
 aliases-cha-huette-winter-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509133
 filewebroot/files/Media/File/CkeditorLg/5fbb981780140.jpg
 size57599
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id9786
 hasheb381ba9216dae571b65f2701fcefccf
 created2020-11-23 12:06:05
 updated2020-11-23 12:06:05
 titleEs_Cha_Huette_im_Winter
 cross_reference_count1
 MediaEntity(array)
 id452985
 pos7
 media_id9786
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509109
 hash7f7e8dd1ccf79c6308b9a2c33468536d
 created2020-11-23 12:06:04
 updated2020-11-23 12:06:05
 modelMedia
 fieldfile
 foreign_key9786
 aliases-cha-huette-im-winter.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb979da479f.jpg
 size172662
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609815
 hash1291ae9ec504546e4d4ba74a5f7bf34a
 created2022-02-22 13:48:33
 updated2022-02-22 13:48:33
 modelMedia
 fieldfile
 foreign_key9786
 aliases-cha-huette-im-winter-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509109
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba16c2c4.jpg
 size165710
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509110
 hash832b19fcdf07c81d47da1d7f61a2c14f
 created2020-11-23 12:06:05
 updated2020-11-23 12:06:05
 modelMedia
 fieldfile
 foreign_key9786
 aliases-cha-huette-im-winter-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509109
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb979da5337.jpg
 size12326
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509111
 hash629f9d514a77d45803c43cdf652bc87f
 created2020-11-23 12:06:06
 updated2020-11-23 12:06:06
 modelMedia
 fieldfile
 foreign_key9786
 aliases-cha-huette-im-winter-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509109
 filewebroot/files/Media/File/CkeditorXs/5fbb979dd52dc.jpg
 size3793
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509112
 hash0a722b402587e26e10bf13325d6dd715
 created2020-11-23 12:06:06
 updated2020-11-23 12:06:06
 modelMedia
 fieldfile
 foreign_key9786
 aliases-cha-huette-im-winter-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509109
 filewebroot/files/Media/File/CkeditorSm/5fbb979e20460.jpg
 size12326
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509113
 hashc614d11a5201ea55cc2e5b82c431f790
 created2020-11-23 12:06:06
 updated2020-11-23 12:06:06
 modelMedia
 fieldfile
 foreign_key9786
 aliases-cha-huette-im-winter-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509109
 filewebroot/files/Media/File/CkeditorMd/5fbb979e50d4d.jpg
 size20383
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509114
 hash82e516eabbf3bdf6736d90d6b01fba4f
 created2020-11-23 12:06:06
 updated2020-11-23 12:06:06
 modelMedia
 fieldfile
 foreign_key9786
 aliases-cha-huette-im-winter-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509109
 filewebroot/files/Media/File/CkeditorLg/5fbb979e7ad99.jpg
 size45793
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 7(array)
 id9784
 hashb576fd986e2194ab6706d65bc0c6adb4
 created2020-11-23 12:05:10
 updated2020-11-23 12:05:10
 titleEs_Cha_Huette_Haupthaus
 cross_reference_count1
 MediaEntity(array)
 id452986
 pos8
 media_id9784
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509097
 hashce07308b4fbce62ce444610f525e3c14
 created2020-11-23 12:05:09
 updated2020-11-23 12:05:10
 modelMedia
 fieldfile
 foreign_key9784
 aliases-cha-huette-haupthaus.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb97662a592.jpg
 size212674
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609816
 hash9737219314e35f3726c391223731279f
 created2022-02-22 13:48:33
 updated2022-02-22 13:48:33
 modelMedia
 fieldfile
 foreign_key9784
 aliases-cha-huette-haupthaus-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509097
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba19a006.jpg
 size152948
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509098
 hash09e7225bd2dd67077cf20f927678fba0
 created2020-11-23 12:05:10
 updated2020-11-23 12:05:10
 modelMedia
 fieldfile
 foreign_key9784
 aliases-cha-huette-haupthaus-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509097
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb97662b5b7.jpg
 size15309
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509099
 hash0108d71c3545c63b9f561e0b4fc4e6a4
 created2020-11-23 12:05:10
 updated2020-11-23 12:05:10
 modelMedia
 fieldfile
 foreign_key9784
 aliases-cha-huette-haupthaus-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509097
 filewebroot/files/Media/File/CkeditorXs/5fbb97665f572.jpg
 size4748
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509100
 hashcca1babaa784f98e9e7443a665626800
 created2020-11-23 12:05:10
 updated2020-11-23 12:05:10
 modelMedia
 fieldfile
 foreign_key9784
 aliases-cha-huette-haupthaus-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509097
 filewebroot/files/Media/File/CkeditorSm/5fbb9766a0c4f.jpg
 size15309
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509101
 hash8f50d7f453a413bcf4db43890ac6261a
 created2020-11-23 12:05:11
 updated2020-11-23 12:05:11
 modelMedia
 fieldfile
 foreign_key9784
 aliases-cha-huette-haupthaus-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509097
 filewebroot/files/Media/File/CkeditorMd/5fbb9766d2c6a.jpg
 size24106
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509102
 hash07c5713484f3da5233543159ccb9afd5
 created2020-11-23 12:05:11
 updated2020-11-23 12:05:11
 modelMedia
 fieldfile
 foreign_key9784
 aliases-cha-huette-haupthaus-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509097
 filewebroot/files/Media/File/CkeditorLg/5fbb97670a9ba.jpg
 size52293
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 8(array)
 id9780
 hash70dc43c7e184851d0af6b97622e7d35b
 created2020-11-23 12:03:20
 updated2020-11-23 12:03:20
 titleEs_Cha_Huette_Aussicht
 cross_reference_count1
 MediaEntity(array)
 id452987
 pos9
 media_id9780
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509073
 hashe7a7e50eb17c4bdb34d983c4396e9fa8
 created2020-11-23 12:03:18
 updated2020-11-23 12:03:20
 modelMedia
 fieldfile
 foreign_key9780
 aliases-cha-huette-aussicht.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb96f86fd9c.jpg
 size226241
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609817
 hasheb3ca6c03df5172239e85299bf8a0761
 created2022-02-22 13:48:33
 updated2022-02-22 13:48:33
 modelMedia
 fieldfile
 foreign_key9780
 aliases-cha-huette-aussicht-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509073
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba1bd45f.jpg
 size131624
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509074
 hash25c0348aa015d3dba02833842227833a
 created2020-11-23 12:03:20
 updated2020-11-23 12:03:20
 modelMedia
 fieldfile
 foreign_key9780
 aliases-cha-huette-aussicht-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509073
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb96f871135.jpg
 size13356
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509075
 hash02c54fe899a591dd07bf6ac47d480574
 created2020-11-23 12:03:20
 updated2020-11-23 12:03:20
 modelMedia
 fieldfile
 foreign_key9780
 aliases-cha-huette-aussicht-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509073
 filewebroot/files/Media/File/CkeditorXs/5fbb96f8a3674.jpg
 size4326
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509076
 hash2913ea6ab9860f0ddf7e8b8e561b24d6
 created2020-11-23 12:03:21
 updated2020-11-23 12:03:21
 modelMedia
 fieldfile
 foreign_key9780
 aliases-cha-huette-aussicht-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509073
 filewebroot/files/Media/File/CkeditorSm/5fbb96f8e6b8b.jpg
 size13356
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509077
 hash2c3556653763196405dc0a100c96b416
 created2020-11-23 12:03:21
 updated2020-11-23 12:03:21
 modelMedia
 fieldfile
 foreign_key9780
 aliases-cha-huette-aussicht-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509073
 filewebroot/files/Media/File/CkeditorMd/5fbb96f9256f7.jpg
 size20947
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509078
 hash78f52aa46c5a7f1373b9f6662212e96e
 created2020-11-23 12:03:21
 updated2020-11-23 12:03:21
 modelMedia
 fieldfile
 foreign_key9780
 aliases-cha-huette-aussicht-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509073
 filewebroot/files/Media/File/CkeditorLg/5fbb96f952a41.jpg
 size44803
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 9(array)
 id9789
 hash2166cbe42dcef32c442abf4b1d544560
 created2020-11-23 12:07:30
 updated2020-11-23 12:07:30
 titleEs_Cha_Huette_Stube
 cross_reference_count1
 MediaEntity(array)
 id452988
 pos10
 media_id9789
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509127
 hasha02cc6c64d69a7e9499d298cec9c6f83
 created2020-11-23 12:07:29
 updated2020-11-23 12:07:30
 modelMedia
 fieldfile
 foreign_key9789
 aliases-cha-huette-stube.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb97f26f42c.jpg
 size204279
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609818
 hash94397a7a54778cb919e13c7574f1dbf2
 created2022-02-22 13:48:34
 updated2022-02-22 13:48:34
 modelMedia
 fieldfile
 foreign_key9789
 aliases-cha-huette-stube-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509127
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba1e0099.jpg
 size113279
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509128
 hash74fd5ab99aa86fea76306a3c6182d44f
 created2020-11-23 12:07:30
 updated2020-11-23 12:07:30
 modelMedia
 fieldfile
 foreign_key9789
 aliases-cha-huette-stube-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509127
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb97f27009b.jpg
 size13667
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509129
 hash19f691c4fba6a089efcf6ba3c1b532ad
 created2020-11-23 12:07:30
 updated2020-11-23 12:07:30
 modelMedia
 fieldfile
 foreign_key9789
 aliases-cha-huette-stube-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509127
 filewebroot/files/Media/File/CkeditorXs/5fbb97f2a509d.jpg
 size4458
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509130
 hashe52849cac5a94b0b16887feaaff4cfe4
 created2020-11-23 12:07:31
 updated2020-11-23 12:07:31
 modelMedia
 fieldfile
 foreign_key9789
 aliases-cha-huette-stube-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509127
 filewebroot/files/Media/File/CkeditorSm/5fbb97f2e8d15.jpg
 size13667
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509131
 hash1f32d57ef70065ee48beb1cfb086f4cc
 created2020-11-23 12:07:31
 updated2020-11-23 12:07:31
 modelMedia
 fieldfile
 foreign_key9789
 aliases-cha-huette-stube-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509127
 filewebroot/files/Media/File/CkeditorMd/5fbb97f32a42f.jpg
 size21500
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509132
 hashca2eadf1069d3e3d74a2b2c9964d2f42
 created2020-11-23 12:07:31
 updated2020-11-23 12:07:31
 modelMedia
 fieldfile
 foreign_key9789
 aliases-cha-huette-stube-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509127
 filewebroot/files/Media/File/CkeditorLg/5fbb97f35a524.jpg
 size45949
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 10(array)
 id9777
 hashd0bed1fd0e80c9a45e862deeacf8a224
 created2020-11-23 12:01:47
 updated2020-11-23 12:01:47
 titleEs_Cha_Huette_am_Wanderweg
 cross_reference_count1
 MediaEntity(array)
 id452989
 pos11
 media_id9777
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509055
 hash4daab8d9c16a04dee25b68bb8eea2343
 created2020-11-23 12:01:45
 updated2020-11-23 12:01:47
 modelMedia
 fieldfile
 foreign_key9777
 aliases-cha-huette-am-wanderweg.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb969bed8e0.jpg
 size220379
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609819
 hashd897e923dd428b11c67df8e4889f77dc
 created2022-02-22 13:48:34
 updated2022-02-22 13:48:34
 modelMedia
 fieldfile
 foreign_key9777
 aliases-cha-huette-am-wanderweg-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509055
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba20e7b3.jpg
 size145203
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509056
 hash00787dc389e6ef3a2f6af45c928d72e2
 created2020-11-23 12:01:48
 updated2020-11-23 12:01:48
 modelMedia
 fieldfile
 foreign_key9777
 aliases-cha-huette-am-wanderweg-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509055
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb969beefa7.jpg
 size13137
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509057
 hash1c26a014d680fa36941db7bfc4368b6e
 created2020-11-23 12:01:48
 updated2020-11-23 12:01:48
 modelMedia
 fieldfile
 foreign_key9777
 aliases-cha-huette-am-wanderweg-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509055
 filewebroot/files/Media/File/CkeditorXs/5fbb969c2f16b.jpg
 size4210
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509058
 hashe54cd13132f667c4142ada79024831be
 created2020-11-23 12:01:48
 updated2020-11-23 12:01:48
 modelMedia
 fieldfile
 foreign_key9777
 aliases-cha-huette-am-wanderweg-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509055
 filewebroot/files/Media/File/CkeditorSm/5fbb969c6fc8c.jpg
 size13137
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509059
 hash6cae3238f5197cff3783a9b263bf8d4a
 created2020-11-23 12:01:48
 updated2020-11-23 12:01:48
 modelMedia
 fieldfile
 foreign_key9777
 aliases-cha-huette-am-wanderweg-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509055
 filewebroot/files/Media/File/CkeditorMd/5fbb969ca159b.jpg
 size20741
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509060
 hash34f2ad77c985d2e5a6445655a461ec9f
 created2020-11-23 12:01:49
 updated2020-11-23 12:01:49
 modelMedia
 fieldfile
 foreign_key9777
 aliases-cha-huette-am-wanderweg-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509055
 filewebroot/files/Media/File/CkeditorLg/5fbb969ccd424.jpg
 size44458
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 11(array)
 id9782
 hashf09345f7eb92ae13b4c23dc61bb95223
 created2020-11-23 12:04:17
 updated2020-11-23 12:04:17
 titleEs_Cha_Huette_Blumenwelt
 cross_reference_count1
 MediaEntity(array)
 id452990
 pos12
 media_id9782
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509085
 hashc41e3266e5b97e369e40d525684d6d6b
 created2020-11-23 12:04:16
 updated2020-11-23 12:04:17
 modelMedia
 fieldfile
 foreign_key9782
 aliases-cha-huette-blumenwelt.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb9731e80cb.jpg
 size235801
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609820
 hashc88cbab90bd954a02e8709bb3c750ca9
 created2022-02-22 13:48:34
 updated2022-02-22 13:48:34
 modelMedia
 fieldfile
 foreign_key9782
 aliases-cha-huette-blumenwelt-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509085
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba236be7.jpg
 size107934
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509086
 hash06caaecbd75b9fa4a8ed328e0c14e2e5
 created2020-11-23 12:04:18
 updated2020-11-23 12:04:18
 modelMedia
 fieldfile
 foreign_key9782
 aliases-cha-huette-blumenwelt-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509085
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb9731e9103.jpg
 size14964
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509087
 hashd0c1befb580c6d69bcad5dad5e6b5802
 created2020-11-23 12:04:18
 updated2020-11-23 12:04:18
 modelMedia
 fieldfile
 foreign_key9782
 aliases-cha-huette-blumenwelt-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509085
 filewebroot/files/Media/File/CkeditorXs/5fbb97322c956.jpg
 size4645
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509088
 hash266008b05d26cb680548f6465c671493
 created2020-11-23 12:04:18
 updated2020-11-23 12:04:18
 modelMedia
 fieldfile
 foreign_key9782
 aliases-cha-huette-blumenwelt-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509085
 filewebroot/files/Media/File/CkeditorSm/5fbb97326f657.jpg
 size14964
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509089
 hash60364dabffc147f869edd37aa061dcdd
 created2020-11-23 12:04:18
 updated2020-11-23 12:04:18
 modelMedia
 fieldfile
 foreign_key9782
 aliases-cha-huette-blumenwelt-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509085
 filewebroot/files/Media/File/CkeditorMd/5fbb9732a2264.jpg
 size23257
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509090
 hashb6f16590e036a0db1873a2cfeb8643a7
 created2020-11-23 12:04:19
 updated2020-11-23 12:04:19
 modelMedia
 fieldfile
 foreign_key9782
 aliases-cha-huette-blumenwelt-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509085
 filewebroot/files/Media/File/CkeditorLg/5fbb9732ce9a5.jpg
 size48508
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 12(array)
 id9785
 hash637de9eb27a16414b495de05113f92ac
 created2020-11-23 12:05:39
 updated2020-11-23 12:05:39
 titleEs_Cha_Huette_Hoehenwanderweg
 cross_reference_count1
 MediaEntity(array)
 id452991
 pos13
 media_id9785
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509103
 hash3f45e0efdc5b568c3cfe778c1c273609
 created2020-11-23 12:05:37
 updated2020-11-23 12:05:39
 modelMedia
 fieldfile
 foreign_key9785
 aliases-cha-huette-hoehenwanderweg.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb9783452b6.jpg
 size184302
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609821
 hashbac95062f32dffa6160849007a9db2ec
 created2022-02-22 13:48:34
 updated2022-02-22 13:48:34
 modelMedia
 fieldfile
 foreign_key9785
 aliases-cha-huette-hoehenwanderweg-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509103
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba263f16.jpg
 size165717
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509104
 hashbbd143123a3b9c3ed8dde20991443d82
 created2020-11-23 12:05:39
 updated2020-11-23 12:05:39
 modelMedia
 fieldfile
 foreign_key9785
 aliases-cha-huette-hoehenwanderweg-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509103
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb978345ffc.jpg
 size14592
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509105
 hash5b2e0efb3665666198c6abb75a617bb3
 created2020-11-23 12:05:39
 updated2020-11-23 12:05:39
 modelMedia
 fieldfile
 foreign_key9785
 aliases-cha-huette-hoehenwanderweg-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509103
 filewebroot/files/Media/File/CkeditorXs/5fbb97837a016.jpg
 size4524
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509106
 hash31a8920f92f3b9873ecbf9f163645127
 created2020-11-23 12:05:39
 updated2020-11-23 12:05:39
 modelMedia
 fieldfile
 foreign_key9785
 aliases-cha-huette-hoehenwanderweg-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509103
 filewebroot/files/Media/File/CkeditorSm/5fbb9783c03af.jpg
 size14592
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509107
 hashb9a863aff9e280fc80df56705b3e8214
 created2020-11-23 12:05:40
 updated2020-11-23 12:05:40
 modelMedia
 fieldfile
 foreign_key9785
 aliases-cha-huette-hoehenwanderweg-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509103
 filewebroot/files/Media/File/CkeditorMd/5fbb9783f2b3f.jpg
 size23375
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509108
 hash1f4bc91fd62b35f87112238ddb22706f
 created2020-11-23 12:05:40
 updated2020-11-23 12:05:40
 modelMedia
 fieldfile
 foreign_key9785
 aliases-cha-huette-hoehenwanderweg-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509103
 filewebroot/files/Media/File/CkeditorLg/5fbb97842a18d.jpg
 size50667
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 13(array)
 id9787
 hash1f2f7bbd32b64756f1097586f7927e0d
 created2020-11-23 12:06:31
 updated2020-11-23 12:06:31
 titleEs_Cha_Huette_Impressionen
 cross_reference_count1
 MediaEntity(array)
 id452992
 pos14
 media_id9787
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509115
 hashe854a03d82eb8de25ece3689176fec19
 created2020-11-23 12:06:30
 updated2020-11-23 12:06:31
 modelMedia
 fieldfile
 foreign_key9787
 aliases-cha-huette-impressionen.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb97b7d7af8.jpg
 size194894
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609822
 hash873f0fda704e701618e145f4f1240a09
 created2022-02-22 13:48:34
 updated2022-02-22 13:48:34
 modelMedia
 fieldfile
 foreign_key9787
 aliases-cha-huette-impressionen-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509115
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba28825e.jpg
 size190872
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509116
 hash9cb52931d28dc1f5a43a4acf7df27475
 created2020-11-23 12:06:32
 updated2020-11-23 12:06:32
 modelMedia
 fieldfile
 foreign_key9787
 aliases-cha-huette-impressionen-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509115
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb97b7d90e5.jpg
 size17126
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509117
 hash4017ca02e43d06e543d236386ebcf870
 created2020-11-23 12:06:32
 updated2020-11-23 12:06:32
 modelMedia
 fieldfile
 foreign_key9787
 aliases-cha-huette-impressionen-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509115
 filewebroot/files/Media/File/CkeditorXs/5fbb97b818e8f.jpg
 size5037
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509118
 hashd6c49749ad42ff20a79aba5e628ae696
 created2020-11-23 12:06:32
 updated2020-11-23 12:06:32
 modelMedia
 fieldfile
 foreign_key9787
 aliases-cha-huette-impressionen-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509115
 filewebroot/files/Media/File/CkeditorSm/5fbb97b85a9dc.jpg
 size17126
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509119
 hash011e2f1e6efb504ab0b19440eddff058
 created2020-11-23 12:06:32
 updated2020-11-23 12:06:32
 modelMedia
 fieldfile
 foreign_key9787
 aliases-cha-huette-impressionen-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509115
 filewebroot/files/Media/File/CkeditorMd/5fbb97b88ea98.jpg
 size27719
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509120
 hashc24bb02830f0a5d004e104b7e617a1ef
 created2020-11-23 12:06:32
 updated2020-11-23 12:06:32
 modelMedia
 fieldfile
 foreign_key9787
 aliases-cha-huette-impressionen-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509115
 filewebroot/files/Media/File/CkeditorLg/5fbb97b8bb76a.jpg
 size60846
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 14(array)
 id9788
 hash902d76e1b4379e7ad22bbbee7050819b
 created2020-11-23 12:07:01
 updated2020-11-23 12:07:01
 titleEs_Cha_Huette_Innenraeume
 cross_reference_count1
 MediaEntity(array)
 id452993
 pos15
 media_id9788
 modelAccomodation
 fieldgallery
 foreign_key66
 FileUpload(array)
 0(array)
 id509121
 hash437afd788b452318765e86be66c6cd5a
 created2020-11-23 12:06:58
 updated2020-11-23 12:07:01
 modelMedia
 fieldfile
 foreign_key9788
 aliases-cha-huette-innenraeume.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5fbb97d5e0e38.jpg
 size209419
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id609823
 hashd523f7910963f5a9c29c0d6697e231f0
 created2022-02-22 13:48:35
 updated2022-02-22 13:48:35
 modelMedia
 fieldfile
 foreign_key9788
 aliases-cha-huette-innenraeume-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id509121
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/6214dba2bb461.jpg
 size86243
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id509122
 hashadf72fb61db96e139fe11c9caefefe05
 created2020-11-23 12:07:02
 updated2020-11-23 12:07:02
 modelMedia
 fieldfile
 foreign_key9788
 aliases-cha-huette-innenraeume-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id509121
 filewebroot/files/Media/File/ThMediaFileIndex/5fbb97d5e1b00.jpg
 size19070
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id509123
 hash4a2b518cbe5f42205e302291509b6c2e
 created2020-11-23 12:07:02
 updated2020-11-23 12:07:02
 modelMedia
 fieldfile
 foreign_key9788
 aliases-cha-huette-innenraeume-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id509121
 filewebroot/files/Media/File/CkeditorXs/5fbb97d62bded.jpg
 size6522
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id509124
 hashc811287c9f41101008c9830a0d5b0dda
 created2020-11-23 12:07:02
 updated2020-11-23 12:07:02
 modelMedia
 fieldfile
 foreign_key9788
 aliases-cha-huette-innenraeume-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id509121
 filewebroot/files/Media/File/CkeditorSm/5fbb97d672480.jpg
 size19070
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id509125
 hasha8553c34fa072d6e3aad0e3621c0f5d8
 created2020-11-23 12:07:02
 updated2020-11-23 12:07:02
 modelMedia
 fieldfile
 foreign_key9788
 aliases-cha-huette-innenraeume-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id509121
 filewebroot/files/Media/File/CkeditorMd/5fbb97d6ab93d.jpg
 size30022
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id509126
 hashc86c3ad65ef114440032e64f46f7f7cf
 created2020-11-23 12:07:03
 updated2020-11-23 12:07:03
 modelMedia
 fieldfile
 foreign_key9788
 aliases-cha-huette-innenraeume-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id509121
 filewebroot/files/Media/File/CkeditorLg/5fbb97d6df201.jpg
 size61866
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 TagsTag(empty)
 TravelReport(empty)
- accomodationTours(array)
 0(array)
 Tour(array)
 id147
 hashc5798b5056214916d958f2fb9e002345
 created2016-06-22 10:39:46
 updated2024-10-02 16:35:43
 tour_number416000000147
 titleRund um den Piz Bernina | Wandern auf dem Bernina Trek
 subtitleGeführte Wanderung auf dem Bernina Trek, rund um den Festsaal der Alpen
 participants_min5
 participants_max10
 duration_days6
 duration_typetour_week
 tour_price1269.00
 down_payment20
 country_of_serviceswiss
 saisonsummer
 travel_insurance_certificate(true)
 out_of_alpine_tour(false)
 rating_condition4
 rating_technique3
 rating_experience2
 rating_difficulty_categorymedium
 rating_seriousness1
 rating_overall_score2.5
 start_zip7523
 start_cityMadulain
 start_streetVia da la Staziun
 start_countryCH
 start_meeting_pointist am Bahnhof in Madulain.
 start_time12:00:00
 end_alternate_address(false)
 end_time16:00:00
 flight(false)
 flight_details(null)
 consultation
 region_id10
 services_excluded• 6 x ÜN / HP im Lager auf den Hütten ca. 50-60 € / Nacht • Transfers / Bahnfahrten ca. 50.- CHF
 mountain_guide_tour_info
 video_url
 customer_tour_info
 firm_id1
 gmap_zoom10
 gmap_long9.917214
 gmap_marker(false)
 gmap_typeoa_topo
 gmap_lat46.452507
 callout_icontip
 travel_information<h3>Bahnanreise:</h3> Die Schweiz bzw. der Kanton Graubünden ist mit der Rhätischen Bahn sehr gut erschlossen, so dass auch eine Bahnanreise zum Treffpunkt in Madulain recht gut möglich ist. <h3>Unterkunftsempfehlung:</h3> Eine relativ neue und zweckmäßige Unterkunft in Laufnähe zum Bahnhof in Madulain ist die Madulain Lodge. Sie befindet sich im Werkhof der Gemeinde und die ehemaligen Personalzimmer wurden 2020 zu einfachen, aber ansprechenden Doppelzimmern umgebaut. Die acht Zimmer sind auf zwei Flügel aufgeteilt, in der Mitte befindet sich eine Gemeinschaftsküche und ein Aufenthaltsraum mit gemütlicher Wohnecke. Jeweils vier Doppelzimmer teilen sich zwei Duschen und zwei Toiletten. Eine weitere gute Unterkunft in der Nähe ist das Berninahaus direkt neben der Diavolezza Seilbahnstation (ca. 14 km von Madulain). Sehr gutes Essen und freundliche Wirtsleute machen dieses uralte Gasthaus aus dem 16. Jahrhundert zu einem besonderen Genuss. Wenn Du eine Übernachtungsmöglichkeit vor oder nach der Tour suchst, wende Dich bitte direkt an die Unterkunft. <h3> Madulain Lodge</h3> Via Principela 4a CH-7523 Madulain Tel.: +41 44 5004180 Email: <a href="mailto:madulain@projekt-interim.ch">madulain@projekt-interim.ch</a> <a href="https://www.madulainlodge.ch/" target="_blank">www.madulainlodge.ch</a> <h3>Gasthaus Berninahaus</h3> Bernina Suot 3 CH-7504 Pontresina Tel.: +41 81 8426200 Fax.: +41 81 8426110 Email: <a href="mailto:info@berninahaus.ch">info@berninahaus.ch</a> <a href="http://www.berninahaus.ch" target="_blank">www.berninahaus.ch</a>
 meeting_point_map_lat46.586983
 meeting_point_map_marker(true)
 meeting_point_map_typeoa_topo
 meeting_point_map_zoom10
 meeting_point_map_long9.938312
 previous_urlhttp://www.alpinewelten.com/de/gefuehrte-tour/wanderung-bernina/#content_top
 packing_list_text_end<h2>Tipps zur Ausrüstung beim Wandern </h2> Du solltest Deinen Rucksack bereits zu Hause “Probepacken”, um zu sehen, ob alles in den Rucksack passt und wie das Gewicht ist. Gerade bei Mehrtagestouren solltest Du zwingend auf ein minimales Gewicht achten! Hier zählt tatsächlich jedes Gramm, das zu viel ist! Für Wanderungen haben wir besondere Empfehlungen für Dich: Ein spezieller Packsack oder alternativ ein Müllsack sowie ein Regenschirm/Knirps halten Dich und Deine Bekleidung trocken. Nicht zwingend notwendig, aber hilfreich sind Wanderstöcke. Beim Bargeld solltest Du sowohl € als auch CHF mitnehmen. Die Schweizer Franken kannst Du vorher bei der Bank oder vor Ort in der Schweiz wechseln lassen. Häufige Fragen zur Ausrüstung werden auch hier geklärt. <h2>Unser Shop-Partner</h2> Die Bergfreunde sind der richtige Ansprechpartner, wenn es um Bergsport Ausrüstung geht! <figure class="figure-responsive" data-blank="1" data-url="https://www.bergfreunde.de/?pid=15321&wt_mc=de.affiliate.qc.15321.-.-&utm_source=sonstige-affiliates&utm_medium=cpo-variabel&utm_campaign=alpinewelten"> <div class="img-responsive" data-media-id="5141" data-media-thumbnail="ckeditor_md"> </div> <figcaption class="hidden"></figcaption> </figure> <h2>Das Alpine Welten Base Camp Duffle</h2> Das Duffle Bag ist ideal für alle Bergreisen und Kurse geeignet. Die Größe ist so dimensioniert, dass auch Skischuhe und Gepäck für eine längere Reise in die Tasche passen. Ideal ist die Tragefunktion - Rucksack für alle Skitouren-, Hochtouren- und Klettersteigkurse! <a href="https://www.alpinewelten.com/shop/base-camp-duffle" target="_blank">HIER Bestellen</a> <figure class="figure-responsive" data-blank="1" data-url="https://www.alpinewelten.com/shop/base-camp-duffle"> <div class="img-responsive" data-media-id="5397" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> 
 packing_list_text_start
 days_before_start_for_cancellation24
 execution_feasibilitylow
 days_before_start_for_last_notice24
 last_tour_date_number143
 tourstart_weekday64
 mountain_guide_tour_search_information
 customer_tour_material_info
 material_list_link
 callout_icon_multiple(null)
 microsite_id(null)
 is_archive(false)
 is_service(false)
 covid_note(false)
 importancenone
 internal_marknone
 responsible_user_id(null)
 is_service_event(false)
 partner_title
 pay_later_hint(false)
 event_duration
 distance
 ascent
 descent
 destination_menu_id(null)
 gmap46.452507,9.917214
 meeting_point_map46.586983,9.938312
 end_zip7523
 end_cityMadulain
 end_streetVia da la Staziun
 end_countryCH
 price_excl_flight1269.00
 highlight0
 TourTexts(array)
 id139
 hashc5798b5056214916d958f2fb9e002345
 created2016-10-25 13:08:12
 updated2024-10-02 16:35:55
 tour_id147
 ws_text_short_descriptionIm Angesicht von Eis und Schnee, umgeben von Eisriesen wie Piz Palü und Piz Bernina, dem einzigen Viertausender der Ostalpen. Wanderwoche in der Bernina auf dem Bernina Trek in der Schweiz - eine der eindrücklichsten Weitwanderungen Graubündens.
 ws_text_requirementsMittelschwere Bergwege ROT. Für diese geführte Wanderung auf dem Bernina Trek rund um die Bernina in der Schweiz solltest Du als Bergwanderer über eine sehr gute Kondition für reine Gehzeiten bis 8 Stunden verfügen. Die Aufstiege bei der Hüttenwanderung betragen pro Tag bis maximal 1.050 Höhenmeter im Aufstieg und 1.450 Höhenmeter im Abstieg. Die durchschnittliche Geschwindigkeit im Aufstieg beträgt beim Wandern ca. 300 Höhenmeter pro Stunde. Ausgesetzte, versicherte oder absturzgefährdete Stellen sind auf der Wanderung in der Bernina nicht oder wenige zu erwarten. Erfahrung im Bergwandern sowie Trittsicherheit und Schwindelfreiheit bringst Du mit. <h3>Mäßige Alpine Erfahrung | Mittlere alpine Unternehmung</h3> <ul> <li>Mäßige Ernsthaftigkeit / Gefährdung</li> <li>Erfahrung Bergwandern</li> <li>Trittsicherheit und Schwindelfreiheit</li> </ul> 1.050 Hm1.450 Hm900 Hm 8 hROTFrühstück 
 ws_text_travel_program<h3>1. Tag: Von Madulein zur schönen Chamanna d'Es-cha</h3> Treffpunkt für unsere Wanderwoche auf dem Bernina Trek in der Bernina ist am Mittag in Madulain am Bahnhof. Nach der Begrüßung steigen wir gemütlich zur Chamanna d'Es-cha (2.594 m) auf. Der Weg führt durch lichte Arven- und Lärchenwälder zur wunderschön gelegenen Hütte - genau der richtige Ort, um den ersten Wandertag gemütlich ausklingen zu lassen. Von der Terrasse genießen wir einen wunderbaren Ausblick über die gesamte Bernina mit ihren mächtigen, vergletscherten Gipfeln. 900 Hm700m800m 3 hsehr schwerHalbpension <h3>2. Tag: Über den Albulapass und die Fuorcla Crap Alv ins Bever Tal</h3> Heute steht ein sehr langer und anstrengender Wandertag auf dem Programm. Deshalb brechen wir früh nach einem stärkenden Frühstück auf. Ohne große Steigungen erreichen wir über die Fuorcla Gualdauna und den sonnigen Südhängen die Straße vom Albulapass auf 2.312 m Höhe. Hier nutzen wir eine kurze Fahrt mit dem Bus bevor es über den Lajets digl Crap Alv zur Fuorcla Crap Alv (2.466 m) geht. Es erwartet uns ein wunderbarer Ausblick in das einsame und wilde Val Bever, in das wir von hier über den steilen Weg absteigen. Wir folgen dem Tal lang, aber leicht ansteigend, bis es an den letzten Aufstieg zur neuen Chamanna Jenatsch (2.652 m) geht. 1.050 Hm 1.000 Hm800m 8 hsehr schwerHalbpension <h3>3. Tag: Über dem Suvretta Pass nach Silvaplana</h3> Auch heute starten wir wieder nach einem frühen Frühstück. Wir verlassen die Hütte und wandern in südöstlicher Richtung am Fuß des 3.000ers Piz Traunter Ovas entlang. Weiter geht es über die Fuorcla Suvretta (2.964 m) und über den Suvretta Pass. Wir passieren den kleinen Suvretta Bergsee und steigen vorbei an der Alp Suvretta weiter hinab ins Tal bis nach Silvaplana. Über die Brücke am Silvaplanasee gelangen wir in den Ortsteil Surlej, unser heutiges Tagesziel. Am Nachmittag haben wir noch etwas Zeit, um die wunderbare Umgebung zu genießen. Das Schloss Crap da Sass bietet ein schönes Fotomotiv, der Aussichtspunkt Cascada ist in etwa 20 min. Fußweg zu erreichen und am Seeufer von Surlej ist ein Felsen zu finden, an dem Friedrich Nietzsche 1881 der Gedanke der Ewigen Wiederkunft kam, die dem Werk "Also sprach Zarathustra" zugrunde liegt. Wir übernachten in einem Hotel in Surlej oder Silvaplana. 650 Hm 1.450 Hm800m 6 hsehr schwerHalbpension <h3>4. Tag: Von Silvaplana in die Gletscherwelt der Bernina</h3> Wir fahren mit der Corvatsch-Bergbahn bis zur Mittelstation Murtèl (2.698 m). Hier eröffnet sich uns bereits ein beeindruckender Blick auf den Piz Corvatsch (3.451 m) sowie die umliegenden 3.000-er der Bernina. Wir setzen unsere Wanderung über einen schönen Panoramaweg über die Fuorcla Surlej und oberhalb des Gletschersees. Unterwegs begleiten uns phantastische Ausblicke in die beeindruckende Gletscherwelt der Bernina mit dem 4.048 m hohen Piz Bernina, dem östlichsten 4.000-er der Alpen und höchsten Gipfel der Bernina. Am Abzweig folgen wir dem Weg, der uns hinunter zum Gletschersee führt, auf dem im Frühsommer noch bläuliche Eisschollen schwimmen. Wir durchqueren eine einzigartige Urlandschaft, am Ufer des milchigen Gletschersses entlang und durch eine faszinierende Moränenlandschaft. Vom Val Roseg steigen wir schließlich auf zur Chamanna Tschierva (2.573 m) mit einer beeindruckenden Aussicht auf die Eisriesen der Bernina, allen voran den Piz Bernina mit seinem mächtigen Gletscher und dem legendären Biancograt. Die Sonnenterrasse lädt zu einer Erfrischung und einem Sonnenbad ein und wir lassen den Tag gemütlich ausklingen. 800 Hm900 Hm800m 5 hsehr schwerHalbpension <h3>5. Tag: Nach Pontresina und weiter nach Morteratsch</h3> Wir steigen in das schöne Val Roseg ab und folgen von dort dem einfachen Weg bis nach Pontresina. Von Pontresina nutzen wir die Rhätische Bahn - UNESCO Weltkulturerbe - um uns den Weg bis nach Morteratsch zu verkürzen. An der Haltestation Morteratsch ist die Schaukäserei ideal für eine kurze Pause, bevor wir uns an den Aufstieg zu unserem heutigen Etappenziel machen. Nachdem wir die Gleise überquert haben, führt uns der Weg sanft ansteigend auf der Moräne des bekannten Morteratschgletschers über die Chünetta hinein ins Tal. Zuerst durch düsteren Arvenwald und dann sehr aussichtsreich, hoch über dem Gletscher bis zur Chamanna Boval (2.495 m). Dabei genießen wir wunderbare Ausblicke auf die majestätischen Berggipfel Piz Bernina, Bellavista und Piz Palü. 600 Hm 800 Hm800m 7 hsehr schwerHalbpension <h3>6. Tag: Durch das Val Minor und Val da Camp zur Saoseo Hütte</h3> Heute steht noch einmal ein langer Wandertag an. Von der Boval Hütte steigen wir wieder ab zurück nach Morteratsch. Mit der Rhätischen Bahn geht es weiter nach Lagalb, wo wir unsere Wanderung rund um den Piz Lagalb durch das Val Minor zum Lej Minoe fortsetzen. Von der Fuorcla Minor (2.432 m) steigen wir ab und erreichen über La Rösa das Val da Camp, dem wir bis zum Rifugio Saoseo (1.985 m) eingebettet in die Natur im Talschluss liegend folgen. Optional können wir das letzte Stück auch mit dem Bus von Sfazù nach Lungacqua abkürzen. Der kurze Aufstieg von der Saoseo Hütte zum gleichnamigen See belohnt mit grandioser Aussicht. 800 Hm 1.300 Hm800m 8 hsehr schwerHalbpension <h3>7. Tag: Val Poschiavo und Rückfahrt</h3> Auf der südlichen Talseite wandern wir hinab ins Val Poschiavo. Der Weg führt mit tollen Aussichtspunkten schließlich hinunter nach Poschiavo - dem Ziel unserer Wanderwoche. Einen Cappuccino im Café haben wir uns redlich verdient. Mit der Rhätischen Bahn fahren wir am Nachmittag gemeinsam über den Berninapass zurück zum Ausgangspunkt in Madulain. Während der Bahnfahrt genießen wir noch einmal wunderbare Ausblicke in die Berg- und Gletscherwelt der Bernina, die wir während der letzten Woche auf dem Bernina Trek durchwandert haben. Zurück in Madulain geht unsere Wanderwoche auf dem Bernina Trek schließlich zu Ende und wir treten die individuelle Heimreise an. 300 Hm 1.300 Hm800m 6 hsehr schwerFrühstück
 ws_text_services<ul> <li>Speisen und Getränke außerhalb der Halbpension</li> <li>Individuelle Trinkgelder</li> </ul>
 ws_text_information<h3>Mindestteilnehmerzahl</h3> Diese Reise kann nur ab der oben angegebenen Mindestteilnehmerzahl durchgeführt werden. Sollte diese 10 Tage vor Antritt der Reise nicht erreicht sein, so kann eine Absage durch den Veranstalter erfolgen. Im Falle einer Absage ist dieser bestrebt, Dir ein Alternativangebot zu unterbreiten. Bitte beachte hierzu unsere ergänzenden Hinweise in den Reisebedingungen <h3>Reiseveranstalter</h3> Reiseveranstalter ist Alpine Welten Die Bergführer GmbH & Co. KG, Rauher Berg 8, 89180 Berghülen <h3>Versicherungen</h3> Wir empfehlen Dir dringend den Abschluss einer Reiserücktrittsversicherung sowie einer Versicherung zur Deckung der Rückführungskosten bei Unfall oder Krankheit. Bitte prüfe hierfür Deinen Versicherungsschutz. Im Verlauf der Buchung besteht entsprechende Möglichkeit diesen Versicherungsschutz herzustellen. Ebenso empfehlen wir für unsere Bergreisen den Abschluss einer Auslandsreisekrankenversicherung zur Deckung von ausländischen Selbstbehalten. Die Mitgliedschaft in einem alpinen Verein (z. B. Deutscher Alpenverein, Österreichischer Alpenverein) deckt bereits die Kosten einer eventuellen Hubschrauberrettung ab und wird von uns empfohlen. <h3>Weiterführende Informationen</h3> Bitte beachte folgenden Link Wichtige Hinweise zu Reisen mit besonderen Risiken
 ws_text_location_descriptionDie Gebirgsgruppe der Bernina ist Teil des Alpenhauptkamms und liegt im westlichsten Teil der Ostalpen. Sie erstreckt sich südlich des Oberengadins von St. Moritz im Schweizer Graubünden bis in die italienische Provinz Sondrio. Der höchste Gipfel der Bernina und einziger Viertausender der Ostalpen ist der Piz Bernina mit 4.048 m Höhe. Das Herzstück der Bernina bilden neben dem Piz Bernina selbst die knapp unter der 4.000 m Marke liegenden und dem Piz Bernina benachbarten Gipfel Piz Palü (3.901 m), Bellavista (3.922 m), Piz Morteratsch (3.751 m) und Piz Roseg (3.937 m). Sie lassen Bergsteigerherzen höher schlagen und sind begehrte Gipfelziele auf Hochtouren durch die Bernina. Doch auch wer nicht auf die höchsten Gipfel der Bernina strebt, findet hier eine unglaublich beeindruckende und unbeschreiblich schöne Bergwelt mit phantastischen Aussichten bis tief in die Gletscherwelt dieser Eisriesen. Erschlossen wird die Bernina außerdem von der Rhätischen Bahn, die zum UNESCO Weltkulturerbe zählt. Sie fährt hier mit dem Ospizio Bernina am Berninapass den höchsten Bahnhof der Rhätischen Bahn auf 2.253 m an. Eine Bahnfahrt allein durch diese wunderbare Region ist bereits ein Erlebnis.
 ws_text_accomodationWährend der Wanderwoche von Hütte zu Hütte sind wir im Lager mit Halbpension untergebracht. Die Hütten sind sehr gemütlich und die Lage ist außerordenlich schön. Die Verpflegung ist hervorragend und auf manchen Hütten gibt es Duschmöglichkeiten. <h3>Informationen zur Unterkunft</h3> <ul> <li>Unterkunft im Zimmerlager folgender Hütten</li> <li>Cham Es-cha / Jenatsch / Tschierva Hütte / Boval Hütte / Rifugio Saoseo</li> <li>Gemütliche Hütten mit hervorragender Verpflegung und freundlichen Wirtsleuten</li> </ul> Fragen zur Unterkunft | Wir geben Antworten!
 ws_text_course_content
 ws_text_overview
 ws_text_advantages<ul> <li>Wandern auf dem Bernina Trek</li> <li>abwechslungsreiche Tagesetappen</li> <li>Tour von Hütte zu Hütte</li> <li>durch den "Festsaal der Alpen"</li> </ul>
 ws_text_detail_description_new<h3>Der Bernina Trek - Wanderung rund um den Piz Bernina in der Schweiz</h3> Die Bernina ist bekannt als "Festsaal der Alpen". Mit dem grandiosen Panorama des Piz Bernina und seiner Nachbargipfel, die ein riesiges Amphitheater aus Eis und Fels bilden, hat die Region diese Bezeichnung nur zu Recht. Von einer gemütlichen Hütte zur nächsten wandern wir über blühende Almwiesen, auf kargen Moränen, vorbei an türkisblauen Gletscherseen. Von den grünen Almen steigen wir an den Rand der beeindruckenden Gletscher, die zum berühmten Biancograt, Piz Roseg und Piz Palü führen. Wir erleben eine abwechslungsreiche und intensive Bergwanderwoche durch hochalpine Berglandschaft und zu urigen und gemütlichen Berghütten. 
 ws_text_information_new
 ws_text_accomodation_new
 ws_text_arrival
 Route(array)
 id159
 hasha57eb81c7da398dbb76dc6dee0107bcd
 created2016-08-12 17:20:30
 updated2024-10-02 16:35:55
 modelTour
 foreign_key147
 base/
 aliasrund-um-den-piz-bernina-wandern-auf-dem-bernina-trek
 controllerFrontendTours.FrontendTours
 actiontour
 parent_id(null)
 lft2891
 rght2892
 route/rund-um-den-piz-bernina-wandern-auf-dem-bernina-trek
 Types(array)
 0(array)
 id5
 hashcce9afa6074d7a7edee83520b6a3bc54
 created2015-09-18 13:15:59
 updated2019-01-10 15:51:02
 titleBergwanderungen
 oa_categoriesofferHiking
 use_for_mountain_guide_tour_search(false)
 tour_main_type_id3
 tour_count72
 TourTypesTour(array)
 id37355
 tour_id147
 tour_type_id5
 TourMainType(array)
 id3
 hash2fb0a759edb324800d3f4c36dad9501b
 created2019-01-10 15:41:38
 updated2024-01-23 08:15:39
 titleBergwandern
 position3
 packing_list_text_start<h3>Ausrüstungsliste für Bergwanderungen</h3> <ul> <li>Detailliert mit nützlichen Ausrüstungstipps (?)</li> <li>Kurz vor Tourbeginn Wetter- & Ausrüstungscheck - ggf. Ergänzung</li> <li>Achte auf Deine Schuhwahl! - <a href="https://akademie.alpinewelten.com/bergwandern/bergschuhe">Hier findest Du viele Infos zum Thema. </a></li> </ul>
 packing_list_text_end<h3>Tipps zur Ausrüstung beim Wandern</h3> <ul> <li style="text-align:justify">Packe Deinen Rucksack bereits zu Hause zur Probe. </li> <li style="text-align:justify">Jedes Gramm zählt!</li> <li style="text-align:justify">Es könnte regnen! - Ein großer Packsack (Alternativ Müllsack) & ein Regenschirm halten Dich trocken!!! Regenponchos werden auf Tour nicht toleriert (Stolper/Sturzgefahr)</li> <li style="text-align:justify">Wanderstöcke sind NICHT zwingend notwendig - Machen aber Sinn</li> <li style="text-align:justify">Antworten auf häufige Fragen zur Ausrüstung & Schuhen findest Du in den FAQ.</li> <li style="text-align:justify">Extra für Dich: Bereite Dich vor mit Tipps und Videos in der <a href="https://akademie.alpinewelten.com/bergwandern">Alpine Welten Akademie</a>. </li> </ul> <figure class="img-center" data-blank="1" data-url="https://www.bergfreunde.de/?pid=15321&wt_mc=de.affiliate.qc.15321.-.-&utm_source=sonstige-affiliates&utm_medium=cpo-variabel&utm_campaign=alpinewelten"> <div class="img-responsive" data-media-id="13679"> </div> <figcaption class="hidden"></figcaption> </figure> *Bedingungen
 IconUpload(array)
 0(array)
 id384634
 hash11fc38d30fdd83efa61db88da9e4c400
 created2020-08-18 08:59:02
 updated2020-08-18 08:59:04
 modelTourMainType
 fieldicon
 foreign_key3
 aliasic-bergwandern.svg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/TourMainType/Icon/5f3b7c3855aeb.svg
 size1308
 ext.svg
 mimeimage/svg+xml
 width(null)
 height(null)
 TeaserImageMedia(array)
 0(array)
 id9181
 hash565302763c611d7edddd28d7ac428cbe
 created2020-10-07 16:55:44
 updated2020-10-07 16:55:44
 titleAufstieg zur Tschiervahütte
 cross_reference_count3
 MediaEntity(array)
 id609818
 pos1
 media_id9181
 modelTour
 fieldteaser_image
 foreign_key147
 FileUpload(array)
 0(array)
 id411896
 hasha971829b91e9a104c84f3b025f17d3da
 created2020-10-07 16:55:07
 updated2020-10-07 16:55:44
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f7dd6f046f19.jpg
 size320239
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id817433
 hash2d4b622672de5223f2e47a0c2b6d4a68
 created2024-10-02 16:35:53
 updated2024-10-02 16:35:53
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-thtourteaserimage.jpg
 thumbnailth-tour-teaser-image
 parent_id411896
 filewebroot/files/Media/File/ThTourTeaserImage/66fd5a4937acf.jpg
 size91334
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id817434
 hashcd3183d8086fc53e757bea19dc2529bd
 created2024-10-02 16:35:53
 updated2024-10-02 16:35:53
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-thtourteaserimagedesaturated.jpg
 thumbnailth-tour-teaser-image-desaturated
 parent_id411896
 filewebroot/files/Media/File/ThTourTeaserImageDesaturated/66fd5a494730e.jpg
 size84826
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 3(array)
 id817435
 hasha05f7adf6e10a010f9a6151de586f8ed
 created2024-10-02 16:35:53
 updated2024-10-02 16:35:53
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-thtourteaserimagefullscreen.jpg
 thumbnailth-tour-teaser-image-fullscreen
 parent_id411896
 filewebroot/files/Media/File/ThTourTeaserImageFullscreen/66fd5a4958f9d.jpg
 size371839
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 4(array)
 id817436
 hash9e077eb04080edeee98b2e2be2733b50
 created2024-10-02 16:35:53
 updated2024-10-02 16:35:53
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id411896
 filewebroot/files/Media/File/ThTourHeaderImage/66fd5a498a6e3.jpg
 size119361
 ext.jpg
 mimeimage/jpeg
 width750
 height560
 5(array)
 id487037
 hash090e80b94a068532b4fb31268b25b315
 created2020-10-28 02:46:03
 updated2020-10-28 02:46:03
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id411896
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cd5b49217.jpg
 size14739
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 6(array)
 id487038
 hash226027516fadd16385c6fe1700898ae5
 created2020-10-28 02:46:03
 updated2020-10-28 02:46:03
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id411896
 filewebroot/files/Media/File/CkeditorXs/5f98cd5b7dad8.jpg
 size4493
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 7(array)
 id487039
 hash96b06a4713a17f7801973330df466b76
 created2020-10-28 02:46:04
 updated2020-10-28 02:46:04
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id411896
 filewebroot/files/Media/File/CkeditorSm/5f98cd5bc10c4.jpg
 size14739
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 8(array)
 id487040
 hash9127f5d7d4021db48da973f183622fdd
 created2020-10-28 02:46:04
 updated2020-10-28 02:46:04
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id411896
 filewebroot/files/Media/File/CkeditorMd/5f98cd5c04a37.jpg
 size24076
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 9(array)
 id487041
 hasheadecca1b14cfa8cc33cd902f73d2755
 created2020-10-28 02:46:04
 updated2020-10-28 02:46:04
 modelMedia
 fieldfile
 foreign_key9181
 aliasaufstieg-zur-tschiervahuette-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id411896
 filewebroot/files/Media/File/CkeditorLg/5f98cd5c3530c.jpg
 size53403
 ext.jpg
 mimeimage/jpeg
 width300
 height168
- months(array)
 1Januar
 2Februar
 4March
 8April
 16Mai
 32Juni
 64Juli
 128August
 256September
 512Oktober
 1024November
 2048Dezember
- accomodationTourMainTypes(array)
 3(array)
 id3
 hash2fb0a759edb324800d3f4c36dad9501b
 created2019-01-10 15:41:38
 updated2024-01-23 08:15:39
 titleBergwandern
 position3
 packing_list_text_start<h3>Ausrüstungsliste für Bergwanderungen</h3> <ul> <li>Detailliert mit nützlichen Ausrüstungstipps (?)</li> <li>Kurz vor Tourbeginn Wetter- & Ausrüstungscheck - ggf. Ergänzung</li> <li>Achte auf Deine Schuhwahl! - <a href="https://akademie.alpinewelten.com/bergwandern/bergschuhe">Hier findest Du viele Infos zum Thema. </a></li> </ul>
 packing_list_text_end<h3>Tipps zur Ausrüstung beim Wandern</h3> <ul> <li style="text-align:justify">Packe Deinen Rucksack bereits zu Hause zur Probe. </li> <li style="text-align:justify">Jedes Gramm zählt!</li> <li style="text-align:justify">Es könnte regnen! - Ein großer Packsack (Alternativ Müllsack) & ein Regenschirm halten Dich trocken!!! Regenponchos werden auf Tour nicht toleriert (Stolper/Sturzgefahr)</li> <li style="text-align:justify">Wanderstöcke sind NICHT zwingend notwendig - Machen aber Sinn</li> <li style="text-align:justify">Antworten auf häufige Fragen zur Ausrüstung & Schuhen findest Du in den FAQ.</li> <li style="text-align:justify">Extra für Dich: Bereite Dich vor mit Tipps und Videos in der <a href="https://akademie.alpinewelten.com/bergwandern">Alpine Welten Akademie</a>. </li> </ul> <figure class="img-center" data-blank="1" data-url="https://www.bergfreunde.de/?pid=15321&wt_mc=de.affiliate.qc.15321.-.-&utm_source=sonstige-affiliates&utm_medium=cpo-variabel&utm_campaign=alpinewelten"> <div class="img-responsive" data-media-id="13679"> </div> <figcaption class="hidden"></figcaption> </figure> *Bedingungen
 IconUpload(array)
 0(array)
 id384634
 hash11fc38d30fdd83efa61db88da9e4c400
 created2020-08-18 08:59:02
 updated2020-08-18 08:59:04
 modelTourMainType
 fieldicon
 foreign_key3
 aliasic-bergwandern.svg
 filewebroot/files/TourMainType/Icon/5f3b7c3855aeb.svg
 size1308
 ext.svg
 mimeimage/svg+xml
- faq(empty)
- minimalLayoutForLayout(false)
- $request->data(empty)
- $this->validationErrors(array)
 Route(empty)
 MountPoint(empty)
 Redirect(empty)
 Language(empty)
 Setting(empty)
 ValueUpload(empty)
 Menu(empty)
 MemberGroup(empty)
 Member(empty)
 Parent(empty)
 HeaderImagesMedia(empty)
 MediaEntity(empty)
 Seo(empty)
 ImageMedia(empty)
 Teaser(empty)
 Advantage(empty)
 IconUpload(empty)
 Accomodation(empty)
 TeaserMedia(empty)
 GalleryMedia(empty)
 VideoThumbnailMedia(empty)
 TravelReport(empty)
 Firm(empty)
 Tours(empty)
 Types(empty)
 Tour(empty)
 Services(empty)
 TourDate(empty)
 TravelOptions(empty)
 Booking(empty)
 TourServices(empty)
 FellowTraveller(empty)
 Invoice(empty)
 EmailTemplate(empty)
 TagsTag(empty)
 TagEntity(empty)
 MountainGuides(empty)
 TeaserImageMedia(empty)
 OutputChannel(empty)
 LogoMedia(empty)
 LogoHorizontalMedia(empty)
 MountainGuideQualification(empty)
 MountainGuide(empty)
 MountainGuideQualifications(empty)
 IconMedia(empty)
 MountainGuideDailyRate(empty)
 Region(empty)
 Accomodations(empty)
 AccomodationAlternatives(empty)
 Countries(empty)
 News(empty)
 FileMedia(empty)
 Country(empty)
 TourMainType(empty)
 RegionAreas(empty)
 PackingListItems(empty)
 PackingList(empty)
 Transfers(empty)
 Co2Items(empty)
 SimilarTours(empty)
 AccomodationImagesMedia(empty)
 EmailHeadMedia(empty)
 EventIconMedia(empty)
 PartnerLogoMedia(empty)
 FaqItem(empty)
 FaqSet(empty)
 FaqItems(empty)
 Content(empty)
 TourType(empty)
 ArticleContentMedia(empty)
 MosaicGalleryMedia(empty)
 BackgroundImageMedia(empty)
 PlaceholderImageMedia(empty)
 User(empty)
 Aro(empty)
 Aco(empty)
 Users(empty)
 Tag(empty)
 Tags(empty)
 ExclusionTags(empty)
 TourFaqItemsForCustomer(empty)
 TourFaqItemsForMountainGuide(empty)
 Job(empty)
 TourMainTypes(empty)
 Microsite(empty)
 Microsites(empty)
 DisturberMedia(empty)
 FileUpload(empty)
 FlagUpload(empty)
 RegionArea(empty)
 AccomodationsTravelReport(empty)
 TourTexts(empty)
 TourTypesTour(empty)
 Highlight(empty)
 HeaderVideoUpload(empty)
 AdvantagesMenu(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7SocialMedia
 8LeafletJs
 9Leaflet
 10GMap
 11Embed
 12Layout
 13Recaptcha
 14ThirdPartyCookies
 15RequestContent
 16BitMask
 17Number
 18SimpleGraph
 19DebugTimer
 20Toolbar
 21LeafletEngine
 22Js
 23HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.2.34
User	u3939483948
Home	/var/www/vhosts/alpinewelten.com
Script Name	/webroot/index.php
Request Uri	/chamanna-d-es-cha
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/chamanna-d-es-cha
Remote Port	40454
Script Filename	/var/www/vhosts/alpinewelten.com/httpdocs/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/alpinewelten.com/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/alpinewelten.com/httpdocs
Remote Addr	3.139.97.161
Server Port	443
Server Addr	85.236.49.170
Server Name	www.alpinewelten.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Cookie	laikanxia_google_v=1; laikanxia_cookie_id=241101081717437; fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E
Http Accept Encoding	gzip, br, zstd, deflate
Http Referer	https://alpinewelten.com/chamanna-d-es-cha
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	3.139.97.161
Http Host	www.alpinewelten.com
Proxy-nokeepalive	1
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Http Authorization
Script Uri	https://www.alpinewelten.com/chamanna-d-es-cha
Script Url	/chamanna-d-es-cha
Unique Id	ZyQeQreDAnhIcrFZonSdhQAAAQE
Redirect Status	200
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 Http Authorization
Redirect Script Uri	https://www.alpinewelten.com/chamanna-d-es-cha
Redirect Script Url	/chamanna-d-es-cha
Redirect Unique Id	ZyQeQreDAnhIcrFZonSdhQAAAQE
Redirect Redirect Status	200
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.alpinewelten.com/chamanna-d-es-cha
Redirect Redirect Script Url	/chamanna-d-es-cha
Redirect Redirect Unique Id	ZyQeQreDAnhIcrFZonSdhQAAAQE
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1730420290.7173
Request Time	1730420290

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/7.2/share/pear
- 2-> /var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Behavior(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/AclBehavior.php
  Cache(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
  1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
  2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
  Component(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/AuthComponent.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SecurityComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/language_country.php
  3APP/Config/routes.php
  4APP/Config/database.php
  5APP/contrance/Config/database.php
  6APP/contrance/Vendor/Cake/lib/Cake/Config/config.php
  Controller(array)
  0APP/Controller/AppController.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Controller.php
  2APP/contrance/Vendor/Cake/lib/Cake/Controller/ComponentCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Controller/Component.php
  Datasource(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/Database/Mysql.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  Error(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Error/exceptions.php
  1APP/contrance/Vendor/Cake/lib/Cake/Error/ErrorHandler.php
  I18n(array)
  0APP/contrance/Vendor/Cake/lib/Cake/I18n/I18n.php
  1APP/contrance/Vendor/Cake/lib/Cake/I18n/L10n.php
  Log(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLog.php
  1APP/contrance/Vendor/Cake/lib/Cake/Log/LogEngineCollection.php
  2APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/FileLog.php
  3APP/contrance/Vendor/Cake/lib/Cake/Log/Engine/BaseLog.php
  4APP/contrance/Vendor/Cake/lib/Cake/Log/CakeLogInterface.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Model.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/BehaviorCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/ModelBehavior.php
  4APP/contrance/Vendor/Cake/lib/Cake/Model/ConnectionManager.php
  5APP/contrance/Vendor/Cake/lib/Cake/Model/Aro.php
  6APP/contrance/Vendor/Cake/lib/Cake/Model/AclNode.php
  7APP/contrance/Vendor/Cake/lib/Cake/Model/Aco.php
  Network(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Network/CakeRequest.php
  1APP/contrance/Vendor/Cake/lib/Cake/Network/CakeResponse.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  10APP/Lib/Util/LanguageUtil.php
  Routing(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Routing/Dispatcher.php
  1APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/AssetDispatcher.php
  2APP/contrance/Vendor/Cake/lib/Cake/Routing/DispatcherFilter.php
  3APP/contrance/Vendor/Cake/lib/Cake/Routing/Filter/CacheDispatcher.php
  4APP/contrance/Vendor/Cake/lib/Cake/Routing/Router.php
  5APP/Lib/Routing/Route/AliasRoute.php
  6APP/contrance/Vendor/Cake/lib/Cake/Routing/Route/CakeRoute.php
  Utility(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Utility/Hash.php
  1APP/contrance/Vendor/Cake/lib/Cake/Utility/Inflector.php
  2APP/contrance/Vendor/Cake/lib/Cake/Utility/ObjectCollection.php
  3APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeNumber.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/Debugger.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  6APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  7APP/contrance/Vendor/Cake/lib/Cake/Utility/Security.php
  8APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeTime.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  Accomodations(array)
  Config(array)
  0Accomodations/Config/bootstrap.php
  Model(array)
  0Accomodations/Model/Accomodation.php
  1Accomodations/Model/AccomodationsAppModel.php
  Advantages(array)
  Model(array)
  0Advantages/Model/Advantage.php
  1Advantages/Model/AdvantagesAppModel.php
  ApiLogging(array)
  Config(array)
  0ApiLogging/Config/routes.php
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/HabtmBehavior.php
  11BaseData/Model/Behavior/BarcodeNumberBehavior.php
  12BaseData/Model/Behavior/ListBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Bookings(array)
  Config(array)
  0Bookings/Config/bootstrap.php
  Model(array)
  0Bookings/Model/Booking.php
  1Bookings/Model/BookingsAppModel.php
  Contents(array)
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.php
  Countries(array)
  Model(array)
  0Countries/Model/Country.php
  1Countries/Model/CountriesAppModel.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Emails(array)
  Model(array)
  0Emails/Model/EmailTemplate.php
  1Emails/Model/EmailsAppModel.php
  Faqs(array)
  Model(array)
  0Faqs/Model/FaqItem.php
  1Faqs/Model/FaqsAppModel.php
  2Faqs/Model/FaqSet.php
  FellowTravellers(array)
  Model(array)
  0FellowTravellers/Model/FellowTraveller.php
  1FellowTravellers/Model/FellowTravellersAppModel.php
  Firms(array)
  Model(array)
  0Firms/Model/Firm.php
  1Firms/Model/FirmsAppModel.php
  FrontendAccomodations(array)
  Controller(array)
  0FrontendAccomodations/Controller/FrontendAccomodationsController.php
  1FrontendAccomodations/Controller/FrontendAccomodationsAppController.php
  FrontendApi(array)
  Config(array)
  0FrontendApi/Config/routes.php
  FrontendContents(array)
  Config(array)
  0FrontendContents/Config/bootstrap.php
  FrontendMembers(array)
  Config(array)
  0FrontendMembers/Config/routes.php
  FrontendTours(array)
  Config(array)
  0FrontendTours/Config/bootstrap.php
  1FrontendTours/Config/routes.php
  FrontendUploads(array)
  Config(array)
  0FrontendUploads/Config/routes.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  Component(array)
  0FrontendUtils/Controller/Component/RecaptchaComponent.php
  Invoices(array)
  Model(array)
  0Invoices/Model/Invoice.php
  1Invoices/Model/InvoicesAppModel.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  Members(array)
  Model(array)
  0Members/Model/MemberGroup.php
  1Members/Model/MembersAppModel.php
  2Members/Model/Member.php
  Menus(array)
  Model(array)
  0Menus/Model/Menu.php
  1Menus/Model/MenusAppModel.php
  Microsites(array)
  Model(array)
  0Microsites/Model/Microsite.php
  1Microsites/Model/MicrositesAppModel.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  MountainGuides(array)
  Model(array)
  0MountainGuides/Model/MountainGuide.php
  1MountainGuides/Model/MountainGuidesAppModel.php
  2MountainGuides/Model/MountainGuideQualification.php
  3MountainGuides/Model/MountainGuideDailyRate.php
  News(array)
  Model(array)
  0News/Model/News.php
  1News/Model/NewsAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  1Outdooractive/Model/Behavior/CMSInterfaceBehavior.php
  Model(array)
  0Outdooractive/Model/Job.php
  1Outdooractive/Model/JobsAppModel.php
  PackingLists(array)
  Model(array)
  0PackingLists/Model/PackingListItem.php
  1PackingLists/Model/PackingListsAppModel.php
  2PackingLists/Model/PackingList.php
  Pdf(array)
  Config(array)
  0Pdf/Config/bootstrap.php
  1Pdf/Config/routes.php
  Plugin(array)
  0Pdf/Vendor/autoload.php
  1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
  2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
  3Pdf/Vendor/autoloader/Autoloader.php
  Regions(array)
  Model(array)
  0Regions/Model/Region.php
  1Regions/Model/RegionsAppModel.php
  2Regions/Model/RegionArea.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Settings(array)
  Component(array)
  0Settings/Controller/Component/SettingsComponent.php
  Model(array)
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Model(array)
  0Tags/Model/Tag.php
  1Tags/Model/TagsAppModel.php
  Tasks(array)
  Behavior(array)
  0Tasks/Model/Behavior/TaskBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  TourDates(array)
  Model(array)
  0TourDates/Model/TourDate.php
  1TourDates/Model/TourDatesAppModel.php
  Tours(array)
  Model(array)
  0Tours/Model/Tour.php
  1Tours/Model/ToursAppModel.php
  2Tours/Model/TourType.php
  3Tours/Model/TourService.php
  4Tours/Model/TourTravelOption.php
  5Tours/Model/TourMainType.php
  6Tours/Model/TourCo2Item.php
  7Tours/Model/TourTexts.php
  Transfers(array)
  Model(array)
  0Transfers/Model/Transfer.php
  1Transfers/Model/TransfersAppModel.php
  TravelReports(array)
  Model(array)
  0TravelReports/Model/TravelReport.php
  1TravelReports/Model/TravelReportsAppModel.php
  Uploads(array)
  Config(array)
  0Uploads/Config/bootstrap.php
  Behavior(array)
  0Uploads/Model/Behavior/UploadBehavior.php
  1Uploads/Model/Behavior/TransformationBehavior.php
  Model(array)
  0Uploads/Model/Upload.php
  1Uploads/Model/UploadsAppModel.php
  Users(array)
  Model(array)
  0Users/Model/User.php
  1Users/Model/UsersAppModel.php
  Behavior(array)
  0Users/Model/Behavior/PasswordBehavior.php
  1Users/Model/Behavior/ActivityBehavior.php
====

Chamanna d'Es-cha Bernina Gruppe, 2.594 m Stützpunkt in den Albula Alpen

Öffnungszeiten

Ausstattung

Währung & Bezahlung

Standort der Unterkunft

Reisen mit der Unterkunft Chamanna d'Es-cha Diese Unterkunft besuchen wir auf folgenden Reisen

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 25 ms Total Queries: 142 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Chamanna d'Es-cha
Bernina Gruppe, 2.594 m
Stützpunkt in den Albula Alpen

Total Time: 25 ms
Total Queries: 142 queries