Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

83.14 ms Query time

1 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

6.59 ms

SELECT m0_.id AS id_0, m0_.is_model AS is_model_1, m0_.invitation_codes AS invitation_codes_2, m0_.user_id AS user_id_3, m0_.profile_id AS profile_id_4, m0_.manager_id AS manager_id_5, m0_.referred_by_id AS referred_by_id_6 FROM member m0_ LEFT JOIN `user` u1_ ON m0_.user_id = u1_.id WHERE m0_.is_model = 1 AND u1_.destacado = 1 ORDER BY m0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.is_model AS is_model_1,
  m0_.invitation_codes AS invitation_codes_2,
  m0_.user_id AS user_id_3,
  m0_.profile_id AS profile_id_4,
  m0_.manager_id AS manager_id_5,
  m0_.referred_by_id AS referred_by_id_6
FROM
  member m0_
  LEFT JOIN `user` u1_ ON m0_.user_id = u1_.id
WHERE
  m0_.is_model = 1
  AND u1_.destacado = 1
ORDER BY
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.is_model AS is_model_1, m0_.invitation_codes AS invitation_codes_2, m0_.user_id AS user_id_3, m0_.profile_id AS profile_id_4, m0_.manager_id AS manager_id_5, m0_.referred_by_id AS referred_by_id_6 FROM member m0_ LEFT JOIN `user` u1_ ON m0_.user_id = u1_.id WHERE m0_.is_model = 1 AND u1_.destacado = 1 ORDER BY m0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 169)
7	App\Repository\MemberRepository->findDestacadosModelo (line 50)
8	App\Controller\HomeController->getModelosDestacados (line 28)
9	App\Controller\HomeController->homepage (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.84 ms

SELECT m0_.id AS id_0, m0_.is_model AS is_model_1, m0_.invitation_codes AS invitation_codes_2, m0_.user_id AS user_id_3, m0_.profile_id AS profile_id_4, m0_.manager_id AS manager_id_5, m0_.referred_by_id AS referred_by_id_6 FROM member m0_ LEFT JOIN `user` u1_ ON m0_.user_id = u1_.id WHERE m0_.is_model = 1 ORDER BY m0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.is_model AS is_model_1,
  m0_.invitation_codes AS invitation_codes_2,
  m0_.user_id AS user_id_3,
  m0_.profile_id AS profile_id_4,
  m0_.manager_id AS manager_id_5,
  m0_.referred_by_id AS referred_by_id_6
FROM
  member m0_
  LEFT JOIN `user` u1_ ON m0_.user_id = u1_.id
WHERE
  m0_.is_model = 1
ORDER BY
  m0_.id DESC

SELECT m0_.id AS id_0, m0_.is_model AS is_model_1, m0_.invitation_codes AS invitation_codes_2, m0_.user_id AS user_id_3, m0_.profile_id AS profile_id_4, m0_.manager_id AS manager_id_5, m0_.referred_by_id AS referred_by_id_6 FROM member m0_ LEFT JOIN `user` u1_ ON m0_.user_id = u1_.id WHERE m0_.is_model = 1 ORDER BY m0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
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 169)
7	App\Repository\MemberRepository->findDestacadosModelo (line 54)
8	App\Controller\HomeController->getModelosDestacados (line 28)
9	App\Controller\HomeController->homepage (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

25.77 ms

SELECT t0_.ref AS ref_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'value', t2_.value)) AS sclr_1 FROM text t0_ LEFT JOIN text_translation t2_ ON t0_.id = t2_.object_id LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id GROUP BY t0_.id ORDER BY t0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.ref AS ref_0,
  GROUP_CONCAT(
    JSON_OBJECT(
      'locale', l1_.locale, 'value', t2_.value
    )
  ) AS sclr_1
FROM
  text t0_
  LEFT JOIN text_translation t2_ ON t0_.id = t2_.object_id
  LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id
GROUP BY
  t0_.id
ORDER BY
  t0_.id DESC

SELECT t0_.ref AS ref_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'value', t2_.value)) AS sclr_1 FROM text t0_ LEFT JOIN text_translation t2_ ON t0_.id = t2_.object_id LEFT JOIN locale l1_ ON t2_.locale_id = l1_.id GROUP BY t0_.id ORDER BY t0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 116)
7	App\Repository\TextRepository->getTextos (line 92)
8	App\Service\QI->getTexts (line 82)
9	App\Service\QI->getText (line 434)
10	App\Service\QI->_ (line 25)
11	App\Twig\Extensions\TranslationExtension->translation (line 98)
12	__TwigTemplate_42d5ba28ea9125b1accc7728f84e7248->block_body (line 431)
13	Twig\Template->yieldBlock (line 82)
14	__TwigTemplate_a103ec0ce781912a8593058ffbe1aed2->doDisplay (line 387)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_42d5ba28ea9125b1accc7728f84e7248->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 35)
20	Twig\TemplateWrapper->render (line 320)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 30)
25	App\Controller\HomeController->homepage (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

49.94 ms

SELECT r0_.key_name AS key_name_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'valor', r2_.value)) AS sclr_1 FROM rich_text r0_ LEFT JOIN rich_text_translation r2_ ON r0_.id = r2_.object_id LEFT JOIN locale l1_ ON r2_.locale_id = l1_.id GROUP BY r0_.id ORDER BY r0_.id DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.key_name AS key_name_0,
  GROUP_CONCAT(
    JSON_OBJECT(
      'locale', l1_.locale, 'valor', r2_.value
    )
  ) AS sclr_1
FROM
  rich_text r0_
  LEFT JOIN rich_text_translation r2_ ON r0_.id = r2_.object_id
  LEFT JOIN locale l1_ ON r2_.locale_id = l1_.id
GROUP BY
  r0_.id
ORDER BY
  r0_.id DESC

SELECT r0_.key_name AS key_name_0, GROUP_CONCAT(JSON_OBJECT('locale', l1_.locale, 'valor', r2_.value)) AS sclr_1 FROM rich_text r0_ LEFT JOIN rich_text_translation r2_ ON r0_.id = r2_.object_id LEFT JOIN locale l1_ ON r2_.locale_id = l1_.id GROUP BY r0_.id ORDER BY r0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 90)
7	App\Repository\RichTextRepository->getTextos (line 107)
8	App\Service\QI->getTextosBig (line 98)
9	App\Service\QI->getTextoBig (line 439)
10	App\Service\QI->richTranslation (line 30)
11	App\Twig\Extensions\TranslationExtension->richTranslation (line 114)
12	__TwigTemplate_42d5ba28ea9125b1accc7728f84e7248->block_body (line 431)
13	Twig\Template->yieldBlock (line 82)
14	__TwigTemplate_a103ec0ce781912a8593058ffbe1aed2->doDisplay (line 387)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_42d5ba28ea9125b1accc7728f84e7248->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 35)
20	Twig\TemplateWrapper->render (line 320)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 30)
25	App\Controller\HomeController->homepage (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	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

Entities Mapping

Class	Mapping errors
App\Entity\Member	No errors.
App\Entity\User	The field App\Entity\User#member is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Member#user does not contain the required 'inversedBy="member"' attribute. The field App\Entity\User#studio is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Studio#user does not contain the required 'inversedBy="studio"' attribute.
App\Entity\Profile	No errors.
App\Entity\Studio	No errors.
App\Entity\Text	No errors.
App\Entity\TextTranslation	No errors.
App\Entity\Locale	No errors.
App\Entity\RichText	No errors.
App\Entity\RichTextTranslation	No errors.

Symfony Profiler

GET https://ztreamo.club/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping