Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.92 ms Query time

0 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.92 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.google AS google_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.sex AS sex_7, t0.contact_hours AS contact_hours_8, t0.status AS status_9, t0.is_suspended AS is_suspended_10, t0.roles AS roles_11, t0.balance AS balance_12, t0.has_picture AS has_picture_13, t0.is_public_name AS is_public_name_14, t0.is_subscribed AS is_subscribed_15, ST_AsText(t0.location) AS location_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.language_id AS language_id_19, t0.company_id AS company_id_20, t21.id AS id_22, t21.phone_number AS phone_number_23, t21.status AS status_24, t21.code AS code_25, t21.ip_address AS ip_address_26, t21.created_at AS created_at_27, t21.updated_at AS updated_at_28, t21.user_id AS user_id_29 FROM ax_user t0 LEFT JOIN ax_user_phone t21 ON t21.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.google AS google_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.sex AS sex_7,
  t0.contact_hours AS contact_hours_8,
  t0.status AS status_9,
  t0.is_suspended AS is_suspended_10,
  t0.roles AS roles_11,
  t0.balance AS balance_12,
  t0.has_picture AS has_picture_13,
  t0.is_public_name AS is_public_name_14,
  t0.is_subscribed AS is_subscribed_15,
  ST_AsText(t0.location) AS location_16,
  t0.created_at AS created_at_17,
  t0.updated_at AS updated_at_18,
  t0.language_id AS language_id_19,
  t0.company_id AS company_id_20,
  t21.id AS id_22,
  t21.phone_number AS phone_number_23,
  t21.status AS status_24,
  t21.code AS code_25,
  t21.ip_address AS ip_address_26,
  t21.created_at AS created_at_27,
  t21.updated_at AS updated_at_28,
  t21.user_id AS user_id_29
FROM
  ax_user t0
  LEFT JOIN ax_user_phone t21 ON t21.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.google AS google_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.sex AS sex_7, t0.contact_hours AS contact_hours_8, t0.status AS status_9, t0.is_suspended AS is_suspended_10, t0.roles AS roles_11, t0.balance AS balance_12, t0.has_picture AS has_picture_13, t0.is_public_name AS is_public_name_14, t0.is_subscribed AS is_subscribed_15, ST_AsText(t0.location) AS location_16, t0.created_at AS created_at_17, t0.updated_at AS updated_at_18, t0.language_id AS language_id_19, t0.company_id AS company_id_20, t21.id AS id_22, t21.phone_number AS phone_number_23, t21.status AS status_24, t21.code AS code_25, t21.ip_address AS ip_address_26, t21.created_at AS created_at_27, t21.updated_at AS updated_at_28, t21.user_id AS user_id_29 FROM ax_user t0 LEFT JOIN ax_user_phone t21 ON t21.user_id = t0.id WHERE t0.id = 7;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 227)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 132)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->{closure:Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext::authenticate():74} (line 77)
11	Symfony\Component\Security\Core\Authentication\Token\Storage\TokenStorage::getToken (line 34)
12	Symfony\Component\Security\Core\Authentication\Token\Storage\UsageTrackingTokenStorage->getToken (line 42)
13	Symfony\Component\Security\Core\Authorization\AuthorizationChecker->isGranted (line 45)
14	Symfony\Bridge\Twig\Extension\SecurityExtension->isGranted (line 52)
15	__TwigTemplate_a6e158db361d4a7473280e61307b6e6e->block_googleusercontent (line 629)
16	Twig\Template->yieldBlock (line 458)
17	__TwigTemplate_a6e158db361d4a7473280e61307b6e6e->doDisplay (line 196)
18	Twig\Template->yield (line 411)
19	__TwigTemplate_d8a67eb3c37e9d4c16aca96904f0c3d0->doDisplay (line 59)
20	Twig\Template->yield (line 411)
21	Twig\Template->display (line 366)
22	Twig\Template->render (line 381)
23	Twig\TemplateWrapper->render (line 51)
24	Twig\Environment->render (line 333)
25	Symfony\Bundle\FrameworkBundle\Controller\TemplateController->templateAction (line 48)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
28	Symfony\Component\HttpKernel\Kernel->handle (line 143)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
30	require_once (line 32)
31	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\Language	1
App\Entity\UserPhone	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Language	No errors.
App\Entity\Company	No errors.
App\Entity\UserPhone	No errors.
App\Entity\Property	No errors.

GET https://land.n46.net/en

Configuration Settings

Theme

Page Width