Blakes Hotel London is a seductive design journey through India, China, Indonesia, Thailand, Cambodia and on to the Pyramids, back through Italy...
Cameron House is a gracious 18th century baronial mansion located on the peaceful southern shores of Loch Lomond looking across its shimmering...
Cowley Manor is a 30 room luxury boutique property set within 55 acres of glorious Cotswold countryside, amongst natural springs, lakes and...
Number Sixteen is a stylish garden townhouse in the heart of South Kensington. Part of the Firmdale Hotels Group owned by Tim and Kit Kemp. Tim...
Prestonfield is the most talked-about hotel in Scotland and was recently awarded the ultimate rating of 5 AA Red Stars to become the only hotel of...
The 5 star Guest Accommodation Miller of Mansfield is an acclaimed Boutique Hotel offering the most amazing modern British food both in the...
Bodysgallen Hall & Spa is located in the heart of 200 acres of parkland and beautiful walled gardens. A magnificent view can admire the mountains...
A luxury country house with a unique story: built in 1630 and opened as a hotel in 1996 by the creator of the British design label, Mulberry....
Contemporary design and hi-tech gadgetry lie behind the elegant Regency facade of Cotswold House Hotel set in a tranquil Gloucestershire village...
Culloden House dates back to 1788 and sits on the original site of Culloden Castle which played host to Bonnie Prince Charlie at the Battle of...
A sensational setting and fantastic food are the main attractions at Holbeck Ghyll Country House Hotel, a charming Victorian former hunting lodge...
Homewood Park Member of Von Essen Hotels a private collection of individual country houses in the UK- Scotland and France. Homewood Park is a very...
It is in a sumptuous manor, just outside of Oxford that the chef Raymond Blanc displays his sensory universe. For him, if the work itself is...
First built in 1408, and belonging to Robert the Bruce until he gifted the castle at that point to the Erskine family for their help in...
Although it has gone through a remarkable transition over the years, this delightful castle hotel still bears much testimony to the golden age of...
Sitting resplendent in 44 acres of lush meadowland, Thainstone House Hotel has been designed to provide the ultimate in wedding hospitality. In...
Situated just a short walk from the magnificent Minster medieval walls and city centre shops this privately owned Regency townhouse is well...
Welcome to Toravaig House Hotel and Restaurant on the beautiful Scottish Isle of Skye; the ultimate romantic retreat on this paradise island. Set...
The Bank Hotel occupies the prime location in Edinburgh city centre, located at the centre of the Royal mile and only two minutes walk from...
Dormy House aims to be a home-away-from-home and with its cozy rooms, mouth-watering cuisine, postcard pretty landscape and above all, unstuffy...
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 | 1 | maybe slow | |
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 | 1 | ||
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 | 1 | maybe slow | |
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` = 'GB' AND `Hotel`.`published` = 1 | 1 | 1 | 7 | 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` = 'GB' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 20 | 20 | 6 | 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 (1348, 1388, 1271, 315, 971, 1269, 929, 1390, 824, 1346, 1393, 1398, 317, 603, 519, 604, 1395, 608, 496, 1276) | 263 | 263 | 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 (1348, 1388, 1271, 315, 971, 1269, 929, 1390, 824, 1346, 1393, 1398, 317, 603, 519, 604, 1395, 608, 496, 1276) | 91 | 91 | 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 (1348, 1388, 1271, 315, 971, 1269, 929, 1390, 824, 1346, 1393, 1398, 317, 603, 519, 604, 1395, 608, 496, 1276) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1348, 1388, 1271, 315, 971, 1269, 929, 1390, 824, 1346, 1393, 1398, 317, 603, 519, 604, 1395, 608, 496, 1276) | 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 (1348, 1388, 1271, 315, 971, 1269, 929, 1390, 824, 1346, 1393, 1398, 317, 603, 519, 604, 1395, 608, 496, 1276) | 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 (1348, 1388, 1271, 315, 971, 1269, 929, 1390, 824, 1346, 1393, 1398, 317, 603, 519, 604, 1395, 608, 496, 1276) | 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 (1348, 1388, 1271, 315, 971, 1269, 929, 1390, 824, 1346, 1393, 1398, 317, 603, 519, 604, 1395, 608, 496, 1276) | 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 (1348, 1388, 1271, 315, 971, 1269, 929, 1390, 824, 1346, 1393, 1398, 317, 603, 519, 604, 1395, 608, 496, 1276) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 94 | 94 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'GB' 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 | 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 28.34 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.48 MB |
Controller render start | 16.25 MB |
View render complete | 20.10 MB |
Total Request Time: 352 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 82.50 | |
Component initialization and startup | 5.52 | |
Controller action | 61.25 | |
Render Controller Action | 115.77 | |
» Rendering View | 114.35 | |
» » Rendering APP/views/hotels/index.ctp | 59.63 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.34 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.43 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.00 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.33 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.19 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.22 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.22 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.19 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.28 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.09 | |
» » » Rendering APP/views/elements/paging.ctp | 1.23 | |
» » Rendering APP/views/layouts/default.ctp | 54.53 | |
» » » 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 | 47.39 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.35 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.34 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |