search

PennyDreadfulMTG / perf-reports

2 stars 2 forks source link

Exceeded slow_query limit (140.5 > 60.0) in mysql: ``` #59915

Open vorpal-buildbot opened 1 year ago

vorpal-buildbot commented 1 year ago 
    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, 140.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (137.5 > 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, 137.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (122.5 > 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, 122.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (140.6 > 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, 140.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (85.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, 85.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (87.0 > 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, 87.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (90.8 > 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, 90.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (84.5 > 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, 84.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (83.0 > 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, 83.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (83.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, 83.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (88.8 > 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, 88.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (86.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, 86.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (82.5 > 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, 82.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (85.5 > 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, 85.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (82.6 > 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, 82.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (84.5 > 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, 84.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (86.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, 86.3, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (105.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, 105.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (92.7 > 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, 92.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (83.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, 83.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (84.5 > 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, 84.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (89.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, 89.9, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (87.1 > 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, 87.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (95.1 > 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, 95.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (83.8 > 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, 83.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (87.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, 87.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (85.0 > 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, 85.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (88.7 > 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, 88.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (85.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, 85.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (83.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, 83.4, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (90.0 > 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, 90.0, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (89.6 > 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, 89.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (85.8 > 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, 85.8, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (84.1 > 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, 84.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (94.6 > 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, 94.6, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (88.5 > 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, 88.5, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (88.7 > 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, 88.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (92.7 > 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, 92.7, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite

vorpal-buildbot commented 1 year ago

Exceeded slow_query limit (87.1 > 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, 87.1, mysql)

Reported on decksite by mysql-perf

Location Hash: 2e677a82b6984ea17cd293d799b6be53468dce3e

Labels: decksite