Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.54 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.12 ms
(43.87%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.slug AS slug_11, t0.master AS master_12, t0.shortname AS shortname_13 FROM cabinet t0 WHERE t0.master = ? LIMIT 1

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.address AS address_3,
  t0.postal_code AS postal_code_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone AS phone_7,
  t0.mail AS mail_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.slug AS slug_11,
  t0.master AS master_12,
  t0.shortname AS shortname_13
FROM
  cabinet t0
WHERE
  t0.master = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.slug AS slug_11, t0.master AS master_12, t0.shortname AS shortname_13 FROM cabinet t0 WHERE t0.master = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 364)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 275)
5	Doctrine\ORM\EntityRepository->__call (line 45)
6	App\Service\CabinetManager->getSessionCabinet (line 35)
7	App\Twig\HeaderFilter->sessionCabinet (line 78)
8	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
9	Twig\Template->yield (line 53)
10	__TwigTemplate_849149ff18b216c75489387b9ae1df0b->doDisplay (line 387)
11	Twig\Template->yield (line 343)
12	Twig\Template->display (line 358)
13	Twig\Template->render (line 35)
14	Twig\TemplateWrapper->render (line 320)
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 173)
19	App\Controller\HomeController->mentions (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.60 ms
(23.39%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.cabinet_id AS cabinet_id_4 FROM cabinet_config t0 WHERE t0.cabinet_id = ? AND t0.name = ? LIMIT 1

Parameters:

[
  7
  "theme"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.cabinet_id AS cabinet_id_4
FROM
  cabinet_config t0
WHERE
  t0.cabinet_id = ?
  AND t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.cabinet_id AS cabinet_id_4 FROM cabinet_config t0 WHERE t0.cabinet_id = 7 AND t0.name = 'theme' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 107)
4	App\Service\CabinetManager->getConfig (line 48)
5	App\Twig\HeaderFilter->cabinetConfig (line 80)
6	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
7	Twig\Template->yield (line 53)
8	__TwigTemplate_849149ff18b216c75489387b9ae1df0b->doDisplay (line 387)
9	Twig\Template->yield (line 343)
10	Twig\Template->display (line 358)
11	Twig\Template->render (line 35)
12	Twig\TemplateWrapper->render (line 320)
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 173)
17	App\Controller\HomeController->mentions (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.49 ms
(19.37%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.slug AS slug_11, t0.master AS master_12, t0.shortname AS shortname_13 FROM cabinet 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.address AS address_3,
  t0.postal_code AS postal_code_4,
  t0.city AS city_5,
  t0.country AS country_6,
  t0.phone AS phone_7,
  t0.mail AS mail_8,
  t0.latitude AS latitude_9,
  t0.longitude AS longitude_10,
  t0.slug AS slug_11,
  t0.master AS master_12,
  t0.shortname AS shortname_13
FROM
  cabinet t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.city AS city_5, t0.country AS country_6, t0.phone AS phone_7, t0.mail AS mail_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.slug AS slug_11, t0.master AS master_12, t0.shortname AS shortname_13 FROM cabinet t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 63)
5	App\Service\CabinetManager->findAll (line 41)
6	App\Twig\HeaderFilter->allCabinets (line 80)
7	__TwigTemplate_eb7dedc03548fdc41b7cc96dbada9282->doDisplay (line 387)
8	Twig\Template->yield (line 343)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 76)
11	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
12	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
13	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 342)
14	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->block_footer (line 431)
15	Twig\Template->yieldBlock (line 168)
16	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
17	Twig\Template->yield (line 53)
18	__TwigTemplate_849149ff18b216c75489387b9ae1df0b->doDisplay (line 387)
19	Twig\Template->yield (line 343)
20	Twig\Template->display (line 358)
21	Twig\Template->render (line 35)
22	Twig\TemplateWrapper->render (line 320)
23	Twig\Environment->render (line 431)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 173)
27	App\Controller\HomeController->mentions (line 178)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.34 ms
(13.36%)

SELECT t0.id AS id_1, t0.type AS type_2, t0.image_name AS image_name_3, t0.uploaded_at AS uploaded_at_4, t0.cabinet_id AS cabinet_id_5 FROM cabinet_image t0 WHERE t0.cabinet_id = ?

Parameters:

[
  7
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.image_name AS image_name_3,
  t0.uploaded_at AS uploaded_at_4,
  t0.cabinet_id AS cabinet_id_5
FROM
  cabinet_image t0
WHERE
  t0.cabinet_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.image_name AS image_name_3, t0.uploaded_at AS uploaded_at_4, t0.cabinet_id AS cabinet_id_5 FROM cabinet_image t0 WHERE t0.cabinet_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1916)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1857)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3301)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 28)
8	App\Twig\CabinetFilter->cabinetImage (line 50)
9	__TwigTemplate_ecb983b6e584b1a22cf8db3c6253a9be->doDisplay (line 387)
10	Twig\Template->yield (line 343)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 76)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 291)
16	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->block_header (line 431)
17	Twig\Template->yieldBlock (line 96)
18	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
19	Twig\Template->yield (line 53)
20	__TwigTemplate_849149ff18b216c75489387b9ae1df0b->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 358)
23	Twig\Template->render (line 35)
24	Twig\TemplateWrapper->render (line 320)
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 173)
29	App\Controller\HomeController->mentions (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)

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\Cabinet	No errors.
App\Entity\Medecin	No errors.
App\Entity\MedecinSpecialities	The field App\Entity\MedecinSpecialities#consultationTypes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ConsultationType#medecinSpecialities does not contain the required 'inversedBy="consultationTypes"' attribute.
App\Entity\CabinetWebsite	No errors.
App\Entity\CabinetConfig	No errors.
App\Entity\CabinetImage	No errors.
App\Entity\Consultation	No errors.
App\Entity\ContactForm	No errors.
App\Entity\UserAccess	No errors.
App\Entity\MedecinUserAccess	No errors.
App\Entity\User	No errors.
App\Entity\MedecinWebsite	No errors.
App\Entity\MedecinConfig	No errors.
App\Entity\CalendarHoliday	No errors.
App\Entity\MedecinSubstitute	No errors.
App\Entity\TodoList	No errors.
App\Entity\Specialities	No errors.
App\Entity\ConsultationType	No errors.
App\Entity\CalendarTimeSlot	No errors.
App\Entity\CalendarModelTimeSlot	No errors.
App\Entity\Patient	No errors.
App\Entity\CancelReason	No errors.
App\Entity\InternalMessage	No errors.
App\Entity\ConsultationNotifHistory	No errors.
App\Entity\MedecinSubstituteCalendarSlot	No errors.
App\Entity\ConsultationInformations	No errors.
App\Entity\PatientUserAccess	No errors.
App\Entity\CalendarModel	No errors.
App\Entity\UserConfig	No errors.
App\Entity\CalendarModelRepeat	No errors.
App\Entity\ConsultationInformationsConfiguration	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\UserSubscription	No errors.
App\Entity\CalendarModelHolidaySlot	No errors.
App\Entity\ShortUrl	No errors.
App\Entity\PatientImported	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET http://drarnoldstrasbourg.fr/mentions_legales

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping