Crosby Street Hotel is a member of Firmdale Hotels. The hotel is situated in a quiet cobbled street in the heart of New York SoHo neighborhood...
Keswick hall is a 600 acre country estate located in the heart of Virginia hunt country, close to historic Charlottesville and only minutes from...
Kona Village features 125 spacious Hawaiian Bungalows spread across a 82-acre natural seaside oasis. Guestrooms offer a choice of picturesque...
An impressive 1818 Greek revival plantation mansion set in 26 acres of scented gardens, Monmouth Plantation is the epitome of southern splendour...
For over 80 years, the Ojai Valley Inn & Spa has captivated business and leisure guests with its breathtaking facilities and natural, unspoiled...
Soho House New York is a private members’ club and hotel in Manhattan’s Meatpacking District. Covering six floors, it is built over 45,000 square...
Three beautiful 1830 townhouses in a residential part of the French Quarter, Soniat House is New Orleans best-kept secret. It will be your refuge...
The hotel Fearrington House Inn and Restaurant is located in an elegant town in central North Carolina, surrounded by shops, gourmet restaurants,...
The Inn at Perry Cabin is ideally located in the quaint Victorian town of St. Michaels on Marylands scenic Eastern Shore just off Chesapeake bay....
The Little Nell is a mountain destination for all seasons located in Aspen Colorado, where the excitement of the city's most famous American who...
Reminiscent of an English manor at the end of the Saint Simons Island's historic Avenue of Oaks, The Lodge at Sea Island benefits from its...
Located on a quiet, tree-lined street off Madison Avenue, The Lowell is in the heart of New York's most exclusive and fashionable Upper East Side....
A peaceful hideaway in the Venice of America, The Pillars Hotel is an eclectic mix of British colonial and island plantation styling with gourmet...
Lavishly expressed and painstakingly constructed on the original site of William Avery Rockefeller's Camp Wonundra, The Point continues that...
Experience the exclusive ambiance, private setting, and unparalleled personal service that distinguish The Sherry-Netherland the landmark choice...
Wheatleigh is the perfect marriage of the grandeur of a 16th century Florentine palazzo with the elegance and comfort of the 21st century. Set on...
Your stay at this 42 acre historic estate offers the highest level of service from distinguished hospitality professionals who will anticipate and...
Traditional American hospitality, comfortable lodging, fresh food and honest value are the guiding principles behind the popular Apple Farm Inn....
Nestled on verdant acres with stately pines and California oak trees, surrounded by a vineyard and the Santa Lucia mountains rising majestically...
An iconic landmark on Miami's Ocean Drive, The Betsy offers exceptional cuisine, a rooftop solarium and spa with sweeping sea views. Behind white...
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 | 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 | 5 | 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 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 (232, 924, 1515, 518, 1403, 235, 1235, 1315, 1361, 1314, 1187, 237, 684, 485, 989, 238, 683, 1328, 516, 1234) | 350 | 350 | 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 (232, 924, 1515, 518, 1403, 235, 1235, 1315, 1361, 1314, 1187, 237, 684, 485, 989, 238, 683, 1328, 516, 1234) | 99 | 99 | 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 (232, 924, 1515, 518, 1403, 235, 1235, 1315, 1361, 1314, 1187, 237, 684, 485, 989, 238, 683, 1328, 516, 1234) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (232, 924, 1515, 518, 1403, 235, 1235, 1315, 1361, 1314, 1187, 237, 684, 485, 989, 238, 683, 1328, 516, 1234) | 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 (232, 924, 1515, 518, 1403, 235, 1235, 1315, 1361, 1314, 1187, 237, 684, 485, 989, 238, 683, 1328, 516, 1234) | 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 (232, 924, 1515, 518, 1403, 235, 1235, 1315, 1361, 1314, 1187, 237, 684, 485, 989, 238, 683, 1328, 516, 1234) | 1 | 1 | 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 (232, 924, 1515, 518, 1403, 235, 1235, 1315, 1361, 1314, 1187, 237, 684, 485, 989, 238, 683, 1328, 516, 1234) | 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 (232, 924, 1515, 518, 1403, 235, 1235, 1315, 1361, 1314, 1187, 237, 684, 485, 989, 238, 683, 1328, 516, 1234) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 119 | 119 | 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 | 1 | ||
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 | 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` = '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 | 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 |
Peak Memory Use 23.54 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.48 MB |
Controller render start | 16.39 MB |
View render complete | 20.24 MB |
Total Request Time: 656 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 85.52 | |
Component initialization and startup | 5.60 | |
Controller action | 64.06 | |
Render Controller Action | 426.61 | |
» Rendering View | 425.31 | |
» » Rendering APP/views/hotels/index.ctp | 355.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.31 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.27 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.11 | |
» » » 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.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 2.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.14 | |
» » » Rendering APP/views/elements/paging.ctp | 2.62 | |
» » Rendering APP/views/layouts/default.ctp | 69.85 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.59 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.32 | |
» » » Rendering APP/views/elements/layout/header.ctp | 60.06 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.27 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 6.45 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.49 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.12 |