L'auberge Westover a été construite en 1867 par William et Joseph Hutton. Westover était comme l'une des plus populaires auberges de l'Ontario...
Situé sur le très chic Robson Square, le Wedgewood est une adresse superbe au cœur de la ville cosmopolite de Vancouver. En 1984, Eleni Skalbania...
L''Auberge des Gallant, Restaurant et Spa, est un etablissement haut de gamme situe entre Montreal et Ottawa sur le mont Rigaud. Cette Auberge...
Le Lodge et ses cabanes sont superbement aménagées et nichées dans les arbres le long des eaux tumultueuses de la rivière Kicking Horse. Des...
Une belle maison historique entièrement rénové et re-décoré avec une élégance du vieux monde et le style contemporain chic. Les 65 chambres et...
Le Edgewater est un superbe domaine avec 12 chambres au bord d'un lac à Whistler, en Colombie-Britannique. Il est situé sur 25 hectares de belles...
Chambres luxueuses, un spa exceptionnel et un restaurant gastronomique sont les principales caractéristiques de cet hôtel contemporain du...
Un manoir de campagne anglaise d'inspiration canadien correspond bien à Hastings House, qui surplombe le port paisible. 10 hectares de jardins de...
Situé à 25 minutes d'Ottawa, le Wakefield Mill Inn & Spa offre un hébergement unique au coeur de la beauté naturelle du parc de la Gatineau avec...
C''est dans le charmant village de Cap-a;-l''Aigle, au coeur de la region de Charlevoix, que vous convie l''Auberge des Peupliers. Ambiance...
Situé au coeur de la ville de Québec, l'Auberge du Quartier est à seulement 15 minutes de marche du Vieux-Québec. Profitez d'une ambiance...
Membre de l'Hôtellerie Champêtre & Country Inns du Québec, label d'escapades gastronomique de renom, la Camarine est un charmant hôtel situé à...
L'hôtel Le Priori se dresse fièrement au coeur du Vieux-Port / Palais Royal. Tranquillité, une variété d'activités et beaucoup plus. Laissez-vous...
Le Sooke Harbour House est niché à côté de Whiffen Spit et situé à 45 minutes par la route panoramique de Victoria. Les 28 chambres disposent de...
L'atmosphère de notre auberge est détendu, décontracté et amical, et le service offert est utile et sans prétention. Beaucoup disent que...
C'est avec fierté et enthousiasme que nous vous accueillons à l'Hôtel Shaw Club & Spa, à Niagara-on-the-Lake, Ontario. Grâce à sa rénovation...
Situé entre les attractions célèbres, les musées, salles de concert, les restaurants et les parcs magnifiques, découvrez l'hôtel Abigails dans...
Perchée à 615 m d'altitude dans la réserve faunique de Matane, la première auberge de montagne dans l'est du Canada vous réserve toute une...
Embellie grâce au charme européen des caractéristiques architecturales, l'Auberge du Vieux-Port offre un accueil chaleureux aux touristes et aux...
Situé au cœur du pays du vin près de la ville de Victoria et à quelques minutes de The Butchart Gardens. L'architecture de Brentwood Bay Lodge and...
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 | 0 | ||
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 COUNT(DISTINCT(`Hotel`.`id`)) AS count FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `HotelI18n` ON (`Hotel`.`id` = `HotelI18n`.`foreign_key` AND `HotelI18n`.`model` = 'Hotel' AND `HotelI18n`.`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`.`country_id` = 'CA' AND `Hotel`.`published` = 1 | 1 | 1 | 6 | maybe slow | |
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`.`country_id` = 'CA' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 20 | 20 | 6 | 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 (991, 495, 1020, 549, 1015, 837, 988, 548, 1021, 1019, 1016, 1023, 992, 229, 534, 550, 1157, 1519, 987, 1105) | 185 | 185 | 1 | ||
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 (991, 495, 1020, 549, 1015, 837, 988, 548, 1021, 1019, 1016, 1023, 992, 229, 534, 550, 1157, 1519, 987, 1105) | 68 | 68 | 1 | ||
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (991, 495, 1020, 549, 1015, 837, 988, 548, 1021, 1019, 1016, 1023, 992, 229, 534, 550, 1157, 1519, 987, 1105) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (991, 495, 1020, 549, 1015, 837, 988, 548, 1021, 1019, 1016, 1023, 992, 229, 534, 550, 1157, 1519, 987, 1105) | 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 (991, 495, 1020, 549, 1015, 837, 988, 548, 1021, 1019, 1016, 1023, 992, 229, 534, 550, 1157, 1519, 987, 1105) | 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 (991, 495, 1020, 549, 1015, 837, 988, 548, 1021, 1019, 1016, 1023, 992, 229, 534, 550, 1157, 1519, 987, 1105) | 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 (991, 495, 1020, 549, 1015, 837, 988, 548, 1021, 1019, 1016, 1023, 992, 229, 534, 550, 1157, 1519, 987, 1105) | 40 | 40 | 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 (991, 495, 1020, 549, 1015, 837, 988, 548, 1021, 1019, 1016, 1023, 992, 229, 534, 550, 1157, 1519, 987, 1105) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 84 | 84 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'CA' ORDER BY `Country`.`name` ASC LIMIT 1 | 1 | 1 | 0 | ||
SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC | 256 | 256 | 0 | ||
SHOW FULL COLUMNS FROM `themes` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `theme_i18n` | 6 | 6 | 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 | 0 | ||
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 | 0 | ||
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 |
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 | 19,00 MB |
Total Request Time: 634 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 74,92 | |
Component initialization and startup | 4,73 | |
Controller action | 51,54 | |
Render Controller Action | 419,46 | |
» Rendering View | 418,01 | |
» » Rendering APP/views/hotels/index.ctp | 365,96 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1,31 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1,18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 2,82 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1,24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1,23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1,08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 0,99 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1,18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1,25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1,05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1,09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1,03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1,12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1,03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1,06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1,15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1,10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1,02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1,26 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1,09 | |
» » » Rendering APP/views/elements/paging.ctp | 0,94 | |
» » Rendering APP/views/layouts/default.ctp | 51,82 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0,09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1,57 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0,32 | |
» » » Rendering APP/views/elements/layout/header.ctp | 44,99 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0,13 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 3,95 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0,30 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0,08 |