Chiva-Som celebrates 15 years of success this year, at the forefront of health and wellbeing. For the past 10 years, Chiva-Som is the only...
Kamalaya is a Spa Resort and wellness sanctuary that opened in November 2005 on the Thai island of Koh Samui lauded by Conde Nast Traveler as one...
Mom Tri's Villa Royale is set atop the headland of Kata Bay between two of the most beautiful sandy beaches on Phuket, Kata Noi and Kata Yai....
Located in a forest of trees of cashew nuts, the Napasai is a paradise on the northern coast of Thailand on Koh Samui. This quiet place is located...
Rayavadee is located on the edge of Krabi Marine National Park with towering limestone cliffs and islands dramatically bordered by the crystal...
The Six Senses Hideaway Samui is located on a promontory, the tip of the northwestern tip of the island of Koh Samui. The field extends over 8...
Silavadee means "beautiful rock" in Thai, as it is located on Laem Nan Beach, between Chaweng and Lamai Beach, which has the most beautiful...
The Library aims to offer a lifestyle vacation experience as shown by the clean lines yet elegant appearance of architecture and intelligent...
The Sarojin in Khao Lak is the most luxurious of the 5 Star Hotels in Khao Lak in Thailand and is situated on the coast of Andaman Sea. The area...
The Zeavola is an idyllic haven for relaxation and luxury. The accent here is on water-themed activities, with everything from scuba diving and...
" The Eugenia ", an old world style architectural beauty, is embodied in a late 19 century colonial-style house, charmingly decorated and...
Welcome to Suanthip Vana Resort, the Nature Lover's Retreat located amidst the evergreen forest of Chaing Rai, a famed northern province of...
137 Pillars House revives the old world elegance of the Orient and invites guests to enjoy every modern luxury. You are our personal guests. As...
Banthai Village is the mini size hotel that tries to keep balance between the tradition and modernity among the changes of the world. This...
Reached by river boat amid Thailand's exotic bamboo jungles, where three countries meet, a one-of-a-kind experience for active adults awaits. With...
Only 2 hours North-east drive from Bangkok Kirimaya is located at the edge of Khao Yai National Park known for its lush tropical rainforest wild...
Welcome to Kohjum Resort on the island of Koh Jum, which is a beautiful peaceful island between Koh Lanta Krabi Krabi sitauada and town. Kohjum...
Discover the secluded grace of this intimate retreat in Thailands far north. Puripunn Baby Grand Boutique Hotel is the ultimate luxury property,...
At the Supanniga Home nature is out in force. Here, the architecture draws the outside inside allowing you to recharge your batteries and fully...
The town of Chiang Mai, known as the Rose of the North, is the setting for a gem of Asian hospitality. Designed by Mr. Ong ard Satrabhundu and Mr....
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` = 'TH' AND `Hotel`.`published` = 1 | 1 | 1 | 9 | 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` = 'TH' AND `Hotel`.`published` = 1 ORDER BY `Hotel`.`starred` DESC, `Hotel`.`rating` DESC, `Hotel`.`name` ASC LIMIT 20 | 20 | 20 | 10 | 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 (280, 1405, 714, 1442, 1295, 277, 1450, 233, 1438, 1498, 276, 1443, 1430, 789, 788, 1375, 278, 1469, 831, 279) | 309 | 309 | 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 (280, 1405, 714, 1442, 1295, 277, 1450, 233, 1438, 1498, 276, 1443, 1430, 789, 788, 1375, 278, 1469, 831, 279) | 74 | 74 | 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 (280, 1405, 714, 1442, 1295, 277, 1450, 233, 1438, 1498, 276, 1443, 1430, 789, 788, 1375, 278, 1469, 831, 279) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (280, 1405, 714, 1442, 1295, 277, 1450, 233, 1438, 1498, 276, 1443, 1430, 789, 788, 1375, 278, 1469, 831, 279) | 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 (280, 1405, 714, 1442, 1295, 277, 1450, 233, 1438, 1498, 276, 1443, 1430, 789, 788, 1375, 278, 1469, 831, 279) | 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 (280, 1405, 714, 1442, 1295, 277, 1450, 233, 1438, 1498, 276, 1443, 1430, 789, 788, 1375, 278, 1469, 831, 279) | 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 (280, 1405, 714, 1442, 1295, 277, 1450, 233, 1438, 1498, 276, 1443, 1430, 789, 788, 1375, 278, 1469, 831, 279) | 40 | 40 | 1 | ||
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 (280, 1405, 714, 1442, 1295, 277, 1450, 233, 1438, 1498, 276, 1443, 1430, 789, 788, 1375, 278, 1469, 831, 279) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 134 | 134 | 2 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'TH' 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 | 1 | maybe slow | |
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 | 1 | ||
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 | 5 | ||
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 | 2 | 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.55 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.47 MB |
Controller render start | 16.26 MB |
View render complete | 20.10 MB |
Total Request Time: 419 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 61.52 | |
Component initialization and startup | 5.70 | |
Controller action | 88.03 | |
Render Controller Action | 162.75 | |
» Rendering View | 160.96 | |
» » Rendering APP/views/hotels/index.ctp | 85.41 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 2.10 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.92 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.55 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.50 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.55 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.61 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.73 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.77 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.45 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.58 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.78 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.67 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.72 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.57 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 2.03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.57 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.72 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.87 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.64 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.63 | |
» » » Rendering APP/views/elements/paging.ctp | 1.40 | |
» » Rendering APP/views/layouts/default.ctp | 75.23 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/top.ctp | 2.17 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.44 | |
» » » Rendering APP/views/elements/layout/header.ctp | 64.36 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.29 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 6.56 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.58 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.13 |