{"action":"created","issue":{"url":"https://api.github.com/repos/os-autoinst/openQA/issues/133","labels_url":"https://api.github.com/repos/os-autoinst/openQA/issues/133/labels{/name}","comments_url":"https://api.github.com/repos/os-autoinst/openQA/issues/133/comments","events_url":"https://api.github.com/repos/os-autoinst/openQA/issues/133/events","html_url":"https://github.com/os-autoinst/openQA/pull/133","id":54438150,"number":133,"title":"enabled dbix profiling for sql debugging","user":{"login":"nilxam","id":417859,"avatar_url":"https://avatars.githubusercontent.com/u/417859?v=3","gravatar_id":"","url":"https://api.github.com/users/nilxam","html_url":"https://github.com/nilxam","followers_url":"https://api.github.com/users/nilxam/followers","following_url":"https://api.github.com/users/nilxam/following{/other_user}","gists_url":"https://api.github.com/users/nilxam/gists{/gist_id}","starred_url":"https://api.github.com/users/nilxam/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/nilxam/subscriptions","organizations_url":"https://api.github.com/users/nilxam/orgs","repos_url":"https://api.github.com/users/nilxam/repos","events_url":"https://api.github.com/users/nilxam/events{/privacy}","received_events_url":"https://api.github.com/users/nilxam/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":3,"created_at":"2015-01-15T11:19:16Z","updated_at":"2015-01-15T12:48:13Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/os-autoinst/openQA/pulls/133","html_url":"https://github.com/os-autoinst/openQA/pull/133","diff_url":"https://github.com/os-autoinst/openQA/pull/133.diff","patch_url":"https://github.com/os-autoinst/openQA/pull/133.patch"},"body":"the output like below\r\n\r\n[DBIx debug] Took 0.00005913 seconds executed: SELECT me.id, me.name FROM dependencies me WHERE ( name = ? ): 'chained'.\r\n[DBIx debug] Took 0.00006008 seconds executed: SELECT me.id, me.name FROM job_states me WHERE ( name = ? ): 'done'.\r\n[DBIx debug] Took 0.00005889 seconds executed: SELECT me.id, me.name FROM job_results me WHERE ( name = ? ): 'passed'.\r\n[DBIx debug] Took 0.00006008 seconds executed: SELECT me.id, me.host, me.instance, me.backend, me.t_created, me.t_updated FROM workers me WHERE ( me.id = ? ): '1'.\r\n[DBIx debug] Took 0.00006199 seconds executed: SELECT me.id, me.key, me.value, me.worker_id, me.t_created, me.t_updated FROM worker_properties me WHERE ( worker_id = ? ): '1'.\r\n[DBIx debug] Took 0.00005603 seconds executed: SELECT me.id, me.name FROM job_states me WHERE ( name = ? ): 'scheduled'.\r\n[DBIx debug] Took 0.00005984 seconds executed: SELECT me.id, me.name FROM job_states me WHERE ( name = ? ): 'running'.\r\n[DBIx debug] Took 0.00054908 seconds executed: UPDATE jobs SET state_id = ?, t_started = ?, worker_id = ? WHERE ( id IN ( SELECT me.id FROM jobs me WHERE ( ( ( id IN ( SELECT me.job_id FROM job_settings me WHERE ( ( key = ? AND ( value = ? OR value = ? OR value = ? ) ) ) ) AND id NOT IN ( SELECT me.child_job_id FROM job_dependencies me  JOIN jobs parent ON parent.id = me.parent_job_id WHERE ( ( ( result_id != ? OR state_id != ? ) AND dep_id = ? ) ) ) ) AND state_id = ? AND worker_id = ? ) ) ORDER BY priority ASC, id ASC LIMIT ? ) ): '1', '2015-01-15T11:12:23', '1', 'ARCH', 'x86_64', 'i586', 'i686', '1', '4', '0', '0', '0', '1'.\r\n"},"comment":{"url":"https://api.github.com/repos/os-autoinst/openQA/issues/comments/70080802","html_url":"https://github.com/os-autoinst/openQA/pull/133#issuecomment-70080802","issue_url":"https://api.github.com/repos/os-autoinst/openQA/issues/133","id":70080802,"user":{"login":"coolo","id":1067203,"avatar_url":"https://avatars.githubusercontent.com/u/1067203?v=3","gravatar_id":"","url":"https://api.github.com/users/coolo","html_url":"https://github.com/coolo","followers_url":"https://api.github.com/users/coolo/followers","following_url":"https://api.github.com/users/coolo/following{/other_user}","gists_url":"https://api.github.com/users/coolo/gists{/gist_id}","starred_url":"https://api.github.com/users/coolo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/coolo/subscriptions","organizations_url":"https://api.github.com/users/coolo/orgs","repos_url":"https://api.github.com/users/coolo/repos","events_url":"https://api.github.com/users/coolo/events{/privacy}","received_events_url":"https://api.github.com/users/coolo/received_events","type":"User","site_admin":false},"created_at":"2015-01-15T12:48:13Z","updated_at":"2015-01-15T12:48:13Z","body":"environment variables are ugly  - especially as they are rather hard to get into the systemd unit without polluting yet another file with options not belonging there :)\r\n\r\nBut I would go for 2 or 3 too instead of this rather hacky approach"}}