Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

1.41 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.47 ms

SELECT h0_.id AS id_0, h0_.created_at AS created_at_1, h0_.updated_at AS updated_at_2, h0_.photo_path AS photo_path_3, h0_.video_url AS video_url_4, h1_.id AS id_5, h1_.title AS title_6, h1_.slug AS slug_7, h1_.meta_title AS meta_title_8, h1_.meta_description AS meta_description_9, h1_.body AS body_10, h1_.locale AS locale_11, h1_.translatable_id AS translatable_id_12 FROM home h0_ LEFT JOIN home_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.slug = ? AND h1_.locale = ?

Parameters:

[
  "accueil"
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.created_at AS created_at_1,
  h0_.updated_at AS updated_at_2,
  h0_.photo_path AS photo_path_3,
  h0_.video_url AS video_url_4,
  h1_.id AS id_5,
  h1_.title AS title_6,
  h1_.slug AS slug_7,
  h1_.meta_title AS meta_title_8,
  h1_.meta_description AS meta_description_9,
  h1_.body AS body_10,
  h1_.locale AS locale_11,
  h1_.translatable_id AS translatable_id_12
FROM
  home h0_
  LEFT JOIN home_translation h1_ ON h0_.id = h1_.translatable_id
WHERE
  h1_.slug = ?
  AND h1_.locale = ?

SELECT h0_.id AS id_0, h0_.created_at AS created_at_1, h0_.updated_at AS updated_at_2, h0_.photo_path AS photo_path_3, h0_.video_url AS video_url_4, h1_.id AS id_5, h1_.title AS title_6, h1_.slug AS slug_7, h1_.meta_title AS meta_title_8, h1_.meta_description AS meta_description_9, h1_.body AS body_10, h1_.locale AS locale_11, h1_.translatable_id AS translatable_id_12 FROM home h0_ LEFT JOIN home_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.slug = 'accueil' AND h1_.locale = 'fr';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 959)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 30)
7	App\Repository\HomeRepository->findByHome (line 19)
8	App\Controller\HomeController->home (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.34 ms

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.content AS content_4, t0.content2 AS content2_5, t0.content3 AS content3_6, t0.content4 AS content4_7, t0.image_path AS image_path_8, t0.push_button_label AS push_button_label_9, t0.push_button_url AS push_button_url_10, t0.push_button_new_tab AS push_button_new_tab_11, t0.video_url AS video_url_12, t0.updated_at AS updated_at_13, t0.position AS position_14, t0.alt AS alt_15, t0.article_translation_id AS article_translation_id_16, t0.home_translation_id AS home_translation_id_17, t0.page_translation_id AS page_translation_id_18 FROM block t0 WHERE t0.home_translation_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.content2 AS content2_5,
  t0.content3 AS content3_6,
  t0.content4 AS content4_7,
  t0.image_path AS image_path_8,
  t0.push_button_label AS push_button_label_9,
  t0.push_button_url AS push_button_url_10,
  t0.push_button_new_tab AS push_button_new_tab_11,
  t0.video_url AS video_url_12,
  t0.updated_at AS updated_at_13,
  t0.position AS position_14,
  t0.alt AS alt_15,
  t0.article_translation_id AS article_translation_id_16,
  t0.home_translation_id AS home_translation_id_17,
  t0.page_translation_id AS page_translation_id_18
FROM
  block t0
WHERE
  t0.home_translation_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.content AS content_4, t0.content2 AS content2_5, t0.content3 AS content3_6, t0.content4 AS content4_7, t0.image_path AS image_path_8, t0.push_button_label AS push_button_label_9, t0.push_button_url AS push_button_url_10, t0.push_button_new_tab AS push_button_new_tab_11, t0.video_url AS video_url_12, t0.updated_at AS updated_at_13, t0.position AS position_14, t0.alt AS alt_15, t0.article_translation_id AS article_translation_id_16, t0.home_translation_id AS home_translation_id_17, t0.page_translation_id AS page_translation_id_18 FROM block t0 WHERE t0.home_translation_id = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1885)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3307)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 24)
7	App\Controller\HomeController->home (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.31 ms

SELECT h0_.id AS id_0, h0_.external AS external_1, h0_.weight AS weight_2, h1_.id AS id_3, h1_.label AS label_4, h1_.url AS url_5, h1_.locale AS locale_6, h1_.translatable_id AS translatable_id_7 FROM header_link h0_ LEFT JOIN header_link_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.locale = ? ORDER BY h0_.weight ASC

Parameters:

[
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  h0_.id AS id_0,
  h0_.external AS external_1,
  h0_.weight AS weight_2,
  h1_.id AS id_3,
  h1_.label AS label_4,
  h1_.url AS url_5,
  h1_.locale AS locale_6,
  h1_.translatable_id AS translatable_id_7
FROM
  header_link h0_
  LEFT JOIN header_link_translation h1_ ON h0_.id = h1_.translatable_id
WHERE
  h1_.locale = ?
ORDER BY
  h0_.weight ASC

SELECT h0_.id AS id_0, h0_.external AS external_1, h0_.weight AS weight_2, h1_.id AS id_3, h1_.label AS label_4, h1_.url AS url_5, h1_.locale AS locale_6, h1_.translatable_id AS translatable_id_7 FROM header_link h0_ LEFT JOIN header_link_translation h1_ ON h0_.id = h1_.translatable_id WHERE h1_.locale = 'fr' ORDER BY h0_.weight ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 25)
7	App\Repository\HeaderLinkRepository->findByLocale (line 114)
8	App\Controller\DefaultController->renderHeader (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 335)
16	__TwigTemplate_48f77575d38223b9c3d6b7933aeef725->block_content (line 446)
17	Twig\Template->yieldBlock (line 172)
18	__TwigTemplate_48f77575d38223b9c3d6b7933aeef725->doDisplay (line 402)
19	Twig\Template->yield (line 53)
20	__TwigTemplate_17306400048e65329e38c671ccaa51ef->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
29	App\Controller\HomeController->home (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.29 ms

SELECT f0_.id AS id_0, f0_.footer_column AS footer_column_1, f0_.external AS external_2, f0_.weight AS weight_3, f1_.id AS id_4, f1_.label AS label_5, f1_.url AS url_6, f1_.locale AS locale_7, f1_.translatable_id AS translatable_id_8 FROM footer_link f0_ LEFT JOIN footer_link_translation f1_ ON f0_.id = f1_.translatable_id WHERE f1_.locale = ? ORDER BY f0_.footer_column ASC, f0_.weight ASC

Parameters:

[
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.footer_column AS footer_column_1,
  f0_.external AS external_2,
  f0_.weight AS weight_3,
  f1_.id AS id_4,
  f1_.label AS label_5,
  f1_.url AS url_6,
  f1_.locale AS locale_7,
  f1_.translatable_id AS translatable_id_8
FROM
  footer_link f0_
  LEFT JOIN footer_link_translation f1_ ON f0_.id = f1_.translatable_id
WHERE
  f1_.locale = ?
ORDER BY
  f0_.footer_column ASC,
  f0_.weight ASC

SELECT f0_.id AS id_0, f0_.footer_column AS footer_column_1, f0_.external AS external_2, f0_.weight AS weight_3, f1_.id AS id_4, f1_.label AS label_5, f1_.url AS url_6, f1_.locale AS locale_7, f1_.translatable_id AS translatable_id_8 FROM footer_link f0_ LEFT JOIN footer_link_translation f1_ ON f0_.id = f1_.translatable_id WHERE f1_.locale = 'fr' ORDER BY f0_.footer_column ASC, f0_.weight ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 29)
7	App\Repository\FooterLinkRepository->findByLocaleGroupedByColumn (line 73)
8	App\Controller\DefaultController->renderFooter (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 78)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 83)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 47)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 44)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 177)
16	__TwigTemplate_48f77575d38223b9c3d6b7933aeef725->doDisplay (line 402)
17	Twig\Template->yield (line 53)
18	__TwigTemplate_17306400048e65329e38c671ccaa51ef->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 448)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
27	App\Controller\HomeController->home (line 181)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	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\Home	1
App\Entity\HomeTranslation	1

Entities Mapping

Class	Mapping errors
App\Entity\Home	No errors.
App\Entity\HomeTranslation	No errors.
App\Entity\Block	No errors.
App\Entity\Article	No errors.
App\Entity\ArticleTranslation	No errors.
App\Entity\Page	No errors.
App\Entity\PageTranslation	No errors.
App\Entity\HeaderLink	No errors.
App\Entity\HeaderLinkTranslation	No errors.
App\Entity\BlockImage	No errors.
App\Entity\BlockQuotation	No errors.
App\Entity\BlockTeamMember	No errors.
App\Entity\Theme	No errors.
App\Entity\ThemeTranslation	No errors.
App\Entity\FooterLink	No errors.
App\Entity\Device	No errors.
App\Entity\Measurement	No errors.
App\Entity\User	No errors.
App\Entity\FooterLinkTranslation	No errors.
App\Entity\Sensor	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://prod.smile-air.fr/fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping