Query Metrics

11 Database Queries
10 Different statements
14.61 ms Query time
16 Invalid entities
12 Managed entities

Queries

Group similar statements

# Time Info
1 0.42 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 0.34 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.montant AS montant_3, t0.taux AS taux_4, t0.numero_paiement AS numero_paiement_5, t0.banque_cheque AS banque_cheque_6, t0.commentaire AS commentaire_7, t0.date_versement AS date_versement_8, t0.date_saisie AS date_saisie_9, t0.client_id AS client_id_10, t0.lieu_vente_id AS lieu_vente_id_11, t0.traite_par_id AS traite_par_id_12, t0.devise_id AS devise_id_13, t0.mode_paie_id AS mode_paie_id_14, t0.compte_id AS compte_id_15, t0.categorie_id AS categorie_id_16 FROM versement t0 WHERE t0.id = ?
Parameters:
[
  "253"
]
3 0.29 ms
SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
4 0.45 ms
SELECT sum(m0_.montant) AS sclr_0, d1_.nom_devise AS nom_devise_1 FROM mouvement_collaborateur m0_ LEFT JOIN devise d1_ ON m0_.devise_id = d1_.id WHERE m0_.collaborateur_id = ? GROUP BY m0_.devise_id
Parameters:
[
  264
]
5 0.45 ms
SELECT sum(m0_.montant) AS sclr_0, d1_.nom_devise AS nom_devise_1 FROM mouvement_collaborateur m0_ LEFT JOIN devise d1_ ON m0_.devise_id = d1_.id WHERE m0_.collaborateur_id = ? AND m0_.date_operation < ? GROUP BY m0_.devise_id ORDER BY m0_.devise_id ASC
Parameters:
[
  264
  "2026-04-09 16:28:00"
]
6 0.36 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:
[]
7 11.32 ms
SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.pays AS pays_3, t0.region AS region_4, t0.ville AS ville_5, t0.telephone AS telephone_6, t0.email AS email_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.initial AS initial_10, t0.type_commerce AS type_commerce_11, t0.lieu AS lieu_12, t0.entreprise_id AS entreprise_id_13, t0.gestionnaire_id AS gestionnaire_id_14 FROM lieux_ventes t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.32 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:
[
  264
]
9 0.23 ms
SELECT t0.id AS id_1, t0.designation AS designation_2 FROM mode_paiement t0 WHERE t0.id = ?
Parameters:
[
  1
]
10 0.19 ms
SELECT t0.id AS id_1, t0.nom_devise AS nom_devise_2 FROM devise t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.24 ms
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.type AS type_3, t0.numero_compte AS numero_compte_4, t0.document AS document_5, t0.point_de_vente_id AS point_de_vente_id_6 FROM caisse 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 2
App\Entity\LieuxVentes 1
App\Entity\Region 1
App\Entity\Versement 1
App\Entity\Devise 1
App\Entity\ModePaiement 1
App\Entity\Caisse 1
App\Entity\CategorieDecaissement 1
App\Entity\Entreprise 1
App\Entity\ConfigurationLogiciel 1
App\Entity\PointDeVente 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\Devise No errors.
App\Entity\ModePaiement No errors.
App\Entity\Caisse No errors.
App\Entity\CategorieDecaissement No errors.
App\Entity\Entreprise No errors.
App\Entity\Licence No errors.
App\Entity\ConfigurationLogiciel No errors.
App\Entity\PointDeVente No errors.
App\Entity\TauxDevise No errors.
App\Entity\FactureFraisSup No errors.
App\Entity\ProformatFraisSup No errors.