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

[vorpal-buildbot]

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 18.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 7876d05cffe74f09ff9505c6cd28282b54d83686

[vorpal-buildbot]

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

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 10.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 7876d05cffe74f09ff9505c6cd28282b54d83686

Labels: decksite

[vorpal-buildbot]

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

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 9.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 7876d05cffe74f09ff9505c6cd28282b54d83686

Labels: decksite

[vorpal-buildbot]

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

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 10.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 7876d05cffe74f09ff9505c6cd28282b54d83686

Labels: decksite

[vorpal-buildbot]

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

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 8.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 7876d05cffe74f09ff9505c6cd28282b54d83686

Labels: decksite

[vorpal-buildbot]

Exceeded slow_query limit (65.4 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 65.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 7876d05cffe74f09ff9505c6cd28282b54d83686

Labels: decksite

[vorpal-buildbot]

Exceeded slow_query limit (60.3 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 60.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 7876d05cffe74f09ff9505c6cd28282b54d83686

Labels: decksite

[vorpal-buildbot]

Exceeded slow_query limit (61.9 > 60.0) in mysql: ```

    CREATE TABLE IF NOT EXISTS _new_unique_cards (
        card VARCHAR(100) NOT NULL,
        person_id INT NOT NULL,
        PRIMARY KEY (card, person_id),
        FOREIGN KEY (person_id) REFERENCES person (id) ON UPDATE CASCADE ON DELETE CASCADE
    )
    SELECT
        card,
        person_id
    FROM
        deck_card AS dc
    INNER JOIN
        deck AS d ON dc.deck_id = d.id
    WHERE
        d.id IN (SELECT deck_id FROM deck_match)
    GROUP BY
        card
    HAVING
        COUNT(DISTINCT person_id) = 1
```

[] (slow_query, 61.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 7876d05cffe74f09ff9505c6cd28282b54d83686

Labels: decksite