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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.54 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.71 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.69 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.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:
[
  240
]
5 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:
[
  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.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:
[
  201
]
8 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:
[
  202
]
9 0.45 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.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:
[
  179
]
11 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:
[
  58
]
12 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:
[
  59
]
13 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
]
14 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:
[
  62
]
15 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:
[
  63
]
16 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:
[
  64
]
17 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:
[
  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.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:
[
  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.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:
[
  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.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:
[
  47
]
24 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:
[
  53
]
25 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:
[
  54
]
26 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:
[
  56
]
27 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:
[
  57
]
28 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:
[
  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.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:
[
  122
]
31 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:
[
  123
]
32 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:
[
  100
]
33 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:
[
  101
]
34 4.66 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.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:
[
  104
]
36 1.03 ms
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:
[]
37 0.82 ms
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"
]
38 0.58 ms
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-30 00:00:00"
]
39 0.65 ms
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-01 00:00:00"
]
40 0.53 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:
[]
41 0.56 ms
SELECT p0_.id AS id_0, p0_.libelle AS libelle_1, p0_.code AS code_2 FROM produit p0_
Parameters:
[]
42 0.51 ms
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:
[]
43 0.48 ms
SELECT m0_.id AS id_0, m0_.libelle AS libelle_1 FROM method_payement m0_
Parameters:
[]
44 0.89 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
]
45 0.62 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
]
46 0.52 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
]

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.