{"action":"opened","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/24103","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/24103/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/24103/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/24103/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/24103","id":330991898,"node_id":"MDU6SXNzdWUzMzA5OTE4OTg=","number":24103,"title":"Exceeded slow_query limit (91.6 > 60.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":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-06-10T18:38:13Z","updated_at":"2018-06-10T18:38:13Z","closed_at":null,"author_association":"NONE","body":"        SELECT\n            card AS name\n        FROM\n            deck_card AS dc\n        INNER JOIN\n            deck AS d ON dc.deck_id = d.id\n        \n        LEFT JOIN\n            (\n        SELECT\n            `start`.id,\n            `start`.code,\n            `start`.start_date AS start_date,\n            `end`.start_date AS end_date\n        FROM\n            season AS `start`\n        LEFT JOIN\n            season AS `end` ON `end`.id = `start`.id + 1\n    ) AS season ON season.start_date <= d.created_date AND (season.end_date IS NULL OR season.end_date > d.created_date)\n    \n        WHERE\n            deck_id\n        IN\n            (\n                SELECT\n                    DISTINCT deck_id\n                FROM\n                    deck_match\n            ) -- Only include cards that actually got played competitively rather than just posted to Goldfish as \"new cards this season\" or similar.\n        AND\n            (TRUE)\n        GROUP BY\n            card\n        HAVING\n            COUNT(DISTINCT d.person_id) = 1\n        AND\n            MAX(d.person_id) = 1264 -- In MySQL 5.7+ this could/should be ANY_VALUE not MAX but this works with any version. The COUNT(DISTINCT  p.id) ensures this only has one possible value but MySQL can't work that out.-- In MySQL 5.7+ this could/should be ANY_VALUE not MAX but this works with any version. The COUNT(DISTINCT  p.id) ensures this only has one possible value but MySQL can't work that out.\n    ```\n\n```[]``` (slow_query, 91.6, mysql)\n\nReported on decksite by mysql-perf\n--------------------------------------------------------------------------------\nRequest Method: GET\nPath: /seasons/all/people/fskura/?\nCookies: {}\nEndpoint: seasons.person\nView Args: {'person_id': 'fskura'}\nPerson: logged_out\nReferrer: None\nRequest Data: {}\nHost: pennydreadfulmagic.com\nAccept-Encoding: gzip\nCf-Ipcountry: US\nX-Forwarded-For: 77.88.47.42, 162.158.238.162\nCf-Ray: 428df1b13bfd5b39-HEL\nX-Forwarded-Proto: https\nCf-Visitor: {\"scheme\":\"https\"}\nUser-Agent: Mozilla/5.0 (compatible; YandexBot/3.0; +http://yandex.com/bots)\nFrom: support@search.yandex.ru\nAccept: */*\nAccept-Language: en, *;q=0.01\nCf-Connecting-Ip: 77.88.47.42\nX-Forwarded-Host: pennydreadfulmagic.com\nX-Forwarded-Server: pennydreadfulmagic.com\nConnection: Keep-Alive"}}
{"actor":{"display_login":"vorpal-buildbot"}}