GET https://newarcanciane.devsoft-pro.com/new-adhesion

Query Metrics

14 Database Queries
12 Different statements
6.91 ms Query time
0 Invalid entities
109 Managed entities

Queries

Group similar statements

# Time Info
1 1.70 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.EstActif = ?
Parameters:
[
  1
]
2 0.40 ms
SELECT t0.IDConfig AS IDConfig_1, t0.name AS name_2, t0.value AS value_3 FROM Config t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "PK_STRIPE"
]
3 0.37 ms
SELECT t0.IDFormuleAdhesion AS IDFormuleAdhesion_1, t0.LibelleFormule AS LibelleFormule_2, t0.TarifFormuleAdhesion AS TarifFormuleAdhesion_3, t0.DateValiditeFormule AS DateValiditeFormule_4, t0.DescriptionLongue AS DescriptionLongue_5, t0.Slug AS Slug_6 FROM FormuleAdhesion t0 WHERE t0.Slug = ? LIMIT 1
Parameters:
[
  "illimitee"
]
4 0.50 ms
SELECT t0.IDOrigineAdhesion AS IDOrigineAdhesion_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3, t0.Commentaire AS Commentaire_4, t0.TypeOrigine AS TypeOrigine_5 FROM OrigineAdhesion t0 WHERE t0.Code = ? LIMIT 1
Parameters:
[
  "PR"
]
5 0.45 ms
SELECT t0.IDAdhesion AS IDAdhesion_1, t0.DateDebutValidate AS DateDebutValidate_2, t0.DateFinValidite AS DateFinValidite_3, t0.NomParrain AS NomParrain_4, t0.CCVAnum AS CCVAnum_5, t0.CCVAOffertpar AS CCVAOffertpar_6, t0.CodePartenaire AS CodePartenaire_7, t0.DateInscription AS DateInscription_8, t0.Observation AS Observation_9, t0.NumAdhesion AS NumAdhesion_10, t0.EstDecouverte AS EstDecouverte_11, t0.EstPaye AS EstPaye_12, t0.EstActif AS EstActif_13, t0.SourceInscription AS SourceInscription_14, t0.IDAdherent1 AS IDAdherent1_15, t0.IDAdherent2 AS IDAdherent2_16, t0.IDCategorieAdhesion AS IDCategorieAdhesion_17, t0.IDOrigineAdhesion AS IDOrigineAdhesion_18, t0.IDFormuleAdhesion AS IDFormuleAdhesion_19, t0.IDCCVA AS IDCCVA_20, t0.IDEtatAdhesion AS IDEtatAdhesion_21, t0.IDPartenaire AS IDPartenaire_22, t0.IDTypePaiement AS IDTypePaiement_23, t0.IDCouponcadeau AS IDCouponcadeau_24, t0.IDAdherentParrain AS IDAdherentParrain_25 FROM Adhesion t0 ORDER BY t0.IDAdhesion DESC LIMIT 1
Parameters:
[]
6 0.31 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 ORDER BY t0.IDAdherent DESC LIMIT 1
Parameters:
[]
7 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:
[
  "adhesion"
]
8 0.44 ms
SELECT t0.IDPays AS IDPays_1, t0.Code AS Code_2, t0.Nom AS Nom_3 FROM Pays t0 WHERE t0.Nom = ? LIMIT 1
Parameters:
[
  "France"
]
9 0.29 ms
SELECT t0.IDPays AS IDPays_1, t0.Code AS Code_2, t0.Nom AS Nom_3 FROM Pays t0 WHERE t0.Nom = ? LIMIT 1
Parameters:
[
  "France"
]
10 0.52 ms
SELECT a0_.IDAdherent AS IDAdherent_0, a0_.NumAdherent AS NumAdherent_1, a0_.NomAdherent AS NomAdherent_2, a0_.PrenomAdherent AS PrenomAdherent_3, a0_.DateNaiss AS DateNaiss_4, a0_.Profession AS Profession_5, a0_.Adresse AS Adresse_6, a0_.Suite AS Suite_7, a0_.CP AS CP_8, a0_.Ville AS Ville_9, a0_.TelDom AS TelDom_10, a0_.TelBur AS TelBur_11, a0_.Fax AS Fax_12, a0_.Email AS Email_13, a0_.Observation AS Observation_14, a0_.EstActif AS EstActif_15, a0_.GiftReservationCurrentYear AS GiftReservationCurrentYear_16, a0_.isAdherent1 AS isAdherent1_17, a0_.DateCreation AS DateCreation_18, a0_.IDCivilite AS IDCivilite_19, a0_.IDPays AS IDPays_20 FROM Adherent a0_
Parameters:
[]
11 0.42 ms
SELECT c0_.IDCivilite AS IDCivilite_0, c0_.Code AS Code_1, c0_.Libelle AS Libelle_2 FROM Civilite c0_
Parameters:
[]
12 0.26 ms
SELECT p0_.IDPays AS IDPays_0, p0_.Code AS Code_1, p0_.Nom AS Nom_2 FROM Pays p0_
Parameters:
[]
13 0.31 ms
SELECT o0_.IDOrigineAdhesion AS IDOrigineAdhesion_0, o0_.Code AS Code_1, o0_.Libelle AS Libelle_2, o0_.Commentaire AS Commentaire_3, o0_.TypeOrigine AS TypeOrigine_4 FROM OrigineAdhesion o0_ WHERE o0_.TypeOrigine = ?
Parameters:
[
  1
]
14 0.59 ms
SELECT t0.IDFormuleAdhesion AS IDFormuleAdhesion_1, t0.LibelleFormule AS LibelleFormule_2, t0.TarifFormuleAdhesion AS TarifFormuleAdhesion_3, t0.DateValiditeFormule AS DateValiditeFormule_4, t0.DescriptionLongue AS DescriptionLongue_5, t0.Slug AS Slug_6 FROM FormuleAdhesion t0 WHERE t0.Slug = ? LIMIT 1
Parameters:
[
  "illimitee"
]

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\Adherent 52
App\Entity\User 34
App\Entity\Origineadhesion 8
App\Entity\Pays 5
App\Entity\Civilite 3
App\Entity\Typeutilisateur 2
App\Entity\Formuleadhesion 2
App\Entity\Config 1
App\Entity\Adhesion 1
App\Entity\Banner 1

Entities Mapping