Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Condition`.`id` FROM `quatres_quatres_bdx`.`conditions` AS `Condition` WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`configuration` AS `Configuration` WHERE `Configuration`.`default_configuration` = 'true' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `quatres_quatres_bdx`.`room_categories` AS `RoomCategory` WHERE `RoomCategory`.`id` = 13 | 1 | 1 | 0 | |
SELECT `RoomCategory`.`id`, `RoomCategory`.`property_id`, `RoomCategory`.`avg_dimensions`, `RoomCategory`.`type_bed`, `RoomCategory`.`max_capacity`, `RoomCategory`.`price_from`, `RoomCategory`.`currency`, `RoomCategory`.`num_rooms`, `RoomCategory`.`num_bedrooms`, `RoomCategory`.`num_bathrooms`, `RoomCategory`.`position`, `RoomCategory`.`modified`, `RoomCategory`.`is_published`, `RoomCategory`.`reservation_url`, `RoomCategory`.`telephone_reservation`, `RoomCategory`.`type_accommodation`, `RoomCategory`.`external_reservation_id`, `RoomCategory`.`created`, (`I18n__name`.`content`) AS `RoomCategory__i18n_name`, (`I18n__description`.`content`) AS `RoomCategory__i18n_description`, `Property`.`id`, `Property`.`type`, `Property`.`title`, `Property`.`min_capacity`, `Property`.`max_capacity`, `Property`.`num_bedrooms`, `Property`.`num_bathrooms`, `Property`.`dimensions`, `Property`.`image`, `Property`.`logo`, `Property`.`google_calendar_id`, `Property`.`change_over_day`, `Property`.`position`, `Property`.`is_published`, `Property`.`created`, `Property`.`modified` FROM `quatres_quatres_bdx`.`room_categories` AS `RoomCategory` LEFT JOIN `quatres_quatres_bdx`.`properties` AS `Property` ON (`RoomCategory`.`property_id` = `Property`.`id`) LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__name` ON (`RoomCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'RoomCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__description` ON (`RoomCategory`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'RoomCategory' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') WHERE `RoomCategory`.`id` = 13 ORDER BY `RoomCategory`.`position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`configuration` AS `Configuration` WHERE `Configuration`.`property_id` = 2 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Room`.`id`, `Room`.`room_category_id`, `Room`.`position`, `Room`.`is_published`, `Room`.`modified`, `Room`.`created` FROM `quatres_quatres_bdx`.`rooms` AS `Room` WHERE `Room`.`room_category_id` = (13) ORDER BY `position` ASC | 0 | 0 | 0 | |
SELECT `RoomCategoryImage`.`id`, `RoomCategoryImage`.`room_category_id`, `RoomCategoryImage`.`date_created`, `RoomCategoryImage`.`name`, `RoomCategoryImage`.`position` FROM `quatres_quatres_bdx`.`room_category_images` AS `RoomCategoryImage` WHERE `RoomCategoryImage`.`room_category_id` = (13) ORDER BY `position` ASC | 3 | 3 | 0 | |
SELECT `RoomConfiguration`.`id`, `RoomConfiguration`.`room_category_id`, `RoomConfiguration`.`created`, `RoomConfiguration`.`modified` FROM `quatres_quatres_bdx`.`room_configurations` AS `RoomConfiguration` WHERE `RoomConfiguration`.`room_category_id` = (13) | 1 | 1 | 0 | |
SELECT `BedTypeRoomConfiguration`.`id`, `BedTypeRoomConfiguration`.`room_configuration_id`, `BedTypeRoomConfiguration`.`bed_type_id`, `BedTypeRoomConfiguration`.`number` FROM `quatres_quatres_bdx`.`room_configurations_to_bed_types` AS `BedTypeRoomConfiguration` WHERE `BedTypeRoomConfiguration`.`room_configuration_id` = (15) ORDER BY `id` ASC | 1 | 1 | 0 | |
SELECT `RoomCategory`.`id`, `RoomCategory`.`property_id`, `RoomCategory`.`avg_dimensions`, `RoomCategory`.`type_bed`, `RoomCategory`.`max_capacity`, `RoomCategory`.`price_from`, `RoomCategory`.`currency`, `RoomCategory`.`num_rooms`, `RoomCategory`.`num_bedrooms`, `RoomCategory`.`num_bathrooms`, `RoomCategory`.`position`, `RoomCategory`.`modified`, `RoomCategory`.`is_published`, `RoomCategory`.`reservation_url`, `RoomCategory`.`telephone_reservation`, `RoomCategory`.`type_accommodation`, `RoomCategory`.`external_reservation_id`, `RoomCategory`.`created`, (`I18n__name`.`content`) AS `RoomCategory__i18n_name`, (`I18n__description`.`content`) AS `RoomCategory__i18n_description`, `Property`.`id`, `Property`.`type`, `Property`.`title`, `Property`.`min_capacity`, `Property`.`max_capacity`, `Property`.`num_bedrooms`, `Property`.`num_bathrooms`, `Property`.`dimensions`, `Property`.`image`, `Property`.`logo`, `Property`.`google_calendar_id`, `Property`.`change_over_day`, `Property`.`position`, `Property`.`is_published`, `Property`.`created`, `Property`.`modified` FROM `quatres_quatres_bdx`.`room_categories` AS `RoomCategory` LEFT JOIN `quatres_quatres_bdx`.`properties` AS `Property` ON (`RoomCategory`.`property_id` = `Property`.`id`) LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__name` ON (`RoomCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'RoomCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__description` ON (`RoomCategory`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'RoomCategory' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') WHERE `RoomCategory`.`is_published` = 'true' ORDER BY `RoomCategory`.`position` ASC | 6 | 6 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`configuration` AS `Configuration` WHERE `Configuration`.`property_id` = 2 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`configuration` AS `Configuration` WHERE `Configuration`.`property_id` = 2 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`configuration` AS `Configuration` WHERE `Configuration`.`property_id` = 2 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`configuration` AS `Configuration` WHERE `Configuration`.`property_id` = 3 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`configuration` AS `Configuration` WHERE `Configuration`.`property_id` = 3 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`configuration` AS `Configuration` WHERE `Configuration`.`property_id` = 3 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Room`.`id`, `Room`.`room_category_id`, `Room`.`position`, `Room`.`is_published`, `Room`.`modified`, `Room`.`created` FROM `quatres_quatres_bdx`.`rooms` AS `Room` WHERE `Room`.`room_category_id` IN (15, 14, 13, 17, 18, 16) ORDER BY `position` ASC | 0 | 0 | 0 | |
SELECT `RoomCategoryImage`.`id`, `RoomCategoryImage`.`room_category_id`, `RoomCategoryImage`.`date_created`, `RoomCategoryImage`.`name`, `RoomCategoryImage`.`position` FROM `quatres_quatres_bdx`.`room_category_images` AS `RoomCategoryImage` WHERE `RoomCategoryImage`.`room_category_id` IN (15, 14, 13, 17, 18, 16) ORDER BY `position` ASC | 29 | 29 | 0 | |
SELECT `RoomConfiguration`.`id`, `RoomConfiguration`.`room_category_id`, `RoomConfiguration`.`created`, `RoomConfiguration`.`modified` FROM `quatres_quatres_bdx`.`room_configurations` AS `RoomConfiguration` WHERE `RoomConfiguration`.`room_category_id` IN (15, 14, 13, 17, 18, 16) | 8 | 8 | 0 | |
SELECT `BedTypeRoomConfiguration`.`id`, `BedTypeRoomConfiguration`.`room_configuration_id`, `BedTypeRoomConfiguration`.`bed_type_id`, `BedTypeRoomConfiguration`.`number` FROM `quatres_quatres_bdx`.`room_configurations_to_bed_types` AS `BedTypeRoomConfiguration` WHERE `BedTypeRoomConfiguration`.`room_configuration_id` IN (15, 16, 17, 18, 19, 20, 21, 22) ORDER BY `id` ASC | 10 | 10 | 0 | |
SELECT `Property`.`id`, `Property`.`type`, `Property`.`title`, `Property`.`min_capacity`, `Property`.`max_capacity`, `Property`.`num_bedrooms`, `Property`.`num_bathrooms`, `Property`.`dimensions`, `Property`.`image`, `Property`.`logo`, `Property`.`google_calendar_id`, `Property`.`change_over_day`, `Property`.`position`, `Property`.`is_published`, `Property`.`created`, `Property`.`modified`, (`I18n__description`.`content`) AS `Property__i18n_description`, `Configuration`.`id`, `Configuration`.`property_id`, `Configuration`.`title`, `Configuration`.`address`, `Configuration`.`address2`, `Configuration`.`post_code`, `Configuration`.`city`, `Configuration`.`country`, `Configuration`.`telephone`, `Configuration`.`mobile`, `Configuration`.`fax`, `Configuration`.`email`, `Configuration`.`contact_form_emails`, `Configuration`.`group_reservation_email`, `Configuration`.`lat`, `Configuration`.`lng`, `Configuration`.`logo`, `Configuration`.`stars`, `Configuration`.`reservation_system`, `Configuration`.`reservation_url`, `Configuration`.`hotel_id`, `Configuration`.`reservation_advantages`, `Configuration`.`welcome_guide`, `Configuration`.`sustainable_certification`, `Configuration`.`url_website`, `Configuration`.`url_facebook`, `Configuration`.`url_twitter`, `Configuration`.`url_google_plus`, `Configuration`.`url_instagram`, `Configuration`.`whatsapp`, `Configuration`.`url_linkedin`, `Configuration`.`code_chain`, `Configuration`.`apollo_galileo`, `Configuration`.`sabre`, `Configuration`.`worldspan`, `Configuration`.`amadeus`, `Configuration`.`odd`, `Configuration`.`default_configuration` FROM `quatres_quatres_bdx`.`properties` AS `Property` LEFT JOIN `quatres_quatres_bdx`.`configuration` AS `Configuration` ON (`Configuration`.`property_id` = `Property`.`id`) LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__description` ON (`Property`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Property' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') WHERE `Property`.`id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Page`.`id` FROM `quatres_quatres_bdx`.`pages` AS `Page` WHERE `Page`.`home_page` = 'yes' LIMIT 1 | 1 | 1 | 0 | |
SELECT `PageImage`.`name`, `PageImage`.`page_id` FROM `quatres_quatres_bdx`.`page_images` AS `PageImage` WHERE `PageImage`.`page_id` = (1) ORDER BY `position` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `Condition`.`id`, `Condition`.`check_in_time_from`, `Condition`.`check_in_time_limit`, `Condition`.`check_in_time_to`, `Condition`.`check_out_time_from`, `Condition`.`check_out_time_limit`, `Condition`.`check_out_time_to`, `Condition`.`children_accepted`, `Condition`.`max_age_child`, `Condition`.`max_age_child_free_stay`, `Condition`.`is_extra_bed_available`, `Condition`.`extra_bed_supplement`, `Condition`.`is_baby_cot_available`, `Condition`.`baby_cot_supplement`, `Condition`.`animal_accepted`, `Condition`.`animal_supplement`, `Condition`.`parking_onsite`, `Condition`.`parking_obligatory_reservation`, `Condition`.`parking_supplement`, `Condition`.`parking_has_charge_point`, `Condition`.`parking_has_reserved_handicap`, `Condition`.`has_automatic_reception`, `Condition`.`has_twenty_four_hour_reception`, `Condition`.`reception_opening_hours`, `Condition`.`has_tourism_tax`, `Condition`.`tourism_tax_amount`, `Condition`.`accepted_payment_methods`, `Condition`.`free_cancellation`, `Condition`.`free_cancellation_days_before`, `Condition`.`free_cancellation_time`, `Condition`.`first_night_billed`, `Condition`.`cancellation_charge`, `Condition`.`is_wifi_available`, `Condition`.`is_wifi_free`, `Condition`.`supplement_wifi`, `Condition`.`is_breakfast_available`, `Condition`.`breakfast_price`, `Condition`.`supplement_breakfast_in_room`, `Condition`.`has_reduced_breakfast_price_for_children`, `Condition`.`breakfast_price_reduced_for_children_max_age`, `Condition`.`breakfast_price_reduced_for_children`, `Condition`.`breakfast_free_for_children_under`, `Condition`.`has_adaptations_for_handicaps`, `Condition`.`handicap_num_adapted_rooms`, `Condition`.`handicap_adaptations`, `Condition`.`created`, `Condition`.`modified`, (`I18n__cancellationConditions`.`content`) AS `Condition__i18n_cancellationConditions`, (`I18n__breakfastConditions`.`content`) AS `Condition__i18n_breakfastConditions`, (`I18n__parkingConditions`.`content`) AS `Condition__i18n_parkingConditions`, (`I18n__checkinExtraConditions`.`content`) AS `Condition__i18n_checkinExtraConditions`, (`I18n__checkoutExtraConditions`.`content`) AS `Condition__i18n_checkoutExtraConditions`, (`I18n__reception`.`content`) AS `Condition__i18n_reception`, (`I18n__supplementary`.`content`) AS `Condition__i18n_supplementary`, (`I18n__animalsConditions`.`content`) AS `Condition__i18n_animalsConditions`, (`I18n__childrenConditions`.`content`) AS `Condition__i18n_childrenConditions` FROM `quatres_quatres_bdx`.`conditions` AS `Condition` LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__cancellationConditions` ON (`Condition`.`id` = `I18n__cancellationConditions`.`foreign_key` AND `I18n__cancellationConditions`.`model` = 'Condition' AND `I18n__cancellationConditions`.`field` = 'cancellationConditions' AND `I18n__cancellationConditions`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__breakfastConditions` ON (`Condition`.`id` = `I18n__breakfastConditions`.`foreign_key` AND `I18n__breakfastConditions`.`model` = 'Condition' AND `I18n__breakfastConditions`.`field` = 'breakfastConditions' AND `I18n__breakfastConditions`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__parkingConditions` ON (`Condition`.`id` = `I18n__parkingConditions`.`foreign_key` AND `I18n__parkingConditions`.`model` = 'Condition' AND `I18n__parkingConditions`.`field` = 'parkingConditions' AND `I18n__parkingConditions`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__checkinExtraConditions` ON (`Condition`.`id` = `I18n__checkinExtraConditions`.`foreign_key` AND `I18n__checkinExtraConditions`.`model` = 'Condition' AND `I18n__checkinExtraConditions`.`field` = 'checkinExtraConditions' AND `I18n__checkinExtraConditions`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__checkoutExtraConditions` ON (`Condition`.`id` = `I18n__checkoutExtraConditions`.`foreign_key` AND `I18n__checkoutExtraConditions`.`model` = 'Condition' AND `I18n__checkoutExtraConditions`.`field` = 'checkoutExtraConditions' AND `I18n__checkoutExtraConditions`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__reception` ON (`Condition`.`id` = `I18n__reception`.`foreign_key` AND `I18n__reception`.`model` = 'Condition' AND `I18n__reception`.`field` = 'reception' AND `I18n__reception`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__supplementary` ON (`Condition`.`id` = `I18n__supplementary`.`foreign_key` AND `I18n__supplementary`.`model` = 'Condition' AND `I18n__supplementary`.`field` = 'supplementary' AND `I18n__supplementary`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__animalsConditions` ON (`Condition`.`id` = `I18n__animalsConditions`.`foreign_key` AND `I18n__animalsConditions`.`model` = 'Condition' AND `I18n__animalsConditions`.`field` = 'animalsConditions' AND `I18n__animalsConditions`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__childrenConditions` ON (`Condition`.`id` = `I18n__childrenConditions`.`foreign_key` AND `I18n__childrenConditions`.`model` = 'Condition' AND `I18n__childrenConditions`.`field` = 'childrenConditions' AND `I18n__childrenConditions`.`locale` = 'eng') WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `RoomCategory`.`id`, (`I18n__name`.`content`) AS `RoomCategory__i18n_name` FROM `quatres_quatres_bdx`.`room_categories` AS `RoomCategory` LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__name` ON (`RoomCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'RoomCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fra') WHERE `RoomCategory`.`id` = 13 LIMIT 1 | 1 | 1 | 0 | |
SELECT `RoomCategory`.`id`, (`I18n__name`.`content`) AS `RoomCategory__i18n_name` FROM `quatres_quatres_bdx`.`room_categories` AS `RoomCategory` LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__name` ON (`RoomCategory`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'RoomCategory' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') WHERE `RoomCategory`.`id` = 13 LIMIT 1 | 1 | 1 | 0 | |
21 duplicate queries run.