Jewelry Deal of the Day

Website:

Stats

Member since:

08.03.09

Submitted Deals:

450

Total Ques:

456

Advertisment

Monday, September 6, 2010 by Jewelry DOD

Compare

Daily Deals / Jewelry and Watches

Tiffany Inspired 15.00 carat Princes...

Featuring an elegant Tiffany Inspired Princess brilliant cut simulated Diamond tennis bracelet. This stunning bracelet is hand set with 43 high grade Princess brilliant cut simulat...

$ 34.99

Leave a Review

change monster

Name

Subject

R U Human?

change image

Prove It!

Comment

Terms & Conditions

(default) 34 queries took 27 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `merchants`	13	13	1
2	DESCRIBE `ratings`	5	5	2
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` = '0reel1ajh5ol7tefd3sikijta2'	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` = 'Jewelry DOD' 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 = "145" AND available="Y"	1	1	4
15	DESCRIBE `comments`	10	10	1
16	DESCRIBE `user_comments`	8	8	1
17	DESCRIBE `users`	11	11	1
18	DESCRIBE `report_deals`	7	7	1
19	DESCRIBE `report_comments`	8	8	1
20	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
21	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283876941;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283876941 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1		0
22	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283858941	1		2
23	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
24	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "145" AND comments.start_date = "2010-09-06 18:09:22") 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 = "145" AND user_comments.start_date = "2010-09-06 18:09:22" )	2	2	0
25	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "145" AND date = "2010-09-06 18:09:22" AND TIMEDIFF("2010-09-07 11:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
26	(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 = "145") 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 = "145") ORDER BY posted_on desc	0	0	0
27	SELECT img,code from verify_imgs	13	13	0
28	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
29	SELECT count(merchant_id) as num_submited, sum(que_count) as total_ques FROM deals WHERE merchant_id = "145" GROUP BY merchant_id	1	1	4
30	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
31	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283876941;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283876941 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	0		0
32	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
33	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
34	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283876941;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283876941 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	0		0

(default) 34 queries took 27 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` = '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` = 'Jewelry DOD' 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 = "145" AND available="Y"

DESCRIBE `comments`

DESCRIBE `user_comments`

DESCRIBE `users`

DESCRIBE `report_deals`

DESCRIBE `report_comments`

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:1283876941;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283876941 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'

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

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 = "145" AND comments.start_date = "2010-09-06 18:09:22") 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 = "145" AND user_comments.start_date = "2010-09-06 18:09:22" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "145" AND date = "2010-09-06 18:09:22" AND TIMEDIFF("2010-09-07 11:09:01", 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 = "145") 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 = "145") 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 = "145" 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'