Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

5.61 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.82 ms
(50.29%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.icon AS icon_4, t0.styles AS styles_5, t0.scripts AS scripts_6, t0.meta AS meta_7, t0.is_canonical AS is_canonical_8, t0.is_robot_index AS is_robot_index_9, t0.is_robot_follow AS is_robot_follow_10, t0.is_published AS is_published_11, t0.label AS label_12, t0.description AS description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.text AS text_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.page_id AS page_id_21 FROM pages t0 LEFT JOIN text_editabled t16 ON t16.page_id = t0.id WHERE t0.url = ? LIMIT 1

Parameters:

[
  "app_login"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.icon AS icon_4,
  t0.styles AS styles_5,
  t0.scripts AS scripts_6,
  t0.meta AS meta_7,
  t0.is_canonical AS is_canonical_8,
  t0.is_robot_index AS is_robot_index_9,
  t0.is_robot_follow AS is_robot_follow_10,
  t0.is_published AS is_published_11,
  t0.label AS label_12,
  t0.description AS description_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t16.id AS id_17,
  t16.text AS text_18,
  t16.created_at AS created_at_19,
  t16.updated_at AS updated_at_20,
  t16.page_id AS page_id_21
FROM
  pages t0
  LEFT JOIN text_editabled t16 ON t16.page_id = t0.id
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.icon AS icon_4, t0.styles AS styles_5, t0.scripts AS scripts_6, t0.meta AS meta_7, t0.is_canonical AS is_canonical_8, t0.is_robot_index AS is_robot_index_9, t0.is_robot_follow AS is_robot_follow_10, t0.is_published AS is_published_11, t0.label AS label_12, t0.description AS description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.text AS text_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.page_id AS page_id_21 FROM pages t0 LEFT JOIN text_editabled t16 ON t16.page_id = t0.id WHERE t0.url = 'app_login' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 26)
5	App\Service\ModulesService->get (line 54)
6	App\Service\ContentsModulesManageService->getModules (line 161)
7	App\Service\ContentsModulesManageService->getParamPage (line 31)
8	App\Controller\RegistrationController->register (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.69 ms
(12.26%)

SELECT t0.id AS id_1, t0.highlight_title AS highlight_title_2, t0.title AS title_3, t0.label_cta AS label_cta_4, t0.cover_image AS cover_image_5, t0.position AS position_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.page_id AS page_id_10 FROM mod_img_full_page t0 WHERE t0.page_id = ? ORDER BY t0.position ASC

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.highlight_title AS highlight_title_2,
  t0.title AS title_3,
  t0.label_cta AS label_cta_4,
  t0.cover_image AS cover_image_5,
  t0.position AS position_6,
  t0.name AS name_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.page_id AS page_id_10
FROM
  mod_img_full_page t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.highlight_title AS highlight_title_2, t0.title AS title_3, t0.label_cta AS label_cta_4, t0.cover_image AS cover_image_5, t0.position AS position_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.page_id AS page_id_10 FROM mod_img_full_page t0 WHERE t0.page_id = 8 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 27)
5	App\Service\ModulesService->get (line 54)
6	App\Service\ContentsModulesManageService->getModules (line 161)
7	App\Service\ContentsModulesManageService->getParamPage (line 31)
8	App\Controller\RegistrationController->register (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.61 ms
(10.90%)

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.icon AS icon_4, t0.styles AS styles_5, t0.scripts AS scripts_6, t0.meta AS meta_7, t0.is_canonical AS is_canonical_8, t0.is_robot_index AS is_robot_index_9, t0.is_robot_follow AS is_robot_follow_10, t0.is_published AS is_published_11, t0.label AS label_12, t0.description AS description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.text AS text_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.page_id AS page_id_21 FROM pages t0 LEFT JOIN text_editabled t16 ON t16.page_id = t0.id WHERE t0.is_published = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.icon AS icon_4,
  t0.styles AS styles_5,
  t0.scripts AS scripts_6,
  t0.meta AS meta_7,
  t0.is_canonical AS is_canonical_8,
  t0.is_robot_index AS is_robot_index_9,
  t0.is_robot_follow AS is_robot_follow_10,
  t0.is_published AS is_published_11,
  t0.label AS label_12,
  t0.description AS description_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t16.id AS id_17,
  t16.text AS text_18,
  t16.created_at AS created_at_19,
  t16.updated_at AS updated_at_20,
  t16.page_id AS page_id_21
FROM
  pages t0
  LEFT JOIN text_editabled t16 ON t16.page_id = t0.id
WHERE
  t0.is_published = ?

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.icon AS icon_4, t0.styles AS styles_5, t0.scripts AS scripts_6, t0.meta AS meta_7, t0.is_canonical AS is_canonical_8, t0.is_robot_index AS is_robot_index_9, t0.is_robot_follow AS is_robot_follow_10, t0.is_published AS is_published_11, t0.label AS label_12, t0.description AS description_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.text AS text_18, t16.created_at AS created_at_19, t16.updated_at AS updated_at_20, t16.page_id AS page_id_21 FROM pages t0 LEFT JOIN text_editabled t16 ON t16.page_id = t0.id WHERE t0.is_published = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 163)
5	App\Service\ContentsModulesManageService->getParamPage (line 31)
6	App\Controller\RegistrationController->register (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.53 ms
(9.40%)

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.title AS title_3, t0.description AS description_4, t0.meta AS meta_5, t0.script AS script_6, t0.style AS style_7, t0.icon AS icon_8, t0.facebook AS facebook_9, t0.instagram AS instagram_10, t0.youtube AS youtube_11, t0.twitter AS twitter_12, t0.adresse AS adresse_13, t0.mail AS mail_14, t0.phone AS phone_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM param_site t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.logo AS logo_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.meta AS meta_5,
  t0.script AS script_6,
  t0.style AS style_7,
  t0.icon AS icon_8,
  t0.facebook AS facebook_9,
  t0.instagram AS instagram_10,
  t0.youtube AS youtube_11,
  t0.twitter AS twitter_12,
  t0.adresse AS adresse_13,
  t0.mail AS mail_14,
  t0.phone AS phone_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17
FROM
  param_site t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.logo AS logo_2, t0.title AS title_3, t0.description AS description_4, t0.meta AS meta_5, t0.script AS script_6, t0.style AS style_7, t0.icon AS icon_8, t0.facebook AS facebook_9, t0.instagram AS instagram_10, t0.youtube AS youtube_11, t0.twitter AS twitter_12, t0.adresse AS adresse_13, t0.mail AS mail_14, t0.phone AS phone_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM param_site t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 165)
7	App\Service\ContentsModulesManageService->getParamPage (line 31)
8	App\Controller\RegistrationController->register (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.52 ms
(9.33%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.cover_image AS cover_image_3, t0.position AS position_4, t0.name AS name_5, t0.label_cta AS label_cta_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.page_id AS page_id_9 FROM mod_offers t0 WHERE t0.page_id = ? ORDER BY t0.position ASC

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.cover_image AS cover_image_3,
  t0.position AS position_4,
  t0.name AS name_5,
  t0.label_cta AS label_cta_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.page_id AS page_id_9
FROM
  mod_offers t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.cover_image AS cover_image_3, t0.position AS position_4, t0.name AS name_5, t0.label_cta AS label_cta_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.page_id AS page_id_9 FROM mod_offers t0 WHERE t0.page_id = 8 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 948)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 30)
5	App\Service\ModulesService->get (line 54)
6	App\Service\ContentsModulesManageService->getModules (line 161)
7	App\Service\ContentsModulesManageService->getParamPage (line 31)
8	App\Controller\RegistrationController->register (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.44 ms
(7.81%)

SELECT t0.id AS id_1, t0.text AS text_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.page_id AS page_id_5 FROM text_editabled t0 WHERE t0.page_id = ? LIMIT 1

Parameters:

[
  8
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.text AS text_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.page_id AS page_id_5
FROM
  text_editabled t0
WHERE
  t0.page_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.text AS text_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.page_id AS page_id_5 FROM text_editabled t0 WHERE t0.page_id = 8 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 41)
5	App\Service\ContentService->get (line 48)
6	App\Service\ContentsModulesManageService->getContents (line 162)
7	App\Service\ContentsModulesManageService->getParamPage (line 31)
8	App\Controller\RegistrationController->register (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (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\Pages	6
App\Entity\TextEditabled	2
App\Entity\ParamSite	1

Entities Mapping

Class	Mapping errors
App\Entity\Pages	No errors.
App\Entity\TextEditabled	No errors.
App\Entity\ModImgFullPage	No errors.
App\Entity\ModOffers	No errors.
App\Entity\ParamSite	No errors.
App\Entity\User	No errors.

Symfony Profiler

GET https://preprod.hk-groupe.fr/inscription

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping