Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

8.70 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.47 ms
(28.32%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.ordre AS ordre_2, a0_.actif AS actif_3 FROM action_rubrique a0_ WHERE a0_.titre = ?

Parameters:

[
  "Accueil"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.ordre AS ordre_2,
  a0_.actif AS actif_3
FROM
  action_rubrique a0_
WHERE
  a0_.titre = ?

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.ordre AS ordre_2, a0_.actif AS actif_3 FROM action_rubrique a0_ WHERE a0_.titre = 'Accueil';

#	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 100)
7	App\Repository\ActionRubriqueRepository->findAccueil (line 126)
8	App\Controller\ZfrontController->front_index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

2.34 ms
(26.83%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.texte AS texte_2, a0_.visuel AS visuel_3, a0_.date_crea AS date_crea_4, a0_.date_publi AS date_publi_5, a0_.actif AS actif_6 FROM articles a0_ WHERE a0_.actif = ? ORDER BY a0_.date_crea DESC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.texte AS texte_2,
  a0_.visuel AS visuel_3,
  a0_.date_crea AS date_crea_4,
  a0_.date_publi AS date_publi_5,
  a0_.actif AS actif_6
FROM
  articles a0_
WHERE
  a0_.actif = ?
ORDER BY
  a0_.date_crea DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.texte AS texte_2, a0_.visuel AS visuel_3, a0_.date_crea AS date_crea_4, a0_.date_publi AS date_publi_5, a0_.actif AS actif_6 FROM articles a0_ WHERE a0_.actif = 1 ORDER BY a0_.date_crea DESC;

#	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 38)
7	App\Repository\ArticlesRepository->findAllActifByDateCrea (line 137)
8	App\Controller\ZfrontController->front_index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.55 ms
(17.75%)

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.texte AS texte_2, a0_.visuel AS visuel_3, a0_.date_crea AS date_crea_4, a0_.date_publi AS date_publi_5, a0_.actif AS actif_6, a0_.rubrique_id AS rubrique_id_7 FROM actions a0_ WHERE a0_.rubrique_id = ? ORDER BY a0_.date_crea DESC

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.titre AS titre_1,
  a0_.texte AS texte_2,
  a0_.visuel AS visuel_3,
  a0_.date_crea AS date_crea_4,
  a0_.date_publi AS date_publi_5,
  a0_.actif AS actif_6,
  a0_.rubrique_id AS rubrique_id_7
FROM
  actions a0_
WHERE
  a0_.rubrique_id = ?
ORDER BY
  a0_.date_crea DESC

SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.texte AS texte_2, a0_.visuel AS visuel_3, a0_.date_crea AS date_crea_4, a0_.date_publi AS date_publi_5, a0_.actif AS actif_6, a0_.rubrique_id AS rubrique_id_7 FROM actions a0_ WHERE a0_.rubrique_id = 6 ORDER BY a0_.date_crea DESC;

#	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 61)
7	App\Repository\ActionsRepository->findAllRubByDateCrea (line 130)
8	App\Controller\ZfrontController->front_index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.22 ms
(14.03%)

SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.ordre AS ordre_4, c0_.actif AS actif_5 FROM caroussel c0_ WHERE c0_.actif = 1 ORDER BY c0_.ordre ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.image AS image_1,
  c0_.title AS title_2,
  c0_.caption AS caption_3,
  c0_.ordre AS ordre_4,
  c0_.actif AS actif_5
FROM
  caroussel c0_
WHERE
  c0_.actif = 1
ORDER BY
  c0_.ordre ASC

SELECT c0_.id AS id_0, c0_.image AS image_1, c0_.title AS title_2, c0_.caption AS caption_3, c0_.ordre AS ordre_4, c0_.actif AS actif_5 FROM caroussel c0_ WHERE c0_.actif = 1 ORDER BY c0_.ordre ASC;

#	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 35)
7	App\Repository\CarousselRepository->findAllActifByOrdre (line 134)
8	App\Controller\ZfrontController->front_index (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.14 ms
(13.06%)

SELECT t0.id AS id_1, t0.actif AS actif_2 FROM carousel_actif t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2
FROM
  carousel_actif t0

SELECT t0.id AS id_1, t0.actif AS actif_2 FROM carousel_actif 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 133)
6	App\Controller\ZfrontController->front_index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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\ActionRubrique	No errors.
App\Entity\Actions	No errors.
App\Entity\CarouselActif	No errors.
App\Entity\Caroussel	No errors.
App\Entity\Articles	No errors.

Symfony Profiler

GET https://sel.asso.fr/www/public/index.php/?id=64

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping