Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

3.39 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.20 ms
(35.56%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.identification_number AS identification_number_5, t0.diplomas AS diplomas_6, t0.refund AS refund_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t10.id AS id_11, t10.mail AS mail_12, t10.mobile AS mobile_13, t10.create_date AS create_date_14, t10.archive_date AS archive_date_15, t10.last_login_date AS last_login_date_16, t10.status AS status_17, t10.slug AS slug_18, t10.roles AS roles_19, t10.password AS password_20, t10.is_verified AS is_verified_21, t10.firstname AS firstname_22, t10.lastname AS lastname_23, t10.patient_id AS patient_id_24, t10.medecin_id AS medecin_id_25 FROM medecin t0 LEFT JOIN `user` t10 ON t10.medecin_id = t0.id WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "Claude-ARNOLD-51288e71"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.identification_number AS identification_number_5,
  t0.diplomas AS diplomas_6,
  t0.refund AS refund_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9,
  t10.id AS id_11,
  t10.mail AS mail_12,
  t10.mobile AS mobile_13,
  t10.create_date AS create_date_14,
  t10.archive_date AS archive_date_15,
  t10.last_login_date AS last_login_date_16,
  t10.status AS status_17,
  t10.slug AS slug_18,
  t10.roles AS roles_19,
  t10.password AS password_20,
  t10.is_verified AS is_verified_21,
  t10.firstname AS firstname_22,
  t10.lastname AS lastname_23,
  t10.patient_id AS patient_id_24,
  t10.medecin_id AS medecin_id_25
FROM
  medecin t0
  LEFT JOIN `user` t10 ON t10.medecin_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.identification_number AS identification_number_5, t0.diplomas AS diplomas_6, t0.refund AS refund_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t10.id AS id_11, t10.mail AS mail_12, t10.mobile AS mobile_13, t10.create_date AS create_date_14, t10.archive_date AS archive_date_15, t10.last_login_date AS last_login_date_16, t10.status AS status_17, t10.slug AS slug_18, t10.roles AS roles_19, t10.password AS password_20, t10.is_verified AS is_verified_21, t10.firstname AS firstname_22, t10.lastname AS lastname_23, t10.patient_id AS patient_id_24, t10.medecin_id AS medecin_id_25 FROM medecin t0 LEFT JOIN `user` t10 ON t10.medecin_id = t0.id WHERE t0.slug = 'Claude-ARNOLD-51288e71' 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 69)
4	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
5	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
7	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.75 ms
(22.22%)

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 128)
9	__TwigTemplate_f4410327f663269671e29004c2839385->block_body (line 431)
10	Twig\Template->yieldBlock (line 160)
11	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
12	Twig\Template->yield (line 59)
13	__TwigTemplate_f4410327f663269671e29004c2839385->doDisplay (line 387)
14	Twig\Template->yield (line 57)
15	__TwigTemplate_11dadc33d8d6e21f9d81e19416ac47ae->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 35)
19	Twig\TemplateWrapper->render (line 320)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 230)
24	App\Controller\Patient\ConsultationController->consultationNew (line 178)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.74 ms
(21.79%)

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 59)
8	__TwigTemplate_f4410327f663269671e29004c2839385->doDisplay (line 387)
9	Twig\Template->yield (line 57)
10	__TwigTemplate_11dadc33d8d6e21f9d81e19416ac47ae->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 230)
19	App\Controller\Patient\ConsultationController->consultationNew (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.36 ms
(10.65%)

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 59)
10	__TwigTemplate_f4410327f663269671e29004c2839385->doDisplay (line 387)
11	Twig\Template->yield (line 57)
12	__TwigTemplate_11dadc33d8d6e21f9d81e19416ac47ae->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
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 230)
21	App\Controller\Patient\ConsultationController->consultationNew (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)

0.33 ms
(9.77%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.identification_number AS identification_number_5, t0.medecin_id AS medecin_id_6, t0.user_id AS user_id_7 FROM medecin_substitute t0 WHERE t0.user_id = ?

Parameters:

[
  17
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.identification_number AS identification_number_5,
  t0.medecin_id AS medecin_id_6,
  t0.user_id AS user_id_7
FROM
  medecin_substitute t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.identification_number AS identification_number_5, t0.medecin_id AS medecin_id_6, t0.user_id AS user_id_7 FROM medecin_substitute t0 WHERE t0.user_id = 17;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 873)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 3027)
4	Doctrine\ORM\UnitOfWork->createEntity (line 272)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 449)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 149)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 272)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 784)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
10	Doctrine\ORM\EntityRepository->findOneBy (line 69)
11	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
12	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
13	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
14	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	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\Medecin	No errors.
App\Entity\User	No errors.
App\Entity\Patient	No errors.
App\Entity\Cabinet	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\Consultation	No errors.
App\Entity\MedecinWebsite	No errors.
App\Entity\MedecinUserAccess	No errors.
App\Entity\MedecinConfig	No errors.
App\Entity\CalendarHoliday	No errors.
App\Entity\MedecinSubstitute	No errors.
App\Entity\TodoList	No errors.
App\Entity\PatientUserAccess	No errors.
App\Entity\UserAccess	No errors.
App\Entity\ConsultationNotifHistory	No errors.
App\Entity\CalendarModel	No errors.
App\Entity\InternalMessage	No errors.
App\Entity\UserConfig	No errors.
App\Entity\CabinetWebsite	No errors.
App\Entity\CabinetConfig	No errors.
App\Entity\CabinetImage	No errors.
App\Entity\ContactForm	No errors.

Symfony Profiler

GET http://drarnoldstrasbourg.fr/patient/consultation/Claude-ARNOLD-51288e71/new

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping