Daily Deals

Website:

Stats

Member since:

01.30.08

Submitted Deals:

272

Total Ques:

272

Advertisment

Monday, July 19, 2010 by SuperMediaStore

Compare

Daily Deals / Computers and Electronics

Rockwell RK5101K SoniCrafter 37 Piec...

The Rockwell RK5101K SoniCrafter 37Piece Variable Speed Complete Professional Kit comes with the SoniCrafter one of the most versatile power tools ever invented plus different ac...

$ 119.99

Leave a Review

change monster

Name

Subject

R U Human?

change image

Prove It!

Comment

Terms & Conditions

(default) 20 queries took 11 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `sponsored_deals`	4	4	1
2	DESCRIBE `reviews`	9	9	1
3	DESCRIBE `user_reviews`	7	7	1
4	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
5	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` = 'SuperMediaStore' LIMIT 1	1	1	0
6	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 = "72" AND available="Y"	1	1	2
7	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
8	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283877085;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283877085 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1		0
9	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
10	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "72" AND comments.start_date = "2010-07-19 19:07:01") 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 = "72" AND user_comments.start_date = "2010-07-19 19:07:01" )	2	2	0
11	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "72" AND date = "2010-07-19 19:07:01" AND TIMEDIFF("2010-09-07 11:09:25", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
12	(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 = "72") 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 = "72") ORDER BY posted_on desc	0	0	1
13	SELECT img,code from verify_imgs	13	13	0
14	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
15	SELECT count(merchant_id) as num_submited, sum(que_count) as total_ques FROM deals WHERE merchant_id = "72" GROUP BY merchant_id	1	1	3
16	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	1
17	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283877085;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283877085 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	0		0
18	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
19	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
20	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283877085;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283877085 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	0		0

(default) 20 queries took 11 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `sponsored_deals`

DESCRIBE `reviews`

DESCRIBE `user_reviews`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'

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` = 'SuperMediaStore' 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 = "72" AND available="Y"

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "72" AND comments.start_date = "2010-07-19 19:07:01") 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 = "72" AND user_comments.start_date = "2010-07-19 19:07:01" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "72" AND date = "2010-07-19 19:07:01" AND TIMEDIFF("2010-09-07 11:09:25", 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 = "72") 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 = "72") 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 = "72" GROUP BY merchant_id

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'