Hotel Schwarzsee Zermatt
Wallis, 2.583 m
Hotel am Fuße des Matterhorns

Das Hotel Schwarzsee Zermatt liegt am Fuße des Matterhorns und ist nur per Bergbahn oder zu Fuß erreichbar. Die beeindruckende Lage unterhalb des bekannten Matterhorns machen den Aufenthalt auf der Hütte zu einem unvergesslichen Erlebnis. Die gemütlichen Zimmer und die hervorragende Bewirtung runden den Aufenthalt ab. Das Hotel ist Sommer wie Winter beliebt bei Wanderern, Bergsteigern, Hochtourengehern Skitourengehern, Schneeschuhgehern und auch bei Tagestouristen und Skifahrern. Unsere Wanderführer nutzen die Hütte für die geführte Tour Auf dem Höhenweg rund um Zermatt.

Alle 19 Fotos ansehen

Öffnungszeiten

Jan

Feb

Mar

Apr

Mai

Jun

Jul

Aug

Sep

Okt

Nov

Dez

Ausstattung

Waschmöglichkeit

Duschmöglichkeit

Handyempfang

Vegetarische Speisen

Mehrbettzimmer

Matratzenlager

Währung & Bezahlung

Barzahlung

CHF

Währung: Schweizer Franken

Standort der Unterkunft

Reisen mit der Unterkunft Hotel Schwarzsee Zermatt Diese Unterkunft besuchen wir auf folgenden Reisen

Auf dem Höhenweg rund um Zermatt

Wochenend-Wanderung entlang des Höhenwegs oberhalb von Zermatt mit traumhafter Aussicht auf mehr als 30 Viertausender und das Matterhorn.

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
  time1730437363
  countdown10
- _Token(array)
  keyf2d26adb02646dcf583179e0350317220514803fed453fae3402e444db8821fc579b767b92cf50b37d7813e6ad565c459e3e260eda51565f5c51b82739b55669
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  f2d26adb02646dcf583179e0350317220514803fed453fae3402e444db8821fc579b767b92cf50b37d7813e6ad565c459e3e260eda51565f5c51b82739b556691730424763
====
Request
+
Request

Cake Params
- pluginFrontendAccomodations
- controllerFrontendAccomodations
- actionaccomodation
- named(empty)
- pass(array)
  0135
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  Accomodation135
- route(array)
  id3960
  hasha1a9a357fda48d7141c1b0eaa50139d5
  created2020-06-18 15:33:10
  updated2024-07-18 16:15:25
  modelAccomodation
  foreign_key135
  base/
  aliashotel-schwarzsee-zermatt
  controllerFrontendAccomodations.FrontendAccomodations
  actionaccomodation
  parent_id(null)
  lft5841
  rght5842
  route/hotel-schwarzsee-zermatt
- isAjax(false)
- _Token(array)
  keyf2d26adb02646dcf583179e0350317220514803fed453fae3402e444db8821fc579b767b92cf50b37d7813e6ad565c459e3e260eda51565f5c51b82739b55669
  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-schwarzsee-zermatt' LIMIT 1	1	1	2	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 5841 AND `Route`.`rght` >= 5842 ORDER BY `Route`.`lft` asc	1	1	2	maybe slow
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `alpinewelten`.`settings` AS `Setting` LEFT JOIN `alpinewelten`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	52	52	1
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `alpinewelten`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 14, 15, 16, 17, 18, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`languages` AS `Language` WHERE `Language`.`title` = 'www.alpinewelten.com' LIMIT 1	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'faq' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 87 AND `Menu`.`rght` < 88 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'down_payment_reminder' LIMIT 1	0	0	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'remaining_payment_reminder' LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 16 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'EmailTemplate' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT `EmailTemplate`.`id`, `EmailTemplate`.`hash`, `EmailTemplate`.`created`, `EmailTemplate`.`updated`, `EmailTemplate`.`subject`, `EmailTemplate`.`text`, `EmailTemplate`.`title`, `EmailTemplate`.`icon`, `EmailTemplate`.`model`, `EmailTemplate`.`status_field`, `EmailTemplate`.`status_value`, `EmailTemplate`.`mandrill_template`, `EmailTemplate`.`additional_model`, `EmailTemplate`.`additional_status_field`, `EmailTemplate`.`additional_status_value`, `EmailTemplate`.`type`, `EmailTemplate`.`trigger_type` FROM `alpinewelten`.`email_templates` AS `EmailTemplate` WHERE `EmailTemplate`.`model` = 'Invoices.Invoice' AND `EmailTemplate`.`type` = 'default' AND `EmailTemplate`.`status_value` = 'warning' LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `alpinewelten`.`tags` AS `TagsTag` JOIN `alpinewelten`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 26 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'EmailTemplate' AND `TagEntity`.`field` = 'tags'	0	0	0
SELECT `Accomodation`.`id`, `Accomodation`.`hash`, `Accomodation`.`created`, `Accomodation`.`updated`, `Accomodation`.`number`, `Accomodation`.`name`, `Accomodation`.`type`, `Accomodation`.`owners`, `Accomodation`.`phone_cabin`, `Accomodation`.`phone_valley`, `Accomodation`.`mobile`, `Accomodation`.`fax`, `Accomodation`.`email`, `Accomodation`.`url`, `Accomodation`.`zip`, `Accomodation`.`city`, `Accomodation`.`street`, `Accomodation`.`country`, `Accomodation`.`region_area_id`, `Accomodation`.`remark`, `Accomodation`.`geopoint_lat`, `Accomodation`.`geopoint_long`, `Accomodation`.`cancellation_period`, `Accomodation`.`tighter_cancellation_period`, `Accomodation`.`status`, `Accomodation`.`subline`, `Accomodation`.`height`, `Accomodation`.`video_url`, `Accomodation`.`opening_hours`, `Accomodation`.`premises`, `Accomodation`.`equipment`, `Accomodation`.`currency`, `Accomodation`.`detail_description`, `Accomodation`.`days_before_to_send_participant_list`, `Accomodation`.`country_id`, `Accomodation`.`url_booking_system`, `Accomodation`.`importance`, `Accomodation`.`participant_list_necessary`, `Accomodation`.`reservation_through_agency`, `Accomodation`.`reduction_not_necessary`, (CONCAT_WS (',',`Accomodation`.`geopoint_lat`,`Accomodation`.`geopoint_long`)) AS `Accomodation__geopoint`, `RegionArea`.`id`, `RegionArea`.`hash`, `RegionArea`.`created`, `RegionArea`.`updated`, `RegionArea`.`title`, `RegionArea`.`region_id`, `Country`.`id`, `Country`.`hash`, `Country`.`created`, `Country`.`updated`, `Country`.`title`, `Country`.`abbreviation`, `Country`.`subtitle`, `Country`.`link_embassy_german`, `Country`.`link_embassy_austrian`, `Country`.`link_embassy_swiss`, `Country`.`link_embassy_italian`, `Country`.`best_travel_season`, `Country`.`general`, `Country`.`security`, `Country`.`nature_climate`, `Country`.`travel_info`, `Country`.`entry_customs`, `Country`.`visa`, `Country`.`health`, `Country`.`tours_summer`, `Country`.`tours_winter`, `Country`.`microsite_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`accomodations` AS `Accomodation` LEFT JOIN `alpinewelten`.`region_areas` AS `RegionArea` ON (`Accomodation`.`region_area_id` = `RegionArea`.`id`) LEFT JOIN `alpinewelten`.`countries` AS `Country` ON (`Accomodation`.`country_id` = `Country`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Accomodation`.`id` AND `Route`.`model` = 'Accomodation') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Accomodation`.`id` AND `Seo`.`model` = 'Accomodation') WHERE `Accomodation`.`id` = 135 LIMIT 1	1	1	3	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` = 135 AND `MediaEntity`.`media_id` = `TeaserMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'teaser' ORDER BY `MediaEntity`.`pos` ASC	1	1	1
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (11005) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	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` = 135 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Accomodation' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	19	19	1	maybe slow
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (11005, 11004, 8707, 8704, 8695, 8694, 11006, 11007, 8703, 11003, 8697, 8698, 8699, 8705, 8696, 8700, 8701, 8702, 8706) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	142	142	2
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` = 135 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` = 135 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` = '135' 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` = 149 AND `TourTypesTour`.`tour_type_id` = `Types`.`id`)	1	1	1
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` = 149 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` = (11156) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 252 AND `Menu`.`rght` < 311 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	29	29	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (6, 649, 652, 656, 127, 701, 106, 655, 648, 966, 91, 884, 885, 663, 670, 669, 668, 667, 666, 664, 750, 752, 751, 761, 847, 848, 849, 851, 972) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_more' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 312 AND `Menu`.`rght` < 325 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	6	6	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (34, 35, 36, 37, 38, 94) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'aw' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Firm`.`id`, `Firm`.`hash`, `Firm`.`created`, `Firm`.`updated`, `Firm`.`title`, `Firm`.`abbreviation`, `Firm`.`oa_offerer_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`languages` AS `Language` LEFT JOIN `alpinewelten`.`firms` AS `Firm` ON (`Language`.`firm_id` = `Firm`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	4	4	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2, 3, 4) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority` FROM `alpinewelten`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Accomodation' AND `Seo`.`foreign_key` = 135 LIMIT 1	1	1	2	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` = 3657 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	1
SELECT `TourType`.`id`, `TourType`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) WHERE 1 = 1 GROUP BY `TourType`.`id` ORDER BY `TourType`.`title` ASC	40	40	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 204 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3217) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2312) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 1 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'text_search' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 7 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 210 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 9 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 7 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 38 AND `Menu`.`rght` < 167 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	40	40	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (690, 774, 775, 864, 842, 843, 853, 854, 855, 856, 857, 858, 844, 867, 845, 875, 861, 776, 797, 795, 796, 801, 802, 803, 777, 872, 869, 873, 874, 778, 779, 859, 781, 780, 783, 881, 882, 608, 607, 606) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	5	5	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'tour_list' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 168 AND `Menu`.`rght` < 251 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	41	41	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (8, 9, 20, 637, 19, 27, 10, 559, 580, 753, 968, 12, 13, 14, 21, 22, 30, 29, 521, 31, 53, 72, 588, 73, 23, 75, 76, 484, 15, 16, 17, 18, 49, 50, 51, 841, 68, 63, 58, 57, 600) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	37	37	0
SELECT `Highlight`.`id`, `Highlight`.`hash`, `Highlight`.`created`, `Highlight`.`updated`, `Highlight`.`status`, `Highlight`.`type`, `Highlight`.`tour_id`, `Highlight`.`manually_title`, `Highlight`.`manually_text`, `Highlight`.`manually_button_label`, `Highlight`.`manually_link`, `Highlight`.`position`, `Highlight`.`language_id`, `Highlight`.`manually_target_blank`, `Highlight`.`menu_id`, `Highlight`.`teaser_home_header`, `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, `Tour`.`covid_note`, `Tour`.`importance`, `Tour`.`internal_mark`, `Tour`.`responsible_user_id`, `Tour`.`is_service_event`, `Tour`.`partner_title`, `Tour`.`pay_later_hint`, `Tour`.`event_duration`, `Tour`.`distance`, `Tour`.`ascent`, `Tour`.`descent`, `Tour`.`destination_menu_id`, (CONCAT_WS (',',`Tour`.`gmap_lat`,`Tour`.`gmap_long`)) AS `Tour__gmap`, (CONCAT_WS (',',`Tour`.`meeting_point_map_lat`,`Tour`.`meeting_point_map_long`)) AS `Tour__meeting_point_map`, (COALESCE(`Tour`.`end_zip`, `Tour`.`start_zip`)) AS `Tour__end_zip`, (COALESCE(`Tour`.`end_city`, `Tour`.`start_city`)) AS `Tour__end_city`, (COALESCE(`Tour`.`end_street`, `Tour`.`start_street`)) AS `Tour__end_street`, (COALESCE(`Tour`.`end_country`, `Tour`.`start_country`)) AS `Tour__end_country`, (`Tour`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tours AS TourTravelOptionXTours inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTours`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTours`.`tour_id` = `Tour`.`id`), 0)) AS `Tour__price_excl_flight`, (EXISTS(SELECT `Tour`.`id`, TourHighlights.* FROM highlights AS TourHighlights WHERE `TourHighlights`.`tour_id` = `Tour`.`id` AND `TourHighlights`.`status` = 'active' AND `TourHighlights`.`type` = 'tour')) AS `Tour__highlight` FROM `alpinewelten`.`highlights` AS `Highlight` LEFT JOIN `alpinewelten`.`tours` AS `Tour` ON (`Highlight`.`tour_id` = `Tour`.`id`) WHERE `Highlight`.`type` = 'tour' AND `Highlight`.`teaser_home_header` = '1' AND `Highlight`.`language_id` = 1 ORDER BY `position` ASC	10	10	1	maybe slow
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 25 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (65) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 217 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 217 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (12264) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 544 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 544 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (14258) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 219 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 219 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (841) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	15	15	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 73 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 73 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4175) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 253 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 253 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4120) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 204 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 204 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4804) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 213 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 213 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (12889) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 470 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 470 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3964) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	19	19	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 28 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 28 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (612) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `TourMainTypes`.`id`, `TourMainTypes`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) JOIN `alpinewelten`.`tour_main_types` AS `TourMainTypes` ON (`TourMainTypes`.`id` = `TourType`.`tour_main_type_id`) WHERE 1 = 1 ORDER BY `TourMainTypes`.`position` ASC	604	604	0
SELECT `Microsite`.`id`, `Microsite`.`hash`, `Microsite`.`created`, `Microsite`.`updated`, `Microsite`.`status`, `Microsite`.`title`, `Microsite`.`url`, `Microsite`.`position`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`microsites` AS `Microsite` LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Microsite`.`id` AND `Teaser`.`model` = 'Microsite') WHERE 1 = 1	5	5	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2951 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (52) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2952 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (459) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2953 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (688) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2954 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5427) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2955 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2275) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 774 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5685 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4208 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (774) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (774) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 774 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 774 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 89 AND `Menu`.`rght` < 166 AND (SELECT GROUP_CONCAT(`AuthorizedFor`.`member_group_id`) FROM member_groups_menus AS AuthorizedFor JOIN `alpinewelten`.`menus` AS `AuthorizedForMenu` ON (`AuthorizedForMenu`.`id` = `AuthorizedFor`.`menu_id`) WHERE `AuthorizedForMenu`.`lft` <= `Menu`.`lft` AND `AuthorizedForMenu`.`rght` >= `Menu`.`rght`) IS NULL ORDER BY `Menu`.`lft` asc	38	38	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (775, 864, 842, 843, 853, 854, 855, 856, 857, 858, 844, 867, 845, 875, 861, 776, 797, 795, 796, 801, 802, 803, 777, 872, 869, 873, 874, 778, 779, 859, 781, 780, 783, 881, 882, 608, 607, 606) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'about_landingpage_mountainguides' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 796 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5712 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4235 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (796) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (796) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 796 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 796 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_partner' AND `Language`.`langid` = 'aw' LIMIT 1	0	0	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'search' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`header_full_screen`, `Menu`.`tour_finder`, `Menu`.`advantage_title`, `Menu`.`microsite_slider`, `Menu`.`hide_landingpage_menu_node`, `Menu`.`landingpage_content_scroll`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`sitemap_priority`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout`, `Teaser`.`subtitle` FROM `alpinewelten`.`menus` AS `Menu` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 11 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 218 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (471) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 17 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `alpinewelten`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `alpinewelten`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 11 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Advantage`.`id`, `Advantage`.`hash`, `Advantage`.`created`, `Advantage`.`updated`, `Advantage`.`title`, `Advantage`.`description`, `AdvantagesMenu`.`id`, `AdvantagesMenu`.`advantage_id`, `AdvantagesMenu`.`menu_id`, `AdvantagesMenu`.`position` FROM `alpinewelten`.`advantages` AS `Advantage` JOIN `alpinewelten`.`advantages_menus` AS `AdvantagesMenu` ON (`AdvantagesMenu`.`menu_id` = 11 AND `AdvantagesMenu`.`advantage_id` = `Advantage`.`id`) ORDER BY `AdvantagesMenu`.`position` ASC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'accomodations_index' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1	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.55 MB

Message	Memory use
Component initialization	2.09 MB
Controller action start	3.14 MB
Controller render start	7.61 MB
View render complete	11.50 MB

Timers

Total Request Time: 426 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	23.65
Event: Controller.initialize	15.78
Event: Controller.startup	1.26
Controller action	76.94
Event: Controller.beforeRender	125.18
» Processing toolbar data	70.48
Rendering View	66.33
» Event: View.beforeRender	0.04
» Rendering APP/Plugin/FrontendAccomodations/View/FrontendAccomodations/accomodation.php	21.99
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php	1.42
» » Rendering APP/View/Elements/icon.php	1.66
» » Rendering APP/Plugin/FrontendContents/View/Elements/gallery_mosaic.php	1.40
» » Rendering APP/View/Elements/icon.php #2	1.39
» » Rendering APP/View/Elements/icon.php #3	1.44
» » Rendering APP/View/Elements/icon.php #4	1.19
» » Rendering APP/View/Elements/icon.php #5	1.13
» » Rendering APP/View/Elements/icon.php #6	1.07
» » Rendering APP/View/Elements/icon.php #7	0.99
» » Rendering APP/View/Elements/icon.php #8	1.15
» » Rendering APP/Plugin/FrontendTours/View/Elements/teaser_slider.php	4.08
» » » Rendering APP/Plugin/FrontendTours/View/Elements/teaser.php	0.87
» » » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php	0.23
» » » Rendering APP/View/Elements/icon.php #9	1.13
» » » Rendering APP/View/Elements/icon.php #10	0.31
» » » Rendering APP/View/Elements/icon.php #11	1.11
» Event: View.afterRender	0.15
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/1.php	41.63
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.62
» » Rendering APP/View/Elements/header/header.php	21.73
» » » Rendering APP/View/Elements/header/header_navbar.php	21.47
» » » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.10
» » » » Rendering APP/View/Elements/navigation_secondary.php	4.77
» » » » » Rendering APP/View/Elements/icon.php #12	1.31
» » » » » Rendering APP/View/Elements/icon.php #13	0.34
» » » » » Rendering APP/View/Elements/icon.php #14	0.25
» » » » » Rendering APP/View/Elements/icon.php #15	1.12
» » » » Rendering APP/View/Elements/navigation.php	14.71
» » » » » Rendering APP/View/Elements/icon.php #16	0.29
» » » » » Rendering APP/View/Elements/icon.php #17	0.35
» » » » » Rendering APP/View/Elements/icon.php #18	0.23
» » » » » Rendering APP/View/Elements/icon.php #19	0.21
» » » » » Rendering APP/View/Elements/icon.php #20	0.28
» » » » » Rendering APP/View/Elements/icon.php #21	0.21
» » » » » Rendering APP/View/Elements/icon.php #22	0.21
» » » » » Rendering APP/View/Elements/icon.php #23	0.25
» » » » » Rendering APP/View/Elements/icon.php #24	0.23
» » » » » Rendering APP/View/Elements/icon.php #25	0.20
» » » » » Rendering APP/View/Elements/icon.php #26	0.22
» » » » » Rendering APP/View/Elements/icon.php #27	0.23
» » » » » Rendering APP/View/Elements/icon.php #28	0.21
» » » » » Rendering APP/View/Elements/icon.php #29	0.32
» » » » » Rendering APP/View/Elements/icon.php #30	0.24
» » » » » Rendering APP/View/Elements/icon.php #31	0.21
» » » » » Rendering APP/View/Elements/icon.php #32	0.21
» » » » » Rendering APP/View/Elements/icon.php #33	0.26
» » » » » Rendering APP/View/Elements/icon.php #34	0.26
» » » » » Rendering APP/View/Elements/icon.php #35	0.22
» » » » » Rendering APP/View/Elements/icon.php #36	0.22
» » » » » Rendering APP/View/Elements/icon.php #37	0.24
» » » » » Rendering APP/View/Elements/icon.php #38	0.21
» » » » » Rendering APP/View/Elements/icon.php #39	0.22
» » » » » Rendering APP/View/Elements/icon.php #40	0.21
» » » » » Rendering APP/View/Elements/icon.php #41	0.20
» » » » » Rendering APP/View/Elements/icon.php #42	0.26
» » » » » Rendering APP/View/Elements/icon.php #43	0.24
» » » » » Rendering APP/View/Elements/icon.php #44	0.25
» » » » » Rendering APP/View/Elements/icon.php #45	0.29
» » » » » Rendering APP/View/Elements/icon.php #46	0.26
» » » » » Rendering APP/View/Elements/icon.php #47	0.22
» » » » » Rendering APP/View/Elements/icon.php #48	0.20
» » » » » Rendering APP/View/Elements/icon.php #49	0.21
» » » » » Rendering APP/View/Elements/icon.php #50	0.19
» » » » » Rendering APP/View/Elements/icon.php #51	0.21
» » » » » Rendering APP/View/Elements/icon.php #52	0.22
» » » » » Rendering APP/View/Elements/icon.php #53	0.21
» » » » » Rendering APP/View/Elements/icon.php #54	0.23
» » » » » Rendering APP/View/Elements/icon.php #55	0.28
» » » » » Rendering APP/View/Elements/icon.php #56	0.24
» » Rendering APP/Plugin/FrontendAccomodations/View/Elements/breadcrumb.php #2	0.67
» » Rendering APP/View/Elements/footer/footer.php	8.83
» » » Rendering APP/View/Elements/icon.php #57	1.07
» » » Rendering APP/View/Elements/icon.php #58	0.97
» » » Rendering APP/View/Elements/logos/logo-instagram.php	0.14
» » » Rendering APP/View/Elements/logos/logo-youtube.php	0.08
» » » Rendering APP/View/Elements/logos/logo-facebook.php	0.08
» » » Rendering APP/View/Elements/logos/logo-alpine-welten.php #2	0.07
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php	0.09
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php	0.09
» » » Rendering APP/View/Elements/footer/footer_newsletter_subscribe.php	0.23
» » » Rendering APP/View/Elements/logos/logo-adidas-terrex.php	0.17
» » » Rendering APP/View/Elements/logos/logo-adidas-eyewear.php	0.10
» » » Rendering APP/View/Elements/logos/logo-petzl.php	0.09
» » » Rendering APP/View/Elements/logos/logo-pieps.php	0.08
» » » Rendering APP/View/Elements/logos/logo-kaestle.php	0.09
» » » Rendering APP/View/Elements/logos/logo-diamir.php	0.09
» » » Rendering APP/View/Elements/logos/logo-komperdell.php	0.09
» » » Rendering APP/View/Elements/logos/logo-scarpa.php	0.09
» » » Rendering APP/View/Elements/logos/logo-exped.php	0.10
» » » Rendering APP/View/Elements/logos/logo-abs.php	0.08
» » » Rendering APP/View/Elements/logos/logo-hilleberg.php	0.09
» » Rendering APP/View/Elements/contact_widget.php	6.07
» » » Rendering APP/View/Elements/icon.php #59	1.13
» » » Rendering APP/View/Elements/icon.php #60	1.06
» » » Rendering APP/View/Elements/icon.php #61	1.03
» » » Rendering APP/View/Elements/icon.php #62	0.99
» » » Rendering APP/View/Elements/icon.php #63	1.03
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- accomodation(array)
 Accomodation(array)
 id135
 hashf2482bcd6dea4ecf57507db99aa7c862
 created2015-12-04 15:11:57
 updated2024-07-18 16:15:25
 number900135
 nameHotel Schwarzsee Zermatt
 typehotel
 ownersTanja Siemerink und Dave Banks
 phone_cabin+41279672263
 phone_valleyA
 mobile+41764619422
 faxSto Sommer 2Tg/Sto Winter 14 Tg
 emailinfo@schwarzsee-zermatt.ch
 urlhttp://www.schwarzsee-zermatt.ch
 zip
 cityZermatt
 street
 countryCH
 region_area_id4
 remarkinfo@schwarzsee-zermatt.ch
 geopoint_lat45.991661
 geopoint_long7.709410
 cancellation_period14
 tighter_cancellation_period(false)
 statusactive
 sublineHotel am Fuße des Matterhorns
 height2.583
 video_url
 opening_hours4095
 premisesDas Hotel Schwarzsee Zermatt liegt am Fuße des Matterhorns und ist nur per Bergbahn oder zu Fuß erreichbar. Die beeindruckende Lage unterhalb des bekannten Matterhorns machen den Aufenthalt auf der Hütte zu einem unvergesslichen Erlebnis. Die gemütlichen Zimmer und die hervorragende Bewirtung runden den Aufenthalt ab. Das Hotel ist Sommer wie Winter beliebt bei Wanderern, Bergsteigern, Hochtourengehern Skitourengehern, Schneeschuhgehern und auch bei Tagestouristen und Skifahrern. Unsere Wanderführer nutzen die Hütte für die geführte Tour Auf dem Höhenweg rund um Zermatt.
 equipment9743
 currency2
 detail_description
 days_before_to_send_participant_list14
 country_id182
 url_booking_system(null)
 importancenone
 participant_list_necessary(true)
 reservation_through_agency(false)
 reduction_not_necessary(false)
 geopoint45.991661,7.709410
 RegionArea(array)
 id4
 hash5647b2b2a6d091246448099175b04919
 created2015-10-27 17:59:15
 updated2018-11-28 16:17:02
 titleWallis
 region_id4
 Country(array)
 id182
 hashddc767fea0846fa09b0aac1adb571630
 created2016-06-01 17:35:19
 updated2024-08-15 14:28:17
 titleSchweiz
 abbreviationCH
 subtitleZwischen wildromantischen Tälern und mächtigen Viertausendern
 link_embassy_germanhttps://www.auswaertiges-amt.de/de/aussenpolitik/laender/schweiz-node/schweizsicherheit/206208
 link_embassy_austrianhttps://www.bmeia.gv.at/reise-aufenthalt/reiseinformation/land/schweiz/
 link_embassy_swisshttps://www.eda.admin.ch/eda/de/home.html
 link_embassy_italianhttp://www.viaggiaresicuri.mae.aci.it/country/CHE
 best_travel_season3071
 generalStand: 12.08.2020 <h2 style="text-align:center">Allgemeines</h2> Die Schweiz liegt in der Mitte Europas und ist eingerahmt von Deutschland im Norden, Österreich und Liechtenstein im Osten, Italien im Süden sowie Ungarn und Frankreich im Westen. Mit einer Fläche von gut 41.000 Quadratkilometern und ca. 8,6 Millionen Einwohnern ist die Schweiz relativ dicht besiedelt. Ausnahmen bilden hier jedoch die Bergregionen, die in der Schweiz bis auf über 4.600 m aufragen und deren ungenutzte Fläche insgesamt ein Viertel der gesamten Landesfläche ausmacht. Die bekanntesten Gipfel der Schweizer Alpen sind allen voran sicherlich das Matterhorn (4.478 m) in Zermatt sowie das Berner Dreigestirn Eiger (3.970 m), Mönch (4.107 m) und Jungfrau (4.158 m) im Berner Oberland. Die höchsten Gipfel der Schweiz liegen jedoch im Wallis, der höchste ist mit 4.637 m die Dufourspitze im Monte Rosa Massiv. So wie im "Goldenen Zeitalter des Alpinismus" Mitte des 19. Jahrhunderts, ziehen die hohen Schweizer Berge aber auch heute noch Bergsteiger aus der ganzen Welt in ihren Bann - Jahr für Jahr, sommers wie winters. In der Schweiz wird - je nach Region - neben Deutsch auch vorwiegend Französisch und Italienisch gesprochen sowie in Graubünden Rätoromanisch. Alle vier Sprachen sind Amtssprachen in der Schweiz. Die größte Stadt ist Zürich mit ca. 415.000 Einwohnern, Hauptstadt der föderalen Republik ist jedoch Bern - mit ca. 134.000 Einwohnern deutlich kleiner. Nationalfeiertag ist der Gründungstag der Schweizerischen Eidgenossenschaft am 01. August. <h3 style="text-align:center">Währung & Bezahlung</h3> Die Schweiz gehört nicht zur EU, jedoch zum Schengen Raum. Die Schweizer Landeswährung ist der Schweizer Franken (CHF). Es kann manchmal auch in Euro gezahlt werden, das Wechselgeld erfolgt dann jedoch in Franken. Normalerweise kann man fast überall mit einer EC-Karte am Geldautomaten Bargeld abheben oder elektronisch mit EC-Karte oder Kreditkarte bezahlen. Auf Berghütten gilt dies jedoch meist nicht und es ist nur Barzahlung möglich. Daher sollte auf Bergtouren in der Schweiz immer genügend Bargeld - und zwar in Schweizer Franken - in der Tasche sein. Hier findest Du einen <a href="https://www1.oanda.com/lang/de/currency/converter/" target="_blank">Währungsrechner</a>.
 security<h2 style="text-align:center">Sicherheit</h2> Generell ist die Schweiz ein sehr sicheres Reiseland im Schengen Raum. Die Kriminalität ist als GERING einzustufen.
 nature_climate<h2 style="text-align:center">Natur & Klima</h2> Aufgrund ihrer Topographie und ihrer geographischen Lage gibt es zahlreiche außergewöhnliche Naturschauplätze in der Schweiz. Flora und Fauna sind sehr vielfältig und artenreich. Wälder überziehen etwa ein Drittel der Schweizer Landesfläche. In den Niederungen sind dies Laub- und Mischwälder, während in den Alpen Nadelwälder dominieren, die dort die wichtige Aufgabe haben, vor Lawinen und Hochwasser zu schützen. Idyllische Seen, tosende Flüsse, Schluchten und Wasserfälle sowie die einzigartige Berg- und Gletscherwelt prägen die Natur der Schweiz. Einige davon sind sogar auf der UNESCO Weltnaturerbeliste, wie z. B. die Aletschgletscher- und Jungfrauregion oder das wild-romantische Val Müstair. Die Schweiz gehört zwar generell zur gemäßigten Klimazone, aufgrund der Topographie des Landes und damit verbundener großer Höhenunterschiede können sich die klimatischen Bedingungen jedoch sehr unterscheiden. Das Schweizer Klima wird jedoch nicht nur von den Alpen geprägt, sondern auch vom Atlantik und Mittelmeer. Der Atlantik bringt feuchte, milde Strömungen in die Regionen nördlich der Alpen. Am Alpenkamm können sich im Sommer häufig Gewitter bilden. Die Alpensüdseite hingegen wird hauptsächlich vom Mittelmeer beeinflusst und hat somit ein mediterranes Klima mit milderen Wintern. Somit bilden die Alpen quasi eine Klimascheide zwischen Nord- und Südschweiz. Dadurch fällt in den inneralpinen Tälern ganzjährig eher wenig Niederschlag und bildet so relativ trockene Regionen. Zu diesen trockenen Tälern zählen zum Beispiel das Wallis oder das Engadin. Im Winter fällt der Niederschlag in Höhen ab 1.500 m Höhe vorwiegend als Schnee, während das Flachland weitestgehend schneefrei bleibt. Die Winter im Gebirge sind sehr kalt und schneereich. Auf vielen Schweizer Bergen liegt ganzjährig Schnee. Der Föhn, der warme Fallwinde und milde Temperaturen bringt, tritt hauptsächlich von Herbst bis ins Frühjahr auf. Auch Nebel ist eine häufige Erscheinung in der kalten Jahreshälfte. Bei Hochnebel können oft Inversionen entstehen, was bedeutet, dass es z. B. im Gebirge über der Hochnebeldecke wärmer ist als darunter. Verschiedene Wetterdienste geben einen ganz guten Überblick über das aktuelle Bergwetter in der Schweiz. Sie können Dir dabei helfen, Dich auf Deine Bergtour in der Schweiz entsprechend vorzubereiten: <ul> <li style="text-align:justify"><a href="https://www.meteoschweiz.admin.ch/home.html?tab=overview" target="_blank">MeteoSchweiz</a></li> <li style="text-align:justify"><a href="https://www.alpenverein.de/DAV-Services/Bergwetter/Berner-Oberland-Appenzeller-Land-Glarner-Alpen/#2020-07-20|weatherLayer" target="_blank">DAV Bergwetter</a></li> <li style="text-align:justify"><a href="https://www.bergfex.ch/schweiz/wetter/" target="_blank">Bergfex Bergwetter</a></li> </ul>
 travel_info
 entry_customs<h2 style="text-align:center">Einreise & Zoll</h2> Bei Grenzübertritten sind stichprobenartige Personen- und Fahrzeugkontrollen möglich. Ansonsten sind Einschränkungen bei der Einreise generell als gering einzustufen. Auf Schweizer Autobahnen gilt Vignettenpflicht! Verkehrsverstöße (z. B. fehlende Vignette, überhöhte Geschwindigkeit) werden mit hohen Strafen belegt. Der öffentliche Personenfern- und -nahverkehr mit Bussen und Bahnen ist in der Schweiz sehr gut ausgebaut. Da die Schweiz nicht zur EU gehört, gilt die Grenze zur Schweiz als EU-Außengrenze und unterliegt entsprechenden Bestimmungen zur Warenein- und -ausfuhr. Informationen dazu liefert die <a href="https://www.ezv.admin.ch/ezv/de/home/information-private.html" target="_blank">Eidgenössische Zollverwaltung EZV</a>. <ul> <li style="text-align:justify">Tipp: <a href="https://www.bundesfinanzministerium.de/Web/DE/Service/Apps_Rechner/Zoll-Reise-App/zoll-reise-app.html" target="_blank">App „Zoll und Reise“</a></li> </ul> <h3 style="text-align:center">Reisedokumente</h3> Die Einreise ist für Staatsangehörige D | A | I mit folgenden Dokumenten möglich. <ul> <li style="text-align:justify">Personalausweis</li> <li style="text-align:justify">Reisepass</li> </ul> (!) Reisedokumente müssen für die gesamte Dauer des Aufenthalts gültig sein!
 visa<h2 style="text-align:center">Visum</h2> Staatsangehörige D | A | I können ohne Visum in die Schweiz einreisen. Informationen zu den aktuellen Einreisebestimmungen für eine Reise in die Schweiz findest Du auch beim <a href="https://www.eda.admin.ch/eda/de/home.html" target="_blank">Eidgenössischen Departement für auswärtige Angelegenheiten EDA</a>. Staatsangehörige mit anderen Nationalitäten Detaillierte Informationen zu den jeweiligen Einreise- und Visabestimmungen stellen wir zur Verfügung, sobald uns Deine Nationalität bekannt ist.
 health<h2 style="text-align:center">Gesundheit</h2> Die medizinische Versorgung ist in der Schweiz generell sehr gut. Die zentrale Notrufnummer in der Schweiz lautet 112, auch für die alpine Bergrettung. Über die 144 erreicht man den Rettungsdienst bei medizinischen Notfällen. Die Schweizer Rettungsflugwacht Rega kann innerhalb der Schweiz über die 1414 kontaktiert werden bzw. mit einer SIM-Karte eines nicht-schweizerischen Netzbetreibers über +41 333 333 333. <h3 style="text-align:center">Impfungen</h3> Für die Einreise in die Schweiz gibt es keine Pflichtimpfungen! Grundsätzlich empfehlen sich für weltweite Bergreisen eine Immunisierung gegen Polio, Diphtherie, Keuchhusten und Tetanus. Für weiterführende Informationen zur Reisemedizin empfehlen wir das <a href="https://www.crm.de/aktuell/" target="_blank">Centrum für Reisemedizin (CRM)</a>.
 tours_summer<h2 style="text-align:center">Tourenmöglichkeiten im Sommer</h2> Die Schweiz bietet im Sommer eine Spielwiese für nahezu alle Bergsportarten! Auch das Bergwegenetz ist sehr gut ausgebaut. Aber nicht nur <a href="https://www.alpinewelten.com/hoehenweg-zermatt?step=tour" target="_blank">Bergwanderungen</a>, sondern insbesondere die hohen 4.000-er reizen mit <a href="https://www.alpinewelten.com/alpinschule/hochtouren" target="_blank">Hochtouren aller Schwierigkeitsgrade</a> und lassen das Bergsteigerherz höher schlagen! Einmalige Bergerlebnisse und Bergabenteuer sind in der Schweiz Programm und wer einmal ganz hoch hinaus will, findet hier seine Erfüllung.
 tours_winter<h2 style="text-align:center">Tourenmöglichkeiten im Winter</h2> Auch im Winter zieht es uns Bergführer sowie viele Bergsteiger und Wintersportbegeisterte in die Schweiz. Insbesondere Skitouren und Skidurchquerungen - sowohl für Genießer als auch für Könner - begeistern mit dem einzigartigen Bergpanorama der hohen 4.000-er. Auch zahlreiche <a href="https://www.alpinewelten.com/gefuehrte-reisen/freeride-tiefschneefahren" target="_blank">Top Spots zum Freeriden</a> sind in der Schweiz zu finden und die mächtigen gefrorenen Wasserfälle laden zum <a href="https://www.alpinewelten.com/gefuehrte-reisen/eisklettern" target="_blank">Abenteuer Eisklettern</a> ein, insbesondere das <a href="https://www.alpinewelten.com/eisklettern-in-der-schweiz-kandersteg?step=tour" target="_blank">Eiskletter-Mekka in Kandersteg</a>.
 microsite_id(null)
 Route(array)
 id4087
 hash7639d80054386fa387b65184c6aad49a
 created2020-07-20 10:21:53
 updated2024-08-15 14:28:17
 modelCountry
 foreign_key182
 base/
 aliasreisen-schweiz
 controllerFrontendCountries.FrontendCountries
 actioncountry
 parent_id(null)
 lft6065
 rght6066
 route/reisen-schweiz
 FlagUpload(array)
 0(array)
 id397014
 hash11b6df42bcf2f9c354534ea25e3c7da3
 created2020-09-14 08:51:43
 updated2020-09-14 08:51:54
 modelCountry
 fieldflag
 foreign_key182
 aliasflagge-schweiz.png
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Country/Flag/5f5f130a9562b.png
 size1745
 ext.png
 mimeimage/png
 width550
 height550
 Route(array)
 id3960
 hasha1a9a357fda48d7141c1b0eaa50139d5
 created2020-06-18 15:33:10
 updated2024-07-18 16:15:25
 modelAccomodation
 foreign_key135
 base/
 aliashotel-schwarzsee-zermatt
 controllerFrontendAccomodations.FrontendAccomodations
 actionaccomodation
 parent_id(null)
 lft5841
 rght5842
 route/hotel-schwarzsee-zermatt
 Seo(array)
 id3657
 hashc189f0d27d724871d547f244c343d954
 created2020-06-18 15:33:10
 updated2023-01-11 13:48:04
 modelAccomodation
 foreign_key135
 titleHotel Schwarzsee | Zermatt
 descriptionDas Hotel Schwarzsee Zermatt liegt am Fuße des Matterhorns und ist nur per Bergbahn oder zu Fuß erreichbar. Die beeindruckende Lage unterhalb des bekannten Matterhorns machen den Aufenthalt auf der Hütte zu einem unvergesslichen Erlebnis. Die gemütlichen Zimmer und die hervorragende Bewirtung runden den Aufenthalt ab.
 internal_keywords
 author
 tw_creator
 fb_author
 robots3
 sitemap_priority0.5
 TeaserMedia(array)
 0(array)
 id11005
 hashafe06dc95cd7131ed579b3905a7100ec
 created2021-11-10 09:10:30
 updated2021-11-10 09:10:30
 titleHotel Schwarzsee Zermatt im Mattertal
 cross_reference_count4
 MediaEntity(array)
 id498511
 pos1
 media_id11005
 modelAccomodation
 fieldteaser
 foreign_key135
 FileUpload(array)
 0(array)
 id592544
 hash8f317c2138013a9a36698e744ac65b46
 created2021-11-10 09:10:28
 updated2021-11-10 09:10:30
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/618b7e768575b.jpg
 size304808
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670252
 hash4d839b5bfa2f3f37751d498dfdd55f92
 created2023-01-11 13:48:00
 updated2023-01-11 13:48:00
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id592544
 filewebroot/files/Media/File/ThAccomodationTeaserImage/63beb0005870b.jpg
 size56963
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id670253
 hash018b5089cda660fd7a51e1a4080fa544
 created2023-01-11 13:48:00
 updated2023-01-11 13:48:00
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id592544
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb000ac6cb.jpg
 size137698
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id670272
 hash7a8b45783968929081a1e38944fceea7
 created2023-01-11 13:48:04
 updated2023-01-11 13:48:04
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id592544
 filewebroot/files/Media/File/ThSeoImageFacebook/63beb00457f8f.png
 size424211
 ext.png
 mimeimage/png
 width720
 height405
 4(array)
 id670273
 hasha803a394afe1826492aaf3dcd6278244
 created2023-01-11 13:48:04
 updated2023-01-11 13:48:04
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id592544
 filewebroot/files/Media/File/ThSeoImageGoogle/63beb0049ff74.png
 size424211
 ext.png
 mimeimage/png
 width720
 height405
 5(array)
 id670274
 hash3cdc659618852276b3b1bd538cc82328
 created2023-01-11 13:48:05
 updated2023-01-11 13:48:05
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id592544
 filewebroot/files/Media/File/ThSeoImageTwitter/63beb004e3450.png
 size132028
 ext.png
 mimeimage/png
 width375
 height210
 6(array)
 id817288
 hash3e3444ab4141f5d62ac95b60887caed7
 created2024-10-02 16:34:01
 updated2024-10-02 16:34:01
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thtouraccomodationimages.jpg
 thumbnailth-tour-accomodation-images
 parent_id592544
 filewebroot/files/Media/File/ThTourAccomodationImages/66fd59d9c2d28.jpg
 size56963
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 7(array)
 id592545
 hash92bbb9f9e4d9500d720aba5fc11f4bce
 created2021-11-10 09:10:30
 updated2021-11-10 09:10:30
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id592544
 filewebroot/files/Media/File/ThMediaFileIndex/618b7e7686591.jpg
 size13422
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 8(array)
 id592546
 hash4c92c10c200c001f14025aa9b40e3a0e
 created2021-11-10 09:10:30
 updated2021-11-10 09:10:30
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id592544
 filewebroot/files/Media/File/CkeditorXs/618b7e76b1665.jpg
 size4299
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 9(array)
 id592547
 hashd0e763b99e8ac7068479e6d0bb82521c
 created2021-11-10 09:10:31
 updated2021-11-10 09:10:31
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id592544
 filewebroot/files/Media/File/CkeditorSm/618b7e76ec064.jpg
 size13422
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 10(array)
 id592548
 hasha3d8cb12fb37e60d0dfd28802c1d3bb8
 created2021-11-10 09:10:31
 updated2021-11-10 09:10:31
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id592544
 filewebroot/files/Media/File/CkeditorMd/618b7e771d649.jpg
 size21365
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 11(array)
 id592549
 hash4023e1ffe0de396cb286ca6d0785a863
 created2021-11-10 09:10:31
 updated2021-11-10 09:10:31
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id592544
 filewebroot/files/Media/File/CkeditorLg/618b7e773bec0.jpg
 size45854
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 GalleryMedia(array)
 0(array)
 id11005
 hashafe06dc95cd7131ed579b3905a7100ec
 created2021-11-10 09:10:30
 updated2021-11-10 09:10:30
 titleHotel Schwarzsee Zermatt im Mattertal
 cross_reference_count4
 MediaEntity(array)
 id498512
 pos1
 media_id11005
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id592544
 hash8f317c2138013a9a36698e744ac65b46
 created2021-11-10 09:10:28
 updated2021-11-10 09:10:30
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/618b7e768575b.jpg
 size304808
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670252
 hash4d839b5bfa2f3f37751d498dfdd55f92
 created2023-01-11 13:48:00
 updated2023-01-11 13:48:00
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id592544
 filewebroot/files/Media/File/ThAccomodationTeaserImage/63beb0005870b.jpg
 size56963
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id670253
 hash018b5089cda660fd7a51e1a4080fa544
 created2023-01-11 13:48:00
 updated2023-01-11 13:48:00
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id592544
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb000ac6cb.jpg
 size137698
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 3(array)
 id670272
 hash7a8b45783968929081a1e38944fceea7
 created2023-01-11 13:48:04
 updated2023-01-11 13:48:04
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id592544
 filewebroot/files/Media/File/ThSeoImageFacebook/63beb00457f8f.png
 size424211
 ext.png
 mimeimage/png
 width720
 height405
 4(array)
 id670273
 hasha803a394afe1826492aaf3dcd6278244
 created2023-01-11 13:48:04
 updated2023-01-11 13:48:04
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id592544
 filewebroot/files/Media/File/ThSeoImageGoogle/63beb0049ff74.png
 size424211
 ext.png
 mimeimage/png
 width720
 height405
 5(array)
 id670274
 hash3cdc659618852276b3b1bd538cc82328
 created2023-01-11 13:48:05
 updated2023-01-11 13:48:05
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id592544
 filewebroot/files/Media/File/ThSeoImageTwitter/63beb004e3450.png
 size132028
 ext.png
 mimeimage/png
 width375
 height210
 6(array)
 id817288
 hash3e3444ab4141f5d62ac95b60887caed7
 created2024-10-02 16:34:01
 updated2024-10-02 16:34:01
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thtouraccomodationimages.jpg
 thumbnailth-tour-accomodation-images
 parent_id592544
 filewebroot/files/Media/File/ThTourAccomodationImages/66fd59d9c2d28.jpg
 size56963
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 7(array)
 id592545
 hash92bbb9f9e4d9500d720aba5fc11f4bce
 created2021-11-10 09:10:30
 updated2021-11-10 09:10:30
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id592544
 filewebroot/files/Media/File/ThMediaFileIndex/618b7e7686591.jpg
 size13422
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 8(array)
 id592546
 hash4c92c10c200c001f14025aa9b40e3a0e
 created2021-11-10 09:10:30
 updated2021-11-10 09:10:30
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id592544
 filewebroot/files/Media/File/CkeditorXs/618b7e76b1665.jpg
 size4299
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 9(array)
 id592547
 hashd0e763b99e8ac7068479e6d0bb82521c
 created2021-11-10 09:10:31
 updated2021-11-10 09:10:31
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id592544
 filewebroot/files/Media/File/CkeditorSm/618b7e76ec064.jpg
 size13422
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 10(array)
 id592548
 hasha3d8cb12fb37e60d0dfd28802c1d3bb8
 created2021-11-10 09:10:31
 updated2021-11-10 09:10:31
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id592544
 filewebroot/files/Media/File/CkeditorMd/618b7e771d649.jpg
 size21365
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 11(array)
 id592549
 hash4023e1ffe0de396cb286ca6d0785a863
 created2021-11-10 09:10:31
 updated2021-11-10 09:10:31
 modelMedia
 fieldfile
 foreign_key11005
 aliashotel-schwarzsee-zermatt-im-mattertal-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id592544
 filewebroot/files/Media/File/CkeditorLg/618b7e773bec0.jpg
 size45854
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 1(array)
 id11004
 hash9dd364af844dfbff88822207e4399203
 created2021-11-10 09:09:23
 updated2021-11-10 09:09:23
 titleHotel Schwarzsee Zermatt im Mattertal Impression
 cross_reference_count1
 MediaEntity(array)
 id498513
 pos2
 media_id11004
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id592538
 hashc1330baeac6435e74351b99b7179da44
 created2021-11-10 09:09:21
 updated2021-11-10 09:09:23
 modelMedia
 fieldfile
 foreign_key11004
 aliashotel-schwarzsee-zermatt-im-mattertal-impression.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/618b7e335e88c.jpg
 size275604
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670254
 hashc7943277ae0225882ee53737c3a778b8
 created2023-01-11 13:48:01
 updated2023-01-11 13:48:01
 modelMedia
 fieldfile
 foreign_key11004
 aliashotel-schwarzsee-zermatt-im-mattertal-impression-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id592538
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb000dd96d.jpg
 size141251
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id592539
 hash174a3a6fa4362a57fdbb91635b038a67
 created2021-11-10 09:09:23
 updated2021-11-10 09:09:23
 modelMedia
 fieldfile
 foreign_key11004
 aliashotel-schwarzsee-zermatt-im-mattertal-impression-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id592538
 filewebroot/files/Media/File/ThMediaFileIndex/618b7e335f410.jpg
 size13006
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id592540
 hashfb66dbe1f343466bb191672d9b70d2f9
 created2021-11-10 09:09:23
 updated2021-11-10 09:09:23
 modelMedia
 fieldfile
 foreign_key11004
 aliashotel-schwarzsee-zermatt-im-mattertal-impression-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id592538
 filewebroot/files/Media/File/CkeditorXs/618b7e3389919.jpg
 size4186
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id592541
 hashfb01a3713bb74b5cd04154bf6f92e7b8
 created2021-11-10 09:09:23
 updated2021-11-10 09:09:23
 modelMedia
 fieldfile
 foreign_key11004
 aliashotel-schwarzsee-zermatt-im-mattertal-impression-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id592538
 filewebroot/files/Media/File/CkeditorSm/618b7e33bfb9f.jpg
 size13006
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id592542
 hash5f501fb53e97e0d7affdc50ba73380a2
 created2021-11-10 09:09:24
 updated2021-11-10 09:09:24
 modelMedia
 fieldfile
 foreign_key11004
 aliashotel-schwarzsee-zermatt-im-mattertal-impression-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id592538
 filewebroot/files/Media/File/CkeditorMd/618b7e33e255e.jpg
 size20494
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id592543
 hash72429f53100fabf803a2a4b61932234d
 created2021-11-10 09:09:24
 updated2021-11-10 09:09:24
 modelMedia
 fieldfile
 foreign_key11004
 aliashotel-schwarzsee-zermatt-im-mattertal-impression-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id592538
 filewebroot/files/Media/File/CkeditorLg/618b7e340adbf.jpg
 size44113
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 2(array)
 id8707
 hash933c2ae656e20c42cf25022cf44fddbb
 created2020-09-03 12:16:57
 updated2020-09-03 12:16:57
 titleHotel_Restaurant_Schwarzsee_Zermatt
 cross_reference_count1
 MediaEntity(array)
 id498514
 pos3
 media_id8707
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394523
 hash9822e5aa4c4c0d2bf37aebf4c54cc273
 created2020-09-03 12:16:56
 updated2020-09-03 12:16:57
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c299c44a1.jpg
 size313926
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id563968
 hashd9f554f6d116cdef679105b800e4940d
 created2021-08-06 11:43:25
 updated2021-08-06 11:43:25
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id394523
 filewebroot/files/Media/File/ThSeoImageFacebook/610d043d1d8e1.png
 size320081
 ext.png
 mimeimage/png
 width720
 height405
 2(array)
 id563969
 hash92670a4df57d9e768c774bdce8446392
 created2021-08-06 11:43:25
 updated2021-08-06 11:43:25
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id394523
 filewebroot/files/Media/File/ThSeoImageGoogle/610d043d76911.png
 size320081
 ext.png
 mimeimage/png
 width720
 height405
 3(array)
 id563970
 hash0b157b8fd51fed1181218a5ab2a57e9c
 created2021-08-06 11:43:25
 updated2021-08-06 11:43:25
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id394523
 filewebroot/files/Media/File/ThSeoImageTwitter/610d043dc1cab.png
 size98093
 ext.png
 mimeimage/png
 width375
 height210
 4(array)
 id670255
 hash35901e20d0890429009e0882eed8b264
 created2023-01-11 13:48:01
 updated2023-01-11 13:48:01
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394523
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb0010d7d2.jpg
 size95276
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 5(array)
 id484787
 hash9ae4a47b33887cd63047d153058d2239
 created2020-10-28 02:37:34
 updated2020-10-28 02:37:34
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394523
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb5e671b0.jpg
 size14673
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 6(array)
 id484788
 hash459991c9a0714812be1f126bbc5eaa8f
 created2020-10-28 02:37:34
 updated2020-10-28 02:37:34
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394523
 filewebroot/files/Media/File/CkeditorXs/5f98cb5ea2611.jpg
 size5046
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 7(array)
 id484789
 hasheb4d987ea2be5f67326ca09fb8c4216a
 created2020-10-28 02:37:35
 updated2020-10-28 02:37:35
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394523
 filewebroot/files/Media/File/CkeditorSm/5f98cb5ee7839.jpg
 size14673
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 8(array)
 id484790
 hashe280b845a2523591461cf17854bff80e
 created2020-10-28 02:37:35
 updated2020-10-28 02:37:35
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394523
 filewebroot/files/Media/File/CkeditorMd/5f98cb5f28c2c.jpg
 size22708
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 9(array)
 id484791
 hash98dd30ec55a39be4fa996c03e2894406
 created2020-10-28 02:37:35
 updated2020-10-28 02:37:35
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394523
 filewebroot/files/Media/File/CkeditorLg/5f98cb5f5c595.jpg
 size46660
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 10(array)
 id563953
 hash1401756867ce7ce8f4523955bd18ac7b
 created2021-08-06 11:43:22
 updated2021-08-06 11:43:22
 modelMedia
 fieldfile
 foreign_key8707
 aliashotel-restaurant-schwarzsee-zermatt-thaccomodationteaserimage.jpg
 thumbnailth-accomodation-teaser-image
 parent_id394523
 filewebroot/files/Media/File/ThAccomodationTeaserImage/610d043a0e94a.jpg
 size38791
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 3(array)
 id8704
 hashca41ab6e68d73e4faf3f7f2d84bfaaba
 created2020-09-03 12:15:20
 updated2020-09-03 12:15:20
 titleHotel_Restaurant_Schwarzsee_Zermatt_Terrasse
 cross_reference_count1
 MediaEntity(array)
 id498515
 pos4
 media_id8704
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394505
 hash171984450037316e8b05dd732aa4ee63
 created2020-09-03 12:15:19
 updated2020-09-03 12:15:20
 modelMedia
 fieldfile
 foreign_key8704
 aliashotel-restaurant-schwarzsee-zermatt-terrasse.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c238c131a.jpg
 size322646
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670256
 hash0dc93a45c5d925fb11dac0cf62c08450
 created2023-01-11 13:48:01
 updated2023-01-11 13:48:01
 modelMedia
 fieldfile
 foreign_key8704
 aliashotel-restaurant-schwarzsee-zermatt-terrasse-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394505
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb0013df9d.jpg
 size150530
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484772
 hash0f7898438b1ced9e7911fd0a36d4dd2c
 created2020-10-28 02:37:30
 updated2020-10-28 02:37:30
 modelMedia
 fieldfile
 foreign_key8704
 aliashotel-restaurant-schwarzsee-zermatt-terrasse-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394505
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb5aaf62e.jpg
 size14181
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484773
 hash207417d0f9c9718ab1b4c66c28258163
 created2020-10-28 02:37:31
 updated2020-10-28 02:37:31
 modelMedia
 fieldfile
 foreign_key8704
 aliashotel-restaurant-schwarzsee-zermatt-terrasse-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394505
 filewebroot/files/Media/File/CkeditorXs/5f98cb5aefcc9.jpg
 size4551
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484774
 hashee7057e8a3f62be96a033968990c4040
 created2020-10-28 02:37:31
 updated2020-10-28 02:37:31
 modelMedia
 fieldfile
 foreign_key8704
 aliashotel-restaurant-schwarzsee-zermatt-terrasse-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394505
 filewebroot/files/Media/File/CkeditorSm/5f98cb5b43f6e.jpg
 size14181
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484775
 hashbb531e715d9fa485d7c89bdffe8e321e
 created2020-10-28 02:37:31
 updated2020-10-28 02:37:31
 modelMedia
 fieldfile
 foreign_key8704
 aliashotel-restaurant-schwarzsee-zermatt-terrasse-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394505
 filewebroot/files/Media/File/CkeditorMd/5f98cb5b7c276.jpg
 size22190
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484776
 hashcd10fbb925b9361056ba8b76659643c6
 created2020-10-28 02:37:31
 updated2020-10-28 02:37:31
 modelMedia
 fieldfile
 foreign_key8704
 aliashotel-restaurant-schwarzsee-zermatt-terrasse-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394505
 filewebroot/files/Media/File/CkeditorLg/5f98cb5bae014.jpg
 size47818
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 4(array)
 id8695
 hash6a210086a3370e81fbeafeb15b723e3b
 created2020-09-03 12:10:27
 updated2020-09-03 12:10:27
 titleHotel_Restaurant_Schwarzsee_Zermatt_Aussicht
 cross_reference_count1
 MediaEntity(array)
 id498516
 pos5
 media_id8695
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394431
 hashab697bb2735da7617709e2364c111137
 created2020-09-03 12:10:25
 updated2020-09-03 12:10:27
 modelMedia
 fieldfile
 foreign_key8695
 aliashotel-restaurant-schwarzsee-zermatt-aussicht.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c113720a1.jpg
 size275017
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670257
 hash882ea73acd6bcf6051228122e2d7e044
 created2023-01-11 13:48:01
 updated2023-01-11 13:48:01
 modelMedia
 fieldfile
 foreign_key8695
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394431
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb00167d96.jpg
 size121964
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484727
 hash614d0f51b5f11d110fc4bfc8efcfdc58
 created2020-10-28 02:37:19
 updated2020-10-28 02:37:19
 modelMedia
 fieldfile
 foreign_key8695
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394431
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb4eb3a9b.jpg
 size12618
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484728
 hash41853aca00c4518f55e9ee67fa158e62
 created2020-10-28 02:37:19
 updated2020-10-28 02:37:19
 modelMedia
 fieldfile
 foreign_key8695
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394431
 filewebroot/files/Media/File/CkeditorXs/5f98cb4f0168d.jpg
 size4169
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484729
 hashcb156db62c4ca367222abfc170781f88
 created2020-10-28 02:37:19
 updated2020-10-28 02:37:19
 modelMedia
 fieldfile
 foreign_key8695
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394431
 filewebroot/files/Media/File/CkeditorSm/5f98cb4f48a37.jpg
 size12618
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484730
 hashfd50c326530c11ea1538870fc6f94979
 created2020-10-28 02:37:19
 updated2020-10-28 02:37:19
 modelMedia
 fieldfile
 foreign_key8695
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394431
 filewebroot/files/Media/File/CkeditorMd/5f98cb4f7f827.jpg
 size19882
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484731
 hashb9c2de5da0efe0bc792ae38d81367645
 created2020-10-28 02:37:19
 updated2020-10-28 02:37:19
 modelMedia
 fieldfile
 foreign_key8695
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394431
 filewebroot/files/Media/File/CkeditorLg/5f98cb4fb24d8.jpg
 size42033
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 5(array)
 id8694
 hashaaad5e72154cbbfe43308c94f89a5f03
 created2020-09-03 12:10:02
 updated2020-09-03 12:10:02
 titleHotel_Restaurant_Schwarzsee_Zermatt_Aussicht_Gastraum
 cross_reference_count1
 MediaEntity(array)
 id498517
 pos6
 media_id8694
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394425
 hashaf648740ce66e0d6ff2077c9ff56af65
 created2020-09-03 12:10:00
 updated2020-09-03 12:10:02
 modelMedia
 fieldfile
 foreign_key8694
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-gastraum.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c0fa4a91f.jpg
 size289848
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670258
 hash7cf1c8219973c8fd478d9ddc1efab1b3
 created2023-01-11 13:48:01
 updated2023-01-11 13:48:01
 modelMedia
 fieldfile
 foreign_key8694
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-gastraum-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394425
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb001919d9.jpg
 size108216
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484722
 hashbf2991f5bf356ea5997162cc84cad3ad
 created2020-10-28 02:37:17
 updated2020-10-28 02:37:17
 modelMedia
 fieldfile
 foreign_key8694
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-gastraum-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394425
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb4d7bb0f.jpg
 size19510
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484723
 hashc106858d9d4888277697c6fa9868e9dc
 created2020-10-28 02:37:18
 updated2020-10-28 02:37:18
 modelMedia
 fieldfile
 foreign_key8694
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-gastraum-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394425
 filewebroot/files/Media/File/CkeditorXs/5f98cb4dbe0ba.jpg
 size6621
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484724
 hash178a19fb39b2105cfae8248d1015f257
 created2020-10-28 02:37:18
 updated2020-10-28 02:37:18
 modelMedia
 fieldfile
 foreign_key8694
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-gastraum-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394425
 filewebroot/files/Media/File/CkeditorSm/5f98cb4e1428f.jpg
 size19510
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484725
 hashe473f7a37a6ec8ae3b31020500864cdd
 created2020-10-28 02:37:18
 updated2020-10-28 02:37:18
 modelMedia
 fieldfile
 foreign_key8694
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-gastraum-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394425
 filewebroot/files/Media/File/CkeditorMd/5f98cb4e4ee99.jpg
 size30692
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484726
 hash44761d3607f30bb4aa2ad4d5147f8011
 created2020-10-28 02:37:18
 updated2020-10-28 02:37:18
 modelMedia
 fieldfile
 foreign_key8694
 aliashotel-restaurant-schwarzsee-zermatt-aussicht-gastraum-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394425
 filewebroot/files/Media/File/CkeditorLg/5f98cb4e87c4d.jpg
 size62883
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id11006
 hashd04a914ac4b875f68b6303ae7873a0a7
 created2021-11-10 09:11:25
 updated2021-11-10 09:11:25
 titleHotel Schwarzsee Zermatt mit Bergblick
 cross_reference_count1
 MediaEntity(array)
 id498518
 pos7
 media_id11006
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id592550
 hashe232b6a15a64787e090f9018848a86a6
 created2021-11-10 09:11:23
 updated2021-11-10 09:11:25
 modelMedia
 fieldfile
 foreign_key11006
 aliashotel-schwarzsee-zermatt-mit-bergblick.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/618b7ead4d3ce.jpg
 size274167
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670259
 hash0df19de1675ed40e4474d024015176df
 created2023-01-11 13:48:01
 updated2023-01-11 13:48:01
 modelMedia
 fieldfile
 foreign_key11006
 aliashotel-schwarzsee-zermatt-mit-bergblick-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id592550
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb001c29c1.jpg
 size134061
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id592551
 hash20cff49ac63342444c3971e03c6dca79
 created2021-11-10 09:11:25
 updated2021-11-10 09:11:25
 modelMedia
 fieldfile
 foreign_key11006
 aliashotel-schwarzsee-zermatt-mit-bergblick-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id592550
 filewebroot/files/Media/File/ThMediaFileIndex/618b7ead4e420.jpg
 size11491
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id592552
 hashb256cb4c46911e49fdff8c2ce880122c
 created2021-11-10 09:11:25
 updated2021-11-10 09:11:25
 modelMedia
 fieldfile
 foreign_key11006
 aliashotel-schwarzsee-zermatt-mit-bergblick-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id592550
 filewebroot/files/Media/File/CkeditorXs/618b7ead7b39d.jpg
 size3725
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id592553
 hashdfcdb9fc6657af43b6268252b64bd0a7
 created2021-11-10 09:11:25
 updated2021-11-10 09:11:25
 modelMedia
 fieldfile
 foreign_key11006
 aliashotel-schwarzsee-zermatt-mit-bergblick-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id592550
 filewebroot/files/Media/File/CkeditorSm/618b7eadb22c1.jpg
 size11491
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id592554
 hashf075edf6470c53045731d0b61f193f0f
 created2021-11-10 09:11:25
 updated2021-11-10 09:11:25
 modelMedia
 fieldfile
 foreign_key11006
 aliashotel-schwarzsee-zermatt-mit-bergblick-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id592550
 filewebroot/files/Media/File/CkeditorMd/618b7eadd3f37.jpg
 size18157
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id592555
 hashc1e6dd0effdec0c40a570efcddbb45a8
 created2021-11-10 09:11:26
 updated2021-11-10 09:11:26
 modelMedia
 fieldfile
 foreign_key11006
 aliashotel-schwarzsee-zermatt-mit-bergblick-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id592550
 filewebroot/files/Media/File/CkeditorLg/618b7eadf0b0d.jpg
 size39358
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 7(array)
 id11007
 hash912011418a74cbac8018cf930cf608a4
 created2021-11-10 09:12:20
 updated2021-11-10 09:12:20
 titleHotel Schwarzsee Zermatt
 cross_reference_count1
 MediaEntity(array)
 id498519
 pos8
 media_id11007
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id592556
 hash0c44c314bc468d7c5d44113cfde20a3a
 created2021-11-10 09:12:18
 updated2021-11-10 09:12:20
 modelMedia
 fieldfile
 foreign_key11007
 aliashotel-schwarzsee-zermatt.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/618b7ee41a07e.jpg
 size282403
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670260
 hash739d1881433ca571dff509d84aa59a32
 created2023-01-11 13:48:02
 updated2023-01-11 13:48:02
 modelMedia
 fieldfile
 foreign_key11007
 aliashotel-schwarzsee-zermatt-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id592556
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb001ec9db.jpg
 size152694
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id592557
 hash8d2eef48d9d83cfad628bed149c11348
 created2021-11-10 09:12:20
 updated2021-11-10 09:12:20
 modelMedia
 fieldfile
 foreign_key11007
 aliashotel-schwarzsee-zermatt-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id592556
 filewebroot/files/Media/File/ThMediaFileIndex/618b7ee41abcf.jpg
 size14374
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id592558
 hashc860fef325568b5233b1e080cd3d286e
 created2021-11-10 09:12:20
 updated2021-11-10 09:12:20
 modelMedia
 fieldfile
 foreign_key11007
 aliashotel-schwarzsee-zermatt-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id592556
 filewebroot/files/Media/File/CkeditorXs/618b7ee4439fd.jpg
 size4685
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id592559
 hashe9b1abfeb8af05535764529b57362fa5
 created2021-11-10 09:12:20
 updated2021-11-10 09:12:20
 modelMedia
 fieldfile
 foreign_key11007
 aliashotel-schwarzsee-zermatt-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id592556
 filewebroot/files/Media/File/CkeditorSm/618b7ee4790f1.jpg
 size14374
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id592560
 hashc07c301e99dfaf4a1ca148d4f2fc5300
 created2021-11-10 09:12:20
 updated2021-11-10 09:12:20
 modelMedia
 fieldfile
 foreign_key11007
 aliashotel-schwarzsee-zermatt-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id592556
 filewebroot/files/Media/File/CkeditorMd/618b7ee49d538.jpg
 size22878
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id592561
 hash20ec0c52fda5243e8ee7b7164da754d5
 created2021-11-10 09:12:20
 updated2021-11-10 09:12:20
 modelMedia
 fieldfile
 foreign_key11007
 aliashotel-schwarzsee-zermatt-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id592556
 filewebroot/files/Media/File/CkeditorLg/618b7ee4ba60d.jpg
 size48314
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 8(array)
 id8703
 hash6e48c2ea9e95a261535f10381b635c3a
 created2020-09-03 12:14:44
 updated2020-09-03 12:14:44
 titleHotel_Restaurant_Schwarzsee_Zermatt_Teaser
 cross_reference_count1
 MediaEntity(array)
 id498520
 pos9
 media_id8703
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394499
 hash81016bfae7bd3985fabe0ab2ee242efb
 created2020-09-03 12:14:43
 updated2020-09-03 12:14:44
 modelMedia
 fieldfile
 foreign_key8703
 aliashotel-restaurant-schwarzsee-zermatt-teaser.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c214b7814.jpg
 size290298
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670261
 hashcfa48198de9fc95a15525b29af8818ea
 created2023-01-11 13:48:02
 updated2023-01-11 13:48:02
 modelMedia
 fieldfile
 foreign_key8703
 aliashotel-restaurant-schwarzsee-zermatt-teaser-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394499
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb00221379.jpg
 size129678
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484767
 hash8828117bb2044fac1198a68664c4986b
 created2020-10-28 02:37:29
 updated2020-10-28 02:37:29
 modelMedia
 fieldfile
 foreign_key8703
 aliashotel-restaurant-schwarzsee-zermatt-teaser-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394499
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb590fd57.jpg
 size11781
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484768
 hash2a73ece57b6f3f863e16adccf0d92cb9
 created2020-10-28 02:37:29
 updated2020-10-28 02:37:29
 modelMedia
 fieldfile
 foreign_key8703
 aliashotel-restaurant-schwarzsee-zermatt-teaser-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394499
 filewebroot/files/Media/File/CkeditorXs/5f98cb594d2b4.jpg
 size3802
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484769
 hash6dee7317fe700a023b1ebfd48260e1ef
 created2020-10-28 02:37:29
 updated2020-10-28 02:37:29
 modelMedia
 fieldfile
 foreign_key8703
 aliashotel-restaurant-schwarzsee-zermatt-teaser-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394499
 filewebroot/files/Media/File/CkeditorSm/5f98cb59932fb.jpg
 size11781
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484770
 hashdb3db12a6c3409052f6f5fcafd5dc7a3
 created2020-10-28 02:37:30
 updated2020-10-28 02:37:30
 modelMedia
 fieldfile
 foreign_key8703
 aliashotel-restaurant-schwarzsee-zermatt-teaser-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394499
 filewebroot/files/Media/File/CkeditorMd/5f98cb59c9532.jpg
 size18918
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484771
 hashbadfe5a9c92c14faea682fd1ccd1fda1
 created2020-10-28 02:37:30
 updated2020-10-28 02:37:30
 modelMedia
 fieldfile
 foreign_key8703
 aliashotel-restaurant-schwarzsee-zermatt-teaser-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394499
 filewebroot/files/Media/File/CkeditorLg/5f98cb5a0374e.jpg
 size41359
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 9(array)
 id11003
 hash332c3bfa561bcaf5174c9ad0f6b3c9bb
 created2021-11-10 09:08:32
 updated2021-11-10 09:08:32
 titleHotel Schwarzsee Wandern Hoehenweg rund um Zermatt
 cross_reference_count1
 MediaEntity(array)
 id498521
 pos10
 media_id11003
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id592532
 hash43066747048ab591a02050fe416f3e72
 created2021-11-10 09:07:49
 updated2021-11-10 09:08:32
 modelMedia
 fieldfile
 foreign_key11003
 aliashotel-schwarzsee-wandern-hoehenweg-rund-um-zermatt.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/618b7e00c64cf.jpg
 size271560
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670262
 hash1524ec80066f8c44340fe7ac5fa49978
 created2023-01-11 13:48:02
 updated2023-01-11 13:48:02
 modelMedia
 fieldfile
 foreign_key11003
 aliashotel-schwarzsee-wandern-hoehenweg-rund-um-zermatt-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id592532
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb002468ff.jpg
 size164291
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id592533
 hash5c7699f5e00efb61001737d383197d8a
 created2021-11-10 09:08:34
 updated2021-11-10 09:08:34
 modelMedia
 fieldfile
 foreign_key11003
 aliashotel-schwarzsee-wandern-hoehenweg-rund-um-zermatt-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id592532
 filewebroot/files/Media/File/ThMediaFileIndex/618b7e00c7a01.jpg
 size14641
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id592534
 hash51ef03d380ef5865d5d24909e2dfc07a
 created2021-11-10 09:08:34
 updated2021-11-10 09:08:34
 modelMedia
 fieldfile
 foreign_key11003
 aliashotel-schwarzsee-wandern-hoehenweg-rund-um-zermatt-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id592532
 filewebroot/files/Media/File/CkeditorXs/618b7e02181a6.jpg
 size4600
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id592535
 hash3d7391780a30ea64bc244bdf433f97f9
 created2021-11-10 09:08:34
 updated2021-11-10 09:08:34
 modelMedia
 fieldfile
 foreign_key11003
 aliashotel-schwarzsee-wandern-hoehenweg-rund-um-zermatt-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id592532
 filewebroot/files/Media/File/CkeditorSm/618b7e026b337.jpg
 size14641
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id592536
 hashe9f6c466331626d8f3290d3f009b939e
 created2021-11-10 09:08:34
 updated2021-11-10 09:08:34
 modelMedia
 fieldfile
 foreign_key11003
 aliashotel-schwarzsee-wandern-hoehenweg-rund-um-zermatt-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id592532
 filewebroot/files/Media/File/CkeditorMd/618b7e0295fe8.jpg
 size23050
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id592537
 hash00ac12cdf960f2fc53b398c7a68540de
 created2021-11-10 09:08:34
 updated2021-11-10 09:08:34
 modelMedia
 fieldfile
 foreign_key11003
 aliashotel-schwarzsee-wandern-hoehenweg-rund-um-zermatt-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id592532
 filewebroot/files/Media/File/CkeditorLg/618b7e02b87da.jpg
 size49760
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 10(array)
 id8697
 hashe393381a223579e17d230347afa7dca9
 created2020-09-03 12:11:18
 updated2020-09-03 12:11:18
 titleHotel_Restaurant_Schwarzsee_Zermatt_Gastraum_Impression
 cross_reference_count1
 MediaEntity(array)
 id498522
 pos11
 media_id8697
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394443
 hash9958fe82fa828bb6c7b2d6232790b530
 created2020-09-03 12:11:17
 updated2020-09-03 12:11:18
 modelMedia
 fieldfile
 foreign_key8697
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-impression.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c1466bbf7.jpg
 size296957
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670263
 hash88c429f1067e910882b16a977e7f908f
 created2023-01-11 13:48:02
 updated2023-01-11 13:48:02
 modelMedia
 fieldfile
 foreign_key8697
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-impression-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394443
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb0026a351.jpg
 size114854
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484737
 hash421a427ed05c17e10f2e92608e1960df
 created2020-10-28 02:37:21
 updated2020-10-28 02:37:21
 modelMedia
 fieldfile
 foreign_key8697
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-impression-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394443
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb51155a2.jpg
 size21270
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484738
 hash477ca92926f2adf38411acd047e70296
 created2020-10-28 02:37:21
 updated2020-10-28 02:37:21
 modelMedia
 fieldfile
 foreign_key8697
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-impression-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394443
 filewebroot/files/Media/File/CkeditorXs/5f98cb516b77a.jpg
 size7208
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484739
 hashbf42dc6959fbd7b5329ddd7023a8495f
 created2020-10-28 02:37:21
 updated2020-10-28 02:37:21
 modelMedia
 fieldfile
 foreign_key8697
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-impression-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394443
 filewebroot/files/Media/File/CkeditorSm/5f98cb51b4a32.jpg
 size21270
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484740
 hash58814d566be334326dae382251cd52a7
 created2020-10-28 02:37:22
 updated2020-10-28 02:37:22
 modelMedia
 fieldfile
 foreign_key8697
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-impression-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394443
 filewebroot/files/Media/File/CkeditorMd/5f98cb51ec53e.jpg
 size32774
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484741
 hashdc0e8605e81480108721528383810170
 created2020-10-28 02:37:22
 updated2020-10-28 02:37:22
 modelMedia
 fieldfile
 foreign_key8697
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-impression-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394443
 filewebroot/files/Media/File/CkeditorLg/5f98cb5227601.jpg
 size64943
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 11(array)
 id8698
 hash48cdd1dca1d1b67488f546f08212ad73
 created2020-09-03 12:12:06
 updated2020-09-03 12:12:06
 titleHotel_Restaurant_Schwarzsee_Zermatt_Gastraum
 cross_reference_count1
 MediaEntity(array)
 id498523
 pos12
 media_id8698
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394469
 hash9ab36418685a1916f4c4aab02f0b90cb
 created2020-09-03 12:12:00
 updated2020-09-03 12:12:06
 modelMedia
 fieldfile
 foreign_key8698
 aliashotel-restaurant-schwarzsee-zermatt-gastraum.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c1763e938.jpg
 size304943
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670264
 hash50e53122d7fffae66a7975aca184a338
 created2023-01-11 13:48:02
 updated2023-01-11 13:48:02
 modelMedia
 fieldfile
 foreign_key8698
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394469
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb00295c3c.jpg
 size128096
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484742
 hash950875c107a978a602c694b75c3c032b
 created2020-10-28 02:37:22
 updated2020-10-28 02:37:22
 modelMedia
 fieldfile
 foreign_key8698
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394469
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb52529e5.jpg
 size23636
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484743
 hashed49b2766c1973fb975771d9ece0a32b
 created2020-10-28 02:37:22
 updated2020-10-28 02:37:22
 modelMedia
 fieldfile
 foreign_key8698
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394469
 filewebroot/files/Media/File/CkeditorXs/5f98cb52911aa.jpg
 size7839
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484744
 hash0b0d98fb3fed4c2651b1a9389751de7b
 created2020-10-28 02:37:23
 updated2020-10-28 02:37:23
 modelMedia
 fieldfile
 foreign_key8698
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394469
 filewebroot/files/Media/File/CkeditorSm/5f98cb52d3fed.jpg
 size23636
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484745
 hash0ceedb3577ec022eb89e6b511312c4c5
 created2020-10-28 02:37:23
 updated2020-10-28 02:37:23
 modelMedia
 fieldfile
 foreign_key8698
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394469
 filewebroot/files/Media/File/CkeditorMd/5f98cb5312fd8.jpg
 size36903
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484746
 hashe673f367655973a7d06fc7109c6e7741
 created2020-10-28 02:37:23
 updated2020-10-28 02:37:23
 modelMedia
 fieldfile
 foreign_key8698
 aliashotel-restaurant-schwarzsee-zermatt-gastraum-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394469
 filewebroot/files/Media/File/CkeditorLg/5f98cb5344afc.jpg
 size74618
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 12(array)
 id8699
 hashf2004fc756752ed9bfe0a506e2a10169
 created2020-09-03 12:12:39
 updated2020-09-03 12:12:39
 titleHotel_Restaurant_Schwarzsee_Zermatt_Lounge
 cross_reference_count1
 MediaEntity(array)
 id498524
 pos13
 media_id8699
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394475
 hash6d2a9df5c6bd21748f56e016118c3d14
 created2020-09-03 12:12:35
 updated2020-09-03 12:12:39
 modelMedia
 fieldfile
 foreign_key8699
 aliashotel-restaurant-schwarzsee-zermatt-lounge.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c197158f9.jpg
 size339675
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670265
 hash1110cfb5213c95b43f1eba8422d984dd
 created2023-01-11 13:48:03
 updated2023-01-11 13:48:03
 modelMedia
 fieldfile
 foreign_key8699
 aliashotel-restaurant-schwarzsee-zermatt-lounge-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394475
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb002d20d8.jpg
 size131734
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484747
 hashe83e6816934165e1a2d0f798f721388e
 created2020-10-28 02:37:24
 updated2020-10-28 02:37:24
 modelMedia
 fieldfile
 foreign_key8699
 aliashotel-restaurant-schwarzsee-zermatt-lounge-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394475
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb5408066.jpg
 size13932
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484748
 hash013168754c9ba66755fb62abfc6962ac
 created2020-10-28 02:37:24
 updated2020-10-28 02:37:24
 modelMedia
 fieldfile
 foreign_key8699
 aliashotel-restaurant-schwarzsee-zermatt-lounge-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394475
 filewebroot/files/Media/File/CkeditorXs/5f98cb54485a8.jpg
 size4469
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484749
 hashf8caad6e89c6f5978d29f79dc964db72
 created2020-10-28 02:37:24
 updated2020-10-28 02:37:24
 modelMedia
 fieldfile
 foreign_key8699
 aliashotel-restaurant-schwarzsee-zermatt-lounge-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394475
 filewebroot/files/Media/File/CkeditorSm/5f98cb548ef0e.jpg
 size13932
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484750
 hashc9d38dea358f777bf83f618bdf13e924
 created2020-10-28 02:37:24
 updated2020-10-28 02:37:24
 modelMedia
 fieldfile
 foreign_key8699
 aliashotel-restaurant-schwarzsee-zermatt-lounge-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394475
 filewebroot/files/Media/File/CkeditorMd/5f98cb54c2543.jpg
 size21896
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484751
 hash5f0b34d2a5ad2c452d66c22c5cbf75ec
 created2020-10-28 02:37:25
 updated2020-10-28 02:37:25
 modelMedia
 fieldfile
 foreign_key8699
 aliashotel-restaurant-schwarzsee-zermatt-lounge-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394475
 filewebroot/files/Media/File/CkeditorLg/5f98cb54efb72.jpg
 size46849
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 13(array)
 id8705
 hashaa9950a44f5124eda1e33d32ff0b3c75
 created2020-09-03 12:15:49
 updated2020-09-03 12:15:49
 titleHotel_Restaurant_Schwarzsee_Zermatt_Theke
 cross_reference_count1
 MediaEntity(array)
 id498525
 pos14
 media_id8705
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394511
 hash3a8bf66f9c1e922d1365bef0e21e5510
 created2020-09-03 12:15:47
 updated2020-09-03 12:15:49
 modelMedia
 fieldfile
 foreign_key8705
 aliashotel-restaurant-schwarzsee-zermatt-theke.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c2550a39f.jpg
 size325914
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670266
 hashb53969a525560a54587713ec4288518a
 created2023-01-11 13:48:03
 updated2023-01-11 13:48:03
 modelMedia
 fieldfile
 foreign_key8705
 aliashotel-restaurant-schwarzsee-zermatt-theke-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394511
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb00312954.jpg
 size150624
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484777
 hashf9720d2e81d8abe02d0c8fbd788c4261
 created2020-10-28 02:37:32
 updated2020-10-28 02:37:32
 modelMedia
 fieldfile
 foreign_key8705
 aliashotel-restaurant-schwarzsee-zermatt-theke-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394511
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb5bd625a.jpg
 size15257
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484778
 hash2a32d59a59850983abd3d6d152a72b6f
 created2020-10-28 02:37:32
 updated2020-10-28 02:37:32
 modelMedia
 fieldfile
 foreign_key8705
 aliashotel-restaurant-schwarzsee-zermatt-theke-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394511
 filewebroot/files/Media/File/CkeditorXs/5f98cb5c29781.jpg
 size4877
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484779
 hash0a2791b63a101b7023712b7994684b55
 created2020-10-28 02:37:32
 updated2020-10-28 02:37:32
 modelMedia
 fieldfile
 foreign_key8705
 aliashotel-restaurant-schwarzsee-zermatt-theke-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394511
 filewebroot/files/Media/File/CkeditorSm/5f98cb5c6fed9.jpg
 size15257
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484780
 hash549caa8d24bfaa84642c4f9bf74c1304
 created2020-10-28 02:37:32
 updated2020-10-28 02:37:32
 modelMedia
 fieldfile
 foreign_key8705
 aliashotel-restaurant-schwarzsee-zermatt-theke-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394511
 filewebroot/files/Media/File/CkeditorMd/5f98cb5ca28e5.jpg
 size24181
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484781
 hash1ee579fcc37f27ece08968f382c48cdf
 created2020-10-28 02:37:33
 updated2020-10-28 02:37:33
 modelMedia
 fieldfile
 foreign_key8705
 aliashotel-restaurant-schwarzsee-zermatt-theke-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394511
 filewebroot/files/Media/File/CkeditorLg/5f98cb5cd9164.jpg
 size51783
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 14(array)
 id8696
 hash0d9ac826ba6f2f480758eb96a21cb1e1
 created2020-09-03 12:10:50
 updated2020-09-03 12:10:50
 titleHotel_Restaurant_Schwarzsee_Zermatt_Doppelzimmer
 cross_reference_count1
 MediaEntity(array)
 id498526
 pos15
 media_id8696
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394437
 hash2f1f07f36014e05a5ae402ae4b5745ba
 created2020-09-03 12:10:48
 updated2020-09-03 12:10:50
 modelMedia
 fieldfile
 foreign_key8696
 aliashotel-restaurant-schwarzsee-zermatt-doppelzimmer.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c12a32a1c.jpg
 size345366
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670267
 hashca9a534ad4066eb6162f7aca2d016ced
 created2023-01-11 13:48:03
 updated2023-01-11 13:48:03
 modelMedia
 fieldfile
 foreign_key8696
 aliashotel-restaurant-schwarzsee-zermatt-doppelzimmer-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394437
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb00344705.jpg
 size92786
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484732
 hash62fd2000f8ef949558fcce3411c5b13e
 created2020-10-28 02:37:20
 updated2020-10-28 02:37:20
 modelMedia
 fieldfile
 foreign_key8696
 aliashotel-restaurant-schwarzsee-zermatt-doppelzimmer-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394437
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb4fe7c52.jpg
 size16295
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484733
 hashc8a0090d59262517424abb8c3fecec43
 created2020-10-28 02:37:20
 updated2020-10-28 02:37:20
 modelMedia
 fieldfile
 foreign_key8696
 aliashotel-restaurant-schwarzsee-zermatt-doppelzimmer-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394437
 filewebroot/files/Media/File/CkeditorXs/5f98cb5031f9b.jpg
 size5857
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484734
 hashcb23778694d541142196e3c9198d863c
 created2020-10-28 02:37:20
 updated2020-10-28 02:37:20
 modelMedia
 fieldfile
 foreign_key8696
 aliashotel-restaurant-schwarzsee-zermatt-doppelzimmer-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394437
 filewebroot/files/Media/File/CkeditorSm/5f98cb5079b00.jpg
 size16295
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484735
 hash33e4d4d38275f3a91a0f812d71572343
 created2020-10-28 02:37:20
 updated2020-10-28 02:37:20
 modelMedia
 fieldfile
 foreign_key8696
 aliashotel-restaurant-schwarzsee-zermatt-doppelzimmer-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394437
 filewebroot/files/Media/File/CkeditorMd/5f98cb50ae925.jpg
 size24698
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484736
 hash671f46e0e5043acdabe933b847ae1da6
 created2020-10-28 02:37:21
 updated2020-10-28 02:37:21
 modelMedia
 fieldfile
 foreign_key8696
 aliashotel-restaurant-schwarzsee-zermatt-doppelzimmer-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394437
 filewebroot/files/Media/File/CkeditorLg/5f98cb50df3e7.jpg
 size50017
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 15(array)
 id8700
 hashd3f651dabcd65d14db4409b95af846b9
 created2020-09-03 12:13:10
 updated2020-09-03 12:13:10
 titleHotel_Restaurant_Schwarzsee_Zermatt_Mehrbettraum
 cross_reference_count1
 MediaEntity(array)
 id498527
 pos16
 media_id8700
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394481
 hash645d4fa84681838b62258447273e3010
 created2020-09-03 12:13:08
 updated2020-09-03 12:13:10
 modelMedia
 fieldfile
 foreign_key8700
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettraum.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c1b63d8db.jpg
 size325505
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670268
 hash64930cede1af03448b1a9c1fc0861056
 created2023-01-11 13:48:03
 updated2023-01-11 13:48:03
 modelMedia
 fieldfile
 foreign_key8700
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettraum-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394481
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb0036cf2a.jpg
 size126210
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484752
 hashbfef4a01e6dec9c499c51f1f30886a8e
 created2020-10-28 02:37:25
 updated2020-10-28 02:37:25
 modelMedia
 fieldfile
 foreign_key8700
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettraum-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394481
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb55248df.jpg
 size21103
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484753
 hashb1ac17105c5ce41f924215d1e47b4606
 created2020-10-28 02:37:25
 updated2020-10-28 02:37:25
 modelMedia
 fieldfile
 foreign_key8700
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettraum-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394481
 filewebroot/files/Media/File/CkeditorXs/5f98cb5567df5.jpg
 size7166
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484754
 hashc429814e61847d589938f591492ef7fc
 created2020-10-28 02:37:25
 updated2020-10-28 02:37:25
 modelMedia
 fieldfile
 foreign_key8700
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettraum-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394481
 filewebroot/files/Media/File/CkeditorSm/5f98cb55b16a3.jpg
 size21103
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484755
 hash181cc5645338bd3a0ad6e54dea55aa71
 created2020-10-28 02:37:26
 updated2020-10-28 02:37:26
 modelMedia
 fieldfile
 foreign_key8700
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettraum-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394481
 filewebroot/files/Media/File/CkeditorMd/5f98cb55e47b0.jpg
 size33551
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484756
 hash1dba8456fef8a4921adb739b9d33fc8b
 created2020-10-28 02:37:26
 updated2020-10-28 02:37:26
 modelMedia
 fieldfile
 foreign_key8700
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettraum-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394481
 filewebroot/files/Media/File/CkeditorLg/5f98cb56200f3.jpg
 size68003
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 16(array)
 id8701
 hash4a1994a7e594bba6b067f747ff64de5a
 created2020-09-03 12:13:42
 updated2020-09-03 12:13:42
 titleHotel_Restaurant_Schwarzsee_Zermatt_Mehrbettzimmer
 cross_reference_count1
 MediaEntity(array)
 id498528
 pos17
 media_id8701
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394487
 hash70a6dd7ceacbcb2acc04e6c9739ada46
 created2020-09-03 12:13:40
 updated2020-09-03 12:13:42
 modelMedia
 fieldfile
 foreign_key8701
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettzimmer.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c1d63b429.jpg
 size257569
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670269
 hashc2eed7447afad2b013d280a734af9236
 created2023-01-11 13:48:03
 updated2023-01-11 13:48:03
 modelMedia
 fieldfile
 foreign_key8701
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettzimmer-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394487
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb003a3986.jpg
 size126511
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484757
 hash9ddc56befa5c06107424a1b66282c313
 created2020-10-28 02:37:26
 updated2020-10-28 02:37:26
 modelMedia
 fieldfile
 foreign_key8701
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettzimmer-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394487
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb565c9b2.jpg
 size18827
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484758
 hashc10686b1ca68e5e1468953e6e768d32a
 created2020-10-28 02:37:27
 updated2020-10-28 02:37:27
 modelMedia
 fieldfile
 foreign_key8701
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettzimmer-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394487
 filewebroot/files/Media/File/CkeditorXs/5f98cb56d46d0.jpg
 size6257
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484759
 hash07c3317e31ee8269dcea8874905d0787
 created2020-10-28 02:37:27
 updated2020-10-28 02:37:27
 modelMedia
 fieldfile
 foreign_key8701
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettzimmer-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394487
 filewebroot/files/Media/File/CkeditorSm/5f98cb5727dbd.jpg
 size18827
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484760
 hash1d76ec073f949bee2157ab879791befe
 created2020-10-28 02:37:27
 updated2020-10-28 02:37:27
 modelMedia
 fieldfile
 foreign_key8701
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettzimmer-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394487
 filewebroot/files/Media/File/CkeditorMd/5f98cb575ef6a.jpg
 size30056
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484761
 hash5755035c06db1b3549f3ca6305f7901c
 created2020-10-28 02:37:27
 updated2020-10-28 02:37:27
 modelMedia
 fieldfile
 foreign_key8701
 aliashotel-restaurant-schwarzsee-zermatt-mehrbettzimmer-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394487
 filewebroot/files/Media/File/CkeditorLg/5f98cb57909ab.jpg
 size64106
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 17(array)
 id8702
 hasha0da1108093c5fbf0ef0624d403583e8
 created2020-09-03 12:14:08
 updated2020-09-03 12:14:08
 titleHotel_Restaurant_Schwarzsee_Zermatt_Rezeption
 cross_reference_count1
 MediaEntity(array)
 id498529
 pos18
 media_id8702
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394493
 hash921ee65c78a7a4ecdeab4608b2a22c7a
 created2020-09-03 12:14:06
 updated2020-09-03 12:14:08
 modelMedia
 fieldfile
 foreign_key8702
 aliashotel-restaurant-schwarzsee-zermatt-rezeption.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c1f062ac8.jpg
 size333869
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670270
 hashd9eeb42d7bbd52637951ebfd6dfb6c09
 created2023-01-11 13:48:04
 updated2023-01-11 13:48:04
 modelMedia
 fieldfile
 foreign_key8702
 aliashotel-restaurant-schwarzsee-zermatt-rezeption-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394493
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb003db019.jpg
 size149438
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484762
 hashccc5a701396138cd715f9974714b88d1
 created2020-10-28 02:37:28
 updated2020-10-28 02:37:28
 modelMedia
 fieldfile
 foreign_key8702
 aliashotel-restaurant-schwarzsee-zermatt-rezeption-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394493
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb57cb264.jpg
 size21252
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484763
 hashe9fad8092c2ba00f23298e4f105d831c
 created2020-10-28 02:37:28
 updated2020-10-28 02:37:28
 modelMedia
 fieldfile
 foreign_key8702
 aliashotel-restaurant-schwarzsee-zermatt-rezeption-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394493
 filewebroot/files/Media/File/CkeditorXs/5f98cb581e0ab.jpg
 size7029
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484764
 hasheee4c4fda6c9e7004fab8e10e330264f
 created2020-10-28 02:37:28
 updated2020-10-28 02:37:28
 modelMedia
 fieldfile
 foreign_key8702
 aliashotel-restaurant-schwarzsee-zermatt-rezeption-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394493
 filewebroot/files/Media/File/CkeditorSm/5f98cb5866a84.jpg
 size21252
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484765
 hashd6a56fa04d1f447afd81b41fc714031f
 created2020-10-28 02:37:28
 updated2020-10-28 02:37:28
 modelMedia
 fieldfile
 foreign_key8702
 aliashotel-restaurant-schwarzsee-zermatt-rezeption-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394493
 filewebroot/files/Media/File/CkeditorMd/5f98cb5899e4c.jpg
 size33673
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484766
 hashd10769f6e67682f80888d5096ec6a94e
 created2020-10-28 02:37:29
 updated2020-10-28 02:37:29
 modelMedia
 fieldfile
 foreign_key8702
 aliashotel-restaurant-schwarzsee-zermatt-rezeption-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394493
 filewebroot/files/Media/File/CkeditorLg/5f98cb58cc1d8.jpg
 size69173
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 18(array)
 id8706
 hash04f93a4633d5591427f6b196666b7a90
 created2020-09-03 12:16:29
 updated2020-09-03 12:16:29
 titleHotel_Restaurant_Schwarzsee_Zermatt_Zimmer_Waschbecken
 cross_reference_count1
 MediaEntity(array)
 id498530
 pos19
 media_id8706
 modelAccomodation
 fieldgallery
 foreign_key135
 FileUpload(array)
 0(array)
 id394517
 hash900795bed1f8989c5060683d0ec14dd6
 created2020-09-03 12:16:23
 updated2020-09-03 12:16:29
 modelMedia
 fieldfile
 foreign_key8706
 aliashotel-restaurant-schwarzsee-zermatt-zimmer-waschbecken.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5f50c27d91b80.jpg
 size339910
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id670271
 hash01e9c8e01f6497ae2cbb69577db7d09b
 created2023-01-11 13:48:04
 updated2023-01-11 13:48:04
 modelMedia
 fieldfile
 foreign_key8706
 aliashotel-restaurant-schwarzsee-zermatt-zimmer-waschbecken-thaccomodationgalleryresponsive.jpg
 thumbnailth-accomodation-gallery-responsive
 parent_id394517
 filewebroot/files/Media/File/ThAccomodationGalleryResponsive/63beb0041de34.jpg
 size108465
 ext.jpg
 mimeimage/jpeg
 width1140
 height640
 2(array)
 id484782
 hash72fc2fa22b5111bc2e0dcd3dc398f9cb
 created2020-10-28 02:37:33
 updated2020-10-28 02:37:33
 modelMedia
 fieldfile
 foreign_key8706
 aliashotel-restaurant-schwarzsee-zermatt-zimmer-waschbecken-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id394517
 filewebroot/files/Media/File/ThMediaFileIndex/5f98cb5d12d24.jpg
 size18305
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id484783
 hashb005e94264fc54cefa10f82a1c923960
 created2020-10-28 02:37:33
 updated2020-10-28 02:37:33
 modelMedia
 fieldfile
 foreign_key8706
 aliashotel-restaurant-schwarzsee-zermatt-zimmer-waschbecken-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id394517
 filewebroot/files/Media/File/CkeditorXs/5f98cb5d54d3d.jpg
 size6372
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id484784
 hashe4b4714f057c8ab55b94eed5ff7e9e68
 created2020-10-28 02:37:33
 updated2020-10-28 02:37:33
 modelMedia
 fieldfile
 foreign_key8706
 aliashotel-restaurant-schwarzsee-zermatt-zimmer-waschbecken-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id394517
 filewebroot/files/Media/File/CkeditorSm/5f98cb5d9e968.jpg
 size18305
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id484785
 hash987fdebbd690d65f73dd8842542abf8e
 created2020-10-28 02:37:34
 updated2020-10-28 02:37:34
 modelMedia
 fieldfile
 foreign_key8706
 aliashotel-restaurant-schwarzsee-zermatt-zimmer-waschbecken-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id394517
 filewebroot/files/Media/File/CkeditorMd/5f98cb5ddb35d.jpg
 size28024
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id484786
 hash47dad53246631603429ac1afe4b33481
 created2020-10-28 02:37:34
 updated2020-10-28 02:37:34
 modelMedia
 fieldfile
 foreign_key8706
 aliashotel-restaurant-schwarzsee-zermatt-zimmer-waschbecken-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id394517
 filewebroot/files/Media/File/CkeditorLg/5f98cb5e1d458.jpg
 size57922
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 TagsTag(empty)
 TravelReport(empty)
- accomodationTours(array)
 0(array)
 Tour(array)
 id149
 hash37611dad763833846efe15118f214b41
 created2016-06-22 10:47:54
 updated2024-10-02 16:33:48
 tour_number416000000149
 titleAuf dem Höhenweg rund um Zermatt
 subtitleGeführte Wanderungen mit Bergwanderführer im Banne des Matterhorn
 participants_min5
 participants_max8
 duration_days3
 duration_typeweekend_tour
 tour_price879.00
 down_payment20
 country_of_serviceswiss
 saisonsummer
 travel_insurance_certificate(true)
 out_of_alpine_tour(false)
 rating_condition3
 rating_technique4
 rating_experience2
 rating_difficulty_categorymedium
 rating_seriousness1
 rating_overall_score2.5
 start_zip3927
 start_cityHerbriggen
 start_streetDorfstrasse 93
 start_countryCH
 start_meeting_pointist an der Rezeption im Hotel Bergfreund in Herbriggen.
 start_time09:30:00
 end_alternate_address(false)
 end_time16:30:00
 flight(false)
 flight_details(null)
 consultationACHTUNG: Sollte Hotel Schwarzsee 2020 wegen Renovierung geschlossen haben (war eig. für 2019 geplant), dann folgenden Verlauf: 1. Tag Treffpunkt im Hotel Bergfreund am Vormittag. Begrüßung und gemeinsame Weiterfahrt mit dem Hotelbus zur Täschalpe. Von hier starten wir mit unserer Wanderung. Begleitet von den Viertausendern Alphubel, Allalin- und Rimpfischhorn geht es südwärts zum Findelgletscher und weiter zum traditionsreichen Fluhalp Berggasthaus, wo wir die Nacht verbringen. Tief unter uns liegt nun das Bergsteigerdorf Zermatt. Von der Terrasse genießen wir die Aussicht auf das Wahrzeichen Zermatts, das Matterhorn, das sich unweit der Hütte im Stellisee wiederspiegelt. Gz 6 h / ↑ 950 Hm, ↓ 550 Hm 2. Tag Nach dem gemütlichen Frühstück machen wir uns an den Abstieg zum Grünsee auf 2.300 m. Von hier führt der Weg durch das Findelbachtal und über Winkelmatten nach Zermatt, wo wir eine gemütliche Kaffeepause einlegen können. Anschließend Aufstieg durch den Botanischen Garten und die Triftschlucht zum Hotel Edelweiss und weiter zum Berggasthaus Trift (2.337 m), unserem heutigen Etappenziel. Der Wirt wird uns sicherlich bereits mit dem Alphorn willkommen heißen. Gz 6 h / ↑ 850 Hm, ↓ 1.050 Hm 3. Tag Über den malerischen Höhenweg unterhalb des Gabelhorns (4.063 m) setzen wir unsere Wanderung in Richtung Matterhorn fort, die beeindruckende Matterhorn Nordwand und den Dent d ́Hérens stets im Blick. Über die Gletschermoräne des Zmuttgletschers erreichen wir die Schönbielhütte 2.694 m). Wenn noch genügend Zeit und Lust bleibt, können wir optional am Nachmittag noch in Richtung Gemsspitz (3.182 m) weiterwandern, bevor wir den Abend auf der urigen Schönbielhütte ausklingen lassen. Gz 4 – 5 h / ↑ 750 Hm, ↓ 400 Hm (mit Gemsspitz: Gz 6 h / ↑ 1.100 Hm, ↓ 700 Hm) 4. Tag Zunächst steigen wir über die Stafelalp ab, bevor wir über eine steile Passage bergan die Hörnlihütte auf 3.260 m erreichen. Die Hörnlihütte ist der Ausgangspunkt für die Matterhornbesteigungen. Wir gehen bis zum Einstieg des berühmten Hörnligrades, wo sich jeder auf den ersten Metern selbst mal versuchen kann, und beobachten anschließend von der Terrasse der Hörnlihütte die ersten Bergsteiger, die bereits vom Matterhorngipfel zurückkehren. Von der Hörnlihütte steigen wir ab bis zur Bergstation Schwarzsee, von wo uns der Matterhorn Express wieder ins Tal nach Zermatt bringt. In Zermatt Verabschiedung und Heimreise. Gz 7 h / ↑ 1.100 Hm, ↓ 1.200 Hm <h3> </h3>
 region_id10
 services_excluded• Zusatzkosten für Speisen und Getränke außerhalb der Halbpension • Zusatzkosten für Transfers + Lifte während der Tour ca. 50 CHF
 mountain_guide_tour_info
 video_url
 customer_tour_info
 firm_id1
 gmap_zoom13
 gmap_long7.751048
 gmap_marker(true)
 gmap_typeoa_topo
 gmap_lat46.020779
 callout_iconnone
 travel_information<h3>Unterkunftsempfehlung:</h3> Das Hotel Bergfreund ist der Alpine Welten Stützpunkt im Wallis und Ausgangspunkt für alle unsere Touren im Wallis. Wenn Du eine Übernachtungsmöglichkeit vor oder nach der Tour suchst, wende Dich bitte direkt an die Rosi vom Hotel Bergfreund. Sie ist immer hilfsbereit und findet auf jeden Fall ein Quartier für Dich. <h3>Hotel Bergfreund</h3> Fam. Remo Almendinger CH-3927 Herbriggen VS Tel: +41 27 955 23 23 Fax: +41 (0)27 955 23 33 Email: <a href="mailto:info@hotel-bergfreund.ch">info@hotel-bergfreund.ch</a> <a href="http://www.hotel-bergfreund.ch" target="_blank">www.hotel-bergfreund.ch</a>
 meeting_point_map_lat46.134380
 meeting_point_map_marker(true)
 meeting_point_map_typeoa_topo
 meeting_point_map_zoom10
 meeting_point_map_long7.791903
 previous_urlhttp://www.alpinewelten.com/de/gefuehrte-tour/hoehenweg-zermatt/#content_top
 packing_list_text_end<h2>Tipps zur Ausrüstung beim Wandern</h2> Du solltest Deinen Rucksack bereits zu Hause “Probepacken”, um zu sehen, ob alles in den Rucksack passt und wie das Gewicht ist. Gerade bei Mehrtagestouren solltest Du zwingend auf ein minimales Gewicht achten! Hier zählt tatsächlich jedes Gramm, 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. Beim Bargeld solltest Du sowohl € als auch CHF mitnehmen. Die Schweizer Franken kannst Du vorher bei der Bank oder vor Ort in der Schweiz wechseln lassen. Häufige Fragen zur Ausrüstung werden auch hier geklärt. <h2>Unser Shop - Partner</h2> Die Bergfreunde sind der richtige Ansprechpartner wenn es um Bergsport Ausrüstung geht! <figure class="figure-responsive" data-blank="1" data-url="https://www.bergfreunde.de/?pid=15321&wt_mc=de.affiliate.qc.15321.-.-&utm_source=sonstige-affiliates&utm_medium=cpo-variabel&utm_campaign=alpinewelten"> <div class="img-responsive" data-media-id="5141" data-media-thumbnail="ckeditor_md"> </div> <figcaption class="hidden"></figcaption> </figure> <h2> </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_feasibilityhigh
 days_before_start_for_last_notice11
 last_tour_date_number148
 tourstart_weekday8
 mountain_guide_tour_search_information
 customer_tour_material_info
 material_list_link
 callout_icon_multiple(null)
 microsite_id(null)
 is_archive(false)
 is_service(false)
 covid_note(false)
 importancenone
 internal_marknone
 responsible_user_id(null)
 is_service_event(false)
 partner_title
 pay_later_hint(false)
 event_duration
 distance
 ascent
 descent
 destination_menu_id(null)
 gmap46.020779,7.751048
 meeting_point_map46.134380,7.791903
 end_zip3927
 end_cityHerbriggen
 end_streetDorfstrasse 93
 end_countryCH
 price_excl_flight879.00
 highlight0
 TourTexts(array)
 id141
 hash37611dad763833846efe15118f214b41
 created2016-10-25 13:08:12
 updated2024-10-02 16:34:02
 tour_id149
 ws_text_short_descriptionWochenend-Wanderung entlang des Höhenwegs oberhalb von Zermatt mit traumhafter Aussicht auf mehr als 30 Viertausender und das Matterhorn. 
 ws_text_requirementsMittelschwere & Passagen mit schweren Bergwegen ROT & SCHWARZ. Für diese geführte Wanderung auf dem Höhenweg um Zermatt solltest Du als Bergwanderer über eine gute Kondition für Gehzeiten bis 7 Stunden verfügen. Die Aufstiege bei der Hüttenwanderung betragen maximal 1.200 Höhenmeter am Tag. Die durchschnittliche Geschwindigkeit im Aufstieg beträgt beim Wandern ca. 300 Höhenmeter pro Stunde. Du bist bereits erfahrener Bergwanderer und verfügst über Trittsicherheit und Schwindelfreiheit. Ausgesetzte, versicherte oder absturzgefährdete Stellen sind auf der Wanderung im Banne des Matterhorns nicht oder wenige zu erwarten. Die Wegpassagen zur Hörnlihütte sind SCHWARZ. Dieser Teil kann aber ausgelassen werden. <h3>Mäßige Alpine Erfahrung | Einfache alpine Unternehmung</h3> <ul> <li>Geringe Ernsthaftigkeit / Gefährdung</li> <li>Erfahrung Bergwandern</li> <li>Trittsicherheit und Schwindelfreieit</li> </ul> 600m700m1.200 Hm7 hROT - SCHWARZFrühstück 
 ws_text_travel_program<h3>1. Tag: Über den Findelgletscher zur Fluhalp hoch über Zermatt</h3> Treffpunkt im Hotel Bergfreund am Vormittag. Begrüßung und gemeinsame Weiterfahrt mit dem Hotelbus zur Täschalpe. Von hier starten wir mit unserer Wanderung. Begleitet von den Viertausendern Alphubel, Allalin- und Rimpfischhorn geht es südwärts zum Findelgletscher und weiter zum traditionsreichen Fluhalp Berggasthaus, wo wir die Nacht verbringen. Tief unter uns liegt nun das Bergsteigerdorf Zermatt. Von der Terrasse genießen wir die Aussicht auf das Wahrzeichen Zermatts, das Matterhorn, das sich unweit der Hütte im Stellisee wiederspiegelt. 950 Hm550 Hm800m6 hsehr schwerHalbpension <h3>2. Tag: Durch die Gornerschlucht zum Schwarzsee</h3> Nach dem gemütlichen Frühstück machen wir uns an den Abstieg zum Grünsee auf 2.300 m. Von hier führt der Weg eine gute Stunde ansteigend zum Rotenboden. Von hier steigen wir über den Gletschergarten hinab in die Gornerschlucht und weiter zur Station Furri. Nach der wohlverdienten Mittagsrast geht es über Furgg zum Berghotel Schwarzsee, wo wir die Nacht verbringen. 600m700m1.150 Hm6 hsehr schwerHalbpension <h3>3. Tag: Hörnlihütte - Ausgangspunkt für Matterhornbesteigungen</h3> Heute gehen wir auf Tuchfühlung mit dem Matterhorn. Mit einer steilen Passage erreichen wir in zwei Stunden die Hörnlihütte (3.260 m), den Ausgangspunkt für die Matterhornbesteigung. Von der Terrasse schauen wir uns das Treiben am Berg an, bevor wir uns an den Abstieg zur Schönbielhütte machen. Über die Gletschermoräne des Zmuttgletschers erreichen wir die Hütte. Unterwegs beeindruckt noch einmal die Aussicht auf die Matterhorn Nordwand und Dent d ́Hérens. Übernachtung in der Schönbielhütte (2.694 m). 1.200 Hm1.050 Hm800m6 hsehr schwerHalbpension <h3>4. Tag: Abstieg nach Zermatt durch die Triftschlucht</h3> Der letzte Tag unserer Rundtour führt uns über den malerischen Höhenweg zum Berggasthaus Trift (2.337 m). Von hier folgen wir dem Abstieg über die Triftschlucht und den botanischen Garten zum Hotel Edelweiss und weiter nach Zermatt. Verabschiedung und Heimreise. 400 Hm1.200 Hm800m6 hsehr schwerFrühstück
 ws_text_services<ul> <li>Speisen und Getränke außerhalb der Halbpension</li> <li>Individuelle Trinkgelder</li> </ul>
 ws_text_information<h3>Mindestteilnehmerzahl</h3> Diese Reise kann nur ab der oben angegebenen Mindestteilnehmerzahl durchgeführt werden. Sollte diese 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_location_description
 ws_text_accomodationWährend der geführten Wanderung rund um Zermatt sind wir in den folgenden Schweizer Berghütten / Berggasthöfen untergebracht. Die Hütten verfügen über Trocken- und Waschräume sowie über Duschmöglichkeiten. Wir sind im Zimmerlager mit Halbpension untergebracht. <h3>Informationen zur Unterkunft</h3> <ul> <li>Übernachtung in den Hütten mit Halbpension</li> <li>Übernachtung im Mehrbettzimmer / Zimmerlager</li> <li>Berggasthaus Fluhalp / Berghotel Schwarzsee / Schönbielhütte</li> </ul> <ul> </ul> Fragen zur Unterkunft | Wir geben Antworten!
 ws_text_course_content
 ws_text_overview
 ws_text_advantages<ul> <li>NUR 8 Personen pro Gruppe! nicht 10 - 12 Personen</li> <li>4 Tage Wandern rund um Zermatt</li> <li>Atemberaubende Bergkulisse</li> <li>Besuch auf der Hörnlihütte</li> <li>Inkl. Übernachtung/HP</li> </ul>
 ws_text_detail_description_new<h3>Wandern um Zermatt im Banne des Matterhorns</h3> Atemberaubende Landschaften und faszinierende Gletscher begleiten uns auf unser Wanderung hoch über Zermatt, dem wohl berühmtesten Bergsteigerdorf der Schweiz. Begleitet werden wir dabei auf Schritt und Tritt von den mehr als 30 Viertausendern, die sich am Rande unserer Wanderung erheben. Unterwegs streifen wir durch duftende Bergwälder und wandern vorbei an schönen Alpseen, in denen sich die majestätischen Gipfel wiederspiegeln. Höhepunkt ist sicher der Besuch auf der Hörnlihütte, dem Startpunkt für die Besteigung des Matterhorns.
 ws_text_information_new
 ws_text_accomodation_new
 ws_text_arrival
 Route(array)
 id161
 hashf536219f4cf1ca0e69443250f4fd785b
 created2016-08-12 17:20:31
 updated2024-10-02 16:34:01
 modelTour
 foreign_key149
 base/
 aliashoehenweg-zermatt
 controllerFrontendTours.FrontendTours
 actiontour
 parent_id(null)
 lft2895
 rght2896
 route/hoehenweg-zermatt
 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)
 id37346
 tour_id149
 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)
 id11156
 hashbd85846621f50665be92b0dafd4dca33
 created2021-11-22 16:45:26
 updated2021-11-22 16:45:26
 titleFreude beim Wandern mit Blick aufs Matterhorn
 cross_reference_count3
 MediaEntity(array)
 id609646
 pos1
 media_id11156
 modelTour
 fieldteaser_image
 foreign_key149
 FileUpload(array)
 0(array)
 id596606
 hash3fe259c72c1ceedeffb46035a64bf6d5
 created2021-11-22 16:45:12
 updated2021-11-22 16:45:26
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/619bbb16440e6.jpg
 size278842
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id817244
 hashae8173d5d5b45fcfd3fa981960f49270
 created2024-10-02 16:33:58
 updated2024-10-02 16:33:58
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-thtourteaserimage.jpg
 thumbnailth-tour-teaser-image
 parent_id596606
 filewebroot/files/Media/File/ThTourTeaserImage/66fd59d6a2754.jpg
 size67168
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id817245
 hashad6bbed7f98dc54e8d42ee370ac7fb37
 created2024-10-02 16:33:58
 updated2024-10-02 16:33:58
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-thtourteaserimagedesaturated.jpg
 thumbnailth-tour-teaser-image-desaturated
 parent_id596606
 filewebroot/files/Media/File/ThTourTeaserImageDesaturated/66fd59d6bba8d.jpg
 size60909
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 3(array)
 id817246
 hash99f385edb5f46b2f7890f46eb0d32a86
 created2024-10-02 16:33:58
 updated2024-10-02 16:33:58
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-thtourteaserimagefullscreen.jpg
 thumbnailth-tour-teaser-image-fullscreen
 parent_id596606
 filewebroot/files/Media/File/ThTourTeaserImageFullscreen/66fd59d6cd748.jpg
 size311883
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 4(array)
 id817247
 hashda0f7ffccd9a1549b408eb2ebd5f8d5f
 created2024-10-02 16:33:59
 updated2024-10-02 16:33:59
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id596606
 filewebroot/files/Media/File/ThTourHeaderImage/66fd59d7069a4.jpg
 size90433
 ext.jpg
 mimeimage/jpeg
 width750
 height560
 5(array)
 id596607
 hash882671da22f4618d6b3b0d89c522af8c
 created2021-11-22 16:45:26
 updated2021-11-22 16:45:26
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id596606
 filewebroot/files/Media/File/ThMediaFileIndex/619bbb164535e.jpg
 size14017
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 6(array)
 id596608
 hashd7330cc863aff72f7c8ae2d8f08fe5a4
 created2021-11-22 16:45:26
 updated2021-11-22 16:45:26
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id596606
 filewebroot/files/Media/File/CkeditorXs/619bbb1670592.jpg
 size4363
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 7(array)
 id596609
 hashe887317688fe2ce1c6b06597d90e4e25
 created2021-11-22 16:45:26
 updated2021-11-22 16:45:26
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id596606
 filewebroot/files/Media/File/CkeditorSm/619bbb16a9ec0.jpg
 size14017
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 8(array)
 id596610
 hash614d8672ec356a1b0c823c10ae538f5c
 created2021-11-22 16:45:26
 updated2021-11-22 16:45:26
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id596606
 filewebroot/files/Media/File/CkeditorMd/619bbb16cdcfe.jpg
 size22214
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 9(array)
 id596611
 hashf6aa70ca5c31ba543b6cbc1a84fe36be
 created2021-11-22 16:45:27
 updated2021-11-22 16:45:27
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id596606
 filewebroot/files/Media/File/CkeditorLg/619bbb16eb210.jpg
 size48200
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 10(array)
 id817291
 hash22b7ae31d9359975ed22eeaf8b8493fa
 created2024-10-02 16:34:02
 updated2024-10-02 16:34:02
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-thseoimagefacebook.png
 thumbnailth-seo-image-facebook
 parent_id596606
 filewebroot/files/Media/File/ThSeoImageFacebook/66fd59da0f729.png
 size479012
 ext.png
 mimeimage/png
 width720
 height405
 11(array)
 id817292
 hash08eadbb5f352a1b45c5f6bbb90f0c2da
 created2024-10-02 16:34:02
 updated2024-10-02 16:34:02
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-thseoimagegoogle.png
 thumbnailth-seo-image-google
 parent_id596606
 filewebroot/files/Media/File/ThSeoImageGoogle/66fd59da3826a.png
 size479012
 ext.png
 mimeimage/png
 width720
 height405
 12(array)
 id817293
 hashe542dc1e67c2345ad2daa33f424016dc
 created2024-10-02 16:34:02
 updated2024-10-02 16:34:02
 modelMedia
 fieldfile
 foreign_key11156
 aliasfreude-beim-wandern-mit-blick-aufs-matterhorn-thseoimagetwitter.png
 thumbnailth-seo-image-twitter
 parent_id596606
 filewebroot/files/Media/File/ThSeoImageTwitter/66fd59da5fd9a.png
 size141896
 ext.png
 mimeimage/png
 width375
 height210
- 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-schwarzsee-zermatt
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/hotel-schwarzsee-zermatt
Remote Port	46978
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.142.119.8
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	fikker-61vm-nk2N=MgPGRI6oXLV7DSLWJk4y6wNi63F1ZE0E; fly_device=desktop; fly_ab_uid=3678bffa-11f9-46c5-989b-3a4b1a48b9cd; fikker-wMW4-9jON=gJAjALadsjih547R14QlSN9xQBOVq4Cr; fly_geo={"countryCode":"us","region":"oh","dma":"535"}
Http Accept Encoding	gzip, br, zstd, deflate
Http Referer	https://alpinewelten.com/hotel-schwarzsee-zermatt
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.142.119.8
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-schwarzsee-zermatt
Script Url	/hotel-schwarzsee-zermatt
Unique Id	ZyQos0B-RyW6I4O7xL0pMAAAAcI
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-schwarzsee-zermatt
Redirect Script Url	/hotel-schwarzsee-zermatt
Redirect Unique Id	ZyQos0B-RyW6I4O7xL0pMAAAAcI
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-schwarzsee-zermatt
Redirect Redirect Script Url	/hotel-schwarzsee-zermatt
Redirect Redirect Unique Id	ZyQos0B-RyW6I4O7xL0pMAAAAcI
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1730422963.5437
Request Time	1730422963

====

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 Schwarzsee Zermatt Wallis, 2.583 m Hotel am Fuße des Matterhorns

Öffnungszeiten

Ausstattung

Währung & Bezahlung

Standort der Unterkunft

Reisen mit der Unterkunft Hotel Schwarzsee Zermatt 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 Schwarzsee Zermatt
Wallis, 2.583 m
Hotel am Fuße des Matterhorns

Total Time: 19 ms
Total Queries: 142 queries