1.24 ms (100.00%)
|
1 |
SELECT t0.id AS id_5, t0.username AS username_6, t0.email AS email_7, t0.roles AS roles_8, t0.password AS password_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.telephone AS telephone_12, t0.adresse AS adresse_13, t0.date_naissance AS date_naissance_14, t0.cin AS cin_15, t0.date_creation AS date_creation_16, t0.derniere_connexion AS derniere_connexion_17, t0.actif AS actif_18, t0.type, t1.specialite AS specialite_19, t1.numero_inpe AS numero_inpe_20, t1.biographie AS biographie_21, t1.tarif_consultation AS tarif_consultation_22, t2.numero_assurance_maladie AS numero_assurance_maladie_23, t2.type_assurance AS type_assurance_24, t2.antecedents_medicaux AS antecedents_medicaux_25, t2.allergies AS allergies_26, t2.groupe_sanguin AS groupe_sanguin_27, t2.profession AS profession_28, t2.responsable AS responsable_29, t2.sexe AS sexe_30, t2.antecedents_chirurgicaux AS antecedents_chirurgicaux_31, t2.antecedents_familiales AS antecedents_familiales_32, t2.note AS note_33, t3.poste AS poste_34, t4.poste AS poste_35, t4.date_embauche AS date_embauche_36, t4.competences AS competences_37 FROM `users` t0 LEFT JOIN medecins t1 ON t0.id = t1.id LEFT JOIN patients t2 ON t0.id = t2.id LEFT JOIN admins t3 ON t0.id = t3.id LEFT JOIN secretaire t4 ON t0.id = t4.id WHERE t0.username = ? LIMIT 1
SELECT t0.id AS id_5, t0.username AS username_6, t0.email AS email_7, t0.roles AS roles_8, t0.password AS password_9, t0.nom AS nom_10, t0.prenom AS prenom_11, t0.telephone AS telephone_12, t0.adresse AS adresse_13, t0.date_naissance AS date_naissance_14, t0.cin AS cin_15, t0.date_creation AS date_creation_16, t0.derniere_connexion AS derniere_connexion_17, t0.actif AS actif_18, t0.type, t1.specialite AS specialite_19, t1.numero_inpe AS numero_inpe_20, t1.biographie AS biographie_21, t1.tarif_consultation AS tarif_consultation_22, t2.numero_assurance_maladie AS numero_assurance_maladie_23, t2.type_assurance AS type_assurance_24, t2.antecedents_medicaux AS antecedents_medicaux_25, t2.allergies AS allergies_26, t2.groupe_sanguin AS groupe_sanguin_27, t2.profession AS profession_28, t2.responsable AS responsable_29, t2.sexe AS sexe_30, t2.antecedents_chirurgicaux AS antecedents_chirurgicaux_31, t2.antecedents_familiales AS antecedents_familiales_32, t2.note AS note_33, t3.poste AS poste_34, t4.poste AS poste_35, t4.date_embauche AS date_embauche_36, t4.competences AS competences_37 FROM `users` t0 LEFT JOIN medecins t1 ON t0.id = t1.id LEFT JOIN patients t2 ON t0.id = t2.id LEFT JOIN admins t3 ON t0.id = t3.id LEFT JOIN secretaire t4 ON t0.id = t4.id WHERE t0.username = 'admin' LIMIT 1;
|