5.79 ms (34.62%)
|
16 |
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 = 164;
|
0.87 ms (5.22%)
|
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.objet AS objet_3, t0.debut AS debut_4, t0.fin AS fin_5, t0.objectif AS objectif_6, t0.carburant AS carburant_7, t0.nature_equipement AS nature_equipement_8, t0.total AS total_9, t0.statut AS statut_10, t0.date AS date_11, t0.validated1_at AS validated1_at_12, t0.validated2_at AS validated2_at_13, t0.validated3_at AS validated3_at_14, t0.delivery_at AS delivery_at_15, t0.cancelled_at AS cancelled_at_16, t0.motif_rejet AS motif_rejet_17, t0.modif AS modif_18, t0.rejected_at AS rejected_at_19, t0.type_document AS type_document_20, t0.heure_reprise AS heure_reprise_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.vehicule_id AS vehicule_id_24, t0.validated1_by_id AS validated1_by_id_25, t0.validated2_by_id AS validated2_by_id_26, t0.validated3_by_id AS validated3_by_id_27, t0.titulaire_id AS titulaire_id_28, t0.owner_id AS owner_id_29, t0.delivery_by_id AS delivery_by_id_30, t0.cancelled_by_id AS cancelled_by_id_31, t0.rejected_by_id AS rejected_by_id_32, t0.asked_by_id AS asked_by_id_33 FROM document t0 WHERE t0.type_document = ? ORDER BY t0.date DESC LIMIT 25
Parameters: [
"ORDRE_MISSION"
]
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.objet AS objet_3, t0.debut AS debut_4, t0.fin AS fin_5, t0.objectif AS objectif_6, t0.carburant AS carburant_7, t0.nature_equipement AS nature_equipement_8, t0.total AS total_9, t0.statut AS statut_10, t0.date AS date_11, t0.validated1_at AS validated1_at_12, t0.validated2_at AS validated2_at_13, t0.validated3_at AS validated3_at_14, t0.delivery_at AS delivery_at_15, t0.cancelled_at AS cancelled_at_16, t0.motif_rejet AS motif_rejet_17, t0.modif AS modif_18, t0.rejected_at AS rejected_at_19, t0.type_document AS type_document_20, t0.heure_reprise AS heure_reprise_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.vehicule_id AS vehicule_id_24, t0.validated1_by_id AS validated1_by_id_25, t0.validated2_by_id AS validated2_by_id_26, t0.validated3_by_id AS validated3_by_id_27, t0.titulaire_id AS titulaire_id_28, t0.owner_id AS owner_id_29, t0.delivery_by_id AS delivery_by_id_30, t0.cancelled_by_id AS cancelled_by_id_31, t0.rejected_by_id AS rejected_by_id_32, t0.asked_by_id AS asked_by_id_33 FROM document t0 WHERE t0.type_document = 'ORDRE_MISSION' ORDER BY t0.date DESC LIMIT 25;
|
0.64 ms (3.81%)
|
1 |
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_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_DELIVERY', 'ROLE_CANCEL', 'ROLE_EMISSION', 'ROLE_USER') AND n0_.unread = 1 ORDER BY n0_.created_at DESC;
|