Redmine

# Logfile created on Tue Sep 02 17:47:27 +0100 2008  SQL (0.015000)    SELECT name

 FROM sqlite_master

 WHERE type = 'table' AND NOT name = 'sqlite_sequence'



Processing BoardsController#show (for 10.50.34.253 at 2008-09-02 17:52:56) [GET]

  Session ID: 692dba831df85787763edea0ca459be2

  Parameters: {"project_id"=>"iaa-in-java", "action"=>"show", "id"=>"5", "controller"=>"boards"}

  SQL (0.000000)   SELECT max(updated_on) AS max_updated_on FROM settings 

  SQL (0.015000)    SELECT name

 FROM sqlite_master

 WHERE type = 'table' AND NOT name = 'sqlite_sequence'



  SQL (0.015000)    SELECT name

 FROM sqlite_master

 WHERE type = 'table' AND NOT name = 'sqlite_sequence'



  SQL (0.016000)    SELECT name

 FROM sqlite_master

 WHERE type = 'table' AND NOT name = 'sqlite_sequence'



  SQL (0.016000)    SELECT name

 FROM sqlite_master

 WHERE type = 'table' AND NOT name = 'sqlite_sequence'



  SQL (0.015000)    SELECT name

 FROM sqlite_master

 WHERE type = 'table' AND NOT name = 'sqlite_sequence'



  SQL (0.016000)    SELECT name

 FROM sqlite_master

 WHERE type = 'table' AND NOT name = 'sqlite_sequence'



  User Load (0.000000)   SELECT * FROM users WHERE (status = 1) AND (users."id" = 2) 

  Project Load (0.015000)   SELECT * FROM projects WHERE (projects."identifier" = 'iaa-in-java') LIMIT 1

  Board Load (0.000000)   SELECT * FROM boards WHERE (boards."id" = 5 AND (boards.project_id = 6)) ORDER BY position ASC

  EnabledModule Load (0.000000)   SELECT * FROM enabled_modules WHERE (enabled_modules.project_id = 6) 

  SQL (0.000000)   SELECT count(*) AS count_all FROM messages WHERE (messages.board_id = 5 AND (messages.parent_id IS NULL)) 

  Setting Load (0.000000)   SELECT * FROM settings WHERE (settings."name" = 'per_page_options') LIMIT 1

  Message Load Including Associations (0.000000)   SELECT messages."id" AS t0_r0, messages."board_id" AS t0_r1, messages."parent_id" AS t0_r2, messages."subject" AS t0_r3, messages."content" AS t0_r4, messages."author_id" AS t0_r5, messages."replies_count" AS t0_r6, messages."last_reply_id" AS t0_r7, messages."created_on" AS t0_r8, messages."updated_on" AS t0_r9, messages."locked" AS t0_r10, messages."sticky" AS t0_r11, 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, last_replies_messages."id" AS t2_r0, last_replies_messages."board_id" AS t2_r1, last_replies_messages."parent_id" AS t2_r2, last_replies_messages."subject" AS t2_r3, last_replies_messages."content" AS t2_r4, last_replies_messages."author_id" AS t2_r5, last_replies_messages."replies_count" AS t2_r6, last_replies_messages."last_reply_id" AS t2_r7, last_replies_messages."created_on" AS t2_r8, last_replies_messages."updated_on" AS t2_r9, last_replies_messages."locked" AS t2_r10, last_replies_messages."sticky" AS t2_r11, authors_messages."id" AS t3_r0, authors_messages."login" AS t3_r1, authors_messages."hashed_password" AS t3_r2, authors_messages."firstname" AS t3_r3, authors_messages."lastname" AS t3_r4, authors_messages."mail" AS t3_r5, authors_messages."mail_notification" AS t3_r6, authors_messages."admin" AS t3_r7, authors_messages."status" AS t3_r8, authors_messages."last_login_on" AS t3_r9, authors_messages."language" AS t3_r10, authors_messages."auth_source_id" AS t3_r11, authors_messages."created_on" AS t3_r12, authors_messages."updated_on" AS t3_r13, authors_messages."type" AS t3_r14 FROM messages LEFT OUTER JOIN users ON users.id = messages.author_id LEFT OUTER JOIN messages last_replies_messages ON last_replies_messages.id = messages.last_reply_id LEFT OUTER JOIN users authors_messages ON authors_messages.id = last_replies_messages.author_id WHERE (messages.board_id = 5 AND (messages.parent_id IS NULL)) ORDER BY messages.sticky DESC, messages.updated_on desc, messages.created_on DESC LIMIT 25 OFFSET 0

Rendering template within layouts/base

Rendering boards/show

  Watcher Load (0.015000)   SELECT * FROM watchers WHERE (watchers.watchable_id = 5 AND watchers.watchable_type = 'Board' AND (watchers.user_id = 2)) LIMIT 1

  Setting Load (0.000000)   SELECT * FROM settings WHERE (settings."name" = 'text_formatting') LIMIT 1

  Setting Load (0.000000)   SELECT * FROM settings WHERE (settings."name" = 'attachment_max_size') LIMIT 1

Rendered attachments/_form (0.04700)

Rendered messages/_form (0.11000)

  Setting Load (0.000000)   SELECT * FROM settings WHERE (settings."name" = 'app_title') LIMIT 1

  Setting Load (0.000000)   SELECT * FROM settings WHERE (settings."name" = 'ui_theme') LIMIT 1

  SQL (0.000000)   select sqlite_version(*)

  SQL (0.016000)   SELECT count(DISTINCT members.id) AS count_all FROM members LEFT OUTER JOIN projects ON projects.id = members.project_id LEFT OUTER JOIN roles ON roles.id = members.role_id WHERE (members.user_id = 2 AND (projects.status=1)) 

  Project Load Including Associations (0.015000)   SELECT projects."id" AS t0_r0, projects."name" AS t0_r1, projects."description" AS t0_r2, projects."homepage" AS t0_r3, projects."is_public" AS t0_r4, projects."parent_id" AS t0_r5, projects."projects_count" AS t0_r6, projects."created_on" AS t0_r7, projects."updated_on" AS t0_r8, projects."identifier" AS t0_r9, projects."status" AS t0_r10, parents_projects."id" AS t1_r0, parents_projects."name" AS t1_r1, parents_projects."description" AS t1_r2, parents_projects."homepage" AS t1_r3, parents_projects."is_public" AS t1_r4, parents_projects."parent_id" AS t1_r5, parents_projects."projects_count" AS t1_r6, parents_projects."created_on" AS t1_r7, parents_projects."updated_on" AS t1_r8, parents_projects."identifier" AS t1_r9, parents_projects."status" AS t1_r10 FROM projects LEFT OUTER JOIN projects parents_projects ON parents_projects.id = projects.parent_id INNER JOIN members ON projects.id = members.project_id WHERE ((members.user_id = 2) AND ((projects.status=1))) 

Rendered layouts/_project_selector (0.06200)

  SQL (0.000000)   SELECT count(*) AS count_all FROM versions WHERE (versions.project_id = 6) 

  Wiki Load (0.000000)   SELECT * FROM wikis WHERE (wikis.project_id = 6) LIMIT 1

  SQL (0.000000)   SELECT count(*) AS count_all FROM boards WHERE (boards.project_id = 6) 

  Repository Load (0.000000)   SELECT * FROM repositories WHERE (repositories.project_id = 6) LIMIT 1

Completed in 2.89000 (0 reqs/sec) | Rendering: 0.82900 (28%) | DB: 0.16900 (5%) | 200 OK [http://blgwiki.ptsi.corppt.com/projects/iaa-in-java/boards/show/5]