# Logfile created on Thu Apr 15 14:55:01 +0800 2010  SQL (0.0ms)   SET NAMES 'utf8'
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0
  SQL (0.0ms)   SET NAMES 'utf8'
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0


Processing WelcomeController#index (for 10.50.240.158 at 2010-04-15 14:56:24) [GET]
  Parameters: {"action"=>"index", "controller"=>"welcome"}
  Setting Columns (0.0ms)   SHOW FIELDS FROM `settings`
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  User Columns (16.0ms)   SHOW FIELDS FROM `users`
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  News Columns (15.0ms)   SHOW FIELDS FROM `news`
  Project Columns (0.0ms)   SHOW FIELDS FROM `projects`
  News Load Including Associations (0.0ms)   SELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `news` LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) ORDER BY news.created_on DESC LIMIT 5
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5
Rendering template within layouts/base
Rendering welcome/index
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1
  UserPreference Load (0.0ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 3) LIMIT 1
  UserPreference Columns (0.0ms)   SHOW FIELDS FROM `user_preferences`
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1
  Token Load (0.0ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 3 AND (action='feeds')) LIMIT 1
  Token Columns (15.0ms)   SHOW FIELDS FROM `tokens`
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
  Project Load (16.0ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 3) AND ((projects.status=1))) 
Completed in 2016ms (View: 1829, DB: 62) | 200 OK [http://10.50.241.20/]
  SQL (0.0ms)   SET NAMES 'utf8'
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0


Processing AccountController#logout (for 10.50.240.158 at 2010-04-15 14:57:39) [GET]
  Parameters: {"action"=>"logout", "controller"=>"account"}
  Setting Columns (16.0ms)   SHOW FIELDS FROM `settings`
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  User Columns (0.0ms)   SHOW FIELDS FROM `users`
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 3) AND (users.status = 1) AND ( (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) ) 
  Token Delete all (0.0ms)   DELETE FROM `tokens` WHERE (user_id = 3 AND action = 'autologin') 
  AnonymousUser Columns (0.0ms)   SHOW FIELDS FROM `users`
  AnonymousUser Load (0.0ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
Redirected to http://10.50.241.20:3000/
Completed in 78ms (DB: 16) | 302 Found [http://10.50.241.20/logout]
  SQL (0.0ms)   SET NAMES 'utf8'
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0


Processing WelcomeController#index (for 10.50.240.158 at 2010-04-15 14:57:46) [GET]
  Parameters: {"action"=>"index", "controller"=>"welcome"}
  Setting Columns (0.0ms)   SHOW FIELDS FROM `settings`
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'rest_api_enabled') LIMIT 1
  AnonymousUser Columns (15.0ms)   SHOW FIELDS FROM `users`
  AnonymousUser Load (0.0ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'login_required') LIMIT 1
  Role Load (0.0ms)   SELECT * FROM `roles` WHERE (`roles`.`builtin` = 2) LIMIT 1
  Role Columns (0.0ms)   SHOW FIELDS FROM `roles`
  News Columns (0.0ms)   SHOW FIELDS FROM `news`
  User Columns (16.0ms)   SHOW FIELDS FROM `users`
  Project Columns (0.0ms)   SHOW FIELDS FROM `projects`
  News Load Including Associations (0.0ms)   SELECT `news`.`id` AS t0_r0, `news`.`project_id` AS t0_r1, `news`.`title` AS t0_r2, `news`.`summary` AS t0_r3, `news`.`description` AS t0_r4, `news`.`author_id` AS t0_r5, `news`.`created_on` AS t0_r6, `news`.`comments_count` AS t0_r7, `users`.`id` AS t1_r0, `users`.`login` AS t1_r1, `users`.`hashed_password` AS t1_r2, `users`.`firstname` AS t1_r3, `users`.`lastname` AS t1_r4, `users`.`mail` AS t1_r5, `users`.`mail_notification` AS t1_r6, `users`.`admin` AS t1_r7, `users`.`status` AS t1_r8, `users`.`last_login_on` AS t1_r9, `users`.`language` AS t1_r10, `users`.`auth_source_id` AS t1_r11, `users`.`created_on` AS t1_r12, `users`.`updated_on` AS t1_r13, `users`.`type` AS t1_r14, `users`.`identity_url` AS t1_r15, `projects`.`id` AS t2_r0, `projects`.`name` AS t2_r1, `projects`.`description` AS t2_r2, `projects`.`homepage` AS t2_r3, `projects`.`is_public` AS t2_r4, `projects`.`parent_id` AS t2_r5, `projects`.`created_on` AS t2_r6, `projects`.`updated_on` AS t2_r7, `projects`.`identifier` AS t2_r8, `projects`.`status` AS t2_r9, `projects`.`lft` AS t2_r10, `projects`.`rgt` AS t2_r11 FROM `news` LEFT OUTER JOIN `users` ON `users`.id = `news`.author_id AND (`users`.`type` = 'User' OR `users`.`type` = 'AnonymousUser' ) LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (((projects.status=1 AND projects.id IN (SELECT em.project_id FROM enabled_modules em WHERE em.name='news')) AND (1=0 OR projects.is_public = 1))) ORDER BY news.created_on DESC LIMIT 5
  Member Columns (0.0ms)   SHOW FIELDS FROM `members`
  SQL (0.0ms)   SELECT count(DISTINCT `members`.id) AS count_all FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `member_roles` ON (`members`.`id` = `member_roles`.`member_id`) LEFT OUTER JOIN `roles` ON (`roles`.`id` = `member_roles`.`role_id`) WHERE (`members`.user_id = 2 AND (projects.status=1)) 
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (projects.status=1 AND projects.is_public = 1) ORDER BY created_on DESC LIMIT 5
Rendering template within layouts/base
Rendering welcome/index
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1
  Project Load (0.0ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 2) AND ((projects.status=1))) 
Completed in 1532ms (View: 1391, DB: 31) | 200 OK [http://10.50.241.20/]
  SQL (0.0ms)   SET NAMES 'utf8'
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0


Processing AccountController#login (for 10.50.240.158 at 2010-04-15 14:59:06) [GET]
  Parameters: {"action"=>"login", "controller"=>"account"}
  Setting Columns (0.0ms)   SHOW FIELDS FROM `settings`
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 
  Setting Load (15.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'rest_api_enabled') LIMIT 1
  AnonymousUser Columns (0.0ms)   SHOW FIELDS FROM `users`
  AnonymousUser Load (0.0ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
  CACHE (0.0ms)   SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
Rendering template within layouts/base
Rendering account/login
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'autologin') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'lost_password') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1
  Project Load (0.0ms)   SELECT `projects`.* FROM `projects` INNER JOIN `members` ON `projects`.id = `members`.project_id WHERE ((`members`.user_id = 2) AND ((projects.status=1))) 
Completed in 1015ms (View: 969, DB: 15) | 200 OK [http://10.50.241.20/login]