Waldschwimmbad in Teisendorf

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgentca40b5f22cf3d88f707fb259b2686ed4
  time1563287417
  countdown10
  languagede
====
Request
+
Request

Cake Params
- pluginFrontendPOI
- controllerFrontendPOI
- actionpoi
- named(empty)
- pass(array)
  016
- ids(array)
  Menu(null)
  Content(null)
  Language1
  POII18n16
- route(array)
  id146
  hash724eaae846ee2616661faee1da996e2c
  created2018-09-17 14:55:34
  updated2019-03-05 12:19:13
  modelPOII18n
  foreign_key16
  base/
  aliaswaldschwimmbad-teisendorf
  controllerFrontendPOI.FrontendPOI
  actionpoi
  parent_id1
  lft750
  rght751
  route/waldschwimmbad-teisendorf
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(empty)
- options(empty)
- defaults(array)
  plugin(null)
  actionindex
- template/*
====

Sql Logs

default

Total Time: 16 ms
Total Queries: 149 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 `piding`.`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`))) = '/waldschwimmbad-teisendorf' LIMIT 1	1	1	1
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `piding`.`routes` AS `Route` WHERE `Route`.`lft` <= 750 AND `Route`.`rght` >= 751 ORDER BY `Route`.`lft` asc	2	2	1	maybe slow
SELECT `Language`.`langid` FROM `piding`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1	1	1	0
SELECT `POII18n`.`id`, `POII18n`.`hash`, `POII18n`.`created`, `POII18n`.`updated`, `POII18n`.`title`, `POII18n`.`poi_id`, `POII18n`.`language_id`, `POII18n`.`short_description`, `POII18n`.`description_1`, `POII18n`.`description_2`, `POII18n`.`description_3`, `POII18n`.`price_list`, `POII18n`.`openings`, `POII18n`.`approaches`, `POII18n`.`awards`, `POII18n`.`accommodation`, `POII18n`.`host`, `POII18n`.`starting_point_description`, `POII18n`.`website`, `POII18n`.`video_url1`, `POII18n`.`additional_information_and_links`, `POII18n`.`sub_title`, `POII18n`.`teaser_title`, `POII18n`.`video_url2`, `POII18n`.`video_url3`, `POII18n`.`hosting`, `POII18n`.`file1_title`, `POII18n`.`file2_title`, `POII18n`.`file3_title`, `POII18n`.`gallery1_title`, `POII18n`.`gallery2_title`, `POII18n`.`gallery3_title`, `POII18n`.`gallery4_title`, `POII18n`.`gallery5_title`, `POII18n`.`gallery6_title`, `POII18n`.`gallery7_title`, `POII18n`.`gallery8_title`, `POII18n`.`gallery9_title`, `POII18n`.`gallery10_title`, `POII18n`.`tickets_button_text`, `POI`.`id`, `POI`.`hash`, `POI`.`created`, `POI`.`updated`, `POI`.`internal_title`, `POI`.`ordering_number`, `POI`.`address_zip`, `POI`.`address_city`, `POI`.`address_street`, `POI`.`address_country`, `POI`.`address_lat`, `POI`.`address_long`, `POI`.`phone`, `POI`.`email`, `POI`.`fax`, `POI`.`starting_point_zip`, `POI`.`starting_point_city`, `POI`.`starting_point_street`, `POI`.`starting_point_country`, `POI`.`starting_point_lat`, `POI`.`starting_point_long`, `POI`.`accessibility`, `POI`.`webcam`, `POI`.`height`, `POI`.`overnight_stay`, `POI`.`alpine_club`, `POI`.`family_friendly`, `POI`.`tip_for_bad_weather`, `POI`.`tickets`, `POI`.`seasons`, `POI`.`categories`, `POI`.`external_id`, `POI`.`customer_fax`, `POI`.`customer_mobile`, `POI`.`customer_phone`, `POI`.`customer_web`, `POI`.`customer_email`, `POI`.`customer_company`, `POI`.`customer_salutation`, `POI`.`customer_name`, `POI`.`customer_first_name`, `POI`.`customer_street`, `POI`.`customer_zip`, `POI`.`customer_city`, `POI`.`customer_country`, `POI`.`show_customer_communication_address`, `POI`.`municipality`, `POI`.`status`, `POI`.`gallery1_position`, `POI`.`gallery2_position`, `POI`.`gallery3_position`, `POI`.`gallery4_position`, `POI`.`gallery5_position`, `POI`.`gallery6_position`, `POI`.`gallery7_position`, `POI`.`gallery8_position`, `POI`.`gallery9_position`, `POI`.`gallery10_position`, `POI`.`webcam_layout`, `POI`.`advertising_banner_id`, `POI`.`widget_code`, (CONCAT_WS (',',`POI`.`address_lat`,`POI`.`address_long`)) AS `POI__address`, (CONCAT_WS (',',`POI`.`starting_point_lat`,`POI`.`starting_point_long`)) AS `POI__starting_point` FROM `piding`.`poi_i18n` AS `POII18n` LEFT JOIN `piding`.`poi` AS `POI` ON (`POII18n`.`poi_id` = `POI`.`id`) WHERE `POII18n`.`id` = 16 AND `POI`.`status` = 'active' LIMIT 1	1	1	1
SELECT `Gallery1Upload`.`id`, `Gallery1Upload`.`hash`, `Gallery1Upload`.`created`, `Gallery1Upload`.`updated`, `Gallery1Upload`.`model`, `Gallery1Upload`.`field`, `Gallery1Upload`.`foreign_key`, `Gallery1Upload`.`alias`, `Gallery1Upload`.`thumbnail`, `Gallery1Upload`.`parent_id`, `Gallery1Upload`.`file`, `Gallery1Upload`.`size`, `Gallery1Upload`.`ext`, `Gallery1Upload`.`mime`, `Gallery1Upload`.`width`, `Gallery1Upload`.`height` FROM `piding`.`uploads` AS `Gallery1Upload` WHERE `Gallery1Upload`.`model` = 'POI' AND `Gallery1Upload`.`field` = 'gallery1' AND `Gallery1Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery1Upload`.`thumbnail`, -1), -1) DESC	1	1	1
SELECT `Gallery2Upload`.`id`, `Gallery2Upload`.`hash`, `Gallery2Upload`.`created`, `Gallery2Upload`.`updated`, `Gallery2Upload`.`model`, `Gallery2Upload`.`field`, `Gallery2Upload`.`foreign_key`, `Gallery2Upload`.`alias`, `Gallery2Upload`.`thumbnail`, `Gallery2Upload`.`parent_id`, `Gallery2Upload`.`file`, `Gallery2Upload`.`size`, `Gallery2Upload`.`ext`, `Gallery2Upload`.`mime`, `Gallery2Upload`.`width`, `Gallery2Upload`.`height` FROM `piding`.`uploads` AS `Gallery2Upload` WHERE `Gallery2Upload`.`model` = 'POI' AND `Gallery2Upload`.`field` = 'gallery2' AND `Gallery2Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery2Upload`.`thumbnail`, -1), -1) DESC	1	1	1
SELECT `Gallery3Upload`.`id`, `Gallery3Upload`.`hash`, `Gallery3Upload`.`created`, `Gallery3Upload`.`updated`, `Gallery3Upload`.`model`, `Gallery3Upload`.`field`, `Gallery3Upload`.`foreign_key`, `Gallery3Upload`.`alias`, `Gallery3Upload`.`thumbnail`, `Gallery3Upload`.`parent_id`, `Gallery3Upload`.`file`, `Gallery3Upload`.`size`, `Gallery3Upload`.`ext`, `Gallery3Upload`.`mime`, `Gallery3Upload`.`width`, `Gallery3Upload`.`height` FROM `piding`.`uploads` AS `Gallery3Upload` WHERE `Gallery3Upload`.`model` = 'POI' AND `Gallery3Upload`.`field` = 'gallery3' AND `Gallery3Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery3Upload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Gallery4Upload`.`id`, `Gallery4Upload`.`hash`, `Gallery4Upload`.`created`, `Gallery4Upload`.`updated`, `Gallery4Upload`.`model`, `Gallery4Upload`.`field`, `Gallery4Upload`.`foreign_key`, `Gallery4Upload`.`alias`, `Gallery4Upload`.`thumbnail`, `Gallery4Upload`.`parent_id`, `Gallery4Upload`.`file`, `Gallery4Upload`.`size`, `Gallery4Upload`.`ext`, `Gallery4Upload`.`mime`, `Gallery4Upload`.`width`, `Gallery4Upload`.`height` FROM `piding`.`uploads` AS `Gallery4Upload` WHERE `Gallery4Upload`.`model` = 'POI' AND `Gallery4Upload`.`field` = 'gallery4' AND `Gallery4Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery4Upload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Gallery5Upload`.`id`, `Gallery5Upload`.`hash`, `Gallery5Upload`.`created`, `Gallery5Upload`.`updated`, `Gallery5Upload`.`model`, `Gallery5Upload`.`field`, `Gallery5Upload`.`foreign_key`, `Gallery5Upload`.`alias`, `Gallery5Upload`.`thumbnail`, `Gallery5Upload`.`parent_id`, `Gallery5Upload`.`file`, `Gallery5Upload`.`size`, `Gallery5Upload`.`ext`, `Gallery5Upload`.`mime`, `Gallery5Upload`.`width`, `Gallery5Upload`.`height` FROM `piding`.`uploads` AS `Gallery5Upload` WHERE `Gallery5Upload`.`model` = 'POI' AND `Gallery5Upload`.`field` = 'gallery5' AND `Gallery5Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery5Upload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Gallery6Upload`.`id`, `Gallery6Upload`.`hash`, `Gallery6Upload`.`created`, `Gallery6Upload`.`updated`, `Gallery6Upload`.`model`, `Gallery6Upload`.`field`, `Gallery6Upload`.`foreign_key`, `Gallery6Upload`.`alias`, `Gallery6Upload`.`thumbnail`, `Gallery6Upload`.`parent_id`, `Gallery6Upload`.`file`, `Gallery6Upload`.`size`, `Gallery6Upload`.`ext`, `Gallery6Upload`.`mime`, `Gallery6Upload`.`width`, `Gallery6Upload`.`height` FROM `piding`.`uploads` AS `Gallery6Upload` WHERE `Gallery6Upload`.`model` = 'POI' AND `Gallery6Upload`.`field` = 'gallery6' AND `Gallery6Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery6Upload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Gallery7Upload`.`id`, `Gallery7Upload`.`hash`, `Gallery7Upload`.`created`, `Gallery7Upload`.`updated`, `Gallery7Upload`.`model`, `Gallery7Upload`.`field`, `Gallery7Upload`.`foreign_key`, `Gallery7Upload`.`alias`, `Gallery7Upload`.`thumbnail`, `Gallery7Upload`.`parent_id`, `Gallery7Upload`.`file`, `Gallery7Upload`.`size`, `Gallery7Upload`.`ext`, `Gallery7Upload`.`mime`, `Gallery7Upload`.`width`, `Gallery7Upload`.`height` FROM `piding`.`uploads` AS `Gallery7Upload` WHERE `Gallery7Upload`.`model` = 'POI' AND `Gallery7Upload`.`field` = 'gallery7' AND `Gallery7Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery7Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Gallery8Upload`.`id`, `Gallery8Upload`.`hash`, `Gallery8Upload`.`created`, `Gallery8Upload`.`updated`, `Gallery8Upload`.`model`, `Gallery8Upload`.`field`, `Gallery8Upload`.`foreign_key`, `Gallery8Upload`.`alias`, `Gallery8Upload`.`thumbnail`, `Gallery8Upload`.`parent_id`, `Gallery8Upload`.`file`, `Gallery8Upload`.`size`, `Gallery8Upload`.`ext`, `Gallery8Upload`.`mime`, `Gallery8Upload`.`width`, `Gallery8Upload`.`height` FROM `piding`.`uploads` AS `Gallery8Upload` WHERE `Gallery8Upload`.`model` = 'POI' AND `Gallery8Upload`.`field` = 'gallery8' AND `Gallery8Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery8Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Gallery9Upload`.`id`, `Gallery9Upload`.`hash`, `Gallery9Upload`.`created`, `Gallery9Upload`.`updated`, `Gallery9Upload`.`model`, `Gallery9Upload`.`field`, `Gallery9Upload`.`foreign_key`, `Gallery9Upload`.`alias`, `Gallery9Upload`.`thumbnail`, `Gallery9Upload`.`parent_id`, `Gallery9Upload`.`file`, `Gallery9Upload`.`size`, `Gallery9Upload`.`ext`, `Gallery9Upload`.`mime`, `Gallery9Upload`.`width`, `Gallery9Upload`.`height` FROM `piding`.`uploads` AS `Gallery9Upload` WHERE `Gallery9Upload`.`model` = 'POI' AND `Gallery9Upload`.`field` = 'gallery9' AND `Gallery9Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery9Upload`.`thumbnail`, -1), -1) DESC	0	0	1	maybe slow
SELECT `Gallery10Upload`.`id`, `Gallery10Upload`.`hash`, `Gallery10Upload`.`created`, `Gallery10Upload`.`updated`, `Gallery10Upload`.`model`, `Gallery10Upload`.`field`, `Gallery10Upload`.`foreign_key`, `Gallery10Upload`.`alias`, `Gallery10Upload`.`thumbnail`, `Gallery10Upload`.`parent_id`, `Gallery10Upload`.`file`, `Gallery10Upload`.`size`, `Gallery10Upload`.`ext`, `Gallery10Upload`.`mime`, `Gallery10Upload`.`width`, `Gallery10Upload`.`height` FROM `piding`.`uploads` AS `Gallery10Upload` WHERE `Gallery10Upload`.`model` = 'POI' AND `Gallery10Upload`.`field` = 'gallery10' AND `Gallery10Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`Gallery10Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `piding`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'POI' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `piding`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'POI' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Webcam`.`id`, `Webcam`.`hash`, `Webcam`.`created`, `Webcam`.`updated`, `Webcam`.`title`, `Webcam`.`type`, `Webcam`.`url`, `Webcam`.`thumbnail_url`, `Webcam`.`height`, `Webcam`.`external_id`, `PoiWebcam`.`id`, `PoiWebcam`.`webcam_id`, `PoiWebcam`.`poi_id`, `PoiWebcam`.`position` FROM `piding`.`webcams` AS `Webcam` JOIN `piding`.`poi_webcams` AS `PoiWebcam` ON (`PoiWebcam`.`poi_id` = 16 AND `PoiWebcam`.`webcam_id` = `Webcam`.`id`) ORDER BY `PoiWebcam`.`position` ASC	0	0	0
SELECT `AwardLogoUpload`.`id`, `AwardLogoUpload`.`hash`, `AwardLogoUpload`.`created`, `AwardLogoUpload`.`updated`, `AwardLogoUpload`.`model`, `AwardLogoUpload`.`field`, `AwardLogoUpload`.`foreign_key`, `AwardLogoUpload`.`alias`, `AwardLogoUpload`.`thumbnail`, `AwardLogoUpload`.`parent_id`, `AwardLogoUpload`.`file`, `AwardLogoUpload`.`size`, `AwardLogoUpload`.`ext`, `AwardLogoUpload`.`mime`, `AwardLogoUpload`.`width`, `AwardLogoUpload`.`height` FROM `piding`.`uploads` AS `AwardLogoUpload` WHERE `AwardLogoUpload`.`model` = 'POII18n' AND `AwardLogoUpload`.`field` = 'award_logo' AND `AwardLogoUpload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`AwardLogoUpload`.`thumbnail`, -1), -1) DESC	0	0	1	maybe slow
SELECT `File1Upload`.`id`, `File1Upload`.`hash`, `File1Upload`.`created`, `File1Upload`.`updated`, `File1Upload`.`model`, `File1Upload`.`field`, `File1Upload`.`foreign_key`, `File1Upload`.`alias`, `File1Upload`.`thumbnail`, `File1Upload`.`parent_id`, `File1Upload`.`file`, `File1Upload`.`size`, `File1Upload`.`ext`, `File1Upload`.`mime`, `File1Upload`.`width`, `File1Upload`.`height` FROM `piding`.`uploads` AS `File1Upload` WHERE `File1Upload`.`model` = 'POII18n' AND `File1Upload`.`field` = 'file1' AND `File1Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`File1Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `File2Upload`.`id`, `File2Upload`.`hash`, `File2Upload`.`created`, `File2Upload`.`updated`, `File2Upload`.`model`, `File2Upload`.`field`, `File2Upload`.`foreign_key`, `File2Upload`.`alias`, `File2Upload`.`thumbnail`, `File2Upload`.`parent_id`, `File2Upload`.`file`, `File2Upload`.`size`, `File2Upload`.`ext`, `File2Upload`.`mime`, `File2Upload`.`width`, `File2Upload`.`height` FROM `piding`.`uploads` AS `File2Upload` WHERE `File2Upload`.`model` = 'POII18n' AND `File2Upload`.`field` = 'file2' AND `File2Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`File2Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `File3Upload`.`id`, `File3Upload`.`hash`, `File3Upload`.`created`, `File3Upload`.`updated`, `File3Upload`.`model`, `File3Upload`.`field`, `File3Upload`.`foreign_key`, `File3Upload`.`alias`, `File3Upload`.`thumbnail`, `File3Upload`.`parent_id`, `File3Upload`.`file`, `File3Upload`.`size`, `File3Upload`.`ext`, `File3Upload`.`mime`, `File3Upload`.`width`, `File3Upload`.`height` FROM `piding`.`uploads` AS `File3Upload` WHERE `File3Upload`.`model` = 'POII18n' AND `File3Upload`.`field` = 'file3' AND `File3Upload`.`foreign_key` = (16) ORDER BY FIELD(COALESCE(`File3Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Host`.`id`, `Host`.`hash`, `Host`.`created`, `Host`.`updated`, `Host`.`title`, `Host`.`host_group_id`, `Host`.`external_id`, `Host`.`output_channel`, `Host`.`category`, `Host`.`stars_sorting`, `Host`.`stars_count`, `Host`.`stars_text`, `Host`.`price_minimum`, `Host`.`price_maximum`, `Host`.`price_1a`, `Host`.`price_1b`, `Host`.`price_1c`, `Host`.`price_2a`, `Host`.`price_2b`, `Host`.`price_2c`, `Host`.`price_3a`, `Host`.`price_3b`, `Host`.`price_4a`, `Host`.`price_4b`, `Host`.`price_camping_1_1`, `Host`.`price_camping_1_2`, `Host`.`price_camping_2_1`, `Host`.`price_camping_2_2`, `Host`.`price_camping_3_1`, `Host`.`price_camping_3_2`, `Host`.`price_camping_4_1`, `Host`.`price_camping_4_2`, `Host`.`price_camping_5_1`, `Host`.`price_camping_5_2`, `Host`.`format_sorting`, `Host`.`booking_url`, `Host`.`irs_detail_url`, `Host`.`owner`, `Host`.`street`, `Host`.`place`, `Host`.`email`, `Host`.`website_url`, `Host`.`phone`, `Host`.`mobile`, `Host`.`fax`, `Host`.`youtube_url1`, `Host`.`youtube_url2`, `Host`.`trustyou_id`, `Host`.`shorttext`, `Host`.`next_busstop`, `Host`.`busstop_minutes_by_foot`, `Host`.`house_prospect_url`, `Host`.`webtext`, `Host`.`map_lat`, `Host`.`map_long`, `Host`.`status`, `Host`.`tomas_id`, `Host`.`previous_url`, `Host`.`2bedroom`, `Host`.`3bedroom`, `Host`.`4bedroom`, `Host`.`mbedroom`, `Host`.`webcam_image`, `Host`.`webcam_link`, `Host`.`opening_hours`, `Host`.`parking_lots`, `Host`.`altitude`, `Host`.`digiggv`, `Host`.`image_order`, (CONCAT_WS (',',`Host`.`map_lat`,`Host`.`map_long`)) AS `Host__map`, `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 `piding`.`hosts` AS `Host` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Host`.`id` AND `Route`.`model` = 'Host') WHERE `Host`.`output_channel` = 'ggv' AND `Host`.`format_sorting` IN (1, 2, 3) ORDER BY `Host`.`format_sorting`=1 DESC, RAND() ASC LIMIT 4	0	0	2	maybe slow
SELECT `Host`.`id`, `Host`.`hash`, `Host`.`created`, `Host`.`updated`, `Host`.`title`, `Host`.`host_group_id`, `Host`.`external_id`, `Host`.`output_channel`, `Host`.`category`, `Host`.`stars_sorting`, `Host`.`stars_count`, `Host`.`stars_text`, `Host`.`price_minimum`, `Host`.`price_maximum`, `Host`.`price_1a`, `Host`.`price_1b`, `Host`.`price_1c`, `Host`.`price_2a`, `Host`.`price_2b`, `Host`.`price_2c`, `Host`.`price_3a`, `Host`.`price_3b`, `Host`.`price_4a`, `Host`.`price_4b`, `Host`.`price_camping_1_1`, `Host`.`price_camping_1_2`, `Host`.`price_camping_2_1`, `Host`.`price_camping_2_2`, `Host`.`price_camping_3_1`, `Host`.`price_camping_3_2`, `Host`.`price_camping_4_1`, `Host`.`price_camping_4_2`, `Host`.`price_camping_5_1`, `Host`.`price_camping_5_2`, `Host`.`format_sorting`, `Host`.`booking_url`, `Host`.`irs_detail_url`, `Host`.`owner`, `Host`.`street`, `Host`.`place`, `Host`.`email`, `Host`.`website_url`, `Host`.`phone`, `Host`.`mobile`, `Host`.`fax`, `Host`.`youtube_url1`, `Host`.`youtube_url2`, `Host`.`trustyou_id`, `Host`.`shorttext`, `Host`.`next_busstop`, `Host`.`busstop_minutes_by_foot`, `Host`.`house_prospect_url`, `Host`.`webtext`, `Host`.`map_lat`, `Host`.`map_long`, `Host`.`status`, `Host`.`tomas_id`, `Host`.`previous_url`, `Host`.`2bedroom`, `Host`.`3bedroom`, `Host`.`4bedroom`, `Host`.`mbedroom`, `Host`.`webcam_image`, `Host`.`webcam_link`, `Host`.`opening_hours`, `Host`.`parking_lots`, `Host`.`altitude`, `Host`.`digiggv`, `Host`.`image_order`, (CONCAT_WS (',',`Host`.`map_lat`,`Host`.`map_long`)) AS `Host__map`, `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 `piding`.`hosts` AS `Host` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Host`.`id` AND `Route`.`model` = 'Host') WHERE `Host`.`output_channel` = 'wellness' ORDER BY (`Host`.`format_sorting` IS NULL), `Host`.`format_sorting` ASC, RAND("fa7b2c099085ec4d73ffe1c1881e6559") LIMIT 4	0	0	1	maybe slow
SELECT `HostGroup`.`id`, `HostGroup`.`title` FROM `piding`.`host_groups` AS `HostGroup` JOIN `piding`.`hosts` AS `Host` ON (`Host`.`host_group_id` = `HostGroup`.`id`) WHERE 1 = 1 GROUP BY `HostGroup`.`id`	0	0	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'show-all-hosts' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'quick-search' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'offers-flatrates' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'hosts' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`canonical_url`, `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 `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `piding`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 13 LIMIT 1	1	1	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (13) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (13) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 13 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `piding`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (13) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'health' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`canonical_url`, `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 `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `piding`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 12 LIMIT 1	1	1	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (12) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 12 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (12) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 12 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `piding`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (12) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'header' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 5 AND `Menu`.`rght` < 142 ORDER BY `Menu`.`lft` asc	68	68	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-service' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`canonical_url`, `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 `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `piding`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 11 LIMIT 1	1	1	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 11 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 11 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `piding`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (11) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`employee_id`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`canonical_url`, `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 `piding`.`contents` AS `Content` LEFT JOIN `piding`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `piding`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `piding`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 11 AND `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1'	1	1	2	maybe slow
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (23) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 23 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (23) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 23 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `WeatherMapUpload`.`id`, `WeatherMapUpload`.`hash`, `WeatherMapUpload`.`created`, `WeatherMapUpload`.`updated`, `WeatherMapUpload`.`model`, `WeatherMapUpload`.`field`, `WeatherMapUpload`.`foreign_key`, `WeatherMapUpload`.`alias`, `WeatherMapUpload`.`thumbnail`, `WeatherMapUpload`.`parent_id`, `WeatherMapUpload`.`file`, `WeatherMapUpload`.`size`, `WeatherMapUpload`.`ext`, `WeatherMapUpload`.`mime`, `WeatherMapUpload`.`width`, `WeatherMapUpload`.`height` FROM `piding`.`uploads` AS `WeatherMapUpload` WHERE `WeatherMapUpload`.`model` = 'Content' AND `WeatherMapUpload`.`field` = 'weather_map' AND `WeatherMapUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`WeatherMapUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, `ArticleContentMedia`.`status`, `ArticleContentMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) AS `ArticleContentMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `piding`.`media` AS `ArticleContentMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (111) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, `GalleryMedia`.`status`, `GalleryMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`) AS `GalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `piding`.`media` AS `GalleryMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `WebradioHeaderImageMedia`.`id`, `WebradioHeaderImageMedia`.`hash`, `WebradioHeaderImageMedia`.`created`, `WebradioHeaderImageMedia`.`updated`, `WebradioHeaderImageMedia`.`title`, `WebradioHeaderImageMedia`.`status`, `WebradioHeaderImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `WebradioHeaderImageMedia`.`id`) AS `WebradioHeaderImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `piding`.`media` AS `WebradioHeaderImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `WebradioHeaderImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'webradio_header_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `SnowReportImageMedia`.`id`, `SnowReportImageMedia`.`hash`, `SnowReportImageMedia`.`created`, `SnowReportImageMedia`.`updated`, `SnowReportImageMedia`.`title`, `SnowReportImageMedia`.`status`, `SnowReportImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `SnowReportImageMedia`.`id`) AS `SnowReportImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `piding`.`media` AS `SnowReportImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `SnowReportImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'snow_report_image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LakeReportGalleryMedia`.`id`, `LakeReportGalleryMedia`.`hash`, `LakeReportGalleryMedia`.`created`, `LakeReportGalleryMedia`.`updated`, `LakeReportGalleryMedia`.`title`, `LakeReportGalleryMedia`.`status`, `LakeReportGalleryMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LakeReportGalleryMedia`.`id`) AS `LakeReportGalleryMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `piding`.`media` AS `LakeReportGalleryMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `LakeReportGalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'lake_report_gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `DownloadTeaserFileMedia`.`id`, `DownloadTeaserFileMedia`.`hash`, `DownloadTeaserFileMedia`.`created`, `DownloadTeaserFileMedia`.`updated`, `DownloadTeaserFileMedia`.`title`, `DownloadTeaserFileMedia`.`status`, `DownloadTeaserFileMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `DownloadTeaserFileMedia`.`id`) AS `DownloadTeaserFileMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `piding`.`media` AS `DownloadTeaserFileMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `DownloadTeaserFileMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'download_teaser_file' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `POI`.`id`, `POI`.`hash`, `POI`.`created`, `POI`.`updated`, `POI`.`internal_title`, `POI`.`ordering_number`, `POI`.`address_zip`, `POI`.`address_city`, `POI`.`address_street`, `POI`.`address_country`, `POI`.`address_lat`, `POI`.`address_long`, `POI`.`phone`, `POI`.`email`, `POI`.`fax`, `POI`.`starting_point_zip`, `POI`.`starting_point_city`, `POI`.`starting_point_street`, `POI`.`starting_point_country`, `POI`.`starting_point_lat`, `POI`.`starting_point_long`, `POI`.`accessibility`, `POI`.`webcam`, `POI`.`height`, `POI`.`overnight_stay`, `POI`.`alpine_club`, `POI`.`family_friendly`, `POI`.`tip_for_bad_weather`, `POI`.`tickets`, `POI`.`seasons`, `POI`.`categories`, `POI`.`external_id`, `POI`.`customer_fax`, `POI`.`customer_mobile`, `POI`.`customer_phone`, `POI`.`customer_web`, `POI`.`customer_email`, `POI`.`customer_company`, `POI`.`customer_salutation`, `POI`.`customer_name`, `POI`.`customer_first_name`, `POI`.`customer_street`, `POI`.`customer_zip`, `POI`.`customer_city`, `POI`.`customer_country`, `POI`.`show_customer_communication_address`, `POI`.`municipality`, `POI`.`status`, `POI`.`gallery1_position`, `POI`.`gallery2_position`, `POI`.`gallery3_position`, `POI`.`gallery4_position`, `POI`.`gallery5_position`, `POI`.`gallery6_position`, `POI`.`gallery7_position`, `POI`.`gallery8_position`, `POI`.`gallery9_position`, `POI`.`gallery10_position`, `POI`.`webcam_layout`, `POI`.`advertising_banner_id`, `POI`.`widget_code`, (CONCAT_WS (',',`POI`.`address_lat`,`POI`.`address_long`)) AS `POI__address`, (CONCAT_WS (',',`POI`.`starting_point_lat`,`POI`.`starting_point_long`)) AS `POI__starting_point`, `ContentsPoi`.`id`, `ContentsPoi`.`content_id`, `ContentsPoi`.`poi_id`, `ContentsPoi`.`position` FROM `piding`.`poi` AS `POI` JOIN `piding`.`contents_poi` AS `ContentsPoi` ON (`ContentsPoi`.`content_id` = 1 AND `ContentsPoi`.`poi_id` = `POI`.`id`) ORDER BY `ContentsPoi`.`position` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social-media' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 144 AND `Menu`.`rght` < 147 ORDER BY `Menu`.`lft` asc	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `piding`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-partner' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 180 AND `Menu`.`rght` < 201 ORDER BY `Menu`.`lft` asc	10	10	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 15 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 275 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (110) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 16 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (102) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 276 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (103) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 277 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (106) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 278 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (109) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 279 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (104) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 280 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (105) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 281 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (108) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 282 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 `piding`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (107) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	4	4	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `piding`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` IN (15, 75, 16, 76, 77, 78, 79, 80, 81, 82) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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 `piding`.`languages` AS `Language` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1	1	1	0
SELECT `FlagUpload`.`id`, `FlagUpload`.`hash`, `FlagUpload`.`created`, `FlagUpload`.`updated`, `FlagUpload`.`model`, `FlagUpload`.`field`, `FlagUpload`.`foreign_key`, `FlagUpload`.`alias`, `FlagUpload`.`thumbnail`, `FlagUpload`.`parent_id`, `FlagUpload`.`file`, `FlagUpload`.`size`, `FlagUpload`.`ext`, `FlagUpload`.`mime`, `FlagUpload`.`width`, `FlagUpload`.`height` FROM `piding`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC	2	2	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`.`canonical_url` FROM `piding`.`seo` AS `Seo` WHERE `Seo`.`model` = 'POII18n' AND `Seo`.`foreign_key` = 16 LIMIT 1	1	1	1
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (142) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	4	4	1	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 142 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`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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 `piding`.`languages` AS `Language` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `langid` = 'de' LIMIT 1	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'languages' AND `Language`.`langid` = 'en' LIMIT 1	0	0	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE 1 != 1 ORDER BY `Menu`.`lft` asc	0	0	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` FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'home' AND `MountPoint`.`language_id` = 1 LIMIT 1	1	1	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'home' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view` FROM `piding`.`menus` AS `Menu` WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `piding`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'sidebar_nav' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 207 AND `Menu`.`rght` < 208 ORDER BY `Menu`.`lft` asc	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `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 `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 148 AND `Menu`.`rght` < 173 ORDER BY `Menu`.`lft` asc	12	12	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'news' AND `Language`.`langid` = 'de' LIMIT 1	1	1	0
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `Menu`.`calendar_label_type`, `Menu`.`ad_types`, `Menu`.`breadcrumb_no_link`, `Menu`.`teaser_search_result_view`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default`, `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`.`canonical_url`, `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 `piding`.`menus` AS `Menu` LEFT JOIN `piding`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `piding`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 103 LIMIT 1	1	1	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Seo' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (382) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 382 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageUpload`.`id`, `ImageUpload`.`hash`, `ImageUpload`.`created`, `ImageUpload`.`updated`, `ImageUpload`.`model`, `ImageUpload`.`field`, `ImageUpload`.`foreign_key`, `ImageUpload`.`alias`, `ImageUpload`.`thumbnail`, `ImageUpload`.`parent_id`, `ImageUpload`.`file`, `ImageUpload`.`size`, `ImageUpload`.`ext`, `ImageUpload`.`mime`, `ImageUpload`.`width`, `ImageUpload`.`height` FROM `piding`.`uploads` AS `ImageUpload` WHERE `ImageUpload`.`model` = 'Teaser' AND `ImageUpload`.`field` = '_image' AND `ImageUpload`.`foreign_key` = (340) ORDER BY FIELD(COALESCE(`ImageUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, `ImageMedia`.`status`, `ImageMedia`.`description`, (SELECT COUNT(1) FROM `piding`.`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 `piding`.`media` AS `ImageMedia` JOIN `piding`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 340 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `IconUpload`.`id`, `IconUpload`.`hash`, `IconUpload`.`created`, `IconUpload`.`updated`, `IconUpload`.`model`, `IconUpload`.`field`, `IconUpload`.`foreign_key`, `IconUpload`.`alias`, `IconUpload`.`thumbnail`, `IconUpload`.`parent_id`, `IconUpload`.`file`, `IconUpload`.`size`, `IconUpload`.`ext`, `IconUpload`.`mime`, `IconUpload`.`width`, `IconUpload`.`height` FROM `piding`.`uploads` AS `IconUpload` WHERE `IconUpload`.`model` = 'Menu' AND `IconUpload`.`field` = 'icon' AND `IconUpload`.`foreign_key` = (103) ORDER BY FIELD(COALESCE(`IconUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Content`.`id`, `Content`.`snow_report_poi_id`, `Content`.`snow_report_ski_area_id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`layout`, `Content`.`links_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_cc`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`flatrate_id`, `Content`.`gmap_zoom`, `Content`.`video_type`, `Content`.`menu_teaser_menu_id`, `Content`.`video_url`, `Content`.`gmap_long`, `Content`.`flatrate_index_tag_id`, `Content`.`gmap_marker`, `Content`.`gmap_type`, `Content`.`gmap_lat`, `Content`.`url_teaser_url`, `Content`.`url_teaser_target`, `Content`.`flex_view_id`, `Content`.`rit_agb`, `Content`.`webcam_image`, `Content`.`webcam_url`, `Content`.`webcam_type`, `Content`.`webcam_height`, `Content`.`host_search_output_channel`, `Content`.`webradio_url`, `Content`.`flatrate_request_lang`, `Content`.`snow_report_weather_url`, `Content`.`snow_report_weather_url_target`, `Content`.`snow_report_price_url`, `Content`.`snow_report_price_url_target`, `Content`.`snow_report_phone`, `Content`.`snow_report_webcam_title`, `Content`.`snow_report_webcam_image`, `Content`.`snow_report_webcam_title_2`, `Content`.`snow_report_webcam_image_2`, `Content`.`lake_report_bergfex_lake_id`, `Content`.`lake_report_custom_title`, `Content`.`lake_report_title`, `Content`.`lake_report_article`, `Content`.`lake_report_weather_location`, `Content`.`lake_webcam_image`, `Content`.`lake_webcam_title`, `Content`.`lake_webcam_title_2`, `Content`.`lake_webcam_image_2`, `Content`.`teaser_banner`, `Content`.`developer_template_code`, `Content`.`float_left`, `Content`.`developer_template_js`, `Content`.`developer_template_css`, `Content`.`childhood_memories_category`, `Content`.`conference_request_category`, `Content`.`poi_index_criteria_municipalities`, `Content`.`poi_index_criteria_properties`, `Content`.`poi_index_criteria_categories`, `Content`.`poi_teaser_poi_id`, `Content`.`flatrate_id_backup`, `Content`.`webcam_id`, `Content`.`teaser_search_result_view`, `Content`.`anex_id`, `Content`.`anex_region`, `Content`.`anex_type`, `Content`.`anex_selection`, `Content`.`advertising_banner_id`, `Content`.`employee_id`, (CONCAT_WS (',',`Content`.`gmap_lat`,`Content`.`gmap_long`)) AS `Content__gmap`, (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) AS `Content__published`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Teaser`.`id`, `Teaser`.`hash`, `Teaser`.`created`, `Teaser`.`updated`, `Teaser`.`model`, `Teaser`.`foreign_key`, `Teaser`.`type`, `Teaser`.`title`, `Teaser`.`content`, `Teaser`.`button`, `Teaser`.`teaser_id`, `Teaser`.`layout` FROM `piding`.`contents` AS `Content` LEFT JOIN `piding`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `piding`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 103 AND `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' ORDER BY `position` ASC	0	0	1	maybe slow
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'nav-banner' AND `Language`.`langid` = 'de' LIMIT 1	0	0	0
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `piding`.`settings` AS `Setting` LEFT JOIN `piding`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id`	35	35	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 `piding`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 3, 4, 5, 7, 8, 10, 11, 13, 14, 15, 16, 17, 18, 19, 20, 22, 23, 24, 25, 26, 27, 28, 29, 34, 35, 36, 37, 39, 40, 41, 42, 43, 45, 46) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT *, Language.id FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `piding`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `piding`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'data-protection' AND `Language`.`langid` = 'de' LIMIT 1	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` FROM `piding`.`mount_points` AS `MountPoint` LEFT JOIN `piding`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `piding`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'de' 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 `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 111 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 111 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 111 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 110 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 110 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 110 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 102 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 102 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 102 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 103 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 103 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 103 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 106 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 106 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 106 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 109 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 109 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 109 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 104 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 104 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 104 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 105 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 105 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 105 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 108 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 108 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 108 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0
SELECT `Media`.`id`, `Media`.`hash`, `Media`.`created`, `Media`.`updated`, `Media`.`title`, `Media`.`status`, `Media`.`description`, (SELECT COUNT(1) FROM `piding`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `Media`.`id`) AS `Media__cross_reference_count` FROM `piding`.`media` AS `Media` WHERE `Media`.`id` = 107 LIMIT 1	1	1	0
SELECT `TagsTag`.`id`, `TagsTag`.`hash`, `TagsTag`.`created`, `TagsTag`.`updated`, `TagsTag`.`title`, `TagsTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `TagsTag`.`id`) AS `TagsTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `TagsTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 107 AND `TagEntity`.`tag_id` = `TagsTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'tags'	1	1	0
SELECT `CopyrightTag`.`id`, `CopyrightTag`.`hash`, `CopyrightTag`.`created`, `CopyrightTag`.`updated`, `CopyrightTag`.`title`, `CopyrightTag`.`scope`, (SELECT COUNT(1) FROM tag_entities AS TagEntity WHERE `TagEntity`.`tag_id` = `CopyrightTag`.`id`) AS `CopyrightTag__cross_reference_count`, `TagEntity`.`id`, `TagEntity`.`tag_id`, `TagEntity`.`model`, `TagEntity`.`field`, `TagEntity`.`foreign_key` FROM `piding`.`tags` AS `CopyrightTag` JOIN `piding`.`tag_entities` AS `TagEntity` ON (`TagEntity`.`foreign_key` = 107 AND `TagEntity`.`tag_id` = `CopyrightTag`.`id`) WHERE `TagEntity`.`model` = 'Media' AND `TagEntity`.`field` = 'copyright'	0	0	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 17.89 MB

Message	Memory use
Component initialization	3.27 MB
Controller action start	3.51 MB
Controller render start	5.68 MB
View render complete	11.98 MB

Timers

Total Request Time: 639 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	128.60
Event: Controller.initialize	4.17
Event: Controller.startup	0.98
Controller action	66.41
Event: Controller.beforeRender	205.44
» Processing toolbar data	34.76
Rendering View	93.70
» Event: View.beforeRender	0.06
» Rendering APP/Plugin/FrontendPOI/View/FrontendPOI/poi.php	24.60
» » Rendering APP/Plugin/FrontendContents/View/Elements/gallery_upload.php	4.87
» » Rendering APP/Plugin/FrontendContents/View/Elements/map.php	12.23
» » Rendering APP/View/Elements/google_maps_route.php	0.30
» » Rendering APP/View/Elements/deutsche_bahn_connections.php	0.39
» Event: View.afterRender	1.21
» Event: View.beforeLayout	0.05
» Rendering APP/View/Layouts/index.php	64.68
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	2.17
» » Rendering APP/View/Elements/news_widget.php	0.28
» » Rendering APP/View/Elements/navigation.php	10.29
» » Rendering APP/View/Elements/footer_collapse.php	0.42
» » Rendering APP/View/Elements/footer_subtree.php	0.93
» » Rendering APP/View/Elements/footer_collapse.php #2	0.30
» » Rendering APP/View/Elements/footer_subtree.php #2	0.92
» » Rendering APP/View/Elements/footer_collapse.php #3	0.30
» » Rendering APP/View/Elements/footer_subtree.php #3	0.92
» » Rendering APP/View/Elements/footer_collapse.php #4	0.30
» » Rendering APP/View/Elements/footer_partner.php	27.53
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- webcamsAfterTitle(empty)
- webcamsAfterVideo(empty)
- webcamsInSidebar(empty)
- poi(array)
 POII18n(array)
 id16
 hash97d2a185aef7a530351ca82782a2c052
 created2018-09-17 14:55:34
 updated2019-03-05 12:19:13
 titleWaldschwimmbad in Teisendorf
 poi_id16
 language_id1
 short_descriptionGerne besucht: Teisendorfs Waldschwimmbad. Eine Liegewiese mit Blick zum "Hochstaufen" lädt zum Sonnen und Entspannen ein. Beach- und Volleyballplatz SB-Restaurant und Kiosk, Tischtennis und Kinderspielplatz.
 description_1Gerne besucht: <a href="https://www.berchtesgaden.de/teisendorf" target="_self">Teisendorfs</a> Waldschwimmbad. Eine Liegewiese mit Blick zum <a href="https://www.bad-reichenhall.de/wandern/wanderwege/hochstaufen-bergtour" target="_self">"Hochstaufen"</a> lädt zum Sonnen und Entspannen ein. Beach- und Volleyballplatz SB-Restaurant und Kiosk, Tischtennis und Kinderspielplatz.
 description_2Das gemütliche Familienbad mit Gebirgsblick liegt am südlich bewaldeten Ortsrand der Marktgemeinede Teisendorf im <a href="https://www.berchtesgaden.de/rupertiwinkel" target="_blank">Rupertiwinkel</a>, Beach- und Volleyballplatz, SB-Restaurant und Kioskbetrieb, Sanitär- und Umkleideanlagen sind neu errichtet, Tischtennis und Kinderspielplatz, große Liegewiese
 description_3(null)
 price_listEinzelkarte Erwachsene: 2,50 Euro Einzelkarte Kinder: 1,50 Euro Saisonkarte Erwachsene : 35,00 Euro Saisonkarte Kinder: 15,00 Euro Familienkarte:50,00 Euro Eintritt für Gäste mit Gästekarte des Marktes Teisendorf frei! Schwimmbad Teisendorf und Neukirchen Liegestuhgebühr: 2,00 Euro
 openingsAnfang Mai bis Anfang September täglich von 10:30 Uhr bis 19:30 Uhr
 approaches(null)
 awards(null)
 accommodation(null)
 host(null)
 starting_point_description(null)
 websitewww.teisendorf.de
 video_url1(null)
 additional_information_and_linksFamilientipp: Jeden Mittwoch- Nachmittag ist eine kostenlose Teilnahme beim Schwimmunterricht möglich.
 sub_titleFamilienbad mit Gebirgsblick
 teaser_titleWaldschwimmbad in Teisendorf
 video_url2(null)
 video_url3(null)
 hosting(null)
 file1_title(null)
 file2_title(null)
 file3_title(null)
 gallery1_titleFreibad in Teisendorf
 gallery2_titleTreffpunkt für junge Menschen: Das Schwimmbad Teisendorf
 gallery3_titleSchwimmbad Teisendorf
 gallery4_titleSchwimmbad Teisendorf
 gallery5_titleSchwimmbad Teisendorf
 gallery6_titleSchwimmbad mit Gebirgsblick
 gallery7_title(null)
 gallery8_title(null)
 gallery9_title(null)
 gallery10_title(null)
 tickets_button_text(null)
 POI(array)
 id16
 hasha485370fbeca024c4aa13d2938884f05
 created2018-09-17 14:55:34
 updated2019-03-05 12:19:13
 internal_titleWaldschwimmbad Teisendorf
 ordering_number-1
 address_zip83317
 address_cityTeisendorf
 address_streetAlte-Reichenhaller-Straße 35
 address_countryde
 address_lat47.842480
 address_long12.827680
 phone+49-8666-929916
 emailtourismusbuero@t-online.de
 fax(null)
 starting_point_zip83317
 starting_point_cityTeisendorf
 starting_point_streetAlte-Reichenhaller-Straße 35
 starting_point_countryde
 starting_point_lat47.842342
 starting_point_long12.827973
 accessibilityno
 webcam(null)
 height(null)
 overnight_stay(null)
 alpine_club(null)
 family_friendlyyes
 tip_for_bad_weatherno
 tickets(null)
 seasonssummer
 categories131072
 external_id46
 customer_fax(null)
 customer_mobile(null)
 customer_phone+49-86 66-295
 customer_webwww.teisendorf.de
 customer_emailtourismusbuero@t-online.de
 customer_company(null)
 customer_salutation(null)
 customer_name(null)
 customer_first_name(null)
 customer_streetPoststraße 14
 customer_zip83317
 customer_cityTeisendorf
 customer_countryde
 show_customer_communication_address(false)
 municipalityTeisendorf
 statusactive
 gallery1_position5
 gallery2_position3
 gallery3_position2
 gallery4_position1
 gallery5_position0
 gallery6_position4
 gallery7_position0
 gallery8_position0
 gallery9_position0
 gallery10_position0
 webcam_layoutall_after_video
 advertising_banner_id(null)
 widget_code(null)
 address47.842480,12.827680
 starting_point47.842342,12.827973
 AdvertisingBanner(empty)
 Gallery1Upload(array)
 0(array)
 id4530
 hash44f3d34712fdcf0e1e8cd9f9081c073b
 created2019-03-05 12:19:13
 updated2019-03-05 12:19:13
 modelPOI
 fieldgallery1
 foreign_key16
 aliaswaldschwimmbad-teisendorf.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/POI/Gallery1/5c7e5b31be06b.jpg
 size412373
 ext.jpg
 mimeimage/jpeg
 width1200
 height744
 Gallery2Upload(array)
 0(array)
 id4531
 hashf260967a421460b9c60fa19ea52910e9
 created2019-03-05 12:19:13
 updated2019-03-05 12:19:13
 modelPOI
 fieldgallery2
 foreign_key16
 aliaswaldschwimmbad-teisendorf-1.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/POI/Gallery2/5c7e5b31bf615.jpg
 size496567
 ext.jpg
 mimeimage/jpeg
 width1200
 height744
 Gallery3Upload(array)
 0(array)
 id4532
 hash0119b3af9e60ab55c6eb0bb4ea63e156
 created2019-03-05 12:19:13
 updated2019-03-05 12:19:13
 modelPOI
 fieldgallery3
 foreign_key16
 aliaswaldschwimmbad-teisendorf-8.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/POI/Gallery3/5c7e5b31c09fe.jpg
 size447645
 ext.jpg
 mimeimage/jpeg
 width1200
 height744
 Gallery4Upload(array)
 0(array)
 id4533
 hash14346ab5611154faee3defa008d941da
 created2019-03-05 12:19:13
 updated2019-03-05 12:19:13
 modelPOI
 fieldgallery4
 foreign_key16
 aliaswaldschwimmbad-teisendorf-9.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/POI/Gallery4/5c7e5b31c1d0a.jpg
 size559791
 ext.jpg
 mimeimage/jpeg
 width1200
 height744
 Gallery5Upload(array)
 0(array)
 id4534
 hashe8cd6dd8fd911e314e770b3cd87222a2
 created2019-03-05 12:19:13
 updated2019-03-05 12:19:13
 modelPOI
 fieldgallery5
 foreign_key16
 aliaswaldschwimmbad-teisendorf-10.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/POI/Gallery5/5c7e5b31c3042.jpg
 size415725
 ext.jpg
 mimeimage/jpeg
 width1200
 height744
 Gallery6Upload(array)
 0(array)
 id4535
 hashba4f277c9ae123bcba2733bdddf12cff
 created2019-03-05 12:19:13
 updated2019-03-05 12:19:13
 modelPOI
 fieldgallery6
 foreign_key16
 aliaswaldschwimmbad-teisendorf-11.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/POI/Gallery6/5c7e5b31c4353.jpg
 size501081
 ext.jpg
 mimeimage/jpeg
 width1200
 height744
 Gallery7Upload(empty)
 Gallery8Upload(empty)
 Gallery9Upload(empty)
 Gallery10Upload(empty)
 LogoUpload(empty)
 TeaserImageUpload(array)
 0(array)
 id4536
 hashcbf67d61cd2f17c5e11d94682fac3285
 created2019-03-05 12:19:13
 updated2019-03-05 12:19:13
 modelPOI
 fieldteaser_image
 foreign_key16
 aliaswaldschwimmbad-teisendorf-12.jpg
 thumbnail(null)
 parent_id(null)
 filewebroot/files/POI/TeaserImage/5c7e5b31c6a64.jpg
 size412373
 ext.jpg
 mimeimage/jpeg
 width1200
 height744
 Webcam(empty)
 AwardLogoUpload(empty)
 File1Upload(empty)
 File2Upload(empty)
 File3Upload(empty)
- $request->data(empty)
- $this->validationErrors(array)
 Route(empty)
 MountPoint(empty)
 Redirect(empty)
 Language(empty)
 POII18n(empty)
 Seo(empty)
 ImageMedia(empty)
 MediaEntity(empty)
 POI(empty)
 Webcam(empty)
 LogoUpload(empty)
 TeaserImageUpload(empty)
 Gallery1Upload(empty)
 Gallery2Upload(empty)
 Gallery3Upload(empty)
 Gallery4Upload(empty)
 Gallery5Upload(empty)
 Gallery6Upload(empty)
 Gallery7Upload(empty)
 Gallery8Upload(empty)
 Gallery9Upload(empty)
 Gallery10Upload(empty)
 AdvertisingBanner(empty)
 BannerImageUpload(empty)
 File1Upload(empty)
 File2Upload(empty)
 File3Upload(empty)
 AwardLogoUpload(empty)
 PoiWebcam(empty)
 Menu(empty)
 Parent(empty)
 Teaser(empty)
 Content(empty)
 ArticleContentMedia(empty)
 GalleryMedia(empty)
 WebradioHeaderImageMedia(empty)
 SnowReportImageMedia(empty)
 LakeReportGalleryMedia(empty)
 DownloadTeaserFileMedia(empty)
 Host(empty)
 HostPictogram(empty)
 HostQualitySeal(empty)
 Image1Upload(empty)
 HostGroup(empty)
 IconUpload(empty)
 FileUpload(empty)
 ImageUpload(empty)
 WeatherMapUpload(empty)
 ContentsPoi(empty)
 FlagUpload(empty)
- Loaded Helpers(array)
 0Html
 1Tree
 2Upload
 3Media
 4Route
 5Bs3Html
 6Form
 7Enum
 8SocialMedia
 9LeafletJs
 10GMap
 11Embed
 12Layout
 13OAJs
 14OA
 15BitMask
 16CookieBar
 17Number
 18SimpleGraph
 19DebugTimer
 20Toolbar
 21FrontendUpload
 22LeafletEngine
 23Text
 24Session
 25Js
 26HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	5.6.40
User	u378492748923123
Home	/var/www/vhosts/piding.de
Fcgi Role	RESPONDER
Redirect Redirect Unique Id	XS2nOSepPV@B1ube9ovF9AAAAU4
Redirect Redirect Https	on
Redirect Redirect Status	200
Redirect Unique Id	XS2nOSepPV@B1ube9ovF9AAAAU4
Redirect Https	on
Redirect Status	200
Unique Id	XS2nOSepPV@B1ube9ovF9AAAAU4
Https	on
Proxy-nokeepalive	1
Http Host	www.piding.de
Http X Real Ip	54.196.116.3
Http X Accel Internal	/internal-nginx-static-location
Http Connection	close
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http If Modified Since	Wed, 22 May 2019 21:17:18 CEST
Http Accept Encoding	gzip
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Server Signature
Server Software	Apache
Server Name	www.piding.de
Server Addr	62.116.174.136
Server Port	443
Remote Addr	54.196.116.3
Document Root	/var/www/vhosts/piding.de/httpdocs
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/piding.de/httpdocs
Server Admin	plesk-admin@internetx.com
Script Filename	/var/www/vhosts/piding.de/httpdocs/webroot/index.php
Remote Port	59536
Redirect Url	/webroot/waldschwimmbad-teisendorf
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/waldschwimmbad-teisendorf
Script Name	/webroot/index.php
Php Self	/webroot/index.php
Request Time Float	1563273017.6347
Request Time	1563273017

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/5.6/share/pear
- 2-> /var/www/vhosts/piding.de/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
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  4APP/contrance/Config/database.php
  5APP/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
  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
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  AdvertisingBanners(array)
  Model(array)
  0AdvertisingBanners/Model/AdvertisingBanner.php
  1AdvertisingBanners/Model/AdvertisingBannersAppModel.php
  ApiClient(array)
  Config(array)
  0ApiClient/Config/bootstrap.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/HabtmBehavior.php
  Contents(array)
  Component(array)
  0Contents/Controller/Component/FacebookApiComponent.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
  Flatrates(array)
  Config(array)
  0Flatrates/Config/bootstrap.php
  FrontendFlatrates(array)
  Config(array)
  0FrontendFlatrates/Config/routes.php
  FrontendHosts(array)
  Config(array)
  0FrontendHosts/Config/bootstrap.php
  1FrontendHosts/Config/routes.php
  FrontendPOI(array)
  Config(array)
  0FrontendPOI/Config/bootstrap.php
  Controller(array)
  0FrontendPOI/Controller/FrontendPOIController.php
  1FrontendPOI/Controller/FrontendPOIAppController.php
  FrontendPressArchive(array)
  Config(array)
  0FrontendPressArchive/Config/routes.php
  FrontendUploads(array)
  Config(array)
  0FrontendUploads/Config/routes.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  Hosts(array)
  Config(array)
  0Hosts/Config/bootstrap.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
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  POI(array)
  Model(array)
  0POI/Model/POII18n.php
  1POI/Model/POIAppModel.php
  2POI/Model/POI.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
  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
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.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
  Webcams(array)
  Model(array)
  0Webcams/Model/Webcam.php
  1Webcams/Model/WebcamsAppModel.php
====

Waldschwimmbad in Teisendorf

Familienbad mit Gebirgsblick

Waldschwimmbad in Teisendorf

Ausgangspunkt / Parkplatz

Route berechnen

Anreise mit Bus & Bahn

Öffnungszeiten

Eintritt / Preise

Weitere Infos und Links

Tourimusbüro Piding

default

Total Time: 16 ms
Total Queries: 149 queries

Query Explain:

Memory

Timers

Waldschwimmbad in Teisendorf

Familienbad mit Gebirgsblick

Waldschwimmbad in Teisendorf

Ausgangspunkt / Parkplatz

Route berechnen

Anreise mit Bus & Bahn

Öffnungszeiten

Eintritt / Preise

Weitere Infos und Links

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 16 ms Total Queries: 149 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 16 ms
Total Queries: 149 queries