Symfony Profiler

Query Metrics

13 Database Queries

10 Different statements

2.28 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.63 ms
(27.51%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.image AS image_3,
  t0.texte AS texte_4,
  t0.ordre AS ordre_5,
  t0.actif AS actif_6,
  t0.parent_id AS parent_id_7
FROM
  blog_rubrique t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.parent_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1834)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1779)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1386)
9	Twig\Extension\CoreExtension::testEmpty (line 79)
10	__TwigTemplate_602d4b613f3d06386670c32b29ea6eca->doDisplay (line 388)
11	Twig\Template->yield (line 108)
12	__TwigTemplate_c5902915d7009eee684b5eebd5209999->block_body (line 432)
13	Twig\Template->yieldBlock (line 97)
14	__TwigTemplate_c8c9e6d49df7209d71d632b76b4ad92f->doDisplay (line 388)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_c5902915d7009eee684b5eebd5209999->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 109)
25	App\Controller\BlogController->blog_rubrique (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.36 ms
(15.81%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.id = ?

Parameters:

[
  "38"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.image AS image_3,
  t0.texte AS texte_4,
  t0.ordre AS ordre_5,
  t0.actif AS actif_6,
  t0.parent_id AS parent_id_7
FROM
  blog_rubrique t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.texte AS texte_4, t0.ordre AS ordre_5, t0.actif AS actif_6, t0.parent_id AS parent_id_7 FROM blog_rubrique t0 WHERE t0.id = '38';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 97)
7	App\Controller\BlogController->blog_rubrique (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.25 ms
(11.04%)

SELECT b0_.id AS id_0, b0_.sur_titre AS sur_titre_1, b0_.titre AS titre_2, b0_.sous_titre AS sous_titre_3, b0_.chapeau AS chapeau_4, b0_.texte AS texte_5, b0_.date_crea AS date_crea_6, b0_.date_modif AS date_modif_7, b0_.date_publication AS date_publication_8, b0_.en_ligne AS en_ligne_9, b0_.auteur_id AS auteur_id_10 FROM blog_publication b0_ INNER JOIN blog_publication_blog_rubrique b2_ ON b0_.id = b2_.blog_publication_id INNER JOIN blog_rubrique b1_ ON b1_.id = b2_.blog_rubrique_id WHERE b1_.id = ? ORDER BY b0_.date_publication DESC LIMIT 3

Parameters:

[
  "38"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.sur_titre AS sur_titre_1,
  b0_.titre AS titre_2,
  b0_.sous_titre AS sous_titre_3,
  b0_.chapeau AS chapeau_4,
  b0_.texte AS texte_5,
  b0_.date_crea AS date_crea_6,
  b0_.date_modif AS date_modif_7,
  b0_.date_publication AS date_publication_8,
  b0_.en_ligne AS en_ligne_9,
  b0_.auteur_id AS auteur_id_10
FROM
  blog_publication b0_
  INNER JOIN blog_publication_blog_rubrique b2_ ON b0_.id = b2_.blog_publication_id
  INNER JOIN blog_rubrique b1_ ON b1_.id = b2_.blog_rubrique_id
WHERE
  b1_.id = ?
ORDER BY
  b0_.date_publication DESC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.sur_titre AS sur_titre_1, b0_.titre AS titre_2, b0_.sous_titre AS sous_titre_3, b0_.chapeau AS chapeau_4, b0_.texte AS texte_5, b0_.date_crea AS date_crea_6, b0_.date_modif AS date_modif_7, b0_.date_publication AS date_publication_8, b0_.en_ligne AS en_ligne_9, b0_.auteur_id AS auteur_id_10 FROM blog_publication b0_ INNER JOIN blog_publication_blog_rubrique b2_ ON b0_.id = b2_.blog_publication_id INNER JOIN blog_rubrique b1_ ON b1_.id = b2_.blog_rubrique_id WHERE b1_.id = '38' ORDER BY b0_.date_publication DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 46)
7	App\Repository\BlogPublicationRepository->findLastRubArticles (line 98)
8	App\Controller\BlogController->blog_rubrique (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.21 ms
(9.24%)

SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.texte AS texte_3, b0_.ordre AS ordre_4, b0_.actif AS actif_5, b0_.parent_id AS parent_id_6 FROM blog_rubrique b0_ LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id WHERE b0_.parent_id IS NULL AND b0_.actif = ? ORDER BY b0_.ordre ASC, b1_.ordre ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.titre AS titre_1,
  b0_.image AS image_2,
  b0_.texte AS texte_3,
  b0_.ordre AS ordre_4,
  b0_.actif AS actif_5,
  b0_.parent_id AS parent_id_6
FROM
  blog_rubrique b0_
  LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id
WHERE
  b0_.parent_id IS NULL
  AND b0_.actif = ?
ORDER BY
  b0_.ordre ASC,
  b1_.ordre ASC

SELECT b0_.id AS id_0, b0_.titre AS titre_1, b0_.image AS image_2, b0_.texte AS texte_3, b0_.ordre AS ordre_4, b0_.actif AS actif_5, b0_.parent_id AS parent_id_6 FROM blog_rubrique b0_ LEFT JOIN blog_rubrique b1_ ON b0_.id = b1_.parent_id WHERE b0_.parent_id IS NULL AND b0_.actif = 1 ORDER BY b0_.ordre ASC, b1_.ordre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 58)
7	App\Repository\BlogRubriqueRepository->findNiv0Actif (line 103)
8	App\Controller\BlogController->blog_rubrique (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.16 ms
(7.01%)

SELECT b0_.id AS id_0, b0_.url AS url_1, b0_.titre AS titre_2, b0_.legende AS legende_3, b0_.ordre AS ordre_4 FROM blog_image b0_ ORDER BY b0_.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.url AS url_1,
  b0_.titre AS titre_2,
  b0_.legende AS legende_3,
  b0_.ordre AS ordre_4
FROM
  blog_image b0_
ORDER BY
  b0_.id DESC
LIMIT
  1

SELECT b0_.id AS id_0, b0_.url AS url_1, b0_.titre AS titre_2, b0_.legende AS legende_3, b0_.ordre AS ordre_4 FROM blog_image b0_ ORDER BY b0_.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 71)
7	App\Repository\BlogImageRepository->recupLastImage (line 107)
8	App\Controller\BlogController->blog_rubrique (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.14 ms
(6.22%)

SELECT t0.id AS id_1, t0.case1_id AS case1_id_2, t0.case2_id AS case2_id_3 FROM blog_chapeau t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.case1_id AS case1_id_2,
  t0.case2_id AS case2_id_3
FROM
  blog_chapeau t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.case1_id AS case1_id_2, t0.case2_id AS case2_id_3 FROM blog_chapeau t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 101)
7	App\Controller\BlogController->blog_rubrique (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.14 ms
(6.13%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.logo AS logo_4 FROM blog_header t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.sous_titre AS sous_titre_3,
  t0.logo AS logo_4
FROM
  blog_header t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.sous_titre AS sous_titre_3, t0.logo AS logo_4 FROM blog_header t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 100)
7	App\Controller\BlogController->blog_rubrique (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.13 ms
(5.83%)

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3 FROM blog_about 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.texte AS texte_3
FROM
  blog_about t0

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.texte AS texte_3 FROM blog_about t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 104)
6	App\Controller\BlogController->blog_rubrique (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.13 ms
(5.69%)

SELECT t0.id AS id_1, t0.url_img AS url_img_2, t0.titre AS titre_3, t0.lien AS lien_4 FROM blog_reseaux t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url_img AS url_img_2,
  t0.titre AS titre_3,
  t0.lien AS lien_4
FROM
  blog_reseaux t0

SELECT t0.id AS id_1, t0.url_img AS url_img_2, t0.titre AS titre_3, t0.lien AS lien_4 FROM blog_reseaux t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 105)
6	App\Controller\BlogController->blog_rubrique (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.13 ms
(5.52%)

SELECT DISTINCT b0_.date_publication AS date_publication_0 FROM blog_publication b0_ WHERE b0_.date_publication IS NOT NULL ORDER BY b0_.date_publication DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT b0_.date_publication AS date_publication_0
FROM
  blog_publication b0_
WHERE
  b0_.date_publication IS NOT NULL
ORDER BY
  b0_.date_publication DESC

SELECT DISTINCT b0_.date_publication AS date_publication_0 FROM blog_publication b0_ WHERE b0_.date_publication IS NOT NULL ORDER BY b0_.date_publication DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 58)
7	App\Repository\BlogPublicationRepository->findPublicationDates (line 106)
8	App\Controller\BlogController->blog_rubrique (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\BlogRubrique	No errors.
App\Entity\BlogPublication	No errors.
App\Entity\SecurUser	No errors.
App\Entity\BlogHeader	No errors.
App\Entity\BlogChapeau	No errors.
App\Entity\BlogAbout	No errors.
App\Entity\BlogReseaux	No errors.
App\Entity\BlogImage	No errors.

Symfony Profiler

GET https://gorgouille.fr/blog/rub/CONCOURS_38

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping