Casa Vieja Is a unique luxury boutique hotel, created to highlight the richness of Mexican art on every stone, featuring arts and crafts from all...
Deseo Hotel and Lounge is a member of Design Hotels. In another attempt to create a modern Mexican sophistication, the owners of Habita in Mexico...
Cheerful and chic, colourful and elegant, Casa Natalia is a modern boutique hotel with a traditional Mexican feel in the San Jose del Cabo art...
Hotelito Desconocido is a 100% ecoluxury resort without compared in the world. Combining unique Palafitos set on a virgin beach on the Pacific...
Rosas & Xocolate a 17 room boutique hotel, situated in the heart of the rich, colonial and increasingly internationally known city of Merida, on...
The Explorian Kohunlich is the perfect place to feel natural enviroment, know more about it beautiful mysteries, tropic, sun and adventure in just...
* There are four courtyard rooms and three garden rooms. All the courtyard rooms have a king bed, three of which can accommodate a rollaway bed...
A delightfully cosy hotel in the 16th century colonial town of San Miguel de Allende, Casa Maria is filled with charm and character, with...
Hotel Casa Sandra is a boutique hotel with 12 superior rooms and suites facing the virgin beaches of Holbox Island. Holbox is the last secret in...
Go back in time to a luxurious Hacienda from 1722. This gorgeous hacienda is filled with antiques and delightful decore, luxurious suites and...
Azucar Hotel is a member of Design Hotels. Named for the sugar cane grown in its home state of Veracruz, the Azucar was conceived by hotelier...
We would like to introduce you to this exclusive 4 star luxury hotel that is almost a museum in itself. The name is hotel Casa Colonial and it is...
Old and traditional French estate built in 1890 in Veracruz by the Haute Savoie family, which actually still has citric and bananas plantations...
At the edge of tranquil Zihuantanejo Bay nestled among palm trees- lush gardens and waterfalls- this hideaway is one of the most romantic hotels...
An elegant, neo-classical townhouse, dating back to 1876, Villa Maria Cristina is set on one of Guanajuato's most elegant boulevards. With...
Villa Ganz is a wonderfully restored charming mansion on one of the main boulevards leading into downtown Guadalajara Mexicos second largest city....
A pristine white stucco villa steps from Xpu-Ha Beach with a world-class Mayan-themed spa. Esencia sits in 50 acres of lush, green gardens with...
20 rooms distributed in 5 modules of 4 rooms each, spread out on the white sand among the native vegetation. Jungle Suite: 12 Suites distributed...
A set of historic buildings in the city center, this charming hotel Orient-Express offers the ultimate Mexican experience. Atmosphere cool, leafy...
El Careyes Beach Resort is an exclusive property so carefully crafted that the detailed design and materials used in the construction form a...
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` = 'MX' AND `Hotel`.`published` = 1 | 1 | 1 | 5 | 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` = 'MX' 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 (210, 224, 208, 209, 1360, 211, 212, 217, 214, 985, 1359, 297, 1358, 207, 1122, 986, 1331, 1332, 1333, 222) | 311 | 311 | 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 (210, 224, 208, 209, 1360, 211, 212, 217, 214, 985, 1359, 297, 1358, 207, 1122, 986, 1331, 1332, 1333, 222) | 59 | 59 | 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 (210, 224, 208, 209, 1360, 211, 212, 217, 214, 985, 1359, 297, 1358, 207, 1122, 986, 1331, 1332, 1333, 222) | 0 | 0 | 0 | ||
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (210, 224, 208, 209, 1360, 211, 212, 217, 214, 985, 1359, 297, 1358, 207, 1122, 986, 1331, 1332, 1333, 222) | 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 (210, 224, 208, 209, 1360, 211, 212, 217, 214, 985, 1359, 297, 1358, 207, 1122, 986, 1331, 1332, 1333, 222) | 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 (210, 224, 208, 209, 1360, 211, 212, 217, 214, 985, 1359, 297, 1358, 207, 1122, 986, 1331, 1332, 1333, 222) | 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 (210, 224, 208, 209, 1360, 211, 212, 217, 214, 985, 1359, 297, 1358, 207, 1122, 986, 1331, 1332, 1333, 222) | 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 (210, 224, 208, 209, 1360, 211, 212, 217, 214, 985, 1359, 297, 1358, 207, 1122, 986, 1331, 1332, 1333, 222) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) | 106 | 106 | 1 | ||
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'MX' 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 27.98 MB
Message | Memory use |
---|---|
Component initialization | 14.28 MB |
Controller action start | 14.47 MB |
Controller render start | 16.19 MB |
View render complete | 20.03 MB |
Total Request Time: 286 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 42.07 | |
Component initialization and startup | 2.97 | |
Controller action | 51.19 | |
Render Controller Action | 112.15 | |
» Rendering View | 110.90 | |
» » Rendering APP/views/hotels/index.ctp | 55.65 | |
» » » Rendering APP/views/elements/hotels/item.ctp | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #2 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #3 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #4 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #5 | 1.12 | |
» » » Rendering APP/views/elements/hotels/item.ctp #6 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #7 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #8 | 1.07 | |
» » » Rendering APP/views/elements/hotels/item.ctp #9 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #10 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #11 | 1.17 | |
» » » Rendering APP/views/elements/hotels/item.ctp #12 | 1.21 | |
» » » Rendering APP/views/elements/hotels/item.ctp #13 | 1.03 | |
» » » Rendering APP/views/elements/hotels/item.ctp #14 | 1.13 | |
» » » Rendering APP/views/elements/hotels/item.ctp #15 | 1.14 | |
» » » Rendering APP/views/elements/hotels/item.ctp #16 | 1.08 | |
» » » Rendering APP/views/elements/hotels/item.ctp #17 | 1.04 | |
» » » Rendering APP/views/elements/hotels/item.ctp #18 | 1.06 | |
» » » Rendering APP/views/elements/hotels/item.ctp #19 | 1.18 | |
» » » Rendering APP/views/elements/hotels/item.ctp #20 | 1.16 | |
» » » Rendering APP/views/elements/paging.ctp | 0.89 | |
» » Rendering APP/views/layouts/default.ctp | 55.04 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.64 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.32 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.76 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.44 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |