Symfony Profiler

Query Metrics

20 Database Queries

4 Different statements

4.63 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.91 ms
(41.35%)

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 483)
7	App\Controller\Controller_Frontoffice\Article\ArticleController->promotionsAction (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)

1.77 ms
(38.19%)

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

Parameters:

[
  2
]

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
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url_img AS url_img_3 FROM categories t0 WHERE t0.id = 2 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 493)
7	App\Controller\Controller_Frontoffice\Article\ArticleController->promotionsAction (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.49 ms
(10.63%)

SELECT a0_.id AS id_0, a0_.date_ajout AS date_ajout_1, a0_.titre AS titre_2, a0_.ref AS ref_3, a0_.description AS description_4, a0_.prix_achat AS prix_achat_5, a0_.marge AS marge_6, a0_.prix_ht AS prix_ht_7, a0_.prix_ttc AS prix_ttc_8, a0_.tva AS tva_9, a0_.prix_promo AS prix_promo_10, a0_.prix_pro AS prix_pro_11, a0_.prix_pro_ttc AS prix_pro_ttc_12, a0_.min_qte AS min_qte_13, a0_.unite AS unite_14, a0_.img_principale AS img_principale_15, a0_.id_sous_categorie AS id_sous_categorie_16, a0_.etat AS etat_17, a0_.ordre AS ordre_18 FROM articles a0_ WHERE a0_.prix_promo > 0 AND a0_.prix_promo < a0_.prix_ttc AND a0_.etat = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.date_ajout AS date_ajout_1,
  a0_.titre AS titre_2,
  a0_.ref AS ref_3,
  a0_.description AS description_4,
  a0_.prix_achat AS prix_achat_5,
  a0_.marge AS marge_6,
  a0_.prix_ht AS prix_ht_7,
  a0_.prix_ttc AS prix_ttc_8,
  a0_.tva AS tva_9,
  a0_.prix_promo AS prix_promo_10,
  a0_.prix_pro AS prix_pro_11,
  a0_.prix_pro_ttc AS prix_pro_ttc_12,
  a0_.min_qte AS min_qte_13,
  a0_.unite AS unite_14,
  a0_.img_principale AS img_principale_15,
  a0_.id_sous_categorie AS id_sous_categorie_16,
  a0_.etat AS etat_17,
  a0_.ordre AS ordre_18
FROM
  articles a0_
WHERE
  a0_.prix_promo > 0
  AND a0_.prix_promo < a0_.prix_ttc
  AND a0_.etat = 1

SELECT a0_.id AS id_0, a0_.date_ajout AS date_ajout_1, a0_.titre AS titre_2, a0_.ref AS ref_3, a0_.description AS description_4, a0_.prix_achat AS prix_achat_5, a0_.marge AS marge_6, a0_.prix_ht AS prix_ht_7, a0_.prix_ttc AS prix_ttc_8, a0_.tva AS tva_9, a0_.prix_promo AS prix_promo_10, a0_.prix_pro AS prix_pro_11, a0_.prix_pro_ttc AS prix_pro_ttc_12, a0_.min_qte AS min_qte_13, a0_.unite AS unite_14, a0_.img_principale AS img_principale_15, a0_.id_sous_categorie AS id_sous_categorie_16, a0_.etat AS etat_17, a0_.ordre AS ordre_18 FROM articles a0_ WHERE a0_.prix_promo > 0 AND a0_.prix_promo < a0_.prix_ttc AND a0_.etat = 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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 472)
7	App\Controller\Controller_Frontoffice\Article\ArticleController->promotionsAction (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.46 ms
(9.83%)

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 452)
6	App\Controller\Controller_Frontoffice\Article\ArticleController->promotionsAction (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)

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/promotions?page=2

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping