Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

4.39 ms Query time

14 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.48 ms
(33.71%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 62)
7	App\Repository\CategorieRepository->findCategoriesPaginated (line 34)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.96 ms
(21.76%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 69)
8	App\Repository\CategorieRepository->findCategoriesPaginated (line 34)
9	App\Controller\HomeController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.54 ms
(12.41%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 72)
7	App\Repository\ProductsRepository->findProductsHomePaginated (line 35)
8	App\Controller\HomeController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.52 ms
(11.80%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 937)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 75)
8	App\Repository\ProductsRepository->findProductsHomePaginated (line 35)
9	App\Controller\HomeController->index (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.32 ms
(7.24%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 53)
6	App\Controller\HomeController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.31 ms
(7.02%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 37)
5	App\Controller\HomeController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.27 ms
(6.06%)

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
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 36)
6	App\Controller\HomeController->index (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

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	The association App\Entity\Products#stocks refers to the owning side field App\Entity\Stock#products which does not exist.
App\Entity\Dimensions	No errors.
App\Entity\Epaisseurs	No errors.
App\Entity\OrigineProduit	No errors.
App\Entity\TypeProduit	No errors.
App\Entity\Stock	The mappings App\Entity\Stock#product and App\Entity\Products#stocks are inconsistent with each other.
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	The association App\Entity\RetourProduct#lieuVente refers to the inverse side field App\Entity\LieuxVentes#retourProducts which does not exist.
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	The mappings App\Entity\TransfertProducts#traitePar and App\Entity\User#transfertProduct are inconsistent with each other.
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	The mappings App\Entity\PrimesPersonnel#saisiePar and App\Entity\User#primesPersonnels are inconsistent with each other.
App\Entity\AvanceSalaire	The association App\Entity\AvanceSalaire#devise refers to the inverse side field App\Entity\Devise#avanceSalaires which does not exist.
App\Entity\PaiementSalairePersonnel	The mappings App\Entity\PaiementSalairePersonnel#saisiePar and App\Entity\User#paiementSalairePersonnels are inconsistent with each other. The association App\Entity\PaiementSalairePersonnel#compteRetrait refers to the inverse side field App\Entity\Caisse#paiementSalairePersonnels which does not exist. The association App\Entity\PaiementSalairePersonnel#typePaiement refers to the inverse side field App\Entity\ModePaiement#paiementSalairePersonnels which does not exist. The association App\Entity\PaiementSalairePersonnel#devise refers to the inverse side field App\Entity\Devise#paiementSalairePersonnels which does not exist.
App\Entity\Depenses	No errors.
App\Entity\Versement	No errors.
App\Entity\TransfertFond	The mappings App\Entity\TransfertFond#caisseReception and App\Entity\Caisse#transfertFonds are inconsistent with each other. The mappings App\Entity\TransfertFond#envoyePar and App\Entity\User#transfertFonds are inconsistent with each other.
App\Entity\ChequeEspece	The mappings App\Entity\ChequeEspece#caisseRetrait and App\Entity\Caisse#chequeEspeces are inconsistent with each other. The mappings App\Entity\ChequeEspece#saisiePar and App\Entity\User#chequeEspeces are inconsistent with each other.
App\Entity\AjustementSolde	No errors.
App\Entity\Recette	No errors.
App\Entity\Facturation	The mappings App\Entity\Facturation#saisiePar and App\Entity\User#facturations are inconsistent with each other.
App\Entity\TauxDevise	No errors.
App\Entity\ModificationFacture	The mappings App\Entity\ModificationFacture#client and App\Entity\User#modificationFactures are inconsistent with each other.
App\Entity\Proformat	The mappings App\Entity\Proformat#saisiePar and App\Entity\User#proformats are inconsistent with each other.
App\Entity\SuppressionFacture	No errors.
App\Entity\EchangeDevise	The mappings App\Entity\EchangeDevise#caisseDestination and App\Entity\Caisse#echangeDevises are inconsistent with each other. The mappings App\Entity\EchangeDevise#deviseDestination and App\Entity\Devise#echangeDevises are inconsistent with each other.
App\Entity\GestionCheque	The mappings App\Entity\GestionCheque#caisseReception and App\Entity\Caisse#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#lieuVenteReception and App\Entity\LieuxVentes#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#envoyePar and App\Entity\User#gestionCheques are inconsistent with each other. The mappings App\Entity\GestionCheque#collaborateur and App\Entity\User#gestionCheques are inconsistent with each other.
App\Entity\ClotureCaisse	No errors.
App\Entity\Contact	No errors.

Symfony Profiler

GET https://globalbusiness.damkocompany.com/public/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping