Redirect 302 redirect from GET @dashboard (7a3407)

GET https://axiumv2.optimumci.com/commercial/dashboard

Query Metrics

83 Database Queries
26 Different statements
42.57 ms Query time
3 Invalid entities
485 Managed entities

Queries

Group similar statements

# Time Info
1 1.36 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.nom AS nom_3, t0.prenom AS prenom_4, t0.fonction AS fonction_5, t0.photo AS photo_6, t0.roles AS roles_7, t0.refresh_token AS refresh_token_8, t0.refresh_token_expires_at AS refresh_token_expires_at_9, t0.apps AS apps_10, t0.signature AS signature_11, t0.fleet_refresh_token AS fleet_refresh_token_12, t0.password AS password_13, t0.slug AS slug_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.station_id AS station_id_17, t0.lieu_empotage_id AS lieu_empotage_id_18 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  21
]
2 0.90 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM role t0 INNER JOIN role_user ON t0.id = role_user.role_id WHERE role_user.user_id = ?
Parameters:
[
  21
]
3 0.85 ms
SELECT t0.id AS id_1, t0.entity AS entity_2, t0.role_id AS role_id_3, t0.permission_id AS permission_id_4 FROM role_permission t0 WHERE t0.role_id = ?
Parameters:
[
  2
]
4 0.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  138
]
5 0.49 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  24
]
6 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  25
]
7 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  44
]
8 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  45
]
9 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  46
]
10 0.48 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  47
]
11 0.51 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  50
]
12 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  51
]
13 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  54
]
14 0.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  75
]
15 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  76
]
16 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  78
]
17 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  79
]
18 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  80
]
19 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  81
]
20 0.32 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  82
]
21 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  83
]
22 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  89
]
23 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  90
]
24 0.34 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  92
]
25 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  93
]
26 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  108
]
27 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  109
]
28 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  111
]
29 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  112
]
30 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  153
]
31 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  154
]
32 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  155
]
33 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  156
]
34 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  61
]
35 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  62
]
36 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  64
]
37 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  65
]
38 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  66
]
39 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  67
]
40 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  68
]
41 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  69
]
42 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  88
]
43 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  97
]
44 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  73
]
45 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  74
]
46 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  99
]
47 0.30 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  100
]
48 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  102
]
49 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  103
]
50 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  19
]
51 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  20
]
52 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  129
]
53 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  130
]
54 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  132
]
55 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  133
]
56 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  122
]
57 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  123
]
58 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  125
]
59 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  126
]
60 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  34
]
61 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.entity AS entity_3, t0.value AS value_4 FROM permission t0 WHERE t0.id = ?
Parameters:
[
  35
]
62 1.77 ms
SELECT v0_.id AS id_0, v0_.montant AS montant_1, v0_.date AS date_2, v0_.reference AS reference_3, v0_.justificatif AS justificatif_4, v0_.commentaire AS commentaire_5, v0_.statut AS statut_6, v0_.motif_rejet AS motif_rejet_7, v0_.type AS type_8, v0_.date_debut AS date_debut_9, v0_.date_fin AS date_fin_10, v0_.created_at AS created_at_11, v0_.updated_at AS updated_at_12, v0_.station_id AS station_id_13, v0_.banque_id AS banque_id_14, v0_.operation_user_id AS operation_user_id_15 FROM versement v0_ WHERE v0_.date BETWEEN ? AND ? ORDER BY v0_.date DESC
Parameters:
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
63 1.19 ms
SELECT c0_.id AS id_0, c0_.ref AS ref_1, c0_.litrage AS litrage_2, c0_.montant_accorde AS montant_accorde_3, c0_.montant_restant AS montant_restant_4, c0_.date AS date_5, c0_.echeance AS echeance_6, c0_.motif AS motif_7, c0_.statut AS statut_8, c0_.validation_statut AS validation_statut_9, c0_.motif_rejet AS motif_rejet_10, c0_.nature AS nature_11, c0_.immatriculation AS immatriculation_12, c0_.with_echeance AS with_echeance_13, c0_.camion_id AS camion_id_14, c0_.vehicule_id AS vehicule_id_15, c0_.counter_year AS counter_year_16, c0_.slug AS slug_17, c0_.created_at AS created_at_18, c0_.updated_at AS updated_at_19, c0_.client_id AS client_id_20, c0_.station_id AS station_id_21, c0_.produit_id AS produit_id_22, c0_.operation_user_id AS operation_user_id_23, c0_.type_credit_id AS type_credit_id_24, c0_.pompiste_id AS pompiste_id_25 FROM credit c0_ WHERE c0_.date BETWEEN ? AND ?
Parameters:
[
  "2026-01-01 00:00:00"
  "2026-12-31 23:59:59"
]
64 4.71 ms
SELECT v0_.id AS id_0, v0_.ref AS ref_1, v0_.date AS date_2, v0_.index_ouverture AS index_ouverture_3, v0_.index_cloture AS index_cloture_4, v0_.retour_en_cuve AS retour_en_cuve_5, v0_.vente AS vente_6, v0_.ca AS ca_7, v0_.jauge_ouverture AS jauge_ouverture_8, v0_.jauge_cloture AS jauge_cloture_9, v0_.stock_theorique AS stock_theorique_10, v0_.ecart AS ecart_11, v0_.stock_cuve_restant AS stock_cuve_restant_12, v0_.commentaire AS commentaire_13, v0_.statut AS statut_14, v0_.motif_rejet AS motif_rejet_15, v0_.counter_year AS counter_year_16, v0_.created_at AS created_at_17, v0_.updated_at AS updated_at_18, d1_.id AS id_19, d1_.index_ouverture AS index_ouverture_20, d1_.index_cloture AS index_cloture_21, d1_.retour_en_cuve AS retour_en_cuve_22, d1_.produit_vendu AS produit_vendu_23, d1_.ca AS ca_24, d1_.product_name AS product_name_25, d1_.jauge_ouverture AS jauge_ouverture_26, d1_.jauge_cloture AS jauge_cloture_27, d1_.stock_restant AS stock_restant_28, d1_.stock_vendu AS stock_vendu_29, d1_.type AS type_30, d1_.stock_reception AS stock_reception_31, d1_.stock_cuve_av_vente AS stock_cuve_av_vente_32, d1_.created_at AS created_at_33, d1_.updated_at AS updated_at_34, v0_.operation_user_id AS operation_user_id_35, v0_.station_id AS station_id_36, d1_.pompe_id AS pompe_id_37, d1_.vente_id AS vente_id_38, d1_.cuve_id AS cuve_id_39 FROM vente v0_ LEFT JOIN details_vente d1_ ON v0_.id = d1_.vente_id WHERE YEAR(v0_.date) = YEAR(CURRENT_DATE) ORDER BY v0_.date ASC
Parameters:
[]
65 0.64 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM credit c0_ WHERE c0_.statut IN (?, ?) AND c0_.echeance < ?
Parameters:
[
  "actif"
  "en_retard"
  "2026-09-24 14:55:19"
]
66 0.52 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM credit c0_ WHERE c0_.statut = ? AND c0_.echeance >= ? AND c0_.echeance <= ?
Parameters:
[
  "actif"
  "2026-09-24 14:55:19"
  "2026-10-08 14:55:19"
]
67 0.50 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM credit c0_ WHERE c0_.statut = ? AND c0_.montant_restant > 0 AND c0_.echeance < ?
Parameters:
[
  "actif"
  "2026-09-24 14:55:19"
]
68 0.42 ms
SELECT COUNT(c0_.id) AS sclr_0 FROM credit c0_ WHERE c0_.statut = ?
Parameters:
[
  "solde"
]
69 0.49 ms
SELECT COALESCE(SUM(c0_.montant_restant), 0) AS sclr_0 FROM credit c0_ WHERE c0_.statut = ?
Parameters:
[
  "actif"
]
70 0.65 ms
SELECT COUNT(DISTINCT c0_.client_id) AS sclr_0 FROM credit c0_ WHERE c0_.statut = ?
Parameters:
[
  "actif"
]
71 0.49 ms
SELECT COALESCE(AVG(c0_.montant_accorde), 0) AS sclr_0 FROM credit c0_ WHERE c0_.statut = ?
Parameters:
[
  "actif"
]
72 0.94 ms
SELECT DATE_FORMAT(r0_.date, '%Y-%m') AS sclr_0, DATE_FORMAT(r0_.date, '%b %y') AS sclr_1, SUM(r0_.montant) AS sclr_2 FROM regelement_credit r0_ WHERE r0_.date >= ? GROUP BY sclr_0, sclr_1 ORDER BY sclr_0 ASC
Parameters:
[
  "2026-03-24 14:55:19"
]
73 0.60 ms
SELECT DATE_FORMAT(r0_.date, '%Y-%m') AS sclr_0, SUM(c1_.montant_accorde) AS sclr_1 FROM regelement_credit r0_ INNER JOIN credit c1_ ON r0_.credit_id = c1_.id WHERE r0_.date >= ? GROUP BY sclr_0
Parameters:
[
  "2026-03-24 14:55:19"
]
74 0.92 ms
SELECT c0_.raison_sociale AS raison_sociale_0, SUM(c1_.montant_accorde) AS sclr_1, COALESCE(SUM(c1_.montant_restant), 0) AS sclr_2 FROM credit c1_ INNER JOIN client c0_ ON c1_.client_id = c0_.id WHERE c1_.statut IN (?, ?) GROUP BY c0_.id, c0_.raison_sociale ORDER BY sclr_1 DESC LIMIT 6
Parameters:
[
  "actif"
  "en_retard"
]
75 0.78 ms
SELECT c0_.raison_sociale AS raison_sociale_0, c0_.cumule_credit AS cumule_credit_1, c0_.plafond_credit AS plafond_credit_2 FROM credit c1_ INNER JOIN client c0_ ON c1_.client_id = c0_.id WHERE c1_.statut = ? AND c0_.plafond_credit > 0 GROUP BY c0_.id, c0_.raison_sociale, c0_.cumule_credit, c0_.plafond_credit ORDER BY c0_.cumule_credit DESC LIMIT 10
Parameters:
[
  "actif"
]
76 1.43 ms
SELECT v0_.id AS id_0, v0_.montant AS montant_1, v0_.date AS date_2, v0_.reference AS reference_3, v0_.justificatif AS justificatif_4, v0_.commentaire AS commentaire_5, v0_.statut AS statut_6, v0_.motif_rejet AS motif_rejet_7, v0_.type AS type_8, v0_.date_debut AS date_debut_9, v0_.date_fin AS date_fin_10, v0_.created_at AS created_at_11, v0_.updated_at AS updated_at_12, s1_.id AS id_13, s1_.libelle AS libelle_14, s1_.ref_client AS ref_client_15, s1_.latitude AS latitude_16, s1_.longitude AS longitude_17, s1_.created_at AS created_at_18, s1_.updated_at AS updated_at_19, b2_.id AS id_20, b2_.name AS name_21, b2_.code AS code_22, b2_.numero_compte AS numero_compte_23, b2_.statut AS statut_24, b2_.created_at AS created_at_25, b2_.updated_at AS updated_at_26, v0_.station_id AS station_id_27, v0_.banque_id AS banque_id_28, v0_.operation_user_id AS operation_user_id_29, s1_.localite_id AS localite_id_30 FROM versement v0_ LEFT JOIN station_service s1_ ON v0_.station_id = s1_.id LEFT JOIN banque b2_ ON v0_.banque_id = b2_.id ORDER BY v0_.date DESC LIMIT 8
Parameters:
[]
77 0.88 ms
SELECT v0_.id AS id_0, v0_.ref AS ref_1, v0_.date AS date_2, v0_.index_ouverture AS index_ouverture_3, v0_.index_cloture AS index_cloture_4, v0_.retour_en_cuve AS retour_en_cuve_5, v0_.vente AS vente_6, v0_.ca AS ca_7, v0_.jauge_ouverture AS jauge_ouverture_8, v0_.jauge_cloture AS jauge_cloture_9, v0_.stock_theorique AS stock_theorique_10, v0_.ecart AS ecart_11, v0_.stock_cuve_restant AS stock_cuve_restant_12, v0_.commentaire AS commentaire_13, v0_.statut AS statut_14, v0_.motif_rejet AS motif_rejet_15, v0_.counter_year AS counter_year_16, v0_.created_at AS created_at_17, v0_.updated_at AS updated_at_18, s1_.id AS id_19, s1_.libelle AS libelle_20, s1_.ref_client AS ref_client_21, s1_.latitude AS latitude_22, s1_.longitude AS longitude_23, s1_.created_at AS created_at_24, s1_.updated_at AS updated_at_25, v0_.operation_user_id AS operation_user_id_26, v0_.station_id AS station_id_27, s1_.localite_id AS localite_id_28 FROM vente v0_ LEFT JOIN station_service s1_ ON v0_.station_id = s1_.id ORDER BY v0_.date DESC, v0_.id DESC LIMIT 8
Parameters:
[]
78 0.46 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.ref_client AS ref_client_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.localite_id AS localite_id_8 FROM station_service t0 WHERE t0.id = ?
Parameters:
[
  5
]
79 0.89 ms
SELECT b0_.name AS name_0, COALESCE(SUM(v1_.montant), 0) AS sclr_1 FROM versement v1_ INNER JOIN banque b0_ ON v1_.banque_id = b0_.id WHERE v1_.statut = ? GROUP BY b0_.id, b0_.name ORDER BY sclr_1 DESC LIMIT 10
Parameters:
[
  "valide"
]
80 0.79 ms
SELECT DATE_FORMAT(v0_.date, '%Y-%m') AS sclr_0, DATE_FORMAT(v0_.date, '%b %Y') AS sclr_1, COALESCE(SUM(v0_.montant), 0) AS sclr_2 FROM versement v0_ WHERE v0_.statut = ? AND v0_.date >= ? GROUP BY sclr_0, sclr_1 ORDER BY sclr_0 ASC
Parameters:
[
  "valide"
  "2025-09-24 14:55:19"
]
81 0.79 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.need_camion AS need_camion_3, t0.need_vehicule AS need_vehicule_4, t0.need_litrage_field AS need_litrage_field_5, t0.need_pompiste AS need_pompiste_6, t0.need_motif AS need_motif_7, t0.need_immatriculation_field AS need_immatriculation_field_8, t0.need_nature_field AS need_nature_field_9 FROM type_credit t0 WHERE t0.id = ?
Parameters:
[
  1
]
82 0.78 ms
SELECT p0_.libelle AS libelle_0, p1_.prix AS prix_1 FROM prix_produit p1_ LEFT JOIN produit p0_ ON (p0_.id = p1_.produit_id) WHERE YEAR(p1_.date) = ? AND MONTH(p1_.date) = ?
Parameters:
[
  2026
  9
]
83 0.46 ms
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.code AS code_3 FROM produit t0
Parameters:
[]

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\Domain\Controle\DetailsVente 209
App\Entity\Domain\Controle\Versement 71
App\Entity\Admin\RolePermission 58
App\Entity\Admin\Permission 58
App\Entity\Domain\Controle\Vente 24
App\Entity\Domain\Controle\Pompe 23
App\Entity\Domain\Controle\Credit 11
App\Entity\Domain\Controle\Cuve 10
App\Entity\Admin\User 5
App\Entity\Domain\Chargement\StationService 4
App\Entity\Domain\System\Banque 4
App\Entity\Domain\System\Localite 3
App\Entity\Domain\Params\Produit 2
App\Entity\Admin\Role 1
App\Entity\Domain\System\Client 1
App\Entity\Domain\Controle\TypeCredit 1

Entities Mapping

Class Mapping errors
App\Entity\Admin\User
  • The mappings App\Entity\Admin\User#detailBonDeLivraisonsGerant and App\Entity\Domain\Chargement\DetailBonDeLivraison#gerant are inconsistent with each other.
App\Entity\Domain\Chargement\StationService
  • The mappings App\Entity\Domain\Chargement\StationService#produit and App\Entity\Domain\Controle\Cuve#station are inconsistent with each other.
App\Entity\Domain\Chargement\LieuEmpotage No errors.
App\Entity\Admin\Role No errors.
App\Entity\Domain\Depotage\Depotage No errors.
App\Entity\Domain\Chargement\DetailBonDeLivraison
  • The mappings App\Entity\Domain\Chargement\DetailBonDeLivraison#gerant and App\Entity\Admin\User#detailBonDeLivraisons are inconsistent with each other.
App\Entity\Domain\Controle\Versement No errors.
App\Entity\Domain\Controle\Credit No errors.
App\Entity\Domain\Controle\Vente No errors.
App\Entity\Domain\Chargement\BonDeLivraison No errors.
App\Entity\Admin\RolePermission No errors.
App\Entity\Admin\Permission No errors.
App\Entity\Domain\System\Banque No errors.
App\Entity\Domain\System\Client No errors.
App\Entity\Domain\Params\Produit No errors.
App\Entity\Domain\Controle\TypeCredit No errors.
App\Entity\Domain\System\Pompiste No errors.
App\Entity\Domain\Controle\RegelementCredit No errors.
App\Entity\Domain\Controle\DetailsVente No errors.
App\Entity\Domain\Controle\Pompe No errors.
App\Entity\Domain\Controle\Cuve No errors.
App\Entity\Domain\System\Localite No errors.
App\Entity\Domain\Controle\Inventaire No errors.
App\Entity\Domain\Params\PrixProduit No errors.
App\Entity\Domain\Flotte\Trailer No errors.
App\Entity\Domain\Flotte\Tractor No errors.