Symfony Profiler

Query Metrics

13 Database Queries

10 Different statements

11.51 ms Query time

0 Invalid entities

10 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.66 ms
(23.07%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.pin_code AS pin_code_6,
  t0.full_name AS full_name_7,
  t0.user_profile_id AS user_profile_id_8,
  t0.settings_id AS settings_id_9,
  t10.id AS id_11,
  t10.work AS work_12,
  t10.weekend AS weekend_13,
  t10.vacation_days AS vacation_days_14,
  t10.contract_hours AS contract_hours_15,
  t10.user_id AS user_id_16
FROM
  user t0
  LEFT JOIN settings t10 ON t10.user_id = t0.id

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 53)
6	App\Controller\HomeController->clockRegister (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

1.88 ms
(16.36%)

SELECT t0_.id AS id_0, t0_.start_time AS start_time_1, t0_.end_time AS end_time_2, t0_.date AS date_3, t0_.day_id AS day_id_4, t0_.user_id AS user_id_5 FROM time t0_ INNER JOIN user u1_ ON t0_.user_id = u1_.id WHERE t0_.date = ?

Parameters:

[
  "05-09-2026"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.start_time AS start_time_1,
  t0_.end_time AS end_time_2,
  t0_.date AS date_3,
  t0_.day_id AS day_id_4,
  t0_.user_id AS user_id_5
FROM
  time t0_
  INNER JOIN user u1_ ON t0_.user_id = u1_.id
WHERE
  t0_.date = ?

SELECT t0_.id AS id_0, t0_.start_time AS start_time_1, t0_.end_time AS end_time_2, t0_.date AS date_3, t0_.day_id AS day_id_4, t0_.user_id AS user_id_5 FROM time t0_ INNER JOIN user u1_ ON t0_.user_id = u1_.id WHERE t0_.date = '05-09-2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 64)
6	App\Repository\TimeRepository->registerdUsers (line 59)
7	App\Controller\HomeController->clockRegister (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.61 ms
(14.01%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.settings_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.pin_code AS pin_code_6,
  t0.full_name AS full_name_7,
  t0.user_profile_id AS user_profile_id_8,
  t0.settings_id AS settings_id_9,
  t10.id AS id_11,
  t10.work AS work_12,
  t10.weekend AS weekend_13,
  t10.vacation_days AS vacation_days_14,
  t10.contract_hours AS contract_hours_15,
  t10.user_id AS user_id_16
FROM
  user t0
  LEFT JOIN settings t10 ON t10.user_id = t0.id
WHERE
  t0.settings_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.settings_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 835)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2444)
4	Doctrine\ORM\UnitOfWork->createEntity (line 264)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 438)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 143)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 170)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 942)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
10	Doctrine\ORM\EntityRepository->findBy (line 73)
11	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
12	Doctrine\ORM\EntityRepository->findAll (line 53)
13	App\Controller\HomeController->clockRegister (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

1.50 ms
(13.06%)

SELECT t0_.id AS id_0, t0_.start_time AS start_time_1, t0_.end_time AS end_time_2, t0_.date AS date_3, t0_.day_id AS day_id_4, t0_.user_id AS user_id_5 FROM time t0_ WHERE t0_.user_id = ? AND t0_.date = ?

Parameters:

[
  4
  "05-09-2026"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.start_time AS start_time_1,
  t0_.end_time AS end_time_2,
  t0_.date AS date_3,
  t0_.day_id AS day_id_4,
  t0_.user_id AS user_id_5
FROM
  time t0_
WHERE
  t0_.user_id = ?
  AND t0_.date = ?

SELECT t0_.id AS id_0, t0_.start_time AS start_time_1, t0_.end_time AS end_time_2, t0_.date AS date_3, t0_.day_id AS day_id_4, t0_.user_id AS user_id_5 FROM time t0_ WHERE t0_.user_id = 4 AND t0_.date = '05-09-2026';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 53)
7	App\Repository\TimeRepository->findOneByUserDate (line 34)
8	App\Models\RegisterTime->__construct (line 54)
9	App\Controller\HomeController->clockRegister (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.98 ms
(8.49%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 431)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 101)
5	App\Models\RegisterTime->registerDay (line 55)
6	App\Controller\HomeController->clockRegister (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.87 ms
(7.56%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.street AS street_4, t0.house_number AS house_number_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.phone_number AS phone_number_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.password AS password_13, t9.is_verified AS is_verified_14, t9.pin_code AS pin_code_15, t9.full_name AS full_name_16, t9.user_profile_id AS user_profile_id_17, t9.settings_id AS settings_id_18 FROM user_profile t0 LEFT JOIN user t9 ON t9.user_profile_id = t0.id WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.street AS street_4,
  t0.house_number AS house_number_5,
  t0.zip_code AS zip_code_6,
  t0.city AS city_7,
  t0.phone_number AS phone_number_8,
  t9.id AS id_10,
  t9.email AS email_11,
  t9.roles AS roles_12,
  t9.password AS password_13,
  t9.is_verified AS is_verified_14,
  t9.pin_code AS pin_code_15,
  t9.full_name AS full_name_16,
  t9.user_profile_id AS user_profile_id_17,
  t9.settings_id AS settings_id_18
FROM
  user_profile t0
  LEFT JOIN user t9 ON t9.user_profile_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.street AS street_4, t0.house_number AS house_number_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.phone_number AS phone_number_8, t9.id AS id_10, t9.email AS email_11, t9.roles AS roles_12, t9.password AS password_13, t9.is_verified AS is_verified_14, t9.pin_code AS pin_code_15, t9.full_name AS full_name_16, t9.user_profile_id AS user_profile_id_17, t9.settings_id AS settings_id_18 FROM user_profile t0 LEFT JOIN user t9 ON t9.user_profile_id = t0.id WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\UserProfile::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\UserProfile->__get (line 47)
8	App\Entity\UserProfile->getFirstName (line 102)
9	App\Models\RegisterTime->registerDay (line 55)
10	App\Controller\HomeController->clockRegister (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.73 ms
(6.32%)

UPDATE time SET end_time = ? WHERE id = ?

Parameters:

[
  "15:15:54"
  347
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  time
SET
  end_time = ?
WHERE
  id = ?

UPDATE time SET end_time = '15:15:54' WHERE id = 347;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1130)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 406)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 101)
7	App\Models\RegisterTime->registerDay (line 55)
8	App\Controller\HomeController->clockRegister (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.60 ms
(5.20%)

SELECT s0_.id AS id_0, s0_.work AS work_1, s0_.weekend AS weekend_2, s0_.vacation_days AS vacation_days_3, s0_.contract_hours AS contract_hours_4, s0_.user_id AS user_id_5 FROM settings s0_ WHERE s0_.user_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.work AS work_1,
  s0_.weekend AS weekend_2,
  s0_.vacation_days AS vacation_days_3,
  s0_.contract_hours AS contract_hours_4,
  s0_.user_id AS user_id_5
FROM
  settings s0_
WHERE
  s0_.user_id = ?

SELECT s0_.id AS id_0, s0_.work AS work_1, s0_.weekend AS weekend_2, s0_.vacation_days AS vacation_days_3, s0_.contract_hours AS contract_hours_4, s0_.user_id AS user_id_5 FROM settings s0_ WHERE s0_.user_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 25)
7	App\Repository\SettingsRepository->findOneByUser (line 35)
8	App\Models\RegisterTime->__construct (line 54)
9	App\Controller\HomeController->clockRegister (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.39 ms
(3.40%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.pin_code = ? LIMIT 1

Parameters:

[
  "550605510735"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.pin_code AS pin_code_6,
  t0.full_name AS full_name_7,
  t0.user_profile_id AS user_profile_id_8,
  t0.settings_id AS settings_id_9,
  t10.id AS id_11,
  t10.work AS work_12,
  t10.weekend AS weekend_13,
  t10.vacation_days AS vacation_days_14,
  t10.contract_hours AS contract_hours_15,
  t10.user_id AS user_id_16
FROM
  user t0
  LEFT JOIN settings t10 ON t10.user_id = t0.id
WHERE
  t0.pin_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.pin_code AS pin_code_6, t0.full_name AS full_name_7, t0.user_profile_id AS user_profile_id_8, t0.settings_id AS settings_id_9, t10.id AS id_11, t10.work AS work_12, t10.weekend AS weekend_13, t10.vacation_days AS vacation_days_14, t10.contract_hours AS contract_hours_15, t10.user_id AS user_id_16 FROM user t0 LEFT JOIN settings t10 ON t10.user_id = t0.id WHERE t0.pin_code = '550605510735' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 28)
5	App\Models\RegisterTime->__construct (line 54)
6	App\Controller\HomeController->clockRegister (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.29 ms
(2.52%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 380)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 101)
4	App\Models\RegisterTime->registerDay (line 55)
5	App\Controller\HomeController->clockRegister (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
App\Entity\User	3
App\Entity\UserProfile	3
App\Entity\Settings	3
App\Entity\Time	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserProfile	No errors.
App\Entity\Settings	No errors.
App\Entity\Time	No errors.
App\Entity\Sick	No errors.
App\Entity\Vacation	No errors.
App\Entity\DayType	No errors.

Symfony Profiler

GET https://time.elan-bikestore.com/clock/550605510735

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping