Symfony Profiler

Query Metrics

6 Database Queries

3 Different statements

5.35 ms Query time

0 Invalid entities

5 Managed entities

5 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

Time▼

Count

Info

2.53 ms
(47.27%)

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL ORDER BY t0.date DESC

Parameters:

[
  "homework_to_do"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.message AS message_3,
  t0.link AS link_4,
  t0.date AS date_5,
  t0.category AS category_6,
  t0.user_id AS user_id_7
FROM
  notification t0
WHERE
  t0.category = ?
  AND t0.user_id IS NULL
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = 'homework_to_do' AND t0.user_id IS NULL ORDER BY t0.date DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Service\GlobalDataService->getNotificationsHomeworksToDo (line 41)
5	App\Twig\AppExtension->getGlobals (line 35)
6	Twig\ExtensionSet->getGlobals (line 365)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 406)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
16	App\Controller\SecurityController->login (line 79)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

1.61 ms
(30.13%)

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id IS NULL ORDER BY t0.date DESC

Parameters:

[
  "internship_approval"
  "internship_to_seal"
  "internship_rejected"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.origin AS origin_2,
  t0.message AS message_3,
  t0.link AS link_4,
  t0.date AS date_5,
  t0.category AS category_6,
  t0.user_id AS user_id_7
FROM
  notification t0
WHERE
  t0.category IN (?, ?, ?)
  AND t0.user_id IS NULL
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN ('internship_approval', 'internship_to_seal', 'internship_rejected') AND t0.user_id IS NULL ORDER BY t0.date DESC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Service\GlobalDataService->getNotificationsInternships (line 69)
5	App\Twig\AppExtension->getGlobals (line 37)
6	Twig\ExtensionSet->getGlobals (line 365)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 406)
9	Twig\Template->display (line 366)
10	Twig\Template->render (line 381)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 472)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 477)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 281)
16	App\Controller\SecurityController->login (line 79)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 79)
19	Symfony\Component\HttpKernel\Kernel->handle (line 143)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 34)
21	require_once (line 32)
22	require_once (line 5)

1.21 ms
(22.60%)

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

Parameters:

[
  4
]

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 = 4;

#	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 166)
6	App\Twig\AppExtension->getGlobals (line 52)
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\SecurityController->login (line 79)
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

5 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
non_strict	1
read_only	4

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\FeedbackCategory	3
App\Entity\SiteSettings	1
App\Entity\Theme	1

Entities Mapping

Class	Mapping errors
App\Entity\SiteSettings	No errors.
App\Entity\Theme	No errors.
App\Entity\FeedbackCategory	No errors.
App\Entity\Feedback	No errors.
App\Entity\Notification	No errors.
App\Entity\User	No errors.

GET https://app.trainizer.fr/sitemap.xml/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Managed Entities

default entity manager

Entities Mapping