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`.`properties` AS `Property` WHERE `Property`.`id` = 2 | 1 | 1 | 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` = 'fra') WHERE `Property`.`id` = 2 LIMIT 1 | 1 | 1 | 7 | maybe slow |
SELECT `PropertyImage`.`id`, `PropertyImage`.`property_id`, `PropertyImage`.`name`, `PropertyImage`.`position` FROM `quatres_quatres_bdx`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`property_id` = (2) ORDER BY `PropertyImage`.`position` ASC | 43 | 43 | 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 `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` = 'fra') 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` = 'fra') WHERE `RoomCategory`.`property_id` = 2 AND `RoomCategory`.`is_published` = 'true' ORDER BY `RoomCategory`.`position` ASC | 3 | 3 | 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 `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) 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) ORDER BY `position` ASC | 18 | 18 | 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) | 4 | 4 | 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) ORDER BY `id` ASC | 5 | 5 | 0 | |
10 duplicate queries run.