Aktualisiert: 21.12.2021

Autor: Hans Honold

Bergsport & Corona Russische Föderation

Aktualisierte Informationen

Werden Reisen nach Russland durchgeführt: Ja, seit 12. Mai

Gibt es Sonderregelungen im Reisevertrag: Ja

Zahlung erst 3 Tage vorher bei sicherer Durchführung
Die Teilnahme ist derzeit nur für Geimpfte und Genesene möglich (2-G Regel)

Hinweise zur Ein- und Ausreise

Deutsche Reisende

Reisewarnung: Ja (Link)

Einstufung: Hochrisikogebiet (RKI)

EINREISE INS REISELAND

Einreiseformular: Ja (Link)

Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Gültigkeit Impfzertifikat: Ab 01.02.22 sind EU Covid Impfzertifikate ohne Boosterimpfung nur noch 9 Monate gültig.

Genesene: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Nicht Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Quarantäne bei Einreise: Nein

RÜCKREISE NACH DEUTSCHLAND

Einreiseformular: Ja (Link)

Geimpfte: Test / Quarantänebefreiung

Genesene: Test / Quarantänebefreiung mit Nachweis (6 Monate)

Nicht Geimpfte: AntigenSchnelltest (48h) / PCR Test (72h)

Quarantäne bei Rückreise: Ja, für Nicht Geimpfte 5 Tage + Test

flaggenset-rund-0000s-0028-österreich.png

Österreichische Reisende

Reisewarnung: Nein (Link)

Einstufung: Sonstiger Staat (Link)

EINREISE INS REISELAND

Einreiseformular: Ja (Link)

Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Gültigkeit Impfzertifikat: Ab 01.02.22 sind EU Covid Impfzertifikate ohne Boosterimpfung nur noch 9 Monate gültig.

Genesene: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Nicht Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Quarantäne bei Einreise: Nein

RÜCKREISE NACH ÖSTERREICH

Einreiseformular: Nein = Mit Booster Impfung oder PCR Test (72h) Ja = ohne Booster Impfung oder PCR Test. - Der Test kann auch in Österreich nach Rückreise durchgeführt werden. Bis zum Ergebnis besteht Quarantänepflicht. (Link)

Geimpfte: PCR Test (72h) | Test- und Quarantänebefreiung mit Boosterimpfung

Genesene: PCR Test (72h) | Quarantänebefreiung mit Nachweis

Nicht Geimpfte: Quarantänebefreiung mit PCR Test (72h)

Quarantäne bei Rückreise: Ja für Nicht Geimpfte 10 Tage

Schweizer Reisende

Reisewarnung: Nein (Link)

Einstufung: Keine

EINREISE INS REISELAND

Einreiseformular: Ja (Link)

Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Gültigkeit Impfzertifikat: 365 Tage ab Verabreichung der letzten Impfdosis
(Ausnahme Impfstoff Janssen (Link))

Genesene: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Nicht Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise

Quarantäne bei Einreise: Nein

RÜCKREISE IN DIE SCHWEIZ

Einreiseformular: Ja (Link)

Geimpfte: PCR Test (72h)

Genesene: PCR Test (72h)

Nicht Geimpfte: PCR Test (72h) | Erneuter PCR- oder Antigentest 4 -7 Tage nach Rückkehr | Meldepflicht Kanton

Quarantäne bei Rückreise: Entfällt

(Veröffentlicht: 05.08.2020)

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)
  userAgent702e6d7fd00a6f14bcc094a4c956d69f
  time1643278676
  countdown10
- _Token(array)
  key5158d8aa3b8044bf119a2667c55c3df1466fc7ccacad64d2c5c1768070f2538c04bc849ed13d4f3bd5312f902d5bb85a2a464d76ec2df15bef56300346c46c34
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  5158d8aa3b8044bf119a2667c55c3df1466fc7ccacad64d2c5c1768070f2538c04bc849ed13d4f3bd5312f902d5bb85a2a464d76ec2df15bef56300346c46c341643266076
====
Request
+
Request

Cake Params
- pluginFrontendNews
- controllerFrontendNews
- actionnews
- named(empty)
- pass(array)
  068
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  News68
- route(array)
  id4910
  hash0354768d3d91213d5c994895bb664420
  created2020-10-20 09:50:11
  updated2021-12-22 13:30:03
  modelNews
  foreign_key68
  base/
  aliasrussland-bergsport-corona
  controllerFrontendNews.FrontendNews
  actionnews
  parent_id(null)
  lft5939
  rght5940
  route/russland-bergsport-corona
- isAjax(false)
- _Token(array)
  key5158d8aa3b8044bf119a2667c55c3df1466fc7ccacad64d2c5c1768070f2538c04bc849ed13d4f3bd5312f902d5bb85a2a464d76ec2df15bef56300346c46c34
  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: 20 ms
Total Queries: 114 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`))) = '/russland-bergsport-corona' LIMIT 1	1	1	3	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 5939 AND `Route`.`rght` >= 5940 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`	46	46	0
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `alpinewelten`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 6, 7, 8, 9, 11, 12, 14, 15, 16, 17, 18, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57) 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.bergsteigerschule-watzmann.de' 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` = 'wf' 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`, `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` > 421 AND `Menu`.`rght` < 422 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 `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 `News`.`id`, `News`.`hash`, `News`.`created`, `News`.`updated`, `News`.`title`, `News`.`status`, `News`.`type`, `News`.`release`, `News`.`hide`, `News`.`publishing_date`, `News`.`customer_status`, `News`.`visibility_website`, `News`.`visibility_customer`, `News`.`visibility_mountainguide`, `News`.`mountain_guide_type`, `News`.`target`, `News`.`external_url`, `News`.`menu_id`, `News`.`alias`, `News`.`mountain_guide_qualification_category`, `News`.`safety`, `News`.`travel_warning`, `News`.`is_updated`, `News`.`user_id`, (NOW() BETWEEN COALESCE(`News`.`release`, NOW()) AND COALESCE(`News`.`hide`, NOW())) AS `News__published`, `User`.`id`, `User`.`hash`, `User`.`created`, `User`.`updated`, `User`.`activity`, `User`.`group_id`, `User`.`status`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`lastname`, `User`.`email`, `User`.`limit`, `User`.`language`, `User`.`email_signature`, `User`.`telephone`, `User`.`dept_for_trigger_mail`, `User`.`expert_text`, `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`internal_keywords`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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`, `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`.`news` AS `News` LEFT JOIN `alpinewelten`.`users` AS `User` ON (`News`.`user_id` = `User`.`id`) LEFT JOIN `alpinewelten`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `News`.`id` AND `Seo`.`model` = 'News') LEFT JOIN `alpinewelten`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `News`.`id` AND `Teaser`.`model` = 'News') LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `News`.`id` AND `Route`.`model` = 'News') WHERE `News`.`id` = 68 AND `News`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`News`.`release`, NOW()) AND COALESCE(`News`.`hide`, NOW())) = '1' AND NOT (`News`.`type` = 'no_details') AND `News`.`visibility_website` ORDER BY `News`.`publishing_date` DESC LIMIT 1	1	1	4	maybe slow
SELECT `AvatarWebsiteUpload`.`id`, `AvatarWebsiteUpload`.`hash`, `AvatarWebsiteUpload`.`created`, `AvatarWebsiteUpload`.`updated`, `AvatarWebsiteUpload`.`model`, `AvatarWebsiteUpload`.`field`, `AvatarWebsiteUpload`.`foreign_key`, `AvatarWebsiteUpload`.`alias`, `AvatarWebsiteUpload`.`thumbnail`, `AvatarWebsiteUpload`.`parent_id`, `AvatarWebsiteUpload`.`file`, `AvatarWebsiteUpload`.`size`, `AvatarWebsiteUpload`.`ext`, `AvatarWebsiteUpload`.`mime`, `AvatarWebsiteUpload`.`width`, `AvatarWebsiteUpload`.`height` FROM `alpinewelten`.`uploads` AS `AvatarWebsiteUpload` WHERE `AvatarWebsiteUpload`.`model` = 'User' AND `AvatarWebsiteUpload`.`field` = 'avatar_website' AND `AvatarWebsiteUpload`.`foreign_key` = (25) ORDER BY FIELD(COALESCE(`AvatarWebsiteUpload`.`thumbnail`, -1), -1) DESC	2	2	0
SELECT `Audit`.`id`, `Audit`.`event`, `Audit`.`model`, `Audit`.`alias`, `Audit`.`entity_id`, `Audit`.`json_object`, `Audit`.`description`, `Audit`.`source_id`, `Audit`.`created` FROM `alpinewelten`.`audits` AS `Audit` WHERE `model` = 'News.News' AND `Audit`.`event` = 'CREATE' AND `Audit`.`entity_id` = (68)	1	1	1
SELECT `User`.`id`, `User`.`hash`, `User`.`created`, `User`.`updated`, `User`.`activity`, `User`.`group_id`, `User`.`status`, `User`.`username`, `User`.`password`, `User`.`name`, `User`.`lastname`, `User`.`email`, `User`.`limit`, `User`.`language`, `User`.`email_signature`, `User`.`telephone`, `User`.`dept_for_trigger_mail`, `User`.`expert_text` FROM `alpinewelten`.`users` AS `User` WHERE `User`.`id` = 25	1	1	0
SELECT `FileMedia`.`id`, `FileMedia`.`hash`, `FileMedia`.`created`, `FileMedia`.`updated`, `FileMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `FileMedia`.`id`) AS `FileMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `FileMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 68 AND `MediaEntity`.`media_id` = `FileMedia`.`id`) WHERE `MediaEntity`.`model` = 'News' AND `MediaEntity`.`field` = 'file' ORDER BY `MediaEntity`.`pos` ASC	0	0	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` = 68 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'News' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `OutputChannel`.`id`, `OutputChannel`.`hash`, `OutputChannel`.`created`, `OutputChannel`.`updated`, `OutputChannel`.`title`, `OutputChannel`.`abbreviation`, `OutputChannel`.`oa_offerer_id`, `FirmsNews`.`id`, `FirmsNews`.`firm_id`, `FirmsNews`.`news_id`, `FirmsNews`.`position` FROM `alpinewelten`.`firms` AS `OutputChannel` JOIN `alpinewelten`.`firms_news` AS `FirmsNews` ON (`FirmsNews`.`news_id` = 68 AND `FirmsNews`.`firm_id` = `OutputChannel`.`id`) ORDER BY `FirmsNews`.`position` ASC	1	1	1
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`, (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`, (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`, (`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`, `NewsTour`.`id`, `NewsTour`.`news_id`, `NewsTour`.`tour_id`, `NewsTour`.`position` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`news_tours` AS `NewsTour` ON (`NewsTour`.`news_id` = 68 AND `NewsTour`.`tour_id` = `Tour`.`id`) ORDER BY `NewsTour`.`position` ASC	0	0	1	maybe slow
SELECT `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`, `CountriesNews`.`id`, `CountriesNews`.`news_id`, `CountriesNews`.`country_id`, `CountriesNews`.`position` FROM `alpinewelten`.`countries` AS `Country` JOIN `alpinewelten`.`countries_news` AS `CountriesNews` ON (`CountriesNews`.`news_id` = 68 AND `CountriesNews`.`country_id` = `Country`.`id`) ORDER BY `CountriesNews`.`position` ASC	1	1	1
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 174 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` = (174) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TourMainType`.`id`, `TourMainType`.`hash`, `TourMainType`.`created`, `TourMainType`.`updated`, `TourMainType`.`title`, `TourMainType`.`position`, `TourMainType`.`packing_list_text_start`, `TourMainType`.`packing_list_text_end`, `NewsTourMainType`.`id`, `NewsTourMainType`.`news_id`, `NewsTourMainType`.`tour_main_type_id`, `NewsTourMainType`.`position` FROM `alpinewelten`.`tour_main_types` AS `TourMainType` JOIN `alpinewelten`.`news_tour_main_types` AS `NewsTourMainType` ON (`NewsTourMainType`.`news_id` = 68 AND `NewsTourMainType`.`tour_main_type_id` = `TourMainType`.`id`) ORDER BY `NewsTourMainType`.`position` ASC	0	0	0
SELECT `NewsContent`.`id`, `NewsContent`.`hash`, `NewsContent`.`created`, `NewsContent`.`updated`, `NewsContent`.`title`, `NewsContent`.`news_id`, `NewsContent`.`status`, `NewsContent`.`type`, `NewsContent`.`article_content`, `NewsContent`.`video_type`, `NewsContent`.`video_url`, `NewsContent`.`position`, `NewsContent`.`developer_template_code`, `NewsContent`.`developer_template_css`, `NewsContent`.`developer_template_js`, `NewsContent`.`layout`, `NewsContent`.`mosaic_gallery_type` FROM `alpinewelten`.`news_contents` AS `NewsContent` WHERE `NewsContent`.`news_id` = 68 AND `NewsContent`.`status` = 'active' ORDER BY `position` ASC	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` IN (57, 155, 156, 157, 200) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'NewsContent' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `GalleryMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (57, 155, 156, 157, 200) AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'NewsContent' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MosaicGalleryMedia`.`id`, `MosaicGalleryMedia`.`hash`, `MosaicGalleryMedia`.`created`, `MosaicGalleryMedia`.`updated`, `MosaicGalleryMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `MosaicGalleryMedia`.`id`) AS `MosaicGalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `MosaicGalleryMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (57, 155, 156, 157, 200) AND `MediaEntity`.`media_id` = `MosaicGalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'NewsContent' AND `MediaEntity`.`field` = 'mosaic_gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
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 `Language`.`firm_id` = 1 LIMIT 1	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Language`.`id`, `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 `Language`.`firm_id` = 3 LIMIT 1	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `alpinewelten`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (3) ORDER BY FIELD(COALESCE(`FlagUpload`.`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` = 'footer' AND `Language`.`langid` = 'wf' 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`, `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` > 474 AND `Menu`.`rght` < 519 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	22	22	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 (705, 338, 195, 709, 696, 194, 327, 326, 532, 554, 686, 687, 707, 689, 337, 351, 544, 545, 685, 688, 697, 698) 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` = 'footer_more' AND `Language`.`langid` = 'wf' 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`, `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` > 520 AND `Menu`.`rght` < 533 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 (354, 356, 570, 355, 199, 357) 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` = 'wf' 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`, `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	3	3	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) 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` = 'News' AND `Seo`.`foreign_key` = 68 LIMIT 1	1	1	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 4782 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	1
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (7227) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	11	11	1	maybe slow
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` = 'wf' 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`, `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` 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` = 184 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` = 976 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` = (3735) 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` = 621 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` = (184) ORDER BY FIELD(COALESCE(`IconUpload`.`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` = 184 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` = 184 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` = 'wf' 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`, `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` 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` = 740 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` = 5141 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` = 3879 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` = (740) ORDER BY FIELD(COALESCE(`IconUpload`.`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` = 740 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` = 740 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` = 'wf' 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`, `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` > 420 AND `Menu`.`rght` < 425 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	2	2	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 (712, 684) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	2	2	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` = 'wf' 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`, `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` 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` > 426 AND `Menu`.`rght` < 473 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	23	23	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 (201, 203, 634, 339, 204, 340, 341, 202, 342, 343, 344, 345, 346, 347, 348, 536, 738, 542, 543, 736, 325, 353, 476) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	20	20	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`, (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`, (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`, (`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` = 3 ORDER BY `position` ASC	4	4	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` = 330 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` = 330 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` = (9376) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	17	17	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` = 281 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` = 281 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` = (256) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	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` = 401 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` = 401 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 402 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` = 402 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` = (468) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	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	524	524	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` 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` = 'wf' LIMIT 1	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` = 'wf' 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`, `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` 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 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 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` = 'wf' 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`, `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` 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` = 185 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` = 977 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` = 622 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` = (185) ORDER BY FIELD(COALESCE(`IconUpload`.`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` = 185 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` = 185 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` = 'wf' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'news' LIMIT 1	1	1	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `alpinewelten`.`media` AS `Media` WHERE `Media`.`id` = 9123 LIMIT 1	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` = (9123) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	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` = 9123 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `alpinewelten`.`media` AS `Media` WHERE `Media`.`id` = 9124 LIMIT 1	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` = (9124) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	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` = 9124 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `alpinewelten`.`media` AS `Media` WHERE `Media`.`id` = 9121 LIMIT 1	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` = (9121) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	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` = 9121 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	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` = 'wf' 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` = 'wf' 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` = 'wf' 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` = 'wf' 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 17.33 MB

Message	Memory use
Component initialization	2.16 MB
Controller action start	3.17 MB
Controller render start	6.69 MB
View render complete	9.32 MB

Timers

Total Request Time: 632 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	102.78
Event: Controller.initialize	29.66
Event: Controller.startup	3.84
Controller action	147.09
Event: Controller.beforeRender	102.00
» Processing toolbar data	55.89
Rendering View	146.49
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendNews/View/FrontendNews/news.php	11.57
» » Rendering APP/Plugin/FrontendNews/View/Elements/breadcrumb.php	1.13
» » Rendering APP/Plugin/FrontendContents/View/Elements/author.php	1.19
» » Rendering APP/View/Elements/icon.php	0.25
» Event: View.afterRender	0.46
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/3.php	131.70
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.77
» » Rendering APP/View/Elements/header/header.php	45.07
» » » Rendering APP/View/Elements/header/header_navbar.php	44.52
» » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php	0.25
» » » » Rendering APP/View/Elements/navigation_secondary.php	22.82
» » » » » Rendering APP/View/Elements/icon.php #2	10.00
» » » » » Rendering APP/View/Elements/icon.php #3	0.59
» » » » » Rendering APP/View/Elements/icon.php #4	0.59
» » » » » Rendering APP/View/Elements/icon.php #5	9.35
» » » » Rendering APP/View/Elements/navigation.php	19.38
» » » » » Rendering APP/View/Elements/icon.php #6	0.57
» » » » » Rendering APP/View/Elements/icon.php #7	0.54
» » » » » Rendering APP/View/Elements/icon.php #8	0.49
» » » » » Rendering APP/View/Elements/icon.php #9	0.50
» » » » » Rendering APP/View/Elements/icon.php #10	0.55
» » » » » Rendering APP/View/Elements/icon.php #11	0.54
» » » » » Rendering APP/View/Elements/icon.php #12	0.38
» » » » » Rendering APP/View/Elements/icon.php #13	0.50
» » » » » Rendering APP/View/Elements/icon.php #14	0.49
» » » » » Rendering APP/View/Elements/icon.php #15	0.54
» » » » » Rendering APP/View/Elements/icon.php #16	0.50
» » » » » Rendering APP/View/Elements/icon.php #17	0.36
» » » » » Rendering APP/View/Elements/icon.php #18	0.53
» » » » » Rendering APP/View/Elements/icon.php #19	0.50
» » » » » Rendering APP/View/Elements/icon.php #20	0.50
» » » » » Rendering APP/View/Elements/icon.php #21	0.53
» » » » » Rendering APP/View/Elements/icon.php #22	0.52
» » » » » Rendering APP/View/Elements/icon.php #23	0.53
» » » » » Rendering APP/View/Elements/icon.php #24	0.54
» » » » » Rendering APP/View/Elements/icon.php #25	0.50
» » » » » Rendering APP/View/Elements/icon.php #26	0.50
» » » » » Rendering APP/View/Elements/icon.php #27	0.50
» » » » » Rendering APP/View/Elements/icon.php #28	0.40
» » Rendering APP/Plugin/FrontendNews/View/Elements/breadcrumb.php #2	0.89
» » Rendering APP/View/Elements/footer/footer.php	31.81
» » » Rendering APP/View/Elements/icon.php #29	9.21
» » » Rendering APP/View/Elements/icon.php #30	9.21
» » » Rendering APP/View/Elements/logos/logo-instagram.php	0.30
» » » Rendering APP/View/Elements/logos/logo-youtube.php	0.24
» » » Rendering APP/View/Elements/logos/logo-facebook.php	0.27
» » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.23
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php	0.27
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php #2	0.23
» » » Rendering APP/View/Elements/footer/footer_newsletter_subscribe.php	0.27
» » » Rendering APP/View/Elements/logos/logo-adidas-terrex.php	0.29
» » » Rendering APP/View/Elements/logos/logo-adidas-eyewear.php	0.24
» » » Rendering APP/View/Elements/logos/logo-petzl.php	0.27
» » » Rendering APP/View/Elements/logos/logo-pieps.php	0.23
» » » Rendering APP/View/Elements/logos/logo-kaestle.php	0.24
» » » Rendering APP/View/Elements/logos/logo-diamir.php	0.23
» » » Rendering APP/View/Elements/logos/logo-komperdell.php	0.25
» » » Rendering APP/View/Elements/logos/logo-scarpa.php	0.24
» » » Rendering APP/View/Elements/logos/logo-exped.php	0.24
» » » Rendering APP/View/Elements/logos/logo-abs.php	0.22
» » » Rendering APP/View/Elements/logos/logo-hilleberg.php	0.25
» » Rendering APP/View/Elements/contact_widget.php	49.29
» » » Rendering APP/View/Elements/icon.php #31	9.25
» » » Rendering APP/View/Elements/icon.php #32	9.25
» » » Rendering APP/View/Elements/icon.php #33	9.77
» » » Rendering APP/View/Elements/icon.php #34	9.49
» » » Rendering APP/View/Elements/icon.php #35	9.49
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- canonicalUrlhttps://www.alpinewelten.com/russland-bergsport-corona
- news(array)
 News(array)
 id68
 hash7359238b638529c1f159cc4952555920
 created2020-10-20 09:50:11
 updated2021-12-22 13:30:03
 titleRussland | Bergsport & Corona
 statusactive
 typecontent
 release(null)
 hide(null)
 publishing_date2021-12-21
 customer_status(null)
 visibility_website1
 visibility_customer0
 visibility_mountainguide0
 mountain_guide_type(null)
 target(null)
 external_url(null)
 menu_id(null)
 alias
 mountain_guide_qualification_category(null)
 safety(true)
 travel_warning(true)
 is_updated(true)
 user_id25
 published1
 User(array)
 id25
 hash9be0db7689deeaef13ed068fb81e9d54
 created2015-10-22 07:32:49
 updated2021-06-12 01:43:06
 activity2022-01-26 15:25:01
 group_id3
 statusactive
 username080573-H-51510
 passwordbbfcd1b3a8b9ab1238d0bb9c0ba97b67
 nameHans
 lastnameHonold
 emailhanshonold@alpinewelten.com
 limit100
 languagede
 email_signatureHans Honold | staatl. gepr. Berg- und Skiführer
 telephone+49(0)7344 929 144-1
 dept_for_trigger_mail0
 expert_textGeschäftsführer | Bergführer Expeditionen, Polarforschung und Bergsteigen weltweit!
 AvatarWebsiteUpload(array)
 0(array)
 id500132
 hash51cc28e1bfe6258422f2c9cf4b038d13
 created2020-11-05 16:50:42
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/User/AvatarWebsite/5fa41f561ea66.jpg
 size104668
 ext.jpg
 mimeimage/jpeg
 width500
 height500
 1(array)
 id500133
 hash7a1e9d03084551e33967a67d2316ac17
 created2020-11-05 16:50:46
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1-thuseravatarwebsite.jpg
 thumbnailth-user-avatar-website
 parent_id500132
 filewebroot/files/User/AvatarWebsite/ThUserAvatarWebsite/5fa41f5620300.jpg
 size100367
 ext.jpg
 mimeimage/jpeg
 width300
 height300
 Seo(array)
 id4782
 hash872675865d0324c424f27f7cbaedca0b
 created2020-10-20 09:50:11
 updated2021-12-22 13:30:04
 modelNews
 foreign_key68
 titleRussland | Bergsport & Corona
 descriptionAllgemeine Hinweise zum Bergsport in Coronazeiten in Russland
 internal_keywords
 author
 tw_creator
 fb_author
 robots3
 sitemap_priority0.5
 Teaser(array)
 id3523
 hash9cf0818c2e1410671e9ee4b3c4867331
 created2020-10-20 09:50:11
 updated2021-12-22 13:30:03
 modelNews
 foreign_key68
 typedefault
 titleRussland | Bergsport & Corona
 contentAllgemeine Covid-19 Hinweise zur Reiseplanung für Russland
 buttonHier erfährst du mehr
 teaser_id(null)
 layoutcol12
 Route(array)
 id4910
 hash0354768d3d91213d5c994895bb664420
 created2020-10-20 09:50:11
 updated2021-12-22 13:30:03
 modelNews
 foreign_key68
 base/
 aliasrussland-bergsport-corona
 controllerFrontendNews.FrontendNews
 actionnews
 parent_id(null)
 lft5939
 rght5940
 route/russland-bergsport-corona
 Audit(array)
 0(array)
 id5f8e96b3-a444-4fa5-968d-139055ec31aa
 eventCREATE
 modelNews.News
 aliasNews
 entity_id68
 json_object{"News":{"id":"68","hash":"7359238b638529c1f159cc4952555920","created":"2020-10-20 09:50:11","updated":"2020-10-20 09:50:11","title":"Russland | Corona & Bergsport","status":"active","type":"no_details","release":null,"hide":null,"publishing_date":"2020-10-20","customer_status":null,"visibility_website":"1","visibility_customer":"0","visibility_mountainguide":"0","mountain_guide_type":null,"target":null,"external_url":null,"menu_id":null,"alias":"","mountain_guide_qualification_category":null,"safety":true,"travel_warning":true,"is_updated":true}}
 description(null)
 source_id25
 created2020-10-20 09:50:11
 User(array)
 id25
 hash9be0db7689deeaef13ed068fb81e9d54
 created2015-10-22 07:32:49
 updated2021-06-12 01:43:06
 activity2022-01-26 15:25:01
 group_id3
 statusactive
 username080573-H-51510
 passwordbbfcd1b3a8b9ab1238d0bb9c0ba97b67
 nameHans
 lastnameHonold
 emailhanshonold@alpinewelten.com
 limit100
 languagede
 email_signatureHans Honold | staatl. gepr. Berg- und Skiführer
 telephone+49(0)7344 929 144-1
 dept_for_trigger_mail0
 expert_textGeschäftsführer | Bergführer Expeditionen, Polarforschung und Bergsteigen weltweit!
 AvatarWebsiteUpload(array)
 0(array)
 id500132
 hash51cc28e1bfe6258422f2c9cf4b038d13
 created2020-11-05 16:50:42
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/User/AvatarWebsite/5fa41f561ea66.jpg
 size104668
 ext.jpg
 mimeimage/jpeg
 width500
 height500
 1(array)
 id500133
 hash7a1e9d03084551e33967a67d2316ac17
 created2020-11-05 16:50:46
 updated2020-11-05 16:50:46
 modelUser
 fieldavatar_website
 foreign_key25
 aliashans-honold-avatar-polar-1-thuseravatarwebsite.jpg
 thumbnailth-user-avatar-website
 parent_id500132
 filewebroot/files/User/AvatarWebsite/ThUserAvatarWebsite/5fa41f5620300.jpg
 size100367
 ext.jpg
 mimeimage/jpeg
 width300
 height300
 FileMedia(empty)
 TagsTag(array)
 0(array)
 id1087
 hasha9e7a4b7f9df2a9e3078ca180a0393c8
 created2020-03-04 14:58:40
 updated2020-03-04 14:58:40
 titlecorona
 scope(null)
 cross_reference_count123
 TagEntity(array)
 id33177
 tag_id1087
 modelNews
 fieldtags
 foreign_key68
 OutputChannel(array)
 0(array)
 id1
 hash13d55677848396f63db6eeef9176c60b
 created2016-06-01 17:31:42
 updated2020-11-11 11:34:21
 titleAlpine Welten
 abbreviationAW
 oa_offerer_id8650995
 FirmsNews(array)
 id1438
 firm_id1
 news_id68
 position1
 Tour(empty)
 Country(array)
 0(array)
 id174
 hashdebe8f319c3197977a4f4fcd7ee50cc0
 created2016-06-01 17:35:19
 updated2021-11-17 10:31:11
 titleRussische Föderation | Russland
 abbreviationRU
 subtitleUnterwegs im größten Land der Welt
 link_embassy_germanhttps://www.auswaertiges-amt.de/de/aussenpolitik/laender/russischefoederation-node/russischefoederationsicherheit/201536
 link_embassy_austrianhttps://www.bmeia.gv.at/reise-aufenthalt/reiseinformation/land/russische-foederation/
 link_embassy_swisshttps://www.eda.admin.ch/eda/de/home/vertretungen-und-reisehinweise/russland.html
 link_embassy_italianhttp://www.viaggiaresicuri.mae.aci.it/country/RUS
 best_travel_season3576
 generalStand: 12.08.2020 <h2 style="text-align:center">Allgemeines</h2> Mit gut 17 Millionen Quadratkilometern (!) ist die Russische Föderation das größte Land der Erde. Russland liegt zum Teil in Osteuropa, zu Dreiviertel des Landes aber im Norden Asiens. Es grenzt an 14 Staaten und 5 Meere. Der gesamte Norden grenzt an den Arktischen Ozean. Durch die Beringstraße ist Russland im äußersten Osten nur ca. 85 km von Alaska getrennt. Von West nach Ost misst Russland eine beachtliche Breite von 9.000 km und verläuft über 40 Breitengrade sowie durch 11 Zeitzonen! Auch von Nord nach Süd hat Russland eine Länge bis 4.000 km. Obwohl etwa 145 Millionen Menschen in Russland leben, gehört es im Verhältnis zu seiner Fläche zu einem der am dünnsten besiedelten Länder. Dreiviertel der russischen Bevölkerung lebt dabei im europäischen Teil westlich des Ural Gebirges. Die Hauptstadt der Russischen Föderation und damit kulturelles, wirtschaftliches und politisches Zentrum des Landes ist Moskau, mit gut 12 Millionen Einwohnern die größte Stadt Europas. Der Nationalfeiertag ist am 12. Juni, wird aber weitaus weniger gefeiert wie der Tag des Sieges am 09. Mai, der auf die Kapitulation der Deutschen Wehrmacht am Ende des 2. Weltkriegs zurückzuführen ist. Russland ist ein Vielvölkerstaat mit verschiedenen Ethnien, Kulturen und Traditionen. Nach dem Zerfall der Sowjetunion kehrten auch die Religionen zurück. Hauptsächlich ist der russich-orthodoxe Glaube in Russland verbreitet. Die Landessprache der Russischen Föderation ist Russisch und wird überall gesprochen. Es gilt das kyrillische Alphabet. Zahlreiche Volkssprachen gelten als zweite Amtssprache in der jeweiligen Region. Inzwischen wird an den Schulen auch Englisch unterrichtet, was jedoch nicht bedeutet, dass es überall gesprochen wird. Im Gegenteil - sprachliche Barrieren sind vor allem in den ländlichen und abgelegenen Gebieten vorhanden und erschweren das Reisen auf eigene Faust. <h3 style="text-align:center">Währung & Bezahlung</h3> Die russische Landeswährung ist der Rubel (RUB). Mit Euro kann nicht bezahlt werden. An vielen Orten ist inzwischen das Abheben von Bargeld in Landeswährung am Geldautomaten mit der Kreditkarte möglich, funktioniert aber nicht immer. In ländlichen Regionen ist es auch meist schwierig, einen Geldautomaten zu finden. Bezahlung mit den gängigen Kreditkarten ist in Hotels im Großen und Ganzen gewährleistet. Bargeldabhebungen und Bezahlungen per Kreditkarte sollten in Landeswährung und nicht in Euro erfolgen, da hier versteckte Kosten entstehen können. Außerhalb der Städte ist meist nur Barzahlung möglich. Auch Unternehmen wickeln ihre Geschäfte außerhalb der Städte per Barzahlung ab. Daher sollte auf Reisen nach Russland immer genügend Bargeld in der Tasche sein, um auf unvorhergesehene Umstände reagieren zu können (Daumenwert: 1.500 €). Euro können problemlos an den Flughäfen in Moskau und Mineralnyje Vody sowie in zugelassenen Banken, Wechselstuben und Hotels umgetauscht werden. Wenn Du vor Ort Geld in Landeswährung umtauschen willst, tausche nur so viel wie Du tatsächlich benötigst und nimm dafür kleinere Scheine mit. Ein Rücktausch ist oft nicht möglich. Geldwechsel auf der Straße und Bezahlung in Devisen sind verboten. 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 Russische Föderation ein sicheres Reiseland. Die Kriminalität ist jedoch als ERHÖHT einzustufen und erfordert Aufmerksamkeit. Insbesondere in Großstädten und Touristenzentren ist Straßen- und Kleinkriminalität sowie Trickdiebstahl zu beobachten. In Bars und Restaurants besteht außerdem die Gefahr, Getränke mit "K.O. Tropfen" verabreicht zu bekommen und anschließend ausgeraubt zu werden. Insbesondere für Pkw-Reisende besteht eine erhöhte Gefahr, Opfer eines Verbrechens zu werden. Auch "falsche" Polizisten sind teilweise involviert. In der Region Nordkaukasus kommen gezielte Entführungen und kriminelle Übergriffe durch Banden und Terroristen vor. In Russland kommt es regelmäßig zu Protesten, Demonstrationen und sozialen Unruhen, die mehrere Tage dauern können. Demonstrationen verlaufen meist friedlich, gewaltsame Ausschreitungen können jedoch nicht ausgeschlossen werden. Korruption und staatliche Willkür sind in Russland weit verbreitet und alltäglich. Reisende kommen hauptsächlich bei Straßen- und Zollkontrollen oder Behördengängen damit in Berührung. Generell besteht in Russland eine erhöhte Gefahr für terroristische Anschläge durch islamistische Terrorgruppen. Reisende sollten landesweit Vorsicht walten lassen und vor allem beim Besuch neuralgischer Orte in den Städten (z. B. Regierungsgebäude, Botschaften, öffentliche Plätze, exponierte Sehenswürdigkeiten usw.) wachsam sein. Die Sicherheitslage in den Unruheregionen Nordossetien, Tschetschenien, Inguschetien, Dagestan und Kabardino-Balkarien, alle im Nordkaukasus im Grenzgebiet zu Georgien, sind kritisch und es besteht eine hohe Anschlags- und Entführungsgefahr. Reisen in diese Region sollten ausschließlich mit professionellen, ortskundigen Partnern erfolgen. Aufgrund seiner geologischen Lage, an der sich tektonische Platten treffen, ist vor allem der Süden und Osten Russlands eine seismisch aktive Zone und es können Erdbeben unterschiedlichen Ausmaßes auftreten. Unwetter mit extremen Niederschlägen haben vor allem im Süden des Landes Überschwemmungen zur Folge, die den Verkehrsbereich einschränken. Es gibt außerdem aktive Vulkane, wodurch es zu lokalen Evakuierungen und Einschränkungen des Flugverkehrs kommen kann.
 nature_climate<h2 style="text-align:center">Natur & Klima</h2> So groß die Landesfläche, so vielfältig ist die Landschaft und Natur Russlands. 40 Prozent der Landesfläche ist gebirgig. Der in Nord-Süd-Richtung verlaufende und ca. 2.200 km lange Ural bildet die Grenze zwischen dem russischen Europa und Asien. Der höchste Gipfel liegt hier auf 1.895 m Höhe. Die hohen Gipfel Russlands sind im Mittelsibirischen Bergland mit dem Altai (bis 4.506 m), dem höchsten Gebirge Sibiriens, auf der vulkanischen Halbinsel Kamtschatka (bis 4.688 m) und natürlich im Großen Kaukasus zu finden. Im Kaukasus liegt der höchste russische sowie gleichzeitig auch der höchste Gipfel Europas und damit einer der Seven Summits: Der Elbrus mit 5.642 m Höhe. Auch der 5.047 m hohe Kazbek ist ein unter Bergsteigern beliebter Gipfel, der direkt auf der russisch-georgischen Grenze liegt. Die Besteigung erfolgt jedoch von Georgien aus. Das Baikalgebirge in Sibirien ist mit 2.588 m deutlich niedriger, bietet aber vor allem im Winter ideales Gelände für Skitouren bei Pulverschnee. Der gleichnamige See, der Baikalsee, ist mit 1.642 m Tiefe der tiefste Süßwassersee der Welt und UNESCO Weltnaturerbe. Neben dem Baikalsee stehen acht weitere Regionen auf der Weltnaturerbeliste, darunter auch die Vulkan-Halbinsel Kamtschatka, der Altai und der westliche Kaukasus mit dem Elbrus. Neben den Naturerbe-Gebieten gibt es zahlreiche Nationalparks, Naturparks und Wildschutzgebiete in Russland, vor allem aber auch die Sapowedniki - äußerst streng geschützte Gebiete, die nur mit Ausnahmegenehmigungen betreten werden dürfen. Landschaftlich wird Russland von den Breitengraden - also von Nord nach Süd - geprägt. Der lebensfeindlichen Kältewüste im Norden folgt ein großer von Tundra geprägter Gürtel, der schließlich in die riesige und tief bewaldete Taiga übergeht. Im Süden daran schließt sich wiederum ein Steppengürtel an, der am Schwarzen Meer in eine subtropische Region mit dichten Laubwäldern übergeht. Das Klima Russlands ist so unterschiedlich wie das Land groß ist. Vom polaren Klima im nördlichen Eismeer bis zum Monsunklima in der südlichen Hälfte des Fernen Ostens, sind große Teil kontinental geprägt. Die Ausprägung von heißen Sommern und sehr kalten Wintern nimmt von West nach Ost zu und bringt extreme Temperaturunterschiede mit sich. Folgender Wetterdienst gibt Dir einen ganz guten Überblick über das aktuelle Bergwetter in Russland und kann Dir dabei helfen, Dich auf Deine Reise oder Expedition entsprechend vorzubereiten: <ul> <li><a href="https://www.mountain-forecast.com/peaks/Pik-Lenin/forecasts/7134" target="_blank">Mountain Forecast</a></li> <li><a href="https://www.zamg.ac.at/cms/de/aktuell" target="_blank">ZAMG</a></li> </ul> <h3 style="text-align:center">Klima Elbrus</h3> Der Elbrus liegt im Kaukasus und ist geprägt vom asiatischen Kontinentalklima. Kalte, stürmische und schneereiche Winter sind die Folge. Der Elbrus mit seiner Höhe von 5.642 m ist diesem Wetter besonders ausgesetzt. Temperaturen von bis zu -50°C im Winter sind durchaus realistisch. Daher ist eine Besteigung oft nur zwischen Mai und September möglich. Erschwerend kommt das feuchte Klima des nur 100 km entfernten Schwarzen Meeres hinzu, so dass mit schnellen Wetterwechseln gerechnet werden muss. Daher sind wir vor Ort in enger Verbindung mit dem Wetterdienst in Innsbruck, von wo wir über Satellitentelefon die neuesten Prognosen erhalten. <h3 style="text-align:center">Klima Sibirien</h3> Bereits Ende Oktober beginnt es in Sibirien heftig zu schneien. In den lichten Wäldern herrschen darum bereits sehr früh im Winter traumhafte Schneeverhältnisse für Skitouren. Die Temperaturen sind für sibirische Verhältnisse "moderat". Wir müssen uns für unsere Skitourenreise in Sibirien jedoch auf Temperaturen um die -20°C einstellen. Hier unterscheiden sich die beiden Gebiete etwas. So ist das Klima für Skitouren am Baikalsee milder als in den Wäldern von Luzbha (Altai Gebirge). Wer die trockene Kälte noch nicht erlebt hat, darf diese nicht mit unserem Winter vergleichen. Durch die trockene Luft fühlt sich die Temperatur wesentlich angenehmer an als -20°C in den Alpen. <h3 style="text-align:center">Klima Kamtschatka</h3> Klimatisch liegt Kamtschatka in einer eher kalten bis gemäßigten Klimazone mit einer jährlichen Durchschnittstemperatur von etwa 2°C sowie einer hohen Niederschlagsrate. Auch in den trockenen Monaten ist mit Niederschlag zu rechnen. Die Küstenregionen werden vom maritimen Klima des Pazifiks beeinflusst, wodurch die niedrigsten Temperaturen im Winter selten unter -10°C fallen und die Sommermonate auf etwa 15°C ansteigen. Im Inselinneren hingegen sind die Temperaturunterschiede wesentlich extremer und von -40°C im Winter bis zu 25°C im Sommer möglich.
 travel_info
 entry_customs<h2 style="text-align:center">Einreise & Zoll</h2> Einschränkungen bei der Einreise sind generell als gering einzustufen. Im Zuge der Corona-Pandemie und damit verbundener Maßnahmen zur Eindämmung des Covid-19-Virus kann es jedoch kurzfristig zu Änderungen mit verstärkten Kontrollen, Quarantänemaßnahmen oder gar Einreisesperren kommen. Die Russischen Einfuhrbestimmungen sind insbesondere bei der Einfuhr von Medikamenten sehr streng. Für das Mitführen von Medikamenten, die nach russischem Recht rezeptpflichtig sind, ist bei der Einreise eine auf Russisch verfasste ärztliche Bescheinigung oder notariell beglaubigte Russische Übersetzung dieser vorzulegen, aus der Name, Adresse, Geburtsdatum des Patienten sowie die verordneten, benötigten Medikamente einschl. Dosierung und Menge eindeutig hervorgehen. Die Russische Botschaft kann Auskunft über die Rezeptpflicht einzelner Medikamente geben. Wer ein Iridium Satelitentelefon nach Russland einführen möchte, muss dieses vorher bei Iridium Russia <a href="https://iridium-russia.com/eng/register/" target="_blank">anmelden</a>. Nach der Einreise muss für Aufenthalte, die 7 Tage und länger dauern, die Anmeldung bei der zuständigen Migrationsbehörde vorgenommen und eine Migrationskarte ausgestellt werden. Die Anmeldepflicht liegt beim Hotel, dem Partner vor Ort oder der einladenden Person. Auf unseren Reisen übernimmt dies unser Partner vor Ort. <ul> <li style="text-align:justify"><a href="https://eng.customs.gov.ru/" target="_blank">Russische Zollbestimmungen (Föderales Zollamt Russland)</a></li> <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 | CH | I mit folgenden Dokumenten möglich. <ul> <li style="text-align:justify">Reisepass</li> </ul> (!) Reisedokumente müssen noch für mindestens 6 Monate über die Reise hinaus gültig sein! (!) Bei beschädigten Reisepässen kann die Einreise verweigert werden.
 visa<h2 style="text-align:center">Visum</h2> Für die Einreise in die Russische Föderation benötigen Staatsangehörige D | A | CH | I ein Visum, das bereits vor der Reise bei der Russischen Botschaft eingeholt werden muss. Weiterhin besteht eine Krankenversicherungspflicht. Der Nachweis darüber muss bei der Visa-Beantragung vorgelegt werden. Informationen dazu findest Du auf der <a href="https://russische-botschaft.ru/de/consulate/visafragen/reiseversicherung/" target="_blank">Webseite der Russischen Botschaft in Berlin</a>. Einige Orte und Regionen Russlands dürfen nur mit staatlicher Erlaubnis bereist werden, Zuwiderhandlungen werden hart bestraft. Insbesondere bei Reisen in grenznahe Gebiete und in den Nordkaukasus ist dies zu beachten und sollte vor der Reise geklärt werden. Wir empfehlen Deutschen Staatsangehörigen bei Auslandsaufenthalten die Eintragung in die <a href="https://elefand.diplo.de/elefandextern/home/login!form.action" target="_blank">Krisenvorsorgeliste des Auswärtigen Amtes</a> vorzunehmen. 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 Russischen Föderation eingeschränkt und entspricht nicht dem westeuropäischen Standard. Die zentrale Notrufnummer in Russland lautet 112, eine schnelle Notfallversorgung kann oft jedoch nicht gewährleistet werden. Abgelegene Regionen können oftmals nur per Allradfahrzeug erreicht werden. Auch die Netzabdeckung für Mobilfunk weist in ländlichen und abgelegenen Gebieten teilweise noch große Lücken auf. Ärztliche Versorgung ist meist nur in den Städten und in der Landessprache verfügbar. In privaten Krankenhäusern, die meist einen höheren medizinischen Standard haben, können die Behandlungskosten um ein vielfaches höher ausfallen. Meist wird - auch in Notfällen - nur gegen Vorkasse (bar oder Kreditkarte) behandelt. Eine gute Trinkwasserversorgung ist nicht überall vorhanden. Daher sollten nur abgekochtes oder gefiltertes Wasser getrunken und abgekochte, ungeöffnete und geschälte Lebensmittel gegessen werden, um Durchfallerkrankungen vorzubeugen. <h3 style="text-align:center">Impfungen</h3> Für die Einreise nach Russland 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>. Bei Reisen nach Russland besteht ein erhöhtes Risiko sich mit Krankheiten zu infizieren, die durch Zecken übertragen werden. Schutzmaßnahmen zur Vermeidung von Insektenbissen sollten vor allem in den tieferen Lagen beachtet werden. Aufgrund der großen Zahl von Straßenhunden in Russland, die bis in die Städte reicht, gibt es ein erhöhtes Tollwut-Risiko. Übertragen wird Tollwut durch Tierbisse, Kratzwunden oder direkten Kontakt mit infiziertem Speichel.
 tours_summer<h2 style="text-align:center">Tourenmöglichkeiten im Sommer</h2> Der "König des Kaukasus" steht bei vielen Bergsteigern ganz oben auf der Liste. Der Elbrus - mit 5.642 m höchster Berg Europas und einer der begehrten Seven Summits, lässt sich sowohl im Sommer als auch im Winter mit Ski besteigen. Kombiniert mit der russischen Gastfreundschaft und der Kulisse längst vergangener Tage inmitten einer grandiosen Bergwelt, ist die <a href="https://www.alpinewelten.com/elbrus-besteigung?step=tour" target="_blank">Besteigung des Elbrus</a> tatsächlich etwas ganz Besonderes, das in keinem Tourenbuch fehlen sollte. Individuelle Verlängerungen in Moskau oder St. Petersburg können problemlos organisiert werden.
 tours_winter<h2 style="text-align:center">Tourenmöglichkeiten im Winter</h2> Aufgrund des kontinentalen Klimas mit kalten, schneereichen Wintern, ist Russland prädestiniert für Skitourenreisen. Allen voran steht hier wieder der Elbrus, den wir sowohl <a href="https://www.alpinewelten.com/skitouren-im-kaukasus-mit-besteigung-des-elbrus-5-642-m?step=tour" target="_blank">von der Südseite</a> als auch <a href="https://www.alpinewelten.com/skitour-elbrus?step=tour" target="_blank">von der anspruchsvolleren Nordseite</a> aus mit Ski besteigen. Auch auf unseren Wintertouren in Russland kommt der kulturelle Aspekt nicht zu kurz und macht die gesamte Reise zu einem Erlebnis. In Sibirien findet sich ein weiteres Winterabenteuer für Skitourengeher. Bester Pulverschnee und <a href="https://www.alpinewelten.com/skitouren-in-sibirien-pulverschneetraeume-im-fruehwinter?step=tour" target="_blank">Skitouren vom Baikalsee bis ins Altai-Gebirge</a> warten in Sibirien auf uns. Den Gebietswechsel verbinden wir mit der einmaligen Fahrt in der Transsibirischen Eisenbahn. Wem das noch nicht abgelegen genug ist, der wird von Kamtschatka, der größten Halbinsel Ostasiens, begeistert sein. Mit seinen Vulkanen und einer bizarren Berglandschaft <a href="https://www.alpinewelten.com/skitourenreise-mit-katamaran-in-kamtschatka?step=tour" target="_blank">begeistert Kamtschatka jeden Skitourengeher</a>! Auf einem 30 m langen Katamaran sind wir dort von einer einsamen Bucht zur nächsten unterwegs und wählen unsere Skitourenziele direkt vom Schiff aus. Im Anschluss wärmt eine bordeigene Sauna die müden Glieder, so dass auch die Entspannung nicht zu kurz kommt. Nach sechs Tagen auf See wechseln wir wieder an Land, um den Avacha Vulkan zu besteigen. Auch das ist ein absolutes Highlight.
 microsite_id(null)
 CountriesNews(array)
 id1271
 news_id68
 country_id174
 position1
 Route(array)
 id4202
 hasha01ef87050401fa0a622c840b6c6a4b1
 created2020-08-18 13:22:18
 updated2021-11-17 10:31:11
 modelCountry
 foreign_key174
 base/
 aliasrussische-foederation-russland
 controllerFrontendCountries.FrontendCountries
 actioncountry
 parent_id(null)
 lft5529
 rght5530
 route/russische-foederation-russland
 FlagUpload(array)
 0(array)
 id397011
 hash63f5f0255a46de793eaa0273edc9c000
 created2020-09-14 08:51:26
 updated2020-09-14 08:51:29
 modelCountry
 fieldflag
 foreign_key174
 aliasflagge-russische-foederation.png
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Country/Flag/5f5f12f1c31da.png
 size1726
 ext.png
 mimeimage/png
 width550
 height550
 TourMainType(empty)
- contents(array)
 0(array)
 NewsContent(array)
 id57
 hashd01c9f01a68ea3b119223d987bef1068
 created2020-10-20 09:50:34
 updated2021-10-15 09:44:41
 titleCorona Lage
 news_id68
 statusactive
 typearticle
 article_content<h1 style="text-align:center">Bergsport & Corona Russische Föderation</h1> <h2 style="text-align:center">Aktualisierte Informationen</h2> Werden Reisen nach Russland durchgeführt: Ja, seit 12. Mai Gibt es Sonderregelungen im Reisevertrag: Ja <ul> <li>Zahlung erst 3 Tage vorher bei sicherer Durchführung</li> <li>Die Teilnahme ist derzeit nur für Geimpfte und Genesene möglich (2-G Regel)</li> </ul> <h3 style="text-align:center">Hinweise zur Ein- und Ausreise</h3>
 video_type(null)
 video_url(null)
 position1
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 layoutcol12
 mosaic_gallery_type(null)
 ImageMedia(empty)
 GalleryMedia(empty)
 MosaicGalleryMedia(empty)
 1(array)
 NewsContent(array)
 id155
 hashe52d7f4cc99be5d060fc8ee25f8fb1f4
 created2021-07-13 10:05:02
 updated2021-12-22 12:47:34
 titleD
 news_id68
 statusactive
 typearticle
 article_content<figure class="pull-left"> <div class="img-responsive" data-media-id="9123"> </div> <figcaption class="hidden"></figcaption> </figure> Deutsche Reisende Reisewarnung: Ja (<a href="https://www.auswaertiges-amt.de/de/aussenpolitik/laender/russischefoederation-node/russischefoederationsicherheit/201536" target="_blank">Link</a>) Einstufung: Hochrisikogebiet (<a href="https://www.rki.de/DE/Content/InfAZ/N/Neuartiges_Coronavirus/Risikogebiete_neu.html" target="_blank">RKI</a>) EINREISE INS REISELAND Einreiseformular: Ja (<a href="https://ru.usembassy.gov/wp-content/uploads/sites/138/Covid-Testing-form.pdf" target="_blank">Link</a>) Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Gültigkeit Impfzertifikat: Ab 01.02.22 sind EU Covid Impfzertifikate ohne Boosterimpfung nur noch 9 Monate gültig. Genesene: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Nicht Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Quarantäne bei Einreise: Nein RÜCKREISE NACH DEUTSCHLAND Einreiseformular: Ja (<a href="https://www.einreiseanmeldung.de/#/" target="_blank">Link</a>) Geimpfte: Test / Quarantänebefreiung Genesene: Test / Quarantänebefreiung mit Nachweis (6 Monate) Nicht Geimpfte: AntigenSchnelltest (48h) / PCR Test (72h) Quarantäne bei Rückreise: Ja, für Nicht Geimpfte 5 Tage + Test 
 video_type(null)
 video_url(null)
 position2
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 layoutcol4
 mosaic_gallery_type(null)
 ImageMedia(empty)
 GalleryMedia(empty)
 MosaicGalleryMedia(empty)
 2(array)
 NewsContent(array)
 id156
 hashfd24101046af2ae7a633048cb32e0049
 created2021-07-13 10:05:30
 updated2021-12-22 12:47:44
 titleAT
 news_id68
 statusactive
 typearticle
 article_content<figure class="pull-left"> <div class="img-responsive" data-media-id="9124"> </div> <figcaption class="hidden"></figcaption> </figure> Österreichische Reisende Reisewarnung: Nein (<a href="https://www.bmeia.gv.at/reise-aufenthalt/reiseinformation/land/russische-foederation/" target="_blank">Link</a>) Einstufung: Sonstiger Staat (<a href="https://www.bmeia.gv.at/reise-aufenthalt/coronavirus-covid-19-und-reisen/" target="_blank">Link</a>) EINREISE INS REISELAND Einreiseformular: Ja (<a href="https://ru.usembassy.gov/wp-content/uploads/sites/138/Covid-Testing-form.pdf" target="_blank">Link</a>) Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Gültigkeit Impfzertifikat: Ab 01.02.22 sind EU Covid Impfzertifikate ohne Boosterimpfung nur noch 9 Monate gültig. Genesene: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Nicht Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Quarantäne bei Einreise: Nein RÜCKREISE NACH ÖSTERREICH Einreiseformular: Nein = Mit Booster Impfung oder PCR Test (72h) Ja = ohne Booster Impfung oder PCR Test. - Der <a href="https://www.austria.info/de/service-und-fakten/coronavirus-situation-in-oesterreich/testungen" target="_blank">Test</a> kann auch in Österreich nach Rückreise durchgeführt werden. Bis zum Ergebnis besteht Quarantänepflicht. (<a href="https://entry.ptc.gv.at/" target="_blank">Link</a>) Geimpfte: PCR Test (72h) | Test- und Quarantänebefreiung mit Boosterimpfung Genesene: PCR Test (72h) | Quarantänebefreiung mit Nachweis Nicht Geimpfte: Quarantänebefreiung mit PCR Test (72h) Quarantäne bei Rückreise: Ja für Nicht Geimpfte 10 Tage 
 video_type(null)
 video_url(null)
 position3
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 layoutcol4
 mosaic_gallery_type(null)
 ImageMedia(empty)
 GalleryMedia(empty)
 MosaicGalleryMedia(empty)
 3(array)
 NewsContent(array)
 id157
 hashe703c0d97cfb21bb86b5058f1678cac7
 created2021-07-13 10:05:47
 updated2021-12-22 12:47:58
 titleCH
 news_id68
 statusactive
 typearticle
 article_content<figure class="pull-left"> <div class="img-responsive" data-media-id="9121"> </div> <figcaption class="hidden"></figcaption> </figure> Schweizer Reisende Reisewarnung: Nein (<a href="https://www.eda.admin.ch/eda/de/home/vertretungen-und-reisehinweise/russland.html" target="_blank">Link</a>) Einstufung: Keine EINREISE INS REISELAND Einreiseformular: Ja (<a href="https://ru.usembassy.gov/wp-content/uploads/sites/138/Covid-Testing-form.pdf" target="_blank">Link</a>) Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Gültigkeit Impfzertifikat: 365 Tage ab Verabreichung der letzten Impfdosis (Ausnahme Impfstoff Janssen (<a href="https://www.bag.admin.ch/bag/de/home/krankheiten/ausbrueche-epidemien-pandemien/aktuelle-ausbrueche-epidemien/novel-cov/covid-zertifikat/covid-zertifikat-erhalt-gueltigkeit.html" target="_blank">Link</a>)) Genesene: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Nicht Geimpfte: Testpflicht, PCR Test (72h) & ggf. weiterer Schnelltest bei Einreise Quarantäne bei Einreise: Nein RÜCKREISE IN DIE SCHWEIZ Einreiseformular: Ja (<a href="http://swissplf.admin.ch/formular">Link</a>) Geimpfte: PCR Test (72h) Genesene: PCR Test (72h) Nicht Geimpfte: PCR Test (72h) | Erneuter PCR- oder Antigentest 4 -7 Tage nach Rückkehr | Meldepflicht Kanton Quarantäne bei Rückreise: Entfällt 
 video_type(null)
 video_url(null)
 position4
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 layoutcol4
 mosaic_gallery_type(null)
 ImageMedia(empty)
 GalleryMedia(empty)
 MosaicGalleryMedia(empty)
 4(array)
 NewsContent(array)
 id200
 hash90f5ab17c08a33e43e79f4354c226be6
 created2021-07-13 17:03:47
 updated2021-11-09 10:01:34
 titleentscheidungsgrundlagen
 news_id68
 statusactive
 typearticle
 article_content(Veröffentlicht: 05.08.2020)
 video_type(null)
 video_url(null)
 position5
 developer_template_code(null)
 developer_template_css(null)
 developer_template_js(null)
 layoutcol12
 mosaic_gallery_type(null)
 ImageMedia(empty)
 GalleryMedia(empty)
 MosaicGalleryMedia(empty)
- 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)
 News(empty)
 FileMedia(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)
 MountainGuides(empty)
 MountainGuideQualifications(empty)
 MountainGuide(empty)
 TeaserImageMedia(empty)
 GalleryMedia(empty)
 VideoThumbnailMedia(empty)
 OutputChannel(empty)
 LogoMedia(empty)
 LogoHorizontalMedia(empty)
 MountainGuideDailyRate(empty)
 Region(empty)
 Accomodations(empty)
 TeaserMedia(empty)
 TravelReport(empty)
 Country(empty)
 Countries(empty)
 TourMainType(empty)
 TourMainTypes(empty)
 Accomodation(empty)
 Microsite(empty)
 Microsites(empty)
 RegionAreas(empty)
 PackingListItems(empty)
 PackingList(empty)
 Co2Items(empty)
 AccomodationImagesMedia(empty)
 EmailHeadMedia(empty)
 FaqItem(empty)
 FaqSet(empty)
 FaqItems(empty)
 Content(empty)
 TourType(empty)
 MountainGuideQualification(empty)
 ArticleContentMedia(empty)
 MosaicGalleryMedia(empty)
 BackgroundImageMedia(empty)
 User(empty)
 Aro(empty)
 Aco(empty)
 Users(empty)
 TourFaqItemsForCustomer(empty)
 TourFaqItemsForMountainGuide(empty)
 Job(empty)
 TagsTag(empty)
 FileUpload(empty)
 FlagUpload(empty)
 TourTexts(empty)
 Audit(empty)
 AvatarWebsiteUpload(empty)
 TagEntity(empty)
 FirmsNews(empty)
 NewsTour(empty)
 CountriesNews(empty)
 NewsTourMainType(empty)
 NewsContent(empty)
 Highlight(empty)
 AdvantagesMenu(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7SocialMedia
 8LeafletJs
 9Leaflet
 10GMap
 11Embed
 12Layout
 13Recaptcha
 14ThirdPartyCookies
 15RequestContent
 16Number
 17SimpleGraph
 18DebugTimer
 19Toolbar
 20Time
 21Js
 22HtmlToolbar
====

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.bergsteigerschule-watzmann.de
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	/russland-bergsport-corona
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/russland-bergsport-corona
Remote Port	34464
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.87.250.158
Server Port	443
Server Addr	85.236.49.170
Server Name	www.bergsteigerschule-watzmann.de
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Accept Encoding	br,gzip
Http If Modified Since	Mon, 18 Oct 2021 15:02:22 GMT
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Connection	close
Http X Accel Internal	/internal-nginx-static-location
Http X Real Ip	3.87.250.158
Http Host	www.bergsteigerschule-watzmann.de
Proxy-nokeepalive	1
Https	on
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Http Authorization
Unique Id	YfI5FJmGwD-ktWfrUfsV1gAAAJE
Redirect Status	200
Redirect Https	on
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Http Authorization
Redirect Unique Id	YfI5FJmGwD-ktWfrUfsV1gAAAJE
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Unique Id	YfI5FJmGwD-ktWfrUfsV1gAAAJE
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1643264276.4811
Request Time	1643264276

====

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
  Model(array)
  0Audit/Model/Audit.php
  1Audit/Model/AuditAppModel.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
  FrontendApi(array)
  Config(array)
  0FrontendApi/Config/routes.php
  FrontendContents(array)
  Config(array)
  0FrontendContents/Config/bootstrap.php
  FrontendMembers(array)
  Config(array)
  0FrontendMembers/Config/routes.php
  FrontendNews(array)
  Controller(array)
  0FrontendNews/Controller/FrontendNewsController.php
  1FrontendNews/Controller/FrontendNewsAppController.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
  2News/Model/NewsContent.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
  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
  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
====

Bergsport & Corona Russische Föderation

Aktualisierte Informationen

Hinweise zur Ein- und Ausreise

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 20 ms Total Queries: 114 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 20 ms
Total Queries: 114 queries