| 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 `City`.`language_id`, `Language`.`iso2`, `Language`.`id` FROM `cities` AS `City` LEFT JOIN `languages` AS `Language` ON (`City`.`language_id` = `Language`.`id`) WHERE `City`.`slug` = '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 | Language | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_playpen120111.City.language_id | 1 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`City`.`language_id` AS `language_id`,`cuponclu_playpen120111`.`Language`.`iso2` AS `iso2`,`cuponclu_playpen120111`.`Language`.`id` AS `id` from `cuponclu_playpen120111`.`cities` `City` left join `cuponclu_playpen120111`.`languages` `Language` on((`cuponclu_playpen120111`.`Language`.`id` = `cuponclu_playpen120111`.`City`.`language_id`)) where ((`cuponclu_playpen120111`.`City`.`is_approved` = 1) and (`cuponclu_playpen120111`.`City`.`slug` = 'San-salvador')) limit 1 |
|
| 3 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '199517b7315e4b57a77ef4cd3d3b7cd9' | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | | | no matching row in const table |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select NULL AS `data` from `cuponclu_playpen120111`.`cake_sessions` where (NULL = '199517b7315e4b57a77ef4cd3d3b7cd9') |
|
| 4 | SELECT `City`.`id`, `City`.`created`, `City`.`modified`, `City`.`country_id`, `City`.`state_id`, `City`.`language_id`, `City`.`name`, `City`.`slug`, `City`.`latitude`, `City`.`longitude`, `City`.`dma_id`, `City`.`county`, `City`.`code`, `City`.`deal_count`, `City`.`active_deal_count`, `City`.`is_approved`, `City`.`fb_user_id`, `City`.`fb_access_token`, `City`.`twitter_username`, `City`.`twitter_password`, `City`.`twitter_access_token`, `City`.`twitter_access_key`, `City`.`twitter_url`, `City`.`facebook_url`, `Attachment`.`id`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`class`, `Attachment`.`foreign_id`, `Attachment`.`filename`, `Attachment`.`dir`, `Attachment`.`mimetype`, `Attachment`.`filesize`, `Attachment`.`height`, `Attachment`.`width`, `Attachment`.`thumb`, `Attachment`.`description` FROM `cities` AS `City` LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `City`.`id` AND `Attachment`.`class` = 'City') WHERE `City`.`slug` = '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 |
|
| 5 | SELECT `BannedIp`.`id`, `BannedIp`.`created`, `BannedIp`.`modified`, `BannedIp`.`address`, `BannedIp`.`range`, `BannedIp`.`referer_url`, `BannedIp`.`reason`, `BannedIp`.`redirect`, `BannedIp`.`thetime`, `BannedIp`.`timespan` FROM `banned_ips` AS `BannedIp` WHERE ((`BannedIp`.`address` = '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 |
|
| 6 | SELECT `Deal`.`id`, `Deal`.`created`, `Deal`.`name`, `Deal`.`short_name`, `Deal`.`slug`, `Deal`.`original_price`, `Deal`.`discount_amount`, `Deal`.`description`, `Deal`.`discount_percentage`, `Deal`.`min_limit`, `Deal`.`max_limit`, `Deal`.`deal_user_count`, `Deal`.`discounted_price`, `Deal`.`buy_min_quantity_per_user`, `Deal`.`buy_max_quantity_per_user`, `Deal`.`city_id`, `Deal`.`start_date`, `Deal`.`end_date` FROM `deals` AS `Deal` 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`.`id` = 6771 AND `Deal`.`deal_status_id` IN (2, 5) LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Deal | | const | PRIMARY,deal_status_id | PRIMARY | 8 | const | 1 | 100.00 | |
| 1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | const | 2 | 100.00 | Using where |
| 1 | SIMPLE | Fbpicture | | ref | foreign_id,class | foreign_id | 8 | const | 1 | 100.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select '6771' AS `id`,'2018-02-15 15:51:19' AS `created`,'PRUEBA-NO COMPRAR¡Paga en Lugar de por Consulta Ginecológica Completa que Incluye: Citología + Ultrasonografía Pélvica + Examen Físico de Mamas y Lectura de Resultados!' AS `name`,'PRUEBA-NO COMPRARConsulta Ginecológica Completa: Citología, Ultrasonografía Pélvica y Más' AS `short_name`,'¡paga--en-lugar-de--por-1' AS `slug`,'90.00' AS `original_price`,'72.00' AS `discount_amount`,' ¿Por qué lo necesitas?
¿Cuándo fue la última vez que te realizaste una revisión ginecológica? Tu respuesta no debería sobrepasar los 6 meses, de lo contrario estás poniendo en riesgo la prevención de enfermedades muy graves como el cáncer ¡Demuéstrate amor hacia ti misma con esta oferta!
¿Qué es?
La citología es un examen que puede salvar tu vida ya que detecta el cáncer del cuello del útero antes de que se extienda a otras partes del cuerpo. Si se detecta oportunamente, las probabilidades de curarlo son mucho mayores. Este examen consiste en tomar células del cuello de la matriz para verlas al microscopio y detectar células anormales que puedan convertirse en células cancerosas y detectar inflamaciones. Los doctores recomiendan que debes hacértela al menos una vez al año. También se realizará una ultrasonografía pélvica, enfocada en visualizar el útero y los ovarios para detectar anomalías.
El cupón también incluye un examen físico de mamas y la lectura de los resultados especialista en el área.
¿Por qué recomendamos a Clínica Integral de Salud para la Mujer?
Porque en ella encontrarás todos los servicios que necesitas para cuidar de tu salud femenina. La clínica cuenta con doctoras especializadas en atención obstétrica y ginecológica integral que te brindarán calidad y amabilidad en tu visita. Entre sus servicios encontrarás atención de parto vaginal y cesárea, ultrasonografía obstétrica y ginecológica, aplicación de vacuna contra el Virus del Papiloma Humano, tratamiento del síndrome poliquístico, menopausia, planificación familiar, control prenatal y otros.
¿Cómo llegar?
Podrás canjear el cupón en avenida Max Bloch #1010 en Colonia Médica. ' AS `description`,'80' AS `discount_percentage`,'1' AS `min_limit`,NULL AS `max_limit`,'98' AS `deal_user_count`,'18.00' AS `discounted_price`,'1' AS `buy_min_quantity_per_user`,'3' AS `buy_max_quantity_per_user`,'42553' AS `city_id`,'2018-02-15 17:08:00' AS `start_date`,'2024-12-31 00:00:00' AS `end_date` from `cuponclu_playpen120111`.`deals` `Deal` left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 6771) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6771) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where (('5' in (2,5))) limit 1 |
|
| 7 | SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE `Setting`.`setting_category_id` = 27 AND `Setting`.`name` = 'date_invoice_generation' LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Setting | | ref | setting_category_id,name | name | 767 | const | 1 | 34.27 | 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` from `cuponclu_playpen120111`.`settings` `Setting` where ((`cuponclu_playpen120111`.`Setting`.`setting_category_id` = 27) and (`cuponclu_playpen120111`.`Setting`.`name` = 'date_invoice_generation')) limit 1 |
|
| 8 | SELECT `User`.`id`, `User`.`fb_user_id`, `User`.`email`, `User`.`wallet_currency`, `User`.`referral_agent_id`, `User`.`bonus_points` FROM `users` AS `User` 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`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`User`.`email` AS `email`,`cuponclu_playpen120111`.`User`.`wallet_currency` AS `wallet_currency`,`cuponclu_playpen120111`.`User`.`referral_agent_id` AS `referral_agent_id`,`cuponclu_playpen120111`.`User`.`bonus_points` AS `bonus_points` from `cuponclu_playpen120111`.`users` `User` where false limit 1 |
|
| 9 | SELECT `PaymentGateway`.`id`, `PaymentGateway`.`created`, `PaymentGateway`.`modified`, `PaymentGateway`.`name`, `PaymentGateway`.`display_name`, `PaymentGateway`.`description`, `PaymentGateway`.`gateway_fees`, `PaymentGateway`.`transaction_count`, `PaymentGateway`.`payment_gateway_setting_count`, `PaymentGateway`.`is_test_mode`, `PaymentGateway`.`is_active` FROM `payment_gateways` AS `PaymentGateway` WHERE `PaymentGateway`.`id` = 7 AND `PaymentGateway`.`is_active` = 1 LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | PaymentGateway | | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select '7' AS `id`,'2019-11-12 00:00:00' AS `created`,'2026-10-07 00:44:14' AS `modified`,'Cybersource' AS `name`,'Visa o MasterCard' AS `display_name`,'Credit card using Cybersource in Guatemala or El Salvador.' AS `description`,'0.00' AS `gateway_fees`,'0' AS `transaction_count`,'0' AS `payment_gateway_setting_count`,'0' AS `is_test_mode`,'1' AS `is_active` from `cuponclu_playpen120111`.`payment_gateways` `PaymentGateway` where true limit 1 |
|
| 10 | SELECT `PaymentGatewaySetting`.`key`, `PaymentGatewaySetting`.`test_mode_value`, `PaymentGatewaySetting`.`live_mode_value`, `PaymentGatewaySetting`.`payment_gateway_id` FROM `payment_gateway_settings` AS `PaymentGatewaySetting` WHERE `PaymentGatewaySetting`.`payment_gateway_id` = (7) | | 12 | 12 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | PaymentGatewaySetting | | ALL | | | | | 46 | 10.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` AS `key`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` AS `test_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`live_mode_value` AS `live_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` AS `payment_gateway_id` from `cuponclu_playpen120111`.`payment_gateway_settings` `PaymentGatewaySetting` where (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` = 7) |
|
| 11 | SELECT `PaymentGateway`.`id`, `PaymentGateway`.`created`, `PaymentGateway`.`modified`, `PaymentGateway`.`name`, `PaymentGateway`.`display_name`, `PaymentGateway`.`description`, `PaymentGateway`.`gateway_fees`, `PaymentGateway`.`transaction_count`, `PaymentGateway`.`payment_gateway_setting_count`, `PaymentGateway`.`is_test_mode`, `PaymentGateway`.`is_active` FROM `payment_gateways` AS `PaymentGateway` WHERE `PaymentGateway`.`is_active` = 1 ORDER BY `PaymentGateway`.`display_name` asc | | 6 | 6 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | PaymentGateway | | ALL | | | | | 7 | 14.29 | Using where; Using filesort |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`PaymentGateway`.`id` AS `id`,`cuponclu_playpen120111`.`PaymentGateway`.`created` AS `created`,`cuponclu_playpen120111`.`PaymentGateway`.`modified` AS `modified`,`cuponclu_playpen120111`.`PaymentGateway`.`name` AS `name`,`cuponclu_playpen120111`.`PaymentGateway`.`display_name` AS `display_name`,`cuponclu_playpen120111`.`PaymentGateway`.`description` AS `description`,`cuponclu_playpen120111`.`PaymentGateway`.`gateway_fees` AS `gateway_fees`,`cuponclu_playpen120111`.`PaymentGateway`.`transaction_count` AS `transaction_count`,`cuponclu_playpen120111`.`PaymentGateway`.`payment_gateway_setting_count` AS `payment_gateway_setting_count`,`cuponclu_playpen120111`.`PaymentGateway`.`is_test_mode` AS `is_test_mode`,`cuponclu_playpen120111`.`PaymentGateway`.`is_active` AS `is_active` from `cuponclu_playpen120111`.`payment_gateways` `PaymentGateway` where (`cuponclu_playpen120111`.`PaymentGateway`.`is_active` = 1) order by `cuponclu_playpen120111`.`PaymentGateway`.`display_name` |
|
| 12 | SELECT `PaymentGatewaySetting`.`id`, `PaymentGatewaySetting`.`created`, `PaymentGatewaySetting`.`modified`, `PaymentGatewaySetting`.`payment_gateway_id`, `PaymentGatewaySetting`.`key`, `PaymentGatewaySetting`.`type`, `PaymentGatewaySetting`.`options`, `PaymentGatewaySetting`.`test_mode_value`, `PaymentGatewaySetting`.`live_mode_value`, `PaymentGatewaySetting`.`description` FROM `payment_gateway_settings` AS `PaymentGatewaySetting` WHERE `PaymentGatewaySetting`.`key` IN ('is_enable_for_buy_a_deal', 'is_enable_wallet') AND `PaymentGatewaySetting`.`test_mode_value` = '1' AND `PaymentGatewaySetting`.`payment_gateway_id` IN (4, 5, 6, 3, 7, 1) | | 7 | 7 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | PaymentGatewaySetting | | ALL | | | | | 46 | 2.17 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`PaymentGatewaySetting`.`id` AS `id`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`created` AS `created`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`modified` AS `modified`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` AS `payment_gateway_id`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` AS `key`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`type` AS `type`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`options` AS `options`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` AS `test_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`live_mode_value` AS `live_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`description` AS `description` from `cuponclu_playpen120111`.`payment_gateway_settings` `PaymentGatewaySetting` where ((`cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` in ('is_enable_for_buy_a_deal','is_enable_wallet')) and (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` = '1') and (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` in (4,5,6,3,7,1))) |
|
| 13 | 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`, `Company`.`name`, `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`, `Fbpicture`.`id`, `Fbpicture`.`created`, `Fbpicture`.`modified`, `Fbpicture`.`class`, `Fbpicture`.`foreign_id`, `Fbpicture`.`filename`, `Fbpicture`.`dir`, `Fbpicture`.`mimetype`, `Fbpicture`.`filesize`, `Fbpicture`.`height`, `Fbpicture`.`width`, `Fbpicture`.`thumb`, `Fbpicture`.`description` FROM `deals` AS `Deal` 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`.`id` = 6771 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Deal | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
| 1 | SIMPLE | Company | | const | PRIMARY | PRIMARY | 8 | const | 1 | 100.00 | |
| 1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | const | 2 | 100.00 | Using where |
| 1 | SIMPLE | Fbpicture | | ref | foreign_id,class | foreign_id | 8 | const | 1 | 100.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select '6771' AS `id`,'2018-02-15 15:51:19' AS `created`,'2018-10-11 15:28:12' AS `modified`,'233925' AS `user_id`,'PRUEBA-NO COMPRAR¡Paga en Lugar de por Consulta Ginecológica Completa que Incluye: Citología + Ultrasonografía Pélvica + Examen Físico de Mamas y Lectura de Resultados!' AS `name`,'PRUEBA-NO COMPRARConsulta Ginecológica Completa: Citología, Ultrasonografía Pélvica y Más' AS `short_name`,'Consulta Ginecológica Completa que Incluye: Citología + Ultrasonografía Pélvica + Examen Físico de Mamas y Lectura de Resultados' AS `coupon_name`,'Colonia Médica' AS `display_neighborhoodname`,'¡paga--en-lugar-de--por-1' AS `slug`,NULL AS `bitly_short_url`,' ¿Por qué lo necesitas?
¿Cuándo fue la última vez que te realizaste una revisión ginecológica? Tu respuesta no debería sobrepasar los 6 meses, de lo contrario estás poniendo en riesgo la prevención de enfermedades muy graves como el cáncer ¡Demuéstrate amor hacia ti misma con esta oferta!
¿Qué es?
La citología es un examen que puede salvar tu vida ya que detecta el cáncer del cuello del útero antes de que se extienda a otras partes del cuerpo. Si se detecta oportunamente, las probabilidades de curarlo son mucho mayores. Este examen consiste en tomar células del cuello de la matriz para verlas al microscopio y detectar células anormales que puedan convertirse en células cancerosas y detectar inflamaciones. Los doctores recomiendan que debes hacértela al menos una vez al año. También se realizará una ultrasonografía pélvica, enfocada en visualizar el útero y los ovarios para detectar anomalías.
El cupón también incluye un examen físico de mamas y la lectura de los resultados especialista en el área.
¿Por qué recomendamos a Clínica Integral de Salud para la Mujer?
Porque en ella encontrarás todos los servicios que necesitas para cuidar de tu salud femenina. La clínica cuenta con doctoras especializadas en atención obstétrica y ginecológica integral que te brindarán calidad y amabilidad en tu visita. Entre sus servicios encontrarás atención de parto vaginal y cesárea, ultrasonografía obstétrica y ginecológica, aplicación de vacuna contra el Virus del Papiloma Humano, tratamiento del síndrome poliquístico, menopausia, planificación familiar, control prenatal y otros.
¿Cómo llegar?
Podrás canjear el cupón en avenida Max Bloch #1010 en Colonia Médica. ' AS `description`,'' AS `private_note`,'90.00' AS `original_price`,'18.00' AS `discounted_price`,'2018-02-15 17:08:00' AS `start_date`,'2024-12-31 00:00:00' AS `end_date`,'16' AS `sort_order`,'80' AS `discount_percentage`,'72.00' AS `discount_amount`,'72.00' AS `savings`,'1' AS `min_limit`,NULL AS `max_limit`,'42553' AS `city_id`,'0' AS `display_city_id`,'1286' AS `company_id`,'' AS `review`,'98' AS `deal_user_count`,'0' AS `payment_failed_count`,'1' AS `buy_min_quantity_per_user`,'3' AS `buy_max_quantity_per_user`,'2018-02-15 17:52:23' AS `deal_tipped_time`,'2024-12-31 00:00:00' AS `coupon_expiry_date`,'¡No dejes para después algo tan importante como tu salud! Un par de detalles: Es necesario programar cita llamando al 2225-6068 o 7740-4583 Los horarios de atención son de lunes a viernes de 8:00 am a 11:00 am y de 2:30 pm a 5:00 pm y sábados de 8:30 am a 12:00 pm. Cita podrá reprogramarse 1 vez, caso contrario se tomará como cupón canjeado. Recargo de .00 los sábados. ' AS `coupon_condition`,'La citología es un examen importantísimo para todas las mujeres—un análisis de la pequeña muestra que se toma de tu cuello uterino será suficiente para determinar la presencia de células anormales y peligrosas… (De no tratar estas anomalías podrían desembocar hasta en un cáncer de útero, y aunque de buenas a primeras no se presenten síntomas recuerda que más vale prevenida que arrepentida).
La ultrasonografía pélvica—es un método de diagnóstico seguro para evaluar la presencia de quistes y fibromas dañinos en el cuello uterino que a simple vista no se ven … (Descubrir cómo andan las cosas ahí adentro te permitirá sentir la tranquilidad de confirmar una buena salud o tomar cartas en el asunto ante algún problemita).
Serás atendida por doctoras especializadas en atención obstétrica y ginecológica integral … (Tu salud femenina será tratada por mujeres profesionales que te harán sentir en completa confianza durante tu evaluación). ' AS `coupon_highlights`,'' AS `comment`,'1' AS `is_coupon_mail_sent`,'0' AS `is_subscription_mail_sent`,'0' AS `is_side_deal`,'5' AS `deal_status_id`,'0.00' AS `bonus_amount`,'37.00' AS `commission_percentage`,'100.00' AS `commission_percent_unused`,NULL AS `vat_percent`,NULL AS `payment1_amt`,'' AS `payment1_date`,'' AS `payment1_check_no`,'' AS `payment1_bank`,NULL AS `payment1_comm`,NULL AS `payment1_vat`,'' AS `payment1_info`,'' AS `payment1_comments`,NULL AS `payment2_amt`,'' AS `payment2_date`,'' AS `payment2_check_no`,'' AS `payment2_bank`,NULL AS `payment2_comm`,NULL AS `payment2_vat`,'' AS `payment2_info`,'' AS `payment2_comments`,NULL AS `payment3_amt`,'' AS `payment3_date`,'' AS `payment3_check_no`,'' AS `payment3_bank`,NULL AS `payment3_comm`,NULL AS `payment3_vat`,'' AS `payment3_info`,'' AS `payment3_comments`,NULL AS `payment4_amt`,'' AS `payment4_date`,'' AS `payment4_check_no`,'' AS `payment4_bank`,NULL AS `payment4_comm`,NULL AS `payment4_vat`,'' AS `payment4_info`,'' AS `payment4_comments`,'66.70' AS `first_payment_percent`,'0' AS `added_coupons`,'0.00' AS `total_commission_amount`,'0.00' AS `total_purchased_amount`,'0.00' AS `net_profit`,'' AS `meta_keywords`,'' AS `meta_description`,'http://bit.ly/2ERtZXv' AS `bitly_short_url_subdomain`,'http://bit.ly/2ETXEzf' AS `bitly_short_url_prefix`,'0' AS `certainly`,'0' AS `probably`,'0' AS `unlikely_satisfied`,'0' AS `unlikely_unsatisfied`,'0' AS `survey_happy`,'0' AS `survey_fair`,'0' AS `survey_sad`,'Fernanda' AS `salesman`,NULL AS `zone`,NULL AS `industry`,'15' AS `category_id`,NULL AS `sub_category_id`,'female' AS `gender`,'4' AS `neighborhood_id`,'0.00' AS `sales_projection`,'' AS `facebook_description`,'' AS `facebook_title`,'Clínica Integral de Salud para la Mujer - CISM' AS `name`,`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`,`cuponclu_playpen120111`.`Fbpicture`.`id` AS `id`,`cuponclu_playpen120111`.`Fbpicture`.`created` AS `created`,`cuponclu_playpen120111`.`Fbpicture`.`modified` AS `modified`,`cuponclu_playpen120111`.`Fbpicture`.`class` AS `class`,`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`Fbpicture`.`filename` AS `filename`,`cuponclu_playpen120111`.`Fbpicture`.`dir` AS `dir`,`cuponclu_playpen120111`.`Fbpicture`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`Fbpicture`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`Fbpicture`.`height` AS `height`,`cuponclu_playpen120111`.`Fbpicture`.`width` AS `width`,`cuponclu_playpen120111`.`Fbpicture`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`Fbpicture`.`description` AS `description` from `cuponclu_playpen120111`.`deals` `Deal` left join `cuponclu_playpen120111`.`companies` `Company` on(multiple equal('1286', '1286')) left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 6771) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6771) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where true |
|
| 14 | 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` |
|
| 15 | SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `neighborhoods` AS `Neighborhood` WHERE 1 = 1 | | 10 | 10 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Neighborhood | | ALL | | | | | 10 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Neighborhood`.`id` AS `id`,`cuponclu_playpen120111`.`Neighborhood`.`name` AS `name` from `cuponclu_playpen120111`.`neighborhoods` `Neighborhood` |
|