Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

50.83 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

#▲

Time

Info

12.38 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 91)
8	App\Service\QI->getTexts (line 81)
9	App\Service\QI->getText (line 424)
10	App\Service\QI->_ (line 25)
11	App\Twig\Extensions\TranslationExtension->translation (line 97)
12	__TwigTemplate_6b4c048d206b4e6d6967caeb5e85d062->block_body (line 432)
13	Twig\Template->yieldBlock (line 82)
14	__TwigTemplate_3310c9a144b7d125e07c8f41f78a5022->doDisplay (line 388)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_6b4c048d206b4e6d6967caeb5e85d062->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
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 27)
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)

38.45 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 106)
8	App\Service\QI->getTextosBig (line 97)
9	App\Service\QI->getTextoBig (line 429)
10	App\Service\QI->richTranslation (line 30)
11	App\Twig\Extensions\TranslationExtension->richTranslation (line 109)
12	__TwigTemplate_6b4c048d206b4e6d6967caeb5e85d062->block_body (line 432)
13	Twig\Template->yieldBlock (line 82)
14	__TwigTemplate_3310c9a144b7d125e07c8f41f78a5022->doDisplay (line 388)
15	Twig\Template->yield (line 53)
16	__TwigTemplate_6b4c048d206b4e6d6967caeb5e85d062->doDisplay (line 388)
17	Twig\Template->yield (line 344)
18	Twig\Template->display (line 359)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 334)
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 27)
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\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.iridian.co/

Configuration Settings

Theme

Page Width