Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

14.77 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

8.31 ms

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.text AS text_2, m0_.created AS created_3, c1_.id AS id_4, c1_.text AS text_5, c1_.created AS created_6, m0_.author_id AS author_id_7, c1_.post_id AS post_id_8, c1_.author_id AS author_id_9 FROM micro_post m0_ LEFT JOIN COMMENT c1_ ON m0_.id = c1_.post_id ORDER BY m0_.created DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.title AS title_1,
  m0_.text AS text_2,
  m0_.created AS created_3,
  c1_.id AS id_4,
  c1_.text AS text_5,
  c1_.created AS created_6,
  m0_.author_id AS author_id_7,
  c1_.post_id AS post_id_8,
  c1_.author_id AS author_id_9
FROM
  micro_post m0_
  LEFT JOIN COMMENT c1_ ON m0_.id = c1_.post_id
ORDER BY
  m0_.created DESC

SELECT m0_.id AS id_0, m0_.title AS title_1, m0_.text AS text_2, m0_.created AS created_3, c1_.id AS id_4, c1_.text AS text_5, c1_.created AS created_6, m0_.author_id AS author_id_7, c1_.post_id AS post_id_8, c1_.author_id AS author_id_9 FROM micro_post m0_ LEFT JOIN COMMENT c1_ ON m0_.id = c1_.post_id ORDER BY m0_.created DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 32)
7	App\Repository\MicroPostRepository->findAllWithComments (line 24)
8	App\Controller\MicroPostController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

5.65 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.banned_until AS banned_until_6, t7.id AS id_8, t7.name AS name_9, t7.bio AS bio_10, t7.website_url AS website_url_11, t7.username AS username_12, t7.company AS company_13, t7.location AS location_14, t7.date_of_birth AS date_of_birth_15, t7.user_id AS user_id_16 FROM user t0 LEFT JOIN user_profile t7 ON t7.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.banned_until AS banned_until_6,
  t7.id AS id_8,
  t7.name AS name_9,
  t7.bio AS bio_10,
  t7.website_url AS website_url_11,
  t7.username AS username_12,
  t7.company AS company_13,
  t7.location AS location_14,
  t7.date_of_birth AS date_of_birth_15,
  t7.user_id AS user_id_16
FROM
  user t0
  LEFT JOIN user_profile t7 ON t7.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.banned_until AS banned_until_6, t7.id AS id_8, t7.name AS name_9, t7.bio AS bio_10, t7.website_url AS website_url_11, t7.username AS username_12, t7.company AS company_13, t7.location AS location_14, t7.date_of_birth AS date_of_birth_15, t7.user_id AS user_id_16 FROM user t0 LEFT JOIN user_profile t7 ON t7.user_id = t0.id WHERE t0.id = 2;

#	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 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
6	Proxies\__CG__\App\Entity\User->__get (line 80)
7	App\Entity\User->getEmail (line 1709)
8	Twig\Extension\CoreExtension::getAttribute (line 77)
9	__TwigTemplate_57b13a50a1d6aab99083e17ad8a062eb->doDisplay (line 360)
10	Twig\Template->yield (line 335)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 1407)
13	Twig\Extension\CoreExtension::include (line 114)
14	__TwigTemplate_fd0c72f5c6e8a1b06c41b9c9e2dda71c->block_body (line 430)
15	Twig\Template->yieldBlock (line 148)
16	__TwigTemplate_c99c6673fd1188f1b4592281ce4730c8->doDisplay (line 360)
17	Twig\Template->yield (line 50)
18	__TwigTemplate_fd0c72f5c6e8a1b06c41b9c9e2dda71c->doDisplay (line 360)
19	Twig\Template->yield (line 335)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 299)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
26	App\Controller\MicroPostController->index (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.81 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.banned_until AS banned_until_6, t7.id AS id_8, t7.name AS name_9, t7.bio AS bio_10, t7.website_url AS website_url_11, t7.username AS username_12, t7.company AS company_13, t7.location AS location_14, t7.date_of_birth AS date_of_birth_15, t7.user_id AS user_id_16 FROM user t0 LEFT JOIN user_profile t7 ON t7.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.is_verified AS is_verified_5,
  t0.banned_until AS banned_until_6,
  t7.id AS id_8,
  t7.name AS name_9,
  t7.bio AS bio_10,
  t7.website_url AS website_url_11,
  t7.username AS username_12,
  t7.company AS company_13,
  t7.location AS location_14,
  t7.date_of_birth AS date_of_birth_15,
  t7.user_id AS user_id_16
FROM
  user t0
  LEFT JOIN user_profile t7 ON t7.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.banned_until AS banned_until_6, t7.id AS id_8, t7.name AS name_9, t7.bio AS bio_10, t7.website_url AS website_url_11, t7.username AS username_12, t7.company AS company_13, t7.location AS location_14, t7.date_of_birth AS date_of_birth_15, t7.user_id AS user_id_16 FROM user t0 LEFT JOIN user_profile t7 ON t7.user_id = t0.id WHERE t0.id = 3;

#	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 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 61)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
6	Proxies\__CG__\App\Entity\User->__get (line 80)
7	App\Entity\User->getEmail (line 1709)
8	Twig\Extension\CoreExtension::getAttribute (line 77)
9	__TwigTemplate_57b13a50a1d6aab99083e17ad8a062eb->doDisplay (line 360)
10	Twig\Template->yield (line 335)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 1407)
13	Twig\Extension\CoreExtension::include (line 114)
14	__TwigTemplate_fd0c72f5c6e8a1b06c41b9c9e2dda71c->block_body (line 430)
15	Twig\Template->yieldBlock (line 148)
16	__TwigTemplate_c99c6673fd1188f1b4592281ce4730c8->doDisplay (line 360)
17	Twig\Template->yield (line 50)
18	__TwigTemplate_fd0c72f5c6e8a1b06c41b9c9e2dda71c->doDisplay (line 360)
19	Twig\Template->yield (line 335)
20	Twig\Template->render (line 38)
21	Twig\TemplateWrapper->render (line 299)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
26	App\Controller\MicroPostController->index (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
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.

Entities Mapping

Class	Mapping errors
App\Entity\MicroPost	No errors.
App\Entity\Comment	No errors.
App\Entity\User	No errors.
App\Entity\UserProfile	No errors.

Symfony Profiler

GET http://social-media.alextran.cloud/micro-post

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping