| 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` = '677707a8e86402e4120d948b18c6f5df' | | 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:1792619982;s:4:"rand";i:1942328137;s:7:"timeout";i:10;}city_attachment|s:0:"";_Token|s:1213:"a:5:{s:3:"key";s:40:"fdc3b2ec0a395ac3eb94a0dfa3ce2307d9981137";s:7:"expires";i:1792613982;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:35:{i:0;s:10:"Attachment";i:1;s:7:"Picture";i:2;s:9:"Fbpicture";i:3;s:25:"Deal.calculator_min_limit";i:4;s:32:"Deal.calculator_discounted_price";i:5;s:28:"Deal.calculator_bonus_amount";i:6;s:37:"Deal.calculator_commission_percentage";i:7;s:28:"Deal.calculator_bonus_amount";i:8;s:37:"Deal.calculator_commission_percentage";i:9;s:15:"Deal.start_date";i:10;s:13:"Deal.end_date";i:11;s:23:"Deal.coupon_expiry_date";i:12;s:13:"DealStatus.id";i:13;s:15:"DealStatus.name";i:14;s:19:"Deal.original_price";i:15;s:12:"Deal.savings";i:16;s:7:"Deal.id";i:17;s:18:"Deal.save_as_draft";i:18;s:18:"Deal.send_to_admin";i:19;s:15:"Deal.gift_email";i:20;s:14:"Deal.gift_from";i:21;s:12:"Deal.gift_to";i:22;s:12:"Deal.message";i:23;s:13:"Deal.quantity";i:24;s:12:"Deal.message";i:25;s:16:"Deal.deal_amount";i:26;s:12:"Deal.deal_id";i:27;s:12:"Deal.is_gift";i:28;s:21:"User.confirm_password";i:29;s:10:"User.email";i:30;s:11:"User.passwd";i:31;s:13:"User.username";i:32;s:27:"Deal.user_available_balance";i:33;s:12:"Deal.gift_to";i:34;s:13:"Deal.salesman";}}";Auth|a:1:{s:11:"redirectUrl";s:32:"San-salvador/deals/checkout/6779";}' 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 `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` = 6784 AND `Deal`.`deal_status_id` IN (2, 5) LIMIT 1 | | 1 | 1 | 1 |
| 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 '6784' AS `id`,'2018-02-16 21:47:25' AS `created`,'PRUEBA-NO COMPRAR¡Paga en Lugar de 5 por 2 Rellenos o 4 Sellantes + Limpieza con Ultrasonido + Pulido Dental + Aplicación de Flúor + Diagnostico!' AS `name`,'2 Rellenos o 4 Sellantes + Limpieza con Ultrasonido' AS `short_name`,'¡paga--en-lugar-de-5-po' AS `slug`,'105.00' AS `original_price`,'85.00' AS `discount_amount`,' ¿Por qué lo necesitas?
¿Qué tal están esos dientes? ¿ves esa mancha en el colmillo? ¿Alguna fisura en la muela? ¿Nuevas caries? Si al sonreír frente al espejo piensas que ya es tiempo de hacer brillar esa sonrisa. ¡Esta oferta es para ti!
¿Qué es?
Los rellenos de resina se utilizan para reparar los dientes o muelas que han sido afectados por caries, grietas o fisuras. Si tu dentadura presenta caries, esta será quitada por medio del pulido y posteriormente rellenada con la resina. La limpieza dental se realizará con una máquina profesional que mediante vibraciones por ultrasonidos desprenden el sarro y manchas superficiales. La oferta también incluye pulido dental, aplicación tópica de flúor y examen diagnóstico.
¿Por qué recomendamos a Forever Smile?
Forever Smile es una empresa que se dedica a la prestación de servicios dentales especializados y es atendida por cirujanos dentistas con experiencia en cualquier rama de la odontología general. Utilizan los equipos más modernos y los materiales de la mejor calidad. Todo procedimiento es efectuado por profesionales preparados durante varios años y bajo los más estrictos cuidados y estándares de esterilización internacionales, garantizando así la prevención de contagio con cualquier infección.
¿Cómo llegar?
Encuentra a Forever Smile en Pasaje Dordelli, #4410, entre 85 y 87 Avenida Norte, Colonia Escalón, San Salvador. Subiendo sobre el Paseo General Escalón hacia el Redondel Masferrer cruzarás sobre la 85 Avenida Norte buscando el pasaje Dordelli, encontrarás la clínica justo frente a Beto's Escalón. ' AS `description`,'81' AS `discount_percentage`,'1' AS `min_limit`,NULL AS `max_limit`,'16' AS `deal_user_count`,'20.00' AS `discounted_price`,'1' AS `buy_min_quantity_per_user`,NULL AS `buy_max_quantity_per_user`,'42553' AS `city_id`,'2018-02-18 14:00: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` = 6784) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6784) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where (('5' in (2,5))) limit 1 |
|
|---|
| 6 | 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 |
|
|---|
| 7 | 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 |
|
|---|
| 8 | 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 |
|
|---|
| 9 | 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) |
|
|---|
| 10 | 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` |
|
|---|
| 11 | 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))) |
|
|---|
| 12 | 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` = 6784 | | 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 '6784' AS `id`,'2018-02-16 21:47:25' AS `created`,'2018-10-11 15:58:00' AS `modified`,'233925' AS `user_id`,'PRUEBA-NO COMPRAR¡Paga en Lugar de 5 por 2 Rellenos o 4 Sellantes + Limpieza con Ultrasonido + Pulido Dental + Aplicación de Flúor + Diagnostico!' AS `name`,'2 Rellenos o 4 Sellantes + Limpieza con Ultrasonido' AS `short_name`,'2 Rellenos o 4 Sellantes + Limpieza con Ultrasonido + Pulido Dental + Aplicación de Flúor + Diagnostico' AS `coupon_name`,'Colonia Escalón' AS `display_neighborhoodname`,'¡paga--en-lugar-de-5-po' AS `slug`,NULL AS `bitly_short_url`,' ¿Por qué lo necesitas?
¿Qué tal están esos dientes? ¿ves esa mancha en el colmillo? ¿Alguna fisura en la muela? ¿Nuevas caries? Si al sonreír frente al espejo piensas que ya es tiempo de hacer brillar esa sonrisa. ¡Esta oferta es para ti!
¿Qué es?
Los rellenos de resina se utilizan para reparar los dientes o muelas que han sido afectados por caries, grietas o fisuras. Si tu dentadura presenta caries, esta será quitada por medio del pulido y posteriormente rellenada con la resina. La limpieza dental se realizará con una máquina profesional que mediante vibraciones por ultrasonidos desprenden el sarro y manchas superficiales. La oferta también incluye pulido dental, aplicación tópica de flúor y examen diagnóstico.
¿Por qué recomendamos a Forever Smile?
Forever Smile es una empresa que se dedica a la prestación de servicios dentales especializados y es atendida por cirujanos dentistas con experiencia en cualquier rama de la odontología general. Utilizan los equipos más modernos y los materiales de la mejor calidad. Todo procedimiento es efectuado por profesionales preparados durante varios años y bajo los más estrictos cuidados y estándares de esterilización internacionales, garantizando así la prevención de contagio con cualquier infección.
¿Cómo llegar?
Encuentra a Forever Smile en Pasaje Dordelli, #4410, entre 85 y 87 Avenida Norte, Colonia Escalón, San Salvador. Subiendo sobre el Paseo General Escalón hacia el Redondel Masferrer cruzarás sobre la 85 Avenida Norte buscando el pasaje Dordelli, encontrarás la clínica justo frente a Beto's Escalón. ' AS `description`,'' AS `private_note`,'105.00' AS `original_price`,'20.00' AS `discounted_price`,'2018-02-18 14:00:00' AS `start_date`,'2024-12-31 00:00:00' AS `end_date`,'11' AS `sort_order`,'81' AS `discount_percentage`,'85.00' AS `discount_amount`,'85.00' AS `savings`,'1' AS `min_limit`,NULL AS `max_limit`,'42553' AS `city_id`,'0' AS `display_city_id`,'1475' AS `company_id`,'' AS `review`,'16' AS `deal_user_count`,'0' AS `payment_failed_count`,'1' AS `buy_min_quantity_per_user`,NULL AS `buy_max_quantity_per_user`,'2018-02-19 01:43:30' AS `deal_tipped_time`,'2024-12-31 00:00:00' AS `coupon_expiry_date`,'¡Sonríe sin pena! Un par de detalles: Realiza tu cita llamando al 2264-6055. Horario de atención de lunes a viernes de 8:30 am a 6:00 pm y sábado de 8:30 am a 12:00 pm. Recargo de los sábados. Válido 1 reprogramación. Espera máxima de 15 minutos. Máximo 1 cupón por persona. No aplica para cambios de rellenos. Válido para mayores de 10 años. Si el relleno requiere de procedimientos adicionales (como una endodoncia, por ejemplo) deberás pagar el costo de los servicios extras. ' AS `coupon_condition`,'2 rellenos de resina—la mejor alternativa para eliminar las caries y corregir fisuras y grietas sin que se note. Se acopla al color de tus dientes por lo que el resultado es imperceptible ¡parecerá que nunca padeciste caries!
La limpieza con ultrasonido—es una tecnología indolora que no utiliza químicos y que evita la sensibilidad. Remueve la suciedad y el sarro de forma fácil y rápida (es la mejor opción para llegar hasta los lugares más escondidos de tu dentadura y al que el cepillo no llega).
La aplicación de flúor protegerá tus dientes de futuras caries.
Serás atendido por manos profesionales y reconocidos dentistas a nivel nacional–7 años de experiencia construyendo las mejores sonrisas lo confirman. ' 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`,'40.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/2EWk96K' AS `bitly_short_url_subdomain`,'http://bit.ly/2EWk8zI' 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`,'6' AS `category_id`,NULL AS `sub_category_id`,'unisex' AS `gender`,'0' AS `neighborhood_id`,'0.00' AS `sales_projection`,'' AS `facebook_description`,'' AS `facebook_title`,'Forever Smile' 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('1475', '1475')) left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 6784) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6784) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where true |
|
|---|
| 13 | 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` |
|
|---|
| 14 | 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` |
|
|---|
![[Imagen:WhatsApp]](https://playpen.cuponclub.net/img/blue-theme/whatsapp.png "WhatsApp"){kind=small}
7568-9447 
![[Imagen:WhatsApp]](https://playpen.cuponclub.net/img/blue-theme/whatsappheader.png "WhatsApp"){kind=small}
