| 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 | 1 |
| 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` = 'd8bd1933bf416bfd92233420567590b2' | | 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:1792625874;s:4:"rand";i:905089004;s:7:"timeout";i:10;}city_attachment|s:0:"";_Token|s:179:"a:5:{s:3:"key";s:40:"f759951a798667e746463a94890386d8d9ceeb32";s:7:"expires";i:1792619874;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' 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 `Topic`.`name` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 313 LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Topic | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select 'Paga y consume en todo el menú de Taco Bell!' AS `name` from `cuponclu_playpen120111`.`topics` `Topic` where true limit 1 |
|
| 6 | SELECT `Topic`.`id`, `Topic`.`created`, `Topic`.`modified`, `Topic`.`topic_type_id`, `Topic`.`user_id`, `Topic`.`city_id`, `Topic`.`deal_id`, `Topic`.`name`, `Topic`.`slug`, `Topic`.`content`, `Topic`.`topic_discussion_count`, `Topic`.`last_replied_user_id`, `Topic`.`last_replied_time`, `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` FROM `topics` AS `Topic` LEFT JOIN `deals` AS `Deal` ON (`Topic`.`deal_id` = `Deal`.`id`) WHERE `Topic`.`id` = 313 LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Topic | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
| 1 | SIMPLE | Deal | | const | PRIMARY | PRIMARY | 8 | const | 0 | 0.00 | unique row not found |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select '313' AS `id`,'2012-03-26 23:22:03' AS `created`,'2012-03-26 23:22:03' AS `modified`,'1' AS `topic_type_id`,'5755' AS `user_id`,'42553' AS `city_id`,'267' AS `deal_id`,'Paga y consume en todo el menú de Taco Bell!' AS `name`,'paga--y-consume--en-todo-el-menú-de-taco-bell!' AS `slug`,' La búsqueda en que se embarcaron los expertos para fabricar una almohada con materiales naturales y biodegradables fue un fracaso de diseño, pues el producto nunca fue demasiado cómodo, pero un éxito gastronómico, porque los diseñadores terminaron comiéndose los prototipos. Prueba un triunfo de diseño de la cocina mexicana con este Groupon. En Taco Bell® paga en vez de por 2 combos de chalupas supreme o gorditas supreme.
Taco Bell® es una cadena de restaurantes que en esta oportunidad ofrece 2 combos de chalupas supreme o gorditas supreme. Las chalupas y gorditas supreme son tortillas de harina gruesa con carne sazonada, tomate, lechuga, queso y sour cream. Todo esto vendrá acompañado por una gaseosa mediana y una porción de nachos con queso o papas medianas, dependiendo de la elección. Esta cadena de restaurantes es reconocida a nivel mundial y cuenta con más de 6.000 sedes alrededor del mundo, invitando a probar una amplia gama de productos, proteínas y combinaciones de ingredientes frescos. El lugar se encuentra ubicado en el centro comercial Atlantis y en Gran Estación. ' AS `content`,'0' AS `topic_discussion_count`,NULL AS `last_replied_user_id`,NULL AS `last_replied_time`,NULL AS `id`,NULL AS `created`,NULL AS `modified`,NULL AS `user_id`,NULL AS `name`,NULL AS `short_name`,NULL AS `coupon_name`,NULL AS `display_neighborhoodname`,NULL AS `slug`,NULL AS `bitly_short_url`,NULL AS `description`,NULL AS `private_note`,NULL AS `original_price`,NULL AS `discounted_price`,NULL AS `start_date`,NULL AS `end_date`,NULL AS `sort_order`,NULL AS `discount_percentage`,NULL AS `discount_amount`,NULL AS `savings`,NULL AS `min_limit`,NULL AS `max_limit`,NULL AS `city_id`,NULL AS `display_city_id`,NULL AS `company_id`,NULL AS `review`,NULL AS `deal_user_count`,NULL AS `payment_failed_count`,NULL AS `buy_min_quantity_per_user`,NULL AS `buy_max_quantity_per_user`,NULL AS `deal_tipped_time`,NULL AS `coupon_expiry_date`,NULL AS `coupon_condition`,NULL AS `coupon_highlights`,NULL AS `comment`,NULL AS `is_coupon_mail_sent`,NULL AS `is_subscription_mail_sent`,NULL AS `is_side_deal`,NULL AS `deal_status_id`,NULL AS `bonus_amount`,NULL AS `commission_percentage`,NULL AS `commission_percent_unused`,NULL AS `vat_percent`,NULL AS `payment1_amt`,NULL AS `payment1_date`,NULL AS `payment1_check_no`,NULL AS `payment1_bank`,NULL AS `payment1_comm`,NULL AS `payment1_vat`,NULL AS `payment1_info`,NULL AS `payment1_comments`,NULL AS `payment2_amt`,NULL AS `payment2_date`,NULL AS `payment2_check_no`,NULL AS `payment2_bank`,NULL AS `payment2_comm`,NULL AS `payment2_vat`,NULL AS `payment2_info`,NULL AS `payment2_comments`,NULL AS `payment3_amt`,NULL AS `payment3_date`,NULL AS `payment3_check_no`,NULL AS `payment3_bank`,NULL AS `payment3_comm`,NULL AS `payment3_vat`,NULL AS `payment3_info`,NULL AS `payment3_comments`,NULL AS `payment4_amt`,NULL AS `payment4_date`,NULL AS `payment4_check_no`,NULL AS `payment4_bank`,NULL AS `payment4_comm`,NULL AS `payment4_vat`,NULL AS `payment4_info`,NULL AS `payment4_comments`,NULL AS `first_payment_percent`,NULL AS `added_coupons`,NULL AS `total_commission_amount`,NULL AS `total_purchased_amount`,NULL AS `net_profit`,NULL AS `meta_keywords`,NULL AS `meta_description`,NULL AS `bitly_short_url_subdomain`,NULL AS `bitly_short_url_prefix`,NULL AS `certainly`,NULL AS `probably`,NULL AS `unlikely_satisfied`,NULL AS `unlikely_unsatisfied`,NULL AS `survey_happy`,NULL AS `survey_fair`,NULL AS `survey_sad`,NULL AS `salesman`,NULL AS `zone`,NULL AS `industry`,NULL AS `category_id`,NULL AS `sub_category_id`,NULL AS `gender`,NULL AS `neighborhood_id`,NULL AS `sales_projection`,NULL AS `facebook_description`,NULL AS `facebook_title` from `cuponclu_playpen120111`.`topics` `Topic` left join `cuponclu_playpen120111`.`deals` `Deal` on(multiple equal('267', NULL)) where true limit 1 |
|
| 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`.`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` FROM `deals` AS `Deal` WHERE `Deal`.`id` = 267 | | 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 `id`,NULL AS `created`,NULL AS `modified`,NULL AS `user_id`,NULL AS `name`,NULL AS `short_name`,NULL AS `coupon_name`,NULL AS `display_neighborhoodname`,NULL AS `slug`,NULL AS `bitly_short_url`,NULL AS `description`,NULL AS `private_note`,NULL AS `original_price`,NULL AS `discounted_price`,NULL AS `start_date`,NULL AS `end_date`,NULL AS `sort_order`,NULL AS `discount_percentage`,NULL AS `discount_amount`,NULL AS `savings`,NULL AS `min_limit`,NULL AS `max_limit`,NULL AS `city_id`,NULL AS `display_city_id`,NULL AS `company_id`,NULL AS `review`,NULL AS `deal_user_count`,NULL AS `payment_failed_count`,NULL AS `buy_min_quantity_per_user`,NULL AS `buy_max_quantity_per_user`,NULL AS `deal_tipped_time`,NULL AS `coupon_expiry_date`,NULL AS `coupon_condition`,NULL AS `coupon_highlights`,NULL AS `comment`,NULL AS `is_coupon_mail_sent`,NULL AS `is_subscription_mail_sent`,NULL AS `is_side_deal`,NULL AS `deal_status_id`,NULL AS `bonus_amount`,NULL AS `commission_percentage`,NULL AS `commission_percent_unused`,NULL AS `vat_percent`,NULL AS `payment1_amt`,NULL AS `payment1_date`,NULL AS `payment1_check_no`,NULL AS `payment1_bank`,NULL AS `payment1_comm`,NULL AS `payment1_vat`,NULL AS `payment1_info`,NULL AS `payment1_comments`,NULL AS `payment2_amt`,NULL AS `payment2_date`,NULL AS `payment2_check_no`,NULL AS `payment2_bank`,NULL AS `payment2_comm`,NULL AS `payment2_vat`,NULL AS `payment2_info`,NULL AS `payment2_comments`,NULL AS `payment3_amt`,NULL AS `payment3_date`,NULL AS `payment3_check_no`,NULL AS `payment3_bank`,NULL AS `payment3_comm`,NULL AS `payment3_vat`,NULL AS `payment3_info`,NULL AS `payment3_comments`,NULL AS `payment4_amt`,NULL AS `payment4_date`,NULL AS `payment4_check_no`,NULL AS `payment4_bank`,NULL AS `payment4_comm`,NULL AS `payment4_vat`,NULL AS `payment4_info`,NULL AS `payment4_comments`,NULL AS `first_payment_percent`,NULL AS `added_coupons`,NULL AS `total_commission_amount`,NULL AS `total_purchased_amount`,NULL AS `net_profit`,NULL AS `meta_keywords`,NULL AS `meta_description`,NULL AS `bitly_short_url_subdomain`,NULL AS `bitly_short_url_prefix`,NULL AS `certainly`,NULL AS `probably`,NULL AS `unlikely_satisfied`,NULL AS `unlikely_unsatisfied`,NULL AS `survey_happy`,NULL AS `survey_fair`,NULL AS `survey_sad`,NULL AS `salesman`,NULL AS `zone`,NULL AS `industry`,NULL AS `category_id`,NULL AS `sub_category_id`,NULL AS `gender`,NULL AS `neighborhood_id`,NULL AS `sales_projection`,NULL AS `facebook_description`,NULL AS `facebook_title` from `cuponclu_playpen120111`.`deals` `Deal` where multiple equal(267, NULL) |
|
| 8 | SELECT `TopicsUser`.`id`, `TopicsUser`.`user_id`, `TopicsUser`.`topic_id` FROM `topics_users` AS `TopicsUser` WHERE `TopicsUser`.`topic_id` = 313 AND `TopicsUser`.`user_id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | | | Impossible WHERE |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`TopicsUser`.`id` AS `id`,`cuponclu_playpen120111`.`TopicsUser`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`TopicsUser`.`topic_id` AS `topic_id` from `cuponclu_playpen120111`.`topics_users` `TopicsUser` where false limit 1 |
|
| 9 | SELECT `User`.`id`, `User`.`created`, `User`.`modified`, `User`.`user_type_id`, `User`.`username`, `User`.`email`, `User`.`password`, `User`.`referred_by_user_id`, `User`.`referral_agent_id`, `User`.`first_buy_discount_given`, `User`.`gift_user_id`, `User`.`fb_user_id`, `User`.`user_login_count`, `User`.`user_view_count`, `User`.`cookie_hash`, `User`.`cookie_time_modified`, `User`.`is_agree_terms_conditions`, `User`.`is_active`, `User`.`is_email_confirmed`, `User`.`signup_ip`, `User`.`last_login_ip`, `User`.`last_logged_in_time`, `User`.`available_balance_amount`, `User`.`wallet_currency`, `User`.`bonus_points`, `User`.`city`, `User`.`deal_notify_city_slug`, `User`.`blocked_amount`, `User`.`user_openid_count`, `User`.`is_openid_register`, `User`.`twitter_access_token`, `User`.`twitter_user_id`, `User`.`twitter_access_key`, `User`.`api_key`, `User`.`api_token`, `User`.`fb_access_token`, `User`.`dns`, `User`.`cim_profile_id`, `User`.`fraud_status`, `UserAvatar`.`id`, `UserAvatar`.`created`, `UserAvatar`.`modified`, `UserAvatar`.`class`, `UserAvatar`.`foreign_id`, `UserAvatar`.`filename`, `UserAvatar`.`dir`, `UserAvatar`.`mimetype`, `UserAvatar`.`filesize`, `UserAvatar`.`height`, `UserAvatar`.`width`, `UserAvatar`.`thumb`, `UserAvatar`.`description`, `Company`.`id`, `Company`.`created`, `Company`.`modified`, `Company`.`name`, `Company`.`slug`, `Company`.`address1`, `Company`.`address2`, `Company`.`user_id`, `Company`.`city_id`, `Company`.`state_id`, `Company`.`country_id`, `Company`.`phone`, `Company`.`zip`, `Company`.`url`, `Company`.`deal_count`, `Company`.`is_online_account`, `Company`.`is_company_profile_enabled`, `Company`.`company_profile`, `Company`.`latitude`, `Company`.`longitude`, `Company`.`map_zoom_level`, `Company`.`survey_average`, `Company`.`survey_responses`, `Company`.`half_stars`, `Company`.`percent_to_return` FROM `users` AS `User` LEFT JOIN `attachments` AS `UserAvatar` ON (`UserAvatar`.`foreign_id` = `User`.`id` AND `UserAvatar`.`class` = 'UserAvatar') LEFT JOIN `companies` AS `Company` ON (`Company`.`user_id` = `User`.`id`) WHERE `User`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | | | Impossible WHERE |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`User`.`id` AS `id`,`cuponclu_playpen120111`.`User`.`created` AS `created`,`cuponclu_playpen120111`.`User`.`modified` AS `modified`,`cuponclu_playpen120111`.`User`.`user_type_id` AS `user_type_id`,`cuponclu_playpen120111`.`User`.`username` AS `username`,`cuponclu_playpen120111`.`User`.`email` AS `email`,`cuponclu_playpen120111`.`User`.`password` AS `password`,`cuponclu_playpen120111`.`User`.`referred_by_user_id` AS `referred_by_user_id`,`cuponclu_playpen120111`.`User`.`referral_agent_id` AS `referral_agent_id`,`cuponclu_playpen120111`.`User`.`first_buy_discount_given` AS `first_buy_discount_given`,`cuponclu_playpen120111`.`User`.`gift_user_id` AS `gift_user_id`,`cuponclu_playpen120111`.`User`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`User`.`user_login_count` AS `user_login_count`,`cuponclu_playpen120111`.`User`.`user_view_count` AS `user_view_count`,`cuponclu_playpen120111`.`User`.`cookie_hash` AS `cookie_hash`,`cuponclu_playpen120111`.`User`.`cookie_time_modified` AS `cookie_time_modified`,`cuponclu_playpen120111`.`User`.`is_agree_terms_conditions` AS `is_agree_terms_conditions`,`cuponclu_playpen120111`.`User`.`is_active` AS `is_active`,`cuponclu_playpen120111`.`User`.`is_email_confirmed` AS `is_email_confirmed`,`cuponclu_playpen120111`.`User`.`signup_ip` AS `signup_ip`,`cuponclu_playpen120111`.`User`.`last_login_ip` AS `last_login_ip`,`cuponclu_playpen120111`.`User`.`last_logged_in_time` AS `last_logged_in_time`,`cuponclu_playpen120111`.`User`.`available_balance_amount` AS `available_balance_amount`,`cuponclu_playpen120111`.`User`.`wallet_currency` AS `wallet_currency`,`cuponclu_playpen120111`.`User`.`bonus_points` AS `bonus_points`,`cuponclu_playpen120111`.`User`.`city` AS `city`,`cuponclu_playpen120111`.`User`.`deal_notify_city_slug` AS `deal_notify_city_slug`,`cuponclu_playpen120111`.`User`.`blocked_amount` AS `blocked_amount`,`cuponclu_playpen120111`.`User`.`user_openid_count` AS `user_openid_count`,`cuponclu_playpen120111`.`User`.`is_openid_register` AS `is_openid_register`,`cuponclu_playpen120111`.`User`.`twitter_access_token` AS `twitter_access_token`,`cuponclu_playpen120111`.`User`.`twitter_user_id` AS `twitter_user_id`,`cuponclu_playpen120111`.`User`.`twitter_access_key` AS `twitter_access_key`,`cuponclu_playpen120111`.`User`.`api_key` AS `api_key`,`cuponclu_playpen120111`.`User`.`api_token` AS `api_token`,`cuponclu_playpen120111`.`User`.`fb_access_token` AS `fb_access_token`,`cuponclu_playpen120111`.`User`.`dns` AS `dns`,`cuponclu_playpen120111`.`User`.`cim_profile_id` AS `cim_profile_id`,`cuponclu_playpen120111`.`User`.`fraud_status` AS `fraud_status`,`cuponclu_playpen120111`.`UserAvatar`.`id` AS `id`,`cuponclu_playpen120111`.`UserAvatar`.`created` AS `created`,`cuponclu_playpen120111`.`UserAvatar`.`modified` AS `modified`,`cuponclu_playpen120111`.`UserAvatar`.`class` AS `class`,`cuponclu_playpen120111`.`UserAvatar`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`UserAvatar`.`filename` AS `filename`,`cuponclu_playpen120111`.`UserAvatar`.`dir` AS `dir`,`cuponclu_playpen120111`.`UserAvatar`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`UserAvatar`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`UserAvatar`.`height` AS `height`,`cuponclu_playpen120111`.`UserAvatar`.`width` AS `width`,`cuponclu_playpen120111`.`UserAvatar`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`UserAvatar`.`description` AS `description`,`cuponclu_playpen120111`.`Company`.`id` AS `id`,`cuponclu_playpen120111`.`Company`.`created` AS `created`,`cuponclu_playpen120111`.`Company`.`modified` AS `modified`,`cuponclu_playpen120111`.`Company`.`name` AS `name`,`cuponclu_playpen120111`.`Company`.`slug` AS `slug`,`cuponclu_playpen120111`.`Company`.`address1` AS `address1`,`cuponclu_playpen120111`.`Company`.`address2` AS `address2`,`cuponclu_playpen120111`.`Company`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`Company`.`city_id` AS `city_id`,`cuponclu_playpen120111`.`Company`.`state_id` AS `state_id`,`cuponclu_playpen120111`.`Company`.`country_id` AS `country_id`,`cuponclu_playpen120111`.`Company`.`phone` AS `phone`,`cuponclu_playpen120111`.`Company`.`zip` AS `zip`,`cuponclu_playpen120111`.`Company`.`url` AS `url`,`cuponclu_playpen120111`.`Company`.`deal_count` AS `deal_count`,`cuponclu_playpen120111`.`Company`.`is_online_account` AS `is_online_account`,`cuponclu_playpen120111`.`Company`.`is_company_profile_enabled` AS `is_company_profile_enabled`,`cuponclu_playpen120111`.`Company`.`company_profile` AS `company_profile`,`cuponclu_playpen120111`.`Company`.`latitude` AS `latitude`,`cuponclu_playpen120111`.`Company`.`longitude` AS `longitude`,`cuponclu_playpen120111`.`Company`.`map_zoom_level` AS `map_zoom_level`,`cuponclu_playpen120111`.`Company`.`survey_average` AS `survey_average`,`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` from `cuponclu_playpen120111`.`users` `User` left join `cuponclu_playpen120111`.`attachments` `UserAvatar` on(((`cuponclu_playpen120111`.`UserAvatar`.`class` = 'UserAvatar') and multiple equal(`cuponclu_playpen120111`.`UserAvatar`.`foreign_id`, `cuponclu_playpen120111`.`User`.`id`))) left join `cuponclu_playpen120111`.`companies` `Company` on((`cuponclu_playpen120111`.`Company`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) where false limit 1 |
|
| 10 | SELECT COUNT(*) AS `count` FROM `topic_discussions` AS `TopicDiscussion` LEFT JOIN `topics` AS `Topic` ON (`TopicDiscussion`.`topic_id` = `Topic`.`id`) LEFT JOIN `users` AS `User` ON (`TopicDiscussion`.`user_id` = `User`.`id`) WHERE `TopicDiscussion`.`topic_id` = 313 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | TopicDiscussion | | ref | topic_id | topic_id | 8 | const | 1 | 100.00 | |
| 1 | SIMPLE | Topic | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | Using index |
| 1 | SIMPLE | User | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_playpen120111.TopicDiscussion.user_id | 1 | 100.00 | Using index |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select count(0) AS `count` from `cuponclu_playpen120111`.`topic_discussions` `TopicDiscussion` left join `cuponclu_playpen120111`.`topics` `Topic` on((`cuponclu_playpen120111`.`Topic`.`id` = 313)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 313) |
|
| 11 | SELECT `TopicDiscussion`.`id`, `TopicDiscussion`.`created`, `TopicDiscussion`.`modified`, `TopicDiscussion`.`topic_id`, `TopicDiscussion`.`user_id`, `TopicDiscussion`.`comment`, `TopicDiscussion`.`ip`, `TopicDiscussion`.`dns`, `Topic`.`name`, `User`.`user_type_id`, `User`.`username`, `User`.`id` FROM `topic_discussions` AS `TopicDiscussion` LEFT JOIN `topics` AS `Topic` ON (`TopicDiscussion`.`topic_id` = `Topic`.`id`) LEFT JOIN `users` AS `User` ON (`TopicDiscussion`.`user_id` = `User`.`id`) WHERE `TopicDiscussion`.`topic_id` = 313 ORDER BY `TopicDiscussion`.`id` asc LIMIT 20 | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | TopicDiscussion | | ref | topic_id | topic_id | 8 | const | 1 | 100.00 | Using filesort |
| 1 | SIMPLE | Topic | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
| 1 | SIMPLE | User | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_playpen120111.TopicDiscussion.user_id | 1 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`TopicDiscussion`.`id` AS `id`,`cuponclu_playpen120111`.`TopicDiscussion`.`created` AS `created`,`cuponclu_playpen120111`.`TopicDiscussion`.`modified` AS `modified`,`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` AS `topic_id`,`cuponclu_playpen120111`.`TopicDiscussion`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`TopicDiscussion`.`comment` AS `comment`,`cuponclu_playpen120111`.`TopicDiscussion`.`ip` AS `ip`,`cuponclu_playpen120111`.`TopicDiscussion`.`dns` AS `dns`,`cuponclu_playpen120111`.`Topic`.`name` AS `name`,`cuponclu_playpen120111`.`User`.`user_type_id` AS `user_type_id`,`cuponclu_playpen120111`.`User`.`username` AS `username`,`cuponclu_playpen120111`.`User`.`id` AS `id` from `cuponclu_playpen120111`.`topic_discussions` `TopicDiscussion` left join `cuponclu_playpen120111`.`topics` `Topic` on((`cuponclu_playpen120111`.`Topic`.`id` = 313)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 313) order by `cuponclu_playpen120111`.`TopicDiscussion`.`id` limit 20 |
|