Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.54 ms Query time

0 Invalid entities

102 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

1.54 ms
(43.57%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.content_type AS content_type_3, t0.content_title AS content_title_4, t0.content_sub_title AS content_sub_title_5, t0.content_description AS content_description_6, t0.page_id AS page_id_7 FROM page_block t0 WHERE t0.page_id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.content_type AS content_type_3,
  t0.content_title AS content_title_4,
  t0.content_sub_title AS content_sub_title_5,
  t0.content_description AS content_description_6,
  t0.page_id AS page_id_7
FROM
  page_block t0
WHERE
  t0.page_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.content_type AS content_type_3, t0.content_title AS content_title_4, t0.content_sub_title AS content_sub_title_5, t0.content_description AS content_description_6, t0.page_id AS page_id_7 FROM page_block t0 WHERE t0.page_id = 16;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 506)
4	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadOneToManyCollection (line 2706)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
7	Doctrine\ORM\PersistentCollection->initialize (line 237)
8	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 31)
9	App\Service\PageBlockManager->getPageBlock (line 43)
10	App\Controller\UserSubscriptionController->subscriptionIndex (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.13 ms
(31.86%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.target AS target_4, t0.menu_id AS menu_id_5, t0.page_id AS page_id_6 FROM menu_item t0 WHERE t0.menu_id = ?

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.url AS url_3,
  t0.target AS target_4,
  t0.menu_id AS menu_id_5,
  t0.page_id AS page_id_6
FROM
  menu_item t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.target AS target_4, t0.menu_id AS menu_id_5, t0.page_id AS page_id_6 FROM menu_item t0 WHERE t0.menu_id = 8;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1842)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1787)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 506)
4	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadOneToManyCollection (line 2706)
5	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
6	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
7	Doctrine\ORM\PersistentCollection->initialize (line 157)
8	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 40)
9	App\Service\MenuManager->getMenuItemsByPosition (line 28)
10	App\Twig\MenuExtension->getMenu (line 48)
11	__TwigTemplate_5e727e9d30a43d20e1a121a1325dc7d4->doDisplay (line 388)
12	Twig\Template->yield (line 66)
13	__TwigTemplate_011e771c2f9850cef005b8942bc71348->doDisplay (line 388)
14	Twig\Template->yield (line 62)
15	__TwigTemplate_da51aa96b5cb76dfa5b82847df5f468e->doDisplay (line 388)
16	Twig\Template->yield (line 143)
17	__TwigTemplate_417e47180f868c41a4acb596461967bb->doDisplay (line 388)
18	Twig\Template->yield (line 58)
19	__TwigTemplate_9d87aaad1b0f9d72ca3e664e79129931->doDisplay (line 388)
20	Twig\Template->yield (line 52)
21	__TwigTemplate_7f0275c89629006e4098a2f58ea37333->doDisplay (line 388)
22	Twig\Template->yield (line 344)
23	Twig\Template->display (line 359)
24	Twig\Template->render (line 51)
25	Twig\TemplateWrapper->render (line 334)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 47)
30	App\Controller\UserSubscriptionController->subscriptionIndex (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.87 ms
(24.57%)

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.price AS price_3, s0_.max_session_number AS max_session_number_4, s0_.is_active AS is_active_5, s0_.month_validity AS month_validity_6, s0_.created_at AS created_at_7 FROM subscription s0_ WHERE s0_.is_active = 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.title AS title_1,
  s0_.description AS description_2,
  s0_.price AS price_3,
  s0_.max_session_number AS max_session_number_4,
  s0_.is_active AS is_active_5,
  s0_.month_validity AS month_validity_6,
  s0_.created_at AS created_at_7
FROM
  subscription s0_
WHERE
  s0_.is_active = 1

SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.description AS description_2, s0_.price AS price_3, s0_.max_session_number AS max_session_number_4, s0_.is_active AS is_active_5, s0_.month_validity AS month_validity_6, s0_.created_at AS created_at_7 FROM subscription s0_ WHERE s0_.is_active = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 907)
2	Doctrine\DBAL\Connection->fetchAllAssociative (line 1157)
3	Doctrine\DBAL\Connection->executeCacheQuery (line 1084)
4	Doctrine\DBAL\Connection->executeQuery (line 27)
5	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
6	Doctrine\ORM\Query->_doExecute (line 935)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 689)
9	Doctrine\ORM\AbstractQuery->getResult (line 127)
10	App\Repository\AbstractRepository->findAllActiveWithCache (line 45)
11	App\Service\PageBlockManager->getPageBlock (line 43)
12	App\Controller\UserSubscriptionController->subscriptionIndex (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	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

102 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
app_entity_settings	86
app_entity_subscription	6
app_entity_page	6
app_entity_menu	4

Entities Mapping

Class	Mapping errors
App\Entity\Settings	No errors.
App\Entity\Page	No errors.
App\Entity\Subscription	No errors.
App\Entity\UserSubscription	No errors.
App\Entity\PageBlock	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuItem	No errors.

Symfony Profiler

GET https://www.dev.lacaserne-juniville.fr/nos-abonnements

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Entities Mapping