Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

4.88 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.88 ms
(100.00%)

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.email = ? LIMIT 1

Parameters:

[
  "savalle.hydraunorm@gmail.com"
]

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.email = ?
LIMIT
  1

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.email = 'savalle.hydraunorm@gmail.com' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 57)
4	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 97)
5	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 56)
6	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 40)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 189)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 193)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 32)
29	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	1
App\Entity\Agency	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.

Symfony Profiler

POST https://hydraunorm.moovsit.fr/login

Configuration Settings

Theme

Page Width