Query Metrics

5 Database Queries
5 Different statements
2.01 ms Query time
11 Invalid entities

Queries

Group similar statements

# Time Info
1 0.70 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.commodite_id AS commodite_id_3, t0.user_id AS user_id_4 FROM type_commodite t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
2 0.57 ms
SELECT c0_.id AS id_0, c0_.date_cours AS date_cours_1, c0_.prix AS prix_2, c0_.bourse AS bourse_3, c0_.teneur AS teneur_4, c0_.mode AS mode_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.deleted_at AS deleted_at_8, c0_.commodite_id AS commodite_id_9, c0_.type_commodite_id AS type_commodite_id_10, c0_.user_id AS user_id_11 FROM cours_moyens_des_metaux c0_ WHERE c0_.type_commodite_id = ? AND (c0_.date_cours BETWEEN ? AND ?) ORDER BY c0_.date_cours DESC
Parameters:
[
  1
  "2024-08-21 00:00:00"
  "2024-09-21 23:59:59"
]
3 0.18 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.commodite_id AS commodite_id_3, t0.user_id AS user_id_4 FROM type_commodite t0
Parameters:
[]
4 0.36 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.21 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:
[]

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\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.