Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

3.70 ms Query time

0 Invalid entities

Time▼

Count

Info

1.52 ms
(41.10%)

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 489)
4	__TwigTemplate_254ecb9fe7e4b6f391dfd85b69c68456->block_body (line 431)
5	Twig\Template->yieldBlock (line 316)
6	__TwigTemplate_91e0649764ad67b155ed2a037d213813->doDisplay (line 387)
7	Twig\Template->yield (line 57)
8	__TwigTemplate_254ecb9fe7e4b6f391dfd85b69c68456->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 34)
17	App\Controller\HomeController->home (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)

1.39 ms
(37.58%)

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 57)
9	__TwigTemplate_254ecb9fe7e4b6f391dfd85b69c68456->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 34)
18	App\Controller\HomeController->home (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.79 ms
(21.32%)

SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 22

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name
FROM
  blog_tag_names
ORDER BY
  RAND() ASC
LIMIT
  22

SELECT id, name FROM blog_tag_names ORDER BY RAND() ASC LIMIT 22;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 638)
3	App\ReadModel\Blog\BlogFetcher->getTags (line 29)
4	App\Widget\Blog\TagsCloud->tags_cloud (line 567)
5	__TwigTemplate_254ecb9fe7e4b6f391dfd85b69c68456->block_body (line 431)
6	Twig\Template->yieldBlock (line 316)
7	__TwigTemplate_91e0649764ad67b155ed2a037d213813->doDisplay (line 387)
8	Twig\Template->yield (line 57)
9	__TwigTemplate_254ecb9fe7e4b6f391dfd85b69c68456->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 34)
18	App\Controller\HomeController->home (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)

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.