{"action":"opened","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/2798","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/2798/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/2798/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/2798/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/2798","id":282074689,"number":2798,"title":"Exceeded slow_query limit (195.0 > 10) in mysql: ","user":{"login":"vorpal-buildbot","id":23072004,"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":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2017-12-14T11:52:06Z","updated_at":"2017-12-14T11:52:06Z","closed_at":null,"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 ('Orator of Ojutai', 'Icefall Regent', 'Sunscorch Regent', 'Keiga, the Tide Star', 'Pristine Skywise', 'Eternal Dragon', 'Ojutai, Soul of Winter', 'Nameless Inversion', 'Silumgar''s Scorn', 'Compulsive Research', 'Foul-Tongue Invocation', 'Consuming Vapors', 'Punish Ignorance', 'Silumgar''s Command', 'Dragonlord''s Prerogative', 'Arcane Sanctum', 'Cloudcrest Lake', 'Crumbling Necropolis', 'Grand Coliseum', 'Mystic Monastery', 'Sandsteppe Citadel'))\n        GROUP BY d.id\n        ORDER BY d.created_date DESC, IFNULL(d.finish, 9999999999)\n        \n    ; [] (slow_query, 195.0, mysql)\n\nReported on mysql by perf\n--------------------------------------------------------------------------------\nRequest Method: GET\nPath: /decks/4693/?\nCookies: {}\nEndpoint: deck\nView Args: {'deck_id': '4693'}\nPerson: logged_out\nUser-Agent: Mozilla/5.0 (compatible; AhrefsBot/5.2; +http://ahrefs.com/robot/)\nReferrer: None\n"}}
{"actor":{"display_login":"vorpal-buildbot"}}