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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
9.57 ms
(52.08%)
32
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
]
3.28 ms
(17.86%)
4
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
]
1.98 ms
(10.79%)
3
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"
]
0.94 ms
(5.10%)
1
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:
[]
0.70 ms
(3.81%)
1
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
]
0.70 ms
(3.79%)
1
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
]
0.63 ms
(3.42%)
1
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:
[]
0.58 ms
(3.15%)
1
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:
[]

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.