| 1 | SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`order`, `SettingCategory`.`id`, `SettingCategory`.`created`, `SettingCategory`.`modified`, `SettingCategory`.`name`, `SettingCategory`.`description`, `SiteLogo`.`id`, `SiteLogo`.`created`, `SiteLogo`.`modified`, `SiteLogo`.`class`, `SiteLogo`.`foreign_id`, `SiteLogo`.`filename`, `SiteLogo`.`dir`, `SiteLogo`.`mimetype`, `SiteLogo`.`filesize`, `SiteLogo`.`height`, `SiteLogo`.`width`, `SiteLogo`.`thumb`, `SiteLogo`.`description` FROM `settings` AS `Setting` LEFT JOIN `setting_categories` AS `SettingCategory` ON (`Setting`.`setting_category_id` = `SettingCategory`.`id`) LEFT JOIN `attachments` AS `SiteLogo` ON (`SiteLogo`.`foreign_id` = `Setting`.`id` AND `SiteLogo`.`class` = 'SiteLogo') WHERE 1 = 1 | | 213 | 213 | 1 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Setting | | ALL | | | | | 213 | 100.00 | |
| 1 | SIMPLE | SettingCategory | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_playpen120111.Setting.setting_category_id | 1 | 100.00 | Using index condition |
| 1 | SIMPLE | SiteLogo | | ref | foreign_id,class | foreign_id | 8 | cuponclu_playpen120111.Setting.id | 1 | 100.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Setting`.`id` AS `id`,`cuponclu_playpen120111`.`Setting`.`setting_category_id` AS `setting_category_id`,`cuponclu_playpen120111`.`Setting`.`name` AS `name`,`cuponclu_playpen120111`.`Setting`.`value` AS `value`,`cuponclu_playpen120111`.`Setting`.`description` AS `description`,`cuponclu_playpen120111`.`Setting`.`type` AS `type`,`cuponclu_playpen120111`.`Setting`.`options` AS `options`,`cuponclu_playpen120111`.`Setting`.`label` AS `label`,`cuponclu_playpen120111`.`Setting`.`order` AS `order`,`cuponclu_playpen120111`.`SettingCategory`.`id` AS `id`,`cuponclu_playpen120111`.`SettingCategory`.`created` AS `created`,`cuponclu_playpen120111`.`SettingCategory`.`modified` AS `modified`,`cuponclu_playpen120111`.`SettingCategory`.`name` AS `name`,`cuponclu_playpen120111`.`SettingCategory`.`description` AS `description`,`cuponclu_playpen120111`.`SiteLogo`.`id` AS `id`,`cuponclu_playpen120111`.`SiteLogo`.`created` AS `created`,`cuponclu_playpen120111`.`SiteLogo`.`modified` AS `modified`,`cuponclu_playpen120111`.`SiteLogo`.`class` AS `class`,`cuponclu_playpen120111`.`SiteLogo`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`SiteLogo`.`filename` AS `filename`,`cuponclu_playpen120111`.`SiteLogo`.`dir` AS `dir`,`cuponclu_playpen120111`.`SiteLogo`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`SiteLogo`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`SiteLogo`.`height` AS `height`,`cuponclu_playpen120111`.`SiteLogo`.`width` AS `width`,`cuponclu_playpen120111`.`SiteLogo`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`SiteLogo`.`description` AS `description` from `cuponclu_playpen120111`.`settings` `Setting` left join `cuponclu_playpen120111`.`setting_categories` `SettingCategory` on((`cuponclu_playpen120111`.`Setting`.`setting_category_id` = `cuponclu_playpen120111`.`SettingCategory`.`id`)) left join `cuponclu_playpen120111`.`attachments` `SiteLogo` on(((`cuponclu_playpen120111`.`SiteLogo`.`foreign_id` = `cuponclu_playpen120111`.`Setting`.`id`) and (`cuponclu_playpen120111`.`SiteLogo`.`class` = 'SiteLogo'))) where true |
|
| 2 | SELECT `City`.`language_id`, `Language`.`iso2`, `Language`.`id` FROM `cities` AS `City` LEFT JOIN `languages` AS `Language` ON (`City`.`language_id` = `Language`.`id`) WHERE `City`.`slug` = 'San-salvador' AND `City`.`is_approved` = 1 LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | City | | ref | slug | slug | 137 | const | 1 | 10.00 | Using where |
| 1 | SIMPLE | Language | | eq_ref | PRIMARY | PRIMARY | 8 | cuponclu_playpen120111.City.language_id | 1 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`City`.`language_id` AS `language_id`,`cuponclu_playpen120111`.`Language`.`iso2` AS `iso2`,`cuponclu_playpen120111`.`Language`.`id` AS `id` from `cuponclu_playpen120111`.`cities` `City` left join `cuponclu_playpen120111`.`languages` `Language` on((`cuponclu_playpen120111`.`Language`.`id` = `cuponclu_playpen120111`.`City`.`language_id`)) where ((`cuponclu_playpen120111`.`City`.`is_approved` = 1) and (`cuponclu_playpen120111`.`City`.`slug` = 'San-salvador')) limit 1 |
|
| 3 | SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '8ebb2ad6c389e311318ca9c4249831b0' | | 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:1792620019;s:4:"rand";i:1641379015;s:7:"timeout";i:10;}city_attachment|s:0:"";_Token|s:1213:"a:5:{s:3:"key";s:40:"3ffec3edd89c36422b486ce15cb0078da9a21aa4";s:7:"expires";i:1792614019;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:60:"San-salvador/deals/checkout/6779/type:gift/city:San-salvador";}' AS `data` from `cuponclu_playpen120111`.`cake_sessions` where true |
|
| 4 | SELECT `City`.`id`, `City`.`created`, `City`.`modified`, `City`.`country_id`, `City`.`state_id`, `City`.`language_id`, `City`.`name`, `City`.`slug`, `City`.`latitude`, `City`.`longitude`, `City`.`dma_id`, `City`.`county`, `City`.`code`, `City`.`deal_count`, `City`.`active_deal_count`, `City`.`is_approved`, `City`.`fb_user_id`, `City`.`fb_access_token`, `City`.`twitter_username`, `City`.`twitter_password`, `City`.`twitter_access_token`, `City`.`twitter_access_key`, `City`.`twitter_url`, `City`.`facebook_url`, `Attachment`.`id`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`class`, `Attachment`.`foreign_id`, `Attachment`.`filename`, `Attachment`.`dir`, `Attachment`.`mimetype`, `Attachment`.`filesize`, `Attachment`.`height`, `Attachment`.`width`, `Attachment`.`thumb`, `Attachment`.`description` FROM `cities` AS `City` LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `City`.`id` AND `Attachment`.`class` = 'City') WHERE `City`.`slug` = 'San-salvador' AND `City`.`is_approved` = 1 LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | City | | ref | slug | slug | 137 | const | 1 | 10.00 | Using where |
| 1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | cuponclu_playpen120111.City.id | 1 | 100.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`City`.`id` AS `id`,`cuponclu_playpen120111`.`City`.`created` AS `created`,`cuponclu_playpen120111`.`City`.`modified` AS `modified`,`cuponclu_playpen120111`.`City`.`country_id` AS `country_id`,`cuponclu_playpen120111`.`City`.`state_id` AS `state_id`,`cuponclu_playpen120111`.`City`.`language_id` AS `language_id`,`cuponclu_playpen120111`.`City`.`name` AS `name`,`cuponclu_playpen120111`.`City`.`slug` AS `slug`,`cuponclu_playpen120111`.`City`.`latitude` AS `latitude`,`cuponclu_playpen120111`.`City`.`longitude` AS `longitude`,`cuponclu_playpen120111`.`City`.`dma_id` AS `dma_id`,`cuponclu_playpen120111`.`City`.`county` AS `county`,`cuponclu_playpen120111`.`City`.`code` AS `code`,`cuponclu_playpen120111`.`City`.`deal_count` AS `deal_count`,`cuponclu_playpen120111`.`City`.`active_deal_count` AS `active_deal_count`,`cuponclu_playpen120111`.`City`.`is_approved` AS `is_approved`,`cuponclu_playpen120111`.`City`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`City`.`fb_access_token` AS `fb_access_token`,`cuponclu_playpen120111`.`City`.`twitter_username` AS `twitter_username`,`cuponclu_playpen120111`.`City`.`twitter_password` AS `twitter_password`,`cuponclu_playpen120111`.`City`.`twitter_access_token` AS `twitter_access_token`,`cuponclu_playpen120111`.`City`.`twitter_access_key` AS `twitter_access_key`,`cuponclu_playpen120111`.`City`.`twitter_url` AS `twitter_url`,`cuponclu_playpen120111`.`City`.`facebook_url` AS `facebook_url`,`cuponclu_playpen120111`.`Attachment`.`id` AS `id`,`cuponclu_playpen120111`.`Attachment`.`created` AS `created`,`cuponclu_playpen120111`.`Attachment`.`modified` AS `modified`,`cuponclu_playpen120111`.`Attachment`.`class` AS `class`,`cuponclu_playpen120111`.`Attachment`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`Attachment`.`filename` AS `filename`,`cuponclu_playpen120111`.`Attachment`.`dir` AS `dir`,`cuponclu_playpen120111`.`Attachment`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`Attachment`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`Attachment`.`height` AS `height`,`cuponclu_playpen120111`.`Attachment`.`width` AS `width`,`cuponclu_playpen120111`.`Attachment`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`Attachment`.`description` AS `description` from `cuponclu_playpen120111`.`cities` `City` left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = `cuponclu_playpen120111`.`City`.`id`) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'City'))) where ((`cuponclu_playpen120111`.`City`.`is_approved` = 1) and (`cuponclu_playpen120111`.`City`.`slug` = 'San-salvador')) limit 1 |
|
| 5 | SELECT `BannedIp`.`id`, `BannedIp`.`created`, `BannedIp`.`modified`, `BannedIp`.`address`, `BannedIp`.`range`, `BannedIp`.`referer_url`, `BannedIp`.`reason`, `BannedIp`.`redirect`, `BannedIp`.`thetime`, `BannedIp`.`timespan` FROM `banned_ips` AS `BannedIp` WHERE ((`BannedIp`.`address` = '3628718375') OR (`BannedIp`.`range` = '3628718375') OR (((`BannedIp`.`address` >= '3628718375') AND (`BannedIp`.`range` <= '3628718375'))) OR (((`BannedIp`.`address` <= '3628718375') AND (`BannedIp`.`range` >= '3628718375')))) LIMIT 1 | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | BannedIp | | ALL | address,range | | | | 2 | 85.94 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`BannedIp`.`id` AS `id`,`cuponclu_playpen120111`.`BannedIp`.`created` AS `created`,`cuponclu_playpen120111`.`BannedIp`.`modified` AS `modified`,`cuponclu_playpen120111`.`BannedIp`.`address` AS `address`,`cuponclu_playpen120111`.`BannedIp`.`range` AS `range`,`cuponclu_playpen120111`.`BannedIp`.`referer_url` AS `referer_url`,`cuponclu_playpen120111`.`BannedIp`.`reason` AS `reason`,`cuponclu_playpen120111`.`BannedIp`.`redirect` AS `redirect`,`cuponclu_playpen120111`.`BannedIp`.`thetime` AS `thetime`,`cuponclu_playpen120111`.`BannedIp`.`timespan` AS `timespan` from `cuponclu_playpen120111`.`banned_ips` `BannedIp` where ((`cuponclu_playpen120111`.`BannedIp`.`address` = '3628718375') or (`cuponclu_playpen120111`.`BannedIp`.`range` = '3628718375') or ((`cuponclu_playpen120111`.`BannedIp`.`address` >= '3628718375') and (`cuponclu_playpen120111`.`BannedIp`.`range` <= '3628718375')) or ((`cuponclu_playpen120111`.`BannedIp`.`address` <= '3628718375') and (`cuponclu_playpen120111`.`BannedIp`.`range` >= '3628718375'))) limit 1 |
|
| 6 | SELECT `Deal`.`id`, `Deal`.`created`, `Deal`.`name`, `Deal`.`short_name`, `Deal`.`slug`, `Deal`.`original_price`, `Deal`.`discount_amount`, `Deal`.`description`, `Deal`.`discount_percentage`, `Deal`.`min_limit`, `Deal`.`max_limit`, `Deal`.`deal_user_count`, `Deal`.`discounted_price`, `Deal`.`buy_min_quantity_per_user`, `Deal`.`buy_max_quantity_per_user`, `Deal`.`city_id`, `Deal`.`start_date`, `Deal`.`end_date` FROM `deals` AS `Deal` LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `Deal`.`id` AND `Attachment`.`class` = 'Deal') LEFT JOIN `fbpictures` AS `Fbpicture` ON (`Fbpicture`.`foreign_id` = `Deal`.`id` AND `Fbpicture`.`class` = 'Deal') WHERE `Deal`.`id` = 6793 AND `Deal`.`deal_status_id` IN (2, 5) LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Deal | | const | PRIMARY,deal_status_id | PRIMARY | 8 | const | 1 | 100.00 | |
| 1 | SIMPLE | Attachment | | ref | foreign_id,class | foreign_id | 8 | const | 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 '6793' AS `id`,'2018-02-20 16:52:18' AS `created`,'PRUEBA-NO COMPRAR Paga en Lugar de por Grooming para Tu Perro que Incluye: Baño, Limado y Corte de Uñas, Limpieza de Oídos y Glándulas Anales, Cepillado de Dientes, Perfume, Moño o Pañoleta + Desparasitación Oral e Inyectada!' AS `name`,'PRUEBA-NO COMPRARGrooming para Tu Mascota + Desparasitación Oral e Inyectada' AS `short_name`,'paga--en-lugar-de--por' AS `slug`,'35.00' AS `original_price`,'33.95' AS `discount_amount`,' ¿Por qué lo necesitas?
Tener un perro conlleva una gran responsabilidad. Más allá de jugar con él, hacerle mimos y tomarte mil fotos, tu peludo requiere de cuidados especializados que le ayuden a mantenerse hermoso, pero también saludable. Con la oferta de hoy, lograrás ambas cosas en manos de profesionales amantes de mascotas.
¿Qué es?
Para empezar esta sesión de embellecimiento le darán un refrescante baño, es importante realizarlo ya que una buena higiene provee no solo belleza, sino también salud a la piel de los animales. Luego, le secarán el pelo para cepillarlo y embellecerlo con un moño o pañuelo. También cepillarán sus dientes, cortarán y limarán sus uñas y limpiarán sus oídos y sus glándulas anales para finalmente perfumarlo y dejarlo hermoso desde la cabeza hasta la punta de la colita.
El cupón también incluye un desparasitante oral y uno inyectado.
¿Por qué recomendamos a Veterinaria Pet Plus?
Convenientemente ubicado cerca del redondel Luceiro, Pet Plus es una veterinaria dedicada a brindar todo tipo de servicios para el cuidado y salud de tus mascotas: consulta clínica, profilaxis dental, cirugías, vacunaciones, desparasitaciones y grooming. Su personal está conformado por profesionales del rubro y amantes del mundo animal. Brindan todos sus servicios pensando siempre en tu comodidad y fundamentalmente en el bienestar de tu mascota.
¿Cómo llegar?
Encuéntralos en Calle El Mirador #5123, bajando del redondel Luceiro, frente a WOW Store. ' AS `description`,'97' AS `discount_percentage`,'1' AS `min_limit`,NULL AS `max_limit`,'19' AS `deal_user_count`,'1.05' AS `discounted_price`,'1' AS `buy_min_quantity_per_user`,NULL AS `buy_max_quantity_per_user`,'42553' AS `city_id`,'2020-08-14 08:59:44' 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` = 6793) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6793) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where (('5' in (2,5))) limit 1 |
|
| 7 | SELECT `Setting`.`id`, `Setting`.`setting_category_id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`options`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE `Setting`.`setting_category_id` = 27 AND `Setting`.`name` = 'date_invoice_generation' LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Setting | | ref | setting_category_id,name | name | 767 | const | 1 | 34.27 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Setting`.`id` AS `id`,`cuponclu_playpen120111`.`Setting`.`setting_category_id` AS `setting_category_id`,`cuponclu_playpen120111`.`Setting`.`name` AS `name`,`cuponclu_playpen120111`.`Setting`.`value` AS `value`,`cuponclu_playpen120111`.`Setting`.`description` AS `description`,`cuponclu_playpen120111`.`Setting`.`type` AS `type`,`cuponclu_playpen120111`.`Setting`.`options` AS `options`,`cuponclu_playpen120111`.`Setting`.`label` AS `label`,`cuponclu_playpen120111`.`Setting`.`order` AS `order` from `cuponclu_playpen120111`.`settings` `Setting` where ((`cuponclu_playpen120111`.`Setting`.`setting_category_id` = 27) and (`cuponclu_playpen120111`.`Setting`.`name` = 'date_invoice_generation')) limit 1 |
|
| 8 | SELECT `User`.`id`, `User`.`fb_user_id`, `User`.`email`, `User`.`wallet_currency`, `User`.`referral_agent_id`, `User`.`bonus_points` FROM `users` AS `User` WHERE `User`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | | | | | | | | | | Impossible WHERE |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`User`.`id` AS `id`,`cuponclu_playpen120111`.`User`.`fb_user_id` AS `fb_user_id`,`cuponclu_playpen120111`.`User`.`email` AS `email`,`cuponclu_playpen120111`.`User`.`wallet_currency` AS `wallet_currency`,`cuponclu_playpen120111`.`User`.`referral_agent_id` AS `referral_agent_id`,`cuponclu_playpen120111`.`User`.`bonus_points` AS `bonus_points` from `cuponclu_playpen120111`.`users` `User` where false limit 1 |
|
| 9 | SELECT `PaymentGateway`.`id`, `PaymentGateway`.`created`, `PaymentGateway`.`modified`, `PaymentGateway`.`name`, `PaymentGateway`.`display_name`, `PaymentGateway`.`description`, `PaymentGateway`.`gateway_fees`, `PaymentGateway`.`transaction_count`, `PaymentGateway`.`payment_gateway_setting_count`, `PaymentGateway`.`is_test_mode`, `PaymentGateway`.`is_active` FROM `payment_gateways` AS `PaymentGateway` WHERE `PaymentGateway`.`id` = 7 AND `PaymentGateway`.`is_active` = 1 LIMIT 1 | | 1 | 1 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | PaymentGateway | | const | PRIMARY | PRIMARY | 4 | const | 1 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select '7' AS `id`,'2019-11-12 00:00:00' AS `created`,'2026-10-07 00:44:14' AS `modified`,'Cybersource' AS `name`,'Visa o MasterCard' AS `display_name`,'Credit card using Cybersource in Guatemala or El Salvador.' AS `description`,'0.00' AS `gateway_fees`,'0' AS `transaction_count`,'0' AS `payment_gateway_setting_count`,'0' AS `is_test_mode`,'1' AS `is_active` from `cuponclu_playpen120111`.`payment_gateways` `PaymentGateway` where true limit 1 |
|
| 10 | SELECT `PaymentGatewaySetting`.`key`, `PaymentGatewaySetting`.`test_mode_value`, `PaymentGatewaySetting`.`live_mode_value`, `PaymentGatewaySetting`.`payment_gateway_id` FROM `payment_gateway_settings` AS `PaymentGatewaySetting` WHERE `PaymentGatewaySetting`.`payment_gateway_id` = (7) | | 12 | 12 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | PaymentGatewaySetting | | ALL | | | | | 46 | 10.00 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` AS `key`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` AS `test_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`live_mode_value` AS `live_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` AS `payment_gateway_id` from `cuponclu_playpen120111`.`payment_gateway_settings` `PaymentGatewaySetting` where (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` = 7) |
|
| 11 | SELECT `PaymentGateway`.`id`, `PaymentGateway`.`created`, `PaymentGateway`.`modified`, `PaymentGateway`.`name`, `PaymentGateway`.`display_name`, `PaymentGateway`.`description`, `PaymentGateway`.`gateway_fees`, `PaymentGateway`.`transaction_count`, `PaymentGateway`.`payment_gateway_setting_count`, `PaymentGateway`.`is_test_mode`, `PaymentGateway`.`is_active` FROM `payment_gateways` AS `PaymentGateway` WHERE `PaymentGateway`.`is_active` = 1 ORDER BY `PaymentGateway`.`display_name` asc | | 6 | 6 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | PaymentGateway | | ALL | | | | | 7 | 14.29 | Using where; Using filesort |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`PaymentGateway`.`id` AS `id`,`cuponclu_playpen120111`.`PaymentGateway`.`created` AS `created`,`cuponclu_playpen120111`.`PaymentGateway`.`modified` AS `modified`,`cuponclu_playpen120111`.`PaymentGateway`.`name` AS `name`,`cuponclu_playpen120111`.`PaymentGateway`.`display_name` AS `display_name`,`cuponclu_playpen120111`.`PaymentGateway`.`description` AS `description`,`cuponclu_playpen120111`.`PaymentGateway`.`gateway_fees` AS `gateway_fees`,`cuponclu_playpen120111`.`PaymentGateway`.`transaction_count` AS `transaction_count`,`cuponclu_playpen120111`.`PaymentGateway`.`payment_gateway_setting_count` AS `payment_gateway_setting_count`,`cuponclu_playpen120111`.`PaymentGateway`.`is_test_mode` AS `is_test_mode`,`cuponclu_playpen120111`.`PaymentGateway`.`is_active` AS `is_active` from `cuponclu_playpen120111`.`payment_gateways` `PaymentGateway` where (`cuponclu_playpen120111`.`PaymentGateway`.`is_active` = 1) order by `cuponclu_playpen120111`.`PaymentGateway`.`display_name` |
|
| 12 | SELECT `PaymentGatewaySetting`.`id`, `PaymentGatewaySetting`.`created`, `PaymentGatewaySetting`.`modified`, `PaymentGatewaySetting`.`payment_gateway_id`, `PaymentGatewaySetting`.`key`, `PaymentGatewaySetting`.`type`, `PaymentGatewaySetting`.`options`, `PaymentGatewaySetting`.`test_mode_value`, `PaymentGatewaySetting`.`live_mode_value`, `PaymentGatewaySetting`.`description` FROM `payment_gateway_settings` AS `PaymentGatewaySetting` WHERE `PaymentGatewaySetting`.`key` IN ('is_enable_for_buy_a_deal', 'is_enable_wallet') AND `PaymentGatewaySetting`.`test_mode_value` = '1' AND `PaymentGatewaySetting`.`payment_gateway_id` IN (4, 5, 6, 3, 7, 1) | | 7 | 7 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | PaymentGatewaySetting | | ALL | | | | | 46 | 2.17 | Using where |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`PaymentGatewaySetting`.`id` AS `id`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`created` AS `created`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`modified` AS `modified`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` AS `payment_gateway_id`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` AS `key`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`type` AS `type`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`options` AS `options`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` AS `test_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`live_mode_value` AS `live_mode_value`,`cuponclu_playpen120111`.`PaymentGatewaySetting`.`description` AS `description` from `cuponclu_playpen120111`.`payment_gateway_settings` `PaymentGatewaySetting` where ((`cuponclu_playpen120111`.`PaymentGatewaySetting`.`key` in ('is_enable_for_buy_a_deal','is_enable_wallet')) and (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`test_mode_value` = '1') and (`cuponclu_playpen120111`.`PaymentGatewaySetting`.`payment_gateway_id` in (4,5,6,3,7,1))) |
|
| 13 | SELECT `Deal`.`id`, `Deal`.`created`, `Deal`.`modified`, `Deal`.`user_id`, `Deal`.`name`, `Deal`.`short_name`, `Deal`.`coupon_name`, `Deal`.`display_neighborhoodname`, `Deal`.`slug`, `Deal`.`bitly_short_url`, `Deal`.`description`, `Deal`.`private_note`, `Deal`.`original_price`, `Deal`.`discounted_price`, `Deal`.`start_date`, `Deal`.`end_date`, `Deal`.`sort_order`, `Deal`.`discount_percentage`, `Deal`.`discount_amount`, `Deal`.`savings`, `Deal`.`min_limit`, `Deal`.`max_limit`, `Deal`.`city_id`, `Deal`.`display_city_id`, `Deal`.`company_id`, `Deal`.`review`, `Deal`.`deal_user_count`, `Deal`.`payment_failed_count`, `Deal`.`buy_min_quantity_per_user`, `Deal`.`buy_max_quantity_per_user`, `Deal`.`deal_tipped_time`, `Deal`.`coupon_expiry_date`, `Deal`.`coupon_condition`, `Deal`.`coupon_highlights`, `Deal`.`comment`, `Deal`.`is_coupon_mail_sent`, `Deal`.`is_subscription_mail_sent`, `Deal`.`is_side_deal`, `Deal`.`deal_status_id`, `Deal`.`bonus_amount`, `Deal`.`commission_percentage`, `Deal`.`commission_percent_unused`, `Deal`.`vat_percent`, `Deal`.`payment1_amt`, `Deal`.`payment1_date`, `Deal`.`payment1_check_no`, `Deal`.`payment1_bank`, `Deal`.`payment1_comm`, `Deal`.`payment1_vat`, `Deal`.`payment1_info`, `Deal`.`payment1_comments`, `Deal`.`payment2_amt`, `Deal`.`payment2_date`, `Deal`.`payment2_check_no`, `Deal`.`payment2_bank`, `Deal`.`payment2_comm`, `Deal`.`payment2_vat`, `Deal`.`payment2_info`, `Deal`.`payment2_comments`, `Deal`.`payment3_amt`, `Deal`.`payment3_date`, `Deal`.`payment3_check_no`, `Deal`.`payment3_bank`, `Deal`.`payment3_comm`, `Deal`.`payment3_vat`, `Deal`.`payment3_info`, `Deal`.`payment3_comments`, `Deal`.`payment4_amt`, `Deal`.`payment4_date`, `Deal`.`payment4_check_no`, `Deal`.`payment4_bank`, `Deal`.`payment4_comm`, `Deal`.`payment4_vat`, `Deal`.`payment4_info`, `Deal`.`payment4_comments`, `Deal`.`first_payment_percent`, `Deal`.`added_coupons`, `Deal`.`total_commission_amount`, `Deal`.`total_purchased_amount`, `Deal`.`net_profit`, `Deal`.`meta_keywords`, `Deal`.`meta_description`, `Deal`.`bitly_short_url_subdomain`, `Deal`.`bitly_short_url_prefix`, `Deal`.`certainly`, `Deal`.`probably`, `Deal`.`unlikely_satisfied`, `Deal`.`unlikely_unsatisfied`, `Deal`.`survey_happy`, `Deal`.`survey_fair`, `Deal`.`survey_sad`, `Deal`.`salesman`, `Deal`.`zone`, `Deal`.`industry`, `Deal`.`category_id`, `Deal`.`sub_category_id`, `Deal`.`gender`, `Deal`.`neighborhood_id`, `Deal`.`sales_projection`, `Deal`.`facebook_description`, `Deal`.`facebook_title`, `Company`.`name`, `Attachment`.`id`, `Attachment`.`created`, `Attachment`.`modified`, `Attachment`.`class`, `Attachment`.`foreign_id`, `Attachment`.`filename`, `Attachment`.`dir`, `Attachment`.`mimetype`, `Attachment`.`filesize`, `Attachment`.`height`, `Attachment`.`width`, `Attachment`.`thumb`, `Attachment`.`description`, `Fbpicture`.`id`, `Fbpicture`.`created`, `Fbpicture`.`modified`, `Fbpicture`.`class`, `Fbpicture`.`foreign_id`, `Fbpicture`.`filename`, `Fbpicture`.`dir`, `Fbpicture`.`mimetype`, `Fbpicture`.`filesize`, `Fbpicture`.`height`, `Fbpicture`.`width`, `Fbpicture`.`thumb`, `Fbpicture`.`description` FROM `deals` AS `Deal` LEFT JOIN `companies` AS `Company` ON (`Deal`.`company_id` = `Company`.`id`) LEFT JOIN `attachments` AS `Attachment` ON (`Attachment`.`foreign_id` = `Deal`.`id` AND `Attachment`.`class` = 'Deal') LEFT JOIN `fbpictures` AS `Fbpicture` ON (`Fbpicture`.`foreign_id` = `Deal`.`id` AND `Fbpicture`.`class` = 'Deal') WHERE `Deal`.`id` = 6793 | | 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 | 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 '6793' AS `id`,'2018-02-20 16:52:18' AS `created`,'2018-10-11 15:40:18' AS `modified`,'233925' AS `user_id`,'PRUEBA-NO COMPRAR Paga en Lugar de por Grooming para Tu Perro que Incluye: Baño, Limado y Corte de Uñas, Limpieza de Oídos y Glándulas Anales, Cepillado de Dientes, Perfume, Moño o Pañoleta + Desparasitación Oral e Inyectada!' AS `name`,'PRUEBA-NO COMPRARGrooming para Tu Mascota + Desparasitación Oral e Inyectada' AS `short_name`,'Grooming para Tu Perro que Incluye: Baño, Limado y Corte de Uñas, Limpieza de Oídos y Glándulas Anales, Cepillado de Dientes, Perfume, Moño o Pañoleta + Desparasitación Oral e Inyectada' AS `coupon_name`,'Colonia Escalón' AS `display_neighborhoodname`,'paga--en-lugar-de--por' AS `slug`,NULL AS `bitly_short_url`,' ¿Por qué lo necesitas?
Tener un perro conlleva una gran responsabilidad. Más allá de jugar con él, hacerle mimos y tomarte mil fotos, tu peludo requiere de cuidados especializados que le ayuden a mantenerse hermoso, pero también saludable. Con la oferta de hoy, lograrás ambas cosas en manos de profesionales amantes de mascotas.
¿Qué es?
Para empezar esta sesión de embellecimiento le darán un refrescante baño, es importante realizarlo ya que una buena higiene provee no solo belleza, sino también salud a la piel de los animales. Luego, le secarán el pelo para cepillarlo y embellecerlo con un moño o pañuelo. También cepillarán sus dientes, cortarán y limarán sus uñas y limpiarán sus oídos y sus glándulas anales para finalmente perfumarlo y dejarlo hermoso desde la cabeza hasta la punta de la colita.
El cupón también incluye un desparasitante oral y uno inyectado.
¿Por qué recomendamos a Veterinaria Pet Plus?
Convenientemente ubicado cerca del redondel Luceiro, Pet Plus es una veterinaria dedicada a brindar todo tipo de servicios para el cuidado y salud de tus mascotas: consulta clínica, profilaxis dental, cirugías, vacunaciones, desparasitaciones y grooming. Su personal está conformado por profesionales del rubro y amantes del mundo animal. Brindan todos sus servicios pensando siempre en tu comodidad y fundamentalmente en el bienestar de tu mascota.
¿Cómo llegar?
Encuéntralos en Calle El Mirador #5123, bajando del redondel Luceiro, frente a WOW Store. ' AS `description`,'' AS `private_note`,'35.00' AS `original_price`,'1.05' AS `discounted_price`,'2020-08-14 08:59:44' AS `start_date`,'2024-12-31 00:00:00' AS `end_date`,'7' AS `sort_order`,'97' AS `discount_percentage`,'33.95' AS `discount_amount`,'33.95' AS `savings`,'1' AS `min_limit`,NULL AS `max_limit`,'42553' AS `city_id`,'42563' AS `display_city_id`,'1613' AS `company_id`,'' AS `review`,'19' 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-20 17:30:31' AS `deal_tipped_time`,'2024-12-31 00:00:00' AS `coupon_expiry_date`,'¡Consiente a tu amado peludo! Un par de detalles: Realiza tu cita llamando al 2263-7556. Horario de atención de lunes a viernes de 8:30 am a 3:30 pm y sábado de 8:30 am a 3:00 pm. Recargo de los sábados. La duración de los servicios y entrega de mascotas es de 2 a 3 horas. Recargo para mascotas arriba de 35 lbs. Si el perro tiene garrapatas, se deberá pagar .00 por baño. No incluye corte de pelo. Si hay exceso de nudos debe pagar corte de pelo. Consulta recargo por servicio a domicilio. Si el perro es muy agresivo, se le dará al dueño la desparasitación oral para que el la administre al perro. ¡Qué disfrutes! ' AS `coupon_condition`,'El grooming completo—un paquete de cuidados, limpieza y embellecimiento que dejará tu perro limpio, bello, relajado y saludable… (Te sentirás feliz al ver a tu peludo moviendo la cola y presumiendo su moño o pañoleta).
La limpieza de los oídos y glándulas es muy importante para preservar la salud de tu mascota—los oídos es el sentido con el que más perciben después del de la vista y la limpieza de las glándulas evita que sufra de estreñimiento y dolor.
Con el cepillado de dientes—evitarás posibles infecciones que afecten la salud general de tu mascota.
Con el desparasitante oral e inyectado—librarás a tu peludo de cualquier parásito que pueda afectar su salud y hasta la de tu familia… (Recuerda que es mejor prevenir que lamentar). ' AS `coupon_highlights`,'' AS `comment`,'1' AS `is_coupon_mail_sent`,'0' AS `is_subscription_mail_sent`,'0' AS `is_side_deal`,'5' AS `deal_status_id`,'0.00' AS `bonus_amount`,'37.00' AS `commission_percentage`,'100.00' AS `commission_percent_unused`,NULL AS `vat_percent`,NULL AS `payment1_amt`,'' AS `payment1_date`,'' AS `payment1_check_no`,'' AS `payment1_bank`,NULL AS `payment1_comm`,NULL AS `payment1_vat`,'' AS `payment1_info`,'' AS `payment1_comments`,NULL AS `payment2_amt`,'' AS `payment2_date`,'' AS `payment2_check_no`,'' AS `payment2_bank`,NULL AS `payment2_comm`,NULL AS `payment2_vat`,'' AS `payment2_info`,'' AS `payment2_comments`,NULL AS `payment3_amt`,'' AS `payment3_date`,'' AS `payment3_check_no`,'' AS `payment3_bank`,NULL AS `payment3_comm`,NULL AS `payment3_vat`,'' AS `payment3_info`,'' AS `payment3_comments`,NULL AS `payment4_amt`,'' AS `payment4_date`,'' AS `payment4_check_no`,'' AS `payment4_bank`,NULL AS `payment4_comm`,NULL AS `payment4_vat`,'' AS `payment4_info`,'' AS `payment4_comments`,'66.70' AS `first_payment_percent`,'0' AS `added_coupons`,'0.00' AS `total_commission_amount`,'0.00' AS `total_purchased_amount`,'0.00' AS `net_profit`,'' AS `meta_keywords`,'' AS `meta_description`,'http://bit.ly/2EWNH4U' AS `bitly_short_url_subdomain`,'http://bit.ly/2EUEYQN' 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`,'8' AS `category_id`,NULL AS `sub_category_id`,'unisex' AS `gender`,'7' AS `neighborhood_id`,'0.00' AS `sales_projection`,'' AS `facebook_description`,'' AS `facebook_title`,'Pet Plus ' 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('1613', '1613')) left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = 6793) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = 6793) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) where true |
|
| 14 | SELECT `DealCategory`.`id`, `DealCategory`.`name` FROM `deal_categories` AS `DealCategory` WHERE 1 = 1 | | 22 | 22 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | DealCategory | | ALL | | | | | 22 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`DealCategory`.`id` AS `id`,`cuponclu_playpen120111`.`DealCategory`.`name` AS `name` from `cuponclu_playpen120111`.`deal_categories` `DealCategory` |
|
| 15 | SELECT `Neighborhood`.`id`, `Neighborhood`.`name` FROM `neighborhoods` AS `Neighborhood` WHERE 1 = 1 | | 10 | 10 | 0 |
| EXPLAIN | | Id | Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| 1 | SIMPLE | Neighborhood | | ALL | | | | | 10 | 100.00 | |
| Level | Code | Message |
|---|
| Note | 1003 | /* select#1 */ select `cuponclu_playpen120111`.`Neighborhood`.`id` AS `id`,`cuponclu_playpen120111`.`Neighborhood`.`name` AS `name` from `cuponclu_playpen120111`.`neighborhoods` `Neighborhood` |
|