1 | SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`order`, `SettingCategory`.`id`, `SettingCategory`.`created`, `SettingCategory`.`modified`, `SettingCategory`.`name`, `SettingCategory`.`description`, `SiteLogo`.`id`, `SiteLogo`.`created`, `SiteLogo`.`modified`, `SiteLogo`.`class`, `SiteLogo`.`foreign_id`, `SiteLogo`.`filename`, `SiteLogo`.`dir`, `SiteLogo`.`mimetype`, `SiteLogo`.`filesize`, `SiteLogo`.`height`, `SiteLogo`.`width`, `SiteLogo`.`thumb`, `SiteLogo`.`description` FROM `settings` AS `Setting` LEFT JOIN `setting_categories` AS `SettingCategory` ON (`Setting`.`setting_category_id` = `SettingCategory`.`id`) LEFT JOIN `attachments` AS `SiteLogo` ON (`SiteLogo`.`foreign_id` = `Setting`.`id` AND `SiteLogo`.`class` = 'SiteLogo') WHERE 1 = 1 | | 214 | 214 | 13 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Setting | | ALL | | | | | 214 | 100.00 | |
1 | SIMPLE | SettingCategory | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_grouponpro.Setting.setting_category_id | 1 | 100.00 | Using index condition |
1 | SIMPLE | SiteLogo | | ref | foreign_id,class | foreign_id | 8 | cuponclu_grouponpro.Setting.id | 1 | 100.00 | Using where |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`Setting`.`id` AS `id`,`cuponclu_grouponpro`.`Setting`.`setting_category_id` AS `setting_category_id`,`cuponclu_grouponpro`.`Setting`.`name` AS `name`,`cuponclu_grouponpro`.`Setting`.`value` AS `value`,`cuponclu_grouponpro`.`Setting`.`description` AS `description`,`cuponclu_grouponpro`.`Setting`.`type` AS `type`,`cuponclu_grouponpro`.`Setting`.`options` AS `options`,`cuponclu_grouponpro`.`Setting`.`label` AS `label`,`cuponclu_grouponpro`.`Setting`.`order` AS `order`,`cuponclu_grouponpro`.`SettingCategory`.`id` AS `id`,`cuponclu_grouponpro`.`SettingCategory`.`created` AS `created`,`cuponclu_grouponpro`.`SettingCategory`.`modified` AS `modified`,`cuponclu_grouponpro`.`SettingCategory`.`name` AS `name`,`cuponclu_grouponpro`.`SettingCategory`.`description` AS `description`,`cuponclu_grouponpro`.`SiteLogo`.`id` AS `id`,`cuponclu_grouponpro`.`SiteLogo`.`created` AS `created`,`cuponclu_grouponpro`.`SiteLogo`.`modified` AS `modified`,`cuponclu_grouponpro`.`SiteLogo`.`class` AS `class`,`cuponclu_grouponpro`.`SiteLogo`.`foreign_id` AS `foreign_id`,`cuponclu_grouponpro`.`SiteLogo`.`filename` AS `filename`,`cuponclu_grouponpro`.`SiteLogo`.`dir` AS `dir`,`cuponclu_grouponpro`.`SiteLogo`.`mimetype` AS `mimetype`,`cuponclu_grouponpro`.`SiteLogo`.`filesize` AS `filesize`,`cuponclu_grouponpro`.`SiteLogo`.`height` AS `height`,`cuponclu_grouponpro`.`SiteLogo`.`width` AS `width`,`cuponclu_grouponpro`.`SiteLogo`.`thumb` AS `thumb`,`cuponclu_grouponpro`.`SiteLogo`.`description` AS `description` from `cuponclu_grouponpro`.`settings` `Setting` left join `cuponclu_grouponpro`.`setting_categories` `SettingCategory` on((`cuponclu_grouponpro`.`Setting`.`setting_category_id` = `cuponclu_grouponpro`.`SettingCategory`.`id`)) left join `cuponclu_grouponpro`.`attachments` `SiteLogo` on(((`cuponclu_grouponpro`.`SiteLogo`.`foreign_id` = `cuponclu_grouponpro`.`Setting`.`id`) and (`cuponclu_grouponpro`.`SiteLogo`.`class` = 'SiteLogo'))) where true |
|
2 | SELECT `City`.`language_id`, `Language`.`iso2`, `Language`.`id` FROM `cities` AS `City` LEFT JOIN `languages` AS `Language` ON (`City`.`language_id` = `Language`.`id`) WHERE `City`.`slug` = 'guatemala-city' AND `City`.`is_approved` = 1 LIMIT 1 | | 1 | 1 | 1 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | City | | ref | slug | slug | 137 | const | 1 | 10.00 | Using where |
1 | SIMPLE | Language | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_grouponpro.City.language_id | 1 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`City`.`language_id` AS `language_id`,`cuponclu_grouponpro`.`Language`.`iso2` AS `iso2`,`cuponclu_grouponpro`.`Language`.`id` AS `id` from `cuponclu_grouponpro`.`cities` `City` left join `cuponclu_grouponpro`.`languages` `Language` on((`cuponclu_grouponpro`.`Language`.`id` = `cuponclu_grouponpro`.`City`.`language_id`)) where ((`cuponclu_grouponpro`.`City`.`is_approved` = 1) and (`cuponclu_grouponpro`.`City`.`slug` = 'guatemala-city')) limit 1 |
|
3 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '7430b5212471e7b07ba7432e6cfe0f37' | | 0 | 0 | 0 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | | | | | | | | | | no matching row in const table |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select NULL AS `data` from `cuponclu_grouponpro`.`cake_sessions` where (NULL = '7430b5212471e7b07ba7432e6cfe0f37') |
|
4 | SELECT `City`.`id`, `City`.`created`, `City`.`modified`, `City`.`country_id`, `City`.`state_id`, `City`.`language_id`, `City`.`name`, `City`.`slug`, `City`.`latitude`, `City`.`longitude`, `City`.`dma_id`, `City`.`county`, `City`.`code`, `City`.`deal_count`, `City`.`active_deal_count`, `City`.`is_approved`, `City`.`fb_user_id`, `City`.`fb_access_token`, `City`.`twitter_username`, `City`.`twitter_password`, `City`.`twitter_access_token`, `City`.`twitter_access_key`, `City`.`twitter_url`, `City`.`facebook_url`, `Attachment`.`id`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`class`, `Attachment`.`foreign_id`, `Attachment`.`filename`, `Attachment`.`dir`, `Attachment`.`mimetype`, `Attachment`.`filesize`, `Attachment`.`height`, `Attachment`.`width`, `Attachment`.`thumb`, `Attachment`.`description` FROM `cities` AS `City` LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `City`.`id` AND `Attachment`.`class` = 'City') WHERE `City`.`slug` = 'guatemala-city' AND `City`.`is_approved` = 1 LIMIT 1 | | 1 | 1 | 1 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | City | | ref | slug | slug | 137 | const | 1 | 10.00 | Using where |
1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | cuponclu_grouponpro.City.id | 1 | 100.00 | Using where |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`City`.`id` AS `id`,`cuponclu_grouponpro`.`City`.`created` AS `created`,`cuponclu_grouponpro`.`City`.`modified` AS `modified`,`cuponclu_grouponpro`.`City`.`country_id` AS `country_id`,`cuponclu_grouponpro`.`City`.`state_id` AS `state_id`,`cuponclu_grouponpro`.`City`.`language_id` AS `language_id`,`cuponclu_grouponpro`.`City`.`name` AS `name`,`cuponclu_grouponpro`.`City`.`slug` AS `slug`,`cuponclu_grouponpro`.`City`.`latitude` AS `latitude`,`cuponclu_grouponpro`.`City`.`longitude` AS `longitude`,`cuponclu_grouponpro`.`City`.`dma_id` AS `dma_id`,`cuponclu_grouponpro`.`City`.`county` AS `county`,`cuponclu_grouponpro`.`City`.`code` AS `code`,`cuponclu_grouponpro`.`City`.`deal_count` AS `deal_count`,`cuponclu_grouponpro`.`City`.`active_deal_count` AS `active_deal_count`,`cuponclu_grouponpro`.`City`.`is_approved` AS `is_approved`,`cuponclu_grouponpro`.`City`.`fb_user_id` AS `fb_user_id`,`cuponclu_grouponpro`.`City`.`fb_access_token` AS `fb_access_token`,`cuponclu_grouponpro`.`City`.`twitter_username` AS `twitter_username`,`cuponclu_grouponpro`.`City`.`twitter_password` AS `twitter_password`,`cuponclu_grouponpro`.`City`.`twitter_access_token` AS `twitter_access_token`,`cuponclu_grouponpro`.`City`.`twitter_access_key` AS `twitter_access_key`,`cuponclu_grouponpro`.`City`.`twitter_url` AS `twitter_url`,`cuponclu_grouponpro`.`City`.`facebook_url` AS `facebook_url`,`cuponclu_grouponpro`.`Attachment`.`id` AS `id`,`cuponclu_grouponpro`.`Attachment`.`created` AS `created`,`cuponclu_grouponpro`.`Attachment`.`modified` AS `modified`,`cuponclu_grouponpro`.`Attachment`.`class` AS `class`,`cuponclu_grouponpro`.`Attachment`.`foreign_id` AS `foreign_id`,`cuponclu_grouponpro`.`Attachment`.`filename` AS `filename`,`cuponclu_grouponpro`.`Attachment`.`dir` AS `dir`,`cuponclu_grouponpro`.`Attachment`.`mimetype` AS `mimetype`,`cuponclu_grouponpro`.`Attachment`.`filesize` AS `filesize`,`cuponclu_grouponpro`.`Attachment`.`height` AS `height`,`cuponclu_grouponpro`.`Attachment`.`width` AS `width`,`cuponclu_grouponpro`.`Attachment`.`thumb` AS `thumb`,`cuponclu_grouponpro`.`Attachment`.`description` AS `description` from `cuponclu_grouponpro`.`cities` `City` left join `cuponclu_grouponpro`.`attachments` `Attachment` on(((`cuponclu_grouponpro`.`Attachment`.`foreign_id` = `cuponclu_grouponpro`.`City`.`id`) and (`cuponclu_grouponpro`.`Attachment`.`class` = 'City'))) where ((`cuponclu_grouponpro`.`City`.`is_approved` = 1) and (`cuponclu_grouponpro`.`City`.`slug` = 'guatemala-city')) limit 1 |
|
5 | SELECT `BannedIp`.`id`, `BannedIp`.`created`, `BannedIp`.`modified`, `BannedIp`.`address`, `BannedIp`.`range`, `BannedIp`.`referer_url`, `BannedIp`.`reason`, `BannedIp`.`redirect`, `BannedIp`.`thetime`, `BannedIp`.`timespan` FROM `banned_ips` AS `BannedIp` WHERE ((`BannedIp`.`address` = '316509735') OR (`BannedIp`.`range` = '316509735') OR (((`BannedIp`.`address` >= '316509735') AND (`BannedIp`.`range` <= '316509735'))) OR (((`BannedIp`.`address` <= '316509735') AND (`BannedIp`.`range` >= '316509735')))) LIMIT 1 | | 0 | 0 | 2 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | BannedIp | | ALL | address,range | | | | 181 | 36.00 | Using where |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`BannedIp`.`id` AS `id`,`cuponclu_grouponpro`.`BannedIp`.`created` AS `created`,`cuponclu_grouponpro`.`BannedIp`.`modified` AS `modified`,`cuponclu_grouponpro`.`BannedIp`.`address` AS `address`,`cuponclu_grouponpro`.`BannedIp`.`range` AS `range`,`cuponclu_grouponpro`.`BannedIp`.`referer_url` AS `referer_url`,`cuponclu_grouponpro`.`BannedIp`.`reason` AS `reason`,`cuponclu_grouponpro`.`BannedIp`.`redirect` AS `redirect`,`cuponclu_grouponpro`.`BannedIp`.`thetime` AS `thetime`,`cuponclu_grouponpro`.`BannedIp`.`timespan` AS `timespan` from `cuponclu_grouponpro`.`banned_ips` `BannedIp` where ((`cuponclu_grouponpro`.`BannedIp`.`address` = '316509735') or (`cuponclu_grouponpro`.`BannedIp`.`range` = '316509735') or ((`cuponclu_grouponpro`.`BannedIp`.`address` >= '316509735') and (`cuponclu_grouponpro`.`BannedIp`.`range` <= '316509735')) or ((`cuponclu_grouponpro`.`BannedIp`.`address` <= '316509735') and (`cuponclu_grouponpro`.`BannedIp`.`range` >= '316509735'))) limit 1 |
|
6 | SELECT `DealCategory`.`id`, `DealCategory`.`name` FROM `deal_categories` AS `DealCategory` WHERE 1 = 1 | | 29 | 29 | 0 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | DealCategory | | ALL | | | | | 29 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`DealCategory`.`id` AS `id`,`cuponclu_grouponpro`.`DealCategory`.`name` AS `name` from `cuponclu_grouponpro`.`deal_categories` `DealCategory` |
|
7 | SELECT `Deal`.`id`, `Deal`.`created`, `Deal`.`modified`, `Deal`.`user_id`, `Deal`.`name`, `Deal`.`short_name`, `Deal`.`coupon_name`, `Deal`.`display_neighborhoodname`, `Deal`.`slug`, `Deal`.`bitly_short_url`, `Deal`.`description`, `Deal`.`private_note`, `Deal`.`original_price`, `Deal`.`discounted_price`, `Deal`.`start_date`, `Deal`.`end_date`, `Deal`.`sort_order`, `Deal`.`discount_percentage`, `Deal`.`discount_amount`, `Deal`.`savings`, `Deal`.`min_limit`, `Deal`.`max_limit`, `Deal`.`city_id`, `Deal`.`company_id`, `Deal`.`review`, `Deal`.`deal_user_count`, `Deal`.`payment_failed_count`, `Deal`.`buy_min_quantity_per_user`, `Deal`.`buy_max_quantity_per_user`, `Deal`.`deal_tipped_time`, `Deal`.`coupon_expiry_date`, `Deal`.`coupon_condition`, `Deal`.`coupon_highlights`, `Deal`.`comment`, `Deal`.`is_coupon_mail_sent`, `Deal`.`is_subscription_mail_sent`, `Deal`.`is_side_deal`, `Deal`.`deal_status_id`, `Deal`.`bonus_amount`, `Deal`.`commission_percentage`, `Deal`.`commission_percent_unused`, `Deal`.`vat_percent`, `Deal`.`payment1_amt`, `Deal`.`payment1_date`, `Deal`.`payment1_check_no`, `Deal`.`payment1_bank`, `Deal`.`payment1_comm`, `Deal`.`payment1_vat`, `Deal`.`payment1_info`, `Deal`.`payment1_comments`, `Deal`.`payment2_amt`, `Deal`.`payment2_date`, `Deal`.`payment2_check_no`, `Deal`.`payment2_bank`, `Deal`.`payment2_comm`, `Deal`.`payment2_vat`, `Deal`.`payment2_info`, `Deal`.`payment2_comments`, `Deal`.`payment3_amt`, `Deal`.`payment3_date`, `Deal`.`payment3_check_no`, `Deal`.`payment3_bank`, `Deal`.`payment3_comm`, `Deal`.`payment3_vat`, `Deal`.`payment3_info`, `Deal`.`payment3_comments`, `Deal`.`payment4_amt`, `Deal`.`payment4_date`, `Deal`.`payment4_check_no`, `Deal`.`payment4_bank`, `Deal`.`payment4_comm`, `Deal`.`payment4_vat`, `Deal`.`payment4_info`, `Deal`.`payment4_comments`, `Deal`.`first_payment_percent`, `Deal`.`added_coupons`, `Deal`.`total_commission_amount`, `Deal`.`total_purchased_amount`, `Deal`.`net_profit`, `Deal`.`meta_keywords`, `Deal`.`meta_description`, `Deal`.`bitly_short_url_subdomain`, `Deal`.`bitly_short_url_prefix`, `Deal`.`certainly`, `Deal`.`probably`, `Deal`.`unlikely_satisfied`, `Deal`.`unlikely_unsatisfied`, `Deal`.`survey_happy`, `Deal`.`survey_fair`, `Deal`.`survey_sad`, `Deal`.`salesman`, `Deal`.`zone`, `Deal`.`industry`, `Deal`.`category_id`, `Deal`.`sub_category_id`, `Deal`.`gender`, `Deal`.`neighborhood_id`, `Deal`.`sales_projection`, `Deal`.`facebook_description`, `Deal`.`facebook_title`, `User`.`user_type_id`, `User`.`username`, `User`.`id`, `User`.`email`, `User`.`password`, `City`.`id`, `City`.`name`, `City`.`slug`, `Company`.`name`, `Company`.`slug`, `Company`.`id`, `Company`.`user_id`, `Company`.`url`, `Company`.`zip`, `Company`.`address1`, `Company`.`address2`, `Company`.`city_id`, `Company`.`latitude`, `Company`.`longitude`, `Company`.`is_company_profile_enabled`, `Company`.`is_online_account`, `Company`.`map_zoom_level`, `Company`.`survey_responses`, `Company`.`half_stars`, `Company`.`percent_to_return`, `Company`.`state_id`, `Company`.`country_id`, `Attachment`.`id`, `Attachment`.`dir`, `Attachment`.`filename`, `Attachment`.`width`, `Attachment`.`height`, `Fbpicture`.`id`, `Fbpicture`.`dir`, `Fbpicture`.`filename`, `Fbpicture`.`width`, `Fbpicture`.`height` FROM `deals` AS `Deal` LEFT JOIN `users` AS `User` ON (`Deal`.`user_id` = `User`.`id`) LEFT JOIN `cities` AS `City` ON (`Deal`.`city_id` = `City`.`id`) LEFT JOIN `companies` AS `Company` ON (`Deal`.`company_id` = `Company`.`id`) LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `Deal`.`id` AND `Attachment`.`class` = 'Deal') LEFT JOIN `fbpictures` AS `Fbpicture` ON (`Fbpicture`.`foreign_id` = `Deal`.`id` AND `Fbpicture`.`class` = 'Deal') WHERE `Deal`.`slug` = '1-hora-de-boliche-pizza-median-18' LIMIT 1 | | 1 | 1 | 2 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Deal | | ref | slug | slug | 767 | const | 1 | 100.00 | |
1 | SIMPLE | User | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_grouponpro.Deal.user_id | 1 | 100.00 | Using index condition |
1 | SIMPLE | City | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_grouponpro.Deal.city_id | 1 | 100.00 | |
1 | SIMPLE | Company | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_grouponpro.Deal.company_id | 1 | 100.00 | |
1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | cuponclu_grouponpro.Deal.id | 1 | 100.00 | Using where |
1 | SIMPLE | Fbpicture | | ref | foreign_id,class | foreign_id | 8 | cuponclu_grouponpro.Deal.id | 1 | 100.00 | Using where |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`Deal`.`id` AS `id`,`cuponclu_grouponpro`.`Deal`.`created` AS `created`,`cuponclu_grouponpro`.`Deal`.`modified` AS `modified`,`cuponclu_grouponpro`.`Deal`.`user_id` AS `user_id`,`cuponclu_grouponpro`.`Deal`.`name` AS `name`,`cuponclu_grouponpro`.`Deal`.`short_name` AS `short_name`,`cuponclu_grouponpro`.`Deal`.`coupon_name` AS `coupon_name`,`cuponclu_grouponpro`.`Deal`.`display_neighborhoodname` AS `display_neighborhoodname`,`cuponclu_grouponpro`.`Deal`.`slug` AS `slug`,`cuponclu_grouponpro`.`Deal`.`bitly_short_url` AS `bitly_short_url`,`cuponclu_grouponpro`.`Deal`.`description` AS `description`,`cuponclu_grouponpro`.`Deal`.`private_note` AS `private_note`,`cuponclu_grouponpro`.`Deal`.`original_price` AS `original_price`,`cuponclu_grouponpro`.`Deal`.`discounted_price` AS `discounted_price`,`cuponclu_grouponpro`.`Deal`.`start_date` AS `start_date`,`cuponclu_grouponpro`.`Deal`.`end_date` AS `end_date`,`cuponclu_grouponpro`.`Deal`.`sort_order` AS `sort_order`,`cuponclu_grouponpro`.`Deal`.`discount_percentage` AS `discount_percentage`,`cuponclu_grouponpro`.`Deal`.`discount_amount` AS `discount_amount`,`cuponclu_grouponpro`.`Deal`.`savings` AS `savings`,`cuponclu_grouponpro`.`Deal`.`min_limit` AS `min_limit`,`cuponclu_grouponpro`.`Deal`.`max_limit` AS `max_limit`,`cuponclu_grouponpro`.`Deal`.`city_id` AS `city_id`,`cuponclu_grouponpro`.`Deal`.`company_id` AS `company_id`,`cuponclu_grouponpro`.`Deal`.`review` AS `review`,`cuponclu_grouponpro`.`Deal`.`deal_user_count` AS `deal_user_count`,`cuponclu_grouponpro`.`Deal`.`payment_failed_count` AS `payment_failed_count`,`cuponclu_grouponpro`.`Deal`.`buy_min_quantity_per_user` AS `buy_min_quantity_per_user`,`cuponclu_grouponpro`.`Deal`.`buy_max_quantity_per_user` AS `buy_max_quantity_per_user`,`cuponclu_grouponpro`.`Deal`.`deal_tipped_time` AS `deal_tipped_time`,`cuponclu_grouponpro`.`Deal`.`coupon_expiry_date` AS `coupon_expiry_date`,`cuponclu_grouponpro`.`Deal`.`coupon_condition` AS `coupon_condition`,`cuponclu_grouponpro`.`Deal`.`coupon_highlights` AS `coupon_highlights`,`cuponclu_grouponpro`.`Deal`.`comment` AS `comment`,`cuponclu_grouponpro`.`Deal`.`is_coupon_mail_sent` AS `is_coupon_mail_sent`,`cuponclu_grouponpro`.`Deal`.`is_subscription_mail_sent` AS `is_subscription_mail_sent`,`cuponclu_grouponpro`.`Deal`.`is_side_deal` AS `is_side_deal`,`cuponclu_grouponpro`.`Deal`.`deal_status_id` AS `deal_status_id`,`cuponclu_grouponpro`.`Deal`.`bonus_amount` AS `bonus_amount`,`cuponclu_grouponpro`.`Deal`.`commission_percentage` AS `commission_percentage`,`cuponclu_grouponpro`.`Deal`.`commission_percent_unused` AS `commission_percent_unused`,`cuponclu_grouponpro`.`Deal`.`vat_percent` AS `vat_percent`,`cuponclu_grouponpro`.`Deal`.`payment1_amt` AS `payment1_amt`,`cuponclu_grouponpro`.`Deal`.`payment1_date` AS `payment1_date`,`cuponclu_grouponpro`.`Deal`.`payment1_check_no` AS `payment1_check_no`,`cuponclu_grouponpro`.`Deal`.`payment1_bank` AS `payment1_bank`,`cuponclu_grouponpro`.`Deal`.`payment1_comm` AS `payment1_comm`,`cuponclu_grouponpro`.`Deal`.`payment1_vat` AS `payment1_vat`,`cuponclu_grouponpro`.`Deal`.`payment1_info` AS `payment1_info`,`cuponclu_grouponpro`.`Deal`.`payment1_comments` AS `payment1_comments`,`cuponclu_grouponpro`.`Deal`.`payment2_amt` AS `payment2_amt`,`cuponclu_grouponpro`.`Deal`.`payment2_date` AS `payment2_date`,`cuponclu_grouponpro`.`Deal`.`payment2_check_no` AS `payment2_check_no`,`cuponclu_grouponpro`.`Deal`.`payment2_bank` AS `payment2_bank`,`cuponclu_grouponpro`.`Deal`.`payment2_comm` AS `payment2_comm`,`cuponclu_grouponpro`.`Deal`.`payment2_vat` AS `payment2_vat`,`cuponclu_grouponpro`.`Deal`.`payment2_info` AS `payment2_info`,`cuponclu_grouponpro`.`Deal`.`payment2_comments` AS `payment2_comments`,`cuponclu_grouponpro`.`Deal`.`payment3_amt` AS `payment3_amt`,`cuponclu_grouponpro`.`Deal`.`payment3_date` AS `payment3_date`,`cuponclu_grouponpro`.`Deal`.`payment3_check_no` AS `payment3_check_no`,`cuponclu_grouponpro`.`Deal`.`payment3_bank` AS `payment3_bank`,`cuponclu_grouponpro`.`Deal`.`payment3_comm` AS `payment3_comm`,`cuponclu_grouponpro`.`Deal`.`payment3_vat` AS `payment3_vat`,`cuponclu_grouponpro`.`Deal`.`payment3_info` AS `payment3_info`,`cuponclu_grouponpro`.`Deal`.`payment3_comments` AS `payment3_comments`,`cuponclu_grouponpro`.`Deal`.`payment4_amt` AS `payment4_amt`,`cuponclu_grouponpro`.`Deal`.`payment4_date` AS `payment4_date`,`cuponclu_grouponpro`.`Deal`.`payment4_check_no` AS `payment4_check_no`,`cuponclu_grouponpro`.`Deal`.`payment4_bank` AS `payment4_bank`,`cuponclu_grouponpro`.`Deal`.`payment4_comm` AS `payment4_comm`,`cuponclu_grouponpro`.`Deal`.`payment4_vat` AS `payment4_vat`,`cuponclu_grouponpro`.`Deal`.`payment4_info` AS `payment4_info`,`cuponclu_grouponpro`.`Deal`.`payment4_comments` AS `payment4_comments`,`cuponclu_grouponpro`.`Deal`.`first_payment_percent` AS `first_payment_percent`,`cuponclu_grouponpro`.`Deal`.`added_coupons` AS `added_coupons`,`cuponclu_grouponpro`.`Deal`.`total_commission_amount` AS `total_commission_amount`,`cuponclu_grouponpro`.`Deal`.`total_purchased_amount` AS `total_purchased_amount`,`cuponclu_grouponpro`.`Deal`.`net_profit` AS `net_profit`,`cuponclu_grouponpro`.`Deal`.`meta_keywords` AS `meta_keywords`,`cuponclu_grouponpro`.`Deal`.`meta_description` AS `meta_description`,`cuponclu_grouponpro`.`Deal`.`bitly_short_url_subdomain` AS `bitly_short_url_subdomain`,`cuponclu_grouponpro`.`Deal`.`bitly_short_url_prefix` AS `bitly_short_url_prefix`,`cuponclu_grouponpro`.`Deal`.`certainly` AS `certainly`,`cuponclu_grouponpro`.`Deal`.`probably` AS `probably`,`cuponclu_grouponpro`.`Deal`.`unlikely_satisfied` AS `unlikely_satisfied`,`cuponclu_grouponpro`.`Deal`.`unlikely_unsatisfied` AS `unlikely_unsatisfied`,`cuponclu_grouponpro`.`Deal`.`survey_happy` AS `survey_happy`,`cuponclu_grouponpro`.`Deal`.`survey_fair` AS `survey_fair`,`cuponclu_grouponpro`.`Deal`.`survey_sad` AS `survey_sad`,`cuponclu_grouponpro`.`Deal`.`salesman` AS `salesman`,`cuponclu_grouponpro`.`Deal`.`zone` AS `zone`,`cuponclu_grouponpro`.`Deal`.`industry` AS `industry`,`cuponclu_grouponpro`.`Deal`.`category_id` AS `category_id`,`cuponclu_grouponpro`.`Deal`.`sub_category_id` AS `sub_category_id`,`cuponclu_grouponpro`.`Deal`.`gender` AS `gender`,`cuponclu_grouponpro`.`Deal`.`neighborhood_id` AS `neighborhood_id`,`cuponclu_grouponpro`.`Deal`.`sales_projection` AS `sales_projection`,`cuponclu_grouponpro`.`Deal`.`facebook_description` AS `facebook_description`,`cuponclu_grouponpro`.`Deal`.`facebook_title` AS `facebook_title`,`cuponclu_grouponpro`.`User`.`user_type_id` AS `user_type_id`,`cuponclu_grouponpro`.`User`.`username` AS `username`,`cuponclu_grouponpro`.`User`.`id` AS `id`,`cuponclu_grouponpro`.`User`.`email` AS `email`,`cuponclu_grouponpro`.`User`.`password` AS `password`,`cuponclu_grouponpro`.`City`.`id` AS `id`,`cuponclu_grouponpro`.`City`.`name` AS `name`,`cuponclu_grouponpro`.`City`.`slug` AS `slug`,`cuponclu_grouponpro`.`Company`.`name` AS `name`,`cuponclu_grouponpro`.`Company`.`slug` AS `slug`,`cuponclu_grouponpro`.`Company`.`id` AS `id`,`cuponclu_grouponpro`.`Company`.`user_id` AS `user_id`,`cuponclu_grouponpro`.`Company`.`url` AS `url`,`cuponclu_grouponpro`.`Company`.`zip` AS `zip`,`cuponclu_grouponpro`.`Company`.`address1` AS `address1`,`cuponclu_grouponpro`.`Company`.`address2` AS `address2`,`cuponclu_grouponpro`.`Company`.`city_id` AS `city_id`,`cuponclu_grouponpro`.`Company`.`latitude` AS `latitude`,`cuponclu_grouponpro`.`Company`.`longitude` AS `longitude`,`cuponclu_grouponpro`.`Company`.`is_company_profile_enabled` AS `is_company_profile_enabled`,`cuponclu_grouponpro`.`Company`.`is_online_account` AS `is_online_account`,`cuponclu_grouponpro`.`Company`.`map_zoom_level` AS `map_zoom_level`,`cuponclu_grouponpro`.`Company`.`survey_responses` AS `survey_responses`,`cuponclu_grouponpro`.`Company`.`half_stars` AS `half_stars`,`cuponclu_grouponpro`.`Company`.`percent_to_return` AS `percent_to_return`,`cuponclu_grouponpro`.`Company`.`state_id` AS `state_id`,`cuponclu_grouponpro`.`Company`.`country_id` AS `country_id`,`cuponclu_grouponpro`.`Attachment`.`id` AS `id`,`cuponclu_grouponpro`.`Attachment`.`dir` AS `dir`,`cuponclu_grouponpro`.`Attachment`.`filename` AS `filename`,`cuponclu_grouponpro`.`Attachment`.`width` AS `width`,`cuponclu_grouponpro`.`Attachment`.`height` AS `height`,`cuponclu_grouponpro`.`Fbpicture`.`id` AS `id`,`cuponclu_grouponpro`.`Fbpicture`.`dir` AS `dir`,`cuponclu_grouponpro`.`Fbpicture`.`filename` AS `filename`,`cuponclu_grouponpro`.`Fbpicture`.`width` AS `width`,`cuponclu_grouponpro`.`Fbpicture`.`height` AS `height` from `cuponclu_grouponpro`.`deals` `Deal` left join `cuponclu_grouponpro`.`users` `User` on((`cuponclu_grouponpro`.`Deal`.`user_id` = `cuponclu_grouponpro`.`User`.`id`)) left join `cuponclu_grouponpro`.`cities` `City` on((`cuponclu_grouponpro`.`City`.`id` = `cuponclu_grouponpro`.`Deal`.`city_id`)) left join `cuponclu_grouponpro`.`companies` `Company` on((`cuponclu_grouponpro`.`Company`.`id` = `cuponclu_grouponpro`.`Deal`.`company_id`)) left join `cuponclu_grouponpro`.`attachments` `Attachment` on(((`cuponclu_grouponpro`.`Attachment`.`foreign_id` = `cuponclu_grouponpro`.`Deal`.`id`) and (`cuponclu_grouponpro`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_grouponpro`.`fbpictures` `Fbpicture` on(((`cuponclu_grouponpro`.`Fbpicture`.`foreign_id` = `cuponclu_grouponpro`.`Deal`.`id`) and (`cuponclu_grouponpro`.`Fbpicture`.`class` = 'Deal'))) where (`cuponclu_grouponpro`.`Deal`.`slug` = '1-hora-de-boliche-pizza-median-18') limit 1 |
|
8 | SELECT `User`.`user_type_id`, `User`.`username`, `User`.`id`, `User`.`email`, `User`.`password` FROM `users` AS `User` WHERE `User`.`id` = 5758 | | 1 | 1 | 0 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | User | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select '4' AS `user_type_id`,'VendedorGlenda' AS `username`,'5758' AS `id`,'bkj@scf.com' AS `email`,'b53cb2bb11aeb49ef475deba1be97aa192636fc7' AS `password` from `cuponclu_grouponpro`.`users` `User` where true |
|
9 | SELECT `City`.`id`, `City`.`name`, `City`.`slug` FROM `cities` AS `City` WHERE `City`.`id` = 42563 | | 1 | 1 | 0 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | City | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select '42563' AS `id`,'Guatemala' AS `name`,'guatemala-city' AS `slug` from `cuponclu_grouponpro`.`cities` `City` where true |
|
10 | SELECT `Company`.`name`, `Company`.`slug`, `Company`.`id`, `Company`.`user_id`, `Company`.`url`, `Company`.`zip`, `Company`.`address1`, `Company`.`address2`, `Company`.`city_id`, `Company`.`latitude`, `Company`.`longitude`, `Company`.`is_company_profile_enabled`, `Company`.`is_online_account`, `Company`.`map_zoom_level`, `Company`.`survey_responses`, `Company`.`half_stars`, `Company`.`percent_to_return`, `Company`.`state_id`, `Company`.`country_id` FROM `companies` AS `Company` WHERE `Company`.`id` = 563 | | 1 | 1 | 0 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Company | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select 'Planet Bowl' AS `name`,'planet-bowl' AS `slug`,'563' AS `id`,'31993' AS `user_id`,'' AS `url`,'01011' AS `zip`,'Calzada Roosevelt 22-43 Z.11 Tikal Futura' AS `address1`,'' AS `address2`,'42563' AS `city_id`,'14.622657' AS `latitude`,'-90.553871' AS `longitude`,'0' AS `is_company_profile_enabled`,'1' AS `is_online_account`,'16' AS `map_zoom_level`,'99' AS `survey_responses`,'10' AS `half_stars`,'99' AS `percent_to_return`,'109' AS `state_id`,'97' AS `country_id` from `cuponclu_grouponpro`.`companies` `Company` where true |
|
11 | SELECT `City`.`id`, `City`.`name`, `City`.`slug` FROM `cities` AS `City` WHERE `City`.`id` = 42563 | | 1 | 1 | 0 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | City | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select '42563' AS `id`,'Guatemala' AS `name`,'guatemala-city' AS `slug` from `cuponclu_grouponpro`.`cities` `City` where true |
|
12 | SELECT `State`.`id`, `State`.`name` FROM `states` AS `State` WHERE `State`.`id` = 109 | | 1 | 1 | 0 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | State | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select '109' AS `id`,'Guatemala' AS `name` from `cuponclu_grouponpro`.`states` `State` where true |
|
13 | SELECT `Country`.`id`, `Country`.`name`, `Country`.`slug` FROM `countries` AS `Country` WHERE `Country`.`id` = 97 | | 1 | 1 | 0 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Country | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select '97' AS `id`,'Guatemala' AS `name`,'guatemala' AS `slug` from `cuponclu_grouponpro`.`countries` `Country` where true |
|
14 | SELECT `CompanyAddress`.`id`, `CompanyAddress`.`created`, `CompanyAddress`.`modified`, `CompanyAddress`.`address1`, `CompanyAddress`.`address2`, `CompanyAddress`.`company_id`, `CompanyAddress`.`city_id`, `CompanyAddress`.`state_id`, `CompanyAddress`.`country_id`, `CompanyAddress`.`phone`, `CompanyAddress`.`zip`, `CompanyAddress`.`url`, `CompanyAddress`.`latitude`, `CompanyAddress`.`longitude` FROM `company_addresses` AS `CompanyAddress` WHERE `CompanyAddress`.`company_id` = (563) LIMIT 5 | | 0 | 0 | 1 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | CompanyAddress | | ref | user_id | user_id | 8 | const | 1 | 100.00 | |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`CompanyAddress`.`id` AS `id`,`cuponclu_grouponpro`.`CompanyAddress`.`created` AS `created`,`cuponclu_grouponpro`.`CompanyAddress`.`modified` AS `modified`,`cuponclu_grouponpro`.`CompanyAddress`.`address1` AS `address1`,`cuponclu_grouponpro`.`CompanyAddress`.`address2` AS `address2`,`cuponclu_grouponpro`.`CompanyAddress`.`company_id` AS `company_id`,`cuponclu_grouponpro`.`CompanyAddress`.`city_id` AS `city_id`,`cuponclu_grouponpro`.`CompanyAddress`.`state_id` AS `state_id`,`cuponclu_grouponpro`.`CompanyAddress`.`country_id` AS `country_id`,`cuponclu_grouponpro`.`CompanyAddress`.`phone` AS `phone`,`cuponclu_grouponpro`.`CompanyAddress`.`zip` AS `zip`,`cuponclu_grouponpro`.`CompanyAddress`.`url` AS `url`,`cuponclu_grouponpro`.`CompanyAddress`.`latitude` AS `latitude`,`cuponclu_grouponpro`.`CompanyAddress`.`longitude` AS `longitude` from `cuponclu_grouponpro`.`company_addresses` `CompanyAddress` where (`cuponclu_grouponpro`.`CompanyAddress`.`company_id` = 563) limit 5 |
|
15 | SELECT `Attachment`.`id`, `Attachment`.`dir`, `Attachment`.`filename`, `Attachment`.`width`, `Attachment`.`height` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_id` = 17232 AND `Attachment`.`class` = 'Deal' | | 1 | 1 | 1 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | const | 1 | 78.08 | Using where |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`Attachment`.`id` AS `id`,`cuponclu_grouponpro`.`Attachment`.`dir` AS `dir`,`cuponclu_grouponpro`.`Attachment`.`filename` AS `filename`,`cuponclu_grouponpro`.`Attachment`.`width` AS `width`,`cuponclu_grouponpro`.`Attachment`.`height` AS `height` from `cuponclu_grouponpro`.`attachments` `Attachment` where ((`cuponclu_grouponpro`.`Attachment`.`foreign_id` = 17232) and (`cuponclu_grouponpro`.`Attachment`.`class` = 'Deal')) |
|
16 | SELECT `Fbpicture`.`id`, `Fbpicture`.`dir`, `Fbpicture`.`filename`, `Fbpicture`.`width`, `Fbpicture`.`height` FROM `fbpictures` AS `Fbpicture` WHERE `Fbpicture`.`foreign_id` = 17232 AND `Fbpicture`.`class` = 'Deal' | | 1 | 1 | 1 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Fbpicture | | ref | foreign_id,class | foreign_id | 8 | const | 1 | 99.98 | Using where |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`Fbpicture`.`id` AS `id`,`cuponclu_grouponpro`.`Fbpicture`.`dir` AS `dir`,`cuponclu_grouponpro`.`Fbpicture`.`filename` AS `filename`,`cuponclu_grouponpro`.`Fbpicture`.`width` AS `width`,`cuponclu_grouponpro`.`Fbpicture`.`height` AS `height` from `cuponclu_grouponpro`.`fbpictures` `Fbpicture` where ((`cuponclu_grouponpro`.`Fbpicture`.`foreign_id` = 17232) and (`cuponclu_grouponpro`.`Fbpicture`.`class` = 'Deal')) |
|
17 | SELECT `Picture`.`id`, `Picture`.`dir`, `Picture`.`filename`, `Picture`.`width`, `Picture`.`height`, `Picture`.`foreign_id` FROM `pictures` AS `Picture` WHERE `Picture`.`class` = 'Deal' AND `Picture`.`foreign_id` = (17232) ORDER BY `Picture`.`id` ASC | | 3 | 3 | 37 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Picture | | ALL | | | | | 5664 | 1.00 | Using where; Using filesort |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`Picture`.`id` AS `id`,`cuponclu_grouponpro`.`Picture`.`dir` AS `dir`,`cuponclu_grouponpro`.`Picture`.`filename` AS `filename`,`cuponclu_grouponpro`.`Picture`.`width` AS `width`,`cuponclu_grouponpro`.`Picture`.`height` AS `height`,`cuponclu_grouponpro`.`Picture`.`foreign_id` AS `foreign_id` from `cuponclu_grouponpro`.`pictures` `Picture` where ((`cuponclu_grouponpro`.`Picture`.`foreign_id` = 17232) and (`cuponclu_grouponpro`.`Picture`.`class` = 'Deal')) order by `cuponclu_grouponpro`.`Picture`.`id` |
|
18 | SELECT `Deal`.`id`, `Deal`.`created`, `Deal`.`modified`, `Deal`.`user_id`, `Deal`.`name`, `Deal`.`short_name`, `Deal`.`coupon_name`, `Deal`.`display_neighborhoodname`, `Deal`.`slug`, `Deal`.`bitly_short_url`, `Deal`.`description`, `Deal`.`private_note`, `Deal`.`original_price`, `Deal`.`discounted_price`, `Deal`.`start_date`, `Deal`.`end_date`, `Deal`.`sort_order`, `Deal`.`discount_percentage`, `Deal`.`discount_amount`, `Deal`.`savings`, `Deal`.`min_limit`, `Deal`.`max_limit`, `Deal`.`city_id`, `Deal`.`company_id`, `Deal`.`review`, `Deal`.`deal_user_count`, `Deal`.`payment_failed_count`, `Deal`.`buy_min_quantity_per_user`, `Deal`.`buy_max_quantity_per_user`, `Deal`.`deal_tipped_time`, `Deal`.`coupon_expiry_date`, `Deal`.`coupon_condition`, `Deal`.`coupon_highlights`, `Deal`.`comment`, `Deal`.`is_coupon_mail_sent`, `Deal`.`is_subscription_mail_sent`, `Deal`.`is_side_deal`, `Deal`.`deal_status_id`, `Deal`.`bonus_amount`, `Deal`.`commission_percentage`, `Deal`.`commission_percent_unused`, `Deal`.`vat_percent`, `Deal`.`payment1_amt`, `Deal`.`payment1_date`, `Deal`.`payment1_check_no`, `Deal`.`payment1_bank`, `Deal`.`payment1_comm`, `Deal`.`payment1_vat`, `Deal`.`payment1_info`, `Deal`.`payment1_comments`, `Deal`.`payment2_amt`, `Deal`.`payment2_date`, `Deal`.`payment2_check_no`, `Deal`.`payment2_bank`, `Deal`.`payment2_comm`, `Deal`.`payment2_vat`, `Deal`.`payment2_info`, `Deal`.`payment2_comments`, `Deal`.`payment3_amt`, `Deal`.`payment3_date`, `Deal`.`payment3_check_no`, `Deal`.`payment3_bank`, `Deal`.`payment3_comm`, `Deal`.`payment3_vat`, `Deal`.`payment3_info`, `Deal`.`payment3_comments`, `Deal`.`payment4_amt`, `Deal`.`payment4_date`, `Deal`.`payment4_check_no`, `Deal`.`payment4_bank`, `Deal`.`payment4_comm`, `Deal`.`payment4_vat`, `Deal`.`payment4_info`, `Deal`.`payment4_comments`, `Deal`.`first_payment_percent`, `Deal`.`added_coupons`, `Deal`.`total_commission_amount`, `Deal`.`total_purchased_amount`, `Deal`.`net_profit`, `Deal`.`meta_keywords`, `Deal`.`meta_description`, `Deal`.`bitly_short_url_subdomain`, `Deal`.`bitly_short_url_prefix`, `Deal`.`certainly`, `Deal`.`probably`, `Deal`.`unlikely_satisfied`, `Deal`.`unlikely_unsatisfied`, `Deal`.`survey_happy`, `Deal`.`survey_fair`, `Deal`.`survey_sad`, `Deal`.`salesman`, `Deal`.`zone`, `Deal`.`industry`, `Deal`.`category_id`, `Deal`.`sub_category_id`, `Deal`.`gender`, `Deal`.`neighborhood_id`, `Deal`.`sales_projection`, `Deal`.`facebook_description`, `Deal`.`facebook_title`, `City`.`id`, `City`.`created`, `City`.`modified`, `City`.`country_id`, `City`.`state_id`, `City`.`language_id`, `City`.`name`, `City`.`slug`, `City`.`latitude`, `City`.`longitude`, `City`.`dma_id`, `City`.`county`, `City`.`code`, `City`.`deal_count`, `City`.`active_deal_count`, `City`.`is_approved`, `City`.`fb_user_id`, `City`.`fb_access_token`, `City`.`twitter_username`, `City`.`twitter_password`, `City`.`twitter_access_token`, `City`.`twitter_access_key`, `City`.`twitter_url`, `City`.`facebook_url`, `Attachment`.`id`, `Attachment`.`dir`, `Attachment`.`filename`, `Attachment`.`width`, `Attachment`.`height`, `Fbpicture`.`id`, `Fbpicture`.`dir`, `Fbpicture`.`filename`, `Fbpicture`.`width`, `Fbpicture`.`height` FROM `deals` AS `Deal` LEFT JOIN `cities` AS `City` ON (`Deal`.`city_id` = `City`.`id`) LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `Deal`.`id` AND `Attachment`.`class` = 'Deal') LEFT JOIN `fbpictures` AS `Fbpicture` ON (`Fbpicture`.`foreign_id` = `Deal`.`id` AND `Fbpicture`.`class` = 'Deal') WHERE ((`Deal`.`deal_status_id` IN (2, 5)) AND (`Deal`.`slug` != '1-hora-de-boliche-pizza-median-18') AND (`Deal`.`city_id` = 42563)) ORDER BY `Deal`.`sort_order` asc LIMIT 68 | | 59 | 59 | 9 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Deal | | range | city_id,slug,deal_status_id | deal_status_id | 4 | | 137 | 50.81 | Using index condition; Using where; Using filesort |
1 | SIMPLE | City | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | cuponclu_grouponpro.Deal.id | 1 | 100.00 | Using where |
1 | SIMPLE | Fbpicture | | ref | foreign_id,class | foreign_id | 8 | cuponclu_grouponpro.Deal.id | 1 | 100.00 | Using where |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`Deal`.`id` AS `id`,`cuponclu_grouponpro`.`Deal`.`created` AS `created`,`cuponclu_grouponpro`.`Deal`.`modified` AS `modified`,`cuponclu_grouponpro`.`Deal`.`user_id` AS `user_id`,`cuponclu_grouponpro`.`Deal`.`name` AS `name`,`cuponclu_grouponpro`.`Deal`.`short_name` AS `short_name`,`cuponclu_grouponpro`.`Deal`.`coupon_name` AS `coupon_name`,`cuponclu_grouponpro`.`Deal`.`display_neighborhoodname` AS `display_neighborhoodname`,`cuponclu_grouponpro`.`Deal`.`slug` AS `slug`,`cuponclu_grouponpro`.`Deal`.`bitly_short_url` AS `bitly_short_url`,`cuponclu_grouponpro`.`Deal`.`description` AS `description`,`cuponclu_grouponpro`.`Deal`.`private_note` AS `private_note`,`cuponclu_grouponpro`.`Deal`.`original_price` AS `original_price`,`cuponclu_grouponpro`.`Deal`.`discounted_price` AS `discounted_price`,`cuponclu_grouponpro`.`Deal`.`start_date` AS `start_date`,`cuponclu_grouponpro`.`Deal`.`end_date` AS `end_date`,`cuponclu_grouponpro`.`Deal`.`sort_order` AS `sort_order`,`cuponclu_grouponpro`.`Deal`.`discount_percentage` AS `discount_percentage`,`cuponclu_grouponpro`.`Deal`.`discount_amount` AS `discount_amount`,`cuponclu_grouponpro`.`Deal`.`savings` AS `savings`,`cuponclu_grouponpro`.`Deal`.`min_limit` AS `min_limit`,`cuponclu_grouponpro`.`Deal`.`max_limit` AS `max_limit`,`cuponclu_grouponpro`.`Deal`.`city_id` AS `city_id`,`cuponclu_grouponpro`.`Deal`.`company_id` AS `company_id`,`cuponclu_grouponpro`.`Deal`.`review` AS `review`,`cuponclu_grouponpro`.`Deal`.`deal_user_count` AS `deal_user_count`,`cuponclu_grouponpro`.`Deal`.`payment_failed_count` AS `payment_failed_count`,`cuponclu_grouponpro`.`Deal`.`buy_min_quantity_per_user` AS `buy_min_quantity_per_user`,`cuponclu_grouponpro`.`Deal`.`buy_max_quantity_per_user` AS `buy_max_quantity_per_user`,`cuponclu_grouponpro`.`Deal`.`deal_tipped_time` AS `deal_tipped_time`,`cuponclu_grouponpro`.`Deal`.`coupon_expiry_date` AS `coupon_expiry_date`,`cuponclu_grouponpro`.`Deal`.`coupon_condition` AS `coupon_condition`,`cuponclu_grouponpro`.`Deal`.`coupon_highlights` AS `coupon_highlights`,`cuponclu_grouponpro`.`Deal`.`comment` AS `comment`,`cuponclu_grouponpro`.`Deal`.`is_coupon_mail_sent` AS `is_coupon_mail_sent`,`cuponclu_grouponpro`.`Deal`.`is_subscription_mail_sent` AS `is_subscription_mail_sent`,`cuponclu_grouponpro`.`Deal`.`is_side_deal` AS `is_side_deal`,`cuponclu_grouponpro`.`Deal`.`deal_status_id` AS `deal_status_id`,`cuponclu_grouponpro`.`Deal`.`bonus_amount` AS `bonus_amount`,`cuponclu_grouponpro`.`Deal`.`commission_percentage` AS `commission_percentage`,`cuponclu_grouponpro`.`Deal`.`commission_percent_unused` AS `commission_percent_unused`,`cuponclu_grouponpro`.`Deal`.`vat_percent` AS `vat_percent`,`cuponclu_grouponpro`.`Deal`.`payment1_amt` AS `payment1_amt`,`cuponclu_grouponpro`.`Deal`.`payment1_date` AS `payment1_date`,`cuponclu_grouponpro`.`Deal`.`payment1_check_no` AS `payment1_check_no`,`cuponclu_grouponpro`.`Deal`.`payment1_bank` AS `payment1_bank`,`cuponclu_grouponpro`.`Deal`.`payment1_comm` AS `payment1_comm`,`cuponclu_grouponpro`.`Deal`.`payment1_vat` AS `payment1_vat`,`cuponclu_grouponpro`.`Deal`.`payment1_info` AS `payment1_info`,`cuponclu_grouponpro`.`Deal`.`payment1_comments` AS `payment1_comments`,`cuponclu_grouponpro`.`Deal`.`payment2_amt` AS `payment2_amt`,`cuponclu_grouponpro`.`Deal`.`payment2_date` AS `payment2_date`,`cuponclu_grouponpro`.`Deal`.`payment2_check_no` AS `payment2_check_no`,`cuponclu_grouponpro`.`Deal`.`payment2_bank` AS `payment2_bank`,`cuponclu_grouponpro`.`Deal`.`payment2_comm` AS `payment2_comm`,`cuponclu_grouponpro`.`Deal`.`payment2_vat` AS `payment2_vat`,`cuponclu_grouponpro`.`Deal`.`payment2_info` AS `payment2_info`,`cuponclu_grouponpro`.`Deal`.`payment2_comments` AS `payment2_comments`,`cuponclu_grouponpro`.`Deal`.`payment3_amt` AS `payment3_amt`,`cuponclu_grouponpro`.`Deal`.`payment3_date` AS `payment3_date`,`cuponclu_grouponpro`.`Deal`.`payment3_check_no` AS `payment3_check_no`,`cuponclu_grouponpro`.`Deal`.`payment3_bank` AS `payment3_bank`,`cuponclu_grouponpro`.`Deal`.`payment3_comm` AS `payment3_comm`,`cuponclu_grouponpro`.`Deal`.`payment3_vat` AS `payment3_vat`,`cuponclu_grouponpro`.`Deal`.`payment3_info` AS `payment3_info`,`cuponclu_grouponpro`.`Deal`.`payment3_comments` AS `payment3_comments`,`cuponclu_grouponpro`.`Deal`.`payment4_amt` AS `payment4_amt`,`cuponclu_grouponpro`.`Deal`.`payment4_date` AS `payment4_date`,`cuponclu_grouponpro`.`Deal`.`payment4_check_no` AS `payment4_check_no`,`cuponclu_grouponpro`.`Deal`.`payment4_bank` AS `payment4_bank`,`cuponclu_grouponpro`.`Deal`.`payment4_comm` AS `payment4_comm`,`cuponclu_grouponpro`.`Deal`.`payment4_vat` AS `payment4_vat`,`cuponclu_grouponpro`.`Deal`.`payment4_info` AS `payment4_info`,`cuponclu_grouponpro`.`Deal`.`payment4_comments` AS `payment4_comments`,`cuponclu_grouponpro`.`Deal`.`first_payment_percent` AS `first_payment_percent`,`cuponclu_grouponpro`.`Deal`.`added_coupons` AS `added_coupons`,`cuponclu_grouponpro`.`Deal`.`total_commission_amount` AS `total_commission_amount`,`cuponclu_grouponpro`.`Deal`.`total_purchased_amount` AS `total_purchased_amount`,`cuponclu_grouponpro`.`Deal`.`net_profit` AS `net_profit`,`cuponclu_grouponpro`.`Deal`.`meta_keywords` AS `meta_keywords`,`cuponclu_grouponpro`.`Deal`.`meta_description` AS `meta_description`,`cuponclu_grouponpro`.`Deal`.`bitly_short_url_subdomain` AS `bitly_short_url_subdomain`,`cuponclu_grouponpro`.`Deal`.`bitly_short_url_prefix` AS `bitly_short_url_prefix`,`cuponclu_grouponpro`.`Deal`.`certainly` AS `certainly`,`cuponclu_grouponpro`.`Deal`.`probably` AS `probably`,`cuponclu_grouponpro`.`Deal`.`unlikely_satisfied` AS `unlikely_satisfied`,`cuponclu_grouponpro`.`Deal`.`unlikely_unsatisfied` AS `unlikely_unsatisfied`,`cuponclu_grouponpro`.`Deal`.`survey_happy` AS `survey_happy`,`cuponclu_grouponpro`.`Deal`.`survey_fair` AS `survey_fair`,`cuponclu_grouponpro`.`Deal`.`survey_sad` AS `survey_sad`,`cuponclu_grouponpro`.`Deal`.`salesman` AS `salesman`,`cuponclu_grouponpro`.`Deal`.`zone` AS `zone`,`cuponclu_grouponpro`.`Deal`.`industry` AS `industry`,`cuponclu_grouponpro`.`Deal`.`category_id` AS `category_id`,`cuponclu_grouponpro`.`Deal`.`sub_category_id` AS `sub_category_id`,`cuponclu_grouponpro`.`Deal`.`gender` AS `gender`,`cuponclu_grouponpro`.`Deal`.`neighborhood_id` AS `neighborhood_id`,`cuponclu_grouponpro`.`Deal`.`sales_projection` AS `sales_projection`,`cuponclu_grouponpro`.`Deal`.`facebook_description` AS `facebook_description`,`cuponclu_grouponpro`.`Deal`.`facebook_title` AS `facebook_title`,`cuponclu_grouponpro`.`City`.`id` AS `id`,`cuponclu_grouponpro`.`City`.`created` AS `created`,`cuponclu_grouponpro`.`City`.`modified` AS `modified`,`cuponclu_grouponpro`.`City`.`country_id` AS `country_id`,`cuponclu_grouponpro`.`City`.`state_id` AS `state_id`,`cuponclu_grouponpro`.`City`.`language_id` AS `language_id`,`cuponclu_grouponpro`.`City`.`name` AS `name`,`cuponclu_grouponpro`.`City`.`slug` AS `slug`,`cuponclu_grouponpro`.`City`.`latitude` AS `latitude`,`cuponclu_grouponpro`.`City`.`longitude` AS `longitude`,`cuponclu_grouponpro`.`City`.`dma_id` AS `dma_id`,`cuponclu_grouponpro`.`City`.`county` AS `county`,`cuponclu_grouponpro`.`City`.`code` AS `code`,`cuponclu_grouponpro`.`City`.`deal_count` AS `deal_count`,`cuponclu_grouponpro`.`City`.`active_deal_count` AS `active_deal_count`,`cuponclu_grouponpro`.`City`.`is_approved` AS `is_approved`,`cuponclu_grouponpro`.`City`.`fb_user_id` AS `fb_user_id`,`cuponclu_grouponpro`.`City`.`fb_access_token` AS `fb_access_token`,`cuponclu_grouponpro`.`City`.`twitter_username` AS `twitter_username`,`cuponclu_grouponpro`.`City`.`twitter_password` AS `twitter_password`,`cuponclu_grouponpro`.`City`.`twitter_access_token` AS `twitter_access_token`,`cuponclu_grouponpro`.`City`.`twitter_access_key` AS `twitter_access_key`,`cuponclu_grouponpro`.`City`.`twitter_url` AS `twitter_url`,`cuponclu_grouponpro`.`City`.`facebook_url` AS `facebook_url`,`cuponclu_grouponpro`.`Attachment`.`id` AS `id`,`cuponclu_grouponpro`.`Attachment`.`dir` AS `dir`,`cuponclu_grouponpro`.`Attachment`.`filename` AS `filename`,`cuponclu_grouponpro`.`Attachment`.`width` AS `width`,`cuponclu_grouponpro`.`Attachment`.`height` AS `height`,`cuponclu_grouponpro`.`Fbpicture`.`id` AS `id`,`cuponclu_grouponpro`.`Fbpicture`.`dir` AS `dir`,`cuponclu_grouponpro`.`Fbpicture`.`filename` AS `filename`,`cuponclu_grouponpro`.`Fbpicture`.`width` AS `width`,`cuponclu_grouponpro`.`Fbpicture`.`height` AS `height` from `cuponclu_grouponpro`.`deals` `Deal` left join `cuponclu_grouponpro`.`cities` `City` on((`cuponclu_grouponpro`.`City`.`id` = 42563)) left join `cuponclu_grouponpro`.`attachments` `Attachment` on(((`cuponclu_grouponpro`.`Attachment`.`foreign_id` = `cuponclu_grouponpro`.`Deal`.`id`) and (`cuponclu_grouponpro`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_grouponpro`.`fbpictures` `Fbpicture` on(((`cuponclu_grouponpro`.`Fbpicture`.`foreign_id` = `cuponclu_grouponpro`.`Deal`.`id`) and (`cuponclu_grouponpro`.`Fbpicture`.`class` = 'Deal'))) where ((`cuponclu_grouponpro`.`Deal`.`city_id` = 42563) and (`cuponclu_grouponpro`.`Deal`.`deal_status_id` in (2,5)) and (`cuponclu_grouponpro`.`Deal`.`slug` <> '1-hora-de-boliche-pizza-median-18')) order by `cuponclu_grouponpro`.`Deal`.`sort_order` limit 68 |
|
19 | SELECT `Picture`.`id`, `Picture`.`dir`, `Picture`.`filename`, `Picture`.`width`, `Picture`.`height`, `Picture`.`foreign_id` FROM `pictures` AS `Picture` WHERE `Picture`.`class` = 'Deal' AND `Picture`.`foreign_id` IN (18194, 18195, 18079, 18104, 17999, 18127, 17984, 18171, 18123, 17965, 18184, 18161, 18180, 18152, 18134, 18106, 18191, 18121, 18138, 18094, 17992, 18181, 18080, 18072, 18142, 18140, 17991, 18187, 18108, 18083, 18133, 18190, 18186, 18185, 18178, 18170, 18169, 18168, 18160, 18156, 18155, 18150, 18143, 18141, 18139, 18135, 18132, 18126, 18124, 18122, 18120, 18116, 18105, 18093, 18084, 18071, 18063, 18015, 18002) ORDER BY `Picture`.`id` ASC | | 92 | 92 | 30 |
EXPLAIN | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
1 | SIMPLE | Picture | | ALL | | | | | 5664 | 5.00 | Using where; Using filesort |
Level | Code | Message |
---|
Note | 1003 | /* select#1 */ select `cuponclu_grouponpro`.`Picture`.`id` AS `id`,`cuponclu_grouponpro`.`Picture`.`dir` AS `dir`,`cuponclu_grouponpro`.`Picture`.`filename` AS `filename`,`cuponclu_grouponpro`.`Picture`.`width` AS `width`,`cuponclu_grouponpro`.`Picture`.`height` AS `height`,`cuponclu_grouponpro`.`Picture`.`foreign_id` AS `foreign_id` from `cuponclu_grouponpro`.`pictures` `Picture` where ((`cuponclu_grouponpro`.`Picture`.`class` = 'Deal') and (`cuponclu_grouponpro`.`Picture`.`foreign_id` in (18194,18195,18079,18104,17999,18127,17984,18171,18123,17965,18184,18161,18180,18152,18134,18106,18191,18121,18138,18094,17992,18181,18080,18072,18142,18140,17991,18187,18108,18083,18133,18190,18186,18185,18178,18170,18169,18168,18160,18156,18155,18150,18143,18141,18139,18135,18132,18126,18124,18122,18120,18116,18105,18093,18084,18071,18063,18015,18002))) order by `cuponclu_grouponpro`.`Picture`.`id` |
|
Compartir este cupón
Tweet