| 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` = 'd2b305f02203867e6b342a570511e45d' | | 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:1792625893;s:4:"rand";i:616566671;s:7:"timeout";i:10;}city_attachment|s:0:"";_Token|s:179:"a:5:{s:3:"key";s:40:"082f448e9dbf29f5295f094ff86a1d1facd14e5b";s:7:"expires";i:1792619893;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` = 290 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 por certificado de regalo de en restaurante Señor Tenedor de La Gran Vía! (También válido para uso personal)' 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` = 290 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 '290' AS `id`,'2011-12-15 16:00:02' AS `created`,'2011-12-15 16:00:02' AS `modified`,'1' AS `topic_type_id`,'1' AS `user_id`,'42553' AS `city_id`,'291' AS `deal_id`,'¡Paga por certificado de regalo de en restaurante Señor Tenedor de La Gran Vía! (También válido para uso personal)' AS `name`,'¡paga--por-certificado-de-regalo-de--en-restaurante-señor-tenedor-de-la-gran-vía!-(también' AS `slug`,' Según la historia, los tres regalos originales de navidad fueron: incienso, mirra y oro. Si, como la mayoría de la gente, no puedes conseguir incienso, no sabes qué carajo es “mirra” y estás harto de dar oro todas las navidades, ¡no busques más! Regala deliciosa comida, excelente servicio y una inolvidable experiencia en uno de los mejores restaurantes de El Salvador con la oferta de hoy: Paga en lugar de por certificado de regalo de Señor Tenedor.
El tiempo se te está agotando como un reloj de arena y tú ¿aún no has pensado qué regalar en navidad? Esta promoción es perfecta para ti: Paga por certificado de regalo en Señor Tenedor que puede ser canjeado por la gran variedad de platillos internacionales y bebidas que el restaurante ofrece.
Invítalos a degustar el paladar en un ambiente exclusivo y vanguardista dentro de la ciudad. Señor Tenedor cuenta con más de 23 años de experiencia en excelente servicio y atención. Su experimentado personal es especialista en vinos y comida internacional. Puedes pedir sugerencias sobre cualquiera de los platos del variado menú que el restaurante ofrece y, lo mejor, a buenos precios.
Prueba las deliciosas Croquetas del Oriente que son exquisitas croquetas de pechuga de pollo bañadas con salsa de yogurt y curry verde. Acompáñalas de tu bebida preferida o un delicioso Calolo que es una mezcla de jugo de fruta con hierba buena.
Si lo que quieres es satisfacer tu apetito de carne te recomendamos pruebes el jugoso Lomo Buscaiola. El plato incluye: ricos medallones de lomo de aguja, bañados con una salsa italiana (a base de tomate fresco), espárragos, aceitunas y alcachofas, sobre fetuccini con salsa blanca liviana. Combínalo con una bebida especial de la casa la Sangría Tenedor que es una exquisita combinación de jugo de fruta, vino blanco o tinto y fruta en pedacitos.
Prueba algo diferente con los Raviolis a la Griega. La receta incluye: deliciosos ravioles rellenos de queso de cabra, acompañados con berenjenas asadas, salsa liviana de hierbas, tomate cherry y espinaca.
No esperes más y comparte esta promoción para que tus invitados disfruten de un ambiente exclusivo. Invítalos a pasar una velada inolvidable en compañía de la música en vivo que el restaurante ofrece. Señor Tenedor te espera en sus amplias instalaciones ya sea dentro o en su amplia terraza.
¡No dejes de compartir en esta navidad! ¡Compra tu cupón YA! ' AS `content`,'1' AS `topic_discussion_count`,'4457' AS `last_replied_user_id`,'2011-12-15 18:57:52' 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('291', 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` = 291 | | 0 | 0 | 2 |
| 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(291, NULL) |
|
| 8 | SELECT `TopicsUser`.`id`, `TopicsUser`.`user_id`, `TopicsUser`.`topic_id` FROM `topics_users` AS `TopicsUser` WHERE `TopicsUser`.`topic_id` = 290 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` = 290 | | 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 | 4 | 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` = 290)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 290) |
|
| 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` = 290 ORDER BY `TopicDiscussion`.`id` asc LIMIT 20 | | 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 | 4 | 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` = 290)) left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = `cuponclu_playpen120111`.`TopicDiscussion`.`user_id`)) where (`cuponclu_playpen120111`.`TopicDiscussion`.`topic_id` = 290) order by `cuponclu_playpen120111`.`TopicDiscussion`.`id` limit 20 |
|
| 12 | SELECT `Topic`.`name` FROM `topics` AS `Topic` WHERE `Topic`.`id` = 290 | | 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 por certificado de regalo de en restaurante Señor Tenedor de La Gran Vía! (También válido para uso personal)' AS `name` from `cuponclu_playpen120111`.`topics` `Topic` where true |
|
| 13 | SELECT `User`.`user_type_id`, `User`.`username`, `User`.`id` FROM `users` AS `User` WHERE `User`.`id` = 4457 | | 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 '2' AS `user_type_id`,'osm1124' AS `username`,'4457' AS `id` from `cuponclu_playpen120111`.`users` `User` where true |
|
| 14 | SELECT `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` FROM `attachments` AS `UserAvatar` WHERE `UserAvatar`.`foreign_id` = 4457 AND `UserAvatar`.`class` = 'UserAvatar' | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | UserAvatar | | ref | foreign_id,class | foreign_id | 8 | const | 1 | 19.92 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `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` from `cuponclu_playpen120111`.`attachments` `UserAvatar` where ((`cuponclu_playpen120111`.`UserAvatar`.`foreign_id` = 4457) and (`cuponclu_playpen120111`.`UserAvatar`.`class` = 'UserAvatar')) |
|