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

Query Metrics

46 Database Queries
10 Different statements
23.85 ms Query time
8 Invalid entities

Grouped Statements

Show all queries

Time Count Info
13.71 ms
(57.46%)
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.57 ms
(14.96%)
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
]
2.06 ms
(8.64%)
3
SELECT c0_.statut AS statut_0, SUM(c0_.montant_accorde) AS sclr_1, SUM(c0_.montant_restant) AS sclr_2, COUNT(c0_.id) AS sclr_3 FROM credit c0_ WHERE c0_.date >= ? GROUP BY c0_.statut
Parameters:
[
  "2026-03-31 00:00:00"
]
1.03 ms
(4.33%)
1
SELECT t0.id AS id_1, t0.ref AS ref_2, t0.litrage AS litrage_3, t0.montant_accorde AS montant_accorde_4, t0.montant_restant AS montant_restant_5, t0.date AS date_6, t0.echeance AS echeance_7, t0.motif AS motif_8, t0.statut AS statut_9, t0.counter_year AS counter_year_10, t0.slug AS slug_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.client_id AS client_id_14, t0.station_id AS station_id_15, t0.produit_id AS produit_id_16, t0.operation_user_id AS operation_user_id_17 FROM credit t0 ORDER BY t0.date DESC LIMIT 200
Parameters:
[]
0.71 ms
(2.98%)
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.69 ms
(2.88%)
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.56 ms
(2.36%)
1
SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.code AS code_2 FROM produit p0_
Parameters:
[]
0.53 ms
(2.22%)
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.51 ms
(2.13%)
1
SELECT c0_.id AS id_0, c0_.raison_sociale AS raison_sociale_1, c0_.telephone AS telephone_2, c0_.email AS email_3, c0_.type_client AS type_client_4, c0_.plafond_credit AS plafond_credit_5, c0_.cumule_credit AS cumule_credit_6, c0_.statut AS statut_7, c0_.credit_max_autorise AS credit_max_autorise_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10 FROM client c0_
Parameters:
[]
0.48 ms
(2.03%)
1
SELECT m0_.id AS id_0, m0_.libelle AS libelle_1 FROM method_payement m0_
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\Params\Produit
  • The mappings App\Entity\Domain\Params\Produit#prixProduits and App\Entity\Domain\Params\PrixProduit#produit are inconsistent with each other.
App\Entity\Domain\System\Client No errors.
App\Entity\Domain\System\MethodPayement No errors.
App\Entity\Domain\Controle\RegelementCredit 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\Params\PrixProduit
  • The association App\Entity\Domain\Params\PrixProduit#produit refers to the inverse side field App\Entity\Domain\Params\Produit#prix which does not exist.
App\Entity\Domain\Flotte\Trailer No errors.
App\Entity\Domain\Flotte\Tractor No errors.