Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `hooh_live`.`cake_sessions` AS `Session` WHERE `id` = 'uvbc6aacm4vboubvkikcd9hkn2' LIMIT 1 | 0 | 0 | 0 | |
SELECT `UserSetting`.`id`, `UserSetting`.`name`, `UserSetting`.`name_public`, `UserSetting`.`value`, `UserSetting`.`type`, `UserSetting`.`category` FROM `hooh_live`.`user_settings` AS `UserSetting` WHERE 1 = 1 | 56 | 56 | 0 | |
SELECT `UserActivity`.`id`, `UserActivity`.`useragent`, `UserActivity`.`user_id`, `UserActivity`.`last_action`, `UserActivity`.`last_url`, `UserActivity`.`logout_time`, `UserActivity`.`user_browser`, `UserActivity`.`ip_address`, `UserActivity`.`logout`, `UserActivity`.`deleted`, `UserActivity`.`status`, `UserActivity`.`created`, `UserActivity`.`modified`, `User`.`id`, `User`.`parent_id`, `User`.`resort_id`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_token`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`mobile_udid`, `User`.`mobile_token`, `User`.`is_android`, `User`.`onsignal_token`, `User`.`user_group_id`, `User`.`username`, `User`.`slug`, `User`.`password`, `User`.`salt`, `User`.`change_password_code`, `User`.`email`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`pending_agent`, `User`.`pending_vendor`, `User`.`by_admin`, `User`.`ip_address`, `User`.`profile_views`, `User`.`is_imported`, `User`.`referal`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__complete_name` FROM `hooh_live`.`user_activities` AS `UserActivity` LEFT JOIN `hooh_live`.`users` AS `User` ON (`UserActivity`.`user_id` = `User`.`id`) WHERE `UserActivity`.`useragent` = '29e8e2091e3e9dfa2b291ecad977d67cuvbc6aacm4vboubvkikcd9hkn2' LIMIT 1 | 0 | 0 | 0 | |
SELECT `Country`.`id`, `Country`.`name` FROM `hooh_live`.`countries` AS `Country` WHERE 1 = 1 | 269 | 269 | 0 | |
SELECT `Region`.`id`, `Region`.`name` FROM `hooh_live`.`regions` AS `Region` WHERE 1 = 1 | 249 | 249 | 0 | |
SELECT `Resort`.`id`, `Resort`.`region_id` FROM `hooh_live`.`resorts` AS `Resort` WHERE 1 = 1 GROUP BY `Resort`.`region_id` | 80 | 80 | 1 | |
SELECT `Country`.`id`, `Country`.`cc_fips`, `Country`.`cc_iso`, `Country`.`tld`, `Country`.`name`, `Country`.`featured`, `Country`.`background`, `Country`.`order` FROM `hooh_live`.`countries` AS `Country` WHERE `Country`.`name` = 'Georgia' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`short_description`, `Region`.`active`, `Region`.`featured`, `Region`.`order`, `Region`.`picture`, `Region`.`modified`, `Region`.`created` FROM `hooh_live`.`regions` AS `Region` WHERE `Region`.`country_id` = 90 | 1 | 1 | 0 | |
SELECT `Resort`.`id`, `Resort`.`radio_id`, `Resort`.`name`, `Resort`.`slug`, `Resort`.`user_id`, `Resort`.`region_based_resort`, `Resort`.`region_id`, `Resort`.`country_id`, `Resort`.`description`, `Resort`.`background`, `Resort`.`background_type`, `Resort`.`email`, `Resort`.`phone`, `Resort`.`uploadfile`, `Resort`.`facebook`, `Resort`.`twitter`, `Resort`.`google`, `Resort`.`website`, `Resort`.`location`, `Resort`.`location_weather`, `Resort`.`location_weather_WEOID`, `Resort`.`lat`, `Resort`.`lng`, `Resort`.`active`, `Resort`.`is_imported`, `Resort`.`featured`, `Resort`.`views`, `Resort`.`seo_title`, `Resort`.`seo_description`, `Resort`.`seo_keywords`, `Resort`.`modified`, `Resort`.`created` FROM `hooh_live`.`resorts` AS `Resort` WHERE `Resort`.`background` IS NOT NULL AND `Resort`.`region_id` IS NOT NULL AND `Resort`.`region_id` = (256) | 1 | 1 | 1 | |
SELECT `Resort`.`id`, `Resort`.`radio_id`, `Resort`.`name`, `Resort`.`slug`, `Resort`.`user_id`, `Resort`.`region_based_resort`, `Resort`.`region_id`, `Resort`.`country_id`, `Resort`.`description`, `Resort`.`background`, `Resort`.`background_type`, `Resort`.`email`, `Resort`.`phone`, `Resort`.`uploadfile`, `Resort`.`facebook`, `Resort`.`twitter`, `Resort`.`google`, `Resort`.`website`, `Resort`.`location`, `Resort`.`location_weather`, `Resort`.`location_weather_WEOID`, `Resort`.`lat`, `Resort`.`lng`, `Resort`.`active`, `Resort`.`is_imported`, `Resort`.`featured`, `Resort`.`views`, `Resort`.`seo_title`, `Resort`.`seo_description`, `Resort`.`seo_keywords`, `Resort`.`modified`, `Resort`.`created`, `User`.`id`, `User`.`parent_id`, `User`.`resort_id`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_token`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`mobile_udid`, `User`.`mobile_token`, `User`.`is_android`, `User`.`onsignal_token`, `User`.`user_group_id`, `User`.`username`, `User`.`slug`, `User`.`password`, `User`.`salt`, `User`.`change_password_code`, `User`.`email`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`pending_agent`, `User`.`pending_vendor`, `User`.`by_admin`, `User`.`ip_address`, `User`.`profile_views`, `User`.`is_imported`, `User`.`referal`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__complete_name`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`short_description`, `Region`.`active`, `Region`.`featured`, `Region`.`order`, `Region`.`picture`, `Region`.`modified`, `Region`.`created`, `Country`.`id`, `Country`.`cc_fips`, `Country`.`cc_iso`, `Country`.`tld`, `Country`.`name`, `Country`.`featured`, `Country`.`background`, `Country`.`order`, `UserNotification`.`id`, `UserNotification`.`user_id`, `UserNotification`.`holiday_id`, `UserNotification`.`resort_id`, `UserNotification`.`place_id`, `UserNotification`.`event_id`, `UserNotification`.`offer_id`, `UserNotification`.`excursion_id`, `UserNotification`.`model_name`, `UserNotification`.`type`, `UserNotification`.`status`, `UserNotification`.`read`, `UserNotification`.`modified`, `UserNotification`.`created` FROM `hooh_live`.`resorts` AS `Resort` LEFT JOIN `hooh_live`.`users` AS `User` ON (`Resort`.`user_id` = `User`.`id`) LEFT JOIN `hooh_live`.`regions` AS `Region` ON (`Resort`.`region_id` = `Region`.`id`) LEFT JOIN `hooh_live`.`countries` AS `Country` ON (`Resort`.`country_id` = `Country`.`id`) LEFT JOIN `hooh_live`.`user_notifications` AS `UserNotification` ON (`UserNotification`.`resort_id` = `Resort`.`id`) WHERE `Resort`.`region_id` IS NULL AND `Resort`.`country_id` = 90 GROUP BY `Resort`.`id` | 0 | 0 | 2 | maybe slow |
SELECT `BackgroundPicture`.`id`, `BackgroundPicture`.`user_id`, `BackgroundPicture`.`title`, `BackgroundPicture`.`type`, `BackgroundPicture`.`picture`, `BackgroundPicture`.`active`, `BackgroundPicture`.`sort_order`, `BackgroundPicture`.`created`, `BackgroundPicture`.`modified`, `User`.`id`, `User`.`parent_id`, `User`.`resort_id`, `User`.`fb_id`, `User`.`fb_access_token`, `User`.`twt_id`, `User`.`twt_access_token`, `User`.`twt_access_secret`, `User`.`ldn_id`, `User`.`mobile_udid`, `User`.`mobile_token`, `User`.`is_android`, `User`.`onsignal_token`, `User`.`user_group_id`, `User`.`username`, `User`.`slug`, `User`.`password`, `User`.`salt`, `User`.`change_password_code`, `User`.`email`, `User`.`name`, `User`.`first_name`, `User`.`last_name`, `User`.`active`, `User`.`email_verified`, `User`.`last_login`, `User`.`pending_agent`, `User`.`pending_vendor`, `User`.`by_admin`, `User`.`ip_address`, `User`.`profile_views`, `User`.`is_imported`, `User`.`referal`, `User`.`created`, `User`.`modified`, (CONCAT(`User`.`first_name`, " ", `User`.`last_name`)) AS `User__complete_name` FROM `hooh_live`.`background_pictures` AS `BackgroundPicture` LEFT JOIN `hooh_live`.`users` AS `User` ON (`BackgroundPicture`.`user_id` = `User`.`id`) WHERE `BackgroundPicture`.`type` = 'resort' LIMIT 1 | 1 | 1 | 0 | |
SELECT `UserGroup`.`id`, `UserGroup`.`parent_id`, `UserGroup`.`name`, `UserGroup`.`alias_name`, `UserGroup`.`description`, `UserGroup`.`allowRegistration`, `UserGroup`.`created`, `UserGroup`.`modified` FROM `hooh_live`.`user_groups` AS `UserGroup` WHERE `allowRegistration` = 1 ORDER BY `name` ASC | 3 | 3 | 0 | |
SELECT `Resort`.`id`, `Resort`.`radio_id`, `Resort`.`name`, `Resort`.`slug`, `Resort`.`user_id`, `Resort`.`region_based_resort`, `Resort`.`region_id`, `Resort`.`country_id`, `Resort`.`description`, `Resort`.`background`, `Resort`.`background_type`, `Resort`.`email`, `Resort`.`phone`, `Resort`.`uploadfile`, `Resort`.`facebook`, `Resort`.`twitter`, `Resort`.`google`, `Resort`.`website`, `Resort`.`location`, `Resort`.`location_weather`, `Resort`.`location_weather_WEOID`, `Resort`.`lat`, `Resort`.`lng`, `Resort`.`active`, `Resort`.`is_imported`, `Resort`.`featured`, `Resort`.`views`, `Resort`.`seo_title`, `Resort`.`seo_description`, `Resort`.`seo_keywords`, `Resort`.`modified`, `Resort`.`created`, `Region`.`id`, `Region`.`country_id`, `Region`.`name`, `Region`.`short_description`, `Region`.`active`, `Region`.`featured`, `Region`.`order`, `Region`.`picture`, `Region`.`modified`, `Region`.`created`, `Country`.`id`, `Country`.`cc_fips`, `Country`.`cc_iso`, `Country`.`tld`, `Country`.`name`, `Country`.`featured`, `Country`.`background`, `Country`.`order` FROM `hooh_live`.`resorts` AS `Resort` LEFT JOIN `hooh_live`.`regions` AS `Region` ON (`Resort`.`region_id` = `Region`.`id`) LEFT JOIN `hooh_live`.`countries` AS `Country` ON (`Resort`.`country_id` = `Country`.`id`) WHERE `Resort`.`active` = '1' AND NOT (`Resort`.`background` IS NULL) GROUP BY `Resort`.`id` ORDER BY rand() ASC LIMIT 16 | 16 | 16 | 4 | maybe slow |