Symfony Profiler

Query Metrics

13 Database Queries

7 Different statements

5.66 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.10 ms
(37.17%)

SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = ? LIMIT 1

Parameters:

[
  "system"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.designation AS designation_3,
  t0.app AS app_4,
  t0.email AS email_5,
  t0.log AS log_6,
  t0.oauth AS oauth_7,
  t0.register AS register_8,
  t0.design AS design_9
FROM
  system_settings t0
WHERE
  t0.designation = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.version AS version_2, t0.designation AS designation_3, t0.app AS app_4, t0.email AS email_5, t0.log AS log_6, t0.oauth AS oauth_7, t0.register AS register_8, t0.design AS design_9 FROM system_settings t0 WHERE t0.designation = 'system' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 40)
4	App\Service\ScssCompiler->__construct (line 31)
5	ContainerPUDdm6V\getPublicControllerService::do (line 837)
6	ContainerPUDdm6V\App_KernelDevDebugContainer->load (line 229)
7	Symfony\Component\DependencyInjection\Container::make (line 211)
8	Symfony\Component\DependencyInjection\Container->get (line 40)
9	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
10	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
11	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
12	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
13	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 22)

0.70 ms
(12.38%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DATABASE()

SELECT DATABASE();

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 622)
2	Doctrine\DBAL\Connection->fetchOne (line 262)
3	Doctrine\DBAL\Connection->getDatabase (line 445)
4	App\AppHelper\EmHelper->system_is_installed (line 39)
5	App\Service\ScssCompiler->__construct (line 31)
6	ContainerPUDdm6V\getPublicControllerService::do (line 837)
7	ContainerPUDdm6V\App_KernelDevDebugContainer->load (line 229)
8	Symfony\Component\DependencyInjection\Container::make (line 211)
9	Symfony\Component\DependencyInjection\Container->get (line 40)
10	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
11	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
12	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
14	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 22)

0.65 ms
(11.51%)

SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.is_verified AS is_verified_5, u0_.totp_secret AS totp_secret_6 FROM user u0_ WHERE JSON_CONTAINS(u0_.roles, ?) = 1

Parameters:

[
  ""ROLE_SUPER_ADMIN""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.uuid AS uuid_1,
  u0_.email AS email_2,
  u0_.roles AS roles_3,
  u0_.password AS password_4,
  u0_.is_verified AS is_verified_5,
  u0_.totp_secret AS totp_secret_6
FROM
  user u0_
WHERE
  JSON_CONTAINS(u0_.roles, ?) = 1

SELECT u0_.id AS id_0, u0_.uuid AS uuid_1, u0_.email AS email_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.is_verified AS is_verified_5, u0_.totp_secret AS totp_secret_6 FROM user u0_ WHERE JSON_CONTAINS(u0_.roles, '\"ROLE_SUPER_ADMIN\"') = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 54)
7	App\Repository\UserRepository->findByRole (line 114)
8	App\Twig\AppExtension->systemIsInstalled (line 80)
9	__TwigTemplate_568f17edbf63e65202f80ea94abe85ed->doDisplay (line 360)
10	Twig\Template->yield (line 335)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 1332)
13	Twig\Extension\CoreExtension::include (line 99)
14	__TwigTemplate_8d7322ae96bc351049cc1254df902b6e->block_navbar (line 430)
15	Twig\Template->yieldBlock (line 121)
16	__TwigTemplate_1f900ea644f52db102a2146415527df6->doDisplay (line 360)
17	Twig\Template->yield (line 52)
18	__TwigTemplate_8d7322ae96bc351049cc1254df902b6e->doDisplay (line 360)
19	Twig\Template->yield (line 335)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 307)
22	Twig\Environment->render (line 448)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 424)
26	App\Controller\PublicController->public_post_site (line 181)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 22)

0.61 ms
(10.74%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.position AS position_5, t0.active AS active_6, t0.type AS type_7, t0.menu_settings AS menu_settings_8 FROM menu_category t0 WHERE t0.type = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "main"
  true
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.position AS position_5,
  t0.active AS active_6,
  t0.type AS type_7,
  t0.menu_settings AS menu_settings_8
FROM
  menu_category t0
WHERE
  t0.type = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.title AS title_3, t0.description AS description_4, t0.position AS position_5, t0.active AS active_6, t0.type AS type_7, t0.menu_settings AS menu_settings_8 FROM menu_category t0 WHERE t0.type = 'main' AND t0.active = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 26)
4	App\AppHelper\NavHelper->get_navigation (line 125)
5	App\Twig\AppExtension->getAppNavigation (line 82)
6	__TwigTemplate_568f17edbf63e65202f80ea94abe85ed->doDisplay (line 360)
7	Twig\Template->yield (line 335)
8	Twig\Template->render (line 38)
9	Twig\TemplateWrapper->render (line 1332)
10	Twig\Extension\CoreExtension::include (line 99)
11	__TwigTemplate_8d7322ae96bc351049cc1254df902b6e->block_navbar (line 430)
12	Twig\Template->yieldBlock (line 121)
13	__TwigTemplate_1f900ea644f52db102a2146415527df6->doDisplay (line 360)
14	Twig\Template->yield (line 52)
15	__TwigTemplate_8d7322ae96bc351049cc1254df902b6e->doDisplay (line 360)
16	Twig\Template->yield (line 335)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 307)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 424)
23	App\Controller\PublicController->public_post_site (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 22)

0.59 ms
(10.35%)

SELECT app FROM system_settings WHERE designation = ?

Parameters:

[
  "system"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  app
FROM
  system_settings
WHERE
  designation = ?

SELECT app FROM system_settings WHERE designation = 'system';

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 224)
2	Doctrine\DBAL\Statement->executeQuery (line 454)
3	App\AppHelper\EmHelper->system_is_installed (line 39)
4	App\Service\ScssCompiler->__construct (line 31)
5	ContainerPUDdm6V\getPublicControllerService::do (line 837)
6	ContainerPUDdm6V\App_KernelDevDebugContainer->load (line 229)
7	Symfony\Component\DependencyInjection\Container::make (line 211)
8	Symfony\Component\DependencyInjection\Container->get (line 40)
9	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
10	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
11	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
12	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
13	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 22)

0.54 ms
(9.55%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.category_design AS category_design_8, t0.post_design AS post_design_9, t0.post_loop AS post_loop_10, t0.category_header AS category_header_11, t0.category_footer AS category_footer_12, t0.post_header AS post_header_13, t0.post_footer AS post_footer_14, t0.created_at AS created_at_15 FROM post_category t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "general"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.position AS position_4,
  t0.type AS type_5,
  t0.cat_img AS cat_img_6,
  t0.slug AS slug_7,
  t0.category_design AS category_design_8,
  t0.post_design AS post_design_9,
  t0.post_loop AS post_loop_10,
  t0.category_header AS category_header_11,
  t0.category_footer AS category_footer_12,
  t0.post_header AS post_header_13,
  t0.post_footer AS post_footer_14,
  t0.created_at AS created_at_15
FROM
  post_category t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.category_design AS category_design_8, t0.post_design AS post_design_9, t0.post_loop AS post_loop_10, t0.category_header AS category_header_11, t0.category_footer AS category_footer_12, t0.post_header AS post_header_13, t0.post_footer AS post_footer_14, t0.created_at AS created_at_15 FROM post_category t0 WHERE t0.slug = 'general' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 418)
4	App\Controller\PublicController->public_post_site (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 22)

0.47 ms
(8.30%)

SELECT t0.id AS id_1, t0.post_content AS post_content_2, t0.post_date AS post_date_3, t0.post_excerpt AS post_excerpt_4, t0.comment_status AS comment_status_5, t0.site_type AS site_type_6, t0.site_img AS site_img_7, t0.excerpt_limit AS excerpt_limit_8, t0.extra_css AS extra_css_9, t0.position AS position_10, t0.post_status AS post_status_11, t0.builder AS builder_12, t0.post_slug AS post_slug_13, t0.header AS header_14, t0.footer AS footer_15, t0.post_gallery AS post_gallery_16, t0.siteSeo AS siteSeo_17, t0.post_category_id AS post_category_id_18 FROM post_sites t0 WHERE t0.post_slug = ? AND t0.post_status = ? LIMIT 1

Parameters:

[
  "article-12025-11-18T10:47:35+01:00monthly"
  "publish"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.post_content AS post_content_2,
  t0.post_date AS post_date_3,
  t0.post_excerpt AS post_excerpt_4,
  t0.comment_status AS comment_status_5,
  t0.site_type AS site_type_6,
  t0.site_img AS site_img_7,
  t0.excerpt_limit AS excerpt_limit_8,
  t0.extra_css AS extra_css_9,
  t0.position AS position_10,
  t0.post_status AS post_status_11,
  t0.builder AS builder_12,
  t0.post_slug AS post_slug_13,
  t0.header AS header_14,
  t0.footer AS footer_15,
  t0.post_gallery AS post_gallery_16,
  t0.siteSeo AS siteSeo_17,
  t0.post_category_id AS post_category_id_18
FROM
  post_sites t0
WHERE
  t0.post_slug = ?
  AND t0.post_status = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.post_content AS post_content_2, t0.post_date AS post_date_3, t0.post_excerpt AS post_excerpt_4, t0.comment_status AS comment_status_5, t0.site_type AS site_type_6, t0.site_img AS site_img_7, t0.excerpt_limit AS excerpt_limit_8, t0.extra_css AS extra_css_9, t0.position AS position_10, t0.post_status AS post_status_11, t0.builder AS builder_12, t0.post_slug AS post_slug_13, t0.header AS header_14, t0.footer AS footer_15, t0.post_gallery AS post_gallery_16, t0.siteSeo AS siteSeo_17, t0.post_category_id AS post_category_id_18 FROM post_sites t0 WHERE t0.post_slug = 'article-12025-11-18T10:47:35+01:00monthly' AND t0.post_status = 'publish' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 419)
4	App\Controller\PublicController->public_post_site (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 22)

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.

Entities Mapping

Class	Mapping errors
App\Entity\SystemSettings	No errors.
App\Entity\PostCategory	The association App\Entity\PostCategory#postSites refers to the owning side field App\Entity\PostSites#postSites which does not exist.
App\Entity\PostSites	The mappings App\Entity\PostSites#postCategory and App\Entity\PostCategory#postSites are inconsistent with each other.
App\Entity\SiteSeo	No errors.
App\Entity\User	No errors.
App\Entity\OAuth2UserConsent	No errors.
App\Entity\MediaCategory	No errors.
App\Entity\Media	No errors.
App\Entity\MenuCategory	No errors.

Symfony Profiler

GET https://backend.wiecker.eu/general/article-12025-11-18T10:47:35+01:00monthly

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping