Symfony Profiler

Query Metrics

10 Database Queries

5 Different statements

10.66 ms Query time

0 Invalid entities

20 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.64 ms
(43.52%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.teaser AS teaser_6, t0.icon AS icon_7, t0.content AS content_8, t0.priority AS priority_9, t0.visible AS visible_10, t0.seo_keywords AS seo_keywords_11, t0.seo_meta_description AS seo_meta_description_12, t0.page_view_counter AS page_view_counter_13, t0.deleted_at AS deleted_at_14, t0.group_id AS group_id_15 FROM settings_content_page t0 WHERE t0.group_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.priority ASC

Parameters:

[
  50
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.teaser AS teaser_6,
  t0.icon AS icon_7,
  t0.content AS content_8,
  t0.priority AS priority_9,
  t0.visible AS visible_10,
  t0.seo_keywords AS seo_keywords_11,
  t0.seo_meta_description AS seo_meta_description_12,
  t0.page_view_counter AS page_view_counter_13,
  t0.deleted_at AS deleted_at_14,
  t0.group_id AS group_id_15
FROM
  settings_content_page t0
WHERE
  t0.group_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.teaser AS teaser_6, t0.icon AS icon_7, t0.content AS content_8, t0.priority AS priority_9, t0.visible AS visible_10, t0.seo_keywords AS seo_keywords_11, t0.seo_meta_description AS seo_meta_description_12, t0.page_view_counter AS page_view_counter_13, t0.deleted_at AS deleted_at_14, t0.group_id AS group_id_15 FROM settings_content_page t0 WHERE t0.group_id = 50 AND ((t0.deleted_at IS NULL)) ORDER BY t0.priority ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_1df376b9be7eb5f996e00ae14437b20a->block_body (line 257)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_625f84f7cfdf39e0254fce8d41d94e2f->doDisplay (line 172)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1df376b9be7eb5f996e00ae14437b20a->doDisplay (line 58)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Content\IndexController->page_list (line 274)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

2.51 ms
(23.52%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.company AS company_4, t0.email AS email_5, t0.branch AS branch_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.telephone AS telephone_9, t0.subdomain AS subdomain_10, t0.status AS status_11, t0.layout_id AS layout_id_12 FROM client t0 WHERE t0.subdomain = ? LIMIT 1

Parameters:

[
  "patientify"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.company AS company_4,
  t0.email AS email_5,
  t0.branch AS branch_6,
  t0.first_name AS first_name_7,
  t0.last_name AS last_name_8,
  t0.telephone AS telephone_9,
  t0.subdomain AS subdomain_10,
  t0.status AS status_11,
  t0.layout_id AS layout_id_12
FROM
  client t0
WHERE
  t0.subdomain = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.company AS company_4, t0.email AS email_5, t0.branch AS branch_6, t0.first_name AS first_name_7, t0.last_name AS last_name_8, t0.telephone AS telephone_9, t0.subdomain AS subdomain_10, t0.status AS status_11, t0.layout_id AS layout_id_12 FROM client t0 WHERE t0.subdomain = 'patientify' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\BaseController->__construct (line 56)
4	Container8qbHT77\getIndexController2Service->do (line 25)
5	Container8qbHT77\App_KernelDevDebugContainer::load (line 600)
6	Symfony\Component\DependencyInjection\Container->make (line 221)
7	Symfony\Component\DependencyInjection\Container::get (line 203)
8	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
9	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
10	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
11	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
12	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 32)
18	require_once (line 5)

1.32 ms
(12.40%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.slug = ? AND t0.client_id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1

Parameters:

[
  "automatisierungen-und-benachrichtigungen"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.icon AS icon_6,
  t0.description AS description_7,
  t0.priority AS priority_8,
  t0.visible AS visible_9,
  t0.deleted_at AS deleted_at_10,
  t0.client_id AS client_id_11,
  t0.user_id AS user_id_12
FROM
  settings_content_category t0
WHERE
  t0.slug = ?
  AND t0.client_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.icon AS icon_6, t0.description AS description_7, t0.priority AS priority_8, t0.visible AS visible_9, t0.deleted_at AS deleted_at_10, t0.client_id AS client_id_11, t0.user_id AS user_id_12 FROM settings_content_category t0 WHERE t0.slug = 'automatisierungen-und-benachrichtigungen' AND t0.client_id = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\Content\IndexController->page_list (line 272)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 32)
9	require_once (line 5)

1.27 ms
(11.88%)

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.category_id = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.priority ASC

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.name AS name_5,
  t0.slug AS slug_6,
  t0.deleted_at AS deleted_at_7,
  t0.category_id AS category_id_8
FROM
  settings_content_group t0
WHERE
  t0.category_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.priority ASC

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.name AS name_5, t0.slug AS slug_6, t0.deleted_at AS deleted_at_7, t0.category_id AS category_id_8 FROM settings_content_group t0 WHERE t0.category_id = 10 AND ((t0.deleted_at IS NULL)) ORDER BY t0.priority ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1956)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1897)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 3318)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 706)
5	Doctrine\ORM\PersistentCollection->initialize (line 218)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	__TwigTemplate_1df376b9be7eb5f996e00ae14437b20a->block_body (line 226)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_625f84f7cfdf39e0254fce8d41d94e2f->doDisplay (line 172)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1df376b9be7eb5f996e00ae14437b20a->doDisplay (line 58)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Content\IndexController->page_list (line 274)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	require_once (line 5)

0.93 ms
(8.68%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.logo AS logo_4, t0.logo_footer AS logo_footer_5, t0.favicon AS favicon_6, t0.link_imprint AS link_imprint_7, t0.link_agb AS link_agb_8, t0.seo_main_keywords AS seo_main_keywords_9, t0.seo_main_description AS seo_main_description_10, t0.header_background_color AS header_background_color_11, t0.primary_color AS primary_color_12, t0.dark_mode_default AS dark_mode_default_13, t0.hero_image AS hero_image_14 FROM client_layout t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.logo AS logo_4,
  t0.logo_footer AS logo_footer_5,
  t0.favicon AS favicon_6,
  t0.link_imprint AS link_imprint_7,
  t0.link_agb AS link_agb_8,
  t0.seo_main_keywords AS seo_main_keywords_9,
  t0.seo_main_description AS seo_main_description_10,
  t0.header_background_color AS header_background_color_11,
  t0.primary_color AS primary_color_12,
  t0.dark_mode_default AS dark_mode_default_13,
  t0.hero_image AS hero_image_14
FROM
  client_layout t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.logo AS logo_4, t0.logo_footer AS logo_footer_5, t0.favicon AS favicon_6, t0.link_imprint AS link_imprint_7, t0.link_agb AS link_agb_8, t0.seo_main_keywords AS seo_main_keywords_9, t0.seo_main_description AS seo_main_description_10, t0.header_background_color AS header_background_color_11, t0.primary_color AS primary_color_12, t0.dark_mode_default AS dark_mode_default_13, t0.hero_image AS hero_image_14 FROM client_layout t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():368} (line 369)
4	Proxies\__CG__\App\Entity\Client\Layout::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():477}:478} (line 479)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Client\Layout->__get (line 153)
7	App\Entity\Client\Layout->getPrimaryColor (line 173)
8	Twig\Extension\CoreExtension->getAttribute (line 1919)
9	__TwigTemplate_625f84f7cfdf39e0254fce8d41d94e2f::doDisplay (line 67)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1df376b9be7eb5f996e00ae14437b20a->doDisplay (line 58)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 467)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 284)
20	App\Controller\Content\IndexController->page_list (line 274)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	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\Entity\Content\Page	10
App\Entity\Content\Group	6
App\Entity\Client\Client	1
App\Entity\Client\Layout	1
App\Entity\Content\Category	1
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Client\Client	No errors.
App\Entity\Client\Layout	No errors.
App\Entity\Settings\General	No errors.
App\Entity\User	No errors.
App\Entity\Content\Category	No errors.
App\Entity\Content\Group	No errors.
App\Entity\Content\Page	No errors.
App\Entity\Content\PageRating	No errors.

Symfony Profiler

GET https://hilfe.patientify.io/de/c/automatisierungen-und-benachrichtigungen

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping