Just twenty minutes from Marrakech airport and ten minutes from the city centre, Amanjena rests with the high Atlas Mountains in the background...
Dar Rhizlane remains prestigious Hivernage, an address, a moment whose flavor bordering on the enjoyment of a princely piece of tranquility. Set...
Kasbah Agafay is now only available to rent on an Exclusive basis and is the ideal luxury venue for private holidays, family gatherings, weddings...
Everywhere the whispering water sings to you of the gentleness of this location where an irrigation system supports the herb gardens and orchards,...
Uniquely Moroccan, La Sultana Marrakech, is a collection of four historic riads, close to the Royal Palaces, with lovely courtyards and gardens,...
Veronique and Pascal Beherec have borrowed the very best of Moroccan craftsmanship to decorate the interiors of this palace full of gorgeous...
Forget any preconceived notions you may have of the desert, in the Oued Izerki Valley, coriander, mint and lucerne flourish under the shade of fig...
Taste the rocky silence of Djebel Sagho. Landscape impregnated by lunar dunes, where civilisation is left behind; a few hours along a desert...
Between the peaks of the High Atlas and the gateway to the South Moroccan desert- Ouarzazate paves the way to luxurious oases. Situated in the...
Riad Demeures d'Orient is a strikingly original creation whose style and decor unites Morocco with the Far East. Its ten deluxe suites are built...
The Caravan Serai evokes the old stops for nomadic traders. Designed as an Arab house "Dar", it has courtyards and secret corners borrowed from...
Located in the heart of the city of Casablanca, this former mansion, now the Hotel Doge, was built in the 30's by an Italian entrepreneur. The...
Seamlessly blending Mediterranean, North African, and traditional Moroccan influences, Jnane Tamsna re-creates the traditional landscape of a...
Kasbah Ait Ben Moro is not a movie, but an authentic XVIIIth century castle restored and converted into a hotel. A masterpiece of traditional...
With breathtaking views, the Kasbah Moroccan Tamadot is a Sir Richard Branson's retreat and located in the spectacular Atlas Mountains. Each of...
Abandoned for almost 30 years, this former palatial residence has now become, thanks to the admirable refurbishment and redecoration, the chicest...
An idyllic retreat on Morocco s Atlantic coast, La Sultana Oualidia overlooks a glorious blue lagoon surrounded by gardens of swaying palms with a...
At the heart of the medina, surrounded by the fragrance of mint and orange of the souk, this riad has been restored in the purest Moroccan...
Built according to Moroccan tradition, the hotel's 30 rooms boast the highest standards of comfort. With its traditional architecture, it is built...
Traces of thousands of years of history have made the city conquered repeatedly and again released, the scene of an incessant coming and going. It...
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 |
---|---|---|---|---|---|
SHOW FULL COLUMNS FROM `hotels` | 34 | 34 | 0 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci'; | 1 | 1 | 0 | ||
SHOW FULL COLUMNS FROM `cities` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `states` | 3 | 3 | 0 | ||
SHOW FULL COLUMNS FROM `countries` | 3 | 3 | 0 | ||
SHOW FULL COLUMNS FROM `weather_forecasts` | 15 | 15 | 0 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci'; | 1 | 1 | 0 | ||
SHOW FULL COLUMNS FROM `news` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `home_hotels` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `hotel_images` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `rooms` | 15 | 15 | 0 | ||
SHOW FULL COLUMNS FROM `rooms_rates` | 8 | 8 | 0 | ||
SHOW FULL COLUMNS FROM `rates_periods` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `rates_period_i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `unavailabilities` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `envies` | 3 | 3 | 0 | ||
SHOW FULL COLUMNS FROM `envie_i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `envies_hotels` | 2 | 2 | 0 | ||
SHOW FULL COLUMNS FROM `comments` | 19 | 19 | 0 | ||
SHOW FULL COLUMNS FROM `users` | 16 | 16 | 0 | ||
SHOW FULL COLUMNS FROM `addresses` | 12 | 12 | 0 | ||
SHOW FULL COLUMNS FROM `janrain_profiles` | 9 | 9 | 0 | ||
SHOW FULL COLUMNS FROM `admins` | 15 | 15 | 0 | ||
SHOW FULL COLUMNS FROM `favorites` | 8 | 8 | 0 | ||
SHOW FULL COLUMNS FROM `hotel_i18n` | 6 | 6 | 0 | ||
SHOW FULL COLUMNS FROM `configs` | 3 | 3 | 0 | ||
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci'; | 1 | 1 | 0 | ||
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` = 'MA' 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` = 'MA' 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 (184, 931, 1410, 746, 1351, 1040, 1483, 1484, 589, 538, 1185, 1039, 1427, 1230, 1368, 181, 183, 1487, 178, 804) | 264 | 264 | 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 (184, 931, 1410, 746, 1351, 1040, 1483, 1484, 589, 538, 1185, 1039, 1427, 1230, 1368, 181, 183, 1487, 178, 804) | 81 | 81 | 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 (184, 931, 1410, 746, 1351, 1040, 1483, 1484, 589, 538, 1185, 1039, 1427, 1230, 1368, 181, 183, 1487, 178, 804) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (184, 931, 1410, 746, 1351, 1040, 1483, 1484, 589, 538, 1185, 1039, 1427, 1230, 1368, 181, 183, 1487, 178, 804) | 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 (184, 931, 1410, 746, 1351, 1040, 1483, 1484, 589, 538, 1185, 1039, 1427, 1230, 1368, 181, 183, 1487, 178, 804) | 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 (184, 931, 1410, 746, 1351, 1040, 1483, 1484, 589, 538, 1185, 1039, 1427, 1230, 1368, 181, 183, 1487, 178, 804) | 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 (184, 931, 1410, 746, 1351, 1040, 1483, 1484, 589, 538, 1185, 1039, 1427, 1230, 1368, 181, 183, 1487, 178, 804) | 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 (184, 931, 1410, 746, 1351, 1040, 1483, 1484, 589, 538, 1185, 1039, 1427, 1230, 1368, 181, 183, 1487, 178, 804) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 97 | 97 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'MA' 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 | ||
SHOW FULL COLUMNS FROM `themes` | 4 | 4 | 0 | ||
SHOW FULL COLUMNS FROM `theme_i18n` | 6 | 6 | 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 | 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 27.43 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.48 MB |
Controller render start | 16.21 MB |
View render complete | 20.07 MB |
Total Request Time: 368 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 88.51 | |
Component initialization and startup | 4.25 | |
Controller action | 59.17 | |
Render Controller Action | 131.03 | |
» Rendering View | 129.59 | |
» » Rendering APP/views/hotels/index.ctp | 61.47 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.11 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.26 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.26 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.01 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.60 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.55 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.25 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.31 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.24 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 0.95 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.27 | |
» » » Rendering APP/views/elements/paging.ctp | 0.90 | |
» » Rendering APP/views/layouts/default.ctp | 67.89 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.54 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 60.44 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.22 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.39 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.34 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |