Symfony Profiler

Query Metrics

189 Database Queries

6 Different statements

102.90 ms Query time

3 Invalid entities

525 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

92.11 ms
(89.51%)

176

UPDATE schedule SET debut = ?, fin = ? WHERE id = ?

Parameters:

[
  "2024-10-17 09:00:00"
  "2024-10-17 17:00:00"
  4
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  schedule
SET
  debut = ?,
  fin = ?
WHERE
  id = ?

UPDATE schedule SET debut = '2024-10-17 09:00:00', fin = '2024-10-17 17:00:00' WHERE id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\HomeController->choice_service (line 99)
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 29)
12	require_once (line 5)

3.63 ms
(3.52%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4 FROM service t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4
FROM
  service t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4 FROM service t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\Service::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\Service->__get (line 146)
7	App\Entity\Service->getName (line 61)
8	App\Controller\HomeController->choice_service (line 45)
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 29)
14	require_once (line 5)

3.34 ms
(3.25%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3 FROM type_schedule t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.description AS description_3
FROM
  type_schedule t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.description AS description_3 FROM type_schedule t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():294} (line 295)
4	Proxies\__CG__\App\Entity\TypeSchedule::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():371}:372} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 59)
6	Proxies\__CG__\App\Entity\TypeSchedule->__get (line 146)
7	App\Entity\TypeSchedule->getType (line 42)
8	App\Controller\HomeController->choice_service (line 58)
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 29)
14	require_once (line 5)

2.76 ms
(2.68%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.debut AS debut_3, t0.fin AS fin_4, t0.uid AS uid_5, t0.smart AS smart_6, t0.state AS state_7, t0.start AS start_8, t0.end AS end_9, t0.is_ferie AS is_ferie_10, t0.is_holiday AS is_holiday_11, t0.time_worked AS time_worked_12, t0.location AS location_13, t0.time_pause AS time_pause_14, t0.user_id AS user_id_15, t0.service_id AS service_id_16, t0.type_schedule_id AS type_schedule_id_17 FROM schedule t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.debut AS debut_3,
  t0.fin AS fin_4,
  t0.uid AS uid_5,
  t0.smart AS smart_6,
  t0.state AS state_7,
  t0.start AS start_8,
  t0.end AS end_9,
  t0.is_ferie AS is_ferie_10,
  t0.is_holiday AS is_holiday_11,
  t0.time_worked AS time_worked_12,
  t0.location AS location_13,
  t0.time_pause AS time_pause_14,
  t0.user_id AS user_id_15,
  t0.service_id AS service_id_16,
  t0.type_schedule_id AS type_schedule_id_17
FROM
  schedule t0

SELECT t0.id AS id_1, t0.date AS date_2, t0.debut AS debut_3, t0.fin AS fin_4, t0.uid AS uid_5, t0.smart AS smart_6, t0.state AS state_7, t0.start AS start_8, t0.end AS end_9, t0.is_ferie AS is_ferie_10, t0.is_holiday AS is_holiday_11, t0.time_worked AS time_worked_12, t0.location AS location_13, t0.time_pause AS time_pause_14, t0.user_id AS user_id_15, t0.service_id AS service_id_16, t0.type_schedule_id AS type_schedule_id_17 FROM schedule t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\HomeController->choice_service (line 37)
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 29)
11	require_once (line 5)

0.65 ms
(0.63%)

"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 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\HomeController->choice_service (line 99)
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 29)
9	require_once (line 5)

0.42 ms
(0.40%)

"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 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\HomeController->choice_service (line 99)
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 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\Schedule	514
App\Entity\Service	5
App\Entity\TypeSchedule	5
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\Schedule	The mappings App\Entity\Schedule#service and App\Entity\Service#schedules are inconsistent with each other.
App\Entity\User	The association App\Entity\User#categories refers to the inverse side field App\Entity\Category#users which does not exist. The mappings App\Entity\User#chatIas and App\Entity\ChatIa#user are inconsistent with each other.
App\Entity\Service	The association App\Entity\Service#schedules refers to the owning side field App\Entity\Schedule#services which does not exist.
App\Entity\TypeSchedule	No errors.

Symfony Profiler

GET https://hdb.amarsyll.pro/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping