Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.idiresa AS idiresa_4,
  t0.etat AS etat_5,
  t0.default AS default_6,
  t0.code_iso AS code_iso_7,
  t0.flag_id AS flag_id_8
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.code AS code_3,
  t0.idiresa AS idiresa_4,
  t0.etat AS etat_5,
  t0.default AS default_6,
  t0.code_iso AS code_iso_7,
  t0.flag_id AS flag_id_8
FROM
  language t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = 'fr' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.destination_idiresa AS destination_idiresa_2,
  t0.lieu_id AS lieu_id_3,
  t0.commercialisation AS commercialisation_4,
  t0.discontinued AS discontinued_5,
  t0.nom AS nom_6,
  t0.slug AS slug_7,
  t0.ville AS ville_8,
  t0.idiresa AS idiresa_9,
  t0.iscontact AS iscontact_10,
  t0.taux AS taux_11,
  t0.prefixetarif AS prefixetarif_12,
  t0.suffixetarif AS suffixetarif_13,
  t0.depot_id AS depot_id_14,
  t0.etefr_id AS etefr_id_15,
  t0.eteen_id AS eteen_id_16,
  t0.hiverfr_id AS hiverfr_id_17,
  t0.hiveren_id AS hiveren_id_18,
  t0.saisonfr_id AS saisonfr_id_19,
  t0.saisonen_id AS saisonen_id_20
FROM
  residence t0
WHERE
  t0.idiresa = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.destination_idiresa AS destination_idiresa_2, t0.lieu_id AS lieu_id_3, t0.commercialisation AS commercialisation_4, t0.discontinued AS discontinued_5, t0.nom AS nom_6, t0.slug AS slug_7, t0.ville AS ville_8, t0.idiresa AS idiresa_9, t0.iscontact AS iscontact_10, t0.taux AS taux_11, t0.prefixetarif AS prefixetarif_12, t0.suffixetarif AS suffixetarif_13, t0.depot_id AS depot_id_14, t0.etefr_id AS etefr_id_15, t0.eteen_id AS eteen_id_16, t0.hiverfr_id AS hiverfr_id_17, t0.hiveren_id AS hiveren_id_18, t0.saisonfr_id AS saisonfr_id_19, t0.saisonen_id AS saisonen_id_20 FROM residence t0 WHERE t0.idiresa = 357 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.etat AS etat_2,
  t0.canonical AS canonical_3,
  t0.residence_id AS residence_id_4,
  t0.lang_id AS lang_id_5
FROM
  option_residence t0
WHERE
  t0.residence_id = ?
  AND t0.lang_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.etat AS etat_2, t0.canonical AS canonical_3, t0.residence_id AS residence_id_4, t0.lang_id AS lang_id_5 FROM option_residence t0 WHERE t0.residence_id = 169 AND t0.lang_id = 1 LIMIT 1;