Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

7.95 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.45 ms
(18.19%)

SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.status AS status_4, t0.title AS title_5, t0.position AS position_6, t0.icon AS icon_7, t0.field_type AS field_type_8, t0.cabinet_id AS cabinet_id_9 FROM cabinet_website 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.field_name AS field_name_2,
  t0.content AS content_3,
  t0.status AS status_4,
  t0.title AS title_5,
  t0.position AS position_6,
  t0.icon AS icon_7,
  t0.field_type AS field_type_8,
  t0.cabinet_id AS cabinet_id_9
FROM
  cabinet_website t0
WHERE
  t0.cabinet_id = ?

SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.status AS status_4, t0.title AS title_5, t0.position AS position_6, t0.icon AS icon_7, t0.field_type AS field_type_8, t0.cabinet_id AS cabinet_id_9 FROM cabinet_website 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 365)
8	App\Entity\Cabinet->getWebSiteOption (line 153)
9	App\Service\CabinetManager->hasShowcaseSite (line 90)
10	App\Controller\HomeController->index (line 178)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.33 ms
(16.74%)

SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.status AS status_4, t0.position AS position_5, t0.icon AS icon_6, t0.title AS title_7, t0.field_type AS field_type_8, t0.medecin_id AS medecin_id_9 FROM medecin_website t0 WHERE t0.medecin_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.field_name AS field_name_2,
  t0.content AS content_3,
  t0.status AS status_4,
  t0.position AS position_5,
  t0.icon AS icon_6,
  t0.title AS title_7,
  t0.field_type AS field_type_8,
  t0.medecin_id AS medecin_id_9
FROM
  medecin_website t0
WHERE
  t0.medecin_id = ?

SELECT t0.id AS id_1, t0.field_name AS field_name_2, t0.content AS content_3, t0.status AS status_4, t0.position AS position_5, t0.icon AS icon_6, t0.title AS title_7, t0.field_type AS field_type_8, t0.medecin_id AS medecin_id_9 FROM medecin_website t0 WHERE t0.medecin_id = 6;

#	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 22)
8	App\Twig\SearchWebsiteFilter->searchWebsite (line 87)
9	__TwigTemplate_b0778853b6d6d342b2ba22ee9d69c07c->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 682)
16	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d___11504034881->block_content (line 431)
17	Twig\Template->yieldBlock (line 78)
18	__TwigTemplate_e84be34d56a0f98bd4412611eb4bf75a->doDisplay (line 387)
19	Twig\Template->yield (line 631)
20	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d___11504034881->doDisplay (line 387)
21	Twig\Template->yield (line 343)
22	Twig\Template->display (line 167)
23	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->block_body (line 431)
24	Twig\Template->yieldBlock (line 160)
25	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
26	Twig\Template->yield (line 55)
27	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->doDisplay (line 387)
28	Twig\Template->yield (line 343)
29	Twig\Template->display (line 358)
30	Twig\Template->render (line 35)
31	Twig\TemplateWrapper->render (line 320)
32	Twig\Environment->render (line 431)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
34	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 94)
36	App\Controller\HomeController->index (line 178)
37	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
38	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
39	Symfony\Component\HttpKernel\Kernel->handle (line 35)
40	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
41	require_once (line 5)

1.07 ms
(13.41%)

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 INNER JOIN cabinet_medecin ON t0.id = cabinet_medecin.medecin_id WHERE cabinet_medecin.cabinet_id = ?

Parameters:

[
  7
]

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
  INNER JOIN cabinet_medecin ON t0.id = cabinet_medecin.medecin_id
WHERE
  cabinet_medecin.cabinet_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.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 INNER JOIN cabinet_medecin ON t0.id = cabinet_medecin.medecin_id WHERE cabinet_medecin.cabinet_id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1117)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1039)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
8	Doctrine\ORM\PersistentCollection->count (line 1227)
9	Twig\Extension\CoreExtension::length (line 158)
10	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->block_body (line 431)
11	Twig\Template->yieldBlock (line 160)
12	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
13	Twig\Template->yield (line 55)
14	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 35)
18	Twig\TemplateWrapper->render (line 320)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 94)
23	App\Controller\HomeController->index (line 178)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

