Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.40 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.78 ms
(55.45%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.last_login AS last_login_8, t0.profile_photo_filename AS profile_photo_filename_9, t0.updated_at AS updated_at_10, t0.address AS address_11, t0.mobile_number AS mobile_number_12, t0.phone_number AS phone_number_13, t0.father_name AS father_name_14, t0.gender AS gender_15, t0.salutation AS salutation_16, t0.date_of_birth AS date_of_birth_17, t0.nationality AS nationality_18, t0.last_password_change_at AS last_password_change_at_19, t0.timezone AS timezone_20, t0.language AS language_21, t0.bio AS bio_22 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.password AS password_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.last_login AS last_login_8,
  t0.profile_photo_filename AS profile_photo_filename_9,
  t0.updated_at AS updated_at_10,
  t0.address AS address_11,
  t0.mobile_number AS mobile_number_12,
  t0.phone_number AS phone_number_13,
  t0.father_name AS father_name_14,
  t0.gender AS gender_15,
  t0.salutation AS salutation_16,
  t0.date_of_birth AS date_of_birth_17,
  t0.nationality AS nationality_18,
  t0.last_password_change_at AS last_password_change_at_19,
  t0.timezone AS timezone_20,
  t0.language AS language_21,
  t0.bio AS bio_22
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.password AS password_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.last_login AS last_login_8, t0.profile_photo_filename AS profile_photo_filename_9, t0.updated_at AS updated_at_10, t0.address AS address_11, t0.mobile_number AS mobile_number_12, t0.phone_number AS phone_number_13, t0.father_name AS father_name_14, t0.gender AS gender_15, t0.salutation AS salutation_16, t0.date_of_birth AS date_of_birth_17, t0.nationality AS nationality_18, t0.last_password_change_at AS last_password_change_at_19, t0.timezone AS timezone_20, t0.language AS language_21, t0.bio AS bio_22 FROM `user` t0 WHERE t0.id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
9	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
11	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.63 ms
(44.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 5;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1079)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1008)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 2710)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 277)
8	App\Entity\User->getRoles (line 303)
9	Symfony\Component\Security\Http\Firewall\ContextListener::hasUserChanged (line 212)
10	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
11	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
13	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
14	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
15	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
16	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Role	No errors.
App\Entity\Permission	No errors.
App\Entity\Applicant	No errors.

Symfony Profiler

POST https://lead-albania.bepro.al/applicant/new

Configuration Settings

Theme