Superb sea views, modern art and tranquillity unite at Aegean Suites Hotel, an intimate, all-suite hotel, set on a hillside dotted with olive...
The Emelisse hotel is situated along the rugged shoreline of the emerald Ionian Sea. It sits in a spot of supreme serenity amongst acres of native...
Mykonos Theoxenia Hotel is one of the hotels in Greece inspired in the 60's. Built by the highly acclaimed architect Aris Konstantinidis, the...
Aetoma traditional hotel is situated in Nafplion, a city with a unique history and a magical aura about it. Hotel Aetoma, an 18th Century mansion,...
This Chania hotel, Casa Delfino Suites, is an elegant 17th Century Venetian mansion in the old Venetian harbor of Chania, Crete. It has been...
Perched on a cliff edge with spectacular sea views, Cosmopolitan Suites sits above Santorini's renowned volcano in Fira. This romantic retreat is...
The newly built Lagos Mare hotel in Naxos island, is an elegant A class boutique hotel with cubistic Cycladic architecture, comprised of 38...
The Magna Grecia Boutique is a small intimate hotel offering panoramic views of the Acropolis and is located in the prime central Plaka district....
Melenos Lindos sits in perfect harmony with the local village on a fortified outcrop of Rhodes. In a stunning position beneath the Temple of...
Pegasus Suites is a new luxurious complex of studios, suites and apartments decorated and furnished in Aegean Cycladic contemporary style and...
Andronis offer only 15 suites which are nestled on the Santorinian cliff above the sea, under the aesthetic guidance of the natural elements that...
For many years, upon entering the harbour of Hydra, the first thing one would notice were the bundles of sponges lying on the docks, waiting to be...
Completely renovated into a neoclassical style, Hotel Hera has now opened its doors and is ready to welcome its guests with the genuine warmth of...
Built in 1817 for Mohamed Ali Pacha the founder of modern Egypt, this jewel of the Orient displays its charms in the small Greek town of Kavala on...
A NEOCLASSIC MANSION-CAPTAINS HOUSE. A TRUE SAMPLE OF LUXURY AND CULTURE HASBEEN RENOVATED AND CONVERTED TO A LUXURY EXCLUSIVE HOTEL. AT THE...
The Marco Polo Mansion is a charming hotel situated in a 15th century building in the Turkish quarter of Rhodes, the capital of the largest island...
Nikos Takis Boutique Hotel is peacefully situated in the heart of Rhodes' Old Town, just steps from the Great Magistro's Palace. It offers stylish...
In a wetland Ahla in Andros, nature has created a place of beauty and unique biodiversity. It is in this place has been created ONAR, meeting...
Secluded within a private compound in the aristocratic old harbor, the Orloff Resort was developed around a renovated 19th century stone-built...
Amongst the best luxury suites in Greece, Zannos Melathron luxury accommodation in Santorini is not only an experience unto itself, but is...
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` = 'GR' AND `Hotel`.`published` = 1 | 1 | 1 | 9 | 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` = 'GR' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 20 | 20 | 10 | 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 (1207, 575, 576, 525, 1507, 1463, 1082, 380, 436, 1464, 1462, 546, 381, 744, 1511, 475, 1465, 1256, 917, 379) | 249 | 249 | 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 (1207, 575, 576, 525, 1507, 1463, 1082, 380, 436, 1464, 1462, 546, 381, 744, 1511, 475, 1465, 1256, 917, 379) | 97 | 97 | 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 (1207, 575, 576, 525, 1507, 1463, 1082, 380, 436, 1464, 1462, 546, 381, 744, 1511, 475, 1465, 1256, 917, 379) | 0 | 0 | 1 | maybe slow | |
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1207, 575, 576, 525, 1507, 1463, 1082, 380, 436, 1464, 1462, 546, 381, 744, 1511, 475, 1465, 1256, 917, 379) | 2 | 2 | 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 (1207, 575, 576, 525, 1507, 1463, 1082, 380, 436, 1464, 1462, 546, 381, 744, 1511, 475, 1465, 1256, 917, 379) | 1 | 1 | 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 (1207, 575, 576, 525, 1507, 1463, 1082, 380, 436, 1464, 1462, 546, 381, 744, 1511, 475, 1465, 1256, 917, 379) | 1 | 1 | 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 (1207, 575, 576, 525, 1507, 1463, 1082, 380, 436, 1464, 1462, 546, 381, 744, 1511, 475, 1465, 1256, 917, 379) | 40 | 40 | 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 (1207, 575, 576, 525, 1507, 1463, 1082, 380, 436, 1464, 1462, 546, 381, 744, 1511, 475, 1465, 1256, 917, 379) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 106 | 106 | 2 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'GR' 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 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 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` = '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 | ||
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` = '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 27.17 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.47 MB |
Controller render start | 16.24 MB |
View render complete | 20.08 MB |
Total Request Time: 417 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 87.01 | |
Component initialization and startup | 3.97 | |
Controller action | 80.86 | |
Render Controller Action | 137.65 | |
» Rendering View | 135.89 | |
» » Rendering APP/views/hotels/index.ctp | 74.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.69 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.53 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.33 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.00 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.26 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.30 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.56 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.53 | |
» » » Rendering APP/views/elements/paging.ctp | 0.31 | |
» » Rendering APP/views/layouts/default.ctp | 61.53 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.60 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.33 | |
» » » Rendering APP/views/elements/layout/header.ctp | 51.48 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.32 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 6.36 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.68 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.18 |