Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

4.46 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.74 ms
(16.49%)

SELECT c.id, c.text, c.created_at, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                 ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = ? AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = ? AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.post_id = ?) AND (c.approved = 1) AND (c.reply_to IS NULL) ORDER BY id desc LIMIT 5

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c.id,
  c.text,
  c.created_at,
  (
    SELECT
      COUNT(cl.id)
    FROM
      blog_post_comments_likes cl
    WHERE
      cl.user_id = c.author_id
      AND cl.comment_id = c.id
  ) AS likes_cnt,
  (
    SELECT
      COUNT(cd.id)
    FROM
      blog_post_comments_dislikes cd
    WHERE
      cd.user_id = c.author_id
      AND cd.comment_id = c.id
  ) AS dislikes_cnt,
  (
    SELECT
      COUNT(cl.id)
    FROM
      blog_post_comments_likes cl
    WHERE
      cl.user_id = ?
      AND cl.comment_id = c.id
  ) AS is_current_user_liked,
  (
    SELECT
      COUNT(cd.id)
    FROM
      blog_post_comments_dislikes cd
    WHERE
      cd.user_id = ?
      AND cd.comment_id = c.id
  ) AS is_current_user_disliked,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  u.nickname,
  u.avatar,
  u.photos_dir_num,
  u.fake
FROM
  blog_post_comments c
  INNER JOIN user_users u ON c.author_id = u.id
WHERE
  (c.post_id = ?)
  AND (c.approved = 1)
  AND (c.reply_to IS NULL)
ORDER BY
  id desc
LIMIT
  5

SELECT c.id, c.text, c.created_at, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                 ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = 0 AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = 0 AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.post_id = 1) AND (c.approved = 1) AND (c.reply_to IS NULL) ORDER BY id desc LIMIT 5;

#	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	ContainerQp1U7LP\PaginatorProxyBa079e5->paginate (line 259)
10	App\ReadModel\Blog\CommentFetcher->getComments (line 220)
11	App\Controller\BlogController->post (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.66 ms
(14.69%)

SELECT COUNT(*) FROM (SELECT c.id, c.text, c.created_at, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                 ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = ? AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = ? AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.post_id = ?) AND (c.approved = 1) AND (c.reply_to IS NULL)) tmp

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  (
    SELECT
      c.id,
      c.text,
      c.created_at,
      (
        SELECT
          COUNT(cl.id)
        FROM
          blog_post_comments_likes cl
        WHERE
          cl.user_id = c.author_id
          AND cl.comment_id = c.id
      ) AS likes_cnt,
      (
        SELECT
          COUNT(cd.id)
        FROM
          blog_post_comments_dislikes cd
        WHERE
          cd.user_id = c.author_id
          AND cd.comment_id = c.id
      ) AS dislikes_cnt,
      (
        SELECT
          COUNT(cl.id)
        FROM
          blog_post_comments_likes cl
        WHERE
          cl.user_id = ?
          AND cl.comment_id = c.id
      ) AS is_current_user_liked,
      (
        SELECT
          COUNT(cd.id)
        FROM
          blog_post_comments_dislikes cd
        WHERE
          cd.user_id = ?
          AND cd.comment_id = c.id
      ) AS is_current_user_disliked,
      TRIM(
        CONCAT(u.name_first, ' ', u.name_last)
      ) AS name,
      u.nickname,
      u.avatar,
      u.photos_dir_num,
      u.fake
    FROM
      blog_post_comments c
      INNER JOIN user_users u ON c.author_id = u.id
    WHERE
      (c.post_id = ?)
      AND (c.approved = 1)
      AND (c.reply_to IS NULL)
  ) tmp

SELECT COUNT(*) FROM (SELECT c.id, c.text, c.created_at, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                 ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = 0 AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = 0 AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.post_id = 1) AND (c.approved = 1) AND (c.reply_to IS NULL)) 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	ContainerQp1U7LP\PaginatorProxyBa079e5->paginate (line 259)
10	App\ReadModel\Blog\CommentFetcher->getComments (line 220)
11	App\Controller\BlogController->post (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.62 ms
(13.93%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.title AS title_3, t0.cover AS cover_4, t0.text_ai AS text_ai_5, t0.text AS text_6, t0.url AS url_7, t0.published AS published_8, t0.moderated AS moderated_9, t0.priority AS priority_10, t0.themed_images AS themed_images_11, t0.photos_dir_num AS photos_dir_num_12, t0.parsed_url AS parsed_url_13, t0.add_later AS add_later_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.author_id AS author_id_17, t0.editor_id AS editor_id_18, t0.category_id AS category_id_19 FROM blog_posts t0 WHERE t0.url = ? LIMIT 1

Parameters:

[
  "energy-efficiency-types-of-renewable-energy-their-comparison-and-main-advantages"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.title AS title_3,
  t0.cover AS cover_4,
  t0.text_ai AS text_ai_5,
  t0.text AS text_6,
  t0.url AS url_7,
  t0.published AS published_8,
  t0.moderated AS moderated_9,
  t0.priority AS priority_10,
  t0.themed_images AS themed_images_11,
  t0.photos_dir_num AS photos_dir_num_12,
  t0.parsed_url AS parsed_url_13,
  t0.add_later AS add_later_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.author_id AS author_id_17,
  t0.editor_id AS editor_id_18,
  t0.category_id AS category_id_19
FROM
  blog_posts t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.title AS title_3, t0.cover AS cover_4, t0.text_ai AS text_ai_5, t0.text AS text_6, t0.url AS url_7, t0.published AS published_8, t0.moderated AS moderated_9, t0.priority AS priority_10, t0.themed_images AS themed_images_11, t0.photos_dir_num AS photos_dir_num_12, t0.parsed_url AS parsed_url_13, t0.add_later AS add_later_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.author_id AS author_id_17, t0.editor_id AS editor_id_18, t0.category_id AS category_id_19 FROM blog_posts t0 WHERE t0.url = 'energy-efficiency-types-of-renewable-energy-their-comparison-and-main-advantages' 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)

0.53 ms
(11.92%)

SELECT c.id, c.text, c.created_at, c.reply_to, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = ? AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = ? AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.reply_to IN (?, ?, ?, ?, ?)) AND (c.approved = 1)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c.id,
  c.text,
  c.created_at,
  c.reply_to,
  (
    SELECT
      COUNT(cl.id)
    FROM
      blog_post_comments_likes cl
    WHERE
      cl.user_id = c.author_id
      AND cl.comment_id = c.id
  ) AS likes_cnt,
  (
    SELECT
      COUNT(cd.id)
    FROM
      blog_post_comments_dislikes cd
    WHERE
      cd.user_id = c.author_id
      AND cd.comment_id = c.id
  ) AS dislikes_cnt,
  (
    SELECT
      COUNT(cl.id)
    FROM
      blog_post_comments_likes cl
    WHERE
      cl.user_id = ?
      AND cl.comment_id = c.id
  ) AS is_current_user_liked,
  (
    SELECT
      COUNT(cd.id)
    FROM
      blog_post_comments_dislikes cd
    WHERE
      cd.user_id = ?
      AND cd.comment_id = c.id
  ) AS is_current_user_disliked,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  u.nickname,
  u.avatar,
  u.photos_dir_num,
  u.fake
FROM
  blog_post_comments c
  INNER JOIN user_users u ON c.author_id = u.id
WHERE
  (
    c.reply_to IN (?, ?, ?, ?, ?)
  )
  AND (c.approved = 1)

SELECT c.id, c.text, c.created_at, c.reply_to, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = c.author_id AND cl.comment_id = c.id
                ) AS likes_cnt, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = c.author_id AND cd.comment_id = c.id
                ) AS dislikes_cnt, (
                    SELECT COUNT(cl.id)
                    FROM blog_post_comments_likes cl
                    WHERE cl.user_id = 0 AND cl.comment_id = c.id
                ) AS is_current_user_liked, (
                    SELECT COUNT(cd.id)
                    FROM blog_post_comments_dislikes cd
                    WHERE cd.user_id = 0 AND cd.comment_id = c.id
                ) AS is_current_user_disliked, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.avatar, u.photos_dir_num, u.fake FROM blog_post_comments c INNER JOIN user_users u ON c.author_id = u.id WHERE (c.reply_to IN (43, 39, 35, 24, 22)) AND (c.approved = 1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 319)
