Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

4.98 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.64 ms
(32.97%)

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 224)
3	App\ReadModel\Blog\BlogFetcher->getPostsAuthorsForLinks (line 28)
4	App\Widget\Blog\AuthorsMenuLiList->authors (line 63)
5	__TwigTemplate_bfc5e709e41f38005070eaee5f54ea65->doDisplay (line 393)
6	Twig\Template->yield (line 135)
7	__TwigTemplate_f3a7e619574d9ef7abd576ddc9742681->doDisplay (line 393)
8	Twig\Template->yield (line 57)
9	__TwigTemplate_65b59b62da4ced6de0e1aa571a9cb3f4->doDisplay (line 393)
10	Twig\Template->yield (line 349)
11	Twig\Template->display (line 364)
12	Twig\Template->render (line 35)
13	Twig\TemplateWrapper->render (line 306)
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 116)
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.97 ms
(19.45%)

SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `post_id`
FROM
  `published_blog_posts_ids`
WHERE
  `id` = 1

SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 616)
2	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
3	App\Widget\Blog\RandomPosts->random_posts (line 154)
4	__TwigTemplate_74b3fa3bd6e5da7c9f181fa59e6ebf7f->doDisplay (line 393)
5	Twig\Template->yield (line 262)
6	__TwigTemplate_f3a7e619574d9ef7abd576ddc9742681->doDisplay (line 393)
7	Twig\Template->yield (line 57)
8	__TwigTemplate_65b59b62da4ced6de0e1aa571a9cb3f4->doDisplay (line 393)
9	Twig\Template->yield (line 349)
10	Twig\Template->display (line 364)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 306)
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 116)
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)

0.86 ms
(17.32%)

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 609)
2	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
3	App\Widget\Blog\RandomPosts->random_posts (line 154)
4	__TwigTemplate_74b3fa3bd6e5da7c9f181fa59e6ebf7f->doDisplay (line 393)
5	Twig\Template->yield (line 262)
6	__TwigTemplate_f3a7e619574d9ef7abd576ddc9742681->doDisplay (line 393)
7	Twig\Template->yield (line 57)
8	__TwigTemplate_65b59b62da4ced6de0e1aa571a9cb3f4->doDisplay (line 393)
9	Twig\Template->yield (line 349)
10	Twig\Template->display (line 364)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 306)
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 116)
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)

0.84 ms
(16.86%)

SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p.url,
  p.title,
  p.cover,
  p.date,
  c.id AS category_id,
  c.name AS category_name,
  a.name AS author_name,
  a.url AS author_url,
  (
    SELECT
      COUNT(m.id)
    FROM
      blog_post_comments m
    WHERE
      m.post_id = p.id
  ) AS comments_count
FROM
  blog_posts p
  INNER JOIN blog_authors a ON p.author_id = a.id
  INNER JOIN blog_categories c ON p.category_id = c.id
WHERE
  p.id IN(?, ?)

SELECT p.url, p.title, p.cover, p.date, c.id AS category_id, c.name AS category_name, a.name AS author_name, a.url AS author_url, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id) AS comments_count FROM blog_posts p INNER JOIN blog_authors a ON p.author_id = a.id INNER JOIN blog_categories c ON p.category_id = c.id WHERE p.id IN(1, 2);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 638)
3	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
4	App\Widget\Blog\RandomPosts->random_posts (line 154)
5	__TwigTemplate_74b3fa3bd6e5da7c9f181fa59e6ebf7f->doDisplay (line 393)
6	Twig\Template->yield (line 262)
7	__TwigTemplate_f3a7e619574d9ef7abd576ddc9742681->doDisplay (line 393)
8	Twig\Template->yield (line 57)
9	__TwigTemplate_65b59b62da4ced6de0e1aa571a9cb3f4->doDisplay (line 393)
10	Twig\Template->yield (line 349)
11	Twig\Template->display (line 364)
12	Twig\Template->render (line 35)
13	Twig\TemplateWrapper->render (line 306)
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 116)
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.67 ms
(13.40%)

SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `post_id`
FROM
  `published_blog_posts_ids`
WHERE
  `id` = 2

SELECT `post_id` FROM `published_blog_posts_ids` WHERE `id` = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 616)
2	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
3	App\Widget\Blog\RandomPosts->random_posts (line 154)
4	__TwigTemplate_74b3fa3bd6e5da7c9f181fa59e6ebf7f->doDisplay (line 393)
5	Twig\Template->yield (line 262)
6	__TwigTemplate_f3a7e619574d9ef7abd576ddc9742681->doDisplay (line 393)
7	Twig\Template->yield (line 57)
8	__TwigTemplate_65b59b62da4ced6de0e1aa571a9cb3f4->doDisplay (line 393)
9	Twig\Template->yield (line 349)
10	Twig\Template->display (line 364)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 306)
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 116)
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)

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\Entity\User\Name	No errors.
App\Model\Entity\User\Location	No errors.
App\Model\Entity\User\User	No errors.
App\Model\Entity\Support\Support	No errors.

Symfony Profiler

GET https://eclectis.eu/contact

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping