API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 16th, 2015
358
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 24.31 KB | None | 0 0
raw download clone embed print report
  1. 2015.01.15 13:06:06 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT t.* FROM (SELECT ROW_NUMBER() OVER(ORDER BY [users].id) AS _row_num, * FROM [users] WHERE ([users].[id] = N'3')) AS t WHERE t._row_num BETWEEN 1 AND 1
  2. 2015.01.15 13:06:06 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [projects] WHERE ([projects].[id] = 69881)
  3. 2015.01.15 13:06:07 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 16ms Executed SQL: SELECT t.* FROM (SELECT ROW_NUMBER() OVER(ORDER BY [snapshots].id) AS _row_num, * FROM [snapshots] WHERE ([snapshots].[islast] = 1 AND [snapshots].[project_id] = N'69881')) AS t WHERE t._row_num BETWEEN 1 AND 1
  4. 2015.01.15 13:06:07 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [groups] INNER JOIN [groups_users] ON [groups].id = [groups_users].group_id WHERE ([groups_users].user_id = 3 )
  5. 2015.01.15 13:06:07 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM group_roles WHERE role='user' and (group_id is null or group_id in(1,2)) and resource_id in (69881)
  6. 2015.01.15 13:06:07 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM user_roles WHERE role='user' and user_id=3 and resource_id in (69881)
  7. 2015.01.15 13:06:07 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT t.* FROM (SELECT ROW_NUMBER() OVER(ORDER BY [dashboards].id) AS _row_num, * FROM [dashboards] WHERE (id=N'12' AND user_id=N'3')) AS t WHERE t._row_num BETWEEN 1 AND 1
  8. 2015.01.15 13:06:07 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [widgets] WHERE ([widgets].dashboard_id = 12)
  9. 2015.01.15 13:06:07 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT [widget_properties].* FROM [widget_properties] WHERE ([widget_properties].widget_id IN (N'119',N'120',N'121',N'122',N'123',N'124',N'125',N'126',N'127',N'129',N'130',N'131',N'132',N'134',N'137'))
  10. 2015.01.15 13:06:07 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [project_measures] WHERE ([project_measures].snapshot_id = 8475972 AND (rule_id IS NULL AND characteristic_id IS NULL AND person_id IS NULL))
  11. 2015.01.15 13:06:08 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 15ms Executed SQL: SELECT t.* FROM (SELECT ROW_NUMBER() OVER(ORDER BY snapshots.created_at ASC) AS _row_num, * FROM [snapshots] WHERE (snapshots.project_id=N'69881' AND snapshots.status=N'P' AND snapshots.scope=N'PRJ' AND snapshots.qualifier=N'TRK')) AS t WHERE t._row_num BETWEEN 1 AND 1
  12. 2015.01.15 13:06:08 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT [snapshots].[id] AS t0_r0, [snapshots].[created_at] AS t0_r1, [snapshots].[project_id] AS t0_r2, [snapshots].[parent_snapshot_id] AS t0_r3, [snapshots].[status] AS t0_r4, [snapshots].[islast] AS t0_r5, [snapshots].[scope] AS t0_r6, [snapshots].[qualifier] AS t0_r7, [snapshots].[root_snapshot_id] AS t0_r8, [snapshots].[version] AS t0_r9, [snapshots].[path] AS t0_r10, [snapshots].[depth] AS t0_r11, [snapshots].[root_project_id] AS t0_r12, [snapshots].[period1_mode] AS t0_r13, [snapshots].[period1_param] AS t0_r14, [snapshots].[period1_date] AS t0_r15, [snapshots].[period2_mode] AS t0_r16, [snapshots].[period2_param] AS t0_r17, [snapshots].[period2_date] AS t0_r18, [snapshots].[period3_mode] AS t0_r19, [snapshots].[period3_param] AS t0_r20, [snapshots].[period3_date] AS t0_r21, [snapshots].[period4_mode] AS t0_r22, [snapshots].[period4_param] AS t0_r23, [snapshots].[period4_date] AS t0_r24, [snapshots].[period5_mode] AS t0_r25, [snapshots].[period5_param] AS t0_r26, [snapshots].[period5_date] AS t0_r27, [snapshots].[build_date] AS t0_r28, [snapshots].[purge_status] AS t0_r29, [events].[id] AS t1_r0, [events].[name] AS t1_r1, [events].[resource_id] AS t1_r2, [events].[snapshot_id] AS t1_r3, [events].[category] AS t1_r4, [events].[event_date] AS t1_r5, [events].[created_at] AS t1_r6, [events].[description] AS t1_r7, [events].[event_data] AS t1_r8 FROM [snapshots] LEFT OUTER JOIN [events] ON events.snapshot_id = snapshots.id WHERE (snapshots.project_id=N'69881' AND snapshots.status=N'P' AND snapshots.scope=N'PRJ' AND snapshots.qualifier=N'TRK' AND events.snapshot_id=snapshots.id AND events.category='Version' AND snapshots.id NOT IN (N'6627698',N'8475972')) ORDER BY snapshots.created_at ASC
  13. 2015.01.15 13:06:09 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [project_measures] WHERE (snapshot_id IN (N'6627698',N'8121595',N'8303506',N'8428161',N'8475972') AND metric_id IN (N'36',N'14',N'16',N'185',N'52',N'79',N'53',N'181',N'182') AND rule_id IS NULL AND characteristic_id IS NULL AND person_id IS NULL)
  14. 2015.01.15 13:06:09 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [events] WHERE ([events].snapshot_id = 6627698) ORDER BY event_date DESC
  15. 2015.01.15 13:06:09 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [events] WHERE ([events].snapshot_id = 8475972) ORDER BY event_date DESC
  16. 2015.01.15 13:06:09 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM group_roles WHERE role='user' and (group_id is null or group_id in(1,2)) and resource_id in (69881)
  17. 2015.01.15 13:06:09 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 16ms Executed SQL: SELECT resource_id FROM user_roles WHERE role='user' and user_id=3 and resource_id in (69881)
  18. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 289ms Executed SQL: select top (?) i.id , i.issue_update_date as issueUpdateDate from issues i inner join ( select s.project_id from snapshots s, ( select project_components.id as id, snapshot_components.id as sid, root_snapshot_components.project_id as root_project_id, root_snapshot_components.id as root_snapshot_id, snapshot_components.path as path from projects project_components inner join snapshots snapshot_components on snapshot_components.project_id = project_components.id and snapshot_components.islast = 1 inner join snapshots root_snapshot_components on root_snapshot_components.project_id = snapshot_components.root_project_id and root_snapshot_components.islast = 1 inner join ( SELECT p.id as root_project_id FROM group_roles gr INNER JOIN projects p on p.id = gr.resource_id AND p.scope = 'PRJ' AND p.qualifier = 'TRK' WHERE gr.role=? and (gr.group_id is null or gr.group_id in (select gu.group_id from groups_users gu where gu.user_id=?)) UNION SELECT p.id as root_project_id FROM user_roles ur INNER JOIN projects p on p.id = ur.resource_id AND p.scope = 'PRJ' AND p.qualifier = 'TRK' WHERE ur.role=? and ur.user_id = ? ) authorized_projects on authorized_projects.root_project_id = root_snapshot_components.project_id WHERE ( project_components.kee=?) and project_components.enabled = 1 ) authorized_input_components WHERE s.root_project_id = authorized_input_components.root_project_id and s.islast = 1 and ( (s.root_snapshot_id = authorized_input_components.root_snapshot_id and s.path LIKE authorized_input_components.path + CAST(authorized_input_components.sid AS varchar(15)) + '.%' ) or (s.id = authorized_input_components.sid) ) ) authorizedComponents on authorizedComponents.project_id=i.component_id WHERE (i.resolution=? ) - parameters are: <10000>, <user>, <3>, <user>, <3>, <no.tine:reku>, <FALSE-POSITIVE>
  19. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select i.id, i.kee as kee, i.component_id as componentId, i.root_component_id as rootComponentId, i.rule_id as ruleId, i.action_plan_key as actionPlanKey, i.severity as severity, i.manual_severity as manualSeverity, i.message as message, i.line as line, i.effort_to_fix as effortToFix, i.technical_debt as debt, i.status as status, i.resolution as resolution, i.checksum as checksum, i.reporter as reporter, i.assignee as assignee, i.author_login as authorLogin, i.issue_attributes as issueAttributes, i.issue_creation_date as issueCreationDate, i.issue_update_date as issueUpdateDate, i.issue_close_date as issueCloseDate, i.created_at as createdAt, i.updated_at as updatedAt, r.plugin_rule_key as ruleKey, r.plugin_name as ruleRepo, p.kee as componentKey, root.kee as rootComponentKey from issues i inner join rules r on r.id=i.rule_id inner join projects p on p.id=i.component_id inner join projects root on root.id=i.root_component_id where i.id in ( ? , ? , ? , ? , ? ) - parameters are: <144275>, <144274>, <144276>, <144286>, <144258>
  20. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select c.id, c.kee as kee, c.issue_key as issueKey, c.user_login as userLogin, c.change_type as changeType, c.change_data as changeData, c.created_at as createdAt, c.updated_at as updatedAt, c.issue_change_creation_date as issueChangeCreationDate from issue_changes c where c.change_type=? and c.issue_key in ( ? , ? , ? , ? , ? ) order by c.created_at - parameters are: <comment>, <8eecca4e-7189-4de8-9216-468fe7f761c6>, <98ccce01-251b-43b8-9601-050a10471f76>, <58415900-02d9-455c-8698-05275f4e19ef>, <e827a513-58f6-4c3b-8caa-3b36902a4381>, <53f8dff5-da6b-47ca-98b5-8bd625353ead>
  21. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select p.id, p.kee as kee, p.name as name, p.long_name as longName, p.qualifier as qualifier, s.root_project_id as projectId, p.root_id as subProjectId, p.path as path from projects p inner join snapshots s on s.project_id=p.id and s.islast=1 WHERE p.enabled=1 and p.id in ( ? , ? , ? , ? ) - parameters are: <70465>, <73765>, <89274>, <71133>
  22. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select p.id, p.kee as kee, p.name as name, p.long_name as longName, p.qualifier as qualifier, s.root_project_id as projectId, p.root_id as subProjectId, p.path as path from projects p inner join snapshots s on s.project_id=p.id and s.islast=1 WHERE p.enabled=1 and p.id in ( ? , ? , ? , ? ) - parameters are: <58096>, <69892>, <69883>, <54431>
  23. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select p.id, p.kee as kee, p.name as name, p.long_name as longName, p.qualifier as qualifier, s.root_project_id as projectId, p.root_id as subProjectId, p.path as path from projects p inner join snapshots s on s.project_id=p.id and s.islast=1 WHERE p.enabled=1 and p.id in ( ? ) - parameters are: <69881>
  24. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[search] 16ms ES Request: {
  25. "size" : 100,
  26. "query" : {
  27. "terms" : {
  28. "id" : [ 1746 ]
  29. }
  30. }
  31. }
  32. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[search] 0ms ES Request: org.elasticsearch.action.search.SearchScrollRequestBuilder@2b641643
  33. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[search] 0ms ES Request: org.elasticsearch.action.search.SearchScrollRequestBuilder@4b7ba74a
  34. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select ap.id, ap.kee as kee, ap.name as name, ap.description as description, ap.user_login as userLogin, ap.project_id as projectId, ap.status as status, ap.deadline as deadLine, ap.created_at as createdAt, ap.updated_at as updatedAt, p.kee as projectKey from action_plans ap, projects p WHERE ap.kee in ( ? ) and ap.project_id=p.id - parameters are: <0>
  35. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 157ms Executed SQL: SELECT i.assignee FROM issues i inner join ( select s.project_id from snapshots s, ( select project_components.id as id, snapshot_components.id as sid, root_snapshot_components.project_id as root_project_id, root_snapshot_components.id as root_snapshot_id, snapshot_components.path as path from projects project_components inner join snapshots snapshot_components on snapshot_components.project_id = project_components.id and snapshot_components.islast = 1 inner join snapshots root_snapshot_components on root_snapshot_components.project_id = snapshot_components.root_project_id and root_snapshot_components.islast = 1 inner join ( SELECT p.id as root_project_id FROM group_roles gr INNER JOIN projects p on p.id = gr.resource_id AND p.scope = 'PRJ' AND p.qualifier = 'TRK' WHERE gr.role=? and (gr.group_id is null or gr.group_id in (select gu.group_id from groups_users gu where gu.user_id=?)) UNION SELECT p.id as root_project_id FROM user_roles ur INNER JOIN projects p on p.id = ur.resource_id AND p.scope = 'PRJ' AND p.qualifier = 'TRK' WHERE ur.role=? and ur.user_id = ? ) authorized_projects on authorized_projects.root_project_id = root_snapshot_components.project_id WHERE ( project_components.kee=?) and project_components.enabled = 1 ) authorized_input_components WHERE s.root_project_id = authorized_input_components.root_project_id and s.islast = 1 and ( (s.root_snapshot_id = authorized_input_components.root_snapshot_id and s.path LIKE authorized_input_components.path + CAST(authorized_input_components.sid AS varchar(15)) + '.%' ) or (s.id = authorized_input_components.sid) ) ) authorizedComponents on authorizedComponents.project_id=i.component_id WHERE i.resolution is null - parameters are: <user>, <3>, <user>, <3>, <no.tine:reku>
  36. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT u.id as id, u.login as login, u.name as name, u.email as email, u.created_at as "createdAt", u.updated_at as "updatedAt", u.active as "active" FROM users u WHERE ( ( u.login=? or u.login=? or u.login=? or u.login=? or u.login=? or u.login=? or u.login=? or u.login=? or u.login=? ) ) - parameters are: <konwaslen>, <vikmik>, <engrun>, <KONHAATOR>, <KONGRATHO>, <konmidkje>, <nygron>, <konloumar>, <konbietor>
  37. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM group_roles WHERE role='user' and (group_id is null or group_id in(1,2)) and resource_id in (69881)
  38. 2015.01.15 13:06:10 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM user_roles WHERE role='user' and user_id=3 and resource_id in (69881)
  39. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 265ms Executed SQL: select top (?) i.id , i.issue_update_date as issueUpdateDate from issues i inner join ( select s.project_id from snapshots s, ( select project_components.id as id, snapshot_components.id as sid, root_snapshot_components.project_id as root_project_id, root_snapshot_components.id as root_snapshot_id, snapshot_components.path as path from projects project_components inner join snapshots snapshot_components on snapshot_components.project_id = project_components.id and snapshot_components.islast = 1 inner join snapshots root_snapshot_components on root_snapshot_components.project_id = snapshot_components.root_project_id and root_snapshot_components.islast = 1 inner join ( SELECT p.id as root_project_id FROM group_roles gr INNER JOIN projects p on p.id = gr.resource_id AND p.scope = 'PRJ' AND p.qualifier = 'TRK' WHERE gr.role=? and (gr.group_id is null or gr.group_id in (select gu.group_id from groups_users gu where gu.user_id=?)) UNION SELECT p.id as root_project_id FROM user_roles ur INNER JOIN projects p on p.id = ur.resource_id AND p.scope = 'PRJ' AND p.qualifier = 'TRK' WHERE ur.role=? and ur.user_id = ? ) authorized_projects on authorized_projects.root_project_id = root_snapshot_components.project_id WHERE ( project_components.kee=?) and project_components.enabled = 1 ) authorized_input_components WHERE s.root_project_id = authorized_input_components.root_project_id and s.islast = 1 and ( (s.root_snapshot_id = authorized_input_components.root_snapshot_id and s.path LIKE authorized_input_components.path + CAST(authorized_input_components.sid AS varchar(15)) + '.%' ) or (s.id = authorized_input_components.sid) ) ) authorizedComponents on authorizedComponents.project_id=i.component_id WHERE i.resolution is null and (i.assignee=? ) - parameters are: <10000>, <user>, <3>, <user>, <3>, <no.tine:reku>, <engrun>
  40. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 31ms Executed SQL: select i.id, i.kee as kee, i.component_id as componentId, i.root_component_id as rootComponentId, i.rule_id as ruleId, i.action_plan_key as actionPlanKey, i.severity as severity, i.manual_severity as manualSeverity, i.message as message, i.line as line, i.effort_to_fix as effortToFix, i.technical_debt as debt, i.status as status, i.resolution as resolution, i.checksum as checksum, i.reporter as reporter, i.assignee as assignee, i.author_login as authorLogin, i.issue_attributes as issueAttributes, i.issue_creation_date as issueCreationDate, i.issue_update_date as issueUpdateDate, i.issue_close_date as issueCloseDate, i.created_at as createdAt, i.updated_at as updatedAt, r.plugin_rule_key as ruleKey, r.plugin_name as ruleRepo, p.kee as componentKey, root.kee as rootComponentKey from issues i inner join rules r on r.id=i.rule_id inner join projects p on p.id=i.component_id inner join projects root on root.id=i.root_component_id where i.id in ( ? , ? , ? , ? , ? ) - parameters are: <138586>, <138587>, <139820>, <139821>, <139822>
  41. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select c.id, c.kee as kee, c.issue_key as issueKey, c.user_login as userLogin, c.change_type as changeType, c.change_data as changeData, c.created_at as createdAt, c.updated_at as updatedAt, c.issue_change_creation_date as issueChangeCreationDate from issue_changes c where c.change_type=? and c.issue_key in ( ? , ? , ? , ? , ? ) order by c.created_at - parameters are: <comment>, <9bcf140c-008a-4ecf-bb11-69a1a89123d3>, <b54d1d6e-73b6-485f-be91-29b2c47bfaec>, <25c6f791-6504-4cd3-816e-ae50a2be4629>, <8a7a14de-1738-45f6-95e1-98277e1f6d02>, <313d3d80-e524-48c8-ada2-073a57bcc32e>
  42. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 32ms Executed SQL: select p.id, p.kee as kee, p.name as name, p.long_name as longName, p.qualifier as qualifier, s.root_project_id as projectId, p.root_id as subProjectId, p.path as path from projects p inner join snapshots s on s.project_id=p.id and s.islast=1 WHERE p.enabled=1 and p.id in ( ? , ? , ? , ? ) - parameters are: <71645>, <90141>, <90143>, <90142>
  43. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select p.id, p.kee as kee, p.name as name, p.long_name as longName, p.qualifier as qualifier, s.root_project_id as projectId, p.root_id as subProjectId, p.path as path from projects p inner join snapshots s on s.project_id=p.id and s.islast=1 WHERE p.enabled=1 and p.id in ( ? , ? ) - parameters are: <54425>, <54431>
  44. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select p.id, p.kee as kee, p.name as name, p.long_name as longName, p.qualifier as qualifier, s.root_project_id as projectId, p.root_id as subProjectId, p.path as path from projects p inner join snapshots s on s.project_id=p.id and s.islast=1 WHERE p.enabled=1 and p.id in ( ? ) - parameters are: <69881>
  45. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[search] 0ms ES Request: {
  46. "size" : 100,
  47. "query" : {
  48. "terms" : {
  49. "id" : [ 1718, 87 ]
  50. }
  51. }
  52. }
  53. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[search] 15ms ES Request: org.elasticsearch.action.search.SearchScrollRequestBuilder@9bda529
  54. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[search] 0ms ES Request: org.elasticsearch.action.search.SearchScrollRequestBuilder@bd2766a
  55. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select ap.id, ap.kee as kee, ap.name as name, ap.description as description, ap.user_login as userLogin, ap.project_id as projectId, ap.status as status, ap.deadline as deadLine, ap.created_at as createdAt, ap.updated_at as updatedAt, p.kee as projectKey from action_plans ap, projects p WHERE ap.kee in ( ? ) and ap.project_id=p.id - parameters are: <0>
  56. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT u.id as id, u.login as login, u.name as name, u.email as email, u.created_at as "createdAt", u.updated_at as "updatedAt", u.active as "active" FROM users u WHERE ( ( u.login=? ) ) - parameters are: <engrun>
  57. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [project_measures] WHERE ([project_measures].snapshot_id = 8475972 AND (rule_id IS NOT NULL AND characteristic_id IS NULL AND person_id IS NULL))
  58. 2015.01.15 13:06:11 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [rules] WHERE ([rules].[id] IN (N'87',N'1723',N'1746',N'1760',N'1763',N'66',N'72',N'26',N'1159',N'1119',N'1152',N'762',N'776',N'1005',N'968',N'944',N'918',N'942',N'760',N'1209',N'1307',N'758',N'1358',N'1349',N'1342',N'1338',N'1365',N'1362',N'1353',N'1375',N'1340',N'1414',N'1332',N'1343',N'1359',N'1290',N'1718',N'1310',N'1306',N'1489',N'1325',N'1327',N'1364',N'1393',N'1390',N'1396',N'1398',N'1288',N'1287',N'1415',N'1486',N'1487',N'1488',N'1724',N'1745',N'1319',N'752',N'756',N'1285',N'82',N'808',N'1457',N'993',N'929',N'1145',N'1125',N'1149',N'799',N'1326',N'1291',N'1311',N'1725',N'1328',N'1212',N'1208',N'1346',N'1344',N'1350'))
  59. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 32ms Executed SQL: SELECT t.* FROM (SELECT ROW_NUMBER() OVER(ORDER BY project_measures.value DESC) AS _row_num, [project_measures].* FROM [project_measures] INNER JOIN [snapshots] ON [snapshots].id = [project_measures].snapshot_id WHERE (snapshots.qualifier in (N'CLA',N'UTS',N'FIL',N'UTS') AND snapshots.islast=1 AND snapshots.status = 'P' AND (snapshots.root_snapshot_id=N'8475972' AND snapshots.path LIKE N'8475972.%') AND project_measures.rule_id IS NULL AND project_measures.characteristic_id IS NULL AND project_measures.person_id IS NULL AND project_measures.metric_id = N'51')) AS t WHERE t._row_num BETWEEN 1 AND 5
  60. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [snapshots] WHERE ([snapshots].[id] IN (8477932,8477984,8477979,8477978,8477977))
  61. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [projects] WHERE ([projects].[id] IN (N'71601',N'90166',N'90183',N'90180',N'71645'))
  62. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: select c.id, c.kee as kee, c.name as name, c.parent_id as parentId, c.characteristic_order as characteristicOrder, c.enabled as enabled, c.created_at as createdAt, c.updated_at as updatedAt from characteristics c WHERE c.parent_id is null and c.enabled=1 order by characteristic_order asc
  63. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 16ms Executed SQL: SELECT * FROM [project_measures] WHERE (characteristic_id IN (N'2',N'15',N'181',N'372',N'419',N'496',N'578',N'961') AND snapshot_id=N'8475972' AND metric_id=N'185')
  64. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT role FROM [group_roles] WHERE (resource_id is null and (group_id is null or group_id in(N'1',N'2')))
  65. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [user_roles] WHERE ([user_roles].user_id = 3)
  66. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [properties] WHERE ([properties].user_id = 3)
  67. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM group_roles WHERE role='admin' and (group_id is null or group_id in(1,2)) and resource_id in (69881)
  68. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM user_roles WHERE role='admin' and user_id=3 and resource_id in (69881)
  69. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM group_roles WHERE role='admin' and (group_id is null or group_id in(1,2)) and resource_id in (69881)
  70. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT resource_id FROM user_roles WHERE role='admin' and user_id=3 and resource_id in (69881)
  71. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 16ms Executed SQL: SELECT * FROM [active_dashboards] WHERE ([active_dashboards].[user_id] = N'3') ORDER BY order_index
  72. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[sql] 0ms Executed SQL: SELECT * FROM [dashboards] WHERE ([dashboards].[id] IN (N'3',N'12',N'4',N'2',N'1',N'10',N'11',N'6',N'7',N'8',N'9'))
  73. 2015.01.15 13:06:12 INFO http-bio-10.230.49.59-9000-exec-5 web[http] 5774ms GET /sonar/dashboard/index/69881?did=12
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!