DealQUE | Member profile for chuckkenty

(default) 20 queries took 14 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `users`	11	11	1
2	DESCRIBE `pending_monsters`	7	7	1
3	DESCRIBE `tickets`	5	5	1
4	DESCRIBE `monsters`	6	6	1
5	DESCRIBE `user_deals`	15	15	2
6	DESCRIBE `user_deal_ratings`	5	5	1
7	DESCRIBE `user_monsters`	3	3	1
8	DESCRIBE `tc_searchs`	12	12	1
9	DESCRIBE `tc_followers`	1	1	1
10	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
11	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`twitter`, `User`.`created`, `User`.`monster_id`, `User`.`website`, `User`.`is_live`, `User`.`email_verified`, `User`.`points` FROM `users` AS `User` WHERE `User`.`username` = 'chuckkenty' LIMIT 1	1	1	0
12	SELECT users.created,users.points,users.username,users.id,users.email_verified,users.email,users.website,users.monster_id,monsters.img from users,monsters where users.monster_id = monsters.id AND users.id = "1303"	1	1	1
13	SELECT count(uid) as num_submited, sum(que_count) as total_ques FROM user_deals WHERE uid = "1303" GROUP BY uid	1	1	1
14	SELECT * FROM user_deals WHERE uid = "1303" AND available = "Y" ORDER BY start_date desc	0	0	0
15	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
16	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284081616;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284081616 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1		0
17	DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284063616	7		2
18	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
19	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	1	1	0
20	UPDATE `cake_sessions` SET `data` = 'Config\|a:3:{s:9:\"userAgent\";s:32:\"271dbdd1862a7610f0e326d69fcb3023\";s:4:\"time\";i:1284081616;s:7:\"timeout\";i:10;}client_view\|s:6:\"normal\";', `expires` = 1284081616 WHERE `id` = 'a7bc7tioa2hfr8o6fqoqgo5cn1'	0		0

(default) 20 queries took 14 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `users`

DESCRIBE `pending_monsters`

DESCRIBE `tickets`

DESCRIBE `monsters`

DESCRIBE `user_deals`

DESCRIBE `user_deal_ratings`

DESCRIBE `user_monsters`

DESCRIBE `tc_searchs`

DESCRIBE `tc_followers`

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

SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`twitter`, `User`.`created`, `User`.`monster_id`, `User`.`website`, `User`.`is_live`, `User`.`email_verified`, `User`.`points` FROM `users` AS `User` WHERE `User`.`username` = 'chuckkenty' LIMIT 1

SELECT users.created,users.points,users.username,users.id,users.email_verified,users.email,users.website,users.monster_id,monsters.img from users,monsters where users.monster_id = monsters.id AND users.id = "1303"

SELECT count(uid) as num_submited, sum(que_count) as total_ques FROM user_deals WHERE uid = "1303" GROUP BY uid

SELECT * FROM user_deals WHERE uid = "1303" AND available = "Y" ORDER BY start_date desc

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

DELETE FROM `cake_sessions` WHERE `cake_sessions`.`expires` < 1284063616

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

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