The Westover Inn was built in 1867 by William and Joseph Hutton. Westover's status was one of Ontario's most popular Inns is based on the historic...
Located on fashionable Robson Square, the Wedgewood is a superb address set in the heart of the cosmopolitan city of Vancouver. In 1984, Eleni...
Luxurious Inn situated between Montreal and Ottawa on the Rigaud mountain, the Auberge des Gallant features a restaurant and a spa. This 4-star...
The Lodge and beautifully appointed cabins are nestled in the trees along the rushing waters of the Kicking Horse River. Wood burning fireplaces...
A beautiful heritage home totally renovated and redecorated with an old world elegance along with contemporary chic style and the utmost...
The Edgewater is a stunning 12 room lakeside retreat in Whistler, B.C. on 45 acres of beautiful, private, forested land, only two miles North of...
Luxurious rooms, exceptional spa services and a gourmet restaurant are the key features in this contemporary downtown hotel siuated in the heart...
Hastings House Country Hotel will be closing for the winter season on 9th November 2008 and looking forward to welcoming guests again on 13th...
Situated within a 25-minute drive of Ottawa, the Wakefield Mill Inn & Spa offers the only accommodation within the natural beauty of the Gatineau...
Located in the charming village of Cap-a;-l'Aigle, in the heart of the Charlevoix region, the Auberge des Peupliers is waiting for you. Comfy...
Located in the heart of the city of Quebec, the Auberge du Quartier is only 15 minutes walk from Old Quebec. Enjoy a warm and cozy atmosphere in...
Member of the Quebec Resorts & Country Inns, label and renowned gourmet getaway, the Camarine is a lovely inn located nearby Mont-Sainte-Anne on...
Hotel Le Priori stands proudly in the heart of the Old Harbour/Palace Royale area, you'll have it all. Peacefulness, a variety of activities and...
The Sooke Harbour House nestled beside Whiffen Spit is located a scenic 45 minute drive from Victoria. The twenty eight guest rooms feature...
Located just a few blocks from the city centre this heritage inn has been renovated to offer style, comfort and value. Beautiful antique filled...
Located on the main street in Niagara on the Lake and directly across from the Shaw Festival Theatre/ this CAA/AAA 4 Diamond luxury hotel is...
Situated between famous downtown attractions, museums, concert halls, fine restaurants and stunning parks, discover Abigails Hotel in breathtaking...
Perched 615 meters above sea level in the Matane Wildlife Reserve, the first mountain lodge in Eastern Canada promises you an experience. At the...
Graced with European charm and architectural features, the Auberge du Vieux Port provides a warm welcome to tourists and business guests alike...
Located in the heart of wine country close to the city of Victoria and minutes from The Butchart Gardens. The West Coast architecture of Brentwood...
Globe Secret has been created from professional travelers, hospitality and e-business. Globe Secret team guarantee our users a high selection of boutique hotels. Travel agent register n° IM075100403 - Financial guarantee : BPRP - Member of - 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 | 1 | maybe slow | |
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` = 'eng') 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` = 'eng') 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 | 8 | 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` = 'eng') 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 | 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 (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 | 2 | ||
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` = 'eng') 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` = 'eng') 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 (19, 5, 6, 24, 8, 25, 4, 10, 12, 7, 9, 22, 30, 14, 26, 21, 3, 1, 13, 27, 18, 11, 28, 29, 16, 15, 23, 2, 17) | 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` 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` = 'eng') 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` = 'eng') 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 26.82 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.48 MB |
Controller render start | 16.04 MB |
View render complete | 19.89 MB |
Total Request Time: 692 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 92.81 | |
Component initialization and startup | 5.60 | |
Controller action | 74.53 | |
Render Controller Action | 430.44 | |
» Rendering View | 428.36 | |
» » Rendering APP/views/hotels/index.ctp | 372.59 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.33 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 2.30 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.32 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.19 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.30 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.07 | |
» » » Rendering APP/views/elements/paging.ctp | 0.95 | |
» » Rendering APP/views/layouts/default.ctp | 55.52 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.10 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.62 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.35 | |
» » » Rendering APP/views/elements/layout/header.ctp | 48.16 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.13 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.43 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |