https://perleshair.com/public/facture/print2/2634

Query Metrics

7 Database Queries
7 Different statements
2.29 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.99 ms
(43.19%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.statut_paiement AS statut_paiement_3, t0.montant_total AS montant_total_4, t0.created_at AS created_at_5, t0.montant_paye AS montant_paye_6, t0.type_paiement AS type_paiement_7, t0.vente_id AS vente_id_8, t0.client_id AS client_id_9 FROM facture t0 WHERE t0.id = ?
Parameters:
[
  "2634"
]
0.27 ms
(11.83%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.is_mere AS is_mere_3, t0.boutique_mere_id AS boutique_mere_id_4 FROM boutique t0
Parameters:
[]
0.22 ms
(9.79%)
1
SELECT t0.id AS id_1, t0.date_vente AS date_vente_2, t0.description AS description_3, t0.vendeur_id AS vendeur_id_4, t0.client_id AS client_id_5, t0.boutique_id AS boutique_id_6 FROM vente t0 WHERE t0.id = ?
Parameters:
[
  2634
]
0.22 ms
(9.78%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.created_at AS created_at_6, t0.telephone AS telephone_7, t0.adress AS adress_8, t9.id AS id_10, t9.user_id AS user_id_11, t0.boutique_id AS boutique_id_12 FROM user t0 LEFT JOIN livreur t9 ON t9.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  11
]
0.22 ms
(9.57%)
1
SELECT t0.id AS id_1, t0.quantite_vendu AS quantite_vendu_2, t0.prix_unitaire AS prix_unitaire_3, t0.prix_total AS prix_total_4, t0.remise_pourcentage AS remise_pourcentage_5, t0.vente_id AS vente_id_6, t0.produit_id AS produit_id_7 FROM details_vente t0 WHERE t0.vente_id = ?
Parameters:
[
  2634
]
0.19 ms
(8.42%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.prix_unitaire AS prix_unitaire_4, t0.quantite_pr AS quantite_pr_5, t0.cout AS cout_6, t0.image_name AS image_name_7, t0.updated_at AS updated_at_8, t0.unite_mesure AS unite_mesure_9, t0.prix_vente_unitaire AS prix_vente_unitaire_10, t0.categorie_id AS categorie_id_11, t0.utilisateur_id AS utilisateur_id_12 FROM produit t0 WHERE t0.id = ?
Parameters:
[
  968
]
0.17 ms
(7.42%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.phone AS phone_3 FROM client t0 WHERE t0.id = ?
Parameters:
[
  3118
]

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\Facture No errors.
App\Entity\Vente No errors.
App\Entity\Client No errors.
App\Entity\Echeance No errors.
App\Entity\Boutique No errors.
App\Entity\ProduitStock No errors.
App\Entity\SortieStock No errors.
App\Entity\EntreeStock No errors.
App\Entity\Recette No errors.
App\Entity\User No errors.
App\Entity\FactureService No errors.
App\Entity\DetailsVente No errors.
App\Entity\Livreur No errors.
App\Entity\Produit No errors.
App\Entity\ActionLog No errors.
App\Entity\Livraison No errors.
App\Entity\Categorie No errors.
App\Entity\LivraisonProd No errors.