Symfony Profiler

Query Metrics

13 Database Queries

3 Different statements

11.79 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
7.89 ms (66.89%)	11	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: [`1`] 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 = 1 ORDER BY t0.libelle ASC;
2.03 ms (17.21%)	1	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;
1.87 ms (15.89%)	1	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 IS NULL AND t0.selection = ? ORDER BY t0.libelle ASC Parameters: [`1`] 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 IS NULL AND t0.selection = ? 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 IS NULL AND t0.selection = 1 ORDER BY t0.libelle ASC;

Time▼

Count

Info

7.89 ms
(66.89%)

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:

[
  1
]

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 = 1 ORDER BY t0.libelle ASC;

2.03 ms
(17.21%)

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;

1.87 ms
(15.89%)

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 IS NULL AND t0.selection = ? ORDER BY t0.libelle ASC

Parameters:

[
  1
]

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 IS NULL
  AND t0.selection = ?
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 IS NULL AND t0.selection = 1 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\Bank\BankMouvement	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\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.
App\Entity\AdminFinance\Vehicule\VehiculeMouvement	No errors.

Symfony Profiler

GET https://cyrdec.net/mobile/mouvement

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping