Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.54 ms Query time

0 Invalid entities

1 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.22 ms

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.ifu AS ifu_6, t0.site_web AS site_web_7, t0.gerant AS gerant_8, t0.sigle AS sigle_9, t0.kilometrage AS kilometrage_10, t0.delai_assurance AS delai_assurance_11, t0.delai_tvm AS delai_tvm_12, t0.delai_visite_technique AS delai_visite_technique_13, t0.logo AS logo_14 FROM entreprise t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.adresse AS adresse_3,
  t0.telephone AS telephone_4,
  t0.email AS email_5,
  t0.ifu AS ifu_6,
  t0.site_web AS site_web_7,
  t0.gerant AS gerant_8,
  t0.sigle AS sigle_9,
  t0.kilometrage AS kilometrage_10,
  t0.delai_assurance AS delai_assurance_11,
  t0.delai_tvm AS delai_tvm_12,
  t0.delai_visite_technique AS delai_visite_technique_13,
  t0.logo AS logo_14
FROM
  entreprise t0
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.telephone AS telephone_4, t0.email AS email_5, t0.ifu AS ifu_6, t0.site_web AS site_web_7, t0.gerant AS gerant_8, t0.sigle AS sigle_9, t0.kilometrage AS kilometrage_10, t0.delai_assurance AS delai_assurance_11, t0.delai_tvm AS delai_tvm_12, t0.delai_visite_technique AS delai_visite_technique_13, t0.logo AS logo_14 FROM entreprise t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 21)
5	App\Twig\EntrepriseGlobalExtension->getGlobals (line 359)
6	Twig\ExtensionSet->getGlobals (line 900)
7	Twig\Environment->getGlobals (line 398)
8	Twig\Template->yield (line 358)
9	Twig\Template->display (line 373)
10	Twig\Template->render (line 51)
11	Twig\TemplateWrapper->render (line 333)
12	Twig\Environment->render (line 431)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
16	App\Controller\SecurityController->login (line 183)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

1.32 ms

SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.date_creation AS date_creation_2, n0_.vue AS vue_3 FROM notification n0_ WHERE n0_.vue = ? ORDER BY n0_.date_creation DESC

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.message AS message_1,
  n0_.date_creation AS date_creation_2,
  n0_.vue AS vue_3
FROM
  notification n0_
WHERE
  n0_.vue = ?
ORDER BY
  n0_.date_creation DESC

SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.date_creation AS date_creation_2, n0_.vue AS vue_3 FROM notification n0_ WHERE n0_.vue = 0 ORDER BY n0_.date_creation DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 36)
7	App\Repository\NotificationRepository->findUnreadNotifications (line 21)
8	App\Twig\NotificationGlobalExtension->getGlobals (line 359)
9	Twig\ExtensionSet->getGlobals (line 900)
10	Twig\Environment->getGlobals (line 398)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 431)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 26)
19	App\Controller\SecurityController->login (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\Entreprise	1

Entities Mapping

Class	Mapping errors
App\Entity\Entreprise	No errors.
App\Entity\Materiel	No errors.
App\Entity\Employe	No errors.
App\Entity\Notification	No errors.

Symfony Profiler

GET https://esuivi.titanic-security.com/

Configuration Settings

Theme

Page Width