Schlosshotel im Grunewald is the most authentic historic luxury hotel in Berlin. Built in the very early 20th century as a private distinguished...
Schlosshotel Burg Schlitz, located in a spacious 180-hectare park, is one of the most splendid examples of 19th century German classicism. Hans...
Grand, comfortable and exclusive; the Steigenberger Frankfurter Hof, with its more than 130 years of history, is one of the best addresses in the...
A destination in its own right, Heidelberg Suites is set in a stunning turn-of-the-century property on the banks of the river. Inside,...
Just one drop of Bach is worth an entire cistern of other music, commented the Russian cellist, Rostropovich. The memory of Johann Sebastian Bach...
Schloss Hugenpoet remained in the ownership of the family Nesselrode Hugenpoet for nearly 200 years; in 1831, Baron Friedrich Leopold von...
A former castle built in 1889 by Empress Victoria, Schlosshotel Kronberg retains its authentic sense of history with a wealth of original...
Reminiscent of a 19th century palace, the decor here is distinctly regal with silk wallpaper, dark woods against a palette of golden beiges and...
The Villa Hammerschmiede has so many treats in store for you. The pleasure of relaxing in the rock swimming pool overlooking the park, The...
Surrounded by a large private park with mature trees, Wald and Schlosshotel Friedrichsruhe was once the palatial summer home and hunting lodge of...
The Gerbermühle Hotel is a member of Design Hotels. Primarily built as a flour mill in the 1520s, the Gerbermühle is, however, better known as the...
The Hotel Burg Wernberg owes its charms to the Middle Ages. With its walls dating back to the 12th century, it proudly stands on a hill with...
Reside in the former manor-house and be enchanted by the flair of yesteryear. The luxurious rooms of Ketschauer Hof offers a distinctive...
The 4 star Schlosshotel Burghaus Kronenburg dates back to the 18th century and was recently completely renovated. It features magnificent rooms...
To say anymore about Dusseldorf is difficult. There are so many places to be, so many attractions in architecture, art and shopping to see. You...
The friendly staff, an elegant interior, the lovely garden as well as numerous thoughtful details make the Admiral Hotel to one of the most...
In the heart of Munich, the H'Otello B01 (former Advokat) offers accommodation in style and minimalist design that has excellent transport links,...
Germanys gateway to the world. This is the name given to Hamburg, the birthplace of Brahms and Karl Lagerfeld, a romantic and chic metropolis with...
Neither the entrance hall nor the guest rooms are typical here in the La Maison, everything has been especially designed to ensure that our guests...
Country house sophistication on a family-run wine estate. Schwarzer Adler Estate Hotel lies in the heart of the Kaiserstuhl region. There are...
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 |
---|---|---|---|---|---|
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` = 'DE' 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` = 'DE' 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 (838, 1248, 309, 314, 1274, 312, 313, 1275, 1401, 1250, 308, 1249, 1251, 1096, 1097, 1091, 311, 310, 769, 942) | 421 | 421 | 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 (838, 1248, 309, 314, 1274, 312, 313, 1275, 1401, 1250, 308, 1249, 1251, 1096, 1097, 1091, 311, 310, 769, 942) | 76 | 76 | 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 (838, 1248, 309, 314, 1274, 312, 313, 1275, 1401, 1250, 308, 1249, 1251, 1096, 1097, 1091, 311, 310, 769, 942) | 4 | 4 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (838, 1248, 309, 314, 1274, 312, 313, 1275, 1401, 1250, 308, 1249, 1251, 1096, 1097, 1091, 311, 310, 769, 942) | 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 (838, 1248, 309, 314, 1274, 312, 313, 1275, 1401, 1250, 308, 1249, 1251, 1096, 1097, 1091, 311, 310, 769, 942) | 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 (838, 1248, 309, 314, 1274, 312, 313, 1275, 1401, 1250, 308, 1249, 1251, 1096, 1097, 1091, 311, 310, 769, 942) | 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 (838, 1248, 309, 314, 1274, 312, 313, 1275, 1401, 1250, 308, 1249, 1251, 1096, 1097, 1091, 311, 310, 769, 942) | 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 (838, 1248, 309, 314, 1274, 312, 313, 1275, 1401, 1250, 308, 1249, 1251, 1096, 1097, 1091, 311, 310, 769, 942) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 100 | 100 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'DE' 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 | ||
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 | ||
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 25.01 MB
Message | Memory use |
---|---|
Component initialization | 14.27 MB |
Controller action start | 14.45 MB |
Controller render start | 16.37 MB |
View render complete | 20.23 MB |
Total Request Time: 270 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 41.62 | |
Component initialization and startup | 2.77 | |
Controller action | 51.94 | |
Render Controller Action | 114.22 | |
» Rendering View | 112.95 | |
» » Rendering APP/views/hotels/index.ctp | 57.97 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.28 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.27 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.19 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.20 | |
» » » Rendering APP/views/elements/paging.ctp | 0.88 | |
» » Rendering APP/views/layouts/default.ctp | 54.78 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.08 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.55 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.32 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.72 | |
» » » 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.31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |