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 `Direction`.`id`, `Direction`.`override_lat`, `Direction`.`override_lng`, `Direction`.`zoom`, `Direction`.`show_directions`, `Direction`.`created`, `Direction`.`modified`, (`I18n__title`.`content`) AS `Direction__i18n_title`, (`I18n__content`.`content`) AS `Direction__i18n_content`, (`I18n__transport`.`content`) AS `Direction__i18n_transport` FROM `quatres_quatres_bdx`.`directions` AS `Direction` LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__title` ON (`Direction`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Direction' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__content` ON (`Direction`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Direction' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__transport` ON (`Direction`.`id` = `I18n__transport`.`foreign_key` AND `I18n__transport`.`model` = 'Direction' AND `I18n__transport`.`field` = 'transport' AND `I18n__transport`.`locale` = 'eng') WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `Parking`.`id`, `Parking`.`map_name`, `Parking`.`type`, `Parking`.`transport_type`, `Parking`.`title`, `Parking`.`address`, `Parking`.`post_code`, `Parking`.`city`, `Parking`.`lat`, `Parking`.`lng`, `Parking`.`distance`, `Parking`.`created`, `Parking`.`modifed` FROM `quatres_quatres_bdx`.`map_points` AS `Parking` WHERE `map_name` = 'directions' AND `type` = 'parking' | 3 | 3 | 0 | |
SELECT `Transport`.`id`, `Transport`.`map_name`, `Transport`.`type`, `Transport`.`transport_type`, `Transport`.`title`, `Transport`.`address`, `Transport`.`post_code`, `Transport`.`city`, `Transport`.`lat`, `Transport`.`lng`, `Transport`.`distance`, `Transport`.`created`, `Transport`.`modifed` FROM `quatres_quatres_bdx`.`map_points` AS `Transport` WHERE `map_name` = 'directions' AND `type` = 'transport' | 3 | 3 | 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 `MetaData`.`id`, `MetaData`.`controller`, `MetaData`.`action`, `MetaData`.`type`, `MetaData`.`created`, `MetaData`.`modified`, (`I18n__heading__fra`.`content`) AS `MetaData__i18n_heading_fra`, (`I18n__heading__eng`.`content`) AS `MetaData__i18n_heading_eng`, (`I18n__introduction__fra`.`content`) AS `MetaData__i18n_introduction_fra`, (`I18n__introduction__eng`.`content`) AS `MetaData__i18n_introduction_eng`, (`I18n__outroduction__fra`.`content`) AS `MetaData__i18n_outroduction_fra`, (`I18n__outroduction__eng`.`content`) AS `MetaData__i18n_outroduction_eng`, (`I18n__title__fra`.`content`) AS `MetaData__i18n_title_fra`, (`I18n__title__eng`.`content`) AS `MetaData__i18n_title_eng`, (`I18n__description__fra`.`content`) AS `MetaData__i18n_description_fra`, (`I18n__description__eng`.`content`) AS `MetaData__i18n_description_eng`, (`I18n__keywords__fra`.`content`) AS `MetaData__i18n_keywords_fra`, (`I18n__keywords__eng`.`content`) AS `MetaData__i18n_keywords_eng` FROM `quatres_quatres_bdx`.`meta_data` AS `MetaData` LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__heading__fra` ON (`MetaData`.`id` = `I18n__heading__fra`.`foreign_key` AND `I18n__heading__fra`.`model` = 'MetaData' AND `I18n__heading__fra`.`field` = 'heading' AND `I18n__heading__fra`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__heading__eng` ON (`MetaData`.`id` = `I18n__heading__eng`.`foreign_key` AND `I18n__heading__eng`.`model` = 'MetaData' AND `I18n__heading__eng`.`field` = 'heading' AND `I18n__heading__eng`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__introduction__fra` ON (`MetaData`.`id` = `I18n__introduction__fra`.`foreign_key` AND `I18n__introduction__fra`.`model` = 'MetaData' AND `I18n__introduction__fra`.`field` = 'introduction' AND `I18n__introduction__fra`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__introduction__eng` ON (`MetaData`.`id` = `I18n__introduction__eng`.`foreign_key` AND `I18n__introduction__eng`.`model` = 'MetaData' AND `I18n__introduction__eng`.`field` = 'introduction' AND `I18n__introduction__eng`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__outroduction__fra` ON (`MetaData`.`id` = `I18n__outroduction__fra`.`foreign_key` AND `I18n__outroduction__fra`.`model` = 'MetaData' AND `I18n__outroduction__fra`.`field` = 'outroduction' AND `I18n__outroduction__fra`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__outroduction__eng` ON (`MetaData`.`id` = `I18n__outroduction__eng`.`foreign_key` AND `I18n__outroduction__eng`.`model` = 'MetaData' AND `I18n__outroduction__eng`.`field` = 'outroduction' AND `I18n__outroduction__eng`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__title__fra` ON (`MetaData`.`id` = `I18n__title__fra`.`foreign_key` AND `I18n__title__fra`.`model` = 'MetaData' AND `I18n__title__fra`.`field` = 'title' AND `I18n__title__fra`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__title__eng` ON (`MetaData`.`id` = `I18n__title__eng`.`foreign_key` AND `I18n__title__eng`.`model` = 'MetaData' AND `I18n__title__eng`.`field` = 'title' AND `I18n__title__eng`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__description__fra` ON (`MetaData`.`id` = `I18n__description__fra`.`foreign_key` AND `I18n__description__fra`.`model` = 'MetaData' AND `I18n__description__fra`.`field` = 'description' AND `I18n__description__fra`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__description__eng` ON (`MetaData`.`id` = `I18n__description__eng`.`foreign_key` AND `I18n__description__eng`.`model` = 'MetaData' AND `I18n__description__eng`.`field` = 'description' AND `I18n__description__eng`.`locale` = 'eng') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__keywords__fra` ON (`MetaData`.`id` = `I18n__keywords__fra`.`foreign_key` AND `I18n__keywords__fra`.`model` = 'MetaData' AND `I18n__keywords__fra`.`field` = 'keywords' AND `I18n__keywords__fra`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__keywords__eng` ON (`MetaData`.`id` = `I18n__keywords__eng`.`foreign_key` AND `I18n__keywords__eng`.`model` = 'MetaData' AND `I18n__keywords__eng`.`field` = 'keywords' AND `I18n__keywords__eng`.`locale` = 'eng') WHERE `controller` = 'Directions' LIMIT 1 | 1 | 1 | 0 | |