Query Metrics

7 Database Queries
7 Different statements
43.05 ms Query time
18 Invalid entities

Queries

Group similar statements

# Time Info
1 0.85 ms
SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.nom AS nom_3, t0.langue AS langue_4, t0.date_signature AS date_signature_5, t0.url_source AS url_source_6, t0.mode_divulgation AS mode_divulgation_7, t0.mode_text_divulgation AS mode_text_divulgation_8, t0.date_recuperation AS date_recuperation_9, t0.categorie AS categorie_10, t0.note AS note_11, t0.identifiant AS identifiant_12, t0.page_manquent AS page_manquent_13, t0.annexe_manquent AS annexe_manquent_14, t0.statut AS statut_15, t0.part_etat AS part_etat_16, t0.dure AS dure_17, t0.annee_signature AS annee_signature_18, t0.code AS code_19, t0.pas_de_porte AS pas_de_porte_20, t0.loyer_annuel AS loyer_annuel_21, t0.royaltie AS royaltie_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.deleted_at AS deleted_at_25, t0.pays_id AS pays_id_26, t0.operateur_id AS operateur_id_27, t0.type_document_id AS type_document_id_28, t0.user_id AS user_id_29 FROM contrat_principal t0
Parameters:
[]
2 0.35 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_principal c0_
Parameters:
[]
3 0.33 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM contrat_relatif c0_
Parameters:
[]
4 40.45 ms
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM commodite c0_
Parameters:
[]
5 0.33 ms
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM pays p0_ INNER JOIN contrat_principal c1_ ON p0_.id = c1_.pays_id WHERE c1_.id IS NOT NULL
Parameters:
[]
6 0.45 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:
[]
7 0.29 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\CadreJuridique\ContratPrincipal
  • The field App\Entity\Emine\CadreJuridique\ContratPrincipal#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\CadreJuridique\ContratPrincipal#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Actionnariat\Pays
  • The field App\Entity\Emine\Actionnariat\Pays#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\Actionnariat\Pays#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\CadreJuridique\TypeDocument
  • The field App\Entity\Emine\CadreJuridique\TypeDocument#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\CadreJuridique\TypeDocument#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\CadreJuridique\PartContrat
  • The field App\Entity\Emine\CadreJuridique\PartContrat#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\CadreJuridique\PartContrat#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\CadreJuridique\ContratRelatif
  • The field App\Entity\Emine\CadreJuridique\ContratRelatif#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\CadreJuridique\ContratRelatif#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\CadreJuridique\TypeContrat
  • The field App\Entity\Emine\CadreJuridique\TypeContrat#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\CadreJuridique\TypeContrat#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\CadreJuridique\EntiteGouvernementale
  • The field App\Entity\Emine\CadreJuridique\EntiteGouvernementale#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\CadreJuridique\EntiteGouvernementale#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Activite\Ressource
  • The field App\Entity\Emine\Activite\Ressource#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\Ressource#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Activite\Reserve
  • The field App\Entity\Emine\Activite\Reserve#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\Reserve#user is many-to-one, then the inversed side App\Entity\User#user has to be one-to-many.
App\Entity\Emine\Activite\Projet
  • The field App\Entity\Emine\Activite\Projet#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\Projet#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\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.