Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

3.18 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.89 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.avatar AS avatar_4, t0.bio AS bio_5, t0.facebook AS facebook_6, t0.twitter AS twitter_7, t0.linkedin AS linkedin_8, t0.instagram AS instagram_9, t0.pinterest AS pinterest_10 FROM blog_authors t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "michael-thompson"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.avatar AS avatar_4,
  t0.bio AS bio_5,
  t0.facebook AS facebook_6,
  t0.twitter AS twitter_7,
  t0.linkedin AS linkedin_8,
  t0.instagram AS instagram_9,
  t0.pinterest AS pinterest_10
FROM
  blog_authors t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.avatar AS avatar_4, t0.bio AS bio_5, t0.facebook AS facebook_6, t0.twitter AS twitter_7, t0.linkedin AS linkedin_8, t0.instagram AS instagram_9, t0.pinterest AS pinterest_10 FROM blog_authors t0 WHERE t0.url = 'michael-thompson' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.79 ms

SELECT a.id, a.name, a.url FROM blog_authors a

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.id,
  a.name,
  a.url
FROM
  blog_authors a

SELECT a.id, a.name, a.url FROM blog_authors a;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 343)
3	App\ReadModel\Blog\BlogFetcher->getPostsAuthorsForLinks (line 28)
4	App\Widget\Blog\AuthorsMenuLiList->authors (line 63)
5	__TwigTemplate_c5acd21ef58be9d9cefd093b05430e74->doDisplay (line 387)
6	Twig\Template->yield (line 135)
7	__TwigTemplate_ec0767ad46ab778310d84a4d0334f5c2->doDisplay (line 387)
8	Twig\Template->yield (line 56)
9	__TwigTemplate_bceb96f532ad41dd6770bd2910acd499->doDisplay (line 387)
10	Twig\Template->yield (line 343)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 320)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
18	App\Controller\BlogController->blogPostsAuthor (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.78 ms

SELECT a.id, a.name, a.url FROM blog_authors a

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a.id,
  a.name,
  a.url
FROM
  blog_authors a

SELECT a.id, a.name, a.url FROM blog_authors a;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 343)
3	App\ReadModel\Blog\BlogFetcher->getPostsAuthorsForLinks (line 28)
4	App\Widget\Blog\AuthorsMenuLiList->authors (line 63)
5	__TwigTemplate_c5acd21ef58be9d9cefd093b05430e74->doDisplay (line 387)
6	Twig\Template->yield (line 200)
7	__TwigTemplate_ec0767ad46ab778310d84a4d0334f5c2->doDisplay (line 387)
8	Twig\Template->yield (line 56)
9	__TwigTemplate_bceb96f532ad41dd6770bd2910acd499->doDisplay (line 387)
10	Twig\Template->yield (line 343)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 320)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
18	App\Controller\BlogController->blogPostsAuthor (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.72 ms

SELECT COUNT(`id`) FROM `published_blog_posts_ids`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(`id`)
FROM
  `published_blog_posts_ids`

SELECT COUNT(`id`) FROM `published_blog_posts_ids`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 666)
2	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
3	App\Widget\Blog\RandomPosts->random_posts (line 154)
4	__TwigTemplate_0c1ed70de7d02225dea3f8896e518107->doDisplay (line 387)
5	Twig\Template->yield (line 262)
6	__TwigTemplate_ec0767ad46ab778310d84a4d0334f5c2->doDisplay (line 387)
7	Twig\Template->yield (line 56)
8	__TwigTemplate_bceb96f532ad41dd6770bd2910acd499->doDisplay (line 387)
9	Twig\Template->yield (line 343)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 320)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 43)
17	App\Controller\BlogController->blogPostsAuthor (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\Model\Blog\Entity\Post	No errors.
App\Model\User\Entity\Name	No errors.
App\Model\User\Entity\Location	No errors.
App\Model\User\Entity\User	No errors.
App\Model\Blog\Entity\Author\Author	No errors.

Symfony Profiler

GET https://eclectis.eu/index.php/blog/author/michael-thompson

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping