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

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.id = 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.date AS date_3,
  t0.product_id AS product_id_4,
  t0.user_id AS user_id_5
FROM
  product_stock t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.date AS date_3, t0.product_id AS product_id_4, t0.user_id AS user_id_5 FROM product_stock t0 WHERE t0.product_id = 1;

SELECT
  t0.id AS id_1,
  t0.name_fr AS name_fr_2,
  t0.type AS type_3,
  t0.price AS price_4,
  t0.weight AS weight_5,
  t0.reference AS reference_6,
  t0.description_fr AS description_fr_7,
  t0.card_id AS card_id_8,
  t0.decks_id AS decks_id_9
FROM
  products t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_fr AS name_fr_2, t0.type AS type_3, t0.price AS price_4, t0.weight AS weight_5, t0.reference AS reference_6, t0.description_fr AS description_fr_7, t0.card_id AS card_id_8, t0.decks_id AS decks_id_9 FROM products t0 WHERE t0.id = 1;