DealQUE | Woot.com 1 Toshiba 26LV61K 26” LCD HDTV with DivX Certified Built-In DVD Player

We’ve got a lot to talk about at this meeting, but first, here’s something kind of fun: anybody here left-handed? Let’s see.. two, three.. five… OK, cool! You guys are all fired! Not because you’re left-handed. We just need to trim the payroll and that’s an easy way for me to make the cut. Otherwise, I’d have to look at your sales records and figure out whose is best and whose is worst and frankly, I’ve got better things to do with my time. If you guys wouldn’t mind leaving now, that’d be cool. This meeting’s for employees only. Company business. Thanks! So management has been talking about some incentives here in the workplace to keep up morale in the, uh, workplace, and that discussion led us to the following question: who here would like a Toshiba 26” LCD HDTV with a built-in DVD player? Sound good to anybody? We’re talking a 26”, 16:9 LCD screen with 720p resolution and a digital tuner – not to mention that slot-loading, DivX-certified DVD player integrated right into the side of the TV. Sounds pretty sweet, huh? Yeah? Who wants to know how it can be yours? Well, here’s how: start doing your job a little better and you can buy one out of your paycheck. If you thought we were going to bribe you with a free TV to do what you’re supposed to be doing, it’s time to grow up, OK? You want incentives? Here’s your incentive: sell more or you’ll be out there Dumpster-diving with those left-handed losers. Everybody clear on that? Finally, one last thing here…speaking of morale, today we’re inaugurating our first-ever Taco Monday! Everybody here likes tacos, right? Well, any employee who brought his or her own taco fixings is allowed to use the break room kitchen to make tacos between 12:15 and 12:30, assuming your lunch break is scheduled for that time. The company will provide the napkins at no charge, but there is a one-napkin-per-employee limit. Anyone found making tacos after 12:30 will be severely disciplined. All right, let’s get out there and have a great Monday – make that a great TACO Monday! Taco! Taco! Taco!

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

(default) 44 queries took 619 ms

Query

Error

Affected

Num. rows

Took (ms)

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

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

SELECT category,sub_category FROM user_deals where uid = 34 AND start_date='2009-12-06 22^12^23'

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

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

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

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

615

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "146" AND date = "2010-09-03 05:09:24" AND TIMEDIFF("2010-09-03 08:09:40", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

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

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

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

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "131" AND date = "2010-09-03 05:09:17" AND TIMEDIFF("2010-09-03 08:09:40", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "34" and deals.start_date="2009-12-06 22:12:23"

SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '34' and start_date = '2009-12-06 22:12:23'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "34" AND date = "2009-12-06 22^12^23" AND TIMEDIFF("2010-09-03 08:09:40", 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 = "34" AND comments.start_date = "2009-12-06 22^12^23") 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 = "34" AND user_comments.start_date = "2009-12-06 22^12^23" ) 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 ="34"

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

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

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