{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/6365","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/6365/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/6365/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/6365/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/6365","id":286034717,"node_id":"MDU6SXNzdWUyODYwMzQ3MTc=","number":6365,"title":"Exceeded slow_query limit (8.3 > 5) 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":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-01-04T16:11:08Z","updated_at":"2018-07-14T18:01:32Z","closed_at":"2018-07-14T18:01:32Z","author_association":"NONE","body":"        SELECT\n            d.id,\n            SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) AS opp_wins,\n            SUM(CASE WHEN dm.games < odm.games THEN 1 ELSE 0 END) AS opp_losses,\n            SUM(CASE WHEN dm.games = odm.games THEN 1 ELSE 0 END) AS opp_draws,\n            ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw,\n            IFNULL(MIN(CASE WHEN m.elimination > 0 THEN m.elimination END), 0) AS stage_reached,\n            GROUP_CONCAT(m.elimination) AS elim\n        FROM\n            deck AS d\n        LEFT JOIN\n            deck AS od\n        ON od.id IN (\n            SELECT\n                deck_id\n            FROM\n                deck_match\n            WHERE\n                deck_id <> d.id\n            AND\n                match_id IN (\n                    SELECT\n                        match_id\n                    FROM\n                        deck_match\n                    WHERE\n                        deck_id = d.id\n                )\n            )\n        LEFT JOIN\n            deck_match AS dm ON od.id = dm.deck_id\n        LEFT JOIN\n            deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> od.id\n        LEFT JOIN\n            `match` AS m ON m.id = dm.match_id\n        WHERE\n            d.id IN (6850, 6401, 5451, 3872, 3746, 3640, 3569, 3458, 3437, 3433, 2485, 2478, 2716, 1715)\n        GROUP BY\n            d.id\n    ; [] (slow_query, 8.3, mysql)\n\nReported on mysql by perf\n--------------------------------------------------------------------------------\nRequest Method: GET\nPath: /cards/Siege Modification/?\nCookies: {}\nEndpoint: card\nView Args: {'name': 'Siege Modification'}\nPerson: logged_out\nUser-Agent: Mozilla/5.0 (compatible; bingbot/2.0; +http://www.bing.com/bingbot.htm)\nReferrer: None\n"}}
{"actor":{"display_login":"stale"}}