Symfony Profiler

Query Metrics

12 Database Queries

9 Different statements

6.61 ms Query time

0 Invalid entities

1 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.10 ms
(16.63%)

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 442)
3	App\ReadModel\Blog\BlogFetcher->getPostsAuthorsForLinks (line 28)
4	App\Widget\Blog\AuthorsMenuLiListWidget->authors (line 69)
5	__TwigTemplate_03d5f7292676084943d83f47b5a931e1->doDisplay (line 402)
6	Twig\Template->yield (line 142)
7	__TwigTemplate_6f38e72a13087c1a98f973cfb89c9edf->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
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 142)
18	App\Controller\BlogController->blogPostsByCategory (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)

1.05 ms
(15.89%)

SELECT COUNT(`id`) FROM `blog_posts_published_ids`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(`id`)
FROM
  `blog_posts_published_ids`

SELECT COUNT(`id`) FROM `blog_posts_published_ids`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 799)
2	App\ReadModel\Blog\BlogFetcher->getRandomPostsIds (line 917)
3	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
4	App\Widget\Blog\RandomPostsWidget->random_posts (line 550)
5	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_6f38e72a13087c1a98f973cfb89c9edf->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
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 142)
18	App\Controller\BlogController->blogPostsByCategory (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.87 ms
(13.15%)

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 AND m.approved = 1) 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(NULL)

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
      AND m.approved = 1
  ) 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(NULL)

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 AND m.approved = 1) 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(NULL);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 936)
3	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
4	App\Widget\Blog\RandomPostsWidget->random_posts (line 550)
5	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_6f38e72a13087c1a98f973cfb89c9edf->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
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 142)
18	App\Controller\BlogController->blogPostsByCategory (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.72 ms
(10.94%)

SELECT COUNT(*) FROM (SELECT p.id, p.title, p.cover, p.text, p.url, p.published, p.date, c.id AS category_id, c.name AS category_name, a.url AS author_url, a.name AS author_name, a.avatar AS author_avatar, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_count FROM blog_posts p INNER JOIN blog_categories c ON p.category_id = c.id INNER JOIN blog_authors a ON p.author_id = a.id WHERE (c.id = ?) AND (p.published = ?)) tmp

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  (
    SELECT
      p.id,
      p.title,
      p.cover,
      p.text,
      p.url,
      p.published,
      p.date,
      c.id AS category_id,
      c.name AS category_name,
      a.url AS author_url,
      a.name AS author_name,
      a.avatar AS author_avatar,
      (
        SELECT
          COUNT(m.id)
        FROM
          blog_post_comments m
        WHERE
          m.post_id = p.id
          AND m.approved = 1
      ) AS comments_count,
      (
        SELECT
          COUNT(i.id)
        FROM
          blog_post_images i
        WHERE
          i.post_id = p.id
      ) AS images_count
    FROM
      blog_posts p
      INNER JOIN blog_categories c ON p.category_id = c.id
      INNER JOIN blog_authors a ON p.author_id = a.id
    WHERE
      (c.id = ?)
      AND (p.published = ?)
  ) tmp

SELECT COUNT(*) FROM (SELECT p.id, p.title, p.cover, p.text, p.url, p.published, p.date, c.id AS category_id, c.name AS category_name, a.url AS author_url, a.name AS author_name, a.avatar AS author_avatar, (SELECT COUNT(m.id) FROM blog_post_comments m WHERE m.post_id = p.id AND m.approved = 1) AS comments_count, (SELECT COUNT(i.id) FROM blog_post_images i WHERE i.post_id = p.id) AS images_count FROM blog_posts p INNER JOIN blog_categories c ON p.category_id = c.id INNER JOIN blog_authors a ON p.author_id = a.id WHERE (c.id = 33) AND (p.published = 1)) tmp;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 34)
3	Knp\Component\Pager\Event\Subscriber\Paginate\Doctrine\DBALQueryBuilderSubscriber->items (line 115)
4	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
5	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
6	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
7	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 97)
8	Knp\Component\Pager\Paginator->paginate (line 25)
9	ContainerSduqmzb\PaginatorProxyBa079e5->paginate (line 378)
10	App\ReadModel\Blog\BlogFetcher->allPosts (line 136)
11	App\Controller\BlogController->blogPostsByCategory (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.65 ms
(9.90%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 771)
3	App\ReadModel\Blog\BlogFetcher->getTags (line 28)
4	App\Widget\Blog\TagsCloudWidget->tags_cloud (line 622)
5	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_6f38e72a13087c1a98f973cfb89c9edf->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
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 142)
18	App\Controller\BlogController->blogPostsByCategory (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.64 ms
(9.74%)

SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 7

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  blog_posts
WHERE
  (published = 1)
  AND (priority = 1)
ORDER BY
  RAND() ASC
LIMIT
  7

SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 810)
3	App\ReadModel\Blog\BlogFetcher->getRandomPostsIds (line 917)
4	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
5	App\Widget\Blog\RandomPostsWidget->random_posts (line 550)
6	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->block_body (line 446)
7	Twig\Template->yieldBlock (line 269)
8	__TwigTemplate_6f38e72a13087c1a98f973cfb89c9edf->doDisplay (line 402)
9	Twig\Template->yield (line 132)
10	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
19	App\Controller\BlogController->blogPostsByCategory (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.60 ms
(9.12%)

SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  blog_posts
WHERE
  (published = 1)
  AND (priority = 1)
ORDER BY
  RAND() ASC
LIMIT
  2

SELECT id FROM blog_posts WHERE (published = 1) AND (priority = 1) ORDER BY RAND() ASC LIMIT 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 810)
3	App\ReadModel\Blog\BlogFetcher->getRandomPostsIds (line 917)
4	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
5	App\Widget\Blog\RandomPostsWidget->random_posts (line 200)
6	__TwigTemplate_56465054f664d8e1fe7cfbd7d98fbe80->doDisplay (line 402)
7	Twig\Template->yield (line 283)
8	__TwigTemplate_6f38e72a13087c1a98f973cfb89c9edf->doDisplay (line 402)
9	Twig\Template->yield (line 132)
10	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 142)
19	App\Controller\BlogController->blogPostsByCategory (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.55 ms
(8.32%)

SELECT id, name FROM blog_categories

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id,
  name
FROM
  blog_categories

SELECT id, name FROM blog_categories;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 751)
3	App\ReadModel\Blog\BlogFetcher->getCategories (line 28)
4	App\Widget\Blog\BlogCategoriesWidget->blog_categories (line 517)
5	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_6f38e72a13087c1a98f973cfb89c9edf->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_eb767550f108df6434dba1a5f411baf4->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 51)
13	Twig\TemplateWrapper->render (line 333)
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 142)
18	App\Controller\BlogController->blogPostsByCategory (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.42 ms
(6.32%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_categories t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "arroyo"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  blog_categories t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2 FROM blog_categories t0 WHERE t0.name = 'arroyo' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Model\Blog\Entity\Category\Category	1

Entities Mapping

Class	Mapping errors
App\Model\Blog\Entity\Post\Post	No errors.
App\Model\Blog\Entity\Comment\Comment	No errors.
App\Model\Site\Entity\Testimonial\Testimonial	No errors.
App\Model\User\Entity\User\Name	No errors.
App\Model\User\Entity\User\Location	No errors.
App\Model\User\Entity\User\User	No errors.
App\Model\Blog\Entity\Category\Category	No errors.

Symfony Profiler

GET https://eclectis.eu/blog/posts/category/arroyo

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping