DealQUE | QVC Motorola 3.5 - $99.00 + $7.22 S/H (Reg. $121.00)

Take the stress out of driving--whether it's across town or across the country--with the Motorola MOTONAV GPS navigation device. This advanced guidance system from one of the leaders in mobile communications provides a host of user-friendly features to help you get to your desired destination.

Directions made simple. Text-to-speech technology speaks turn-by-turn directions--including street names--for easier navigation. Lane guidance tells you exactly where you need to be: that means no more missed exits because you didn't switch lanes soon enough! If you're in unfamiliar territory, this MOTONAV even lets you search for nearby restaurants, gas stations, banks, and more--over a million points of interest in all.

Unspoiled views. The 3.5" diagonal anti-glare touchscreen automatically adjusts for day and night travel. A mere touch of the finger lets you move onscreen maps and zoom in or out to get a clear picture of your route.

No hidden tolls. With this MOTONAV, there's no activation fee or monthly service fee. You pay only the incredibly affordable purchase price.

So, get this MOTONAV GPS navigator--and get straight to the point. From Motorola. Includes MOTONAV TN20 GPS system, rechargeable battery, car charger, windshield mount, dashboard mount, DVD, and quick-start guide 3.5" diagonal anti-glare touchscreen display 1GB built-in memory Maps of continental U.S. Text-to-speech technology Voice-guided directions and street names Lane guidance technology More than one million points of interest Automatic day/night mode adjustment 2-D and 3-D map perspectives Zoom and move maps with your finger Measures 3-3/4"L x 3/4"W x 3-1/4"H 1-year Limited Manufacturer's Warranty Made in Philippines

(default) 55 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	1
4	DESCRIBE `monsters`	6	6	1
5	DESCRIBE `ratings`	5	5	1
6	DESCRIBE `user_deals`	15	15	1
7	DESCRIBE `user_deal_ratings`	5	5	1
8	DESCRIBE `categories`	3	3	1
9	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
10	SELECT name,id,temp_cat,website FROM merchants WHERE id ="92"	1	1	0
11	SELECT category,sub_category FROM user_deals where uid = 92 AND start_date='2009-07-04 21^07^52'	0	0	0
12	DESCRIBE `sponsored_deals`	4	4	1
13	DESCRIBE `reviews`	9	9	1
14	DESCRIBE `user_reviews`	7	7	1
15	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
16	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520190;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520190 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1		0
17	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
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 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	617
19	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
20	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520190;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520191 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1		0
21	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
22	(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
23	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:11", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
24	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
25	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520191;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520191 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1		0
26	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
27	(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
28	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:11", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
29	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
30	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520191;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520191 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
31	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
32	(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
33	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:11", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
34	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
35	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520191;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520191 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
36	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
37	(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
38	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:11", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
39	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
40	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520191;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520191 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
41	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
42	(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
43	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:11", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	1
44	SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "92" and deals.start_date="2009-07-04 21:07:52"	1	1	0
45	SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '92' and start_date = '2009-07-04 21:07:52'	1	1	0
46	SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "92" AND date = "2009-07-04 21^07^52" AND TIMEDIFF("2010-09-03 08:09:11", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	2
47	(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 = "92" AND comments.start_date = "2009-07-04 21^07^52") 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 = "92" AND user_comments.start_date = "2009-07-04 21^07^52" ) ORDER BY posted_on desc	0	0	2
48	SELECT img,code from verify_imgs	13	13	0
49	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
50	SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="92"	1	1	0
51	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
52	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520191;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520191 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0
53	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
54	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	1	1	0
55	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283520191;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1283520191 WHERE `id` = 'v4oc8us6iuk6a068pg9ase4uu3'	0		0

(default) 55 queries took 639 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `deals`

DESCRIBE `merchants`

DESCRIBE `verify_imgs`

DESCRIBE `monsters`

DESCRIBE `ratings`

DESCRIBE `user_deals`

DESCRIBE `user_deal_ratings`

DESCRIBE `categories`

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

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

SELECT category,sub_category FROM user_deals where uid = 92 AND start_date='2009-07-04 21^07^52'

DESCRIBE `sponsored_deals`

DESCRIBE `reviews`

DESCRIBE `user_reviews`

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

617

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 = "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:11", 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:1283520191;s:7:\"timeout\";i:10;}client_view|s:6:\"normal\";', `expires` = 1283520191 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 = "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:11", 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 = "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:11", 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 = "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:11", 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 = "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:11", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"

SELECT * from deals,merchants where deals.merchant_id = merchants.id and merchants.id = "92" and deals.start_date="2009-07-04 21:07:52"

SELECT * FROM deals,merchants where deals.merchant_id = merchants.id and merchant_id = '92' and start_date = '2009-07-04 21:07:52'

SELECT DISTINCT(ip_address) FROM ratings WHERE merchant_id = "92" AND date = "2009-07-04 21^07^52" AND TIMEDIFF("2010-09-03 08:09:11", 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 = "92" AND comments.start_date = "2009-07-04 21^07^52") 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 = "92" AND user_comments.start_date = "2009-07-04 21^07^52" ) 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 ="92"

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'