Symfony Profiler

Query Metrics

583 Database Queries

12 Different statements

194.34 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

36.19 ms
(18.62%)

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_visit_reports ON t0.id = office_visit_reports.uploaded_file_id WHERE office_visit_reports.office_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_name AS original_name_2,
  t0.filename AS filename_3,
  t0.path AS path_4,
  t0.comment AS comment_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.author_id AS author_id_8
FROM
  uploaded_file t0
  INNER JOIN office_visit_reports ON t0.id = office_visit_reports.uploaded_file_id
WHERE
  office_visit_reports.office_id = ?

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_visit_reports ON t0.id = office_visit_reports.uploaded_file_id WHERE office_visit_reports.office_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 3175)
5	Doctrine\ORM\UnitOfWork->createEntity (line 272)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3211)
11	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 24)
17	App\Repository\ContractRepository->findContracts (line 52)
18	App\Twig\AppExtension->getGlobals (line 331)
19	Twig\ExtensionSet->getGlobals (line 787)
20	Twig\Environment->getGlobals (line 800)
21	Twig\Environment->mergeGlobals (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 76)
29	App\Controller\SecurityController->forgotPassword (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

32.34 ms
(16.64%)

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_visit_plans ON t0.id = office_visit_plans.uploaded_file_id WHERE office_visit_plans.office_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_name AS original_name_2,
  t0.filename AS filename_3,
  t0.path AS path_4,
  t0.comment AS comment_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.author_id AS author_id_8
FROM
  uploaded_file t0
  INNER JOIN office_visit_plans ON t0.id = office_visit_plans.uploaded_file_id
WHERE
  office_visit_plans.office_id = ?

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_visit_plans ON t0.id = office_visit_plans.uploaded_file_id WHERE office_visit_plans.office_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 3175)
5	Doctrine\ORM\UnitOfWork->createEntity (line 272)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3211)
11	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 24)
17	App\Repository\ContractRepository->findContracts (line 52)
18	App\Twig\AppExtension->getGlobals (line 331)
19	Twig\ExtensionSet->getGlobals (line 787)
20	Twig\Environment->getGlobals (line 800)
21	Twig\Environment->mergeGlobals (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 76)
29	App\Controller\SecurityController->forgotPassword (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

29.95 ms
(15.41%)

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_fire_permits ON t0.id = office_fire_permits.uploaded_file_id WHERE office_fire_permits.office_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_name AS original_name_2,
  t0.filename AS filename_3,
  t0.path AS path_4,
  t0.comment AS comment_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.author_id AS author_id_8
FROM
  uploaded_file t0
  INNER JOIN office_fire_permits ON t0.id = office_fire_permits.uploaded_file_id
WHERE
  office_fire_permits.office_id = ?

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_fire_permits ON t0.id = office_fire_permits.uploaded_file_id WHERE office_fire_permits.office_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 3175)
5	Doctrine\ORM\UnitOfWork->createEntity (line 272)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3211)
11	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 24)
17	App\Repository\ContractRepository->findContracts (line 52)
18	App\Twig\AppExtension->getGlobals (line 331)
19	Twig\ExtensionSet->getGlobals (line 787)
20	Twig\Environment->getGlobals (line 800)
21	Twig\Environment->mergeGlobals (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 76)
29	App\Controller\SecurityController->forgotPassword (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

29.90 ms
(15.39%)

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_prevention_plans ON t0.id = office_prevention_plans.uploaded_file_id WHERE office_prevention_plans.office_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_name AS original_name_2,
  t0.filename AS filename_3,
  t0.path AS path_4,
  t0.comment AS comment_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.author_id AS author_id_8
FROM
  uploaded_file t0
  INNER JOIN office_prevention_plans ON t0.id = office_prevention_plans.uploaded_file_id
WHERE
  office_prevention_plans.office_id = ?

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_prevention_plans ON t0.id = office_prevention_plans.uploaded_file_id WHERE office_prevention_plans.office_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 3175)
5	Doctrine\ORM\UnitOfWork->createEntity (line 272)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3211)
11	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 24)
17	App\Repository\ContractRepository->findContracts (line 52)
18	App\Twig\AppExtension->getGlobals (line 331)
19	Twig\ExtensionSet->getGlobals (line 787)
20	Twig\Environment->getGlobals (line 800)
21	Twig\Environment->mergeGlobals (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 76)
29	App\Controller\SecurityController->forgotPassword (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

29.41 ms
(15.13%)

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_leases ON t0.id = office_leases.uploaded_file_id WHERE office_leases.office_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_name AS original_name_2,
  t0.filename AS filename_3,
  t0.path AS path_4,
  t0.comment AS comment_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.author_id AS author_id_8
FROM
  uploaded_file t0
  INNER JOIN office_leases ON t0.id = office_leases.uploaded_file_id
WHERE
  office_leases.office_id = ?

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_leases ON t0.id = office_leases.uploaded_file_id WHERE office_leases.office_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 3175)
5	Doctrine\ORM\UnitOfWork->createEntity (line 272)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3211)
11	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 24)
17	App\Repository\ContractRepository->findContracts (line 52)
18	App\Twig\AppExtension->getGlobals (line 331)
19	Twig\ExtensionSet->getGlobals (line 787)
20	Twig\Environment->getGlobals (line 800)
21	Twig\Environment->mergeGlobals (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 76)
29	App\Controller\SecurityController->forgotPassword (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

29.13 ms
(14.99%)

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_safety_rules ON t0.id = office_safety_rules.uploaded_file_id WHERE office_safety_rules.office_id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.original_name AS original_name_2,
  t0.filename AS filename_3,
  t0.path AS path_4,
  t0.comment AS comment_5,
  t0.description AS description_6,
  t0.created_at AS created_at_7,
  t0.author_id AS author_id_8
FROM
  uploaded_file t0
  INNER JOIN office_safety_rules ON t0.id = office_safety_rules.uploaded_file_id
WHERE
  office_safety_rules.office_id = ?

SELECT t0.id AS id_1, t0.original_name AS original_name_2, t0.filename AS filename_3, t0.path AS path_4, t0.comment AS comment_5, t0.description AS description_6, t0.created_at AS created_at_7, t0.author_id AS author_id_8 FROM uploaded_file t0 INNER JOIN office_safety_rules ON t0.id = office_safety_rules.uploaded_file_id WHERE office_safety_rules.office_id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1087)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1009)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3293)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 3175)
5	Doctrine\ORM\UnitOfWork->createEntity (line 272)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 498)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
8	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 270)
9	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 943)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3211)
11	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
12	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
13	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
14	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
15	Doctrine\ORM\AbstractQuery->execute (line 901)
16	Doctrine\ORM\AbstractQuery->getResult (line 24)
17	App\Repository\ContractRepository->findContracts (line 52)
18	App\Twig\AppExtension->getGlobals (line 331)
19	Twig\ExtensionSet->getGlobals (line 787)
20	Twig\Environment->getGlobals (line 800)
21	Twig\Environment->mergeGlobals (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 76)
29	App\Controller\SecurityController->forgotPassword (line 178)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

3.51 ms
(1.80%)

SELECT t0.id AS id_1, t0.label AS label_2, t0.main AS main_3, t0.head_office AS head_office_4, t0.billing_email AS billing_email_5, t0.description AS description_6, t0.rate AS rate_7, t0.limit_amount_of_capitals AS limit_amount_of_capitals_8, t0.damage_insurance_name AS damage_insurance_name_9, t0.damage_insurance_number AS damage_insurance_number_10, t0.rc_name AS rc_name_11, t0.rc_number AS rc_number_12, t0.is_company_office AS is_company_office_13, t0.area AS area_14, t0.building AS building_15, t0.content_on AS content_on_16, t0.content AS content_17, t0.material AS material_18, t0.merchandise AS merchandise_19, t0.variable AS variable_20, t0.frequency AS frequency_21, t0.owner AS owner_22, t0.tenant AS tenant_23, t0.address_id AS address_id_24, t25.id AS id_26, t25.country AS country_27, t25.city AS city_28, t25.zip_code AS zip_code_29, t25.street_number AS street_number_30, t25.street_name AS street_name_31, t0.company_id AS company_id_32, t0.logo_id AS logo_id_33, t34.id AS id_35, t34.original_name AS original_name_36, t34.filename AS filename_37, t34.path AS path_38, t34.comment AS comment_39, t34.description AS description_40, t34.created_at AS created_at_41, t34.author_id AS author_id_42, t0.picture_id AS picture_id_43, t44.id AS id_45, t44.original_name AS original_name_46, t44.filename AS filename_47, t44.path AS path_48, t44.comment AS comment_49, t44.description AS description_50, t44.created_at AS created_at_51, t44.author_id AS author_id_52, t0.contact_person_id AS contact_person_id_53, t54.id AS id_55, t54.firstname AS firstname_56, t54.lastname AS lastname_57, t54.phone AS phone_58, t54.email AS email_59, t54.job AS job_60, t0.current_index_id AS current_index_id_61, t0.contract_id AS contract_id_62, t63.id AS id_64, t63.start AS start_65, t63.end AS end_66, t63.number AS number_67, t63.insurer AS insurer_68, t63.draft AS draft_69, t63.type AS type_70, t63.office_id AS office_id_71, t0.accounting_person_id AS accounting_person_id_72, t73.id AS id_74, t73.firstname AS firstname_75, t73.lastname AS lastname_76, t73.phone AS phone_77, t73.email AS email_78, t73.job AS job_79 FROM office t0 INNER JOIN address t25 ON t0.address_id = t25.id LEFT JOIN uploaded_file t34 ON t0.logo_id = t34.id LEFT JOIN uploaded_file t44 ON t0.picture_id = t44.id INNER JOIN contact_person t54 ON t0.contact_person_id = t54.id LEFT JOIN contract t63 ON t0.contract_id = t63.id LEFT JOIN contact_person t73 ON t0.accounting_person_id = t73.id WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.main AS main_3,
  t0.head_office AS head_office_4,
  t0.billing_email AS billing_email_5,
  t0.description AS description_6,
  t0.rate AS rate_7,
  t0.limit_amount_of_capitals AS limit_amount_of_capitals_8,
  t0.damage_insurance_name AS damage_insurance_name_9,
  t0.damage_insurance_number AS damage_insurance_number_10,
  t0.rc_name AS rc_name_11,
  t0.rc_number AS rc_number_12,
  t0.is_company_office AS is_company_office_13,
  t0.area AS area_14,
  t0.building AS building_15,
  t0.content_on AS content_on_16,
  t0.content AS content_17,
  t0.material AS material_18,
  t0.merchandise AS merchandise_19,
  t0.variable AS variable_20,
  t0.frequency AS frequency_21,
  t0.owner AS owner_22,
  t0.tenant AS tenant_23,
  t0.address_id AS address_id_24,
  t25.id AS id_26,
  t25.country AS country_27,
  t25.city AS city_28,
  t25.zip_code AS zip_code_29,
  t25.street_number AS street_number_30,
  t25.street_name AS street_name_31,
  t0.company_id AS company_id_32,
  t0.logo_id AS logo_id_33,
  t34.id AS id_35,
  t34.original_name AS original_name_36,
  t34.filename AS filename_37,
  t34.path AS path_38,
  t34.comment AS comment_39,
  t34.description AS description_40,
  t34.created_at AS created_at_41,
  t34.author_id AS author_id_42,
  t0.picture_id AS picture_id_43,
  t44.id AS id_45,
  t44.original_name AS original_name_46,
  t44.filename AS filename_47,
  t44.path AS path_48,
  t44.comment AS comment_49,
  t44.description AS description_50,
  t44.created_at AS created_at_51,
  t44.author_id AS author_id_52,
  t0.contact_person_id AS contact_person_id_53,
  t54.id AS id_55,
  t54.firstname AS firstname_56,
  t54.lastname AS lastname_57,
  t54.phone AS phone_58,
  t54.email AS email_59,
  t54.job AS job_60,
  t0.current_index_id AS current_index_id_61,
  t0.contract_id AS contract_id_62,
  t63.id AS id_64,
  t63.start AS start_65,
  t63.end AS end_66,
  t63.number AS number_67,
  t63.insurer AS insurer_68,
  t63.draft AS draft_69,
  t63.type AS type_70,
  t63.office_id AS office_id_71,
  t0.accounting_person_id AS accounting_person_id_72,
  t73.id AS id_74,
  t73.firstname AS firstname_75,
  t73.lastname AS lastname_76,
  t73.phone AS phone_77,
  t73.email AS email_78,
  t73.job AS job_79
FROM
  office t0
  INNER JOIN address t25 ON t0.address_id = t25.id
  LEFT JOIN uploaded_file t34 ON t0.logo_id = t34.id
  LEFT JOIN uploaded_file t44 ON t0.picture_id = t44.id
  INNER JOIN contact_person t54 ON t0.contact_person_id = t54.id
  LEFT JOIN contract t63 ON t0.contract_id = t63.id
  LEFT JOIN contact_person t73 ON t0.accounting_person_id = t73.id
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?
  )

SELECT t0.id AS id_1, t0.label AS label_2, t0.main AS main_3, t0.head_office AS head_office_4, t0.billing_email AS billing_email_5, t0.description AS description_6, t0.rate AS rate_7, t0.limit_amount_of_capitals AS limit_amount_of_capitals_8, t0.damage_insurance_name AS damage_insurance_name_9, t0.damage_insurance_number AS damage_insurance_number_10, t0.rc_name AS rc_name_11, t0.rc_number AS rc_number_12, t0.is_company_office AS is_company_office_13, t0.area AS area_14, t0.building AS building_15, t0.content_on AS content_on_16, t0.content AS content_17, t0.material AS material_18, t0.merchandise AS merchandise_19, t0.variable AS variable_20, t0.frequency AS frequency_21, t0.owner AS owner_22, t0.tenant AS tenant_23, t0.address_id AS address_id_24, t25.id AS id_26, t25.country AS country_27, t25.city AS city_28, t25.zip_code AS zip_code_29, t25.street_number AS street_number_30, t25.street_name AS street_name_31, t0.company_id AS company_id_32, t0.logo_id AS logo_id_33, t34.id AS id_35, t34.original_name AS original_name_36, t34.filename AS filename_37, t34.path AS path_38, t34.comment AS comment_39, t34.description AS description_40, t34.created_at AS created_at_41, t34.author_id AS author_id_42, t0.picture_id AS picture_id_43, t44.id AS id_45, t44.original_name AS original_name_46, t44.filename AS filename_47, t44.path AS path_48, t44.comment AS comment_49, t44.description AS description_50, t44.created_at AS created_at_51, t44.author_id AS author_id_52, t0.contact_person_id AS contact_person_id_53, t54.id AS id_55, t54.firstname AS firstname_56, t54.lastname AS lastname_57, t54.phone AS phone_58, t54.email AS email_59, t54.job AS job_60, t0.current_index_id AS current_index_id_61, t0.contract_id AS contract_id_62, t63.id AS id_64, t63.start AS start_65, t63.end AS end_66, t63.number AS number_67, t63.insurer AS insurer_68, t63.draft AS draft_69, t63.type AS type_70, t63.office_id AS office_id_71, t0.accounting_person_id AS accounting_person_id_72, t73.id AS id_74, t73.firstname AS firstname_75, t73.lastname AS lastname_76, t73.phone AS phone_77, t73.email AS email_78, t73.job AS job_79 FROM office t0 INNER JOIN address t25 ON t0.address_id = t25.id LEFT JOIN uploaded_file t34 ON t0.logo_id = t34.id LEFT JOIN uploaded_file t44 ON t0.picture_id = t44.id INNER JOIN contact_person t54 ON t0.contact_person_id = t54.id LEFT JOIN contract t63 ON t0.contract_id = t63.id LEFT JOIN contact_person t73 ON t0.accounting_person_id = t73.id WHERE t0.id IN (3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 162, 163, 164);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 3211)
3	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 126)
4	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 272)
5	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 1225)
6	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
7	Doctrine\ORM\AbstractQuery->execute (line 901)
8	Doctrine\ORM\AbstractQuery->getResult (line 24)
9	App\Repository\ContractRepository->findContracts (line 52)
10	App\Twig\AppExtension->getGlobals (line 331)
11	Twig\ExtensionSet->getGlobals (line 787)
12	Twig\Environment->getGlobals (line 800)
13	Twig\Environment->mergeGlobals (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 76)
21	App\Controller\SecurityController->forgotPassword (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

1.22 ms
(0.63%)

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 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 95)
4	App\Twig\AppExtension->getAllRequests (line 48)
5	App\Twig\AppExtension->getGlobals (line 331)
6	Twig\ExtensionSet->getGlobals (line 787)
7	Twig\Environment->getGlobals (line 800)
8	Twig\Environment->mergeGlobals (line 367)
9	Twig\Template->display (line 379)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 280)
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 76)
16	App\Controller\SecurityController->forgotPassword (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.87 ms
(0.45%)

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, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.phone AS phone_15, t11.email AS email_16, t11.job AS job_17, t0.accounting_person_id AS accounting_person_id_18, t19.id AS id_20, t19.firstname AS firstname_21, t19.lastname AS lastname_22, t19.phone AS phone_23, t19.email AS email_24, t19.job AS job_25, t0.logo_id AS logo_id_26, t27.id AS id_28, t27.original_name AS original_name_29, t27.filename AS filename_30, t27.path AS path_31, t27.comment AS comment_32, t27.description AS description_33, t27.created_at AS created_at_34, t27.author_id AS author_id_35 FROM company t0 INNER JOIN contact_person t11 ON t0.contact_person_id = t11.id LEFT JOIN contact_person t19 ON t0.accounting_person_id = t19.id LEFT JOIN uploaded_file t27 ON t0.logo_id = t27.id

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,
  t11.id AS id_12,
  t11.firstname AS firstname_13,
  t11.lastname AS lastname_14,
  t11.phone AS phone_15,
  t11.email AS email_16,
  t11.job AS job_17,
  t0.accounting_person_id AS accounting_person_id_18,
  t19.id AS id_20,
  t19.firstname AS firstname_21,
  t19.lastname AS lastname_22,
  t19.phone AS phone_23,
  t19.email AS email_24,
  t19.job AS job_25,
  t0.logo_id AS logo_id_26,
  t27.id AS id_28,
  t27.original_name AS original_name_29,
  t27.filename AS filename_30,
  t27.path AS path_31,
  t27.comment AS comment_32,
  t27.description AS description_33,
  t27.created_at AS created_at_34,
  t27.author_id AS author_id_35
FROM
  company t0
  INNER JOIN contact_person t11 ON t0.contact_person_id = t11.id
  LEFT JOIN contact_person t19 ON t0.accounting_person_id = t19.id
  LEFT JOIN uploaded_file t27 ON t0.logo_id = t27.id

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, t11.id AS id_12, t11.firstname AS firstname_13, t11.lastname AS lastname_14, t11.phone AS phone_15, t11.email AS email_16, t11.job AS job_17, t0.accounting_person_id AS accounting_person_id_18, t19.id AS id_20, t19.firstname AS firstname_21, t19.lastname AS lastname_22, t19.phone AS phone_23, t19.email AS email_24, t19.job AS job_25, t0.logo_id AS logo_id_26, t27.id AS id_28, t27.original_name AS original_name_29, t27.filename AS filename_30, t27.path AS path_31, t27.comment AS comment_32, t27.description AS description_33, t27.created_at AS created_at_34, t27.author_id AS author_id_35 FROM company t0 INNER JOIN contact_person t11 ON t0.contact_person_id = t11.id LEFT JOIN contact_person t19 ON t0.accounting_person_id = t19.id LEFT JOIN uploaded_file t27 ON t0.logo_id = t27.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 109)
5	App\Twig\AppExtension->getAllCompanies (line 51)
6	App\Twig\AppExtension->getGlobals (line 331)
7	Twig\ExtensionSet->getGlobals (line 787)
8	Twig\Environment->getGlobals (line 800)
9	Twig\Environment->mergeGlobals (line 367)
10	Twig\Template->display (line 379)
11	Twig\Template->render (line 38)
12	Twig\TemplateWrapper->render (line 280)
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 76)
17	App\Controller\SecurityController->forgotPassword (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)

0.82 ms
(0.42%)

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-04-03 12:06:42"
  "2025-04-03 12:06:42"
]

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-04-03 12:06:42' AND (c0_.end IS NULL OR c0_.end >= '2025-04-03 12:06:42') AND c0_.draft = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 24)
7	App\Repository\ContractRepository->findContracts (line 52)
8	App\Twig\AppExtension->getGlobals (line 331)
9	Twig\ExtensionSet->getGlobals (line 787)
10	Twig\Environment->getGlobals (line 800)
11	Twig\Environment->mergeGlobals (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
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 76)
19	App\Controller\SecurityController->forgotPassword (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.55 ms
(0.28%)

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, t9.id AS id_10, t9.label AS label_11, t9.main AS main_12, t9.head_office AS head_office_13, t9.billing_email AS billing_email_14, t9.description AS description_15, t9.rate AS rate_16, t9.limit_amount_of_capitals AS limit_amount_of_capitals_17, t9.damage_insurance_name AS damage_insurance_name_18, t9.damage_insurance_number AS damage_insurance_number_19, t9.rc_name AS rc_name_20, t9.rc_number AS rc_number_21, t9.is_company_office AS is_company_office_22, t9.area AS area_23, t9.building AS building_24, t9.content_on AS content_on_25, t9.content AS content_26, t9.material AS material_27, t9.merchandise AS merchandise_28, t9.variable AS variable_29, t9.frequency AS frequency_30, t9.owner AS owner_31, t9.tenant AS tenant_32, t9.address_id AS address_id_33, t9.company_id AS company_id_34, t9.logo_id AS logo_id_35, t9.picture_id AS picture_id_36, t9.contact_person_id AS contact_person_id_37, t9.current_index_id AS current_index_id_38, t9.contract_id AS contract_id_39, t9.accounting_person_id AS accounting_person_id_40 FROM contract t0 LEFT JOIN office t9 ON t0.office_id = t9.id 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,
  t9.id AS id_10,
  t9.label AS label_11,
  t9.main AS main_12,
  t9.head_office AS head_office_13,
  t9.billing_email AS billing_email_14,
  t9.description AS description_15,
  t9.rate AS rate_16,
  t9.limit_amount_of_capitals AS limit_amount_of_capitals_17,
  t9.damage_insurance_name AS damage_insurance_name_18,
  t9.damage_insurance_number AS damage_insurance_number_19,
  t9.rc_name AS rc_name_20,
  t9.rc_number AS rc_number_21,
  t9.is_company_office AS is_company_office_22,
  t9.area AS area_23,
  t9.building AS building_24,
  t9.content_on AS content_on_25,
  t9.content AS content_26,
  t9.material AS material_27,
  t9.merchandise AS merchandise_28,
  t9.variable AS variable_29,
  t9.frequency AS frequency_30,
  t9.owner AS owner_31,
  t9.tenant AS tenant_32,
  t9.address_id AS address_id_33,
  t9.company_id AS company_id_34,
  t9.logo_id AS logo_id_35,
  t9.picture_id AS picture_id_36,
  t9.contact_person_id AS contact_person_id_37,
  t9.current_index_id AS current_index_id_38,
  t9.contract_id AS contract_id_39,
  t9.accounting_person_id AS accounting_person_id_40
FROM
  contract t0
  LEFT JOIN office t9 ON t0.office_id = t9.id
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, t9.id AS id_10, t9.label AS label_11, t9.main AS main_12, t9.head_office AS head_office_13, t9.billing_email AS billing_email_14, t9.description AS description_15, t9.rate AS rate_16, t9.limit_amount_of_capitals AS limit_amount_of_capitals_17, t9.damage_insurance_name AS damage_insurance_name_18, t9.damage_insurance_number AS damage_insurance_number_19, t9.rc_name AS rc_name_20, t9.rc_number AS rc_number_21, t9.is_company_office AS is_company_office_22, t9.area AS area_23, t9.building AS building_24, t9.content_on AS content_on_25, t9.content AS content_26, t9.material AS material_27, t9.merchandise AS merchandise_28, t9.variable AS variable_29, t9.frequency AS frequency_30, t9.owner AS owner_31, t9.tenant AS tenant_32, t9.address_id AS address_id_33, t9.company_id AS company_id_34, t9.logo_id AS logo_id_35, t9.picture_id AS picture_id_36, t9.contact_person_id AS contact_person_id_37, t9.current_index_id AS current_index_id_38, t9.contract_id AS contract_id_39, t9.accounting_person_id AS accounting_person_id_40 FROM contract t0 LEFT JOIN office t9 ON t0.office_id = t9.id WHERE t0.draft = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 29)
4	App\Repository\ContractRepository->findProjects (line 53)
5	App\Twig\AppExtension->getGlobals (line 331)
6	Twig\ExtensionSet->getGlobals (line 787)
7	Twig\Environment->getGlobals (line 800)
8	Twig\Environment->mergeGlobals (line 367)
9	Twig\Template->display (line 379)
10	Twig\Template->render (line 38)
11	Twig\TemplateWrapper->render (line 280)
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 76)
16	App\Controller\SecurityController->forgotPassword (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.45 ms
(0.23%)

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-04-03 12:06:42"
]

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-04-03 12:06:42') AND c0_.draft = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 40)
7	App\Repository\ContractRepository->findArchives (line 54)
8	App\Twig\AppExtension->getGlobals (line 331)
9	Twig\ExtensionSet->getGlobals (line 787)
10	Twig\Environment->getGlobals (line 800)
11	Twig\Environment->mergeGlobals (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
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 76)
19	App\Controller\SecurityController->forgotPassword (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)

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.

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	The field App\Entity\Office#indexHistory is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\OfficeIndex#office does not contain the required 'inversedBy="indexHistory"' attribute.
App\Entity\Contract	No errors.
App\Entity\Address	No errors.
App\Entity\OfficeIndex	No errors.
App\Entity\CapitalAmount	No errors.
App\Entity\Good	No errors.
App\Entity\Event	No errors.
App\Entity\OfficeHistory	No errors.

Symfony Profiler

GET https://riskmanagement.i-b-s.fr/forgot-password

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping