For over four decades, the Byblos has been the reigning address in Saint-Tropez. Created as a Mediterranean village in the heart of...
The Chateau Les Crayeres a mythical address in the heart of Reims, nestled discretely in a 7 hectare park. But the Chateau Les Crayeres is also...
A historic hostelry with a fascinating heritage in the Burgundy wine capital of Beaune, Hotel Le Cep is a collection of 14th to 18th century...
Intimate seafront property enjoying a splendid location overlooking its own sandy beach in a paradise secluded cove, at the edge of the bay of...
In the heart of historical Montmartre nested in a secret passageway nicknamed Le passage du Rocher de la Sorciere the witch's rock passage a big...
Experience Paris in a rare gem set in a quiet street filled with art galleries, L'Hotel is a dramatic expression of Parisian panache with...
Sheltered behind a vast garden in the middle of the Provence La Benvengudo Bastide des Baux; you will find our 3 star hotel. We invite you to...
Period town house build on the remains of a medieval cardinal's palace, with superb 18th century interiors throughout, antique furniture and old...
Nestling on the hillside above Cannes with spectacular views of the foothills of the Alps, Le Mas Candille is one of these rare jewels. Its...
Nestled in a 6 hectare park, 5 minutes by car from the nice beaches of Saint Malo, the Chateau Hotel Du Colombier invites you to travel through...
In the heart of the Perigord Noir, cradle of humanity, gastronomic heartland redolent with history, overlooking the peaceful valley of the...
Right next to the Champs-Elysées and the rue du faubourg Saint-Honoré, feast your eyes upon the unique interiors of this hotel with its furniture...
When speaking of Megeve one name immediately comes to mind and echoes like the bells of the church square. The history of this particular hotel is...
In Menerbes, in the heart of the Luberon Natural Park between Gordes and Bonnieux lies a unique and enchanting place - La Bastide de Marie. This...
In 1967, Mrs. Sulitzer, the sister of the famous French writer, transformed this beautiful traditional mansion into a hotel. Quickly the MAS DE...
Nobody loves Marseilles more than the Passedat family. To love Marseilles means to love the Mediterranean, inseparable from the city just like...
A picturesque retreat surrounded by lakes and gardens, Les Etangs de Corot nestles in Ville d'Avray, a beautiful setting that has attracted...
Les Fermes de Marie is a complex of nine chalets in the heart of Megève. Constructed with materials from high mountain pasture chalets several...
In the middle of Chateau Smith Haut Lafitte vineyards near Bordeaux, sits Les Sources de Caudalie, the perfect wine-country escape. Nestled among...
Within walking distance to the ski lift at the Megeve ski resort Lodge Park is like a walk-in travel guide blending artefacts and souvenirs from...
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` = 'FR' 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` = 'FR' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 20 | 20 | 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 (354, 378, 591, 973, 716, 375, 554, 356, 366, 1044, 1077, 373, 365, 561, 353, 600, 362, 361, 1406, 360) | 321 | 321 | 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 (354, 378, 591, 973, 716, 375, 554, 356, 366, 1044, 1077, 373, 365, 561, 353, 600, 362, 361, 1406, 360) | 107 | 107 | 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 (354, 378, 591, 973, 716, 375, 554, 356, 366, 1044, 1077, 373, 365, 561, 353, 600, 362, 361, 1406, 360) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (354, 378, 591, 973, 716, 375, 554, 356, 366, 1044, 1077, 373, 365, 561, 353, 600, 362, 361, 1406, 360) | 1 | 1 | 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 (354, 378, 591, 973, 716, 375, 554, 356, 366, 1044, 1077, 373, 365, 561, 353, 600, 362, 361, 1406, 360) | 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 (354, 378, 591, 973, 716, 375, 554, 356, 366, 1044, 1077, 373, 365, 561, 353, 600, 362, 361, 1406, 360) | 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 (354, 378, 591, 973, 716, 375, 554, 356, 366, 1044, 1077, 373, 365, 561, 353, 600, 362, 361, 1406, 360) | 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 (354, 378, 591, 973, 716, 375, 554, 356, 366, 1044, 1077, 373, 365, 561, 353, 600, 362, 361, 1406, 360) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 104 | 104 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'FR' 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 28.57 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.46 MB |
Controller render start | 16.35 MB |
View render complete | 20.19 MB |
Total Request Time: 318 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 50.68 | |
Component initialization and startup | 4.14 | |
Controller action | 56.86 | |
Render Controller Action | 124.10 | |
» Rendering View | 122.71 | |
» » Rendering APP/views/hotels/index.ctp | 63.89 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.33 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.30 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.37 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.34 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.65 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.65 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.63 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.54 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.33 | |
» » » Rendering APP/views/elements/paging.ctp | 3.23 | |
» » Rendering APP/views/layouts/default.ctp | 58.58 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.61 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.33 | |
» » » Rendering APP/views/elements/layout/header.ctp | 51.09 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.19 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.43 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.34 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |