Symfony Profiler

Query Metrics

16 Database Queries

13 Different statements

5.11 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.40 ms
(27.40%)

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 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 1270)
9	twig_test_empty (line 74)
10	__TwigTemplate_03463e67c99ada97ffde98c7c1a1c340->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 96)
13	__TwigTemplate_56c9b1f411c2b269f36c1ddb14b7fff6->block_body (line 171)
14	Twig\Template->displayBlock (line 92)
15	__TwigTemplate_589a0445aab85c29a08ac76d4c1b04ba->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 49)
18	__TwigTemplate_56c9b1f411c2b269f36c1ddb14b7fff6->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 379)
21	Twig\Template->render (line 38)
22	Twig\TemplateWrapper->render (line 280)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 109)
27	App\Controller\BlogController->blog_rubrique (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.51 ms
(9.92%)

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:

[
  "20"
]

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 = '20';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
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.38 ms
(7.44%)

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 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 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.36 ms
(6.97%)

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 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 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.34 ms
(6.69%)

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 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
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.34 ms
(6.63%)

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 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
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.33 ms
(6.44%)

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 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 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.32 ms
(6.18%)

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 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = ?

Parameters:

[
  15
]

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
  INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id
WHERE
  blog_publication_blog_rubrique.blog_publication_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 INNER JOIN blog_publication_blog_rubrique ON t0.id = blog_publication_blog_rubrique.blog_rubrique_id WHERE blog_publication_blog_rubrique.blog_publication_id = 15;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 62)
8	__TwigTemplate_a3f14aad4bc80e3678899ba2d1c9d33b->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 117)
11	__TwigTemplate_56c9b1f411c2b269f36c1ddb14b7fff6->block_body (line 171)
12	Twig\Template->displayBlock (line 92)
13	__TwigTemplate_589a0445aab85c29a08ac76d4c1b04ba->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 49)
16	__TwigTemplate_56c9b1f411c2b269f36c1ddb14b7fff6->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 379)
19	Twig\Template->render (line 38)
20	Twig\TemplateWrapper->render (line 280)
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.30 ms
(5.95%)

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 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 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.28 ms
(5.57%)

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 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 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)

0.22 ms
(4.24%)

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:

[
  "20"
]

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 = '20' ORDER BY b0_.date_publication DESC LIMIT 3;

#	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 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
(4.09%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.titre AS titre_3,
  t0.legende AS legende_4,
  t0.ordre AS ordre_5
FROM
  blog_image t0
  INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id
WHERE
  blog_image_blog_publication.blog_publication_id = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.titre AS titre_3, t0.legende AS legende_4, t0.ordre AS ordre_5 FROM blog_image t0 INNER JOIN blog_image_blog_publication ON t0.id = blog_image_blog_publication.blog_image_id WHERE blog_image_blog_publication.blog_publication_id = 15;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1051)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 980)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2712)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 108)
7	Doctrine\Common\Collections\AbstractLazyCollection->containsKey (line 350)
8	Doctrine\ORM\PersistentCollection->containsKey (line 425)
9	Doctrine\ORM\PersistentCollection->offsetExists (line 1476)
10	twig_get_attribute (line 95)
11	__TwigTemplate_a3f14aad4bc80e3678899ba2d1c9d33b->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 117)
14	__TwigTemplate_56c9b1f411c2b269f36c1ddb14b7fff6->block_body (line 171)
15	Twig\Template->displayBlock (line 92)
16	__TwigTemplate_589a0445aab85c29a08ac76d4c1b04ba->doDisplay (line 394)
17	Twig\Template->displayWithErrorHandling (line 367)
18	Twig\Template->display (line 49)
19	__TwigTemplate_56c9b1f411c2b269f36c1ddb14b7fff6->doDisplay (line 394)
20	Twig\Template->displayWithErrorHandling (line 367)
21	Twig\Template->display (line 379)
22	Twig\Template->render (line 38)
23	Twig\TemplateWrapper->render (line 280)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 109)
28	App\Controller\BlogController->blog_rubrique (line 178)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.13 ms
(2.48%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.societe AS societe_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.cgu AS cgu_10, t0.actif AS actif_11, t0.code_verif AS code_verif_12, t0.date_crea AS date_crea_13, t0.date_modif AS date_modif_14, t0.color AS color_15 FROM secur_user t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.prenom AS prenom_5,
  t0.nom AS nom_6,
  t0.societe AS societe_7,
  t0.email AS email_8,
  t0.telephone AS telephone_9,
  t0.cgu AS cgu_10,
  t0.actif AS actif_11,
  t0.code_verif AS code_verif_12,
  t0.date_crea AS date_crea_13,
  t0.date_modif AS date_modif_14,
  t0.color AS color_15
FROM
  secur_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.prenom AS prenom_5, t0.nom AS nom_6, t0.societe AS societe_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.cgu AS cgu_10, t0.actif AS actif_11, t0.code_verif AS code_verif_12, t0.date_crea AS date_crea_13, t0.date_modif AS date_modif_14, t0.color AS color_15 FROM secur_user t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 118)
6	Proxies\__CG__\App\Entity\SecurUser->__get (line 91)
7	App\Entity\SecurUser->getUsername (line 1635)
8	twig_get_attribute (line 106)
9	__TwigTemplate_a3f14aad4bc80e3678899ba2d1c9d33b->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 117)
12	__TwigTemplate_56c9b1f411c2b269f36c1ddb14b7fff6->block_body (line 171)
13	Twig\Template->displayBlock (line 92)
14	__TwigTemplate_589a0445aab85c29a08ac76d4c1b04ba->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 49)
17	__TwigTemplate_56c9b1f411c2b269f36c1ddb14b7fff6->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 379)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 280)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 109)
26	App\Controller\BlogController->blog_rubrique (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	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\BlogImage	No errors.
App\Entity\BlogHeader	No errors.
App\Entity\BlogChapeau	No errors.
App\Entity\BlogAbout	No errors.
App\Entity\BlogReseaux	No errors.
App\Entity\Medias	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping