Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

2.45 ms Query time

0 Invalid entities

Time▼

Count

Info

1.59 ms
(64.84%)

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 57)
9	__TwigTemplate_6479b40cb1c70879cd59f637c2a3768c->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 109)
18	App\Controller\HomeController->contact (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.86 ms
(35.16%)

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 57)
8	__TwigTemplate_6479b40cb1c70879cd59f637c2a3768c->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 109)
17	App\Controller\HomeController->contact (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.
App\Model\Support\Entity\Support	No errors.