Aquapura Douro Valley promises a wonderful mix of history, great wines and the ultimate in wellbeing. Set on the sunny banks of the river,...
On the volcanic soil of Madeira, the pearl of the Atlantic, this former hunting lodge is a perfect example of the local tradition of "quintas",...
Choupana Hills Resort & Spa is a member of Design Hotels. Choupana Hills is the ideal place to experience a combination of luxury and unique...
Majestic and imposing, Hotel Infante Sagres is conveniently located within a few metres of Porto's most famous thoroughfare, the Avenida dos...
The first section of the Palácio was built in 1449, on the top of the ancient fortified Roman and Moorish walls, called "Cerca do Alcáçova" and...
Set on the slopes of the Serra da Esperança, at a kilometre from the town of Belmonte, the birthplace of Pedro Álvares de Cabral, the Pousada...
A castle, a convent and a palace.. built in different periods.. were the origin of this ecclesiastical architectural work of outstanding harmony....
The Quinta da Bela Vista was the first "Quinta" five star Madeira. This "mansion", dated 1844, transformed into an exclusive hotel in 1989, where...
Welcome to Romaneira - the quinta dos Sonhos - house of dreams in Portuguese. An estate which stretches over 400 hectares on the banks of the...
Quinta Vale d'Oliveira is orchestrated to complement the natural beauty. Arranged in landscaped gardens designed to preserve the flora, the...
This charming and intimate hotel was a 16th century olive oil mill for the neighboring convent. It is perfectly situated within the ancient walls...
A small 18th century palace restored in 2002. Its 29 rooms are well equipped, soundproofed, sunny and cheerful. Hotel facilities include a lounge,...
On one side an 18th century palace, on the other a most modern building, designed by one of Portugals most reputed architects, these houses are a...
Monte do Casal is considered as one of the most picturesque Luxury Boutique hotels in the Algarve. Nominated once again this year by WTA for...
The former cells of the monks have been transformed into bedrooms adding to the unique atmosphere of this historic building. The Pousada has been...
Lisbon's hotel with a unique history: former kitchens of the first Royal Palace, it has a history that stretches back eight centuries. Devastated...
At night, the cleverly located lanterns in the gardens light up fairylike routes around the swimming pool, ponds and palm trees. Under the stars...
This is a 16th century building refurbishing on 2003, located close to Janelas Verdes street, 5 min to railway station and between Lapa and Santos...
Situated in the historical and cultural town of Evora, Casa De S. Tiago is situated in an aristocratic house whose origins date back to the reign...
Enjoy the tranquillity of the beautiful Penha Park, the gardens and the interior corners with granite fountains and the cloisters. Discover at 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` = 'PT' AND `Hotel`.`published` = 1 | 1 | 1 | 5 | 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` = 'PT' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 20 | 20 | 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 (411, 1508, 405, 870, 410, 880, 935, 1241, 563, 1054, 1070, 408, 1352, 409, 874, 407, 1310, 406, 779, 865) | 346 | 346 | 2 | ||
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 (411, 1508, 405, 870, 410, 880, 935, 1241, 563, 1054, 1070, 408, 1352, 409, 874, 407, 1310, 406, 779, 865) | 65 | 65 | 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 (411, 1508, 405, 870, 410, 880, 935, 1241, 563, 1054, 1070, 408, 1352, 409, 874, 407, 1310, 406, 779, 865) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (411, 1508, 405, 870, 410, 880, 935, 1241, 563, 1054, 1070, 408, 1352, 409, 874, 407, 1310, 406, 779, 865) | 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 (411, 1508, 405, 870, 410, 880, 935, 1241, 563, 1054, 1070, 408, 1352, 409, 874, 407, 1310, 406, 779, 865) | 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 (411, 1508, 405, 870, 410, 880, 935, 1241, 563, 1054, 1070, 408, 1352, 409, 874, 407, 1310, 406, 779, 865) | 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 (411, 1508, 405, 870, 410, 880, 935, 1241, 563, 1054, 1070, 408, 1352, 409, 874, 407, 1310, 406, 779, 865) | 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 (411, 1508, 405, 870, 410, 880, 935, 1241, 563, 1054, 1070, 408, 1352, 409, 874, 407, 1310, 406, 779, 865) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 92 | 92 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'PT' 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 27.64 MB
Message | Memory use |
---|---|
Component initialization | 14.21 MB |
Controller action start | 14.47 MB |
Controller render start | 16.25 MB |
View render complete | 20.09 MB |
Total Request Time: 333 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 84.43 | |
Component initialization and startup | 3.07 | |
Controller action | 55.80 | |
Render Controller Action | 113.24 | |
» Rendering View | 112.00 | |
» » Rendering APP/views/hotels/index.ctp | 57.28 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.27 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.33 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.28 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.23 | |
» » » Rendering APP/views/elements/paging.ctp | 1.21 | |
» » Rendering APP/views/layouts/default.ctp | 54.52 | |
» » » 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 | 47.52 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.27 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |