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 | 1 | |
SELECT `Restaurant`.`id`, `Restaurant`.`is_published`, `Restaurant`.`created`, `Restaurant`.`modified`, (`I18n__title`.`content`) AS `Restaurant__i18n_title`, (`I18n__introduction`.`content`) AS `Restaurant__i18n_introduction`, (`I18n__outroduction`.`content`) AS `Restaurant__i18n_outroduction`, (`I18n__business_hours_comments`.`content`) AS `Restaurant__i18n_business_hours_comments` FROM `quatres_quatres_bdx`.`restaurants` AS `Restaurant` LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__title` ON (`Restaurant`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Restaurant' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__introduction` ON (`Restaurant`.`id` = `I18n__introduction`.`foreign_key` AND `I18n__introduction`.`model` = 'Restaurant' AND `I18n__introduction`.`field` = 'introduction' AND `I18n__introduction`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__outroduction` ON (`Restaurant`.`id` = `I18n__outroduction`.`foreign_key` AND `I18n__outroduction`.`model` = 'Restaurant' AND `I18n__outroduction`.`field` = 'outroduction' AND `I18n__outroduction`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__business_hours_comments` ON (`Restaurant`.`id` = `I18n__business_hours_comments`.`foreign_key` AND `I18n__business_hours_comments`.`model` = 'Restaurant' AND `I18n__business_hours_comments`.`field` = 'business_hours_comments' AND `I18n__business_hours_comments`.`locale` = 'fra') WHERE 1 = 1 LIMIT 1 | 1 | 1 | 0 | |
SELECT `RestaurantImage`.`id`, `RestaurantImage`.`restaurant_id`, `RestaurantImage`.`name`, `RestaurantImage`.`position` FROM `quatres_quatres_bdx`.`restaurant_images` AS `RestaurantImage` WHERE `RestaurantImage`.`restaurant_id` = (2) ORDER BY `position` ASC | 5 | 5 | 0 | |
SELECT `RestaurantMenu`.`id`, `RestaurantMenu`.`price`, `RestaurantMenu`.`position`, `RestaurantMenu`.`display_prices`, `RestaurantMenu`.`is_published`, `RestaurantMenu`.`type`, `RestaurantMenu`.`has_global_price`, `RestaurantMenu`.`use_section_titles`, `RestaurantMenu`.`date_start`, `RestaurantMenu`.`date_end`, `RestaurantMenu`.`is_available_to_order`, `RestaurantMenu`.`order_type`, `RestaurantMenu`.`has_online_payment`, `RestaurantMenu`.`has_unlimited_selection`, `RestaurantMenu`.`order_restriction`, `RestaurantMenu`.`order_date_limit`, `RestaurantMenu`.`order_pickup_time_start`, `RestaurantMenu`.`order_pickup_time_end`, `RestaurantMenu`.`created`, `RestaurantMenu`.`modified`, (`I18n__title`.`content`) AS `RestaurantMenu__i18n_title`, (`I18n__content`.`content`) AS `RestaurantMenu__i18n_content` FROM `quatres_quatres_bdx`.`restaurant_menus` AS `RestaurantMenu` LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__title` ON (`RestaurantMenu`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'RestaurantMenu' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__content` ON (`RestaurantMenu`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'RestaurantMenu' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'fra') WHERE `type` IN ('carte', 'menu') AND `is_published` = 'true' ORDER BY `position` ASC | 0 | 0 | 1 | maybe slow |
SELECT `RestaurantMenu`.`id`, `RestaurantMenu`.`price`, `RestaurantMenu`.`position`, `RestaurantMenu`.`display_prices`, `RestaurantMenu`.`is_published`, `RestaurantMenu`.`type`, `RestaurantMenu`.`has_global_price`, `RestaurantMenu`.`use_section_titles`, `RestaurantMenu`.`date_start`, `RestaurantMenu`.`date_end`, `RestaurantMenu`.`is_available_to_order`, `RestaurantMenu`.`order_type`, `RestaurantMenu`.`has_online_payment`, `RestaurantMenu`.`has_unlimited_selection`, `RestaurantMenu`.`order_restriction`, `RestaurantMenu`.`order_date_limit`, `RestaurantMenu`.`order_pickup_time_start`, `RestaurantMenu`.`order_pickup_time_end`, `RestaurantMenu`.`created`, `RestaurantMenu`.`modified`, (`I18n__title`.`content`) AS `RestaurantMenu__i18n_title`, (`I18n__content`.`content`) AS `RestaurantMenu__i18n_content` FROM `quatres_quatres_bdx`.`restaurant_menus` AS `RestaurantMenu` LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__title` ON (`RestaurantMenu`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'RestaurantMenu' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fra') LEFT JOIN `quatres_quatres_bdx`.`i18n` AS `I18n__content` ON (`RestaurantMenu`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'RestaurantMenu' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'fra') WHERE ((`RestaurantMenu`.`is_published` = 'true') AND (`RestaurantMenu`.`type` = 'daily') AND (((`RestaurantMenu`.`date_start` = '2024-12-07') OR (((`RestaurantMenu`.`date_start` <= '2024-12-07') AND (`RestaurantMenu`.`date_end` IS NOT NULL) AND (`RestaurantMenu`.`date_end` >= '2024-12-07')))))) ORDER BY `RestaurantMenu`.`date_start` ASC | 0 | 0 | 0 | |
SELECT `RestaurantBusinessHour`.`id`, `RestaurantBusinessHour`.`day`, `RestaurantBusinessHour`.`open`, `RestaurantBusinessHour`.`close` FROM `quatres_quatres_bdx`.`restaurant_business_hours` AS `RestaurantBusinessHour` WHERE 1 = 1 ORDER BY `open` ASC | 7 | 7 | 0 | |
SELECT `RestaurantSupplier`.`id`, `RestaurantSupplier`.`name`, `RestaurantSupplier`.`product_type`, `RestaurantSupplier`.`locality`, `RestaurantSupplier`.`url`, `RestaurantSupplier`.`image`, `RestaurantSupplier`.`position`, `RestaurantSupplier`.`is_published`, `RestaurantSupplier`.`created`, `RestaurantSupplier`.`modified` FROM `quatres_quatres_bdx`.`restaurant_suppliers` AS `RestaurantSupplier` WHERE `RestaurantSupplier`.`is_published` = 'true' ORDER BY `position` ASC | 0 | 0 | 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` = 'Restaurants' LIMIT 1 | 1 | 1 | 0 | |
HAPPY HOUR du lundi au vendredi 17H-19H