Query Metrics

2 Database Queries
2 Different statements
1.66 ms Query time
18 Invalid entities
5 Managed entities

Grouped Statements

Show all queries

Time Count Info
1.29 ms
(77.51%)
1
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.prix_vente AS prix_vente_3, p0_.code_barre AS code_barre_4, p0_.nbre_piece AS nbre_piece_5, p0_.nbre_paquet AS nbre_paquet_6, p0_.type_produit AS type_produit_7, p0_.nbre_vente AS nbre_vente_8, p0_.statut AS statut_9, p0_.statut_comptable AS statut_comptable_10, p0_.tva AS tva_11, p0_.categorie_id AS categorie_id_12, p0_.epaisseur_id AS epaisseur_id_13, p0_.dimension_id AS dimension_id_14, p0_.origine_id AS origine_id_15, p0_.type_id AS type_id_16 FROM products p0_ WHERE p0_.designation LIKE ? OR p0_.reference LIKE ? LIMIT 100
Parameters:
[
  "%DR %"
  "%DR %"
]
0.37 ms
(22.49%)
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\User 1
App\Entity\LieuxVentes 1
App\Entity\Region 1
App\Entity\Products 1
App\Entity\Categorie 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\Products
  • The association App\Entity\Products#stocks refers to the owning side field App\Entity\Stock#products which does not exist.
App\Entity\Categorie No errors.
App\Entity\Epaisseurs No errors.
App\Entity\Dimensions No errors.
App\Entity\OrigineProduit No errors.
App\Entity\TypeProduit No errors.
App\Entity\Stock
  • The mappings App\Entity\Stock#product and App\Entity\Products#stocks are inconsistent with each other.
App\Entity\LiaisonProduit No errors.
App\Entity\ListeProductBonFournisseur No errors.
App\Entity\CommandeProduct No errors.
App\Entity\ProformatProduct No errors.