Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

96.72 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

22.39 ms

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.locale AS locale_19, n0_.user_id_id AS user_id_id_20, c1_.parent_id AS parent_id_21 FROM news_post n0_ LEFT JOIN newsposts_categories n2_ ON n0_.id = n2_.news_post_id LEFT JOIN categorie c1_ ON c1_.id = n2_.categorie_id WHERE n0_.slug = ?

Parameters:

[
  "article-dans-la-revue-diocesaine-d-oslo"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.summary AS summary_3,
  n0_.content AS content_4,
  n0_.content2 AS content2_5,
  n0_.nm AS nm_6,
  n0_.locale AS locale_7,
  n0_.aside AS aside_8,
  n0_.notes AS notes_9,
  n0_.mindate AS mindate_10,
  n0_.published_at AS published_at_11,
  n0_.active AS active_12,
  n0_.illustration AS illustration_13,
  n0_.illustration2 AS illustration2_14,
  n0_.illustration3 AS illustration3_15,
  c1_.id AS id_16,
  c1_.name AS name_17,
  c1_.slug AS slug_18,
  c1_.locale AS locale_19,
  n0_.user_id_id AS user_id_id_20,
  c1_.parent_id AS parent_id_21
FROM
  news_post n0_
  LEFT JOIN newsposts_categories n2_ ON n0_.id = n2_.news_post_id
  LEFT JOIN categorie c1_ ON c1_.id = n2_.categorie_id
WHERE
  n0_.slug = ?

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, c1_.id AS id_16, c1_.name AS name_17, c1_.slug AS slug_18, c1_.locale AS locale_19, n0_.user_id_id AS user_id_id_20, c1_.parent_id AS parent_id_21 FROM news_post n0_ LEFT JOIN newsposts_categories n2_ ON n0_.id = n2_.news_post_id LEFT JOIN categorie c1_ ON c1_.id = n2_.categorie_id WHERE n0_.slug = 'article-dans-la-revue-diocesaine-d-oslo';

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 76)
7	App\Repository\NewsPostRepository->findOneNews (line 31)
8	App\Controller\NewsPostPublicController->detailNews (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)

18.15 ms

SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.display_name AS display_name_7 FROM "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.nickname AS nickname_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.email AS email_5,
  t0.is_verified AS is_verified_6,
  t0.display_name AS display_name_7
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nickname AS nickname_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.is_verified AS is_verified_6, t0.display_name AS display_name_7 FROM "user" 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 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\User::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 140)
7	Proxies\__CG__\App\Entity\User->__get (line 251)
8	App\Entity\User->getDisplayName (line 1882)
9	Twig\Extension\CoreExtension::getAttribute (line 102)
10	__TwigTemplate_837fd837480ca728d31945d29b8db054->block_body (line 432)
11	Twig\Template->yieldBlock (line 171)
12	__TwigTemplate_251b2ca1e7ea4af5a48ca7b88e515ef4->doDisplay (line 388)
13	Twig\Template->yield (line 53)
14	__TwigTemplate_837fd837480ca728d31945d29b8db054->doDisplay (line 388)
15	Twig\Template->yield (line 344)
16	Twig\Template->display (line 359)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 334)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
23	App\Controller\NewsPostPublicController->detailNews (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

37.48 ms

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.active = ? AND n0_.locale = ? ORDER BY n0_.nm DESC LIMIT 3

Parameters:

[
  1
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.summary AS summary_3,
  n0_.content AS content_4,
  n0_.content2 AS content2_5,
  n0_.nm AS nm_6,
  n0_.locale AS locale_7,
  n0_.aside AS aside_8,
  n0_.notes AS notes_9,
  n0_.mindate AS mindate_10,
  n0_.published_at AS published_at_11,
  n0_.active AS active_12,
  n0_.illustration AS illustration_13,
  n0_.illustration2 AS illustration2_14,
  n0_.illustration3 AS illustration3_15,
  n0_.user_id_id AS user_id_id_16
FROM
  news_post n0_
WHERE
  n0_.active = ?
  AND n0_.locale = ?
ORDER BY
  n0_.nm DESC
LIMIT
  3

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.active = 1 AND n0_.locale = 'fr' ORDER BY n0_.nm 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 93)
6	App\Repository\NewsPostRepository->findLatest3Posts (line 74)
7	App\Controller\NewsPostPublicController->news3blogdetails (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 181)
15	__TwigTemplate_837fd837480ca728d31945d29b8db054->block_body (line 432)
16	Twig\Template->yieldBlock (line 171)
17	__TwigTemplate_251b2ca1e7ea4af5a48ca7b88e515ef4->doDisplay (line 388)
18	Twig\Template->yield (line 53)
19	__TwigTemplate_837fd837480ca728d31945d29b8db054->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
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 33)
28	App\Controller\NewsPostPublicController->detailNews (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

18.69 ms

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.active = ? AND n0_.locale = ? ORDER BY n0_.nm DESC LIMIT 2

Parameters:

[
  1
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.summary AS summary_3,
  n0_.content AS content_4,
  n0_.content2 AS content2_5,
  n0_.nm AS nm_6,
  n0_.locale AS locale_7,
  n0_.aside AS aside_8,
  n0_.notes AS notes_9,
  n0_.mindate AS mindate_10,
  n0_.published_at AS published_at_11,
  n0_.active AS active_12,
  n0_.illustration AS illustration_13,
  n0_.illustration2 AS illustration2_14,
  n0_.illustration3 AS illustration3_15,
  n0_.user_id_id AS user_id_id_16
FROM
  news_post n0_
WHERE
  n0_.active = ?
  AND n0_.locale = ?
ORDER BY
  n0_.nm DESC
LIMIT
  2

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.summary AS summary_3, n0_.content AS content_4, n0_.content2 AS content2_5, n0_.nm AS nm_6, n0_.locale AS locale_7, n0_.aside AS aside_8, n0_.notes AS notes_9, n0_.mindate AS mindate_10, n0_.published_at AS published_at_11, n0_.active AS active_12, n0_.illustration AS illustration_13, n0_.illustration2 AS illustration2_14, n0_.illustration3 AS illustration3_15, n0_.user_id_id AS user_id_id_16 FROM news_post n0_ WHERE n0_.active = 1 AND n0_.locale = 'fr' ORDER BY n0_.nm DESC LIMIT 2;

#	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 109)
6	App\Repository\NewsPostRepository->findLatest2Posts (line 85)
7	App\Controller\NewsPostPublicController->news2 (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
10	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
11	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
12	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
13	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
14	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 184)
15	__TwigTemplate_9c50303b7d6c017efa500a72efe1d8c3->doDisplay (line 388)
16	Twig\Template->yield (line 176)
17	__TwigTemplate_251b2ca1e7ea4af5a48ca7b88e515ef4->doDisplay (line 388)
18	Twig\Template->yield (line 53)
19	__TwigTemplate_837fd837480ca728d31945d29b8db054->doDisplay (line 388)
20	Twig\Template->yield (line 344)
21	Twig\Template->display (line 359)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 334)
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 33)
28	App\Controller\NewsPostPublicController->detailNews (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	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\NewsPost	No errors.
App\Entity\Categorie	No errors.
App\Entity\User	No errors.
App\Entity\Post	No errors.
App\Entity\Comment	The field App\Entity\Comment#comments is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Comment#comments does not contain the required 'mappedBy="comments"' attribute. If association App\Entity\Comment#comments is many-to-one, then the inversed side App\Entity\Comment#comments has to be one-to-many.
App\Entity\Keyword	No errors.
App\Entity\JoinImagePost	No errors.
App\Entity\Image	No errors.

Symfony Profiler

GET http://elisebisschop.fr/fr/news/article-dans-la-revue-diocesaine-d-oslo

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping