Symfony Profiler

Query Metrics

5 Database Queries

4 Different statements

5.65 ms Query time

0 Invalid entities

17 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.80 ms
(67.28%)

SELECT t0.id AS id_1, t0.email AS email_2, t0."passwordHash" AS passwordhash_3, t0."systemKey" AS systemkey_4, t0.status AS status_5, t0."forcePasswordChange" AS forcepasswordchange_6, t0."lastLoginAt" AS lastloginat_7, t0."failedLoginAttempts" AS failedloginattempts_8, t0."firstName" AS firstname_9, t0."lastName" AS lastname_10, t0."avatarData" AS avatardata_11, t0."createdAt" AS createdat_12, t0."updatedAt" AS updatedat_13, t0.locale AS locale_14, t0."roleId" AS roleid_15, t16.id AS id_17, t16."employeeNumber" AS employeenumber_18, t16.position AS position_19, t16.department AS department_20, t16."employmentDate" AS employmentdate_21, t16."employmentStatus" AS employmentstatus_22, t16."contractEndDate" AS contractenddate_23, t16."contractType" AS contracttype_24, t16."salaryGross" AS salarygross_25, t16."workHoursPerWeek" AS workhoursperweek_26, t16."annualLeaveLimit" AS annualleavelimit_27, t16."hrmCanViewTeam" AS hrmcanviewteam_28, t16."hrmCanApproveLeave" AS hrmcanapproveleave_29, t16."hrmCanManageSick" AS hrmcanmanagesick_30, t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31, t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32, t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33, t16."hrmCanApproveTime" AS hrmcanapprovetime_34, t16."hrmCanEditTime" AS hrmcanedittime_35, t16."createdAt" AS createdat_36, t16."updatedAt" AS updatedat_37, t16."userId" AS userid_38, t16."managerId" AS managerid_39 FROM "CRM_Pro_Users" t0 LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id WHERE t0.email = ? LIMIT 1

Parameters:

[
  "izab"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0."passwordHash" AS passwordhash_3,
  t0."systemKey" AS systemkey_4,
  t0.status AS status_5,
  t0."forcePasswordChange" AS forcepasswordchange_6,
  t0."lastLoginAt" AS lastloginat_7,
  t0."failedLoginAttempts" AS failedloginattempts_8,
  t0."firstName" AS firstname_9,
  t0."lastName" AS lastname_10,
  t0."avatarData" AS avatardata_11,
  t0."createdAt" AS createdat_12,
  t0."updatedAt" AS updatedat_13,
  t0.locale AS locale_14,
  t0."roleId" AS roleid_15,
  t16.id AS id_17,
  t16."employeeNumber" AS employeenumber_18,
  t16.position AS position_19,
  t16.department AS department_20,
  t16."employmentDate" AS employmentdate_21,
  t16."employmentStatus" AS employmentstatus_22,
  t16."contractEndDate" AS contractenddate_23,
  t16."contractType" AS contracttype_24,
  t16."salaryGross" AS salarygross_25,
  t16."workHoursPerWeek" AS workhoursperweek_26,
  t16."annualLeaveLimit" AS annualleavelimit_27,
  t16."hrmCanViewTeam" AS hrmcanviewteam_28,
  t16."hrmCanApproveLeave" AS hrmcanapproveleave_29,
  t16."hrmCanManageSick" AS hrmcanmanagesick_30,
  t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31,
  t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32,
  t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33,
  t16."hrmCanApproveTime" AS hrmcanapprovetime_34,
  t16."hrmCanEditTime" AS hrmcanedittime_35,
  t16."createdAt" AS createdat_36,
  t16."updatedAt" AS updatedat_37,
  t16."userId" AS userid_38,
  t16."managerId" AS managerid_39
FROM
  "CRM_Pro_Users" t0
  LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0."passwordHash" AS passwordhash_3, t0."systemKey" AS systemkey_4, t0.status AS status_5, t0."forcePasswordChange" AS forcepasswordchange_6, t0."lastLoginAt" AS lastloginat_7, t0."failedLoginAttempts" AS failedloginattempts_8, t0."firstName" AS firstname_9, t0."lastName" AS lastname_10, t0."avatarData" AS avatardata_11, t0."createdAt" AS createdat_12, t0."updatedAt" AS updatedat_13, t0.locale AS locale_14, t0."roleId" AS roleid_15, t16.id AS id_17, t16."employeeNumber" AS employeenumber_18, t16.position AS position_19, t16.department AS department_20, t16."employmentDate" AS employmentdate_21, t16."employmentStatus" AS employmentstatus_22, t16."contractEndDate" AS contractenddate_23, t16."contractType" AS contracttype_24, t16."salaryGross" AS salarygross_25, t16."workHoursPerWeek" AS workhoursperweek_26, t16."annualLeaveLimit" AS annualleavelimit_27, t16."hrmCanViewTeam" AS hrmcanviewteam_28, t16."hrmCanApproveLeave" AS hrmcanapproveleave_29, t16."hrmCanManageSick" AS hrmcanmanagesick_30, t16."hrmCanUploadPayslip" AS hrmcanuploadpayslip_31, t16."hrmCanManageLeaveTypes" AS hrmcanmanageleavetypes_32, t16."hrmCanManageEmployees" AS hrmcanmanageemployees_33, t16."hrmCanApproveTime" AS hrmcanapprovetime_34, t16."hrmCanEditTime" AS hrmcanedittime_35, t16."createdAt" AS createdat_36, t16."updatedAt" AS updatedat_37, t16."userId" AS userid_38, t16."managerId" AS managerid_39 FROM "CRM_Pro_Users" t0 LEFT JOIN "CRM_Pro_EmployeeProfiles" t16 ON t16."userId" = t0.id WHERE t0.email = 'izab' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\EventSubscriber\JwtEventSubscriber->onJwtDecoded (line 101)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
9	Lexik\Bundle\JWTAuthenticationBundle\Services\JWTManager->parse (line 125)
10	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->authenticate (line 86)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
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 126)
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)

1.00 ms
(17.72%)

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.title AS title_2, t0_.message AS message_3, t0_."isRead" AS isread_4, t0_."isHidden" AS ishidden_5, t0_."createdAt" AS createdat_6, t0_."userId" AS userid_7 FROM "CRM_Pro_Notifications" t0_ WHERE t0_."userId" = ? AND t0_."isHidden" = false ORDER BY t0_."createdAt" DESC LIMIT 50

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.type AS type_1,
  t0_.title AS title_2,
  t0_.message AS message_3,
  t0_."isRead" AS isread_4,
  t0_."isHidden" AS ishidden_5,
  t0_."createdAt" AS createdat_6,
  t0_."userId" AS userid_7
FROM
  "CRM_Pro_Notifications" t0_
WHERE
  t0_."userId" = ?
  AND t0_."isHidden" = false
ORDER BY
  t0_."createdAt" DESC
LIMIT
  50

SELECT t0_.id AS id_0, t0_.type AS type_1, t0_.title AS title_2, t0_.message AS message_3, t0_."isRead" AS isread_4, t0_."isHidden" AS ishidden_5, t0_."createdAt" AS createdat_6, t0_."userId" AS userid_7 FROM "CRM_Pro_Notifications" t0_ WHERE t0_."userId" = 5 AND t0_."isHidden" = false ORDER BY t0_."createdAt" DESC LIMIT 50;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\NotificationRepository->findByUser (line 37)
7	App\Controller\NotificationController->list (line 32)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.45 ms
(7.95%)

SELECT t0.id AS id_1, t0."companyEmail" AS companyemail_2, t0."privateEmail" AS privateemail_3, t0."companyPhone" AS companyphone_4, t0."privatePhone" AS privatephone_5, t0.location AS location_6, t0."emergencyName" AS emergencyname_7, t0."emergencyPhone" AS emergencyphone_8, t0."updatedAt" AS updatedat_9, t0."profileId" AS profileid_10 FROM "CRM_Pro_EmployeeContacts" t0 WHERE t0."profileId" = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0."companyEmail" AS companyemail_2,
  t0."privateEmail" AS privateemail_3,
  t0."companyPhone" AS companyphone_4,
  t0."privatePhone" AS privatephone_5,
  t0.location AS location_6,
  t0."emergencyName" AS emergencyname_7,
  t0."emergencyPhone" AS emergencyphone_8,
  t0."updatedAt" AS updatedat_9,
  t0."profileId" AS profileid_10
FROM
  "CRM_Pro_EmployeeContacts" t0
WHERE
  t0."profileId" = ?

SELECT t0.id AS id_1, t0."companyEmail" AS companyemail_2, t0."privateEmail" AS privateemail_3, t0."companyPhone" AS companyphone_4, t0."privatePhone" AS privatephone_5, t0.location AS location_6, t0."emergencyName" AS emergencyname_7, t0."emergencyPhone" AS emergencyphone_8, t0."updatedAt" AS updatedat_9, t0."profileId" AS profileid_10 FROM "CRM_Pro_EmployeeContacts" t0 WHERE t0."profileId" = 5;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 837)
3	Doctrine\ORM\UnitOfWork->createEntity (line 2458)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 442)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 746)
9	Doctrine\ORM\EntityRepository->findOneBy (line 125)
10	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
11	App\EventSubscriber\JwtEventSubscriber->onJwtDecoded (line 101)
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 126)
16	Lexik\Bundle\JWTAuthenticationBundle\Services\JWTManager->parse (line 125)
17	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->authenticate (line 86)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
19	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
20	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
21	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
22	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
23	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
24	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
25	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
26	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
27	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
28	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
29	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
30	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 193)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 32)
36	require_once (line 5)

0.40 ms
(7.05%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM "CRM_Pro_Roles" t0 WHERE t0.id = ?

Parameters:

[
  1
]

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
FROM
  "CRM_Pro_Roles" t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM "CRM_Pro_Roles" 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->Doctrine\ORM\Proxy\{closure} (line 295)
4	Proxies\__CG__\App\Entity\Role::Doctrine\ORM\Proxy\{closure} (line 373)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 60)
6	Proxies\__CG__\App\Entity\Role->__get (line 153)
7	App\Entity\Role->getName (line 46)
8	App\Entity\User->getRoles (line 95)
9	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->createToken (line 213)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->createToken (line 84)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 207)
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\Debug\TraceableFirewallListener->callListeners (line 94)
18	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
19	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
20	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
21	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
22	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 193)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 32)
28	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\Notification	13
App\Entity\User	1
App\Entity\Role	1
App\Entity\EmployeeProfile	1
App\Entity\EmployeeContact	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Role	No errors.
App\Entity\EmployeeProfile	No errors.
App\Entity\Session	No errors.
App\Entity\EmployeeContact	No errors.
App\Entity\Permission	No errors.
App\Entity\Notification	No errors.

Symfony Profiler

GET http://crm.proadvice-marketing.de/notifications

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping