Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

9.08 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
3.26 ms (35.84%)	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 s0_.statut = ? AND r2_.libiller IN (?) LIMIT 60 Parameters: [`"17415" "public" "photo"`] View formatted query View runnable query Explain query 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 (?) LIMIT 60 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 = '17415' AND s0_.statut = 'public' AND r2_.libiller IN ('photo') LIMIT 60;
3.08 ms (33.88%)	1	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 = ? Parameters: [`121525`] View formatted query View runnable query Explain query 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 = 121525;
2.75 ms (30.27%)	1	SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id_sejour = ? AND t0.id_user = ? Parameters: [`17415 121525`] View formatted query View runnable query Explain query SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id_sejour = ? AND t0.id_user = ? SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id_sejour = 17415 AND t0.id_user = 121525;

Time▼

Count

Info

3.26 ms
(35.84%)

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 (?) LIMIT 60

Parameters:

[
  "17415"
  "public"
  "photo"
]

View formatted query View runnable query Explain query

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 (?)
LIMIT
  60

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 = '17415' AND s0_.statut = 'public' AND r2_.libiller IN ('photo') LIMIT 60;

3.08 ms
(33.88%)

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

Parameters:

[
  121525
]

View formatted query View runnable query Explain query

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

2.75 ms
(30.27%)

SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id_sejour = ? AND t0.id_user = ?

Parameters:

View formatted query View runnable query Explain query

SELECT
  t0.num_comande AS num_comande_1,
  t0.montantHt AS montantHt_2,
  t0.montanenv AS montanenv_3,
  t0.montantRth AS montantRth_4,
  t0.traiter AS traiter_5,
  t0.moantantTtcregl AS moantantTtcregl_6,
  t0.tva AS tva_7,
  t0.date_create_commande AS date_create_commande_8,
  t0.date_facture AS date_facture_9,
  t0.Jeton AS Jeton_10,
  t0.payement_type AS payement_type_11,
  t0.periode AS periode_12,
  t0.dupligetStatut AS dupligetStatut_13,
  t0.id AS id_14,
  t0.revesmentpart AS revesmentpart_15,
  t0.remisecodepromo AS remisecodepromo_16,
  t0.totalBlackFriday AS totalBlackFriday_17,
  t0.nbconnx AS nbconnx_18,
  t0.rev AS rev_19,
  t0.NumSuivi AS NumSuivi_20,
  t0.dateLivraison AS dateLivraison_21,
  t0.dateExpidition AS dateExpidition_22,
  t0.lettreSuivi AS lettreSuivi_23,
  t0.addresseLivraison AS addresseLivraison_24,
  t0.nbenfantencours AS nbenfantencours_25,
  t0.numfacture AS numfacture_26,
  t0.id_sejour AS id_sejour_27,
  t0.id_user AS id_user_28,
  t0.statut AS statut_29,
  t0.adresslivraison AS adresslivraison_30,
  t0.adressfactoration AS adressfactoration_31,
  t0.idPanier_id AS idPanier_id_32,
  t0.idPromotion_id AS idPromotion_id_33,
  t0.logPromo_id AS logPromo_id_34
FROM
  commande t0
WHERE
  t0.id_sejour = ?
  AND t0.id_user = ?

SELECT t0.num_comande AS num_comande_1, t0.montantHt AS montantHt_2, t0.montanenv AS montanenv_3, t0.montantRth AS montantRth_4, t0.traiter AS traiter_5, t0.moantantTtcregl AS moantantTtcregl_6, t0.tva AS tva_7, t0.date_create_commande AS date_create_commande_8, t0.date_facture AS date_facture_9, t0.Jeton AS Jeton_10, t0.payement_type AS payement_type_11, t0.periode AS periode_12, t0.dupligetStatut AS dupligetStatut_13, t0.id AS id_14, t0.revesmentpart AS revesmentpart_15, t0.remisecodepromo AS remisecodepromo_16, t0.totalBlackFriday AS totalBlackFriday_17, t0.nbconnx AS nbconnx_18, t0.rev AS rev_19, t0.NumSuivi AS NumSuivi_20, t0.dateLivraison AS dateLivraison_21, t0.dateExpidition AS dateExpidition_22, t0.lettreSuivi AS lettreSuivi_23, t0.addresseLivraison AS addresseLivraison_24, t0.nbenfantencours AS nbenfantencours_25, t0.numfacture AS numfacture_26, t0.id_sejour AS id_sejour_27, t0.id_user AS id_user_28, t0.statut AS statut_29, t0.adresslivraison AS adresslivraison_30, t0.adressfactoration AS adressfactoration_31, t0.idPanier_id AS idPanier_id_32, t0.idPromotion_id AS idPromotion_id_33, t0.logPromo_id AS logPromo_id_34 FROM commande t0 WHERE t0.id_sejour = 17415 AND t0.id_user = 121525;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\User	The field App\Entity\User#mescommandes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commande#idUser does not contain the required 'inversedBy="mescommandes"' attribute. The field App\Entity\User#etablismentuser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Etablisment#user does not contain the required 'inversedBy="etablismentuser"' attribute. The field App\Entity\User#mesblogs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog#iduser does not contain the required 'inversedBy="mesblogs"' attribute. The field App\Entity\User#mesSejourAcc is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idAcommp does not contain the required 'inversedBy="mesSejourAcc"' attribute. The field App\Entity\User#mesSejourPart is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idPartenaire does not contain the required 'inversedBy="mesSejourPart"' attribute.
App\Entity\Adress	No errors.
App\Entity\Ref	No errors.
App\Entity\Comptebancaire	No errors.
App\Entity\Fonctions	No errors.
App\Entity\Commande	The field App\Entity\Commande#commandesProduits is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ComandeProduit#idComande does not contain the required 'inversedBy="commandesProduits"' attribute.
App\Entity\Etablisment	No errors.
App\Entity\Blog	The field App\Entity\Blog#mesattachments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\BlogAttachement#idblog does not contain the required 'inversedBy="mesattachments"' attribute.
App\Entity\Sejour	The field App\Entity\Sejour#produits is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Produit#idsjour does not contain the required 'inversedBy="produits"' attribute. The field App\Entity\Sejour#commandes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Commande#idSejour does not contain the required 'inversedBy="commandes"' attribute. The field App\Entity\Sejour#cartes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart#idsejour does not contain the required 'inversedBy="cartes"' attribute. The field App\Entity\Sejour#attachements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SejourAttachment#idSejour does not contain the required 'inversedBy="attachements"' attribute. The field App\Entity\Sejour#jourdescripdate is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Jourdescripdate#idsejour does not contain the required 'inversedBy="jourdescripdate"' attribute. The field App\Entity\Sejour#parentSejour is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ParentSejour#idSejour does not contain the required 'inversedBy="parentSejour"' attribute.
App\Entity\SejourAttachment	No errors.
App\Entity\Panier	No errors.
App\Entity\Etiquette	No errors.
App\Entity\CommentaireEtiquette	No errors.
App\Entity\LogPromotions	No errors.
App\Entity\PromoParents	No errors.
App\Entity\Photonsumeriques	No errors.
App\Entity\Attachment	No errors.
App\Entity\Position	No errors.
App\Entity\Typeref	No errors.
App\Entity\Promotions	No errors.

Symfony Profiler

https://futur.5sur5sejour.fr/Parent/disablepack

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping