GET https://axiumv2.optimumci.com/domain/controle/versement

Query Metrics

44 Database Queries
8 Different statements
18.37 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 1.50 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.password AS password_8, t0.refresh_token AS refresh_token_9, t0.refresh_token_expires_at AS refresh_token_expires_at_10, t0.has_permis_de_conduire AS has_permis_de_conduire_11, t0.apps AS apps_12, t0.slug AS slug_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.station_id AS station_id_16, t0.lieu_empotage_id AS lieu_empotage_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  5
]
2 0.70 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:
[
  5
]
3 0.70 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.54 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:
[
  240
]
5 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:
[
  198
]
6 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:
[
  199
]
7 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:
[
  201
]
8 0.37 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:
[
  202
]
9 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:
[
  178
]
10 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:
[
  179
]
11 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:
[
  58
]
12 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:
[
  59
]
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:
[
  61
]
14 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:
[
  62
]
15 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:
[
  63
]
16 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:
[
  64
]
17 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:
[
  65
]
18 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:
[
  66
]
19 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:
[
  43
]
20 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:
[
  44
]
21 0.22 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
]
22 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:
[
  46
]
23 0.21 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
]
24 0.21 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:
[
  53
]
25 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:
[
  54
]
26 0.21 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:
[
  56
]
27 0.21 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:
[
  57
]
28 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:
[
  119
]
29 0.23 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:
[
  120
]
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:
[
  122
]
31 0.23 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
]
32 0.23 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
]
33 0.23 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:
[
  101
]
34 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:
[
  103
]
35 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:
[
  104
]
36 0.94 ms
SELECT t0.id AS id_1, t0.montant AS montant_2, t0.date AS date_3, t0.reference AS reference_4, t0.justificatif AS justificatif_5, t0.commentaire AS commentaire_6, t0.statut AS statut_7, t0.motif_rejet AS motif_rejet_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.station_id AS station_id_11, t0.banque_id AS banque_id_12, t0.operation_user_id AS operation_user_id_13 FROM versement t0 ORDER BY t0.date DESC
Parameters:
[]
37 0.70 ms
SELECT v0_.statut AS statut_0, SUM(v0_.montant) AS sclr_1, COUNT(v0_.id) AS sclr_2 FROM versement v0_ WHERE v0_.date >= ? GROUP BY v0_.statut
Parameters:
[
  "2026-03-31 00:00:00"
]
38 0.58 ms
SELECT v0_.statut AS statut_0, SUM(v0_.montant) AS sclr_1, COUNT(v0_.id) AS sclr_2 FROM versement v0_ WHERE v0_.date >= ? GROUP BY v0_.statut
Parameters:
[
  "2026-03-30 00:00:00"
]
39 0.70 ms
SELECT v0_.statut AS statut_0, SUM(v0_.montant) AS sclr_1, COUNT(v0_.id) AS sclr_2 FROM versement v0_ WHERE v0_.date >= ? GROUP BY v0_.statut
Parameters:
[
  "2026-03-01 00:00:00"
]
40 0.58 ms
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.code AS code_2, b0_.numero_compte AS numero_compte_3, b0_.statut AS statut_4, b0_.created_at AS created_at_5, b0_.updated_at AS updated_at_6 FROM banque b0_
Parameters:
[]
41 0.63 ms
SELECT s0_.id AS id_0, s0_.libelle AS libelle_1, s0_.latitude AS latitude_2, s0_.longitude AS longitude_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.gerant_id AS gerant_id_6, s0_.localite_id AS localite_id_7 FROM station_service s0_
Parameters:
[]
42 0.71 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.password AS password_8, t0.refresh_token AS refresh_token_9, t0.refresh_token_expires_at AS refresh_token_expires_at_10, t0.has_permis_de_conduire AS has_permis_de_conduire_11, t0.apps AS apps_12, t0.slug AS slug_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.station_id AS station_id_16, t0.lieu_empotage_id AS lieu_empotage_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  3
]
43 0.55 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.password AS password_8, t0.refresh_token AS refresh_token_9, t0.refresh_token_expires_at AS refresh_token_expires_at_10, t0.has_permis_de_conduire AS has_permis_de_conduire_11, t0.apps AS apps_12, t0.slug AS slug_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.station_id AS station_id_16, t0.lieu_empotage_id AS lieu_empotage_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  6
]
44 0.53 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.password AS password_8, t0.refresh_token AS refresh_token_9, t0.refresh_token_expires_at AS refresh_token_expires_at_10, t0.has_permis_de_conduire AS has_permis_de_conduire_11, t0.apps AS apps_12, t0.slug AS slug_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.station_id AS station_id_16, t0.lieu_empotage_id AS lieu_empotage_id_17 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Admin\User
  • The association App\Entity\Admin\User#bonDeLivraisons refers to the owning side field App\Entity\Domain\Chargement\BonDeLivraison#gerant which does not exist.
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\GestionStock\AchatMateriel No errors.
App\Entity\Domain\Flotte\ArchivesNormes No errors.
App\Entity\Domain\Depotage\Depotage
  • The mappings App\Entity\Domain\Depotage\Depotage#gerant and App\Entity\Admin\User#depotages are inconsistent with each other.
App\Entity\Domain\Chargement\BonDeLivraison 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\Flotte\SortieVehiculeUser No errors.
App\Entity\Domain\Controle\Versement No errors.
App\Entity\Domain\Controle\Credit
  • The field 'App\Entity\Domain\Controle\Credit#litrage' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\Admin\RolePermission No errors.
App\Entity\Admin\Permission No errors.
App\Entity\Domain\System\Banque No errors.
App\Entity\Domain\System\Localite
  • The association App\Entity\Domain\System\Localite#voyageLocalites refers to the owning side field App\Entity\Domain\GesVoyage\VoyageLocalite#localite which does not exist.
App\Entity\Domain\GesVoyage\VoyageLocalite No errors.
App\Entity\Domain\Controle\Cuve No errors.
App\Entity\Domain\Controle\Pompe No errors.
App\Entity\Domain\Controle\Inventaire No errors.
App\Entity\Domain\Controle\RegelementCredit No errors.