If there was a competition between the best views of the Alps, the Lauterbrunnen Valley would certainly not far from winning the first prize. Rugged peaks carved by glaciers and snow-covered dominant green pastures dotted with cottages straight out of the adventures...
Off the coast of Galicia, the last bastion of the European continent facing the Atlantic, lie the islands certainly the most spectacular in Spain. Best among the submerged rocks, there are sandy beaches worthy of Caribbean shores. Today, this former haunt of pirates...
Plivitce National Park is a marvel of nature more difficult to describe this series of turquoise lakes perched in the heart of the Dinaric Alps in central Croatia. It is the wealth of minéreaux flowing in the veins of this massif. Bijela and Crna rivers, which must...
It is said that the island of Orleans, located just outside of town is the birthplace of the French & Metric. If you can practice a lot of activities (biking, fishing, horse riding), its main interest lies in its local products, the island is full of small bakeries,...
In summer, the Image Mill is planning four centuries of Quebec hisotire on huge grain silos in the port. Feel free to start or end an evening with the sound and visual prowess 3D 45 min.
The great biologist Rolland Lemieux takes you observe the bears in the wildlife reserve of Parc des Laurentides. For 34 years this is the best trapper in the area. It captures with just the cake. He must see if you want to capture a lynx, a bear, but his greatest...
The Cameron Highlands are not only known for their tea, the wind and the beautiful scenery. This is one of the few places where one finds the largest flower in the world, rafflésie, presqeu and found a very short life. Your guide will take you on a perilous road to...
In a neighborhood where good restaurants abound, this one stands out. It serves traditional Peranakan cuisine for over 60 years, including fried noodles with shrimp or crab pepper.
The Raffles is tourism, but the Long Bar is a must to enjoy such a Singapore Sling or the Million Dollar Cocktail.
The island of Pulau Tenggol is a small island perfect for diving and is located in the South China Sea off the coast of Tanjong Jara Resort and is part of Terengganu Marine Park, which is still a closely guarded secret amongst the diving community . This means that...
Know how to prepare typical dishes from the east coast of Malaysia with a master processor. Make an appointment with our chef and learn the secrets in the mixture of herbs and spices, a style of cooking is now a tradition.
An exciting hike to the giant waterfall of 200 meters Chemerung. A breathtaking view awaits you at the end of this trek, water slide down the steep mountain in the pool and clear rock pools below.
Our resident naturalist will escort you for a smooth and pleasant excursion through the jungle around the area. Discover many aspects of the local nature, including some of their traditional uses that are still practiced in the surrounding villages for their unique...
Boh plantation, with trees that you arrive at the waist, stretches nearly 5 km2 of hills. It is the largest producer of black tea in Malaysia. The setting is idyllic and the undulating hills out of sight, interrupted only small streams, water wheels and few...
Renowned jeweler to the good old days, a favorite of Sarah Bernarhdt Andre Lalique is one of the great creators of Art Nouveau and Art Deco through his work on the glass and crystal. Since 2011, Wingen-sur Moder, bucolic Alsatian city which hosts the factory...
This Tratoria 7 Soldi hiding in a tiny alley of Via Toledo with a small dining room and a take away service. They serve a good Neapolitan cuisine, like wine, sparkling red Gragano. The clientele is exclusively Neapolitan, some basic Italian with the staff are...
In Naples, the Kingdom of the pizza, the pizza is a reference Sorbillo: soft and crispy batter, and a variation of flavors that does not exclude the light. The Margherita leads to Paradise, with a delicate tomato sauce and melted cheese in the mouth. One could make...
Try at the Palazzo Reale in Caserta north of Naples. This huge palace of 1200 parts is known as the Versailles of Italy; it reflects a sublime baroque architecture. You can even take to the famous Etan Hauck since this is where Tom Cruise filmed scenes for Mission...
Dora is the best seafood restaurant in Naples. We feast on grilled shrimp and the owner pushes the canzonetta. Book in advance.
The Scialuppa restaurant offers the perfect setting for a romantic dinner overlooking the sea. Seafood dominates the menu.
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 `Event`.`id`, `Event`.`deleted`, `Event`.`validate`, `Event`.`published`, `Event`.`created_user_id`, `Event`.`begin`, `Event`.`end`, `Event`.`location`, `Event`.`latitude`, `Event`.`longitude`, `Event`.`zoom`, `Event`.`state_id`, `Event`.`country_id`, `Event`.`created`, `Event`.`modified`, `Event`.`url`, `Event`.`comment_count`, `Event`.`former_business_id` FROM `events` AS `Event` WHERE `Event`.`deleted` = 0 AND `Event`.`validate` = 1 AND `Event`.`published` = 1 AND `Event`.`country_id` = 'IT' AND `Event`.`begin` <= '2023-07' AND `Event`.`end` >= '2023-07' | 0 | 0 | 1 | maybe slow | |
SELECT `Event`.*, `HomeEvent`.*, `CreatedUser`.*, `Country`.*, `State`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18n__name` ON (`Event`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Event' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__description` ON (`Event`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Event' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__link` ON (`Event`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Event' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') LEFT JOIN `users` AS `CreatedUser` ON (`Event`.`created_user_id` = `CreatedUser`.`id`) LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `home_events` AS `HomeEvent` ON (`HomeEvent`.`event_id` = `Event`.`id`) WHERE `Event`.`deleted` = 0 AND `Event`.`validate` = 1 AND `Event`.`published` = 1 AND `Event`.`country_id` = 'IT' AND `Event`.`begin` <= '2023-07' AND `Event`.`end` >= '2023-07' ORDER BY `Event`.`id` DESC LIMIT 20 | 0 | 0 | 11 | maybe slow | |
SELECT COUNT(DISTINCT(`Event`.`id`)) AS count FROM `events` AS `Event` INNER JOIN `event_i18n` AS `EventI18n` ON (`Event`.`id` = `EventI18n`.`foreign_key` AND `EventI18n`.`model` = 'Event' AND `EventI18n`.`locale` = 'eng') LEFT JOIN `users` AS `CreatedUser` ON (`Event`.`created_user_id` = `CreatedUser`.`id`) LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `home_events` AS `HomeEvent` ON (`HomeEvent`.`event_id` = `Event`.`id`) WHERE `Event`.`deleted` = 0 AND `Event`.`validate` = 1 AND `Event`.`published` = 1 | 1 | 1 | 0 | ||
SELECT `Event`.*, `HomeEvent`.*, `CreatedUser`.*, `Country`.*, `State`.*, `I18n__name`.`content`, `I18n__description`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18n__name` ON (`Event`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Event' AND `I18n__name`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__description` ON (`Event`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'Event' AND `I18n__description`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18n__link` ON (`Event`.`id` = `I18n__link`.`foreign_key` AND `I18n__link`.`model` = 'Event' AND `I18n__link`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') LEFT JOIN `users` AS `CreatedUser` ON (`Event`.`created_user_id` = `CreatedUser`.`id`) LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) LEFT JOIN `home_events` AS `HomeEvent` ON (`HomeEvent`.`event_id` = `Event`.`id`) WHERE `Event`.`deleted` = 0 AND `Event`.`validate` = 1 AND `Event`.`published` = 1 ORDER BY `Event`.`id` DESC LIMIT 300, 20 | 20 | 20 | 54 | maybe slow | |
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718) | 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 (1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718) | 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` = 'Event' AND `Favorite`.`foreign_key` IN (1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718) | 0 | 0 | 0 | ||
SELECT `Names`.`id`, `Names`.`locale`, `Names`.`model`, `Names`.`foreign_key`, `Names`.`field`, `Names`.`content` FROM `event_i18n` AS `Names` WHERE `model` = 'Event' AND `field` = 'name' AND `Names`.`foreign_key` IN (1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718) | 40 | 40 | 1 | ||
SELECT `Descriptions`.`id`, `Descriptions`.`locale`, `Descriptions`.`model`, `Descriptions`.`foreign_key`, `Descriptions`.`field`, `Descriptions`.`content` FROM `event_i18n` AS `Descriptions` WHERE `model` = 'Event' AND `field` = 'description' AND `Descriptions`.`foreign_key` IN (1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718) | 40 | 40 | 0 | ||
SELECT `Links`.`id`, `Links`.`locale`, `Links`.`model`, `Links`.`foreign_key`, `Links`.`field`, `Links`.`content` FROM `event_i18n` AS `Links` WHERE `model` = 'Event' AND `field` = 'link' AND `Links`.`foreign_key` IN (1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718) | 40 | 40 | 0 | ||
SELECT `Hotel`.`id`, `Hotel`.`starred`, `Hotel`.`in`, `Hotel`.`maintrack_hotel_id`, `Hotel`.`brand_code`, `Hotel`.`name`, `Hotel`.`address`, `Hotel`.`zip_code`, `Hotel`.`cityarea_id`, `Hotel`.`city_id`, `Hotel`.`region_id`, `Hotel`.`state_id`, `Hotel`.`country_id`, `Hotel`.`latitude`, `Hotel`.`longitude`, `Hotel`.`zoom`, `Hotel`.`rating`, `Hotel`.`phone`, `Hotel`.`reservation_phone`, `Hotel`.`fax`, `Hotel`.`email`, `Hotel`.`created`, `Hotel`.`modified`, `Hotel`.`description`, `Hotel`.`description_fre`, `Hotel`.`amenity`, `Hotel`.`amenity_fre`, `Hotel`.`lowest_rate`, `Hotel`.`lr_currency`, `Hotel`.`lr_people`, `Hotel`.`comment_count`, `Hotel`.`cancellation_policy`, `Hotel`.`cancellation_policy_fre`, `Hotel`.`published`, `EventsHotel`.`event_id`, `EventsHotel`.`hotel_id` FROM `hotels` AS `Hotel` JOIN `events_hotels` AS `EventsHotel` ON (`EventsHotel`.`event_id` IN (1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718) AND `EventsHotel`.`hotel_id` = `Hotel`.`id`) | 0 | 0 | 0 | ||
SELECT `Theme`.`id`, `Theme`.`created`, `Theme`.`modified`, `Theme`.`uri`, `EventsTheme`.`event_id`, `EventsTheme`.`theme_id` FROM `themes` AS `Theme` JOIN `events_themes` AS `EventsTheme` ON (`EventsTheme`.`event_id` IN (1737, 1736, 1735, 1734, 1733, 1732, 1731, 1730, 1729, 1728, 1727, 1726, 1725, 1724, 1723, 1722, 1721, 1720, 1719, 1718) AND `EventsTheme`.`theme_id` = `Theme`.`id`) | 0 | 0 | 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 `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC | 256 | 256 | 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.08 MB
Message | Memory use |
---|---|
Component initialization | 14.99 MB |
Controller action start | 15.17 MB |
Controller render start | 16.14 MB |
View render complete | 20.00 MB |
Total Request Time: 355 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 48.22 | |
Component initialization and startup | 2.98 | |
Controller action | 101.98 | |
Render Controller Action | 117.47 | |
» Rendering View | 116.15 | |
» » Rendering APP/views/events/index.ctp | 60.67 | |
» » » Rendering APP/views/elements/events/item_search.ctp | 1.91 | |
» » » Rendering APP/views/elements/events/item_search.ctp #2 | 1.91 | |
» » » Rendering APP/views/elements/events/item_search.ctp #3 | 1.95 | |
» » » Rendering APP/views/elements/events/item_search.ctp #4 | 2.14 | |
» » » Rendering APP/views/elements/events/item_search.ctp #5 | 2.06 | |
» » » Rendering APP/views/elements/events/item_search.ctp #6 | 1.89 | |
» » » Rendering APP/views/elements/events/item_search.ctp #7 | 1.91 | |
» » » Rendering APP/views/elements/events/item_search.ctp #8 | 1.73 | |
» » » Rendering APP/views/elements/events/item_search.ctp #9 | 1.96 | |
» » » Rendering APP/views/elements/events/item_search.ctp #10 | 1.92 | |
» » » Rendering APP/views/elements/events/item_search.ctp #11 | 1.89 | |
» » » Rendering APP/views/elements/events/item_search.ctp #12 | 2.00 | |
» » » Rendering APP/views/elements/events/item_search.ctp #13 | 1.86 | |
» » » Rendering APP/views/elements/events/item_search.ctp #14 | 1.86 | |
» » » Rendering APP/views/elements/events/item_search.ctp #15 | 1.78 | |
» » » Rendering APP/views/elements/events/item_search.ctp #16 | 1.77 | |
» » » Rendering APP/views/elements/events/item_search.ctp #17 | 1.82 | |
» » » Rendering APP/views/elements/events/item_search.ctp #18 | 1.87 | |
» » » Rendering APP/views/elements/events/item_search.ctp #19 | 1.76 | |
» » » Rendering APP/views/elements/events/item_search.ctp #20 | 1.88 | |
» » » Rendering APP/views/elements/paging.ctp | 3.58 | |
» » Rendering APP/views/layouts/default.ctp | 55.28 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.10 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.45 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.33 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.89 | |
» » » Rendering APP/views/elements/messages/error.ctp | 0.09 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.47 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.33 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |