Symfony Profiler

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  decks d0_
WHERE
  d0_.type = ?
  AND d0_.state = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM decks d0_ WHERE d0_.type = 'base' AND d0_.state = 'officiel';

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  decks d0_
WHERE
  d0_.type = ?
  AND d0_.state = ?

SELECT COUNT(d0_.id) AS sclr_0 FROM decks d0_ WHERE d0_.type = 'commu' AND d0_.state = 'public';

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

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 = 'aoi' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug_fr AS slug_fr_2,
  t0.mana AS mana_3,
  t0.description_fr AS description_fr_4,
  t0.power AS power_5,
  t0.legend AS legend_6,
  t0.rapide AS rapide_7,
  t0.position AS position_8,
  t0.reputation AS reputation_9,
  t0.slug_en AS slug_en_10,
  t0.name_en AS name_en_11,
  t0.name_fr AS name_fr_12,
  t0.description_en AS description_en_13,
  t0.hp AS hp_14,
  t0.movement AS movement_15,
  t0.active AS active_16,
  t0.price AS price_17,
  t0.edition_id AS edition_id_18,
  t19.id AS id_20,
  t19.name AS name_21,
  t19.date AS date_22,
  t19.slug AS slug_23,
  t19.code AS code_24,
  t19.name_en AS name_en_25,
  t19.active AS active_26,
  t19.name_fr AS name_fr_27,
  t0.eglise_id AS eglise_id_28,
  t0.card_type_id AS card_type_id_29,
  t0.artist_id AS artist_id_30,
  t0.product_id AS product_id_31
FROM
  cards t0
  LEFT JOIN `set` t19 ON t0.edition_id = t19.id
WHERE
  t0.position = ?
  AND t0.edition_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug_fr AS slug_fr_2, t0.mana AS mana_3, t0.description_fr AS description_fr_4, t0.power AS power_5, t0.legend AS legend_6, t0.rapide AS rapide_7, t0.position AS position_8, t0.reputation AS reputation_9, t0.slug_en AS slug_en_10, t0.name_en AS name_en_11, t0.name_fr AS name_fr_12, t0.description_en AS description_en_13, t0.hp AS hp_14, t0.movement AS movement_15, t0.active AS active_16, t0.price AS price_17, t0.edition_id AS edition_id_18, t19.id AS id_20, t19.name AS name_21, t19.date AS date_22, t19.slug AS slug_23, t19.code AS code_24, t19.name_en AS name_en_25, t19.active AS active_26, t19.name_fr AS name_fr_27, t0.eglise_id AS eglise_id_28, t0.card_type_id AS card_type_id_29, t0.artist_id AS artist_id_30, t0.product_id AS product_id_31 FROM cards t0 LEFT JOIN `set` t19 ON t0.edition_id = t19.id WHERE t0.position = '5' AND t0.edition_id = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_en AS name_en_3,
  t0.name_fr AS name_fr_4
FROM
  card_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_en AS name_en_3, t0.name_fr AS name_fr_4 FROM card_type t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_fr AS name_fr_3,
  t0.name_en AS name_en_4
FROM
  soustype t0
  INNER JOIN cards_soustype ON t0.id = cards_soustype.soustype_id
WHERE
  cards_soustype.cards_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_fr AS name_fr_3, t0.name_en AS name_en_4 FROM soustype t0 INNER JOIN cards_soustype ON t0.id = cards_soustype.soustype_id WHERE cards_soustype.cards_id = 215;

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 = ?

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 = 7;