A stay at Dunbrody Country House Hotel and Cookery School will stimulate more than just your taste buds. Georgian manor on the outside, explore...
Dublin's premier boutique hotel located in the heart of the city on the famous River Liffey. Owned by Bono & The Edge of Irish rock group U2, The...
Waterford Castle Hotel and Golf Resort is set in the grounds of a private 310-acre island only 3 miles from Waterford City and the world-renowned...
Located on 450 acre estate, Ballynahinch 4 star hotel is overlooking the famous Ballynahinch River. The original house is over two hundred years...
The last quarter mile to the Cahernane House Hotel is through a tunnel of greenery that frames its long private avenue, an approach that helps you...
Nestled on 1000 acres of undulating Irish countryside dotted with ancient woodland and glittering lakes; Castle Leslie Estate is one of the last...
This oasis of comfort is family owned and operated ensuring only the best in Guest Services and Satisfaction. Irish hospitality, good food from...
Beautifully appointed on a hillside overlooking the picturesque town of Westport, Co. Mayo, Knockranny House Hotel is an extremely luxurious...
Located on the banks of the River Moy, Mount Falcon is a stunning Baronial structure, designed and completed in 1876 by James Franklin Fuller. A...
A visionary, multi-cultural odyssey behind an elegant townhouse facade, La Stampa Hotel and Spa is unique and ultra chic. The restaurants are Thai...
Located at an exclusive Limerick address, overlooking the tree lined Peoples Park in Limericks historic Georgian quarter, this elegant Georgian...
A stunningly designed 39 bedroom Boutique Hotel situated on a cliff overlooking Ardmore Bay, the Cliff House Hotel features The House Restaurant,...
Set overlooking two stunning beaches with endless views of the ocean, Inchydoney Island Lodge and Spa is long renowned as Ireland's most exclusive...
If you are coming from Dublin on your way to this part of Ireland, you will pass through the magical countryside of Wicklow nestled between sea...
Built 200 years ago for the captain of the port, The Quay House is the oldest building in Clifden has been carefully restored and now offers...
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` = 'IE' 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` = 'IE' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 15 | 15 | 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 (846, 383, 1056, 1260, 1263, 1261, 850, 1067, 1262, 943, 1264, 847, 849, 848, 1184) | 160 | 160 | 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 (846, 383, 1056, 1260, 1263, 1261, 850, 1067, 1262, 943, 1264, 847, 849, 848, 1184) | 79 | 79 | 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 (846, 383, 1056, 1260, 1263, 1261, 850, 1067, 1262, 943, 1264, 847, 849, 848, 1184) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (846, 383, 1056, 1260, 1263, 1261, 850, 1067, 1262, 943, 1264, 847, 849, 848, 1184) | 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 (846, 383, 1056, 1260, 1263, 1261, 850, 1067, 1262, 943, 1264, 847, 849, 848, 1184) | 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 (846, 383, 1056, 1260, 1263, 1261, 850, 1067, 1262, 943, 1264, 847, 849, 848, 1184) | 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 (846, 383, 1056, 1260, 1263, 1261, 850, 1067, 1262, 943, 1264, 847, 849, 848, 1184) | 30 | 30 | 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 (846, 383, 1056, 1260, 1263, 1261, 850, 1067, 1262, 943, 1264, 847, 849, 848, 1184) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 79 | 79 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'IE' 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 25.97 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.47 MB |
Controller render start | 15.93 MB |
View render complete | 19.75 MB |
Total Request Time: 263 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 42.33 | |
Component initialization and startup | 3.23 | |
Controller action | 47.43 | |
Render Controller Action | 100.83 | |
» Rendering View | 99.69 | |
» » Rendering APP/views/hotels/index.ctp | 44.97 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.31 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 0.99 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.23 | |
» » » Rendering APP/views/elements/paging.ctp | 0.11 | |
» » Rendering APP/views/layouts/default.ctp | 54.53 | |
» » » 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.31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.43 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.13 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.35 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.30 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |