Warning (2): DOMDocument::loadXML() [domdocument.loadxml]: StartTag: invalid element name in Entity, line: 1 [APP/models/datasources/google_weather_source.php, line 92]
Warning (2): DOMDocument::loadXML() [domdocument.loadxml]: Extra content at the end of the document in Entity, line: 1 [APP/models/datasources/google_weather_source.php, line 92]
Situé dans un village du Bessin, ce magnifique manoir classé du 13ème siècle se trouve à proximité des plages du débarquement dans le pays de Guillaume le Conquérant. Ses murs fortifiés cachent une vaste terrasse où les clients peuvent déguster un apéritif en été avant de s'asseoir pour un repas typiquement régional. Le restaurant évoque l'époque médiévale avec ses épais murs de pierre et sa grande cheminée. Les chambres ont la même ambiance authentique avec des poutres en chêne magnifiques, des armoires normandes du 15ème siècle, des sols en pierre, du mobilier et de beaux tapis. La Ferme de la Ranconnière est la base idéale pour explorer l'histoire de la Normandie.
Ascenseurs, Restaurant, Service d'entretien, petit déjeuner buffet, parking gratuit, club de santé, golf, piscine extérieure, tennis, sécurité 24 heures, Téléphone, pays rural, sur l'océan, des détecteurs de fumée.
Vous devez vous connecter pour pouvoir poster un commentaire.
Globe Secret est né de l'association de professionnels du tourisme, de l’hotellerie et du e-commerce. Les équipes de Globe Secret garantissent à ses utilisateurs une sélection rigoureuse d'hôtels de charme. Immatriculation d'agent de voyages n° IM075100403 - Garantie Financière : BPRP - Membre de l' - RCP : Hiscox n° HA PRC0055186 - CNIL 1517931.
Query | Error | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|---|
SHOW FULL COLUMNS FROM `hotels` | 34 | 34 | 0 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | ||
SHOW FULL COLUMNS FROM `cities` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `states` | 3 | 3 | 0 | ||
SHOW FULL COLUMNS FROM `countries` | 3 | 3 | 0 | ||
SHOW FULL COLUMNS FROM `weather_forecasts` | 15 | 15 | 0 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 0 | ||
SHOW FULL COLUMNS FROM `news` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `home_hotels` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `hotel_images` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `rooms` | 15 | 15 | 0 | ||
SHOW FULL COLUMNS FROM `rooms_rates` | 8 | 8 | 0 | ||
SHOW FULL COLUMNS FROM `rates_periods` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `rates_period_i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `unavailabilities` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `envies` | 3 | 3 | 0 | ||
SHOW FULL COLUMNS FROM `envie_i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `envies_hotels` | 2 | 2 | 0 | ||
SHOW FULL COLUMNS FROM `comments` | 19 | 19 | 0 | ||
SHOW FULL COLUMNS FROM `users` | 16 | 16 | 0 | ||
SHOW FULL COLUMNS FROM `addresses` | 12 | 12 | 0 | ||
SHOW FULL COLUMNS FROM `janrain_profiles` | 9 | 9 | 0 | ||
SHOW FULL COLUMNS FROM `admins` | 15 | 15 | 0 | ||
SHOW FULL COLUMNS FROM `favorites` | 8 | 8 | 0 | ||
SHOW FULL COLUMNS FROM `hotel_i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `configs` | 3 | 3 | 0 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | 1 | 1 | 0 | ||
SELECT `Config`.*, `I18n__val`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18n__val` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18n__val`.`model` = 'Config' AND `I18n__val`.`field` = 'val' AND `I18n__val`.`locale` = 'fre') WHERE 1 = 1 | 1 | 1 | 1 | ||
SELECT `Vals`.`id`, `Vals`.`locale`, `Vals`.`model`, `Vals`.`foreign_key`, `Vals`.`field`, `Vals`.`content` FROM `i18n` AS `Vals` WHERE `model` = 'Config' AND `field` = 'val' AND `Vals`.`foreign_key` = (1) | 2 | 2 | 0 | ||
SELECT `Hotel`.*, `City`.*, `Country`.*, `State`.*, `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'fre') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) WHERE `Hotel`.`id` = 574 LIMIT 1 | 1 | 1 | 0 | ||
SELECT `City`.`id`, `City`.`country_id`, `City`.`state_id`, `City`.`maintrack_id`, `City`.`name`, `City`.`main_key` FROM `cities` AS `City` WHERE `City`.`id` = 529 | 1 | 1 | 0 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'FR' | 1 | 1 | 0 | ||
SELECT `HotelImage`.`id`, `HotelImage`.`hotel_id`, `HotelImage`.`order`, `HotelImage`.`uri`, `HotelImage`.`ratio_hw`, `HotelImage`.`on_wall` FROM `hotel_images` AS `HotelImage` WHERE `HotelImage`.`hotel_id` = (574) | 7 | 7 | 0 | ||
SELECT `Room`.`id`, `Room`.`type`, `Room`.`hotel_id`, `Room`.`name`, `Room`.`description`, `Room`.`name_fre`, `Room`.`description_fre`, `Room`.`lowest_rate`, `Room`.`lr_currency`, `Room`.`lr_people`, `Room`.`breakfast_included`, `Room`.`half_board`, `Room`.`all_inclusive`, `Room`.`full_board`, `Room`.`accomodation_only` FROM `rooms` AS `Room` WHERE `Room`.`hotel_id` = (574) | 3 | 3 | 1 | maybe slow | |
SELECT `RoomsRate`.`id`, `RoomsRate`.`rates_period_id`, `RoomsRate`.`room_id`, `RoomsRate`.`rate_regular`, `RoomsRate`.`rate_special`, `RoomsRate`.`rate_currency`, `RoomsRate`.`created`, `RoomsRate`.`modified` FROM `rooms_rates` AS `RoomsRate` WHERE `RoomsRate`.`room_id` IN (2324, 2325, 2326) | 0 | 0 | 0 | ||
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`to` >= NOW() AND `RatesPeriod`.`hotel_id` = (574) ORDER BY `RatesPeriod`.`from` ASC LIMIT 5 | 0 | 0 | 0 | ||
SELECT `News`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content` FROM `news` AS `News` INNER JOIN `i18n` AS `I18n__name` ON (`News`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'News' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') INNER JOIN `i18n` AS `I18n__description` ON (`News`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'News' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'fre') INNER JOIN `i18n` AS `I18n__link` ON (`News`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'News' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'fre') WHERE `News`.`country_id` = 'FR' ORDER BY `News`.`created` DESC | 2 | 2 | 2 | ||
SELECT `Hotel`.*, `HomeHotel`.*, `City`.*, `Country`.*, `State`.*, `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18n__tagline` ON (`Hotel`.`id` = `I18n__tagline`.`foreign_key` AND `I18n__tagline`.`model` = 'Hotel' AND `I18n__tagline`.`field` = 'tagline' AND `I18n__tagline`.`locale` = 'fre') LEFT JOIN `cities` AS `City` ON (`Hotel`.`city_id` = `City`.`id`) LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Hotel`.`state_id` = `State`.`id`) LEFT JOIN `home_hotels` AS `HomeHotel` ON (`HomeHotel`.`hotel_id` = `Hotel`.`id`) WHERE `Hotel`.`published` = 1 AND `Hotel`.`id` != 574 AND `Hotel`.`longitude` BETWEEN -1.9324163703614 AND 0.83045037036137 AND `Hotel`.`latitude` BETWEEN 48.41546404058 AND 50.21653995942 ORDER BY ABS(`Hotel`.`longitude` - -0.550983) + ABS(`Hotel`.`latitude` - 49.316002) ASC LIMIT 3 | 3 | 3 | 8 | maybe slow | |
SELECT `HotelImage`.`id`, `HotelImage`.`hotel_id`, `HotelImage`.`order`, `HotelImage`.`uri`, `HotelImage`.`ratio_hw`, `HotelImage`.`on_wall` FROM `hotel_images` AS `HotelImage` WHERE `HotelImage`.`hotel_id` IN (1108, 597, 1109) | 20 | 20 | 0 | ||
SELECT `Room`.`id`, `Room`.`type`, `Room`.`hotel_id`, `Room`.`name`, `Room`.`description`, `Room`.`name_fre`, `Room`.`description_fre`, `Room`.`lowest_rate`, `Room`.`lr_currency`, `Room`.`lr_people`, `Room`.`breakfast_included`, `Room`.`half_board`, `Room`.`all_inclusive`, `Room`.`full_board`, `Room`.`accomodation_only` FROM `rooms` AS `Room` WHERE `Room`.`hotel_id` IN (1108, 597, 1109) | 12 | 12 | 2 | maybe slow | |
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (1108, 597, 1109) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1108, 597, 1109) | 0 | 0 | 0 | ||
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`foreign_key` IN (1108, 597, 1109) | 0 | 0 | 0 | ||
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`foreign_key`, `Favorite`.`model`, `Favorite`.`type`, `Favorite`.`position`, `Favorite`.`created`, `Favorite`.`modified` FROM `favorites` AS `Favorite` WHERE `Favorite`.`model` = 'Hotel' AND `Favorite`.`foreign_key` IN (1108, 597, 1109) | 0 | 0 | 0 | ||
SELECT `Taglines`.`id`, `Taglines`.`locale`, `Taglines`.`model`, `Taglines`.`foreign_key`, `Taglines`.`field`, `Taglines`.`content` FROM `hotel_i18n` AS `Taglines` WHERE `model` = 'Hotel' AND `field` = 'tagline' AND `Taglines`.`foreign_key` IN (1108, 597, 1109) | 6 | 6 | 0 | ||
SELECT `Envie`.`id`, `Envie`.`created`, `Envie`.`modified`, `EnviesHotel`.`envie_id`, `EnviesHotel`.`hotel_id` FROM `envies` AS `Envie` JOIN `envies_hotels` AS `EnviesHotel` ON (`EnviesHotel`.`hotel_id` IN (1108, 597, 1109) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 19 | 19 | 1 | maybe slow | |
SHOW FULL COLUMNS FROM `events` | 18 | 18 | 0 | ||
SHOW FULL COLUMNS FROM `home_events` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `event_images` | 5 | 5 | 0 | ||
SHOW FULL COLUMNS FROM `themes` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `theme_i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `events_hotels` | 2 | 2 | 0 | ||
SHOW FULL COLUMNS FROM `events_themes` | 2 | 2 | 0 | ||
SHOW FULL COLUMNS FROM `event_i18n` | 6 | 6 | 0 | ||
SELECT `Event`.*, `HomeEvent`.*, `CreatedUser`.*, `Country`.*, `State`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18n__name` ON (`Event`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Event' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') INNER JOIN `event_i18n` AS `I18n__description` ON (`Event`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Event' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'fre') INNER JOIN `event_i18n` AS `I18n__link` ON (`Event`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Event' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'fre') LEFT JOIN `users` AS `CreatedUser` ON (`Event`.`created_user_id` = `CreatedUser`.`id`) LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `home_events` AS `HomeEvent` ON (`HomeEvent`.`event_id` = `Event`.`id`) WHERE ((`Event`.`end` IS NULL) OR (`Event`.`end` >= NOW())) AND `Event`.`longitude` BETWEEN -1.9324163703614 AND 0.83045037036137 AND `Event`.`latitude` BETWEEN 48.41546404058 AND 50.21653995942 ORDER BY ABS(`Event`.`longitude` - -0.550983) + ABS(`Event`.`latitude` - 49.316002) ASC LIMIT 10 | 10 | 10 | 12 | maybe slow | |
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (902, 665, 668, 671, 667, 673, 670, 672, 666, 664) | 0 | 0 | 0 | ||
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`foreign_key` IN (902, 665, 668, 671, 667, 673, 670, 672, 666, 664) | 0 | 0 | 0 | ||
SELECT `Favorite`.`id`, `Favorite`.`user_id`, `Favorite`.`foreign_key`, `Favorite`.`model`, `Favorite`.`type`, `Favorite`.`position`, `Favorite`.`created`, `Favorite`.`modified` FROM `favorites` AS `Favorite` WHERE `Favorite`.`model` = 'Event' AND `Favorite`.`foreign_key` IN (902, 665, 668, 671, 667, 673, 670, 672, 666, 664) | 0 | 0 | 0 | ||
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `event_i18n` AS `Names` WHERE `model` = 'Event' AND `field` = 'name' AND `Names`.`foreign_key` IN (902, 665, 668, 671, 667, 673, 670, 672, 666, 664) | 20 | 20 | 0 | ||
SELECT `Descriptions`.`id`, `Descriptions`.`locale`, `Descriptions`.`model`, `Descriptions`.`foreign_key`, `Descriptions`.`field`, `Descriptions`.`content` FROM `event_i18n` AS `Descriptions` WHERE `model` = 'Event' AND `field` = 'description' AND `Descriptions`.`foreign_key` IN (902, 665, 668, 671, 667, 673, 670, 672, 666, 664) | 20 | 20 | 0 | ||
SELECT `Links`.`id`, `Links`.`locale`, `Links`.`model`, `Links`.`foreign_key`, `Links`.`field`, `Links`.`content` FROM `event_i18n` AS `Links` WHERE `model` = 'Event' AND `field` = 'link' AND `Links`.`foreign_key` IN (902, 665, 668, 671, 667, 673, 670, 672, 666, 664) | 20 | 20 | 0 | ||
SELECT `Hotel`.`id`, `Hotel`.`starred`, `Hotel`.`in`, `Hotel`.`maintrack_hotel_id`, `Hotel`.`brand_code`, `Hotel`.`name`, `Hotel`.`address`, `Hotel`.`zip_code`, `Hotel`.`cityarea_id`, `Hotel`.`city_id`, `Hotel`.`region_id`, `Hotel`.`state_id`, `Hotel`.`country_id`, `Hotel`.`latitude`, `Hotel`.`longitude`, `Hotel`.`zoom`, `Hotel`.`rating`, `Hotel`.`phone`, `Hotel`.`reservation_phone`, `Hotel`.`fax`, `Hotel`.`email`, `Hotel`.`created`, `Hotel`.`modified`, `Hotel`.`description`, `Hotel`.`description_fre`, `Hotel`.`amenity`, `Hotel`.`amenity_fre`, `Hotel`.`lowest_rate`, `Hotel`.`lr_currency`, `Hotel`.`lr_people`, `Hotel`.`comment_count`, `Hotel`.`cancellation_policy`, `Hotel`.`cancellation_policy_fre`, `Hotel`.`published`, `EventsHotel`.`event_id`, `EventsHotel`.`hotel_id` FROM `hotels` AS `Hotel` JOIN `events_hotels` AS `EventsHotel` ON (`EventsHotel`.`event_id` IN (902, 665, 668, 671, 667, 673, 670, 672, 666, 664) AND `EventsHotel`.`hotel_id` = `Hotel`.`id`) | 0 | 0 | 0 | ||
SELECT `Theme`.`id`, `Theme`.`created`, `Theme`.`modified`, `Theme`.`uri`, `EventsTheme`.`event_id`, `EventsTheme`.`theme_id` FROM `themes` AS `Theme` JOIN `events_themes` AS `EventsTheme` ON (`EventsTheme`.`event_id` IN (902, 665, 668, 671, 667, 673, 670, 672, 666, 664) AND `EventsTheme`.`theme_id` = `Theme`.`id`) | 0 | 0 | 0 | ||
SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC | 256 | 256 | 0 | ||
SELECT `Theme`.*, `I18n__name`.`content`, `Theme`.`id` FROM `themes` AS `Theme` INNER JOIN `theme_i18n` AS `I18n__name` ON (`Theme`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Theme' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC | 10 | 10 | 0 | ||
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `theme_i18n` AS `Names` WHERE `model` = 'Theme' AND `field` = 'name' AND `Names`.`foreign_key` IN (6, 10, 7, 12, 11, 13, 5, 8, 4, 9) | 20 | 20 | 0 | ||
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1 | 10 | 10 | 0 | ||
SELECT `Envie`.*, `I18n__name`.`content`, `Envie`.`id` FROM `envies` AS `Envie` INNER JOIN `envie_i18n` AS `I18n__name` ON (`Envie`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Envie' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'fre') WHERE 1 = 1 ORDER BY `I18n__name`.`content` ASC | 29 | 29 | 0 | ||
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `envie_i18n` AS `Names` WHERE `model` = 'Envie' AND `field` = 'name' AND `Names`.`foreign_key` IN (22, 21, 25, 26, 4, 12, 14, 19, 9, 30, 3, 1, 13, 6, 24, 7, 18, 5, 10, 27, 2, 11, 29, 16, 15, 23, 17, 8, 28) | 58 | 58 | 0 | ||
SELECT `Hotel`.`id`, `Country`.*, `Country`.`id` FROM `hotels` AS `Hotel` LEFT JOIN `countries` AS `Country` ON (`Hotel`.`country_id` = `Country`.`id`) WHERE 1 = 1 GROUP BY `Hotel`.`country_id` ORDER BY `Country`.`name_fre` ASC | 120 | 120 | 3 | ||
SHOW FULL COLUMNS FROM `promises` | 3 | 3 | 0 | ||
SELECT `Promise`.*, `I18n__title`.`content`, `I18n__content`.`content`, `Promise`.`id` FROM `promises` AS `Promise` INNER JOIN `i18n` AS `I18n__title` ON (`Promise`.`id` = `I18n__title`.`foreign_key` AND `I18n__title`.`model` = 'Promise' AND `I18n__title`.`field` = 'title' AND `I18n__title`.`locale` = 'fre') INNER JOIN `i18n` AS `I18n__content` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18n__content`.`model` = 'Promise' AND `I18n__content`.`field` = 'content' AND `I18n__content`.`locale` = 'fre') WHERE 1 = 1 LIMIT 4 | 4 | 4 | 1 | maybe slow | |
SELECT `Titles`.`id`, `Titles`.`locale`, `Titles`.`model`, `Titles`.`foreign_key`, `Titles`.`field`, `Titles`.`content` FROM `i18n` AS `Titles` WHERE `model` = 'Promise' AND `field` = 'title' AND `Titles`.`foreign_key` IN (1, 2, 3, 4) | 8 | 8 | 0 | ||
SELECT `Contents`.`id`, `Contents`.`locale`, `Contents`.`model`, `Contents`.`foreign_key`, `Contents`.`field`, `Contents`.`content` FROM `i18n` AS `Contents` WHERE `model` = 'Promise' AND `field` = 'content' AND `Contents`.`foreign_key` IN (1, 2, 3, 4) | 8 | 8 | 0 | ||
SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 574 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham') | 1 | 1 | 0 | ||
SELECT `Comment`.`id`, `Comment`.`parent_id`, `Comment`.`foreign_key`, `Comment`.`user_id`, `Comment`.`lft`, `Comment`.`rght`, `Comment`.`model`, `Comment`.`approved`, `Comment`.`is_spam`, `Comment`.`title`, `Comment`.`slug`, `Comment`.`body`, `Comment`.`author_name`, `Comment`.`author_url`, `Comment`.`author_email`, `Comment`.`language`, `Comment`.`comment_type`, `Comment`.`created`, `Comment`.`modified`, `Hotel`.`id`, `UserModel`.`id`, `UserModel`.`first_name`, (CONCAT(`UserModel`.`first_name`, ' ', `UserModel`.`name`)) AS `UserModel__full_name`, (`UserModel`.`id`) AS `UserModel__slug` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 574 AND `Comment`.`model` = 'Hotel' AND `Comment`.`is_spam` IN ('clean', 'ham') LIMIT 5 | 0 | 0 | 0 |
Peak Memory Use 27,00 MB
Message | Memory use |
---|---|
Component initialization | 14,00 MB |
Controller action start | 14,00 MB |
Controller render start | 16,00 MB |
View render complete | 20,00 MB |
Total Request Time: 483 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 64,94 | |
Component initialization and startup | 5,14 | |
Controller action | 198,76 | |
Render Controller Action | 99,31 | |
» Rendering View | 96,07 | |
» » Rendering APP/views/hotels/view.ctp | 43,63 | |
» » » Rendering APP/views/elements/sharing_widget.ctp | 0,21 | |
» » » Rendering APP/views/elements/comments/flat/main.ctp | 0,42 | |
» » » Rendering APP/views/elements/hotels/form_reservation.ctp | 3,28 | |
» » » Rendering APP/views/elements/events/related.ctp | 0,91 | |
» » » Rendering APP/views/elements/events/related.ctp #2 | 0,94 | |
» » » Rendering APP/views/elements/events/related.ctp #3 | 0,96 | |
» » » Rendering APP/views/elements/events/related.ctp #4 | 0,91 | |
» » » Rendering APP/views/elements/events/related.ctp #5 | 0,91 | |
» » » Rendering APP/views/elements/events/related.ctp #6 | 0,91 | |
» » » Rendering APP/views/elements/events/related.ctp #7 | 0,86 | |
» » » Rendering APP/views/elements/events/related.ctp #8 | 0,92 | |
» » » Rendering APP/views/elements/events/related.ctp #9 | 0,93 | |
» » » Rendering APP/views/elements/events/related.ctp #10 | 0,94 | |
» » » Rendering APP/views/elements/events/legend.ctp | 1,82 | |
» » » Rendering APP/views/elements/hotels/related.ctp #11 | 0,66 | |
» » » Rendering APP/views/elements/hotels/related.ctp #12 | 0,65 | |
» » » Rendering APP/views/elements/hotels/related.ctp #13 | 0,53 | |
» » Rendering APP/views/layouts/default.ctp | 52,25 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0,10 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1,57 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0,31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 45,63 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0,12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 3,68 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0,31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0,09 |
Time | Message |
---|---|
2023-06-01 08:39:25 | Warning (2): DOMDocument::loadXML() [<a href='http://php.net/domdocument.loadxml'>domdocument.loadxml</a>]: StartTag: invalid element name in Entity, line: 1 in [/home/globesecret/dev/app/models/datasources/google_weather_source.php, line 92] |
2023-06-01 08:39:25 | Warning (2): DOMDocument::loadXML() [<a href='http://php.net/domdocument.loadxml'>domdocument.loadxml</a>]: Extra content at the end of the document in Entity, line: 1 in [/home/globesecret/dev/app/models/datasources/google_weather_source.php, line 92] |
Time | Message |
---|---|
2023-06-01 08:39:25 | Impossible to access the Google API |
2023-06-01 08:39:25 | Impossible to access the Google API |
0 commentaires
Poster un commentaire