Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

2.05 ms Query time

0 Invalid entities

198 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.52 ms
(25.37%)

SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.requested_at AS requested_at_4, t0.status AS status_5, t0.reviewed_at AS reviewed_at_6, t0.requested_by_id AS requested_by_id_7, t0.reviewed_by_id AS reviewed_by_id_8 FROM request t0 WHERE t0.requested_by_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.entity_type AS entity_type_2,
  t0.entity_id AS entity_id_3,
  t0.requested_at AS requested_at_4,
  t0.status AS status_5,
  t0.reviewed_at AS reviewed_at_6,
  t0.requested_by_id AS requested_by_id_7,
  t0.reviewed_by_id AS reviewed_by_id_8
FROM
  request t0
WHERE
  t0.requested_by_id IS NULL

SELECT t0.id AS id_1, t0.entity_type AS entity_type_2, t0.entity_id AS entity_id_3, t0.requested_at AS requested_at_4, t0.status AS status_5, t0.reviewed_at AS reviewed_at_6, t0.requested_by_id AS requested_by_id_7, t0.reviewed_by_id AS reviewed_by_id_8 FROM request t0 WHERE t0.requested_by_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 95)
4	App\Twig\AppExtension->getAllRequests (line 48)
5	App\Twig\AppExtension->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 28)
16	App\Controller\SecurityController->login (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.51 ms
(24.73%)

SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE c0_.start <= ? AND (c0_.end IS NULL OR c0_.end >= ?) AND c0_.draft = 0

Parameters:

[
  "2025-07-01 02:45:24"
  "2025-07-01 02:45:24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.start AS start_1,
  c0_.end AS end_2,
  c0_.number AS number_3,
  c0_.insurer AS insurer_4,
  c0_.draft AS draft_5,
  c0_.type AS type_6,
  c0_.office_id AS office_id_7
FROM
  contract c0_
WHERE
  c0_.start <= ?
  AND (
    c0_.end IS NULL
    OR c0_.end >= ?
  )
  AND c0_.draft = 0

SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE c0_.start <= '2025-07-01 02:45:24' AND (c0_.end IS NULL OR c0_.end >= '2025-07-01 02:45:24') AND c0_.draft = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 24)
7	App\Repository\ContractRepository->findContracts (line 52)
8	App\Twig\AppExtension->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 28)
19	App\Controller\SecurityController->login (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.37 ms
(18.04%)

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.number AS number_4, t0.insurer AS insurer_5, t0.draft AS draft_6, t0.type AS type_7, t0.office_id AS office_id_8 FROM contract t0 WHERE t0.draft = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.start AS start_2,
  t0.end AS end_3,
  t0.number AS number_4,
  t0.insurer AS insurer_5,
  t0.draft AS draft_6,
  t0.type AS type_7,
  t0.office_id AS office_id_8
FROM
  contract t0
WHERE
  t0.draft = ?

SELECT t0.id AS id_1, t0.start AS start_2, t0.end AS end_3, t0.number AS number_4, t0.insurer AS insurer_5, t0.draft AS draft_6, t0.type AS type_7, t0.office_id AS office_id_8 FROM contract t0 WHERE t0.draft = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 29)
4	App\Repository\ContractRepository->findProjects (line 53)
5	App\Twig\AppExtension->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 28)
16	App\Controller\SecurityController->login (line 178)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.36 ms
(17.70%)

SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE (c0_.end IS NOT NULL AND c0_.end >= ?) AND c0_.draft = 0

Parameters:

[
  "2025-07-01 02:45:24"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.start AS start_1,
  c0_.end AS end_2,
  c0_.number AS number_3,
  c0_.insurer AS insurer_4,
  c0_.draft AS draft_5,
  c0_.type AS type_6,
  c0_.office_id AS office_id_7
FROM
  contract c0_
WHERE
  (
    c0_.end IS NOT NULL
    AND c0_.end >= ?
  )
  AND c0_.draft = 0

SELECT c0_.id AS id_0, c0_.start AS start_1, c0_.end AS end_2, c0_.number AS number_3, c0_.insurer AS insurer_4, c0_.draft AS draft_5, c0_.type AS type_6, c0_.office_id AS office_id_7 FROM contract c0_ WHERE (c0_.end IS NOT NULL AND c0_.end >= '2025-07-01 02:45:24') AND c0_.draft = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 40)
7	App\Repository\ContractRepository->findArchives (line 54)
8	App\Twig\AppExtension->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 28)
19	App\Controller\SecurityController->login (line 178)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	require_once (line 5)

0.29 ms
(14.17%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.limit_amount_of_capitals AS limit_amount_of_capitals_4, t0.contract_rc AS contract_rc_5, t0.property_damage AS property_damage_6, t0.soft_deleted AS soft_deleted_7, t0.rate AS rate_8, t0.creator_user_id AS creator_user_id_9, t0.contact_person_id AS contact_person_id_10, t0.accounting_person_id AS accounting_person_id_11, t0.logo_id AS logo_id_12 FROM company t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.comment AS comment_3,
  t0.limit_amount_of_capitals AS limit_amount_of_capitals_4,
  t0.contract_rc AS contract_rc_5,
  t0.property_damage AS property_damage_6,
  t0.soft_deleted AS soft_deleted_7,
  t0.rate AS rate_8,
  t0.creator_user_id AS creator_user_id_9,
  t0.contact_person_id AS contact_person_id_10,
  t0.accounting_person_id AS accounting_person_id_11,
  t0.logo_id AS logo_id_12
FROM
  company t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.comment AS comment_3, t0.limit_amount_of_capitals AS limit_amount_of_capitals_4, t0.contract_rc AS contract_rc_5, t0.property_damage AS property_damage_6, t0.soft_deleted AS soft_deleted_7, t0.rate AS rate_8, t0.creator_user_id AS creator_user_id_9, t0.contact_person_id AS contact_person_id_10, t0.accounting_person_id AS accounting_person_id_11, t0.logo_id AS logo_id_12 FROM company t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 109)
5	App\Twig\AppExtension->getAllCompanies (line 51)
6	App\Twig\AppExtension->getGlobals (line 359)
7	Twig\ExtensionSet->getGlobals (line 900)
8	Twig\Environment->getGlobals (line 398)
9	Twig\Template->yield (line 358)
10	Twig\Template->display (line 373)
11	Twig\Template->render (line 51)
12	Twig\TemplateWrapper->render (line 333)
13	Twig\Environment->render (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 28)
17	App\Controller\SecurityController->login (line 178)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\Contract	98
App\Entity\Office	98
App\Entity\Company	1
App\Entity\ContactPerson	1

Entities Mapping

Class	Mapping errors
App\Entity\Request	No errors.
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\ContactPerson	No errors.
App\Entity\UploadedFile	No errors.
App\Entity\Office	No errors.
App\Entity\Contract	No errors.

Symfony Profiler

GET https://riskmanagement.i-b-s.fr/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping