| 1 |
0.19 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.EstResponsable AS EstResponsable_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 WHERE t0.username = ? LIMIT 1
Parameters: [
"responsable@gmail.com"
]
SELECT t0.id AS id_1, t0.username AS username_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.EstResponsable AS EstResponsable_5, t0.roles AS roles_6, t0.password AS password_7 FROM `user` t0 WHERE t0.username = 'responsable@gmail.com' LIMIT 1;
|
| 2 |
0.35 ms |
SELECT r0_.IDCourse AS IDCourse_0, r0_.Code AS Code_1, r0_.Nom AS Nom_2, r0_.PrixEnAriary AS PrixEnAriary_3, r0_.PrixEnEuro AS PrixEnEuro_4, r0_.DepartOK AS DepartOK_5, r0_.DateDepart AS DateDepart_6, r0_.HeureDepart AS HeureDepart_7, r0_.LieuCourse AS LieuCourse_8, r0_.DateCourse AS DateCourse_9, r0_.DistanceEnKm AS DistanceEnKm_10, r0_.Lieu AS Lieu_11, r0_.AgeMinimum AS AgeMinimum_12, r0_.AgeMaximum AS AgeMaximum_13, r0_.WithScratch AS WithScratch_14, r0_.BarriereHor AS BarriereHor_15, r0_.DistanceCourse AS DistanceCourse_16, p1_.IDParticipant AS IDParticipant_17, p1_.HeureDepart AS HeureDepart_18, p1_.HeureArrivee AS HeureArrivee_19, p1_.TempsTotal AS TempsTotal_20, p1_.Emargement AS Emargement_21, p1_.IDCoureur AS IDCoureur_22, p1_.IDEtatCoureur AS IDEtatCoureur_23, p1_.IDCourse AS IDCourse_24, p1_.IDDossard AS IDDossard_25 FROM rd_course r0_ LEFT JOIN Participant p1_ ON r0_.IDCourse = p1_.IDCourse ORDER BY r0_.IDCourse ASC
SELECT r0_.IDCourse AS IDCourse_0, r0_.Code AS Code_1, r0_.Nom AS Nom_2, r0_.PrixEnAriary AS PrixEnAriary_3, r0_.PrixEnEuro AS PrixEnEuro_4, r0_.DepartOK AS DepartOK_5, r0_.DateDepart AS DateDepart_6, r0_.HeureDepart AS HeureDepart_7, r0_.LieuCourse AS LieuCourse_8, r0_.DateCourse AS DateCourse_9, r0_.DistanceEnKm AS DistanceEnKm_10, r0_.Lieu AS Lieu_11, r0_.AgeMinimum AS AgeMinimum_12, r0_.AgeMaximum AS AgeMaximum_13, r0_.WithScratch AS WithScratch_14, r0_.BarriereHor AS BarriereHor_15, r0_.DistanceCourse AS DistanceCourse_16, p1_.IDParticipant AS IDParticipant_17, p1_.HeureDepart AS HeureDepart_18, p1_.HeureArrivee AS HeureArrivee_19, p1_.TempsTotal AS TempsTotal_20, p1_.Emargement AS Emargement_21, p1_.IDCoureur AS IDCoureur_22, p1_.IDEtatCoureur AS IDEtatCoureur_23, p1_.IDCourse AS IDCourse_24, p1_.IDDossard AS IDDossard_25 FROM rd_course r0_ LEFT JOIN Participant p1_ ON r0_.IDCourse = p1_.IDCourse ORDER BY r0_.IDCourse ASC;
|
| 3 |
0.28 ms |
SELECT t0.IDCoureur AS IDCoureur_1, t0.Date AS Date_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.DateNais AS DateNais_5, t0.Sexe AS Sexe_6, t0.Adresse AS Adresse_7, t0.Telephone AS Telephone_8, t0.Licencie AS Licencie_9, t0.NumLicence AS NumLicence_10, t0.Ville AS Ville_11, t0.Region AS Region_12, t0.Commune AS Commune_13, t0.PersonneAcontatcter AS PersonneAcontatcter_14, t0.NumPersonneAcontacter AS NumPersonneAcontacter_15, t0.NomTeam AS NomTeam_16, t0.Email AS Email_17, t0.Particulier AS Particulier_18, t0.NomClub AS NomClub_19, t0.Paye AS Paye_20, t0.CIN AS CIN_21, t0.linkcin AS linkcin_22, t0.LinkAutorisation AS LinkAutorisation_23, t0.linkcertificat AS linkcertificat_24, t0.profil AS profil_25, t0.PointureTshirt AS PointureTshirt_26, t0.remarque AS remarque_27, t0.StatusResidence AS StatusResidence_28, t0.Navette AS Navette_29, t0.IDCategorie AS IDCategorie_30, t0.IDNationalite AS IDNationalite_31, t0.IDCourse AS IDCourse_32 FROM rd_coureur t0 WHERE t0.IDCoureur = ?
SELECT t0.IDCoureur AS IDCoureur_1, t0.Date AS Date_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.DateNais AS DateNais_5, t0.Sexe AS Sexe_6, t0.Adresse AS Adresse_7, t0.Telephone AS Telephone_8, t0.Licencie AS Licencie_9, t0.NumLicence AS NumLicence_10, t0.Ville AS Ville_11, t0.Region AS Region_12, t0.Commune AS Commune_13, t0.PersonneAcontatcter AS PersonneAcontatcter_14, t0.NumPersonneAcontacter AS NumPersonneAcontacter_15, t0.NomTeam AS NomTeam_16, t0.Email AS Email_17, t0.Particulier AS Particulier_18, t0.NomClub AS NomClub_19, t0.Paye AS Paye_20, t0.CIN AS CIN_21, t0.linkcin AS linkcin_22, t0.LinkAutorisation AS LinkAutorisation_23, t0.linkcertificat AS linkcertificat_24, t0.profil AS profil_25, t0.PointureTshirt AS PointureTshirt_26, t0.remarque AS remarque_27, t0.StatusResidence AS StatusResidence_28, t0.Navette AS Navette_29, t0.IDCategorie AS IDCategorie_30, t0.IDNationalite AS IDNationalite_31, t0.IDCourse AS IDCourse_32 FROM rd_coureur t0 WHERE t0.IDCoureur = 1;
|
| 4 |
0.15 ms |
SELECT t0.IDEtatCoureur AS IDEtatCoureur_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3 FROM EtatCoureur t0 WHERE t0.IDEtatCoureur = ?
SELECT t0.IDEtatCoureur AS IDEtatCoureur_1, t0.Code AS Code_2, t0.Libelle AS Libelle_3 FROM EtatCoureur t0 WHERE t0.IDEtatCoureur = 1;
|
| 5 |
0.11 ms |
SELECT t0.IDDossard AS IDDossard_1, t0.NumDossard AS NumDossard_2, t0.QRcode AS QRcode_3, t0.IDCourse AS IDCourse_4 FROM Dossard t0 WHERE t0.IDDossard = ?
SELECT t0.IDDossard AS IDDossard_1, t0.NumDossard AS NumDossard_2, t0.QRcode AS QRcode_3, t0.IDCourse AS IDCourse_4 FROM Dossard t0 WHERE t0.IDDossard = 1;
|
| 6 |
0.16 ms |
SELECT t0.IDCoureur AS IDCoureur_1, t0.Date AS Date_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.DateNais AS DateNais_5, t0.Sexe AS Sexe_6, t0.Adresse AS Adresse_7, t0.Telephone AS Telephone_8, t0.Licencie AS Licencie_9, t0.NumLicence AS NumLicence_10, t0.Ville AS Ville_11, t0.Region AS Region_12, t0.Commune AS Commune_13, t0.PersonneAcontatcter AS PersonneAcontatcter_14, t0.NumPersonneAcontacter AS NumPersonneAcontacter_15, t0.NomTeam AS NomTeam_16, t0.Email AS Email_17, t0.Particulier AS Particulier_18, t0.NomClub AS NomClub_19, t0.Paye AS Paye_20, t0.CIN AS CIN_21, t0.linkcin AS linkcin_22, t0.LinkAutorisation AS LinkAutorisation_23, t0.linkcertificat AS linkcertificat_24, t0.profil AS profil_25, t0.PointureTshirt AS PointureTshirt_26, t0.remarque AS remarque_27, t0.StatusResidence AS StatusResidence_28, t0.Navette AS Navette_29, t0.IDCategorie AS IDCategorie_30, t0.IDNationalite AS IDNationalite_31, t0.IDCourse AS IDCourse_32 FROM rd_coureur t0 WHERE t0.IDCoureur = ?
SELECT t0.IDCoureur AS IDCoureur_1, t0.Date AS Date_2, t0.Nom AS Nom_3, t0.Prenom AS Prenom_4, t0.DateNais AS DateNais_5, t0.Sexe AS Sexe_6, t0.Adresse AS Adresse_7, t0.Telephone AS Telephone_8, t0.Licencie AS Licencie_9, t0.NumLicence AS NumLicence_10, t0.Ville AS Ville_11, t0.Region AS Region_12, t0.Commune AS Commune_13, t0.PersonneAcontatcter AS PersonneAcontatcter_14, t0.NumPersonneAcontacter AS NumPersonneAcontacter_15, t0.NomTeam AS NomTeam_16, t0.Email AS Email_17, t0.Particulier AS Particulier_18, t0.NomClub AS NomClub_19, t0.Paye AS Paye_20, t0.CIN AS CIN_21, t0.linkcin AS linkcin_22, t0.LinkAutorisation AS LinkAutorisation_23, t0.linkcertificat AS linkcertificat_24, t0.profil AS profil_25, t0.PointureTshirt AS PointureTshirt_26, t0.remarque AS remarque_27, t0.StatusResidence AS StatusResidence_28, t0.Navette AS Navette_29, t0.IDCategorie AS IDCategorie_30, t0.IDNationalite AS IDNationalite_31, t0.IDCourse AS IDCourse_32 FROM rd_coureur t0 WHERE t0.IDCoureur = 2;
|
| 7 |
0.11 ms |
SELECT t0.IDDossard AS IDDossard_1, t0.NumDossard AS NumDossard_2, t0.QRcode AS QRcode_3, t0.IDCourse AS IDCourse_4 FROM Dossard t0 WHERE t0.IDDossard = ?
SELECT t0.IDDossard AS IDDossard_1, t0.NumDossard AS NumDossard_2, t0.QRcode AS QRcode_3, t0.IDCourse AS IDCourse_4 FROM Dossard t0 WHERE t0.IDDossard = 2;
|