https://futur.5sur5sejour.fr/Accompagnateur/appActiveAcompt_Acompa/18534

Query Metrics

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

Queries

Group similar statements

# Time Info
1 3.76 ms
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 = ?
Parameters:
[
  "18534"
]
2 2.79 ms
SELECT t0.id AS id_1, t0.libiller AS libiller_2, t0.code AS code_3, t0.typeref AS typeref_4 FROM ref t0 WHERE t0.id = ?
Parameters:
[
  21
]
3 3.48 ms
SELECT t0.id AS id_1, t0.date_creation AS date_creation_2, t0.typeemail AS typeemail_3, t0.id_user_creation AS id_user_creation_4, t0.id_image1 AS id_image1_5, t0.id_image2 AS id_image2_6, t0.statut AS statut_7, t0.id_destinataire AS id_destinataire_8 FROM emailing t0 WHERE t0.typeemail = ? AND t0.statut = ? LIMIT 1
Parameters:
[
  21
  9
]

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\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\Etablisment No 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\Ref No errors.
App\Entity\Produit 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\Cart
  • The field App\Entity\Cart#positions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Position#idcart does not contain the required 'inversedBy="positions"' attribute.
App\Entity\SejourAttachment No errors.
App\Entity\Jourdescripdate No errors.
App\Entity\Panier No errors.
App\Entity\ParentSejour No errors.
App\Entity\PromoSejour No errors.
App\Entity\Photonsumeriques No errors.
App\Entity\Typeref No errors.
App\Entity\Promotions No errors.
App\Entity\Emailing No errors.
App\Entity\Attachment No errors.