The historic hotel building, under heritage protection, dates back to 1895 and was completely refurbished in Spring 2004. The 5-star boutique...
The Restaurant Hotel du Parc des Eaux-Vives is housed in a historical 18th century building located within the beautiful Parc des Eaux-Vive and...
Discreet luxury, intimate atmosphere and easy-going elegance, this exclusive address has the feel of a home away from home, ideally situated in...
Stunning mountain and valley views from sun-kissed terraces and dramatic picture windows await you at Hotel Caprice, a Swiss-chalet boutique...
The Saint Pierre Cathedral, the Reformation Wall, the fountain, the English garden. The discovery of Genevas cultural wonders begins with a...
THE HOTEL HAUS PARADIES IS LOCATED AT THE EXIT OF THE VILLAGE FTAN, WITH NO NEIGHBORING BUILDINGS.ALL 24 ROOMS HAVE A BREATHTAKING VIEW OVER THE...
A former home of wealthy villagers become youth hostel in 1900, and in the euphoria of the Belle Epoque, Le TRALALA born in the old town of...
Dream situation - in natural surroundings, beside the slopes and close to the village centre. CERVO opened. The hotel is being carried out in two...
A designer and manufacturer of cars at the beginning of the last century, Baron Adrien de Turckheim took part in numerous rallies. One of them...
Sauna, hammam, solarium, skiing on the world-renowned slopes of the Crans-Montana is not the only pleasure in store for you at this chalet...
Family traditions, luxury and l'art d'hositalite on an international level have graciously been offered for almost 70 years by the JULEN Family....
Experience innovative design at our hotel Matthiol! Our two chalets are constucted out of wood and stone and combine modern as well as traditional...
The Guarda Val is a unique Maiensäss hotel in 11 huts and barns that are up to 300 years old. Located 1600 metres above sea level in the hamlet of...
An oasis of charm and hospitality snuggled in the picturesque old town of Lucerne. Each room is individually and beautifully decorated with a...
The Lodge is a stunning mountain retreat, perched high in the Swiss Alps in Verbier, is a perfect year-round escape. The 13 friendly and...
The Saas-Fee valley also called the pearl of the Alps. And what is the pearl of this valley? The Fletschhorn Waldhotel which has just celebrated...
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 | 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 | 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` = 'CH' 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` = 'CH' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 17 | 17 | 7 | 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 (1092, 1095, 423, 944, 537, 845, 1094, 1205, 1212, 1093, 1399, 1086, 1425, 1424, 1426, 1369, 1213) | 180 | 180 | 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 (1092, 1095, 423, 944, 537, 845, 1094, 1205, 1212, 1093, 1399, 1086, 1425, 1424, 1426, 1369, 1213) | 77 | 77 | 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 (1092, 1095, 423, 944, 537, 845, 1094, 1205, 1212, 1093, 1399, 1086, 1425, 1424, 1426, 1369, 1213) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1092, 1095, 423, 944, 537, 845, 1094, 1205, 1212, 1093, 1399, 1086, 1425, 1424, 1426, 1369, 1213) | 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 (1092, 1095, 423, 944, 537, 845, 1094, 1205, 1212, 1093, 1399, 1086, 1425, 1424, 1426, 1369, 1213) | 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 (1092, 1095, 423, 944, 537, 845, 1094, 1205, 1212, 1093, 1399, 1086, 1425, 1424, 1426, 1369, 1213) | 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 (1092, 1095, 423, 944, 537, 845, 1094, 1205, 1212, 1093, 1399, 1086, 1425, 1424, 1426, 1369, 1213) | 34 | 34 | 1 | ||
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 (1092, 1095, 423, 944, 537, 845, 1094, 1205, 1212, 1093, 1399, 1086, 1425, 1424, 1426, 1369, 1213) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 72 | 72 | 2 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'CH' 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 | 5 | ||
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 23.77 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.46 MB |
Controller render start | 15.98 MB |
View render complete | 19.81 MB |
Total Request Time: 588 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 51.17 | |
Component initialization and startup | 5.18 | |
Controller action | 59.90 | |
Render Controller Action | 412.49 | |
» Rendering View | 411.27 | |
» » Rendering APP/views/hotels/index.ctp | 356.83 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.31 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 2.55 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.34 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 2.03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.01 | |
» » » Rendering APP/views/elements/paging.ctp | 0.12 | |
» » Rendering APP/views/layouts/default.ctp | 54.22 | |
» » » 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.33 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.03 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.32 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |