Nestled in an exclusive estate surrounded by lush greenery and verdant rice fields, only 20 elegantly appointed villas and suites (One Bedroom...
A trend setting, all-suite luxury hotel, offering a private, quiet haven beside a stretch of white sandy beach at the heart of the fashionable...
The Oberoi Lombok resort lies opposite the three Gili Islands, renowned for their colourful coral reefs and dazzling tropical sea life....
TUGU BALI HOTEL Nestled between the pristine, wave-sung sunset beach of Canggu, the whispering rice fields, the quaint fishermen village, and...
Waka Shorea nestles on a protective peninsula, a fifteen minute boat ride from the main public area. Twelve bungalows and two villas uniquely...
Nestled amongst bamboo plants and water lilies, the Matahari Beach Resort and Spa hotel plunges you into a paradisiacal and unspoilt Bali. Your...
Villa Semana is a hidden treasure deep in the Ubud area of Bali. Consisting of 10 traditional Balinese villas, each with amazing views of...
Amanjiwo, peaceful soul, rests in the rural heartland of central java. The resort is located within a natural amphitheatre, with the limestone...
The wilderness hideaway of Amanwana is located on Moyo Island, a nature reserve 15km off the coast of Sumbawa, east of Bali. Rising under a canopy...
Located in a lush setting overlooking the South China Sea, a stillness of spirit permeates the body and soul at Banyan Tree Bintan. Discover true...
COMO Shambhala Estate is a villa-style residential health retreat occupying a 23-acre jungle-covered riverbank amidst the serenity and stunning...
In the heart of a 1.2 hectare estate four authentic architects villas straight out of an interior design magazine offer pride of place to 17...
MesaStila, a high-end luxury resort, previously known as Losari Spa Retreat & Coffee Plantation has recently been established as a wellness...
Located at the tip of a virgin forest in the west Bali National Park, you will find a place to meet the natural environment and adventure. The...
The Puri Madawi is located in one of Bali’s most beautiful and well-known areas, Seminyak/Batu Belig Beach. The intimate layout of our 16 rooms in...
Qunci Villa Senggigi Boutique Hotel, the complex of Villas includes 20 units located in a property giving on the beach and admirably arranged in...
The Purist Villas and Spa is a Ubud small Boutique hotel resort where each suite of two and three rooms has an indoor and outdoor bathroom with a...
Hotel Tugu Lombok, just 20 minutes flight or 1.5-2.5 hours speed boat ride east of Bali, just across of the Gili Islands. This property, only with...
Uma Ubud is located in the centre of Bali. A small but lively town regarded as the islands cultural hub. The town is a compelling mix of rustic...
The natural rejuvenating energies of the Indian Ocean surf, the gently sloping rice terraces and the invigorating sea air make this a sanctum for...
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` = 'ID' 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` = 'ID' 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 (1364, 256, 259, 258, 261, 257, 254, 1035, 1034, 1408, 1409, 967, 1480, 1354, 506, 807, 508, 507, 255, 260) | 344 | 344 | 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 (1364, 256, 259, 258, 261, 257, 254, 1035, 1034, 1408, 1409, 967, 1480, 1354, 506, 807, 508, 507, 255, 260) | 69 | 69 | 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 (1364, 256, 259, 258, 261, 257, 254, 1035, 1034, 1408, 1409, 967, 1480, 1354, 506, 807, 508, 507, 255, 260) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1364, 256, 259, 258, 261, 257, 254, 1035, 1034, 1408, 1409, 967, 1480, 1354, 506, 807, 508, 507, 255, 260) | 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 (1364, 256, 259, 258, 261, 257, 254, 1035, 1034, 1408, 1409, 967, 1480, 1354, 506, 807, 508, 507, 255, 260) | 2 | 2 | 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 (1364, 256, 259, 258, 261, 257, 254, 1035, 1034, 1408, 1409, 967, 1480, 1354, 506, 807, 508, 507, 255, 260) | 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 (1364, 256, 259, 258, 261, 257, 254, 1035, 1034, 1408, 1409, 967, 1480, 1354, 506, 807, 508, 507, 255, 260) | 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 (1364, 256, 259, 258, 261, 257, 254, 1035, 1034, 1408, 1409, 967, 1480, 1354, 506, 807, 508, 507, 255, 260) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 148 | 148 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'ID' 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 29.76 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.47 MB |
Controller render start | 16.32 MB |
View render complete | 20.16 MB |
Total Request Time: 294 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 42.20 | |
Component initialization and startup | 3.08 | |
Controller action | 51.60 | |
Render Controller Action | 113.93 | |
» Rendering View | 112.71 | |
» » Rendering APP/views/hotels/index.ctp | 57.46 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.30 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 0.96 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.02 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 0.95 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.40 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.33 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 0.99 | |
» » » Rendering APP/views/elements/paging.ctp | 0.11 | |
» » Rendering APP/views/layouts/default.ctp | 55.06 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.57 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.31 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.97 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.33 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.31 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.08 |