Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

4.70 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.48 ms
(31.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.02 ms
(21.69%)

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.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  178
]

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.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.id = 178 AND ((t0.deleted_at IS NULL));

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 797)
3	Doctrine\ORM\EntityManager->find (line 530)
4	Doctrine\ORM\EntityRepository->find (line 196)
5	App\Controller\Content\IndexController->page_rate (line 400)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.65 ms
(13.79%)

INSERT INTO settings_content_page_rating (created_at, updated_at, rating, deleted_at, page_id) VALUES (?, ?, ?, ?, ?)

Parameters:

[
  "2026-06-10 15:36:09"
  "2026-06-10 15:36:09"
  "good"
  null
  178
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO settings_content_page_rating (
  created_at, updated_at, rating, deleted_at,
  page_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO settings_content_page_rating (created_at, updated_at, rating, deleted_at, page_id) VALUES ('2026-06-10 15:36:09', '2026-06-10 15:36:09', 'good', NULL, 178);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 288)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1191)
4	Doctrine\ORM\UnitOfWork->commit (line 451)
5	Doctrine\ORM\EntityManager->flush (line 414)
6	App\Controller\Content\IndexController->page_rate (line 407)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.51 ms
(10.76%)

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.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  11
]

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.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.id = 11 AND ((t0.deleted_at IS NULL));

#	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\Content\Category::{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\Content\Category->__get (line 153)
7	App\Entity\Content\Category->getSlug (line 196)
8	App\Controller\Content\IndexController->page_rate (line 413)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.46 ms
(9.86%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 480)
3	Doctrine\ORM\EntityManager->flush (line 414)
4	App\Controller\Content\IndexController->page_rate (line 407)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.42 ms
(9.02%)

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.id = ? AND ((t0.deleted_at IS NULL))

Parameters:

[
  56
]

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.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

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.id = 56 AND ((t0.deleted_at IS NULL));

#	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\Content\Group::{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\Content\Group->__get (line 153)
7	App\Entity\Content\Group->getCategory (line 99)
8	App\Controller\Content\IndexController->page_rate (line 413)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.16 ms
(3.36%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 430)
2	Doctrine\ORM\EntityManager->flush (line 414)
3	App\Controller\Content\IndexController->page_rate (line 407)
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)

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\Client\Client	1
App\Entity\Client\Layout	1
App\Entity\Content\Page	1
App\Entity\Content\Group	1
App\Entity\Content\PageRating	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\Page	No errors.
App\Entity\Content\Group	No errors.
App\Entity\Content\PageRating	No errors.

Symfony Profiler

GET https://hilfe.patientify.io/de/rate/178?rating=good

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping