Symfony Profiler

Query Metrics

63 Database Queries

5 Different statements

6.47 ms Query time

0 Invalid entities

90 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.35 ms
(51.71%)

SELECT t0.website AS website_1, t0.last_login AS last_login_2, t0.sex AS sex_3, t0.nickname AS nickname_4, t0.birthday AS birthday_5, t0.bio AS bio_6, t0.experience AS experience_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.skills AS skills_10, t0.is_active AS is_active_11, t0.is_public AS is_public_12, t0.is_searchable AS is_searchable_13, t0.is_team AS is_team_14, t0.team_title AS team_title_15, t0.social_links AS social_links_16, t0.id AS id_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.loc_country AS loc_country_20, t0.loc_state AS loc_state_21, t0.loc_city AS loc_city_22, t0.loc_address AS loc_address_23, t0.loc_post AS loc_post_24, t0.user_id AS user_id_25 FROM core_user_profile t0 WHERE t0.user_id = ?

Parameters:

[
  405
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.website AS website_1,
  t0.last_login AS last_login_2,
  t0.sex AS sex_3,
  t0.nickname AS nickname_4,
  t0.birthday AS birthday_5,
  t0.bio AS bio_6,
  t0.experience AS experience_7,
  t0.firstname AS firstname_8,
  t0.lastname AS lastname_9,
  t0.skills AS skills_10,
  t0.is_active AS is_active_11,
  t0.is_public AS is_public_12,
  t0.is_searchable AS is_searchable_13,
  t0.is_team AS is_team_14,
  t0.team_title AS team_title_15,
  t0.social_links AS social_links_16,
  t0.id AS id_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.loc_country AS loc_country_20,
  t0.loc_state AS loc_state_21,
  t0.loc_city AS loc_city_22,
  t0.loc_address AS loc_address_23,
  t0.loc_post AS loc_post_24,
  t0.user_id AS user_id_25
FROM
  core_user_profile t0
WHERE
  t0.user_id = ?

SELECT t0.website AS website_1, t0.last_login AS last_login_2, t0.sex AS sex_3, t0.nickname AS nickname_4, t0.birthday AS birthday_5, t0.bio AS bio_6, t0.experience AS experience_7, t0.firstname AS firstname_8, t0.lastname AS lastname_9, t0.skills AS skills_10, t0.is_active AS is_active_11, t0.is_public AS is_public_12, t0.is_searchable AS is_searchable_13, t0.is_team AS is_team_14, t0.team_title AS team_title_15, t0.social_links AS social_links_16, t0.id AS id_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.loc_country AS loc_country_20, t0.loc_state AS loc_state_21, t0.loc_city AS loc_city_22, t0.loc_address AS loc_address_23, t0.loc_post AS loc_post_24, t0.user_id AS user_id_25 FROM core_user_profile t0 WHERE t0.user_id = 405;

#	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 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
12	__TwigTemplate_5cdfa7e412f2ffadfd2c57487bddc8ea->block_body (line 85)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_a52a9f68459e84c45b06252170a9bf46->doDisplay (line 167)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_5cdfa7e412f2ffadfd2c57487bddc8ea->doDisplay (line 56)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 66)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 6)

2.35 ms
(36.25%)

SELECT t0.privacy AS privacy_1, t0.id AS id_2, t0.user_id AS user_id_3 FROM core_user_prefs t0 WHERE t0.user_id = ?

Parameters:

[
  405
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.privacy AS privacy_1,
  t0.id AS id_2,
  t0.user_id AS user_id_3
FROM
  core_user_prefs t0
WHERE
  t0.user_id = ?

SELECT t0.privacy AS privacy_1, t0.id AS id_2, t0.user_id AS user_id_3 FROM core_user_prefs t0 WHERE t0.user_id = 405;

#	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 495)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 147)
7	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 176)
8	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 943)
9	Doctrine\ORM\AbstractQuery->execute (line 886)
10	Doctrine\ORM\AbstractQuery->getResult (line 688)
11	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
12	__TwigTemplate_5cdfa7e412f2ffadfd2c57487bddc8ea->block_body (line 85)
13	Twig\Template->yieldBlock (line 446)
14	__TwigTemplate_a52a9f68459e84c45b06252170a9bf46->doDisplay (line 167)
15	Twig\Template->yield (line 402)
16	__TwigTemplate_5cdfa7e412f2ffadfd2c57487bddc8ea->doDisplay (line 56)
17	Twig\Template->yield (line 402)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 373)
20	Twig\TemplateWrapper->render (line 51)
21	Twig\Environment->render (line 333)
22	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 66)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
29	Symfony\Component\HttpKernel\Kernel->handle (line 191)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
31	require_once (line 32)
32	require_once (line 6)

0.29 ms
(4.44%)

SELECT DISTINCT id_6 FROM (SELECT DISTINCT id_6 FROM (SELECT c0_.email AS email_0, c0_.is_verified AS is_verified_1, c0_.roles AS roles_2, c0_.status AS status_3, c0_.terms AS terms_4, c0_.password AS password_5, c0_.id AS id_6, c0_.slug AS slug_7, c0_.phone AS phone_8 FROM core_user c0_) dctrn_result_inner ORDER BY id_6 ASC) dctrn_result LIMIT 38 OFFSET 114

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_6
FROM
  (
    SELECT
      DISTINCT id_6
    FROM
      (
        SELECT
          c0_.email AS email_0,
          c0_.is_verified AS is_verified_1,
          c0_.roles AS roles_2,
          c0_.status AS status_3,
          c0_.terms AS terms_4,
          c0_.password AS password_5,
          c0_.id AS id_6,
          c0_.slug AS slug_7,
          c0_.phone AS phone_8
        FROM
          core_user c0_
      ) dctrn_result_inner
    ORDER BY
      id_6 ASC
  ) dctrn_result
LIMIT
  38
OFFSET
  114

SELECT DISTINCT id_6 FROM (SELECT DISTINCT id_6 FROM (SELECT c0_.email AS email_0, c0_.is_verified AS is_verified_1, c0_.roles AS roles_2, c0_.status AS status_3, c0_.terms AS terms_4, c0_.password AS password_5, c0_.id AS id_6, c0_.slug AS slug_7, c0_.phone AS phone_8 FROM core_user c0_) dctrn_result_inner ORDER BY id_6 ASC) dctrn_result LIMIT 38 OFFSET 114;

#	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->getScalarResult (line 724)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 127)
7	__TwigTemplate_5cdfa7e412f2ffadfd2c57487bddc8ea->block_body (line 85)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_a52a9f68459e84c45b06252170a9bf46->doDisplay (line 167)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_5cdfa7e412f2ffadfd2c57487bddc8ea->doDisplay (line 56)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 66)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 6)

0.25 ms
(3.88%)

SELECT COUNT(c0_.id) AS sclr_0 FROM core_user c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  core_user c0_

SELECT COUNT(c0_.id) AS sclr_0 FROM core_user c0_;

#	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->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\BaseRepository->getCount (line 38)
8	App\Addon\Controller\PublicController->members (line 121)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 191)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 6)

0.24 ms
(3.72%)

SELECT c0_.email AS email_0, c0_.is_verified AS is_verified_1, c0_.roles AS roles_2, c0_.status AS status_3, c0_.terms AS terms_4, c0_.password AS password_5, c0_.id AS id_6, c0_.slug AS slug_7, c0_.phone AS phone_8 FROM core_user c0_ WHERE c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY c0_.id ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.email AS email_0,
  c0_.is_verified AS is_verified_1,
  c0_.roles AS roles_2,
  c0_.status AS status_3,
  c0_.terms AS terms_4,
  c0_.password AS password_5,
  c0_.id AS id_6,
  c0_.slug AS slug_7,
  c0_.phone AS phone_8
FROM
  core_user c0_
WHERE
  c0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  c0_.id ASC

SELECT c0_.email AS email_0, c0_.is_verified AS is_verified_1, c0_.roles AS roles_2, c0_.status AS status_3, c0_.terms AS terms_4, c0_.password AS password_5, c0_.id AS id_6, c0_.slug AS slug_7, c0_.phone AS phone_8 FROM core_user c0_ WHERE c0_.id IN (405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 419, 420, 421, 422, 423, 424, 425, 426, 427, 428, 429, 430, 431, 432, 433, 434) ORDER BY c0_.id ASC;

#	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	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 145)
7	__TwigTemplate_5cdfa7e412f2ffadfd2c57487bddc8ea->block_body (line 85)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_a52a9f68459e84c45b06252170a9bf46->doDisplay (line 167)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_5cdfa7e412f2ffadfd2c57487bddc8ea->doDisplay (line 56)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bridge\Twig\EventListener\TemplateAttributeListener->onKernelView (line 66)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 191)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 6)

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	30
App\Addon\Entity\UserProfile	30
App\Addon\Entity\UserPreferences	30

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Addon\Entity\UserProfile	No errors.
App\Addon\Entity\UserPreferences	No errors.
App\Addon\Entity\Credit	No errors.

Symfony Profiler

GET https://mountwells.mizzium.com/members/4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping