| 1 |
0.73 ms |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.created AS created_5, t0.status AS status_6, t7.id AS id_8, t7.nom AS nom_9, t7.prenom AS prenom_10, t7.email AS email_11, t7.photo AS photo_12, t7.skype AS skype_13, t7.created AS created_14, t7.active_roles AS active_roles_15, t7.statut AS statut_16, t7.liste AS liste_17, t7.user_account_id AS user_account_id_18 FROM user t0 LEFT JOIN personne t7 ON t7.user_account_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.created AS created_5, t0.status AS status_6, t7.id AS id_8, t7.nom AS nom_9, t7.prenom AS prenom_10, t7.email AS email_11, t7.photo AS photo_12, t7.skype AS skype_13, t7.created AS created_14, t7.active_roles AS active_roles_15, t7.statut AS statut_16, t7.liste AS liste_17, t7.user_account_id AS user_account_id_18 FROM user t0 LEFT JOIN personne t7 ON t7.user_account_id = t0.id WHERE t0.id = 7;
|
| 2 |
0.30 ms |
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.email AS email_2, s0_.en_activite AS en_activite_3, s0_.position AS position_4, p1_.id AS id_5, p1_.nom AS nom_6, p1_.prenom AS prenom_7, p1_.email AS email_8, p1_.photo AS photo_9, p1_.skype AS skype_10, p1_.created AS created_11, p1_.active_roles AS active_roles_12, p1_.statut AS statut_13, p1_.liste AS liste_14 FROM segment s0_ LEFT JOIN personne p1_ ON s0_.responsable_id = p1_.id WHERE s0_.en_activite IS NULL ORDER BY s0_.position ASC
SELECT s0_.id AS id_0, s0_.nom AS nom_1, s0_.email AS email_2, s0_.en_activite AS en_activite_3, s0_.position AS position_4, p1_.id AS id_5, p1_.nom AS nom_6, p1_.prenom AS prenom_7, p1_.email AS email_8, p1_.photo AS photo_9, p1_.skype AS skype_10, p1_.created AS created_11, p1_.active_roles AS active_roles_12, p1_.statut AS statut_13, p1_.liste AS liste_14 FROM segment s0_ LEFT JOIN personne p1_ ON s0_.responsable_id = p1_.id WHERE s0_.en_activite IS NULL ORDER BY s0_.position ASC;
|