Le Bjertorp Slott est situé sur la belle plaine de Vara, à 110 km au nord de Göteborg. Ferdinand Boberg, grand architecte de son temps, conçu le...
L'hôtel Birger Jarl se concentre sur le design suédois contemporain. Les chambres de l'hôtel et les suites ont été aménagées par plusieurs...
Bienvenue à l'hôtel Flora ! L'hôtel est situé au coeur du centre de Göteborg, avec restaurants, bars, rues commerçantes et cafés juste autour de...
Situé de manière unique au bord de l'eau à l'une des entrées du plus étonnant port au monde, se trouve l'élégant Hôtel J. L'inspiration classique...
Dans le centre de Stockholm, se trouve un élégant bâtiment du 19ème siècle dont la décoration intérieure est inspirée par l'artisanat suédois...
La Villa Kallhagen est un petit hôtel intime, avec son emplacement unique dans le parc de Djurgården Stockholm Royal, à seulement cinq minutes du...
L'Albert Kok Hotell est située sur un plateau avec une vue grandiose sur les chutes et la ville de Trollhättan. Le bâtiment principal date de 1865...
L'hôtel Baltzar est situé dans un bâtiment préservé du début du siècle avec beaucoup de charme. Les chambres sont équipées avec des meubles...
L'hôtel Akerblads et Gästgiveri est un hôtel familial et le plus ancien corps de ferme du village de Tällberg. Autrefois, les gens vivaient de...
Avant d'être un hôtel, ce bâtiment était appelé Hans Petter Farm, nommé d'après son propriétaire, le capitaine de marine et le gardien du phare de...
L'hôtel Gimo Herrgard est un manoir quatre étoiles construit dans les années 1760 .. récemment rénové pour accueillir des hôtes qui apprécient les...
Bienvenue au Grythyttan Inn, un hôtel vraiment unique à proximité de Orebro, en Suède. L'histoire dit que Oslo, Stockholm, Copenhague, et...
Il y a un certain nombre d'adjectifs qui pourraient être utilisés pour décrire l'hôtel Hellsten, conception, chic ou boutique hôtel ou encore les...
Karlaby Kro est situé dans le petit village Karlaby au milieu de Österlen dans le sud de la Suède. L'hôtel est entouré de champs et de son propre...
L'Hôtel Toftaholm est l'image d'un charmant manoir de style du milieu du 19ème siècle, avec des salons, une zone de réception, un bar et des...
Globe Secret est né de l'association de professionnels du tourisme, de l’hotellerie et du e-commerce. Les équipes de Globe Secret garantissent à ses utilisateurs une sélection rigoureuse d'hôtels de charme. Immatriculation d'agent de voyages n° IM075100403 - Garantie Financière : BPRP - Membre de l' - 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` = 'fre') 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` = 'fre') 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` = 'SE' 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` = 'fre') 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` = 'SE' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 15 | 15 | 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 (909, 422, 1206, 421, 1227, 1225, 1223, 800, 1229, 1226, 1224, 979, 828, 1181, 1228) | 136 | 136 | 0 | ||
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 (909, 422, 1206, 421, 1227, 1225, 1223, 800, 1229, 1226, 1224, 979, 828, 1181, 1228) | 58 | 58 | 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 (909, 422, 1206, 421, 1227, 1225, 1223, 800, 1229, 1226, 1224, 979, 828, 1181, 1228) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (909, 422, 1206, 421, 1227, 1225, 1223, 800, 1229, 1226, 1224, 979, 828, 1181, 1228) | 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 (909, 422, 1206, 421, 1227, 1225, 1223, 800, 1229, 1226, 1224, 979, 828, 1181, 1228) | 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 (909, 422, 1206, 421, 1227, 1225, 1223, 800, 1229, 1226, 1224, 979, 828, 1181, 1228) | 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 (909, 422, 1206, 421, 1227, 1225, 1223, 800, 1229, 1226, 1224, 979, 828, 1181, 1228) | 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 (909, 422, 1206, 421, 1227, 1225, 1223, 800, 1229, 1226, 1224, 979, 828, 1181, 1228) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 76 | 76 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'SE' 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` = 'fre') 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` = 'fre') 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 (22, 21, 25, 26, 4, 12, 14, 19, 9, 30, 3, 1, 13, 6, 24, 7, 18, 5, 10, 27, 2, 11, 29, 16, 15, 23, 17, 8, 28) | 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_fre` 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` = 'fre') 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` = 'fre') 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,00 MB
Message | Memory use |
---|---|
Component initialization | 14,00 MB |
Controller action start | 14,00 MB |
Controller render start | 15,00 MB |
View render complete | 19,00 MB |
Total Request Time: 308 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 77,10 | |
Component initialization and startup | 4,96 | |
Controller action | 49,47 | |
Render Controller Action | 99,85 | |
» Rendering View | 98,41 | |
» » Rendering APP/views/hotels/index.ctp | 46,41 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1,13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1,09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1,14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1,12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1,17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1,08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1,15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1,08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1,14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1,07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1,01 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1,13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1,09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1,22 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1,07 | |
» » » Rendering APP/views/elements/paging.ctp | 0,11 | |
» » Rendering APP/views/layouts/default.ctp | 51,80 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0,09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1,55 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0,30 | |
» » » Rendering APP/views/elements/layout/header.ctp | 45,05 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0,12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4,01 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0,30 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0,08 |