DealQUE - Social Bargain Hunting and daily deal aggregator. Great bargains at DealQUE.com

(default) 57 queries took 156 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` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
13	SELECT * from sponsored_deals where type like "all" AND end_date >= "2010-09-09 20:09:56" LIMIT 2	0	0	0
14	SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE 1=1 AND available='Y'	1	1	0
15	SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE 1=1 AND available='Y'	1	1	0
16	SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE 1=1 AND available='Y'	1	1	0
17	( 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, user_deals.img_size, monsters.img as logo, username as name, 0 as shipping, additional_info as additional_info, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND 1=1 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, img_size, logo, name, shipping, '' as additional_info, pub_date, available, price FROM deals, merchants WHERE 1=1 AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' AND merchants.id>1000 ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 10,10	0	0	70
18	( 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 1=1 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 1=1 AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' AND id>1000 ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5	5	5	70
19	DESCRIBE `comments`	10	10	1
20	DESCRIBE `user_comments`	8	8	1
21	DESCRIBE `users`	11	11	1
22	DESCRIBE `report_deals`	7	7	1
23	DESCRIBE `report_comments`	8	8	1
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
25	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284082016;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284082017 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
26	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
27	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "1597" AND comments.start_date = "2010-07-13 05:07:02") 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 = "1597" AND user_comments.start_date = "2010-07-13 05:07:02" )	2	2	0
28	SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1597" AND date = "2010-07-13 05:07:02" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
29	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
30	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284082017;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284082017 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
31	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
32	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "1544" AND comments.start_date = "2010-07-12 02:07:09") 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 = "1544" AND user_comments.start_date = "2010-07-12 02:07:09" )	2	2	0
33	SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1544" AND date = "2010-07-12 02:07:09" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
34	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
35	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284082017;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284082017 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
36	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
37	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "1595" AND comments.start_date = "2010-07-12 00:07:41") 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 = "1595" AND user_comments.start_date = "2010-07-12 00:07:41" )	2	2	0
38	SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1595" AND date = "2010-07-12 00:07:41" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
39	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
40	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284082017;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284082017 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
41	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
42	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "1571" AND comments.start_date = "2010-07-11 22:07: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 = "1571" AND user_comments.start_date = "2010-07-11 22:07:12" )	2	2	0
43	SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1571" AND date = "2010-07-11 22:07:12" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
44	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
45	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284082017;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284082017 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
46	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
47	(SELECT count() as total_comments FROM comments,monsters WHERE comments.monster_id = monsters.id AND comments.merchant_id = "1571" AND comments.start_date = "2010-07-11 20:07:29") 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 = "1571" AND user_comments.start_date = "2010-07-11 20:07:29" )	2	2	0
48	SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1571" AND date = "2010-07-11 20:07:29" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	0
49	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
50	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284082017;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284082017 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
51	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
52	SELECT `Category`.`parent` FROM `categories` AS `Category` Group by parent	18	18	0
53	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
54	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284082017;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284082017 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0
55	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
56	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
57	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284082017;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284082017 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0

(default) 57 queries took 156 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` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'

SELECT * from sponsored_deals where type like "all" AND end_date >= "2010-09-09 20:09:56" LIMIT 2

SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE 1=1 AND available='Y'

SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE 1=1 AND available='Y'

SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE 1=1 AND available='Y'

( 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, user_deals.img_size, monsters.img as logo, username as name, 0 as shipping, additional_info as additional_info, NULL as pub_date, available, price FROM user_deals, users, monsters WHERE users.monster_id = monsters.id AND 1=1 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, img_size, logo, name, shipping, '' as additional_info, pub_date, available, price FROM deals, merchants WHERE 1=1 AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' AND merchants.id>1000 ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 10,10

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

DESCRIBE `comments`

DESCRIBE `user_comments`

DESCRIBE `users`

DESCRIBE `report_deals`

DESCRIBE `report_comments`

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

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

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

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

SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1597" AND date = "2010-07-13 05:07:02" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

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

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

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

SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1544" AND date = "2010-07-12 02:07:09" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

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

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

SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1595" AND date = "2010-07-12 00:07:41" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

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

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

SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1571" AND date = "2010-07-11 22:07:12" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

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

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

SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1571" AND date = "2010-07-11 20:07:29" AND TIMEDIFF("2010-09-09 20:09:57", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

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

SELECT `Category`.`parent` FROM `categories` AS `Category` Group by parent

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

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

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