Query Metrics
2
Database Queries
2
Different statements
1.66 ms
Query time
18
Invalid entities
5
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1.29 ms (77.51%) |
1 |
SELECT p0_.id AS id_0, p0_.reference AS reference_1, p0_.designation AS designation_2, p0_.prix_vente AS prix_vente_3, p0_.code_barre AS code_barre_4, p0_.nbre_piece AS nbre_piece_5, p0_.nbre_paquet AS nbre_paquet_6, p0_.type_produit AS type_produit_7, p0_.nbre_vente AS nbre_vente_8, p0_.statut AS statut_9, p0_.statut_comptable AS statut_comptable_10, p0_.tva AS tva_11, p0_.categorie_id AS categorie_id_12, p0_.epaisseur_id AS epaisseur_id_13, p0_.dimension_id AS dimension_id_14, p0_.origine_id AS origine_id_15, p0_.type_id AS type_id_16 FROM products p0_ WHERE p0_.designation LIKE ? OR p0_.reference LIKE ? LIMIT 100
Parameters:
[ "%DR %" "%DR %" ]
|
||||||||||||||||||||||||||||
|
0.37 ms (22.49%) |
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
]
|
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 | 1 |
| App\Entity\LieuxVentes | 1 |
| App\Entity\Region | 1 |
| App\Entity\Products | 1 |
| App\Entity\Categorie | 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. |