History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- pluginFrontendRegions
- controllerFrontendRegions
- actionstation
- named(empty)
- pass(array)
  02633
- ids(array)
  Menu(null)
  Content(null)
  Language(null)
  Station2633
- route(array)
  id12671
  hash53698581cc7311057fbbebf8d7757bff
  created2020-03-26 19:25:05
  updated2020-05-04 12:52:52
  modelStation
  foreign_key2633
  base/
  aliasferienwohnung-strandapartment-deich-lounge
  controllerFrontendRegions.FrontendRegions
  actionstation
  parent_id(null)
  lft1821
  rght1822
  route/ferienwohnung-strandapartment-deich-lounge
- 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: 28 ms
Total Queries: 215 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Image9Upload`.`id`, `Image9Upload`.`hash`, `Image9Upload`.`created`, `Image9Upload`.`updated`, `Image9Upload`.`model`, `Image9Upload`.`field`, `Image9Upload`.`foreign_key`, `Image9Upload`.`alias`, `Image9Upload`.`thumbnail`, `Image9Upload`.`parent_id`, `Image9Upload`.`file`, `Image9Upload`.`size`, `Image9Upload`.`ext`, `Image9Upload`.`mime`, `Image9Upload`.`width`, `Image9Upload`.`height` FROM `ebh_2020`.`uploads` AS `Image9Upload` WHERE `Image9Upload`.`model` = 'Station' AND `Image9Upload`.`field` = 'image_9' AND `Image9Upload`.`foreign_key` = (2633) ORDER BY FIELD(COALESCE(`Image9Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Image10Upload`.`id`, `Image10Upload`.`hash`, `Image10Upload`.`created`, `Image10Upload`.`updated`, `Image10Upload`.`model`, `Image10Upload`.`field`, `Image10Upload`.`foreign_key`, `Image10Upload`.`alias`, `Image10Upload`.`thumbnail`, `Image10Upload`.`parent_id`, `Image10Upload`.`file`, `Image10Upload`.`size`, `Image10Upload`.`ext`, `Image10Upload`.`mime`, `Image10Upload`.`width`, `Image10Upload`.`height` FROM `ebh_2020`.`uploads` AS `Image10Upload` WHERE `Image10Upload`.`model` = 'Station' AND `Image10Upload`.`field` = 'image_10' AND `Image10Upload`.`foreign_key` = (2633) ORDER BY FIELD(COALESCE(`Image10Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Image11Upload`.`id`, `Image11Upload`.`hash`, `Image11Upload`.`created`, `Image11Upload`.`updated`, `Image11Upload`.`model`, `Image11Upload`.`field`, `Image11Upload`.`foreign_key`, `Image11Upload`.`alias`, `Image11Upload`.`thumbnail`, `Image11Upload`.`parent_id`, `Image11Upload`.`file`, `Image11Upload`.`size`, `Image11Upload`.`ext`, `Image11Upload`.`mime`, `Image11Upload`.`width`, `Image11Upload`.`height` FROM `ebh_2020`.`uploads` AS `Image11Upload` WHERE `Image11Upload`.`model` = 'Station' AND `Image11Upload`.`field` = 'image_11' AND `Image11Upload`.`foreign_key` = (2633) ORDER BY FIELD(COALESCE(`Image11Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Image12Upload`.`id`, `Image12Upload`.`hash`, `Image12Upload`.`created`, `Image12Upload`.`updated`, `Image12Upload`.`model`, `Image12Upload`.`field`, `Image12Upload`.`foreign_key`, `Image12Upload`.`alias`, `Image12Upload`.`thumbnail`, `Image12Upload`.`parent_id`, `Image12Upload`.`file`, `Image12Upload`.`size`, `Image12Upload`.`ext`, `Image12Upload`.`mime`, `Image12Upload`.`width`, `Image12Upload`.`height` FROM `ebh_2020`.`uploads` AS `Image12Upload` WHERE `Image12Upload`.`model` = 'Station' AND `Image12Upload`.`field` = 'image_12' AND `Image12Upload`.`foreign_key` = (2633) ORDER BY FIELD(COALESCE(`Image12Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Image13Upload`.`id`, `Image13Upload`.`hash`, `Image13Upload`.`created`, `Image13Upload`.`updated`, `Image13Upload`.`model`, `Image13Upload`.`field`, `Image13Upload`.`foreign_key`, `Image13Upload`.`alias`, `Image13Upload`.`thumbnail`, `Image13Upload`.`parent_id`, `Image13Upload`.`file`, `Image13Upload`.`size`, `Image13Upload`.`ext`, `Image13Upload`.`mime`, `Image13Upload`.`width`, `Image13Upload`.`height` FROM `ebh_2020`.`uploads` AS `Image13Upload` WHERE `Image13Upload`.`model` = 'Station' AND `Image13Upload`.`field` = 'image_13' AND `Image13Upload`.`foreign_key` = (2633) ORDER BY FIELD(COALESCE(`Image13Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Image14Upload`.`id`, `Image14Upload`.`hash`, `Image14Upload`.`created`, `Image14Upload`.`updated`, `Image14Upload`.`model`, `Image14Upload`.`field`, `Image14Upload`.`foreign_key`, `Image14Upload`.`alias`, `Image14Upload`.`thumbnail`, `Image14Upload`.`parent_id`, `Image14Upload`.`file`, `Image14Upload`.`size`, `Image14Upload`.`ext`, `Image14Upload`.`mime`, `Image14Upload`.`width`, `Image14Upload`.`height` FROM `ebh_2020`.`uploads` AS `Image14Upload` WHERE `Image14Upload`.`model` = 'Station' AND `Image14Upload`.`field` = 'image_14' AND `Image14Upload`.`foreign_key` = (2633) ORDER BY FIELD(COALESCE(`Image14Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `Image15Upload`.`id`, `Image15Upload`.`hash`, `Image15Upload`.`created`, `Image15Upload`.`updated`, `Image15Upload`.`model`, `Image15Upload`.`field`, `Image15Upload`.`foreign_key`, `Image15Upload`.`alias`, `Image15Upload`.`thumbnail`, `Image15Upload`.`parent_id`, `Image15Upload`.`file`, `Image15Upload`.`size`, `Image15Upload`.`ext`, `Image15Upload`.`mime`, `Image15Upload`.`width`, `Image15Upload`.`height` FROM `ebh_2020`.`uploads` AS `Image15Upload` WHERE `Image15Upload`.`model` = 'Station' AND `Image15Upload`.`field` = 'image_15' AND `Image15Upload`.`foreign_key` = (2633) ORDER BY FIELD(COALESCE(`Image15Upload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT * FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'offers' 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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 5 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 43 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 29 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (5)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (133, 134, 135, 136, 137, 138) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1144) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `ebh_2020`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (5) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `HeaderImagesMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_secondary`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`provider_type`, `Content`.`deadline`, `Content`.`competition_answer`, `Content`.`member_group_id`, `Content`.`contact_options`, (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`, (`Content`.`status` = "active") AS `Content__isActive`, `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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`contents` AS `Content` LEFT JOIN `ebh_2020`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 5 AND `Content`.`type` = 'search_offers' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 41 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 27 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ArticleContentMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 26 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `GalleryMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 26 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `BannerLogoMedia`.`id`, `BannerLogoMedia`.`hash`, `BannerLogoMedia`.`created`, `BannerLogoMedia`.`updated`, `BannerLogoMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `BannerLogoMedia`.`id`) AS `BannerLogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `BannerLogoMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 26 AND `MediaEntity`.`media_id` = `BannerLogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'banner_logo' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 26 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght` FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`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`.`icon_font_code`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 1 AND `Menu`.`rght` < 46 ORDER BY `Menu`.`lft` asc	22	22	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (14176)	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (4)	2	2	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (6)	2	2	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9282)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9059)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9062)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9063)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9139)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9142)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9148)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9160)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9310)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (11158)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9312)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (11181)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (8)	2	2	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (8714)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (8584)	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (14)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (15)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9178)	0	0	0
SELECT `Entity`.`lft`, `Entity`.`rght` FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'secondNavHead' 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`.`icon_font_code`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 47 AND `Menu`.`rght` < 54 ORDER BY `Menu`.`lft` asc	3	3	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9056)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9057)	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id` FROM `ebh_2020`.`mount_points` AS `MountPoint` WHERE `MountPoint`.`route_id` = (9058)	0	0	0
SELECT * FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'partner-logos' 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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 2 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2826 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 335 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (2)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (1363, 1364, 1365, 1366, 1367, 1368) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `ebh_2020`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (2) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `HeaderImagesMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	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`.`icon_font_code` FROM `ebh_2020`.`menus` AS `Menu` WHERE `Menu`.`id` = 2 LIMIT 1	1	1	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_secondary`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`provider_type`, `Content`.`deadline`, `Content`.`competition_answer`, `Content`.`member_group_id`, `Content`.`contact_options`, (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`, (`Content`.`status` = "active") AS `Content__isActive` FROM `ebh_2020`.`contents` AS `Content` WHERE `status` = 'active' AND `Content`.`menu_id` = (2) ORDER BY `Content`.`position` ASC	17	17	1	maybe slow
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 14 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 8 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (4) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 15 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 9 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (5) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 186 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 392 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1826) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 16 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 10 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1380) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 17 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`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	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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1379) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 18 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`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	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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (553) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	7	7	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 179 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 383 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (961) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 181 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 387 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (959) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 182 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 388 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (960) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 187 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 393 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1375) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 188 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 394 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (969) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 208 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 422 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1028) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 209 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 423 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1029) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 210 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 424 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1030) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 183 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 389 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (962) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 20 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 14 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (10) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `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 `ebh_2020`.`teasers` AS `Teaser` WHERE `Teaser`.`foreign_key` = 224 AND `Teaser`.`model` = 'Content'	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 439 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1072) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `Entity`.`lft`, `Entity`.`rght` FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-navigation' 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`.`icon_font_code`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 58 AND `Menu`.`rght` < 67 ORDER BY `Menu`.`lft` asc	4	4	0
SELECT `Entity`.`lft`, `Entity`.`rght` FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer-social' 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`.`icon_font_code`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` > 68 AND `Menu`.`rght` < 73 ORDER BY `Menu`.`lft` asc	2	2	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 17 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (13) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	1	1	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 `ebh_2020`.`languages` AS `Language` LEFT JOIN `ebh_2020`.`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 `ebh_2020`.`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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots` FROM `ebh_2020`.`seo` AS `Seo` WHERE `Seo`.`model` = 'Station' AND `Seo`.`foreign_key` = 2633 LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 6296 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 `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `model` = 'Station' AND `foreign_key` = 2633	6	6	3	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (10099, 10100, 10101, 10102, 10103, 10104) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	1	maybe slow
SELECT `Station`.`id`, `Station`.`hash`, `Station`.`created`, `Station`.`updated`, `Station`.`title`, `Station`.`region_id`, `Station`.`owner`, `Station`.`street`, `Station`.`zip_city`, `Station`.`phone`, `Station`.`fax`, `Station`.`mobile`, `Station`.`email`, `Station`.`web`, `Station`.`description`, `Station`.`short_description`, `Station`.`geopoint_lat`, `Station`.`geopoint_long`, `Station`.`category_id`, `Station`.`status`, `Station`.`classification`, `Station`.`classification_text`, `Station`.`country`, `Station`.`type`, `Station`.`video1`, `Station`.`video2`, `Station`.`openings`, `Station`.`state_id`, `Station`.`country_id`, `Station`.`holiday_voucher_url`, `Station`.`we_are_travel_id`, `Station`.`booking_url`, `Station`.`source`, (CONCAT_WS (';',`Station`.`geopoint_lat`,`Station`.`geopoint_long`)) AS `Station__geopoint`, (SELECT COUNT(1) FROM `ebh_2020`.`offers` AS `OfferCount` WHERE `OfferCount`.`station_id` = `Station`.`id` AND `OfferCount`.`status` = 'active' AND NOW() BETWEEN COALESCE(`OfferCount`.`release`, NOW()) AND COALESCE(`OfferCount`.`hide`, NOW())) AS `Station__offer_count`, `Region`.`id`, `Region`.`hash`, `Region`.`created`, `Region`.`updated`, `Region`.`title`, `Region`.`status`, `Region`.`country_id`, `Region`.`state_id`, `Region`.`description`, `Region`.`sidebar`, `Region`.`teaser_text`, (SELECT COUNT(1) FROM `ebh_2020`.`stations` AS `StationCount` WHERE `StationCount`.`region_id` = `Region`.`id`) AS `Region__station_count`, `State`.`id`, `State`.`hash`, `State`.`created`, `State`.`updated`, `State`.`title`, `State`.`country_id`, `State`.`status`, `State`.`search`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`stations` AS `Station` LEFT JOIN `ebh_2020`.`regions` AS `Region` ON (`Station`.`region_id` = `Region`.`id`) LEFT JOIN `ebh_2020`.`states` AS `State` ON (`Station`.`state_id` = `State`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Station`.`id` AND `Route`.`model` = 'Station') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Station`.`id` AND `Seo`.`model` = 'Station') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Station`.`id` AND `Teaser`.`model` = 'Station') WHERE `Station`.`id` = 2633 LIMIT 1	1	1	3	maybe slow
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Station' AND `HeaderImage`.`foreign_key` = (2633)	6	6	3	maybe slow
SELECT * FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'hotel' 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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 127 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5648 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1104 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (127)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (7393, 7394, 7395, 7396, 7397, 7398) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (422) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	8	8	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `ebh_2020`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (127) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `HeaderImagesMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 127 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `model` = 'Menu' AND `foreign_key` = 127	6	6	0
SELECT * FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 1 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 18 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	1	1	0
SELECT `FileUpload`.`id`, `FileUpload`.`hash`, `FileUpload`.`created`, `FileUpload`.`updated`, `FileUpload`.`model`, `FileUpload`.`field`, `FileUpload`.`foreign_key`, `FileUpload`.`alias`, `FileUpload`.`thumbnail`, `FileUpload`.`parent_id`, `FileUpload`.`file`, `FileUpload`.`size`, `FileUpload`.`ext`, `FileUpload`.`mime`, `FileUpload`.`width`, `FileUpload`.`height` FROM `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (1133) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	9	9	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 18 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (1)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (19, 20, 21, 22, 23, 24) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	4	4	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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (671, 667, 16, 297) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	35	35	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `ebh_2020`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (1) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `HeaderImagesMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Banner`.`id`, `Banner`.`hash`, `Banner`.`title`, `Banner`.`text`, `Banner`.`img`, `Banner`.`status`, `Banner`.`created`, `Banner`.`updated`, `Banner`.`link`, `Banner`.`button` FROM `ebh_2020`.`banners` AS `Banner` WHERE `Banner`.`status` = 'active' LIMIT 1	0	0	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 `ebh_2020`.`languages` AS `Language` LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE `langid` IS NULL 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 `ebh_2020`.`mount_points` AS `MountPoint` LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `ebh_2020`.`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 `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_secondary`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`provider_type`, `Content`.`deadline`, `Content`.`competition_answer`, `Content`.`member_group_id`, `Content`.`contact_options`, (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`, (`Content`.`status` = "active") AS `Content__isActive`, `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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`contents` AS `Content` LEFT JOIN `ebh_2020`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 127 AND `Content`.`type` = 'search_providers' LIMIT 1	1	1	2	maybe slow
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 5650 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1105 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ArticleContentMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 623 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `GalleryMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 623 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `BannerLogoMedia`.`id`, `BannerLogoMedia`.`hash`, `BannerLogoMedia`.`created`, `BannerLogoMedia`.`updated`, `BannerLogoMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `BannerLogoMedia`.`id`) AS `BannerLogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `BannerLogoMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 623 AND `MediaEntity`.`media_id` = `BannerLogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'banner_logo' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 623 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Country`.`id`, `Country`.`hash`, `Country`.`created`, `Country`.`updated`, `Country`.`title`, `Country`.`manager_id`, `Country`.`status`, `Country`.`menu_id`, `Country`.`position`, `Country`.`search`, (SELECT COUNT(1) FROM `ebh_2020`.`regions` AS `RegionCount` WHERE `RegionCount`.`country_id` = `Country`.`id`) AS `Country__region_count`, (SELECT COUNT(1) FROM `ebh_2020`.`states` AS `StateCount` WHERE `StateCount`.`country_id` = `Country`.`id`) AS `Country__state_count` FROM `ebh_2020`.`countries` AS `Country` JOIN `ebh_2020`.`states` AS `statesForCond` ON (`statesForCond`.`country_id` = `Country`.`id` AND `statesForCond`.`status` = 'active') JOIN `ebh_2020`.`stations` AS `joinForCond` ON (`joinForCond`.`state_id` = `statesForCond`.`id` AND `joinForCond`.`status` = 'active' AND `joinForCond`.`type` = 'hotel') WHERE `Country`.`status` = 'active' GROUP BY `Country`.`id` ORDER BY `Country`.`position` ASC	5	5	0
SELECT `State`.`id`, `State`.`country_id`, `State`.`title` FROM `ebh_2020`.`states` AS `State` JOIN `ebh_2020`.`stations` AS `joinForCond` ON (`joinForCond`.`state_id` = `State`.`id` AND `joinForCond`.`status` = 'active' AND `joinForCond`.`type` = 'hotel') WHERE `State`.`status` = 'active' GROUP BY `State`.`id`	47	47	0
SELECT * FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'station' 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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 3 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 20 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 20 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (3)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (25, 26, 27, 28, 29, 30) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' 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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (27) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	10	10	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `ebh_2020`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (3) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `HeaderImagesMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 3 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_secondary`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`provider_type`, `Content`.`deadline`, `Content`.`competition_answer`, `Content`.`member_group_id`, `Content`.`contact_options`, (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`, (`Content`.`status` = "active") AS `Content__isActive`, `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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`contents` AS `Content` LEFT JOIN `ebh_2020`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 3 AND `Content`.`type` = 'search_providers' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 19 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 19 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ArticleContentMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 22 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `GalleryMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 22 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `BannerLogoMedia`.`id`, `BannerLogoMedia`.`hash`, `BannerLogoMedia`.`created`, `BannerLogoMedia`.`updated`, `BannerLogoMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `BannerLogoMedia`.`id`) AS `BannerLogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `BannerLogoMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 22 AND `MediaEntity`.`media_id` = `BannerLogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'banner_logo' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 22 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Country`.`id`, `Country`.`hash`, `Country`.`created`, `Country`.`updated`, `Country`.`title`, `Country`.`manager_id`, `Country`.`status`, `Country`.`menu_id`, `Country`.`position`, `Country`.`search`, (SELECT COUNT(1) FROM `ebh_2020`.`regions` AS `RegionCount` WHERE `RegionCount`.`country_id` = `Country`.`id`) AS `Country__region_count`, (SELECT COUNT(1) FROM `ebh_2020`.`states` AS `StateCount` WHERE `StateCount`.`country_id` = `Country`.`id`) AS `Country__state_count` FROM `ebh_2020`.`countries` AS `Country` JOIN `ebh_2020`.`states` AS `statesForCond` ON (`statesForCond`.`country_id` = `Country`.`id` AND `statesForCond`.`status` = 'active') JOIN `ebh_2020`.`stations` AS `joinForCond` ON (`joinForCond`.`state_id` = `statesForCond`.`id` AND `joinForCond`.`status` = 'active' AND `joinForCond`.`type` = 'station') WHERE `Country`.`status` = 'active' GROUP BY `Country`.`id` ORDER BY `Country`.`position` ASC	7	7	0
SELECT `State`.`id`, `State`.`country_id`, `State`.`title` FROM `ebh_2020`.`states` AS `State` JOIN `ebh_2020`.`stations` AS `joinForCond` ON (`joinForCond`.`state_id` = `State`.`id` AND `joinForCond`.`status` = 'active' AND `joinForCond`.`type` = 'station') WHERE `State`.`status` = 'active' GROUP BY `State`.`id`	27	27	0
SELECT `Country`.`id`, `Country`.`hash`, `Country`.`created`, `Country`.`updated`, `Country`.`title`, `Country`.`manager_id`, `Country`.`status`, `Country`.`menu_id`, `Country`.`position`, `Country`.`search`, (SELECT COUNT(1) FROM `ebh_2020`.`regions` AS `RegionCount` WHERE `RegionCount`.`country_id` = `Country`.`id`) AS `Country__region_count`, (SELECT COUNT(1) FROM `ebh_2020`.`states` AS `StateCount` WHERE `StateCount`.`country_id` = `Country`.`id`) AS `Country__state_count` FROM `ebh_2020`.`countries` AS `Country` JOIN `ebh_2020`.`states` AS `statesForCond` ON (`statesForCond`.`country_id` = `Country`.`id` AND `statesForCond`.`status` = 'active') JOIN `ebh_2020`.`offers` AS `joinForCond` ON (`joinForCond`.`state_id` = `statesForCond`.`id` AND `joinForCond`.`status` = 'active' AND NOW() BETWEEN COALESCE(`joinForCond`.`release`, NOW()) AND COALESCE(`joinForCond`.`hide`, NOW())) WHERE `Country`.`status` = 'active' GROUP BY `Country`.`id` ORDER BY `Country`.`position` ASC	1	1	1
SELECT `State`.`id`, `State`.`country_id`, `State`.`title` FROM `ebh_2020`.`states` AS `State` JOIN `ebh_2020`.`offers` AS `joinForCond` ON (`joinForCond`.`state_id` = `State`.`id` AND `joinForCond`.`status` = 'active' AND NOW() BETWEEN COALESCE(`joinForCond`.`release`, NOW()) AND COALESCE(`joinForCond`.`hide`, NOW())) WHERE `State`.`status` = 'active' GROUP BY `State`.`id`	1	1	0
SELECT * FROM `ebh_2020`.`mount_points` AS `MountPoint` JOIN `ebh_2020`.`languages` AS `Language` ON (`Language`.`id` = `MountPoint`.`language_id`) JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `ebh_2020`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'regions' 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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`menus` AS `Menu` LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 7 LIMIT 1	1	1	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 26 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 26 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `HeaderImage`.`id`, `HeaderImage`.`hash`, `HeaderImage`.`created`, `HeaderImage`.`updated`, `HeaderImage`.`model`, `HeaderImage`.`foreign_key`, `HeaderImage`.`title`, `HeaderImage`.`url`, `HeaderImage`.`target_blank` FROM `ebh_2020`.`header_images` AS `HeaderImage` WHERE `HeaderImage`.`model` = 'Menu' AND `HeaderImage`.`foreign_key` = (7)	6	6	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (43, 44, 45, 46, 47, 48) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	3	3	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 `ebh_2020`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (1063, 1062, 1057) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	21	21	0
SELECT `HeaderVideoUpload`.`id`, `HeaderVideoUpload`.`hash`, `HeaderVideoUpload`.`created`, `HeaderVideoUpload`.`updated`, `HeaderVideoUpload`.`model`, `HeaderVideoUpload`.`field`, `HeaderVideoUpload`.`foreign_key`, `HeaderVideoUpload`.`alias`, `HeaderVideoUpload`.`thumbnail`, `HeaderVideoUpload`.`parent_id`, `HeaderVideoUpload`.`file`, `HeaderVideoUpload`.`size`, `HeaderVideoUpload`.`ext`, `HeaderVideoUpload`.`mime`, `HeaderVideoUpload`.`width`, `HeaderVideoUpload`.`height` FROM `ebh_2020`.`uploads` AS `HeaderVideoUpload` WHERE `HeaderVideoUpload`.`model` = 'Menu' AND `HeaderVideoUpload`.`field` = 'header_video' AND `HeaderVideoUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`HeaderVideoUpload`.`thumbnail`, -1), -1) DESC	0	0	0
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) AS `HeaderImagesMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `HeaderImagesMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `Content`.`id`, `Content`.`hash`, `Content`.`created`, `Content`.`updated`, `Content`.`menu_id`, `Content`.`position`, `Content`.`type`, `Content`.`status`, `Content`.`title`, `Content`.`layout`, `Content`.`language_id`, `Content`.`article_content`, `Content`.`contact_content`, `Content`.`contact_email`, `Content`.`contact_email_secondary`, `Content`.`contact_success`, `Content`.`contact_error`, `Content`.`iframe_url`, `Content`.`iframe_width`, `Content`.`iframe_height`, `Content`.`release`, `Content`.`hide`, `Content`.`gmap_lat`, `Content`.`gmap_long`, `Content`.`gmap_zoom`, `Content`.`gmap_type`, `Content`.`gmap_marker`, `Content`.`video_type`, `Content`.`video_url`, `Content`.`developer_template_code`, `Content`.`developer_template_css`, `Content`.`developer_template_js`, `Content`.`teaser_menu_id`, `Content`.`teaser_external_url`, `Content`.`teaser_external_target`, `Content`.`provider_type`, `Content`.`deadline`, `Content`.`competition_answer`, `Content`.`member_group_id`, `Content`.`contact_options`, (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`, (`Content`.`status` = "active") AS `Content__isActive`, `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`.`icon_font_code`, `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`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `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 `ebh_2020`.`contents` AS `Content` LEFT JOIN `ebh_2020`.`menus` AS `Menu` ON (`Content`.`menu_id` = `Menu`.`id`) LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`Content`.`language_id` = `Language`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Content`.`id` AND `Route`.`model` = 'Content') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') LEFT JOIN `ebh_2020`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Content`.`id` AND `Teaser`.`model` = 'Content') WHERE `Content`.`menu_id` = 7 AND `Content`.`type` = 'search_regions' LIMIT 1	1	1	1
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 24 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 24 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ArticleContentMedia`.`id`, `ArticleContentMedia`.`hash`, `ArticleContentMedia`.`created`, `ArticleContentMedia`.`updated`, `ArticleContentMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ArticleContentMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `ArticleContentMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'article_content' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `GalleryMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `BannerLogoMedia`.`id`, `BannerLogoMedia`.`hash`, `BannerLogoMedia`.`created`, `BannerLogoMedia`.`updated`, `BannerLogoMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `BannerLogoMedia`.`id`) AS `BannerLogoMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `ebh_2020`.`media` AS `BannerLogoMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `BannerLogoMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'banner_logo' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `ebh_2020`.`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 `ebh_2020`.`media` AS `ImageMedia` JOIN `ebh_2020`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 25 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Content' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `ebh_2020`.`mount_points` AS `MountPoint` LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `ebh_2020`.`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` = 'partners' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `ebh_2020`.`mount_points` AS `MountPoint` LEFT JOIN `ebh_2020`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `MountPoint`.`title` = 'data-protection' LIMIT 1	1	1	0
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `ebh_2020`.`mount_points` AS `MountPoint` LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `ebh_2020`.`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` = 'data-protection' LIMIT 1	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 25.29 MB

Message	Memory use
Component initialization	1.52 MB
Controller action start	2.48 MB
Controller render start	8.17 MB
View render complete	10.17 MB

Timers

Total Request Time: 654 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	102.11
Event: Controller.initialize	33.25
Event: Controller.startup	0.73
Controller action	54.62
Event: Controller.beforeRender	170.46
» Processing toolbar data	109.48
Rendering View	160.45
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendRegions/View/FrontendRegions/station.php	4.78
» » Rendering APP/Plugin/FrontendContents/View/Elements/gallery_upload.php	1.15
» Rendering APP/Plugin/FrontendRegions/View/FrontendRegions/base.php	0.24
» Event: View.afterRender	0.39
» Event: View.beforeLayout	0.03
» Rendering APP/View/Layouts/index.php	153.05
» » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.07
» » Rendering APP/View/Elements/svg/logo.php	0.21
» » Rendering APP/View/Elements/svg/close.php	0.25
» » Rendering APP/View/Elements/mainNav.php	98.42
» » » Rendering APP/View/Elements/search/navigation.php	23.83
» » » » Rendering APP/View/Elements/search/form/start.php	7.50
» » » » Rendering APP/View/Elements/search/inputs/country_state.php	0.91
» » » » Rendering APP/View/Elements/search/form/submit.php	0.31
» » » » Rendering APP/View/Elements/search/form/end.php	0.23
» » » » Rendering APP/View/Elements/search/form/start.php #2	3.96
» » » » Rendering APP/View/Elements/search/inputs/radius.php	0.48
» » » » Rendering APP/View/Elements/search/form/submit.php #2	0.27
» » » » Rendering APP/View/Elements/search/form/end.php #2	0.21
» » » » Rendering APP/View/Elements/search/form/start.php #3	4.14
» » » » Rendering APP/View/Elements/search/inputs/name.php	0.28
» » » » Rendering APP/View/Elements/search/form/submit.php #3	0.28
» » » » Rendering APP/View/Elements/search/form/end.php #3	0.22
» » » Rendering APP/View/Elements/search/navigation.php #2	24.01
» » » » Rendering APP/View/Elements/search/form/start.php #4	8.29
» » » » Rendering APP/View/Elements/search/inputs/country_state.php #2	0.78
» » » » Rendering APP/View/Elements/search/form/submit.php #4	0.28
» » » » Rendering APP/View/Elements/search/form/end.php #4	0.21
» » » » Rendering APP/View/Elements/search/form/start.php #5	4.09
» » » » Rendering APP/View/Elements/search/inputs/radius.php #2	0.41
» » » » Rendering APP/View/Elements/search/form/submit.php #5	0.27
» » » » Rendering APP/View/Elements/search/form/end.php #5	0.21
» » » » Rendering APP/View/Elements/search/form/start.php #6	4.01
» » » » Rendering APP/View/Elements/search/inputs/name.php #2	0.32
» » » » Rendering APP/View/Elements/search/form/submit.php #6	0.28
» » » » Rendering APP/View/Elements/search/form/end.php #6	0.21
» » » Rendering APP/View/Elements/search/navigation.php #3	20.31
» » » » Rendering APP/View/Elements/search/form/start.php #7	4.09
» » » » Rendering APP/View/Elements/search/inputs/country_state.php #3	0.44
» » » » Rendering APP/View/Elements/search/form/submit.php #7	0.28
» » » » Rendering APP/View/Elements/search/form/end.php #7	0.22
» » » » Rendering APP/View/Elements/search/form/start.php #8	4.08
» » » » Rendering APP/View/Elements/search/inputs/radius.php #3	0.41
» » » » Rendering APP/View/Elements/search/form/submit.php #8	0.27
» » » » Rendering APP/View/Elements/search/form/end.php #8	0.21
» » » » Rendering APP/View/Elements/search/form/start.php #9	3.91
» » » » Rendering APP/View/Elements/search/inputs/name.php #3	0.27
» » » » Rendering APP/View/Elements/search/form/submit.php #9	0.27
» » » » Rendering APP/View/Elements/search/form/end.php #9	0.22
» » » Rendering APP/View/Elements/search/navigation.php #4	10.28
» » » » Rendering APP/View/Elements/search/form/start.php #10	7.95
» » » » Rendering APP/View/Elements/search/inputs/name.php #4	0.28
» » » » Rendering APP/View/Elements/search/form/submit.php #10	0.28
» » » » Rendering APP/View/Elements/search/form/end.php #10	0.30
» » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/headerImage.php	38.91
» » » Rendering APP/View/Elements/search/form/start.php #11	3.93
» » » Rendering APP/View/Elements/search/inputs/country_state.php #4	0.75
» » » Rendering APP/View/Elements/search/form/submit.php #11	0.28
» » » Rendering APP/View/Elements/search/form/end.php #11	0.21
» » » Rendering APP/View/Elements/search/form/start.php #12	3.99
» » » Rendering APP/View/Elements/search/inputs/radius.php #4	0.42
» » » Rendering APP/View/Elements/search/form/submit.php #12	0.27
» » » Rendering APP/View/Elements/search/form/end.php #12	0.22
» » » Rendering APP/View/Elements/search/form/start.php #13	4.05
» » » Rendering APP/View/Elements/search/inputs/name.php #5	0.27
» » » Rendering APP/View/Elements/search/form/submit.php #13	0.28
» » » Rendering APP/View/Elements/search/form/end.php #13	0.21
» » » Rendering APP/View/Elements/search/form/start.php #14	3.95
» » » Rendering APP/View/Elements/search/inputs/country_state.php #5	0.71
» » » Rendering APP/View/Elements/search/form/submit.php #14	0.28
» » » Rendering APP/View/Elements/search/form/end.php #14	0.22
» » » Rendering APP/View/Elements/search/form/start.php #15	4.01
» » » Rendering APP/View/Elements/search/inputs/radius.php #5	0.40
» » » Rendering APP/View/Elements/search/form/submit.php #15	0.28
» » » Rendering APP/View/Elements/search/form/end.php #15	0.22
» » » Rendering APP/View/Elements/search/form/start.php #16	3.90
» » » Rendering APP/View/Elements/search/inputs/name.php #6	0.27
» » » Rendering APP/View/Elements/search/form/submit.php #16	0.28
» » » Rendering APP/View/Elements/search/form/end.php #16	0.22
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Station(array)
  id2633
  hashe0be006dc613bc485a2db1167f88cc50
  created2019-01-15 03:00:47
  updated2020-05-04 12:52:52
  titleFerienwohnung Strandapartment Deich-Lounge
  region_id80
  owner
  streetKurzer Weg
  zip_city18374 Zingst
  phone0049 38232 84902
  fax
  mobile
  emailferienwohnung-zingst@web.de
  webwww.strandapartment-zingst.de
  description<h2>E-BIKE VERMIETUNG & STRANDAPARTMENT in ZINGST in TOP-LAGE – nur 50m zum Ostseestrand</h2> <p>In TRAUM-LAGE, direkt hinter dem Deich, nur 50 m vom beinahe endlosen feinsandigen weißen Ostseestrand & ca. 200 Meter von der Seebrücke entfernt, wartet auf Sie ein kleines STRANDAPARTMENT mit Terrasse, angrenzendem Garten, Sonnenliegen, Strandkorb, PKW-Stellplatz & E-BIKE Vermietung (beides ganzjährig).</p> <p>Fischland-Darß-Zingst ist ein Fahrradparadies - rundum gibt es ein gut ausgebautes Wegenetz für Radtouren.</p>
  short_description<p>Fischland-Darß-Zingst ist ein Fahrradparadies - rundum gibt es ein gut ausgebautes Wegenetz für Radtouren.</p>
  geopoint_lat54.440357
  geopoint_long12.685607
  category_id9
  statusactive
  classification0
  classification_text
  country
  typehotel
  video1
  video2
  openings
  state_id(null)
  country_id(null)
  holiday_voucher_url
  we_are_travel_id(null)
  booking_url
  sourcemovelo_manual
  geopoint54.440357;12.685607
  offer_count0
  Region(array)
  id80
  hashd7ab9db69ccc4cd7dcca69c431b3c3e8
  created2016-06-07 10:07:13
  updated2020-03-26 20:20:30
  titleMecklenburg-Vorpommern - BL
  statusactive
  country_id10
  state_id11
  description(null)
  sidebar(null)
  teaser_text
  station_count35
  State(array)
  id(null)
  hash(null)
  created(null)
  updated(null)
  title(null)
  country_id(null)
  status(null)
  search(null)
  Seo(array)
  id6296
  hash315e749ed359e8c8aaf9cbe7a74f24ee
  created2020-05-04 12:52:52
  updated2020-05-04 12:52:52
  modelStation
  foreign_key2633
  title
  description
  author
  tw_creator
  fb_author
  robots3
  LogoUpload(empty)
  Image1Upload(array)
  0(array)
  id148657
  hash0c2a4729642341b570140cd8a03448df
  created2020-02-04 03:00:59
  updated2020-02-04 03:01:00
  modelStation
  fieldimage_1
  foreign_key2633
  aliasp1010609.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Station/Image1/5e38d05c7c2b4.jpg
  size3819916
  ext.jpg
  mimeimage/jpeg
  width4608
  height3456
  1(array)
  id148662
  hasha0584f85e756d8993d15da91132c27b1
  created2020-02-04 03:01:02
  updated2020-02-04 03:01:02
  modelStation
  fieldimage_1
  foreign_key2633
  aliasp1010609-thstationimagelandscape.jpg
  thumbnailth-station-image-landscape
  parent_id148657
  filewebroot/files/Station/Image1/ThStationImageLandscape/5e38d05c7ee5a.jpg
  size156874
  ext.jpg
  mimeimage/jpeg
  width752
  height562
  2(array)
  id148663
  hashe4247fb7cb4c406abacf0af49a0ff209
  created2020-02-04 03:01:04
  updated2020-02-04 03:01:04
  modelStation
  fieldimage_1
  foreign_key2633
  aliasp1010609-thstationimagelightbox.jpg
  thumbnailth-station-image-lightbox
  parent_id148657
  filewebroot/files/Station/Image1/ThStationImageLightbox/5e38d05e3ee95.jpg
  size849578
  ext.jpg
  mimeimage/jpeg
  width1920
  height1440
  Image2Upload(array)
  0(array)
  id148658
  hash7f7eed74c7c799193d363262e4568a17
  created2020-02-04 03:01:00
  updated2020-02-04 03:01:04
  modelStation
  fieldimage_2
  foreign_key2633
  aliasp1010526.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Station/Image2/5e38d06072e80.jpg
  size3637820
  ext.jpg
  mimeimage/jpeg
  width4608
  height3456
  1(array)
  id148664
  hash8d45476e9bb50488cee966008cd91576
  created2020-02-04 03:01:06
  updated2020-02-04 03:01:06
  modelStation
  fieldimage_2
  foreign_key2633
  aliasp1010526-thstationimagelandscape.jpg
  thumbnailth-station-image-landscape
  parent_id148658
  filewebroot/files/Station/Image2/ThStationImageLandscape/5e38d060765ef.jpg
  size99832
  ext.jpg
  mimeimage/jpeg
  width752
  height562
  2(array)
  id148665
  hash9dfff49d4bcd3e13a277213abf4746f4
  created2020-02-04 03:01:08
  updated2020-02-04 03:01:08
  modelStation
  fieldimage_2
  foreign_key2633
  aliasp1010526-thstationimagelightbox.jpg
  thumbnailth-station-image-lightbox
  parent_id148658
  filewebroot/files/Station/Image2/ThStationImageLightbox/5e38d0623447c.jpg
  size672945
  ext.jpg
  mimeimage/jpeg
  width1920
  height1440
  Image3Upload(array)
  0(array)
  id148659
  hashcc3fc5b9335f49c3be5d1a2ebbffecff
  created2020-02-04 03:01:00
  updated2020-02-04 03:01:08
  modelStation
  fieldimage_3
  foreign_key2633
  aliasaussen-2014.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Station/Image3/5e38d064602b8.jpg
  size784541
  ext.jpg
  mimeimage/jpeg
  width1920
  height1280
  1(array)
  id148666
  hash71de7f0832ed1cd22d86cc1434f9cd73
  created2020-02-04 03:01:08
  updated2020-02-04 03:01:08
  modelStation
  fieldimage_3
  foreign_key2633
  aliasaussen-2014-thstationimagelandscape.jpg
  thumbnailth-station-image-landscape
  parent_id148659
  filewebroot/files/Station/Image3/ThStationImageLandscape/5e38d06462e05.jpg
  size90676
  ext.jpg
  mimeimage/jpeg
  width752
  height562
  2(array)
  id148667
  hash9b650851ef443abd50617397ae7cd323
  created2020-02-04 03:01:08
  updated2020-02-04 03:01:08
  modelStation
  fieldimage_3
  foreign_key2633
  aliasaussen-2014-thstationimagelightbox.jpg
  thumbnailth-station-image-lightbox
  parent_id148659
  filewebroot/files/Station/Image3/ThStationImageLightbox/5e38d064af628.jpg
  size527945
  ext.jpg
  mimeimage/jpeg
  width1920
  height1280
  Image4Upload(array)
  0(array)
  id148660
  hash07ad7a2332d2582cc920880a0c82ada4
  created2020-02-04 03:01:00
  updated2020-02-04 03:01:08
  modelStation
  fieldimage_4
  foreign_key2633
  aliasluftbild-2015.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Station/Image4/5e38d064e4ca7.jpg
  size697193
  ext.jpg
  mimeimage/jpeg
  width1024
  height647
  1(array)
  id148668
  hashfc01ca6f011d172b3c4f2f7a24dcb288
  created2020-02-04 03:01:09
  updated2020-02-04 03:01:09
  modelStation
  fieldimage_4
  foreign_key2633
  aliasluftbild-2015-thstationimagelandscape.jpg
  thumbnailth-station-image-landscape
  parent_id148660
  filewebroot/files/Station/Image4/ThStationImageLandscape/5e38d064e7798.jpg
  size110197
  ext.jpg
  mimeimage/jpeg
  width752
  height562
  2(array)
  id148669
  hash4daa7040d2977fe49c7c3532881b8baf
  created2020-02-04 03:01:09
  updated2020-02-04 03:01:09
  modelStation
  fieldimage_4
  foreign_key2633
  aliasluftbild-2015-thstationimagelightbox.jpg
  thumbnailth-station-image-lightbox
  parent_id148660
  filewebroot/files/Station/Image4/ThStationImageLightbox/5e38d06516586.jpg
  size170998
  ext.jpg
  mimeimage/jpeg
  width1024
  height647
  Image5Upload(array)
  0(array)
  id148661
  hashe4263d8269949b364c6cd7703266af6a
  created2020-02-04 03:01:00
  updated2020-02-04 03:01:09
  modelStation
  fieldimage_5
  foreign_key2633
  aliasoi000007.jpg
  thumbnail(null)
  parent_id(null)
  filewebroot/files/Station/Image5/5e38d06523eb1.jpg
  size716686
  ext.jpg
  mimeimage/jpeg
  width2048
  height1360
  1(array)
  id148670
  hasha2bedc5987e7b80e7747e8f68715963b
  created2020-02-04 03:01:09
  updated2020-02-04 03:01:09
  modelStation
  fieldimage_5
  foreign_key2633
  aliasoi000007-thstationimagelandscape.jpg
  thumbnailth-station-image-landscape
  parent_id148661
  filewebroot/files/Station/Image5/ThStationImageLandscape/5e38d06526822.jpg
  size115563
  ext.jpg
  mimeimage/jpeg
  width752
  height562
  2(array)
  id148671
  hash5de2a6569eacf52b9de5a6befbee7615
  created2020-02-04 03:01:10
  updated2020-02-04 03:01:10
  modelStation
  fieldimage_5
  foreign_key2633
  aliasoi000007-thstationimagelightbox.jpg
  thumbnailth-station-image-lightbox
  parent_id148661
  filewebroot/files/Station/Image5/ThStationImageLightbox/5e38d0658092d.jpg
  size535487
  ext.jpg
  mimeimage/jpeg
  width1920
  height1275
  Image6Upload(empty)
  Image7Upload(empty)
  Image8Upload(empty)
  Image9Upload(empty)
  Image10Upload(empty)
  Image11Upload(empty)
  Image12Upload(empty)
  Image13Upload(empty)
  Image14Upload(empty)
  Image15Upload(empty)
- regionModel(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Media.Media(array)
  gallery(array)
  multiple(true)
  thumbnails(array)
  th-region-gallery(array)
  filters(array)
  0(array)
  0adaptive_resize
  1750
  2500
  quality80
  ext.jpg
  Uploads.Upload(array)
  logo(array)
  thumbnails(array)
  th-region-logo(array)
  filters(array)
  0(array)
  0best_fit
  1300
  2230
  quality80
  ext.png
  BaseData.Enum(array)
  0status
  Routes.Routable(array)
  controllerFrontendRegions.FrontendRegions
  actionregion
  unique(true)
  autoGenerate(true)
  fieldtitle
  Seo.Seo(null)
  HeaderImages.HeaderImage(null)
  containments(array)
  0Country
  1State
  GalleryMedia(array)
  0FileUpload
  2LogoUpload
  3Route
  Seo(array)
  ImageMedia(array)
  0FileUpload
  HeaderImage(array)
  ImageMedia(array)
  0FileUpload
  belongsTo(array)
  Country(array)
  classNameCountries.Country
  foreignKeycountry_id
  conditions
  fields
  order
  counterCache
  State(array)
  classNameStates.State
  foreignKeystate_id
  conditions
  fields
  order
  counterCache
  hasMany(array)
  Station(array)
  classNameStations.Station
  foreignKeyregion_id
  conditions
  fields
  order
  limit
  offset
  dependent
  exclusive
  finderQuery
  counterQuery
  LogoUpload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(LogoUpload.thumbnail, -1), -1) DESC
  conditions(array)
  LogoUpload.modelRegion
  LogoUpload.fieldlogo
  HeaderImage(array)
  classNameHeaderImages.HeaderImage
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  HeaderImage.modelRegion
  validate(array)
  title(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  state_id(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTableregions
  id(false)
  data(empty)
  schemaNameebh_2020
  tableregions
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginRegions
  nameRegion
  aliasRegion
  tableToModel(array)
  regionsRegion
  mediaGalleryMedia
  seoSeo
  header_imagesHeaderImage
  stationsStation
  hasOne(array)
  Route(array)
  classNameRoutes.Route
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Route.modelRegion
  Seo(array)
  classNameSeo.Seo
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Seo.modelRegion
  hasAndBelongsToMany(array)
  GalleryMedia(array)
  classNameMedia.Media
  withMedia.MediaEntity
  joinTablemedia_entities
  foreignKeyforeign_key
  associationForeignKeymedia_id
  unique(true)
  conditions(array)
  MediaEntity.modelRegion
  MediaEntity.fieldgallery
  orderMediaEntity.pos ASC
  Behaviors(object)
  modelNameRegion
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(array)
  station_countSELECT COUNT(1) FROM `ebh_2020`.`stations` AS `StationCount` WHERE `StationCount`.`region_id` = `Region`.`id`
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  GalleryMedia(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Uploads.Upload(array)
  file(array)
  thumbnails(array)
  th-media-file-index(array)
  filters(array)
  0(array)
  0best_fit
  1150
  2150
  ckeditor_xs(array)
  filters(array)
  0(array)
  0fit_to_width
  180
  ckeditor_sm(array)
  filters(array)
  0(array)
  0fit_to_width
  1150
  ckeditor_md(array)
  filters(array)
  0(array)
  0fit_to_width
  1200
  ckeditor_lg(array)
  filters(array)
  0(array)
  0fit_to_width
  1300
  Tags.Taggable(array)
  0tags
  hasMany(array)
  MediaEntity(array)
  classNameMedia.MediaEntity
  essential(true)
  foreignKeymedia_id
  conditions
  fields
  order
  limit
  offset
  dependent
  exclusive
  finderQuery
  counterQuery
  FileUpload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(FileUpload.thumbnail, -1), -1) DESC
  conditions(array)
  FileUpload.modelMedia
  FileUpload.fieldfile
  validate(array)
  title(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  file(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  containments(array)
  0FileUpload
  1TagsTag
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTablemedia
  id(false)
  data(empty)
  schemaNameebh_2020
  tablemedia
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginMedia
  nameMedia
  aliasGalleryMedia
  tableToModel(array)
  mediaGalleryMedia
  media_entitiesMediaEntity
  uploadsFileUpload
  belongsTo(empty)
  hasOne(empty)
  hasAndBelongsToMany(array)
  TagsTag(array)
  classNameTags.Tag
  withTagEntity
  joinTabletag_entities
  foreignKeyforeign_key
  associationForeignKeytag_id
  unique(true)
  conditions(array)
  TagEntity.modelMedia
  TagEntity.fieldtags
  Behaviors(object)
  modelNameGalleryMedia
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(array)
  cross_reference_countSELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `GalleryMedia`.`id`
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  MediaEntity(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  validate(array)
  title(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  containments(empty)
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTablemedia_entities
  id(false)
  data(empty)
  schemaNameebh_2020
  tablemedia_entities
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginMedia
  nameMediaEntity
  aliasMediaEntity
  tableToModel(array)
  media_entitiesMediaEntity
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameMediaEntity
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  FileUpload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasFileUpload
  tableToModel(array)
  uploadsFileUpload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameFileUpload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Seo(object)
  useTableseo
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Media.Media(array)
  image(array)
  thumbnails(array)
  th-seo-image-facebook(array)
  filters(array)
  0(array)
  0best_fit
  11500
  21500
  ext.png
  quality100
  th-seo-image-google(array)
  filters(array)
  0(array)
  0best_fit
  11500
  21500
  ext.png
  quality100
  th-seo-image-twitter(array)
  filters(array)
  0(array)
  0best_fit
  1375
  2375
  ext.png
  quality100
  BaseData.BitMask(array)
  robots(array)
  1(array)
  titleSeite in den Suchindex aufnehmen
  iconfa fa-plus-square-alt green
  2(array)
  titleLinks auf der Seite folgen
  iconfa fa-share-alt blue
  validate(array)
  author(array)
  ruleurl
  messageDieses Feld muss eine URL sein
  allowEmpty(true)
  recursive-1
  containments(array)
  ImageMedia(array)
  0FileUpload
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  id(false)
  data(empty)
  schemaNameebh_2020
  tableseo
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginSeo
  nameSeo
  aliasSeo
  tableToModel(array)
  seoSeo
  mediaImageMedia
  media_entitiesMediaEntity
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(array)
  ImageMedia(array)
  classNameMedia.Media
  withMedia.MediaEntity
  joinTablemedia_entities
  foreignKeyforeign_key
  associationForeignKeymedia_id
  unique(true)
  conditions(array)
  MediaEntity.modelSeo
  MediaEntity.fieldimage
  orderMediaEntity.pos ASC
  Behaviors(object)
  modelNameSeo
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  ImageMedia(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Uploads.Upload(array)
  file(array)
  thumbnails(array)
  th-media-file-index(array)
  filters(array)
  0(array)
  0best_fit
  1150
  2150
  ckeditor_xs(array)
  filters(array)
  0(array)
  0fit_to_width
  180
  ckeditor_sm(array)
  filters(array)
  0(array)
  0fit_to_width
  1150
  ckeditor_md(array)
  filters(array)
  0(array)
  0fit_to_width
  1200
  ckeditor_lg(array)
  filters(array)
  0(array)
  0fit_to_width
  1300
  Tags.Taggable(array)
  0tags
  hasMany(array)
  MediaEntity(array)
  classNameMedia.MediaEntity
  essential(true)
  foreignKeymedia_id
  conditions
  fields
  order
  limit
  offset
  dependent
  exclusive
  finderQuery
  counterQuery
  FileUpload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(FileUpload.thumbnail, -1), -1) DESC
  conditions(array)
  FileUpload.modelMedia
  FileUpload.fieldfile
  validate(array)
  title(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  file(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  containments(array)
  0FileUpload
  1TagsTag
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTablemedia
  id(false)
  data(empty)
  schemaNameebh_2020
  tablemedia
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginMedia
  nameMedia
  aliasImageMedia
  tableToModel(array)
  mediaImageMedia
  media_entitiesMediaEntity
  uploadsFileUpload
  belongsTo(empty)
  hasOne(empty)
  hasAndBelongsToMany(array)
  TagsTag(array)
  classNameTags.Tag
  withTagEntity
  joinTabletag_entities
  foreignKeyforeign_key
  associationForeignKeytag_id
  unique(true)
  conditions(array)
  TagEntity.modelMedia
  TagEntity.fieldtags
  Behaviors(object)
  modelNameImageMedia
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(array)
  cross_reference_countSELECT COUNT(1) FROM `ebh_2020`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `ImageMedia`.`id`
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  MediaEntity(object) - recursion
  FileUpload(object) - recursion
  MediaEntity(object) - recursion
  HeaderImage(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Media.Media(array)
  image(array)
  thumbnails(array)
  th-header-image(array)
  filters(array)
  0(array)
  0adaptive_resize
  11920
  2960
  ext.jpg
  quality80
  validate(array)
  url(array)
  rule(array)
  0url
  1(true)
  messageDieses Feld muss eine URL sein
  allowEmpty(true)
  recursive-1
  containments(array)
  ImageMedia(array)
  0FileUpload
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTableheader_images
  id(false)
  data(empty)
  schemaNameebh_2020
  tableheader_images
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginHeaderImages
  nameHeaderImage
  aliasHeaderImage
  tableToModel(array)
  header_imagesHeaderImage
  mediaImageMedia
  media_entitiesMediaEntity
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(array)
  ImageMedia(array)
  classNameMedia.Media
  withMedia.MediaEntity
  joinTablemedia_entities
  foreignKeyforeign_key
  associationForeignKeymedia_id
  unique(true)
  conditions(array)
  MediaEntity.modelHeaderImage
  MediaEntity.fieldimage
  orderMediaEntity.pos ASC
  Behaviors(object)
  modelNameHeaderImage
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  ImageMedia(object) - recursion
  MediaEntity(object) - recursion
  Station(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Maps.GeoPosition(array)
  0geopoint
  BaseData.Enum(array)
  status(array)
  active(array)
  titleAktiv
  iconfa fa-check green
  inactive(array)
  titleInaktiv
  iconfa fa-times red
  type(array)
  hotel(array)
  titleE-Bike Hotel
  iconfa fa-suitcase green
  station(array)
  titleVerleihstation
  iconfa fa-bicycle purple
  source(array)
  greenstorm_manual(array)
  titleGreenstorm manuell
  greenstorm_api(array)
  titleGreenstorm Schnittstelle
  movelo_manual(array)
  titleMovelo manuell
  other_manual(array)
  titleSonstige manuell
  Uploads.Upload(array)
  logo(array)
  thumbnails(array)
  th-station-logo(array)
  filters(array)
  0(array)
  0fit_to_max_width
  1350
  ext.gif
  image_1(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_2(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_3(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_4(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_5(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_6(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_7(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_8(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_9(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_10(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_11(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_12(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_13(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_14(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  image_15(array)
  thumbnails(array)
  th-station-image-landscape(array)
  filters(array)
  0(array)
  0fit_to_width
  1752
  ext.jpg
  quality80
  th-station-image-lightbox(array)
  filters(array)
  0(array)
  0fit_to_max_width
  11920
  quality80
  Routes.Routable(array)
  controllerFrontendRegions.FrontendRegions
  actionstation
  unique(true)
  autoGenerate(true)
  fieldtitle
  Seo.Seo(null)
  Teasers.Teaser(null)
  HeaderImages.HeaderImage(null)
  containments(array)
  0Region
  1State
  2LogoUpload
  3Image1Upload
  4Image2Upload
  5Image3Upload
  6Image4Upload
  7Image5Upload
  8Image6Upload
  9Image7Upload
  10Image8Upload
  11Image9Upload
  12Image10Upload
  13Image11Upload
  14Image12Upload
  15Image13Upload
  16Image14Upload
  17Image15Upload
  18Route
  Seo(array)
  ImageMedia(array)
  0FileUpload
  Teaser(array)
  ImageMedia(array)
  0FileUpload
  HeaderImage(array)
  ImageMedia(array)
  0FileUpload
  belongsTo(array)
  Region(array)
  classNameRegions.Region
  foreignKeyregion_id
  conditions
  fields
  order
  counterCache
  State(array)
  classNameStates.State
  foreignKeystate_id
  conditions
  fields
  order
  counterCache
  hasMany(array)
  Offer(array)
  classNameOffers.Offer
  foreignKeystation_id
  conditions
  fields
  order
  limit
  offset
  dependent
  exclusive
  finderQuery
  counterQuery
  LogoUpload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(LogoUpload.thumbnail, -1), -1) DESC
  conditions(array)
  LogoUpload.modelStation
  LogoUpload.fieldlogo
  Image1Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image1Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image1Upload.modelStation
  Image1Upload.fieldimage_1
  Image2Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image2Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image2Upload.modelStation
  Image2Upload.fieldimage_2
  Image3Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image3Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image3Upload.modelStation
  Image3Upload.fieldimage_3
  Image4Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image4Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image4Upload.modelStation
  Image4Upload.fieldimage_4
  Image5Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image5Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image5Upload.modelStation
  Image5Upload.fieldimage_5
  Image6Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image6Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image6Upload.modelStation
  Image6Upload.fieldimage_6
  Image7Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image7Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image7Upload.modelStation
  Image7Upload.fieldimage_7
  Image8Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image8Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image8Upload.modelStation
  Image8Upload.fieldimage_8
  Image9Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image9Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image9Upload.modelStation
  Image9Upload.fieldimage_9
  Image10Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image10Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image10Upload.modelStation
  Image10Upload.fieldimage_10
  Image11Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image11Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image11Upload.modelStation
  Image11Upload.fieldimage_11
  Image12Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image12Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image12Upload.modelStation
  Image12Upload.fieldimage_12
  Image13Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image13Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image13Upload.modelStation
  Image13Upload.fieldimage_13
  Image14Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image14Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image14Upload.modelStation
  Image14Upload.fieldimage_14
  Image15Upload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(Image15Upload.thumbnail, -1), -1) DESC
  conditions(array)
  Image15Upload.modelStation
  Image15Upload.fieldimage_15
  HeaderImage(array)
  classNameHeaderImages.HeaderImage
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  HeaderImage.modelStation
  validate(array)
  title(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  route(array)
  notBlank(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  category_id(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTablestations
  id(false)
  data(empty)
  schemaNameebh_2020
  tablestations
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginStations
  nameStation
  aliasStation
  tableToModel(array)
  stationsStation
  seoSeo
  teasersTeaser
  header_imagesHeaderImage
  offersOffer
  uploadsImage15Upload
  regionsRegion
  statesState
  routesRoute
  hasOne(array)
  Route(array)
  classNameRoutes.Route
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Route.modelStation
  Seo(array)
  classNameSeo.Seo
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Seo.modelStation
  Teaser(array)
  classNameTeasers.Teaser
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Teaser.modelStation
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameStation
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(array)
  geopointCONCAT_WS (';',Station.geopoint_lat,Station.geopoint_long)
  offer_countSELECT COUNT(1) FROM `ebh_2020`.`offers` AS `OfferCount` WHERE `OfferCount`.`station_id` = `Station`.`id` AND `OfferCount`.`status` = 'active' AND NOW() BETWEEN COALESCE(`OfferCount`.`release`, NOW()) AND COALESCE(`OfferCount`.`hide`, NOW())
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Seo(object) - recursion
  Teaser(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Media.Media(array)
  image(array)
  thumbnails(array)
  th-teaser-image-landscape(array)
  filters(array)
  0(array)
  0adaptive_resize
  1700
  2483
  ext.jpg
  quality80
  BaseData.Layout(array)
  layout(array)
  col12(array)
  title1/1 Breite
  classcol-xs-12
  groupAllgemein
  col6(array)
  title1/2 Breite
  classcol-xs-12 col-sm-6
  groupAllgemein
  col4(array)
  title1/3 Breite
  classcol-xs-12 col-sm-6 col-md-4
  groupAllgemein
  col8(array)
  title2/3 Breite
  classcol-xs-12 col-sm-6 col-md-8
  groupAllgemein
  col3(array)
  title1/4 Breite
  classcol-xs-12 col-sm-6 col-md-3
  groupAllgemein
  validate(empty)
  recursive-1
  containments(array)
  ImageMedia(array)
  0FileUpload
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTableteasers
  id(false)
  data(empty)
  schemaNameebh_2020
  tableteasers
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginTeasers
  nameTeaser
  aliasTeaser
  tableToModel(array)
  teasersTeaser
  mediaImageMedia
  media_entitiesMediaEntity
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(array)
  ImageMedia(array)
  classNameMedia.Media
  withMedia.MediaEntity
  joinTablemedia_entities
  foreignKeyforeign_key
  associationForeignKeymedia_id
  unique(true)
  conditions(array)
  MediaEntity.modelTeaser
  MediaEntity.fieldimage
  orderMediaEntity.pos ASC
  Behaviors(object)
  modelNameTeaser
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  ImageMedia(object) - recursion
  MediaEntity(object) - recursion
  HeaderImage(object) - recursion
  Offer(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Maps.GeoPosition(array)
  0geopoint
  Media.Media(array)
  gallery(array)
  multiple(true)
  thumbnails(array)
  th-offer-gallery(array)
  filters(array)
  0(array)
  0adaptive_resize
  1750
  2500
  quality80
  ext.jpg
  BaseData.Enum(array)
  0status
  Routes.Routable(array)
  controllerFrontendOffers.FrontendOffers
  actionoffer
  unique(true)
  autoGenerate(true)
  fieldtitle
  Seo.Seo(null)
  Teasers.Teaser(null)
  HeaderImages.HeaderImage(null)
  belongsTo(array)
  Station(array)
  classNameStations.Station
  foreignKeystation_id
  conditions
  fields
  order
  counterCache
  State(array)
  classNameStates.State
  foreignKeystate_id
  conditions
  fields
  order
  counterCache
  Region(array)
  classNameRegions.Region
  foreignKeyregion_id
  conditions
  fields
  order
  counterCache
  containments(array)
  0Station
  1State
  2Region
  GalleryMedia(array)
  0FileUpload
  3Route
  Seo(array)
  ImageMedia(array)
  0FileUpload
  Teaser(array)
  ImageMedia(array)
  0FileUpload
  HeaderImage(array)
  ImageMedia(array)
  0FileUpload
  validate(array)
  title(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTableoffers
  id(false)
  data(empty)
  schemaNameebh_2020
  tableoffers
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginOffers
  nameOffer
  aliasOffer
  tableToModel(array)
  offersOffer
  mediaGalleryMedia
  seoSeo
  teasersTeaser
  header_imagesHeaderImage
  hasOne(array)
  Route(array)
  classNameRoutes.Route
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Route.modelOffer
  Seo(array)
  classNameSeo.Seo
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Seo.modelOffer
  Teaser(array)
  classNameTeasers.Teaser
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Teaser.modelOffer
  hasMany(array)
  HeaderImage(array)
  classNameHeaderImages.HeaderImage
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  HeaderImage.modelOffer
  hasAndBelongsToMany(array)
  GalleryMedia(array)
  classNameMedia.Media
  withMedia.MediaEntity
  joinTablemedia_entities
  foreignKeyforeign_key
  associationForeignKeymedia_id
  unique(true)
  conditions(array)
  MediaEntity.modelOffer
  MediaEntity.fieldgallery
  orderMediaEntity.pos ASC
  Behaviors(object)
  modelNameOffer
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(array)
  geopointCONCAT_WS (';',Offer.geopoint_lat,Offer.geopoint_long)
  publishedNOW() BETWEEN COALESCE(`Offer`.`release`, NOW()) AND COALESCE(`Offer`.`hide`, NOW())
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  GalleryMedia(object) - recursion
  Seo(object) - recursion
  Teaser(object) - recursion
  HeaderImage(object) - recursion
  LogoUpload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasLogoUpload
  tableToModel(array)
  uploadsLogoUpload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameLogoUpload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Region(object) - recursion
  State(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  BaseData.Enum(array)
  0status
  belongsTo(array)
  Country(array)
  classNameCountries.Country
  foreignKeycountry_id
  conditions
  fields
  order
  counterCache
  hasMany(array)
  Station(array)
  classNameStations.Station
  foreignKeystate_id
  conditions
  fields
  order
  limit
  offset
  dependent
  exclusive
  finderQuery
  counterQuery
  validate(array)
  title(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  country_id(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  containments(empty)
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTablestates
  id(false)
  data(empty)
  schemaNameebh_2020
  tablestates
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginStates
  nameState
  aliasState
  tableToModel(array)
  statesState
  countriesCountry
  hasOne(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameState
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Country(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  BaseData.Enum(array)
  0status
  BaseData.List(null)
  hasMany(array)
  Region(array)
  classNameRegions.Region
  foreignKeycountry_id
  conditions
  fields
  order
  limit
  offset
  dependent
  exclusive
  finderQuery
  counterQuery
  State(array)
  classNameStates.State
  foreignKeycountry_id
  conditions
  fields
  order
  limit
  offset
  dependent
  exclusive
  finderQuery
  counterQuery
  belongsTo(array)
  Menu(array)
  classNameMenus.Menu
  foreignKeymenu_id
  conditions
  fields
  order
  counterCache
  validate(array)
  title(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  containments(empty)
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTablecountries
  id(false)
  data(empty)
  schemaNameebh_2020
  tablecountries
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginCountries
  nameCountry
  aliasCountry
  tableToModel(array)
  countriesCountry
  regionsRegion
  statesState
  hasOne(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameCountry
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(array)
  region_countSELECT COUNT(1) FROM `ebh_2020`.`regions` AS `RegionCount` WHERE `RegionCount`.`country_id` = `Country`.`id`
  state_countSELECT COUNT(1) FROM `ebh_2020`.`states` AS `StateCount` WHERE `StateCount`.`country_id` = `Country`.`id`
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Region(object) - recursion
  State(object) - recursion
  Image1Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage1Upload
  tableToModel(array)
  uploadsImage1Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage1Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image2Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage2Upload
  tableToModel(array)
  uploadsImage2Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage2Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image3Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage3Upload
  tableToModel(array)
  uploadsImage3Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage3Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image4Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage4Upload
  tableToModel(array)
  uploadsImage4Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage4Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image5Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage5Upload
  tableToModel(array)
  uploadsImage5Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage5Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image6Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage6Upload
  tableToModel(array)
  uploadsImage6Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage6Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image7Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage7Upload
  tableToModel(array)
  uploadsImage7Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage7Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image8Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage8Upload
  tableToModel(array)
  uploadsImage8Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage8Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image9Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage9Upload
  tableToModel(array)
  uploadsImage9Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage9Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image10Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage10Upload
  tableToModel(array)
  uploadsImage10Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage10Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image11Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage11Upload
  tableToModel(array)
  uploadsImage11Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage11Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image12Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage12Upload
  tableToModel(array)
  uploadsImage12Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage12Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image13Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage13Upload
  tableToModel(array)
  uploadsImage13Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage13Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image14Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage14Upload
  tableToModel(array)
  uploadsImage14Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage14Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Image15Upload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasImage15Upload
  tableToModel(array)
  uploadsImage15Upload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameImage15Upload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Route(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Tree(null)
  Routes.Redirect(null)
  BaseData.Nullable(array)
  0controller
  1action
  2alias
  hasMany(array)
  MountPoint(array)
  classNameMountPoints.MountPoint
  foreignKeyroute_id
  conditions
  fields
  order
  limit
  offset
  dependent
  exclusive
  finderQuery
  counterQuery
  validate(array)
  model(array)
  notBlank(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  foreign_key(array)
  notBlank(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  decimal(array)
  ruledecimal
  messageDas ist keine Zahl
  alias(array)
  isValidAlias(array)
  ruleisValidAlias
  messageDieser Alias ist ungültig
  recursive-1
  containments(empty)
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTableroutes
  id(false)
  data(empty)
  schemaNameebh_2020
  tableroutes
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginRoutes
  nameRoute
  aliasRoute
  tableToModel(array)
  routesRoute
  mount_pointsMountPoint
  belongsTo(empty)
  hasOne(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameRoute
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(array)
  routeIF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  MountPoint(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Languages.Language(null)
  belongsTo(array)
  Route(array)
  classNameRoutes.Route
  foreignKeyroute_id
  conditions
  fields
  order
  counterCache
  Language(array)
  classNameLanguages.Language
  foreignKeylanguage_id
  typeLEFT
  counterCache(false)
  conditions(empty)
  validate(array)
  title(array)
  notBlank(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  isUniqueMountPoint(array)
  ruleisUniqueMountPoint
  messageDieser Einhängepunkt ist bereits veregeben
  route_id(array)
  notBlank(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  recursive-1
  containments(array)
  0Language
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTablemount_points
  id(false)
  data(empty)
  schemaNameebh_2020
  tablemount_points
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginMountPoints
  nameMountPoint
  aliasMountPoint
  tableToModel(array)
  mount_pointsMountPoint
  languagesLanguage
  routesRoute
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameMountPoint
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Language(object)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Search(null)
  Audit.Auditable(null)
  BaseData.Hash(null)
  BaseData.DateTime(null)
  Uploads.Upload(array)
  flag(array)
  thumbnails(array)
  th-language-flag-xs(array)
  filters(array)
  0(array)
  0adaptive_resize
  124
  224
  ext.gif
  Routes.Routable(null)
  validate(array)
  title(array)
  notBlank(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  langid(array)
  notBlank(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  flag(array)
  notBlank(array)
  rulenotBlank
  messageDieses Feld ist ein Pflichtfeld
  default(array)
  ruleoneMustBePresent
  messageEin Standard wird benötigt
  recursive-1
  containments(array)
  0FlagUpload
  1Route
  validationDomainapp
  cacheQueries(true)
  useDbConfigdefault
  useTablelanguages
  id(false)
  data(empty)
  schemaNameebh_2020
  tablelanguages
  primaryKeyid
  validationErrors(empty)
  tablePrefix
  pluginLanguages
  nameLanguage
  aliasLanguage
  tableToModel(array)
  languagesLanguage
  uploadsFlagUpload
  routesRoute
  belongsTo(empty)
  hasOne(array)
  Route(array)
  classNameRoutes.Route
  foreignKeyforeign_key
  dependent(true)
  conditions(array)
  Route.modelLanguage
  hasMany(array)
  FlagUpload(array)
  classNameUploads.Upload
  foreignKeyforeign_key
  dependent(true)
  order(array)
  0(array)
  0FIELD(COALESCE(FlagUpload.thumbnail, -1), -1) DESC
  conditions(array)
  FlagUpload.modelLanguage
  FlagUpload.fieldflag
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameLanguage
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  FlagUpload(object)
  cacheQueries(false)
  actsAs(array)
  BaseData.AdvancedContainable(null)
  BaseData.Essential(null)
  BaseData.Hash(null)
  Uploads.Transformation(null)
  recursive-1
  containments(empty)
  validationDomainapp
  useDbConfigdefault
  useTableuploads
  id(false)
  data(empty)
  schemaNameebh_2020
  tableuploads
  primaryKeyid
  validate(empty)
  validationErrors(empty)
  tablePrefix
  pluginUploads
  nameUpload
  aliasFlagUpload
  tableToModel(array)
  uploadsFlagUpload
  belongsTo(empty)
  hasOne(empty)
  hasMany(empty)
  hasAndBelongsToMany(empty)
  Behaviors(object)
  modelNameFlagUpload
  defaultPriority10
  whitelist(empty)
  cacheSources(true)
  findQueryType(null)
  order(null)
  virtualFields(empty)
  __backAssociation(empty)
  __backInnerAssociation(empty)
  __backOriginalAssociation(empty)
  __backContainableAssociation(empty)
  __safeUpdateMode(false)
  useConsistentAfterFind(true)
  findMethods(array)
  all(true)
  first(true)
  count(true)
  neighbors(true)
  list(true)
  threaded(true)
  Route(object) - recursion
  Route(object) - recursion
- offerUrl/e-bike-urlaub/reiseangebote/ergebnis
- OfferSearch(object)
  seo(array)
  title
  description
- RegionSearch(object)
  seo(array)
  title
  description
- HotelAndRentalStationSearch(object)
  seo(array)
  title
  description
- HotelSearch(object)
  seo(array)
  title
  description
- RentalStationSearch(object)
  seo(array)
  title
  description
- stationModel(object) - recursion
- $request->data(empty)
- $this->validationErrors(array)
  Route(empty)
  MountPoint(empty)
  Redirect(empty)
  Language(empty)
  Station(empty)
  Seo(empty)
  ImageMedia(empty)
  MediaEntity(empty)
  Teaser(empty)
  HeaderImage(empty)
  Offer(empty)
  GalleryMedia(empty)
  Setting(empty)
  ValueUpload(empty)
  LogoUpload(empty)
  Region(empty)
  State(empty)
  Country(empty)
  Image1Upload(empty)
  Image2Upload(empty)
  Image3Upload(empty)
  Image4Upload(empty)
  Image5Upload(empty)
  Image6Upload(empty)
  Image7Upload(empty)
  Image8Upload(empty)
  Image9Upload(empty)
  Image10Upload(empty)
  Image11Upload(empty)
  Image12Upload(empty)
  Image13Upload(empty)
  Image14Upload(empty)
  Image15Upload(empty)
  Menu(empty)
  Parent(empty)
  HeaderImagesMedia(empty)
  FileUpload(empty)
  HeaderVideoUpload(empty)
  Content(empty)
  ArticleContentMedia(empty)
  BannerLogoMedia(empty)
  FlagUpload(empty)
  Banner(empty)
- Loaded Helpers(array)
  0Html
  1Tree
  2Upload
  3Media
  4Route
  5Bs3Html
  6Form
  7SocialMedia
  8GMap
  9OAJs
  10OA
  11Embed
  12Layout
  13ThirdPartyCookies
  14BitMask
  15Recaptcha
  16Number
  17SimpleGraph
  18DebugTimer
  19Toolbar
  20FrontendUpload
  21Session
  22Js
  23HtmlToolbar
====

Environment

App Constants

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

CakePHP Constants

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

PHP Environment

Environment Variable	Value
Php Version	7.2.31
User	u34892347892
Home	/var/www/vhosts/ebike-holiday.com
Script Name	/webroot/index.php
Request Uri	/ferienwohnung-strandapartment-deich-lounge
Query String
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Url	/webroot/ferienwohnung-strandapartment-deich-lounge
Remote Port	55330
Script Filename	/var/www/vhosts/ebike-holiday.com/httpdocs/webroot/index.php
Server Admin	root@localhost
Context Document Root	/var/www/vhosts/ebike-holiday.com/httpdocs
Context Prefix
Request Scheme	https
Document Root	/var/www/vhosts/ebike-holiday.com/httpdocs
Remote Addr	3.214.184.223
Server Port	443
Server Addr	85.236.63.137
Server Name	www.ebike-holiday.com
Server Software	Apache
Server Signature
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin
Http Accept Encoding	br,gzip
Http If Modified Since	Sun, 29 Mar 2020 07:58:41 UTC
Http Accept Language	en-US,en;q=0.5
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Connection	close
Http X Accel Internal	/internal-nginx-static-location
Http X Real Ip	3.214.184.223
Http Host	www.ebike-holiday.com
Proxy-nokeepalive	1
Https	on
Unique Id	XwFDT@NfyvaL1If6dcT5QgAAAAw
Redirect Status	200
Redirect Https	on
Redirect Unique Id	XwFDT@NfyvaL1If6dcT5QgAAAAw
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Unique Id	XwFDT@NfyvaL1If6dcT5QgAAAAw
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1593918287.9857
Request Time	1593918287

====

Include
+
Included Files

Include Paths
- 1/opt/plesk/php/7.2/share/pear
- 2-> /var/www/vhosts/ebike-holiday.com/httpdocs/contrance/Vendor/Cake/lib/Cake/
Included Files
- core(empty)
- app(array)
  Behavior(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/ContainableBehavior.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Behavior/TreeBehavior.php
  Cache(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Cache/Cache.php
  1APP/contrance/Vendor/Cake/lib/Cake/Cache/Engine/FileEngine.php
  2APP/contrance/Vendor/Cake/lib/Cake/Cache/CacheEngine.php
  Component(array)
  0APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/RequestHandlerComponent.php
  1APP/contrance/Vendor/Cake/lib/Cake/Controller/Component/SessionComponent.php
  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/Database/Mysql.php
  1APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DboSource.php
  2APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/DataSource.php
  3APP/contrance/Vendor/Cake/lib/Cake/Model/Datasource/CakeSession.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
  2APP/contrance/Vendor/Cake/lib/Cake/Network/Http/HttpSocket.php
  3APP/contrance/Vendor/Cake/lib/Cake/Network/CakeSocket.php
  Other(array)
  0APP/webroot/index.php
  1APP/contrance/Vendor/Cake/lib/Cake/bootstrap.php
  2APP/contrance/Vendor/Cake/lib/Cake/basics.php
  3APP/contrance/Vendor/Cake/lib/Cake/Core/App.php
  4APP/contrance/Vendor/Cake/lib/Cake/Core/Configure.php
  5APP/contrance/Vendor/Cake/lib/Cake/Core/CakePlugin.php
  6APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventListener.php
  7APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEvent.php
  8APP/contrance/Vendor/Cake/lib/Cake/Event/CakeEventManager.php
  9APP/contrance/Vendor/Cake/lib/Cake/Core/CakeObject.php
  10APP/Lib/Search/Common/SearchRequest.php
  11APP/Lib/Search/RentalStationSearch.php
  12APP/Lib/Search/AbstractStationSearch.php
  13APP/Lib/Search/AbstractSearch.php
  14APP/Lib/Search/Types/CountryStateSearchType.php
  15APP/Lib/Search/Types/AbstractSearchType.php
  16APP/Lib/Search/Types/RadiusSearchType.php
  17APP/Lib/Search/Types/NameSearchType.php
  18APP/Lib/Search/Types/RegionSearchType.php
  19APP/Lib/Search/HotelSearch.php
  20APP/Lib/Search/HotelAndRentalStationSearch.php
  21APP/Lib/Search/RegionSearch.php
  22APP/Lib/Search/OfferSearch.php
  23APP/Lib/Search/Types/RadiusOfferSearchType.php
  24APP/Lib/Search/Types/StationSearchType.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/Debugger.php
  4APP/contrance/Vendor/Cake/lib/Cake/Utility/CakeText.php
  5APP/contrance/Vendor/Cake/lib/Cake/Utility/ClassRegistry.php
  View(array)
  0APP/contrance/Vendor/Cake/lib/Cake/View/HelperCollection.php
- plugins(array)
  Audit(array)
  Behavior(array)
  0Audit/Model/Behavior/AuditableBehavior.php
  BaseData(array)
  Model(array)
  0BaseData/Model/BaseDataAppModel.php
  Behavior(array)
  0BaseData/Model/Behavior/AdvancedContainableBehavior.php
  1BaseData/Model/Behavior/EssentialBehavior.php
  2BaseData/Model/Behavior/SearchBehavior.php
  3BaseData/Model/Behavior/HashBehavior.php
  4BaseData/Model/Behavior/DateTimeBehavior.php
  5BaseData/Model/Behavior/NullableBehavior.php
  6BaseData/Model/Behavior/EnumBehavior.php
  7BaseData/Model/Behavior/SwitchableBehavior.php
  8BaseData/Model/Behavior/BitMaskBehavior.php
  9BaseData/Model/Behavior/LayoutBehavior.php
  10BaseData/Model/Behavior/ListBehavior.php
  BaseTree(array)
  Model(array)
  0BaseTree/Model/BaseTreeAppModel.php
  Contents(array)
  Component(array)
  0Contents/Controller/Component/EyepinApiComponent.php
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.php
  Countries(array)
  Model(array)
  0Countries/Model/Country.php
  1Countries/Model/CountriesAppModel.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  FrontendRegions(array)
  Config(array)
  0FrontendRegions/Config/bootstrap.php
  Controller(array)
  0FrontendRegions/Controller/FrontendRegionsController.php
  1FrontendRegions/Controller/FrontendRegionsAppController.php
  FrontendUploads(array)
  Config(array)
  0FrontendUploads/Config/routes.php
  FrontendUtils(array)
  Config(array)
  0FrontendUtils/Config/bootstrap.php
  1FrontendUtils/Config/routes.php
  Plugin(array)
  0FrontendUtils/Vendor/ReCaptcha/src/autoload.php
  Component(array)
  0FrontendUtils/Controller/Component/GoogleAnalyticsComponent.php
  1FrontendUtils/Controller/Component/RecaptchaComponent.php
  HeaderImages(array)
  Behavior(array)
  0HeaderImages/Model/Behavior/HeaderImageBehavior.php
  Model(array)
  0HeaderImages/Model/HeaderImage.php
  1HeaderImages/Model/HeaderImagesAppModel.php
  Languages(array)
  Behavior(array)
  0Languages/Model/Behavior/LanguageBehavior.php
  Model(array)
  0Languages/Model/Language.php
  1Languages/Model/LanguagesAppModel.php
  Maps(array)
  Behavior(array)
  0Maps/Model/Behavior/GeoPositionBehavior.php
  Media(array)
  Behavior(array)
  0Media/Model/Behavior/MediaBehavior.php
  Model(array)
  0Media/Model/Media.php
  1Media/Model/MediaAppModel.php
  2Media/Model/MediaEntity.php
  Menus(array)
  Model(array)
  0Menus/Model/Menu.php
  1Menus/Model/MenusAppModel.php
  MountPoints(array)
  Model(array)
  0MountPoints/Model/MountPoint.php
  1MountPoints/Model/MountPointsAppModel.php
  Offers(array)
  Model(array)
  0Offers/Model/Offer.php
  1Offers/Model/OffersAppModel.php
  Outdooractive(array)
  Behavior(array)
  0Outdooractive/Model/Behavior/OAGeoBehavior.php
  Pdf(array)
  Config(array)
  0Pdf/Config/bootstrap.php
  1Pdf/Config/routes.php
  Plugin(array)
  0Pdf/Vendor/autoload.php
  1Pdf/Vendor/autoloader/exceptions/NamespaceAlreadyAddedException.php
  2Pdf/Vendor/autoloader/exceptions/DirectoryNotFoundException.php
  3Pdf/Vendor/autoloader/Autoloader.php
  Regions(array)
  Model(array)
  0Regions/Model/Region.php
  1Regions/Model/RegionsAppModel.php
  Routes(array)
  Model(array)
  0Routes/Model/Route.php
  1Routes/Model/RoutesAppModel.php
  2Routes/Model/Redirect.php
  Behavior(array)
  0Routes/Model/Behavior/RedirectBehavior.php
  1Routes/Model/Behavior/RoutableBehavior.php
  Seo(array)
  Behavior(array)
  0Seo/Model/Behavior/SeoBehavior.php
  Model(array)
  0Seo/Model/Seo.php
  1Seo/Model/SeoAppModel.php
  Settings(array)
  Component(array)
  0Settings/Controller/Component/SettingsComponent.php
  Model(array)
  0Settings/Model/Setting.php
  1Settings/Model/SettingsAppModel.php
  States(array)
  Model(array)
  0States/Model/State.php
  1States/Model/StatesAppModel.php
  Stations(array)
  Model(array)
  0Stations/Model/Station.php
  1Stations/Model/StationsAppModel.php
  Tags(array)
  Behavior(array)
  0Tags/Model/Behavior/TaggableBehavior.php
  Teasers(array)
  Behavior(array)
  0Teasers/Model/Behavior/TeaserBehavior.php
  Model(array)
  0Teasers/Model/Teaser.php
  1Teasers/Model/TeasersAppModel.php
  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
====

Ferienwohnung Strandapartment Deich-Lounge

E-BIKE VERMIETUNG & STRANDAPARTMENT in ZINGST in TOP-LAGE – nur 50m zum Ostseestrand

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 28 ms Total Queries: 215 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 28 ms
Total Queries: 215 queries