Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.nbconnx AS nbconnx_2,
  t0.username AS username_3,
  t0.adresse AS adresse_4,
  t0.fonction AS fonction_5,
  t0.etablisment AS etablisment_6,
  t0.numMobile AS numMobile_7,
  t0.logourl AS logourl_8,
  t0.Datedepart AS Datedepart_9,
  t0.dateFlagDepot AS dateFlagDepot_10,
  t0.flagDepot AS flagDepot_11,
  t0.nom AS nom_12,
  t0.prenom AS prenom_13,
  t0.roles AS roles_14,
  t0.email AS email_15,
  t0.password AS password_16,
  t0.salt AS salt_17,
  t0.date_creation AS date_creation_18,
  t0.nometablisment AS nometablisment_19,
  t0.randomnotice AS randomnotice_20,
  t0.infocomple AS infocomple_21,
  t0.reponseemail AS reponseemail_22,
  t0.password_non_cripted AS password_non_cripted_23,
  t0.cnxparent AS cnxparent_24,
  t0.accompaplus AS accompaplus_25,
  t0.activatemail AS activatemail_26,
  t0.Jeton AS Jeton_27,
  t0.showpubprod AS showpubprod_28,
  t0.showdetailsalbum AS showdetailsalbum_29,
  t0.showdetailslivre AS showdetailslivre_30,
  t0.showdetailsphotos AS showdetailsphotos_31,
  t0.showdetailsretros AS showdetailsretros_32,
  t0.showdetailscal AS showdetailscal_33,
  t0.cnxpartenaire AS cnxpartenaire_34,
  t0.smsnotif AS smsnotif_35,
  t0.mailnotif AS mailnotif_36,
  t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37,
  t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38,
  t0.adresslivraison AS adresslivraison_39,
  t0.adressfactoration AS adressfactoration_40,
  t0.statut AS statut_41,
  t0.usersecondaire AS usersecondaire_42,
  t0.comptebanque AS comptebanque_43,
  t0.idFonction_id AS idFonction_id_44
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nbconnx AS nbconnx_2, t0.username AS username_3, t0.adresse AS adresse_4, t0.fonction AS fonction_5, t0.etablisment AS etablisment_6, t0.numMobile AS numMobile_7, t0.logourl AS logourl_8, t0.Datedepart AS Datedepart_9, t0.dateFlagDepot AS dateFlagDepot_10, t0.flagDepot AS flagDepot_11, t0.nom AS nom_12, t0.prenom AS prenom_13, t0.roles AS roles_14, t0.email AS email_15, t0.password AS password_16, t0.salt AS salt_17, t0.date_creation AS date_creation_18, t0.nometablisment AS nometablisment_19, t0.randomnotice AS randomnotice_20, t0.infocomple AS infocomple_21, t0.reponseemail AS reponseemail_22, t0.password_non_cripted AS password_non_cripted_23, t0.cnxparent AS cnxparent_24, t0.accompaplus AS accompaplus_25, t0.activatemail AS activatemail_26, t0.Jeton AS Jeton_27, t0.showpubprod AS showpubprod_28, t0.showdetailsalbum AS showdetailsalbum_29, t0.showdetailslivre AS showdetailslivre_30, t0.showdetailsphotos AS showdetailsphotos_31, t0.showdetailsretros AS showdetailsretros_32, t0.showdetailscal AS showdetailscal_33, t0.cnxpartenaire AS cnxpartenaire_34, t0.smsnotif AS smsnotif_35, t0.mailnotif AS mailnotif_36, t0.AccoPlusToPartenaire AS AccoPlusToPartenaire_37, t0.jetonAccoPlusSejourGratuit AS jetonAccoPlusSejourGratuit_38, t0.adresslivraison AS adresslivraison_39, t0.adressfactoration AS adressfactoration_40, t0.statut AS statut_41, t0.usersecondaire AS usersecondaire_42, t0.comptebanque AS comptebanque_43, t0.idFonction_id AS idFonction_id_44 FROM user t0 WHERE t0.id = 63581;

SELECT
  t0.id AS id_1,
  t0.code_sejour AS code_sejour_2,
  t0.date_creation_code AS date_creation_code_3,
  t0.date_fin_code AS date_fin_code_4,
  t0.them_sejour AS them_sejour_5,
  t0.adresse_sejour AS adresse_sejour_6,
  t0.pays AS pays_7,
  t0.ville AS ville_8,
  t0.code_postal AS code_postal_9,
  t0.date_debut_sejour AS date_debut_sejour_10,
  t0.date_fin_sejour AS date_fin_sejour_11,
  t0.nb_photo_diposer AS nb_photo_diposer_12,
  t0.paym AS paym_13,
  t0.albumgratuie AS albumgratuie_14,
  t0.nb_message AS nb_message_15,
  t0.etat_acomp_Album AS etat_acomp_Album_16,
  t0.etat_adresse_carte AS etat_adresse_carte_17,
  t0.nbenfan AS nbenfan_18,
  t0.nbenfantencours AS nbenfantencours_19,
  t0.cd AS cd_20,
  t0.prixcnxparent AS prixcnxparent_21,
  t0.prixcnxpartenaire AS prixcnxpartenaire_22,
  t0.reversecnxpart AS reversecnxpart_23,
  t0.reverseventepart AS reverseventepart_24,
  t0.Referenc AS Referenc_25,
  t0.cp AS cp_26,
  t0.id_etablisment AS id_etablisment_27,
  t0.Id_acommp AS Id_acommp_28,
  t0.id_partenaire AS id_partenaire_29,
  t0.statut AS statut_30,
  t0.age_group AS age_group_31
FROM
  sejour t0
WHERE
  t0.code_sejour = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = 'EF865747' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.code_sejour AS code_sejour_2,
  t0.date_creation_code AS date_creation_code_3,
  t0.date_fin_code AS date_fin_code_4,
  t0.them_sejour AS them_sejour_5,
  t0.adresse_sejour AS adresse_sejour_6,
  t0.pays AS pays_7,
  t0.ville AS ville_8,
  t0.code_postal AS code_postal_9,
  t0.date_debut_sejour AS date_debut_sejour_10,
  t0.date_fin_sejour AS date_fin_sejour_11,
  t0.nb_photo_diposer AS nb_photo_diposer_12,
  t0.paym AS paym_13,
  t0.albumgratuie AS albumgratuie_14,
  t0.nb_message AS nb_message_15,
  t0.etat_acomp_Album AS etat_acomp_Album_16,
  t0.etat_adresse_carte AS etat_adresse_carte_17,
  t0.nbenfan AS nbenfan_18,
  t0.nbenfantencours AS nbenfantencours_19,
  t0.cd AS cd_20,
  t0.prixcnxparent AS prixcnxparent_21,
  t0.prixcnxpartenaire AS prixcnxpartenaire_22,
  t0.reversecnxpart AS reversecnxpart_23,
  t0.reverseventepart AS reverseventepart_24,
  t0.Referenc AS Referenc_25,
  t0.cp AS cp_26,
  t0.id_etablisment AS id_etablisment_27,
  t0.Id_acommp AS Id_acommp_28,
  t0.id_partenaire AS id_partenaire_29,
  t0.statut AS statut_30,
  t0.age_group AS age_group_31
FROM
  sejour t0
WHERE
  t0.code_sejour = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.code_sejour = 'EF865747' LIMIT 1;

SELECT
  l0_.date AS date_0,
  l0_.etat AS etat_1,
  l0_.id AS id_2,
  l0_.id_sejour AS id_sejour_3,
  l0_.id_sejour_attchment AS id_sejour_attchment_4,
  l0_.id_produit AS id_produit_5,
  l0_.id_user AS id_user_6
FROM
  likephoto l0_
WHERE
  l0_.id_user = ?
  AND l0_.id_sejour = ?

SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = 63581 AND l0_.id_sejour = 17771;

