MODIFY JAR file: find query => change it or find loop

Hello, I have java website solution - CentOS, PostgreSQL, Jetty & JAR file which make report very long ~5min In log files i found that one query runs few hundred times and takes 1s/time = 5+minutes 1. I need to find this query and try to optimize it - remove ordering 2. find out there loop is (in not helps 1.) Query: 2016-10-04 12:06:15,426 DEBUG [68447657-5] [login to view URL] - select datasets0_.column_id as column6_5_1_, [login to view URL] as id1_, [login to view URL] as id6_0_, datasets0_.changed_on as changed3_6_0_, datasets0_.created_on as created4_6_0_, datasets0_.column_id as column6_6_0_, [login to view URL] as single6_0_, datasets0_.employees_data_set as employees7_6_0_, datasets0_.users_data_set as users8_6_0_, datasets0_.experts_data_set as experts9_6_0_, datasets0_.members_data_set as members10_6_0_, datasets0_.variants_data_set as variants11_6_0_, datasets0_.departments_data_set as departm12_6_0_, datasets0_.positions_data_set as positions13_6_0_, [login to view URL] as type6_0_ from public.column_data_set datasets0_ where datasets0_.column_id=? order by [login to view URL] asc Java Decompiler attached if you need anything more do not hesitate to ask