Commercial boulevard starbucks ilaria kolke boticas fasa morman and taylor atm machine carati. The restaurant perroquet offers gourmet and...
Located in the heart of the Incan Capital of Cusco. The hotel overlooks Plazoleta Nazarenas and is two blocks from the Main Square Plaza de Armas....
Located right within the boundaries of ancient Machu Picchu ruins with views to the unique Huayna Picchu Mountain and the Urubamba river where you...
Titilaka - a modern lodge on the shores of the Lake Titicaca offers a luxurious refuge from which to explore the treasured natural, cultural and...
A solar-powered eco-lodge on remote and uniquely beautiful isla Suasi. The only private island in massive lake Titicaca. Featuring panoramic lake...
The monument known as the "Casa de Cartagena and Santa Cruz de Cuzco" was acquired in July 2006 by an Italian company. The restoration of the...
Inkaterra, one of the first Spanish buildings in the town is located in the heart of the historic centre of Cusco, on Plaza Las Nazarenas. It is...
Inkaterra Machu Picchu Pueblo Hotel a select boutique nature hotel lets you experience life at an exclusive royal Inca retreat for you stay. You...
Las Casitas del Colca is Peru's hidden gem, a collection of luxurious cottage villas with a fabulous spa, set in the peace and serenity of the...
Mountain Lodges of Peru (MLP) offers "The cream of the adventure": the opportunity to live in the heart of the adventure in the realm of comfort!...
Inkaterra Reserva Amazonica, a simple elegant ecological lodge, graces the banks of Peru's Madre de Dios River. The lodge, composed of 34...
In the heart of the Sacred Valley, between green fields and towering mountains, is nestled hotel Rio Sagrado. Located on the banks of the Urubamba...
The Tambopata Research Center is a comfortable 18 bedroom lodge situated by one of the world's largest Macaw Claylicks on the uninhabited frontier...
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` = 'PE' 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` = 'PE' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 13 | 13 | 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 (1131, 739, 740, 523, 1382, 919, 920, 742, 741, 1448, 743, 918, 1447) | 219 | 219 | 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 (1131, 739, 740, 523, 1382, 919, 920, 742, 741, 1448, 743, 918, 1447) | 46 | 46 | 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 (1131, 739, 740, 523, 1382, 919, 920, 742, 741, 1448, 743, 918, 1447) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1131, 739, 740, 523, 1382, 919, 920, 742, 741, 1448, 743, 918, 1447) | 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 (1131, 739, 740, 523, 1382, 919, 920, 742, 741, 1448, 743, 918, 1447) | 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 (1131, 739, 740, 523, 1382, 919, 920, 742, 741, 1448, 743, 918, 1447) | 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 (1131, 739, 740, 523, 1382, 919, 920, 742, 741, 1448, 743, 918, 1447) | 26 | 26 | 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 (1131, 739, 740, 523, 1382, 919, 920, 742, 741, 1448, 743, 918, 1447) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 45 | 45 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'PE' 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 26.53 MB
Message | Memory use |
---|---|
Component initialization | 14.21 MB |
Controller action start | 14.46 MB |
Controller render start | 15.90 MB |
View render complete | 19.71 MB |
Total Request Time: 261 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 41.60 | |
Component initialization and startup | 3.06 | |
Controller action | 47.96 | |
Render Controller Action | 97.74 | |
» Rendering View | 96.57 | |
» » Rendering APP/views/hotels/index.ctp | 43.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.22 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.30 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.32 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.23 | |
» » » Rendering APP/views/elements/paging.ctp | 0.11 | |
» » Rendering APP/views/layouts/default.ctp | 53.21 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.08 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.53 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.30 | |
» » » Rendering APP/views/elements/layout/header.ctp | 46.26 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.23 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |