Exceeded slow_query limit (30.7 > 10.0) in mysql: ```

[vorpal-buildbot]

    SELECT
        name,
        SUM(num_decks) AS num_decks,
        SUM(wins) AS wins,
        SUM(losses) AS losses,
        SUM(draws) AS draws,
        SUM(wins - losses) AS record,
        SUM(perfect_runs) AS perfect_runs,
        SUM(tournament_wins) AS tournament_wins,
        SUM(tournament_top8s) AS tournament_top8s,
        IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS win_percent
    FROM
        _card_stats AS cs
    WHERE
        (TRUE) AND (season_id = 14)
    GROUP BY
        name
    ORDER BY
        num_decks DESC,
        record,
        name
```

[] (slow_query, 30.7, mysql)

Reported on decksite by mysql-perf

Location Hash: e1f139af74366c69fce0c3d94af568d69a9f7511

Request Data

``` Request Method: HEAD Path: /? Cookies: {} Endpoint: home View Args: {} Person: logged_out Referrer: http://pennydreadfulmagic.com/ Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 35.247.53.186, 172.69.22.106 Cf-Ray: 53da6bc16b0779ad-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Referer: http://pennydreadfulmagic.com/ Cf-Connecting-Ip: 35.247.53.186 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive ```

[vorpal-buildbot]

Exceeded slow_query limit (12.3 > 10.0) in mysql: ```

    SELECT
        name,
        SUM(num_decks) AS num_decks,
        SUM(wins) AS wins,
        SUM(losses) AS losses,
        SUM(draws) AS draws,
        SUM(wins - losses) AS record,
        SUM(perfect_runs) AS perfect_runs,
        SUM(tournament_wins) AS tournament_wins,
        SUM(tournament_top8s) AS tournament_top8s,
        IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS win_percent
    FROM
        _card_stats AS cs
    WHERE
        (TRUE) AND (season_id = 14)
    GROUP BY
        name
    ORDER BY
        num_decks DESC,
        record,
        name
```

[] (slow_query, 12.3, mysql)

Reported on decksite by mysql-perf

Location Hash: e1f139af74366c69fce0c3d94af568d69a9f7511

Request Data

``` Request Method: GET Path: /? Cookies: {} Endpoint: home View Args: {} Person: logged_out Referrer: https://www.youtube.com/ Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: BR X-Forwarded-For: 2804:14c:598f:8471:4c2f:89ec:c366:4d9, 172.68.141.192 Cf-Ray: 53e732fbceddeed6-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} Upgrade-Insecure-Requests: 1 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/78.0.3904.108 Safari/537.36 Accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3 Sec-Fetch-Site: cross-site Sec-Fetch-Mode: navigate Referer: https://www.youtube.com/ Accept-Language: pt-BR,pt;q=0.9,en-US;q=0.8,en;q=0.7,de;q=0.6,es;q=0.5,fr;q=0.4 Cf-Connecting-Ip: 2804:14c:598f:8471:4c2f:89ec:c366:4d9 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive ```

Labels: decksite

[vorpal-buildbot]

Exceeded slow_query limit (56.9 > 30.0) in mysql: ```

    SELECT
        name,
        SUM(num_decks) AS num_decks,
        SUM(wins) AS wins,
        SUM(losses) AS losses,
        SUM(draws) AS draws,
        SUM(wins - losses) AS record,
        SUM(perfect_runs) AS perfect_runs,
        SUM(tournament_wins) AS tournament_wins,
        SUM(tournament_top8s) AS tournament_top8s,
        IFNULL(ROUND((SUM(wins) / NULLIF(SUM(wins + losses), 0)) * 100, 1), '') AS win_percent
    FROM
        _card_stats AS cs
    WHERE
        (TRUE) AND (season_id = 14)
    GROUP BY
        name
    ORDER BY
        num_decks DESC,
        record,
        name
```

[] (slow_query, 56.9, mysql)

Reported on decksite by mysql-perf

Location Hash: e1f139af74366c69fce0c3d94af568d69a9f7511

Request Data

``` Request Method: HEAD Path: /? Cookies: {} Endpoint: home View Args: {} Person: logged_out Referrer: https://pennydreadfulmagic.com Request Data: {} Host: pennydreadfulmagic.com Accept-Encoding: gzip Cf-Ipcountry: US X-Forwarded-For: 69.162.124.234, 172.68.189.243 Cf-Ray: 53f9956e7c75ec7a-SJC X-Forwarded-Proto: https Cf-Visitor: {"scheme":"https"} User-Agent: Mozilla/5.0+(compatible; UptimeRobot/2.0; http://www.uptimerobot.com/) Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8 Accept-Language: en-US,en;q=0.8 Accept-Charset: ISO-8859-1,UTF-8;q=0.7,*;q=0.7 Cache-Control: no-cache Referer: https://pennydreadfulmagic.com Cf-Connecting-Ip: 69.162.124.234 Cdn-Loop: cloudflare X-Forwarded-Host: pennydreadfulmagic.com X-Forwarded-Server: pennydreadfulmagic.com Connection: Keep-Alive Content-Length: 0 ```

Labels: decksite