GET https://mail.kronika.fr/editions/aoi

Query Metrics

13 Database Queries
4 Different statements
6.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.17 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM decks d0_ WHERE d0_.type = ? AND d0_.state = ?
Parameters:
[
  "base"
  "officiel"
]
2 0.07 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM decks d0_ WHERE d0_.type = ? AND d0_.state = ?
Parameters:
[
  "commu"
  "public"
]
3 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.date AS date_3, t0.slug AS slug_4, t0.code AS code_5, t0.name_en AS name_en_6, t0.active AS active_7, t0.name_fr AS name_fr_8 FROM `set` t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "aoi"
]
4 3.45 ms
SELECT c0_.id AS id_0, c0_.slug_fr AS slug_fr_1, c0_.mana AS mana_2, c0_.description_fr AS description_fr_3, c0_.power AS power_4, c0_.legend AS legend_5, c0_.rapide AS rapide_6, c0_.position AS position_7, c0_.reputation AS reputation_8, c0_.slug_en AS slug_en_9, c0_.name_en AS name_en_10, c0_.name_fr AS name_fr_11, c0_.description_en AS description_en_12, c0_.hp AS hp_13, c0_.movement AS movement_14, c0_.active AS active_15, c0_.price AS price_16, c0_.edition_id AS edition_id_17, c0_.eglise_id AS eglise_id_18, c0_.card_type_id AS card_type_id_19, c0_.artist_id AS artist_id_20, c0_.product_id AS product_id_21 FROM cards c0_ WHERE c0_.active = ? AND c0_.edition_id = ? ORDER BY c0_.position ASC
Parameters:
[
  1
  1
]
5 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  7
]
7 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  5
]
8 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  10
]
9 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  11
]
10 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  9
]
11 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  6
]
12 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  2
]
13 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.instagram AS instagram_3, t0.slug AS slug_4, t0.web AS web_5 FROM artist t0 WHERE t0.id = ?
Parameters:
[
  8
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Decks No errors.
App\Entity\Set No errors.
App\Entity\Cards No errors.
App\Entity\Eglise No errors.
App\Entity\CardType No errors.
App\Entity\Artist No errors.
App\Entity\Products No errors.
App\Entity\DeckCards No errors.
App\Entity\Soustype No errors.
App\Entity\CardNote No errors.