Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

5.06 ms Query time

0 Invalid entities

10 Managed entities

11 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

#▲

Time

Info

1.83 ms

SELECT f0_.id AS id_0, f0_.theme AS theme_1, f0_.title AS title_2, f0_.content AS content_3, f0_.visibility AS visibility_4, f0_.priority AS priority_5, f0_.sector_id AS sector_id_6 FROM faq f0_ WHERE (f0_.sector_id = ? OR f0_.sector_id IS NULL) GROUP BY f0_.theme

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.theme AS theme_1,
  f0_.title AS title_2,
  f0_.content AS content_3,
  f0_.visibility AS visibility_4,
  f0_.priority AS priority_5,
  f0_.sector_id AS sector_id_6
FROM
  faq f0_
WHERE
  (
    f0_.sector_id = ?
    OR f0_.sector_id IS NULL
  )
GROUP BY
  f0_.theme

SELECT f0_.id AS id_0, f0_.theme AS theme_1, f0_.title AS title_2, f0_.content AS content_3, f0_.visibility AS visibility_4, f0_.priority AS priority_5, f0_.sector_id AS sector_id_6 FROM faq f0_ WHERE (f0_.sector_id = NULL OR f0_.sector_id IS NULL) GROUP BY f0_.theme;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\FaqRepository->getThemes (line 31)
7	App\Controller\HomeController->faq (line 338)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

1.07 ms

SELECT f0_.id AS id_0, f0_.theme AS theme_1, f0_.title AS title_2, f0_.content AS content_3, f0_.visibility AS visibility_4, f0_.priority AS priority_5, f0_.sector_id AS sector_id_6 FROM faq f0_ WHERE ((f0_.sector_id = ? OR f0_.sector_id IS NULL)) AND f0_.visibility = 1 ORDER BY f0_.sector_id ASC, f0_.title ASC

Parameters:

[
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.theme AS theme_1,
  f0_.title AS title_2,
  f0_.content AS content_3,
  f0_.visibility AS visibility_4,
  f0_.priority AS priority_5,
  f0_.sector_id AS sector_id_6
FROM
  faq f0_
WHERE
  (
    (
      f0_.sector_id = ?
      OR f0_.sector_id IS NULL
    )
  )
  AND f0_.visibility = 1
ORDER BY
  f0_.sector_id ASC,
  f0_.title ASC

SELECT f0_.id AS id_0, f0_.theme AS theme_1, f0_.title AS title_2, f0_.content AS content_3, f0_.visibility AS visibility_4, f0_.priority AS priority_5, f0_.sector_id AS sector_id_6 FROM faq f0_ WHERE ((f0_.sector_id = NULL OR f0_.sector_id IS NULL)) AND f0_.visibility = 1 ORDER BY f0_.sector_id ASC, f0_.title ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\FaqRepository->getFaqs (line 50)
7	App\Controller\HomeController->faq (line 339)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
10	Symfony\Component\HttpKernel\Kernel->handle (line 143)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
12	require_once (line 32)
13	require_once (line 5)

1.39 ms

SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.role AS role_19, t1.entrance_code AS entrance_code_20, t1.entrance_code_date AS entrance_code_date_21, t1.sector_id AS sector_id_22, t2.password_save AS password_save_23, t2.documents AS documents_24, t2.diploma AS diploma_25, t2.tutorial_completed AS tutorial_completed_26, t2.cohort_id AS cohort_id_27, t3.role AS role_28, t3.entrance_code AS entrance_code_29, t3.entrance_code_date AS entrance_code_date_30, t3.responsible_id AS responsible_id_31, t4.role AS role_32, t4.entrance_code AS entrance_code_33, t4.entrance_code_date AS entrance_code_date_34, t4.coordinator_id AS coordinator_id_35 FROM user t0 LEFT JOIN responsible t1 ON t0.id = t1.id LEFT JOIN trainee t2 ON t0.id = t2.id LEFT JOIN coordinator t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_5,
  t0.username AS username_6,
  t0.last_name AS last_name_7,
  t0.first_name AS first_name_8,
  t0.roles AS roles_9,
  t0.password AS password_10,
  t0.email AS email_11,
  t0.activated AS activated_12,
  t0.tmp_code AS tmp_code_13,
  t0.tmp_code_date AS tmp_code_date_14,
  t0.signature AS signature_15,
  t0.uuid AS uuid_16,
  t0.phone_number AS phone_number_17,
  t0.avatar_id AS avatar_id_18,
  t0.dtype,
  t1.role AS role_19,
  t1.entrance_code AS entrance_code_20,
  t1.entrance_code_date AS entrance_code_date_21,
  t1.sector_id AS sector_id_22,
  t2.password_save AS password_save_23,
  t2.documents AS documents_24,
  t2.diploma AS diploma_25,
  t2.tutorial_completed AS tutorial_completed_26,
  t2.cohort_id AS cohort_id_27,
  t3.role AS role_28,
  t3.entrance_code AS entrance_code_29,
  t3.entrance_code_date AS entrance_code_date_30,
  t3.responsible_id AS responsible_id_31,
  t4.role AS role_32,
  t4.entrance_code AS entrance_code_33,
  t4.entrance_code_date AS entrance_code_date_34,
  t4.coordinator_id AS coordinator_id_35
FROM
  user t0
  LEFT JOIN responsible t1 ON t0.id = t1.id
  LEFT JOIN trainee t2 ON t0.id = t2.id
  LEFT JOIN coordinator t3 ON t0.id = t3.id
  LEFT JOIN trainer t4 ON t0.id = t4.id
WHERE
  t0.id = ?

SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.role AS role_19, t1.entrance_code AS entrance_code_20, t1.entrance_code_date AS entrance_code_date_21, t1.sector_id AS sector_id_22, t2.password_save AS password_save_23, t2.documents AS documents_24, t2.diploma AS diploma_25, t2.tutorial_completed AS tutorial_completed_26, t2.cohort_id AS cohort_id_27, t3.role AS role_28, t3.entrance_code AS entrance_code_29, t3.entrance_code_date AS entrance_code_date_30, t3.responsible_id AS responsible_id_31, t4.role AS role_32, t4.entrance_code AS entrance_code_33, t4.entrance_code_date AS entrance_code_date_34, t4.coordinator_id AS coordinator_id_35 FROM user t0 LEFT JOIN responsible t1 ON t0.id = t1.id LEFT JOIN trainee t2 ON t0.id = t2.id LEFT JOIN coordinator t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 782)
3	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadOneToOneEntity (line 533)
4	Doctrine\ORM\UnitOfWork->createEntity (line 2535)
5	Doctrine\ORM\Cache\DefaultQueryCache->get (line 104)
6	Doctrine\ORM\Cache\Persister\Entity\AbstractEntityPersister->loadAll (line 349)
7	Doctrine\ORM\EntityRepository->findBy (line 110)
8	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
9	App\Service\GlobalDataService->getNotificationsNews (line 37)
10	App\Twig\AppExtension->getGlobals (line 35)
11	Twig\ExtensionSet->getGlobals (line 365)
12	Twig\Environment->getGlobals (line 908)
13	Twig\Template->yield (line 406)
14	Twig\Template->display (line 366)
15	Twig\Template->render (line 381)
16	Twig\TemplateWrapper->render (line 51)
17	Twig\Environment->render (line 333)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
21	App\Controller\HomeController->faq (line 337)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
24	Symfony\Component\HttpKernel\Kernel->handle (line 143)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
26	require_once (line 32)
27	require_once (line 5)

0.78 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3
FROM
  theme t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Theme::getPath (line 41)
5	App\Service\GlobalDataService->getPlatformThemePath (line 94)
6	App\Twig\AppExtension->getGlobals (line 43)
7	Twig\ExtensionSet->getGlobals (line 365)
8	Twig\Environment->getGlobals (line 908)
9	Twig\Template->yield (line 406)
10	Twig\Template->display (line 366)
11	Twig\Template->render (line 381)
12	Twig\TemplateWrapper->render (line 51)
13	Twig\Environment->render (line 333)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
17	App\Controller\HomeController->faq (line 337)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
20	Symfony\Component\HttpKernel\Kernel->handle (line 143)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
22	require_once (line 32)
23	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

11 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
non_strict	7
read_only	4

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\FeedbackCategory	3
App\Entity\User	2
App\Entity\SiteSettings	1
App\Entity\Theme	1
App\Entity\Faq	1
App\Entity\Notification	1
App\Entity\Avatar	1

Entities Mapping

Class	Mapping errors
App\Entity\SiteSettings	No errors.
App\Entity\Theme	No errors.
App\Entity\Faq	No errors.
App\Entity\Sector	No errors.
App\Entity\FeedbackCategory	No errors.
App\Entity\Feedback	No errors.
App\Entity\Notification	No errors.
App\Entity\User	No errors.
App\Entity\Responsible	No errors.
App\Entity\Trainee	No errors.
App\Entity\Coordinator	No errors.
App\Entity\Trainer	No errors.
App\Entity\Avatar	No errors.
App\Entity\Cohort	No errors.
App\Entity\Message	No errors.
App\Entity\UserQuiz	No errors.
App\Entity\Calendar	No errors.
App\Entity\RssFeed	No errors.
App\Entity\Course	No errors.
App\Entity\Quiz	No errors.
App\Entity\Sandbox	No errors.

GET https://app.trainizer.fr/fr/q-and-a

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Managed Entities

default entity manager

Entities Mapping