select b.id c0, b.title c1, b.body c2, b.resolution c3, b.reported_version c4, b.fixed_version c5, b.duplicate_of c6, b.cretime c7, b.updtime c8, b.user_logged_id c9, b.type_code c10
        , u.id c11, u.email c12, u.name c13, u.pwd c14, u.salt c15, u.last_login c16, u.cookie_login c17, u.error_count c18, u.reset_code c19, u.reset_time c20, u.cretime c21, u.updtime c22, u.status_code c23
        , p.id c24, p.name c25
        , c.code c26, c.title c27, c.sort_order c28
        , s.code c29, s.title c30
        , e.id c31, e.title c32, e.post_date c33, e.body c34, e.cretime c35, e.updtime c36, e.user_id c37, e.bug_id c38 
from b_bug b
left outer join s_user u on b.user_assigned_id = u.id 
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_status s on b.status_code = s.code 
left outer join b_bug_detail e on b.id = e.bug_id  
where b.status_code in (?,?) and b.type_code in (?) 
order by u.name desc , b.id, e.id asc

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 09:56
Origin key: -1305179324:-880739087 app.comp.TopBugs.findList(TopBugs.java:44)

select b.id c0, b.updtime c1, b.title c2, b.type_code c3
        , p.id c4, p.updtime c5
        , c.code c6, c.title c7
        , s.code c8, s.title c9
        , e.id c10, e.updtime c11 
from b_bug b
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_status s on b.status_code = s.code 
left outer join b_bug_detail e on b.id = e.bug_id 
left outer join s_user u on b.user_assigned_id = u.id  
where b.status_code in (?,?) and b.type_code in (?) 
order by u.name desc , b.id, e.id asc

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 11:43
Origin key: -1305179324:-880739087 app.comp.TopBugs.findList(TopBugs.java:44)

select b.id c0, b.title c1, b.body c2, b.resolution c3, b.reported_version c4, b.fixed_version c5, b.duplicate_of c6, b.cretime c7, b.updtime c8
        , u.id c9, u.email c10, u.name c11, u.pwd c12, u.salt c13, u.last_login c14, u.cookie_login c15, u.error_count c16, u.reset_code c17, u.reset_time c18, u.cretime c19, u.updtime c20, u.status_code c21
        , a.id c22, a.email c23, a.name c24, a.pwd c25, a.salt c26, a.last_login c27, a.cookie_login c28, a.error_count c29, a.reset_code c30, a.reset_time c31, a.cretime c32, a.updtime c33, a.status_code c34
        , p.id c35, p.name c36, p.sort_order c37, p.cretime c38, p.updtime c39
        , c.code c40, c.title c41, c.sort_order c42
        , t.code c43, t.title c44
        , s.code c45, s.title c46
        , e.id c47, e.title c48, e.post_date c49, e.body c50, e.cretime c51, e.updtime c52, e.bug_id c53
        , eu.id c54, eu.email c55, eu.name c56, eu.pwd c57, eu.salt c58, eu.last_login c59, eu.cookie_login c60, eu.error_count c61, eu.reset_code c62, eu.reset_time c63, eu.cretime c64, eu.updtime c65, eu.status_code c66 
from b_bug b
left outer join s_user u on b.user_assigned_id = u.id 
left outer join s_user a on b.user_logged_id = a.id 
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_type t on b.type_code = t.code 
join b_bug_status s on b.status_code = s.code 
left outer join b_bug_detail e on b.id = e.bug_id 
left outer join s_user eu on e.user_id = eu.id 
where b.id = ?   
order by b.id , e.id asc

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 10:03
Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)

select b.id c0, b.updtime c1, b.body c2, b.reported_version c3, b.fixed_version c4, b.title c5, b.user_assigned_id c6, b.cretime c7, b.duplicate_of c8
        , a.id c9, a.name c10, a.updtime c11
        , p.id c12, p.name c13, p.updtime c14
        , c.code c15, c.title c16
        , t.code c17, t.title c18
        , s.code c19, s.title c20
        , e.id c21, e.body c22, e.title c23, e.cretime c24, e.updtime c25
        , eu.id c26, eu.name c27, eu.updtime c28 
from b_bug b
left outer join s_user a on b.user_logged_id = a.id 
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_type t on b.type_code = t.code 
join b_bug_status s on b.status_code = s.code 
left outer join b_bug_detail e on b.id = e.bug_id 
left outer join s_user eu on e.user_id = eu.id 
where b.id = ?   
order by b.id , e.id asc

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 14:04
Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)

select b.id c0, b.updtime c1, b.body c2, b.reported_version c3, b.fixed_version c4, b.title c5, b.user_assigned_id c6, b.cretime c7, b.duplicate_of c8
        , a.id c9, a.name c10, a.updtime c11
        , p.id c12, p.name c13, p.updtime c14
        , c.code c15, c.title c16
        , t.code c17, t.title c18
        , s.code c19, s.title c20
        , e.id c21, e.body c22, e.title c23, e.cretime c24, e.user_id c25, e.updtime c26 
from b_bug b
left outer join s_user a on b.user_logged_id = a.id 
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_type t on b.type_code = t.code 
join b_bug_status s on b.status_code = s.code 
left outer join b_bug_detail e on b.id = e.bug_id 
where b.id = ?   
order by b.id , e.id asc

Autofetch Tuned: true
Started Collecting Statistics: 21-Nov 05:49
Origin key: -604475720:509217749 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)

select b.id c0, b.title c1, b.body c2, b.resolution c3, b.reported_version c4, b.fixed_version c5, b.duplicate_of c6, b.cretime c7, b.updtime c8, b.user_assigned_id c9, b.user_logged_id c10, b.product_id c11, b.priority_code c12, b.type_code c13, b.status_code c14 
from b_bug b
where b.id = ?  

Autofetch Tuned: true
Started Collecting Statistics: 24-Aug 04:46
Origin key: -604475720:982149000 app.comp.BugDetailComp.render(BugDetailComp.java:48)

select b.id c0, b.updtime c1, b.body c2, b.reported_version c3, b.fixed_version c4, b.title c5, b.user_assigned_id c6, b.cretime c7, b.duplicate_of c8
        , a.id c9, a.name c10, a.updtime c11
        , p.id c12, p.name c13, p.updtime c14
        , c.code c15, c.title c16
        , t.code c17, t.title c18
        , s.code c19, s.title c20
        , e.id c21, e.body c22, e.title c23, e.cretime c24, e.user_id c25, e.updtime c26 
from b_bug b
left outer join s_user a on b.user_logged_id = a.id 
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_type t on b.type_code = t.code 
join b_bug_status s on b.status_code = s.code 
left outer join b_bug_detail e on b.id = e.bug_id 
where b.id = ?   
order by b.id , e.id asc

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 12:25
Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)

select b.id c0, b.updtime c1, b.body c2, b.reported_version c3, b.fixed_version c4, b.title c5, b.user_assigned_id c6, b.cretime c7, b.duplicate_of c8
        , a.id c9, a.name c10, a.updtime c11
        , p.id c12, p.name c13, p.updtime c14
        , c.code c15, c.title c16
        , t.code c17, t.title c18
        , s.code c19, s.title c20 
from b_bug b
left outer join s_user a on b.user_logged_id = a.id 
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_type t on b.type_code = t.code 
join b_bug_status s on b.status_code = s.code 
where b.id = ?  

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 11:46
Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)

select b.id c0, b.title c1, b.body c2, b.resolution c3, b.reported_version c4, b.fixed_version c5, b.duplicate_of c6, b.cretime c7, b.updtime c8, b.type_code c9
        , u.id c10, u.email c11, u.name c12, u.pwd c13, u.salt c14, u.last_login c15, u.cookie_login c16, u.error_count c17, u.reset_code c18, u.reset_time c19, u.cretime c20, u.updtime c21, u.status_code c22
        , a.id c23, a.email c24, a.name c25, a.pwd c26, a.salt c27, a.last_login c28, a.cookie_login c29, a.error_count c30, a.reset_code c31, a.reset_time c32, a.cretime c33, a.updtime c34, a.status_code c35
        , p.id c36, p.name c37
        , c.code c38, c.title c39, c.sort_order c40
        , s.code c41, s.title c42 
from b_bug b
left outer join s_user u on b.user_assigned_id = u.id 
left outer join s_user a on b.user_logged_id = a.id 
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_status s on b.status_code = s.code  
where b.fixed_version like ? and b.type_code in ( ?, ? )  
order by b.id desc

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 09:56
Origin key: 993345720:-1061479707 app.comp.RecentBugs.findList(RecentBugs.java:40)

select b.id c0, b.updtime c1, b.title c2, b.type_code c3
        , a.id c4, a.updtime c5
        , p.id c6, p.updtime c7
        , c.code c8, c.title c9
        , s.code c10 
from b_bug b
left outer join s_user a on b.user_logged_id = a.id 
join b_product p on b.product_id = p.id 
join b_bug_priority c on b.priority_code = c.code 
join b_bug_status s on b.status_code = s.code  
where b.fixed_version like ? and b.type_code in ( ?, ? )  
order by b.id desc

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 11:43
Origin key: 993345720:-1061479707 app.comp.RecentBugs.findList(RecentBugs.java:40)

select a.id c0, a.file_name c1, a.file_path c2, a.abstract c3, a.file_size c4, a.cretime c5, a.updtime c6, a.bug_id c7 
from b_bug_attachment a 
where a.bug_id = ? 

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 10:03
Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)

select d.id c0, d.title c1, d.post_date c2, d.body c3, d.cretime c4, d.updtime c5, d.user_id c6, d.bug_id c7 
from b_bug_detail d 
where d.bug_id = ?  
order by d.id asc

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 11:46
Origin key: -604475720:-275561723 app.comp.init.BugDetailInit.initialise(BugDetailInit.java:36)

select f.id c0, f.title c1, f.topic_count c2, f.sort_order c3, f.cretime c4, f.updtime c5 
from f_forum f
where f.id = ?  

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 10:11
Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)

select f.id c0, f.title c1, f.topic_count c2, f.sort_order c3, f.cretime c4, f.updtime c5 
from f_forum f 
order by f.sort_order

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 10:12
Origin key: 887892902:154414995 app.comp.init.ForumListInit.initialise(ForumListInit.java:22)

select f.id c0, f.title c1, f.updtime c2 
from f_forum f 
order by f.sort_order

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 18:58
Origin key: 887892902:154414995 app.comp.init.ForumListInit.initialise(ForumListInit.java:22)

select f.id c0, f.title c1, f.topic_count c2, f.sort_order c3, f.cretime c4, f.updtime c5 
from f_forum f
where f.id = ?  

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 09:57
Origin key: 1908865224:1634510449 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:24)

select f.id c0, f.title c1, f.updtime c2 
from f_forum f
where f.id = ?  

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 10:19
Origin key: 1908865224:1634510449 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:24)

select t.id c0, t.open c1, t.title c2, t.body c3, t.editor_note c4, t.post_count c5, t.rating_count c6, t.rating_total c7, t.cretime c8, t.updtime c9, t.type_code c10, t.user_id c11, t.forum_id c12 
from f_topic t 
where t.forum_id = ?  
order by t.updtime desc 
limit 6

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 10:12
Origin key: -149309933:-865332634 app.comp.init.ForumListInit.initialise(ForumListInit.java:35)

select t.id c0, t.updtime c1, t.title c2, t.post_count c3 
from f_topic t 
where t.forum_id = ?  
order by t.updtime desc 
limit 6

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 18:58
Origin key: -149309933:-865332634 app.comp.init.ForumListInit.initialise(ForumListInit.java:35)

select t.id c0, t.open c1, t.title c2, t.body c3, t.editor_note c4, t.post_count c5, t.rating_count c6, t.rating_total c7, t.cretime c8, t.updtime c9, t.type_code c10, t.user_id c11, t.forum_id c12 
from f_topic t 
where t.forum_id = ?  
order by t.updtime desc 
limit 51

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 09:57
Origin key: 592257536:-202885630 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:39)

select t.id c0, t.updtime c1, t.title c2, t.post_count c3 
from f_topic t 
where t.forum_id = ?  
order by t.updtime desc 
limit 51

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 10:19
Origin key: 592257536:-202885630 app.comp.init.ForumDetailInit.initialise(ForumDetailInit.java:39)

select t.id c0, t.open c1, t.title c2, t.body c3, t.editor_note c4, t.post_count c5, t.rating_count c6, t.rating_total c7, t.cretime c8, t.updtime c9, t.type_code c10, t.forum_id c11
        , u.id c12, u.email c13, u.name c14, u.pwd c15, u.salt c16, u.last_login c17, u.cookie_login c18, u.error_count c19, u.reset_code c20, u.reset_time c21, u.cretime c22, u.updtime c23, u.status_code c24 
from f_topic t
join s_user u on t.user_id = u.id 

Autofetch Tuned: false
Started Collecting Statistics: 29-Jan 19:02
Origin key: 722531090:-1916500025 app.comp.init.TopicInit.initialise(TopicInit.java:25)

select t.id c0, t.open c1, t.title c2, t.body c3, t.editor_note c4, t.post_count c5, t.rating_count c6, t.rating_total c7, t.cretime c8, t.updtime c9, t.type_code c10, t.forum_id c11
        , u.id c12, u.email c13, u.name c14, u.pwd c15, u.salt c16, u.last_login c17, u.cookie_login c18, u.error_count c19, u.reset_code c20, u.reset_time c21, u.cretime c22, u.updtime c23, u.status_code c24 
from f_topic t
join s_user u on t.user_id = u.id 
where t.id = ?  

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 10:11
Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)

select t.id c0, t.body c1, t.forum_id c2, t.title c3, t.cretime c4, t.updtime c5
        , u.id c6, u.name c7, u.updtime c8
        , p.id c9, p.body c10, p.cretime c11, p.updtime c12
        , pu.id c13, pu.name c14, pu.updtime c15 
from f_topic t
join s_user u on t.user_id = u.id 
left outer join f_topic_post p on t.id = p.topic_id 
left outer join s_user pu on p.user_id = pu.id 
where t.id = ?   
order by t.id

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 10:19
Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)

select t.id c0, t.body c1, t.forum_id c2, t.title c3, t.cretime c4, t.updtime c5
        , u.id c6, u.name c7, u.updtime c8
        , p.id c9, p.body c10, p.cretime c11, p.user_id c12, p.updtime c13 
from f_topic t
join s_user u on t.user_id = u.id 
left outer join f_topic_post p on t.id = p.topic_id 
where t.id = ?   
order by t.id

Autofetch Tuned: true
Started Collecting Statistics: 11-Aug 11:09
Origin key: 722532051:-1657982302 app.comp.init.TopicInit.initialise(TopicInit.java:25)

select t.id c0, t.open c1, t.title c2, t.body c3, t.editor_note c4, t.post_count c5, t.rating_count c6, t.rating_total c7, t.cretime c8, t.updtime c9, t.type_code c10, t.user_id c11, t.forum_id c12 
from f_topic t
where t.id = ?  

Autofetch Tuned: false
Started Collecting Statistics: 12-Oct 10:05
Origin key: 1751618793:1750980254 app.data.Topic$$EntityBean$mysql.getForum(Topic.java:1)

select t.id c0, t.open c1, t.title c2, t.body c3, t.editor_note c4, t.post_count c5, t.rating_count c6, t.rating_total c7, t.cretime c8, t.updtime c9, t.type_code c10, t.user_id c11, t.forum_id c12 
from f_topic t
where t.id = ?  

Autofetch Tuned: true
Started Collecting Statistics: 12-Oct 10:05
Origin key: 1751618793:1750980254 app.data.Topic$$EntityBean$mysql.getForum(Topic.java:1)

select p.id c0, p.title c1, p.body c2, p.editor_note c3, p.cretime c4, p.updtime c5, p.parent_id c6, p.topic_id c7, p.user_id c8 
from f_topic_post p 
where p.topic_id = ? 

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 10:11
Origin key: 722532051:-1240757584 app.comp.init.TopicInit.initialise(TopicInit.java:25)

select u.id c0, u.email c1, u.name c2, u.pwd c3, u.salt c4, u.last_login c5, u.cookie_login c6, u.error_count c7, u.reset_code c8, u.reset_time c9, u.cretime c10, u.updtime c11, u.status_code c12 
from s_user u 
where lower(u.email) =? 

Autofetch Tuned: false
Started Collecting Statistics: 17-Aug 19:51
Origin key: 540431822:852069242 app.global.usercontext.UserManager.findUser(UserManager.java:239)

select u.id c0, u.email c1, u.name c2, u.pwd c3, u.salt c4, u.last_login c5, u.cookie_login c6, u.error_count c7, u.reset_code c8, u.reset_time c9, u.cretime c10, u.updtime c11, u.status_code c12 
from s_user u 
where lower(u.email) =? 

Autofetch Tuned: true
Started Collecting Statistics: 08-Sep 17:35
Origin key: 540431822:-1406529978 app.global.usercontext.UserManager.findUser(UserManager.java:239)

select u.id c0, u.last_login c1, u.pwd c2, u.name c3, u.status_code c4, u.error_count c5, u.salt c6, u.updtime c7 
from s_user u 
where lower(u.email) =? 

Autofetch Tuned: true
Started Collecting Statistics: 07-Sep 09:21
Origin key: 540431822:-1310677491 app.global.usercontext.UserManager.findUser(UserManager.java:239)

select u.id c0, u.email c1, u.name c2, u.pwd c3, u.salt c4, u.last_login c5, u.cookie_login c6, u.error_count c7, u.reset_code c8, u.reset_time c9, u.cretime c10, u.updtime c11, u.status_code c12 
from s_user u
where u.id = ?  

Autofetch Tuned: false
Started Collecting Statistics: 11-Aug 09:56
Origin key: 1932188223:-1245660067 app.global.usercontext.UserManager.loginAuto(UserManager.java:176)

select u.id c0, u.last_login c1, u.name c2, u.status_code c3, u.updtime c4 
from s_user u
where u.id = ?  

Autofetch Tuned: true
Started Collecting Statistics: 24-Aug 07:37
Origin key: 1932188223:-1612095406 app.global.usercontext.UserManager.loginAuto(UserManager.java:176)