| 1 |
0.86 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_verified AS is_verified_7, t0.identity AS identity_8, t0.type_user AS type_user_9, t0.date_naiss AS date_naiss_10, t0.nationalite AS nationalite_11, t0.lieu_naiss AS lieu_naiss_12, t0.cinimage AS cinimage_13, t0.cin_verso AS cin_verso_14, t0.phone AS phone_15, t0.genre AS genre_16, t0.address AS address_17 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.is_verified AS is_verified_7, t0.identity AS identity_8, t0.type_user AS type_user_9, t0.date_naiss AS date_naiss_10, t0.nationalite AS nationalite_11, t0.lieu_naiss AS lieu_naiss_12, t0.cinimage AS cinimage_13, t0.cin_verso AS cin_verso_14, t0.phone AS phone_15, t0.genre AS genre_16, t0.address AS address_17 FROM user t0 WHERE t0.id = 119;
|
| 2 |
0.24 ms |
SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.is_read AS is_read_2, n0_.created_at AS created_at_3, n0_.user_id AS user_id_4 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = ? ORDER BY n0_.created_at DESC
SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.is_read AS is_read_2, n0_.created_at AS created_at_3, n0_.user_id AS user_id_4 FROM notification n0_ WHERE n0_.user_id = 119 AND n0_.is_read = 0 ORDER BY n0_.created_at DESC;
|
| 3 |
0.22 ms |
SELECT count(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = ? AND n0_.is_read = 0
SELECT count(n0_.id) AS sclr_0 FROM notification n0_ WHERE n0_.user_id = 119 AND n0_.is_read = 0;
|
| 4 |
0.23 ms |
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.commentaire AS commentaire_3, t0.date_demande AS date_demande_4, t0.traite AS traite_5, t0.user_id AS user_id_6 FROM demande t0 WHERE t0.user_id = ? ORDER BY t0.date_demande DESC
SELECT t0.id AS id_1, t0.statut AS statut_2, t0.commentaire AS commentaire_3, t0.date_demande AS date_demande_4, t0.traite AS traite_5, t0.user_id AS user_id_6 FROM demande t0 WHERE t0.user_id = 119 ORDER BY t0.date_demande DESC;
|
| 5 |
0.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = 54;
|
| 6 |
0.22 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abreviation AS abreviation_3 FROM etablissement t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.abreviation AS abreviation_3 FROM etablissement t0 WHERE t0.id = 21;
|
| 7 |
0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = 55;
|
| 8 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = 56;
|
| 9 |
0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.file AS file_3, t0.date AS date_4, t0.signed_by AS signed_by_5, t0.post_signed_by AS post_signed_by_6, t0.status AS status_7, t0.commentaire AS commentaire_8, t0.language_auth AS language_auth_9, t0.etablissement_id AS etablissement_id_10, t0.demande_id AS demande_id_11 FROM document t0 WHERE t0.demande_id = 57;
|