Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

2.68 ms Query time

0 Invalid entities

Time▼

Count

Info

1.16 ms
(43.31%)

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_ad1902b54f88ed394dcc7b6a8a8b84a3->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 117)
18	App\Controller\HomeController->team (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.95 ms
(35.47%)

SELECT id, name, url, avatar, bio, facebook, twitter, linkedin, instagram, pinterest FROM blog_authors

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name,
  url,
  avatar,
  bio,
  facebook,
  twitter,
  linkedin,
  instagram,
  pinterest
FROM
  blog_authors

SELECT id, name, url, avatar, bio, facebook, twitter, linkedin, instagram, pinterest FROM blog_authors;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 22)
3	App\ReadModel\CommonFetcher->team (line 117)
4	App\Controller\HomeController->team (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.57 ms
(21.22%)

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_ad1902b54f88ed394dcc7b6a8a8b84a3->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 117)
17	App\Controller\HomeController->team (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.