Query Metrics

6 Database Queries
6 Different statements
3.31 ms Query time
16 Invalid entities

Queries

Group similar statements

# Time Info
1 1.73 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.unite AS unite_3, t0.commodite_id AS commodite_id_4, t0.user_id AS user_id_5 FROM type_commodite t0
Parameters:
[]
2 0.51 ms
SELECT p0_.id AS id_0, p0_.zone AS zone_1, p0_.date_prix AS date_prix_2, p0_.prix AS prix_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.deleted_at AS deleted_at_6, p0_.type_produit_id AS type_produit_id_7, p0_.user_id AS user_id_8 FROM prix_du_carburant p0_ WHERE p0_.type_produit_id = ? ORDER BY p0_.date_prix ASC
Parameters:
[
  1
]
3 0.28 ms
SELECT p0_.id AS id_0, p0_.zone AS zone_1, p0_.date_prix AS date_prix_2, p0_.prix AS prix_3, p0_.created_at AS created_at_4, p0_.updated_at AS updated_at_5, p0_.deleted_at AS deleted_at_6, p0_.type_produit_id AS type_produit_id_7, p0_.user_id AS user_id_8 FROM prix_du_carburant p0_ WHERE p0_.type_produit_id = ? AND (p0_.date_prix BETWEEN ? AND ?) ORDER BY p0_.date_prix ASC
Parameters:
[
  1
  "2025-11-06 00:00:00"
  "2025-12-06 23:59:59"
]
4 0.23 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.22 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.34 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\Operateur\TypeCommodite No errors.
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\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\Production\Exportation
  • The field 'App\Entity\Emine\Production\Exportation#quantite' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\Entity\Emine\Production\Exportation#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\Production\Exportation#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Production\Production
  • The field App\Entity\Emine\Production\Production#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\Production\Production#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Production\VenteLocal
  • The field 'App\Entity\Emine\Production\VenteLocal#quantite' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field App\Entity\Emine\Production\VenteLocal#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\Production\VenteLocal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Autres\CoursMoyensDesMetaux
  • The field App\Entity\Emine\Autres\CoursMoyensDesMetaux#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\CoursMoyensDesMetaux#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\Autres\PrixDuCarburant
  • The field App\Entity\Emine\Autres\PrixDuCarburant#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\PrixDuCarburant#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\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\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\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.