Hotel Grimsel
Obergoms, 1.355 m
Das gemütliche Hotel in Obergoms

Alle 7 Fotos ansehen

Öffnungszeiten

Jan

Feb

Mar

Apr

Mai

Jun

Jul

Aug

Sep

Okt

Nov

Dez

Ausstattung

Waschmöglichkeit

Duschmöglichkeit

Handyempfang

Vegetarische Speisen

WLAN

Doppelzimmer

Währung & Bezahlung

Kreditkartenzahlung

Barzahlung

CHF

Währung: Schweizer Franken

Standort der Unterkunft

Reisen mit der Unterkunft Hotel Grimsel Diese Unterkunft besuchen wir auf folgenden Reisen

Der Vier-Quellen-Weg in der Zentralschweiz

Mehrtägige Hüttenwanderung durch das eindrucksvolle Gotthardmassiv und zum Ursprung der vier Flüsse Rhein, Reuss, Ticino und Rhone.

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
  time1730348121
  countdown10
- _Token(array)
  key8f8a252d6d03848f1e3a3d382d1124a4c8f496fb85134c8179518f497b4cfc0ae97f38f7fe384478117d140d6e583e6dd5c8f33fe2b595e536febc422ed4927a
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  ae15c4dd2d0213e81b4a2ff8007eced348ab8ea752a3cef89e2e36c410afd084b5571a49b7bcae8f424b453dc5ccc988516cac5842d5fa2439ab137ed1c10fbd1730335519
  5edc1591522d9ddd206534de5d8ba0aa23b8fb552c27dc5a40f22275f018326c892a3ec22fdb4e7c84b1ad830d256962a57eb936785f4534b64ba104840a60a01730335519
  a928c61dcda8443780018f57a3be17493fd787e1960e5dc2150da285b7758edabb62935f47552485e320969d1c3b5f5994a17ec63b34783d562e307160943f701730335520
  ee9e194a62367168db08ad3737d9cb6e747644800b5496e61379bad01aa940fb585e8f388c8d5a476eb9de3344d5564bba1a264bb5cb7bce9b65dc127b69d1e81730335520
  e37478d63b392357123781045a151179aa3cc24e323c1ed0d40aaa5a47ac45be216602ac5147c31e3e754062f69fc09472e9bc8b2df93d9d838ffb5b19428bd51730335520
  0650f0d103600a4c24e4e4912edf3b3aae9a6a254759e4e22d10d79547dbcf408b0969aafefe14536c6ea1abaa9ffc7fb4570f94f47b81092488017291bed0ca1730335521
  0374622aef53a1a38f323206a6f30252964ad57dd77665bd229daebe8e29f61650ea358224b9fedb272e5bf61d7e7e9458e882bc1479886dbecff60c7063332f1730335521
  c372346dc55dff266112b8797263d97658e1cbc9e7bf28073cc2f2e378b2285fd07676415a116c3d28c12972823585eaef958552f673394ae5d4f7abad99eb5f1730335522
  8f8a252d6d03848f1e3a3d382d1124a4c8f496fb85134c8179518f497b4cfc0ae97f38f7fe384478117d140d6e583e6dd5c8f33fe2b595e536febc422ed4927a1730335522
====
Request
+
Request

Cake Params
- pluginFrontendAccomodations
- controllerFrontendAccomodations
- actionaccomodation
- named(empty)
- pass(array)
  0581
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  Accomodation581
- route(array)
  id5451
  hash30c3d2367ef94eb54c8154f8b548e485
  created2020-12-14 13:21:38
  updated2024-10-24 10:40:33
  modelAccomodation
  foreign_key581
  base/
  aliashotel-grimsel
  controllerFrontendAccomodations.FrontendAccomodations
  actionaccomodation
  parent_id(null)
  lft6723
  rght6724
  route/hotel-grimsel
