The Bagh is a magnificent 200 year-old heritage hotel set in a 12 acre Charbagh, or four-part orchard. Charbaghs were originally conceived as...
A hotel that exudes colonial charm with large and spacious rooms and bathrooms providing the business traveler the much needed luxury of space....
This Taj Leisure Hotel, is located close to Kovalam Beach and spread across 15 acres of land. The hillside and the floating cottages overlook the...
An immaculately restored 300 year old heritage hotel set in wonderfully serene gardens. Retaining its Dutch colonial architectural features, this...
Nestled on the banks of the Kabini River, close to the lush forests of Nagerhole National Park, Orange County Kabini provides a unique setting...
Located close to the city centre and 20 minutes of picturesque drive to the Ranthambhore National Park. Two kilometres away from the railway...
Sutra d'Onyx are luxury apartments situated in the prominent Union Park in Bandra, just across hotel Pali Hills, part of our group. These are...
An innovative language of architecture that combines age-old local building techniques with contemporary design and structural technologies, set...
Ahilya Fort overlooks the sacred Narmada River in Madhya Pradesh. Its walls enclose 18th century buildings amongst which are 14 unique rooms....
Aman-I-Khas combining Aman meaning peace in Sanskrit and Khas meaning special in Urdu and Hindi is an exclusive wilderness camp set in the rugged...
The palace draws heavily from Moorish architecture, with accents of Italian Renaissance columns coupled with Gujarati and Rajasthani jarrokhas,...
Made famous by the famous Rudyard Kipling tale of Mowgli the wolf boy in the Jungle Book, Pench National Park is located in the districts of Seoni...
The Dune Eco Village Resort & Spa, Pondicherry is a themed hotel designed to meet the growing demand for long stay destinations with soul and...
Nestled among the picturesque Vindhya and Satpura region in the central Indian state of Madhya Pradesh, the famous Tiger Reserve Bandhavgarh...
Located in one of the oldest cities in the world, on the banks of the Ganges, the Nadesar Palace hosted royalty, heads of state and celebrities...
In ancient India spending time in a beautiful forest was considered to be an essential part of a balanced life. By adapting this tradition for our...
Sharing the same idyllic beach as 'Elsewhere' Beach Houses is 'Otter Creek Tents'. Three exclusive, comfortable tents, all in the most idyllic...
Be privy to an unforgettable experience in a camp of exceptional tents, elegantly decorated in the authentic English style of the 1920s. Situated...
Dedicated to reflection rejuvenation and self-discovery Shreyas offers a seamless blend of the modern and the timeless sumptuousness and...
On a relatively private spit of land overlooking the ocean, separated from the rest of the world by a salt water creek, stands "ELSEWHERE". Four...
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 | 1 | maybe slow | |
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 | 1 | ||
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` = 'IN' 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` = 'IN' 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 (580, 253, 1317, 464, 784, 1318, 582, 547, 585, 1036, 1045, 1334, 1165, 1336, 1319, 465, 1497, 584, 583, 1496) | 289 | 289 | 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 (580, 253, 1317, 464, 784, 1318, 582, 547, 585, 1036, 1045, 1334, 1165, 1336, 1319, 465, 1497, 584, 583, 1496) | 56 | 56 | 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 (580, 253, 1317, 464, 784, 1318, 582, 547, 585, 1036, 1045, 1334, 1165, 1336, 1319, 465, 1497, 584, 583, 1496) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (580, 253, 1317, 464, 784, 1318, 582, 547, 585, 1036, 1045, 1334, 1165, 1336, 1319, 465, 1497, 584, 583, 1496) | 1 | 1 | 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 (580, 253, 1317, 464, 784, 1318, 582, 547, 585, 1036, 1045, 1334, 1165, 1336, 1319, 465, 1497, 584, 583, 1496) | 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 (580, 253, 1317, 464, 784, 1318, 582, 547, 585, 1036, 1045, 1334, 1165, 1336, 1319, 465, 1497, 584, 583, 1496) | 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 (580, 253, 1317, 464, 784, 1318, 582, 547, 585, 1036, 1045, 1334, 1165, 1336, 1319, 465, 1497, 584, 583, 1496) | 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 (580, 253, 1317, 464, 784, 1318, 582, 547, 585, 1036, 1045, 1334, 1165, 1336, 1319, 465, 1497, 584, 583, 1496) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 100 | 100 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'IN' 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 | 3 | ||
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 | 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.50 MB
Message | Memory use |
---|---|
Component initialization | 14.31 MB |
Controller action start | 14.48 MB |
Controller render start | 16.18 MB |
View render complete | 20.04 MB |
Total Request Time: 337 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 74.53 | |
Component initialization and startup | 5.10 | |
Controller action | 59.71 | |
Render Controller Action | 116.49 | |
» Rendering View | 115.10 | |
» » Rendering APP/views/hotels/index.ctp | 60.55 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.09 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 0.97 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.34 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.31 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.39 | |
» » » 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.20 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.15 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.16 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.33 | |
» » » Rendering APP/views/elements/paging.ctp | 0.89 | |
» » Rendering APP/views/layouts/default.ctp | 54.36 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.08 | |
» » » 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.31 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.32 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |