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 aún vigentes que se vieron afectados por COVID-19 para poder ser canjeados.

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

Clic aquí para suscribirte a recibir nuestras ofertas

Cupón Club

San Salvador

Más Ciudades

7568-9447

Comkarinho

Dirección: Calle y Pasaje El Mirador #5824 , San Salvador El Salvador 0016-8000
Teléfono: 2124-3990

Ofertas de propiedad

Session
Session
- Config
  - userAgentba15070f06aa4c878a6794410449d967
  - time1792619978
  - rand722011544
  - timeout10
- city_attachment(empty)
- _Tokena:5:{s:3:"key";s:40:"89f02a07c3045ae9fbbe88927cde5cd239baab44";s:7:"expires";i:1792613978;s:18:"allowedControllers";a:0:{}s:14:"allowedActions";a:0:{}s:14:"disabledFields";a:18:{i:0;s:4:"City";i:1;s:5:"State";i:2;s:16:"Company.latitude";i:3;s:17:"Company.longitude";i:4;s:22:"Company.map_zoom_level";i:5;s:19:"UserAvatar.filename";i:6;s:7:"User.id";i:7;s:10:"Company.id";i:8;s:16:"Company.address1";i:9;s:16:"Company.address2";i:10;s:23:"Company.company_profile";i:11;s:18:"Company.country_id";i:12;s:34:"Company.is_company_profile_enabled";i:13;s:12:"Company.name";i:14;s:13:"Company.phone";i:15;s:11:"Company.url";i:16;s:11:"Company.zip";i:17;s:31:"User.UserProfile.paypal_account";}}
Request
Request

Cake Params
- pass
  - 0comkarinho
- named
  - citySan-salvador
- controllercompanies
- actionview
- plugin(null)
- url
  - exthtml
  - urlSan-salvador/company/comkarinho
- form(empty)
- isAjax(false)
- _Token
  - key89f02a07c3045ae9fbbe88927cde5cd239baab44
  - expires1792613978
  - allowedControllers(empty)
  - allowedActions(empty)
  - disabledFields
    - 0City
    - 1State
    - 2Company.latitude
    - 3Company.longitude
    - 4Company.map_zoom_level
    - 5UserAvatar.filename
    - 6User.id
    - 7Company.id
    - 8Company.address1
    - 9Company.address2
    - 10Company.company_profile
    - 11Company.country_id
    - 12Company.is_company_profile_enabled
    - 13Company.name
    - 14Company.phone
    - 15Company.url
    - 16Company.zip
    - 17User.UserProfile.paypal_account
$_GET
- urlSan-salvador/company/comkarinho
Cookie
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

19 queries took 26 ms

Nr

Query

Error

Affected

Num. rows

Took (ms)

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

1

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

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

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` = '59f55e19520b137972a9a555830b46b2'

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:1792619978;s:4:"rand";i:722011544;s:7:"timeout";i:10;}city_attachment\|s:0:"";_Token\|s:1213:"a:5:{s:3:"key";s:40:"89f02a07c3045ae9fbbe88927cde5cd239baab44";s:7:"expires";i:1792613978;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";}}";' 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

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

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 `Company`.`id`, `Company`.`created`, `Company`.`modified`, `Company`.`name`, `Company`.`slug`, `Company`.`address1`, `Company`.`address2`, `Company`.`user_id`, `Company`.`city_id`, `Company`.`state_id`, `Company`.`country_id`, `Company`.`phone`, `Company`.`zip`, `Company`.`url`, `Company`.`deal_count`, `Company`.`is_online_account`, `Company`.`is_company_profile_enabled`, `Company`.`company_profile`, `Company`.`latitude`, `Company`.`longitude`, `Company`.`map_zoom_level`, `Company`.`survey_average`, `Company`.`survey_responses`, `Company`.`half_stars`, `Company`.`percent_to_return`, `User`.`email`, `User`.`user_type_id`, `User`.`username`, `User`.`id`, `User`.`available_balance_amount`, `User`.`is_email_confirmed`, `User`.`is_active`, `City`.`id`, `City`.`name`, `City`.`slug`, `State`.`id`, `State`.`name`, `Country`.`id`, `Country`.`name`, `Country`.`slug` FROM `companies` AS `Company` LEFT JOIN `users` AS `User` ON (`Company`.`user_id` = `User`.`id`) LEFT JOIN `cities` AS `City` ON (`Company`.`city_id` = `City`.`id`) LEFT JOIN `states` AS `State` ON (`Company`.`state_id` = `State`.`id`) LEFT JOIN `countries` AS `Country` ON (`Company`.`country_id` = `Country`.`id`) WHERE `Company`.`slug` = 'comkarinho' AND `Company`.`is_company_profile_enabled` = 1 AND `Company`.`is_online_account` = 1 LIMIT 1

1

0

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Company	ref	slug	slug	797	const	1	5.00	Using where
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Company.user_id	1	100.00	Using index condition
1	SIMPLE	City	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Company.city_id	1	100.00
1	SIMPLE	State	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Company.state_id	1	100.00	Using index condition
1	SIMPLE	Country	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Company.country_id	1	100.00

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`Company`.`id` AS `id`,`cuponclu_playpen120111`.`Company`.`created` AS `created`,`cuponclu_playpen120111`.`Company`.`modified` AS `modified`,`cuponclu_playpen120111`.`Company`.`name` AS `name`,`cuponclu_playpen120111`.`Company`.`slug` AS `slug`,`cuponclu_playpen120111`.`Company`.`address1` AS `address1`,`cuponclu_playpen120111`.`Company`.`address2` AS `address2`,`cuponclu_playpen120111`.`Company`.`user_id` AS `user_id`,`cuponclu_playpen120111`.`Company`.`city_id` AS `city_id`,`cuponclu_playpen120111`.`Company`.`state_id` AS `state_id`,`cuponclu_playpen120111`.`Company`.`country_id` AS `country_id`,`cuponclu_playpen120111`.`Company`.`phone` AS `phone`,`cuponclu_playpen120111`.`Company`.`zip` AS `zip`,`cuponclu_playpen120111`.`Company`.`url` AS `url`,`cuponclu_playpen120111`.`Company`.`deal_count` AS `deal_count`,`cuponclu_playpen120111`.`Company`.`is_online_account` AS `is_online_account`,`cuponclu_playpen120111`.`Company`.`is_company_profile_enabled` AS `is_company_profile_enabled`,`cuponclu_playpen120111`.`Company`.`company_profile` AS `company_profile`,`cuponclu_playpen120111`.`Company`.`latitude` AS `latitude`,`cuponclu_playpen120111`.`Company`.`longitude` AS `longitude`,`cuponclu_playpen120111`.`Company`.`map_zoom_level` AS `map_zoom_level`,`cuponclu_playpen120111`.`Company`.`survey_average` AS `survey_average`,`cuponclu_playpen120111`.`Company`.`survey_responses` AS `survey_responses`,`cuponclu_playpen120111`.`Company`.`half_stars` AS `half_stars`,`cuponclu_playpen120111`.`Company`.`percent_to_return` AS `percent_to_return`,`cuponclu_playpen120111`.`User`.`email` AS `email`,`cuponclu_playpen120111`.`User`.`user_type_id` AS `user_type_id`,`cuponclu_playpen120111`.`User`.`username` AS `username`,`cuponclu_playpen120111`.`User`.`id` AS `id`,`cuponclu_playpen120111`.`User`.`available_balance_amount` AS `available_balance_amount`,`cuponclu_playpen120111`.`User`.`is_email_confirmed` AS `is_email_confirmed`,`cuponclu_playpen120111`.`User`.`is_active` AS `is_active`,`cuponclu_playpen120111`.`City`.`id` AS `id`,`cuponclu_playpen120111`.`City`.`name` AS `name`,`cuponclu_playpen120111`.`City`.`slug` AS `slug`,`cuponclu_playpen120111`.`State`.`id` AS `id`,`cuponclu_playpen120111`.`State`.`name` AS `name`,`cuponclu_playpen120111`.`Country`.`id` AS `id`,`cuponclu_playpen120111`.`Country`.`name` AS `name`,`cuponclu_playpen120111`.`Country`.`slug` AS `slug` from `cuponclu_playpen120111`.`companies` `Company` left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`Company`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`cities` `City` on((`cuponclu_playpen120111`.`City`.`id` = `cuponclu_playpen120111`.`Company`.`city_id`)) left join `cuponclu_playpen120111`.`states` `State` on((`cuponclu_playpen120111`.`Company`.`state_id` = `cuponclu_playpen120111`.`State`.`id`)) left join `cuponclu_playpen120111`.`countries` `Country` on((`cuponclu_playpen120111`.`Country`.`id` = `cuponclu_playpen120111`.`Company`.`country_id`)) where ((`cuponclu_playpen120111`.`Company`.`is_online_account` = 1) and (`cuponclu_playpen120111`.`Company`.`is_company_profile_enabled` = 1) and (`cuponclu_playpen120111`.`Company`.`slug` = 'comkarinho')) limit 1

7

SELECT `User`.`email`, `User`.`user_type_id`, `User`.`username`, `User`.`id`, `User`.`available_balance_amount`, `User`.`is_email_confirmed`, `User`.`is_active` FROM `users` AS `User` WHERE `User`.`id` = 79233

1

0

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	User		const	PRIMARY	PRIMARY	8	const	1	100.00

Level	Code	Message
Note	1003	/* select#1 */ select 'ventas@example.com' AS `email`,'3' AS `user_type_id`,'comkarinho' AS `username`,'79233' AS `id`,'0.00' AS `available_balance_amount`,'1' AS `is_email_confirmed`,'1' AS `is_active` from `cuponclu_playpen120111`.`users` `User` where true

8

SELECT `UserAvatar`.`id`, `UserAvatar`.`created`, `UserAvatar`.`modified`, `UserAvatar`.`class`, `UserAvatar`.`foreign_id`, `UserAvatar`.`filename`, `UserAvatar`.`dir`, `UserAvatar`.`mimetype`, `UserAvatar`.`filesize`, `UserAvatar`.`height`, `UserAvatar`.`width`, `UserAvatar`.`thumb`, `UserAvatar`.`description` FROM `attachments` AS `UserAvatar` WHERE `UserAvatar`.`foreign_id` = 79233 AND `UserAvatar`.`class` = 'UserAvatar'

0

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	UserAvatar		ref	foreign_id,class	foreign_id	8	const	1	19.92	Using where

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`UserAvatar`.`id` AS `id`,`cuponclu_playpen120111`.`UserAvatar`.`created` AS `created`,`cuponclu_playpen120111`.`UserAvatar`.`modified` AS `modified`,`cuponclu_playpen120111`.`UserAvatar`.`class` AS `class`,`cuponclu_playpen120111`.`UserAvatar`.`foreign_id` AS `foreign_id`,`cuponclu_playpen120111`.`UserAvatar`.`filename` AS `filename`,`cuponclu_playpen120111`.`UserAvatar`.`dir` AS `dir`,`cuponclu_playpen120111`.`UserAvatar`.`mimetype` AS `mimetype`,`cuponclu_playpen120111`.`UserAvatar`.`filesize` AS `filesize`,`cuponclu_playpen120111`.`UserAvatar`.`height` AS `height`,`cuponclu_playpen120111`.`UserAvatar`.`width` AS `width`,`cuponclu_playpen120111`.`UserAvatar`.`thumb` AS `thumb`,`cuponclu_playpen120111`.`UserAvatar`.`description` AS `description` from `cuponclu_playpen120111`.`attachments` `UserAvatar` where ((`cuponclu_playpen120111`.`UserAvatar`.`foreign_id` = 79233) and (`cuponclu_playpen120111`.`UserAvatar`.`class` = 'UserAvatar'))

9

SELECT `City`.`id`, `City`.`name`, `City`.`slug` FROM `cities` AS `City` WHERE `City`.`id` = 43051

0

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE										no matching row in const table

Level	Code	Message
Note	1003	/* select#1 */ select NULL AS `id`,NULL AS `name`,NULL AS `slug` from `cuponclu_playpen120111`.`cities` `City` where multiple equal(43051, NULL)

10

SELECT `State`.`id`, `State`.`name` FROM `states` AS `State` WHERE `State`.`id` = 102

1

0

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	State		const	PRIMARY	PRIMARY	8	const	1	100.00

Level	Code	Message
Note	1003	/* select#1 */ select '102' AS `id`,'San Salvador' AS `name` from `cuponclu_playpen120111`.`states` `State` where true

11

SELECT `Country`.`id`, `Country`.`name`, `Country`.`slug` FROM `countries` AS `Country` WHERE `Country`.`id` = 69

1

0

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Country		const	PRIMARY	PRIMARY	8	const	1	100.00

Level	Code	Message
Note	1003	/* select#1 */ select '69' AS `id`,'El Salvador' AS `name`,'el-salvador' AS `slug` from `cuponclu_playpen120111`.`countries` `Country` where true

12

SELECT `Deal`.`id`, `Deal`.`name`, `Deal`.`slug`, `Deal`.`description`, `Deal`.`company_id` FROM `deals` AS `Deal` WHERE `Deal`.`deal_status_id` IN (2, 4, 5, 6, 8) AND `Deal`.`company_id` = (908) LIMIT 5

1

0

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Deal		ref	company_id,deal_status_id	company_id	8	const	2	62.12	Using where

Level	Code	Message
Note	1003	/* select#1 */ select `cuponclu_playpen120111`.`Deal`.`id` AS `id`,`cuponclu_playpen120111`.`Deal`.`name` AS `name`,`cuponclu_playpen120111`.`Deal`.`slug` AS `slug`,`cuponclu_playpen120111`.`Deal`.`description` AS `description`,`cuponclu_playpen120111`.`Deal`.`company_id` AS `company_id` from `cuponclu_playpen120111`.`deals` `Deal` where ((`cuponclu_playpen120111`.`Deal`.`company_id` = 908) and (`cuponclu_playpen120111`.`Deal`.`deal_status_id` in (2,4,5,6,8))) limit 5

13

SELECT `CompanyAddress`.`id`, `CompanyAddress`.`created`, `CompanyAddress`.`modified`, `CompanyAddress`.`address1`, `CompanyAddress`.`address2`, `CompanyAddress`.`company_id`, `CompanyAddress`.`city_id`, `CompanyAddress`.`state_id`, `CompanyAddress`.`country_id`, `CompanyAddress`.`phone`, `CompanyAddress`.`zip`, `CompanyAddress`.`url`, `CompanyAddress`.`latitude`, `CompanyAddress`.`longitude` FROM `company_addresses` AS `CompanyAddress` WHERE `CompanyAddress`.`company_id` = (908) ORDER BY `CompanyAddress`.`id` desc

0

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE										Impossible WHERE noticed after reading const tables

Level	Code	Message
Note	1003	/* select#1 */ select '2' AS `id`,'2011-11-07 23:50:19' AS `created`,'2011-11-07 23:50:19' AS `modified`,'Col. Escalon entre la 85 y 87ave. Norte No. 4436.' AS `address1`,'' AS `address2`,'246' AS `company_id`,'42553' AS `city_id`,'102' AS `state_id`,'69' AS `country_id`,'' AS `phone`,NULL AS `zip`,'' AS `url`,NULL AS `latitude`,NULL AS `longitude` from dual where false order by '2' desc

14

SELECT COUNT(*) AS `count` FROM `users` AS `User` LEFT JOIN `user_types` AS `UserType` ON (`User`.`user_type_id` = `UserType`.`id`) LEFT JOIN `users` AS `RefferalUser` ON (`User`.`referred_by_user_id` = `RefferalUser`.`id`) LEFT JOIN `users` AS `GiftRecivedFromUser` ON (`User`.`gift_user_id` = `GiftRecivedFromUser`.`id`) LEFT JOIN `user_profiles` AS `UserProfile` ON (`UserProfile`.`user_id` = `User`.`id`) LEFT JOIN `mobile_devices` AS `MobileDevice` ON (`MobileDevice`.`user_id` = `User`.`id`) LEFT JOIN `user_permission_preferences` AS `UserPermissionPreference` ON (`UserPermissionPreference`.`user_id` = `User`.`id`) LEFT JOIN `attachments` AS `UserAvatar` ON (`UserAvatar`.`foreign_id` = `User`.`id` AND `UserAvatar`.`class` = 'UserAvatar') LEFT JOIN `cake_sessions` AS `CkSession` ON (`CkSession`.`user_id` = `User`.`id`) LEFT JOIN `companies` AS `Company` ON (`Company`.`user_id` = `User`.`id`) LEFT JOIN `fc_companies` AS `FcCompany` ON (`FcCompany`.`user_id` = `User`.`id`) LEFT JOIN `suspect_pws` AS `SuspectPw` ON (`SuspectPw`.`id` = `User`.`id`) WHERE `User`.`referred_by_user_id` = 79233

1

10

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	User	ALL					10860	10.00	Using where
1	SIMPLE	UserType	eq_ref	PRIMARY	PRIMARY	4	cuponclu_playpen120111.User.user_type_id	1	100.00	Using index
1	SIMPLE	RefferalUser	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
1	SIMPLE	GiftRecivedFromUser	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.User.gift_user_id	1	100.00	Using where; Using index
1	SIMPLE	UserProfile	ref	user_id	user_id	8	cuponclu_playpen120111.User.id	1	100.00	Using index
1	SIMPLE	MobileDevice	eq_ref	user_id	user_id	9	cuponclu_playpen120111.User.id	1	100.00	Using where; Using index
1	SIMPLE	UserPermissionPreference	ref	user_id	user_id	8	cuponclu_playpen120111.User.id	1	100.00	Using index
1	SIMPLE	UserAvatar	ref	foreign_id,class	foreign_id	8	cuponclu_playpen120111.User.id	1	100.00	Using where
1	SIMPLE	CkSession	ref	user_id	user_id	8	cuponclu_playpen120111.User.id	11	100.00	Using where; Using index
1	SIMPLE	Company	ref	user_id	user_id	8	cuponclu_playpen120111.User.id	1	100.00	Using where; Using index
1	SIMPLE	FcCompany	ref	user_id	user_id	8	cuponclu_playpen120111.User.id	1	100.00	Using where; Using index
1	SIMPLE	SuspectPw	eq_ref	PRIMARY	PRIMARY	4	cuponclu_playpen120111.User.id	1	100.00	Using where; Using index

Level	Code	Message
Note	1003	/* select#1 */ select count(0) AS `count` from `cuponclu_playpen120111`.`users` `User` left join `cuponclu_playpen120111`.`user_types` `UserType` on((`cuponclu_playpen120111`.`UserType`.`id` = `cuponclu_playpen120111`.`User`.`user_type_id`)) left join `cuponclu_playpen120111`.`users` `RefferalUser` on((79233 = `cuponclu_playpen120111`.`RefferalUser`.`id`)) left join `cuponclu_playpen120111`.`users` `GiftRecivedFromUser` on((`cuponclu_playpen120111`.`User`.`gift_user_id` = `cuponclu_playpen120111`.`GiftRecivedFromUser`.`id`)) left join `cuponclu_playpen120111`.`user_profiles` `UserProfile` on((`cuponclu_playpen120111`.`UserProfile`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`mobile_devices` `MobileDevice` on((`cuponclu_playpen120111`.`MobileDevice`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`user_permission_preferences` `UserPermissionPreference` on((`cuponclu_playpen120111`.`UserPermissionPreference`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`attachments` `UserAvatar` on(((`cuponclu_playpen120111`.`UserAvatar`.`foreign_id` = `cuponclu_playpen120111`.`User`.`id`) and (`cuponclu_playpen120111`.`UserAvatar`.`class` = 'UserAvatar'))) left join `cuponclu_playpen120111`.`cake_sessions` `CkSession` on((`cuponclu_playpen120111`.`CkSession`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`companies` `Company` on((`cuponclu_playpen120111`.`Company`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`fc_companies` `FcCompany` on((`cuponclu_playpen120111`.`FcCompany`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`suspect_pws` `SuspectPw` on((`cuponclu_playpen120111`.`SuspectPw`.`id` = `cuponclu_playpen120111`.`User`.`id`)) where (`cuponclu_playpen120111`.`User`.`referred_by_user_id` = 79233)

15

SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` LEFT JOIN `users` AS `User` ON (`Deal`.`user_id` = `User`.`id`) LEFT JOIN `cities` AS `City` ON (`Deal`.`city_id` = `City`.`id`) LEFT JOIN `companies` AS `Company` ON (`Deal`.`company_id` = `Company`.`id`) LEFT JOIN `deal_statuses` AS `DealStatus` ON (`Deal`.`deal_status_id` = `DealStatus`.`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') LEFT JOIN `topics` AS `Topic` ON (`Topic`.`deal_id` = `Deal`.`id`) LEFT JOIN `deal_categories` AS `DealCategory` ON (`DealCategory`.`id` = `Deal`.`id`) LEFT JOIN `deal_sub_categories` AS `DealSubCategory` ON (`DealSubCategory`.`id` = `Deal`.`id`) LEFT JOIN `neighborhoods` AS `Neighborhood` ON (`Neighborhood`.`id` = `Deal`.`id`) WHERE ((`Deal`.`user_id` = 79233) OR (`Deal`.`company_id` = 908)) AND `Deal`.`deal_status_id` IN (2, 4, 5, 6, 8)

1

0

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	Deal	index_merge	company_id,deal_status_id,user_id	user_id,company_id	8,8		3	62.12	Using union(user_id,company_id); Using where
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Deal.user_id	1	100.00	Using where; Using index
1	SIMPLE	City	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Deal.city_id	1	100.00	Using index
1	SIMPLE	Company	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Deal.company_id	1	100.00	Using index
1	SIMPLE	DealStatus	eq_ref	PRIMARY	PRIMARY	4	cuponclu_playpen120111.Deal.deal_status_id	1	100.00	Using index
1	SIMPLE	Attachment	ref	foreign_id,class	foreign_id	8	cuponclu_playpen120111.Deal.id	1	100.00	Using where
1	SIMPLE	Fbpicture	ref	foreign_id,class	foreign_id	8	cuponclu_playpen120111.Deal.id	1	100.00	Using where
1	SIMPLE	Topic	ref	deal_id	deal_id	8	cuponclu_playpen120111.Deal.id	1	100.00	Using index
1	SIMPLE	DealCategory	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.Deal.id	1	100.00	Using where; Using index
1	SIMPLE	DealSubCategory	eq_ref	PRIMARY	PRIMARY	4	cuponclu_playpen120111.Deal.id	1	100.00	Using where; Using index
1	SIMPLE	Neighborhood	eq_ref	PRIMARY	PRIMARY	4	cuponclu_playpen120111.Deal.id	1	100.00	Using where; Using index

Level	Code	Message
Note	1003	/* select#1 */ select count(0) AS `count` from `cuponclu_playpen120111`.`deals` `Deal` left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`Deal`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`cities` `City` on((`cuponclu_playpen120111`.`City`.`id` = `cuponclu_playpen120111`.`Deal`.`city_id`)) left join `cuponclu_playpen120111`.`companies` `Company` on((`cuponclu_playpen120111`.`Company`.`id` = `cuponclu_playpen120111`.`Deal`.`company_id`)) left join `cuponclu_playpen120111`.`deal_statuses` `DealStatus` on((`cuponclu_playpen120111`.`DealStatus`.`id` = `cuponclu_playpen120111`.`Deal`.`deal_status_id`)) left join `cuponclu_playpen120111`.`attachments` `Attachment` on(((`cuponclu_playpen120111`.`Attachment`.`foreign_id` = `cuponclu_playpen120111`.`Deal`.`id`) and (`cuponclu_playpen120111`.`Attachment`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`fbpictures` `Fbpicture` on(((`cuponclu_playpen120111`.`Fbpicture`.`foreign_id` = `cuponclu_playpen120111`.`Deal`.`id`) and (`cuponclu_playpen120111`.`Fbpicture`.`class` = 'Deal'))) left join `cuponclu_playpen120111`.`topics` `Topic` on((`cuponclu_playpen120111`.`Topic`.`deal_id` = `cuponclu_playpen120111`.`Deal`.`id`)) left join `cuponclu_playpen120111`.`deal_categories` `DealCategory` on((`cuponclu_playpen120111`.`DealCategory`.`id` = `cuponclu_playpen120111`.`Deal`.`id`)) left join `cuponclu_playpen120111`.`deal_sub_categories` `DealSubCategory` on((`cuponclu_playpen120111`.`DealSubCategory`.`id` = `cuponclu_playpen120111`.`Deal`.`id`)) left join `cuponclu_playpen120111`.`neighborhoods` `Neighborhood` on((`cuponclu_playpen120111`.`Neighborhood`.`id` = `cuponclu_playpen120111`.`Deal`.`id`)) where (((`cuponclu_playpen120111`.`Deal`.`user_id` = 79233) or (`cuponclu_playpen120111`.`Deal`.`company_id` = 908)) and (`cuponclu_playpen120111`.`Deal`.`deal_status_id` in (2,4,5,6,8)))

16

SELECT COUNT(*) AS `count` FROM `deal_users` AS `DealUser` LEFT JOIN `users` AS `User` ON (`DealUser`.`user_id` = `User`.`id`) LEFT JOIN `deals` AS `Deal` ON (`DealUser`.`deal_id` = `Deal`.`id`) LEFT JOIN `paypal_docapture_logs` AS `PaypalDocaptureLog` ON (`PaypalDocaptureLog`.`deal_user_id` = `DealUser`.`id`) LEFT JOIN `paypal_transaction_logs` AS `PaypalTransactionLog` ON (`PaypalTransactionLog`.`deal_user_id` = `DealUser`.`id`) LEFT JOIN `paypal_mobile_logs` AS `PaypalMobileLog` ON (`PaypalMobileLog`.`deal_user_id` = `DealUser`.`id`) LEFT JOIN `credomatic_logs` AS `CredomaticLog` ON (`CredomaticLog`.`deal_user_id` = `DealUser`.`id`) LEFT JOIN `authorizenet_docapture_logs` AS `AuthorizenetDocaptureLog` ON (`AuthorizenetDocaptureLog`.`deal_user_id` = `DealUser`.`id`) LEFT JOIN `banned_duis` AS `BannedDui` ON (`BannedDui`.`id` = `DealUser`.`id`) LEFT JOIN `invoices` AS `Invoice` ON (`Invoice`.`deal_user_id` = `DealUser`.`id`) WHERE `DealUser`.`user_id` = 79233 AND `DealUser`.`is_gift` = 0

1

15

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	DealUser	ref	user_id	user_id	8	const	1	10.00	Using where
1	SIMPLE	User	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
1	SIMPLE	Deal	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.DealUser.deal_id	1	100.00	Using index
1	SIMPLE	PaypalDocaptureLog	ref	deal_user_id	deal_user_id	9	cuponclu_playpen120111.DealUser.id	1	100.00	Using where; Using index
1	SIMPLE	PaypalTransactionLog	ALL					9472	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	PaypalMobileLog	ALL					57	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	CredomaticLog	ALL					499	100.00	Using where; Using join buffer (hash join)
1	SIMPLE	AuthorizenetDocaptureLog	ref	deal_user_id	deal_user_id	9	cuponclu_playpen120111.DealUser.id	6	100.00	Using where; Using index
1	SIMPLE	BannedDui	eq_ref	PRIMARY	PRIMARY	4	cuponclu_playpen120111.DealUser.id	1	100.00	Using where; Using index
1	SIMPLE	Invoice	ALL					61	100.00	Using where; Using join buffer (hash join)

Level	Code	Message
Note	1003	/* select#1 */ select count(0) AS `count` from `cuponclu_playpen120111`.`deal_users` `DealUser` left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`User`.`id` = 79233)) left join `cuponclu_playpen120111`.`deals` `Deal` on((`cuponclu_playpen120111`.`Deal`.`id` = `cuponclu_playpen120111`.`DealUser`.`deal_id`)) left join `cuponclu_playpen120111`.`paypal_docapture_logs` `PaypalDocaptureLog` on((`cuponclu_playpen120111`.`PaypalDocaptureLog`.`deal_user_id` = `cuponclu_playpen120111`.`DealUser`.`id`)) left join `cuponclu_playpen120111`.`paypal_transaction_logs` `PaypalTransactionLog` on((`cuponclu_playpen120111`.`PaypalTransactionLog`.`deal_user_id` = `cuponclu_playpen120111`.`DealUser`.`id`)) left join `cuponclu_playpen120111`.`paypal_mobile_logs` `PaypalMobileLog` on((`cuponclu_playpen120111`.`PaypalMobileLog`.`deal_user_id` = `cuponclu_playpen120111`.`DealUser`.`id`)) left join `cuponclu_playpen120111`.`credomatic_logs` `CredomaticLog` on((`cuponclu_playpen120111`.`CredomaticLog`.`deal_user_id` = `cuponclu_playpen120111`.`DealUser`.`id`)) left join `cuponclu_playpen120111`.`authorizenet_docapture_logs` `AuthorizenetDocaptureLog` on((`cuponclu_playpen120111`.`AuthorizenetDocaptureLog`.`deal_user_id` = `cuponclu_playpen120111`.`DealUser`.`id`)) left join `cuponclu_playpen120111`.`banned_duis` `BannedDui` on((`cuponclu_playpen120111`.`BannedDui`.`id` = `cuponclu_playpen120111`.`DealUser`.`id`)) left join `cuponclu_playpen120111`.`invoices` `Invoice` on((`cuponclu_playpen120111`.`Invoice`.`deal_user_id` = `cuponclu_playpen120111`.`DealUser`.`id`)) where ((`cuponclu_playpen120111`.`DealUser`.`is_gift` = 0) and (`cuponclu_playpen120111`.`DealUser`.`user_id` = 79233))

17

SELECT COUNT(*) AS `count` FROM `gift_users` AS `GiftUser` LEFT JOIN `users` AS `User` ON (`GiftUser`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `GiftedToUser` ON (`GiftUser`.`gifted_to_user_id` = `GiftedToUser`.`id`) WHERE `GiftUser`.`user_id` = 79233

1

0

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	GiftUser	ref	user_id	user_id	8	const	1	100.00
1	SIMPLE	User	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
1	SIMPLE	GiftedToUser	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.GiftUser.gifted_to_user_id	1	100.00	Using where; Using index

Level	Code	Message
Note	1003	/* select#1 */ select count(0) AS `count` from `cuponclu_playpen120111`.`gift_users` `GiftUser` left join `cuponclu_playpen120111`.`users` `User` on((79233 = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`users` `GiftedToUser` on((`cuponclu_playpen120111`.`GiftUser`.`gifted_to_user_id` = `cuponclu_playpen120111`.`GiftedToUser`.`id`)) where (`cuponclu_playpen120111`.`GiftUser`.`user_id` = 79233)

18

SELECT COUNT(*) AS `count` FROM `gift_users` AS `GiftUser` LEFT JOIN `users` AS `User` ON (`GiftUser`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `GiftedToUser` ON (`GiftUser`.`gifted_to_user_id` = `GiftedToUser`.`id`) WHERE `GiftUser`.`friend_mail` = '79233'

1

0

EXPLAIN

Id	Select Type	Table	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE	GiftUser	ALL					36	10.00	Using where
1	SIMPLE	User	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.GiftUser.user_id	1	100.00	Using where; Using index
1	SIMPLE	GiftedToUser	eq_ref	PRIMARY	PRIMARY	8	cuponclu_playpen120111.GiftUser.gifted_to_user_id	1	100.00	Using where; Using index

Level	Code	Message
Note	1003	/* select#1 */ select count(0) AS `count` from `cuponclu_playpen120111`.`gift_users` `GiftUser` left join `cuponclu_playpen120111`.`users` `User` on((`cuponclu_playpen120111`.`GiftUser`.`user_id` = `cuponclu_playpen120111`.`User`.`id`)) left join `cuponclu_playpen120111`.`users` `GiftedToUser` on((`cuponclu_playpen120111`.`GiftUser`.`gifted_to_user_id` = `cuponclu_playpen120111`.`GiftedToUser`.`id`)) where (`cuponclu_playpen120111`.`GiftUser`.`friend_mail` = '79233')

19

SELECT COUNT(*) AS `count` FROM `user_friends` AS `UserFriend` LEFT JOIN `users` AS `User` ON (`UserFriend`.`user_id` = `User`.`id`) LEFT JOIN `users` AS `FriendUser` ON (`UserFriend`.`friend_user_id` = `FriendUser`.`id`) LEFT JOIN `friend_statuses` AS `FriendStatus` ON (`UserFriend`.`friend_status_id` = `FriendStatus`.`id`) WHERE `UserFriend`.`user_id` = 79233 AND `UserFriend`.`friend_status_id` = 2 AND `UserFriend`.`is_requested` = 0

1

0

EXPLAIN

Id	Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
1	SIMPLE										no matching row in const table

Level	Code	Message
Note	1003	/* select#1 */ select count(0) AS `count` from `cuponclu_playpen120111`.`user_friends` `UserFriend` left join `cuponclu_playpen120111`.`users` `User` on((79233 = '79233')) left join `cuponclu_playpen120111`.`users` `FriendUser` on((NULL = NULL)) left join `cuponclu_playpen120111`.`friend_statuses` `FriendStatus` on((2 = '2')) where (multiple equal(79233, NULL) and multiple equal(2, NULL) and multiple equal(0, NULL))

Timer

Timers

Total Request Time: 0.411546m (seconds)

Message	time in seconds
Component initialization and startup	0.00177
Controller Action	0.0334
Render Controller Action	0.0053
Rendering View	0.00521
Rendering APP/views/companies/view.ctp	0.00312
Rendering APP/views/layouts/default.ctp	0.00195
Rendering APP/views/elements/site_tracker.ctp	1.0E-5
Rendering APP/views/elements/cities-index-static.ctp	0.00014

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 12:39:38	Warning: Warning (2): Undefined variable $displayemailsubscribepopup in [APP/views/layouts/default.ctp, line 1069]

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 3.87 MB

Peak Memory Use 7.29 MB
Variables
View Variables
- is_klaviyo_enabled
- city_id42553
- city_nameSan Salvador
- city_slugSan-salvador
- 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)
- statistics
  - referred_users
  - deal_created1
  - deal_purchased
  - gift_sent
  - gift_received
  - user_friends
- company
  - Company
    - id908
    - created2014-07-04 15:00:24
    - modified2020-05-25 16:00:24
    - nameComkarinho
    - slugcomkarinho
    - address1Calle y Pasaje El Mirador #5824
    - address2(empty)
    - user_id79233
    - city_id43051
    - state_id102
    - country_id69
    - phone2124-3990
    - zip0016-8000
    - url(empty)
    - deal_count11
    - is_online_account1
    - is_company_profile_enabled1
    - company_profile(empty)
    - latitude13.707201
    - longitude-89.255341
    - map_zoom_level17
    - survey_average0.00
    - survey_responses1
    - half_stars10
    - percent_to_return100
  - User
    - emailventas@example.com
    - user_type_id3
    - usernamecomkarinho
    - id79233
    - available_balance_amount0.00
    - is_email_confirmed1
    - is_active1
    - UserAvatar(empty)
  - City
    - id(null)
    - name(null)
    - slug(null)
  - State
    - id102
    - nameSan Salvador
  - Country
    - id69
    - nameEl Salvador
    - slugel-salvador
  - Deal
    - 0
      id6782
      namePRUEBA-NO COMPRAR¡Paga en Lugar de por una Caja de 25 Unidades de Deliciosos Dulces Brasileños: Brigadeiros!
      slug¡paga--en-lugar-de--por
      description
      ¿Por qué lo necesitas?
      
      ¡Existen adicciones que se convierten en placeres culposos! Si eres amante de los dulces y quieres degustar de un nuevo sabor, tenemos la oferta perfecta para ti. Enamórate sin culpa del postre más famoso de todo Brasil y disfruta con cada Brigadeiro del sabor del cielo en tu paladar. ¿Te parece una locura? ¡Atrévete a probarlos... son exquisitamente adictivos!
      
      ¿Qué es?
      
      ¿Son bombones? ¿Son trufas? ¿Son muffins? ¡Son Brigadeiros! Las exquisitas bolitas a base de leche condensada más famosas y queridas de Brasil, su país de origen. La preparación de este apetitoso postre lo vuelve único y especial, ya que su receta incluye ingredientes que lo vuelven aún más deleitable como: almendras, chocolate, chocolate blanco, oreo, café, ron con pasas, coco, maní y muchos ingredientes más.
      
      ¿Por qué recomendamos a Comkarinho?
      
      Comkarinho cuenta con más de 10 años endulzando el paladar salvadoreño con deliciosos Brigadeiros, su receta única y secreta le da el toque especial a cada uno de estos postres de origen brasileño. La variedad, el sabor, la creatividad y la calidad de sus productos distinguen a Comkarinho de los demás.
      
      ¿Cómo llegar?
      
      Encuentra la tienda de Comkarinho en su nueva ubicación, calle y pasaje El Mirador #5824, Colonia Escalón. Subiendo del Redondel Masferrer y pasando el Club Campestre, cruzarás a la derecha en la siguiente calle. Luego, seguirás el camino y al final de esa calle encontrarás el nuevo local de Comkarinho, justo donde se junta con la Calle El Mirador.
      company_id908
  - CompanyAddress(empty)
- 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

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

San Salvador

Comkarinho

Empresa

Más información sobre

Síguenos

Otros sitios que recomendamos

Cupón Club

San Salvador

Comkarinho

Empresa

Más información sobre

Síguenos

Otros sitios que recomendamos

Cupón Club

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Timers

Logs

error.log

debug.log

Memory

View Variables