Above your bed is a blackboard covered in chalk-written algebraic formula. Did Einstein once sleep here. In another suite a chessboard painted on...
The city of North Adams formerly overlooked is revitalized with contemporary art. Our building was a dilapidated block, but solidly constructed,...
Located in the heart of Bethlehems historic Fountain Hill district, The Sayre Mansion offers all the amenities of a modern hotel with a blend of...
Miami Beach's most exceptional experience awaits at The Villa By Barton G., inside the former Versace Mansion, where unparalleled service and...
Welcome to the island of Nantucket and its tranquil harbours, endless stretches of beach, old manor houses and beautiful gardens; just fifty...
As a young boy, Jonathan Cartwright wanted to be a cyclist and win the Tour de France. But at the age of 15, he discovered cooking and became more...
The Willows hotel beckons the weary traveler to retreat from the windy city's frenetic pace of life. Lakeview neighborhood, the Willows evokes a...
Providing the charm and intimacy of a world class country inn and the exceptional service of a grand hotel, The Wort Hotel offers comfort and...
The Three Village Inn is located in the quaint and historical town of Stony Brook overlooking scenic Stony Brook harbor. Step into the Three...
In summer slip your boots into the stirrups don your cowboy hat and set off to explore the rugged scenery of Montana with its white water...
This property is a romantic getaway site. This is a romantic site and small children are not recommended. Breathtaking mountain views surround the...
Named to Travel Leisure Magazine's "500 Best Hotels in the World", Vintage Inn, a AAA Four Diamond Award property, is an intimate French...
The Virginia offers 24 intimate rooms in the main house and 5 spacious cottages along Jackson Street, the crowning glory of Cape May's historic...
At the heart of the beautiful region of New Jersey Skyland, the house now known as the Whistling Swan Inn was built in 1905 by Daniel Best for his...
Only 3 miles from Newton, 7 miles from Sparta, and 11 miles from Branchville, the Wooden Duck is here to meet your needs. Spacious guest rooms...
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 | 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 120, 20 | 15 | 15 | 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 (646, 1202, 1149, 514, 231, 680, 1199, 517, 1327, 634, 1146, 1485, 473, 1147, 1148) | 140 | 140 | 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 (646, 1202, 1149, 514, 231, 680, 1199, 517, 1327, 634, 1146, 1485, 473, 1147, 1148) | 71 | 71 | 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 (646, 1202, 1149, 514, 231, 680, 1199, 517, 1327, 634, 1146, 1485, 473, 1147, 1148) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (646, 1202, 1149, 514, 231, 680, 1199, 517, 1327, 634, 1146, 1485, 473, 1147, 1148) | 1 | 1 | 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 (646, 1202, 1149, 514, 231, 680, 1199, 517, 1327, 634, 1146, 1485, 473, 1147, 1148) | 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 (646, 1202, 1149, 514, 231, 680, 1199, 517, 1327, 634, 1146, 1485, 473, 1147, 1148) | 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 (646, 1202, 1149, 514, 231, 680, 1199, 517, 1327, 634, 1146, 1485, 473, 1147, 1148) | 30 | 30 | 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 (646, 1202, 1149, 514, 231, 680, 1199, 517, 1327, 634, 1146, 1485, 473, 1147, 1148) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 102 | 102 | 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 26.55 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.48 MB |
Controller render start | 15.92 MB |
View render complete | 19.76 MB |
Total Request Time: 316 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 74.30 | |
Component initialization and startup | 4.03 | |
Controller action | 52.97 | |
Render Controller Action | 105.55 | |
» Rendering View | 104.19 | |
» » Rendering APP/views/hotels/index.ctp | 50.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.26 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.26 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.22 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 0.98 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.33 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.52 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.46 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.01 | |
» » » Rendering APP/views/elements/paging.ctp | 2.59 | |
» » Rendering APP/views/layouts/default.ctp | 53.94 | |
» » » 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.31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 46.84 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.30 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.30 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |