Symfony Profiler

Query Metrics

12 Database Queries

10 Different statements

5.47 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.03 ms
(18.89%)

SELECT COUNT(*) FROM (SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id) tmp

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*)
FROM
  (
    SELECT
      u.id,
      TRIM(
        CONCAT(u.name_first, ' ', u.name_last)
      ) AS name,
      u.nickname,
      u.email,
      u.avatar,
      u.reg_date,
      u.role,
      u.status,
      u.fake,
      u.photos_dir_num,
      u.location_ip,
      u.location_country,
      u.location_state,
      u.location_city,
      u.location_country_code,
      s.show_social_links_in_profile,
      (
        SELECT
          COUNT(c.id)
        FROM
          blog_post_comments c
        WHERE
          u.id = c.author_id
      ) AS blog_comments_count
    FROM
      user_users u
      INNER JOIN user_settings s ON u.id = s.user_id
  ) tmp

SELECT COUNT(*) FROM (SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id) 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	ContainerOxxqqqv\PaginatorProxyBa079e5->paginate (line 189)
10	App\ReadModel\User\UserFetcher->allForPublic (line 73)
11	App\Controller\UserController->users (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.80 ms
(14.54%)

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 941)
3	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
4	App\Widget\Blog\RandomPostsWidget->random_posts (line 517)
5	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->block_body (line 446)
6	Twig\Template->yieldBlock (line 311)
7	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->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 80)
18	App\Controller\UserController->users (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.75 ms
(13.76%)

SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id ORDER BY id desc LIMIT 9 OFFSET 18

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u.id,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  u.nickname,
  u.email,
  u.avatar,
  u.reg_date,
  u.role,
  u.status,
  u.fake,
  u.photos_dir_num,
  u.location_ip,
  u.location_country,
  u.location_state,
  u.location_city,
  u.location_country_code,
  s.show_social_links_in_profile,
  (
    SELECT
      COUNT(c.id)
    FROM
      blog_post_comments c
    WHERE
      u.id = c.author_id
  ) AS blog_comments_count
FROM
  user_users u
  INNER JOIN user_settings s ON u.id = s.user_id
ORDER BY
  id desc
LIMIT
  9
OFFSET
  18

SELECT u.id, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.nickname, u.email, u.avatar, u.reg_date, u.role, u.status, u.fake, u.photos_dir_num, u.location_ip, u.location_country, u.location_state, u.location_city, u.location_country_code, s.show_social_links_in_profile, (SELECT COUNT(c.id) FROM blog_post_comments c WHERE u.id = c.author_id) AS blog_comments_count FROM user_users u INNER JOIN user_settings s ON u.id = s.user_id ORDER BY id desc LIMIT 9 OFFSET 18;

#	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	ContainerOxxqqqv\PaginatorProxyBa079e5->paginate (line 189)
10	App\ReadModel\User\UserFetcher->allForPublic (line 73)
11	App\Controller\UserController->users (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
(11.29%)

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 804)
2	App\ReadModel\Blog\BlogFetcher->getRandomPostsIds (line 922)
3	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
4	App\Widget\Blog\RandomPostsWidget->random_posts (line 517)
5	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->block_body (line 446)
6	Twig\Template->yieldBlock (line 311)
7	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->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 80)
18	App\Controller\UserController->users (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.49 ms
(8.88%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 776)
3	App\ReadModel\Blog\BlogFetcher->getTags (line 28)
4	App\Widget\Blog\TagsCloudWidget->tags_cloud (line 589)
5	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->block_body (line 446)
6	Twig\Template->yieldBlock (line 311)
7	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->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 80)
18	App\Controller\UserController->users (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
(7.60%)

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

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
  5

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

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 815)
3	App\ReadModel\Blog\BlogFetcher->getRandomPostsIds (line 922)
4	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
5	App\Widget\Blog\RandomPostsWidget->random_posts (line 517)
6	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->block_body (line 446)
7	Twig\Template->yieldBlock (line 311)
8	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
9	Twig\Template->yield (line 156)
10	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->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 80)
19	App\Controller\UserController->users (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.37 ms
(6.76%)

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 815)
3	App\ReadModel\Blog\BlogFetcher->getRandomPostsIds (line 922)
4	App\ReadModel\Blog\BlogFetcher->getRandomPosts (line 28)
5	App\Widget\Blog\RandomPostsWidget->random_posts (line 200)
6	__TwigTemplate_b52bf3244c4a1be173d42d633e57a1b1->doDisplay (line 402)
7	Twig\Template->yield (line 325)
8	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
9	Twig\Template->yield (line 156)
10	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->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 80)
19	App\Controller\UserController->users (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.34 ms
(6.23%)

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 152)
7	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->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 80)
18	App\Controller\UserController->users (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.34 ms
(6.21%)

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 756)
3	App\ReadModel\Blog\BlogFetcher->getCategories (line 28)
4	App\Widget\Blog\BlogCategoriesWidget->blog_categories (line 484)
5	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->block_body (line 446)
6	Twig\Template->yieldBlock (line 311)
7	__TwigTemplate_acb799625646d03a659ed6fe99da21d6->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_d29407663e908d9c978e8f0459dd5fd5->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 80)
18	App\Controller\UserController->users (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.32 ms
(5.84%)

SELECT user_id, network, identity, nickname FROM user_networks WHERE user_id IN(?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  user_id,
  network,
  identity,
  nickname
FROM
  user_networks
WHERE
  user_id IN(?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT user_id, network, identity, nickname FROM user_networks WHERE user_id IN(25, 24, 23, 22, 21, 20, 19, 18, 17);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 316)
3	App\ReadModel\User\UserFetcher->batchLoadNetworks (line 193)
4	App\ReadModel\User\UserFetcher->allForPublic (line 73)
5	App\Controller\UserController->users (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)

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/index.php/users/page/3

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping