Toolbar Access

Français

{"session":"

Session<\/h2>\n
Config<\/strong>
userAgent<\/strong>96a2135195cee4dc19bc11b4bba8d8cd<\/li>
time<\/strong>1679705839<\/li>
timeout<\/strong>10<\/li>
language<\/strong>fre<\/li><\/ul><\/li><\/ul>","request":"
Request<\/h2>\n
Cake Params<\/h4>\n
controller<\/strong>hotels<\/li>
action<\/strong>view<\/li>
named<\/strong>(empty)<\/li>
pass<\/strong>
0<\/strong>940<\/li>
1<\/strong>haras-larissa<\/li><\/ul><\/li>
language<\/strong>fr<\/li>
plugin<\/strong>(null)<\/li>
url<\/strong>
ext<\/strong>html<\/li>
url<\/strong>fr\/hotels\/voir\/940\/haras-larissa<\/li><\/ul><\/li>
form<\/strong>(empty)<\/li>
isAjax<\/strong>(false)<\/li><\/ul>\n
$_GET<\/h4>\n
url<\/strong>fr\/hotels\/voir\/940\/haras-larissa<\/li><\/ul>\n
Cookie<\/h4>\n\t
language<\/strong>fr<\/li><\/ul>\n
Current Route<\/h4>\n
keys<\/strong>(empty)<\/li>
options<\/strong>(empty)<\/li>
defaults<\/strong>
controller<\/strong>hotels<\/li>
action<\/strong>view<\/li>
language<\/strong>fr<\/li>
plugin<\/strong>(null)<\/li><\/ul><\/li>
**template<\/strong>\/fr\/hotels\/voir\/<\/li>
_greedy<\/strong>(true)<\/li>
_compiledRoute<\/strong>#^\/fr\/hotels\/voir(?:\/(?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 `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> 1<\/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` = 'fre') 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 `Hotel`., `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` = 'fre') 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`) WHERE `Hotel`.`id` = 940 LIMIT 1<\/td> <\/td> 1<\/td> 1<\/td> 1<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `City`.`id`, `City`.`country_id`, `City`.`state_id`, `City`.`maintrack_id`, `City`.`name`, `City`.`main_key` FROM `cities` AS `City` WHERE `City`.`id` = 889 <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `Country`.`id`, `Country`.`name`, `Country`.`name_fre` FROM `countries` AS `Country` WHERE `Country`.`id` = 'BR' <\/td> <\/td> 1<\/td> 1<\/td> 0<\/td>
<\/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` = (940) <\/td> <\/td> 44<\/td> 44<\/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` = (940) <\/td> <\/td> 2<\/td> 2<\/td> 2<\/td>
<\/div><\/form><\/td><\/tr>\n
SELECT `RoomsRate`.`id`, `RoomsRate`.`rates_period_id`, `RoomsRate`.`room_id`, `RoomsRate`.`rate_regular`, `RoomsRate`.`rate_special`, `RoomsRate`.`rate_currency`, `RoomsRate`.`created`, `RoomsRate`.`modified` FROM `rooms_rates` AS `RoomsRate` WHERE `RoomsRate`.`room_id` IN (3726, 3727) <\/td> <\/td> 0<\/td> 0<\/td> 0<\/td>
<\/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`.`to` >= NOW() AND `RatesPeriod`.`hotel_id` = (940) ORDER BY `RatesPeriod`.`from` ASC LIMIT 5<\/td> <\/td> 0<\/td> 0<\/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` = 'fre') INNER JOIN `i18n` AS `I18ndescription` ON (`News`.`id` = `I18n__description`.`foreign_key` AND `I18ndescription`.`model` = 'News' AND `I18ndescription`.`field` = 'description' AND `I18ndescription`.`locale` = 'fre') INNER JOIN `i18n` AS `I18nlink` ON (`News`.`id` = `I18n__link`.`foreign_key` AND `I18nlink`.`model` = 'News' AND `I18nlink`.`field` = 'link' AND `I18n__link`.`locale` = 'fre') WHERE `News`.`country_id` = 'BR' ORDER BY `News`.`created` DESC <\/td> <\/td> 0<\/td> 0<\/td> 1<\/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` = 'fre') 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`.`published` = 1 AND `Hotel`.`id` != 940 AND `Hotel`.`longitude` BETWEEN -48.299426635209 AND -46.344253354293 AND `Hotel`.`latitude` BETWEEN -23.800626289082 AND -21.999550370241 ORDER BY ABS(`Hotel`.`longitude` - -47.321839994751) + ABS(`Hotel`.`latitude` - -22.9000883296616) ASC LIMIT 3<\/td> <\/td> 0<\/td> 0<\/td> 7<\/td> maybe slow<\/span>
<\/div><\/form><\/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
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 `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
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` = 'fre') INNER JOIN `event_i18n` AS `I18ndescription` ON (`Event`.`id` = `I18ndescription`.`foreign_key` AND `I18ndescription`.`model` = 'Event' AND `I18ndescription`.`field` = 'description' AND `I18n__description`.`locale` = 'fre') INNER JOIN `event_i18n` AS `I18nlink` ON (`Event`.`id` = `I18nlink`.`foreign_key` AND `I18nlink`.`model` = 'Event' AND `I18nlink`.`field` = 'link' AND `I18n__link`.`locale` = 'fre') 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`.`end` IS NULL) OR (`Event`.`end` >= NOW())) AND `Event`.`longitude` BETWEEN -48.299426635209 AND -46.344253354293 AND `Event`.`latitude` BETWEEN -23.800626289082 AND -21.999550370241 ORDER BY ABS(`Event`.`longitude` - -47.321839994751) + ABS(`Event`.`latitude` - -22.9000883296616) ASC LIMIT 10<\/td> <\/td> 1<\/td> 1<\/td> 13<\/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` = (1162) <\/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` = (1162) <\/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` = (1162) <\/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` = (1162) <\/td> <\/td> 2<\/td> 2<\/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` = (1162) <\/td> <\/td> 2<\/td> 2<\/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` = (1162) <\/td> <\/td> 2<\/td> 2<\/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` = 1162 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` = 1162 AND `EventsTheme`.`theme_id` = `Theme`.`id`) <\/td> <\/td> 0<\/td> 0<\/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` = 'fre') 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` = 'fre') 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 (22, 21, 25, 26, 4, 12, 14, 19, 9, 30, 3, 1, 13, 6, 24, 7, 18, 5, 10, 27, 2, 11, 29, 16, 15, 23, 17, 8, 28) <\/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_fre` 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` = 'fre') INNER JOIN `i18n` AS `I18ncontent` ON (`Promise`.`id` = `I18n__content`.`foreign_key` AND `I18ncontent`.`model` = 'Promise' AND `I18ncontent`.`field` = 'content' AND `I18n__content`.`locale` = 'fre') 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 `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 940 AND `Comment`.`model` = 'Hotel' 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`, `Hotel`.`id`, `UserModel`.`id`, `UserModel`.`first_name`, (CONCAT(`UserModel`.`first_name`, ' ', `UserModel`.`name`)) AS `UserModel__full_name`, (`UserModel`.`id`) AS `UserModel__slug` FROM `comments` AS `Comment` LEFT JOIN `hotels` AS `Hotel` ON (`Comment`.`foreign_key` = `Hotel`.`id`) LEFT JOIN `users` AS `UserModel` ON (`Comment`.`user_id` = `UserModel`.`id`) WHERE `Comment`.`approved` = 1 AND `Hotel`.`id` = 940 AND `Comment`.`model` = 'Hotel' 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