Query Metrics
10
Database Queries
8
Different statements
33.60 ms
Query time
18
Invalid entities
9
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
29.28 ms (87.14%) |
1 |
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.designation AS designation_3, t0.prix_vente AS prix_vente_4, t0.code_barre AS code_barre_5, t0.nbre_piece AS nbre_piece_6, t0.nbre_paquet AS nbre_paquet_7, t0.type_produit AS type_produit_8, t0.nbre_vente AS nbre_vente_9, t0.statut AS statut_10, t0.statut_comptable AS statut_comptable_11, t0.tva AS tva_12, t0.categorie_id AS categorie_id_13, t0.epaisseur_id AS epaisseur_id_14, t0.dimension_id AS dimension_id_15, t0.origine_id AS origine_id_16, t0.type_id AS type_id_17 FROM products t0 WHERE t0.id = ?
Parameters:
[
"515"
]
|
||||||||||||||||||||||||||||||
|
1.55 ms (4.62%) |
1 |
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
]
|
||||||||||||||||||||||||||||||
|
0.75 ms (2.22%) |
2 |
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:
[]
|
||||||||||||||||||||||||||||||
|
0.57 ms (1.71%) |
2 |
SELECT sum(s0_.quantite) AS sclr_0 FROM stock s0_ WHERE s0_.product_id = ?
Parameters:
[
515
]
|
||||||||||||||||||||||||||||||
|
0.41 ms (1.23%) |
1 |
SELECT t0.id AS id_1, t0.nom_stock AS nom_stock_2, t0.adresse AS adresse_3, t0.surface AS surface_4, t0.nbre_pieces AS nbre_pieces_5, t0.type AS type_6, t0.statut AS statut_7, t0.lieu_vente_id AS lieu_vente_id_8, t0.responsable_id AS responsable_id_9 FROM liste_stock t0 WHERE t0.lieu_vente_id = ? AND t0.type = ? LIMIT 1
Parameters:
[ 1 "vente" ]
|
||||||||||||||||||||||||||||||
|
0.38 ms (1.13%) |
1 |
SELECT t0.id AS id_1, t0.quantite AS quantite_2, t0.prix_achat AS prix_achat_3, t0.prix_revient AS prix_revient_4, t0.prix_vente AS prix_vente_5, t0.date_peremption AS date_peremption_6, t0.stock_produit_id AS stock_produit_id_7, t0.product_id AS product_id_8 FROM stock t0 WHERE t0.product_id = ? AND t0.stock_produit_id = ? LIMIT 1
Parameters:
[ 515 1 ]
|
||||||||||||||||||||||||||||||
|
0.33 ms (1.00%) |
1 |
SELECT sum(s0_.quantite) AS sclr_0 FROM stock s0_ WHERE s0_.stock_produit_id IN (?) AND s0_.product_id = ?
Parameters:
[ 1 515 ]
|
||||||||||||||||||||||||||||||
|
0.32 ms (0.95%) |
1 |
SELECT t0.id AS id_1, t0.nom_stock AS nom_stock_2, t0.adresse AS adresse_3, t0.surface AS surface_4, t0.nbre_pieces AS nbre_pieces_5, t0.type AS type_6, t0.statut AS statut_7, t0.lieu_vente_id AS lieu_vente_id_8, t0.responsable_id AS responsable_id_9 FROM liste_stock t0 WHERE t0.lieu_vente_id = ? LIMIT 1
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\Products | 1 |
| App\Entity\Categorie | 1 |
| App\Entity\ListeStock | 1 |
| App\Entity\Stock | 1 |
| App\Entity\ConfigurationLogiciel | 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 |
|
| 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 |
|
| App\Entity\AvanceSalaire |
|
| App\Entity\PaiementSalairePersonnel |
|
| App\Entity\ModifDecaissement | No errors. |
| App\Entity\Depenses | No errors. |
| App\Entity\Versement | No errors. |
| App\Entity\Modification |
|
| App\Entity\TransfertFond |
|
| App\Entity\ChequeEspece |
|
| App\Entity\Recette | No errors. |
| App\Entity\AjustementSolde | No errors. |
| App\Entity\Livraison | No errors. |
| App\Entity\Facturation |
|
| App\Entity\CommissionVente | No errors. |
| App\Entity\ModificationFacture |
|
| App\Entity\Proformat |
|
| App\Entity\SuppressionFacture | No errors. |
| App\Entity\RetourProduct |
|
| App\Entity\EchangeDevise |
|
| App\Entity\MouvementCaisse | No errors. |
| App\Entity\GestionCheque |
|
| App\Entity\ClotureCaisse | No errors. |
| App\Entity\RetourProductFournisseur | No errors. |
| App\Entity\FactureFrais |
|
| App\Entity\ListeProductAchatFournisseurFrais | No errors. |
| App\Entity\ListeProductAchatFournisseurMultiple | No errors. |
| App\Entity\AchatFournisseurGeneral |
|
| App\Entity\Promotion |
|
| App\Entity\SortieStock | No errors. |
| App\Entity\ClotureAnnuel | No errors. |
| App\Entity\HistoriqueChangement | No errors. |
| App\Entity\Products |
|
| App\Entity\Categorie | No errors. |
| App\Entity\Epaisseurs | No errors. |
| App\Entity\Dimensions | No errors. |
| App\Entity\OrigineProduit | No errors. |
| App\Entity\TypeProduit | No errors. |
| App\Entity\Stock |
|
| App\Entity\LiaisonProduit | No errors. |
| App\Entity\ListeProductBonFournisseur | No errors. |
| App\Entity\CommandeProduct | No errors. |
| App\Entity\ProformatProduct | No errors. |
| App\Entity\ConfigurationLogiciel | No errors. |