Nature at its best in one of the world's most exotic settings. Los Cauquenes is an imposing resort and spa facing the beaches of Beagle Channel...
The journey begins at Tunquelen port. This is the first contact the traveler has with the mysterious and impressive Lake Nahuel Huapi. The lake...
Patagonian style Boutique Hotel/Lodge with similar services to a 5 stars hotel. 20 differently decorated exclusive rooms. Gourmet restaurant with...
Situated in the Irya jungle - only 10 km from Argentinean Falls and in perfect harmony with its ecosystem - La Cantera has 24 rooms spread...
Mansion Dandi Royal is located in San Telmo neighbourhood. San Telmo is Tangos birthplace. A superb Mansion, built to the eclectic architectural...
Algodon Mansion Hotel is located in a historic building in 1912 and shaped in a classic French design that has been impeccably restored. Each of...
Of all the Wine Routes in the world- the one that runs through Mendoza is one of the most charming- due to the beauty of the landscape and the...
Club Tapiz is located in a residence built in 1890 and surrounded by 10 hectares of Mendozas finest vineyards. Due to its location on the Wine...
At the heart of the Argentinean pampas, Stephanie and Raoul Fenestraz welcome you to a hacienda that plunges you into the heart of the superb...
The Manantial Del Silencio hotel meaning the Source of SiIence opened in 2001 is a small luxury hotel in Pumamarca, a charming village in the...
Eolo is a unique place that embodies the spirit of Patagonia, its indigenous roots, the personal experiences of the first European and Criollo...
Estancia Las Carreras is located in one of Tucumans most spectacular settings- surrounded by imposing peaks and abundant wildlife. Just 12 km from...
Located in northern Patagonia, the Estancia is an eco-lodge on a mountain location of 250 acres in the Lake District and the Nahuel Huapi National...
Al pie del Nevado de Cachi, La Merced del Alto se destaca sobre el pintoresco valle rodeado de cerros, rios y arroyos. Dominando desde lo alto,...
Hotel del Casco is a luxurious Neoclassical Palazzo built in 1892 that enjoys a privileged location in San Isidro's historical district, the most...
A magic spirit reigns at the foot of the Andes mountain range. Legend has it that a spell was cast over the town of Salta, which means the beauty...
La Alondra is a residence for travelers of this time. A magic and unique place, simple and noble, situated at the heart of Corrientes Argentina in...
La Becasina Delta Lodge is an exclusive luxury resort in central Parana Delta area. Thought for rest, private overnight stops or exclusive work...
Our "casona" is a space that combines comfort and simplicity in a natural and healthy environment. The hotel consists of 10 rooms, point that...
Patagonia is the last inhabitable land before the South Pole and continues to fascinate all of those who come here. And Las Balsas is undoubtedly...
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 |
---|---|---|---|---|---|
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 `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 `hotel_i18n` | 6 | 6 | 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` = '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` = 'AR' 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` = 'AR' 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 (694, 1432, 1433, 764, 763, 1415, 753, 635, 738, 1436, 1255, 560, 1306, 544, 240, 442, 641, 1471, 964, 627) | 170 | 170 | 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 (694, 1432, 1433, 764, 763, 1415, 753, 635, 738, 1436, 1255, 560, 1306, 544, 240, 442, 641, 1471, 964, 627) | 61 | 61 | 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 (694, 1432, 1433, 764, 763, 1415, 753, 635, 738, 1436, 1255, 560, 1306, 544, 240, 442, 641, 1471, 964, 627) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (694, 1432, 1433, 764, 763, 1415, 753, 635, 738, 1436, 1255, 560, 1306, 544, 240, 442, 641, 1471, 964, 627) | 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 (694, 1432, 1433, 764, 763, 1415, 753, 635, 738, 1436, 1255, 560, 1306, 544, 240, 442, 641, 1471, 964, 627) | 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 (694, 1432, 1433, 764, 763, 1415, 753, 635, 738, 1436, 1255, 560, 1306, 544, 240, 442, 641, 1471, 964, 627) | 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 (694, 1432, 1433, 764, 763, 1415, 753, 635, 738, 1436, 1255, 560, 1306, 544, 240, 442, 641, 1471, 964, 627) | 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 (694, 1432, 1433, 764, 763, 1415, 753, 635, 738, 1436, 1255, 560, 1306, 544, 240, 442, 641, 1471, 964, 627) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 108 | 108 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'AR' 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` = '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 | 3 | ||
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 | 1 | maybe slow | |
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.38 MB
Message | Memory use |
---|---|
Component initialization | 14.30 MB |
Controller action start | 14.47 MB |
Controller render start | 16.02 MB |
View render complete | 19.88 MB |
Total Request Time: 366 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 59.60 | |
Component initialization and startup | 2.88 | |
Controller action | 63.29 | |
Render Controller Action | 153.29 | |
» Rendering View | 151.43 | |
» » Rendering APP/views/hotels/index.ctp | 86.79 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.87 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.58 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.91 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.79 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.55 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.67 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.62 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.47 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.62 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.61 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.37 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.70 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.79 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.78 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.52 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.70 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.70 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.72 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.54 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.68 | |
» » » Rendering APP/views/elements/paging.ctp | 1.19 | |
» » Rendering APP/views/layouts/default.ctp | 64.40 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.11 | |
» » » Rendering APP/views/elements/layout/top.ctp | 2.11 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.42 | |
» » » Rendering APP/views/elements/layout/header.ctp | 56.56 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.37 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |