MTB Fahrtechnik Wochenende Ulm
MTB Fahrtechnik Level I-III Kurs in Ulm, um Ulm und um Ulm herum

MTB Fahrtechnik Level I-III

Je besser Deine Fahrtechnik ist, umso mehr Freude wirst Du mit Deinem Bike haben. Grund genug also, um an einem unserer Mountainbike Fahrtechnik Kurse teilzunehmen, denn Ausdauer ist beim Mountainbiken noch lange nicht alles. Unser MTB Fahrtechnik Kurs Wochenende vermittelt Dir die Kursinhalte Level I bis Level III und bereitet Dich so ideal auf Deine zukünftigen Trails vor.
Gerne organisieren wir Deine Hotelübernachtung.

• Kleine Gruppen max. 6 Teilnehmer
• Auf Wunsch mit Hotelübernachtung
• Ausbildung durch lizensierten MTB-Guide

Anforderungen

Für das Mountainbike Fahrtechnik Wochenende solltest Du über Kondition für Tagesetappen von 20 km und ca 200 Hm verfügen. Du verfügst über ein funktionsfähiges Bike mit grobstolliger Bereifung (keine abgefahrenen Reifen) und Sattelschnellspanner. Außerdem benötigst Du Helm und Handschuhe sowie ggf. eine Radbrille und Radbekleidung. Bei ungünstiger Wetterlage behalten wir uns eine Absage des Kurses vor.

Ausführliche Information zur Schwierigkeitsbewertung von Bergtouren

Reiseprogramm

1. Tag:

Individuelle Anreise und Treffpunkt am Morgen in Ulm an der Straßenbahnhaltestelle Donauhalle beim Hotel Lago. Nach einem Bike-Check starten wir mit den ersten Aufgaben und Übungen zur Verbesserung Deines Bike-Handlings. Dabei stehen Deine Kompetenzen im Bereich Balance und Koordination im Mittelpunkt. Nach der Mittagspause in einem nahe gelegenen Lokal starten wir in das Themengebiet Level II wo wir anspruchsvolle Fahrmanöver angehen und durchführen, wie z. B. steil bergauf und bergab fahren, bergauf Anfahren, Stufen, Teppen usw. Dabei geht Dein Guide ganz individuell auf Dich ein. Übernachtung auf Wunsch im Hotel oder individuelle Heimreise am Nachmittag.

2. Tag:
Morgens starten wir, um spannende Trails rund um Ulm zu erkunden. Nun heißt es, die vom Vortag erworbenen Kenntnisse ins Gelände umzusetzen und zu vertiefen. Mit individuellen Korrekturen und Tipps verbessern wir Deine Fahrtechnik und erarbeiten uns die Technikinhalte des Level III. Verabschiedung und Heimreise am frühen Nachmittag.

Leistungen & Zusatzkosten

Leistungen inklusive

2 Tage Organisation und Führung durch einen lizenzierten MTB-Guide
AW Plus Paket | Reservierung | Komfort | Sicherheit

Reiseoptionen

Freiwilliger myclimate Klimaschutzbeitrag 9 €

Beschreibung der Region

Ausbildungsthemen im Kurs

Level I:
Neutrale Position, richtiges Bremsen, Kurventechnik, Balance (der Schlüssel zum Erfolg), Überwinden kleiner Hindernisse sowie individuelle Korrekturen und Tipps rund ums Mountainbike.

Level II:
Verbesserung der Brems- und Kurventechnik und der Balance im schwierigeren Gelände, Überwinden von Hindernissen, richtig Bergauf und Bergab fahren, individuelle Korrekturen.

Level III:
Balance, Brems- und Kurventechnik in Trailpassagen, Befahren von Wurzelpassagen, stufiges und verblocktes Gelände, Spitzkehren, steil Bergauf und Bergab, individuelle Korrekturen.

ab 149,00 €

Tourdauer:

2 Tage

Teilnehmer:

min. 4, max. 6

Land:

Deutschland

Alpine-Erfahrung:

Anforderungen:

Kondition

Technik

Ernsthaftigkeit

Schwierigkeit

1.0

Tourtermine:

Dein Wunschtermin ist nicht dabei? Dann frag gleich bei uns nach einem individuellen Termin Wunschtermin beantragen

Noch Fragen?

Antworten zu häufig gestellten Fragen findest Du hier in den Themenbereichen:

Cookie Einstellungen

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

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

Weitere Informationen findest Du in unserer Datenschutzerklärung.

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent702e6d7fd00a6f14bcc094a4c956d69f
  time1582088990
  countdown10
- _Token(array)
  keye3138eb0d4c4d756a7692ee22ee8435d9343d7ed7bc5c80838dd79129069997f1d77191daa9995f9b6207d3cd42a7830d7fe747c67540a07788150b2a55bd6a7
  allowedControllers(empty)
  allowedActions(empty)
  unlockedFields(empty)
  csrfTokens(array)
  e3138eb0d4c4d756a7692ee22ee8435d9343d7ed7bc5c80838dd79129069997f1d77191daa9995f9b6207d3cd42a7830d7fe747c67540a07788150b2a55bd6a71582076390
====
Request
+
Request

Cake Params
- pluginFrontendTours
- controllerFrontendTours
- actiontour
- named(empty)
- pass(array)
  0127
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  Tour127
- route(array)
  id139
  hash5e443a1eb4720bb9208d5bf2df698d89
  created2016-08-12 17:20:30
  updated2019-09-02 11:23:21
  modelTour
  foreign_key127
  base/
  aliasmtb-fahrtechnik
  controllerFrontendTours.FrontendTours
  actiontour
  parent_id(null)
  lft2391
  rght2392
  route/mtb-fahrtechnik
- isAjax(false)
- _Token(array)
  keye3138eb0d4c4d756a7692ee22ee8435d9343d7ed7bc5c80838dd79129069997f1d77191daa9995f9b6207d3cd42a7830d7fe747c67540a07788150b2a55bd6a7
  unlockedFields(empty)
Post data

No post data.

Query string
- steptour
Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0model
  1id
- options(array)
  pass(array)
  0model
  1id
  modeltour|tourdate
  tourDateId[0-9]+
- defaults(array)
  pluginfrontend_tours
  controllerfrontend_tours
  actiontravel_program
- template/!travel-program/:model/:id
====

Sql Log

Sql Logs

default

Total Time: 4 ms
Total Queries: 60 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`))) = '/mtb-fahrtechnik' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`lft` <= 2391 AND `Route`.`rght` >= 2392 ORDER BY `Route`.`lft` asc	1	1	0
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`	45	45	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, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`languages` AS `Language` WHERE `Language`.`title` = 'www.alpinewelten.com' LIMIT 1	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'faq' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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` > 59 AND `Menu`.`rght` < 112 ORDER BY `Menu`.`lft` asc	26	26	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	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` = 'trigger' AND `EmailTemplate`.`trigger_type` = 'remaining_payment_reminder' LIMIT 1	1	1	0
SELECT `Tour`., `FirmsTour`., `Firm`.`id`, `Tour`.`id`, (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` FROM `alpinewelten`.`tours` AS `Tour` LEFT JOIN `alpinewelten`.`firms` AS `Firm` ON (`Tour`.`firm_id` = `Firm`.`id`) LEFT JOIN `alpinewelten`.`tour_texts` AS `TourTexts` ON (`TourTexts`.`tour_id` = `Tour`.`id`) LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Tour`.`id` AND `Route`.`model` = 'Tour') LEFT JOIN `alpinewelten`.`firms_tours` AS `FirmsTour` ON (`FirmsTour`.`tour_id` = `Tour`.`id` AND `FirmsTour`.`firm_id` = '1') WHERE `Tour`.`id` = 127 LIMIT 1	1	1	0
SELECT `LogoMedia`.`id`, `LogoMedia`.`hash`, `LogoMedia`.`created`, `LogoMedia`.`updated`, `LogoMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoMedia`.`id`) AS `LogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `LogoMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `LogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Firm' AND `MediaEntity`.`field` = 'logo' 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` = (3848) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_detail_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_travel_report`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview` FROM `alpinewelten`.`tour_texts` AS `TourTexts` WHERE `TourTexts`.`tour_id` = 127	1	1	0
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `alpinewelten`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 127 AND `Route`.`model` = 'Tour'	1	1	0
SELECT `TourDate`.`id`, `TourDate`.`hash`, `TourDate`.`created`, `TourDate`.`updated`, `TourDate`.`status`, `TourDate`.`tour_id`, `TourDate`.`tour_date_number`, `TourDate`.`title`, `TourDate`.`subtitle`, `TourDate`.`participants_min`, `TourDate`.`participants_max`, `TourDate`.`duration_days`, `TourDate`.`tour_price`, `TourDate`.`down_payment`, `TourDate`.`country_of_service`, `TourDate`.`saison`, `TourDate`.`travel_insurance_certificate`, `TourDate`.`rating_condition`, `TourDate`.`rating_technique`, `TourDate`.`rating_experience`, `TourDate`.`rating_difficulty_category`, `TourDate`.`start_zip`, `TourDate`.`start_city`, `TourDate`.`start_street`, `TourDate`.`start_country`, `TourDate`.`start_meeting_point`, `TourDate`.`start_time`, `TourDate`.`end_alternate_address`, `TourDate`.`end_time`, `TourDate`.`flight`, `TourDate`.`flight_details`, `TourDate`.`region_id`, `TourDate`.`date_start`, `TourDate`.`mountain_guide_status`, `TourDate`.`manual_booking_status`, `TourDate`.`participant_list_visible`, `TourDate`.`speciality`, `TourDate`.`special_features`, `TourDate`.`mountain_guide_tour_info`, `TourDate`.`customer_tour_info`, `TourDate`.`ws_text_requirements`, `TourDate`.`ws_text_travel_program`, `TourDate`.`ws_text_accomodation`, `TourDate`.`ws_text_services`, `TourDate`.`rating_seriousness`, `TourDate`.`rating_overall_score`, `TourDate`.`infotext_booking`, `TourDate`.`last_minute`, `TourDate`.`travel_information`, `TourDate`.`meeting_point_map_lat`, `TourDate`.`meeting_point_map_marker`, `TourDate`.`meeting_point_map_type`, `TourDate`.`meeting_point_map_zoom`, `TourDate`.`meeting_point_map_long`, `TourDate`.`participant_list_visible2`, `TourDate`.`cancelled`, `TourDate`.`days_before_start_for_last_notice`, `TourDate`.`execution_feasibility`, `TourDate`.`days_before_start_for_cancellation`, `TourDate`.`ws_text_overview`, `TourDate`.`mountain_guide_tour_search_information`, `TourDate`.`allow_double_assignment`, `TourDate`.`customer_tour_material_info`, `TourDate`.`material_list_link`, `TourDate`.`minimum_reached_notification`, (CONCAT_WS (',',`TourDate`.`meeting_point_map_lat`,`TourDate`.`meeting_point_map_long`)) AS `TourDate__meeting_point_map`, (COALESCE(`TourDate`.`end_zip`, `TourDate`.`start_zip`)) AS `TourDate__end_zip`, (COALESCE(`TourDate`.`end_city`, `TourDate`.`start_city`)) AS `TourDate__end_city`, (COALESCE(`TourDate`.`end_street`, `TourDate`.`start_street`)) AS `TourDate__end_street`, (COALESCE(`TourDate`.`end_country`, `TourDate`.`start_country`)) AS `TourDate__end_country`, (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) AS `TourDate__date_end`, (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')) AS `TourDate__count_participants`, (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`) AS `TourDate__count_mountain_guides`, (CONCAT((SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')), " + " , (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`))) AS `TourDate__participants_booked`, (CASE (GREATEST ((CASE WHEN `TourDate`.`manual_booking_status` = "none" THEN 0 WHEN `TourDate`.`manual_booking_status` = "places_free" THEN 1 WHEN `TourDate`.`manual_booking_status` = "few_places_free" THEN 2 WHEN `TourDate`.`manual_booking_status` = "one_place_free" THEN 3 WHEN `TourDate`.`manual_booking_status` = "booked_up" THEN 4 WHEN `TourDate`.`manual_booking_status` = "waiting_list" THEN 5 END), (CASE WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = `TourDate`.`participants_max` - 1 ) THEN 3 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) < `TourDate`.`participants_min` ) THEN 1 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_max` ) THEN 4 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_min` ) THEN 2 END)))WHEN 0 THEN "none" WHEN 1 THEN "places_free" WHEN 2 THEN "few_places_free" WHEN 3 THEN "one_place_free" WHEN 4 THEN "booked_up" WHEN 5 THEN "waiting_list" END) AS `TourDate__booking_status`, ( IF( `TourDate`.`cancelled`, 'canceled', IF((SELECT SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) > 0 AND SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) = SUM(IF(`Booking`.`status` NOT IN ('new_from_website', 'waiting_list', 'called_off', 'canceled'), 1, 0)) FROM bookings AS Booking WHERE `Booking`.`tour_date_id` = `TourDate`.`id`), 'completed', 'in_process') )) AS `TourDate__processing_status`, (`TourDate`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tour_dates AS TourTravelOptionXTourDates inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTourDates`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTourDates`.`tour_date_id` = `TourDate`.`id`), 0)) AS `TourDate__price_excl_flight` FROM `alpinewelten`.`tour_dates` AS `TourDate` WHERE `TourDate`.`date_start` > CURDATE() AND `TourDate`.`status` = 'active' AND `TourDate`.`tour_id` = (127) ORDER BY `TourDate`.`date_start` ASC	0	0	2	maybe slow
SELECT `Services`.`id`, `Services`.`hash`, `Services`.`created`, `Services`.`updated`, `Services`.`title`, `Services`.`description`, `Services`.`type`, (SELECT COUNT(1) FROM tour_services_tours AS TourServiceCrossTab WHERE `TourServiceCrossTab`.`tour_service_id` = `Services`.`id`) AS `Services__tour_count`, `TourServicesTour`.`id`, `TourServicesTour`.`tour_id`, `TourServicesTour`.`tour_service_id`, `TourServicesTour`.`type`, `TourServicesTour`.`price`, `TourServicesTour`.`position` FROM `alpinewelten`.`tour_services` AS `Services` JOIN `alpinewelten`.`tour_services_tours` AS `TourServicesTour` ON (`TourServicesTour`.`tour_id` = 127 AND `TourServicesTour`.`tour_service_id` = `Services`.`id`)	2	2	0
SELECT `TravelOptions`.`id`, `TravelOptions`.`hash`, `TravelOptions`.`created`, `TravelOptions`.`updated`, `TravelOptions`.`title`, `TravelOptions`.`description`, `TravelOptions`.`type`, (SELECT COUNT(1) FROM tour_travel_options_tours AS TourTravelOptionCrossTab WHERE `TourTravelOptionCrossTab`.`tour_travel_option_id` = `TravelOptions`.`id`) AS `TravelOptions__tour_count`, `TourTravelOptionsTour`.`id`, `TourTravelOptionsTour`.`tour_id`, `TourTravelOptionsTour`.`tour_travel_option_id`, `TourTravelOptionsTour`.`price`, `TourTravelOptionsTour`.`position` FROM `alpinewelten`.`tour_travel_options` AS `TravelOptions` JOIN `alpinewelten`.`tour_travel_options_tours` AS `TourTravelOptionsTour` ON (`TourTravelOptionsTour`.`tour_id` = 127 AND `TourTravelOptionsTour`.`tour_travel_option_id` = `TravelOptions`.`id`)	1	1	0
SELECT `Countries`.`id`, `Countries`.`hash`, `Countries`.`created`, `Countries`.`updated`, `Countries`.`title`, `Countries`.`abbreviation`, `CountriesTour`.`id`, `CountriesTour`.`country_id`, `CountriesTour`.`tour_id` FROM `alpinewelten`.`countries` AS `Countries` JOIN `alpinewelten`.`countries_tours` AS `CountriesTour` ON (`CountriesTour`.`tour_id` = 127 AND `CountriesTour`.`country_id` = `Countries`.`id`)	1	1	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` = 127 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	6	6	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (3273, 3280, 3277, 3272, 3284, 3282) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	48	48	0
SELECT `AccomodationImagesMedia`.`id`, `AccomodationImagesMedia`.`hash`, `AccomodationImagesMedia`.`created`, `AccomodationImagesMedia`.`updated`, `AccomodationImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `AccomodationImagesMedia`.`id`) AS `AccomodationImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `AccomodationImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 127 AND `MediaEntity`.`media_id` = `AccomodationImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Tour' AND `MediaEntity`.`field` = 'accomodation_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `OutputChannel`.`id`, `OutputChannel`.`hash`, `OutputChannel`.`created`, `OutputChannel`.`updated`, `OutputChannel`.`title`, `OutputChannel`.`abbreviation`, `OutputChannel`.`oa_offerer_id`, `FirmsTour`.`id`, `FirmsTour`.`firm_id`, `FirmsTour`.`tour_id`, `FirmsTour`.`position` FROM `alpinewelten`.`firms` AS `OutputChannel` JOIN `alpinewelten`.`firms_tours` AS `FirmsTour` ON (`FirmsTour`.`tour_id` = 127 AND `FirmsTour`.`firm_id` = `OutputChannel`.`id`) ORDER BY `FirmsTour`.`position` ASC	1	1	0
SELECT `TourFaqItemsForCustomer`.`id`, `TourFaqItemsForCustomer`.`hash`, `TourFaqItemsForCustomer`.`created`, `TourFaqItemsForCustomer`.`updated`, `TourFaqItemsForCustomer`.`title`, `TourFaqItemsForCustomer`.`target_group`, `TourFaqItemsForCustomer`.`tags`, `TourFaqItemsForCustomer`.`question`, `TourFaqItemsForCustomer`.`answer`, `TourFaqItemsForCustomer`.`login_required`, `FaqItemsTour`.`id`, `FaqItemsTour`.`tour_id`, `FaqItemsTour`.`faq_item_id`, `FaqItemsTour`.`position`, `FaqItemsTour`.`for` FROM `alpinewelten`.`faq_items` AS `TourFaqItemsForCustomer` JOIN `alpinewelten`.`faq_items_tours` AS `FaqItemsTour` ON (`FaqItemsTour`.`tour_id` = 127 AND `FaqItemsTour`.`faq_item_id` = `TourFaqItemsForCustomer`.`id`) WHERE `FaqItemsTour`.`for` = 'customer' AND `login_required` = '0' ORDER BY `FaqItemsTour`.`position` ASC	0	0	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`.`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`))) = '/!travel-program/tour/127' LIMIT 1	0	0	0
SELECT `Redirect`.`id`, `Redirect`.`hash`, `Redirect`.`created`, `Redirect`.`updated`, `Redirect`.`route`, `Redirect`.`type`, `Redirect`.`auto`, `Redirect`.`route_id`, `Redirect`.`url` FROM `alpinewelten`.`redirects` AS `Redirect` WHERE `Redirect`.`route` = '/!travel-program/tour/127' LIMIT 1	0	0	0
SELECT `Tour`.`id`, `Tour`.`hash`, `Tour`.`created`, `Tour`.`updated`, `Tour`.`tour_number`, `Tour`.`title`, `Tour`.`subtitle`, `Tour`.`participants_min`, `Tour`.`participants_max`, `Tour`.`duration_days`, `Tour`.`duration_type`, `Tour`.`tour_price`, `Tour`.`down_payment`, `Tour`.`country_of_service`, `Tour`.`saison`, `Tour`.`travel_insurance_certificate`, `Tour`.`out_of_alpine_tour`, `Tour`.`rating_condition`, `Tour`.`rating_technique`, `Tour`.`rating_experience`, `Tour`.`rating_difficulty_category`, `Tour`.`rating_seriousness`, `Tour`.`rating_overall_score`, `Tour`.`start_zip`, `Tour`.`start_city`, `Tour`.`start_street`, `Tour`.`start_country`, `Tour`.`start_meeting_point`, `Tour`.`start_time`, `Tour`.`end_alternate_address`, `Tour`.`end_time`, `Tour`.`flight`, `Tour`.`flight_details`, `Tour`.`consultation`, `Tour`.`region_id`, `Tour`.`services_excluded`, `Tour`.`mountain_guide_tour_info`, `Tour`.`video_url`, `Tour`.`customer_tour_info`, `Tour`.`firm_id`, `Tour`.`gmap_zoom`, `Tour`.`gmap_long`, `Tour`.`gmap_marker`, `Tour`.`gmap_type`, `Tour`.`gmap_lat`, `Tour`.`callout_icon`, `Tour`.`travel_information`, `Tour`.`meeting_point_map_lat`, `Tour`.`meeting_point_map_marker`, `Tour`.`meeting_point_map_type`, `Tour`.`meeting_point_map_zoom`, `Tour`.`meeting_point_map_long`, `Tour`.`previous_url`, `Tour`.`packing_list_text_end`, `Tour`.`packing_list_text_start`, `Tour`.`days_before_start_for_cancellation`, `Tour`.`execution_feasibility`, `Tour`.`days_before_start_for_last_notice`, `Tour`.`last_tour_date_number`, `Tour`.`tourstart_weekday`, `Tour`.`mountain_guide_tour_search_information`, `Tour`.`customer_tour_material_info`, `Tour`.`material_list_link`, (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`, `TourTexts`.`id`, `TourTexts`.`hash`, `TourTexts`.`created`, `TourTexts`.`updated`, `TourTexts`.`tour_id`, `TourTexts`.`ws_text_short_description`, `TourTexts`.`ws_text_detail_description`, `TourTexts`.`ws_text_requirements`, `TourTexts`.`ws_text_travel_program`, `TourTexts`.`ws_text_services`, `TourTexts`.`ws_text_travel_report`, `TourTexts`.`ws_text_information`, `TourTexts`.`ws_text_location_description`, `TourTexts`.`ws_text_accomodation`, `TourTexts`.`ws_text_course_content`, `TourTexts`.`ws_text_overview` FROM `alpinewelten`.`tours` AS `Tour` LEFT JOIN `alpinewelten`.`tour_texts` AS `TourTexts` ON (`TourTexts`.`tour_id` = `Tour`.`id`) WHERE `Tour`.`id` = 127 LIMIT 1	1	1	0
SELECT `Accomodations`.`id`, `Accomodations`.`hash`, `Accomodations`.`created`, `Accomodations`.`updated`, `Accomodations`.`number`, `Accomodations`.`name`, `Accomodations`.`type`, `Accomodations`.`owners`, `Accomodations`.`phone_cabin`, `Accomodations`.`phone_valley`, `Accomodations`.`mobile`, `Accomodations`.`fax`, `Accomodations`.`email`, `Accomodations`.`url`, `Accomodations`.`zip`, `Accomodations`.`city`, `Accomodations`.`street`, `Accomodations`.`country`, `Accomodations`.`region_area_id`, `Accomodations`.`remark`, `Accomodations`.`geopoint_lat`, `Accomodations`.`geopoint_long`, `Accomodations`.`cancellation_period`, `Accomodations`.`tighter_cancellation_period`, `Accomodations`.`status`, `Accomodations`.`subline`, `Accomodations`.`height`, `Accomodations`.`video_url`, `Accomodations`.`opening_hours`, `Accomodations`.`premises`, `Accomodations`.`equipment`, `Accomodations`.`currency`, `Accomodations`.`detail_description`, `Accomodations`.`days_before_to_send_participant_list`, (CONCAT_WS (',',`Accomodations`.`geopoint_lat`,`Accomodations`.`geopoint_long`)) AS `Accomodations__geopoint`, `AccomodationsTour`.`id`, `AccomodationsTour`.`tour_id`, `AccomodationsTour`.`accomodation_id`, `AccomodationsTour`.`overnight_stay`, `AccomodationsTour`.`number_participants`, `AccomodationsTour`.`number_mountain_guides`, `AccomodationsTour`.`reservation_type`, `AccomodationsTour`.`base_camp` FROM `alpinewelten`.`accomodations` AS `Accomodations` JOIN `alpinewelten`.`accomodations_tours` AS `AccomodationsTour` ON (`AccomodationsTour`.`tour_id` = 127 AND `AccomodationsTour`.`accomodation_id` = `Accomodations`.`id`)	0	0	0
SELECT `TourDate`.`id`, `TourDate`.`hash`, `TourDate`.`created`, `TourDate`.`updated`, `TourDate`.`status`, `TourDate`.`tour_id`, `TourDate`.`tour_date_number`, `TourDate`.`title`, `TourDate`.`subtitle`, `TourDate`.`participants_min`, `TourDate`.`participants_max`, `TourDate`.`duration_days`, `TourDate`.`tour_price`, `TourDate`.`down_payment`, `TourDate`.`country_of_service`, `TourDate`.`saison`, `TourDate`.`travel_insurance_certificate`, `TourDate`.`rating_condition`, `TourDate`.`rating_technique`, `TourDate`.`rating_experience`, `TourDate`.`rating_difficulty_category`, `TourDate`.`start_zip`, `TourDate`.`start_city`, `TourDate`.`start_street`, `TourDate`.`start_country`, `TourDate`.`start_meeting_point`, `TourDate`.`start_time`, `TourDate`.`end_alternate_address`, `TourDate`.`end_time`, `TourDate`.`flight`, `TourDate`.`flight_details`, `TourDate`.`region_id`, `TourDate`.`date_start`, `TourDate`.`mountain_guide_status`, `TourDate`.`manual_booking_status`, `TourDate`.`participant_list_visible`, `TourDate`.`speciality`, `TourDate`.`special_features`, `TourDate`.`mountain_guide_tour_info`, `TourDate`.`customer_tour_info`, `TourDate`.`ws_text_requirements`, `TourDate`.`ws_text_travel_program`, `TourDate`.`ws_text_accomodation`, `TourDate`.`ws_text_services`, `TourDate`.`rating_seriousness`, `TourDate`.`rating_overall_score`, `TourDate`.`infotext_booking`, `TourDate`.`last_minute`, `TourDate`.`travel_information`, `TourDate`.`meeting_point_map_lat`, `TourDate`.`meeting_point_map_marker`, `TourDate`.`meeting_point_map_type`, `TourDate`.`meeting_point_map_zoom`, `TourDate`.`meeting_point_map_long`, `TourDate`.`participant_list_visible2`, `TourDate`.`cancelled`, `TourDate`.`days_before_start_for_last_notice`, `TourDate`.`execution_feasibility`, `TourDate`.`days_before_start_for_cancellation`, `TourDate`.`ws_text_overview`, `TourDate`.`mountain_guide_tour_search_information`, `TourDate`.`allow_double_assignment`, `TourDate`.`customer_tour_material_info`, `TourDate`.`material_list_link`, `TourDate`.`minimum_reached_notification`, (CONCAT_WS (',',`TourDate`.`meeting_point_map_lat`,`TourDate`.`meeting_point_map_long`)) AS `TourDate__meeting_point_map`, (COALESCE(`TourDate`.`end_zip`, `TourDate`.`start_zip`)) AS `TourDate__end_zip`, (COALESCE(`TourDate`.`end_city`, `TourDate`.`start_city`)) AS `TourDate__end_city`, (COALESCE(`TourDate`.`end_street`, `TourDate`.`start_street`)) AS `TourDate__end_street`, (COALESCE(`TourDate`.`end_country`, `TourDate`.`start_country`)) AS `TourDate__end_country`, (DATE_ADD(`TourDate`.`date_start`, INTERVAL `TourDate`.`duration_days` DAY)) AS `TourDate__date_end`, (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')) AS `TourDate__count_participants`, (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`) AS `TourDate__count_mountain_guides`, (CONCAT((SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information')), " + " , (SELECT COUNT(`MountainGuidesForCount`.`id`) FROM mountain_guides AS MountainGuidesForCount JOIN `alpinewelten`.`mountain_guides_tour_dates` AS `MGxTD` ON (`MountainGuidesForCount`.`id` = `MGxTD`.`mountain_guide_id`) WHERE `MGxTD`.`tour_date_id` = `TourDate`.`id`))) AS `TourDate__participants_booked`, (CASE (GREATEST ((CASE WHEN `TourDate`.`manual_booking_status` = "none" THEN 0 WHEN `TourDate`.`manual_booking_status` = "places_free" THEN 1 WHEN `TourDate`.`manual_booking_status` = "few_places_free" THEN 2 WHEN `TourDate`.`manual_booking_status` = "one_place_free" THEN 3 WHEN `TourDate`.`manual_booking_status` = "booked_up" THEN 4 WHEN `TourDate`.`manual_booking_status` = "waiting_list" THEN 5 END), (CASE WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) = `TourDate`.`participants_max` - 1 ) THEN 3 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) < `TourDate`.`participants_min` ) THEN 1 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_max` ) THEN 4 WHEN ( (SELECT COUNT(`FellowTraveller`.`id`) + COUNT(DISTINCT `Booking`.`id`) FROM bookings AS Booking LEFT JOIN `alpinewelten`.`fellow_travellers` AS `FellowTraveller` ON (`FellowTraveller`.`booking_id` = `Booking`.`id`) WHERE `Booking`.`tour_date_id` = `TourDate`.`id` AND `Booking`.`status` IN ('confirmed', 'last_information') ) >= `TourDate`.`participants_min` ) THEN 2 END)))WHEN 0 THEN "none" WHEN 1 THEN "places_free" WHEN 2 THEN "few_places_free" WHEN 3 THEN "one_place_free" WHEN 4 THEN "booked_up" WHEN 5 THEN "waiting_list" END) AS `TourDate__booking_status`, ( IF( `TourDate`.`cancelled`, 'canceled', IF((SELECT SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) > 0 AND SUM(IF(`Booking`.`status` IN ('last_information'), 1, 0)) = SUM(IF(`Booking`.`status` NOT IN ('new_from_website', 'waiting_list', 'called_off', 'canceled'), 1, 0)) FROM bookings AS Booking WHERE `Booking`.`tour_date_id` = `TourDate`.`id`), 'completed', 'in_process') )) AS `TourDate__processing_status`, (`TourDate`.`tour_price`+COALESCE((SELECT price FROM tour_travel_options_tour_dates AS TourTravelOptionXTourDates inner JOIN `alpinewelten`.`tour_travel_options` AS `TourTravelOptionForCond` ON (`TourTravelOptionXTourDates`.`tour_travel_option_id` = `TourTravelOptionForCond`.`id` AND `TourTravelOptionForCond`.`type` = 'price_flight') WHERE `TourTravelOptionXTourDates`.`tour_date_id` = `TourDate`.`id`), 0)) AS `TourDate__price_excl_flight` FROM `alpinewelten`.`tour_dates` AS `TourDate` WHERE `TourDate`.`id` IS NULL LIMIT 1	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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` > 10 AND `Menu`.`rght` < 199 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	70	70	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'tour_list' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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` > 200 AND `Menu`.`rght` < 275 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	37	37	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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` > 286 AND `Menu`.`rght` < 451 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	82	82	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'aw' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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` = 'Tour' AND `Seo`.`foreign_key` = 127 LIMIT 1	1	1	1
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` = 127 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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` = 1 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 204 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (3217) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (2312) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	12	12	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `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	35	35	0
SELECT *, Language.id FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `alpinewelten`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `alpinewelten`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'search' AND `Language`.`langid` = 'aw' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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` = 11 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 218 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `alpinewelten`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (471) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`) AS `ImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `ImageMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 17 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `alpinewelten`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `alpinewelten`.`media` AS `HeaderImagesMedia` JOIN `alpinewelten`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 11 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'search' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'difficulty-rating' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'contact' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `Language`.`firm_id` FROM `alpinewelten`.`mount_points` AS `MountPoint` LEFT JOIN `alpinewelten`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `alpinewelten`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'aw' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 16.12 MB

Message	Memory use
Component initialization	2.07 MB
Controller action start	3.10 MB
Component initialization #2	5.67 MB
Controller action start #2	5.70 MB
Controller render start	5.95 MB
View render complete	7.87 MB

Timers

Total Request Time: 203 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	16.01
Event: Controller.initialize	10.63
Event: Controller.startup	0.74
Controller action	42.59
» Event: Controller.initialize #2	0.96
» Event: Controller.startup #2	0.14
Controller action #2	0.00
» » Event: Controller.shutdown	0.02
» Event: Controller.beforeRender	52.20
» » Processing toolbar data	32.88
» Rendering View	27.93
» » Event: View.beforeRender	0.03
» » Rendering APP/Plugin/FrontendTours/View/FrontendTours/tour.php	17.79
» » » Rendering APP/Plugin/FrontendContents/View/Elements/gallery.php	1.68
» » » Rendering APP/Plugin/FrontendContents/View/Elements/tour-service-item.php	0.15
» » » Rendering APP/Plugin/FrontendContents/View/Elements/tour-service-item.php #2	0.13
» » » Rendering APP/Plugin/FrontendTours/View/Elements/tour_price.php	0.20
» » Rendering APP/Plugin/FrontendTours/View/FrontendTours/base.php	0.19
» » Event: View.afterRender	0.09
» » Event: View.beforeLayout	0.02
» » Rendering APP/View/Layouts/1.php	8.25
» » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	0.62
» » » Rendering APP/View/Elements/logo-alpine-welten.php	0.13
» » » Rendering APP/View/Elements/logo-ivbv.php	0.16
» » » Rendering APP/View/Elements/logo-alpine-welten.php #2	0.10
» » » Rendering APP/View/Elements/logo-bergsteigerschule-zugspitze.php	0.11
» » » Rendering APP/View/Elements/logo-bergsteigerschule-watzmann.php	0.11
» » » Rendering APP/View/Elements/logo-facebook.php	0.10
» » » Rendering APP/View/Elements/logo-twitter.php	0.15
» » » Rendering APP/View/Elements/logo-youtube.php	0.11
» » » Rendering APP/View/Elements/logo-instagram.php	0.11
» » » Rendering APP/View/Elements/logo-adidas-terrex.php	0.10
» » » Rendering APP/View/Elements/logo-adidas-eyewear.php	0.16
» » » Rendering APP/View/Elements/logo-petzl.php	0.12
» » » Rendering APP/View/Elements/logo-pieps.php	0.11
» » » Rendering APP/View/Elements/logo-kaestle.php	0.11
» » » Rendering APP/View/Elements/logo-diamir.php	0.11
» » » Rendering APP/View/Elements/logo-komperdell.php	0.13
» » » Rendering APP/View/Elements/logo-scarpa.php	0.11
» » » Rendering APP/View/Elements/logo-exped.php	0.11
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- _wizardVars(array)
 steps(array)
 0tour
 1tour_date
 2login
 3customer
 6overview
 currentSteptour
 redirectUrl(array)
 route139
 queryNamestep
 stepTranslation(array)
 tourTour
 loginAnmelden
 customerPersönliche Daten
 tour_dateTourtermin
 fellow_travellersMitreisende
 optionsReiseoptionen
 insuranceReiseversicherung
 overviewÜberprüfen & Buchen
- canonicalUrl(null)
- row(array)
 Tour(array)
 id127
 hashcec1caaef2ac104ee1ea0e5a8d2662e4
 created2016-06-22 08:11:20
 updated2019-09-02 11:23:19
 tour_number416000000127
 titleMTB Fahrtechnik Wochenende Ulm
 subtitleMTB Fahrtechnik Level I-III Kurs in Ulm, um Ulm und um Ulm herum
 participants_min4
 participants_max6
 duration_days1
 duration_typeweekend_tour
 tour_price149.00
 down_payment20
 country_of_servicegermany
 saisonsummer
 travel_insurance_certificate(false)
 out_of_alpine_tour(false)
 rating_condition1
 rating_technique1
 rating_experience1
 rating_difficulty_categoryeasy
 rating_seriousness0
 rating_overall_score1.0
 start_zip89073
 start_cityUlm
 start_streetFriedrichsau 50
 start_countryDE
 start_meeting_pointTreffpunkt zum Kurs ist an der Straßenbahn-Haltestelle Donauhalle in Ulm (gegenüber ist das Hotel Lago).
 start_time09:00:00
 end_alternate_address(false)
 end_zip89073
 end_cityUlm
 end_streetFriedrichsau 50
 end_countryDE
 end_time16:00:00
 flight(false)
 flight_details(null)
 consultation
 region_id8
 services_excluded• Zusatzkosten für Übernachtung • Zusatzkosten für Getränke und Verpflegung
 mountain_guide_tour_info
 video_url
 customer_tour_info
 firm_id1
 gmap_zoom12
 gmap_long10.005871
 gmap_marker(true)
 gmap_typeoa_topo
 gmap_lat48.403885
 callout_iconnone
 travel_information<h3>Bahnanreise:</h3> Die Anreise nach Ulm ist auch mit öffentlichen Verkehrsmitteln recht gut möglich. Ulm ist aus Richtung Stuttgart oder München sehr gut mit dem ICE erreichbar. Auf dem Vorplatz des Ulmer Hauptbahnhofs steigst Du um in die Straßenbahn Linie 1 (Richtung Böfingen) und fährst in ca. 10 Minuten bis zur Haltestelle Donauhalle, wo auch der Treffpunkt für den Kurs ist.
 meeting_point_map_lat48.411976
 meeting_point_map_marker(true)
 meeting_point_map_typeoa_topo
 meeting_point_map_zoom10
 meeting_point_map_long10.012394
 previous_urlhttp://www.alpinewelten.com/de/gefuehrte-tour/mtb-fahrtechnik-blautal/#content_top
 packing_list_text_end <h2>Unser Shop - Partner</h2> Die Bergfreunde sind der richtige Ansprechpartner wenn es um Bergsport Ausrüstung geht! <figure class="figure-responsive" data-blank="1" data-url="https://www.bergfreunde.de/?pid=15321&wt_mc=de.affiliate.qc.15321.-.-&utm_source=sonstige-affiliates&utm_medium=cpo-variabel&utm_campaign=alpinewelten"> <div class="img-responsive" data-media-id="5141" data-media-thumbnail="ckeditor_md"> </div> <figcaption class="hidden"></figcaption> </figure> <h2> </h2> <h2>Das Alpine Welten Base Camp Duffle</h2> Das Duffle Bag ist ideal für alle Bergreisen und Kurse geeignet. Die Größe ist so dimensioniert, dass auch Skischuhe und Gepäck für eine längere Reise ins Gepäck passen. Ideal ist die Tragefunktion - Rucksack für alle Skitouren, Hochtouren, und Klettersteigkurse! <a href="https://www.alpinewelten.com/shop/base-camp-duffle" target="_blank">HIER Bestellen</a> <figure class="figure-responsive" data-blank="1" data-url="https://www.alpinewelten.com/shop/base-camp-duffle"> <div class="img-responsive" data-media-id="5397" data-media-thumbnail="ckeditor_lg"> </div> <figcaption class="hidden"></figcaption> </figure> 
 packing_list_text_start
 days_before_start_for_cancellation14
 execution_feasibilitymedium
 days_before_start_for_last_notice14
 last_tour_date_number(null)
 tourstart_weekday1
 mountain_guide_tour_search_information
 customer_tour_material_info
 material_list_link
 gmap48.403885,10.005871
 meeting_point_map48.411976,10.012394
 price_excl_flight149.00
 FirmsTour(array)
 id15723
 firm_id1
 tour_id127
 position1
 Firm(array)
 id1
 LogoMedia(array)
 0(array)
 id3848
 hashf65eea471299987bed858b048626ed6d
 created2017-03-15 14:47:08
 updated2017-03-15 14:47:08
 titleDurchgeführt von Alpine Welten
 cross_reference_count1
 MediaEntity(array)
 id149540
 pos1
 media_id3848
 modelFirm
 fieldlogo
 foreign_key1
 FileUpload(array)
 0(array)
 id115467
 hash7587c7daefbee1e2f1fdfe13c4236f9e
 created2017-03-15 14:47:06
 updated2017-03-15 14:47:08
 modelMedia
 fieldfile
 foreign_key3848
 aliasdurchgefuehrt-von-alpinewelten-1.svg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/58c945dc66741.svg
 size16311
 ext.svg
 mimeimage/svg+xml
 width(null)
 height(null)
 TourTexts(array)
 id119
 hashcec1caaef2ac104ee1ea0e5a8d2662e4
 created2016-10-25 13:08:12
 updated2019-09-02 11:23:21
 tour_id127
 ws_text_short_descriptionFahrtechnik mit dem MTB verbessern mit geprüften Mountainbike- Guides auf den Top Trails der Region . 
 ws_text_detail_description<div> <h2>MTB Fahrtechnik Level I-III</h2> Je besser Deine Fahrtechnik ist, umso mehr Freude wirst Du mit Deinem Bike haben. Grund genug also, um an einem unserer Mountainbike Fahrtechnik Kurse teilzunehmen, denn Ausdauer ist beim Mountainbiken noch lange nicht alles. Unser MTB Fahrtechnik Kurs Wochenende vermittelt Dir die Kursinhalte Level I bis Level III und bereitet Dich so ideal auf Deine zukünftigen Trails vor. Gerne organisieren wir Deine Hotelübernachtung. • Kleine Gruppen max. 6 Teilnehmer • Auf Wunsch mit Hotelübernachtung • Ausbildung durch lizensierten MTB-Guide </div> 
 ws_text_requirementsFür das Mountainbike Fahrtechnik Wochenende solltest Du über Kondition für Tagesetappen von 20 km und ca 200 Hm verfügen. Du verfügst über ein funktionsfähiges Bike mit grobstolliger Bereifung (keine abgefahrenen Reifen) und Sattelschnellspanner. Außerdem benötigst Du Helm und Handschuhe sowie ggf. eine Radbrille und Radbekleidung. Bei ungünstiger Wetterlage behalten wir uns eine Absage des Kurses vor. 
 ws_text_travel_program1. Tag: Individuelle Anreise und Treffpunkt am Morgen in Ulm an der Straßenbahnhaltestelle Donauhalle beim Hotel Lago. Nach einem Bike-Check starten wir mit den ersten Aufgaben und Übungen zur Verbesserung Deines Bike-Handlings. Dabei stehen Deine Kompetenzen im Bereich Balance und Koordination im Mittelpunkt. Nach der Mittagspause in einem nahe gelegenen Lokal starten wir in das Themengebiet Level II wo wir anspruchsvolle Fahrmanöver angehen und durchführen, wie z. B. steil bergauf und bergab fahren, bergauf Anfahren, Stufen, Teppen usw. Dabei geht Dein Guide ganz individuell auf Dich ein. Übernachtung auf Wunsch im Hotel oder individuelle Heimreise am Nachmittag. 2. Tag: Morgens starten wir, um spannende Trails rund um Ulm zu erkunden. Nun heißt es, die vom Vortag erworbenen Kenntnisse ins Gelände umzusetzen und zu vertiefen. Mit individuellen Korrekturen und Tipps verbessern wir Deine Fahrtechnik und erarbeiten uns die Technikinhalte des Level III. Verabschiedung und Heimreise am frühen Nachmittag.
 ws_text_services
 ws_text_travel_report
 ws_text_information
 ws_text_location_description
 ws_text_accomodation
 ws_text_course_contentLevel I: Neutrale Position, richtiges Bremsen, Kurventechnik, Balance (der Schlüssel zum Erfolg), Überwinden kleiner Hindernisse sowie individuelle Korrekturen und Tipps rund ums Mountainbike. Level II: Verbesserung der Brems- und Kurventechnik und der Balance im schwierigeren Gelände, Überwinden von Hindernissen, richtig Bergauf und Bergab fahren, individuelle Korrekturen. Level III: Balance, Brems- und Kurventechnik in Trailpassagen, Befahren von Wurzelpassagen, stufiges und verblocktes Gelände, Spitzkehren, steil Bergauf und Bergab, individuelle Korrekturen.
 ws_text_overview
 Route(array)
 id139
 hash5e443a1eb4720bb9208d5bf2df698d89
 created2016-08-12 17:20:30
 updated2019-09-02 11:23:21
 modelTour
 foreign_key127
 base/
 aliasmtb-fahrtechnik
 controllerFrontendTours.FrontendTours
 actiontour
 parent_id(null)
 lft2391
 rght2392
 route/mtb-fahrtechnik
 TourDate(empty)
 Services(array)
 0(array)
 id113
 hash59151738321784c051f3b73b88cfd6f2
 created2016-06-22 08:19:38
 updated2016-10-18 09:58:46
 title 2 Tage Organisation und Führung durch einen lizenzierten MTB-Guide
 description
 typeother
 tour_count3
 TourServicesTour(array)
 id427
 tour_id127
 tour_service_id113
 typeinclusive
 price(null)
 position1
 1(array)
 id438
 hash3e3a3076803aefa25d95af6af54f8d58
 created2018-04-20 11:45:47
 updated2019-02-08 11:19:28
 titleAW Plus Paket | Reservierung | Komfort | Sicherheit
 descriptionDas AW Plus Paket bietet Dir mehr Komfort & Sicherheit <ul> <li>Vorab Reservierung aller Unterkünfte laut Programm</li> <li>Digital & Detailliert | Online-Übersicht aller Deiner Reiseinformationen</li> <li>Detaillierte Ausrüstungsliste mit Bergführertipp</li> <li>Assistance & Krisenmanagement im Notfall.</li> </ul>
 typeother
 tour_count256
 TourServicesTour(array)
 id1807
 tour_id127
 tour_service_id438
 typeinclusive
 price(null)
 position2
 TravelOptions(array)
 0(array)
 id12
 hashc1607e104124f87197d139264e91265c
 created2016-10-18 15:04:12
 updated2017-12-04 11:30:43
 titleFreiwilliger myclimate Klimaschutzbeitrag 9 €
 descriptionFreiwilliger Beitrag zum Klimaschutz und zur Reduktion der entstehenden Treibhausgase auf dieser Reise. Mach mit, wir sind auch schon dabei!
 typeclimate_protection_fee
 tour_count91
 TourTravelOptionsTour(array)
 id79
 tour_id127
 tour_travel_option_id12
 price9.00
 position1
 Countries(array)
 0(array)
 id46
 hash1aa19ba373ef88511f72e93d01a1de95
 created2016-06-01 17:35:19
 updated2016-06-01 17:35:19
 titleDeutschland
 abbreviationDE
 CountriesTour(array)
 id14626
 country_id46
 tour_id127
 HeaderImagesMedia(array)
 0(array)
 id3273
 hashd9b95f01f88e59028de729edc2102530
 created2016-10-29 15:11:05
 updated2016-10-29 15:11:05
 titlemountainbike-kurse-und-fuehrung
 cross_reference_count5
 MediaEntity(array)
 id261723
 pos1
 media_id3273
 modelTour
 fieldheader_images
 foreign_key127
 FileUpload(array)
 0(array)
 id92917
 hashbf8880d623e8b4280c99b58d237c605b
 created2016-10-29 15:10:51
 updated2016-10-29 15:11:05
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/58149fe9ecfa3.jpg
 size241835
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id92932
 hash3698118f2440f35a0c5cce2c9650de97
 created2016-10-29 15:11:06
 updated2016-10-29 15:11:06
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id92917
 filewebroot/files/Media/File/ThMediaFileIndex/58149fe9edf48.jpg
 size12483
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 2(array)
 id92933
 hashde4c99d197a738e0ee8161cd791217e5
 created2016-10-29 15:11:06
 updated2016-10-29 15:11:06
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id92917
 filewebroot/files/Media/File/CkeditorXs/58149fea21007.jpg
 size4003
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 3(array)
 id92934
 hash45ddaf57ca76f6528085a0d8d5b76949
 created2016-10-29 15:11:06
 updated2016-10-29 15:11:06
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id92917
 filewebroot/files/Media/File/CkeditorSm/58149fea45eac.jpg
 size12483
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 4(array)
 id92935
 hashdb2cf7e3c189336b86e44489990e3f2c
 created2016-10-29 15:11:06
 updated2016-10-29 15:11:06
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id92917
 filewebroot/files/Media/File/CkeditorMd/58149fea6d10e.jpg
 size19609
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 5(array)
 id92937
 hash6b91a3728cd5d954920f22e3b4f65baa
 created2016-10-29 15:11:06
 updated2016-10-29 15:11:06
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id92917
 filewebroot/files/Media/File/CkeditorLg/58149fea9aeea.jpg
 size42830
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 6(array)
 id323545
 hash3f89791071f2716eb1f24d849b9f962b
 created2019-12-17 14:43:03
 updated2019-12-17 14:43:03
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id92917
 filewebroot/files/Media/File/ThTourHeaderImage/5df8db6785d30.jpg
 size65182
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 7(array)
 id312824
 hash29c894697c469086d6d2c46939235e56
 created2019-09-02 11:23:19
 updated2019-09-02 11:23:19
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung-thtourteaserimage.jpg
 thumbnailth-tour-teaser-image
 parent_id92917
 filewebroot/files/Media/File/ThTourTeaserImage/5d6cdf877aec2.jpg
 size65182
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 8(array)
 id312825
 hash29e0749e3766c4624384c837797ff037
 created2019-09-02 11:23:20
 updated2019-09-02 11:23:20
 modelMedia
 fieldfile
 foreign_key3273
 aliasmountainbike-kurse-und-fu-hrung-thtourteaserimagedesaturated.jpg
 thumbnailth-tour-teaser-image-desaturated
 parent_id92917
 filewebroot/files/Media/File/ThTourTeaserImageDesaturated/5d6cdf87c283f.jpg
 size59450
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 1(array)
 id3280
 hash101b396381d7c43a8930e0ef5e75f3b9
 created2016-10-29 15:13:18
 updated2016-10-29 15:13:18
 titlemtb-fuehrungen
 cross_reference_count3
 MediaEntity(array)
 id261724
 pos2
 media_id3280
 modelTour
 fieldheader_images
 foreign_key127
 FileUpload(array)
 0(array)
 id93033
 hash4f76090f4578e848795657bf8c8c5aaa
 created2016-10-29 15:13:04
 updated2016-10-29 15:13:18
 modelMedia
 fieldfile
 foreign_key3280
 aliasmtb-fu-hrungen.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5814a06e0377b.jpg
 size250934
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id312843
 hash3051136da43bdf5e1cd5f0e01192f26a
 created2019-09-02 11:24:22
 updated2019-09-02 11:24:22
 modelMedia
 fieldfile
 foreign_key3280
 aliasmtb-fu-hrungen-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id93033
 filewebroot/files/Media/File/ThTourHeaderImage/5d6cdfc602f1a.jpg
 size93246
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id93034
 hashf4498cb049dca88df2fcf33fa9e88380
 created2016-10-29 15:13:18
 updated2016-10-29 15:13:18
 modelMedia
 fieldfile
 foreign_key3280
 aliasmtb-fu-hrungen-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id93033
 filewebroot/files/Media/File/ThMediaFileIndex/5814a06e04a76.jpg
 size14930
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id93035
 hash51e2d893923433c101edabb55467d279
 created2016-10-29 15:13:18
 updated2016-10-29 15:13:18
 modelMedia
 fieldfile
 foreign_key3280
 aliasmtb-fu-hrungen-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id93033
 filewebroot/files/Media/File/CkeditorXs/5814a06e27b9b.jpg
 size4506
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id93036
 hash579117eb485490100666c244293ecd9c
 created2016-10-29 15:13:18
 updated2016-10-29 15:13:18
 modelMedia
 fieldfile
 foreign_key3280
 aliasmtb-fu-hrungen-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id93033
 filewebroot/files/Media/File/CkeditorSm/5814a06e450dc.jpg
 size14930
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id93037
 hash8da4d917c7611766d242a3371f03cced
 created2016-10-29 15:13:18
 updated2016-10-29 15:13:18
 modelMedia
 fieldfile
 foreign_key3280
 aliasmtb-fu-hrungen-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id93033
 filewebroot/files/Media/File/CkeditorMd/5814a06e65a77.jpg
 size24197
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id93038
 hashaaa7d0f37d3f1fbf338012ba930e235f
 created2016-10-29 15:13:18
 updated2016-10-29 15:13:18
 modelMedia
 fieldfile
 foreign_key3280
 aliasmtb-fu-hrungen-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id93033
 filewebroot/files/Media/File/CkeditorLg/5814a06e86446.jpg
 size54266
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 2(array)
 id3277
 hash07590f8f448b51bb2122e632b217f03d
 created2016-10-29 15:12:16
 updated2016-10-29 15:12:16
 titlemountainbiken-lernen
 cross_reference_count3
 MediaEntity(array)
 id261725
 pos3
 media_id3277
 modelTour
 fieldheader_images
 foreign_key127
 FileUpload(array)
 0(array)
 id93015
 hasha800470f63ff2c5a2ec66b0bf3725ab4
 created2016-10-29 15:12:06
 updated2016-10-29 15:12:16
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5814a030c2dfd.jpg
 size224237
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id312840
 hashf2d844ee0429f5b548384b3a4697508b
 created2019-09-02 11:24:21
 updated2019-09-02 11:24:21
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen-thtourteaserimage.jpg
 thumbnailth-tour-teaser-image
 parent_id93015
 filewebroot/files/Media/File/ThTourTeaserImage/5d6cdfc52f0e7.jpg
 size79077
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id312841
 hash603b48471d4f0737166d0bd701ad09b3
 created2019-09-02 11:24:21
 updated2019-09-02 11:24:21
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen-thtourteaserimagedesaturated.jpg
 thumbnailth-tour-teaser-image-desaturated
 parent_id93015
 filewebroot/files/Media/File/ThTourTeaserImageDesaturated/5d6cdfc56db47.jpg
 size71554
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 3(array)
 id312842
 hashc4f776944704fa419f8a1b885d02fbf6
 created2019-09-02 11:24:22
 updated2019-09-02 11:24:22
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id93015
 filewebroot/files/Media/File/ThTourHeaderImage/5d6cdfc5b2212.jpg
 size79077
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 4(array)
 id93016
 hash2440947cdbc404b1fde7d6dad916d33d
 created2016-10-29 15:12:16
 updated2016-10-29 15:12:16
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id93015
 filewebroot/files/Media/File/ThMediaFileIndex/5814a030c3d36.jpg
 size14233
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id93017
 hashaadd9a110abdda7924040fe0039c7701
 created2016-10-29 15:12:17
 updated2016-10-29 15:12:17
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id93015
 filewebroot/files/Media/File/CkeditorXs/5814a030e05f1.jpg
 size4386
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 6(array)
 id93018
 hash5ba021f629c94af612ab25c75fad7845
 created2016-10-29 15:12:17
 updated2016-10-29 15:12:17
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id93015
 filewebroot/files/Media/File/CkeditorSm/5814a0310bae3.jpg
 size14233
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 7(array)
 id93019
 hash269008f5c2a2557d97c2805bf29b2caa
 created2016-10-29 15:12:17
 updated2016-10-29 15:12:17
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id93015
 filewebroot/files/Media/File/CkeditorMd/5814a03127d9e.jpg
 size23237
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 8(array)
 id93020
 hashd88e5f2894f36009d329c4060ae9cf60
 created2016-10-29 15:12:17
 updated2016-10-29 15:12:17
 modelMedia
 fieldfile
 foreign_key3277
 aliasmountainbiken-lernen-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id93015
 filewebroot/files/Media/File/CkeditorLg/5814a03143f0d.jpg
 size51220
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 3(array)
 id3272
 hash7bb9b5e1bd65bcda3f708986d6022ec8
 created2016-10-29 15:10:39
 updated2016-10-29 15:10:39
 titlemountainbike-kurse-mit-guide
 cross_reference_count3
 MediaEntity(array)
 id261726
 pos4
 media_id3272
 modelTour
 fieldheader_images
 foreign_key127
 FileUpload(array)
 0(array)
 id92879
 hashdb93ca324b23e18ab36fd19aefce6a78
 created2016-10-29 15:10:29
 updated2016-10-29 15:10:39
 modelMedia
 fieldfile
 foreign_key3272
 aliasmountainbike-kurse-mit-guide.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/58149fcf643b8.jpg
 size281505
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id312846
 hash30710356fbf17647bd10e05c4f997de9
 created2019-09-02 11:24:22
 updated2019-09-02 11:24:22
 modelMedia
 fieldfile
 foreign_key3272
 aliasmountainbike-kurse-mit-guide-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id92879
 filewebroot/files/Media/File/ThTourHeaderImage/5d6cdfc6919ab.jpg
 size63342
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id92912
 hash88f720fc6065d715677d47f38df60f48
 created2016-10-29 15:10:39
 updated2016-10-29 15:10:39
 modelMedia
 fieldfile
 foreign_key3272
 aliasmountainbike-kurse-mit-guide-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id92879
 filewebroot/files/Media/File/ThMediaFileIndex/58149fcf64ff0.jpg
 size13150
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id92913
 hash56464477fa899c874732d059e0ab2b16
 created2016-10-29 15:10:39
 updated2016-10-29 15:10:39
 modelMedia
 fieldfile
 foreign_key3272
 aliasmountainbike-kurse-mit-guide-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id92879
 filewebroot/files/Media/File/CkeditorXs/58149fcf82a1b.jpg
 size4342
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id92914
 hash1237ca7163294e121712f1055263cc3e
 created2016-10-29 15:10:39
 updated2016-10-29 15:10:39
 modelMedia
 fieldfile
 foreign_key3272
 aliasmountainbike-kurse-mit-guide-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id92879
 filewebroot/files/Media/File/CkeditorSm/58149fcf9e7fc.jpg
 size13150
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id92915
 hash4bc5cbb6111c25c5b0027f8f2f59f8c2
 created2016-10-29 15:10:39
 updated2016-10-29 15:10:39
 modelMedia
 fieldfile
 foreign_key3272
 aliasmountainbike-kurse-mit-guide-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id92879
 filewebroot/files/Media/File/CkeditorMd/58149fcfbb075.jpg
 size20145
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id92916
 hashc93c7fbe0d1a13e8e2eaa67c3e359ab7
 created2016-10-29 15:10:40
 updated2016-10-29 15:10:40
 modelMedia
 fieldfile
 foreign_key3272
 aliasmountainbike-kurse-mit-guide-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id92879
 filewebroot/files/Media/File/CkeditorLg/58149fcfd7302.jpg
 size43463
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 4(array)
 id3284
 hash12b96dae2ec9833b45c77dea45fb6b7f
 created2016-10-29 15:14:25
 updated2016-10-29 15:14:25
 titletrail-kurs
 cross_reference_count4
 MediaEntity(array)
 id261727
 pos5
 media_id3284
 modelTour
 fieldheader_images
 foreign_key127
 FileUpload(array)
 0(array)
 id93057
 hash82aee2f579ea8352994d7a79719a3dc7
 created2016-10-29 15:14:17
 updated2016-10-29 15:14:25
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5814a0b1ce2ac.jpg
 size297642
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id312832
 hash8cbf88aed32b45c60b1d266e9a4122ae
 created2019-09-02 11:23:47
 updated2019-09-02 11:23:47
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs-thtourteaserimage.jpg
 thumbnailth-tour-teaser-image
 parent_id93057
 filewebroot/files/Media/File/ThTourTeaserImage/5d6cdfa398913.jpg
 size110263
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id312833
 hash0fb11ebb1aa9fb91fcd3fe2f0ed9fe1a
 created2019-09-02 11:23:47
 updated2019-09-02 11:23:47
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs-thtourteaserimagedesaturated.jpg
 thumbnailth-tour-teaser-image-desaturated
 parent_id93057
 filewebroot/files/Media/File/ThTourTeaserImageDesaturated/5d6cdfa3c6c5a.jpg
 size102118
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 3(array)
 id312847
 hash02409824448597c85c836c0f2f113e34
 created2019-09-02 11:24:23
 updated2019-09-02 11:24:23
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id93057
 filewebroot/files/Media/File/ThTourHeaderImage/5d6cdfc6cd9ce.jpg
 size110263
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 4(array)
 id93058
 hashf5a4bc3dbd6f5e1b54789b4761a46dae
 created2016-10-29 15:14:25
 updated2016-10-29 15:14:25
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id93057
 filewebroot/files/Media/File/ThMediaFileIndex/5814a0b1cee05.jpg
 size15099
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id93059
 hash8d7aa913bbfae361c57c20fae58dacb2
 created2016-10-29 15:14:26
 updated2016-10-29 15:14:26
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id93057
 filewebroot/files/Media/File/CkeditorXs/5814a0b1eb201.jpg
 size4402
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 6(array)
 id93060
 hashd7b3a0ba7173458817abd695e5db9fa0
 created2016-10-29 15:14:26
 updated2016-10-29 15:14:26
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id93057
 filewebroot/files/Media/File/CkeditorSm/5814a0b212b7c.jpg
 size15099
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 7(array)
 id93061
 hash517150838a2d374efe9e84723685c9c2
 created2016-10-29 15:14:26
 updated2016-10-29 15:14:26
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id93057
 filewebroot/files/Media/File/CkeditorMd/5814a0b22ed66.jpg
 size24875
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 8(array)
 id93062
 hash4275af230fd4ce105b315fa16d8c8f19
 created2016-10-29 15:14:26
 updated2016-10-29 15:14:26
 modelMedia
 fieldfile
 foreign_key3284
 aliastrail-kurs-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id93057
 filewebroot/files/Media/File/CkeditorLg/5814a0b24cfc8.jpg
 size56894
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 5(array)
 id3282
 hash435f873f851d2323992db5f17d84ce4b
 created2016-10-29 15:13:52
 updated2016-10-29 15:13:52
 titlemtb-kurse
 cross_reference_count3
 MediaEntity(array)
 id261728
 pos6
 media_id3282
 modelTour
 fieldheader_images
 foreign_key127
 FileUpload(array)
 0(array)
 id93045
 hash76e5c91ac5462403136ca5f71fb7ed36
 created2016-10-29 15:13:43
 updated2016-10-29 15:13:52
 modelMedia
 fieldfile
 foreign_key3282
 aliasmtb-kurse.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/Media/File/5814a0901f7b3.jpg
 size258070
 ext.jpg
 mimeimage/jpeg
 width1920
 height1080
 1(array)
 id316203
 hashaa14bdd8005c6a55c2a4f9e3807c3f54
 created2019-09-11 14:00:28
 updated2019-09-11 14:00:28
 modelMedia
 fieldfile
 foreign_key3282
 aliasmtb-kurse-thtourheaderimage.jpg
 thumbnailth-tour-header-image
 parent_id93045
 filewebroot/files/Media/File/ThTourHeaderImage/5d78e1dc29019.jpg
 size76505
 ext.jpg
 mimeimage/jpeg
 width750
 height421
 2(array)
 id93046
 hash4748c1d87ebd795504c2df24605cabf3
 created2016-10-29 15:13:52
 updated2016-10-29 15:13:52
 modelMedia
 fieldfile
 foreign_key3282
 aliasmtb-kurse-thmediafileindex.jpg
 thumbnailth-media-file-index
 parent_id93045
 filewebroot/files/Media/File/ThMediaFileIndex/5814a090203a5.jpg
 size13627
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 3(array)
 id93047
 hash1c7372e031b1e10916ddb954258100c4
 created2016-10-29 15:13:52
 updated2016-10-29 15:13:52
 modelMedia
 fieldfile
 foreign_key3282
 aliasmtb-kurse-ckeditorxs.jpg
 thumbnailckeditor_xs
 parent_id93045
 filewebroot/files/Media/File/CkeditorXs/5814a0903f2a5.jpg
 size4220
 ext.jpg
 mimeimage/jpeg
 width80
 height45
 4(array)
 id93048
 hashf596751dc077dfeb6b0c308395354554
 created2016-10-29 15:13:52
 updated2016-10-29 15:13:52
 modelMedia
 fieldfile
 foreign_key3282
 aliasmtb-kurse-ckeditorsm.jpg
 thumbnailckeditor_sm
 parent_id93045
 filewebroot/files/Media/File/CkeditorSm/5814a0905aadc.jpg
 size13627
 ext.jpg
 mimeimage/jpeg
 width150
 height84
 5(array)
 id93049
 hashceef34e4a0ddd3c6efaeb2c466f543e8
 created2016-10-29 15:13:52
 updated2016-10-29 15:13:52
 modelMedia
 fieldfile
 foreign_key3282
 aliasmtb-kurse-ckeditormd.jpg
 thumbnailckeditor_md
 parent_id93045
 filewebroot/files/Media/File/CkeditorMd/5814a09077ea1.jpg
 size22028
 ext.jpg
 mimeimage/jpeg
 width200
 height112
 6(array)
 id93050
 hashc368666462a43eb4b84116d567aff290
 created2016-10-29 15:13:52
 updated2016-10-29 15:13:52
 modelMedia
 fieldfile
 foreign_key3282
 aliasmtb-kurse-ckeditorlg.jpg
 thumbnailckeditor_lg
 parent_id93045
 filewebroot/files/Media/File/CkeditorLg/5814a0909456f.jpg
 size49156
 ext.jpg
 mimeimage/jpeg
 width300
 height168
 AccomodationImagesMedia(empty)
 OutputChannel(array)
 0(array)
 id1
 hash13d55677848396f63db6eeef9176c60b
 created2016-06-01 17:31:42
 updated2018-04-16 10:42:09
 titleAlpine Welten
 abbreviationAW
 oa_offerer_id8650995
 FirmsTour(array)
 id15723
 firm_id1
 tour_id127
 position1
 TourFaqItemsForCustomer(empty)
- tourDateSelectOptions(empty)
- travelProgram1. Tag: Individuelle Anreise und Treffpunkt am Morgen in Ulm an der Straßenbahnhaltestelle Donauhalle beim Hotel Lago. Nach einem Bike-Check starten wir mit den ersten Aufgaben und Übungen zur Verbesserung Deines Bike-Handlings. Dabei stehen Deine Kompetenzen im Bereich Balance und Koordination im Mittelpunkt. Nach der Mittagspause in einem nahe gelegenen Lokal starten wir in das Themengebiet Level II wo wir anspruchsvolle Fahrmanöver angehen und durchführen, wie z. B. steil bergauf und bergab fahren, bergauf Anfahren, Stufen, Teppen usw. Dabei geht Dein Guide ganz individuell auf Dich ein. Übernachtung auf Wunsch im Hotel oder individuelle Heimreise am Nachmittag. 2. Tag: Morgens starten wir, um spannende Trails rund um Ulm zu erkunden. Nun heißt es, die vom Vortag erworbenen Kenntnisse ins Gelände umzusetzen und zu vertiefen. Mit individuellen Korrekturen und Tipps verbessern wir Deine Fahrtechnik und erarbeiten uns die Technikinhalte des Level III. Verabschiedung und Heimreise am frühen Nachmittag.
- faq(array)
 0(array)
 Menu(array)
 id109
 hash665eda9c5c35647e003369c9132213f9
 created2016-10-13 14:01:50
 updated2016-11-03 09:59:51
 parent_id5
 lft60
 rght65
 language_id1
 typefaq
 titleFragen zur Unterkunft
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id672
 hash623c50de53cff1567ac036f58c4f5f8c
 created2016-10-13 14:01:50
 updated2016-11-03 09:59:51
 modelMenu
 foreign_key109
 base/faq-bergsportreisen/
 aliasfragen-zur-unterkunft
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id6
 lft385
 rght408
 route/faq-bergsportreisen/fragen-zur-unterkunft
 children(array)
 0(array)
 Menu(array)
 id103
 hashc63e04e53e02b4774612fff57efd8c61
 created2016-10-11 11:58:03
 updated2019-03-13 13:33:55
 parent_id109
 lft61
 rght62
 language_id1
 typecontent
 titleTouren mit Übernachtung in BERGHÜTTEN
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id651
 hashe96e26d4c2595af04769708f6d072be4
 created2016-10-11 11:58:04
 updated2019-03-13 13:33:55
 modelMenu
 foreign_key103
 base/faq-bergsportreisen/fragen-zur-unterkunft/
 aliastouren-mit-uebernachtung-in-berghuetten
 controllerFrontendMenus.FrontendMenus
 actioncontent
 parent_id672
 lft386
 rght399
 route/faq-bergsportreisen/fragen-zur-unterkunft/touren-mit-uebernachtung-in-berghuetten
 children(empty)
 1(array)
 Menu(array)
 id114
 hashfb46f7726d3b68150e6e1860709c5fb2
 created2016-10-16 20:29:12
 updated2016-11-03 10:01:04
 parent_id109
 lft63
 rght64
 language_id1
 typecontent
 titleTouren mit Übernachtung in HOTELS
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id690
 hashc83e965bee34cd2e535bd227964fbb42
 created2016-10-16 20:29:12
 updated2016-11-03 10:01:04
 modelMenu
 foreign_key114
 base/faq-bergsportreisen/fragen-zur-unterkunft/
 aliastouren-mit-uebernachtung-in-hotels
 controllerFrontendMenus.FrontendMenus
 actioncontent
 parent_id672
 lft400
 rght407
 route/faq-bergsportreisen/fragen-zur-unterkunft/touren-mit-uebernachtung-in-hotels
 children(empty)
 1(array)
 Menu(array)
 id108
 hash3ce8d08c69eff82c873057b236616463
 created2016-10-13 13:59:40
 updated2016-11-03 10:02:18
 parent_id5
 lft66
 rght73
 language_id1
 typefaq
 titleFragen zur Ausrüstung
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id671
 hashf281002e4b9e4d8f578a72ee09e325c2
 created2016-10-13 13:59:40
 updated2016-11-03 10:02:18
 modelMenu
 foreign_key108
 base/faq-bergsportreisen/
 aliasfragen-zur-ausruestung
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id6
 lft365
 rght384
 route/faq-bergsportreisen/fragen-zur-ausruestung
 children(array)
 0(array)
 Menu(array)
 id82
 hash2b1765849fe396f7b95ec1504e925d7d
 created2016-10-05 09:30:15
 updated2016-11-03 10:02:58
 parent_id108
 lft67
 rght68
 language_id1
 typecontent
 titleBergsportausrüstung leihen
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id578
 hash851e892292499e7826a3589e819b7584
 created2016-10-05 09:30:15
 updated2016-11-03 10:02:58
 modelMenu
 foreign_key82
 base/faq-bergsportreisen/fragen-zur-ausruestung/
 aliasbergsportausruestung-leihen
 controllerFrontendMenus.FrontendMenus
 actioncontent
 parent_id671
 lft366
 rght369
 route/faq-bergsportreisen/fragen-zur-ausruestung/bergsportausruestung-leihen
 children(empty)
 1(array)
 Menu(array)
 id123
 hash447e1e28d945ba79dc88d1218f20eed0
 created2016-10-17 15:53:14
 updated2016-11-03 10:04:03
 parent_id108
 lft69
 rght70
 language_id1
 typecontent
 titleBergschuhe | Welcher Schuh ist der richtige für meine Bergtour?
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id719
 hashdda805c4dec77ee7b18556ebcdbd9050
 created2016-10-17 15:53:14
 updated2016-11-03 10:04:03
 modelMenu
 foreign_key123
 base/faq-bergsportreisen/fragen-zur-ausruestung/
 aliasbergschuhe-welcher-schuh-ist-der-richtige-fuer-meine-bergtour
 controllerFrontendMenus.FrontendMenus
 actioncontent
 parent_id671
 lft370
 rght379
 route/faq-bergsportreisen/fragen-zur-ausruestung/bergschuhe-welcher-schuh-ist-der-richtige-fuer-meine-bergtour
 children(empty)
 2(array)
 Menu(array)
 id124
 hash7c791bf658edc009bc0cea28d4d1593c
 created2016-10-17 18:46:02
 updated2016-11-03 10:05:34
 parent_id108
 lft71
 rght72
 language_id1
 typecontent
 titleHüttenschlafsack
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id722
 hashadfa678fc0db4d3a5914acb4cb0cdb61
 created2016-10-17 18:46:02
 updated2016-11-03 10:05:34
 modelMenu
 foreign_key124
 base/faq-bergsportreisen/fragen-zur-ausruestung/
 aliashuettenschlafsack
 controllerFrontendMenus.FrontendMenus
 actioncontent
 parent_id671
 lft380
 rght383
 route/faq-bergsportreisen/fragen-zur-ausruestung/huettenschlafsack
 children(empty)
 2(array)
 Menu(array)
 id137
 hash5f5b9645c69f1f403065cdbf0a633cb1
 created2016-10-22 18:16:11
 updated2017-02-25 11:04:41
 parent_id5
 lft74
 rght79
 language_id1
 typefaq
 titleFragen zum Flug
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id803
 hash6413fc16e3784e08636b9dddaf7b220d
 created2016-10-22 18:16:11
 updated2017-02-25 11:04:41
 modelMenu
 foreign_key137
 base/faq-bergsportreisen/
 aliasfragen-zum-flug
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id6
 lft409
 rght430
 route/faq-bergsportreisen/fragen-zum-flug
 children(array)
 0(array)
 Menu(array)
 id136
 hashd38d88141380c4f683a4fcfcb4183e3f
 created2016-10-22 17:20:27
 updated2016-10-22 18:54:37
 parent_id137
 lft75
 rght76
 language_id1
 typefaq
 titleAllgemeines
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id802
 hashd7e689cfefd3294d20fc01d5eb0be1f4
 created2016-10-22 17:20:27
 updated2016-10-22 18:54:38
 modelMenu
 foreign_key136
 base/faq-bergsportreisen/fragen-zum-flug/
 aliasallgemeines
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id803
 lft410
 rght421
 route/faq-bergsportreisen/fragen-zum-flug/allgemeines
 children(empty)
 1(array)
 Menu(array)
 id138
 hash53a6a179bd58d3ba1103d2cd636dcbea
 created2016-10-22 18:54:02
 updated2016-10-22 18:54:02
 parent_id137
 lft77
 rght78
 language_id1
 typefaq
 titleFlüge mit Skigepäck
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id809
 hashe1bc2c837bc293aaebdd19a2342e3efe
 created2016-10-22 18:54:03
 updated2016-10-22 18:54:03
 modelMenu
 foreign_key138
 base/faq-bergsportreisen/fragen-zum-flug/
 aliasfluege-mit-skigepaeck
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id803
 lft422
 rght429
 route/faq-bergsportreisen/fragen-zum-flug/fluege-mit-skigepaeck
 children(empty)
 3(array)
 Menu(array)
 id487
 hash8fcb7b9841fdc44573409da2721f25a6
 created2017-03-28 14:57:05
 updated2017-03-28 15:22:25
 parent_id5
 lft80
 rght99
 language_id1
 typefaq
 titleFragen zur Tour
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1873
 hash598d65103fb273c8ef4a800cc898ce49
 created2017-03-28 14:57:05
 updated2017-03-28 15:22:25
 modelMenu
 foreign_key487
 base/faq-bergsportreisen/
 aliasfragen-zur-tour
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id6
 lft431
 rght488
 route/faq-bergsportreisen/fragen-zur-tour
 children(array)
 0(array)
 Menu(array)
 id489
 hash5e9c54a582a067506998ff3bfee1c32d
 created2017-03-28 14:59:14
 updated2017-03-28 15:09:16
 parent_id487
 lft81
 rght82
 language_id1
 typefaq
 titleDas Wetter
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1875
 hash2c7d4d5d02be177fd9ded872c7913b49
 created2017-03-28 14:59:14
 updated2017-03-28 15:09:16
 modelMenu
 foreign_key489
 base/faq-bergsportreisen/fragen-zur-tour/
 aliasdas-wetter
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft432
 rght437
 route/faq-bergsportreisen/fragen-zur-tour/das-wetter
 children(empty)
 1(array)
 Menu(array)
 id490
 hash6ea0bb2542ca9cfc8acf3c635097e9bd
 created2017-03-28 15:08:53
 updated2017-03-28 15:09:09
 parent_id487
 lft83
 rght84
 language_id1
 typefaq
 titleHunde auf Bergtouren
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1878
 hash77e4a4ab42a1777499bab94582975e33
 created2017-03-28 15:08:53
 updated2017-03-28 15:09:09
 modelMenu
 foreign_key490
 base/faq-bergsportreisen/fragen-zur-tour/
 aliashunde-auf-bergtouren
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft438
 rght441
 route/faq-bergsportreisen/fragen-zur-tour/hunde-auf-bergtouren
 children(empty)
 2(array)
 Menu(array)
 id491
 hash43dd4e42795e07fdf12026ce970549fa
 created2017-03-28 15:09:41
 updated2017-03-28 15:09:51
 parent_id487
 lft85
 rght86
 language_id1
 typefaq
 titleAnreise zur Bergtour
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1879
 hash879a18379a9a34a2a3b756010e66b892
 created2017-03-28 15:09:41
 updated2017-03-28 15:09:51
 modelMenu
 foreign_key491
 base/faq-bergsportreisen/fragen-zur-tour/
 aliasanreise-zur-bergtour
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft442
 rght449
 route/faq-bergsportreisen/fragen-zur-tour/anreise-zur-bergtour
 children(empty)
 3(array)
 Menu(array)
 id492
 hashfb4ef5fbbfe190f81bb401f0da541b97
 created2017-03-28 15:10:04
 updated2017-03-28 15:10:04
 parent_id487
 lft87
 rght88
 language_id1
 typefaq
 titleMein Bergführer | Meine Bergführerin
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1880
 hash1d22a6b9baa2909ac70b564afcfbfe0e
 created2017-03-28 15:10:04
 updated2017-03-28 15:10:05
 modelMenu
 foreign_key492
 base/faq-bergsportreisen/fragen-zur-tour/
 aliasmein-bergfuehrer-meine-bergfuehrerin
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft450
 rght455
 route/faq-bergsportreisen/fragen-zur-tour/mein-bergfuehrer-meine-bergfuehrerin
 children(empty)
 4(array)
 Menu(array)
 id493
 hash1bfd0958fc558524d9973e9a7ade6b57
 created2017-03-28 15:10:19
 updated2017-03-28 15:10:19
 parent_id487
 lft89
 rght90
 language_id1
 typefaq
 titleDie Schwierigkeit der Bergtour
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1881
 hash09a926c94c047967ddcd296f8d6c070b
 created2017-03-28 15:10:19
 updated2017-03-28 15:10:19
 modelMenu
 foreign_key493
 base/faq-bergsportreisen/fragen-zur-tour/
 aliasdie-schwierigkeit-der-bergtour
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft456
 rght465
 route/faq-bergsportreisen/fragen-zur-tour/die-schwierigkeit-der-bergtour
 children(empty)
 5(array)
 Menu(array)
 id494
 hash8caf580aad706d584ea2395c9020c45e
 created2017-03-28 15:10:37
 updated2017-03-28 15:10:37
 parent_id487
 lft91
 rght92
 language_id1
 typefaq
 titleKinder & Jugendliche auf Bergtour
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1882
 hashc52c9a25632b320cac8062ca0ae0fe0a
 created2017-03-28 15:10:37
 updated2017-03-28 15:10:38
 modelMenu
 foreign_key494
 base/faq-bergsportreisen/fragen-zur-tour/
 aliaskinder-jugendliche-auf-bergtour
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft466
 rght471
 route/faq-bergsportreisen/fragen-zur-tour/kinder-jugendliche-auf-bergtour
 children(empty)
 6(array)
 Menu(array)
 id495
 hash3f7bccae24bfb83ef9f84977087628bd
 created2017-03-28 15:10:50
 updated2017-03-28 15:10:50
 parent_id487
 lft93
 rght94
 language_id1
 typefaq
 titleDie Mitreisenden | Mit wem bin ich unterwegs?
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1883
 hash35e7a267124138d71c3ba30f1781344d
 created2017-03-28 15:10:50
 updated2017-03-28 15:10:51
 modelMenu
 foreign_key495
 base/faq-bergsportreisen/fragen-zur-tour/
 aliasdie-mitreisenden-mit-wem-bin-ich-unterwegs
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft472
 rght477
 route/faq-bergsportreisen/fragen-zur-tour/die-mitreisenden-mit-wem-bin-ich-unterwegs
 children(empty)
 7(array)
 Menu(array)
 id496
 hash46c5b4227c97674f4e082de0f074dd83
 created2017-03-28 15:11:07
 updated2017-03-28 15:11:07
 parent_id487
 lft95
 rght96
 language_id1
 typefaq
 titleDas Risiko auf der Bergtour
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1884
 hashef676c168ed0ae7b79760dd1f03b2e23
 created2017-03-28 15:11:07
 updated2017-03-28 15:11:08
 modelMenu
 foreign_key496
 base/faq-bergsportreisen/fragen-zur-tour/
 aliasdas-risiko-auf-der-bergtour
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft478
 rght483
 route/faq-bergsportreisen/fragen-zur-tour/das-risiko-auf-der-bergtour
 children(empty)
 8(array)
 Menu(array)
 id497
 hashe776bf97d8f7e688e80710e2909163bd
 created2017-03-28 15:11:21
 updated2017-03-28 15:11:21
 parent_id487
 lft97
 rght98
 language_id1
 typefaq
 titleVerpflegung auf Tour
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1885
 hash6c3ba09f39c29624022d03a347eca744
 created2017-03-28 15:11:21
 updated2017-03-28 15:11:22
 modelMenu
 foreign_key497
 base/faq-bergsportreisen/fragen-zur-tour/
 aliasverpflegung-auf-tour
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1873
 lft484
 rght487
 route/faq-bergsportreisen/fragen-zur-tour/verpflegung-auf-tour
 children(empty)
 4(array)
 Menu(array)
 id488
 hash7bb26e4b38fd7980aa916765a756c645
 created2017-03-28 14:57:46
 updated2017-03-28 15:34:07
 parent_id5
 lft100
 rght111
 language_id1
 typefaq
 titleFragen zur Buchung
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1874
 hash8adbe7e1c9447861d375e7f0613df64c
 created2017-03-28 14:57:46
 updated2017-03-28 15:34:07
 modelMenu
 foreign_key488
 base/faq-bergsportreisen/
 aliasfragen-zur-buchung
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id6
 lft489
 rght530
 route/faq-bergsportreisen/fragen-zur-buchung
 children(array)
 0(array)
 Menu(array)
 id498
 hashc05add5c17ffdfbe37cc423d4f1a500e
 created2017-03-28 15:22:50
 updated2017-03-28 15:23:22
 parent_id488
 lft101
 rght102
 language_id1
 typefaq
 titleBuchungsablauf
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1903
 hash9274baabf81e067c415f4a3a58de92c3
 created2017-03-28 15:22:50
 updated2017-03-28 15:23:22
 modelMenu
 foreign_key498
 base/faq-bergsportreisen/fragen-zur-buchung/
 aliasbuchungsablauf
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1874
 lft490
 rght497
 route/faq-bergsportreisen/fragen-zur-buchung/buchungsablauf
 children(empty)
 1(array)
 Menu(array)
 id499
 hash91e5521c1b9596bd8f752c07be49a632
 created2017-03-28 15:23:13
 updated2017-03-28 15:23:13
 parent_id488
 lft103
 rght104
 language_id1
 typefaq
 titleBezahlung der gebuchten Reise
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1904
 hash42e79e093df13614c807e92db129e48a
 created2017-03-28 15:23:13
 updated2017-03-28 15:23:13
 modelMenu
 foreign_key499
 base/faq-bergsportreisen/fragen-zur-buchung/
 aliasbezahlung-der-gebuchten-reise
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1874
 lft498
 rght501
 route/faq-bergsportreisen/fragen-zur-buchung/bezahlung-der-gebuchten-reise
 children(empty)
 2(array)
 Menu(array)
 id500
 hash9e4cfbb64ea05c89df2dc7c377ff91fa
 created2017-03-28 15:23:36
 updated2017-03-28 15:23:36
 parent_id488
 lft105
 rght106
 language_id1
 typefaq
 titleAbsagegründe durch den Veranstalter
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1905
 hashdf9b6524d36800c4552ce140219212c2
 created2017-03-28 15:23:36
 updated2017-03-28 15:23:36
 modelMenu
 foreign_key500
 base/faq-bergsportreisen/fragen-zur-buchung/
 aliasabsagegruende-durch-den-veranstalter
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1874
 lft502
 rght511
 route/faq-bergsportreisen/fragen-zur-buchung/absagegruende-durch-den-veranstalter
 children(empty)
 3(array)
 Menu(array)
 id501
 hash8b9226a67b3e76dea85029cf8e2c7d93
 created2017-03-28 15:23:50
 updated2017-03-28 15:23:50
 parent_id488
 lft107
 rght108
 language_id1
 typefaq
 titleReiserücktritt & Umbuchung durch den Kunden
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1906
 hashaab173d0e12081a33256c9463347c559
 created2017-03-28 15:23:50
 updated2017-03-28 15:23:50
 modelMenu
 foreign_key501
 base/faq-bergsportreisen/fragen-zur-buchung/
 aliasreiseruecktritt-umbuchung-durch-den-kunden
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1874
 lft512
 rght519
 route/faq-bergsportreisen/fragen-zur-buchung/reiseruecktritt-umbuchung-durch-den-kunden
 children(empty)
 4(array)
 Menu(array)
 id502
 hashf6e113101328c09f264cf3a04925b9b7
 created2017-03-28 15:24:02
 updated2017-03-28 15:24:02
 parent_id488
 lft109
 rght110
 language_id1
 typefaq
 titleErmäßigungen und Preisnachlässe
 previous_url(null)
 url(null)
 target_blank(false)
 Route(array)
 id1907
 hash9f1ed693bbdd3c2a4a0ed72a7ad29d4b
 created2017-03-28 15:24:02
 updated2017-03-28 15:24:02
 modelMenu
 foreign_key502
 base/faq-bergsportreisen/fragen-zur-buchung/
 aliasermaessigungen-und-preisnachlaesse
 controllerFrontendMenus.FrontendMenus
 actionfaq
 parent_id1874
 lft520
 rght529
 route/faq-bergsportreisen/fragen-zur-buchung/ermaessigungen-und-preisnachlaesse
 children(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)
 Tour(empty)
 Types(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)
 Firm(empty)
 Tours(empty)
 Accomodations(empty)
 TeaserMedia(empty)
 Countries(empty)
 RegionAreas(empty)
 PackingListItems(empty)
 PackingList(empty)
 AccomodationImagesMedia(empty)
 EmailHeadMedia(empty)
 OutputChannel(empty)
 LogoMedia(empty)
 FaqItem(empty)
 FaqSet(empty)
 FaqItems(empty)
 Content(empty)
 Country(empty)
 TourType(empty)
 MountainGuideQualification(empty)
 ArticleContentMedia(empty)
 MosaicGalleryMedia(empty)
 TourFaqItemsForCustomer(empty)
 TourFaqItemsForMountainGuide(empty)
 Job(empty)
 MountainGuideDailyRate(empty)
 Region(empty)
 FileUpload(empty)
 TourTexts(empty)
 TourServicesTour(empty)
 TourTravelOptionsTour(empty)
 CountriesTour(empty)
 FirmsTour(empty)
 FaqItemsTour(empty)
 AccomodationsTour(empty)
 TourTravelOptionsTourDate(empty)
 FlagUpload(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7SocialMedia
 8LeafletJs
 9Leaflet
 10GMap
 11Embed
 12Layout
 13Recaptcha
 14ThirdPartyCookies
 15Wizard
 16Number
 17SimpleGraph
 18DebugTimer
 19Toolbar
 20LeafletEngine
 21Js
 22HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.2.27
User	u3939483948
Home	/var/www/vhosts/alpinewelten.com
Script Name	/webroot/index.php
Request Uri	/mtb-fahrtechnik?step=tour
Query String	step=tour
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/mtb-fahrtechnik
Redirect Query String	step=tour
Remote Port	58492
Script Filename	/var/www/vhosts/alpinewelten.com/httpdocs/webroot/index.php
Server Admin	plesk-admin@internetx.com
Context Document Root	/var/www/vhosts/alpinewelten.com/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/alpinewelten.com/httpdocs
Remote Addr	34.204.183.113
Server Port	443
Server Addr	85.236.49.170
Server Name	www.alpinewelten.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Accept Encoding	br,gzip
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	34.204.183.113
Http Host	www.alpinewelten.com
Proxy-nokeepalive	1
Https	on
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Http Authorization
Script Uri	https://www.alpinewelten.com/mtb-fahrtechnik
Script Url	/mtb-fahrtechnik
Unique Id	XkyK3k3f36FzUlWuy8rd9AAAARM
Redirect Status	200
Redirect Https	on
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Http Authorization
Redirect Script Uri	https://www.alpinewelten.com/mtb-fahrtechnik
Redirect Script Url	/mtb-fahrtechnik
Redirect Unique Id	XkyK3k3f36FzUlWuy8rd9AAAARM
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.alpinewelten.com/mtb-fahrtechnik
Redirect Redirect Script Url	/mtb-fahrtechnik
Redirect Redirect Unique Id	XkyK3k3f36FzUlWuy8rd9AAAARM
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1582074590.7006
Request Time	1582074590

====

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
  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
  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
  1APP/contrance/Vendor/Cake/lib/Cake/View/Helper/TimeHelper.php
  2APP/View/Helper/AppHelper.php
  3APP/contrance/Vendor/Cake/lib/Cake/View/Helper.php
  4APP/contrance/Vendor/Cake/lib/Cake/View/View.php
  5APP/contrance/Vendor/Cake/lib/Cake/View/ViewBlock.php
- plugins(array)
  Accomodations(array)
  Config(array)
  0Accomodations/Config/bootstrap.php
  Model(array)
  0Accomodations/Model/Accomodation.php
  1Accomodations/Model/AccomodationsAppModel.php
  ApiLogging(array)
  Config(array)
  0ApiLogging/Config/routes.php
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/BarcodeNumberBehavior.php
  11BaseData/Model/Behavior/HabtmBehavior.php
  12BaseData/Model/Behavior/ListBehavior.php
  Component(array)
  0BaseData/Controller/Component/WizardComponent.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
  FrontendTours(array)
  Config(array)
  0FrontendTours/Config/bootstrap.php
  1FrontendTours/Config/routes.php
  Controller(array)
  0FrontendTours/Controller/FrontendToursController.php
  1FrontendTours/Controller/FrontendToursAppController.php
  Component(array)
  0FrontendTours/Controller/Component/BookingWizardComponent.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
  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
  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/RegionArea.php
  1Regions/Model/RegionsAppModel.php
  2Regions/Model/Region.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
  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/TourTexts.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
====

MTB Fahrtechnik Wochenende Ulm
MTB Fahrtechnik Level I-III Kurs in Ulm, um Ulm und um Ulm herum

MTB Fahrtechnik Level I-III

Anforderungen

Reiseprogramm

Leistungen & Zusatzkosten

Leistungen inklusive

Reiseoptionen

Beschreibung der Region

Ausbildungsthemen im Kurs

Tourdauer:

Teilnehmer:

Land:

Alpine-Erfahrung:

Anforderungen:

Tourtermine:

Noch Fragen?

Lyngenalps

Island

Lofoten

Cookie Einstellungen

default

Total Time: 4 ms
Total Queries: 60 queries

Query Explain:

Memory

Timers

MTB Fahrtechnik Wochenende Ulm MTB Fahrtechnik Level I-III Kurs in Ulm, um Ulm und um Ulm herum

MTB Fahrtechnik Level I-III

Anforderungen

Reiseprogramm

Leistungen & Zusatzkosten

Leistungen inklusive

Reiseoptionen

Beschreibung der Region

Ausbildungsthemen im Kurs

Tourdauer:

Teilnehmer:

Land:

Alpine-Erfahrung:

Anforderungen:

Tourtermine:

Noch Fragen?

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 4 ms Total Queries: 60 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

MTB Fahrtechnik Wochenende Ulm
MTB Fahrtechnik Level I-III Kurs in Ulm, um Ulm und um Ulm herum

Total Time: 4 ms
Total Queries: 60 queries