Query Metrics

8 Database Queries
4 Different statements
22.43 ms Query time
17 Invalid entities
10 Managed entities

Grouped Statements

Show all queries

Time Count Info
18.64 ms
(83.09%)
5
SELECT t0.id AS id_1, t0.taux AS taux_2, t0.devise_id AS devise_id_3, t0.lieu_vente_id AS lieu_vente_id_4 FROM taux_devise t0 WHERE t0.devise_id = ? AND t0.lieu_vente_id = ? LIMIT 1
Parameters:
[
  1
  1
]
1.59 ms
(7.08%)
1
SELECT sum(s0_.quantite) AS sclr_0 FROM stock s0_ WHERE s0_.product_id = NULL
Parameters:
[]
1.46 ms
(6.52%)
1
SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0
Parameters:
[]
0.74 ms
(3.31%)
1
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.telephone AS telephone_7, t0.email AS email_8, t0.type_user AS type_user_9, t0.date_creation AS date_creation_10, t0.adresse AS adresse_11, t0.ville AS ville_12, t0.pays AS pays_13, t0.statut AS statut_14, t0.reference AS reference_15, t0.lieu_vente_id AS lieu_vente_id_16, t0.region_id AS region_id_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Devise 4
App\Entity\TauxDevise 3
App\Entity\User 1
App\Entity\LieuxVentes 1
App\Entity\Region 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\LieuxVentes No errors.
App\Entity\Region No errors.
App\Entity\ListeStock No errors.
App\Entity\Personnel No errors.
App\Entity\Client No errors.
App\Entity\ListeInventaire No errors.
App\Entity\Inventaire No errors.
App\Entity\MouvementProduct No errors.
App\Entity\AnomalieProduit No errors.
App\Entity\ListeTransfertProduct No errors.
App\Entity\TransfertProducts
  • The mappings App\Entity\TransfertProducts#traitePar and App\Entity\User#transfertProduct are inconsistent with each other.
App\Entity\AchatFournisseur No errors.
App\Entity\ListeProductAchatFournisseur No errors.
App\Entity\Decaissement No errors.
App\Entity\MouvementCollaborateur No errors.
App\Entity\BonCommandeFournisseur No errors.
App\Entity\AbsencesPersonnels No errors.
App\Entity\PrimesPersonnel
  • The mappings App\Entity\PrimesPersonnel#saisiePar and App\Entity\User#primesPersonnels are inconsistent with each other.
App\Entity\AvanceSalaire
  • The association App\Entity\AvanceSalaire#devise refers to the inverse side field App\Entity\Devise#avanceSalaires which does not exist.
App\Entity\PaiementSalairePersonnel
  • The mappings App\Entity\PaiementSalairePersonnel#saisiePar and App\Entity\User#paiementSalairePersonnels are inconsistent with each other.
  • The association App\Entity\PaiementSalairePersonnel#compteRetrait refers to the inverse side field App\Entity\Caisse#paiementSalairePersonnels which does not exist.
  • The association App\Entity\PaiementSalairePersonnel#typePaiement refers to the inverse side field App\Entity\ModePaiement#paiementSalairePersonnels which does not exist.
  • The association App\Entity\PaiementSalairePersonnel#devise refers to the inverse side field App\Entity\Devise#paiementSalairePersonnels which does not exist.
App\Entity\ModifDecaissement No errors.
App\Entity\Depenses No errors.
App\Entity\Versement No errors.
App\Entity\Modification
  • The mappings App\Entity\Modification#traitePar and App\Entity\User#modifications are inconsistent with each other.
App\Entity\TransfertFond
  • The mappings App\Entity\TransfertFond#caisseReception and App\Entity\Caisse#transfertFonds are inconsistent with each other.
  • The mappings App\Entity\TransfertFond#envoyePar and App\Entity\User#transfertFonds are inconsistent with each other.
App\Entity\ChequeEspece
  • The mappings App\Entity\ChequeEspece#caisseRetrait and App\Entity\Caisse#chequeEspeces are inconsistent with each other.
  • The mappings App\Entity\ChequeEspece#saisiePar and App\Entity\User#chequeEspeces are inconsistent with each other.
App\Entity\Recette No errors.
App\Entity\AjustementSolde No errors.
App\Entity\Livraison No errors.
App\Entity\Facturation
  • The mappings App\Entity\Facturation#saisiePar and App\Entity\User#facturations are inconsistent with each other.
App\Entity\CommissionVente No errors.
App\Entity\ModificationFacture
  • The mappings App\Entity\ModificationFacture#client and App\Entity\User#modificationFactures are inconsistent with each other.
App\Entity\Proformat
  • The mappings App\Entity\Proformat#saisiePar and App\Entity\User#proformats are inconsistent with each other.
App\Entity\SuppressionFacture No errors.
App\Entity\RetourProduct
  • The association App\Entity\RetourProduct#lieuVente refers to the inverse side field App\Entity\LieuxVentes#retourProducts which does not exist.
App\Entity\EchangeDevise
  • The mappings App\Entity\EchangeDevise#caisseDestination and App\Entity\Caisse#echangeDevises are inconsistent with each other.
  • The mappings App\Entity\EchangeDevise#deviseDestination and App\Entity\Devise#echangeDevises are inconsistent with each other.
App\Entity\MouvementCaisse No errors.
App\Entity\GestionCheque
  • The mappings App\Entity\GestionCheque#caisseReception and App\Entity\Caisse#gestionCheques are inconsistent with each other.
  • The mappings App\Entity\GestionCheque#lieuVenteReception and App\Entity\LieuxVentes#gestionCheques are inconsistent with each other.
  • The mappings App\Entity\GestionCheque#envoyePar and App\Entity\User#gestionCheques are inconsistent with each other.
  • The mappings App\Entity\GestionCheque#collaborateur and App\Entity\User#gestionCheques are inconsistent with each other.
App\Entity\ClotureCaisse No errors.
App\Entity\RetourProductFournisseur No errors.
App\Entity\FactureFrais
  • The mappings App\Entity\FactureFrais#personnel and App\Entity\User#factureFrais are inconsistent with each other.
App\Entity\ListeProductAchatFournisseurFrais No errors.
App\Entity\ListeProductAchatFournisseurMultiple No errors.
App\Entity\AchatFournisseurGeneral
  • The mappings App\Entity\AchatFournisseurGeneral#personnel and App\Entity\User#achatFournisseurGenerals are inconsistent with each other.
App\Entity\Promotion
  • The mappings App\Entity\Promotion#produitBonus and App\Entity\Products#promotions are inconsistent with each other.
  • If association App\Entity\Promotion#produitBonus is many-to-one, then the inversed side App\Entity\Products#promotions has to be one-to-many.
App\Entity\SortieStock No errors.
App\Entity\ClotureAnnuel No errors.
App\Entity\HistoriqueChangement No errors.
App\Entity\Stock
  • The mappings App\Entity\Stock#product and App\Entity\Products#stocks are inconsistent with each other.
App\Entity\Devise No errors.
App\Entity\FactureFraisSup No errors.
App\Entity\TauxDevise No errors.
App\Entity\ProformatFraisSup No errors.