Symfony Profiler

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;

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;

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.id = ?

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.id = '40';

SELECT
  t0.id AS id_1,
  t0.commentaire AS commentaire_2,
  t0.unread AS unread_3,
  t0.link_to AS link_to_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.emissaire_id AS emissaire_id_7,
  t0.destinataire_id AS destinataire_id_8,
  t0.document_id AS document_id_9
FROM
  message t0
WHERE
  t0.document_id = ?
  AND t0.unread = ?
  AND t0.destinataire_id = ?

SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.unread AS unread_3, t0.link_to AS link_to_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.emissaire_id AS emissaire_id_7, t0.destinataire_id AS destinataire_id_8, t0.document_id AS document_id_9 FROM message t0 WHERE t0.document_id = 40 AND t0.unread = 1 AND t0.destinataire_id = 163;

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

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;

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;

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 = 150;

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 = 147;

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 = 225;

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 = 204;

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
  INNER JOIN document_user ON t0.id = document_user.user_id
WHERE
  document_user.document_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 INNER JOIN document_user ON t0.id = document_user.user_id WHERE document_user.document_id = 40;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.marque AS marque_3,
  t0.immatriculation AS immatriculation_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  vehicule t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.marque AS marque_3, t0.immatriculation AS immatriculation_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM vehicule t0 WHERE t0.id = 33;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  ville t0
  INNER JOIN document_ville ON t0.id = document_ville.ville_id
WHERE
  document_ville.document_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM ville t0 INNER JOIN document_ville ON t0.id = document_ville.ville_id WHERE document_ville.document_id = 40;

SELECT
  t0.id AS id_1,
  t0.ordre AS ordre_2,
  t0.ville_id AS ville_id_3,
  t0.mission_id AS mission_id_4
FROM
  itineraire t0
WHERE
  t0.mission_id = ?

SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.ville_id AS ville_id_3, t0.mission_id AS mission_id_4 FROM itineraire t0 WHERE t0.mission_id = 40;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.nom AS nom_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  ville t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM ville t0 WHERE t0.id = 214;