COVID-19: En función de proteger a nuestros clientes y permitir que se practique adecuadamente el distanciamiento social sin perder el uso de sus cupones, hemos extendido la vigencia de los cupones vigentes hasta el 31 de julio. Si la situación entonces lo requiere, extenderemos la vigencia de nuevo.

Cupones con descuentos del 50-90% en los mejores lugares

Clic aquí para suscribirte a recibir nuestras ofertas

Cupón Club

Guatemala

Más Ciudades

Para comprar en línea:

¿Necesitas ayuda? L-V 9:00 AM - 5:00 PM

5632-4924

Llena el formulario y completa la orden.

¿Quieres regalar este cupón? Clic aquí.

Descripción	Cantidad	Precio	Total
PRUEBA-NO COMPRAR¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!		Q299.00	Q299.00
Total del Carrito			Q299.00

¿No tienes una cuenta?

Regístrate

Puedes crear una cuenta con un formulario.

Centro Comercio Unicentro (Zona 10)

Ubicación: Tercer Nivel, área de restaurantes a mano izquierda de las gradas eléctricas
Lunes a Viernes de 8:30 am a 8:00 pm y fin de semana de 10:00 am a 7:00 pm.

Las Plazas Majadas (Zona 11)

Ubicación: Entrada Principal Kiosco 7

Lunes a Viernes de 10:00 am a 8:00 pm y fin de semana de 10:00 am a 7:00 pm.

Nuestro trabajo es darte experiencias increíbles. Cada cupón cuenta con nuestro respaldo. Haz clic para leer nuestra fuerte garantia.

Session
Session
- Config
  - userAgentba15070f06aa4c878a6794410449d967
  - time1792623918
  - rand1841209506
  - timeout10
- city_attachment(empty)
- _Tokena:5:{s:3:"key";s:40:"c870cb6d6603c26f3437b7b7bf2f0554c1c3cee5";s:7:"expires";i:1792617918;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
  - redirectUrlguatemala-city/deals/checkout/6797
Request
Request

Cake Params
- pass
  - 06797
- named
  - cityguatemala-city
- controllerdeals
- actioncheckout
- plugin(null)
- url
  - exthtml
  - urlguatemala-city/deals/checkout/6797
- form(empty)
- isAjax(false)
- _Token
  - keyc870cb6d6603c26f3437b7b7bf2f0554c1c3cee5
  - expires1792617918
  - allowedControllers(empty)
  - allowedActions(empty)
  - disabledFields
    - 0Attachment
    - 1Picture
    - 2Fbpicture
    - 3Deal.calculator_min_limit
    - 4Deal.calculator_discounted_price
    - 5Deal.calculator_bonus_amount
    - 6Deal.calculator_commission_percentage
    - 7Deal.calculator_bonus_amount
    - 8Deal.calculator_commission_percentage
    - 9Deal.start_date
    - 10Deal.end_date
    - 11Deal.coupon_expiry_date
    - 12DealStatus.id
    - 13DealStatus.name
    - 14Deal.original_price
    - 15Deal.savings
    - 16Deal.id
    - 17Deal.save_as_draft
    - 18Deal.send_to_admin
    - 19Deal.gift_email
    - 20Deal.gift_from
    - 21Deal.gift_to
    - 22Deal.message
    - 23Deal.quantity
    - 24Deal.message
    - 25Deal.deal_amount
    - 26Deal.deal_id
    - 27Deal.is_gift
    - 28User.confirm_password
    - 29User.email
    - 30User.passwd
    - 31User.username
    - 32Deal.user_available_balance
    - 33Deal.gift_to
    - 34Deal.salesman
$_GET
- urlguatemala-city/deals/checkout/6797
Cookie
- city_slugSan-salvador
- city_languagees
- Box
  - category
    - 62
Current Route
- 0/:city/:controller/:action/*
- 1#^(?:/((?!app|pages|devs|images|cybersource_logs|translations|languages|user_cash_withdrawals|subscription_emails|user_openids|gift_users|credomatic_logs|temp_contacts|user_comments|companies|invoices|deal_sub_categories|authorizenet_docapture_logs|bp_transaction_types|user_permission_preferences|transaction_types|payment_gateways|city_suggestions|users|scheduled_emails|user_logins|crons|cities|email_segments|fraud_status_logs|business_suggestions|user_profiles|user_friends|fc_companies|topic_discussions|deal_user_coupons|subscriptions|transactions|fc_company_addresses|email_templates|banned_ips|cash_coupons|paypal_transaction_logs|company_addresses|fc_coupons|user_views|paypal_mobile_logs|deal_categories|countries|deal_users|bonus_point_transactions|states|contacts|payment_gateway_settings|deal_categories_subscriptions|topics_users|deals|cybersource_tokens|settings|topics|paypal_docapture_logs|user_payment_profiles|blocked_users|cash_coupon|company|fc_company|fc_coupon|fraud_status_log|deal|page|user|admin|deal_user|contactus|sitemap|robots|sitemap.xml|robots.txt|welcome_to_cupon_club)[^\/]*))(?:/([^\/]+))?(?:/([^\/]+))?(?:/(.*))?[\/]*$#
- 2
  - 0city
  - 1controller
  - 2action
- 3
  - plugin(null)
  - controller(null)
  - actionindex
- 4
  - city(?!app|pages|devs|images|cybersource_logs|translations|languages|user_cash_withdrawals|subscription_emails|user_openids|gift_users|credomatic_logs|temp_contacts|user_comments|companies|invoices|deal_sub_categories|authorizenet_docapture_logs|bp_transaction_types|user_permission_preferences|transaction_types|payment_gateways|city_suggestions|users|scheduled_emails|user_logins|crons|cities|email_segments|fraud_status_logs|business_suggestions|user_profiles|user_friends|fc_companies|topic_discussions|deal_user_coupons|subscriptions|transactions|fc_company_addresses|email_templates|banned_ips|cash_coupons|paypal_transaction_logs|company_addresses|fc_coupons|user_views|paypal_mobile_logs|deal_categories|countries|deal_users|bonus_point_transactions|states|contacts|payment_gateway_settings|deal_categories_subscriptions|topics_users|deals|cybersource_tokens|settings|topics|paypal_docapture_logs|user_payment_profiles|blocked_users|cash_coupon|company|fc_company|fc_coupon|fraud_status_log|deal|page|user|admin|deal_user|contactus|sitemap|robots|sitemap.xml|robots.txt|welcome_to_cupon_club)[^\/]*

Sql Log

Sql Logs

default

17 queries took 3 ms

Query

Error

Affected

Num. rows

Took (ms)

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

EXPLAIN

Id	Select Type	Table	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

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` = 'guatemala-city' AND `City`.`is_approved` = 1 LIMIT 1

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` = 'guatemala-city')) limit 1

DESCRIBE `email_templates`

DESCRIBE `survey_questions`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '14c59c6ad9c01db6ac054ab89953afb8'

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:1792623918;s:4:"rand";i:1841209506;s:7:"timeout";i:10;}city_attachment\|s:0:"";_Token\|s:179:"a:5:{s:3:"key";s:40:"c870cb6d6603c26f3437b7b7bf2f0554c1c3cee5";s:7:"expires";i:1792617918;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:0:{}}";' AS `data` from `cuponclu_playpen120111`.`cake_sessions` where true

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` = 'guatemala-city' AND `City`.`is_approved` = 1 LIMIT 1

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` = 'guatemala-city')) limit 1

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

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

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` = 6797 AND `Deal`.`deal_status_id` IN (2, 5) LIMIT 1

EXPLAIN

Id	Select Type	Table	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	1	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 '6797' AS `id`,'2018-09-03 15:58:40' AS `created`,'PRUEBA-NO COMPRAR¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!' AS `name`,'3 Rellenos Dentales + Limpieza Profunda con Ultrasonido y Más' AS `short_name`,'¡paga-q299-en-lugar-q1,500-po' AS `slug`,'1500.00' AS `original_price`,'1201.00' AS `discount_amount`,'

¿Por qué lo necesitas?

¿Dientes sensibles al tomar algo helado o caliente? ¿Dolor repentino al masticar? ¿Hinchazón en tus mejillas? Si tienes alguno de estos síntomas y no trataste problemas de caries a tiempo, es probable que tu diente esté afectado en gran medida. Por suerte, ¡no debes perder tu diente para sanar tu sonrisa! Conserva tus piezas dentales y salud de las mismas con esta oferta.

¿Qué es?

Los 3 rellenos repararán las piezas dentales que han sido fracturadas o agrietas por las caries rellenándolas con resina del color natural de los dientes. Si tus piezas dentales no necesitan de rellenos, se procederá a realizar 4 sellantes previniendo así el aparecimiento de caries.

La limpieza con ultrasonido (indolora) se acompañará de un pulido dental con Profijet que eliminará eficientemente las manchas superficiales. Recibirás además aplicación de flúor para prevenir caries, 2 radiografías para analizar la estructura ósea de tus dientes y un examen diagnóstico con Cámara Intraoral.

¿Por qué recomendamos a Clínica Integral Odontológica?

Clínica Integral de Odontológica cuenta con un equipo de profesionales altamente capacitados en salud bucodental, comprometidos con brindar el mejor servicio a cada uno de sus pacientes. Ofrece servicios para todas las edades en diversas especialidades como odontología general, odontología restauradora, preventiva, cosmética, endodoncia, ortodoncia y más.

¿Cómo llegar?

Encuéntralos en 18 calle 5-56 zona 10 Centro Comercial Unicentro Nivel 1 local 214.

' AS `description`,'80' AS `discount_percentage`,'1' AS `min_limit`,NULL AS `max_limit`,'8' AS `deal_user_count`,'299.00' AS `discounted_price`,'1' AS `buy_min_quantity_per_user`,'10' AS `buy_max_quantity_per_user`,'42563' AS `city_id`,'2018-09-03 17:00:00' AS `start_date`,'2025-01-02 00:00:00' AS `end_date` from `cuponclu_playpen120111`.`deals` `Deal` left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 6797) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6797) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where (('5' in (2,5))) limit 1

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

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

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

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

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

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

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)

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)

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

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`

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)

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)))

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` = 6797

EXPLAIN

Id	Select Type	Table	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	1	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 '6797' AS `id`,'2018-09-03 15:58:40' AS `created`,'2018-10-11 16:20:36' AS `modified`,'2827' AS `user_id`,'PRUEBA-NO COMPRAR¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!' AS `name`,'3 Rellenos Dentales + Limpieza Profunda con Ultrasonido y Más' AS `short_name`,'3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral en Clínica Integral Odontológica' AS `coupon_name`,'Zona 10' AS `display_neighborhoodname`,'¡paga-q299-en-lugar-q1,500-po' AS `slug`,NULL AS `bitly_short_url`,'

¿Por qué lo necesitas?

¿Qué es?

¿Por qué recomendamos a Clínica Integral Odontológica?

¿Cómo llegar?

Encuéntralos en 18 calle 5-56 zona 10 Centro Comercial Unicentro Nivel 1 local 214.

' AS `description`,'' AS `private_note`,'1500.00' AS `original_price`,'299.00' AS `discounted_price`,'2018-09-03 17:00:00' AS `start_date`,'2025-01-02 00:00:00' AS `end_date`,'13' AS `sort_order`,'80' AS `discount_percentage`,'1201.00' AS `discount_amount`,'1201.00' AS `savings`,'1' AS `min_limit`,NULL AS `max_limit`,'42563' AS `city_id`,'0' AS `display_city_id`,'1290' AS `company_id`,'' AS `review`,'8' AS `deal_user_count`,'0' AS `payment_failed_count`,'1' AS `buy_min_quantity_per_user`,'10' AS `buy_max_quantity_per_user`,'2018-09-03 18:21:05' AS `deal_tipped_time`,'2024-12-31 00:00:00' AS `coupon_expiry_date`,'

¡Sonreirás de oreja a oreja! Un par de detalles: No combinable con otras ofertas. Cita previa al teléfono: 2228-6040 y 5421-4334. Horario de atención: lunes a viernes de 9:00 am a 7:00 pm, sábados y domingos de 9:00 am a 5:00 pm. Recargo de Q20 por citas los fines de semana. Cancelaciones con 24 horas de anticipación. Presentarse 10 minutos antes de la hora de cita para preparación del servicio. ¡Que disfrutes!

' AS `coupon_condition`,'

3 rellenos de resina—una alternativa estética para corregir fisuras y grietas que se acopla al color de tus dientes por lo que el resultado es una restauración cosmética y agradable... (cualquiera diría que nunca has tenido un diente con caries).

El pulido se realiza con profijet—novedoso sistema que en base a agua a presión y compuestos carbonatados elimina las manchas de los dientes.

La limpieza es con ultrasonido—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).

La aplicación de flúor ayuda a prevenir caries y refuerza el esmalte dental.

El examen con cámara intraoral—analizará a detalle cualquier tipo de enfermedad bucal: gingivitis, periodontitis, halitosis entre otras… (Dándote tranquilidad o detectando cualquier problemita a tiempo).

' 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`,'35.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`,'¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!' AS `meta_keywords`,'¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!' AS `meta_description`,'http://bit.ly/2LW2dIC' AS `bitly_short_url_subdomain`,'http://bit.ly/2LUUI4H' 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`,'Glenda' AS `salesman`,NULL AS `zone`,NULL AS `industry`,'6' AS `category_id`,NULL AS `sub_category_id`,'unisex' AS `gender`,'10' AS `neighborhood_id`,'0.00' AS `sales_projection`,'' AS `facebook_description`,'' AS `facebook_title`,'Clínica Integral Odontológica' 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('1290', '1290')) left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 6797) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6797) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where true

SELECT `DealCategory`.`id`, `DealCategory`.`name` FROM `deal_categories` AS `DealCategory` WHERE 1 = 1

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`

SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `neighborhoods` AS `Neighborhood` WHERE 1 = 1

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`

Timer

Timers

Total Request Time: 0.852468m (seconds)

Message	time in seconds
Component initialization and startup	0.00151
Controller Action	0.00043
Render Controller Action	0.00155
Rendering View	0.00146
Rendering APP/views/deals/checkout.ctp	0.02163
Rendering APP/views/elements/users-login.ctp	0.0191
Rendering APP/views/users/login.ctp	0.00111
Rendering APP/views/layouts/default.ctp	0.02172
Rendering APP/views/elements/site_tracker.ctp	1.0E-5
Rendering APP/views/elements/cities-index-static.ctp	0.00016
Rendering APP/views/elements/deal-faq.ctp	0.01979
Rendering APP/views/pages/view.ctp	0.00045

Log

Logs

error.log

Time	Message
2026-10-21 16:35:51	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:35:58	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:36:11	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:36:45	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:37:42	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:37:50	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:37:56	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:01	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:02	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:02	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:16	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:16	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:17	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:39:17	Warning: Warning (2): Undefined variable $error in [CORE/cake/libs/cake_object.php, line 213]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_core_paths) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_object_map) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_companies) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deals) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_statuses) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_topic_types) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_coupons) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_categories) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_transactions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_cybersource_tokens) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_views) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_openids) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_friends) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_logins) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_paypal_transaction_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_payment_gateway_settings) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_bonus_point_transactions) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_cash_withdrawals) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_withdrawal_statuses) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_city_suggestions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_paypal_mobile_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_credomatic_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_banned_duis) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fraud_ids) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_cybersource_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_friend_statuses) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 16:56:43	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_email_templates) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_survey_questions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_default_en_us) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 16:56:43	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 16:56:43	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 16:56:43	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_core_paths) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_object_map) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_cuponclu_playpen120111_list) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_setting_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_languages) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_subscriptions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_cake_sessions) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_companies) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_transactions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_fc_company_addresses) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_views) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_comments) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_openids) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_blocked_users) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_users) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_paypal_docapture_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_payment_gateway_settings) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_gift_users) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_invoices) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_user_cash_withdrawals) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_credomatic_logs) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_topic_discussions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_topics_users) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_sub_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 17:27:40	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_email_templates) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_survey_questions) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_default_en_us) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 17:27:40	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 17:27:40	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 17:27:40	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 18:06:56	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_bp_transaction_types) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 18:06:56	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_topics_users) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 18:06:56	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_sub_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 18:06:56	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 18:06:56	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 18:06:56	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 19:30:19	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_credomatic_logs) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 19:30:19	Warning: Warning (2): fopen(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_user_coupons) [function.fopen]: Failed to open stream: No such file or directory in [CORE/cake/libs/file.php, line 156]
2026-10-21 19:30:19	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_model_default_deal_sub_categories) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 19:30:19	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 19:30:19	Warning: Warning (2): Cannot modify header information - headers already sent by (output started at /home/cuponclu/public_html/gitplaypen/core/cake/basics.php:111) in [APP/app_controller.php, line 127]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 19:30:19	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 19:30:19	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 19:30:19	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]
2026-10-21 19:43:36	Warning: Warning (2): unlink(/home/cuponclu/public_html/gitplaypen/app/tmp/cache/cake_core_default_en_us) [function.unlink]: No such file or directory in [CORE/cake/libs/file.php, line 292]
2026-10-21 19:43:36	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 432]
2026-10-21 19:43:36	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 466]
2026-10-21 19:43:36	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 469]
2026-10-21 19:43:36	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 470]
2026-10-21 19:43:36	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 471]
2026-10-21 19:43:36	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 472]
2026-10-21 19:43:36	Warning: Warning (2): ini_set() [function.ini-set]: Session ini settings cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 473]
2026-10-21 19:43:36	Warning: Warning (2): session_set_save_handler() [function.session-set-save-handler]: Session save handler cannot be changed after headers have already been sent in [CORE/cake/libs/session.php, line 477]

debug.log

Time	Message
2026-10-21 16:30:14	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:30:15	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:01	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:02	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:04	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:16	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:16	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:31:17	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:34:50	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:34:55	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:35:37	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:35:49	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:35:49	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 16:35:57	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:47:58	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:48:17	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:48:18	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:48:19	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:49:08	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:49:39	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:52:22	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:52:22	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 17:52:23	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:01:23	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:01:24	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:01:25	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:02:05	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:02:25	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:24:42	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:24:42	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:24:43	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:30:29	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:30:29	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:30:30	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:35:10	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:35:10	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:35:12	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:37:30	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:37:30	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]
2026-10-21 18:37:31	Notice: Notice (8): ob_clean() [ref.outcontrol]: Failed to delete buffer. No buffer to delete in [CORE/cake/dispatcher.php, line 737]

Memory

Memory

Current Memory Use 4.49 MB

Peak Memory Use 9.22 MB
Variables
View Variables
- is_klaviyo_enabled
- city_id42563
- city_nameGuatemala
- city_slugguatemala-city
- city_attachment
  - id(null)
  - created(null)
  - modified(null)
  - class(null)
  - foreign_id(null)
  - filename(null)
  - dir(null)
  - mimetype(null)
  - filesize(null)
  - height(null)
  - width(null)
  - thumb(null)
  - description(null)
- payment_failed(null)
- deal_id6797
- cybersourceFingerprintUrlhttps://h.online-metrix.net/fp/tags.js?org_id=k8vif92e&session_id=visanetgt_cuponclub123456789
- showcaptcha(false)
- validation_errors(empty)
- gateway_options
  - paymentGateways
    - 7Visa o MasterCard
    - 5American Express
  - creditCardTypes
    - VisaVisa
    - MasterCardMasterCard
  - creditCardTypesAuthnet
    - AmexAmex
    - DiscoverOtros
- deals
  - 6797
    - Deal
      id6797
      created2018-09-03 15:58:40
      namePRUEBA-NO COMPRAR¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!
      short_name3 Rellenos Dentales + Limpieza Profunda con Ultrasonido y Más
      slug¡paga-q299-en-lugar-q1,500-po
      original_price1500.00
      discount_amount1201.00
      description
      ¿Por qué lo necesitas?
      
      ¿Dientes sensibles al tomar algo helado o caliente? ¿Dolor repentino al masticar? ¿Hinchazón en tus mejillas? Si tienes alguno de estos síntomas y no trataste problemas de caries a tiempo, es probable que tu diente esté afectado en gran medida. Por suerte, ¡no debes perder tu diente para sanar tu sonrisa! Conserva tus piezas dentales y salud de las mismas con esta oferta.
      
      ¿Qué es?
      
      Los 3 rellenos repararán las piezas dentales que han sido fracturadas o agrietas por las caries rellenándolas con resina del color natural de los dientes. Si tus piezas dentales no necesitan de rellenos, se procederá a realizar 4 sellantes previniendo así el aparecimiento de caries.
      
      La limpieza con ultrasonido (indolora) se acompañará de un pulido dental con Profijet que eliminará eficientemente las manchas superficiales. Recibirás además aplicación de flúor para prevenir caries, 2 radiografías para analizar la estructura ósea de tus dientes y un examen diagnóstico con Cámara Intraoral.
      
      ¿Por qué recomendamos a Clínica Integral Odontológica?
      
      Clínica Integral de Odontológica cuenta con un equipo de profesionales altamente capacitados en salud bucodental, comprometidos con brindar el mejor servicio a cada uno de sus pacientes. Ofrece servicios para todas las edades en diversas especialidades como odontología general, odontología restauradora, preventiva, cosmética, endodoncia, ortodoncia y más.
      
      ¿Cómo llegar?
      
      Encuéntralos en 18 calle 5-56 zona 10 Centro Comercial Unicentro Nivel 1 local 214.
      
      discount_percentage80
      min_limit1
      max_limit(null)
      deal_user_count8
      discounted_price299.00
      buy_min_quantity_per_user1
      buy_max_quantity_per_user10
      city_id42563
      start_date2018-09-03 17:00:00
      end_date2025-01-02 00:00:00
      user_quantity
- date_invoice_generation2023-08-16
- deals_forgoogleanalyricsecommerce
  - 0
    - Deal
      id6797
      created2018-09-03 15:58:40
      modified2018-10-11 16:20:36
      user_id2827
      namePRUEBA-NO COMPRAR¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!
      short_name3 Rellenos Dentales + Limpieza Profunda con Ultrasonido y Más
      coupon_name3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral en Clínica Integral Odontológica
      display_neighborhoodnameZona 10
      slug¡paga-q299-en-lugar-q1,500-po
      bitly_short_url(null)
      description
      ¿Por qué lo necesitas?
      
      ¿Dientes sensibles al tomar algo helado o caliente? ¿Dolor repentino al masticar? ¿Hinchazón en tus mejillas? Si tienes alguno de estos síntomas y no trataste problemas de caries a tiempo, es probable que tu diente esté afectado en gran medida. Por suerte, ¡no debes perder tu diente para sanar tu sonrisa! Conserva tus piezas dentales y salud de las mismas con esta oferta.
      
      ¿Qué es?
      
      Los 3 rellenos repararán las piezas dentales que han sido fracturadas o agrietas por las caries rellenándolas con resina del color natural de los dientes. Si tus piezas dentales no necesitan de rellenos, se procederá a realizar 4 sellantes previniendo así el aparecimiento de caries.
      
      La limpieza con ultrasonido (indolora) se acompañará de un pulido dental con Profijet que eliminará eficientemente las manchas superficiales. Recibirás además aplicación de flúor para prevenir caries, 2 radiografías para analizar la estructura ósea de tus dientes y un examen diagnóstico con Cámara Intraoral.
      
      ¿Por qué recomendamos a Clínica Integral Odontológica?
      
      Clínica Integral de Odontológica cuenta con un equipo de profesionales altamente capacitados en salud bucodental, comprometidos con brindar el mejor servicio a cada uno de sus pacientes. Ofrece servicios para todas las edades en diversas especialidades como odontología general, odontología restauradora, preventiva, cosmética, endodoncia, ortodoncia y más.
      
      ¿Cómo llegar?
      
      Encuéntralos en 18 calle 5-56 zona 10 Centro Comercial Unicentro Nivel 1 local 214.
      
      private_note(empty)
      original_price1500.00
      discounted_price299.00
      start_date2018-09-03 17:00:00
      end_date2025-01-02 00:00:00
      sort_order13
      discount_percentage80
      discount_amount1201.00
      savings1201.00
      min_limit1
      max_limit(null)
      city_id42563
      display_city_id
      company_id1290
      review(empty)
      deal_user_count8
      payment_failed_count
      buy_min_quantity_per_user1
      buy_max_quantity_per_user10
      deal_tipped_time2018-09-03 18:21:05
      coupon_expiry_date2024-12-31 00:00:00
      coupon_condition
      ¡Sonreirás de oreja a oreja! Un par de detalles: No combinable con otras ofertas. Cita previa al teléfono: 2228-6040 y 5421-4334. Horario de atención: lunes a viernes de 9:00 am a 7:00 pm, sábados y domingos de 9:00 am a 5:00 pm. Recargo de Q20 por citas los fines de semana. Cancelaciones con 24 horas de anticipación. Presentarse 10 minutos antes de la hora de cita para preparación del servicio. ¡Que disfrutes!
      coupon_highlights
      3 rellenos de resina—una alternativa estética para corregir fisuras y grietas que se acopla al color de tus dientes por lo que el resultado es una restauración cosmética y agradable... (cualquiera diría que nunca has tenido un diente con caries).
      
      El pulido se realiza con profijet—novedoso sistema que en base a agua a presión y compuestos carbonatados elimina las manchas de los dientes.
      
      La limpieza es con ultrasonido—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).
      
      La aplicación de flúor ayuda a prevenir caries y refuerza el esmalte dental.
      
      El examen con cámara intraoral—analizará a detalle cualquier tipo de enfermedad bucal: gingivitis, periodontitis, halitosis entre otras… (Dándote tranquilidad o detectando cualquier problemita a tiempo).
      
      comment(empty)
      is_coupon_mail_sent1
      is_subscription_mail_sent
      is_side_deal
      deal_status_id5
      bonus_amount0.00
      commission_percentage35.00
      commission_percent_unused100.00
      vat_percent(null)
      payment1_amt(null)
      payment1_date(empty)
      payment1_check_no(empty)
      payment1_bank(empty)
      payment1_comm(null)
      payment1_vat(null)
      payment1_info(empty)
      payment1_comments(empty)
      payment2_amt(null)
      payment2_date(empty)
      payment2_check_no(empty)
      payment2_bank(empty)
      payment2_comm(null)
      payment2_vat(null)
      payment2_info(empty)
      payment2_comments(empty)
      payment3_amt(null)
      payment3_date(empty)
      payment3_check_no(empty)
      payment3_bank(empty)
      payment3_comm(null)
      payment3_vat(null)
      payment3_info(empty)
      payment3_comments(empty)
      payment4_amt(null)
      payment4_date(empty)
      payment4_check_no(empty)
      payment4_bank(empty)
      payment4_comm(null)
      payment4_vat(null)
      payment4_info(empty)
      payment4_comments(empty)
      first_payment_percent66.70
      added_coupons
      total_commission_amount0.00
      total_purchased_amount0.00
      net_profit0.00
      meta_keywords¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!
      meta_description¡Paga Q299 en lugar Q1,500 por 3 Rellenos o 4 Sellantes + Limpieza Profunda con Ultrasonido + Pulido Dental con Profijet + Aplicación de Flúor + 2 Radiografías + Examen Dental y Evaluación con Cámara Intraoral!
      bitly_short_url_subdomainhttp://bit.ly/2LW2dIC
      bitly_short_url_prefixhttp://bit.ly/2LUUI4H
      certainly
      probably
      unlikely_satisfied
      unlikely_unsatisfied
      survey_happy
      survey_fair
      survey_sad
      salesmanGlenda
      zone(null)
      industry(null)
      category_id6
      sub_category_id(null)
      genderunisex
      neighborhood_id10
      sales_projection0.00
      facebook_description(empty)
      facebook_title(empty)
    - Company
      nameClínica Integral Odontológica
    - Attachment
      id1311
      created2018-09-03 23:57:00
      modified2018-09-03 23:57:00
      classDeal
      foreign_id6797
      filename127558619ecfa5e5b630e89f193f880d90364.jpg
      dirDeal/6797
      mimetypeimage/png
      filesize243285
      height327
      width579
      thumb(null)
      descriptionProduct Image
    - Fbpicture
      id(null)
      created(null)
      modified(null)
      class(null)
      foreign_id(null)
      filename(null)
      dir(null)
      mimetype(null)
      filesize(null)
      height(null)
      width(null)
      thumb(null)
      description(null)
- categories
  - 3Mecanicos & Carros
  - 2Floristas
  - 1Relaxation and Spas
  - 4Salones de belleza
  - 5Restaurantes
  - 6Dental - Sin Blanquimientos
  - 7Medicina Estetica - Incluyendo Blanquimientos
  - 8Mascotas
  - 9Hoteles
  - 10Reductivos, incluyendo Celulitis
  - 11Electronicos
  - 12Ropa y Zapatos
  - 13Otros Productos
  - 14Deportes Extremos
  - 15Medicina, Doctores, y otras cosas medicas
  - 16Clases y cursos
  - 17Conciertos
  - 18Gimnasios, Baile, Yoga, etc
  - 19Fotografia
  - 20Lentes
  - 21Clases de manejo
  - 22Otro
- neighborhoods
  - 0Generales para El Salvador
  - 2Generales para Guatemala
  - 3Santa Tecla y Merliot
  - 4Metrocentro y Colonia Médica
  - 5Plaza Mundo y Soyapango
  - 6Chalatenango
  - 7San Benito y Escalón
  - 8Mixco
  - 9Antigua Guatemala
  - 10Zona Metropolitana
- user(false)
- user_available_balance
- meta_for_layout
  - keywordsCupón Club | Enormes descuentos
  - descriptionEnormes descuentos en los mejores servicios de San Salvador! Spas, salones, restaurantes, deportes extremos y más.
- js_vars_for_layout
  - cfg
    - lang
      Are you sure you want to ¿Está seguro que desea
      Please select atleast one record!Por favor, seleccione al menos un récord!
      Are you sure you want to do this action?¿Estás seguro que quieres hacer esta acción?
      Please enter valid original price.Por favor, introduzca precio original válido.
      Discount percentage should be less than 100.porcentaje de descuento debe ser inferior a 100.
      Discount amount should be less than original price.importe del descuento debe ser menor que el precio original.
      Are you sure do you want to change the status? Once the status is changed you cannot undo the status.El comerciante mantiene una lista de los cupones utilizados. Usted puede marcar esta tal como se utiliza para sus propios archivos si lo desea. No se como se usa la marca no le permitirá volver a utilizarlo
      By clicking this button you are confirming your purchase. Once you confirmed amount will be deducted from your wallet and you can not undo this process. Are you sure you want to confirm this purchase?Al hacer clic en este botón estas confirmando tu compra. Una vez confirmada la cantidad se deducirá de su saldo y no se puede deshacer este proceso. ¿Estas seguro que desea confirmar esta compra?
      Google map could not find your location, please enter known location to googlemapa de Google no pudo encontrar su ubicación, por favor escribe ubicación conocida de google
      Invalid extension, Only csv, txt are allowedextensión no válido, sólo se permiten csv, txt
      StateDepartamento
      departmentDepartamento
      YearsAños
      MonthsMeses
      WeeksSemanas
      Days Días
    - icm
    - path_relative/
    - path_absolutehttps://www.playpen.cuponclub.net/
    - date_formatM d, Y
    - today_date2026-10-21
    - site_namecupon_club

Guatemala

Para comprar en línea:

¿No tienes una cuenta?

¿Ya tienes una cuenta?

Ingresar

Para comprar con efectivo:

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Timers

Logs

error.log

debug.log

Memory

View Variables