Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

6.74 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	2.70 ms	SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.solde AS solde_4, t0.etat AS etat_5 FROM bank_compte t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.solde AS solde_4, t0.etat AS etat_5 FROM bank_compte t0 SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.solde AS solde_4, t0.etat AS etat_5 FROM bank_compte t0;
2	2.38 ms	SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_achat AS date_achat_3, t0.prix_achat AS prix_achat_4, t0.prix_actuel AS prix_actuel_5, t0.km_initial AS km_initial_6 FROM vehicule_voiture t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_achat AS date_achat_3, t0.prix_achat AS prix_achat_4, t0.prix_actuel AS prix_actuel_5, t0.km_initial AS km_initial_6 FROM vehicule_voiture t0 SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_achat AS date_achat_3, t0.prix_achat AS prix_achat_4, t0.prix_actuel AS prix_actuel_5, t0.km_initial AS km_initial_6 FROM vehicule_voiture t0;
3	1.66 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.libelle AS libelle_3, t0.selection AS selection_4, t0.budget AS budget_5, t0.parent_id AS parent_id_6 FROM bank_mouvement_categorie t0 WHERE t0.parent_id = ? ORDER BY t0.libelle ASC Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.libelle AS libelle_3, t0.selection AS selection_4, t0.budget AS budget_5, t0.parent_id AS parent_id_6 FROM bank_mouvement_categorie t0 WHERE t0.parent_id = ? ORDER BY t0.libelle ASC SELECT t0.id AS id_1, t0.type AS type_2, t0.libelle AS libelle_3, t0.selection AS selection_4, t0.budget AS budget_5, t0.parent_id AS parent_id_6 FROM bank_mouvement_categorie t0 WHERE t0.parent_id = 3 ORDER BY t0.libelle ASC;

#▲

Time

Info

2.70 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.solde AS solde_4, t0.etat AS etat_5 FROM bank_compte t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.type AS type_3,
  t0.solde AS solde_4,
  t0.etat AS etat_5
FROM
  bank_compte t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.type AS type_3, t0.solde AS solde_4, t0.etat AS etat_5 FROM bank_compte t0;

2.38 ms

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_achat AS date_achat_3, t0.prix_achat AS prix_achat_4, t0.prix_actuel AS prix_actuel_5, t0.km_initial AS km_initial_6 FROM vehicule_voiture t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2,
  t0.date_achat AS date_achat_3,
  t0.prix_achat AS prix_achat_4,
  t0.prix_actuel AS prix_actuel_5,
  t0.km_initial AS km_initial_6
FROM
  vehicule_voiture t0

SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.date_achat AS date_achat_3, t0.prix_achat AS prix_achat_4, t0.prix_actuel AS prix_actuel_5, t0.km_initial AS km_initial_6 FROM vehicule_voiture t0;

1.66 ms

SELECT t0.id AS id_1, t0.type AS type_2, t0.libelle AS libelle_3, t0.selection AS selection_4, t0.budget AS budget_5, t0.parent_id AS parent_id_6 FROM bank_mouvement_categorie t0 WHERE t0.parent_id = ? ORDER BY t0.libelle ASC

Parameters:

[
  3
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.libelle AS libelle_3,
  t0.selection AS selection_4,
  t0.budget AS budget_5,
  t0.parent_id AS parent_id_6
FROM
  bank_mouvement_categorie t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.libelle ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.libelle AS libelle_3, t0.selection AS selection_4, t0.budget AS budget_5, t0.parent_id AS parent_id_6 FROM bank_mouvement_categorie t0 WHERE t0.parent_id = 3 ORDER BY t0.libelle ASC;

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\Site\Menu	No errors.
App\Entity\AdminFinance\Vehicule\VehiculeMouvement	No errors.
App\Entity\AdminFinance\Vehicule\Voiture	No errors.
App\Entity\AdminFinance\Bank\BankCompte	The field App\Entity\AdminFinance\Bank\BankCompte#mouvementDebit is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AdminFinance\Bank\BankMouvement#compteDebit does not contain the required 'inversedBy="mouvementDebit"' attribute. The field App\Entity\AdminFinance\Bank\BankCompte#mouvementCredit is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\AdminFinance\Bank\BankMouvement#compteCredit does not contain the required 'inversedBy="mouvementCredit"' attribute. The mappings App\Entity\AdminFinance\Bank\BankCompte#prelevements and App\Entity\AdminFinance\Bank\BankPrelevement#compteDebit are inconsistent with each other.
App\Entity\AdminFinance\Bank\BankMouvementCategorie	No errors.
App\Entity\AdminFinance\Bank\BankMouvement	No errors.
App\Entity\AdminFinance\Bank\BankPrelevement	The association App\Entity\AdminFinance\Bank\BankPrelevement#compteDebit refers to the inverse side field App\Entity\AdminFinance\Bank\BankCompte#prelevement which does not exist.

Symfony Profiler

GET https://cyrdec.net/vehicule/mvt

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping