{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/9004","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/9004/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/9004/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/9004/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/9004","id":288379606,"node_id":"MDU6SXNzdWUyODgzNzk2MDY=","number":9004,"title":"Exceeded slow_query limit (6.2 > 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-14T03:34:14Z","updated_at":"2018-07-19T03:06:05Z","closed_at":"2018-07-19T03:06:05Z","author_association":"NONE","body":"        SELECT\n            d.id,\n            d.name AS original_name,\n            d.created_date,\n            d.updated_date,\n            SUM(CASE WHEN dm.games > IFNULL(odm.games, 0) THEN 1 ELSE 0 END) AS wins,\n            SUM(CASE WHEN dm.games < odm.games THEN 1 ELSE 0 END) AS losses,\n            SUM(CASE WHEN dm.games = odm.games THEN 1 ELSE 0 END) AS draws,\n            d.finish,\n            d.archetype_id,\n            d.url AS source_url,\n            d.competition_id,\n            c.name AS competition_name,\n            c.end_date AS competition_end_date,\n            ct.name AS competition_type_name,\n            d.identifier,\n            LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person,\n            p.id AS person_id,\n            p.banned,\n            p.discord_id,\n            d.created_date AS `date`,\n            d.decklist_hash,\n            d.retired,\n            s.name AS source_name,\n            IFNULL(a.name, '') AS archetype_name,\n            cache.normalized_name AS name,\n            cache.colors,\n            cache.colored_symbols,\n            cache.legal_formats\n        FROM\n            deck AS d\n        LEFT JOIN\n            person AS p ON d.person_id = p.id\n        LEFT JOIN\n            source AS s ON d.source_id = s.id\n        LEFT JOIN\n            archetype AS a ON d.archetype_id = a.id\n        \n        LEFT JOIN\n            competition AS c ON d.competition_id = c.id\n        LEFT JOIN\n            competition_series AS cs ON cs.id = c.competition_series_id\n        LEFT JOIN\n            competition_type AS ct ON ct.id = cs.competition_type_id\n    \n        LEFT JOIN\n            deck_cache AS cache ON d.id = cache.deck_id\n        LEFT JOIN\n            deck_match AS dm ON d.id = dm.deck_id\n        LEFT JOIN\n            deck_match AS odm ON odm.deck_id <> d.id AND dm.match_id = odm.match_id\n        WHERE\n            d.id = 2712\n        GROUP BY\n            d.id\n        ORDER BY\n            d.created_date DESC, IFNULL(d.finish, 9999999999)\n        \n    ; [] (slow_query, 6.2, mysql)\n\nReported on mysql by perf\n--------------------------------------------------------------------------------\nRequest Method: GET\nPath: /decks/2712/?\nCookies: {'_ga': 'GA1.2.1272360605.1515877405', '_gid': 'GA1.2.578365766.1515877405', '__cfduid': 'df9cf252821de4219a1ff9b0c03bca6351515877400'}\nEndpoint: deck\nView Args: {'deck_id': '2712'}\nPerson: logged_out\nUser-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/604.3.5 (KHTML, like Gecko) Version/11.0.1 Safari/604.3.5\nReferrer: https://pennydreadfulmagic.com/archetypes/83/\nRequest Data: {}\n"}}
{"actor":{"display_login":"stale"}}