Charming hotel in downtown Madrid. The hotel is placed at the second floor of this protected building that dates back to the end of the 18th...
The tasteful 4 star Casona de Yaiza Hotel offers a typical atmosphere. A lobby with a reception 24 hour front desk service bar parking lot safe...
Duquesa de Cardona is a XVI century residence completely rebuilt for top level boutique hotel use. The Four Star Hotel Duquesa de Cardona...
Sitting amongst beautiful gardens on the Alicante coast, El Rodat Hotel is set in a quiet location, within easy reach of the beaches and town of...
The Hotel Dalt Murada is a restored manor house that retains all the character of the original building. Its superb location, in the old city of...
A new concept of Boutique Hotel has arrived in Barcelona in 2008. Murmuri Barcelona is getting ready to surprise you, please you and serve you. A...
Situated in Villabuena de Alava in the Rioja Alavesa, Hotel Viura is perfect as a base for discovering La Rioja. Only 20 minutes away from Logrono...
Neri Hotel & Restaurant is a member of Design Hotels. Neri Hotel & Restaurant is located in a small 18th century palace, completely renovated and...
A magnificent 18th century palace in the heart of Pamplona. Palacio Guendulain is one of the most prominent buildings in Pamplona, located in the...
Reminiscent of a Tuscan villa, surrounded by landscaped gardens, this 32 roomed hotel is a new addition to our Madrid hotels. it is a relaxing...
Having been restored and renovated with the utmost care, this manor house dating from the 17th century has been converted into an hotel where...
Located in the heart of Madrid, at 200 meters from Gran Via and close to museums, coolest city restaurants and shops Abalu emerges as the ultimate...
Casona d'Alevia is located close to the square of the Alevia village. The delightful establishment was build up on XV century when it was a...
When you arrive at the hotel, you may sense that life has suddenly become much easier. You can stop worrying about your car and luggage: the...
Renaissance Palace was built in 1503 and located in the Albaycin district, in front of the Alhambra and close to the historical area of the city....
A small hotel situated in the centre of Seville, opposite the church of Santa Catalina. It is a typical nineteenth-century Seville...
Originally the residence of the first Marquis of Santillana, Don Íñigo López de Mendoza. Today it is a charming, luxury five star hotel with an...
Refurbished houses built as a hotel. They are diferent spaces, full of conforts. Combinate of a old and new furniture, and country side with city...
The recently opened Hotel Catedral, in the Catedral square, is the first hotel with charm in Almería. It is a 4 stars superior warm establishment...
Find refuge in an oasis that has had every single detail designed to assure the perfect rest. Nestled in the ample plains of the Spanish...
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 `i18n` | 6 | 6 | 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 `favorites` | 8 | 8 | 0 | ||
SHOW FULL COLUMNS FROM `hotel_i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `configs` | 3 | 3 | 0 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | 1 | 1 | 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` = 'ES' 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` = 'ES' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20, 20 | 20 | 20 | 7 | 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 (347, 552, 902, 1079, 340, 344, 823, 345, 1104, 955, 1517, 330, 954, 335, 342, 333, 785, 915, 1080, 328) | 211 | 211 | 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 (347, 552, 902, 1079, 340, 344, 823, 345, 1104, 955, 1517, 330, 954, 335, 342, 333, 785, 915, 1080, 328) | 38 | 38 | 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 (347, 552, 902, 1079, 340, 344, 823, 345, 1104, 955, 1517, 330, 954, 335, 342, 333, 785, 915, 1080, 328) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (347, 552, 902, 1079, 340, 344, 823, 345, 1104, 955, 1517, 330, 954, 335, 342, 333, 785, 915, 1080, 328) | 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 (347, 552, 902, 1079, 340, 344, 823, 345, 1104, 955, 1517, 330, 954, 335, 342, 333, 785, 915, 1080, 328) | 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 (347, 552, 902, 1079, 340, 344, 823, 345, 1104, 955, 1517, 330, 954, 335, 342, 333, 785, 915, 1080, 328) | 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 (347, 552, 902, 1079, 340, 344, 823, 345, 1104, 955, 1517, 330, 954, 335, 342, 333, 785, 915, 1080, 328) | 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 (347, 552, 902, 1079, 340, 344, 823, 345, 1104, 955, 1517, 330, 954, 335, 342, 333, 785, 915, 1080, 328) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 64 | 64 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'ES' 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 | 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 25.36 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.49 MB |
Controller render start | 15.97 MB |
View render complete | 19.81 MB |
Total Request Time: 40512 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 68.38 | |
Component initialization and startup | 5.36 | |
Controller action | 68.97 | |
Render Controller Action | 40290.25 | |
» Rendering View | 40288.84 | |
» » Rendering APP/views/hotels/index.ctp | 40231.84 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.00 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 10004.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 2.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.73 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.46 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.60 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.59 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.74 | |
» » » Rendering APP/views/elements/paging.ctp | 2.65 | |
» » Rendering APP/views/layouts/default.ctp | 56.74 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/top.ctp | 2.18 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.43 | |
» » » Rendering APP/views/elements/layout/header.ctp | 48.61 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.18 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.34 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.33 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |