Nestled between the longest unspoiled stretch of rainforest in Australia and the Great Barrier Reef, Bloomfield Lodge is a wonderfully secluded,...
Chateau Yering Historic House Hotel a restored Victorian mansion surrounded by beautiful Heritage Listed trees is located in theheart of the Yarra...
A small contemporary luxury 5 star hotel located in the business district of Sydney and within easy walking distance of many major attractions....
Comfort and life's simple pleasures is the emphasis at Kims Beach Hideaway where stylish beach, rainforest and hillside bungalows, delectable...
Lake House lies on the shores of beautiful lake Daylesford. 33 rooms and suites nestle amongst six acres of manicured gardens, waterfalls and...
Elegant and Relaxing from the moment you arrive at Meadowlake Lodge you know that you have arrived at somewhere very special. This lovely property...
A beacon of sophistication in the Barossa Valley, The Louise is an idyllic vineyard retreat in the heart of Shiraz country with breathtaking...
Thorngrove Manor Hotel boasts unique creative architecture with captivating style and contemporary influence. Guests enjoy total privacy with...
Located on Australia's great dividing range, in the heart of the Blue Mountains World Heritage Area, a scenic three-hour drive from Sydney, Wolgan...
Lindenderry Country House is situated on 30 acres of stunning manicured gardens and vineyard. The 40 luxurious and spacious guest rooms are...
Paradise Bay Eco Escape is one of Australia's most unique and environmentally sustainable resorts, located in the beautiful Whitsunday Islands,...
The Hatton's 20 spacious rooms cater for business and leisure travellers who appreciate quality inner city accommodation with personal service and...
For a wonderful splurge of guilt free Hedonism, the only option is Paperbark Camp. Paperbark Camp is placed thoughtfully amongst the soaring...
Nestled in the heart of Hunter wine country Peppers Guest House brims with old style country charm and affability and beguiles with a low long...
A "Treasure Island" extraordinary contrasts, with rugged volcanic peaks, lush forests, the surf and tranquil lagoon, Lord Howe Island is encircled...
Via Ayers Rock, situated on a secluded sand dune close to the border of the dual World Heritage listed Uluru-Kata Tjuta National Park, Longitude...
Award winning indulgent options on the edge of Tasmanian wilderness dollops of style on the edge of one of the worlds last truly wild landscapes....
The Elandra Mission Beach is a boutique resort which houses 55 creatively designed rooms. It is nestled in amongst lush tropical rainforest...
Situated in the heart of Australia s famous Hunter Valley wine region north of Sydney, Tower Lodge is just waiting to be discovered and enjoyed....
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 | 1 | ||
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` = 'AU' 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` = 'AU' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 19 | 19 | 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 (664, 666, 624, 707, 1161, 708, 668, 665, 630, 710, 663, 661, 662, 1232, 1168, 431, 667, 709, 659) | 250 | 250 | 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 (664, 666, 624, 707, 1161, 708, 668, 665, 630, 710, 663, 661, 662, 1232, 1168, 431, 667, 709, 659) | 67 | 67 | 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 (664, 666, 624, 707, 1161, 708, 668, 665, 630, 710, 663, 661, 662, 1232, 1168, 431, 667, 709, 659) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (664, 666, 624, 707, 1161, 708, 668, 665, 630, 710, 663, 661, 662, 1232, 1168, 431, 667, 709, 659) | 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 (664, 666, 624, 707, 1161, 708, 668, 665, 630, 710, 663, 661, 662, 1232, 1168, 431, 667, 709, 659) | 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 (664, 666, 624, 707, 1161, 708, 668, 665, 630, 710, 663, 661, 662, 1232, 1168, 431, 667, 709, 659) | 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 (664, 666, 624, 707, 1161, 708, 668, 665, 630, 710, 663, 661, 662, 1232, 1168, 431, 667, 709, 659) | 38 | 38 | 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 (664, 666, 624, 707, 1161, 708, 668, 665, 630, 710, 663, 661, 662, 1232, 1168, 431, 667, 709, 659) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 109 | 109 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'AU' 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.67 MB
Message | Memory use |
---|---|
Component initialization | 14.21 MB |
Controller action start | 14.46 MB |
Controller render start | 16.13 MB |
View render complete | 19.96 MB |
Total Request Time: 401 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 155.46 | |
Component initialization and startup | 3.55 | |
Controller action | 54.12 | |
Render Controller Action | 110.41 | |
» Rendering View | 109.23 | |
» » Rendering APP/views/hotels/index.ctp | 54.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.27 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.05 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 0.88 | |
» » » Rendering APP/views/elements/paging.ctp | 0.11 | |
» » Rendering APP/views/layouts/default.ctp | 55.00 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.08 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.56 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.30 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.86 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.37 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.35 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |