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.
First Chopin festival of the world; since 1930, festival receives support from many sources. Taking place in the beautiful Valldemossa monastry offering an International programme.
The history of the Copa Del Rey Audi Mapfre is the chronicle of competition sailing of the highest level in Spain and the Mediterranean. Thirty editions support a sports event which has tried, from its very beginning, to improve day by day, growing into one of the...
The program of the 60 International Festival of Santander is composed of an intense schedule of summer events and festivals that try to elicit the historical weight of our European tradition with future cross-cultural appeal looms in the new Europe.From 1st to 26...
In July and August, culture takes hold of the most emblematic of Cordoba, in Andalusia, with Noches de Embrujo. This is a festival made ??up of many artistic activities for people of all ages. The event list is very long: theater, classical music concerts, poetry...
Consuegra, Toledo province, lives in late October in time to the Rose festival of saffron. Its aim is to discover the cultural essence of Castile-La Mancha through food, crafts, history and traditions. The programming of this event, very varied, beginning with the...
The proceedings of the pilgrimage itself starts at dawn the second Sunday in September with the departure of the statue of the Virgin to the shrine, carried on a cart Mountain richly decorated and accompanied by thousands of pilgrims who pray the Rosary Dawn, this...
In September, Jerez de la Frontera celebrates the harvest festivals, which mark a major event in the annual calendar of the city: the beginning of the grape harvest. During the festivities, the three elements that symbolize the culture of Jerez are honored: wine,...
In a harmless battle paintings, faces Cascamorras tradition, a character reminiscent of the medieval minstrels, the people of Baza and Guadix. Guadix and Baza, in Granada province, live in September one of the most anticipated of the year: the Cascamorras. The...
The origin of this great "battle" of tomatoes was in a fight juvenile onset in 1945. Since then she has never ceased to stand. This unique festival brings each year a crowd of people willing to spend a great moment of laughter and entertainment, helping tomatoes. In...
The Cipotegato is the main character of the festivals of Tarazona. All August 27th, from 12:00, he traveled the city in a rain of tomatoes. Disguised as a harlequin, it opens a passage through the crowd that invaded the streets and eventually transform the way...
Xátiva, near Valencia, in August is one of the oldest fairs in the region of Valencia. This traditional celebration, dating from the thirteenth century, was a privilege granted by King Jacques I in the locality. Apart from the sale of animals and products typical of...
Feria of Málaga commemorates the reconquest of the city by the Catholic Kings in August 1487. The former home of the Cortijo de Torres enclosure of the fair, El Real, where several activities, contests, performances and concerts are organized. A host of events...
In August, in the afternoon and at low tide, the beaches of Sanlúcar de Barrameda is since 1845 the headquarters of horse racing. According to popular tradition, the origin of this celebration goes back to the informal competitions that took place between sellers of...
The rocket launched from the balcony of City Hall marks the start of the new day of joy and entertainment, marked by music, bands and folk dances, concerts, peñas, as well as religious acts, sporting events, bulls and a large number of activities for all ages.
Music, sports competitions and fireworks are just some of the ingredients of traditional fiestas of Ibiza. There are activities for all ages. Among them, a tribute to the pirates and seafarers, and folklore shows. As usual, it was during the first day that is given...
On a giant chessboard Children from Xàbia-Jávea play In August, in the province of Alicante, they offers a very unique theater: the living chess game. This curious initiative counts on the participation of children, school children 6 to 14 years, that give life to...
This event, closely linked to the discovery of America, commemorating the departure of the caravels of Christopher Columbus in 1492 to the New World. Ibero-American culture is reflected in the popular festivities, through several dance festivals. The arenas also...
The town of Nájera in La Rioja, home to such representation on the medieval site of the monastery of Santa María la Real at festivals Nájera. A popular show, with a lot of scenic resources, which narrates the history, traditions and legends of the city.
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` = 'ES' | 28 | 28 | 2 | 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` = 'ES' ORDER BY `Event`.`id` DESC LIMIT 20 | 20 | 20 | 12 | maybe slow | |
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (366, 279, 278, 275, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199) | 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 (366, 279, 278, 275, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199) | 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 (366, 279, 278, 275, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199) | 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 (366, 279, 278, 275, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199) | 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 (366, 279, 278, 275, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199) | 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 (366, 279, 278, 275, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199) | 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 (366, 279, 278, 275, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199) 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 (366, 279, 278, 275, 214, 213, 212, 211, 210, 209, 208, 207, 206, 205, 204, 203, 202, 201, 200, 199) AND `EventsTheme`.`theme_id` = `Theme`.`id`) | 72 | 72 | 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 28.08 MB
Message | Memory use |
---|---|
Component initialization | 14.99 MB |
Controller action start | 15.17 MB |
Controller render start | 16.23 MB |
View render complete | 20.10 MB |
Total Request Time: 320 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived) | 47.53 | |
Component initialization and startup | 2.95 | |
Controller action | 44.70 | |
Render Controller Action | 138.59 | |
» Rendering View | 137.26 | |
» » Rendering APP/views/events/index.ctp | 82.59 | |
» » » Rendering APP/views/elements/events/item_search.ctp | 2.99 | |
» » » Rendering APP/views/elements/events/item_search.ctp #2 | 2.27 | |
» » » Rendering APP/views/elements/events/item_search.ctp #3 | 2.20 | |
» » » Rendering APP/views/elements/events/item_search.ctp #4 | 2.97 | |
» » » Rendering APP/views/elements/events/item_search.ctp #5 | 2.71 | |
» » » Rendering APP/views/elements/events/item_search.ctp #6 | 3.78 | |
» » » Rendering APP/views/elements/events/item_search.ctp #7 | 3.74 | |
» » » Rendering APP/views/elements/events/item_search.ctp #8 | 3.13 | |
» » » Rendering APP/views/elements/events/item_search.ctp #9 | 2.92 | |
» » » Rendering APP/views/elements/events/item_search.ctp #10 | 3.23 | |
» » » Rendering APP/views/elements/events/item_search.ctp #11 | 3.28 | |
» » » Rendering APP/views/elements/events/item_search.ctp #12 | 2.99 | |
» » » Rendering APP/views/elements/events/item_search.ctp #13 | 2.86 | |
» » » Rendering APP/views/elements/events/item_search.ctp #14 | 3.90 | |
» » » Rendering APP/views/elements/events/item_search.ctp #15 | 3.60 | |
» » » Rendering APP/views/elements/events/item_search.ctp #16 | 3.58 | |
» » » Rendering APP/views/elements/events/item_search.ctp #17 | 3.23 | |
» » » Rendering APP/views/elements/events/item_search.ctp #18 | 2.90 | |
» » » Rendering APP/views/elements/events/item_search.ctp #19 | 3.23 | |
» » » Rendering APP/views/elements/events/item_search.ctp #20 | 3.28 | |
» » » Rendering APP/views/elements/paging.ctp | 0.90 | |
» » Rendering APP/views/layouts/default.ctp | 54.47 | |
» » » Rendering APP/views/elements/google_analytics.ctp | 0.10 | |
» » » Rendering APP/views/elements/layout/top.ctp | 1.41 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp | 0.33 | |
» » » Rendering APP/views/elements/layout/header.ctp | 47.69 | |
» » » Rendering APP/views/elements/layout/extra.ctp | 0.13 | |
» » » Rendering APP/views/elements/layout/footer.ctp | 4.14 | |
» » » » Rendering APP/views/elements/layout/social_networks.ctp #2 | 0.32 | |
» » » Rendering APP/views/elements/layout/footnotes.ctp | 0.09 |