At the beginning of the last century, after falling under the spell of this bay ?at the ends of the earth?, the ship owner Sir John Ellerman...
Located in the heart of the hills of graceful picturesque fishing village of Hout Bay lies the Hout Bay Manor, a heritage listed building. Built...
Thanda, meaning 'love' in Zulu, is an expression of the union of Zulu culture, wildlife, romantic decadence and exclusivity. Safaris in open game...
Rising out of the indigenous Tsitsikamma forest istsala a seductive creation of timber, stone and glass. Exclusive and very private suites, each...
Kensington Place is situated on the slopes of Table Mountain, in the quiet, leafy suburb of Higgovale where you are close to the hottest spots,...
In the fertile valleys of the Cape Town hinterland, the Asara Wine Estate and Hotel invites you to a unique experience, a safari through the...
Bartholomeus Klip is a charming small hotel for only 16 guests on a working wheat and sheep farm just over an hour away from Cape Town – ideally...
To obtain an understanding of Africa you need to see it, touch it and really feel it. Because above all it is a living breathing land and a spirit...
Colona Castle is an elegant villa situated on the warm False Bay coast, a base of scenic grandeur from which to explore the interesting and...
Victorian House built in 1904 and refurbished in 2004. It offers 12 spacious rooms in a luxurious and comfortable environment. Set in a quaint...
Fairlawns is a very unique, privately owned property that has been in existence since 1997. Since then it has won several international awards and...
Boasting an exquisite location in the heart of the Cape Winelands, Grande Roche Hotel & Restaurant provides guests with unmatched service and...
Hunters is located in beautiful gardens on the estate offers rooms furnished with antique thatch with private patios, swimming pools. Superb...
Experience the intimate ambience of an aristocratic villa set in tranquil gardens. The serene beauty of Illyria House has always been an...
Cocooned in natures splendor Karkloof Spa is home to a lush and varied landscape. All around, wildlife abounds. Mastering the art of balance, the...
Garden Route is one of the most striking regions in South Africa with its lush greenery- flower-filled prairies- huge trees- and long white sandy...
Overlooking the great fish river, the lodge is master fully contoured to blend with the magnificient landscape. The decor is african inspired with...
Wine-tasting on horseback, watching movies in the comfort of a plush in-house cinema, innovative cooking classes, indulgent facials...This...
Explore the mysteries of the southern African trade routes at the foot of the great Waterberg Mountains crossing the mighty Limpopo River to view...
Charming Hotel Rutland Lodge is located in Cape Town, South Africa. This early 20th century residence, towering over the city centre of Cape Town,...
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` = 'ZA' 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` = 'ZA' 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 (1296, 1284, 631, 1286, 168, 1290, 503, 750, 1283, 176, 499, 1297, 175, 171, 1282, 174, 647, 169, 1287, 172) | 188 | 188 | 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 (1296, 1284, 631, 1286, 168, 1290, 503, 750, 1283, 176, 499, 1297, 175, 171, 1282, 174, 647, 169, 1287, 172) | 57 | 57 | 2 | ||
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (1296, 1284, 631, 1286, 168, 1290, 503, 750, 1283, 176, 499, 1297, 175, 171, 1282, 174, 647, 169, 1287, 172) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1296, 1284, 631, 1286, 168, 1290, 503, 750, 1283, 176, 499, 1297, 175, 171, 1282, 174, 647, 169, 1287, 172) | 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 (1296, 1284, 631, 1286, 168, 1290, 503, 750, 1283, 176, 499, 1297, 175, 171, 1282, 174, 647, 169, 1287, 172) | 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 (1296, 1284, 631, 1286, 168, 1290, 503, 750, 1283, 176, 499, 1297, 175, 171, 1282, 174, 647, 169, 1287, 172) | 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 (1296, 1284, 631, 1286, 168, 1290, 503, 750, 1283, 176, 499, 1297, 175, 171, 1282, 174, 647, 169, 1287, 172) | 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 (1296, 1284, 631, 1286, 168, 1290, 503, 750, 1283, 176, 499, 1297, 175, 171, 1282, 174, 647, 169, 1287, 172) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 108 | 108 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'ZA' 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 28.34 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.47 MB |
Controller render start | 16.02 MB |
View render complete | 19.86 MB |
Total Request Time: 291 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 42.79 | |
Component initialization and startup | 3.11 | |
Controller action | 48.69 | |
Render Controller Action | 115.90 | |
» Rendering View | 114.59 | |
» » Rendering APP/views/hotels/index.ctp | 59.86 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.26 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.23 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.35 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 0.99 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.29 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.28 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.31 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.17 | |
» » » Rendering APP/views/elements/paging.ctp | 0.94 | |
» » Rendering APP/views/layouts/default.ctp | 54.49 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.55 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.19 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.19 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.31 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |