Symfony Profiler

Query Metrics

14 Database Queries

5 Different statements

10.78 ms Query time

0 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.99 ms
(37.00%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.inspection_date AS inspection_date_3, t0.frequency AS frequency_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.machine_id AS machine_id_7, t0.type_id AS type_id_8 FROM machine_equipment t0 WHERE t0.machine_id = ?

Parameters:

[
  234
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.inspection_date AS inspection_date_3,
  t0.frequency AS frequency_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.machine_id AS machine_id_7,
  t0.type_id AS type_id_8
FROM
  machine_equipment t0
WHERE
  t0.machine_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.inspection_date AS inspection_date_3, t0.frequency AS frequency_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.machine_id AS machine_id_7, t0.type_id AS type_id_8 FROM machine_equipment t0 WHERE t0.machine_id = 234;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 876)
3	Doctrine\ORM\UnitOfWork->createEntity (line 3038)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 502)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 149)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 276)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1226)
9	Doctrine\ORM\AbstractQuery->execute (line 1167)
10	Doctrine\ORM\AbstractQuery->getResult (line 906)
11	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 171)
12	App\Orm\EntityPaginator->paginate (line 67)
13	EasyCorp\Bundle\EasyAdminBundle\Factory\PaginatorFactory->create (line 26)
14	App\Controller\CustomAbstractCrudController->autocomplete (line 80)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
17	Symfony\Component\HttpKernel\Kernel->handle (line 193)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
19	require_once (line 32)
20	require_once (line 5)

2.81 ms
(26.07%)

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.67 ms
(24.79%)

SELECT DISTINCT m0_.id AS id_0, m0_.created_at AS created_at_1 FROM machine 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 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 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.72 ms
(6.68%)

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_.type_id AS type_id_4, m0_.client_id AS client_id_5, m0_.contact_id AS contact_id_6 FROM machine 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_.type_id AS type_id_4,
  m0_.client_id AS client_id_5,
  m0_.contact_id AS contact_id_6
FROM
  machine 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_.type_id AS type_id_4, m0_.client_id AS client_id_5, m0_.contact_id AS contact_id_6 FROM machine m0_ WHERE m0_.id IN (267, 243, 265, 234, 249, 268, 241, 242, 257, 253) 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.59 ms
(5.46%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

SELECT count(m0_.id) AS sclr_0 FROM machine 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\Machine	10
App\Entity\Client	10
App\Entity\MachineType	5
App\Entity\User	1
App\Entity\Agency	1
App\Entity\MachineEquipment	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\Machine	No errors.
App\Entity\MachineType	No errors.
App\Entity\Client	No errors.
App\Entity\Contact	No errors.
App\Entity\MachinePhoto	No errors.
App\Entity\MachineEquipment	No errors.
App\Entity\MachineInformationValue	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

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping