joeyjam's Profile

joeyjam

He/she is the founder of Joeyjamity.

Sins Committed

This user hasn't sinned yet. Goody two shoes!

More About Me..

Last logged in

on 12/1/10

24 queries took 6 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `religions`	11	11	1
2	DESCRIBE `symbols`	5	5	1
3	DESCRIBE `commandments`	4	4	1
4	DESCRIBE `holidays`	4	4	1
5	DESCRIBE `sins`	9	9	1
6	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`created`, `User`.`last_login`, `User`.`activated`, `User`.`activate_key`, `User`.`password_key`, `User`.`belief`, `Profile`.`id`, `Profile`.`forename`, `Profile`.`surname`, `Profile`.`date_of_birth`, `Profile`.`gender`, `Profile`.`user_id`, `Profile`.`photo`, `Profile`.`country_id`, `Profile`.`important_thing`, `Profile`.`first_memory`, `Profile`.`happen_after_death` FROM `users` AS `User` LEFT JOIN `profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`username` = 'joeyjam' LIMIT 1	1	1	0
7	SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`user_id` IN (185)	0	0	0
8	SELECT `Task`.`id`, `Task`.`title`, `Task`.`description`, `Task`.`url`, `Task`.`type` FROM `tasks` AS `Task` JOIN `tasks_users` ON (`tasks_users`.`user_id` = 185 AND `tasks_users`.`task_id` = `Task`.`id`) WHERE `tasks_users`.`completed` = "0"	5	5	0
9	SELECT `Belief`.`id`, `Belief`.`title`, `Belief`.`prefix`, `Belief`.`description`, `Belief`.`belief_id`, `Belief`.`beliefs_category_id`, `Belief`.`created`, `Belief`.`modified`, `Belief`.`obj_id`, `Belief`.`user_id`, `Belief`.`photo`, `Belief`.`main` FROM `beliefs` AS `Belief` JOIN `beliefs_users` ON (`beliefs_users`.`user_id` = 185 AND `beliefs_users`.`belief_id` = `Belief`.`id`) WHERE 1 = 1 ORDER BY `beliefs_users`.`priority` ASC	4	4	0
10	SELECT `Sin`.`id`, `Sin`.`title`, `Sin`.`description`, `Sin`.`modified`, `Sin`.`created`, `Sin`.`photo`, `Sin`.`user_id`, `Sin`.`uid`, `Sin`.`service` FROM `sins` AS `Sin` JOIN `sins_users` ON (`sins_users`.`user_id` = 185 AND `sins_users`.`sin_id` = `Sin`.`id`) WHERE 1 = 1	0	0	0
11	SELECT `Religion`.`id`, `Religion`.`created`, `Religion`.`modified`, `Religion`.`title`, `Religion`.`user_id`, `Religion`.`active`, `Religion`.`followers_title`, `Religion`.`strict_sins`, `Religion`.`sole_religion`, `Religion`.`world_begin`, `Religion`.`world_end` FROM `religions` AS `Religion` JOIN `religions_users` ON (`religions_users`.`user_id` = 185 AND `religions_users`.`religion_id` = `Religion`.`id`) WHERE 1 = 1	0	0	0
12	SELECT `Profile`.`id`, `Profile`.`forename`, `Profile`.`surname`, `Profile`.`date_of_birth`, `Profile`.`gender`, `Profile`.`user_id`, `Profile`.`photo`, `Profile`.`country_id`, `Profile`.`important_thing`, `Profile`.`first_memory`, `Profile`.`happen_after_death`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`created`, `User`.`last_login`, `User`.`activated`, `User`.`activate_key`, `User`.`password_key`, `User`.`belief`, `Country`.`id`, `Country`.`name` FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Profile`.`country_id` = `Country`.`id`) WHERE `Profile`.`user_id` = 185 LIMIT 1	1	1	0
13	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`created`, `User`.`last_login`, `User`.`activated`, `User`.`activate_key`, `User`.`password_key`, `User`.`belief` FROM `users` AS `User` WHERE `User`.`id` = 185	1	1	0
14	SELECT `Profile`.`id`, `Profile`.`forename`, `Profile`.`surname`, `Profile`.`date_of_birth`, `Profile`.`gender`, `Profile`.`user_id`, `Profile`.`photo`, `Profile`.`country_id`, `Profile`.`important_thing`, `Profile`.`first_memory`, `Profile`.`happen_after_death` FROM `profiles` AS `Profile` WHERE `Profile`.`user_id` = 185	1	1	0
15	SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` JOIN `comments_profiles` ON (`comments_profiles`.`profile_id` = 127 AND `comments_profiles`.`comment_id` = `Comment`.`id`) WHERE 1 = 1 ORDER BY `comments_profiles`.`id` DESC LIMIT 10	0	0	0
16	SELECT id FROM religions WHERE user_id = '185' AND active = '1'	1	1	0
17	SELECT `Religion`.`id`, `Religion`.`created`, `Religion`.`modified`, `Religion`.`title`, `Religion`.`user_id`, `Religion`.`active`, `Religion`.`followers_title`, `Religion`.`strict_sins`, `Religion`.`sole_religion`, `Religion`.`world_begin`, `Religion`.`world_end` FROM `religions` AS `Religion` WHERE `Religion`.`id` = 104 LIMIT 1	1	1	0
18	SELECT `Symbol`.`id`, `Symbol`.`religion_id`, `Symbol`.`photo`, `Symbol`.`description`, `Symbol`.`default` FROM `symbols` AS `Symbol` WHERE `Symbol`.`religion_id` IN (104)	0	0	0
19	SELECT `Commandment`.`id`, `Commandment`.`obj_id`, `Commandment`.`shalt`, `Commandment`.`verb` FROM `commandments` AS `Commandment` JOIN `commandments_religions` ON (`commandments_religions`.`religion_id` = 104 AND `commandments_religions`.`commandment_id` = `Commandment`.`id`) WHERE 1 = 1 ORDER BY `commandments_religions`.`priority` ASC	0	0	0
20	SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` JOIN `comments_religions` ON (`comments_religions`.`religion_id` = 104 AND `comments_religions`.`comment_id` = `Comment`.`id`) WHERE 1 = 1 ORDER BY `comments_religions`.`id` DESC LIMIT 10	0	0	0
21	SELECT `Holiday`.`id`, `Holiday`.`title`, `Holiday`.`start_date`, `Holiday`.`end_date` FROM `holidays` AS `Holiday` JOIN `holidays_religions` ON (`holidays_religions`.`religion_id` = 104 AND `holidays_religions`.`holiday_id` = `Holiday`.`id`) WHERE 1 = 1	0	0	0
22	SELECT `Sin`.`id`, `Sin`.`title`, `Sin`.`description`, `Sin`.`modified`, `Sin`.`created`, `Sin`.`photo`, `Sin`.`user_id`, `Sin`.`uid`, `Sin`.`service` FROM `sins` AS `Sin` JOIN `religions_sins` ON (`religions_sins`.`religion_id` = 104 AND `religions_sins`.`sin_id` = `Sin`.`id`) WHERE 1 = 1	0	0	0
23	SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`created`, `User`.`last_login`, `User`.`activated`, `User`.`activate_key`, `User`.`password_key`, `User`.`belief` FROM `users` AS `User` JOIN `religions_users` ON (`religions_users`.`religion_id` = 104 AND `religions_users`.`user_id` = `User`.`id`) WHERE 1 = 1	0	0	0
24	SELECT bu.description, b.photo, b.beliefs_category_id, u.username, p.photo, bu.priority, bu.score, b.id, b.description, b.title FROM beliefs_users as bu, beliefs as b, users as u, profiles as p WHERE bu.user_id = '185' AND bu.belief_id = b.id AND bu.description != '' AND b.user_id = u.id AND p.user_id = u.id ORDER by bu.priority ASC LIMIT 5	0	0	1

