Terraced on a hillside in Laguna Beach, California amid tropic gardens and flower splashed patios, this Laguna Beach hotel exudes an ambiance of...
Casa Sedona is a 16 room bed and breakfast inn on an acre of lush manicured gardens with Red Rock views including Sedonas highest red rock peak...
Set in sixteen hectares of grounds bordering the ocean, this magnificent resort is a romantic haven of well-being. Whether you are in your suite,...
A magnificent, turn-of-the-century castle with Norman towers and turrets overlooking the Hudson River, the Castle on the Hudson stands in 10 acres...
A luxury Chateau located just outside Yosemite National Park. Le Chateau du Sureau is a fairy tale that has received some of the highest ratings...
Cibolo Creek Ranch is the finest luxury hotel in West Texas and a historic Texas legacy. It is located on a 30 000 acre working cattle ranch in...
Clifton is one of Virginias most elegant intimate and historic property combining charm of a country inn with the top tier comfort and amenities...
The focal point of this 36 acre resort is the 15,000 square foot lodge offering an incredible great room with beamed cathedral ceilings, two story...
Experience a unique location at Dunton Hot Springs, situated in a restored 19th century ghost town located deep in the San Juan Mountains of...
Amidst the mystical beauty of Taos, New Mexico, El Monte Sagrado Living Resort and Spa offers a secluded sanctuary in harmony with the Earth....
The newly redesigned Equus Hotel an intimate boutique property makes its debut in Waikiki Beach. Originally named the Hawaii Polo Inn the new...
Paradise in the Wine Country - a Rural Sanctuary in the heart of Sonomas Russian River Valley. Near Santa Rosa - central to Sonoma, Napa,...
Located in the heart of historic downtown Newport with a stunning backdrop of the harbor this waterfront destination is close to Bellevue Avenues...
Located fifteen minutes from the Golden Gate Bridge and thirty minute from the wine country, the Inn is in the heart of beautiful Marin County. It...
Visit this reborn, 100 acre working farm and inn to experience sustainable agriculture in action. Chef Stephen Browning uses his passion for farm...
Nestled northwest of Pennsylvania, The Lodge at Glendorn is a real journey through time. Enter through the doors and winds along a creek to get to...
From first glimpse of its undulating green roof, the stylish sustainability of h2 hotel stands out. 36 eco-chic rooms with private patios or...
Originally hand built in the 1930s by cowboy artist Lon Megargee as his personal residence and studio it was originally known as Casa Hermosa...
The Hob Knob hotel is a mansion run by a family and built in 1937 as the first ski lodge in Stowe, the Hob Knob is now completely restored. All...
Located almost halfway between San Francisco and Los Angeles on scenic Highway 101, Hotel Cheval Paso Robles is situated just off the charming and...
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 | 1 | maybe slow | |
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` = '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` = 'US' 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` = 'US' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 60, 20 | 20 | 20 | 10 | 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 (1153, 1159, 578, 638, 682, 1304, 686, 901, 502, 1301, 842, 690, 1453, 1155, 1280, 1124, 1253, 677, 1237, 678) | 237 | 237 | 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 (1153, 1159, 578, 638, 682, 1304, 686, 901, 502, 1301, 842, 690, 1453, 1155, 1280, 1124, 1253, 677, 1237, 678) | 95 | 95 | 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 (1153, 1159, 578, 638, 682, 1304, 686, 901, 502, 1301, 842, 690, 1453, 1155, 1280, 1124, 1253, 677, 1237, 678) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1153, 1159, 578, 638, 682, 1304, 686, 901, 502, 1301, 842, 690, 1453, 1155, 1280, 1124, 1253, 677, 1237, 678) | 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 (1153, 1159, 578, 638, 682, 1304, 686, 901, 502, 1301, 842, 690, 1453, 1155, 1280, 1124, 1253, 677, 1237, 678) | 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 (1153, 1159, 578, 638, 682, 1304, 686, 901, 502, 1301, 842, 690, 1453, 1155, 1280, 1124, 1253, 677, 1237, 678) | 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 (1153, 1159, 578, 638, 682, 1304, 686, 901, 502, 1301, 842, 690, 1453, 1155, 1280, 1124, 1253, 677, 1237, 678) | 40 | 40 | 1 | ||
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 (1153, 1159, 578, 638, 682, 1304, 686, 901, 502, 1301, 842, 690, 1453, 1155, 1280, 1124, 1253, 677, 1237, 678) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 135 | 135 | 2 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'US' 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.68 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.48 MB |
Controller render start | 16.24 MB |
View render complete | 20.10 MB |
Total Request Time: 645 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 80.82 | |
Component initialization and startup | 4.22 | |
Controller action | 61.05 | |
Render Controller Action | 421.97 | |
» Rendering View | 420.51 | |
» » Rendering APP/views/hotels/index.ctp | 363.76 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.39 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 0.88 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.29 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.31 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.00 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 2.96 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 0.98 | |
» » » Rendering APP/views/elements/paging.ctp | 2.82 | |
» » Rendering APP/views/layouts/default.ctp | 56.49 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.64 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.33 | |
» » » Rendering APP/views/elements/layout/header.ctp | 49.01 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.22 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.35 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |