E-Bike Reiseangebote & Urlaubsangebote

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

Cake Params
- pluginFrontendMenus
- controllerFrontendMenus
- actioncontent
- named(empty)
- pass(array)
  05
- ids(array)
  Menu5
  Content(null)
  Language1
- route(array)
  id6
  hashdc59ae2dab34608d05fdbfad122ee6f4
  created2016-04-21 10:54:59
  updated2018-10-23 15:29:09
  modelMenu
  foreign_key5
  base/e-bike-urlaub/
  aliasreiseangebote
  controllerFrontendMenus.FrontendMenus
  actioncontent
  parent_id2
  lft7
  rght10
  route/e-bike-urlaub/reiseangebote
- isAjax(false)
Post data
- qtyperegion
- qregion186
- qcountry11
Query string
- qtyperegion
- qregion186
- qcountry11
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: 52 ms
Total Queries: 206 queries

Query	Affected	Num. rows	Took (ms)	Actions
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 `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 `Content`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' AND `Content`.`menu_id` = (5) ORDER BY `Content`.`position` asc	1	1	1
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `ebh_2020`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 26 AND `Route`.`model` = 'Content'	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` = '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` < 36 ORDER BY `Menu`.`lft` asc	17	17	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` = (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` = (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` = (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` > 37 AND `Menu`.`rght` < 44 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	11	11	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` = 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	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` = 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` = 185 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` = 391 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` = (965) 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` = 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` = 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` > 48 AND `Menu`.`rght` < 59 ORDER BY `Menu`.`lft` asc	5	5	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` > 60 AND `Menu`.`rght` < 65 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	1	maybe slow
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` = 'Menu' AND `Seo`.`foreign_key` = 5 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` FROM `ebh_2020`.`menus` AS `Menu` WHERE `Menu`.`id` = 5 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` <= 6 AND `Menu`.`rght` >= 7 ORDER BY `Menu`.`lft` asc	2	2	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` = 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 * 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	1
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` = 'de' LIMIT 1	1	1	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 `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`.`routes` AS `Route` WHERE `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) = '/e-bike-urlaub/reiseangebote/ergebnis' LIMIT 1	1	1	0
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `ebh_2020`.`routes` AS `Route` WHERE `Route`.`lft` <= 8 AND `Route`.`rght` >= 9 ORDER BY `Route`.`lft` asc	4	4	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`, (1=1) AS `Content__isActive`, `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`.`contents` AS `Content` LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Content`.`id` AND `Seo`.`model` = 'Content') WHERE (1=1) = '1' AND `Content`.`id` = 26 AND (NOW() BETWEEN COALESCE(`Content`.`release`, NOW()) AND COALESCE(`Content`.`hide`, NOW())) = '1' 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 `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`, `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`, `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` FROM `ebh_2020`.`regions` AS `Region` LEFT JOIN `ebh_2020`.`countries` AS `Country` ON (`Region`.`country_id` = `Country`.`id`) LEFT JOIN `ebh_2020`.`states` AS `State` ON (`Region`.`state_id` = `State`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Region`.`id` AND `Route`.`model` = 'Region') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Region`.`id` AND `Seo`.`model` = 'Region') WHERE `Region`.`id` = 186 LIMIT 1	1	1	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` = 6677 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `ebh_2020`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Region' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` = (186) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	2	2	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 `HeaderImage`.`model` = 'Region' AND `HeaderImage`.`foreign_key` = (186)	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 (12307, 12308, 12309, 12310, 12311, 12312) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' 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` = 186 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Region' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	9	9	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 (1808, 1801, 1802, 1803, 1804, 1805, 1806, 1807, 1800) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	66	66	1
SELECT `Offer`.`id`, `Offer`.`hash`, `Offer`.`created`, `Offer`.`updated`, `Offer`.`title`, `Offer`.`status`, `Offer`.`station_id`, `Offer`.`state_id`, `Offer`.`valid_from`, `Offer`.`expiration_date`, `Offer`.`price`, `Offer`.`book_url`, `Offer`.`release`, `Offer`.`hide`, `Offer`.`geopoint_long`, `Offer`.`geopoint_lat`, `Offer`.`nights`, `Offer`.`region_id`, `Offer`.`city`, `Offer`.`zip`, `Offer`.`country`, `Offer`.`street`, `Offer`.`description`, (CONCAT_WS (';',`Offer`.`geopoint_lat`,`Offer`.`geopoint_long`)) AS `Offer__geopoint`, (NOW() BETWEEN COALESCE(`Offer`.`release`, NOW()) AND COALESCE(`Offer`.`hide`, NOW())) AS `Offer__published`, `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`, `State`.`status`, `State`.`country_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `ebh_2020`.`offers` AS `Offer` LEFT JOIN `ebh_2020`.`stations` AS `Station` ON (`Offer`.`station_id` = `Station`.`id`) LEFT JOIN `ebh_2020`.`states` AS `State` ON (`Offer`.`state_id` = `State`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Offer`.`id` AND `Route`.`model` = 'Offer') JOIN `ebh_2020`.`regions` AS `QRegion` ON (`QRegion`.`id` = '186' AND `Offer`.`region_id` = `QRegion`.`id`) WHERE `Offer`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Offer`.`release`, NOW()) AND COALESCE(`Offer`.`hide`, NOW())) = '1' ORDER BY RAND('d74f9ca619861ffab6383f91d3064c16') ASC LIMIT 15	0	0	1	maybe slow
SELECT `Offer`.`id`, `Offer`.`hash`, `Offer`.`created`, `Offer`.`updated`, `Offer`.`title`, `Offer`.`status`, `Offer`.`station_id`, `Offer`.`state_id`, `Offer`.`valid_from`, `Offer`.`expiration_date`, `Offer`.`price`, `Offer`.`book_url`, `Offer`.`release`, `Offer`.`hide`, `Offer`.`geopoint_long`, `Offer`.`geopoint_lat`, `Offer`.`nights`, `Offer`.`region_id`, `Offer`.`city`, `Offer`.`zip`, `Offer`.`country`, `Offer`.`street`, `Offer`.`description`, (CONCAT_WS (';',`Offer`.`geopoint_lat`,`Offer`.`geopoint_long`)) AS `Offer__geopoint`, (NOW() BETWEEN COALESCE(`Offer`.`release`, NOW()) AND COALESCE(`Offer`.`hide`, NOW())) AS `Offer__published`, `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`, `State`.`status`, `State`.`country_id`, `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`, `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`.`offers` AS `Offer` LEFT JOIN `ebh_2020`.`stations` AS `Station` ON (`Offer`.`station_id` = `Station`.`id`) LEFT JOIN `ebh_2020`.`states` AS `State` ON (`Offer`.`state_id` = `State`.`id`) LEFT JOIN `ebh_2020`.`regions` AS `Region` ON (`Offer`.`region_id` = `Region`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Offer`.`id` AND `Route`.`model` = 'Offer') JOIN `ebh_2020`.`regions` AS `QRegion` ON (`QRegion`.`id` = '186' AND `Offer`.`region_id` = `QRegion`.`id`) WHERE `Offer`.`status` = 'active' AND (NOW() BETWEEN COALESCE(`Offer`.`release`, NOW()) AND COALESCE(`Offer`.`hide`, NOW())) = '1'	0	0	1	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` = '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` = 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 `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`, (1=1) 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` = 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 `Country`.`id`, `Country`.`title` FROM `ebh_2020`.`countries` AS `Country` WHERE 1 = 1	38	38	0
SELECT `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`, `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`, `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` FROM `ebh_2020`.`regions` AS `Region` LEFT JOIN `ebh_2020`.`countries` AS `Country` ON (`Region`.`country_id` = `Country`.`id`) LEFT JOIN `ebh_2020`.`states` AS `State` ON (`Region`.`state_id` = `State`.`id`) LEFT JOIN `ebh_2020`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Region`.`id` AND `Route`.`model` = 'Region') LEFT JOIN `ebh_2020`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Region`.`id` AND `Seo`.`model` = 'Region') WHERE `Region`.`status` = 'active' ORDER BY `Region`.`title` asc	13	13	19	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` = 6666 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` = 6668 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` = 5644 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` = 6671 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` = 6674 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` = 6678 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` = 6667 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` = 6669 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` = 6676 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` = 6673 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` = 6670 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` = 6675 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC	0	0	0
SELECT `LogoUpload`.`id`, `LogoUpload`.`hash`, `LogoUpload`.`created`, `LogoUpload`.`updated`, `LogoUpload`.`model`, `LogoUpload`.`field`, `LogoUpload`.`foreign_key`, `LogoUpload`.`alias`, `LogoUpload`.`thumbnail`, `LogoUpload`.`parent_id`, `LogoUpload`.`file`, `LogoUpload`.`size`, `LogoUpload`.`ext`, `LogoUpload`.`mime`, `LogoUpload`.`width`, `LogoUpload`.`height` FROM `ebh_2020`.`uploads` AS `LogoUpload` WHERE `LogoUpload`.`model` = 'Region' AND `LogoUpload`.`field` = 'logo' AND `LogoUpload`.`foreign_key` IN (77, 100, 186, 76, 128, 144, 119, 98, 106, 185, 82, 121, 176) ORDER BY FIELD(COALESCE(`LogoUpload`.`thumbnail`, -1), -1) DESC	24	24	1
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` = 'Region' AND `HeaderImage`.`foreign_key` IN (77, 100, 186, 76, 128, 144, 119, 98, 106, 185, 82, 121, 176)	78	78	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 (7369, 7370, 7371, 7372, 7373, 7374, 12241, 12242, 12243, 12244, 12245, 12246, 12247, 12248, 12249, 12250, 12251, 12252, 12253, 12254, 12255, 12256, 12257, 12258, 12259, 12260, 12261, 12262, 12263, 12264, 12265, 12266, 12267, 12268, 12269, 12270, 12271, 12272, 12273, 12274, 12275, 12276, 12283, 12284, 12285, 12286, 12287, 12288, 12289, 12290, 12291, 12292, 12293, 12294, 12295, 12296, 12297, 12298, 12299, 12300, 12301, 12302, 12303, 12304, 12305, 12306, 12307, 12308, 12309, 12310, 12311, 12312, 12313, 12314, 12315, 12316, 12317, 12318) AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'HeaderImage' AND `MediaEntity`.`field` = 'image' 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` IN (77, 100, 186, 76, 128, 144, 119, 98, 106, 185, 82, 121, 176) AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'Region' AND `MediaEntity`.`field` = 'gallery' ORDER BY `MediaEntity`.`pos` ASC	101	101	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 (176, 574, 171, 130, 474, 1235, 295, 207, 122, 1770, 1390, 1781, 1808, 175, 575, 170, 138, 254, 1236, 294, 203, 123, 1505, 1386, 1782, 1801, 177, 576, 172, 126, 255, 1237, 204, 22, 1502, 1387, 1783, 1802, 178, 577, 174, 127, 475, 1238, 205, 725, 1504, 1388, 1784, 1803, 179, 578, 128, 1239, 206, 728, 1769, 1389, 1785, 1804, 129, 1240, 209, 729, 1771, 1385, 1786, 1805, 131, 1241, 210, 730, 1499, 1806, 132, 211, 731, 1500, 1807, 134, 212, 732, 1503, 1800, 136, 213, 733, 139, 142, 146, 1726, 147, 1728, 149, 151, 158, 154, 160, 1729, 1730, 1731) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC	733	733	7
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 * 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	1	maybe slow
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 `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`, (1=1) 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	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` = 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	8	8	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`	58	58	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	1	maybe slow
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`, (1=1) 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	1
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	1
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`, (1=1) 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 35.64 MB

Message	Memory use
Component initialization	1.63 MB
Controller action start	2.91 MB
Controller render start	11.80 MB
Component initialization #2	13.10 MB
Controller action start #2	13.13 MB
Controller render start #2	12.80 MB
View render complete	15.39 MB

Timers

Total Request Time: 668 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	41.31
Event: Controller.initialize	20.76
Event: Controller.startup	0.39
Controller action	3.68
Event: Controller.beforeRender	146.93
» Processing toolbar data	110.08
Rendering View	302.75
» Event: View.beforeRender	0.03
» Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/content.php	173.09
» Rendering APP/Plugin/FrontendMenus/View/Elements/requestContent.php	173.09
» » » Event: Controller.initialize #2	0.41
» » » Event: Controller.startup #2	0.12
» » » Controller action #2	22.96
» » » Event: Controller.beforeRender #2	67.97
» » » » Processing toolbar data #2	67.85
Rendering View #2	0.00
» » » » Event: View.beforeRender #2	0.03
» » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/search_offers.php	76.13
» » Rendering APP/View/Elements/search/content.php #2	76.02
» » » » » » Rendering APP/View/Elements/search/form/start.php	7.15
» » » » » » Rendering APP/View/Elements/search/inputs/region.php	0.71
» » » » » » Rendering APP/View/Elements/search/additional_inputs/offers.php	1.27
» » » » » » Rendering APP/View/Elements/search/form/submit.php	0.30
» » » » » » Rendering APP/View/Elements/search/form/end.php	0.25
» » » » Rendering APP/Plugin/FrontendContents/View/FrontendContents/base.php	0.27
» » » » Event: View.afterRender	0.04
» » » » Event: Controller.shutdown	0.02
» » Rendering APP/Plugin/FrontendMenus/View/FrontendMenus/base.php #2	0.22
» » Event: View.afterRender #2	0.05
» » Event: View.beforeLayout	0.02
» » Rendering APP/View/Layouts/index.php	127.44
» » » Rendering APP/Plugin/FrontendSeo/View/Elements/seo.php	1.21
» » » Rendering APP/View/Elements/svg/logo.php	0.21
» » » Rendering APP/View/Elements/svg/close.php	0.25
» » » Rendering APP/View/Elements/mainNav.php	80.15
» » » » Rendering APP/View/Elements/search/navigation.php	24.62
» » » » » Rendering APP/View/Elements/search/form/start.php #2	9.75
» » » » » Rendering APP/View/Elements/search/inputs/country_state.php	0.90
» » » » » Rendering APP/View/Elements/search/form/submit.php #2	0.26
» » » » » Rendering APP/View/Elements/search/form/end.php #2	0.20
» » » » » Rendering APP/View/Elements/search/form/start.php #3	3.76
» » » » » Rendering APP/View/Elements/search/inputs/radius.php	0.44
» » » » » Rendering APP/View/Elements/search/form/submit.php #3	0.25
» » » » » Rendering APP/View/Elements/search/form/end.php #3	0.19
» » » » » Rendering APP/View/Elements/search/form/start.php #4	3.52
» » » » » Rendering APP/View/Elements/search/inputs/name.php	0.27
» » » » » Rendering APP/View/Elements/search/form/submit.php #4	0.24
» » » » » Rendering APP/View/Elements/search/form/end.php #4	0.27
» » » » Rendering APP/View/Elements/search/navigation.php #2	22.82
» » » » » Rendering APP/View/Elements/search/form/start.php #5	8.40
» » » » » Rendering APP/View/Elements/search/inputs/country_state.php #2	0.75
» » » » » Rendering APP/View/Elements/search/form/submit.php #5	0.29
» » » » » Rendering APP/View/Elements/search/form/end.php #5	0.19
» » » » » Rendering APP/View/Elements/search/form/start.php #6	3.72
» » » » » Rendering APP/View/Elements/search/inputs/radius.php #2	0.45
» » » » » Rendering APP/View/Elements/search/form/submit.php #6	0.25
» » » » » Rendering APP/View/Elements/search/form/end.php #6	0.22
» » » » » Rendering APP/View/Elements/search/form/start.php #7	3.55
» » » » » Rendering APP/View/Elements/search/inputs/name.php #2	0.27
» » » » » Rendering APP/View/Elements/search/form/submit.php #7	0.27
» » » » » Rendering APP/View/Elements/search/form/end.php #7	0.19
» » » » Rendering APP/View/Elements/search/navigation.php #3	19.75
» » » » » Rendering APP/View/Elements/search/form/start.php #8	3.55
» » » » » Rendering APP/View/Elements/search/inputs/country_state.php #3	0.40
» » » » » Rendering APP/View/Elements/search/form/submit.php #8	0.26
» » » » » Rendering APP/View/Elements/search/form/end.php #8	0.20
» » » » » Rendering APP/View/Elements/search/form/start.php #9	3.67
» » » » » Rendering APP/View/Elements/search/inputs/radius.php #3	0.43
» » » » » Rendering APP/View/Elements/search/form/submit.php #9	0.25
» » » » » Rendering APP/View/Elements/search/form/end.php #9	0.23
» » » » » Rendering APP/View/Elements/search/form/start.php #10	4.71
» » » » » Rendering APP/View/Elements/search/inputs/name.php #3	0.27
» » » » » Rendering APP/View/Elements/search/form/submit.php #10	0.28
» » » » » Rendering APP/View/Elements/search/form/end.php #10	0.19
» » » » Rendering APP/View/Elements/search/navigation.php #4	11.52
» » » » » Rendering APP/View/Elements/search/form/start.php #11	9.31
» » » » » Rendering APP/View/Elements/search/inputs/name.php #4	0.40
» » » » » Rendering APP/View/Elements/search/form/submit.php #11	0.28
» » » » » Rendering APP/View/Elements/search/form/end.php #11	0.20
» » » Rendering APP/Plugin/FrontendHeaderImages/View/Elements/headerImage.php	37.38
» » » » Rendering APP/View/Elements/search/form/start.php #12	4.01
» » » » Rendering APP/View/Elements/search/inputs/country_state.php #4	0.96
» » » » Rendering APP/View/Elements/search/form/submit.php #12	0.33
» » » » Rendering APP/View/Elements/search/form/end.php #12	0.21
» » » » Rendering APP/View/Elements/search/form/start.php #13	3.77
» » » » Rendering APP/View/Elements/search/inputs/radius.php #4	0.45
» » » » Rendering APP/View/Elements/search/form/submit.php #13	0.26
» » » » Rendering APP/View/Elements/search/form/end.php #13	0.21
» » » » Rendering APP/View/Elements/search/form/start.php #14	3.68
» » » » Rendering APP/View/Elements/search/inputs/name.php #5	0.26
» » » » Rendering APP/View/Elements/search/form/submit.php #14	0.31
» » » » Rendering APP/View/Elements/search/form/end.php #14	0.20
» » » » Rendering APP/View/Elements/search/form/start.php #15	3.68
» » » » Rendering APP/View/Elements/search/inputs/country_state.php #5	0.74
» » » » Rendering APP/View/Elements/search/form/submit.php #15	0.27
» » » » Rendering APP/View/Elements/search/form/end.php #15	0.20
» » » » Rendering APP/View/Elements/search/form/start.php #16	3.75
» » » » Rendering APP/View/Elements/search/inputs/radius.php #5	0.41
» » » » Rendering APP/View/Elements/search/form/submit.php #16	0.29
» » » » Rendering APP/View/Elements/search/form/end.php #16	0.22
» » » » Rendering APP/View/Elements/search/form/start.php #17	3.72
» » » » Rendering APP/View/Elements/search/inputs/name.php #6	0.27
» » » » Rendering APP/View/Elements/search/form/submit.php #17	0.30
» » » » Rendering APP/View/Elements/search/form/end.php #17	0.20
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- row(array)
  Menu(array)
  id5
  hash3d4847d693dbca7529c120704cff2acd
  created2016-04-21 10:54:59
  updated2018-10-23 15:29:09
  parent_id1
  lft6
  rght7
  language_id1
  typecontent
  titleReiseangebote
  previous_urlhttp://www.movelo.com/e-bike/urlaubsangebote
  url(null)
  target_blank(false)
  icon_font_code
  Seo(array)
  id43
  hashaf5c6b92187af4c7bb3c083ba51af69e
  created2016-06-13 17:01:50
  updated2018-10-23 15:29:10
  modelMenu
  foreign_key5
  titleE-Bike Reiseangebote & Urlaubsangebote | EBIKE HOLIDAY
  descriptionBuchen Sie Ihre ebike holiday E-Bike Urlaubsreise. Wählen Sie aus einer Vielzahl an weltweiten Reiseangeboten rund um den Urlaub mit dem Elektrofahrrad.
  author
  tw_creator
  fb_author
  robots3
  ImageMedia(empty)
  Content(array)
  0(array)
  id26
  hash8adf5cd62ca38a107b6ee2940d7598f8
  created2016-06-13 09:54:42
  updated2017-03-06 22:14:27
  menu_id5
  position1
  typesearch_offers
  statusactive
  titleErgebnis
  layoutcol12
  language_id1
  article_content(null)
  contact_content(null)
  contact_email(null)
  contact_email_secondary(null)
  contact_success(null)
  contact_error(null)
  iframe_url(null)
  iframe_width(null)
  iframe_height(null)
  release(null)
  hide(null)
  gmap_lat(null)
  gmap_long(null)
  gmap_zoom(null)
  gmap_type(null)
  gmap_marker(null)
  video_type(null)
  video_url(null)
  developer_template_code(null)
  developer_template_css(null)
  developer_template_js(null)
  teaser_menu_id(null)
  teaser_external_url(null)
  teaser_external_target(null)
  provider_type(null)
  deadline(null)
  competition_answer(null)
  member_group_id0
  contact_options0
  gmap
  published1
  isActive1
  Route(array)
  id8505
  hash1f41d97219f8b6f7733012397c6f40fc
  created2016-06-13 09:54:42
  updated2017-03-06 22:14:27
  modelContent
  foreign_key26
  base/e-bike-urlaub/reiseangebote/
  aliasergebnis
  controllerFrontendContents.FrontendContents
  actionsearch_offers
  parent_id6
  lft8
  rght9
  route/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)
  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
  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)
  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)
  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)
  MediaEntity(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)
  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
  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
  stationsStation
  statesState
  routesRoute
  media_entitiesMediaEntity
  regionsRegion
  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)
  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) - recursion
  FileUpload(object) - recursion
  Seo(object) - recursion
  Teaser(object) - recursion
  HeaderImage(object) - recursion
  Station(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
  displayFieldtitle
  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)
  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
  countriesCountry
  statesState
  uploadsLogoUpload
  routesRoute
  media_entitiesMediaEntity
  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) - recursion
  Seo(object) - recursion
  HeaderImage(object) - recursion
  Station(object) - recursion
  Country(object) - recursion
  State(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)
  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
  MediaEntity(object) - recursion
  State(object) - recursion
  Route(object) - recursion
  MediaEntity(object) - recursion
  Region(object) - recursion
  Route(object) - recursion
- $request->data(array)
  qtyperegion
  qregion186
  qcountry11
- $this->validationErrors(array)
  Route(empty)
  MountPoint(empty)
  Redirect(empty)
  Language(empty)
  Menu(empty)
  Parent(empty)
  HeaderImagesMedia(empty)
  MediaEntity(empty)
  Seo(empty)
  ImageMedia(empty)
  HeaderImage(empty)
  Teaser(empty)
  Content(empty)
  ArticleContentMedia(empty)
  GalleryMedia(empty)
  BannerLogoMedia(empty)
  Station(empty)
  Offer(empty)
  Setting(empty)
  ValueUpload(empty)
  FileUpload(empty)
  HeaderVideoUpload(empty)
  FlagUpload(empty)
  Banner(empty)
- Loaded Helpers(array)
  0Html
  1Tree
  2Upload
  3Media
  4Route
  5Bs3Html
  6Form
  7SocialMedia
  8GMap
  9OAJs
  10OA
  11Embed
  12Layout
  13ThirdPartyCookies
  14BitMask
  15Number
  16SimpleGraph
  17DebugTimer
  18Toolbar
  19Session
  20Js
  21HtmlToolbar
====

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.34
User	u34892347892
Home	/var/www/vhosts/ebike-holiday.com
Script Name	/webroot/index.php
Request Uri	/e-bike-urlaub/reiseangebote?qtype=region&qregion=186&qcountry=11
Query String	qtype=region&qregion=186&qcountry=11
Request Method	GET
Server Protocol	HTTP/1.0
Gateway Interface	CGI/1.1
Redirect Query String	qtype=region&qregion=186&qcountry=11
Redirect Url	/webroot/e-bike-urlaub/reiseangebote
Remote Port	57130
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.239.3.196
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 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.239.3.196
Http Host	www.ebike-holiday.com
Proxy-nokeepalive	1
Https	on
Passenger Download Native Support Binary	0
Passenger Compile Native Support Binary	0
Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Unique Id	ZwYyv49yuthMWiSF32cqiAAAAEc
Redirect Status	200
Redirect Https	on
Redirect Passenger Download Native Support Binary	0
Redirect Passenger Compile Native Support Binary	0
Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Unique Id	ZwYyv49yuthMWiSF32cqiAAAAEc
Redirect Redirect Status	200
Redirect Redirect Https	on
Redirect Redirect Passenger Download Native Support Binary	0
Redirect Redirect Passenger Compile Native Support Binary	0
Redirect Redirect Perl5lib	/usr/share/awstats/lib:/usr/share/awstats/plugins
Redirect Redirect Unique Id	ZwYyv49yuthMWiSF32cqiAAAAEc
Fcgi Role	RESPONDER
Php Self	/webroot/index.php
Request Time Float	1728459455.9084
Request Time	1728459455

====

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
  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)
  Model(array)
  0Contents/Model/Content.php
  1Contents/Model/ContentsAppModel.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
  FrontendMenus(array)
  Controller(array)
  0FrontendMenus/Controller/FrontendMenusController.php
  1FrontendMenus/Controller/FrontendMenusAppController.php
  FrontendRegions(array)
  Config(array)
  0FrontendRegions/Config/bootstrap.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
  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
  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
  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
====

E-Bike Reiseangebote nach Land und Region

Es wurden keine Ergebnisse gefunden.

Cookie Einstellungen

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 52 ms Total Queries: 206 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 52 ms
Total Queries: 206 queries