24 queries took 6 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `religions`

DESCRIBE `symbols`

DESCRIBE `commandments`

DESCRIBE `holidays`

DESCRIBE `sins`

SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`created`, `User`.`last_login`, `User`.`activated`, `User`.`activate_key`, `User`.`password_key`, `User`.`belief`, `Profile`.`id`, `Profile`.`forename`, `Profile`.`surname`, `Profile`.`date_of_birth`, `Profile`.`gender`, `Profile`.`user_id`, `Profile`.`photo`, `Profile`.`country_id`, `Profile`.`important_thing`, `Profile`.`first_memory`, `Profile`.`happen_after_death` FROM `users` AS `User` LEFT JOIN `profiles` AS `Profile` ON (`Profile`.`user_id` = `User`.`id`) WHERE `User`.`username` = 'joeyjam' LIMIT 1

SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` WHERE `Comment`.`user_id` IN (185)

SELECT `Task`.`id`, `Task`.`title`, `Task`.`description`, `Task`.`url`, `Task`.`type` FROM `tasks` AS `Task` JOIN `tasks_users` ON (`tasks_users`.`user_id` = 185 AND `tasks_users`.`task_id` = `Task`.`id`) WHERE `tasks_users`.`completed` = "0"

SELECT `Belief`.`id`, `Belief`.`title`, `Belief`.`prefix`, `Belief`.`description`, `Belief`.`belief_id`, `Belief`.`beliefs_category_id`, `Belief`.`created`, `Belief`.`modified`, `Belief`.`obj_id`, `Belief`.`user_id`, `Belief`.`photo`, `Belief`.`main` FROM `beliefs` AS `Belief` JOIN `beliefs_users` ON (`beliefs_users`.`user_id` = 185 AND `beliefs_users`.`belief_id` = `Belief`.`id`) WHERE 1 = 1 ORDER BY `beliefs_users`.`priority` ASC

SELECT `Sin`.`id`, `Sin`.`title`, `Sin`.`description`, `Sin`.`modified`, `Sin`.`created`, `Sin`.`photo`, `Sin`.`user_id`, `Sin`.`uid`, `Sin`.`service` FROM `sins` AS `Sin` JOIN `sins_users` ON (`sins_users`.`user_id` = 185 AND `sins_users`.`sin_id` = `Sin`.`id`) WHERE 1 = 1

SELECT `Religion`.`id`, `Religion`.`created`, `Religion`.`modified`, `Religion`.`title`, `Religion`.`user_id`, `Religion`.`active`, `Religion`.`followers_title`, `Religion`.`strict_sins`, `Religion`.`sole_religion`, `Religion`.`world_begin`, `Religion`.`world_end` FROM `religions` AS `Religion` JOIN `religions_users` ON (`religions_users`.`user_id` = 185 AND `religions_users`.`religion_id` = `Religion`.`id`) WHERE 1 = 1

SELECT `Profile`.`id`, `Profile`.`forename`, `Profile`.`surname`, `Profile`.`date_of_birth`, `Profile`.`gender`, `Profile`.`user_id`, `Profile`.`photo`, `Profile`.`country_id`, `Profile`.`important_thing`, `Profile`.`first_memory`, `Profile`.`happen_after_death`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`created`, `User`.`last_login`, `User`.`activated`, `User`.`activate_key`, `User`.`password_key`, `User`.`belief`, `Country`.`id`, `Country`.`name` FROM `profiles` AS `Profile` LEFT JOIN `users` AS `User` ON (`Profile`.`user_id` = `User`.`id`) LEFT JOIN `countries` AS `Country` ON (`Profile`.`country_id` = `Country`.`id`) WHERE `Profile`.`user_id` = 185 LIMIT 1

SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` JOIN `comments_profiles` ON (`comments_profiles`.`profile_id` = 127 AND `comments_profiles`.`comment_id` = `Comment`.`id`) WHERE 1 = 1 ORDER BY `comments_profiles`.`id` DESC LIMIT 10

SELECT id FROM religions WHERE user_id = '185' AND active = '1'

SELECT `Symbol`.`id`, `Symbol`.`religion_id`, `Symbol`.`photo`, `Symbol`.`description`, `Symbol`.`default` FROM `symbols` AS `Symbol` WHERE `Symbol`.`religion_id` IN (104)

SELECT `Commandment`.`id`, `Commandment`.`obj_id`, `Commandment`.`shalt`, `Commandment`.`verb` FROM `commandments` AS `Commandment` JOIN `commandments_religions` ON (`commandments_religions`.`religion_id` = 104 AND `commandments_religions`.`commandment_id` = `Commandment`.`id`) WHERE 1 = 1 ORDER BY `commandments_religions`.`priority` ASC

SELECT `Comment`.`id`, `Comment`.`user_id`, `Comment`.`content`, `Comment`.`created`, `Comment`.`modified` FROM `comments` AS `Comment` JOIN `comments_religions` ON (`comments_religions`.`religion_id` = 104 AND `comments_religions`.`comment_id` = `Comment`.`id`) WHERE 1 = 1 ORDER BY `comments_religions`.`id` DESC LIMIT 10

SELECT `Holiday`.`id`, `Holiday`.`title`, `Holiday`.`start_date`, `Holiday`.`end_date` FROM `holidays` AS `Holiday` JOIN `holidays_religions` ON (`holidays_religions`.`religion_id` = 104 AND `holidays_religions`.`holiday_id` = `Holiday`.`id`) WHERE 1 = 1

SELECT `Sin`.`id`, `Sin`.`title`, `Sin`.`description`, `Sin`.`modified`, `Sin`.`created`, `Sin`.`photo`, `Sin`.`user_id`, `Sin`.`uid`, `Sin`.`service` FROM `sins` AS `Sin` JOIN `religions_sins` ON (`religions_sins`.`religion_id` = 104 AND `religions_sins`.`sin_id` = `Sin`.`id`) WHERE 1 = 1

SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`email`, `User`.`created`, `User`.`last_login`, `User`.`activated`, `User`.`activate_key`, `User`.`password_key`, `User`.`belief` FROM `users` AS `User` JOIN `religions_users` ON (`religions_users`.`religion_id` = 104 AND `religions_users`.`user_id` = `User`.`id`) WHERE 1 = 1

SELECT bu.description, b.photo, b.beliefs_category_id, u.username, p.photo, bu.priority, bu.score, b.id, b.description, b.title FROM beliefs_users as bu, beliefs as b, users as u, profiles as p WHERE bu.user_id = '185' AND bu.belief_id = b.id AND bu.description != '' AND b.user_id = u.id AND p.user_id = u.id ORDER by bu.priority ASC LIMIT 5