- isAjax(false)
- _Token(array)
  key8f8a252d6d03848f1e3a3d382d1124a4c8f496fb85134c8179518f497b4cfc0ae97f38f7fe384478117d140d6e583e6dd5c8f33fe2b595e536febc422ed4927a
  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: 19 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`))) = '/hotel-grimsel' LIMIT 1	1	1	5	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 6723 AND `Route`.`rght` >= 6724 ORDER BY `Route`.`lft` asc	1	1	4	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	0
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `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` > 89 AND `Menu`.`rght` < 90 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` = 581 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` = 581 AND `MediaEntity`.`media_id` = `TeaserMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'teaser' 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` = (14286) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	0
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` = 581 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	7	7	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` IN (14287, 14288, 14289, 14290, 14291, 14292, 14293) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	49	49	1
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` = 581 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Accomodation' AND `TagEntity`.`field` = 'tags'	0	0	0
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` = 581 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` = '581' 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	2	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` = 407 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` = 407 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` = (14247) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	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` > 254 AND `Menu`.`rght` < 313 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` > 314 AND `Menu`.`rght` < 327 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` = 581 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` = 5306 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
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` > 40 AND `Menu`.`rght` < 169 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` > 170 AND `Menu`.`rght` < 253 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` > 91 AND `Menu`.`rght` < 168 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	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` = '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 22.20 MB

Message	Memory use
Component initialization	2.34 MB
Controller action start	3.40 MB
Controller render start	7.62 MB
View render complete	11.51 MB

Timers

Total Request Time: 1417 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	1077.37
Event: Controller.initialize	11.44
Event: Controller.startup	0.61
Controller action	60.69
Event: Controller.beforeRender	98.12
» Processing toolbar data	51.99
Rendering View	54.81
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendAccomodations/View/FrontendAccomodations/accomodation.php	18.22
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php	1.05
» » Rendering APP/View/Elements/icon.php	1.70
» » Rendering APP/Plugin/FrontendContents/View/Elements/gallery_mosaic.php	0.96
» » Rendering APP/View/Elements/icon.php #2	1.01
» » Rendering APP/View/Elements/icon.php #3	1.06
» » Rendering APP/View/Elements/icon.php #4	1.12
» » Rendering APP/View/Elements/icon.php #5	0.99
» » Rendering APP/View/Elements/icon.php #6	0.98
» » Rendering APP/View/Elements/icon.php #7	0.96
» » Rendering APP/View/Elements/icon.php #8	1.00
» » Rendering APP/View/Elements/icon.php #9	0.96
» » Rendering APP/Plugin/FrontendTours/View/Elements/teaser_slider.php	3.84
» » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php	1.24
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php	0.21
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/callout_icons.php	0.29
» » » Rendering APP/View/Elements/icon.php #10	0.97
» » » Rendering APP/View/Elements/icon.php #11	0.24
» » » Rendering APP/View/Elements/icon.php #12	0.93
» Event: View.afterRender	0.09
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/1.php	35.00
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.49
» » Rendering APP/View/Elements/header/header.php	18.54
» » » Rendering APP/View/Elements/header/header_navbar.php	18.37
» » » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.07
» » » » Rendering APP/View/Elements/navigation_secondary.php	3.81
» » » » » Rendering APP/View/Elements/icon.php #13	1.09
» » » » » Rendering APP/View/Elements/icon.php #14	0.25
» » » » » Rendering APP/View/Elements/icon.php #15	0.21
» » » » » Rendering APP/View/Elements/icon.php #16	0.94
» » » » Rendering APP/View/Elements/navigation.php	13.05
» » » » » Rendering APP/View/Elements/icon.php #17	0.22
» » » » » Rendering APP/View/Elements/icon.php #18	0.20
» » » » » Rendering APP/View/Elements/icon.php #19	0.23
» » » » » Rendering APP/View/Elements/icon.php #20	0.20
» » » » » Rendering APP/View/Elements/icon.php #21	0.20
» » » » » Rendering APP/View/Elements/icon.php #22	0.24
» » » » » Rendering APP/View/Elements/icon.php #23	0.20
» » » » » Rendering APP/View/Elements/icon.php #24	0.21
» » » » » Rendering APP/View/Elements/icon.php #25	0.19
» » » » » Rendering APP/View/Elements/icon.php #26	0.19
» » » » » Rendering APP/View/Elements/icon.php #27	0.19
» » » » » Rendering APP/View/Elements/icon.php #28	0.19
» » » » » Rendering APP/View/Elements/icon.php #29	0.23
» » » » » Rendering APP/View/Elements/icon.php #30	0.19
» » » » » Rendering APP/View/Elements/icon.php #31	0.19
» » » » » Rendering APP/View/Elements/icon.php #32	0.23
» » » » » Rendering APP/View/Elements/icon.php #33	0.20
» » » » » Rendering APP/View/Elements/icon.php #34	0.20
» » » » » Rendering APP/View/Elements/icon.php #35	0.23
» » » » » Rendering APP/View/Elements/icon.php #36	0.21
» » » » » Rendering APP/View/Elements/icon.php #37	0.20
» » » » » Rendering APP/View/Elements/icon.php #38	0.19
» » » » » Rendering APP/View/Elements/icon.php #39	0.20
» » » » » Rendering APP/View/Elements/icon.php #40	0.20
» » » » » Rendering APP/View/Elements/icon.php #41	0.19
» » » » » Rendering APP/View/Elements/icon.php #42	0.21
» » » » » Rendering APP/View/Elements/icon.php #43	0.20
» » » » » Rendering APP/View/Elements/icon.php #44	0.23
» » » » » Rendering APP/View/Elements/icon.php #45	0.21
» » » » » Rendering APP/View/Elements/icon.php #46	0.20
» » » » » Rendering APP/View/Elements/icon.php #47	0.20
» » » » » Rendering APP/View/Elements/icon.php #48	0.24
» » » » » Rendering APP/View/Elements/icon.php #49	0.20
» » » » » Rendering APP/View/Elements/icon.php #50	0.20
» » » » » Rendering APP/View/Elements/icon.php #51	0.20
» » » » » Rendering APP/View/Elements/icon.php #52	0.20
» » » » » Rendering APP/View/Elements/icon.php #53	0.20
» » » » » Rendering APP/View/Elements/icon.php #54	0.24
» » » » » Rendering APP/View/Elements/icon.php #55	0.21
» » » » » Rendering APP/View/Elements/icon.php #56	0.20
» » » » » Rendering APP/View/Elements/icon.php #57	0.22
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php #2	0.60
» » Rendering APP/View/Elements/footer/footer.php	7.13
» » » Rendering APP/View/Elements/icon.php #58	0.96
» » » Rendering APP/View/Elements/icon.php #59	0.92
» » » Rendering APP/View/Elements/logos/logo-instagram.php	0.08
» » » Rendering APP/View/Elements/logos/logo-youtube.php	0.07
» » » Rendering APP/View/Elements/logos/logo-facebook.php	0.07
» » » Rendering APP/View/Elements/logos/logo-alpine-welten.php #2	0.12
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php	0.07
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php	0.07
» » » Rendering APP/View/Elements/footer/footer_newsletter_subscribe.php	0.17
» » » Rendering APP/View/Elements/logos/logo-adidas-terrex.php	0.09
» » » Rendering APP/View/Elements/logos/logo-adidas-eyewear.php	0.07
» » » Rendering APP/View/Elements/logos/logo-petzl.php	0.07
» » » Rendering APP/View/Elements/logos/logo-pieps.php	0.07
» » » Rendering APP/View/Elements/logos/logo-kaestle.php	0.07
» » » Rendering APP/View/Elements/logos/logo-diamir.php	0.07
» » » Rendering APP/View/Elements/logos/logo-komperdell.php	0.07
» » » Rendering APP/View/Elements/logos/logo-scarpa.php	0.07
» » » Rendering APP/View/Elements/logos/logo-exped.php	0.07
» » » Rendering APP/View/Elements/logos/logo-abs.php	0.07
» » » Rendering APP/View/Elements/logos/logo-hilleberg.php	0.07
» » Rendering APP/View/Elements/contact_widget.php	5.30
» » » Rendering APP/View/Elements/icon.php #60	1.00
» » » Rendering APP/View/Elements/icon.php #61	0.95
» » » Rendering APP/View/Elements/icon.php #62	0.88
» » » Rendering APP/View/Elements/icon.php #63	0.90
» » » Rendering APP/View/Elements/icon.php #64	0.86
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- accomodation(array)
 Accomodation(array)
 id581
 hashbff6e4fb37f89368892b976b9c0b1901
 created2020-12-14 13:21:38
 updated2024-10-24 10:40:33
 number900581
 nameHotel Grimsel
 typehotel
 ownersFam. Manfred Zeiter
 phone_cabin+41 (0)27 973 11 56
 phone_valleyA
 mobile
 fax+41 (0)27 973 17 50
 emailinfo@hotelgrimsel.ch
 urlhttps://www.hotelgrimsel.ch/
 zip3988
 cityObergesteln
 street
 country
 region_area_id166
 remarkinfo@hotelgrimsel.ch
 geopoint_lat46.513866
 geopoint_long8.323858
 cancellation_period20
 tighter_cancellation_period(false)
 statusinactive
 sublineDas gemütliche Hotel in Obergoms
 height1.355
 video_url
 opening_hours4095
 premises
 equipment10527
 currency2
 detail_description
 days_before_to_send_participant_list14
 country_id182
 url_booking_system
 importancenone
 participant_list_necessary(true)
 reservation_through_agency(false)
 reduction_not_necessary(false)
 geopoint46.513866,8.323858
 RegionArea(array)
 id166
 hash88bdbb299f7180bb60df7ee45a0193f1
 created2020-12-14 13:18:42
 updated2020-12-14 13:18:42
 titleObergoms
 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)
 lft6119
 rght6120
 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)
 id5451
 hash30c3d2367ef94eb54c8154f8b548e485
 created2020-12-14 13:21:38
 updated2024-10-24 10:40:33
 modelAccomodation
 foreign_key581
 base/
 aliashotel-grimsel
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft6723
 rght6724
 route/hotel-grimsel
 Seo(array)
 id5306
 hashafd56e8c1842396e21cb8d720bbc91b3
 created2020-12-14 13:21:38
 updated2024-10-24 10:40:34
 modelAccomodation
 foreign_key581
 title
 description
 internal_keywords
 author
 tw_creator
 fb_author
 robots2
 sitemap_priority0.5
 TeaserMedia(array)
 0(array)
 id14286
 hash7b512f5eacfc333aaf6cf12706e31474
 created2024-10-24 10:37:00
 updated2024-10-24 10:37:00
 titleHotel Grimsel
 cross_reference_count1
 MediaEntity(array)
 id612460
 pos1
 media_id14286
 modelAccomodation
 fieldteaser
 foreign_key581
 FileUpload(array)
 0(array)
 id821280
 hash799cc5c3c98bfc7186c80379054d1c7a
 created2024-10-24 10:36:58
 updated2024-10-24 10:37:00
 modelMedia
 fieldfile
 foreign_key14286
 aliashotel-grimsel-aussenansicht.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/671a072c6a7ff.jpg
 size371866
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id821281
 hashdf601febab51bc50f4354a0d8c213ed7
 created2024-10-24 10:37:00
 updated2024-10-24 10:37:00
 modelMedia
 fieldfile
 foreign_key14286
 aliashotel-grimsel-aussenansicht-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id821280
 filewebroot/files/Media/File/ThMediaFileIndex/671a072c6b6f4.jpg
 size23062
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id821282
 hash265ba0336fa8a5a8b02597c3f731f684
 created2024-10-24 10:37:00
 updated2024-10-24 10:37:00
 modelMedia
 fieldfile
 foreign_key14286
 aliashotel-grimsel-aussenansicht-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id821280
 filewebroot/files/Media/File/CkeditorXs/671a072c8502b.jpg
 size7620
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id821283
 hashd633699ef0bf4c1d97c5c6d3dd0beaf2
 created2024-10-24 10:37:00
 updated2024-10-24 10:37:00
 modelMedia
 fieldfile
 foreign_key14286
 aliashotel-grimsel-aussenansicht-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id821280
 filewebroot/files/Media/File/CkeditorSm/671a072ca8d88.jpg
 size23062
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id821284
 hasheae7d5126b97c7d85f40041b4f4db016
 created2024-10-24 10:37:00
 updated2024-10-24 10:37:00
 modelMedia
 fieldfile
 foreign_key14286
 aliashotel-grimsel-aussenansicht-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id821280
 filewebroot/files/Media/File/CkeditorMd/671a072cc06c8.jpg
 size36752
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id821285
 hash161756a748d7dead585c28d6dd41c209
 created2024-10-24 10:37:00
 updated2024-10-24 10:37:00
 modelMedia
 fieldfile
 foreign_key14286
 aliashotel-grimsel-aussenansicht-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id821280
 filewebroot/files/Media/File/CkeditorLg/671a072cd56a5.jpg
 size74953
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id821343
 hash6d66e733963353cd2b6143ae9c0de7a8
 created2024-10-24 10:40:34
 updated2024-10-24 10:40:34
 modelMedia
 fieldfile
 foreign_key14286
 aliashotel-grimsel-aussenansicht-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id821280
 filewebroot/files/Media/File/ThAccomodationTeaserImage/671a0801e86ab.jpg
 size73959
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 GalleryMedia(array)
 0(array)
 id14287
 hash49d0fe9708adf501ae68a9dcc3f88f4f
 created2024-10-24 10:37:28
 updated2024-10-24 10:37:28
 titleHotel Grimsel Panorama
 cross_reference_count1
 MediaEntity(array)
 id612461
 pos1
 media_id14287
 modelAccomodation
 fieldgallery
 foreign_key581
 FileUpload(array)
 0(array)
 id821286
 hash3dfae6cac7744b6d310d7b476d4fee0b
 created2024-10-24 10:37:27
 updated2024-10-24 10:37:28
 modelMedia
 fieldfile
 foreign_key14287
 aliashotel-grimsel-aussenansicht-panorama.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/671a0748de11b.jpg
 size343861
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id821287
 hash1c38d9b9eedf15f1f47a7c6a13b4a917
 created2024-10-24 10:37:28
 updated2024-10-24 10:37:28
 modelMedia
 fieldfile
 foreign_key14287
 aliashotel-grimsel-aussenansicht-panorama-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id821286
 filewebroot/files/Media/File/ThMediaFileIndex/671a0748df033.jpg
 size24124
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id821288
 hashe61eb90be4dcfad99d5c74a55e019590
 created2024-10-24 10:37:29
 updated2024-10-24 10:37:29
 modelMedia
 fieldfile
 foreign_key14287
 aliashotel-grimsel-aussenansicht-panorama-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id821286
 filewebroot/files/Media/File/CkeditorXs/671a0748f2d10.jpg
 size7991
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id821289
 hash154a5d30eb51529edb1c9b9ea8ab9832
 created2024-10-24 10:37:29
 updated2024-10-24 10:37:29
 modelMedia
 fieldfile
 foreign_key14287
 aliashotel-grimsel-aussenansicht-panorama-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id821286
 filewebroot/files/Media/File/CkeditorSm/671a07491fd6a.jpg
 size24124
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id821290
 hash67dd5a6b633798713e6ab79f383d2636
 created2024-10-24 10:37:29
 updated2024-10-24 10:37:29
 modelMedia
 fieldfile
 foreign_key14287
 aliashotel-grimsel-aussenansicht-panorama-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id821286
 filewebroot/files/Media/File/CkeditorMd/671a07493423b.jpg
 size38337
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id821291
 hashd9405a83a181c935dbb8d04c515e2a2e
 created2024-10-24 10:37:29
 updated2024-10-24 10:37:29
 modelMedia
 fieldfile
 foreign_key14287
 aliashotel-grimsel-aussenansicht-panorama-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id821286
 filewebroot/files/Media/File/CkeditorLg/671a074948429.jpg
 size77554
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id821344
 hash876a69672d3fed2f87314fe0694a14ec
 created2024-10-24 10:40:34
 updated2024-10-24 10:40:34
 modelMedia
 fieldfile
 foreign_key14287
 aliashotel-grimsel-aussenansicht-panorama-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id821286
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/671a0802115d1.jpg
 size143801
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 1(array)
 id14288
 hash394dbe4078e5d72c2c155a80500de695
 created2024-10-24 10:37:47
 updated2024-10-24 10:37:47
 titleHotel Grimsel 2Bett
 cross_reference_count1
 MediaEntity(array)
 id612462
 pos2
 media_id14288
 modelAccomodation
 fieldgallery
 foreign_key581
 FileUpload(array)
 0(array)
 id821292
 hash0e0db60920a42220167b055b67d037ae
 created2024-10-24 10:37:37
 updated2024-10-24 10:37:47
 modelMedia
 fieldfile
 foreign_key14288
 aliashotel-grimsel-2bett-2.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/671a075b84bcf.jpg
 size293563
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id821293
 hash3984609392ea3a8a9f917a1177066d9d
 created2024-10-24 10:37:47
 updated2024-10-24 10:37:47
 modelMedia
 fieldfile
 foreign_key14288
 aliashotel-grimsel-2bett-2-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id821292
 filewebroot/files/Media/File/ThMediaFileIndex/671a075b863a3.jpg
 size17148
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id821294
 hash4a7459a7e44f31284ae3e640425602ee
 created2024-10-24 10:37:47
 updated2024-10-24 10:37:47
 modelMedia
 fieldfile
 foreign_key14288
 aliashotel-grimsel-2bett-2-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id821292
 filewebroot/files/Media/File/CkeditorXs/671a075b9edbf.jpg
 size6129
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id821295
 hash9e2ed701640f54a528a96316557d0413
 created2024-10-24 10:37:47
 updated2024-10-24 10:37:47
 modelMedia
 fieldfile
 foreign_key14288
 aliashotel-grimsel-2bett-2-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id821292
 filewebroot/files/Media/File/CkeditorSm/671a075bc373c.jpg
 size17148
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id821296
 hash246312e43c3e4d1bfae8842911ae76b5
 created2024-10-24 10:37:47
 updated2024-10-24 10:37:47
 modelMedia
 fieldfile
 foreign_key14288
 aliashotel-grimsel-2bett-2-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id821292
 filewebroot/files/Media/File/CkeditorMd/671a075bda532.jpg
 size26466
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id821297
 hashb4d7c5fb7b0efdacee5d76140a478049
 created2024-10-24 10:37:48
 updated2024-10-24 10:37:48
 modelMedia
 fieldfile
 foreign_key14288
 aliashotel-grimsel-2bett-2-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id821292
 filewebroot/files/Media/File/CkeditorLg/671a075beb91d.jpg
 size51848
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id821345
 hash8220625f7610dee821b39ef68c120908
 created2024-10-24 10:40:34
 updated2024-10-24 10:40:34
 modelMedia
 fieldfile
 foreign_key14288
 aliashotel-grimsel-2bett-2-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id821292
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/671a08022db42.jpg
 size74933
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id14289
 hash29ee47feded10186b201507fe3932945
 created2024-10-24 10:38:03
 updated2024-10-24 10:38:03
 titleHotel Grimsel Zimmer
 cross_reference_count1
 MediaEntity(array)
 id612463
 pos3
 media_id14289
 modelAccomodation
 fieldgallery
 foreign_key581
 FileUpload(array)
 0(array)
 id821298
 hash0eddab81f19a871863f0be0ae26bcfc2
 created2024-10-24 10:38:01
 updated2024-10-24 10:38:03
 modelMedia
 fieldfile
 foreign_key14289
 aliashotel-grimsel-zimmer.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/671a076b3eb24.jpg
 size295888
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id821299
 hash17212f133771181e4fea6dbb65751e04
 created2024-10-24 10:38:03
 updated2024-10-24 10:38:03
 modelMedia
 fieldfile
 foreign_key14289
 aliashotel-grimsel-zimmer-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id821298
 filewebroot/files/Media/File/ThMediaFileIndex/671a076b3fbd5.jpg
 size18417
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id821300
 hashc29523f7bbc34a56ab8f769b1a3e243a
 created2024-10-24 10:38:03
 updated2024-10-24 10:38:03
 modelMedia
 fieldfile
 foreign_key14289
 aliashotel-grimsel-zimmer-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id821298
 filewebroot/files/Media/File/CkeditorXs/671a076b59361.jpg
 size6725
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id821301
 hash64dbc2a9e6cb53b8191c11a7efe9337f
 created2024-10-24 10:38:03
 updated2024-10-24 10:38:03
 modelMedia
 fieldfile
 foreign_key14289
 aliashotel-grimsel-zimmer-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id821298
 filewebroot/files/Media/File/CkeditorSm/671a076b7f041.jpg
 size18417
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id821302
 hash966cb26f63129249229c37d783abc729
 created2024-10-24 10:38:03
 updated2024-10-24 10:38:03
 modelMedia
 fieldfile
 foreign_key14289
 aliashotel-grimsel-zimmer-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id821298
 filewebroot/files/Media/File/CkeditorMd/671a076b92116.jpg
 size27419
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id821303
 hashdadf483d012309e29b18e7bc29b62f6b
 created2024-10-24 10:38:03
 updated2024-10-24 10:38:03
 modelMedia
 fieldfile
 foreign_key14289
 aliashotel-grimsel-zimmer-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id821298
 filewebroot/files/Media/File/CkeditorLg/671a076ba5eb2.jpg
 size53027
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id821346
 hash7720ddc03fe66b4b770f11c37c9bf925
 created2024-10-24 10:40:34
 updated2024-10-24 10:40:34
 modelMedia
 fieldfile
 foreign_key14289
 aliashotel-grimsel-zimmer-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id821298
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/671a080242668.jpg
 size76417
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id14290
 hash8425321dea9f515a38777f94bfc27be6
 created2024-10-24 10:38:22
 updated2024-10-24 10:38:22
 titleHotel Grimsel 2Bett 2
 cross_reference_count1
 MediaEntity(array)
 id612464
 pos4
 media_id14290
 modelAccomodation
 fieldgallery
 foreign_key581
 FileUpload(array)
 0(array)
 id821304
 hash44c1bbcf2ba10cf44539b75ab9bdde03
 created2024-10-24 10:38:14
 updated2024-10-24 10:38:22
 modelMedia
 fieldfile
 foreign_key14290
 aliashotel-grimsel-zimmer-2bett.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/671a077ea8039.jpg
 size326353
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id821305
 hash3ec9c767f298c03550123b0280d4ec8e
 created2024-10-24 10:38:22
 updated2024-10-24 10:38:22
 modelMedia
 fieldfile
 foreign_key14290
 aliashotel-grimsel-zimmer-2bett-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id821304
 filewebroot/files/Media/File/ThMediaFileIndex/671a077ea9167.jpg
 size18543
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id821306
 hash3f284a3bab8e50cb6c2dc9f34bfccdaa
 created2024-10-24 10:38:22
 updated2024-10-24 10:38:22
 modelMedia
 fieldfile
 foreign_key14290
 aliashotel-grimsel-zimmer-2bett-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id821304
 filewebroot/files/Media/File/CkeditorXs/671a077ec398c.jpg
 size6538
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id821307
 hash7505782aae45915427b154dd38cbaf6c
 created2024-10-24 10:38:23
 updated2024-10-24 10:38:23
 modelMedia
 fieldfile
 foreign_key14290
 aliashotel-grimsel-zimmer-2bett-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id821304
 filewebroot/files/Media/File/CkeditorSm/671a077ee6e60.jpg
 size18543
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id821308
 hash7f4676dc3db222be3e2ab867817d9d21
 created2024-10-24 10:38:23
 updated2024-10-24 10:38:23
 modelMedia
 fieldfile
 foreign_key14290
 aliashotel-grimsel-zimmer-2bett-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id821304
 filewebroot/files/Media/File/CkeditorMd/671a077f09857.jpg
 size28750
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id821309
 hash2798781773214deb05266dfd9a1305e6
 created2024-10-24 10:38:23
 updated2024-10-24 10:38:23
 modelMedia
 fieldfile
 foreign_key14290
 aliashotel-grimsel-zimmer-2bett-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id821304
 filewebroot/files/Media/File/CkeditorLg/671a077f1c81b.jpg
 size56609
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id821347
 hashf136bea367cb891668d782348db75443
 created2024-10-24 10:40:34
 updated2024-10-24 10:40:34
 modelMedia
 fieldfile
 foreign_key14290
 aliashotel-grimsel-zimmer-2bett-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id821304
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/671a08025b4ec.jpg
 size85430
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 4(array)
 id14291
 hashceb253b7513e8717112355f17fbcfc44
 created2024-10-24 10:38:44
 updated2024-10-24 10:38:44
 titleHotel Grimsel Garten Schaukel
 cross_reference_count1
 MediaEntity(array)
 id612465
 pos5
 media_id14291
 modelAccomodation
 fieldgallery
 foreign_key581
 FileUpload(array)
 0(array)
 id821310
 hash59f6b40f45bd286091393b7742b26076
 created2024-10-24 10:38:30
 updated2024-10-24 10:38:44
 modelMedia
 fieldfile
 foreign_key14291
 aliashotel-grimsel-garten-schauke.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/671a0794047b0.jpg
 size355710
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id821311
 hash09ca34cd59eaa619b8b156ee4947778f
 created2024-10-24 10:38:44
 updated2024-10-24 10:38:44
 modelMedia
 fieldfile
 foreign_key14291
 aliashotel-grimsel-garten-schauke-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id821310
 filewebroot/files/Media/File/ThMediaFileIndex/671a0794060ae.jpg
 size24377
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id821312
 hash48cb864a88950ddb48b144ebb673aa58
 created2024-10-24 10:38:44
 updated2024-10-24 10:38:44
 modelMedia
 fieldfile
 foreign_key14291
 aliashotel-grimsel-garten-schauke-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id821310
 filewebroot/files/Media/File/CkeditorXs/671a07941c176.jpg
 size7913
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id821313
 hashf20831367273741ad73867fda5b47876
 created2024-10-24 10:38:44
 updated2024-10-24 10:38:44
 modelMedia
 fieldfile
 foreign_key14291
 aliashotel-grimsel-garten-schauke-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id821310
 filewebroot/files/Media/File/CkeditorSm/671a07943c938.jpg
 size24377
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id821314
 hash9dd8a23f2b697cfb6da49def15c13156
 created2024-10-24 10:38:44
 updated2024-10-24 10:38:44
 modelMedia
 fieldfile
 foreign_key14291
 aliashotel-grimsel-garten-schauke-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id821310
 filewebroot/files/Media/File/CkeditorMd/671a07944f869.jpg
 size38671
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id821315
 hash1bad3d74d4babc81206a4af7d9970680
 created2024-10-24 10:38:44
 updated2024-10-24 10:38:44
 modelMedia
 fieldfile
 foreign_key14291
 aliashotel-grimsel-garten-schauke-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id821310
 filewebroot/files/Media/File/CkeditorLg/671a079460b23.jpg
 size79199
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id821348
 hash5d52a46b044a095b6cdd2c8da5142a87
 created2024-10-24 10:40:34
 updated2024-10-24 10:40:34
 modelMedia
 fieldfile
 foreign_key14291
 aliashotel-grimsel-garten-schauke-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id821310
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/671a0802732bb.jpg
 size149416
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 5(array)
 id14292
 hashc50e895b45bd3332829e30294e2f58f5
 created2024-10-24 10:39:03
 updated2024-10-24 10:39:03
 titleHotel Grimsel Speisesaal
 cross_reference_count1
 MediaEntity(array)
 id612466
 pos6
 media_id14292
 modelAccomodation
 fieldgallery
 foreign_key581
 FileUpload(array)
 0(array)
 id821316
 hash0a902fec3280ff863db12e2032ce4d12
 created2024-10-24 10:38:52
 updated2024-10-24 10:39:03
 modelMedia
 fieldfile
 foreign_key14292
 aliashotel-grimsel-speiseraum.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/671a07a7bf9dc.jpg
 size369756
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id821331
 hashb45ef5a9e0c7cabefc8d0000f452a7da
 created2024-10-24 10:39:03
 updated2024-10-24 10:39:03
 modelMedia
 fieldfile
 foreign_key14292
 aliashotel-grimsel-speiseraum-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id821316
 filewebroot/files/Media/File/ThMediaFileIndex/671a07a7c0573.jpg
 size20124
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id821332
 hash885fdc26a52b2293f0d902e8656c43b5
 created2024-10-24 10:39:04
 updated2024-10-24 10:39:04
 modelMedia
 fieldfile
 foreign_key14292
 aliashotel-grimsel-speiseraum-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id821316
 filewebroot/files/Media/File/CkeditorXs/671a07a7d2fbd.jpg
 size7059
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id821333
 hash6558910384ccc0e78d762c6d6c2028f3
 created2024-10-24 10:39:04
 updated2024-10-24 10:39:04
 modelMedia
 fieldfile
 foreign_key14292
 aliashotel-grimsel-speiseraum-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id821316
 filewebroot/files/Media/File/CkeditorSm/671a07a803c2c.jpg
 size20124
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id821334
 hashfdc46f11735f1d0bd5a4d0f6445b298f
 created2024-10-24 10:39:04
 updated2024-10-24 10:39:04
 modelMedia
 fieldfile
 foreign_key14292
 aliashotel-grimsel-speiseraum-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id821316
 filewebroot/files/Media/File/CkeditorMd/671a07a81c723.jpg
 size31004
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id821335
 hash1ec4d8f91ae5124c659042aef2bd2d26
 created2024-10-24 10:39:04
 updated2024-10-24 10:39:04
 modelMedia
 fieldfile
 foreign_key14292
 aliashotel-grimsel-speiseraum-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id821316
 filewebroot/files/Media/File/CkeditorLg/671a07a82f8d3.jpg
 size60898
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id821349
 hasha781a287212eca284c80ff81688646a6
 created2024-10-24 10:40:34
 updated2024-10-24 10:40:34
 modelMedia
 fieldfile
 foreign_key14292
 aliashotel-grimsel-speiseraum-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id821316
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/671a08028b2fd.jpg
 size98063
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 6(array)
 id14293
 hash7fcc032cf7d41b40fdc8d1e0ae4ccbf7
 created2024-10-24 10:39:28
 updated2024-10-24 10:39:28
 titleHotel Grimsel Panoramablick
 cross_reference_count1
 MediaEntity(array)
 id612467
 pos7
 media_id14293
 modelAccomodation
 fieldgallery
 foreign_key581
 FileUpload(array)
 0(array)
 id821336
 hashc3165b33d911fa3690af13aed85c88f7
 created2024-10-24 10:39:13
 updated2024-10-24 10:39:28
 modelMedia
 fieldfile
 foreign_key14293
 aliashotel-grimsel-panorama.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/671a07c027301.jpg
 size372096
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id821337
 hash4b10b1114abc6ec311ef2db1bba2dc06
 created2024-10-24 10:39:28
 updated2024-10-24 10:39:28
 modelMedia
 fieldfile
 foreign_key14293
 aliashotel-grimsel-panorama-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id821336
 filewebroot/files/Media/File/ThMediaFileIndex/671a07c028a39.jpg
 size19252
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id821338
 hashbc34d53d2496159336e0e8801c0215aa
 created2024-10-24 10:39:28
 updated2024-10-24 10:39:28
 modelMedia
 fieldfile
 foreign_key14293
 aliashotel-grimsel-panorama-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id821336
 filewebroot/files/Media/File/CkeditorXs/671a07c04264c.jpg
 size6437
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id821339
 hash535c5806ce3ac97cfcbf629dd5c77467
 created2024-10-24 10:39:28
 updated2024-10-24 10:39:28
 modelMedia
 fieldfile
 foreign_key14293
 aliashotel-grimsel-panorama-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id821336
 filewebroot/files/Media/File/CkeditorSm/671a07c067750.jpg
 size19252
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id821340
 hash3e1d91458dc867a6ab0bb120f6ef10a0
 created2024-10-24 10:39:28
 updated2024-10-24 10:39:28
 modelMedia
 fieldfile
 foreign_key14293
 aliashotel-grimsel-panorama-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id821336
 filewebroot/files/Media/File/CkeditorMd/671a07c07c01f.jpg
 size30086
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id821341
 hasheeda4fde35a2f1569d7d815318d1698c
 created2024-10-24 10:39:28
 updated2024-10-24 10:39:28
 modelMedia
 fieldfile
 foreign_key14293
 aliashotel-grimsel-panorama-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id821336
 filewebroot/files/Media/File/CkeditorLg/671a07c08d55f.jpg
 size61567
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id821350
 hash4281e5daa94ebce2f0b9b8d7c6ea682f
 created2024-10-24 10:40:34
 updated2024-10-24 10:40:34
 modelMedia
 fieldfile
 foreign_key14293
 aliashotel-grimsel-panorama-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id821336
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/671a0802a25e8.jpg
 size125986
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 TagsTag(empty)
 TravelReport(empty)
- accomodationTours(array)
 0(array)
 Tour(array)
 id407
 hash2303d92cc17ae026b0c6712c8b3765b8
 created2020-12-02 09:34:34
 updated2024-10-16 14:10:48
 tour_number420000000407
 titleDer Vier-Quellen-Weg in der Zentralschweiz
 subtitleZu Fuß vom Oberalppass bis zum Rhonegletscher
 participants_min6
 participants_max10
 duration_days5
 duration_typetour_week
 tour_price1149.00
 down_payment20
 country_of_serviceswiss
 saisonsummer
 travel_insurance_certificate(true)
 out_of_alpine_tour(false)
 rating_condition3
 rating_technique2
 rating_experience1
 rating_difficulty_categoryeasy
 rating_seriousness2
 rating_overall_score2.0
 start_zip6490
 start_cityAndermatt
 start_streetOberalppass
 start_countryCH
 start_meeting_pointLeuchtturm am Oberalppass
 start_time10:30:00
 end_alternate_address(false)
 end_time13:00:00
 flight(false)
 flight_details(null)
 consultation
 region_id10
 services_excluded
 mountain_guide_tour_info
 video_url
 customer_tour_info
 firm_id1
 gmap_zoom13
 gmap_long8.671049
 gmap_marker(false)
 gmap_typeoa_map
 gmap_lat46.658478
 callout_iconnew
 travel_information<h3>Details Anreise:</h3> Treffpunkt zur Tour ist am Leuchtturm auf dem Oberalppass. <h3>Bahnanreise:</h3> Die Anreise zum Oberalppass ist auch mit dem Zug sehr gut möglich. Beispielsweise von München führt die Verbindung über St. Margrethen und Chur in ca. 6 Stunden direkt zum Ziel. Die Fahrtzeit mit dem Auto ist nur unwesentlich kürzer. Den aktuellen Fahrplan, Abfahrtszeiten und Kosten kannst Du auf www.bahn.de ermitteln.
 meeting_point_map_lat46.659943
 meeting_point_map_marker(true)
 meeting_point_map_typeoa_map
 meeting_point_map_zoom10
 meeting_point_map_long8.672154
 previous_url
 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, welches 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. 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> </h2> <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 ins Gepäck 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_cancellation11
 execution_feasibilitymedium
 days_before_start_for_last_notice11
 last_tour_date_number144
 tourstart_weekday1
 mountain_guide_tour_search_information
 customer_tour_material_info
 material_list_link
 callout_icon_multiple12
 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.658478,8.671049
 meeting_point_map46.659943,8.672154
 end_zip6490
 end_cityAndermatt
 end_streetOberalppass
 end_countryCH
 price_excl_flight1149.00
 highlight0
 TourTexts(array)
 id398
 hashd55825d474941da9763373a231c40718
 created2020-12-02 09:34:35
 updated2024-10-16 14:11:01
 tour_id407
 ws_text_short_descriptionMehrtägige Hüttenwanderung durch das eindrucksvolle Gotthardmassiv und zum Ursprung der vier Flüsse Rhein, Reuss, Ticino und Rhone.
 ws_text_requirementsMittelschwere Bergwege ROT. Für diese geführte Bergwanderung durch das Gotthardmassiv solltest Du sportlich sein und über eine gute Kondition für Gehzeiten bis 6,5 Stunden verfügen. Die Aufstiege bei dieser Wanderung betragen maximal 1.250 Höhenmeter am Tag, wobei die Tagesetappen in ihrer Intensität aufeinander aufbauen. Die durchschnittliche Geschwindigkeit im Aufstieg beträgt ca. 300 Höhenmeter pro Stunde. Die Wanderung ist ideal für sportliche Bergwanderer geeignet, die sich auch auf teils schmalen Bergwegen wohlfühlen und das Gebiet des Gotthardmassivs kennen lernen möchten. <h3>Geringe Alpine Erfahrung | Mittlere alpine Unternehmung</h3> <ul> <li>Mäßige Ernsthaftigkeit / Gefährdung</li> <li>Erfahrung Bergwandern</li> <li>Trittsicherheit</li> <li>Idealer Einstieg für mehrtägiges alpines Bergwandern</li> </ul> 1.260 Hm 1.350 Hm 800m 6,5 h ROT Frühstück
 ws_text_travel_program<h3>1. Tag: Vom Oberalppass zur Rheinquelle</h3> Am Morgen treffen wir uns direkt am Leuchtturm des Oberalppasses (2.044 m) und starten entlang der Wandertafeln zu unserem ersten Etappenpunkt, dem Tomasee. Über ein abfallendes Geländestück, über Steintreppen und über Alpwiesen führt der Weg direkt zum Fuße des Berges Badus (2.928 m), wo in schönster Landschaft glitzernd der Tomasee (Lai da Toma, 2.345 m) ruht. Dieser Ort ist auch zugleich die Rhein Quelle, durch welche der See erst entstehen konnte. Der Weiterweg zum Maighelspass (2.421 m) führt uns an unzähligen Bächen vorbei, durch Feuchtgebiete und vorbei am Urlaunsee (Lai Urlaun), dessen Umgebung mit einer ausgeprägten einheimischen Pflanzen- und Blumenwelt geschmückt ist. Wer diesen Weg im Herbst begeht, kann sogar noch in den Genuss der vielen Wollgräser kommen, die wie kleine weiße Schneebälle über die weiten Wiesenflächen im Wind tanzen. Schon kurz nach dem Maighelspass entdecken wir den idyllischen Portgerensee, der gleichfalls ein beliebtes Ziel von Anglern ist und für uns der perfekte Ort für eine Rast in traumhaftem Bergambiente. Hier genießen wir die Aussicht, bevor wir an den Abstieg denken müssen und nach ca. einer weiteren Stunde Gehzeit unser Tagesziel, die gemütliche Vermigelhütte (2.042 m) erreichen. 680 Hm 690m 700 Hm 5 h sehr schwerHalbpension <h3>2. Tag: Aussicht genießen am Giübin (2.776 m)</h3> Bei der heutigen Tagesetappe steht unser höchster Gipfel des Vier-Quellen-Weges auf dem Programm, der Giüdin mit 2.776 m. Ihn zu überschreiten und den Gotthardpass zu erreichen ist unser Tagesziel. Nach dem Frühstück brechen wir von der Vermigelhütte auf und wandern zunächst durch liebliche Landschaft, die mit vielen Alpenrosen geschmückt ist. Bald schon können wir den Giüdin in der Ferne erblicken. Der Wanderweg führt uns durch eine Landschaft, die schon zu früheren Zeiten durch ihren Mineralreichtum bekannt geworden war. Zahlreiche bereits ausgebeutete Kristallklüfte sind Zeugen dieser Zeit und lassen uns einen Teil dieser geschichtlichen Reise nachempfinden. Schließlich erreichen wir unser Ziel und genießen die eindruckvollen Weitblicke über die Berge des Gotthardmassivs. Auf dem Abstieg passieren wir noch den Staudamm des glitzernden Sellasees (2.256 m), der eingebettet in der Bergwelt des Tessins liegt. Unterhalb des Staudamms steigen wir weiter ab und erreichen dort nach einem sehr eindrucksvollen Wandertag den Gotthardpass und unsere Unterkunft, wo wir den Tag gemütlich ausklingen lassen. 700 Hm 650 Hm 800m 5 h sehr schwerHalbpension <h3>3. Tag: Vom Gotthardpass zur Reuss-Quelle</h3> Auch der dritte Tag unserer Wanderung erwartet uns wieder mit einigen spannenden Erlebnissen. Nach dem Frühstück brechen wir auf und wandern zunächst in Richtung Lucendro Pass (2.522 m). Dabei passieren wir auch den Lucendro Stausee, der eingebettet im Bedrettotal liegt und dessen Staumauer bereits im zweiten Weltkrieg erbaut wurde. Rund sieben Prozent der Wasservorräte Europas lagern noch heute im Gotthardmassiv, was die enorme Bedeutung dieser Region, auch im Zusammenhang mit der Energiegewinnung bildhaft verdeutlicht. An der Staumauer empor führt uns der Weg zur Alpe di Lucendro und eröffnet den Blick auf den spiegelglatten See. Dieser einzigartige Ort ist der Ursprung der Reuss, die auf knapp 2.500 m Höhe entspringt und den Stausee durchgehend mit frischem Wasser speist. Nach einer Rast überqueren wir den Pass und folgen nach einem kurzen, steilen Abstieg dem aussichtsreichen Höhenweg "Sentiero Alto Bedretto", der über dem malerischen Bedrettotal verläuft und uns die Aussicht in vollen Zügen genießen lässt. Unterwegs haben wir noch die Möglichkeit ein paar Heidelbeeren zu sammeln, bevor wir mit der Piansecco-Hütte auf knapp 2.000 m unser Tagesziel erreichen. 750 Hm 850 Hm 800m 6,5 h sehr schwerHalbpension <h3>4. Tag: Vom Tessin ins Wallis und zur Ticino-Quelle</h3> Heute setzen wir unsere Wanderung in Richtung Nufenenpass fort. Wir wissen bereits, dass an dessen Fuße das einzigartige Quellgebiet des Ticino auf uns wartet und so starten wir motiviert in den Tag. Auf unserem Weg passieren wir die beiden Almen "Alpe di Manio" und "Alpe di Cruina" sowie mehrere Verkehrswege aus dem 17. und 18. Jahrhundert. Wir lernen die zentrale wirtschaftliche Rolle des Gotthardmassivs frührerer Zeiten kennen und verstehen dessen Bedeutung in der Blütezeit der Alpwirtschaft und der Warentransporte. Vorbei an abwechslungsreichen Gebirgsketten, über Wiesen, Hochebenen und durch Feuchtbiotope führt uns der Weg weiter Richtung Nufenenpass. Dabei überqueren wir auch noch eine historische Brücke aus dem Jahr 1761, die über eine Schlucht gespannt wurde. Angekommen an der Ticinoquelle gönnen wir uns eine Pause und lassen den Blick über die Wasseroberfläche schweifen, in der sich die umliegende Bergwelt glitzernd spiegelt. Dieser schöne Ort ist der Ursprung des Ticino, dessen langer Weg ins Tal schließlich im Lago Maggiore endet. Unterwegs bestaunen wir noch den wohl ältesten Baum der Schweiz - eine ca. 1.500 Jahre alte Lärche, bevor wir schließlich an unserer Unterkunft in Obergesteln ankommen. 600 Hm 1.350 Hm 800m 6,5 h sehr schwerHalbpension <h3>5. Tag: Von Obergoms zum Rhonegletscher</h3> Auf unserer letzten Etappe wartet nochmal ein echtes Highligt auf uns - der Rhonegletscher und die Rhonequelle. Bevor wir diese erreichen, gilt es aber erst noch einige Höhenmeter zu bewältigen. Von Obergoms führt unser Wanderweg hinauf zum Furkapass, dem heutigen Ausgangspunkt des Rhonegletschers. Im Jahr 1850 konnte man den Gletscher noch vom Dorf Gletsch aus erreichen, das ca. 500 Höhenmeter tiefer im Tal liegt. Über die vielen Jahre hat sich der Rhonegletscher aber bedingt durch den Klimawandel weit zurück gezogen und dadurch das Landschaftsbild stark verändert. Auf unserem knapp 1.300 Hm langen Anstieg durchqueren wir eindrucksvolle Gegenden und bestaunen die hochalpinen 4.000er der Schweizer Berge, die gar nicht mehr so weit entfernt zu sein scheinen. Schon der Anblick des Finsteraarhorns (4.274 m) und Lauteraarhorns (4.042 m) mit ihren angrenzenden Gletschern ist aus dieser Perspektive wirklich atemberaubend. Angekommen am früheren Hotel Belvédère ist es dann nur noch ein Katzensprung zum heutigen Ausgangspunkt des Rhonegletschers. Beim Anblick dessen wissen wir direkt, dass der mühsame Aufstieg jede Anstrengung wert war! Wunderschön und zugleich extrem vergänglich präsentiert sich uns das weiße Gletschermeer, das sich wie eingebettet in die alpine Bergkulisse schmiegt. Stolz auf unser Etappenziel gratulieren wir uns zu diesem Erfolg und erholen uns beim Anblick auf Gletscher und Rhonequelle. Dieser letzte Wandertag ist definitiv ein krönender Abschluss unserer gemeinsamen Wanderwoche! Mit dem Bus gehts anschließend in ca. 45 Minuten nach Andermatt, wo wir im Hotel unseren letzten Abend gemütlich ausklingen lassen. 1.250 Hm 350 Hm 800m 6,5 h sehr schwerHalbpension <h3>6. Tag: Rückfahrt zum Oberalppass</h3> Nach dem späten Frühstück machen wir uns mit dem Zug von Andermatt auf den Rückweg zu unseren Fahrzeugen am Oberalppass. Verabschiedung um die Mittagszeit. 860 Hm 1.480 Hm 800m7 h sehr schwerFrühstück <h3></h3> 
 ws_text_services<ul> <li>Speisen und Getränke außerhalb der Halbpension</li> <li>Individuelle Trinkgelder</li> </ul>
 ws_text_information
 ws_text_location_description<h3>Das Gotthardmassiv - Wasserschloss & Mittelpunkt Europas</h3> Bereits in frühen Zeiten des Handels spielte der Gotthard für die Menschen eine entscheidende Rolle. Mit nur einem Auf- und Abstieg bot er die Möglichkeit, die Alpen vergleichsweise einfach zu überqueren. Trotz dieses Vorteils konnte sich der Gotthard im römischen Reich nie zu einer zentralen Route im florierenden Handel entwickeln. Zu beschwerlich waren die Auf- und Abstiege, deren Wege erst nach und nach befestigt und angelegt werden konnten. Einzig für teure Luxusgüter wie Bücher, Gewürze, Wachs und Produkte des täglichen Bedarfs lohnte sich dieser kostspielige und zeitintensive Aufwand. Heute ist das Gotthardmassiv neben seiner bekannten Rolle als Verkehrnotenpunkt vor allem durch seine Berg-, Wasser-, Tier- und Pflanzenvielfalt bekannt und zieht noch immer zahlreiche Besucher in seinen Bann. Diese Vielfalt des Gotthards zu erleben, ist durch eine mehrtägige Etappenwanderung bestmöglich, da viele malerische Ecken fernab der Verkehrsstraßen liegen. Das besonderes Highlight dabei sind die Ursprünge der vier Flüsse Rhein, Reuss, Ticino und Rhone. Malerisch eingebettet inmitten einer atemberaubenden Bergwelt verstecken sich diese Quellen und bieten ihren Besuchern ein einzigartiges Berg- und Wassererlebnis. Verkehrstechnisch erzielte die Gotthardregion durch den 2016 eröffneten Gotthard-Basistunnel nach 17 Jahren Bauzeit einen Meilenstein im Personen- und Warenverkehr. Mit 57 km bietet dieser längste Eisenbahntunnel der Welt die Möglichkeit zu Transportfahrten in Hochgeschwindigkeit bis zu 250 km/h. Gerade im Hinblick auf autofreie Anreisemöglichkeiten in diese Region ist dadurch ein weiterer wichtiger Baustein gesetzt.
 ws_text_accomodationWährend der geführten Wanderung durch das Gotthardmassiv übernachten wir im Wechsel zwischen Hütte und Pesion/Hotel. In den Hütten erfolgt die Unterbringung im Mehrbettzimmer oder Lager, im Hotel/Pension schlafen wir in Doppelzimmern. Für alle Tourentage ist die Halbpension (Abendessen und Frühstück) inklusive. Die Hütten verfügen über Waschräume und bieten manchmal auch eine Duschmöglichkeit. Es erwarten Dich Übernachtungsplätze in traumhafter Lage, das Essen ist durchwegs sehr gut. <h3>Informationen zur Unterkunft</h3> <ul> <li>Hütten: Vermigelhütte / Capanna Piansecco</li> <li>Pensionen & Hotels: Albergo San Gottardo / Hotel Grimsel / Hotel Aurora Andermatt</li> </ul> Fragen zur Unterkunft | Wir geben Antworten!
 ws_text_course_content
 ws_text_overview
 ws_text_advantages<ul> <li>Wandergebiet Gotthardmassiv mit artenreicher Pflanzen- und Tiervielfalt</li> <li>Wunderschöne mehrtägige Bergwanderung</li> <li>2 x Hüttenübernachtung / 3 x Pension oder Hotel</li> <li>Geprüfter Bergwanderführer</li> </ul>
 ws_text_detail_description_new<h3>Von Hütte zu Hütte durch das wassergeprägte Gotthardmassiv</h3> Traumhafte mehrtägige Hüttenwanderung durch das Gotthardmassiv in der Zentralschweiz. Auf rund 85 km steht diese 6-tägige Bergwanderung ganz im Zeichen des Wassers, denn gleich vier Quellen bedeutender Flüsse werden wir auf dieser Wanderwoche entdecken: die der Flüsse Rhein, Reuss, Ticino und Rhone. Vorbei an Seen, Mooren und Bachläufen, durch Feuchtgebiete sowie über ausgedehnte Alpweiden führt dieser Weg durch die malerische Landschaft der vier Kantone Graubünden, Tessin, Wallis und Uri. Wir übernachten in gemütlichen Hütten und Hotels entlang des Weges, bei denen auch nach langen Wandertagen die Erholung nicht zu kurz kommt. Die Intensität der einzelnen Tagesetappen steigert sich bis zum Ende der Tour, so dass ein "Warm-Wandern" gut möglich ist. Die Region, welche wir in diesen Tagen erkunden, zählt zu den wasserreichsten der Alpen. Große Teile der umliegenden Gipfel führen noch Gletscher, die in tieferen Bergregionen mit dem "Lebenselixier Wasser" für eine prächtige Tier- und Pflanzenwelt sorgen.
 ws_text_information_new<h3> </h3> <h3>Mindestteilnehmerzahl</h3> Diese Reise kann nur ab der oben angegebenen Mindestteilnehmerzahl durchgeführt werden. Sollte diese 7 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, Schweizer Alpenclub SAC, Ö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_accomodation_new
 ws_text_arrival
 Route(array)
 id5427
 hash424e33176ae5a687367ddeef44029144
 created2020-12-02 09:34:34
 updated2024-10-16 14:11:01
 modelTour
 foreign_key407
 base/
 aliasder-vier-quellen-weg-in-der-zentralschweiz
 controllerFrontendTours.FrontendTours
 actiontour
 parent_id(null)
 lft6689
 rght6690
 route/der-vier-quellen-weg-in-der-zentralschweiz
 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)
 id37468
 tour_id407
 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)
 id14247
 hashfe9cdf9641730224fcef2ec9a83aa12e
 created2024-10-16 14:07:58
 updated2024-10-16 14:07:58
 title4Quellen Weitblick Tal und Berge
 cross_reference_count1
 MediaEntity(array)
 id611614
 pos1
 media_id14247
 modelTour
 fieldteaser_image
 foreign_key407
 FileUpload(array)
 0(array)
 id819970
 hashc9b5947a145d2e921fab58bb6e00111e
 created2024-10-16 14:07:53
 updated2024-10-16 14:07:58
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/670fac9e8d9c1.jpg
 size365184
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id819971
 hash2f1b2d91b0cdf035132bf68c15d1c3d5
 created2024-10-16 14:07:58
 updated2024-10-16 14:07:58
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id819970
 filewebroot/files/Media/File/ThMediaFileIndex/670fac9e8f0e0.jpg
 size14239
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id819972
 hash2cde8bbec55c62113d1b36cff13cbe7f
 created2024-10-16 14:07:58
 updated2024-10-16 14:07:58
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id819970
 filewebroot/files/Media/File/CkeditorXs/670fac9ea5cd6.jpg
 size4351
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id819973
 hashd7584484177851a83a77846a2925bc05
 created2024-10-16 14:07:58
 updated2024-10-16 14:07:58
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id819970
 filewebroot/files/Media/File/CkeditorSm/670fac9ec740e.jpg
 size14239
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id819974
 hash30eccfbba20801fa52d07465f83e56c9
 created2024-10-16 14:07:58
 updated2024-10-16 14:07:58
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id819970
 filewebroot/files/Media/File/CkeditorMd/670fac9edc16f.jpg
 size22994
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id819975
 hash3be4cb7293a6310c17c00e303b480e96
 created2024-10-16 14:07:59
 updated2024-10-16 14:07:59
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id819970
 filewebroot/files/Media/File/CkeditorLg/670fac9ef0dd9.jpg
 size50540
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id819976
 hash009887a3b95f2730135a851c4cd9a43e
 created2024-10-16 14:10:59
 updated2024-10-16 14:10:59
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge-thtourteaserimage.jpg
 thumbnailth-tour-teaser-image
 parent_id819970
 filewebroot/files/Media/File/ThTourTeaserImage/670fad531277e.jpg
 size68291
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 7(array)
 id819977
 hash1fe4f6bdc971a19b15dec2f68fea8965
 created2024-10-16 14:10:59
 updated2024-10-16 14:10:59
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge-thtourteaserimagedesaturated.jpg
 thumbnailth-tour-teaser-image-desaturated
 parent_id819970
 filewebroot/files/Media/File/ThTourTeaserImageDesaturated/670fad5331688.jpg
 size60936
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 8(array)
 id819978
 hashe5a71260f6f71268065f058b20bcf129
 created2024-10-16 14:10:59
 updated2024-10-16 14:10:59
 modelMedia
 fieldfile
 foreign_key14247
 alias4quellen-weitblick-tal-und-berge-thtourteaserimagefullscreen.jpg
 thumbnailth-tour-teaser-image-fullscreen
 parent_id819970
 filewebroot/files/Media/File/ThTourTeaserImageFullscreen/670fad5347f76.jpg
 size360914
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
- 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	/hotel-grimsel
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/hotel-grimsel
Remote Port	36660
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.138.102.181
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	frontend=l844g35nvla0p89leaa19lv5po
Http Referer	https://alpinewelten.com/hotel-grimsel
Http Accept Encoding	gzip, br, zstd, deflate
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Http Accept	/
Http Connection	close
Http X Accel Internal	/internal-nginx-static-location
Http X Real Ip	3.138.102.181
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/hotel-grimsel
Script Url	/hotel-grimsel
Unique Id	ZyLMGeecudXz-I7VFpUavgAAAYU
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/hotel-grimsel
Redirect Script Url	/hotel-grimsel
Redirect Unique Id	ZyLMGeecudXz-I7VFpUavgAAAYU
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/hotel-grimsel
Redirect Redirect Script Url	/hotel-grimsel
Redirect Redirect Unique Id	ZyLMGeecudXz-I7VFpUavgAAAYU
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1730333721.608
Request Time	1730333721

====

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
====

Hotel Grimsel Obergoms, 1.355 m Das gemütliche Hotel in Obergoms

Öffnungszeiten

Ausstattung

Währung & Bezahlung

Standort der Unterkunft

Reisen mit der Unterkunft Hotel Grimsel 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: 19 ms Total Queries: 142 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Hotel Grimsel
Obergoms, 1.355 m
Das gemütliche Hotel in Obergoms

Total Time: 19 ms
Total Queries: 142 queries