GET https://newarcanciane.devsoft-pro.com/page/plan-site

Query Metrics

11 Database Queries
8 Different statements
3.99 ms Query time
5 Invalid entities
32 Managed entities

Queries

Group similar statements

# Time Info
1 0.87 ms
SELECT t0.IDPagePublique AS IDPagePublique_1, t0.NomPage AS NomPage_2, t0.TitrePage AS TitrePage_3, t0.ContenuPage AS ContenuPage_4, t0.Metatitle AS Metatitle_5, t0.Metadescription AS Metadescription_6, t0.EstActif AS EstActif_7, t0.EstBlog AS EstBlog_8, t0.ImageMiseEnAvant AS ImageMiseEnAvant_9, t0.LienPageAfficher AS LienPageAfficher_10, t0.LibelleBanner AS LibelleBanner_11 FROM PagePublique t0 WHERE t0.LienPageAfficher = ? LIMIT 1
Parameters:
[
  "plan-site"
]
2 0.34 ms
SELECT t0.IDBanner AS IDBanner_1, t0.ImageBanner AS ImageBanner_2, t0.TitreBanner AS TitreBanner_3, t0.SoustitreBanner AS SoustitreBanner_4, t0.Libelle AS Libelle_5, t0.AltImageBanner AS AltImageBanner_6 FROM Banner t0 WHERE t0.Libelle = ? LIMIT 1
Parameters:
[
  "plansite"
]
3 0.22 ms
SELECT t0.IDPays AS IDPays_1, t0.Code AS Code_2, t0.Nom AS Nom_3 FROM Pays t0
Parameters:
[]
4 0.20 ms
SELECT t0.IDCategorieOffre AS IDCategorieOffre_1, t0.LibelleCategorieOffre AS LibelleCategorieOffre_2, t0.CouleurEtiquette AS CouleurEtiquette_3, t0.Commentaire AS Commentaire_4 FROM CategorieOffre t0
Parameters:
[]
5 0.37 ms
SELECT t0.IDAvis AS IDAvis_1, t0.LibelleAvis AS LibelleAvis_2, t0.DateAvis AS DateAvis_3, t0.Commentaire AS Commentaire_4, t0.note AS note_5, t0.EstActif AS EstActif_6, t0.IDSejour AS IDSejour_7, t0.id AS id_8, t0.IDDateSejour AS IDDateSejour_9 FROM Avis t0 WHERE t0.EstActif = ?
Parameters:
[
  1
]
6 0.35 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.EstActif AS EstActif_6, t0.EstDecouverte AS EstDecouverte_7, t0.nomuser AS nomuser_8, t0.photo AS photo_9, t0.Hidden AS Hidden_10, t0.IDTypeUtilisateur AS IDTypeUtilisateur_11, t0.IDDistributeur AS IDDistributeur_12, t0.IDClient AS IDClient_13, t0.IDAdherent AS IDAdherent_14 FROM user t0 WHERE t0.id = ?
Parameters:
[
  13
]
7 0.33 ms
SELECT t0.IDAdherent AS IDAdherent_1, t0.NumAdherent AS NumAdherent_2, t0.NomAdherent AS NomAdherent_3, t0.PrenomAdherent AS PrenomAdherent_4, t0.DateNaiss AS DateNaiss_5, t0.Profession AS Profession_6, t0.Adresse AS Adresse_7, t0.Suite AS Suite_8, t0.CP AS CP_9, t0.Ville AS Ville_10, t0.TelDom AS TelDom_11, t0.TelBur AS TelBur_12, t0.Fax AS Fax_13, t0.Email AS Email_14, t0.Observation AS Observation_15, t0.EstActif AS EstActif_16, t0.GiftReservationCurrentYear AS GiftReservationCurrentYear_17, t0.isAdherent1 AS isAdherent1_18, t0.DateCreation AS DateCreation_19, t0.IDCivilite AS IDCivilite_20, t0.IDPays AS IDPays_21 FROM Adherent t0 WHERE t0.IDAdherent = ?
Parameters:
[
  "21"
]
8 0.39 ms
SELECT t0.IDSejour AS IDSejour_1, t0.NomSejour AS NomSejour_2, t0.DescriptionCourte AS DescriptionCourte_3, t0.Ville AS Ville_4, t0.CP AS CP_5, t0.DescriptionLongue AS DescriptionLongue_6, t0.DescriptionRegion AS DescriptionRegion_7, t0.ConseilsVisites AS ConseilsVisites_8, t0.DureeSejour AS DureeSejour_9, t0.NbreJour AS NbreJour_10, t0.NbreNuit AS NbreNuit_11, t0.motCle AS motCle_12, t0.EstCoupDeCoeur AS EstCoupDeCoeur_13, t0.RangCoupDeCoeur AS RangCoupDeCoeur_14, t0.EstNouveaute AS EstNouveaute_15, t0.ImageMiseEnAvant AS ImageMiseEnAvant_16, t0.TarifSejour AS TarifSejour_17, t0.NoteGenerale AS NoteGenerale_18, t0.EstVisible AS EstVisible_19, t0.DateCreation AS DateCreation_20, t0.DateModification AS DateModification_21, t0.IDRegion AS IDRegion_22, t0.IDTheme AS IDTheme_23, t0.IDCategorieOffre AS IDCategorieOffre_24, t0.IDHebergement AS IDHebergement_25, t0.IDTypeFormule AS IDTypeFormule_26, t0.IDTypePrestation AS IDTypePrestation_27, t0.IDTypeEtatsejour AS IDTypeEtatsejour_28, t0.IDTypeLogement AS IDTypeLogement_29 FROM Sejour t0 WHERE t0.IDSejour = ?
Parameters:
[
  "3"
]
9 0.30 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.EstActif AS EstActif_6, t0.EstDecouverte AS EstDecouverte_7, t0.nomuser AS nomuser_8, t0.photo AS photo_9, t0.Hidden AS Hidden_10, t0.IDTypeUtilisateur AS IDTypeUtilisateur_11, t0.IDDistributeur AS IDDistributeur_12, t0.IDClient AS IDClient_13, t0.IDAdherent AS IDAdherent_14 FROM user t0 WHERE t0.id = ?
Parameters:
[
  6
]
10 0.30 ms
SELECT t0.IDAdherent AS IDAdherent_1, t0.NumAdherent AS NumAdherent_2, t0.NomAdherent AS NomAdherent_3, t0.PrenomAdherent AS PrenomAdherent_4, t0.DateNaiss AS DateNaiss_5, t0.Profession AS Profession_6, t0.Adresse AS Adresse_7, t0.Suite AS Suite_8, t0.CP AS CP_9, t0.Ville AS Ville_10, t0.TelDom AS TelDom_11, t0.TelBur AS TelBur_12, t0.Fax AS Fax_13, t0.Email AS Email_14, t0.Observation AS Observation_15, t0.EstActif AS EstActif_16, t0.GiftReservationCurrentYear AS GiftReservationCurrentYear_17, t0.isAdherent1 AS isAdherent1_18, t0.DateCreation AS DateCreation_19, t0.IDCivilite AS IDCivilite_20, t0.IDPays AS IDPays_21 FROM Adherent t0 WHERE t0.IDAdherent = ?
Parameters:
[
  "7"
]
11 0.33 ms
SELECT t0.IDSejour AS IDSejour_1, t0.NomSejour AS NomSejour_2, t0.DescriptionCourte AS DescriptionCourte_3, t0.Ville AS Ville_4, t0.CP AS CP_5, t0.DescriptionLongue AS DescriptionLongue_6, t0.DescriptionRegion AS DescriptionRegion_7, t0.ConseilsVisites AS ConseilsVisites_8, t0.DureeSejour AS DureeSejour_9, t0.NbreJour AS NbreJour_10, t0.NbreNuit AS NbreNuit_11, t0.motCle AS motCle_12, t0.EstCoupDeCoeur AS EstCoupDeCoeur_13, t0.RangCoupDeCoeur AS RangCoupDeCoeur_14, t0.EstNouveaute AS EstNouveaute_15, t0.ImageMiseEnAvant AS ImageMiseEnAvant_16, t0.TarifSejour AS TarifSejour_17, t0.NoteGenerale AS NoteGenerale_18, t0.EstVisible AS EstVisible_19, t0.DateCreation AS DateCreation_20, t0.DateModification AS DateModification_21, t0.IDRegion AS IDRegion_22, t0.IDTheme AS IDTheme_23, t0.IDCategorieOffre AS IDCategorieOffre_24, t0.IDHebergement AS IDHebergement_25, t0.IDTypeFormule AS IDTypeFormule_26, t0.IDTypePrestation AS IDTypePrestation_27, t0.IDTypeEtatsejour AS IDTypeEtatsejour_28, t0.IDTypeLogement AS IDTypeLogement_29 FROM Sejour t0 WHERE t0.IDSejour = ?
Parameters:
[
  "2"
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Pays 5
App\Entity\Categorieoffre 3
App\Entity\Avis 2
App\Entity\Sejour 2
App\Entity\User 2
App\Entity\Datesejour 2
App\Entity\Adherent 2
App\Entity\Theme 2
App\Entity\Hebergement 2
App\Entity\Catalogue 2
App\Entity\Typeprestation 2
App\Entity\Typelogement 2
App\Entity\Pagepublique 1
App\Entity\Banner 1
App\Entity\Civilite 1
App\Entity\Region 1

Entities Mapping

Class Mapping errors
App\Entity\Pagepublique No errors.
App\Entity\Banner No errors.
App\Entity\Pays No errors.
App\Entity\Categorieoffre No errors.
App\Entity\Avis No errors.
App\Entity\Sejour
  • The field App\Entity\Sejour#galeries is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Galeriesejour#idsejour does not contain the required 'inversedBy="galeries"' attribute.
  • The field App\Entity\Sejour#reservations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Reservation#idsejour does not contain the required 'inversedBy="reservations"' attribute.
  • The field App\Entity\Sejour#blogs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Blog#idsejour does not contain the required 'inversedBy="blogs"' attribute.
App\Entity\User No errors.
App\Entity\Datesejour
  • The field App\Entity\Datesejour#paniers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PanierSejour#iddatesejour does not contain the required 'inversedBy="paniers"' attribute.
  • The field App\Entity\Datesejour#avis is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Avis#iddatesejour does not contain the required 'inversedBy="avis"' attribute.
App\Entity\Typeutilisateur No errors.
App\Entity\Distributeur No errors.
App\Entity\Client No errors.
App\Entity\Adherent No errors.
App\Entity\Notification No errors.
App\Entity\Civilite No errors.
App\Entity\Region No errors.
App\Entity\Theme
  • The field App\Entity\Theme#sejours is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idtheme does not contain the required 'inversedBy="sejours"' attribute.
App\Entity\Hebergement
  • The field App\Entity\Hebergement#sejours is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sejour#idhebergement does not contain the required 'inversedBy="sejours"' attribute.
App\Entity\Catalogue No errors.
App\Entity\Typeprestation No errors.
App\Entity\Typeetatsejour No errors.
App\Entity\Typelogement No errors.
App\Entity\Galeriesejour No errors.
App\Entity\Reservation
  • The field App\Entity\Reservation#factures is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Facture#idreservation does not contain the required 'inversedBy="factures"' attribute.
  • The field App\Entity\Reservation#paiements is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Paiement#idreservation does not contain the required 'inversedBy="paiements"' attribute.
App\Entity\Blog No errors.