{"action":"opened","issue":{"url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/41007","repository_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports","labels_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/41007/labels{/name}","comments_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/41007/comments","events_url":"https://api.github.com/repos/PennyDreadfulMTG/perf-reports/issues/41007/events","html_url":"https://github.com/PennyDreadfulMTG/perf-reports/issues/41007","id":373764117,"node_id":"MDU6SXNzdWUzNzM3NjQxMTc=","number":41007,"title":"Exceeded slow_query limit (1.0 > 1.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-10-25T03:59:44Z","updated_at":"2018-10-25T03:59:44Z","closed_at":null,"author_association":"NONE","body":"        SELECT\n            d.id,\n            d.finish,\n            d.decklist_hash,\n            cache.active_date,\n            cache.wins,\n            cache.losses,\n            cache.draws\n        FROM\n            deck AS d\n        \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        \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            (d.id = 6891) AND (TRUE)\n        GROUP BY\n            d.id,\n            season.id -- In theory this is not necessary as all decks are in a single season and we join on the date but MySQL cannot work that out so give it the hint it needs.\n        HAVING\n            1 = 1\n        ORDER BY\n            active_date DESC, d.finish IS NULL, d.finish\n        \n    ```\n\n```[]``` (slow_query, 1.0, mysql)\n\nReported on decksite by mysql-perf```\n            --------------------------------------------------------------------------------\n            Request Method: GET\n            Path: /decks/6891/?locale=ja\n            Cookies: {}\n            Endpoint: deck\n            View Args: {'deck_id': '6891'}\n            Person: logged_out\n            Referrer: None\n            Request Data: {}\nHost: pennydreadfulmagic.com\nAccept-Encoding: gzip\nCf-Ipcountry: US\nX-Forwarded-For: 46.229.168.142, 162.158.78.12\nCf-Ray: 46f1c5a6193e568d-IAD\nX-Forwarded-Proto: https\nCf-Visitor: {\"scheme\":\"https\"}\nAccept: text/html\nUser-Agent: Mozilla/5.0 (compatible; SemrushBot/2~bl; +http://www.semrush.com/bot.html)\nCf-Connecting-Ip: 46.229.168.142\nX-Forwarded-Host: pennydreadfulmagic.com\nX-Forwarded-Server: pennydreadfulmagic.com\nConnection: Keep-Alive\n```\n"}}
{"actor":{"display_login":"vorpal-buildbot"}}