Symfony Profiler

Query Metrics

13 Database Queries

10 Different statements

22.48 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.46 ms
(64.34%)

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 156)
9	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->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)

1.54 ms
(6.87%)

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

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

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;

#	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 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)

1.34 ms
(5.98%)

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	ContainerJ9VITRS\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)

1.07 ms
(4.77%)

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 517)
5	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->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.90 ms
(3.99%)

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 517)
5	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->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.73 ms
(3.25%)

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

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
  6

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

#	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 517)
6	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->block_body (line 446)
7	Twig\Template->yieldBlock (line 269)
8	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
9	Twig\Template->yield (line 156)
10	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->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.68 ms
(3.02%)

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 589)
5	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->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.66 ms
(2.94%)

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 484)
5	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->block_body (line 446)
6	Twig\Template->yieldBlock (line 269)
7	__TwigTemplate_07bde74b07c4b95f976f7c26354efdf1->doDisplay (line 402)
8	Twig\Template->yield (line 156)
9	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->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.61 ms
(2.72%)

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 156)
10	__TwigTemplate_88ac5f5749490e42ab389b32b96f7bc2->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.48 ms
(2.12%)

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(87, 82, 79, 78, 77, 75, 73, 71, 65);

#	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/users

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping