Symfony Profiler

Query Metrics

5 Database Queries

3 Different statements

3.77 ms Query time

0 Invalid entities

11 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.84 ms
(48.79%)

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 27)
6	App\Controller\HomeController->index (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.26 ms
(33.46%)

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 27)
13	App\Controller\HomeController->index (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)

0.67 ms
(17.75%)

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-06-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-06-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 41)
7	App\Controller\HomeController->index (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)

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	2

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://www.time.elan-bikestore.com/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping