Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

6.48 ms Query time

0 Invalid entities

13 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.91 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 WHERE t0.id = ?

Parameters:

[
  9
]

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.matricule AS matricule_5,
  t0.last_name AS last_name_6,
  t0.first_name AS first_name_7,
  t0.enabled AS enabled_8,
  t0.background_color AS background_color_9,
  t0.text_color AS text_color_10,
  t0.badge_number AS badge_number_11,
  t0.hourly_plan AS hourly_plan_12,
  t0.weekly_schedule AS weekly_schedule_13,
  t0.rtt_balance AS rtt_balance_14,
  t0.rtt_max AS rtt_max_15,
  t0.rtt_min AS rtt_min_16,
  t0.vacation_monthly_credit AS vacation_monthly_credit_17,
  t0.vacation_n0 AS vacation_n0_18,
  t0.vacation_n1 AS vacation_n1_19,
  t0.end_of_input AS end_of_input_20,
  t0.created_at AS created_at_21,
  t0.updated_at AS updated_at_22,
  t0.sector_id AS sector_id_23,
  t0.attached_agency_id AS attached_agency_id_24,
  t0.badge_id AS badge_id_25
FROM
  "user" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.matricule AS matricule_5, t0.last_name AS last_name_6, t0.first_name AS first_name_7, t0.enabled AS enabled_8, t0.background_color AS background_color_9, t0.text_color AS text_color_10, t0.badge_number AS badge_number_11, t0.hourly_plan AS hourly_plan_12, t0.weekly_schedule AS weekly_schedule_13, t0.rtt_balance AS rtt_balance_14, t0.rtt_max AS rtt_max_15, t0.rtt_min AS rtt_min_16, t0.vacation_monthly_credit AS vacation_monthly_credit_17, t0.vacation_n0 AS vacation_n0_18, t0.vacation_n1 AS vacation_n1_19, t0.end_of_input AS end_of_input_20, t0.created_at AS created_at_21, t0.updated_at AS updated_at_22, t0.sector_id AS sector_id_23, t0.attached_agency_id AS attached_agency_id_24, t0.badge_id AS badge_id_25 FROM "user" t0 WHERE t0.id = 9;

#	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	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
6	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
7	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
8	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
10	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
11	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 193)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 32)
21	require_once (line 5)

2.32 ms

SELECT DISTINCT m0_.id AS id_0, m0_.created_at AS created_at_1 FROM machine_type m0_ ORDER BY m0_.created_at DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT m0_.id AS id_0,
  m0_.created_at AS created_at_1
FROM
  machine_type m0_
ORDER BY
  m0_.created_at DESC
LIMIT
  10

SELECT DISTINCT m0_.id AS id_0, m0_.created_at AS created_at_1 FROM machine_type m0_ ORDER BY m0_.created_at DESC LIMIT 10;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 153)
7	App\Orm\EntityPaginator->paginate (line 67)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	App\Controller\CustomAbstractCrudController->autocomplete (line 80)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.73 ms

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.created_at AS created_at_2, m0_.updated_at AS updated_at_3, m0_.agency_id AS agency_id_4 FROM machine_type m0_ WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.created_at DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.created_at AS created_at_2,
  m0_.updated_at AS updated_at_3,
  m0_.agency_id AS agency_id_4
FROM
  machine_type m0_
WHERE
  m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  m0_.created_at DESC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.created_at AS created_at_2, m0_.updated_at AS updated_at_3, m0_.agency_id AS agency_id_4 FROM machine_type m0_ WHERE m0_.id IN (59, 60, 61, 62, 63, 64, 65, 66, 67, 68) ORDER BY m0_.created_at DESC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getResult (line 906)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 171)
7	App\Orm\EntityPaginator->paginate (line 67)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	App\Controller\CustomAbstractCrudController->autocomplete (line 80)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

0.52 ms

SELECT count(m0_.id) AS sclr_0 FROM machine_type m0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(m0_.id) AS sclr_0
FROM
  machine_type m0_

SELECT count(m0_.id) AS sclr_0 FROM machine_type m0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 120)
7	App\Orm\EntityPaginator->paginate (line 68)
8	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
9	App\Controller\CustomAbstractCrudController->autocomplete (line 80)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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\MachineType	10
App\Entity\Agency	2
App\Entity\User	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Sector	No errors.
App\Entity\Agency	No errors.
App\Entity\Badge	No errors.
App\Entity\Business	No errors.
App\Entity\Activity	No errors.
App\Entity\Intervention	No errors.
App\Entity\ClockingIn	No errors.
App\Entity\Absence	No errors.
App\Entity\AbsenceRequest	No errors.
App\Entity\UserBalancesAdjustmentHistory	No errors.
App\Entity\Overtime	No errors.
App\Entity\LockedWeek	No errors.
App\Entity\MachineType	No errors.
App\Entity\MachineMonitoring	No errors.
App\Entity\Machine	No errors.
App\Entity\MachineTypeInformation	No errors.
App\Entity\MachineEquipment	No errors.

Symfony Profiler

GET https://hydraunorm.moovsit.fr/?autocompleteContext%5BcrudControllerFqcn%5D=App%5CController%5CAdmin%5CMachineEquipmentCrudController&autocompleteContext%5Bprope…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping