Symfony Profiler

Query Metrics

19 Database Queries

10 Different statements

10.80 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.23 ms
(11.42%)

SELECT COUNT(id) FROM site_support_requests WHERE resolved = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  site_support_requests
WHERE
  resolved = 0

SELECT COUNT(id) FROM site_support_requests WHERE resolved = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 72)
3	App\ReadModel\Site\SupportFetcher->getPendingCount (line 29)
4	App\Widget\Site\SupportPendingCountWidget->count (line 85)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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.16 ms
(10.75%)

SELECT COUNT(id) FROM user_login_history WHERE viewed = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  user_login_history
WHERE
  viewed = 0

SELECT COUNT(id) FROM user_login_history WHERE viewed = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 812)
3	App\ReadModel\User\UserFetcher->getPendingLoginsNotViewedCount (line 29)
4	App\Widget\User\UsersLoginsPendingViewCountWidget->count (line 167)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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.14 ms
(10.54%)

SELECT COUNT(id) FROM blog_post_comments WHERE approved = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_comments
WHERE
  approved = 0

SELECT COUNT(id) FROM blog_post_comments WHERE approved = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 179)
3	App\ReadModel\Blog\CommentFetcher->getPendingCount (line 29)
4	App\Widget\Blog\CountWidget->count (line 227)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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.13 ms
(10.44%)

SELECT COUNT(id) FROM site_testimonials WHERE approved = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  site_testimonials
WHERE
  approved = 0

SELECT COUNT(id) FROM site_testimonials WHERE approved = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 126)
3	App\ReadModel\Site\TestimonialFetcher->getPendingCount (line 29)
4	App\Widget\Site\TestimonialsPendingCountWidget->count (line 99)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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.13 ms
(10.43%)

SELECT COUNT(id) FROM user_users WHERE viewed = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  user_users
WHERE
  viewed = 0

SELECT COUNT(id) FROM user_users WHERE viewed = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 794)
3	App\ReadModel\User\UserFetcher->getPendingNotViewedCount (line 29)
4	App\Widget\User\UsersPendingViewCountWidget->count (line 142)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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.12 ms
(10.38%)

SELECT COUNT(id) FROM blog_post_search_queries WHERE viewed = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_search_queries
WHERE
  viewed = 0

SELECT COUNT(id) FROM blog_post_search_queries WHERE viewed = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 1147)
3	App\ReadModel\Blog\BlogFetcher->getPendingSearchQueriesNotViewedCount (line 29)
4	App\Widget\Blog\SearchQueriesPendingCountWidget->count (line 243)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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
(10.27%)

SELECT COUNT(id) FROM blog_post_favorites WHERE viewed = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_favorites
WHERE
  viewed = 0

SELECT COUNT(id) FROM blog_post_favorites WHERE viewed = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 1192)
3	App\ReadModel\Blog\BlogFetcher->getPendingBlogPostsFavoritesNotViewedCount (line 29)
4	App\Widget\Blog\BlogPostsFavoritesPendingCountWidget->count (line 294)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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.10 ms
(10.18%)

SELECT COUNT(id) FROM blog_post_likes WHERE viewed = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_likes
WHERE
  viewed = 0

SELECT COUNT(id) FROM blog_post_likes WHERE viewed = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 1162)
3	App\ReadModel\Blog\BlogFetcher->getPendingBlogPostsLikesNotViewedCount (line 29)
4	App\Widget\Blog\BlogPostsLikesPendingCountWidget->count (line 260)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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.08 ms
(10.03%)

SELECT COUNT(id) FROM blog_post_dislikes WHERE viewed = 0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id)
FROM
  blog_post_dislikes
WHERE
  viewed = 0

SELECT COUNT(id) FROM blog_post_dislikes WHERE viewed = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 1177)
3	App\ReadModel\Blog\BlogFetcher->getPendingBlogPostsDislikesNotViewedCount (line 29)
4	App\Widget\Blog\BlogPostsDislikesPendingCountWidget->count (line 277)
5	__TwigTemplate_3cd8505ca36f2673b871ff835d483cf3->doDisplay (line 402)
6	Twig\Template->yield (line 113)
7	__TwigTemplate_9ff871d02c27667eaf4c78f9d01d03ad->doDisplay (line 402)
8	Twig\Template->yield (line 55)
9	__TwigTemplate_4bf8e07bade66f9bd9a5bf9e34b123a4->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 89)
18	App\Controller\Dashboard\Admin\Blog\PostsController->add (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.60 ms
(5.57%)

SELECT u.id, u.nickname, u.reg_date, u.email, u.photos_dir_num, u.avatar, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.role, u.status, s.dark_theme FROM user_users u INNER JOIN user_networks n ON u.id = n.user_id INNER JOIN user_settings s ON u.id = s.user_id WHERE n.network = ? AND n.identity = ?

Parameters:

[
  "tiktok"
  "7025d781-d722-508c-8b95-c0bf19ba3533"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u.id,
  u.nickname,
  u.reg_date,
  u.email,
  u.photos_dir_num,
  u.avatar,
  TRIM(
    CONCAT(u.name_first, ' ', u.name_last)
  ) AS name,
  u.role,
  u.status,
  s.dark_theme
FROM
  user_users u
  INNER JOIN user_networks n ON u.id = n.user_id
  INNER JOIN user_settings s ON u.id = s.user_id
WHERE
  n.network = ?
  AND n.identity = ?

SELECT u.id, u.nickname, u.reg_date, u.email, u.photos_dir_num, u.avatar, TRIM(CONCAT(u.name_first, ' ', u.name_last)) AS name, u.role, u.status, s.dark_theme FROM user_users u INNER JOIN user_networks n ON u.id = n.user_id INNER JOIN user_settings s ON u.id = s.user_id WHERE n.network = 'tiktok' AND n.identity = '7025d781-d722-508c-8b95-c0bf19ba3533';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 344)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 111)
3	App\ReadModel\User\UserFetcher->findForAuthByNetwork (line 47)
4	App\Security\UserProvider->loadUser (line 33)
5	App\Security\UserProvider->refreshUser (line 212)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 61)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	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.
App\Model\Blog\Entity\Category\Category	No errors.
App\Model\Blog\Entity\Author\Author	No errors.

Symfony Profiler

GET https://eclectis.eu/dashboard/adminka/blog/add/empty/posts

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping