Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.07 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.07 ms	SELECT t0.id AS id_1, t0.date_edition AS date_edition_2, t0.date_paiement AS date_paiement_3, t0.prix_total AS prix_total_4, t0.montant_recu AS montant_recu_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.code_facture AS code_facture_8, t0.date_echeance AS date_echeance_9, t0.montant_rendu AS montant_rendu_10, t0.rabais AS rabais_11, t0.bonus AS bonus_12, t0.discompte AS discompte_13, t0.client_id_id AS client_id_id_14, t0.devise_id_id AS devise_id_id_15, t0.site_id_id AS site_id_id_16, t0.user_id_id AS user_id_id_17, t0.tva_id AS tva_id_18, t0.client_id AS client_id_19, t0.devise_id AS devise_id_20, t0.commande_id AS commande_id_21, t0.user_id AS user_id_22, t0.site_id AS site_id_23 FROM facture t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.date_edition AS date_edition_2, t0.date_paiement AS date_paiement_3, t0.prix_total AS prix_total_4, t0.montant_recu AS montant_recu_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.code_facture AS code_facture_8, t0.date_echeance AS date_echeance_9, t0.montant_rendu AS montant_rendu_10, t0.rabais AS rabais_11, t0.bonus AS bonus_12, t0.discompte AS discompte_13, t0.client_id_id AS client_id_id_14, t0.devise_id_id AS devise_id_id_15, t0.site_id_id AS site_id_id_16, t0.user_id_id AS user_id_id_17, t0.tva_id AS tva_id_18, t0.client_id AS client_id_19, t0.devise_id AS devise_id_20, t0.commande_id AS commande_id_21, t0.user_id AS user_id_22, t0.site_id AS site_id_23 FROM facture t0 SELECT t0.id AS id_1, t0.date_edition AS date_edition_2, t0.date_paiement AS date_paiement_3, t0.prix_total AS prix_total_4, t0.montant_recu AS montant_recu_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.code_facture AS code_facture_8, t0.date_echeance AS date_echeance_9, t0.montant_rendu AS montant_rendu_10, t0.rabais AS rabais_11, t0.bonus AS bonus_12, t0.discompte AS discompte_13, t0.client_id_id AS client_id_id_14, t0.devise_id_id AS devise_id_id_15, t0.site_id_id AS site_id_id_16, t0.user_id_id AS user_id_id_17, t0.tva_id AS tva_id_18, t0.client_id AS client_id_19, t0.devise_id AS devise_id_20, t0.commande_id AS commande_id_21, t0.user_id AS user_id_22, t0.site_id AS site_id_23 FROM facture t0;

#▲

Time

Info

1.07 ms

SELECT t0.id AS id_1, t0.date_edition AS date_edition_2, t0.date_paiement AS date_paiement_3, t0.prix_total AS prix_total_4, t0.montant_recu AS montant_recu_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.code_facture AS code_facture_8, t0.date_echeance AS date_echeance_9, t0.montant_rendu AS montant_rendu_10, t0.rabais AS rabais_11, t0.bonus AS bonus_12, t0.discompte AS discompte_13, t0.client_id_id AS client_id_id_14, t0.devise_id_id AS devise_id_id_15, t0.site_id_id AS site_id_id_16, t0.user_id_id AS user_id_id_17, t0.tva_id AS tva_id_18, t0.client_id AS client_id_19, t0.devise_id AS devise_id_20, t0.commande_id AS commande_id_21, t0.user_id AS user_id_22, t0.site_id AS site_id_23 FROM facture t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.date_edition AS date_edition_2,
  t0.date_paiement AS date_paiement_3,
  t0.prix_total AS prix_total_4,
  t0.montant_recu AS montant_recu_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.code_facture AS code_facture_8,
  t0.date_echeance AS date_echeance_9,
  t0.montant_rendu AS montant_rendu_10,
  t0.rabais AS rabais_11,
  t0.bonus AS bonus_12,
  t0.discompte AS discompte_13,
  t0.client_id_id AS client_id_id_14,
  t0.devise_id_id AS devise_id_id_15,
  t0.site_id_id AS site_id_id_16,
  t0.user_id_id AS user_id_id_17,
  t0.tva_id AS tva_id_18,
  t0.client_id AS client_id_19,
  t0.devise_id AS devise_id_20,
  t0.commande_id AS commande_id_21,
  t0.user_id AS user_id_22,
  t0.site_id AS site_id_23
FROM
  facture t0

SELECT t0.id AS id_1, t0.date_edition AS date_edition_2, t0.date_paiement AS date_paiement_3, t0.prix_total AS prix_total_4, t0.montant_recu AS montant_recu_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.code_facture AS code_facture_8, t0.date_echeance AS date_echeance_9, t0.montant_rendu AS montant_rendu_10, t0.rabais AS rabais_11, t0.bonus AS bonus_12, t0.discompte AS discompte_13, t0.client_id_id AS client_id_id_14, t0.devise_id_id AS devise_id_id_15, t0.site_id_id AS site_id_id_16, t0.user_id_id AS user_id_id_17, t0.tva_id AS tva_id_18, t0.client_id AS client_id_19, t0.devise_id AS devise_id_20, t0.commande_id AS commande_id_21, t0.user_id AS user_id_22, t0.site_id AS site_id_23 FROM facture t0;

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\Client	The association App\Entity\Client#personneContact refers to the owning side field App\Entity\PersonneContact#Client which does not exist.
App\Entity\Devise	No errors.
App\Entity\Site	The association App\Entity\Site#devises refers to the owning side field App\Entity\Devise#site which does not exist.
App\Entity\User	The association App\Entity\User#ajusteCommissions refers to the owning side field App\Entity\Vente\AjusteCommission#emetteur which does not exist.
App\Entity\Taxe	No errors.
App\Entity\Vente\Commande	No errors.
App\Entity\ModePaiement	No errors.
App\Entity\Article	The association App\Entity\Article#Categorie_id refers to the inverse side field App\Entity\Categorie#Article_id which does not exist. The association App\Entity\Article#factures refers to the inverse side field App\Entity\Facture#article_id which does not exist.
App\Entity\Vente\Commission	No errors.
App\Entity\Vente\Item	No errors.
App\Entity\Vente\ModeDePaiement	No errors.
App\Entity\Condition	No errors.

Symfony Profiler

GET https://malakitcomplet.toonaerp.com/fournisseurs/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping