Project

General

Profile

Download (3.71 KB)

Defect #3451 ยป production.log

Carlo Camerino, 2009-06-06 13:13

 
1 
# Logfile created on Sat Jun 06 19:06:21 +0800 2009
2 

    		
  

  

    
      3
    
    
      
Processing WelcomeController#index (for 222.127.185.144 at 2009-06-06 19:09:52) [GET]


    		
  

  

    
      4
    
    
      
  Parameters: {"action"=>"index", "controller"=>"welcome"}


    		
  

  

    
      5
    
    
      
  SQL (0.0ms)   SET NAMES 'utf8'


    		
  

  

    
      6
    
    
      
  SQL (0.0ms)   SET SQL_AUTO_IS_NULL=0


    		
  

  

    
      7
    
    
      
  Setting Columns (0.4ms)   SHOW FIELDS FROM `settings`


    		
  

  

    
      8
    
    
      
  SQL (0.0ms)   SELECT max(`settings`.updated_on) AS max_updated_on FROM `settings` 


    		
  

  

    
      9
    
    
      
  User Columns (0.6ms)   SHOW FIELDS FROM `users`


    		
  

  

    
      10
    
    
      
  User Load (0.0ms)   SELECT * FROM `users` WHERE (`users`.`id` = 1) AND (users.status = 1) 


    		
  

  

    
      11
    
    
      
  News Columns (0.5ms)   SHOW FIELDS FROM `news`


    		
  

  

    
      12
    
    
      
  Project Columns (0.5ms)   SHOW FIELDS FROM `projects`


    		
  

  

    
      13
    
    
      
  News Load Including Associations (0.1ms)   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 LEFT OUTER JOIN `projects` ON `projects`.id = `news`.project_id WHERE (projects.status=1 AND EXISTS (SELECT em.id FROM enabled_modules em WHERE em.name='news' AND em.project_id=projects.id)) ORDER BY news.created_on DESC LIMIT 5


    		
  

  

    
      14
    
    
      
  Project Load (0.0ms)   SELECT * FROM `projects` WHERE (projects.status=1) ORDER BY created_on DESC LIMIT 5


    		
  

  

    
      15
    
    
      
Rendering template within layouts/base


    		
  

  

    
      16
    
    
      
Rendering welcome/index


    		
  

  

    
      17
    
    
      
  Setting Load (0.1ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'welcome_text') LIMIT 1


    		
  

  

    
      18
    
    
      
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'text_formatting') LIMIT 1


    		
  

  

    
      19
    
    
      
  UserPreference Load (0.0ms)   SELECT * FROM `user_preferences` WHERE (`user_preferences`.user_id = 1) LIMIT 1


    		
  

  

    
      20
    
    
      
  UserPreference Columns (0.5ms)   SHOW FIELDS FROM `user_preferences`


    		
  

  

    
      21
    
    
      
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'time_format') LIMIT 1


    		
  

  

    
      22
    
    
      
  Token Load (0.0ms)   SELECT * FROM `tokens` WHERE (`tokens`.user_id = 1 AND (action='feeds')) LIMIT 1


    		
  

  

    
      23
    
    
      
  Token Columns (0.4ms)   SHOW FIELDS FROM `tokens`


    		
  

  

    
      24
    
    
      
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1


    		
  

  

    
      25
    
    
      
  Setting Load (0.0ms)   SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1


    		
  

  

    
      26
    
    
      
  Project Load (0.1ms)   SELECT `projects`.* FROM `projects` INNER JOIN members ON projects.id = members.project_id WHERE ((`members`.user_id = 1) AND ((projects.status=1))) 


    		
  

  

    
      27
    
    
      
Completed in 340ms (View: 326, DB: 2) | 200 OK [http://www.sxchange.com.ph/]


    		
  












  
    (1-1/1)