The striking colonial architecture of the Convento do Carmo blends with graceful furniture and works of art, taking guests back to a more...
A magnificent, privately owned stud and working ranch in the heart of the Brazilian countryside with 17 elegant suites. Haras Larissa provides the...
Kenoa Exclusive Beach Spa & Resort is a member of Design Hotels. Imagine a private sanctuary of tranquility and balance where the smallest of...
It is impossible to think of the historical center of Paraty without mentioning Pousada do Sandi or Sandi's Lodge. Located in one of the most...
Priviliged location and a 23.000 area of native vegetation like palm trees/ caju trees and hibiscus. Pousada Estrela d'Agua is located in the...
Txai Itacare is located in a coconut plantation of approximately 247 104 acres by the heavenly beach of Itacarezinho 48 km north of Ilheus and 15...
All is very unique at ZANK. From the reception area located in a colonial style house from the early parts of the 20th century to the brand new...
Member of the selected group Roteiros de Charme Hotel Association, the Canto das Águas Hotel is located in the Historical Centre of Lençois, at...
Located in Jericoacroara on the northeastern coast of Brazil in the state of Ceara. The panoramic Mosquito Blue Jeri is the perfect place for...
Located only 25 miles (40 km) from the state capital of Florianópolis, the district of Governador Celso Ramos is a region immersed in history and...
The Porto Bay Glezhaus is a delicate inn with 14 Suites with approximately 60m2, each one with a personalized decoration.
Located in a beautiful corner of Búzios called "Ponta da Lagoinha" near Ferradura Beach, Pedra da Laguna offers top quality hotel services in a...
Casa Cairuçu takes its name from its spectacular location. A few steps from the calm, protected waters of Paraty Bay, the house is located inside...
Fazenda Catuçaba is a true rural idyll situated amongst the rolling hills in the countryside 30 minutes from the historical town of São Luiz do...
Old colonial fazenda in the heart of the historic part of Rio and now the latest 5 star boutique hotel of the city, the Hotel Santa Teresa...
Buzios is the favored retreat of the Carioca bourgeoisie for relaxation and water sport. The property is a terraced building facing west; ideal...
"La Maison" is an exceptional guest house run by a French fan of Brazil. In a refined decor and unique to Rio, "La Maison" offers a new hosting...
Bahia, the most African of Brazilian cities, beats to the rhythm of his ancestors. At 8 hours of Europe, its beaches bewitching dance. And at the...
Member of the prestigious Roteiros de Charme Hotel Association Manary is an exclusive hotel located on the sands of beautiful Ponta Negra beach....
Pestana Angra Beach Bungalows is a hotel well-equipped, integrated with the Atlantic forest, rich in fauna and flora and with an excellent...
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` = 'BR' 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` = 'BR' 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 (757, 940, 655, 758, 528, 241, 1013, 930, 790, 243, 1454, 1012, 1383, 1451, 698, 491, 567, 1488, 1014, 791) | 527 | 527 | 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 (757, 940, 655, 758, 528, 241, 1013, 930, 790, 243, 1454, 1012, 1383, 1451, 698, 491, 567, 1488, 1014, 791) | 62 | 62 | 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 (757, 940, 655, 758, 528, 241, 1013, 930, 790, 243, 1454, 1012, 1383, 1451, 698, 491, 567, 1488, 1014, 791) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (757, 940, 655, 758, 528, 241, 1013, 930, 790, 243, 1454, 1012, 1383, 1451, 698, 491, 567, 1488, 1014, 791) | 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 (757, 940, 655, 758, 528, 241, 1013, 930, 790, 243, 1454, 1012, 1383, 1451, 698, 491, 567, 1488, 1014, 791) | 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 (757, 940, 655, 758, 528, 241, 1013, 930, 790, 243, 1454, 1012, 1383, 1451, 698, 491, 567, 1488, 1014, 791) | 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 (757, 940, 655, 758, 528, 241, 1013, 930, 790, 243, 1454, 1012, 1383, 1451, 698, 491, 567, 1488, 1014, 791) | 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 (757, 940, 655, 758, 528, 241, 1013, 930, 790, 243, 1454, 1012, 1383, 1451, 698, 491, 567, 1488, 1014, 791) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 148 | 148 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'BR' 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.08 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.46 MB |
Controller render start | 16.54 MB |
View render complete | 20.39 MB |
Total Request Time: 40390 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 50.87 | |
Component initialization and startup | 3.21 | |
Controller action | 55.86 | |
Render Controller Action | 40178.55 | |
» Rendering View | 40177.17 | |
» » Rendering APP/views/hotels/index.ctp | 40103.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.35 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.01 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 0.99 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 10007.48 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 2.29 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 2.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.63 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.58 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.38 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.54 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.55 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.58 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.48 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.60 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.64 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 2.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.74 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.67 | |
» » » Rendering APP/views/elements/paging.ctp | 0.97 | |
» » Rendering APP/views/layouts/default.ctp | 73.82 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.64 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 64.35 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.29 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 6.04 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.47 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.11 |