Le bâtiment historique de l'hôtel, sous la protection du patrimoine, remonte à 1895 et a été entièrement rénové au printemps 2004. L'hôtel de...
L'hôtel Restaurant du Parc des Eaux-Vives est logé dans un bâtiment du 18ème siècle situé dans le magnifique Parc des Eaux-Vive et offre une vue...
Le luxe discret, une atmosphère intime et facile à vivre, l'élégance, cette adresse exclusive a la sensation d'une maison loin de la maison,...
Des vues imprenables sur la montagne et la vallée ensoleillée et les fenêtres panoramiques spectaculaires vous attendent à l'Hôtel Caprice, un...
La cathédrale Saint-Pierre, le Mur des Réformateurs, la fontaine, le jardin anglais. La découverte des merveilles culturelles de Genève commence...
L'hôtel Haus Paradies est situé à la sortie du village de Ftan, sans aucuns bâtiments voisins. Toutes les 24 chambres ont une vue imprenable sur...
Une ancienne maison de villageois aisés devenue auberge de jeunesse en 1900, puis dans l'euphorie de la Belle Epoque, l'hôtel Le TRALALA naît...
Un site idéal ? en pleine nature, au pied des pistes et à quelques pas du centre du village. Le CERVO est ouvert. L?hôtel est réalisé en deux...
Un concepteur et fabricant de voitures au début du siècle dernier, le baron Adrien de Turckheim participa à de nombreux rallyes. L'un d'eux l'a...
Sauna, hammam, solarium, ski sur les pistes de renommée mondiale de Crans-Montana ne sont pas les seuls plaisirs pour vous dans ce chalet...
Le Romantik Hotel JULEN, dont la tradition a presque 70 ans, propose des chambres de style rustique exclusif en bois d'épicéa. Le...
Immergez-vous dans l'expérience d'un hôtel innovant, au pied du Cervin. Niché dans le paysage incomparable alpin et le "Horu" (le nom local du...
Le Guarda Val est un hôtel unique en Maiensäss de 11 huttes et des granges qui ont plus de 300 ans. Situé à 1600 mètres d'altitude, dans le hameau...
Un petit joyau au coeur de la vieille ville qui rayonne ce charme incomparable du passé. Chaque chambre, personnalisée, est agencée avec un grand...
Hotel tres comfortable avec 18 chambres.
Le Lodge est un refuge de montagne, perché dans les Alpes suisses à Verbier, c'est un endroit parfait ouvert toute l'année pour s'échapper. Le...
La vallée de Saas-Fee également appelé la perle des Alpes. Et quelle est la perle de cette vallée ? le Waldhotel Fletschhorn, qui vient de fêter...
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` = '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` = '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` = 'CH' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 17 | 17 | 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 (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 | 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 (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 | 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 (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 | 1 | ||
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 | ||
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 24,00 MB
Message | Memory use |
---|---|
Component initialization | 14,00 MB |
Controller action start | 14,00 MB |
Controller render start | 16,00 MB |
View render complete | 19,00 MB |
Total Request Time: 612 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 76,33 | |
Component initialization and startup | 4,77 | |
Controller action | 51,12 | |
Render Controller Action | 409,73 | |
» Rendering View | 408,42 | |
» » Rendering APP/views/hotels/index.ctp | 356,59 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1,19 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1,21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1,02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1,06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1,10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1,09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1,07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1,13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1,07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1,29 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1,05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1,05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 2,26 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1,30 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 2,03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1,25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1,03 | |
» » » Rendering APP/views/elements/paging.ctp | 0,13 | |
» » Rendering APP/views/layouts/default.ctp | 51,62 | |
» » » 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,31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 44,68 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0,12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4,08 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0,32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0,08 |