search

PennyDreadfulMTG / perf-reports

2 stars 7 forks source link

Exceeded slow_query limit (19.5 > 1.0) in mysql: ``` #63123

Open vorpal-buildbot opened 3 months ago

vorpal-buildbot commented 3 months ago 
    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.9 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (24.0 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 24.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.1 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.2 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (19.9 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.9 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (24.1 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 24.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (24.3 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 24.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.9 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (19.6 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.9 > 1.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (19.5 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (19.5 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.7 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.9 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (19.4 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.3 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.0 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.0 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (25.3 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 25.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.3 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (19.9 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.8 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.7 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.5 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.4 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.2 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.7 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (23.5 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 23.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (22.6 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 22.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (19.3 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (19.4 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 19.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (22.3 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 22.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.8 > 2.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (22.3 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 22.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.3 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.9 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (22.7 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 22.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.4 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (22.2 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 22.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (23.2 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 23.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (20.7 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 20.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.6 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (24.1 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 24.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.3 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (18.4 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 18.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.2 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (22.2 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 22.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (22.0 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 22.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite

vorpal-buildbot commented 3 months ago

Exceeded slow_query limit (21.2 > 5.0) in mysql: ```

    SELECT
        d.id,
        ROUND(SUM(CASE WHEN dm.games > odm.games THEN 1 ELSE 0 END) / NULLIF((SUM(CASE WHEN dm.games <> odm.games THEN 1 ELSE 0 END)), 0), 2) * 100 AS omw
    FROM
        deck AS d
    INNER JOIN
        deck_match AS my_dm ON my_dm.deck_id = d.id
    LEFT JOIN
        deck_match AS my_odm ON my_odm.match_id = my_dm.match_id AND my_odm.deck_id <> d.id
    INNER JOIN
        deck AS od ON od.id = my_odm.deck_id
    INNER JOIN
        deck_match AS dm ON dm.deck_id = od.id
    LEFT JOIN
        deck_match AS odm ON odm.match_id = dm.match_id AND odm.deck_id <> dm.deck_id
    INNER JOIN
        `match` AS m ON m.id = dm.match_id
    WHERE
        TRUE
    GROUP BY
        d.id
```

[] (slow_query, 21.2, mysql)

Reported on decksite by mysql-perf

Location Hash: 2950cdcab1c6aa751f42bbbe4ed9e73f265355c5

Labels: decksite