SELECT
  t0.id AS id_1,
  t0.code_sejour AS code_sejour_2,
  t0.date_creation_code AS date_creation_code_3,
  t0.date_fin_code AS date_fin_code_4,
  t0.them_sejour AS them_sejour_5,
  t0.adresse_sejour AS adresse_sejour_6,
  t0.pays AS pays_7,
  t0.ville AS ville_8,
  t0.code_postal AS code_postal_9,
  t0.date_debut_sejour AS date_debut_sejour_10,
  t0.date_fin_sejour AS date_fin_sejour_11,
  t0.nb_photo_diposer AS nb_photo_diposer_12,
  t0.paym AS paym_13,
  t0.albumgratuie AS albumgratuie_14,
  t0.nb_message AS nb_message_15,
  t0.etat_acomp_Album AS etat_acomp_Album_16,
  t0.etat_adresse_carte AS etat_adresse_carte_17,
  t0.nbenfan AS nbenfan_18,
  t0.nbenfantencours AS nbenfantencours_19,
  t0.cd AS cd_20,
  t0.prixcnxparent AS prixcnxparent_21,
  t0.prixcnxpartenaire AS prixcnxpartenaire_22,
  t0.reversecnxpart AS reversecnxpart_23,
  t0.reverseventepart AS reverseventepart_24,
  t0.Referenc AS Referenc_25,
  t0.cp AS cp_26,
  t0.id_etablisment AS id_etablisment_27,
  t0.Id_acommp AS Id_acommp_28,
  t0.id_partenaire AS id_partenaire_29,
  t0.statut AS statut_30,
  t0.age_group AS age_group_31
FROM
  sejour t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.code_sejour AS code_sejour_2, t0.date_creation_code AS date_creation_code_3, t0.date_fin_code AS date_fin_code_4, t0.them_sejour AS them_sejour_5, t0.adresse_sejour AS adresse_sejour_6, t0.pays AS pays_7, t0.ville AS ville_8, t0.code_postal AS code_postal_9, t0.date_debut_sejour AS date_debut_sejour_10, t0.date_fin_sejour AS date_fin_sejour_11, t0.nb_photo_diposer AS nb_photo_diposer_12, t0.paym AS paym_13, t0.albumgratuie AS albumgratuie_14, t0.nb_message AS nb_message_15, t0.etat_acomp_Album AS etat_acomp_Album_16, t0.etat_adresse_carte AS etat_adresse_carte_17, t0.nbenfan AS nbenfan_18, t0.nbenfantencours AS nbenfantencours_19, t0.cd AS cd_20, t0.prixcnxparent AS prixcnxparent_21, t0.prixcnxpartenaire AS prixcnxpartenaire_22, t0.reversecnxpart AS reversecnxpart_23, t0.reverseventepart AS reverseventepart_24, t0.Referenc AS Referenc_25, t0.cp AS cp_26, t0.id_etablisment AS id_etablisment_27, t0.Id_acommp AS Id_acommp_28, t0.id_partenaire AS id_partenaire_29, t0.statut AS statut_30, t0.age_group AS age_group_31 FROM sejour t0 WHERE t0.id = '17771' LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.date_depot_attachement AS date_depot_attachement_1,
  s0_.etat AS etat_2,
  s0_.nbconsomateurattch AS nbconsomateurattch_3,
  s0_.nbpartenaireattch AS nbpartenaireattch_4,
  s0_.nbecoleattch AS nbecoleattch_5,
  s0_.statut AS statut_6,
  a1_.id AS id_7,
  a1_.path AS path_8,
  a1_.date AS date_9,
  a1_.idblog AS idblog_10,
  a1_.descreption AS descreption_11,
  r2_.id AS id_12,
  r2_.libiller AS libiller_13,
  r2_.code AS code_14,
  s0_.id_attchment AS id_attchment_15,
  s0_.id_sejour AS id_sejour_16,
  s0_.idParent_id AS idParent_id_17,
  a1_.idposition AS idposition_18,
  a1_.idref AS idref_19,
  a1_.iduser AS iduser_20,
  r2_.typeref AS typeref_21
FROM
  sejour_attachment s0_
  INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id
  INNER JOIN ref r2_ ON a1_.idref = r2_.id
WHERE
  s0_.id_sejour = ?
  AND r2_.libiller IN (?)

SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = '17771' AND r2_.libiller IN ('message');

SELECT
  s0_.id AS id_0,
  s0_.date_depot_attachement AS date_depot_attachement_1,
  s0_.etat AS etat_2,
  s0_.nbconsomateurattch AS nbconsomateurattch_3,
  s0_.nbpartenaireattch AS nbpartenaireattch_4,
  s0_.nbecoleattch AS nbecoleattch_5,
  s0_.statut AS statut_6,
  a1_.id AS id_7,
  a1_.path AS path_8,
  a1_.date AS date_9,
  a1_.idblog AS idblog_10,
  a1_.descreption AS descreption_11,
  r2_.id AS id_12,
  r2_.libiller AS libiller_13,
  r2_.code AS code_14,
  s0_.id_attchment AS id_attchment_15,
  s0_.id_sejour AS id_sejour_16,
  s0_.idParent_id AS idParent_id_17,
  a1_.idposition AS idposition_18,
  a1_.idref AS idref_19,
  a1_.iduser AS iduser_20,
  r2_.typeref AS typeref_21
FROM
  sejour_attachment s0_
  INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id
  INNER JOIN ref r2_ ON a1_.idref = r2_.id
WHERE
  s0_.id_sejour = ?
  AND s0_.statut = ?
  AND r2_.libiller IN (?, ?)

SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = '17771' AND s0_.statut = 'public' AND r2_.libiller IN ('photo', 'video');

SELECT
  l0_.date AS date_0,
  l0_.etat AS etat_1,
  l0_.id AS id_2,
  l0_.id_sejour AS id_sejour_3,
  l0_.id_sejour_attchment AS id_sejour_attchment_4,
  l0_.id_produit AS id_produit_5,
  l0_.id_user AS id_user_6
FROM
  likephoto l0_
WHERE
  l0_.id_user = ?
  AND l0_.id_sejour = ?

SELECT l0_.date AS date_0, l0_.etat AS etat_1, l0_.id AS id_2, l0_.id_sejour AS id_sejour_3, l0_.id_sejour_attchment AS id_sejour_attchment_4, l0_.id_produit AS id_produit_5, l0_.id_user AS id_user_6 FROM likephoto l0_ WHERE l0_.id_user = 63581 AND l0_.id_sejour = '17771';

SELECT
  s0_.id AS id_0,
  s0_.date_depot_attachement AS date_depot_attachement_1,
  s0_.etat AS etat_2,
  s0_.nbconsomateurattch AS nbconsomateurattch_3,
  s0_.nbpartenaireattch AS nbpartenaireattch_4,
  s0_.nbecoleattch AS nbecoleattch_5,
  s0_.statut AS statut_6,
  a1_.id AS id_7,
  a1_.path AS path_8,
  a1_.date AS date_9,
  a1_.idblog AS idblog_10,
  a1_.descreption AS descreption_11,
  r2_.id AS id_12,
  r2_.libiller AS libiller_13,
  r2_.code AS code_14,
  s0_.id_attchment AS id_attchment_15,
  s0_.id_sejour AS id_sejour_16,
  s0_.idParent_id AS idParent_id_17,
  a1_.idposition AS idposition_18,
  a1_.idref AS idref_19,
  a1_.iduser AS iduser_20,
  r2_.typeref AS typeref_21
FROM
  sejour_attachment s0_
  INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id
  INNER JOIN ref r2_ ON a1_.idref = r2_.id
WHERE
  s0_.id_sejour = ?
  AND r2_.libiller IN (?)

SELECT s0_.id AS id_0, s0_.date_depot_attachement AS date_depot_attachement_1, s0_.etat AS etat_2, s0_.nbconsomateurattch AS nbconsomateurattch_3, s0_.nbpartenaireattch AS nbpartenaireattch_4, s0_.nbecoleattch AS nbecoleattch_5, s0_.statut AS statut_6, a1_.id AS id_7, a1_.path AS path_8, a1_.date AS date_9, a1_.idblog AS idblog_10, a1_.descreption AS descreption_11, r2_.id AS id_12, r2_.libiller AS libiller_13, r2_.code AS code_14, s0_.id_attchment AS id_attchment_15, s0_.id_sejour AS id_sejour_16, s0_.idParent_id AS idParent_id_17, a1_.idposition AS idposition_18, a1_.idref AS idref_19, a1_.iduser AS iduser_20, r2_.typeref AS typeref_21 FROM sejour_attachment s0_ INNER JOIN attachment a1_ ON s0_.id_attchment = a1_.id INNER JOIN ref r2_ ON a1_.idref = r2_.id WHERE s0_.id_sejour = '17771' AND r2_.libiller IN ('message');

SELECT
  *
FROM
  position AS p,
  cart AS c,
  sejour AS s
WHERE
  p.idcart = c.id
  AND c.idsejour = s.id
  AND s.id = 17771

SELECT *
        FROM position AS p, cart AS c, sejour AS s
        WHERE p.idcart = c.id
        AND c.idsejour= s.id
        AND s.id = 17771;

SELECT
  t0.id AS id_1,
  t0.labele AS labele_2,
  t0.prix AS prix_3,
  t0.Produitcol AS Produitcol_4,
  t0.date AS date_5,
  t0.statut AS statut_6,
  t0.nbattach AS nbattach_7,
  t0.pathpdf AS pathpdf_8,
  t0.delated AS delated_9,
  t0.version AS version_10,
  t0.idsjour AS idsjour_11,
  t0.type AS type_12,
  t0.iduser AS iduser_13,
  t0.idConditionnement_id AS idConditionnement_id_14
FROM
  produit t0
WHERE
  t0.idsjour = ?
  AND t0.iduser = ?
  AND t0.statut = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'saved' ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.labele AS labele_2,
  t0.prix AS prix_3,
  t0.Produitcol AS Produitcol_4,
  t0.date AS date_5,
  t0.statut AS statut_6,
  t0.nbattach AS nbattach_7,
  t0.pathpdf AS pathpdf_8,
  t0.delated AS delated_9,
  t0.version AS version_10,
  t0.idsjour AS idsjour_11,
  t0.type AS type_12,
  t0.iduser AS iduser_13,
  t0.idConditionnement_id AS idConditionnement_id_14
FROM
  produit t0
WHERE
  t0.iduser = ?
  AND t0.statut = ?
  AND t0.idsjour = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = 1 AND t0.statut = 'Album_sejour' AND t0.idsjour = 17771 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.labele AS labele_2,
  t0.prix AS prix_3,
  t0.Produitcol AS Produitcol_4,
  t0.date AS date_5,
  t0.statut AS statut_6,
  t0.nbattach AS nbattach_7,
  t0.pathpdf AS pathpdf_8,
  t0.delated AS delated_9,
  t0.version AS version_10,
  t0.idsjour AS idsjour_11,
  t0.type AS type_12,
  t0.iduser AS iduser_13,
  t0.idConditionnement_id AS idConditionnement_id_14
FROM
  produit t0
WHERE
  t0.idsjour = ?
  AND t0.iduser = ?
  AND t0.statut = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'saved' ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.labele AS labele_2,
  t0.prix AS prix_3,
  t0.Produitcol AS Produitcol_4,
  t0.date AS date_5,
  t0.statut AS statut_6,
  t0.nbattach AS nbattach_7,
  t0.pathpdf AS pathpdf_8,
  t0.delated AS delated_9,
  t0.version AS version_10,
  t0.idsjour AS idsjour_11,
  t0.type AS type_12,
  t0.iduser AS iduser_13,
  t0.idConditionnement_id AS idConditionnement_id_14
FROM
  produit t0
WHERE
  t0.idsjour = ?
  AND t0.iduser = ?
  AND t0.statut = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.idsjour = 17771 AND t0.iduser = 116971 AND t0.statut = 'saved' ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.labele AS labele_2,
  t0.prix AS prix_3,
  t0.Produitcol AS Produitcol_4,
  t0.date AS date_5,
  t0.statut AS statut_6,
  t0.nbattach AS nbattach_7,
  t0.pathpdf AS pathpdf_8,
  t0.delated AS delated_9,
  t0.version AS version_10,
  t0.idsjour AS idsjour_11,
  t0.type AS type_12,
  t0.iduser AS iduser_13,
  t0.idConditionnement_id AS idConditionnement_id_14
FROM
  produit t0
WHERE
  t0.iduser = ?
  AND t0.statut = ?
  AND t0.idsjour = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.iduser = 1 AND t0.statut = 'Album_sejour' AND t0.idsjour = 17771 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.labele AS labele_2,
  t0.prix AS prix_3,
  t0.Produitcol AS Produitcol_4,
  t0.date AS date_5,
  t0.statut AS statut_6,
  t0.nbattach AS nbattach_7,
  t0.pathpdf AS pathpdf_8,
  t0.delated AS delated_9,
  t0.version AS version_10,
  t0.idsjour AS idsjour_11,
  t0.type AS type_12,
  t0.iduser AS iduser_13,
  t0.idConditionnement_id AS idConditionnement_id_14
FROM
  produit t0
WHERE
  t0.statut = ?
  AND t0.idsjour = ?
  AND t0.labele = ?
  AND t0.version = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.labele AS labele_2, t0.prix AS prix_3, t0.Produitcol AS Produitcol_4, t0.date AS date_5, t0.statut AS statut_6, t0.nbattach AS nbattach_7, t0.pathpdf AS pathpdf_8, t0.delated AS delated_9, t0.version AS version_10, t0.idsjour AS idsjour_11, t0.type AS type_12, t0.iduser AS iduser_13, t0.idConditionnement_id AS idConditionnement_id_14 FROM produit t0 WHERE t0.statut = 'Livre_sejour' AND t0.idsjour = 17771 AND t0.labele = 'Livre_sejourEF865747' AND t0.version = 'Livre_Admin' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_creation AS date_creation_2,
  t0.date_modification AS date_modification_3,
  t0.payment AS payment_4,
  t0.smsnotif AS smsnotif_5,
  t0.mailnotif AS mailnotif_6,
  t0.traiter AS traiter_7,
  t0.rev AS rev_8,
  t0.fact AS fact_9,
  t0.flagPrix AS flagPrix_10,
  t0.id_parent AS id_parent_11,
  t0.Id_sejour AS Id_sejour_12
FROM
  parent_sejour t0
WHERE
  t0.id_parent = ?
  AND t0.Id_sejour = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.date_modification AS date_modification_3, t0.payment AS payment_4, t0.smsnotif AS smsnotif_5, t0.mailnotif AS mailnotif_6, t0.traiter AS traiter_7, t0.rev AS rev_8, t0.fact AS fact_9, t0.flagPrix AS flagPrix_10, t0.id_parent AS id_parent_11, t0.Id_sejour AS Id_sejour_12 FROM parent_sejour t0 WHERE t0.id_parent = 63581 AND t0.Id_sejour = 17771 LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.montantHT AS montantHT_1,
  t0_.montantTTC AS montantTTC_2,
  t0_.TVA AS TVA_3,
  t0_.poidsContenant AS poidsContenant_4,
  t0_.poidsProduit AS poidsProduit_5,
  t0_.poidsTotal AS poidsTotal_6,
  t0_.pochetteEnvoi AS pochetteEnvoi_7,
  t0_.descriptionCommande AS descriptionCommande_8,
  t0_.type AS type_9,
  t0_.sousTitre AS sousTitre_10,
  t0_.orderprod AS orderprod_11,
  t0_.idTypeProduit_id AS idTypeProduit_id_12
FROM
  typeproduitconditionnement t0_
  INNER JOIN typeproduit t1_ ON t0_.idTypeProduit_id = t1_.id
WHERE
  t1_.statut = ?
ORDER BY
  t0_.orderprod ASC

SELECT t0_.id AS id_0, t0_.montantHT AS montantHT_1, t0_.montantTTC AS montantTTC_2, t0_.TVA AS TVA_3, t0_.poidsContenant AS poidsContenant_4, t0_.poidsProduit AS poidsProduit_5, t0_.poidsTotal AS poidsTotal_6, t0_.pochetteEnvoi AS pochetteEnvoi_7, t0_.descriptionCommande AS descriptionCommande_8, t0_.type AS type_9, t0_.sousTitre AS sousTitre_10, t0_.orderprod AS orderprod_11, t0_.idTypeProduit_id AS idTypeProduit_id_12 FROM typeproduitconditionnement t0_ INNER JOIN typeproduit t1_ ON t0_.idTypeProduit_id = t1_.id WHERE t1_.statut = 'publier' ORDER BY t0_.orderprod ASC;