| 1 |
10.33 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.plain_password AS plain_password_9, t0.enable AS enable_10, t0.deleted AS deleted_11, t0.birth_date AS birth_date_12, t0.birth_place AS birth_place_13, t0.cnps AS cnps_14, t0.embauche_date AS embauche_date_15, t0.renvoi_date AS renvoi_date_16, t0.signature_url AS signature_url_17, t0.initiale AS initiale_18, t0.signature_data AS signature_data_19, t0.signature_name AS signature_name_20, t0.signature_size AS signature_size_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.service_id AS service_id_24, t0.departement_id AS departement_id_25 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.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.plain_password AS plain_password_9, t0.enable AS enable_10, t0.deleted AS deleted_11, t0.birth_date AS birth_date_12, t0.birth_place AS birth_place_13, t0.cnps AS cnps_14, t0.embauche_date AS embauche_date_15, t0.renvoi_date AS renvoi_date_16, t0.signature_url AS signature_url_17, t0.initiale AS initiale_18, t0.signature_data AS signature_data_19, t0.signature_name AS signature_name_20, t0.signature_size AS signature_size_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.service_id AS service_id_24, t0.departement_id AS departement_id_25 FROM `user` t0 WHERE t0.id = 163;
|
| 2 |
0.48 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM permission t0 INNER JOIN permission_user ON t0.id = permission_user.permission_id WHERE permission_user.user_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.libelle AS libelle_3 FROM permission t0 INNER JOIN permission_user ON t0.id = permission_user.permission_id WHERE permission_user.user_id = 163;
|
| 3 |
0.61 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.plain_password AS plain_password_9, t0.enable AS enable_10, t0.deleted AS deleted_11, t0.birth_date AS birth_date_12, t0.birth_place AS birth_place_13, t0.cnps AS cnps_14, t0.embauche_date AS embauche_date_15, t0.renvoi_date AS renvoi_date_16, t0.signature_url AS signature_url_17, t0.initiale AS initiale_18, t0.signature_data AS signature_data_19, t0.signature_name AS signature_name_20, t0.signature_size AS signature_size_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.service_id AS service_id_24, t0.departement_id AS departement_id_25 FROM `user` t0
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenoms AS prenoms_6, t0.telephone AS telephone_7, t0.fonction AS fonction_8, t0.plain_password AS plain_password_9, t0.enable AS enable_10, t0.deleted AS deleted_11, t0.birth_date AS birth_date_12, t0.birth_place AS birth_place_13, t0.cnps AS cnps_14, t0.embauche_date AS embauche_date_15, t0.renvoi_date AS renvoi_date_16, t0.signature_url AS signature_url_17, t0.initiale AS initiale_18, t0.signature_data AS signature_data_19, t0.signature_name AS signature_name_20, t0.signature_size AS signature_size_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.service_id AS service_id_24, t0.departement_id AS departement_id_25 FROM `user` t0;
|
| 4 |
0.71 ms |
SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.link_to AS link_to_2, n0_.unread AS unread_3, n0_.permission AS permission_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.document_id AS document_id_7, n0_.owner_id AS owner_id_8, n0_.destinataire_id AS destinataire_id_9 FROM notification n0_ WHERE n0_.permission IN (?, ?, ?, ?, ?) AND n0_.unread = 1 ORDER BY n0_.created_at DESC
Parameters: [
"ROLE_ADMIN"
"ROLE_DELIVERY"
"ROLE_CANCEL"
"ROLE_EMISSION"
"ROLE_USER"
]
SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.link_to AS link_to_2, n0_.unread AS unread_3, n0_.permission AS permission_4, n0_.created_at AS created_at_5, n0_.updated_at AS updated_at_6, n0_.document_id AS document_id_7, n0_.owner_id AS owner_id_8, n0_.destinataire_id AS destinataire_id_9 FROM notification n0_ WHERE n0_.permission IN ('ROLE_ADMIN', 'ROLE_DELIVERY', 'ROLE_CANCEL', 'ROLE_EMISSION', 'ROLE_USER') AND n0_.unread = 1 ORDER BY n0_.created_at DESC;
|
| 5 |
0.71 ms |
SELECT m0_.id AS id_0, m0_.commentaire AS commentaire_1, m0_.unread AS unread_2, m0_.link_to AS link_to_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.emissaire_id AS emissaire_id_6, m0_.destinataire_id AS destinataire_id_7, m0_.document_id AS document_id_8 FROM message m0_ WHERE m0_.destinataire_id = ? AND m0_.unread = 1 ORDER BY m0_.created_at DESC
SELECT m0_.id AS id_0, m0_.commentaire AS commentaire_1, m0_.unread AS unread_2, m0_.link_to AS link_to_3, m0_.created_at AS created_at_4, m0_.updated_at AS updated_at_5, m0_.emissaire_id AS emissaire_id_6, m0_.destinataire_id AS destinataire_id_7, m0_.document_id AS document_id_8 FROM message m0_ WHERE m0_.destinataire_id = 163 AND m0_.unread = 1 ORDER BY m0_.created_at DESC;
|
| 6 |
0.27 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 5;
|
| 7 |
0.22 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = 3;
|
| 8 |
0.18 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 3;
|
| 9 |
0.24 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 4;
|
| 10 |
0.18 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = 7;
|
| 11 |
0.17 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 2;
|
| 12 |
0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = 4;
|
| 13 |
0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 14;
|
| 14 |
0.17 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 1;
|
| 15 |
0.20 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 18;
|
| 16 |
0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = 2;
|
| 17 |
0.16 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 13;
|
| 18 |
0.19 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = 8;
|
| 19 |
0.32 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 6;
|
| 20 |
0.28 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0 WHERE t0.id = 9;
|
| 21 |
0.28 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 7;
|
| 22 |
0.26 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 15;
|
| 23 |
0.23 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 17;
|
| 24 |
0.25 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM service t0 WHERE t0.id = 12;
|