DealQUE | REI-OUTLET.com's Deal of the Day for March 12, 2010: Life is good Baseball T-Shirt - Men's

(default) 45 queries took 2493 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
2	SELECT name,id,temp_cat,website FROM merchants WHERE id ="64"	1	1	0
3	SELECT category,sub_category FROM user_deals where uid = 64 AND start_date='2010-03-12 02^03^09'	0	0	1
4	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	1
5	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078034;s:7:\"timeout\";i:10;}', `expires` = 1284078034 WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1		0
6	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
7	( 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='Apparel' 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='Apparel' 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	2455
8	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	1
9	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078034;s:7:\"timeout\";i:10;}', `expires` = 1284078036 WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1		0
10	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284060036	0		2
11	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	2
12	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "2" AND comments.start_date = "2010-09-09 19:09:03") 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 = "2" AND user_comments.start_date = "2010-09-09 19:09:03" )	2	2	0
13	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "2" AND date = "2010-09-09 19:09:03" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
14	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
15	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078036;s:7:\"timeout\";i:10;}', `expires` = 1284078036 WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1		0
16	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	1
17	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "59" AND comments.start_date = "2010-09-09 17:09:43") 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 = "59" AND user_comments.start_date = "2010-09-09 17:09:43" )	2	2	0
18	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "59" AND date = "2010-09-09 17:09:43" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
19	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
20	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078036;s:7:\"timeout\";i:10;}', `expires` = 1284078036 WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	0		0
21	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
22	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "56" AND comments.start_date = "2010-09-09 17:09:42") 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 = "56" AND user_comments.start_date = "2010-09-09 17:09:42" )	2	2	0
23	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "56" AND date = "2010-09-09 17:09:42" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
25	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078036;s:7:\"timeout\";i:10;}', `expires` = 1284078036 WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	0		0
26	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
27	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "45" AND comments.start_date = "2010-09-09 17:09:38") 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 = "45" AND user_comments.start_date = "2010-09-09 17:09:38" )	2	2	0
28	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "45" AND date = "2010-09-09 17:09:38" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
29	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
30	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078036;s:7:\"timeout\";i:10;}', `expires` = 1284078036 WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	0		0
31	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
32	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "41" AND comments.start_date = "2010-09-09 17:09:35") 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 = "41" AND user_comments.start_date = "2010-09-09 17:09:35" )	2	2	0
33	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "41" AND date = "2010-09-09 17:09:35" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
34	SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "64" and deals.start_date="2010-03-12 02:03:09"	1	1	1
35	SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '64' and start_date = '2010-03-12 02:03:09'	1	1	0
36	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "64" AND date = "2010-03-12 02^03^09" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	26
37	(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 = "64" AND comments.start_date = "2010-03-12 02^03^09") 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 = "64" AND user_comments.start_date = "2010-03-12 02^03^09" ) ORDER BY posted_on desc	0	0	2
38	SELECT img,code from verify_imgs	13	13	0
39	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
40	SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="64"	1	1	0
41	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
42	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078036;s:7:\"timeout\";i:10;}', `expires` = 1284078036 WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	0		0
43	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
44	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1	1	0
45	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284078036;s:7:\"timeout\";i:10;}', `expires` = 1284078037 WHERE `id` = 'ktsk410gj8ugmf71qci969khm5'	1		1

(default) 45 queries took 2493 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'

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

SELECT category,sub_category FROM user_deals where uid = 64 AND start_date='2010-03-12 02^03^09'

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

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'

( 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='Apparel' 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='Apparel' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5

2455

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

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'

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

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

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

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "59" AND comments.start_date = "2010-09-09 17:09:43") 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 = "59" AND user_comments.start_date = "2010-09-09 17:09:43" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "59" AND date = "2010-09-09 17:09:43" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "56" AND comments.start_date = "2010-09-09 17:09:42") 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 = "56" AND user_comments.start_date = "2010-09-09 17:09:42" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "56" AND date = "2010-09-09 17:09:42" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "45" AND comments.start_date = "2010-09-09 17:09:38") 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 = "45" AND user_comments.start_date = "2010-09-09 17:09:38" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "45" AND date = "2010-09-09 17:09:38" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'

(SELECT count(*) as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "41" AND comments.start_date = "2010-09-09 17:09:35") 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 = "41" AND user_comments.start_date = "2010-09-09 17:09:35" )

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "41" AND date = "2010-09-09 17:09:35" AND TIMEDIFF("2010-09-09 19:09:36", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "64" and deals.start_date="2010-03-12 02:03:09"

SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '64' and start_date = '2010-03-12 02:03:09'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "64" AND date = "2010-03-12 02^03^09" AND TIMEDIFF("2010-09-09 19:09:36", 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 = "64" AND comments.start_date = "2010-03-12 02^03^09") 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 = "64" AND user_comments.start_date = "2010-03-12 02^03^09" ) 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 ="64"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'ktsk410gj8ugmf71qci969khm5'

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