The 23 room Albergo al Sole is located in the historical center of the medieval town of Asolo, at the top of the main square, with direct easy...
Just 6 kilometers from the centre of Pisa, the Bagni di Pisa is a converted eighteenth century palace once owned by the Grand Duke of Tuscany that...
Strong in an unmatched beauty, Lake Como reveals its charm gradually leading the guest from one wonder to another. Even before art took to...
Let yourself be wrapped by the magic atmosphere of this castle. Walk aside ancient roman walls and live a medieval experience. Stop and listen to...
With its graceful architecture, well-manicured tropical garden and sea water emerald pool looking out over the Portofino coast, the Grand Hotel...
King Farouk I of Egypt loved this hotel so much that he reserved a suite for an entire year. You will understand why he fell for it when you...
Originally an antique rural estate dating back to the XIII century, this distinguished hotel has been completely restored in a conservative style....
The only hotel in Rome to have its own ancient Roman ruins, The Inn at the Roman Forum has a fascinating Cryptoporticus, a 2,000-year-old stone...
Press a button and, like magic, the ceiling of your room will open. You can fall asleep contemplating the stars from your four-poster bed. This is...
The 5 Star L Ea Bianca Luxury Resort is nestled in a natural amphitheatre of rare beauty between the dark green juniper trees and the white rocks...
The former residence of Leopold II, Duke of Tuscany, has become a refined hotel and it features vineyards and olive trees used to make its own...
Originally an ancient fishery, the 5 star hotel La Peschiera has been converted into a resort with 7 deluxe rooms; 2 junior suites; 2 suites and 1...
The Style of Le Sirenuse hotel, an 18th century villa, is very unique. The Sersale family lives and entertains in the hotel and keeps it very much...
The 5 star Torre Maizza farm is located in the middle of a large hillside estate 2km from the coast overlooking the Mediterranean. The ancient...
Set imposingly on a rocky headland in the midst of a natural park, overlooking the splendid Bay of San Montano, with a breathtaking view of the...
Nestled at the foot of Mont Blanc, surrounded by the most awe-inspiring mountain peaks, Mont Blanc Hotel Village is a cluster of pretty wood and...
Situated on a clifftop 1000 feet above sea level, Palazzo Sasso majestically overlooks the famous Amalfi coastline. Picturesque fishing villages...
A former medieval castle and Papal villa full of priceless treasures, Relais La Suvera stands high on a hill, overlooking rolling Tuscan...
The hotel Sextantio Le grotte della Civita, encompasses 18 rooms, some of them of outstanding size, and a common area in a rock hewn church. The...
With two separate but nearby locations, hotel splendido and splendido mare offers the best of portofino. Guests staying at either location have...
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` = 'IT' 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` = 'IT' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 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 (1083, 927, 926, 812, 861, 386, 1024, 1144, 745, 1099, 1461, 1309, 1343, 468, 390, 462, 899, 896, 469, 1195) | 494 | 494 | 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 (1083, 927, 926, 812, 861, 386, 1024, 1144, 745, 1099, 1461, 1309, 1343, 468, 390, 462, 899, 896, 469, 1195) | 119 | 119 | 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 (1083, 927, 926, 812, 861, 386, 1024, 1144, 745, 1099, 1461, 1309, 1343, 468, 390, 462, 899, 896, 469, 1195) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1083, 927, 926, 812, 861, 386, 1024, 1144, 745, 1099, 1461, 1309, 1343, 468, 390, 462, 899, 896, 469, 1195) | 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 (1083, 927, 926, 812, 861, 386, 1024, 1144, 745, 1099, 1461, 1309, 1343, 468, 390, 462, 899, 896, 469, 1195) | 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 (1083, 927, 926, 812, 861, 386, 1024, 1144, 745, 1099, 1461, 1309, 1343, 468, 390, 462, 899, 896, 469, 1195) | 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 (1083, 927, 926, 812, 861, 386, 1024, 1144, 745, 1099, 1461, 1309, 1343, 468, 390, 462, 899, 896, 469, 1195) | 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 (1083, 927, 926, 812, 861, 386, 1024, 1144, 745, 1099, 1461, 1309, 1343, 468, 390, 462, 899, 896, 469, 1195) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 114 | 114 | 2 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'IT' 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 | ||
SHOW FULL COLUMNS FROM `promises` | 3 | 3 | 1 | maybe slow | |
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 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.79 MB
Message | Memory use |
---|---|
Component initialization | 14.21 MB |
Controller action start | 14.47 MB |
Controller render start | 16.62 MB |
View render complete | 20.47 MB |
Total Request Time: 325 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 62.80 | |
Component initialization and startup | 4.98 | |
Controller action | 64.20 | |
Render Controller Action | 113.44 | |
» Rendering View | 111.67 | |
» » Rendering APP/views/hotels/index.ctp | 57.84 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.29 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.19 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.28 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.00 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.36 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.20 | |
» » » Rendering APP/views/elements/paging.ctp | 2.18 | |
» » Rendering APP/views/layouts/default.ctp | 53.60 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.56 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.32 | |
» » » Rendering APP/views/elements/layout/header.ctp | 46.59 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.26 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |