{"action":"closed","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/1556","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/1556/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/1556/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/1556/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/1556","id":280970666,"node_id":"MDU6SXNzdWUyODA5NzA2NjY=","number":1556,"title":"Exceeded slow_query limit (280.9 > 10) 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":"2017-12-11T10:45:51Z","updated_at":"2018-07-09T04:13:33Z","closed_at":"2018-07-09T04:13:33Z","author_association":"NONE","body":"        SELECT d.id, d.name AS original_name, d.created_date, d.updated_date, d.wins, d.losses, d.draws, d.finish, d.archetype_id, d.url AS source_url,\n            d.competition_id, c.name AS competition_name, c.end_date AS competition_end_date, ct.name AS competition_type_name, d.identifier,\n            LOWER(IFNULL(IFNULL(IFNULL(p.name, p.mtgo_username), p.mtggoldfish_username), p.tappedout_username)) AS person, p.id AS person_id,\n            d.created_date AS `date`, d.decklist_hash, d.retired,\n            s.name AS source_name, IFNULL(a.name, '') AS archetype_name,\n            cache.normalized_name AS name, cache.colors, cache.colored_symbols, cache.legal_formats\n        FROM deck AS d\n        LEFT JOIN person AS p ON d.person_id = p.id\n        LEFT JOIN competition AS c ON d.competition_id = c.id\n        LEFT JOIN source AS s ON d.source_id = s.id\n        LEFT JOIN archetype AS a ON d.archetype_id = a.id\n        LEFT JOIN deck AS opp ON opp.id IN (SELECT deck_id FROM deck_match WHERE deck_id <> d.id AND match_id IN (SELECT match_id FROM deck_match WHERE deck_id = d.id))\n        LEFT JOIN competition_type AS ct ON ct.id = c.competition_type_id\n        LEFT JOIN deck_cache AS cache ON d.id = cache.deck_id\n        WHERE d.id IN (SELECT deck_id FROM deck_card WHERE card IN ('Avacyn''s Pilgrim', 'Rofellos, Llanowar Emissary', 'Stampeding Serow', 'Wolfbriar Elemental', 'Acidic Slime', 'Mistcutter Hydra', 'Benefactor''s Draught', 'Nature''s Lore', 'Nostalgic Dreams', 'Chariot of Victory', 'Nissa''s Pilgrimage', 'Harmonize', 'Postmortem Lunge', 'Wildest Dreams'))\n        GROUP BY d.id\n        ORDER BY d.created_date DESC, IFNULL(d.finish, 9999999999)\n        \n    ; [] (slow_query, 280.9, mysql)\n\nReported on mysql by perf\n--------------------------------------------------------------------------------\nRequest Method: GET\nPath: /decks/2653/?\nCookies: {}\nEndpoint: decks\nView Args: {'deck_id': '2653'}\nPerson: logged_out\nUser-Agent: Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)\nReferrer: None\n"}}
{"actor":{"display_login":"stale"}}