1.02 ms
(12.82%)

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 55)
8	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->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 94)
17	App\Controller\HomeController->index (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.79 ms
(9.94%)

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 37)
7	App\Service\CabinetManager->initSessionCabinet (line 89)
8	App\Controller\HomeController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.51 ms
(6.42%)

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 1031)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadCollectionFromStatement (line 1041)
10	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3305)
11	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
12	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
13	Doctrine\ORM\PersistentCollection->initialize (line 39)
14	Doctrine\Common\Collections\AbstractLazyCollection->count (line 456)
15	Doctrine\ORM\PersistentCollection->count (line 1227)
16	Twig\Extension\CoreExtension::length (line 158)
17	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->block_body (line 431)
18	Twig\Template->yieldBlock (line 160)
19	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
20	Twig\Template->yield (line 55)
21	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->doDisplay (line 387)
22	Twig\Template->yield (line 343)
23	Twig\Template->display (line 358)
24	Twig\Template->render (line 35)
25	Twig\TemplateWrapper->render (line 320)
26	Twig\Environment->render (line 431)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 94)
30	App\Controller\HomeController->index (line 178)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.51 ms
(6.41%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.message_type AS message_type_3, t0.value AS value_4, t0.value_txt AS value_txt_5, t0.medecin_id AS medecin_id_6 FROM medecin_config t0 WHERE t0.medecin_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.message_type AS message_type_3,
  t0.value AS value_4,
  t0.value_txt AS value_txt_5,
  t0.medecin_id AS medecin_id_6
FROM
  medecin_config t0
WHERE
  t0.medecin_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.message_type AS message_type_3, t0.value AS value_4, t0.value_txt AS value_txt_5, t0.medecin_id AS medecin_id_6 FROM medecin_config t0 WHERE t0.medecin_id = 6;

#	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 551)
8	App\Entity\Medecin->getMedecinConfigValue (line 564)
9	App\Entity\Medecin->hasBookingInternet (line 1861)
10	Twig\Extension\CoreExtension::getAttribute (line 100)
11	__TwigTemplate_b0778853b6d6d342b2ba22ee9d69c07c->doDisplay (line 387)
12	Twig\Template->yield (line 343)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 76)
15	Symfony\UX\TwigComponent\ComponentRenderer->render (line 55)
16	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
17	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 682)
18	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d___11504034881->block_content (line 431)
19	Twig\Template->yieldBlock (line 78)
20	__TwigTemplate_e84be34d56a0f98bd4412611eb4bf75a->doDisplay (line 387)
21	Twig\Template->yield (line 631)
22	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d___11504034881->doDisplay (line 387)
23	Twig\Template->yield (line 343)
24	Twig\Template->display (line 167)
25	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->block_body (line 431)
26	Twig\Template->yieldBlock (line 160)
27	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
28	Twig\Template->yield (line 55)
29	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->doDisplay (line 387)
30	Twig\Template->yield (line 343)
31	Twig\Template->display (line 358)
32	Twig\Template->render (line 35)
33	Twig\TemplateWrapper->render (line 320)
34	Twig\Environment->render (line 431)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 94)
38	App\Controller\HomeController->index (line 178)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	require_once (line 5)

0.50 ms
(6.30%)

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 476)
18	Twig\Template->yieldParentBlock (line 94)
19	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->block_header (line 431)
20	Twig\Template->yieldBlock (line 96)
21	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
22	Twig\Template->yield (line 55)
23	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->doDisplay (line 387)
24	Twig\Template->yield (line 343)
25	Twig\Template->display (line 358)
26	Twig\Template->render (line 35)
27	Twig\TemplateWrapper->render (line 320)
28	Twig\Environment->render (line 431)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 94)
32	App\Controller\HomeController->index (line 178)
33	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
34	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
35	Symfony\Component\HttpKernel\Kernel->handle (line 35)
36	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
37	require_once (line 5)

0.41 ms
(5.21%)

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 = ?

Parameters:

[
  7
  "widget"
]

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 = ?

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 = 'widget';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 134)
4	App\Service\CabinetManager->getConfigArray (line 55)
5	App\Twig\HeaderFilter->cabinetConfigArray (line 208)
6	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->block_body (line 431)
7	Twig\Template->yieldBlock (line 160)
8	__TwigTemplate_e27dfc8a5661b56a8d3cee33c31636ec->doDisplay (line 387)
9	Twig\Template->yield (line 55)
10	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->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 94)
19	App\Controller\HomeController->index (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
(4.55%)

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 55)
18	__TwigTemplate_023b0098b976ddcc3c25d14a8e95d59d->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 94)
27	App\Controller\HomeController->index (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)

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/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping