DealQUE - Social Bargain Hunting and daily deal aggregator. Great bargains at DealQUE.com | Browsing Audio and Video / Speakers Deals

(default) 18 queries took 1721 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
2	SELECT * from sponsored_deals where type like "all" AND end_date >= "2010-09-09 19:09:37" LIMIT 2	0	0	0
3	SELECT `Category`.`category` FROM `categories` AS `Category` WHERE parent='Audio and Video' AND category='Speakers'	1	1	0
4	SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y'	1	1	22
5	SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y'	1	1	183
6	SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y'	1	1	0
7	SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y'	1	1	0
8	( 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 category='Audio and Video' AND sub_category='Speakers' 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 category='Audio and Video' AND sub_category='Speakers' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 0,10	0	0	778
9	( 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='Audio and Video' AND sub_category='Speakers' 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='Audio and Video' AND sub_category='Speakers' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC, start_date DESC LIMIT 5	0	0	734
10	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	1
11	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077737;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077739 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		1
12	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
13	SELECT `Category`.`parent` FROM `categories` AS `Category` Group by parent	18	18	0
14	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
15	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077739;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077739 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		1
16	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
17	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	1
18	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077739;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284077739 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0

(default) 18 queries took 1721 ms

Query

Error

Affected

Num. rows

Took (ms)

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 19:09:37" LIMIT 2

SELECT `Category`.`category` FROM `categories` AS `Category` WHERE parent='Audio and Video' AND category='Speakers'

SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y'

SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y'

183

SELECT COUNT(*) AS `count` FROM `user_deals` AS `User_deals` WHERE category='Audio and Video' AND sub_category='Speakers' AND available='Y'

SELECT COUNT(*) AS `count` FROM `deals` AS `Deal` WHERE category='Audio and Video' AND sub_category='Speakers' 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 category='Audio and Video' AND sub_category='Speakers' 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 category='Audio and Video' AND sub_category='Speakers' AND available='Y' AND merchants.id=deals.merchant_id AND merchants.is_live='true' ) ORDER BY ratingOrdered DESC,start_date DESC LIMIT 0,10

778

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

734

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:1284077737;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284077739 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'

UPDATE `cake_sessions` SET `data` = 'Config|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284077739;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1284077739 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'