Query Metrics
7
Database Queries
7
Different statements
13.81 ms
Query time
14
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.64 ms |
SELECT c0_.id AS id_0, c0_.name_categorie AS name_categorie_1, c0_.couverture AS couverture_2, c0_.img_produit AS img_produit_3, c0_.priorite AS priorite_4, c0_.description AS description_5 FROM categorie c0_ ORDER BY c0_.priorite ASC LIMIT 6
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 2 | 8.28 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT c0_.id AS id_0, c0_.name_categorie AS name_categorie_1, c0_.couverture AS couverture_2, c0_.img_produit AS img_produit_3, c0_.priorite AS priorite_4, c0_.description AS description_5 FROM categorie c0_ ORDER BY c0_.priorite ASC) dctrn_result) dctrn_table
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 3 | 1.75 ms |
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_ ORDER BY p0_.nbre_vente DESC LIMIT 25
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 4 | 0.69 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM products p0_ ORDER BY p0_.nbre_vente DESC) dctrn_result) dctrn_table
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 5 | 0.25 ms |
SELECT t0.id AS id_1, t0.nom_entreprise AS nom_entreprise_2, t0.identifiant AS identifiant_3, t0.numero_agrement AS numero_agrement_4, t0.adresse AS adresse_5, t0.telephone AS telephone_6, t0.logo AS logo_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9 FROM entreprise t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 6 | 0.57 ms |
SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.pays AS pays_3, t0.region AS region_4, t0.ville AS ville_5, t0.telephone AS telephone_6, t0.email AS email_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.initial AS initial_10, t0.type_commerce AS type_commerce_11, t0.lieu AS lieu_12, t0.entreprise_id AS entreprise_id_13, t0.gestionnaire_id AS gestionnaire_id_14 FROM lieux_ventes t0
Parameters:
[]
|
||||||||||||||||||||||||||||||
| 7 | 0.63 ms |
SELECT t0.id AS id_1, t0.numero_licence AS numero_licence_2, t0.date_debut AS date_debut_3, t0.datefin AS datefin_4, t0.statut AS statut_5, t0.statut_site_web AS statut_site_web_6, t0.entreprise_id AS entreprise_id_7 FROM licence 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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Categorie | No errors. |
| App\Entity\Products |
|
| App\Entity\Dimensions | No errors. |
| App\Entity\Epaisseurs | No errors. |
| App\Entity\OrigineProduit | No errors. |
| App\Entity\TypeProduit | No errors. |
| App\Entity\Stock |
|
| App\Entity\MouvementProduct | No errors. |
| App\Entity\LiaisonProduit | No errors. |
| App\Entity\Inventaire | No errors. |
| App\Entity\AnomalieProduit | No errors. |
| App\Entity\ListeTransfertProduct | No errors. |
| App\Entity\ListeProductAchatFournisseur | No errors. |
| App\Entity\ListeProductBonFournisseur | No errors. |
| App\Entity\CommandeProduct | No errors. |
| App\Entity\ProformatProduct | No errors. |
| App\Entity\RetourProduct |
|
| App\Entity\Entreprise | No errors. |
| App\Entity\LieuxVentes | No errors. |
| App\Entity\Licence | No errors. |
| App\Entity\User | No errors. |
| App\Entity\ListeStock | No errors. |
| App\Entity\ListeInventaire | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\TransfertProducts |
|
| App\Entity\AchatFournisseur | No errors. |
| App\Entity\PointDeVente | No errors. |
| App\Entity\Decaissement | No errors. |
| App\Entity\MouvementCaisse | 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\Depenses | No errors. |
| App\Entity\Versement | No errors. |
| App\Entity\TransfertFond |
|
| App\Entity\ChequeEspece |
|
| App\Entity\AjustementSolde | No errors. |
| App\Entity\Recette | No errors. |
| App\Entity\Facturation |
|
| App\Entity\TauxDevise | No errors. |
| App\Entity\ModificationFacture |
|
| App\Entity\Proformat |
|
| App\Entity\SuppressionFacture | No errors. |
| App\Entity\EchangeDevise |
|
| App\Entity\GestionCheque |
|
| App\Entity\ClotureCaisse | No errors. |
| App\Entity\Contact | No errors. |