0.44 ms (32.65%)
|
2 |
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;
|
0.35 ms (25.76%)
|
1 |
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;
|