Query Metrics
7
Database Queries
6
Different statements
2.22 ms
Query time
0
Invalid entities
Queries
#▲ | 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. |