The Bjertorp Slott is situated on the beautiful plain of Vara, 110 km north of Gothenburg. Ferdinand Boberg, architect of his time, designed the...
Hotel Birger Jarl's profile focuses on contemporary Swedish design. The hotel rooms and suites have been furnished by several prominent Swedish...
Welcome to Hotel Flora at Grönsakstorget 2, next to the moat. The hotel is located in the heart of central Göteborg with restaurants, bars,...
Situated uniquely by the waterside at one of the world's most stunning harbor entrances, is the elegant Hotel J. The inspiration by classic...
In the earth of Stockholm. Elegant 19th century building whose interior design is inspired by traditional swedish craftmanship. Everything the...
Villa Kallhagen is a small, intimate hotel with its unique location in Stockholm's Royal Djurgarden Park, only five minutes away from the city...
Albert Kok Hotell & Konferens has undergone a total transformation. You will find this transformation in the hotel rooms and dining rooms. You...
Hotel Baltzar is situated in a building from the turn of the century with much preserved from that era. The rooms are equipped with antique and...
The hotel Akerblads and Gästgiveri is a family hotel and the oldest farmhouse in the village of Tällberg. Formerly, people lived on agriculture...
Before it was turned into a hotel, the building was called the Hans Petter Farm, named after its owner, the sea captain and supervisor of...
Gimo Herrgard is a four star manor house hotel built in the 1760's .. recently refurbished and renovated to accommodate modern hotel guests who...
Welcome to Grythyttan Inn, a truly unique hotel near Orebro, Sweden. The story said that Oslo, Stockholm, Copenhagen and Grythyttan were the only...
There are a number of labels that could be used to describe Hotel Hellsten, Design, Hip or Boutique being three of them. The founder's firm...
Every weekend throughout the year, guests can enjoy gourmet menus and excellent wines, in charming surroundings. Activities include indoor...
The Hotel Toftaholm is the picture of a charming mid-19th century manor-house style.. with lounges.. reception area.. bar and dining rooms. The...
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` = '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` = '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` = '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 | ||
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.62 MB
Message | Memory use |
---|---|
Component initialization | 14.21 MB |
Controller action start | 14.46 MB |
Controller render start | 15.83 MB |
View render complete | 19.65 MB |
Total Request Time: 268 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 49.79 | |
Component initialization and startup | 3.20 | |
Controller action | 45.46 | |
Render Controller Action | 100.38 | |
» Rendering View | 99.16 | |
» » Rendering APP/views/hotels/index.ctp | 45.53 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 0.97 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.27 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.11 | |
» » » Rendering APP/views/elements/paging.ctp | 0.11 | |
» » Rendering APP/views/layouts/default.ctp | 53.43 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.08 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.54 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.30 | |
» » » Rendering APP/views/elements/layout/header.ctp | 46.46 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.24 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |