Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`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`))) = '/de/gourmet-und-genuss' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Route`.`model`, `Route`.`foreign_key` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`lft` <= 1152 AND `Route`.`rght` >= 1153 ORDER BY `Route`.`lft` asc | 2 | 2 | 0 | |
SELECT `Language`.`langid` FROM `deutsche_alpenstr2019`.`languages` AS `Language` WHERE `Language`.`id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT *, (GROUP_CONCAT(`Parent`.`key` ORDER BY `Parent`.`lft` ASC SEPARATOR '.')) AS `Setting__path`, `Setting`.`id` FROM `deutsche_alpenstr2019`.`settings` AS `Setting` LEFT JOIN `deutsche_alpenstr2019`.`settings` AS `Parent` ON (`Parent`.`lft` <= `Setting`.`lft` AND `Parent`.`rght` >= `Setting`.`rght`) WHERE 1 = 1 GROUP BY `Setting`.`id` | 24 | 24 | 0 | |
SELECT `ValueUpload`.`id`, `ValueUpload`.`hash`, `ValueUpload`.`created`, `ValueUpload`.`updated`, `ValueUpload`.`model`, `ValueUpload`.`field`, `ValueUpload`.`foreign_key`, `ValueUpload`.`alias`, `ValueUpload`.`thumbnail`, `ValueUpload`.`parent_id`, `ValueUpload`.`file`, `ValueUpload`.`size`, `ValueUpload`.`ext`, `ValueUpload`.`mime`, `ValueUpload`.`width`, `ValueUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `ValueUpload` WHERE `ValueUpload`.`model` = 'Setting' AND `ValueUpload`.`field` = 'value' AND `ValueUpload`.`foreign_key` IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 14, 15, 16, 17, 18, 20, 21, 22, 26, 27, 28, 29) ORDER BY FIELD(COALESCE(`ValueUpload`.`thumbnail`, -1), -1) DESC | 0 | 0 | 0 | |
SELECT `TravelIdeaI18n`.`id`, `TravelIdeaI18n`.`hash`, `TravelIdeaI18n`.`created`, `TravelIdeaI18n`.`updated`, `TravelIdeaI18n`.`language_id`, `TravelIdeaI18n`.`travel_idea_id`, `TravelIdeaI18n`.`title`, `TravelIdeaI18n`.`article_content`, `TravelIdea`.`id`, `TravelIdea`.`hash`, `TravelIdea`.`created`, `TravelIdea`.`updated`, `TravelIdea`.`status`, `TravelIdea`.`title`, `TravelIdea`.`duration`, `TravelIdea`.`overnight_stays`, `TravelIdea`.`distance`, `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`, `Seo`.`internal_keywords` FROM `deutsche_alpenstr2019`.`travel_idea_i18n` AS `TravelIdeaI18n` LEFT JOIN `deutsche_alpenstr2019`.`travel_ideas` AS `TravelIdea` ON (`TravelIdeaI18n`.`travel_idea_id` = `TravelIdea`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`TravelIdeaI18n`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `TravelIdeaI18n`.`id` AND `Route`.`model` = 'TravelIdeaI18n') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `TravelIdeaI18n`.`id` AND `Seo`.`model` = 'TravelIdeaI18n') WHERE `TravelIdeaI18n`.`id` = 7 LIMIT 1 | 1 | 1 | 0 | |
SELECT `TravelExperience`.`id`, `TravelExperience`.`hash`, `TravelExperience`.`created`, `TravelExperience`.`updated`, `TravelExperience`.`status`, `TravelExperience`.`title`, `TravelExperience`.`point_id`, `TravelExperience`.`travel_idea_id` FROM `deutsche_alpenstr2019`.`travel_experiences` AS `TravelExperience` WHERE `TravelExperience`.`travel_idea_id` = (7) | 3 | 3 | 0 | |
SELECT `TravelExperienceI18n`.`id`, `TravelExperienceI18n`.`hash`, `TravelExperienceI18n`.`created`, `TravelExperienceI18n`.`updated`, `TravelExperienceI18n`.`language_id`, `TravelExperienceI18n`.`travel_experience_id`, `TravelExperienceI18n`.`title`, `TravelExperienceI18n`.`article_content` FROM `deutsche_alpenstr2019`.`travel_experience_i18n` AS `TravelExperienceI18n` WHERE `language_id` = '1' AND `TravelExperienceI18n`.`travel_experience_id` IN (15, 16, 17) | 0 | 0 | 0 | |
SELECT `TravelBooking`.`id`, `TravelBooking`.`hash`, `TravelBooking`.`created`, `TravelBooking`.`updated`, `TravelBooking`.`status`, `TravelBooking`.`travel_idea_id`, `TravelBooking`.`day_from`, `TravelBooking`.`day_to`, `TravelBooking`.`point_id_city`, `TravelBooking`.`point_id_hotel`, `TravelBooking`.`article`, `TravelBooking`.`title`, `TravelBooking`.`point` FROM `deutsche_alpenstr2019`.`travel_bookings` AS `TravelBooking` WHERE `TravelBooking`.`travel_idea_id` = (7) | 3 | 3 | 0 | |
SELECT `GalleryMedia`.`id`, `GalleryMedia`.`hash`, `GalleryMedia`.`created`, `GalleryMedia`.`updated`, `GalleryMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `GalleryMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `GalleryMedia`.`id`) WHERE `MediaEntity`.`model` = 'TravelIdea' AND `MediaEntity`.`field` = 'gallery' 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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (584, 588, 586, 589) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 28 | 28 | 0 | |
SELECT `CardMedia`.`id`, `CardMedia`.`hash`, `CardMedia`.`created`, `CardMedia`.`updated`, `CardMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `CardMedia`.`id`) AS `CardMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `CardMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 7 AND `MediaEntity`.`media_id` = `CardMedia`.`id`) WHERE `MediaEntity`.`model` = 'TravelIdea' AND `MediaEntity`.`field` = 'card' 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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (590) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 7 | 7 | 0 | |
SELECT `PointsTravelIdeas`.`id`, `PointsTravelIdeas`.`hash`, `PointsTravelIdeas`.`created`, `PointsTravelIdeas`.`updated`, `PointsTravelIdeas`.`status`, `PointsTravelIdeas`.`title`, `PointsTravelIdeas`.`content_type`, `PointsTravelIdeas`.`category`, `PointsTravelIdeas`.`teaser_title`, `PointsTravelIdeas`.`top_tip`, `PointsTravelIdeas`.`map_lat`, `PointsTravelIdeas`.`map_long`, `PointsTravelIdeas`.`street`, `PointsTravelIdeas`.`zip_code`, `PointsTravelIdeas`.`city`, `PointsTravelIdeas`.`phone`, `PointsTravelIdeas`.`website_url`, `PointsTravelIdeas`.`email`, `PointsTravelIdeas`.`region1`, `PointsTravelIdeas`.`region2`, `PointsTravelIdeas`.`region3`, `PointsTravelIdeas`.`booking_link`, `PointsTravelIdeas`.`gmap_url`, `PointsTravelIdeas`.`external_id`, `PointsTravelIdeas`.`gmap_zoom`, `PointsTravelIdeas`.`fax`, `PointsTravelIdeas`.`weather_widget_code`, `PointsTravelIdeas`.`hotels_gastronomy`, `PointsTravelIdeas`.`hotels_wellness`, `PointsTravelIdeas`.`hotels_parking`, `PointsTravelIdeas`.`hotels_car_rental`, `PointsTravelIdeas`.`hotels_oldtimer`, `PointsTravelIdeas`.`hotels_transfer`, `PointsTravelIdeas`.`hotels_car_charging_possibility`, `PointsTravelIdeas`.`hotels_distance_to_nearest_train_station`, `PointsTravelIdeas`.`hotels_bike_rental`, `PointsTravelIdeas`.`hotels_car_rental_other_de`, `PointsTravelIdeas`.`hotels_car_rental_other_it`, `PointsTravelIdeas`.`hotels_car_rental_other_nl`, `PointsTravelIdeas`.`hotels_car_rental_other_en`, `PointsTravelIdeas`.`hotels_emobil`, (CONCAT_WS (';',`PointsTravelIdeas`.`map_lat`,`PointsTravelIdeas`.`map_long`)) AS `PointsTravelIdeas__map`, `PointsTravelIdea`.`id`, `PointsTravelIdea`.`travel_idea_id`, `PointsTravelIdea`.`point_id`, `PointsTravelIdea`.`position` FROM `deutsche_alpenstr2019`.`points` AS `PointsTravelIdeas` JOIN `deutsche_alpenstr2019`.`points_travel_ideas` AS `PointsTravelIdea` ON (`PointsTravelIdea`.`travel_idea_id` = 7 AND `PointsTravelIdea`.`point_id` = `PointsTravelIdeas`.`id`) ORDER BY `PointsTravelIdea`.`position` ASC | 3 | 3 | 0 | |
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` WHERE `language_id` = '1' AND `PointI18n`.`point_id` IN (17, 60, 25) | 3 | 3 | 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 `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 17 AND `Route`.`model` = 'PointI18n' | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 25 AND `Route`.`model` = 'PointI18n' | 1 | 1 | 0 | |
SELECT `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`routes` AS `Route` WHERE `Route`.`foreign_key` = 60 AND `Route`.`model` = 'PointI18n' | 1 | 1 | 0 | |
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` IN (17, 60, 25) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC | 6 | 6 | 0 | |
SELECT `PdfUpload`.`id`, `PdfUpload`.`hash`, `PdfUpload`.`created`, `PdfUpload`.`updated`, `PdfUpload`.`model`, `PdfUpload`.`field`, `PdfUpload`.`foreign_key`, `PdfUpload`.`alias`, `PdfUpload`.`thumbnail`, `PdfUpload`.`parent_id`, `PdfUpload`.`file`, `PdfUpload`.`size`, `PdfUpload`.`ext`, `PdfUpload`.`mime`, `PdfUpload`.`width`, `PdfUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `PdfUpload` WHERE `PdfUpload`.`model` = 'TravelIdeaI18n' AND `PdfUpload`.`field` = 'pdf' AND `PdfUpload`.`foreign_key` = (7) ORDER BY FIELD(COALESCE(`PdfUpload`.`thumbnail`, -1), -1) DESC | 1 | 1 | 0 | |
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 115 AND `language_id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (115) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 0 | |
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 150 AND `language_id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (150) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 0 | |
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 88 AND `language_id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (88) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 0 | |
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 123 AND `language_id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (123) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 0 | |
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 90 AND `language_id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (90) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 0 | |
SELECT `PointI18n`.`id`, `PointI18n`.`hash`, `PointI18n`.`created`, `PointI18n`.`updated`, `PointI18n`.`language_id`, `PointI18n`.`point_id`, `PointI18n`.`country`, `PointI18n`.`introduction_text`, `PointI18n`.`detail_text`, `PointI18n`.`teaser_text`, `PointI18n`.`image_title_1`, `PointI18n`.`image_title_2`, `PointI18n`.`image_title_3`, `PointI18n`.`image_title_4`, `PointI18n`.`image_title_5`, `PointI18n`.`image_title_6`, `PointI18n`.`image_title_7`, `PointI18n`.`title`, `PointI18n`.`teaser_button`, `PointI18n`.`previous_url`, `Point`.`id`, `Point`.`hash`, `Point`.`created`, `Point`.`updated`, `Point`.`status`, `Point`.`title`, `Point`.`content_type`, `Point`.`category`, `Point`.`teaser_title`, `Point`.`top_tip`, `Point`.`map_lat`, `Point`.`map_long`, `Point`.`street`, `Point`.`zip_code`, `Point`.`city`, `Point`.`phone`, `Point`.`website_url`, `Point`.`email`, `Point`.`region1`, `Point`.`region2`, `Point`.`region3`, `Point`.`booking_link`, `Point`.`gmap_url`, `Point`.`external_id`, `Point`.`gmap_zoom`, `Point`.`fax`, `Point`.`weather_widget_code`, `Point`.`hotels_gastronomy`, `Point`.`hotels_wellness`, `Point`.`hotels_parking`, `Point`.`hotels_car_rental`, `Point`.`hotels_oldtimer`, `Point`.`hotels_transfer`, `Point`.`hotels_car_charging_possibility`, `Point`.`hotels_distance_to_nearest_train_station`, `Point`.`hotels_bike_rental`, `Point`.`hotels_car_rental_other_de`, `Point`.`hotels_car_rental_other_it`, `Point`.`hotels_car_rental_other_nl`, `Point`.`hotels_car_rental_other_en`, `Point`.`hotels_emobil`, (CONCAT_WS (';',`Point`.`map_lat`,`Point`.`map_long`)) AS `Point__map`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route` FROM `deutsche_alpenstr2019`.`point_i18ns` AS `PointI18n` LEFT JOIN `deutsche_alpenstr2019`.`points` AS `Point` ON (`PointI18n`.`point_id` = `Point`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `PointI18n`.`id` AND `Route`.`model` = 'PointI18n') WHERE `point_id` = 143 AND `language_id` = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `TeaserImageUpload`.`id`, `TeaserImageUpload`.`hash`, `TeaserImageUpload`.`created`, `TeaserImageUpload`.`updated`, `TeaserImageUpload`.`model`, `TeaserImageUpload`.`field`, `TeaserImageUpload`.`foreign_key`, `TeaserImageUpload`.`alias`, `TeaserImageUpload`.`thumbnail`, `TeaserImageUpload`.`parent_id`, `TeaserImageUpload`.`file`, `TeaserImageUpload`.`size`, `TeaserImageUpload`.`ext`, `TeaserImageUpload`.`mime`, `TeaserImageUpload`.`width`, `TeaserImageUpload`.`height` FROM `deutsche_alpenstr2019`.`uploads` AS `TeaserImageUpload` WHERE `TeaserImageUpload`.`model` = 'Point' AND `TeaserImageUpload`.`field` = 'teaser_image' AND `TeaserImageUpload`.`foreign_key` = (143) ORDER BY FIELD(COALESCE(`TeaserImageUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 0 | |
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 3 AND `Menu`.`rght` < 156 ORDER BY `Menu`.`lft` asc | 76 | 76 | 0 | |
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` = (408) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 10 | 10 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`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 | 0 | 0 | 0 | |
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`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 `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'links' 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`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 158 AND `Menu`.`rght` < 177 ORDER BY `Menu`.`lft` asc | 9 | 9 | 0 | |
SELECT `Entity`.`lft`, `Entity`.`rght`, `Language`.`id` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'service' AND `Language`.`langid` = 'de' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Menu`.`id`, `Menu`.`hash`, `Menu`.`created`, `Menu`.`updated`, `Menu`.`parent_id`, `Menu`.`lft`, `Menu`.`rght`, `Menu`.`language_id`, `Menu`.`type`, `Menu`.`title`, `Menu`.`previous_url`, `Menu`.`url`, `Menu`.`target_blank`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') WHERE `Menu`.`lft` > 124 AND `Menu`.`rght` < 155 ORDER BY `Menu`.`lft` asc | 15 | 15 | 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 `deutsche_alpenstr2019`.`languages` AS `Language` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Language`.`id` AND `Route`.`model` = 'Language') WHERE 1 = 1 | 4 | 4 | 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 `deutsche_alpenstr2019`.`uploads` AS `FlagUpload` WHERE `FlagUpload`.`model` = 'Language' AND `FlagUpload`.`field` = 'flag' AND `FlagUpload`.`foreign_key` IN (1, 2, 3, 4) ORDER BY FIELD(COALESCE(`FlagUpload`.`thumbnail`, -1), -1) DESC | 8 | 8 | 0 | |
SELECT `Seo`.`id`, `Seo`.`hash`, `Seo`.`created`, `Seo`.`updated`, `Seo`.`model`, `Seo`.`foreign_key`, `Seo`.`title`, `Seo`.`description`, `Seo`.`author`, `Seo`.`tw_creator`, `Seo`.`fb_author`, `Seo`.`robots`, `Seo`.`internal_keywords` FROM `deutsche_alpenstr2019`.`seo` AS `Seo` WHERE `Seo`.`model` = 'TravelIdeaI18n' AND `Seo`.`foreign_key` = 7 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 1199 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Seo' AND `MediaEntity`.`field` = 'image' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` IS NULL LIMIT 1 | 0 | 0 | 0 | |
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'metaa' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`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 `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 2 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`lft` < NULL AND `Menu`.`rght` > NULL AND `Menu`.`parent_id` = 2 ORDER BY `Menu`.`lft` asc LIMIT 1 | 0 | 0 | 0 | |
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social_share_links' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 179 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 441 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 441 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 179 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 179 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 179 | 3 | 3 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 443 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 445 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 446 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 443 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 445 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 446 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (181, 183, 184) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (181, 183, 184) AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (285, 287, 288) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 18 | 18 | 0 | |
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'social_site_links' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 180 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 442 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 442 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 180 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 180 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 180 | 0 | 0 | 0 | |
SELECT *, Language.id FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`id` = `MountPoint`.`route_id` AND `Route`.`model` = 'Menu') JOIN `deutsche_alpenstr2019`.`menus` AS `Entity` ON (`Entity`.`id` = `Route`.`foreign_key`) WHERE `MountPoint`.`title` = 'footer_social_links' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`id` = 319 LIMIT 1 | 1 | 1 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 916 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 686 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 319 AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 319 AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' 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`, `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`, `Seo`.`internal_keywords`, `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 `deutsche_alpenstr2019`.`menus` AS `Menu` LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`Menu`.`language_id` = `Language`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`Route`.`foreign_key` = `Menu`.`id` AND `Route`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`seo` AS `Seo` ON (`Seo`.`foreign_key` = `Menu`.`id` AND `Seo`.`model` = 'Menu') LEFT JOIN `deutsche_alpenstr2019`.`teasers` AS `Teaser` ON (`Teaser`.`foreign_key` = `Menu`.`id` AND `Teaser`.`model` = 'Menu') WHERE `Menu`.`parent_id` = 319 | 2 | 2 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 917 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 918 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 `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 687 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `ImageMedia`.`id`, `ImageMedia`.`hash`, `ImageMedia`.`created`, `ImageMedia`.`updated`, `ImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `ImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` = 688 AND `MediaEntity`.`media_id` = `ImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Teaser' AND `MediaEntity`.`field` = 'image' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `HeaderImagesMedia`.`id`, `HeaderImagesMedia`.`hash`, `HeaderImagesMedia`.`created`, `HeaderImagesMedia`.`updated`, `HeaderImagesMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`media` AS `HeaderImagesMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (320, 321) AND `MediaEntity`.`media_id` = `HeaderImagesMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'header_images' ORDER BY `MediaEntity`.`pos` ASC | 0 | 0 | 0 | |
SELECT `LogoIconImageMedia`.`id`, `LogoIconImageMedia`.`hash`, `LogoIconImageMedia`.`created`, `LogoIconImageMedia`.`updated`, `LogoIconImageMedia`.`title`, (SELECT COUNT(1) FROM `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` WHERE `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) AS `LogoIconImageMedia__cross_reference_count`, `MediaEntity`.`id`, `MediaEntity`.`pos`, `MediaEntity`.`media_id`, `MediaEntity`.`model`, `MediaEntity`.`field`, `MediaEntity`.`foreign_key` FROM `deutsche_alpenstr2019`.`media` AS `LogoIconImageMedia` JOIN `deutsche_alpenstr2019`.`media_entities` AS `MediaEntity` ON (`MediaEntity`.`foreign_key` IN (320, 321) AND `MediaEntity`.`media_id` = `LogoIconImageMedia`.`id`) WHERE `MediaEntity`.`model` = 'Menu' AND `MediaEntity`.`field` = 'logo_icon_image' ORDER BY `MediaEntity`.`pos` ASC | 2 | 2 | 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 `deutsche_alpenstr2019`.`uploads` AS `FileUpload` WHERE `FileUpload`.`model` = 'Media' AND `FileUpload`.`field` = 'file' AND `FileUpload`.`foreign_key` IN (351, 352) ORDER BY FIELD(COALESCE(`FileUpload`.`thumbnail`, -1), -1) DESC | 2 | 2 | 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 `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`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 `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 `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'it' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'nl' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Route`.`id`, `Route`.`hash`, `Route`.`created`, `Route`.`updated`, `Route`.`model`, `Route`.`foreign_key`, `Route`.`base`, `Route`.`alias`, `Route`.`controller`, `Route`.`action`, `Route`.`parent_id`, `Route`.`lft`, `Route`.`rght`, (IF(`Route`.`alias` IS NULL, NULL, CONCAT(`Route`.`base`, `Route`.`alias`))) AS `Route__route`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`languages` AS `Language` ON (`MountPoint`.`language_id` = `Language`.`id`) WHERE `Language`.`langid` = 'en' AND `Route`.`alias` IS NOT NULL AND `Route`.`controller` IS NOT NULL AND `Route`.`action` IS NOT NULL AND `MountPoint`.`title` = 'home' LIMIT 1 | 1 | 1 | 0 | |
SELECT `MountPoint`.`id`, `MountPoint`.`hash`, `MountPoint`.`created`, `MountPoint`.`updated`, `MountPoint`.`title`, `MountPoint`.`annotation`, `MountPoint`.`language_id`, `MountPoint`.`route_id`, `Language`.`id`, `Language`.`hash`, `Language`.`created`, `Language`.`updated`, `Language`.`title`, `Language`.`langid`, `Language`.`default` FROM `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`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 `deutsche_alpenstr2019`.`mount_points` AS `MountPoint` LEFT JOIN `deutsche_alpenstr2019`.`routes` AS `Route` ON (`MountPoint`.`route_id` = `Route`.`id`) LEFT JOIN `deutsche_alpenstr2019`.`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 | |