3	App\ReadModel\Blog\CommentFetcher->getReplyComments (line 262)
4	App\ReadModel\Blog\CommentFetcher->getComments (line 220)
5	App\Controller\BlogController->post (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.39 ms
(8.81%)

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 447)
3	App\ReadModel\Blog\BlogFetcher->getPostsAuthorsForLinks (line 28)
4	App\Widget\Blog\AuthorsMenuLiListWidget->authors (line 69)
5	__TwigTemplate_df61667987b52dd59310d6245c0f135b->doDisplay (line 402)
6	Twig\Template->yield (line 153)
7	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
8	Twig\Template->yield (line 111)
9	__TwigTemplate_3449f4d8261bf30ffad18e02a3a7f57a->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 243)
18	App\Controller\BlogController->post (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.36 ms
(8.11%)

SELECT COUNT(id) FROM blog_post_comments WHERE (post_id = ?) AND (approved = 1)

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_comments
WHERE
  (post_id = ?)
  AND (approved = 1)

SELECT COUNT(id) FROM blog_post_comments WHERE (post_id = 1) AND (approved = 1);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 197)
3	App\ReadModel\Blog\CommentFetcher->getCountForPost (line 252)
4	App\Controller\BlogController->post (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.36 ms
(8.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.avatar AS avatar_4, t0.bio AS bio_5, t0.facebook AS facebook_6, t0.twitter AS twitter_7, t0.linkedin AS linkedin_8, t0.instagram AS instagram_9, t0.pinterest AS pinterest_10 FROM blog_authors t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.avatar AS avatar_4,
  t0.bio AS bio_5,
  t0.facebook AS facebook_6,
  t0.twitter AS twitter_7,
  t0.linkedin AS linkedin_8,
  t0.instagram AS instagram_9,
  t0.pinterest AS pinterest_10
FROM
  blog_authors t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.avatar AS avatar_4, t0.bio AS bio_5, t0.facebook AS facebook_6, t0.twitter AS twitter_7, t0.linkedin AS linkedin_8, t0.instagram AS instagram_9, t0.pinterest AS pinterest_10 FROM blog_authors t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 281)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():280} (line 359)
5	Proxies\__CG__\App\Model\Blog\Entity\Author\Author::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():357}:358} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Model\Blog\Entity\Author\Author->__get (line 90)
8	App\Model\Blog\Entity\Author\Author->getName (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 174)
10	__TwigTemplate_3449f4d8261bf30ffad18e02a3a7f57a->block_description (line 446)
11	Twig\Template->yieldBlock (line 71)
12	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
13	Twig\Template->yield (line 111)
14	__TwigTemplate_3449f4d8261bf30ffad18e02a3a7f57a->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 243)
23	App\Controller\BlogController->post (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.36 ms
(7.97%)

SELECT COUNT(id) FROM blog_post_likes WHERE post_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_likes
WHERE
  post_id = ?

SELECT COUNT(id) FROM blog_post_likes WHERE post_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 733)
3	App\ReadModel\Blog\BlogFetcher->likesCnt (line 216)
4	App\Controller\BlogController->post (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.23 ms
(5.24%)

SELECT COUNT(id) FROM blog_post_dislikes WHERE post_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_dislikes
WHERE
  post_id = ?

SELECT COUNT(id) FROM blog_post_dislikes WHERE post_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 744)
3	App\ReadModel\Blog\BlogFetcher->dislikesCnt (line 217)
4	App\Controller\BlogController->post (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.21 ms
(4.77%)

SELECT COUNT(id) FROM blog_post_favorites WHERE post_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_favorites
WHERE
  post_id = ?

SELECT COUNT(id) FROM blog_post_favorites WHERE post_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 722)
3	App\ReadModel\Blog\BlogFetcher->favoritesCnt (line 218)
4	App\Controller\BlogController->post (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)

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\Author\Author	2
App\Model\Blog\Entity\Post\Post	1
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\Author\Author	No errors.
App\Model\Blog\Entity\Category\Category	No errors.
App\Model\Blog\Entity\Tag\Tag	No errors.
App\Model\Blog\Entity\Post\Image	No errors.

Symfony Profiler

GET https://eclectis.eu/blog/post/energy-efficiency-types-of-renewable-energy-their-comparison-and-main-advantages

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping