Query Metrics

6 Database Queries
6 Different statements
2.87 ms Query time
15 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.user_id AS user_id_6 FROM service_etat t0
Parameters:
[]
2 0.64 ms
SELECT SUM(p0_.montant) AS sclr_0, SUBSTRING(p0_.date_paiement FROM 6 FOR 2) AS sclr_1 FROM paiement p0_ WHERE (p0_.date_paiement BETWEEN ? AND ?) AND p0_.type_paiement = ? GROUP BY sclr_1 ORDER BY sclr_1 ASC
Parameters:
[
  "2025-01-01 00:00:00"
  "2025-12-31 23:59:00"
  "Droit"
]
3 0.27 ms
SELECT SUM(p0_.montant) AS sclr_0, SUBSTRING(p0_.date_paiement FROM 1 FOR 4) AS sclr_1 FROM paiement p0_ WHERE p0_.type_paiement = ? GROUP BY sclr_1 ORDER BY sclr_1 ASC
Parameters:
[
  "Droit"
]
4 0.44 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.unite AS unite_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.deleted_at AS deleted_at_7, t0.user_id AS user_id_8 FROM filiere t0
Parameters:
[]
5 0.37 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.user_id AS user_id_7 FROM categorie t0
Parameters:
[]
6 0.44 ms
SELECT t0.id AS id_1, t0.nom_gisement AS nom_gisement_2, t0.nom_mine AS nom_mine_3, t0.ressource AS ressource_4, t0.teneur AS teneur_5, t0.metal_contenu AS metal_contenu_6, t0.longitude AS longitude_7, t0.latitude AS latitude_8, t0.annotation AS annotation_9, t0.date_debut AS date_debut_10, t0.code AS code_11, t0.details AS details_12, t0.superficie_on AS superficie_on_13, t0.superficie_off AS superficie_off_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17, t0.operateur_id AS operateur_id_18, t0.user_id AS user_id_19 FROM gisement t0
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\Emine\Obligation\ServiceEtat
  • The field App\Entity\Emine\Obligation\ServiceEtat#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Obligation\ServiceEtat#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\User
  • The field App\Entity\User#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\User#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Obligation\TypeTaxe
  • The field App\Entity\Emine\Obligation\TypeTaxe#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Obligation\TypeTaxe#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Obligation\RepartitionRedevance
  • The field App\Entity\Emine\Obligation\RepartitionRedevance#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Obligation\RepartitionRedevance#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Obligation\Paiement
  • The field App\Entity\Emine\Obligation\Paiement#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Obligation\Paiement#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Operateur\Filiere
  • The field App\Entity\Emine\Operateur\Filiere#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Operateur\Filiere#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Operateur\Commodite
  • The field App\Entity\Emine\Operateur\Commodite#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Operateur\Commodite#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Autres\Etd
  • The field App\Entity\Emine\Autres\Etd#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Autres\Etd#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Autres\Zea
  • The field App\Entity\Emine\Autres\Zea#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Autres\Zea#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Operateur\Categorie
  • The field App\Entity\Emine\Operateur\Categorie#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Operateur\Categorie#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Operateur\Operateur
  • The field App\Entity\Emine\Operateur\Operateur#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Operateur\Operateur#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Autres\Gisement
  • The field App\Entity\Emine\Autres\Gisement#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Autres\Gisement#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Activite\Mine
  • The field App\Entity\Emine\Activite\Mine#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Activite\Mine#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Activite\TitreMinier
  • The field App\Entity\Emine\Activite\TitreMinier#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Activite\TitreMinier#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Operateur\TypeCommodite No errors.
App\Entity\Emine\Operateur\Province
  • The field App\Entity\Emine\Operateur\Province#user is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\User#user does not contain the required 'mappedBy="user"' attribute.
  • If association App\Entity\Emine\Operateur\Province#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.