Toolbar Access

Français

{"session":"

Session<\/h2>\n
Config<\/strong>
userAgent<\/strong>96a2135195cee4dc19bc11b4bba8d8cd<\/li>
time<\/strong>1685707196<\/li>
timeout<\/strong>10<\/li>
language<\/strong>eng<\/li><\/ul><\/li><\/ul>","request":"
Request<\/h2>\n
Cake Params<\/h4>\n
controller<\/strong>events<\/li>
action<\/strong>view<\/li>
language<\/strong>en<\/li>
named<\/strong>(empty)<\/li>
pass<\/strong>
0<\/strong>82<\/li>
1<\/strong>cowal-highland-festival<\/li><\/ul><\/li>
plugin<\/strong>(null)<\/li>
url<\/strong>
ext<\/strong>html<\/li>
url<\/strong>en\/events\/view\/82\/cowal-highland-festival<\/li><\/ul><\/li>
form<\/strong>(empty)<\/li>
isAjax<\/strong>(false)<\/li><\/ul>\n
$_GET<\/h4>\n
url<\/strong>en\/events\/view\/82\/cowal-highland-festival<\/li><\/ul>\n
Cookie<\/h4>\n\t
language<\/strong>en<\/li><\/ul>\n
Current Route<\/h4>\n
keys<\/strong>
0<\/strong>language<\/li>
1<\/strong>controller<\/li>
2<\/strong>action<\/li><\/ul><\/li>
options<\/strong>
language<\/strong>en|fr<\/li><\/ul><\/li>
defaults<\/strong>
plugin<\/strong>(null)<\/li>
action<\/strong>index<\/li><\/ul><\/li>
**template<\/strong>\/:language\/:controller\/:action\/<\/li>
_greedy<\/strong>(true)<\/li>
_compiledRoute<\/strong>#^(?:\/(en|fr))\/(?:([^\/]+))\/(?:([^\/]+))(?:\/(?P<_args_>.))?[\/]*$#<\/li>
__headerMap<\/strong>
type<\/strong>content_type<\/li>
method<\/strong>request_method<\/li>**
server<\/strong>server_name<\/li><\/ul><\/li><\/ul>","sql_log":"
Sql Logs<\/h2>\n\t\t
\n\t\t
default<\/h4>\n\t\t
Query<\/th> Error<\/th> Affected<\/th> Num. rows<\/th> Took (ms)<\/th> Actions<\/th><\/tr>
SHOW FULL COLUMNS FROM `events`<\/td> <\/td> 18<\/td> 18<\/td> 0<\/td> <\/td><\/tr>\n
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_general_ci';<\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `users`<\/td> <\/td> 16<\/td> 16<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `addresses`<\/td> <\/td> 12<\/td> 12<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `janrain_profiles`<\/td> <\/td> 9<\/td> 9<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `admins`<\/td> <\/td> 15<\/td> 15<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `countries`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `weather_forecasts`<\/td> <\/td> 15<\/td> 15<\/td> 0<\/td> <\/td><\/tr>\n
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'latin1_swedish_ci';<\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `hotels`<\/td> <\/td> 34<\/td> 34<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `cities`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `states`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `home_hotels`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `hotel_images`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `rooms`<\/td> <\/td> 15<\/td> 15<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `rooms_rates`<\/td> <\/td> 8<\/td> 8<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `rates_periods`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `rates_period_i18n`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `unavailabilities`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `envies`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `envie_i18n`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `envies_hotels`<\/td> <\/td> 2<\/td> 2<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `comments`<\/td> <\/td> 19<\/td> 19<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `favorites`<\/td> <\/td> 8<\/td> 8<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `hotel_i18n`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `news`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `i18n`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `home_events`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `event_images`<\/td> <\/td> 5<\/td> 5<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `themes`<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `theme_i18n`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `events_hotels`<\/td> <\/td> 2<\/td> 2<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `events_themes`<\/td> <\/td> 2<\/td> 2<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `event_i18n`<\/td> <\/td> 6<\/td> 6<\/td> 0<\/td> <\/td><\/tr>\n
SHOW FULL COLUMNS FROM `configs`<\/td> <\/td> 3<\/td> 3<\/td> 1<\/td> maybe slow<\/span><\/td><\/tr>\n
SELECT CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE COLLATION_NAME= 'utf8_unicode_ci';<\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Config`., `I18nval`.`content`, `Config`.`id` FROM `configs` AS `Config` INNER JOIN `i18n` AS `I18nval` ON (`Config`.`id` = `I18n__val`.`foreign_key` AND `I18nval`.`model` = 'Config' AND `I18nval`.`field` = 'val' AND `I18n__val`.`locale` = 'eng') WHERE 1 = 1 <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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) <\/td> <\/td> 2<\/td> 2<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Event`., `Country`., `State`., `I18nname`.`content`, `I18ndescription`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18nname` ON (`Event`.`id` = `I18nname`.`foreign_key` AND `I18nname`.`model` = 'Event' AND `I18nname`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18ndescription` ON (`Event`.`id` = `I18ndescription`.`foreign_key` AND `I18ndescription`.`model` = 'Event' AND `I18ndescription`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18nlink` ON (`Event`.`id` = `I18nlink`.`foreign_key` AND `I18nlink`.`model` = 'Event' AND `I18nlink`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') LEFT JOIN `countries` AS `Country` ON (`Event`.`country_id` = `Country`.`id`) LEFT JOIN `states` AS `State` ON (`Event`.`state_id` = `State`.`id`) WHERE `Event`.`id` = 82 AND `Event`.`deleted` = 0 AND `Event`.`validate` = 1 AND `Event`.`published` = 1 LIMIT 1<\/td> <\/td> 1<\/td> 1<\/td> 1<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` = (82) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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` = 82 AND `EventsTheme`.`theme_id` = `Theme`.`id`) <\/td> <\/td> 3<\/td> 3<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `News`., `I18nname`.`content`, `I18ndescription`.`content`, `I18nlink`.`content` FROM `news` AS `News` INNER JOIN `i18n` AS `I18nname` ON (`News`.`id` = `I18n__name`.`foreign_key` AND `I18nname`.`model` = 'News' AND `I18nname`.`field` = 'name' AND `I18nname`.`locale` = 'eng') INNER JOIN `i18n` AS `I18ndescription` ON (`News`.`id` = `I18n__description`.`foreign_key` AND `I18ndescription`.`model` = 'News' AND `I18ndescription`.`field` = 'description' AND `I18ndescription`.`locale` = 'eng') INNER JOIN `i18n` AS `I18nlink` ON (`News`.`id` = `I18n__link`.`foreign_key` AND `I18nlink`.`model` = 'News' AND `I18nlink`.`field` = 'link' AND `I18n__link`.`locale` = 'eng') WHERE `News`.`country_id` = 'GB' ORDER BY `News`.`created` DESC LIMIT 1<\/td> <\/td> 1<\/td> 1<\/td> 2<\/td> maybe slow<\/span>
<\/div><\/form><\/td><\/tr>\n
SELECT `Hotel`., `HomeHotel`., `City`., `Country`., `State`., `I18n__tagline`.`content`, `Hotel`.`id` FROM `hotels` AS `Hotel` INNER JOIN `hotel_i18n` AS `I18ntagline` ON (`Hotel`.`id` = `I18ntagline`.`foreign_key` AND `I18ntagline`.`model` = 'Hotel' AND `I18ntagline`.`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`.`longitude` BETWEEN -6.5539573552842 AND -3.3399614447158 AND `Hotel`.`latitude` BETWEEN 55.01701714058 AND 56.81809305942 ORDER BY ABS(`Hotel`.`longitude` - -4.946959399999971) + ABS(`Hotel`.`latitude` - 55.9175551) ASC LIMIT 10<\/td> <\/td> 6<\/td> 6<\/td> 9<\/td> maybe slow<\/span>
<\/div><\/form><\/td><\/tr>\n
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 (1388, 519, 497, 606, 607, 1456) <\/td> <\/td> 66<\/td> 66<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (1388, 519, 497, 606, 607, 1456) <\/td> <\/td> 19<\/td> 19<\/td> 1<\/td> maybe slow<\/span>
<\/div><\/form><\/td><\/tr>\n
SELECT `RatesPeriod`.`id`, `RatesPeriod`.`hotel_id`, `RatesPeriod`.`from`, `RatesPeriod`.`to`, `RatesPeriod`.`created`, `RatesPeriod`.`modified` FROM `rates_periods` AS `RatesPeriod` WHERE `RatesPeriod`.`hotel_id` IN (1388, 519, 497, 606, 607, 1456) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Unavailability`.`id`, `Unavailability`.`hotel_id`, `Unavailability`.`from`, `Unavailability`.`to` FROM `unavailabilities` AS `Unavailability` WHERE `Unavailability`.`hotel_id` IN (1388, 519, 497, 606, 607, 1456) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (1388, 519, 497, 606, 607, 1456) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (1388, 519, 497, 606, 607, 1456) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (1388, 519, 497, 606, 607, 1456) <\/td> <\/td> 12<\/td> 12<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (1388, 519, 497, 606, 607, 1456) AND `EnviesHotel`.`envie_id` = `Envie`.`id`) <\/td> <\/td> 43<\/td> 43<\/td> 1<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Event`., `HomeEvent`., `CreatedUser`., `Country`., `State`., `I18nname`.`content`, `I18ndescription`.`content`, `I18n__link`.`content`, `Event`.`id` FROM `events` AS `Event` INNER JOIN `event_i18n` AS `I18nname` ON (`Event`.`id` = `I18nname`.`foreign_key` AND `I18nname`.`model` = 'Event' AND `I18nname`.`field` = 'name' AND `I18n__name`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18ndescription` ON (`Event`.`id` = `I18ndescription`.`foreign_key` AND `I18ndescription`.`model` = 'Event' AND `I18ndescription`.`field` = 'description' AND `I18n__description`.`locale` = 'eng') INNER JOIN `event_i18n` AS `I18nlink` ON (`Event`.`id` = `I18nlink`.`foreign_key` AND `I18nlink`.`model` = 'Event' AND `I18nlink`.`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`.`id` != 82 AND `Event`.`longitude` BETWEEN -6.5539573552842 AND -3.3399614447158 AND `Event`.`latitude` BETWEEN 55.01701714058 AND 56.81809305942 ORDER BY ABS(`Event`.`longitude` - -4.946959399999971) + ABS(`Event`.`latitude` - 55.9175551) ASC LIMIT 10<\/td> <\/td> 10<\/td> 10<\/td> 12<\/td> maybe slow<\/span>
<\/div><\/form><\/td><\/tr>\n
SELECT `EventImage`.`id`, `EventImage`.`event_id`, `EventImage`.`order`, `EventImage`.`uri`, `EventImage`.`credits` FROM `event_images` AS `EventImage` WHERE `EventImage`.`event_id` IN (505, 502, 1931, 83, 500, 499, 285, 501, 351, 1935) <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (505, 502, 1931, 83, 500, 499, 285, 501, 351, 1935) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (505, 502, 1931, 83, 500, 499, 285, 501, 351, 1935) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (505, 502, 1931, 83, 500, 499, 285, 501, 351, 1935) <\/td> <\/td> 20<\/td> 20<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (505, 502, 1931, 83, 500, 499, 285, 501, 351, 1935) <\/td> <\/td> 20<\/td> 20<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (505, 502, 1931, 83, 500, 499, 285, 501, 351, 1935) <\/td> <\/td> 20<\/td> 20<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (505, 502, 1931, 83, 500, 499, 285, 501, 351, 1935) AND `EventsHotel`.`hotel_id` = `Hotel`.`id`) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 (505, 502, 1931, 83, 500, 499, 285, 501, 351, 1935) AND `EventsTheme`.`theme_id` = `Theme`.`id`) <\/td> <\/td> 12<\/td> 12<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Theme`., `I18n__name`.`content`, `Theme`.`id` FROM `themes` AS `Theme` INNER JOIN `theme_i18n` AS `I18nname` ON (`Theme`.`id` = `I18nname`.`foreign_key` AND `I18nname`.`model` = 'Theme' AND `I18nname`.`field` = 'name' AND `I18nname`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18nname`.`content` ASC <\/td> <\/td> 10<\/td> 10<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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) <\/td> <\/td> 20<\/td> 20<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1 <\/td> <\/td> 10<\/td> 10<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Country`.`id`, `Country`.`name` FROM `countries` AS `Country` WHERE 1 = 1 ORDER BY `Country`.`name` ASC <\/td> <\/td> 256<\/td> 256<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Theme`., `I18n__name`.`content`, `Theme`.`id` FROM `themes` AS `Theme` INNER JOIN `theme_i18n` AS `I18nname` ON (`Theme`.`id` = `I18nname`.`foreign_key` AND `I18nname`.`model` = 'Theme' AND `I18nname`.`field` = 'name' AND `I18nname`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18nname`.`content` ASC <\/td> <\/td> 10<\/td> 10<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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) <\/td> <\/td> 20<\/td> 20<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Theme`.`id`, `Theme`.`uri` FROM `themes` AS `Theme` WHERE 1 = 1 <\/td> <\/td> 10<\/td> 10<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Envie`., `I18n__name`.`content`, `Envie`.`id` FROM `envies` AS `Envie` INNER JOIN `envie_i18n` AS `I18nname` ON (`Envie`.`id` = `I18nname`.`foreign_key` AND `I18nname`.`model` = 'Envie' AND `I18nname`.`field` = 'name' AND `I18nname`.`locale` = 'eng') WHERE 1 = 1 ORDER BY `I18nname`.`content` ASC <\/td> <\/td> 29<\/td> 29<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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) <\/td> <\/td> 58<\/td> 58<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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 <\/td> <\/td> 120<\/td> 120<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SHOW FULL COLUMNS FROM `promises`<\/td> <\/td> 3<\/td> 3<\/td> 0<\/td> <\/td><\/tr>\n
SELECT `Promise`., `I18ntitle`.`content`, `I18ncontent`.`content`, `Promise`.`id` FROM `promises` AS `Promise` INNER JOIN `i18n` AS `I18ntitle` ON (`Promise`.`id` = `I18ntitle`.`foreign_key` AND `I18ntitle`.`model` = 'Promise' AND `I18ntitle`.`field` = 'title' AND `I18ntitle`.`locale` = 'eng') INNER JOIN `i18n` AS `I18ncontent` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18ncontent`.`model` = 'Promise' AND `I18ncontent`.`field` = 'content' AND `I18n__content`.`locale` = 'eng') WHERE 1 = 1 LIMIT 4<\/td> <\/td> 4<\/td> 4<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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) <\/td> <\/td> 8<\/td> 8<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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) <\/td> <\/td> 8<\/td> 8<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT COUNT(*) AS `count` FROM `comments` AS `Comment` LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) LEFT JOIN `events` AS `Event` ON (`Comment`.`foreign_key` = `Event`.`id`) WHERE `Comment`.`approved` = 1 AND `Event`.`id` = 82 AND `Comment`.`model` = 'Event' AND `Comment`.`is_spam` IN ('clean', 'ham') <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
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`, `UserModel`.`id`, `UserModel`.`first_name`, (CONCAT(`UserModel`.`first_name`, ' ', `UserModel`.`name`)) AS `UserModel__full_name`, (`UserModel`.`id`) AS `UserModel__slug`, `Event`.`id` FROM `comments` AS `Comment` LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) LEFT JOIN `events` AS `Event` ON (`Comment`.`foreign_key` = `Event`.`id`) WHERE `Comment`.`approved` = 1 AND `Event`.`id` = 82 AND `Comment`.`model` = 'Event' AND `Comment`.`is_spam` IN ('clean', 'ham') LIMIT 5<\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr><\/table>\t\t
Query Explain:<\/h4>\n\t\t
\n\t\t\t <\/a>\n\t\t\t
Click an \"Explain\" link above, to see the query explanation.<\/p>\n\t\t<\/div>\n\t<\/div>\n\t\n