# 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]