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

Query Metrics

3 Database Queries
3 Different statements
9.08 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 3.08 ms
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
]
2 3.26 ms
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"
]
3 2.75 ms
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
]

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.