Founded in 1852 by Delmonicos master chef, Louis Fauchere and run by his descendants until closing in 1976, the hotels extraordinary culinary...
At the end of the Hana Highway, on the lush eastern coast of Maui, is the legendary Hotel Hana-Maui and Honua Spa, where tranquility is a way of...
The Havana Hotel is a elegant 27-room boutique hotel that sits on San Antonios historic Riverwalk. Built in 1914, its Mediterranean Revival...
In 1839, travelers' first sight as they crossed the Mississippi River into Dubuque was a hotel building on the corner of 2nd and Main. This old...
Hotel Renew, Honolulus only true designer boutique hotel, is an intimate gateway located just steps to Waikiki Beach. This exquisite hotel offers...
Hotel Saint Cecilia is a secluded estate in Austins South Congress District. Named in honor of the patron saint of music and poetry these...
Hotel San Jose is located south of Congress Avenue just blocks where the Colorado River through downtown Austin. Behind the stucco walls in the...
The Inn of the Spanish Garden is Santa Barbaras only luxury boutique hotel conveniently located Downtown. The hotel has a European feel and offers...
The Inn has twelve luxurious guestrooms and is located on the main body of Lake Granbury and is within a short walk to the downtown square for...
The Kendall Hotel in Boston offers 73 guest rooms and 4 luxury one-bedroom suites decorated in a classic American decor with reproduction...
It was in front of the stunning scenery of Big Sur that Henry Miller said that he learnt to pray. To take the time to meditate in front of the...
The La Farge Perry House, circa 1860, was the former home of the American artist John La Farge and his wife, Margaret Perry La Farge, niece of...
The Lake Placid Lodge is a beautifully handcrafted Lodge nestled in the Adirondack Mountains, situated on the shores of Lake Placid. The new Main...
In this part of California- the Mars family has created a European style hotel that will immerse you in extreme elegance- with Louis XV marquetry...
Private luxury resort with 30 bedroom suites. All accommodations surround the perimeter of the Little Palm island and have water views. We have a...
Lookout Point uniquely merges the privacy and spaciousness of a luxury boutique hotel with the comprehesive pampering and tranquility of a bed and...
Built back in 1900, the Goodall Wooten House is now home to Austin's premier luxury boutique hotel and restaurant. An architectural treasure in...
Welcome to the Marquesa, the best boutique hotel in Key West and its famous restaurant near Duval Street. Located in the heart of historic Old...
Escape to Milliken Creek Inn and Spa an elegant Napa hotel in California esteemed wine country. Hidden away on three verdant acres overlooking the...
Nestled in 10 acres of pines at the tip of Southport Island, the Newagen Seaside Inn is a friendly, relaxed recalling a bygone era. Newly...
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 | 1 | ||
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` = '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 | 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` = '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 80, 20 | 20 | 20 | 7 | 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 (1503, 543, 1191, 323, 841, 945, 1141, 511, 1152, 1279, 773, 1365, 693, 648, 691, 1145, 1150, 1233, 687, 1278) | 239 | 239 | 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 (1503, 543, 1191, 323, 841, 945, 1141, 511, 1152, 1279, 773, 1365, 693, 648, 691, 1145, 1150, 1233, 687, 1278) | 96 | 96 | 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 (1503, 543, 1191, 323, 841, 945, 1141, 511, 1152, 1279, 773, 1365, 693, 648, 691, 1145, 1150, 1233, 687, 1278) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1503, 543, 1191, 323, 841, 945, 1141, 511, 1152, 1279, 773, 1365, 693, 648, 691, 1145, 1150, 1233, 687, 1278) | 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 (1503, 543, 1191, 323, 841, 945, 1141, 511, 1152, 1279, 773, 1365, 693, 648, 691, 1145, 1150, 1233, 687, 1278) | 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 (1503, 543, 1191, 323, 841, 945, 1141, 511, 1152, 1279, 773, 1365, 693, 648, 691, 1145, 1150, 1233, 687, 1278) | 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 (1503, 543, 1191, 323, 841, 945, 1141, 511, 1152, 1279, 773, 1365, 693, 648, 691, 1145, 1150, 1233, 687, 1278) | 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 (1503, 543, 1191, 323, 841, 945, 1141, 511, 1152, 1279, 773, 1365, 693, 648, 691, 1145, 1150, 1233, 687, 1278) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 117 | 117 | 1 | ||
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 27.22 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.48 MB |
Controller render start | 16.23 MB |
View render complete | 20.09 MB |
Total Request Time: 328 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 74.89 | |
Component initialization and startup | 4.17 | |
Controller action | 54.09 | |
Render Controller Action | 114.80 | |
» Rendering View | 113.42 | |
» » Rendering APP/views/hotels/index.ctp | 59.45 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.52 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.19 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 0.91 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.15 | |
» » » Rendering APP/views/elements/paging.ctp | 2.79 | |
» » Rendering APP/views/layouts/default.ctp | 53.77 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.56 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 46.76 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.27 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.30 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |