| 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 | | 213 | 213 | 2 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Setting | | ALL | | | | | 213 | 100.00 | |
| 1 | SIMPLE | SettingCategory | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_playpen120111.Setting.setting_category_id | 1 | 100.00 | Using index condition |
| 1 | SIMPLE | SiteLogo | | ref | foreign_id,class | foreign_id | 8 | cuponclu_playpen120111.Setting.id | 1 | 100.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Setting`.`id` AS `id`,`cuponclu_playpen120111`.`Setting`.`setting_category_id` AS `setting_category_id`,`cuponclu_playpen120111`.`Setting`.`name` AS `name`,`cuponclu_playpen120111`.`Setting`.`value` AS `value`,`cuponclu_playpen120111`.`Setting`.`description` AS `description`,`cuponclu_playpen120111`.`Setting`.`type` AS `type`,`cuponclu_playpen120111`.`Setting`.`options` AS `options`,`cuponclu_playpen120111`.`Setting`.`label` AS `label`,`cuponclu_playpen120111`.`Setting`.`order` AS `order`,`cuponclu_playpen120111`.`SettingCategory`.`id` AS `id`,`cuponclu_playpen120111`.`SettingCategory`.`created` AS `created`,`cuponclu_playpen120111`.`SettingCategory`.`modified` AS `modified`,`cuponclu_playpen120111`.`SettingCategory`.`name` AS `name`,`cuponclu_playpen120111`.`SettingCategory`.`description` AS `description`,`cuponclu_playpen120111`.`SiteLogo`.`id` AS `id`,`cuponclu_playpen120111`.`SiteLogo`.`created` AS `created`,`cuponclu_playpen120111`.`SiteLogo`.`modified` AS `modified`,`cuponclu_playpen120111`.`SiteLogo`.`class` AS `class`,`cuponclu_playpen120111`.`SiteLogo`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`SiteLogo`.`filename` AS `filename`,`cuponclu_playpen120111`.`SiteLogo`.`dir` AS `dir`,`cuponclu_playpen120111`.`SiteLogo`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`SiteLogo`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`SiteLogo`.`height` AS `height`,`cuponclu_playpen120111`.`SiteLogo`.`width` AS `width`,`cuponclu_playpen120111`.`SiteLogo`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`SiteLogo`.`description` AS `description` from `cuponclu_playpen120111`.`settings` `Setting` left join `cuponclu_playpen120111`.`setting_categories` `SettingCategory` on((`cuponclu_playpen120111`.`Setting`.`setting_category_id` = `cuponclu_playpen120111`.`SettingCategory`.`id`)) left join `cuponclu_playpen120111`.`attachments` `SiteLogo` on(((`cuponclu_playpen120111`.`SiteLogo`.`foreign_id` = `cuponclu_playpen120111`.`Setting`.`id`) and (`cuponclu_playpen120111`.`SiteLogo`.`class` = 'SiteLogo'))) where true |
|
|---|
| 2 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'afe58926cacef87866257e00302fb116' | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | cake_sessions | | const | PRIMARY | PRIMARY | 767 | const | 1 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select 'Config|a:4:{s:9:"userAgent";s:32:"ba15070f06aa4c878a6794410449d967";s:4:"time";i:1792626037;s:4:"rand";i:2073681194;s:7:"timeout";i:10;}city_attachment|s:0:"";_Token|s:1213:"a:5:{s:3:"key";s:40:"662a0778a762f5ef24f8cde8295b0c0326368ead";s:7:"expires";i:1792620037;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:35:{i:0;s:10:"Attachment";i:1;s:7:"Picture";i:2;s:9:"Fbpicture";i:3;s:25:"Deal.calculator_min_limit";i:4;s:32:"Deal.calculator_discounted_price";i:5;s:28:"Deal.calculator_bonus_amount";i:6;s:37:"Deal.calculator_commission_percentage";i:7;s:28:"Deal.calculator_bonus_amount";i:8;s:37:"Deal.calculator_commission_percentage";i:9;s:15:"Deal.start_date";i:10;s:13:"Deal.end_date";i:11;s:23:"Deal.coupon_expiry_date";i:12;s:13:"DealStatus.id";i:13;s:15:"DealStatus.name";i:14;s:19:"Deal.original_price";i:15;s:12:"Deal.savings";i:16;s:7:"Deal.id";i:17;s:18:"Deal.save_as_draft";i:18;s:18:"Deal.send_to_admin";i:19;s:15:"Deal.gift_email";i:20;s:14:"Deal.gift_from";i:21;s:12:"Deal.gift_to";i:22;s:12:"Deal.message";i:23;s:13:"Deal.quantity";i:24;s:12:"Deal.message";i:25;s:16:"Deal.deal_amount";i:26;s:12:"Deal.deal_id";i:27;s:12:"Deal.is_gift";i:28;s:21:"User.confirm_password";i:29;s:10:"User.email";i:30;s:11:"User.passwd";i:31;s:13:"User.username";i:32;s:27:"Deal.user_available_balance";i:33;s:12:"Deal.gift_to";i:34;s:13:"Deal.salesman";}}";' AS `data` from `cuponclu_playpen120111`.`cake_sessions` where true |
|
|---|
| 3 | 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` = 'San-salvador' AND `City`.`is_approved` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 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_playpen120111.City.id | 1 | 100.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`City`.`id` AS `id`,`cuponclu_playpen120111`.`City`.`created` AS `created`,`cuponclu_playpen120111`.`City`.`modified` AS `modified`,`cuponclu_playpen120111`.`City`.`country_id` AS `country_id`,`cuponclu_playpen120111`.`City`.`state_id` AS `state_id`,`cuponclu_playpen120111`.`City`.`language_id` AS `language_id`,`cuponclu_playpen120111`.`City`.`name` AS `name`,`cuponclu_playpen120111`.`City`.`slug` AS `slug`,`cuponclu_playpen120111`.`City`.`latitude` AS `latitude`,`cuponclu_playpen120111`.`City`.`longitude` AS `longitude`,`cuponclu_playpen120111`.`City`.`dma_id` AS `dma_id`,`cuponclu_playpen120111`.`City`.`county` AS `county`,`cuponclu_playpen120111`.`City`.`code` AS `code`,`cuponclu_playpen120111`.`City`.`deal_count` AS `deal_count`,`cuponclu_playpen120111`.`City`.`active_deal_count` AS `active_deal_count`,`cuponclu_playpen120111`.`City`.`is_approved` AS `is_approved`,`cuponclu_playpen120111`.`City`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`City`.`fb_access_token` AS `fb_access_token`,`cuponclu_playpen120111`.`City`.`twitter_username` AS `twitter_username`,`cuponclu_playpen120111`.`City`.`twitter_password` AS `twitter_password`,`cuponclu_playpen120111`.`City`.`twitter_access_token` AS `twitter_access_token`,`cuponclu_playpen120111`.`City`.`twitter_access_key` AS `twitter_access_key`,`cuponclu_playpen120111`.`City`.`twitter_url` AS `twitter_url`,`cuponclu_playpen120111`.`City`.`facebook_url` AS `facebook_url`,`cuponclu_playpen120111`.`Attachment`.`id` AS `id`,`cuponclu_playpen120111`.`Attachment`.`created` AS `created`,`cuponclu_playpen120111`.`Attachment`.`modified` AS `modified`,`cuponclu_playpen120111`.`Attachment`.`class` AS `class`,`cuponclu_playpen120111`.`Attachment`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`Attachment`.`filename` AS `filename`,`cuponclu_playpen120111`.`Attachment`.`dir` AS `dir`,`cuponclu_playpen120111`.`Attachment`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`Attachment`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`Attachment`.`height` AS `height`,`cuponclu_playpen120111`.`Attachment`.`width` AS `width`,`cuponclu_playpen120111`.`Attachment`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`Attachment`.`description` AS `description` from `cuponclu_playpen120111`.`cities` `City` left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = `cuponclu_playpen120111`.`City`.`id`) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'City'))) where ((`cuponclu_playpen120111`.`City`.`is_approved` = 1) and (`cuponclu_playpen120111`.`City`.`slug` = 'San-salvador')) limit 1 |
|
|---|
| 4 | 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` = '3628718375') OR (`BannedIp`.`range` = '3628718375') OR (((`BannedIp`.`address` >= '3628718375') AND (`BannedIp`.`range` <= '3628718375'))) OR (((`BannedIp`.`address` <= '3628718375') AND (`BannedIp`.`range` >= '3628718375')))) LIMIT 1 | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | BannedIp | | ALL | address,range | | | | 2 | 85.94 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`BannedIp`.`id` AS `id`,`cuponclu_playpen120111`.`BannedIp`.`created` AS `created`,`cuponclu_playpen120111`.`BannedIp`.`modified` AS `modified`,`cuponclu_playpen120111`.`BannedIp`.`address` AS `address`,`cuponclu_playpen120111`.`BannedIp`.`range` AS `range`,`cuponclu_playpen120111`.`BannedIp`.`referer_url` AS `referer_url`,`cuponclu_playpen120111`.`BannedIp`.`reason` AS `reason`,`cuponclu_playpen120111`.`BannedIp`.`redirect` AS `redirect`,`cuponclu_playpen120111`.`BannedIp`.`thetime` AS `thetime`,`cuponclu_playpen120111`.`BannedIp`.`timespan` AS `timespan` from `cuponclu_playpen120111`.`banned_ips` `BannedIp` where ((`cuponclu_playpen120111`.`BannedIp`.`address` = '3628718375') or (`cuponclu_playpen120111`.`BannedIp`.`range` = '3628718375') or ((`cuponclu_playpen120111`.`BannedIp`.`address` >= '3628718375') and (`cuponclu_playpen120111`.`BannedIp`.`range` <= '3628718375')) or ((`cuponclu_playpen120111`.`BannedIp`.`address` <= '3628718375') and (`cuponclu_playpen120111`.`BannedIp`.`range` >= '3628718375'))) limit 1 |
|
|---|
| 5 | SELECT `DealCategory`.`id`, `DealCategory`.`name` FROM `deal_categories` AS `DealCategory` WHERE 1 = 1 | | 22 | 22 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | DealCategory | | ALL | | | | | 22 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`DealCategory`.`id` AS `id`,`cuponclu_playpen120111`.`DealCategory`.`name` AS `name` from `cuponclu_playpen120111`.`deal_categories` `DealCategory` |
|
|---|
| 6 | 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`.`display_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` = 'srl-testing-long-name-2.9.14' LIMIT 1 | | 1 | 1 | 0 |
| 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_playpen120111.Deal.user_id | 1 | 100.00 | Using index condition |
| 1 | SIMPLE | City | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_playpen120111.Deal.city_id | 1 | 100.00 | |
| 1 | SIMPLE | Company | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_playpen120111.Deal.company_id | 1 | 100.00 | |
| 1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | cuponclu_playpen120111.Deal.id | 1 | 100.00 | Using where |
| 1 | SIMPLE | Fbpicture | | ref | foreign_id,class | foreign_id | 8 | cuponclu_playpen120111.Deal.id | 1 | 100.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Deal`.`id` AS `id`,`cuponclu_playpen120111`.`Deal`.`created` AS `created`,`cuponclu_playpen120111`.`Deal`.`modified` AS `modified`,`cuponclu_playpen120111`.`Deal`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`Deal`.`name` AS `name`,`cuponclu_playpen120111`.`Deal`.`short_name` AS `short_name`,`cuponclu_playpen120111`.`Deal`.`coupon_name` AS `coupon_name`,`cuponclu_playpen120111`.`Deal`.`display_neighborhoodname` AS `display_neighborhoodname`,`cuponclu_playpen120111`.`Deal`.`slug` AS `slug`,`cuponclu_playpen120111`.`Deal`.`bitly_short_url` AS `bitly_short_url`,`cuponclu_playpen120111`.`Deal`.`description` AS `description`,`cuponclu_playpen120111`.`Deal`.`private_note` AS `private_note`,`cuponclu_playpen120111`.`Deal`.`original_price` AS `original_price`,`cuponclu_playpen120111`.`Deal`.`discounted_price` AS `discounted_price`,`cuponclu_playpen120111`.`Deal`.`start_date` AS `start_date`,`cuponclu_playpen120111`.`Deal`.`end_date` AS `end_date`,`cuponclu_playpen120111`.`Deal`.`sort_order` AS `sort_order`,`cuponclu_playpen120111`.`Deal`.`discount_percentage` AS `discount_percentage`,`cuponclu_playpen120111`.`Deal`.`discount_amount` AS `discount_amount`,`cuponclu_playpen120111`.`Deal`.`savings` AS `savings`,`cuponclu_playpen120111`.`Deal`.`min_limit` AS `min_limit`,`cuponclu_playpen120111`.`Deal`.`max_limit` AS `max_limit`,`cuponclu_playpen120111`.`Deal`.`city_id` AS `city_id`,`cuponclu_playpen120111`.`Deal`.`display_city_id` AS `display_city_id`,`cuponclu_playpen120111`.`Deal`.`company_id` AS `company_id`,`cuponclu_playpen120111`.`Deal`.`review` AS `review`,`cuponclu_playpen120111`.`Deal`.`deal_user_count` AS `deal_user_count`,`cuponclu_playpen120111`.`Deal`.`payment_failed_count` AS `payment_failed_count`,`cuponclu_playpen120111`.`Deal`.`buy_min_quantity_per_user` AS `buy_min_quantity_per_user`,`cuponclu_playpen120111`.`Deal`.`buy_max_quantity_per_user` AS `buy_max_quantity_per_user`,`cuponclu_playpen120111`.`Deal`.`deal_tipped_time` AS `deal_tipped_time`,`cuponclu_playpen120111`.`Deal`.`coupon_expiry_date` AS `coupon_expiry_date`,`cuponclu_playpen120111`.`Deal`.`coupon_condition` AS `coupon_condition`,`cuponclu_playpen120111`.`Deal`.`coupon_highlights` AS `coupon_highlights`,`cuponclu_playpen120111`.`Deal`.`comment` AS `comment`,`cuponclu_playpen120111`.`Deal`.`is_coupon_mail_sent` AS `is_coupon_mail_sent`,`cuponclu_playpen120111`.`Deal`.`is_subscription_mail_sent` AS `is_subscription_mail_sent`,`cuponclu_playpen120111`.`Deal`.`is_side_deal` AS `is_side_deal`,`cuponclu_playpen120111`.`Deal`.`deal_status_id` AS `deal_status_id`,`cuponclu_playpen120111`.`Deal`.`bonus_amount` AS `bonus_amount`,`cuponclu_playpen120111`.`Deal`.`commission_percentage` AS `commission_percentage`,`cuponclu_playpen120111`.`Deal`.`commission_percent_unused` AS `commission_percent_unused`,`cuponclu_playpen120111`.`Deal`.`vat_percent` AS `vat_percent`,`cuponclu_playpen120111`.`Deal`.`payment1_amt` AS `payment1_amt`,`cuponclu_playpen120111`.`Deal`.`payment1_date` AS `payment1_date`,`cuponclu_playpen120111`.`Deal`.`payment1_check_no` AS `payment1_check_no`,`cuponclu_playpen120111`.`Deal`.`payment1_bank` AS `payment1_bank`,`cuponclu_playpen120111`.`Deal`.`payment1_comm` AS `payment1_comm`,`cuponclu_playpen120111`.`Deal`.`payment1_vat` AS `payment1_vat`,`cuponclu_playpen120111`.`Deal`.`payment1_info` AS `payment1_info`,`cuponclu_playpen120111`.`Deal`.`payment1_comments` AS `payment1_comments`,`cuponclu_playpen120111`.`Deal`.`payment2_amt` AS `payment2_amt`,`cuponclu_playpen120111`.`Deal`.`payment2_date` AS `payment2_date`,`cuponclu_playpen120111`.`Deal`.`payment2_check_no` AS `payment2_check_no`,`cuponclu_playpen120111`.`Deal`.`payment2_bank` AS `payment2_bank`,`cuponclu_playpen120111`.`Deal`.`payment2_comm` AS `payment2_comm`,`cuponclu_playpen120111`.`Deal`.`payment2_vat` AS `payment2_vat`,`cuponclu_playpen120111`.`Deal`.`payment2_info` AS `payment2_info`,`cuponclu_playpen120111`.`Deal`.`payment2_comments` AS `payment2_comments`,`cuponclu_playpen120111`.`Deal`.`payment3_amt` AS `payment3_amt`,`cuponclu_playpen120111`.`Deal`.`payment3_date` AS `payment3_date`,`cuponclu_playpen120111`.`Deal`.`payment3_check_no` AS `payment3_check_no`,`cuponclu_playpen120111`.`Deal`.`payment3_bank` AS `payment3_bank`,`cuponclu_playpen120111`.`Deal`.`payment3_comm` AS `payment3_comm`,`cuponclu_playpen120111`.`Deal`.`payment3_vat` AS `payment3_vat`,`cuponclu_playpen120111`.`Deal`.`payment3_info` AS `payment3_info`,`cuponclu_playpen120111`.`Deal`.`payment3_comments` AS `payment3_comments`,`cuponclu_playpen120111`.`Deal`.`payment4_amt` AS `payment4_amt`,`cuponclu_playpen120111`.`Deal`.`payment4_date` AS `payment4_date`,`cuponclu_playpen120111`.`Deal`.`payment4_check_no` AS `payment4_check_no`,`cuponclu_playpen120111`.`Deal`.`payment4_bank` AS `payment4_bank`,`cuponclu_playpen120111`.`Deal`.`payment4_comm` AS `payment4_comm`,`cuponclu_playpen120111`.`Deal`.`payment4_vat` AS `payment4_vat`,`cuponclu_playpen120111`.`Deal`.`payment4_info` AS `payment4_info`,`cuponclu_playpen120111`.`Deal`.`payment4_comments` AS `payment4_comments`,`cuponclu_playpen120111`.`Deal`.`first_payment_percent` AS `first_payment_percent`,`cuponclu_playpen120111`.`Deal`.`added_coupons` AS `added_coupons`,`cuponclu_playpen120111`.`Deal`.`total_commission_amount` AS `total_commission_amount`,`cuponclu_playpen120111`.`Deal`.`total_purchased_amount` AS `total_purchased_amount`,`cuponclu_playpen120111`.`Deal`.`net_profit` AS `net_profit`,`cuponclu_playpen120111`.`Deal`.`meta_keywords` AS `meta_keywords`,`cuponclu_playpen120111`.`Deal`.`meta_description` AS `meta_description`,`cuponclu_playpen120111`.`Deal`.`bitly_short_url_subdomain` AS `bitly_short_url_subdomain`,`cuponclu_playpen120111`.`Deal`.`bitly_short_url_prefix` AS `bitly_short_url_prefix`,`cuponclu_playpen120111`.`Deal`.`certainly` AS `certainly`,`cuponclu_playpen120111`.`Deal`.`probably` AS `probably`,`cuponclu_playpen120111`.`Deal`.`unlikely_satisfied` AS `unlikely_satisfied`,`cuponclu_playpen120111`.`Deal`.`unlikely_unsatisfied` AS `unlikely_unsatisfied`,`cuponclu_playpen120111`.`Deal`.`survey_happy` AS `survey_happy`,`cuponclu_playpen120111`.`Deal`.`survey_fair` AS `survey_fair`,`cuponclu_playpen120111`.`Deal`.`survey_sad` AS `survey_sad`,`cuponclu_playpen120111`.`Deal`.`salesman` AS `salesman`,`cuponclu_playpen120111`.`Deal`.`zone` AS `zone`,`cuponclu_playpen120111`.`Deal`.`industry` AS `industry`,`cuponclu_playpen120111`.`Deal`.`category_id` AS `category_id`,`cuponclu_playpen120111`.`Deal`.`sub_category_id` AS `sub_category_id`,`cuponclu_playpen120111`.`Deal`.`gender` AS `gender`,`cuponclu_playpen120111`.`Deal`.`neighborhood_id` AS `neighborhood_id`,`cuponclu_playpen120111`.`Deal`.`sales_projection` AS `sales_projection`,`cuponclu_playpen120111`.`Deal`.`facebook_description` AS `facebook_description`,`cuponclu_playpen120111`.`Deal`.`facebook_title` AS `facebook_title`,`cuponclu_playpen120111`.`User`.`user_type_id` AS `user_type_id`,`cuponclu_playpen120111`.`User`.`username` AS `username`,`cuponclu_playpen120111`.`User`.`id` AS `id`,`cuponclu_playpen120111`.`User`.`email` AS `email`,`cuponclu_playpen120111`.`User`.`password` AS `password`,`cuponclu_playpen120111`.`City`.`id` AS `id`,`cuponclu_playpen120111`.`City`.`name` AS `name`,`cuponclu_playpen120111`.`City`.`slug` AS `slug`,`cuponclu_playpen120111`.`Company`.`name` AS `name`,`cuponclu_playpen120111`.`Company`.`slug` AS `slug`,`cuponclu_playpen120111`.`Company`.`id` AS `id`,`cuponclu_playpen120111`.`Company`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`Company`.`url` AS `url`,`cuponclu_playpen120111`.`Company`.`zip` AS `zip`,`cuponclu_playpen120111`.`Company`.`address1` AS `address1`,`cuponclu_playpen120111`.`Company`.`address2` AS `address2`,`cuponclu_playpen120111`.`Company`.`city_id` AS `city_id`,`cuponclu_playpen120111`.`Company`.`latitude` AS `latitude`,`cuponclu_playpen120111`.`Company`.`longitude` AS `longitude`,`cuponclu_playpen120111`.`Company`.`is_company_profile_enabled` AS `is_company_profile_enabled`,`cuponclu_playpen120111`.`Company`.`is_online_account` AS `is_online_account`,`cuponclu_playpen120111`.`Company`.`map_zoom_level` AS `map_zoom_level`,`cuponclu_playpen120111`.`Company`.`survey_responses` AS `survey_responses`,`cuponclu_playpen120111`.`Company`.`half_stars` AS `half_stars`,`cuponclu_playpen120111`.`Company`.`percent_to_return` AS `percent_to_return`,`cuponclu_playpen120111`.`Company`.`state_id` AS `state_id`,`cuponclu_playpen120111`.`Company`.`country_id` AS `country_id`,`cuponclu_playpen120111`.`Attachment`.`id` AS `id`,`cuponclu_playpen120111`.`Attachment`.`dir` AS `dir`,`cuponclu_playpen120111`.`Attachment`.`filename` AS `filename`,`cuponclu_playpen120111`.`Attachment`.`width` AS `width`,`cuponclu_playpen120111`.`Attachment`.`height` AS `height`,`cuponclu_playpen120111`.`Fbpicture`.`id` AS `id`,`cuponclu_playpen120111`.`Fbpicture`.`dir` AS `dir`,`cuponclu_playpen120111`.`Fbpicture`.`filename` AS `filename`,`cuponclu_playpen120111`.`Fbpicture`.`width` AS `width`,`cuponclu_playpen120111`.`Fbpicture`.`height` AS `height` from `cuponclu_playpen120111`.`deals` `Deal` left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`Deal`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`cities` `City` on((`cuponclu_playpen120111`.`City`.`id` = `cuponclu_playpen120111`.`Deal`.`city_id`)) left join `cuponclu_playpen120111`.`companies` `Company` on((`cuponclu_playpen120111`.`Company`.`id` = `cuponclu_playpen120111`.`Deal`.`company_id`)) left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = `cuponclu_playpen120111`.`Deal`.`id`) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = `cuponclu_playpen120111`.`Deal`.`id`) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where (`cuponclu_playpen120111`.`Deal`.`slug` = 'srl-testing-long-name-2.9.14') limit 1 |
|
|---|
| 7 | SELECT `User`.`user_type_id`, `User`.`username`, `User`.`id`, `User`.`email`, `User`.`password` FROM `users` AS `User` WHERE `User`.`id` = 798 | | 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 '1' AS `user_type_id`,'admin3' AS `username`,'798' AS `id`,'p.ippolito2@cuponclub.net' AS `email`,'09133bda269af8e4cee9bd9c61bfc03e35cb9744' AS `password` from `cuponclu_playpen120111`.`users` `User` where true |
|
|---|
| 8 | SELECT `City`.`id`, `City`.`name`, `City`.`slug` FROM `cities` AS `City` WHERE `City`.`id` = 42553 | | 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 '42553' AS `id`,'San Salvador' AS `name`,'San-salvador' AS `slug` from `cuponclu_playpen120111`.`cities` `City` where true |
|
|---|
| 9 | 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` = 282 | | 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 'Entre Pinos Resort & Spa ' AS `name`,'entre-pinos-resort-spa' AS `slug`,'282' AS `id`,'11199' AS `user_id`,'' AS `url`,'0000-0001' AS `zip`,'Carretera Troncal del Nte, km. 87 1/2 ' AS `address1`,'' AS `address2`,'42767' AS `city_id`,'14.333973' AS `latitude`,'-89.178856' AS `longitude`,'0' AS `is_company_profile_enabled`,'1' AS `is_online_account`,'15' AS `map_zoom_level`,'0' AS `survey_responses`,'0' AS `half_stars`,NULL AS `percent_to_return`,'125' AS `state_id`,'69' AS `country_id` from `cuponclu_playpen120111`.`companies` `Company` where true |
|
|---|
| 10 | SELECT `City`.`id`, `City`.`name`, `City`.`slug` FROM `cities` AS `City` WHERE `City`.`id` = 42767 | | 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 '42767' AS `id`,'Guatemala City' AS `name`,'guatemala-city-1' AS `slug` from `cuponclu_playpen120111`.`cities` `City` where true |
|
|---|
| 11 | SELECT `State`.`id`, `State`.`name` FROM `states` AS `State` WHERE `State`.`id` = 125 | | 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 '125' AS `id`,'Chalatenango' AS `name` from `cuponclu_playpen120111`.`states` `State` where true |
|
|---|
| 12 | SELECT `Country`.`id`, `Country`.`name`, `Country`.`slug` FROM `countries` AS `Country` WHERE `Country`.`id` = 69 | | 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 '69' AS `id`,'El Salvador' AS `name`,'el-salvador' AS `slug` from `cuponclu_playpen120111`.`countries` `Country` where true |
|
|---|
| 13 | 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` = (282) LIMIT 5 | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | | | Impossible WHERE noticed after reading const tables |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select '2' AS `id`,'2011-11-07 23:50:19' AS `created`,'2011-11-07 23:50:19' AS `modified`,'Col. Escalon entre la 85 y 87ave. Norte No. 4436.' AS `address1`,'' AS `address2`,'246' AS `company_id`,'42553' AS `city_id`,'102' AS `state_id`,'69' AS `country_id`,'' AS `phone`,NULL AS `zip`,'' AS `url`,NULL AS `latitude`,NULL AS `longitude` from dual where false limit 5 |
|
|---|
| 14 | SELECT `Attachment`.`id`, `Attachment`.`dir`, `Attachment`.`filename`, `Attachment`.`width`, `Attachment`.`height` FROM `attachments` AS `Attachment` WHERE `Attachment`.`foreign_id` = 366 AND `Attachment`.`class` = 'Deal' | | 1 | 1 | 0 |
| 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 | 61.23 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Attachment`.`id` AS `id`,`cuponclu_playpen120111`.`Attachment`.`dir` AS `dir`,`cuponclu_playpen120111`.`Attachment`.`filename` AS `filename`,`cuponclu_playpen120111`.`Attachment`.`width` AS `width`,`cuponclu_playpen120111`.`Attachment`.`height` AS `height` from `cuponclu_playpen120111`.`attachments` `Attachment` where ((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 366) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal')) |
|
|---|
| 15 | SELECT `Fbpicture`.`id`, `Fbpicture`.`dir`, `Fbpicture`.`filename`, `Fbpicture`.`width`, `Fbpicture`.`height` FROM `fbpictures` AS `Fbpicture` WHERE `Fbpicture`.`foreign_id` = 366 AND `Fbpicture`.`class` = 'Deal' | | 0 | 0 | 0 |
| 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 | 80.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Fbpicture`.`id` AS `id`,`cuponclu_playpen120111`.`Fbpicture`.`dir` AS `dir`,`cuponclu_playpen120111`.`Fbpicture`.`filename` AS `filename`,`cuponclu_playpen120111`.`Fbpicture`.`width` AS `width`,`cuponclu_playpen120111`.`Fbpicture`.`height` AS `height` from `cuponclu_playpen120111`.`fbpictures` `Fbpicture` where ((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 366) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal')) |
|
|---|
| 16 | 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` = (366) ORDER BY `Picture`.`id` ASC | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Picture | | ALL | | | | | 27 | 3.70 | Using where; Using filesort |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Picture`.`id` AS `id`,`cuponclu_playpen120111`.`Picture`.`dir` AS `dir`,`cuponclu_playpen120111`.`Picture`.`filename` AS `filename`,`cuponclu_playpen120111`.`Picture`.`width` AS `width`,`cuponclu_playpen120111`.`Picture`.`height` AS `height`,`cuponclu_playpen120111`.`Picture`.`foreign_id` AS `foreign_id` from `cuponclu_playpen120111`.`pictures` `Picture` where ((`cuponclu_playpen120111`.`Picture`.`foreign_id` = 366) and (`cuponclu_playpen120111`.`Picture`.`class` = 'Deal')) order by `cuponclu_playpen120111`.`Picture`.`id` |
|
|---|
| 17 | 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`.`display_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` != 'srl-testing-long-name-2.9.14') AND (`Deal`.`city_id` = 42553)) ORDER BY `Deal`.`sort_order` asc LIMIT 68 | | 30 | 30 | 1 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Deal | | ref | city_id,slug,deal_status_id | city_id | 8 | const | 134 | 21.21 | 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_playpen120111.Deal.id | 1 | 100.00 | Using where |
| 1 | SIMPLE | Fbpicture | | ref | foreign_id,class | foreign_id | 8 | cuponclu_playpen120111.Deal.id | 1 | 100.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Deal`.`id` AS `id`,`cuponclu_playpen120111`.`Deal`.`created` AS `created`,`cuponclu_playpen120111`.`Deal`.`modified` AS `modified`,`cuponclu_playpen120111`.`Deal`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`Deal`.`name` AS `name`,`cuponclu_playpen120111`.`Deal`.`short_name` AS `short_name`,`cuponclu_playpen120111`.`Deal`.`coupon_name` AS `coupon_name`,`cuponclu_playpen120111`.`Deal`.`display_neighborhoodname` AS `display_neighborhoodname`,`cuponclu_playpen120111`.`Deal`.`slug` AS `slug`,`cuponclu_playpen120111`.`Deal`.`bitly_short_url` AS `bitly_short_url`,`cuponclu_playpen120111`.`Deal`.`description` AS `description`,`cuponclu_playpen120111`.`Deal`.`private_note` AS `private_note`,`cuponclu_playpen120111`.`Deal`.`original_price` AS `original_price`,`cuponclu_playpen120111`.`Deal`.`discounted_price` AS `discounted_price`,`cuponclu_playpen120111`.`Deal`.`start_date` AS `start_date`,`cuponclu_playpen120111`.`Deal`.`end_date` AS `end_date`,`cuponclu_playpen120111`.`Deal`.`sort_order` AS `sort_order`,`cuponclu_playpen120111`.`Deal`.`discount_percentage` AS `discount_percentage`,`cuponclu_playpen120111`.`Deal`.`discount_amount` AS `discount_amount`,`cuponclu_playpen120111`.`Deal`.`savings` AS `savings`,`cuponclu_playpen120111`.`Deal`.`min_limit` AS `min_limit`,`cuponclu_playpen120111`.`Deal`.`max_limit` AS `max_limit`,`cuponclu_playpen120111`.`Deal`.`city_id` AS `city_id`,`cuponclu_playpen120111`.`Deal`.`display_city_id` AS `display_city_id`,`cuponclu_playpen120111`.`Deal`.`company_id` AS `company_id`,`cuponclu_playpen120111`.`Deal`.`review` AS `review`,`cuponclu_playpen120111`.`Deal`.`deal_user_count` AS `deal_user_count`,`cuponclu_playpen120111`.`Deal`.`payment_failed_count` AS `payment_failed_count`,`cuponclu_playpen120111`.`Deal`.`buy_min_quantity_per_user` AS `buy_min_quantity_per_user`,`cuponclu_playpen120111`.`Deal`.`buy_max_quantity_per_user` AS `buy_max_quantity_per_user`,`cuponclu_playpen120111`.`Deal`.`deal_tipped_time` AS `deal_tipped_time`,`cuponclu_playpen120111`.`Deal`.`coupon_expiry_date` AS `coupon_expiry_date`,`cuponclu_playpen120111`.`Deal`.`coupon_condition` AS `coupon_condition`,`cuponclu_playpen120111`.`Deal`.`coupon_highlights` AS `coupon_highlights`,`cuponclu_playpen120111`.`Deal`.`comment` AS `comment`,`cuponclu_playpen120111`.`Deal`.`is_coupon_mail_sent` AS `is_coupon_mail_sent`,`cuponclu_playpen120111`.`Deal`.`is_subscription_mail_sent` AS `is_subscription_mail_sent`,`cuponclu_playpen120111`.`Deal`.`is_side_deal` AS `is_side_deal`,`cuponclu_playpen120111`.`Deal`.`deal_status_id` AS `deal_status_id`,`cuponclu_playpen120111`.`Deal`.`bonus_amount` AS `bonus_amount`,`cuponclu_playpen120111`.`Deal`.`commission_percentage` AS `commission_percentage`,`cuponclu_playpen120111`.`Deal`.`commission_percent_unused` AS `commission_percent_unused`,`cuponclu_playpen120111`.`Deal`.`vat_percent` AS `vat_percent`,`cuponclu_playpen120111`.`Deal`.`payment1_amt` AS `payment1_amt`,`cuponclu_playpen120111`.`Deal`.`payment1_date` AS `payment1_date`,`cuponclu_playpen120111`.`Deal`.`payment1_check_no` AS `payment1_check_no`,`cuponclu_playpen120111`.`Deal`.`payment1_bank` AS `payment1_bank`,`cuponclu_playpen120111`.`Deal`.`payment1_comm` AS `payment1_comm`,`cuponclu_playpen120111`.`Deal`.`payment1_vat` AS `payment1_vat`,`cuponclu_playpen120111`.`Deal`.`payment1_info` AS `payment1_info`,`cuponclu_playpen120111`.`Deal`.`payment1_comments` AS `payment1_comments`,`cuponclu_playpen120111`.`Deal`.`payment2_amt` AS `payment2_amt`,`cuponclu_playpen120111`.`Deal`.`payment2_date` AS `payment2_date`,`cuponclu_playpen120111`.`Deal`.`payment2_check_no` AS `payment2_check_no`,`cuponclu_playpen120111`.`Deal`.`payment2_bank` AS `payment2_bank`,`cuponclu_playpen120111`.`Deal`.`payment2_comm` AS `payment2_comm`,`cuponclu_playpen120111`.`Deal`.`payment2_vat` AS `payment2_vat`,`cuponclu_playpen120111`.`Deal`.`payment2_info` AS `payment2_info`,`cuponclu_playpen120111`.`Deal`.`payment2_comments` AS `payment2_comments`,`cuponclu_playpen120111`.`Deal`.`payment3_amt` AS `payment3_amt`,`cuponclu_playpen120111`.`Deal`.`payment3_date` AS `payment3_date`,`cuponclu_playpen120111`.`Deal`.`payment3_check_no` AS `payment3_check_no`,`cuponclu_playpen120111`.`Deal`.`payment3_bank` AS `payment3_bank`,`cuponclu_playpen120111`.`Deal`.`payment3_comm` AS `payment3_comm`,`cuponclu_playpen120111`.`Deal`.`payment3_vat` AS `payment3_vat`,`cuponclu_playpen120111`.`Deal`.`payment3_info` AS `payment3_info`,`cuponclu_playpen120111`.`Deal`.`payment3_comments` AS `payment3_comments`,`cuponclu_playpen120111`.`Deal`.`payment4_amt` AS `payment4_amt`,`cuponclu_playpen120111`.`Deal`.`payment4_date` AS `payment4_date`,`cuponclu_playpen120111`.`Deal`.`payment4_check_no` AS `payment4_check_no`,`cuponclu_playpen120111`.`Deal`.`payment4_bank` AS `payment4_bank`,`cuponclu_playpen120111`.`Deal`.`payment4_comm` AS `payment4_comm`,`cuponclu_playpen120111`.`Deal`.`payment4_vat` AS `payment4_vat`,`cuponclu_playpen120111`.`Deal`.`payment4_info` AS `payment4_info`,`cuponclu_playpen120111`.`Deal`.`payment4_comments` AS `payment4_comments`,`cuponclu_playpen120111`.`Deal`.`first_payment_percent` AS `first_payment_percent`,`cuponclu_playpen120111`.`Deal`.`added_coupons` AS `added_coupons`,`cuponclu_playpen120111`.`Deal`.`total_commission_amount` AS `total_commission_amount`,`cuponclu_playpen120111`.`Deal`.`total_purchased_amount` AS `total_purchased_amount`,`cuponclu_playpen120111`.`Deal`.`net_profit` AS `net_profit`,`cuponclu_playpen120111`.`Deal`.`meta_keywords` AS `meta_keywords`,`cuponclu_playpen120111`.`Deal`.`meta_description` AS `meta_description`,`cuponclu_playpen120111`.`Deal`.`bitly_short_url_subdomain` AS `bitly_short_url_subdomain`,`cuponclu_playpen120111`.`Deal`.`bitly_short_url_prefix` AS `bitly_short_url_prefix`,`cuponclu_playpen120111`.`Deal`.`certainly` AS `certainly`,`cuponclu_playpen120111`.`Deal`.`probably` AS `probably`,`cuponclu_playpen120111`.`Deal`.`unlikely_satisfied` AS `unlikely_satisfied`,`cuponclu_playpen120111`.`Deal`.`unlikely_unsatisfied` AS `unlikely_unsatisfied`,`cuponclu_playpen120111`.`Deal`.`survey_happy` AS `survey_happy`,`cuponclu_playpen120111`.`Deal`.`survey_fair` AS `survey_fair`,`cuponclu_playpen120111`.`Deal`.`survey_sad` AS `survey_sad`,`cuponclu_playpen120111`.`Deal`.`salesman` AS `salesman`,`cuponclu_playpen120111`.`Deal`.`zone` AS `zone`,`cuponclu_playpen120111`.`Deal`.`industry` AS `industry`,`cuponclu_playpen120111`.`Deal`.`category_id` AS `category_id`,`cuponclu_playpen120111`.`Deal`.`sub_category_id` AS `sub_category_id`,`cuponclu_playpen120111`.`Deal`.`gender` AS `gender`,`cuponclu_playpen120111`.`Deal`.`neighborhood_id` AS `neighborhood_id`,`cuponclu_playpen120111`.`Deal`.`sales_projection` AS `sales_projection`,`cuponclu_playpen120111`.`Deal`.`facebook_description` AS `facebook_description`,`cuponclu_playpen120111`.`Deal`.`facebook_title` AS `facebook_title`,`cuponclu_playpen120111`.`City`.`id` AS `id`,`cuponclu_playpen120111`.`City`.`created` AS `created`,`cuponclu_playpen120111`.`City`.`modified` AS `modified`,`cuponclu_playpen120111`.`City`.`country_id` AS `country_id`,`cuponclu_playpen120111`.`City`.`state_id` AS `state_id`,`cuponclu_playpen120111`.`City`.`language_id` AS `language_id`,`cuponclu_playpen120111`.`City`.`name` AS `name`,`cuponclu_playpen120111`.`City`.`slug` AS `slug`,`cuponclu_playpen120111`.`City`.`latitude` AS `latitude`,`cuponclu_playpen120111`.`City`.`longitude` AS `longitude`,`cuponclu_playpen120111`.`City`.`dma_id` AS `dma_id`,`cuponclu_playpen120111`.`City`.`county` AS `county`,`cuponclu_playpen120111`.`City`.`code` AS `code`,`cuponclu_playpen120111`.`City`.`deal_count` AS `deal_count`,`cuponclu_playpen120111`.`City`.`active_deal_count` AS `active_deal_count`,`cuponclu_playpen120111`.`City`.`is_approved` AS `is_approved`,`cuponclu_playpen120111`.`City`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`City`.`fb_access_token` AS `fb_access_token`,`cuponclu_playpen120111`.`City`.`twitter_username` AS `twitter_username`,`cuponclu_playpen120111`.`City`.`twitter_password` AS `twitter_password`,`cuponclu_playpen120111`.`City`.`twitter_access_token` AS `twitter_access_token`,`cuponclu_playpen120111`.`City`.`twitter_access_key` AS `twitter_access_key`,`cuponclu_playpen120111`.`City`.`twitter_url` AS `twitter_url`,`cuponclu_playpen120111`.`City`.`facebook_url` AS `facebook_url`,`cuponclu_playpen120111`.`Attachment`.`id` AS `id`,`cuponclu_playpen120111`.`Attachment`.`dir` AS `dir`,`cuponclu_playpen120111`.`Attachment`.`filename` AS `filename`,`cuponclu_playpen120111`.`Attachment`.`width` AS `width`,`cuponclu_playpen120111`.`Attachment`.`height` AS `height`,`cuponclu_playpen120111`.`Fbpicture`.`id` AS `id`,`cuponclu_playpen120111`.`Fbpicture`.`dir` AS `dir`,`cuponclu_playpen120111`.`Fbpicture`.`filename` AS `filename`,`cuponclu_playpen120111`.`Fbpicture`.`width` AS `width`,`cuponclu_playpen120111`.`Fbpicture`.`height` AS `height` from `cuponclu_playpen120111`.`deals` `Deal` left join `cuponclu_playpen120111`.`cities` `City` on((`cuponclu_playpen120111`.`City`.`id` = 42553)) left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = `cuponclu_playpen120111`.`Deal`.`id`) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = `cuponclu_playpen120111`.`Deal`.`id`) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where ((`cuponclu_playpen120111`.`Deal`.`city_id` = 42553) and (`cuponclu_playpen120111`.`Deal`.`deal_status_id` in (2,5)) and (`cuponclu_playpen120111`.`Deal`.`slug` <> 'srl-testing-long-name-2.9.14')) order by `cuponclu_playpen120111`.`Deal`.`sort_order` limit 68 |
|
|---|
| 18 | 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 (6774, 6816, 6795, 6794, 6793, 6792, 6786, 6785, 6784, 6783, 6782, 6779, 6778, 6771, 6768, 6767, 6766, 6763, 6762, 6759, 6758, 6755, 6754, 6753, 6746, 6745, 6742, 6739, 6736, 6721) ORDER BY `Picture`.`id` ASC | | 5 | 5 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Picture | | ALL | | | | | 27 | 5.00 | Using where; Using filesort |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Picture`.`id` AS `id`,`cuponclu_playpen120111`.`Picture`.`dir` AS `dir`,`cuponclu_playpen120111`.`Picture`.`filename` AS `filename`,`cuponclu_playpen120111`.`Picture`.`width` AS `width`,`cuponclu_playpen120111`.`Picture`.`height` AS `height`,`cuponclu_playpen120111`.`Picture`.`foreign_id` AS `foreign_id` from `cuponclu_playpen120111`.`pictures` `Picture` where ((`cuponclu_playpen120111`.`Picture`.`class` = 'Deal') and (`cuponclu_playpen120111`.`Picture`.`foreign_id` in (6774,6816,6795,6794,6793,6792,6786,6785,6784,6783,6782,6779,6778,6771,6768,6767,6766,6763,6762,6759,6758,6755,6754,6753,6746,6745,6742,6739,6736,6721))) order by `cuponclu_playpen120111`.`Picture`.`id` |
|
|---|
![[Imagen:WhatsApp]](https://www.playpen.cuponclub.net/img/blue-theme/whatsappheader.png "WhatsApp"){kind=small}
7568-9447 ![[Image: SRL Testing Long Name 2.9.14m]](/img/wide_big_thumb/Deal/1011.be467fda4f2d61f5e26532a2c88ec2a1.jpg "SRL Testing Long Name 2.9.14")
![[Image: SRL Testing Long Name 2.9.14m]](/img/jcarousel_thumb/Deal/1011.32feb9a76690864cd5e094ef0aa1c166.jpg "SRL Testing Long Name 2.9.14")
![[Image: PRUEBA-NO COMPRAR¡Paga $12 en lugar de $50 por Manicure + Pedicure + Esmaltado Permanente en Manos y Pies + Exfoliación + Mascarilla!m]](/img/wide_small_big_thumb/Deal/1304.296d73a68a73f3dd4dfa762d61d9ad6c.jpg "PRUEBA-NO COMPRAR¡Paga $12 en lugar de $50 por Manicure + Pedicure + Esmaltado Permanente en Manos y Pies + Exfoliación + Mascarilla!")
![[Image: Test Sort Orderm]](/img/wide_small_big_thumb/Deal/1322.726d0ddf4dd53760dd65dbf9ae8fea23.jpg "Test Sort Order")
![[Image: PRUEBA-NO COMPRAR¡Paga $62 en Lugar de $160 por Estadía para 2 Adultos y 2 Niños o para 3 Adultos + Desayunos + Parrillada para 2!m]](/img/wide_small_big_thumb/Deal/1309.b68c7f26135471d8beeabb6fe6498177.jpg "PRUEBA-NO COMPRAR¡Paga $62 en Lugar de $160 por Estadía para 2 Adultos y 2 Niños o para 3 Adultos + Desayunos + Parrillada para 2!")
![[Image: PRUEBA-NO COMPRAR¡Paga $29.99 en Lugar de $72.99 por Banquete para 4 Personas con: 1 Entrada de Aros de Cebollas + 4 Platos Fuertes a Elección entre: Grilled Sirloin, Chipotle Burger, Carbonara Pasta, Chicken Tender o Baby Ribs!m]](/img/wide_small_big_thumb/Deal/1308.bb92fd5f81c3eb521ff56d47ae47f1d3.jpg "PRUEBA-NO COMPRAR¡Paga $29.99 en Lugar de $72.99 por Banquete para 4 Personas con: 1 Entrada de Aros de Cebollas + 4 Platos Fuertes a Elección entre: Grilled Sirloin, Chipotle Burger, Carbonara Pasta, Chicken Tender o Baby Ribs!")
![[Image: PRUEBA-NO COMPRAR Paga $1 en Lugar de $35 por Grooming para Tu Perro que Incluye: Baño, Limado y Corte de Uñas, Limpieza de Oídos y Glándulas Anales, Cepillado de Dientes, Perfume, Moño o Pañoleta + Desparasitación Oral e Inyectada!m]](/img/wide_small_big_thumb/Deal/1281.0d2b6a8965dd086289091f516190e26f.jpg "PRUEBA-NO COMPRAR Paga $1 en Lugar de $35 por Grooming para Tu Perro que Incluye: Baño, Limado y Corte de Uñas, Limpieza de Oídos y Glándulas Anales, Cepillado de Dientes, Perfume, Moño o Pañoleta + Desparasitación Oral e Inyectada!")
![[Image: PRUEBA-NO COMPRAR¡Paga $15 en Vez de $90 por Tratamiento Capilar Hidratante de Caviar + Corte de Cabello con Split Ender (Elimina Las Puntas Maltratadas sin Afectar el Largo) + Lavado + Planchado o Secado + Mascarilla Facial de Colágeno!m]](/img/wide_small_big_thumb/Deal/1280.a14705fc3d26ae14afdafe04d9044fda.jpg "PRUEBA-NO COMPRAR¡Paga $15 en Vez de $90 por Tratamiento Capilar Hidratante de Caviar + Corte de Cabello con Split Ender (Elimina Las Puntas Maltratadas sin Afectar el Largo) + Lavado + Planchado o Secado + Mascarilla Facial de Colágeno!")
![[Image: PRUEBA-NO COMPRAR¡Paga $19 en Vez de $135 por 2 Sesiones Faciales con: 1 Microdermoabrasión con Punta de Diamante + Limpieza Facial Profunda con Vaporización, Tonificación, Extracción de Puntos, Alta Frecuencia, Mascarilla e Hidratación!m]](/img/wide_small_big_thumb/Deal/1285.003c614b07e8bdceee10d29047acb2c3.jpg "PRUEBA-NO COMPRAR¡Paga $19 en Vez de $135 por 2 Sesiones Faciales con: 1 Microdermoabrasión con Punta de Diamante + Limpieza Facial Profunda con Vaporización, Tonificación, Extracción de Puntos, Alta Frecuencia, Mascarilla e Hidratación!")
![[Image: PRUEBA-NO COMPRAR¡Paga $79 en Lugar de $300 por Blanqueamiento Dental + Limpieza con Ultrasonido + Profilaxis (Pulido Dental) + Aplicación de Flúor!m]](/img/wide_small_big_thumb/Deal/1284.c31a5208fcdec8d59ffaf14823a26443.jpg "PRUEBA-NO COMPRAR¡Paga $79 en Lugar de $300 por Blanqueamiento Dental + Limpieza con Ultrasonido + Profilaxis (Pulido Dental) + Aplicación de Flúor!")
![[Image: PRUEBA-NO COMPRAR¡Paga $20 en Lugar de $105 por 2 Rellenos o 4 Sellantes + Limpieza con Ultrasonido + Pulido Dental + Aplicación de Flúor + Diagnostico!m]](/img/wide_small_big_thumb/Deal/1283.f62ae8044be8e2b022dab8f6bc0d4218.jpg "PRUEBA-NO COMPRAR¡Paga $20 en Lugar de $105 por 2 Rellenos o 4 Sellantes + Limpieza con Ultrasonido + Pulido Dental + Aplicación de Flúor + Diagnostico!")
![[Image: PRUEBA-NO COMPRAR¡Paga $15 en Lugar de $82 por Carga Completa de Aire Acondicionado + Limpieza de Filtro de Cabina + Diagnóstico de Check Engine + Revisión Filtro de Motor, Fugas y Cámara de Aceleración + Lavado, Aspirado y Siliconado!m]](/img/wide_small_big_thumb/Deal/1286.08226f0491103b0823d5ee31766a6111.jpg "PRUEBA-NO COMPRAR¡Paga $15 en Lugar de $82 por Carga Completa de Aire Acondicionado + Limpieza de Filtro de Cabina + Diagnóstico de Check Engine + Revisión Filtro de Motor, Fugas y Cámara de Aceleración + Lavado, Aspirado y Siliconado!")
![[Image: PRUEBA-NO COMPRAR¡Paga $11 en Lugar de $23 por una Caja de 25 Unidades de Deliciosos Dulces Brasileños: Brigadeiros!m]](/img/wide_small_big_thumb/Deal/1282.317986fb075416bc2c6943c27003d82a.jpg "PRUEBA-NO COMPRAR¡Paga $11 en Lugar de $23 por una Caja de 25 Unidades de Deliciosos Dulces Brasileños: Brigadeiros!")
![[Image: PRUEBA-NO COMPRAR¡Paga $10 y Consume $20 en el Menú de Desayunos de Los Ranchos!m]](/img/wide_small_big_thumb/Deal/1306.91341bd58f157b37f92c43018609972f.jpg "PRUEBA-NO COMPRAR¡Paga $10 y Consume $20 en el Menú de Desayunos de Los Ranchos!")
![[Image: PRUEBA-NO COMPRAR¡Paga $1 y Consume $16 en el Menú de Desayunos de Puyas Grill!m]](/img/wide_small_big_thumb/Deal/1305.55f735d5101e444081b8860e5d4fe42c.jpg "PRUEBA-NO COMPRAR¡Paga $1 y Consume $16 en el Menú de Desayunos de Puyas Grill!")
![[Image: PRUEBA-NO COMPRAR¡Paga $18 en Lugar de $90 por Consulta Ginecológica Completa que Incluye: Citología + Ultrasonografía Pélvica + Examen Físico de Mamas y Lectura de Resultados!m]](/img/wide_small_big_thumb/Deal/1307.1fedef638201616ef7a25a29525046af.jpg "PRUEBA-NO COMPRAR¡Paga $18 en Lugar de $90 por Consulta Ginecológica Completa que Incluye: Citología + Ultrasonografía Pélvica + Examen Físico de Mamas y Lectura de Resultados!")
![[Image: PRUEBA-NO COMPRAR¡Paga $15 en Lugar de $100.50 por Exámenes de Laboratorio a Elección entre Perfil Básico, Diabético, Prostático o Digestivo!m]](/img/wide_small_big_thumb/Deal/1302.49952b3475301c623ac66f86a4375a17.jpg "PRUEBA-NO COMPRAR¡Paga $15 en Lugar de $100.50 por Exámenes de Laboratorio a Elección entre Perfil Básico, Diabético, Prostático o Digestivo!")
![[Image: PRUEBA-NO COMPRAR¡Paga $35 en Lugar de $110 por 1 Sesión Láser para Eliminar Hongos en 2 Uñas!m]](/img/wide_small_big_thumb/Deal/1301.bb02ee53bb4c20481bd4ab12fbf61d71.jpg "PRUEBA-NO COMPRAR¡Paga $35 en Lugar de $110 por 1 Sesión Láser para Eliminar Hongos en 2 Uñas!")
![[Image: PRUEBA-NO COMPRAR¡Paga $55 en Lugar de $122 por Estadía de 1 Noche para 4 Personas + 2 Sopas de Gallina + 1 Quesadilla para Compartir + 4 Cafés + Tour en El Bosque + Fogata Nocturna y Más!m]](/img/wide_small_big_thumb/Deal/1300.a0ee78d1621a54f12784cd378c58e748.jpg "PRUEBA-NO COMPRAR¡Paga $55 en Lugar de $122 por Estadía de 1 Noche para 4 Personas + 2 Sopas de Gallina + 1 Quesadilla para Compartir + 4 Cafés + Tour en El Bosque + Fogata Nocturna y Más!")
![[Image: PRUEBA-NO COMPRAR¡Paga $22 en Lugar de $80 por Limpieza de Tapicería + Car Wash Completo + Pasteado + Check Engine + Pulido de Silvines + Revisión de 21 Puntos!m]](/img/wide_small_big_thumb/Deal/1299.f68501ac7be05b1489339f1d9696d4af.jpg "PRUEBA-NO COMPRAR¡Paga $22 en Lugar de $80 por Limpieza de Tapicería + Car Wash Completo + Pasteado + Check Engine + Pulido de Silvines + Revisión de 21 Puntos!")
![[Image: PRUEBA-NO COMPRAR¡Paga $23 en Lugar de $90 por Rejuvenecimiento Facial con: Mesoterapia sin Agujas y sin Dolor con Ácido Hialurónico + Mascarilla Hidratante de Vino + Limpieza + Exfoliación Profunda + Masaje Facial + Sellador de Poros!m]](/img/wide_small_big_thumb/Deal/1298.ccd07fa17c084ea1dca20275be3f0abf.jpg "PRUEBA-NO COMPRAR¡Paga $23 en Lugar de $90 por Rejuvenecimiento Facial con: Mesoterapia sin Agujas y sin Dolor con Ácido Hialurónico + Mascarilla Hidratante de Vino + Limpieza + Exfoliación Profunda + Masaje Facial + Sellador de Poros!")
![[Image: PRUEBA-NO COMPRAR¡Paga $18 en Lugar de $90 por Extensión de Pestañas de Seda Pelo a Pelo o Pestañas con Efecto Dimensional (2D A 7D) + Diseño y Depilación de Cejas!m]](/img/wide_small_big_thumb/Deal/1297.3eaf8e437cbf277f91139cbed96d57c1.jpg "PRUEBA-NO COMPRAR¡Paga $18 en Lugar de $90 por Extensión de Pestañas de Seda Pelo a Pelo o Pestañas con Efecto Dimensional (2D A 7D) + Diseño y Depilación de Cejas!")
![[Image: PRUEBA-NO COMPRAR¡Paga $5 y Consume $10 de Paletas La Colmenita! ¡100% Naturales!m]](/img/wide_small_big_thumb/Deal/1291.15d7be89869e8ba5e6e859b1556af61b.jpg "PRUEBA-NO COMPRAR¡Paga $5 y Consume $10 de Paletas La Colmenita! ¡100% Naturales!")
![[Image: PRUEBA-NO COMPRAR¡Paga $25 en Lugar de $150 por Alisado de la Exclusiva Marca Lu de Melo a Elección entre Guaraná, Chocolate, Argán, Samba (Aceite de Coco) o Do Brasil Acai + Lavado Detox + Mascarilla Capilar Hidratante + Limpieza de Puntas!m]](/img/wide_small_big_thumb/Deal/1290.5e0bc32378ff732d404d3c9df9baba3d.jpg "PRUEBA-NO COMPRAR¡Paga $25 en Lugar de $150 por Alisado de la Exclusiva Marca Lu de Melo a Elección entre Guaraná, Chocolate, Argán, Samba (Aceite de Coco) o Do Brasil Acai + Lavado Detox + Mascarilla Capilar Hidratante + Limpieza de Puntas!")
![[Image: PRUEBA-NO COMPRAR¡A Domicilio! ¡Paga $12 en Lugar de $24 por 2 Frascos de Carbón Activado para Desintoxicar la Piel, Eliminar Puntos Negros, Acné, Tratar la Piel Grasa y Mucho Más!m]](/img/wide_small_big_thumb/Deal/1296.6c2188eb676e834318bbaf9b0ccaf619.jpg "PRUEBA-NO COMPRAR¡A Domicilio! ¡Paga $12 en Lugar de $24 por 2 Frascos de Carbón Activado para Desintoxicar la Piel, Eliminar Puntos Negros, Acné, Tratar la Piel Grasa y Mucho Más!")
![[Image: PRUEBA-NO COMPRAR¡Hasta la Puerta de Tu Casa u Oficina! ¡Paga $12 en Lugar de $24 por 1 Pastel de Chocolate o Caramelo para 15 Personas con Entrega a Domicilio + 6 Cupcakes Decorados con Fondant!m]](/img/wide_small_big_thumb/Deal/1295.d5d7dfde9ebd085f7254878d2ec03527.jpg "PRUEBA-NO COMPRAR¡Hasta la Puerta de Tu Casa u Oficina! ¡Paga $12 en Lugar de $24 por 1 Pastel de Chocolate o Caramelo para 15 Personas con Entrega a Domicilio + 6 Cupcakes Decorados con Fondant!")
![[Image: PRUEBA-NO COMPRAR¡Paga $16 en Lugar de $299 por 6 Meses de Curso Online de Microsoft Excel 2016!m]](/img/wide_small_big_thumb/Deal/1294.cf415a21193918b3297dd5fc863dc8f0.jpg "PRUEBA-NO COMPRAR¡Paga $16 en Lugar de $299 por 6 Meses de Curso Online de Microsoft Excel 2016!")
![[Image: PRUEBA-NO COMPRAR¡Paga $9 en Lugar de $36 por 4 Lavados + 4 Cortes + 4 Aplicaciones Cera o Gel!m]](/img/wide_small_big_thumb/Deal/1293.318a4810d97c730a50f56510ec0425e6.jpg "PRUEBA-NO COMPRAR¡Paga $9 en Lugar de $36 por 4 Lavados + 4 Cortes + 4 Aplicaciones Cera o Gel!")
![[Image: PRUEBA-NO COMPRAR¡Paga $20 en Vez de $75 y Elige entre Tinte Completo, Retoque, Mechas Balayage, Californianas u Ombré + Proteína BIFASE para Hidratar y Reestructurar + Corte de Puntas + Lavado + Planchado o Secado!m]](/img/wide_small_big_thumb/Deal/1287.2c40d22404ad76fe65b3038e5849ab50.jpg "PRUEBA-NO COMPRAR¡Paga $20 en Vez de $75 y Elige entre Tinte Completo, Retoque, Mechas Balayage, Californianas u Ombré + Proteína BIFASE para Hidratar y Reestructurar + Corte de Puntas + Lavado + Planchado o Secado!")
![[Image: PRUEBA-NO COMPRAR¡Paga $7 en Lugar de $15 por Cubo Fotográfico Tipo Farol!m]](/img/wide_small_big_thumb/Deal/1289.592daffc528c0c843151c9a0b3d97cb1.jpg "PRUEBA-NO COMPRAR¡Paga $7 en Lugar de $15 por Cubo Fotográfico Tipo Farol!")
![[Image: PRUEBA-NO COMPRAR¡Paga $25 en Lugar de $49 por Parrillada Criolla Charrúa para 2 que Incluye: 8 Oz. de Churrasco + 10 Oz. de Pollo + 10 Oz. de Lechón + 2 Chorizos + 2 Consomés + Casamiento + 1 Elote + 1 Papa + Chimichurri, Escabeche y Chirmol!m]](/img/wide_small_big_thumb/Deal/1292.2a86ae158a798709d38b9d004025c85d.jpg "PRUEBA-NO COMPRAR¡Paga $25 en Lugar de $49 por Parrillada Criolla Charrúa para 2 que Incluye: 8 Oz. de Churrasco + 10 Oz. de Pollo + 10 Oz. de Lechón + 2 Chorizos + 2 Consomés + Casamiento + 1 Elote + 1 Papa + Chimichurri, Escabeche y Chirmol!")
![[Image: PRUEBA-NO COMPRAR¡Paga $75 en Lugar de $140 por Retrovisor con Cámara de Reversa!m]](/img/wide_small_big_thumb/Deal/1288.e2e9bb001a355895eb3cceb0c840994e.jpg "PRUEBA-NO COMPRAR¡Paga $75 en Lugar de $140 por Retrovisor con Cámara de Reversa!")
