{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/41209","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/41209/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/41209/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/41209/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/41209","id":373937549,"node_id":"MDU6SXNzdWUzNzM5Mzc1NDk=","number":41209,"title":"Exceeded slow_query limit (1.2 > 1.0) in mysql: ```","user":{"login":"vorpal-buildbot","id":23072004,"node_id":"MDQ6VXNlcjIzMDcyMDA0","avatar_url":"https://avatars2.githubusercontent.com/u/23072004?v=4","gravatar_id":"","url":"https://api.github.com/users/vorpal-buildbot","html_url":"https://github.com/vorpal-buildbot","followers_url":"https://api.github.com/users/vorpal-buildbot/followers","following_url":"https://api.github.com/users/vorpal-buildbot/following{/other_user}","gists_url":"https://api.github.com/users/vorpal-buildbot/gists{/gist_id}","starred_url":"https://api.github.com/users/vorpal-buildbot/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/vorpal-buildbot/subscriptions","organizations_url":"https://api.github.com/users/vorpal-buildbot/orgs","repos_url":"https://api.github.com/users/vorpal-buildbot/repos","events_url":"https://api.github.com/users/vorpal-buildbot/events{/privacy}","received_events_url":"https://api.github.com/users/vorpal-buildbot/received_events","type":"User","site_admin":false},"labels":[{"id":958792189,"node_id":"MDU6TGFiZWw5NTg3OTIxODk=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/decksite","name":"decksite","color":"bfd4f2","default":false},{"id":763867617,"node_id":"MDU6TGFiZWw3NjM4Njc2MTc=","url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/labels/wontfix","name":"wontfix","color":"ffffff","default":true}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-10-25T13:05:59Z","updated_at":"2018-12-31T13:20:01Z","closed_at":"2018-12-31T13:20:01Z","author_association":"NONE","body":"        SELECT\n            GROUP_CONCAT(d.person_id) AS people,\n            GROUP_CONCAT(dm.games) AS games\n        FROM\n            `match` AS m\n        INNER JOIN\n            deck_match AS dm ON dm.match_id = m.id\n        INNER JOIN\n            deck AS d ON dm.deck_id = d.id\n        GROUP BY\n            m.id\n        ORDER BY\n            m.date,\n            `round`\n    ```\n\n```[]``` (slow_query, 1.2, mysql)\n\nReported on decksite by mysql-perf"}}
{"actor":{"display_login":"stale"}}