DealQUE | Selam Transportation

(default) 24 queries took 2140 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `deals`	17	17	3
2	DESCRIBE `verify_imgs`	3	3	1
3	DESCRIBE `monsters`	6	6	1
4	DESCRIBE `comments`	10	10	1
5	DESCRIBE `user_comments`	8	8	3
6	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	4
7	SELECT username as name,users.id,monster_id,monsters.img as monster_img FROM users,monsters WHERE users.id ='1485' AND monsters.id = users.monster_id	1	1	0
8	SELECT category,sub_category FROM user_deals where uid = 1485 AND start_date='2010-03-11 14^03^42'	1	1	0
9	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
10	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283875830;s:7:\"timeout\";i:10;}', `expires` = 1283875830 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1		0
11	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
12	( 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='Miscellaneous' AND sub_category='Other' 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='Miscellaneous' AND sub_category='Other' 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	2063
13	SELECT * from user_deals,users where user_deals.uid = users.id and users.id = "1485" and user_deals.start_date="2010-03-11 14:03:42"	1	1	1
14	SELECT * FROM user_deals,users where user_deals.uid = users.id and uid = '1485' and start_date = '2010-03-11 14:03:42'	1	1	1
15	SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1485" AND date = "2010-03-11 14^03^42" AND TIMEDIFF("2010-09-07 11:09:33", CONCAT(date_clicked," ",time_clicked)) < "01:00:00"	0	0	11
16	(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 = "1485" AND comments.start_date = "2010-03-11 14^03^42") 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 = "1485" AND user_comments.start_date = "2010-03-11 14^03^42" ) ORDER BY posted_on desc	0	0	40
17	SELECT img,code from verify_imgs	13	13	0
18	SELECT * from monsters where is_live ="true" and rights = "public"	7	7	0
19	SELECT MAX(start_date) as live_start_date FROM deals WHERE merchant_id ="1485"	1	1	0
20	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	2
21	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283875830;s:7:\"timeout\";i:10;}', `expires` = 1283875833 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1		1
22	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	8
23	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	1	1	0
24	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1283875830;s:7:\"timeout\";i:10;}', `expires` = 1283875833 WHERE `id` = '0reel1ajh5ol7tefd3sikijta2'	0		0

(default) 24 queries took 2140 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `deals`

DESCRIBE `verify_imgs`

DESCRIBE `monsters`

DESCRIBE `comments`

DESCRIBE `user_comments`

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'

SELECT username as name,users.id,monster_id,monsters.img as monster_img FROM users,monsters WHERE users.id ='1485' AND monsters.id = users.monster_id

SELECT category,sub_category FROM user_deals where uid = 1485 AND start_date='2010-03-11 14^03^42'

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

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'

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

2063

SELECT * from user_deals,users where user_deals.uid = users.id and users.id = "1485" and user_deals.start_date="2010-03-11 14:03:42"

SELECT * FROM user_deals,users where user_deals.uid = users.id and uid = '1485' and start_date = '2010-03-11 14:03:42'

SELECT DISTINCT(ip_address),time_clicked,date_clicked FROM user_deal_ratings WHERE uid = "1485" AND date = "2010-03-11 14^03^42" AND TIMEDIFF("2010-09-07 11:09:33", 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 = "1485" AND comments.start_date = "2010-03-11 14^03^42") 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 = "1485" AND user_comments.start_date = "2010-03-11 14^03^42" ) 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 ="1485"

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

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = '0reel1ajh5ol7tefd3sikijta2'

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