Symfony Profiler

Query Metrics

13 Database Queries

3 Different statements

3.34 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.49 ms
(74.57%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  9
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.url_img AS url_img_3,
  t0.id_categorie AS id_categorie_4
FROM
  sous_categories t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3, t0.id_categorie AS id_categorie_4 FROM sous_categories t0 WHERE t0.id = 9 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 234)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 157)
5	Doctrine\ORM\EntityRepository->__call (line 94)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 69)
7	App\Controller\Controller_Frontoffice\Article\ArticleController->productsAction (line 163)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.43 ms
(12.82%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.url_img AS url_img_3
FROM
  categories t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 54)
6	App\Controller\Controller_Frontoffice\Article\ArticleController->productsAction (line 163)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.42 ms
(12.61%)

SELECT t0.id AS id_1, t0.date_ajout AS date_ajout_2, t0.titre AS titre_3, t0.ref AS ref_4, t0.description AS description_5, t0.prix_achat AS prix_achat_6, t0.marge AS marge_7, t0.prix_ht AS prix_ht_8, t0.prix_ttc AS prix_ttc_9, t0.tva AS tva_10, t0.prix_promo AS prix_promo_11, t0.prix_pro AS prix_pro_12, t0.prix_pro_ttc AS prix_pro_ttc_13, t0.min_qte AS min_qte_14, t0.unite AS unite_15, t0.img_principale AS img_principale_16, t0.id_sous_categorie AS id_sous_categorie_17, t0.etat AS etat_18, t0.ordre AS ordre_19 FROM articles t0 WHERE t0.etat = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date_ajout AS date_ajout_2,
  t0.titre AS titre_3,
  t0.ref AS ref_4,
  t0.description AS description_5,
  t0.prix_achat AS prix_achat_6,
  t0.marge AS marge_7,
  t0.prix_ht AS prix_ht_8,
  t0.prix_ttc AS prix_ttc_9,
  t0.tva AS tva_10,
  t0.prix_promo AS prix_promo_11,
  t0.prix_pro AS prix_pro_12,
  t0.prix_pro_ttc AS prix_pro_ttc_13,
  t0.min_qte AS min_qte_14,
  t0.unite AS unite_15,
  t0.img_principale AS img_principale_16,
  t0.id_sous_categorie AS id_sous_categorie_17,
  t0.etat AS etat_18,
  t0.ordre AS ordre_19
FROM
  articles t0
WHERE
  t0.etat = ?

SELECT t0.id AS id_1, t0.date_ajout AS date_ajout_2, t0.titre AS titre_3, t0.ref AS ref_4, t0.description AS description_5, t0.prix_achat AS prix_achat_6, t0.marge AS marge_7, t0.prix_ht AS prix_ht_8, t0.prix_ttc AS prix_ttc_9, t0.tva AS tva_10, t0.prix_promo AS prix_promo_11, t0.prix_pro AS prix_pro_12, t0.prix_pro_ttc AS prix_pro_ttc_13, t0.min_qte AS min_qte_14, t0.unite AS unite_15, t0.img_principale AS img_principale_16, t0.id_sous_categorie AS id_sous_categorie_17, t0.etat AS etat_18, t0.ordre AS ordre_19 FROM articles t0 WHERE t0.etat = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 57)
5	App\Controller\Controller_Frontoffice\Article\ArticleController->productsAction (line 163)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 74)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 184)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Categories	No errors.
App\Entity\Articles	No errors.
App\Entity\SousCategories	No errors.

Symfony Profiler

GET https://ep.proxisoft.ma/products?page=1

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping