https://zouini-td1.proxisoft.ma/dashboard

Query Metrics

7 Database Queries
6 Different statements
2.22 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.58 ms
SELECT m0_.id AS id_0, m0_.nume_marc AS nume_marc_1, m0_.date_creation AS date_creation_2, m0_.obje_marc AS obje_marc_3, m0_.total_ht AS total_ht_4, m0_.tva AS tva_5, m0_.total_ttc AS total_ttc_6, m0_.etat_marc AS etat_marc_7, m0_.id_client AS id_client_8, m0_.type_marc AS type_marc_9, m0_.desc_marc AS desc_marc_10, m0_.mode_paie AS mode_paie_11, m0_.date_debut AS date_debut_12, m0_.date_fin AS date_fin_13, m0_.id_devis AS id_devis_14, m0_.rg AS rg_15, m0_.montant_rg AS montant_rg_16 FROM marche m0_ INNER JOIN bureau_marche b1_ ON (b1_.id_marche = m0_.id) WHERE b1_.id_bureau = ?
Parameters:
[
  46
]
2 0.32 ms
SELECT sum(f0_.total_ttc) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ? OR f0_.etat_fact = ? OR f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)
Parameters:
[
  1
  2
  3
  "2025-09-01"
  "2025-09-30"
]
3 0.26 ms
SELECT SUM(f0_.total_ttc) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)
Parameters:
[
  2
  "2025-09-01"
  "2025-09-30"
]
4 0.28 ms
SELECT SUM(f0_.total_ttc - f0_.reste) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)
Parameters:
[
  3
  "2025-09-01"
  "2025-09-30"
]
5 0.25 ms
SELECT SUM(f0_.total_ttc) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)
Parameters:
[
  1
  "2025-09-01"
  "2025-09-30"
]
6 0.24 ms
SELECT SUM(f0_.reste) AS sclr_0 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)
Parameters:
[
  3
  "2025-09-01"
  "2025-09-30"
]
7 0.29 ms
SELECT f0_.id AS id_0, f0_.num_facture AS num_facture_1, f0_.id_four AS id_four_2, f0_.id_bon_com AS id_bon_com_3, f0_.total_ht AS total_ht_4, f0_.tva AS tva_5, f0_.total_ttc AS total_ttc_6, f0_.etat_fact AS etat_fact_7, f0_.desc_fact AS desc_fact_8, f0_.date_creation AS date_creation_9, f0_.imag_facr AS imag_facr_10, f0_.id_bure AS id_bure_11, f0_.id_char AS id_char_12, f0_.reste AS reste_13 FROM facture_fournisseur f0_ WHERE (f0_.etat_fact = ? OR f0_.etat_fact = ? OR f0_.etat_fact = ?) AND (f0_.date_creation BETWEEN ? AND ?)
Parameters:
[
  1
  2
  3
  "2025-09-01"
  "2025-09-30"
]

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\Marche No errors.
App\Entity\BureauMarche No errors.
App\Entity\FactureFournisseur No errors.