Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.96 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.36 ms
(37.62%)

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.id_sous_categorie IN (?) AND t0.etat = ?

Parameters:

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.id_sous_categorie IN (?)
  AND 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.id_sous_categorie IN (5) AND 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 147)
5	App\Controller\Controller_Frontoffice\Article\ArticleController->productAction (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)

0.36 ms
(37.42%)

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 127)
6	App\Controller\Controller_Frontoffice\Article\ArticleController->productAction (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.24 ms
(24.96%)

SELECT s0_.id AS id_0 FROM sous_categories s0_ WHERE s0_.id_categorie = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0
FROM
  sous_categories s0_
WHERE
  s0_.id_categorie = 1

SELECT s0_.id AS id_0 FROM sous_categories s0_ WHERE s0_.id_categorie = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 140)
7	App\Controller\Controller_Frontoffice\Article\ArticleController->productAction (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)

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\SousCategories	No errors.
App\Entity\Articles	No errors.

Symfony Profiler

GET https://ep.proxisoft.ma/products/L%C3%A9gumes/1/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping