Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.nom AS nom_1,
  s0_.description AS description_2,
  s0_.resume AS resume_3,
  s0_.accroche AS accroche_4,
  s0_.code_sejour AS code_sejour_5,
  s0_.nb_jours AS nb_jours_6,
  s0_.nb_nuits AS nb_nuits_7,
  s0_.nb_jours_activite AS nb_jours_activite_8,
  s0_.vignette AS vignette_9,
  s0_.img_principale AS img_principale_10,
  s0_.fiche_technique_pdf AS fiche_technique_pdf_11,
  s0_.mise_en_avant AS mise_en_avant_12,
  s0_.publie AS publie_13,
  s0_.prix_default AS prix_default_14,
  s0_.montant_acompte AS montant_acompte_15,
  s0_.pourcentage_acompte AS pourcentage_acompte_16,
  s0_.stock_default AS stock_default_17,
  s0_.coord_depart AS coord_depart_18,
  s0_.coord_arrivee AS coord_arrivee_19,
  s1_.id AS id_20,
  s1_.date_debut AS date_debut_21,
  s1_.date_fin AS date_fin_22,
  s1_.commentaire AS commentaire_23,
  s1_.prix AS prix_24,
  s1_.stock_initial AS stock_initial_25,
  s1_.stock AS stock_26,
  s1_.effectif_mini AS effectif_mini_27,
  s1_.statut AS statut_28,
  s2_.id AS id_29,
  s2_.libelle AS libelle_30,
  s3_.id AS id_31,
  s3_.libelle AS libelle_32,
  s0_.niveau_id AS niveau_id_33,
  s1_.sejour_id AS sejour_id_34
FROM
  sejour__sejour s0_
  LEFT JOIN sejour__session s1_ ON s0_.id = s1_.sejour_id
  LEFT JOIN sejour__sejour_categorie s4_ ON s0_.id = s4_.sejour_id
  LEFT JOIN sejour__categorie s2_ ON s2_.id = s4_.categorie_id
  LEFT JOIN sejour__niveau s3_ ON s0_.niveau_id = s3_.id
ORDER BY
  s0_.id ASC
LIMIT
  1000

SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.description AS description_2, s0_.resume AS resume_3, s0_.accroche AS accroche_4, s0_.code_sejour AS code_sejour_5, s0_.nb_jours AS nb_jours_6, s0_.nb_nuits AS nb_nuits_7, s0_.nb_jours_activite AS nb_jours_activite_8, s0_.vignette AS vignette_9, s0_.img_principale AS img_principale_10, s0_.fiche_technique_pdf AS fiche_technique_pdf_11, s0_.mise_en_avant AS mise_en_avant_12, s0_.publie AS publie_13, s0_.prix_default AS prix_default_14, s0_.montant_acompte AS montant_acompte_15, s0_.pourcentage_acompte AS pourcentage_acompte_16, s0_.stock_default AS stock_default_17, s0_.coord_depart AS coord_depart_18, s0_.coord_arrivee AS coord_arrivee_19, s1_.id AS id_20, s1_.date_debut AS date_debut_21, s1_.date_fin AS date_fin_22, s1_.commentaire AS commentaire_23, s1_.prix AS prix_24, s1_.stock_initial AS stock_initial_25, s1_.stock AS stock_26, s1_.effectif_mini AS effectif_mini_27, s1_.statut AS statut_28, s2_.id AS id_29, s2_.libelle AS libelle_30, s3_.id AS id_31, s3_.libelle AS libelle_32, s0_.niveau_id AS niveau_id_33, s1_.sejour_id AS sejour_id_34 FROM sejour__sejour s0_ LEFT JOIN sejour__session s1_ ON s0_.id = s1_.sejour_id LEFT JOIN sejour__sejour_categorie s4_ ON s0_.id = s4_.sejour_id LEFT JOIN sejour__categorie s2_ ON s2_.id = s4_.categorie_id LEFT JOIN sejour__niveau s3_ ON s0_.niveau_id = s3_.id ORDER BY s0_.id ASC LIMIT 1000;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__activite t0
  INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id
WHERE
  sejour__sejour_activite.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 2;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__destination t0
  INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id
WHERE
  sejour__sejour_destination.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 2;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.sejour_id AS sejour_id_6
FROM
  sejour__media t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = 2;

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.sejour_id AS sejour_id_3,
  t0.champ_id AS champ_id_4
FROM
  sejour__champ_valeur t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = 2;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.type AS type_3,
  t0.options AS options_4
FROM
  sejour__champ t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.type AS type_3, t0.options AS options_4 FROM sejour__champ t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__activite t0
  INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id
WHERE
  sejour__sejour_activite.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 4;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__destination t0
  INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id
WHERE
  sejour__sejour_destination.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 4;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.sejour_id AS sejour_id_6
FROM
  sejour__media t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = 4;

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.sejour_id AS sejour_id_3,
  t0.champ_id AS champ_id_4
FROM
  sejour__champ_valeur t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = 4;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__activite t0
  INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id
WHERE
  sejour__sejour_activite.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 5;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__destination t0
  INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id
WHERE
  sejour__sejour_destination.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 5;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.sejour_id AS sejour_id_6
FROM
  sejour__media t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = 5;

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.sejour_id AS sejour_id_3,
  t0.champ_id AS champ_id_4
FROM
  sejour__champ_valeur t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = 5;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__activite t0
  INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id
WHERE
  sejour__sejour_activite.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 6;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__destination t0
  INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id
WHERE
  sejour__sejour_destination.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 6;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.sejour_id AS sejour_id_6
FROM
  sejour__media t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = 6;

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.sejour_id AS sejour_id_3,
  t0.champ_id AS champ_id_4
FROM
  sejour__champ_valeur t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = 6;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__activite t0
  INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id
WHERE
  sejour__sejour_activite.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 7;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__destination t0
  INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id
WHERE
  sejour__sejour_destination.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 7;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.sejour_id AS sejour_id_6
FROM
  sejour__media t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = 7;

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.sejour_id AS sejour_id_3,
  t0.champ_id AS champ_id_4
FROM
  sejour__champ_valeur t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = 7;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__activite t0
  INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id
WHERE
  sejour__sejour_activite.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 8;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__destination t0
  INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id
WHERE
  sejour__sejour_destination.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 8;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.path AS path_5,
  t0.sejour_id AS sejour_id_6
FROM
  sejour__media t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.description AS description_3, t0.type AS type_4, t0.path AS path_5, t0.sejour_id AS sejour_id_6 FROM sejour__media t0 WHERE t0.sejour_id = 8;

SELECT
  t0.id AS id_1,
  t0.valeur AS valeur_2,
  t0.sejour_id AS sejour_id_3,
  t0.champ_id AS champ_id_4
FROM
  sejour__champ_valeur t0
WHERE
  t0.sejour_id = ?

SELECT t0.id AS id_1, t0.valeur AS valeur_2, t0.sejour_id AS sejour_id_3, t0.champ_id AS champ_id_4 FROM sejour__champ_valeur t0 WHERE t0.sejour_id = 8;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__activite t0
  INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id
WHERE
  sejour__sejour_activite.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__activite t0 INNER JOIN sejour__sejour_activite ON t0.id = sejour__sejour_activite.activite_id WHERE sejour__sejour_activite.sejour_id = 9;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  sejour__destination t0
  INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id
WHERE
  sejour__sejour_destination.sejour_id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM sejour__destination t0 INNER JOIN sejour__sejour_destination ON t0.id = sejour__sejour_destination.destination_id WHERE sejour__sejour_destination.sejour_id = 9;