Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.02 ms Query time

0 Invalid entities

#▲

Time

Info

0.89 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 155)
7	__TwigTemplate_91e0649764ad67b155ed2a037d213813->doDisplay (line 387)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_d1227c1941dafab8cb756f06028bbcb0->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 49)
18	App\Controller\HomeController->login (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.59 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 225)
7	__TwigTemplate_91e0649764ad67b155ed2a037d213813->doDisplay (line 387)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_d1227c1941dafab8cb756f06028bbcb0->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 49)
18	App\Controller\HomeController->login (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.55 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 326)
6	__TwigTemplate_91e0649764ad67b155ed2a037d213813->doDisplay (line 387)
7	Twig\Template->yield (line 55)
8	__TwigTemplate_d1227c1941dafab8cb756f06028bbcb0->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 49)
17	App\Controller\HomeController->login (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)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

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.