Aktualisiert: 03.10.2021

Autor: Hans Honold

Bergsport & Corona Rumänien

Aktualisierte Informationen

Werden Reisen nach Rumänien durchgeführt: Ja

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: Nein

Nicht Geimpfte: Testbefreiung

Geimpfte: Testbefreiung für vollständig Geimpfte

Genesene: Testbefreiung mit Nachweis (6 Monate)

Quarantäne bei Einreise: Nein

RÜCKREISE NACH DEUTSCHLAND

Einreiseformular: Ja (Link)

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

Geimpfte: Keine Test / Quarantänepflicht

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

Quarantäne bei Rückreise: Ja, für Nicht Geimpfte bei Rückkehr aus Hochrisikogebieten. Befreiung am 5. Tag durch Test

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

Österreichische Reisende

Reisewarnung: Nein (Link)

Einstufung: Keine

EINREISE INS REISELAND

Einreiseformular: Nein

Nicht Geimpfte: Testbefreiung

Geimpfte: Testbefreiung für vollständig Geimpfte

Genesene: Testbefreiung mit Nachweis (6 Monate)

Quarantäne bei Einreise: Nein

RÜCKREISE NACH ÖSTERREICH

Einreiseformular: Ja für Nicht Geimpfte (Link)

Nicht Geimpfte: Testpflicht innerhalb 24h nach Einreise (Link)

Geimpfte: Testbefreiung

Genesene: Testbefreiung

Quarantäne bei Rückreise: Nein

Schweizer Reisende

Reisewarnung: Nein (Link)

Einstufung: Keine

EINREISE INS REISELAND

Einreiseformular: Nein

Nicht Geimpfte: Testbefreiung

Geimpfte: Testbefreiung für vollständig Geimpfte

Genesene: Testbefreiung mit Nachweis (6 Monate)

Quarantäne bei Einreise: Nein

RÜCKREISE IN DIE SCHWEIZ

Einreiseformular: Ja (Link)

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

Geimpfte: Testbefreiung

Genesene: Testbefreiung

Quarantäne bei Rückreise: Nein

Entscheidungsgrundlagen:

Gesamtcharakter der Reisen: Positiv, Abseits von Menschenansammlungen

Regelmäßig vorhandener Flugverkehr: Ja

Covid-19 Lage in den Zielgebieten: Gering

Hygiene-, Abstands- und Sicherheitsmaßnahmen: Umsetzbar

Bisher durchgeführte Reisen: Keine

Weitere Informationen:

Die Europäische Union hat eine sehr übersichtliche und informative Plattform geschaffen, die einen sehr guten Überblick liefert.

Details Rumänien auf der Seite Re-open EU

Aktuelle Corona Übersichtskarte Rumänien

Übersichtskarte Rumänien

(Veröffentlicht: 07.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.

Infos rund um Corona / Covid-19 & Reisen

Buchung ohne Anzahlung

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent702e6d7fd00a6f14bcc094a4c956d69f
  time1634758607
  countdown10
- _Token(array)
  key7d7df623bbf0264361783902e446c3c672eadd5feb4a745c414dcd94a1c56de7b636203e72e059a31440fcf5cdb3e724332481d973aeadcd7bf39107530f5a26
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  7d7df623bbf0264361783902e446c3c672eadd5feb4a745c414dcd94a1c56de7b636203e72e059a31440fcf5cdb3e724332481d973aeadcd7bf39107530f5a261634746007
====
Request
+
Request

Cake Params
- pluginFrontendNews
- controllerFrontendNews
- actionnews
- named(empty)
- pass(array)
  071
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  News71
- route(array)
  id4920
  hash04a038d2154d797da34d4cd9954c4248
  created2020-10-20 14:17:03
  updated2021-10-03 12:19:08
  modelNews
  foreign_key71
  base/
  aliasrumaenien-bergsport-corona
  controllerFrontendNews.FrontendNews
  actionnews
  parent_id(null)
  lft5861
  rght5862
  route/rumaenien-bergsport-corona
- isAjax(false)
- _Token(array)
  key7d7df623bbf0264361783902e446c3c672eadd5feb4a745c414dcd94a1c56de7b636203e72e059a31440fcf5cdb3e724332481d973aeadcd7bf39107530f5a26
  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: 21 ms
Total Queries: 128 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`))) = '/rumaenien-bergsport-corona' LIMIT 1	1	1	3	maybe slow
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 5861 AND `Route`.`rght` >= 5862 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-zugspitze.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` = 'bz' 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` > 285 AND `Menu`.`rght` < 286 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` = 71 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` = (71)	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` = 71 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` = 71 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'News' AND `TagEntity`.`field` = 'tags'	1	1	1
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` = 71 AND `FirmsNews`.`firm_id` = `OutputChannel`.`id`) ORDER BY `FirmsNews`.`position` ASC	1	1	0
SELECT `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, `Tour`.`callout_icon_multiple`, `Tour`.`microsite_id`, `Tour`.`is_archive`, `Tour`.`is_service`, (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` = 71 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` = 71 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` = 173 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` = (173) 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` = 71 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` = 71 AND `NewsContent`.`status` = 'active' ORDER BY `position` ASC	5	5	1	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` IN (60, 170, 171, 172, 205) 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 (60, 170, 171, 172, 205) AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'NewsContent' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
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 (60, 170, 171, 172, 205) 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` = 2 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` = (2) 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` = 'bz' 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` > 348 AND `Menu`.`rght` < 387 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	19	19	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 (710, 267, 180, 708, 692, 179, 244, 277, 731, 678, 680, 248, 682, 266, 273, 679, 694, 681, 693) 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` = 'bz' 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` > 388 AND `Menu`.`rght` < 401 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 (236, 182, 237, 238, 569, 239) 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` = 'bz' 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` = 71 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` = 4792 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` = (8260) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT `TourType`.`id`, `TourType`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) WHERE 1 = 1 GROUP BY `TourType`.`id` ORDER BY `TourType`.`title` ASC	38	38	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` = 'bz' 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` = 166 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` = 957 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` = (1528) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	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` = 602 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` = (166) 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` = 166 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` = 166 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` = 'bz' 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` = 739 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` = 5140 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` = 3878 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` = (739) 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` = 739 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` = 739 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` = 'bz' 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` > 284 AND `Menu`.`rght` < 289 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 (711, 677) 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` = 'bz' 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` > 290 AND `Menu`.`rght` < 347 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	28	28	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 (205, 220, 635, 207, 206, 219, 221, 223, 224, 225, 226, 227, 229, 230, 231, 754, 755, 756, 232, 733, 214, 222, 262, 639, 640, 641, 642, 643) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	16	16	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`, (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` = 2 ORDER BY `position` ASC	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` = 375 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` = 375 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` = (7529) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 167 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` = 167 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` = (4924) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	14	14	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 340 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` = 340 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` = (6972) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	18	18	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 331 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` = 331 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` = (4974) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 23 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` = 23 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` = (453) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 42 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` = 42 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` = (107) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 251 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` = 251 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` = (662) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 187 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` = 187 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` = (391) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 28 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TeaserImageMedia`.`id`, `TeaserImageMedia`.`hash`, `TeaserImageMedia`.`created`, `TeaserImageMedia`.`updated`, `TeaserImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) AS `TeaserImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `TeaserImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 28 AND `MediaEntity`.`media_id` = `TeaserImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'teaser_image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (612) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	0
SELECT `TourMainTypes`.`id`, `TourMainTypes`.`title` FROM `alpinewelten`.`tours` AS `Tour` JOIN `alpinewelten`.`tour_types_tours` AS `TourTypesTour` ON (`TourTypesTour`.`tour_id` = `Tour`.`id`) JOIN `alpinewelten`.`tour_types` AS `TourType` ON (`TourTypesTour`.`tour_type_id` = `TourType`.`id`) JOIN `alpinewelten`.`tour_main_types` AS `TourMainTypes` ON (`TourMainTypes`.`id` = `TourType`.`tour_main_type_id`) WHERE 1 = 1 ORDER BY `TourMainTypes`.`position` ASC	504	504	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` = 'search' AND `Language`.`langid` = 'bz' 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` = 170 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` = 961 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` = (1880) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	13	13	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` = 606 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` = (170) 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` = 170 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` = 170 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` = 'bz' 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` = 'bz' 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` = 'bz' 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` = 'bz' 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` = 'bz' 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 19.76 MB

Message	Memory use
Component initialization	1.77 MB
Controller action start	2.81 MB
Controller render start	6.42 MB
View render complete	9.27 MB

Timers

Total Request Time: 735 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	119.13
Event: Controller.initialize	34.54
Event: Controller.startup	4.22
Controller action	168.48
Event: Controller.beforeRender	135.78
» Processing toolbar data	79.71
Rendering View	148.87
» Event: View.beforeRender	0.04
» Rendering APP/Plugin/FrontendNews/View/FrontendNews/news.php	12.96
» » Rendering APP/Plugin/FrontendNews/View/Elements/breadcrumb.php	1.34
» » Rendering APP/Plugin/FrontendContents/View/Elements/author.php	1.27
» » Rendering APP/View/Elements/icon.php	0.25
» Event: View.afterRender	0.52
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/2.php	132.41
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.89
» » Rendering APP/View/Elements/header/header.php	44.95
» » » Rendering APP/View/Elements/header/header_navbar.php	44.39
» » » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php	0.25
» » » » Rendering APP/View/Elements/navigation_secondary.php	22.76
» » » » » Rendering APP/View/Elements/icon.php #2	9.74
» » » » » Rendering APP/View/Elements/icon.php #3	0.63
» » » » » Rendering APP/View/Elements/icon.php #4	0.54
» » » » » Rendering APP/View/Elements/icon.php #5	9.24
» » » » Rendering APP/View/Elements/navigation.php	19.22
» » » » » Rendering APP/View/Elements/icon.php #6	0.51
» » » » » Rendering APP/View/Elements/icon.php #7	0.49
» » » » » Rendering APP/View/Elements/icon.php #8	0.50
» » » » » Rendering APP/View/Elements/icon.php #9	0.54
» » » » » Rendering APP/View/Elements/icon.php #10	0.53
» » » » » Rendering APP/View/Elements/icon.php #11	0.53
» » » » » Rendering APP/View/Elements/icon.php #12	0.33
» » » » » Rendering APP/View/Elements/icon.php #13	0.50
» » » » » Rendering APP/View/Elements/icon.php #14	0.52
» » » » » Rendering APP/View/Elements/icon.php #15	0.54
» » » » » Rendering APP/View/Elements/icon.php #16	0.55
» » » » » Rendering APP/View/Elements/icon.php #17	0.33
» » » » » Rendering APP/View/Elements/icon.php #18	0.52
» » » » » Rendering APP/View/Elements/icon.php #19	0.53
» » » » » Rendering APP/View/Elements/icon.php #20	0.58
» » » » » Rendering APP/View/Elements/icon.php #21	0.35
» » » » » Rendering APP/View/Elements/icon.php #22	0.34
» » » » » Rendering APP/View/Elements/icon.php #23	0.32
» » » » » Rendering APP/View/Elements/icon.php #24	0.50
» » » » » Rendering APP/View/Elements/icon.php #25	0.56
» » » » » Rendering APP/View/Elements/icon.php #26	0.54
» » » » » Rendering APP/View/Elements/icon.php #27	0.54
» » » » » Rendering APP/View/Elements/icon.php #28	0.33
» » Rendering APP/Plugin/FrontendNews/View/Elements/breadcrumb.php #2	0.91
» » Rendering APP/View/Elements/footer/footer.php	32.80
» » » Rendering APP/View/Elements/icon.php #29	9.18
» » » Rendering APP/View/Elements/icon.php #30	9.18
» » » Rendering APP/View/Elements/logos/logo-instagram.php	0.36
» » » Rendering APP/View/Elements/logos/logo-youtube.php	0.24
» » » Rendering APP/View/Elements/logos/logo-facebook.php	0.23
» » » Rendering APP/View/Elements/logos/logo-alpine-welten.php	0.28
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-zugspitze.php #2	0.25
» » » Rendering APP/View/Elements/logos/logo-bergsteigerschule-watzmann.php	0.24
» » » Rendering APP/View/Elements/footer/footer_newsletter_subscribe.php	0.27
» » » Rendering APP/View/Elements/logos/logo-adidas-terrex.php	0.32
» » » Rendering APP/View/Elements/logos/logo-adidas-eyewear.php	0.24
» » » Rendering APP/View/Elements/logos/logo-petzl.php	0.24
» » » Rendering APP/View/Elements/logos/logo-pieps.php	0.23
» » » Rendering APP/View/Elements/logos/logo-kaestle.php	0.23
» » » Rendering APP/View/Elements/logos/logo-diamir.php	0.28
» » » Rendering APP/View/Elements/logos/logo-komperdell.php	0.25
» » » Rendering APP/View/Elements/logos/logo-scarpa.php	0.26
» » » Rendering APP/View/Elements/logos/logo-exped.php	0.25
» » » Rendering APP/View/Elements/logos/logo-abs.php	0.23
» » » Rendering APP/View/Elements/logos/logo-hilleberg.php	0.23
» » Rendering APP/View/Elements/contact_widget.php	47.04
» » » Rendering APP/View/Elements/icon.php #31	9.15
» » » Rendering APP/View/Elements/icon.php #32	9.21
» » » Rendering APP/View/Elements/icon.php #33	8.97
» » » Rendering APP/View/Elements/icon.php #34	8.69
» » » Rendering APP/View/Elements/icon.php #35	8.72
» » Rendering APP/View/Elements/popup_notification.php	0.98
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- canonicalUrlhttps://www.alpinewelten.com/rumaenien-bergsport-corona
- news(array)
 News(array)
 id71
 hash927b5e83922f8e7c6bf47633c039c04c
 created2020-10-20 14:17:03
 updated2021-10-03 12:19:07
 titleRumänien | Bergsport & Corona
 statusactive
 typecontent
 release(null)
 hide(null)
 publishing_date2021-10-03
 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(false)
 is_updated(true)
 user_id25
 published1
 User(array)
 id25
 hash9be0db7689deeaef13ed068fb81e9d54
 created2015-10-22 07:32:49
 updated2021-06-12 01:43:06
 activity2021-10-20 17:14:25
 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)
 id4792
 hash34edc462a7e8eadf7e8140f51211e429
 created2020-10-20 14:17:03
 updated2021-10-03 12:19:08
 modelNews
 foreign_key71
 titleRumänien | Bergsport & Corona
 descriptionAllgemeine Covid-19 Hinweise zur Reiseplanung für Rumänien
 internal_keywords
 author
 tw_creator
 fb_author
 robots3
 sitemap_priority0.5
 Teaser(array)
 id3533
 hasha0eebb378a48837a95ef860cc598ad54
 created2020-10-20 14:17:03
 updated2021-10-03 12:19:08
 modelNews
 foreign_key71
 typedefault
 titleRumänien | Bergsport & Corona
 contentAllgemeine Covid-19 Hinweise zur Reiseplanung für Bulgarien
 buttonHier erfährst du mehr
 teaser_id(null)
 layoutcol12
 Route(array)
 id4920
 hash04a038d2154d797da34d4cd9954c4248
 created2020-10-20 14:17:03
 updated2021-10-03 12:19:08
 modelNews
 foreign_key71
 base/
 aliasrumaenien-bergsport-corona
 controllerFrontendNews.FrontendNews
 actionnews
 parent_id(null)
 lft5861
 rght5862
 route/rumaenien-bergsport-corona
 Audit(array)
 0(array)
 id5f8ed53f-8ab8-4263-a8a2-08a555ec31aa
 eventCREATE
 modelNews.News
 aliasNews
 entity_id71
 json_object{"News":{"id":"71","hash":"927b5e83922f8e7c6bf47633c039c04c","created":"2020-10-20 14:17:03","updated":"2020-10-20 14:17:03","title":"Rum\u00e4nien | Bergsport & Corona","status":"active","type":"no_details","release":null,"hide":null,"publishing_date":"2020-08-07","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 14:17:03
 User(array)
 id25
 hash9be0db7689deeaef13ed068fb81e9d54
 created2015-10-22 07:32:49
 updated2021-06-12 01:43:06
 activity2021-10-20 17:14:25
 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_count112
 TagEntity(array)
 id31795
 tag_id1087
 modelNews
 fieldtags
 foreign_key71
 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)
 id1310
 firm_id1
 news_id71
 position1
 Tour(empty)
 Country(array)
 0(array)
 id173
 hash7897a62ee0b67e12cef9a68acadabd53
 created2016-06-01 17:35:19
 updated2021-03-25 14:51:20
 titleRumänien
 abbreviationRO
 subtitleTranssilvanien - Die Heimat Graf Draculas
 link_embassy_germanhttps://www.auswaertiges-amt.de/de/aussenpolitik/laender/rumaenien-node/rumaeniensicherheit/210822
 link_embassy_austrianhttps://www.bmeia.gv.at/reise-aufenthalt/reiseinformation/land/rumaenien/
 link_embassy_swisshttps://www.eda.admin.ch/eda/de/home/vertretungen-und-reisehinweise/rumaenien.html
 link_embassy_italianhttp://www.viaggiaresicuri.mae.aci.it/country/ROU
 best_travel_season3071
 generalStand: 12.08.2020 <h2 style="text-align:center">Allgemeines</h2> Wer kennt ihn nicht - Bram Stokers berühmten "Graf Dracula", der von seinem Schloss in den tiefen transsilvanischen Wäldern aus sein dunkles Unwesen getrieben haben soll? Tatsächlich war Vlad III. Draculea, der Erzählungen zufolge den irischen Schriftsteller zu seinem Roman inspiriert haben soll, ein rumänischer Woiwode des 14. Jahrhunderts, der vielleicht grausam gewesen sein mochte, doch mit einem Vampir sicherlich nichts zu tun hatte. Transsilvanien, oder auf Deutsch auch Siebenbürgen, liegt heute im Zentrum Rumäniens. Bereits seit dem 13. Jahrhundert haben sich in Siebenbürgen deutsche Siedler niedergelassen, so dass diese Region auch eine gewisse deutsche Prägung hat. Im Osten und Süden vom Karpatenbogen eingerahmt findet sich in Siebenbürgen auch heute noch eine unberührte Berglandschaft mit den höchsten Gipfeln des Landes. Rumänien liegt in Südosteuropa und grenzt im Westen an Ungarn und Serbien, im Norden und Osten an die Ukraine und Moldawien sowie im Süden entlang der Donau an Bulgarien. Die Hauptstadt ist Bukarest, die mit gut 1,8 Millionen Einwohnern in etwa so groß ist wie Hamburg. Die Landessprache ist Rumänisch. Englisch ist in Rumänien inzwischen weit verbreitet. In Siebenbürgen wird teilweise auch noch Deutsch gesprochen, auch wenn es nicht mehr viele Rumäniendeutsche dort gibt. Die Rumänen sind generell sehr freundlich, hilfsbereit und aufgeschlossen. Der Großteil der rumänischen Bevölkerung bekennt sich zum rumänisch-orthodoxen Glauben. Die meisten Feiertage sind daher religiös geprägt und zeitlich vom Osterfest abhängig. Am 01. Dezember feiern die Rumänen außerdem ihren Nationalfeiertag, der auf einen der wichtigsten Momente der rumänischen Geschichte, die große Vereinigung, zurückzuführen ist. Militärparaden und unzählige Veranstaltungen begleiten diesen Tag. <h3 style="text-align:center">Währung & Bezahlung</h3> Rumänien gehört zur EU und daher ist die Landeswährung der Euro. Normalerweise kann man fast überall mit einer EC-Karte oder Kreditkarte am Geldautomaten Bargeld abheben. In ländlichen Regionen ist es allerdings manchmal schwierig, einen Geldautomaten zu finden. Bezahlung mit den gängigen Kreditkarten ist im Großen und Ganzen gewährleistet. Außerhalb der Städte ist häufig nur Barzahlung möglich, ebenso wie auf Berghütten. Daher sollte auf Reisen nach Rumänien immer genügend Bargeld in der Tasche sein.
 security<h2 style="text-align:center">Sicherheit</h2> Generell ist Rumänien ein sicheres Reiseland in der Europäischen Union (EU). Die Kriminalität ist als GERING einzustufen. Insbesondere in Großstädten und Touristenzentren sind Straßen- und Kleinkriminalität sowie Trickdiebe zu beobachten. Da Rumänien sich im Kampf gegen den internationalen islamistischen Terrorismus beteiligt, sind terroristische Anschläge in Rumänien nicht auszuschließen, aber dennoch als gering einzustufen.
 nature_climate<h2 style="text-align:center">Natur & Klima</h2> Rumänien erstreckt sich von West nach Ost von der Pannonischen Tiefebene über den Karpatenbogen bis zum Schwarzen Meer, das die natürliche Grenze im Osten bildet. Gut ein Viertel der Landesfläche ist Waldgebiet, in denen zahlreiche Tierarten heimisch sind, insbesondere auch Braunbären, Wölfe und Luchse. Im Zuge des NATURA-2000-Schutzgebietnetzes gibt es in Rumänien inzwischen zahlreiche Naturschutzgebiete und das Donaudelta mit dem größten Schilfrohrgebiet der Erde zählt zum UNESCO Weltnaturerbe. Dennoch wird die Natur Rumäniens zunehmend von der modernen Landwirtschaft, dem Wachstum der Städte, aber auch von illegalem Holzschlag beeinflusst. Der Gebirgsbogen der südlichen Karpaten, auch Transsilvanische Alpen genannt, trennt Siebenbürgen von der Walachai. Der höchste Gipfel ist der 2.544 m hohe Moldoveanu. Die Gebirgsregionen mit ihren oft schroffen Gipfeln sind sehr einsam, ursprünglich, wild und artenreich, was insbesondere an fehlenden Zufahrtsstraßen liegt. Das Klima im Gebirge ist rau und nordseitig häufig kalt. Die Temperaturen können aber von über -30°C im Winter bis zu 20°C im Sommer reichen. Die Winter in den Hochlagen sind sehr schneereich und vor allem im Februar und März ideal für einsame Skitouren bei besten Bedingungen geeignet. Ansonsten herrscht in Rumänien ein kontinentales Klima mit heißen Sommern und kalten Wintern. Folgender Wetterdienst gibt Dir einen ganz guten Überblick über das aktuelle Bergwetter in Rumänien und kann Dir dabei helfen, Dich auf Deine Reise nach Rumänien entsprechend vorzubereiten: <ul> <li style="text-align:justify"><a href="https://www.mountain-forecast.com/peaks/Negoiu/forecasts/2535" target="_blank">Mountain Forecast</a></li> </ul>
 travel_info
 entry_customs<h2 style="text-align:center">Einreise & Zoll</h2> Bei Grenzübertritten sind stichprobenartige Personen- und Fahrzeugkontrollen möglich, insbesondere. Ansonsten sind Einschränkungen 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. Da Rumänien zur EU gehört, unterliegt die Warenein- und -ausfuhr den <a href="https://europa.eu/youreurope/citizens/travel/carry/alcohol-tobacco-cash/index_de.htm" target="_blank">Bestimmungen der Europäischen Union.</a> <ul> <li style="text-align:justify">Tipp: <a href="https://www.bundesfinanzministerium.de/Web/DE/Service/Apps_Rechner/Zoll-Reise-App/zoll-reise-app.html" target="_blank">App „Zoll und Reise“</a></li> </ul> <h3 style="text-align:center">Reisedokumente</h3> Die Einreise ist für Staatsangehörige D | A | CH | I mit folgenden Dokumenten möglich. <ul> <li style="text-align:justify">Personalausweis</li> <li style="text-align:justify">Reisepass</li> </ul> (!) Reisedokumente müssen für die gesamte Dauer des Aufenthalts gültig sein!
 visa<h2 style="text-align:center">Visum</h2> Staatsangehörige D | A | CH | I können ohne Visum nach Rumänien einreisen. Informationen zu den aktuellen Einreisebestimmungen für eine Reise nach Rumänien findest Du auch beim<a href="https://www.mae.ro/en/node/2084" target="_blank"> Rumänischen Außenministerium.</a> 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 Rumänien generell gut. Die zentrale Notrufnummer in Rumänien lautet 112. <h3 style="text-align:center">Impfungen</h3> Für die Einreise nach Rumänien gibt es keine Pflichtimpfungen! Grundsätzlich empfehlen sich für weltweite Bergreisen eine Immunisierung gegen Polio, Diphtherie, Keuchhusten und Tetanus. Für weiterführende Informationen zur Reisemedizin empfehlen wir das <a href="https://www.crm.de/aktuell/" target="_blank">Centrum für Reisemedizin (CRM)</a>.
 tours_summer<h2 style="text-align:center">Tourenmöglichkeiten im Sommer</h2> Auch im Sommer ist Rumänien ein lohnenswertes Reiseziel für geführte Wanderungen abseits der Massen. Vor allem das Fagaras Gebirge in den Karpaten Transsilvaniens, in dem wir auch im Winter auf unserer Skitourenreise Rumänien unterwegs sind, bietet anspruchsvolle Bergwanderungen in einer abgelegenen und unberührten Berglandschaft. Ab 2021 haben wir diese geführte Wanderreise im Programm! Solltest Du daran Interesse haben, kontaktiere uns einfach!
 tours_winter<h2 style="text-align:center">Tourenmöglichkeiten im Winter</h2> Einsame Skitouren in einer wilden Berglandschaft mit besten Schneebedingungen. Das findest Du, wenn Du mit uns auf unsere <a href="https://www.alpinewelten.com/skitouren-karpaten-rumaenien?step=tour" target="_blank">Entdecker-Skitourenreise in die rumänischen Karpaten</a> gehst. Die schroffen Berge und sanften Täler des Fagaras Gebirges in den Transsilvanischen Alpen versprechen perfekte Skitourentage. Im Gegensatz zu den Ostalpen sind wir hier fast immer allein unterwegs. Auch kulturell kommt diese Reise nicht zu kurz und wir erleben die Kontraste, die dieses Land zwischen Moderne und Tradition prägen. Eine Reise nach Rumänien ist eine Reise voller Gegensätze. In Verbindung mit der einmalig schönen Natur, die wir auf unseren geführten Skitouren erleben, ein unvergessliches Erlebnis.
 microsite_id(null)
 CountriesNews(array)
 id1193
 news_id71
 country_id173
 position1
 Route(array)
 id4092
 hash843e3172bea92f8b4955b933f5ed0654
 created2020-07-20 14:37:55
 updated2021-03-25 14:51:20
 modelCountry
 foreign_key173
 base/
 aliasrumaenien-reisen
 controllerFrontendCountries.FrontendCountries
 actioncountry
 parent_id(null)
 lft5355
 rght5356
 route/rumaenien-reisen
 FlagUpload(array)
 0(array)
 id396997
 hash04248089da9bcd4d070af311863a03dc
 created2020-09-14 08:51:09
 updated2020-09-14 08:51:15
 modelCountry
 fieldflag
 foreign_key173
 aliasflagge-rumaenien.png
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Country/Flag/5f5f12e3c18e8.png
 size1724
 ext.png
 mimeimage/png
 width550
 height550
 TourMainType(empty)
- contents(array)
 0(array)
 NewsContent(array)
 id60
 hashf12eb12e1c1bad69476cf1d3dd054582
 created2020-10-20 14:28:28
 updated2021-10-15 09:43:50
 titleCorona Lage
 news_id71
 statusactive
 typearticle
 article_content<h1 style="text-align:center">Bergsport & Corona Rumänien</h1> <h2 style="text-align:center">Aktualisierte Informationen</h2> Werden Reisen nach Rumänien durchgeführt: Ja 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)
 id170
 hashb74cc0d511647a2a2b8c4c86f856e1c5
 created2021-07-13 10:09:35
 updated2021-10-15 09:59:17
 titleD
 news_id71
 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/rumaenien-node/rumaeniensicherheit/210822#content_0" 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: Nein Nicht Geimpfte: Testbefreiung Geimpfte: Testbefreiung für vollständig Geimpfte Genesene: Testbefreiung mit Nachweis (6 Monate) Quarantäne bei Einreise: Nein RÜCKREISE NACH DEUTSCHLAND Einreiseformular: Ja (<a href="https://www.einreiseanmeldung.de/#/" target="_blank">Link</a>) Nicht Geimpfte: AntigenSchnelltest (48h) / PCR Test (72h) Geimpfte: Keine Test / Quarantänepflicht Genesene: Test / Quarantänebefreiung mit Nachweis (6 Monate) Quarantäne bei Rückreise: Ja, für Nicht Geimpfte bei Rückkehr aus Hochrisikogebieten. Befreiung am 5. Tag durch 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)
 id171
 hasha6c48917fcbe07870eb68868a95b2091
 created2021-07-13 10:09:45
 updated2021-08-27 10:06:12
 titleAT
 news_id71
 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/rumaenien/" target="_blank">Link</a>) Einstufung: Keine EINREISE INS REISELAND Einreiseformular: Nein Nicht Geimpfte: Testbefreiung Geimpfte: Testbefreiung für vollständig Geimpfte Genesene: Testbefreiung mit Nachweis (6 Monate) Quarantäne bei Einreise: Nein RÜCKREISE NACH ÖSTERREICH Einreiseformular: Ja für Nicht Geimpfte (<a href="https://entry.ptc.gv.at/" target="_blank">Link</a>) Nicht Geimpfte: Testpflicht innerhalb 24h nach Einreise (<a href="https://www.bmeia.gv.at/reise-aufenthalt/coronavirus-covid-19-und-reisen/">Link</a>) Geimpfte: Testbefreiung Genesene: Testbefreiung Quarantäne bei Rückreise: Nein 
 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)
 id172
 hash4d808f92941986dbc911fc75a6aca4fd
 created2021-07-13 10:09:57
 updated2021-08-27 10:06:23
 titleCH
 news_id71
 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/countries/romania/de/home/reisehinweise.html" target="_blank">Link</a>) Einstufung: Keine EINREISE INS REISELAND Einreiseformular: Nein Nicht Geimpfte: Testbefreiung Geimpfte: Testbefreiung für vollständig Geimpfte Genesene: Testbefreiung mit Nachweis (6 Monate) Quarantäne bei Einreise: Nein RÜCKREISE IN DIE SCHWEIZ Einreiseformular: Ja (<a href="https://travelcheck.admin.ch/home" target="_blank">Link</a>) Nicht Geimpfte: AntigenSchnelltest (48h) / PCR Test (72h) (<a href="https://travelcheck.admin.ch/home" target="_blank">Link</a>) Geimpfte: Testbefreiung Genesene: Testbefreiung Quarantäne bei Rückreise: Nein 
 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)
 id205
 hashaee3aa02a64bbd00e6ee618f42822aba
 created2021-07-13 19:19:11
 updated2021-07-20 13:34:14
 titleentscheidungsgrundlagen
 news_id71
 statusactive
 typearticle
 article_contentEntscheidungsgrundlagen: Gesamtcharakter der Reisen: Positiv, Abseits von Menschenansammlungen Regelmäßig vorhandener Flugverkehr: Ja Covid-19 Lage in den Zielgebieten: Gering Hygiene-, Abstands- und Sicherheitsmaßnahmen: Umsetzbar Bisher durchgeführte Reisen: Keine Weitere Informationen: Die Europäische Union hat eine sehr übersichtliche und informative Plattform geschaffen, die einen sehr guten Überblick liefert. <a href="https://reopen.europa.eu/de/map/ROU/2002" target="_blank">Details Rumänien auf der Seite Re-open EU</a> Aktuelle Corona Übersichtskarte Rumänien <a href="https://covid19.geo-spatial.org/" target="_blank">Übersichtskarte Rumänien</a> (Veröffentlicht: 07.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
 22Session
 23HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/alpinewelten.com/httpdocs/
APP_DIR	httpdocs
APPLIBS	/var/www/vhosts/alpinewelten.com/httpdocs/Lib/
CACHE	/var/www/vhosts/alpinewelten.com/httpdocs/tmp/cache/
CAKE	/var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib
CORE_PATH	/var/www/vhosts/alpinewelten.com/httpdocs/contrance/Vendor/Cake/lib/
CAKE_VERSION	2.9.0
CSS	/var/www/vhosts/alpinewelten.com/httpdocs/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://www.bergsteigerschule-zugspitze.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	/rumaenien-bergsport-corona
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/rumaenien-bergsport-corona
Remote Port	44400
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.80.3.192
Server Port	443
Server Addr	85.236.49.170
Server Name	www.bergsteigerschule-zugspitze.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	Sun, 01 Aug 2021 19:21:59 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.80.3.192
Http Host	www.bergsteigerschule-zugspitze.de
Proxy-nokeepalive	1
Https	on
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Http Authorization
Script Uri	https://www.bergsteigerschule-zugspitze.de/rumaenien-bergsport-corona
Script Url	/rumaenien-bergsport-corona
Unique Id	YXA3j7IONCRqGO-IhIA3IgAAAcY
Redirect Status	200
Redirect Https	on
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Http Authorization
Redirect Script Uri	https://www.bergsteigerschule-zugspitze.de/rumaenien-bergsport-corona
Redirect Script Url	/rumaenien-bergsport-corona
Redirect Unique Id	YXA3j7IONCRqGO-IhIA3IgAAAcY
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Script Uri	https://www.bergsteigerschule-zugspitze.de/rumaenien-bergsport-corona
Redirect Redirect Script Url	/rumaenien-bergsport-corona
Redirect Redirect Unique Id	YXA3j7IONCRqGO-IhIA3IgAAAcY
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1634744207.6959
Request Time	1634744207

====

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 Rumänien

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: 21 ms Total Queries: 128 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 21 ms
Total Queries: 128 queries