Symfony Profiler

Query Metrics

75 Database Queries

9 Different statements

58.34 ms Query time

1 Invalid entities

154 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

14.42 ms
(24.72%)

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

10.56 ms
(18.10%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.created_at AS created_at_5, t0.last_login AS last_login_6, t0.nickname AS nickname_7, t0.enabled AS enabled_8, t0.last_time_online AS last_time_online_9, t0.balance AS balance_10, t0.destacado AS destacado_11, t0.accept_terms AS accept_terms_12, t0.studio_percentage AS studio_percentage_13, t0.birth_date AS birth_date_14, t0.confirmed_age AS confirmed_age_15, t0.profile_image_id AS profile_image_id_16, t17.id AS id_18, t17.is_model AS is_model_19, t17.invitation_codes AS invitation_codes_20, t17.user_id AS user_id_21, t17.profile_id AS profile_id_22, t17.manager_id AS manager_id_23, t17.referred_by_id AS referred_by_id_24, t25.id AS id_26, t25.name AS name_27, t25.user_id AS user_id_28, t25.logo_id AS logo_id_29, t0.archivo_id AS archivo_id_30 FROM `user` t0 LEFT JOIN member t17 ON t17.user_id = t0.id LEFT JOIN studio t25 ON t25.user_id = t0.id WHERE t0.id = ?

Parameters:

[
  137
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.roles AS roles_4,
  t0.created_at AS created_at_5,
  t0.last_login AS last_login_6,
  t0.nickname AS nickname_7,
  t0.enabled AS enabled_8,
  t0.last_time_online AS last_time_online_9,
  t0.balance AS balance_10,
  t0.destacado AS destacado_11,
  t0.accept_terms AS accept_terms_12,
  t0.studio_percentage AS studio_percentage_13,
  t0.birth_date AS birth_date_14,
  t0.confirmed_age AS confirmed_age_15,
  t0.profile_image_id AS profile_image_id_16,
  t17.id AS id_18,
  t17.is_model AS is_model_19,
  t17.invitation_codes AS invitation_codes_20,
  t17.user_id AS user_id_21,
  t17.profile_id AS profile_id_22,
  t17.manager_id AS manager_id_23,
  t17.referred_by_id AS referred_by_id_24,
  t25.id AS id_26,
  t25.name AS name_27,
  t25.user_id AS user_id_28,
  t25.logo_id AS logo_id_29,
  t0.archivo_id AS archivo_id_30
FROM
  `user` t0
  LEFT JOIN member t17 ON t17.user_id = t0.id
  LEFT JOIN studio t25 ON t25.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.roles AS roles_4, t0.created_at AS created_at_5, t0.last_login AS last_login_6, t0.nickname AS nickname_7, t0.enabled AS enabled_8, t0.last_time_online AS last_time_online_9, t0.balance AS balance_10, t0.destacado AS destacado_11, t0.accept_terms AS accept_terms_12, t0.studio_percentage AS studio_percentage_13, t0.birth_date AS birth_date_14, t0.confirmed_age AS confirmed_age_15, t0.profile_image_id AS profile_image_id_16, t17.id AS id_18, t17.is_model AS is_model_19, t17.invitation_codes AS invitation_codes_20, t17.user_id AS user_id_21, t17.profile_id AS profile_id_22, t17.manager_id AS manager_id_23, t17.referred_by_id AS referred_by_id_24, t25.id AS id_26, t25.name AS name_27, t25.user_id AS user_id_28, t25.logo_id AS logo_id_29, t0.archivo_id AS archivo_id_30 FROM `user` t0 LEFT JOIN member t17 ON t17.user_id = t0.id LEFT JOIN studio t25 ON t25.user_id = t0.id WHERE t0.id = 137;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\User::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\User->__get (line 120)
7	App\Entity\User->getProfileImage (line 270)
8	Twig\Extension\CoreExtension->getAttribute (line 1861)
9	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd::block_body (line 430)
10	Twig\Template->yieldBlock (line 431)
11	__TwigTemplate_a103ec0ce781912a8593058ffbe1aed2->doDisplay (line 82)
12	Twig\Template->yield (line 387)
13	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd->doDisplay (line 55)
14	Twig\Template->yield (line 387)
15	Twig\Template->display (line 343)
16	Twig\Template->render (line 358)
17	Twig\TemplateWrapper->render (line 35)
18	Twig\Environment->render (line 320)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
22	App\Controller\AuthController->appLogin (line 59)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
25	Symfony\Component\HttpKernel\Kernel->handle (line 185)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
27	require_once (line 29)
28	require_once (line 5)

8.65 ms
(14.82%)

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

7.69 ms
(13.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.bio AS bio_4, t0.phone_number AS phone_number_5, t0.birthday AS birthday_6, t0.description AS description_7, t8.id AS id_9, t8.is_model AS is_model_10, t8.invitation_codes AS invitation_codes_11, t8.user_id AS user_id_12, t8.profile_id AS profile_id_13, t8.manager_id AS manager_id_14, t8.referred_by_id AS referred_by_id_15, t0.country_id AS country_id_16 FROM profile t0 LEFT JOIN member t8 ON t8.profile_id = t0.id WHERE t0.id = ?

Parameters:

[
  112
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.bio AS bio_4,
  t0.phone_number AS phone_number_5,
  t0.birthday AS birthday_6,
  t0.description AS description_7,
  t8.id AS id_9,
  t8.is_model AS is_model_10,
  t8.invitation_codes AS invitation_codes_11,
  t8.user_id AS user_id_12,
  t8.profile_id AS profile_id_13,
  t8.manager_id AS manager_id_14,
  t8.referred_by_id AS referred_by_id_15,
  t0.country_id AS country_id_16
FROM
  profile t0
  LEFT JOIN member t8 ON t8.profile_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.bio AS bio_4, t0.phone_number AS phone_number_5, t0.birthday AS birthday_6, t0.description AS description_7, t8.id AS id_9, t8.is_model AS is_model_10, t8.invitation_codes AS invitation_codes_11, t8.user_id AS user_id_12, t8.profile_id AS profile_id_13, t8.manager_id AS manager_id_14, t8.referred_by_id AS referred_by_id_15, t0.country_id AS country_id_16 FROM profile t0 LEFT JOIN member t8 ON t8.profile_id = t0.id WHERE t0.id = 112;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Profile::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Profile->__get (line 120)
7	App\Entity\Profile->getSocialProfiles (line 208)
8	App\Entity\Profile->getRedes (line 235)
9	Twig\Extension\CoreExtension->getAttribute (line 1861)
10	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd::block_body (line 450)
11	Twig\Template->yieldBlock (line 431)
12	__TwigTemplate_a103ec0ce781912a8593058ffbe1aed2->doDisplay (line 82)
13	Twig\Template->yield (line 387)
14	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd->doDisplay (line 55)
15	Twig\Template->yield (line 387)
16	Twig\Template->display (line 343)
17	Twig\Template->render (line 358)
18	Twig\TemplateWrapper->render (line 35)
19	Twig\Environment->render (line 320)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\AuthController->appLogin (line 59)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 185)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

5.64 ms
(9.67%)

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\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\MemberRepository->findDestacadosModelo (line 181)
7	App\Controller\AuthController->appLogin (line 47)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

5.14 ms
(8.81%)

SELECT t0.id AS id_1, t0.valor AS valor_2, t0.profile_id AS profile_id_3, t0.red_id AS red_id_4 FROM social_profile t0 WHERE t0.profile_id = ?

Parameters:

[
  112
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.valor AS valor_2,
  t0.profile_id AS profile_id_3,
  t0.red_id AS red_id_4
FROM
  social_profile t0
WHERE
  t0.profile_id = ?

SELECT t0.id AS id_1, t0.valor AS valor_2, t0.profile_id AS profile_id_3, t0.red_id AS red_id_4 FROM social_profile t0 WHERE t0.profile_id = 112;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1790)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2722)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->count (line 39)
7	Doctrine\ORM\PersistentCollection->count (line 391)
8	count (line 235)
9	App\Entity\Profile::getRedes (line 235)
10	Twig\Extension\CoreExtension->getAttribute (line 1861)
11	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd::block_body (line 450)
12	Twig\Template->yieldBlock (line 431)
13	__TwigTemplate_a103ec0ce781912a8593058ffbe1aed2->doDisplay (line 82)
14	Twig\Template->yield (line 387)
15	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd->doDisplay (line 55)
16	Twig\Template->yield (line 387)
17	Twig\Template->display (line 343)
18	Twig\Template->render (line 358)
19	Twig\TemplateWrapper->render (line 35)
20	Twig\Environment->render (line 320)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
24	App\Controller\AuthController->appLogin (line 59)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
27	Symfony\Component\HttpKernel\Kernel->handle (line 185)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
29	require_once (line 29)
30	require_once (line 5)

4.26 ms
(7.30%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.visible AS visible_7, t0.orden AS orden_8, t0.ref AS ref_9, t0.size AS size_10, t0.gallery_id AS gallery_id_11 FROM image t0 WHERE t0.id = ?

Parameters:

[
  408
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.path AS path_3,
  t0.link AS link_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.visible AS visible_7,
  t0.orden AS orden_8,
  t0.ref AS ref_9,
  t0.size AS size_10,
  t0.gallery_id AS gallery_id_11
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.path AS path_3, t0.link AS link_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.visible AS visible_7, t0.orden AS orden_8, t0.ref AS ref_9, t0.size AS size_10, t0.gallery_id AS gallery_id_11 FROM image t0 WHERE t0.id = 408;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Image::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Image->__get (line 120)
7	App\Entity\Image->getFilename (line 94)
8	App\Service\Google\SignedUrlGenerator->generateSignedUrlFromEntity (line 35)
9	Twig\Extension\CoreExtension->getAttribute (line 1861)
10	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd::block_body (line 430)
11	Twig\Template->yieldBlock (line 431)
12	__TwigTemplate_a103ec0ce781912a8593058ffbe1aed2->doDisplay (line 82)
13	Twig\Template->yield (line 387)
14	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd->doDisplay (line 55)
15	Twig\Template->yield (line 387)
16	Twig\Template->display (line 343)
17	Twig\Template->render (line 358)
18	Twig\TemplateWrapper->render (line 35)
19	Twig\Environment->render (line 320)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
23	App\Controller\AuthController->appLogin (line 59)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 185)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

1.27 ms
(2.18%)

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.visible AS visible_3, t0.orden AS orden_4, t0.dominio AS dominio_5, t0.icono_id AS icono_id_6 FROM social t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nombre AS nombre_2,
  t0.visible AS visible_3,
  t0.orden AS orden_4,
  t0.dominio AS dominio_5,
  t0.icono_id AS icono_id_6
FROM
  social t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nombre AS nombre_2, t0.visible AS visible_3, t0.orden AS orden_4, t0.dominio AS dominio_5, t0.icono_id AS icono_id_6 FROM social t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\Proxy\ProxyFactory->Doctrine\ORM\Proxy\{closure} (line 289)
4	Proxies\__CG__\App\Entity\Social::Doctrine\ORM\Proxy\{closure} (line 367)
5	Symfony\Component\VarExporter\Internal\LazyObjectState::initialize (line 61)
6	Proxies\__CG__\App\Entity\Social->__get (line 120)
7	App\Entity\Social->isVisible (line 63)
8	App\Entity\Profile->App\Entity\{closure} (line 238)
9	array_filter (line 237)
10	App\Entity\Profile::getRedes (line 237)
11	Twig\Extension\CoreExtension->getAttribute (line 1861)
12	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd::block_body (line 450)
13	Twig\Template->yieldBlock (line 431)
14	__TwigTemplate_a103ec0ce781912a8593058ffbe1aed2->doDisplay (line 82)
15	Twig\Template->yield (line 387)
16	__TwigTemplate_7e7d0789e31dfecde0e912ebb590f5fd->doDisplay (line 55)
17	Twig\Template->yield (line 387)
18	Twig\Template->display (line 343)
19	Twig\Template->render (line 358)
20	Twig\TemplateWrapper->render (line 35)
21	Twig\Environment->render (line 320)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
25	App\Controller\AuthController->appLogin (line 59)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 185)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 29)
31	require_once (line 5)

0.72 ms
(1.23%)

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\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getResult (line 689)
6	App\Repository\MemberRepository->findDestacadosModelo (line 181)
7	App\Controller\AuthController->appLogin (line 50)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 185)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	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\Member	38
App\Entity\User	38
App\Entity\Profile	37
App\Entity\Image	11
App\Entity\File	9
App\Entity\SocialProfile	8
App\Entity\Studio	6
App\Entity\Social	4
App\Entity\Country	3

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\Relationship	No errors.
App\Entity\Post	No errors.
App\Entity\PurchasedPost	No errors.
App\Entity\Payment	No errors.
App\Entity\Message	No errors.
App\Entity\PostLike	No errors.
App\Entity\PostComment	No errors.
App\Entity\Blog	No errors.
App\Entity\RichText	No errors.
App\Entity\RichTextTranslation	No errors.
App\Entity\Locale	No errors.
App\Entity\Text	No errors.
App\Entity\TextTranslation	No errors.
App\Entity\Image	No errors.
App\Entity\File	No errors.
App\Entity\SupportRequest	No errors.
App\Entity\Notification	No errors.
App\Entity\Billetera\SolicitudPago	No errors.
App\Entity\Gallery	No errors.
App\Entity\ImageTranslation	No errors.
App\Entity\Seo	No errors.
App\Entity\Social	No errors.
App\Entity\Country	No errors.
App\Entity\ProfileFormData	No errors.
App\Entity\SocialProfile	No errors.

Symfony Profiler

GET https://ztreamo.iridian.co/app/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping