1.70 ms (24.67%)
|
1 |
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 = ?
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 = 1;
|
0.96 ms (13.93%)
|
2 |
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"
]
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 = 'illimitee' LIMIT 1;
|
0.73 ms (10.51%)
|
2 |
SELECT t0.IDPays AS IDPays_1, t0.Code AS Code_2, t0.Nom AS Nom_3 FROM Pays t0 WHERE t0.Nom = ? LIMIT 1
SELECT t0.IDPays AS IDPays_1, t0.Code AS Code_2, t0.Nom AS Nom_3 FROM Pays t0 WHERE t0.Nom = 'France' LIMIT 1;
|
0.52 ms (7.50%)
|
1 |
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_
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_;
|
0.50 ms (7.28%)
|
1 |
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
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 = 'PR' LIMIT 1;
|
0.45 ms (6.52%)
|
1 |
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
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;
|
0.42 ms (6.02%)
|
1 |
SELECT c0_.IDCivilite AS IDCivilite_0, c0_.Code AS Code_1, c0_.Libelle AS Libelle_2 FROM Civilite c0_
SELECT c0_.IDCivilite AS IDCivilite_0, c0_.Code AS Code_1, c0_.Libelle AS Libelle_2 FROM Civilite c0_;
|
0.40 ms (5.83%)
|
1 |
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"
]
SELECT t0.IDConfig AS IDConfig_1, t0.name AS name_2, t0.value AS value_3 FROM Config t0 WHERE t0.name = 'PK_STRIPE' LIMIT 1;
|
0.34 ms (4.98%)
|
1 |
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"
]
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 = 'adhesion' LIMIT 1;
|
0.31 ms (4.52%)
|
1 |
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
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;
|
0.31 ms (4.52%)
|
1 |
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 = ?
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 = 1;
|
0.26 ms (3.71%)
|
1 |
SELECT p0_.IDPays AS IDPays_0, p0_.Code AS Code_1, p0_.Nom AS Nom_2 FROM Pays p0_
SELECT p0_.IDPays AS IDPays_0, p0_.Code AS Code_1, p0_.Nom AS Nom_2 FROM Pays p0_;
|