GET https://www.logisport.pro/

Response
200 OK
Browse referrer URL
IP
160.154.231.143
Profiled on
Token
94e9d3

Query Metrics

26 Database Queries
17 Different statements
21.00 ms Query time
0 Invalid entities
276 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.48 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 = ?
Parameters: 
[
  147
]
View formatted query    View runnable query    Explain query    View query backtrace
2 0.42 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 = ?
Parameters: 
[
  147
]
View formatted query    View runnable query    Explain query    View query backtrace
3 0.48 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3 FROM departement t0
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
4 1.31 ms 
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
Parameters: 
[]
View formatted query    View runnable query    Explain query    View query backtrace
5 1.04 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE d0_.date BETWEEN ? AND ?
Parameters: 
[
  "2026-04-01 00:00:00"
  "2026-04-30 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
6 0.93 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE d0_.statut NOT IN (?, ?, ?)
Parameters: 
[
  "REJECTED"
  "DELIVERED"
  "CANCELED"
]
View formatted query    View runnable query    Explain query    View query backtrace
7 1.28 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE d0_.statut = ?
Parameters: 
[
  "DELIVERED"
]
View formatted query    View runnable query    Explain query    View query backtrace
8 0.89 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.statut IN (?)
Parameters: 
[
  "2026-04-01 00:00:00"
  "2026-04-30 23:59:59"
  "DELIVERED"
]
View formatted query    View runnable query    Explain query    View query backtrace
9 1.24 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.type_document = ? AND d0_.statut IN (?) ORDER BY d0_.date ASC
Parameters: 
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  "ORDRE_MISSION"
  "DELIVERED"
]
View formatted query    View runnable query    Explain query    View query backtrace
10 0.84 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE d0_.date BETWEEN ? AND ?
Parameters: 
[
  "2026-04-01 00:00:00"
  "2026-04-30 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
11 0.83 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.statut IN (?, ?, ?, ?, ?, ?)
Parameters: 
[
  "2026-04-01 00:00:00"
  "2026-04-30 23:59:59"
  "PENDING"
  "PENDING_UPDATE"
  "SUBMITTED"
  "VALIDATED_STEP_1"
  "VALIDATED_STEP_2"
  "VALIDATED_STEP_3"
]
View formatted query    View runnable query    Explain query    View query backtrace
12 0.75 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.statut IN (?)
Parameters: 
[
  "2026-04-01 00:00:00"
  "2026-04-30 23:59:59"
  "REJECTED"
]
View formatted query    View runnable query    Explain query    View query backtrace
13 0.76 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.statut IN (?)
Parameters: 
[
  "2026-04-01 00:00:00"
  "2026-04-30 23:59:59"
  "DELIVERED"
]
View formatted query    View runnable query    Explain query    View query backtrace
14 0.74 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.statut IN (?)
Parameters: 
[
  "2026-04-01 00:00:00"
  "2026-04-30 23:59:59"
  "CANCELED"
]
View formatted query    View runnable query    Explain query    View query backtrace
15 1.26 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.type_document = ? ORDER BY d0_.date ASC
Parameters: 
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  "ORDRE_MISSION"
]
View formatted query    View runnable query    Explain query    View query backtrace
16 0.73 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.type_document = ? AND d0_.statut IN (?, ?, ?, ?, ?, ?) ORDER BY d0_.date ASC
Parameters: 
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  "ORDRE_MISSION"
  "PENDING"
  "PENDING_UPDATE"
  "SUBMITTED"
  "VALIDATED_STEP_1"
  "VALIDATED_STEP_2"
  "VALIDATED_STEP_3"
]
View formatted query    View runnable query    Explain query    View query backtrace
17 0.72 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.type_document = ? AND d0_.statut IN (?) ORDER BY d0_.date ASC
Parameters: 
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  "ORDRE_MISSION"
  "REJECTED"
]
View formatted query    View runnable query    Explain query    View query backtrace
18 1.40 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.type_document = ? AND d0_.statut IN (?) ORDER BY d0_.date ASC
Parameters: 
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  "ORDRE_MISSION"
  "DELIVERED"
]
View formatted query    View runnable query    Explain query    View query backtrace
19 0.85 ms 
SELECT d0_.id AS id_0, d0_.reference AS reference_1, d0_.objet AS objet_2, d0_.debut AS debut_3, d0_.fin AS fin_4, d0_.objectif AS objectif_5, d0_.carburant AS carburant_6, d0_.nature_equipement AS nature_equipement_7, d0_.total AS total_8, d0_.statut AS statut_9, d0_.date AS date_10, d0_.validated1_at AS validated1_at_11, d0_.validated2_at AS validated2_at_12, d0_.validated3_at AS validated3_at_13, d0_.delivery_at AS delivery_at_14, d0_.cancelled_at AS cancelled_at_15, d0_.motif_rejet AS motif_rejet_16, d0_.modif AS modif_17, d0_.rejected_at AS rejected_at_18, d0_.type_document AS type_document_19, d0_.heure_reprise AS heure_reprise_20, d0_.created_at AS created_at_21, d0_.updated_at AS updated_at_22, d0_.vehicule_id AS vehicule_id_23, d0_.validated1_by_id AS validated1_by_id_24, d0_.validated2_by_id AS validated2_by_id_25, d0_.validated3_by_id AS validated3_by_id_26, d0_.titulaire_id AS titulaire_id_27, d0_.owner_id AS owner_id_28, d0_.delivery_by_id AS delivery_by_id_29, d0_.cancelled_by_id AS cancelled_by_id_30, d0_.rejected_by_id AS rejected_by_id_31, d0_.asked_by_id AS asked_by_id_32 FROM document d0_ WHERE (d0_.date BETWEEN ? AND ?) AND d0_.type_document = ? AND d0_.statut IN (?) ORDER BY d0_.date ASC
Parameters: 
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
  "ORDRE_MISSION"
  "CANCELED"
]
View formatted query    View runnable query    Explain query    View query backtrace
20 0.73 ms 
SELECT
            MONTH(d.date) as mois,
            SUM(d.total) as totalCharge
        FROM document d
        WHERE d.statut = :statut AND YEAR(d.date) = :an
        GROUP BY MONTH(d.date)
        ORDER BY mois ASC
Parameters: 
[
  "statut" => "DELIVERED"
  "an" => "2026"
]
View formatted query    View runnable query    Explain query    View query backtrace
21 0.52 ms 
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.statut = ? AND (d0_.date >= ? AND d0_.date <= ?)
Parameters: 
[
  "DELIVERED"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
22 0.49 ms 
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.statut IN (?, ?, ?, ?, ?, ?) AND (d0_.date >= ? AND d0_.date <= ?)
Parameters: 
[
  "PENDING"
  "PENDING_UPDATE"
  "SUBMITTED"
  "VALIDATED_STEP_1"
  "VALIDATED_STEP_2"
  "VALIDATED_STEP_3"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
23 0.44 ms 
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.statut = ? AND (d0_.date >= ? AND d0_.date <= ?)
Parameters: 
[
  "REJECTED"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
24 0.42 ms 
SELECT COUNT(d0_.id) AS sclr_0 FROM document d0_ WHERE d0_.statut = ? AND (d0_.date >= ? AND d0_.date <= ?)
Parameters: 
[
  "CANCELED"
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
View formatted query    View runnable query    Explain query    View query backtrace
25 1.04 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_VALIDATE_STEP_1"
  "ROLE_USER"
]
View formatted query    View runnable query    Explain query    View query backtrace
26 0.40 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
Parameters: 
[
  147
]
View formatted query    View runnable query    Explain query    View query backtrace

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Document 204
App\Entity\User 46
App\Entity\Vehicule 18
App\Entity\Departement 6
App\Entity\Service 1
App\Entity\Permission 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Service No errors.
App\Entity\Departement No errors.
App\Entity\Document No errors.
App\Entity\Permission No errors.
App\Entity\Notification No errors.
App\Entity\DetailItineraire No errors.
App\Entity\Message No errors.
App\Entity\Vehicule No errors.
App\Entity\Ville No errors.
App\Entity\Itineraire No errors.
App\Entity\DetailPeage No errors.