Put on your beautiful orange T-shirt, drink and go to the health of the Queen through the streets of Amsterdam or on the deck of a boat.
The Festival of Scalloway is the first Viking festival in Shetland torchlight of the season, culminating in the burning of a Viking ship at sea thereby reviving the tradition of over a thousand years, he resumed the ancient practice of sacrificing Viking. A powerful...
Put a touch of madness in your life and watch the famous Lemon Festival in Menton. This is a unique event in which are organized: parades, exhibitions, and even an orchid festival.
The Wahta Mohawks are a rural community Aboriginal living near Bala in central Ontario, they left Oka in Quebec to settle in Muskoka in 1881. Wahta the powwow is held every year during the season of Thanksgiving. This is a unique event that coincides with the annual...
Many stories exist about the origin of pow-wows. Indigenous peoples of North America has always come together to renew friendships and celebrate through song, dance and stories. Join us for this dazzling show with bright colors representing different tribes and...
Celebrate Chinese New Year in Hong Kong. The parade is held in Tsim Sha Tsui East on the Kowloon peninsula with a cavalcade of colorful floats, dragon dancers and performers from all over the world. The day of Chinese New Year tanks are decorated and parade around...
For one week, Valencia Fallas hosts. Real bacchanalia spring, they are festive occasion where the fire uninterrupted in all its forms: Bengal fireworks, joy and excess are highlighted.
In April, the festival of music for Aldrei for eg suour is a model of its kind. First, it is free and open to all ages. No artist is paid, and each must play 20 min. Some concerts are held in the baths Isafjordur. It coincides with the ski season.
Find a costume and dance in the streets during the festivities preceding Lent. The liveliest carnivals are those of Rio, Salvador and Recife. For the lucky ones you can attend the parade celebrating the Sambodrome to see the famous parade of Samba schools in Rio who...
Each month of January in Boquete, people from around the world to participate in the celebration of flowers and coffee. La Feria de las Flores y del Café, an event celebrated in over 50 years. Artisans of the South and Central America exhibit their products, play...
The Oruro Carnival is one of the biggest festivals in South America, which attracts over 400,000 people to celebrate the ancient cultural traditions of Bolivia. Expect to see the devil dancing and water fights. To close the festival, a parade of 20 hours with nearly...
Organized as a way to distract the Latvians early in gloomy long winter nights, the festival Staro Lights takes place in November, with the bridges of the city, parks and monuments illuminated by strange designs. In previous years saw luminous jellyfish floating...
Come to dream at International Boat Show in Fort Lauderdale, the largest boat show in the world. The annual event that takes place late in October, covers six sites of South Florida: Bahia Mar Yachting Center, Broward County Convention Center, Fort Lauderdale Grand...
The Drover Tryst Festival is a celebration of the surrounding countryside and the most unusual traditions of the past through the desolate lands of the Highlands. There is also the opportunity to observe bats, wild goats, deer and buzzards as you walk through the...
October marks the beginning of the season for dredging oysters in the seaside town of Falmouth in Cornwall. Some regulations require that the 19th century engines are prohibited in the waters around (not to disturb shellfish), so the fishermen traverse winding...
Also called the star festival, is held every july. The festival celebrates an old Japanese legend: one night each year. Orihime, the emperor of the galaxy's daughter, can meet her lover, whom the emperor had banished to the other side of the Milky Way. People mark...
Between October and March, Mexico becomes the site of one of the most beautiful natural spectacles in Central America, where millions of monarch butterflies arrive in search of fertile land and sunlight on the branches of their trees. These beautiful insects travel...
The Chablis Wine Festival takes place every fourth Saturday and Sunday in October. If you're in the area, then you really should take a ride through the city whose name symbolizes the white wine. Saturday is devoted to a competition among producers of local wine...
Simple village festival in its infancy in 1963, the Acadian Festival already claimed its cultural character as an essential component of its programming. Community theater then rubbed them the blessing of the boats. Then the first "song boxes" appeared in 1966 and...
Since 1934, residents of Montmartre gather to celebrate with everyone, wine and gastronomy, which contribute to the diversity and vitality of the Parisian culture. See you in Montmartre at the option of tasting, shows, exhibitions and many events that make this...
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`.`id` in (SELECT `EventsTheme`.`event_id` FROM events_themes AS EventsTheme WHERE `EventsTheme`.`theme_id` = 10 ) | 133 | 133 | 1 | ||
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`.`id` in (SELECT `EventsTheme`.`event_id` FROM events_themes AS EventsTheme WHERE `EventsTheme`.`theme_id` = 10 ) ORDER BY `Event`.`id` DESC LIMIT 20 | 20 | 20 | 6 | maybe slow | |
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (386, 384, 381, 375, 374, 372, 366, 363, 358, 357, 356, 355, 353, 351, 350, 348, 347, 342, 340, 339) | 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 (386, 384, 381, 375, 374, 372, 366, 363, 358, 357, 356, 355, 353, 351, 350, 348, 347, 342, 340, 339) | 1 | 1 | 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 (386, 384, 381, 375, 374, 372, 366, 363, 358, 357, 356, 355, 353, 351, 350, 348, 347, 342, 340, 339) | 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 (386, 384, 381, 375, 374, 372, 366, 363, 358, 357, 356, 355, 353, 351, 350, 348, 347, 342, 340, 339) | 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 (386, 384, 381, 375, 374, 372, 366, 363, 358, 357, 356, 355, 353, 351, 350, 348, 347, 342, 340, 339) | 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 (386, 384, 381, 375, 374, 372, 366, 363, 358, 357, 356, 355, 353, 351, 350, 348, 347, 342, 340, 339) | 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 (386, 384, 381, 375, 374, 372, 366, 363, 358, 357, 356, 355, 353, 351, 350, 348, 347, 342, 340, 339) 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 (386, 384, 381, 375, 374, 372, 366, 363, 358, 357, 356, 355, 353, 351, 350, 348, 347, 342, 340, 339) AND `EventsTheme`.`theme_id` = `Theme`.`id`) | 76 | 76 | 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.34 MB
Message | Memory use |
---|---|
Component initialization | 14.99 MB |
Controller action start | 15.17 MB |
Controller render start | 16.24 MB |
View render complete | 20.11 MB |
Total Request Time: 315 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 47.88 | |
Component initialization and startup | 3.79 | |
Controller action | 41.28 | |
Render Controller Action | 142.28 | |
» Rendering View | 140.99 | |
» » Rendering APP/views/events/index.ctp | 86.94 | |
» » » Rendering APP/views/elements/events/item_search.ctp | 3.26 | |
» » » Rendering APP/views/elements/events/item_search.ctp #2 | 2.97 | |
» » » Rendering APP/views/elements/events/item_search.ctp #3 | 3.63 | |
» » » Rendering APP/views/elements/events/item_search.ctp #4 | 3.41 | |
» » » Rendering APP/views/elements/events/item_search.ctp #5 | 3.33 | |
» » » Rendering APP/views/elements/events/item_search.ctp #6 | 3.45 | |
» » » Rendering APP/views/elements/events/item_search.ctp #7 | 2.90 | |
» » » Rendering APP/views/elements/events/item_search.ctp #8 | 3.66 | |
» » » Rendering APP/views/elements/events/item_search.ctp #9 | 3.28 | |
» » » Rendering APP/views/elements/events/item_search.ctp #10 | 3.40 | |
» » » Rendering APP/views/elements/events/item_search.ctp #11 | 3.25 | |
» » » Rendering APP/views/elements/events/item_search.ctp #12 | 3.77 | |
» » » Rendering APP/views/elements/events/item_search.ctp #13 | 2.72 | |
» » » Rendering APP/views/elements/events/item_search.ctp #14 | 3.04 | |
» » » Rendering APP/views/elements/events/item_search.ctp #15 | 2.99 | |
» » » Rendering APP/views/elements/events/item_search.ctp #16 | 3.34 | |
» » » Rendering APP/views/elements/events/item_search.ctp #17 | 3.29 | |
» » » Rendering APP/views/elements/events/item_search.ctp #18 | 3.29 | |
» » » Rendering APP/views/elements/events/item_search.ctp #19 | 3.34 | |
» » » Rendering APP/views/elements/events/item_search.ctp #20 | 3.37 | |
» » » Rendering APP/views/elements/paging.ctp | 2.54 | |
» » Rendering APP/views/layouts/default.ctp | 53.86 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.10 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.43 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.32 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.05 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.13 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.13 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.10 |