DealQUE | Totally Cards Mystery Bag - 1 Auto or 1 Game Used Card and More

(default) 61 queries took 639 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `deals`	17	17	1
2	DESCRIBE `merchants`	13	13	1
3	DESCRIBE `verify_imgs`	3	3	0
4	DESCRIBE `monsters`	6	6	1
5	DESCRIBE `comments`	10	10	1
6	DESCRIBE `ratings`	5	5	1
7	DESCRIBE `user_comments`	8	8	1
8	DESCRIBE `user_deals`	15	15	1
9	DESCRIBE `users`	11	11	1
10	DESCRIBE `report_deals`	7	7	1
11	DESCRIBE `user_deal_ratings`	5	5	1
12	DESCRIBE `report_comments`	8	8	1
13	DESCRIBE `categories`	3	3	1
14	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
15	SELECT name,id,temp_cat,website FROM merchants WHERE id ="117"	1	1	0
16	SELECT category,sub_category FROM user_deals where uid = 117 AND start_date='2009-07-02 15^07^06'	0	0	0
17	DESCRIBE `sponsored_deals`	4	4	1
18	DESCRIBE `reviews`	9	9	1
19	DESCRIBE `user_reviews`	7	7	1
20	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
21	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520360;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520360 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1		0
22	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
23	( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5	5	5	612
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
25	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520360;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520361 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1		0
26	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1283502361	2		2
27	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
28	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "109" AND comments.start_date = "2010-09-03 07:09:10") 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 = "109" AND user_comments.start_date = "2010-09-03 07:09:10" )	2	2	0
29	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "109" AND date = "2010-09-03 07:09:10" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
30	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
31	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520361;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520361 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1		0
32	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
33	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "60" AND comments.start_date = "2010-09-03 07:09:04") 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 = "60" AND user_comments.start_date = "2010-09-03 07:09:04" )	2	2	0
34	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "60" AND date = "2010-09-03 07:09:04" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
35	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
36	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520361;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520361 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
37	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
38	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "112" AND comments.start_date = "2010-09-03 06:09:21") 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 = "112" AND user_comments.start_date = "2010-09-03 06:09:21" )	2	2	0
39	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "112" AND date = "2010-09-03 06:09:21" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
40	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
41	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520361;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520361 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
42	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
43	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "92" AND comments.start_date = "2010-09-03 06:09:15") 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 = "92" AND user_comments.start_date = "2010-09-03 06:09:15" )	2	2	0
44	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "92" AND date = "2010-09-03 06:09:15" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
45	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
46	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520361;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520361 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
47	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
48	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "83" AND comments.start_date = "2010-09-03 06:09:12") 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 = "83" AND user_comments.start_date = "2010-09-03 06:09:12" )	2	2	0
49	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "83" AND date = "2010-09-03 06:09:12" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
50	SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "117" and deals.start_date="2009-07-02 15:07:06"	1	1	0
51	SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '117' and start_date = '2009-07-02 15:07:06'	1	1	0
52	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "117" AND date = "2009-07-02 15^07^06" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
53	(SELECT comments.name as name, comments.subject as subject, comments.body as body, comments.posted_on as posted_on, "anon" as user_type, comments.id as ident_id, monsters.img as img FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "117" AND comments.start_date = "2009-07-02 15^07^06") UNION ALL ( SELECT users.username as name, user_comments.subject as subject, user_comments.body as body, user_comments.posted_on as posted_on, user_comments.user_id as user_type, user_comments.posted_on as ident_id, monsters.img as img FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "117" AND user_comments.start_date = "2009-07-02 15^07^06" ) ORDER BY posted_on desc	0	0	2
54	SELECT img,code from verify_imgs	13	13	0
55	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
56	SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="117"	1	1	0
57	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
58	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520361;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520361 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0
59	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
60	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	1	1	0
61	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520361;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520361 WHERE `id` = '5eqhj93afcn1bpjeqlvflsq1q2'	0		0

(default) 61 queries took 639 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `deals`

DESCRIBE `merchants`

DESCRIBE `verify_imgs`

DESCRIBE `monsters`

DESCRIBE `comments`

DESCRIBE `ratings`

DESCRIBE `user_comments`

DESCRIBE `user_deals`

DESCRIBE `users`

DESCRIBE `report_deals`

DESCRIBE `user_deal_ratings`

DESCRIBE `report_comments`

DESCRIBE `categories`

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

SELECT name,id,temp_cat,website FROM merchants WHERE id ="117"

SELECT category,sub_category FROM user_deals where uid = 117 AND start_date='2009-07-02 15^07^06'

DESCRIBE `sponsored_deals`

DESCRIBE `reviews`

DESCRIBE `user_reviews`

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

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

( SELECT start_date, title, user_deals.category as category, user_deals.sub_category as sub_category, description,uid as ID, link,rating as ratingOrdered, que_count as rating, user_deals.img,monsters.img as logo, username as name,0 as shipping, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND users.id=user_deals.uid ) UNION ALL ( SELECT start_date, title, deals.category as category, deals.sub_category as sub_category, description,merchant_id as ID, link, rating as ratingOrdered, que_count as rating, img, logo, name,shipping, pub_date, available, price FROM deals, merchants WHERE category='Daily Deals' AND sub_category='Miscellaneous' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5

612

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

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

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 = "109" AND comments.start_date = "2010-09-03 07:09:10") 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 = "109" AND user_comments.start_date = "2010-09-03 07:09:10" )

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

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:1283520361;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283520361 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 = "60" AND comments.start_date = "2010-09-03 07:09:04") 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 = "60" AND user_comments.start_date = "2010-09-03 07:09:04" )

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

SELECT COUNT(id) AS count FROM `cake_sessions` 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 = "112" AND comments.start_date = "2010-09-03 06:09:21") 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 = "112" AND user_comments.start_date = "2010-09-03 06:09:21" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "112" AND date = "2010-09-03 06:09:21" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` 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 = "92" AND comments.start_date = "2010-09-03 06:09:15") 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 = "92" AND user_comments.start_date = "2010-09-03 06:09:15" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "92" AND date = "2010-09-03 06:09:15" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT COUNT(id) AS count FROM `cake_sessions` 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 = "83" AND comments.start_date = "2010-09-03 06:09:12") 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 = "83" AND user_comments.start_date = "2010-09-03 06:09:12" )

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

SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "117" and deals.start_date="2009-07-02 15:07:06"

SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '117' and start_date = '2009-07-02 15:07:06'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "117" AND date = "2009-07-02 15^07^06" AND TIMEDIFF("2010-09-03 08:09:01", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

(SELECT comments.name as name, comments.subject as subject, comments.body as body, comments.posted_on as posted_on, "anon" as user_type, comments.id as ident_id, monsters.img as img FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "117" AND comments.start_date = "2009-07-02 15^07^06") UNION ALL ( SELECT users.username as name, user_comments.subject as subject, user_comments.body as body, user_comments.posted_on as posted_on, user_comments.user_id as user_type, user_comments.posted_on as ident_id, monsters.img as img FROM users,user_comments,monsters WHERE user_comments.user_id = users.id AND users.monster_id = monsters.id AND user_comments.merchant_id = "117" AND user_comments.start_date = "2009-07-02 15^07^06" ) ORDER BY posted_on desc

SELECT img,code from verify_imgs

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

SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="117"

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

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

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