A little slice of heaven at the foot of the Montserrat Mountain, Can Bonastre is an exclusive wine resort surrounded by 250 acres of vineyards...
Set on a private headland, overlooking Mallorca's Bay of Palma, Cap Rocat is an impressive 19th century military fortress, now totally transformed...
El Palauet Living Barcelona is a member of Design Hotels. Located in Passeig de Gràcia, 113, the most emblematic avenue of Barcelona, in a listed...
The stunning setting of this luxurious former Andalusia palace with panoramic views over its private 1,000 acre estate enhances the uniqueness of...
Finca Cortesin Hotel Golf & Spa is a truly magnificent development situated just 1.5 kilometres from the sandy beaches of South of Spain, between...
"ElBullihotel is a wish, a different way to understand a hotel. It's hard to explain it with words. It's the beginning of a dream we had since...
Hospes las Casas del Rey de Baeza is a small charming boutique hotel in the center of Seville, all rooms individually decorated and located around...
Hospes Palace del Bailío, the first and only five star hotel in Cordoba is located in the historical heart of the city of the caliphate, which was...
Hospes Villa Paulita is a member of Design Hotels. A formerly art nouveau family mansion standing right by the Puigcerdà lake, Villa Paulita is...
Hotel Bagues is located on Barcelona s famous Les Rambles, in the heart of the city's Gothic Quarter and occupies the building that was the...
Villa Oniria is an intimate and elegant establishment housed in XIXth century mansion build around a beautiful courtyard graced with sound of...
La Pleta Hotel and Spa is an exclusive hotel located in a unique part of the world, with a wide range of activities conceived to relax your body...
The hotel La Residencia is tranquil and relaxing offering a first class yet friendly service and fantastic Mediterranean cuisine in a romantic...
In the heart of Emporda, just a few minutes from the beautiful beaches which account for the irresistible, famed charm of the Costa Brava, the Mas...
Imaginative and unusual, yet picturesque and alluring, Mas Passamaner is a tribute to 1920s modernist architecture set in pretty gardens and...
A totally unique and exclusive 5 star hotel with just 23 rooms. Situated at the foot of the Tramuntana mountains in the heart of the most...
The Gran Hotel Domine Bilbao, facing the Guggenheim Museum, is the Silken Hotels first five-star and the chain's pride. The hotel expresses a...
The tasteful 5 star Villa Vik offers a typical atmosphere. A lobby with a reception 24 hour front desk service bar parking lot safe internet...
Ayre Hotel Alfonso II has an Eclectic stylish, unique and architecturally inspired environment, carefully restored hotel, not far from the centre...
The tasteful 4 star Casa de Hilario offers a typical atmosphere. A lobby with a reception 24 hour front desk service parking lot safe and some...
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` = 'ES' 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` = 'ES' 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 (653, 642, 1058, 329, 755, 332, 334, 341, 640, 916, 958, 1252, 747, 652, 970, 337, 1391, 1466, 1102, 487) | 373 | 373 | 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 (653, 642, 1058, 329, 755, 332, 334, 341, 640, 916, 958, 1252, 747, 652, 970, 337, 1391, 1466, 1102, 487) | 57 | 57 | 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 (653, 642, 1058, 329, 755, 332, 334, 341, 640, 916, 958, 1252, 747, 652, 970, 337, 1391, 1466, 1102, 487) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (653, 642, 1058, 329, 755, 332, 334, 341, 640, 916, 958, 1252, 747, 652, 970, 337, 1391, 1466, 1102, 487) | 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 (653, 642, 1058, 329, 755, 332, 334, 341, 640, 916, 958, 1252, 747, 652, 970, 337, 1391, 1466, 1102, 487) | 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 (653, 642, 1058, 329, 755, 332, 334, 341, 640, 916, 958, 1252, 747, 652, 970, 337, 1391, 1466, 1102, 487) | 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 (653, 642, 1058, 329, 755, 332, 334, 341, 640, 916, 958, 1252, 747, 652, 970, 337, 1391, 1466, 1102, 487) | 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 (653, 642, 1058, 329, 755, 332, 334, 341, 640, 916, 958, 1252, 747, 652, 970, 337, 1391, 1466, 1102, 487) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 117 | 117 | 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 | ||
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 | ||
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.36 MB
Message | Memory use |
---|---|
Component initialization | 14.27 MB |
Controller action start | 14.45 MB |
Controller render start | 16.27 MB |
View render complete | 20.13 MB |
Total Request Time: 290 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 43.33 | |
Component initialization and startup | 3.02 | |
Controller action | 56.44 | |
Render Controller Action | 113.86 | |
» Rendering View | 112.44 | |
» » Rendering APP/views/hotels/index.ctp | 56.93 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.30 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.19 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.28 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.06 | |
» » » Rendering APP/views/elements/paging.ctp | 1.54 | |
» » Rendering APP/views/layouts/default.ctp | 55.31 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.58 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.33 | |
» » » Rendering APP/views/elements/layout/header.ctp | 48.03 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.14 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.41 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |