Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.18 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

2.18 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.name AS name_6, t0.token AS token_7, t0.google AS google_8, t0.enabled AS enabled_9, t10.lname AS lname_11, t10.profession AS profession_12, t10.id AS id_13, t10.name AS name_14, t10.gender AS gender_15, t10.dob AS dob_16, t10.enable AS enable_17, t10.marital_status AS marital_status_18, t10.type AS type_19, t10.created AS created_20, t10.updated AS updated_21, t10.account_id AS account_id_22, t10.permanent_address_id AS permanent_address_id_23, t10.media_id AS media_id_24, t10.user_id AS user_id_25, t10.address_id AS address_id_26, t10.photo_id AS photo_id_27 FROM user__user t0 LEFT JOIN profile__person t10 ON t10.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.name AS name_6,
  t0.token AS token_7,
  t0.google AS google_8,
  t0.enabled AS enabled_9,
  t10.lname AS lname_11,
  t10.profession AS profession_12,
  t10.id AS id_13,
  t10.name AS name_14,
  t10.gender AS gender_15,
  t10.dob AS dob_16,
  t10.enable AS enable_17,
  t10.marital_status AS marital_status_18,
  t10.type AS type_19,
  t10.created AS created_20,
  t10.updated AS updated_21,
  t10.account_id AS account_id_22,
  t10.permanent_address_id AS permanent_address_id_23,
  t10.media_id AS media_id_24,
  t10.user_id AS user_id_25,
  t10.address_id AS address_id_26,
  t10.photo_id AS photo_id_27
FROM
  user__user t0
  LEFT JOIN profile__person t10 ON t10.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.name AS name_6, t0.token AS token_7, t0.google AS google_8, t0.enabled AS enabled_9, t10.lname AS lname_11, t10.profession AS profession_12, t10.id AS id_13, t10.name AS name_14, t10.gender AS gender_15, t10.dob AS dob_16, t10.enable AS enable_17, t10.marital_status AS marital_status_18, t10.type AS type_19, t10.created AS created_20, t10.updated AS updated_21, t10.account_id AS account_id_22, t10.permanent_address_id AS permanent_address_id_23, t10.media_id AS media_id_24, t10.user_id AS user_id_25, t10.address_id AS address_id_26, t10.photo_id AS photo_id_27 FROM user__user t0 LEFT JOIN profile__person t10 ON t10.user_id = t0.id WHERE t0.id = 15;

#	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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\Profile\Person	No errors.
App\Entity\Account\Account	No errors.
SDRO\ProfileBundle\Entity\Address	No errors.
App\Entity\Media\Media	No errors.
App\Entity\Payment\Payment	No errors.
SDRO\NotificationBundle\Entity\Mail	No errors.
App\Entity\Profile\Reference	No errors.
App\Entity\English\Dictionary	No errors.
App\Entity\English\UserVocabulary	No errors.
App\Entity\Profile\Config	No errors.
SDRO\ProfileBundle\Entity\Group	No errors.
SDRO\ProfileBundle\Entity\Contact	No errors.
SDRO\ProfileBundle\Entity\Email	No errors.

Symfony Profiler

POST https://eduboi.com/register

Configuration Settings

Theme