Symfony Profiler

Query Metrics

12 Database Queries

9 Different statements

9.18 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.36 ms
(25.71%)

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 p.published = ? ORDER BY p.priority, date desc LIMIT 10

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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
  p.published = ?
ORDER BY
  p.priority,
  date desc
LIMIT
  10

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 p.published = 1 ORDER BY p.priority, date desc LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 47)
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	ContainerJ9VITRS\PaginatorProxyBa079e5->paginate (line 378)
10	App\ReadModel\Blog\BlogFetcher->allPosts (line 163)
11	App\Controller\BlogController->posts (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)

1.16 ms
(12.62%)

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_1b3e1a98421cefddf53692438d0ed3b8->doDisplay (line 402)
6	Twig\Template->yield (line 142)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_6f990b41a5b59948bb65eec7c090af71->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 170)
18	App\Controller\BlogController->posts (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.11 ms
(12.11%)

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 p.published = ?) tmp

Parameters:

[
  1
]

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
      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 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	ContainerJ9VITRS\PaginatorProxyBa079e5->paginate (line 378)
10	App\ReadModel\Blog\BlogFetcher->allPosts (line 163)
11	App\Controller\BlogController->posts (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)

1.09 ms
(11.84%)

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_6f990b41a5b59948bb65eec7c090af71->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_6f990b41a5b59948bb65eec7c090af71->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 170)
18	App\Controller\BlogController->posts (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.93 ms
(10.14%)

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_6f990b41a5b59948bb65eec7c090af71->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_6f990b41a5b59948bb65eec7c090af71->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 170)
18	App\Controller\BlogController->posts (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.69 ms
(7.53%)

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_6f990b41a5b59948bb65eec7c090af71->block_body (line 446)
7	Twig\Template->yieldBlock (line 269)
8	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
9	Twig\Template->yield (line 132)
10	__TwigTemplate_6f990b41a5b59948bb65eec7c090af71->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 170)
19	App\Controller\BlogController->posts (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.67 ms
(7.32%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	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_6f990b41a5b59948bb65eec7c090af71->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_6f990b41a5b59948bb65eec7c090af71->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 170)
18	App\Controller\BlogController->posts (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.62 ms
(6.71%)

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_d7566e37cbeddc508e301d779aa5e681->doDisplay (line 402)
7	Twig\Template->yield (line 283)
8	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
9	Twig\Template->yield (line 132)
10	__TwigTemplate_6f990b41a5b59948bb65eec7c090af71->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 170)
19	App\Controller\BlogController->posts (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
(6.03%)

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_6f990b41a5b59948bb65eec7c090af71->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 132)
9	__TwigTemplate_6f990b41a5b59948bb65eec7c090af71->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 170)
18	App\Controller\BlogController->posts (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)

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

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.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping