Choose either the the luxurious waterfront inn or the off-site extended stay condos for your stay. The spectacular waterfront inn location has...
Unique architecture blends into its natural surroundings complemented with interior earth tones, high sweeping arches and skylights. In a...
Rittenhouse 1715 is located on a quiet street in the heart of Philadelphia. With 23 rooms we are known for our attention to detail and friendly...
The luxurious Santa Ynez Inn delivers a unique hotel experience with Victorian grace and warm hospitality nestled in the heart of Santa Barbara...
Come experience the beautiful and romantic Shore House at Lake Tahoe. We are located in Tahoe Vista, CA in the center of the North Shore of Lake...
In the adventure capital of the south-west, Sorrel River Ranch Resort rests in 160 acres of green pastures on the Colorado River, surrounded by...
The St. James Hotel is the South's Only Remaining Antebellum Riverfront Hotel. Plantation owners, Union Soldiers, and the notorious, Frank and...
This gracious stone and wood lodge is set in a beautiful mountain valley, surrounded by a ponderosa forest. Grace Coolidge Creek winds through the...
Enjoy beautiful rooms and suites with fireplaces and sumptuous decor, in the award-winning, eco-friendly environment of Stonehurst Place. Then, to...
The Sundy House, the home of the first Mayor of Delray Beach, Florida was built in 1902. The Sundy House is now known as the *Best Kept Secret* in...
Sunset Beach is a relaxing hideaway on secluded Shelter Island. The exquisite 20 room seasonal hotel has a charming restaurant and bar where you...
As a National Historical Landmark and one of the most distinctive resort hotels in North America, The Ahwahnee is well known for its great granite...
Prime Downtown Aspen Location, five-minute walk to anywhere in town. All rooms are professionally decorated and contain 20-inch flat panel TV's...
Step back in time at The Chanler at Cliff Walk, a stunning historic mansion located on the famous Cliff Walk in Newport, Rhode Island. Boasting 20...
Welcome to the historic Cliff House at Pikes Peak, voted one of Colorado's most romantic hotels, nestled at the foot of majestic Pikes Peak in...
The Greenwich Hotel is located in one of New York's most desirable neighborhoods, at the corner of Greenwich Street and North Moore Street in...
Situated in the picturesque South Carolina Lowcountry along the beautiful May River, The Inn at Palmetto Bluff Resort is the embodiment of all...
The second oldest town in the US, Santa Fe is still very much influenced by its Indian and Spanish heritage. It possesses that true Pueblo, charm...
The Mayflower Inn and Spa is located in the idyllic town of Washington Connecticut less than 2 hours from New York City. At this New England...
Escape from the everyday and indulge your senses at The Ocean House, the quintessential Victorian seaside hotel. From the simple yet sumptuous...
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 100, 20 | 20 | 20 | 11 | 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 (1323, 512, 959, 1154, 1158, 568, 1292, 1128, 1236, 274, 513, 1127, 526, 1311, 689, 234, 1510, 676, 230, 1308) | 241 | 241 | 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 (1323, 512, 959, 1154, 1158, 568, 1292, 1128, 1236, 274, 513, 1127, 526, 1311, 689, 234, 1510, 676, 230, 1308) | 101 | 101 | 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 (1323, 512, 959, 1154, 1158, 568, 1292, 1128, 1236, 274, 513, 1127, 526, 1311, 689, 234, 1510, 676, 230, 1308) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1323, 512, 959, 1154, 1158, 568, 1292, 1128, 1236, 274, 513, 1127, 526, 1311, 689, 234, 1510, 676, 230, 1308) | 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 (1323, 512, 959, 1154, 1158, 568, 1292, 1128, 1236, 274, 513, 1127, 526, 1311, 689, 234, 1510, 676, 230, 1308) | 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 (1323, 512, 959, 1154, 1158, 568, 1292, 1128, 1236, 274, 513, 1127, 526, 1311, 689, 234, 1510, 676, 230, 1308) | 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 (1323, 512, 959, 1154, 1158, 568, 1292, 1128, 1236, 274, 513, 1127, 526, 1311, 689, 234, 1510, 676, 230, 1308) | 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 (1323, 512, 959, 1154, 1158, 568, 1292, 1128, 1236, 274, 513, 1127, 526, 1311, 689, 234, 1510, 676, 230, 1308) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 99 | 99 | 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 23.65 MB
Message | Memory use |
---|---|
Component initialization | 14.24 MB |
Controller action start | 14.49 MB |
Controller render start | 16.24 MB |
View render complete | 20.08 MB |
Total Request Time: 326 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 83.93 | |
Component initialization and startup | 5.88 | |
Controller action | 59.48 | |
Render Controller Action | 115.84 | |
» Rendering View | 114.67 | |
» » Rendering APP/views/hotels/index.ctp | 60.43 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.22 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.01 | |
» » » Rendering APP/views/elements/paging.ctp | 2.82 | |
» » Rendering APP/views/layouts/default.ctp | 54.02 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.58 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 46.82 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.36 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |