Exceeded slow_query limit (1.1 > 0.5) in mysql: ```

SELECT c.id, c.name, c.start_date, c.end_date, c.url, c.top_n, COUNT(d.id) AS num_decks, SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed, sp.name AS sponsor_name, cs.name AS series_name, ct.name AS type, season.season_id FROM competition AS c LEFT JOIN deck AS d ON c.id = d.competition_id LEFT JOIN competition_series AS cs ON cs.id = c.competition_series_id LEFT JOIN competition_type as ct ON ct.id = cs.competition_type_id LEFT JOIN sponsor AS sp ON cs.sponsor_id = sp.id LEFT JOIN deck_cache AS season ON d.id = season.deck_id WHERE (c.id = ( SELECT id FROM competition WHERE start_date < 1684873692 AND end_date > 1684873692 AND id IN ( SELECT id FROM competition WHERE competition_series_id IN ( SELECT id FROM competition_series WHERE competition_type_id IN ( SELECT id FROM competition_type WHERE name = 'League' ) ) ) )) AND (TRUE) GROUP BY c.id HAVING TRUE ORDER BY c.start_date DESC, c.name ```

Exceeded slow_query limit (0.5 > 0.5) in mysql: ```

    SELECT
        c.id,
        c.name,
        c.start_date,
        c.end_date,
        c.url,
        c.top_n,
        COUNT(d.id) AS num_decks,
        SUM(CASE WHEN d.reviewed THEN 1 ELSE 0 END) AS num_reviewed,
        sp.name AS sponsor_name,
        cs.name AS series_name,
        ct.name AS type,
        season.season_id
    FROM
        competition AS c
    LEFT JOIN
        deck AS d ON c.id = d.competition_id
    LEFT JOIN
        competition_series AS cs ON cs.id = c.competition_series_id
    LEFT JOIN
        competition_type as ct ON ct.id = cs.competition_type_id
    LEFT JOIN
        sponsor AS sp ON cs.sponsor_id = sp.id
    LEFT JOIN deck_cache AS season ON d.id = season.deck_id
    WHERE
        (c.id = (
    SELECT id FROM competition
    WHERE
        start_date < 1684909692
    AND
        end_date > 1684909692
    AND
        id IN (
    SELECT
        id
    FROM
        competition
    WHERE
        competition_series_id IN
            (
                SELECT
                    id
                FROM
                    competition_series
                WHERE
                    competition_type_id
                IN (
    SELECT
        id
    FROM
        competition_type
    WHERE
        name = 'League'
)
            )
    )
    )) AND (TRUE)
    GROUP BY
        c.id
    HAVING
        TRUE
    ORDER BY
        c.start_date DESC,
        c.name

```

[] (slow_query, 0.5, mysql)

Reported on decksite by mysql-perf

Location Hash: a1d976b2f195df1a4822324e9a7e1fe8dd72d50c

Request Data

``` Request Method: HEAD Path: /league/current/? Cookies: ImmutableMultiDict([]) Endpoint: current_league View Args: {} Person: logged_out Referrer: https://pennydreadfulmagic.com/league/current/ Request Data: {} Content-Length: 0 Host: pennydreadfulmagic.com Connection: Keep-Alive Accept-Encoding: gzip X-Forwarded-For: 63.143.42.247 Cf-Ray: 7cc37a27af6f0bca-DFW 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 Cache-Control: no-cache Referer: https://pennydreadfulmagic.com/league/current/ Cf-Connecting-Ip: 63.143.42.247 Cf-Ipcountry: US Cdn-Loop: cloudflare ```

Labels: decksite

PennyDreadfulMTG / perf-reports

Exceeded slow_query limit (1.1 > 0.5) in mysql: ``` #61395