Admire the infinity of the Atlantic Ocean from the highest dune in Europe: the Pyla dune is 500 m long and surrounded by pine trees. Get sensations racing down the dune.
Koyasan is a region that hosts an active monastic center founded twelve centuries ago by the priest Kukai (posthumously known as Kobo Daishi) for the study and practice of esoteric Buddhism. It is the headquarters of the Koyasan sect Shingon Buddhism, a faith widely...
You can easily understand why the construction of this magnificent site and was once attributed to large giants, hence the nickname! Legend has it that the warrior Fionn Mac Cumhaill Irish giant built the floor to walk to Scotland to fight Benandonner, his...
Facing the Aegean Sea, the ruins of the Temple of Poseidon offers you a magical place to watch the sunset.
The famous Lewes Arms of the historic town of Lewes. This traditional English pub offers a relaxed atmosphere to enjoy a range of well kept beers and homecooked food.
Bergen and his wooden houses and cobbled streets was once the ancient capital of Norway and a thriving port. These days, cruise ships tend to block the port in the summer. However, the lull in January is a good time to explore the city and fjords near freezing in...
At the heart of a valley 10 km from Cameron House, created a scotch distillery Glengoyne for over 200 years. During the visit by a Master Blender, you will have the chance to visit the factory before making your own malt under the guidance of experts. Take home for...
The famous Bolshoi Ballet is known for his perfectionism, although it is regarded as a bit stuffy. Yet there are signs that the scene becomes more adventurous and avant-garde. After a period of restoration, the theater is once again ready for its international audience.
The All Blacks are the famous rugby team in New Zealand playing for over 100 years. They represent perhaps the team sport that is most closely associated with one country. Famous for the haka, a Maori war dance, they perform before each game, they still rank at the...
Boils, pools of boiling water, geysers, geothermal spas, all of which can be found at Rotorua, one of the most active geothermal areas in the world. Strong odor of sulfur in the vicinity of the city informs you of the vicinity. Rotorua is also popular for adventure...
According to some, Milford Sound is one of the best destinations in the world. Travelers come to explore the fjord aboard boat from Queenstown, the nearest town of Milford Sound. Hikers can reach the place via the Milford Track, one of the trails the most popular.
White Island is an active volcano named by Captain Cook and known as Whakaari Maori in the local dialect, he was the former site of a sulfur mining that ended in disaster. You can find the white island in the Bay of Plenty near the North Island and enjoy excursions...
Kiyomizu temple is one of the oldest and best known in Kyoto, is a Buddhist temple Tendi. The temple dates back to 778, but the current buildings you can see were built in 1633. The temple is notable for its architecture and the fact that there is not a single nail...
The train "La Trochita" is unique because of the narrow gauge between the rails, it also offers a fascinating journey between the valleys and plateaus of Patagonia. With its wooden cars, its heating and Salamander locomotives of yesteryear, this famous train...
The train of clouds is considered one of the highest trains in the world, it reaches 4200 meters during his trip. Technically called "Railroad Belgrano", this train of 1948, and 435 km across. (return), 29 bridges, 21 tunnels, 13 viaducts and zigzags its way twice...
Succumb to the Ice Cream of Berthillon: famous glacier de Paris. The fruit aromas (blackcurrant, for example) are justifiably famous, chocolate, coffee, glazed chestnuts, Agenaise (Armagnac and prunes), nut (hazelnut) and honey nougat (honey nougat) are even richer....
Browse through the narrow streets of Amsterdam, lined channels and are ideal for bikes. All the major streets of the city are equipped with bike paths usually invaded by citizens of the Dutch capital pedaling outdoors. Feel free to imitate them by taking a bike in...
Between April and September, you can watch the Red Sox play at Fenway Park, the oldest ballpark in the country. It is also the most expensive as tickets in the stands range from $ 25 to $ 30, while the more comfortable seats in grandstands are $ 50. Even at these...
Experience a tour with Mojdeh that exposes you to all aspects social, political and cultural Mexico City. You can see the main historical sites, artistic or cultural. You can walk the streets, visiting the different neighborhoods and get an idea of how ordinary...
Klia palace was built in a Spanish architectural style with a facade facing the sea The present monarch, King Bhumipol is often in residence here, where the presence of royal warships normally anchored offshore.
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`.`begin` <= '2023-09' AND `Event`.`end` >= '2023-09' | 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`.`begin` <= '2023-09' AND `Event`.`end` >= '2023-09' ORDER BY `Event`.`id` DESC LIMIT 20 | 0 | 0 | 12 | 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 100, 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 (1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1919, 1918) | 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 (1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1919, 1918) | 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 (1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1919, 1918) | 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 (1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1919, 1918) | 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 (1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1919, 1918) | 40 | 40 | 1 | ||
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 (1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1919, 1918) | 40 | 40 | 1 | ||
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 (1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1919, 1918) 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 (1937, 1936, 1935, 1934, 1933, 1932, 1931, 1930, 1929, 1928, 1927, 1926, 1925, 1924, 1923, 1922, 1921, 1920, 1919, 1918) 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.17 MB
Message | Memory use |
---|---|
Component initialization | 14.99 MB |
Controller action start | 15.17 MB |
Controller render start | 16.15 MB |
View render complete | 20.01 MB |
Total Request Time: 358 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 46.94 | |
Component initialization and startup | 3.00 | |
Controller action | 104.22 | |
Render Controller Action | 119.97 | |
» Rendering View | 118.48 | |
» » Rendering APP/views/events/index.ctp | 62.04 | |
» » » Rendering APP/views/elements/events/item_search.ctp | 2.18 | |
» » » Rendering APP/views/elements/events/item_search.ctp #2 | 1.95 | |
» » » Rendering APP/views/elements/events/item_search.ctp #3 | 1.90 | |
» » » Rendering APP/views/elements/events/item_search.ctp #4 | 1.92 | |
» » » Rendering APP/views/elements/events/item_search.ctp #5 | 1.83 | |
» » » Rendering APP/views/elements/events/item_search.ctp #6 | 1.84 | |
» » » Rendering APP/views/elements/events/item_search.ctp #7 | 1.86 | |
» » » Rendering APP/views/elements/events/item_search.ctp #8 | 1.83 | |
» » » Rendering APP/views/elements/events/item_search.ctp #9 | 1.91 | |
» » » Rendering APP/views/elements/events/item_search.ctp #10 | 1.89 | |
» » » Rendering APP/views/elements/events/item_search.ctp #11 | 1.90 | |
» » » Rendering APP/views/elements/events/item_search.ctp #12 | 1.87 | |
» » » Rendering APP/views/elements/events/item_search.ctp #13 | 1.88 | |
» » » Rendering APP/views/elements/events/item_search.ctp #14 | 1.92 | |
» » » Rendering APP/views/elements/events/item_search.ctp #15 | 1.93 | |
» » » Rendering APP/views/elements/events/item_search.ctp #16 | 1.91 | |
» » » Rendering APP/views/elements/events/item_search.ctp #17 | 1.87 | |
» » » Rendering APP/views/elements/events/item_search.ctp #18 | 1.88 | |
» » » Rendering APP/views/elements/events/item_search.ctp #19 | 1.93 | |
» » » Rendering APP/views/elements/events/item_search.ctp #20 | 1.91 | |
» » » Rendering APP/views/elements/paging.ctp | 3.74 | |
» » Rendering APP/views/layouts/default.ctp | 56.19 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.12 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.49 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.34 | |
» » » Rendering APP/views/elements/layout/header.ctp | 48.61 | |
» » » Rendering APP/views/elements/messages/error.ctp | 0.17 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.14 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.26 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.34 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.10 |