One monster of a deal per day!

Website:

Stats

Member since:

12.10.07

Submitted Deals:

6174

Total Ques:

6150

Advertisment

Monday, July 19, 2010 by cigarmonster

Compare

Daily Deals / Miscellaneous

Famous Nicaraguan 4000 Churchill onl...

<a href="http://www.cigarmonster.com/index.cfm?kws=ZWW2781/inum=30301"><img src="http://www&...

$ 39.98

Leave a Review

change monster

Name

Subject

R U Human?

change image

Prove It!

Comment

Terms & Conditions

(default) 29 queries took 102 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `merchants`	13	13	1
2	DESCRIBE `ratings`	5	5	1
3	DESCRIBE `deals`	17	17	1
4	DESCRIBE `sponsored_deals`	4	4	1
5	DESCRIBE `user_deals`	15	15	1
6	DESCRIBE `user_deal_ratings`	5	5	1
7	DESCRIBE `categories`	3	3	1
8	DESCRIBE `reviews`	9	9	1
9	DESCRIBE `user_reviews`	7	7	1
10	DESCRIBE `monsters`	6	6	1
11	DESCRIBE `verify_imgs`	3	3	1
12	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
13	SELECT `Merchant`.`id`, `Merchant`.`name`, `Merchant`.`categoryOLD`, `Merchant`.`url`, `Merchant`.`date_created`, `Merchant`.`logo`, `Merchant`.`website`, `Merchant`.`slogan`, `Merchant`.`is_live`, `Merchant`.`email`, `Merchant`.`temp_cat`, `Merchant`.`affiliate_type`, `Merchant`.`affiliate_options` FROM `merchants` AS `Merchant` WHERE `Merchant`.`name` = 'cigarmonster' LIMIT 1	1	1	0
14	SELECT deals.start_date, deals.title, deals.category, deals.sub_category, deals.description, deals.link, deals.que_count, deals.shipping, deals.pub_date, deals.available, deals.price, deals.img, deals.img_size FROM deals WHERE merchant_id = "12" AND available="Y"	1	1	40
15	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
16	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520549;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520549 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1		0
17	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
18	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "12" AND comments.start_date = "2010-07-19 19:07:23") UNION ALL ( SELECT count() as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "12" AND user_comments.start_date = "2010-07-19 19:07:23" )	2	2	0
19	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "12" AND date = "2010-07-19 19:07:23" AND TIMEDIFF("2010-09-03 08:09:09", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
20	(SELECT reviews.name as name, reviews.subject as subject, reviews.body as body, reviews.posted_on as posted_on, "anon" as user_type, reviews.id as ident_id, monsters.img as img FROM reviews,monsters WHERE reviews.is_live = "true" AND reviews.monster_id = monsters.id AND reviews.merchant_id = "12") UNION ALL ( SELECT users.username as name, user_reviews.subject as subject, user_reviews.body as body, user_reviews.posted_on as posted_on, user_reviews.user_id as user_type, user_reviews.posted_on as ident_id, monsters.img as img FROM users,user_reviews,monsters WHERE user_reviews.is_live = "true" AND user_reviews.user_id = users.id AND users.monster_id = monsters.id AND user_reviews.merchant_id = "12") ORDER BY posted_on desc	0	0	1
21	SELECT img,code from verify_imgs	13	13	0
22	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
23	SELECT count(merchant_id) as num_submited, sum(que_count) as total_ques FROM deals WHERE merchant_id = "12" GROUP BY merchant_id	1	1	46
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	1
25	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520549;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520549 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
26	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283502549	1		2
27	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
28	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
29	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520549;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520549 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0

(default) 29 queries took 102 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `merchants`

DESCRIBE `ratings`

DESCRIBE `deals`

DESCRIBE `sponsored_deals`

DESCRIBE `user_deals`

DESCRIBE `user_deal_ratings`

DESCRIBE `categories`

DESCRIBE `reviews`

DESCRIBE `user_reviews`

DESCRIBE `monsters`

DESCRIBE `verify_imgs`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

SELECT `Merchant`.`id`, `Merchant`.`name`, `Merchant`.`categoryOLD`, `Merchant`.`url`, `Merchant`.`date_created`, `Merchant`.`logo`, `Merchant`.`website`, `Merchant`.`slogan`, `Merchant`.`is_live`, `Merchant`.`email`, `Merchant`.`temp_cat`, `Merchant`.`affiliate_type`, `Merchant`.`affiliate_options` FROM `merchants` AS `Merchant` WHERE `Merchant`.`name` = 'cigarmonster' LIMIT 1

SELECT deals.start_date, deals.title, deals.category, deals.sub_category, deals.description, deals.link, deals.que_count, deals.shipping, deals.pub_date, deals.available, deals.price, deals.img, deals.img_size FROM deals WHERE merchant_id = "12" AND available="Y"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520549;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283520549 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "12" AND comments.start_date = "2010-07-19 19:07:23") UNION ALL ( SELECT count(*) as total_comments FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "12" AND user_comments.start_date = "2010-07-19 19:07:23" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "12" AND date = "2010-07-19 19:07:23" AND TIMEDIFF("2010-09-03 08:09:09", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

(SELECT reviews.name as name, reviews.subject as subject, reviews.body as body, reviews.posted_on as posted_on, "anon" as user_type, reviews.id as ident_id, monsters.img as img FROM reviews,monsters WHERE reviews.is_live = "true" AND reviews.monster_id = monsters.id AND reviews.merchant_id = "12") UNION ALL ( SELECT users.username as name, user_reviews.subject as subject, user_reviews.body as body, user_reviews.posted_on as posted_on, user_reviews.user_id as user_type, user_reviews.posted_on as ident_id, monsters.img as img FROM users,user_reviews,monsters WHERE user_reviews.is_live = "true" AND user_reviews.user_id = users.id AND users.monster_id = monsters.id AND user_reviews.merchant_id = "12") ORDER BY posted_on desc

SELECT img,code from verify_imgs

SELECT * from monsters where is_live ="true" and rights = "public"

SELECT count(merchant_id) as num_submited, sum(que_count) as total_ques FROM deals WHERE merchant_id = "12" GROUP BY merchant_id

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283502549

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'