Query Metrics

10 Database Queries
8 Different statements
33.60 ms Query time
18 Invalid entities
9 Managed entities

Queries

Group similar statements

# Time Info
1 1.55 ms
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
]
2 29.28 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?
Parameters:
[
  "515"
]
3 0.41 ms
SELECT t0.id AS id_1, t0.nom_stock AS nom_stock_2, t0.adresse AS adresse_3, t0.surface AS surface_4, t0.nbre_pieces AS nbre_pieces_5, t0.type AS type_6, t0.statut AS statut_7, t0.lieu_vente_id AS lieu_vente_id_8, t0.responsable_id AS responsable_id_9 FROM liste_stock t0 WHERE t0.lieu_vente_id = ? AND t0.type = ? LIMIT 1
Parameters:
[
  1
  "vente"
]
4 0.38 ms
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1
Parameters:
[
  515
  1
]
5 0.32 ms
SELECT t0.id AS id_1, t0.nom_stock AS nom_stock_2, t0.adresse AS adresse_3, t0.surface AS surface_4, t0.nbre_pieces AS nbre_pieces_5, t0.type AS type_6, t0.statut AS statut_7, t0.lieu_vente_id AS lieu_vente_id_8, t0.responsable_id AS responsable_id_9 FROM liste_stock t0 WHERE t0.lieu_vente_id = ? LIMIT 1
Parameters:
[
  1
]
6 0.33 ms
SELECT sum(s0_.quantite) AS sclr_0 FROM stock s0_ WHERE s0_.stock_produit_id IN (?) AND s0_.product_id = ?
Parameters:
[
  1
  515
]
7 0.29 ms
SELECT sum(s0_.quantite) AS sclr_0 FROM stock s0_ WHERE s0_.product_id = ?
Parameters:
[
  515
]
8 0.42 ms
SELECT t0.id AS id_1, t0.color AS color_2, t0.background_color AS background_color_3, t0.livraison AS livraison_4, t0.caisse AS caisse_5, t0.format_facture AS format_facture_6, t0.long_logo AS long_logo_7, t0.larg_logo AS larg_logo_8, t0.nom_entreprise AS nom_entreprise_9, t0.compte_client_fournisseur AS compte_client_fournisseur_10, t0.affichage_vente_compte AS affichage_vente_compte_11, t0.chemin_sauvegarde AS chemin_sauvegarde_12, t0.chemin_mysql AS chemin_mysql_13, t0.vente_stock AS vente_stock_14 FROM configuration_logiciel t0 LIMIT 1
Parameters:
[]
9 0.28 ms
SELECT sum(s0_.quantite) AS sclr_0 FROM stock s0_ WHERE s0_.product_id = ?
Parameters:
[
  515
]
10 0.33 ms
SELECT t0.id AS id_1, t0.color AS color_2, t0.background_color AS background_color_3, t0.livraison AS livraison_4, t0.caisse AS caisse_5, t0.format_facture AS format_facture_6, t0.long_logo AS long_logo_7, t0.larg_logo AS larg_logo_8, t0.nom_entreprise AS nom_entreprise_9, t0.compte_client_fournisseur AS compte_client_fournisseur_10, t0.affichage_vente_compte AS affichage_vente_compte_11, t0.chemin_sauvegarde AS chemin_sauvegarde_12, t0.chemin_mysql AS chemin_mysql_13, t0.vente_stock AS vente_stock_14 FROM configuration_logiciel t0 LIMIT 1
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 2
App\Entity\LieuxVentes 1
App\Entity\Region 1
App\Entity\Products 1
App\Entity\Categorie 1
App\Entity\ListeStock 1
App\Entity\Stock 1
App\Entity\ConfigurationLogiciel 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.
App\Entity\ConfigurationLogiciel No errors.