Symfony Profiler

Query Metrics

75 Database Queries

11 Different statements

34.08 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.97 ms
(26.31%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_page AS is_page_3, t0.title AS title_4, t0.route_name AS route_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.parent_id AS parent_id_9, t0.element_id AS element_id_10, t0.lien_interne_id AS lien_interne_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM menu t0 WHERE t0.parent_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_page AS is_page_3,
  t0.title AS title_4,
  t0.route_name AS route_name_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.enabled AS enabled_8,
  t0.parent_id AS parent_id_9,
  t0.element_id AS element_id_10,
  t0.lien_interne_id AS lien_interne_id_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  menu t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_page AS is_page_3, t0.title AS title_4, t0.route_name AS route_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.parent_id AS parent_id_9, t0.element_id AS element_id_10, t0.lien_interne_id AS lien_interne_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM menu t0 WHERE t0.parent_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1834)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1779)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 1230)
9	Twig\Extension\CoreExtension::length (line 78)
10	__TwigTemplate_05c806418e72d7ee987bba3eb10695bf->doDisplay (line 387)
11	Twig\Template->yield (line 85)
12	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->block_body (line 431)
13	Twig\Template->yieldBlock (line 193)
14	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
15	Twig\Template->yieldBlock (line 53)
16	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
17	Twig\Template->yield (line 61)
18	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->doDisplay (line 387)
21	Twig\Template->yield (line 62)
22	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->doDisplay (line 387)
23	Twig\Template->yield (line 343)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 35)
26	Twig\TemplateWrapper->render (line 320)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
31	App\Controller\DocumentController->show (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

7.62 ms
(22.35%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 56)
5	App\Controller\DocumentController->show (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

5.48 ms
(16.07%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.route_name AS route_name_3, t0.params AS params_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM link t0 WHERE t0.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.route_name AS route_name_3,
  t0.params AS params_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.enabled AS enabled_7,
  t0.created_by_id AS created_by_id_8,
  t0.updated_by_id AS updated_by_id_9
FROM
  link t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.route_name AS route_name_3, t0.params AS params_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.enabled AS enabled_7, t0.created_by_id AS created_by_id_8, t0.updated_by_id AS updated_by_id_9 FROM link t0 WHERE t0.id = 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Link::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Link->__get (line 68)
8	App\Entity\Link->getParams (line 1864)
9	Twig\Extension\CoreExtension::getAttribute (line 174)
10	__TwigTemplate_05c806418e72d7ee987bba3eb10695bf->doDisplay (line 387)
11	Twig\Template->yield (line 85)
12	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->block_body (line 431)
13	Twig\Template->yieldBlock (line 193)
14	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
15	Twig\Template->yieldBlock (line 53)
16	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
17	Twig\Template->yield (line 61)
18	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->doDisplay (line 387)
21	Twig\Template->yield (line 62)
22	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->doDisplay (line 387)
23	Twig\Template->yield (line 343)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 35)
26	Twig\TemplateWrapper->render (line 320)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
31	App\Controller\DocumentController->show (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

4.91 ms
(14.39%)

SELECT t0.id AS id_1, t0.facebook_url AS facebook_url_2, t0.facebook_enabled AS facebook_enabled_3, t0.twitter_url AS twitter_url_4, t0.twitter_enabled AS twitter_enabled_5, t0.instagram_url AS instagram_url_6, t0.instagram_enabled AS instagram_enabled_7, t0.newletter_enabled AS newletter_enabled_8, t0.email_contact AS email_contact_9, t0.email_guide AS email_guide_10, t0.email_partenaire AS email_partenaire_11, t0.email_donation AS email_donation_12, t0.email_leg AS email_leg_13, t0.maildsn AS maildsn_14, t0.message_leg AS message_leg_15, t0.message_don AS message_don_16, t0.message_guide AS message_guide_17, t0.message_contact AS message_contact_18, t0.message_confirmation AS message_confirmation_19, t0.message_partenaire AS message_partenaire_20, t0.youtube_url AS youtube_url_21, t0.youtube_enabled AS youtube_enabled_22, t0.linkedin_url AS linkedin_url_23, t0.linkedin_enabled AS linkedin_enabled_24 FROM parametre t0 ORDER BY t0.id ASC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.facebook_url AS facebook_url_2,
  t0.facebook_enabled AS facebook_enabled_3,
  t0.twitter_url AS twitter_url_4,
  t0.twitter_enabled AS twitter_enabled_5,
  t0.instagram_url AS instagram_url_6,
  t0.instagram_enabled AS instagram_enabled_7,
  t0.newletter_enabled AS newletter_enabled_8,
  t0.email_contact AS email_contact_9,
  t0.email_guide AS email_guide_10,
  t0.email_partenaire AS email_partenaire_11,
  t0.email_donation AS email_donation_12,
  t0.email_leg AS email_leg_13,
  t0.maildsn AS maildsn_14,
  t0.message_leg AS message_leg_15,
  t0.message_don AS message_don_16,
  t0.message_guide AS message_guide_17,
  t0.message_contact AS message_contact_18,
  t0.message_confirmation AS message_confirmation_19,
  t0.message_partenaire AS message_partenaire_20,
  t0.youtube_url AS youtube_url_21,
  t0.youtube_enabled AS youtube_enabled_22,
  t0.linkedin_url AS linkedin_url_23,
  t0.linkedin_enabled AS linkedin_enabled_24
FROM
  parametre t0
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.facebook_url AS facebook_url_2, t0.facebook_enabled AS facebook_enabled_3, t0.twitter_url AS twitter_url_4, t0.twitter_enabled AS twitter_enabled_5, t0.instagram_url AS instagram_url_6, t0.instagram_enabled AS instagram_enabled_7, t0.newletter_enabled AS newletter_enabled_8, t0.email_contact AS email_contact_9, t0.email_guide AS email_guide_10, t0.email_partenaire AS email_partenaire_11, t0.email_donation AS email_donation_12, t0.email_leg AS email_leg_13, t0.maildsn AS maildsn_14, t0.message_leg AS message_leg_15, t0.message_don AS message_don_16, t0.message_guide AS message_guide_17, t0.message_contact AS message_contact_18, t0.message_confirmation AS message_confirmation_19, t0.message_partenaire AS message_partenaire_20, t0.youtube_url AS youtube_url_21, t0.youtube_enabled AS youtube_enabled_22, t0.linkedin_url AS linkedin_url_23, t0.linkedin_enabled AS linkedin_enabled_24 FROM parametre t0 ORDER BY t0.id ASC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 25)
5	App\Controller\ParametreController->parametre (line 1864)
6	Twig\Extension\CoreExtension::getAttribute (line 55)
7	__TwigTemplate_95a950d68beea27161c16ae480fb5dad->doDisplay (line 387)
8	Twig\Template->yield (line 198)
9	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
10	Twig\Template->yieldBlock (line 53)
11	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
12	Twig\Template->yield (line 61)
13	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->doDisplay (line 387)
16	Twig\Template->yield (line 62)
17	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
26	App\Controller\DocumentController->show (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.79 ms
(5.25%)

SELECT t0.id AS id_1, t0.link AS link_2, t0.position AS position_3, t0.promoted AS promoted_4, t0.url AS url_5, t0.url_text AS url_text_6, t0.title AS title_7, t0.content AS content_8, t0.metadata AS metadata_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.enabled AS enabled_13, t0.image_name AS image_name_14, t0.image_original_name AS image_original_name_15, t0.image_mime_type AS image_mime_type_16, t0.image_size AS image_size_17, t0.image_dimensions AS image_dimensions_18, t0.parent_id AS parent_id_19, t0.equipe_id AS equipe_id_20, t0.mediatheque_id AS mediatheque_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM page t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.link AS link_2,
  t0.position AS position_3,
  t0.promoted AS promoted_4,
  t0.url AS url_5,
  t0.url_text AS url_text_6,
  t0.title AS title_7,
  t0.content AS content_8,
  t0.metadata AS metadata_9,
  t0.slug AS slug_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.enabled AS enabled_13,
  t0.image_name AS image_name_14,
  t0.image_original_name AS image_original_name_15,
  t0.image_mime_type AS image_mime_type_16,
  t0.image_size AS image_size_17,
  t0.image_dimensions AS image_dimensions_18,
  t0.parent_id AS parent_id_19,
  t0.equipe_id AS equipe_id_20,
  t0.mediatheque_id AS mediatheque_id_21,
  t0.created_by_id AS created_by_id_22,
  t0.updated_by_id AS updated_by_id_23
FROM
  page t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.link AS link_2, t0.position AS position_3, t0.promoted AS promoted_4, t0.url AS url_5, t0.url_text AS url_text_6, t0.title AS title_7, t0.content AS content_8, t0.metadata AS metadata_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.enabled AS enabled_13, t0.image_name AS image_name_14, t0.image_original_name AS image_original_name_15, t0.image_mime_type AS image_mime_type_16, t0.image_size AS image_size_17, t0.image_dimensions AS image_dimensions_18, t0.parent_id AS parent_id_19, t0.equipe_id AS equipe_id_20, t0.mediatheque_id AS mediatheque_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM page t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Page::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Page->__get (line 80)
8	App\Entity\Page->getParent (line 1864)
9	Twig\Extension\CoreExtension::getAttribute (line 154)
10	__TwigTemplate_05c806418e72d7ee987bba3eb10695bf->doDisplay (line 387)
11	Twig\Template->yield (line 85)
12	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->block_body (line 431)
13	Twig\Template->yieldBlock (line 193)
14	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
15	Twig\Template->yieldBlock (line 53)
16	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
17	Twig\Template->yield (line 61)
18	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
19	Twig\Template->yield (line 56)
20	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->doDisplay (line 387)
21	Twig\Template->yield (line 62)
22	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->doDisplay (line 387)
23	Twig\Template->yield (line 343)
24	Twig\Template->display (line 358)
25	Twig\Template->render (line 35)
26	Twig\TemplateWrapper->render (line 320)
27	Twig\Environment->render (line 431)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
30	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
31	App\Controller\DocumentController->show (line 183)
32	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
33	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
34	Symfony\Component\HttpKernel\Kernel->handle (line 35)
35	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
36	require_once (line 5)

1.74 ms
(5.12%)

SELECT t0.id AS id_1, t0.isdefault AS isdefault_2, t0.title AS title_3, t0.content AS content_4, t0.metadata AS metadata_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.image_name AS image_name_10, t0.image_original_name AS image_original_name_11, t0.image_mime_type AS image_mime_type_12, t0.image_size AS image_size_13, t0.image_dimensions AS image_dimensions_14, t0.link_id AS link_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM image_interne t0 WHERE t0.isdefault = ? AND t0.enabled = ? LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.isdefault AS isdefault_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.metadata AS metadata_5,
  t0.slug AS slug_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.enabled AS enabled_9,
  t0.image_name AS image_name_10,
  t0.image_original_name AS image_original_name_11,
  t0.image_mime_type AS image_mime_type_12,
  t0.image_size AS image_size_13,
  t0.image_dimensions AS image_dimensions_14,
  t0.link_id AS link_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.updated_by_id AS updated_by_id_17
FROM
  image_interne t0
WHERE
  t0.isdefault = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.isdefault AS isdefault_2, t0.title AS title_3, t0.content AS content_4, t0.metadata AS metadata_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.image_name AS image_name_10, t0.image_original_name AS image_original_name_11, t0.image_mime_type AS image_mime_type_12, t0.image_size AS image_size_13, t0.image_dimensions AS image_dimensions_14, t0.link_id AS link_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM image_interne t0 WHERE t0.isdefault = 1 AND t0.enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 18)
5	App\Controller\ImageInterneController->searchImage (line 1864)
6	Twig\Extension\CoreExtension::getAttribute (line 193)
7	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->block_title_img (line 431)
8	Twig\Template->yieldBlock (line 126)
9	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
10	Twig\Template->yieldBlock (line 53)
11	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
12	Twig\Template->yield (line 61)
13	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->doDisplay (line 387)
16	Twig\Template->yield (line 62)
17	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
26	App\Controller\DocumentController->show (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

1.50 ms
(4.41%)

SELECT t0.id AS id_1, t0.isdefault AS isdefault_2, t0.title AS title_3, t0.content AS content_4, t0.metadata AS metadata_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.image_name AS image_name_10, t0.image_original_name AS image_original_name_11, t0.image_mime_type AS image_mime_type_12, t0.image_size AS image_size_13, t0.image_dimensions AS image_dimensions_14, t0.link_id AS link_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM image_interne t0 WHERE t0.slug = ? AND t0.enabled = ? LIMIT 1

Parameters:

[
  "documentheque"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.isdefault AS isdefault_2,
  t0.title AS title_3,
  t0.content AS content_4,
  t0.metadata AS metadata_5,
  t0.slug AS slug_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.enabled AS enabled_9,
  t0.image_name AS image_name_10,
  t0.image_original_name AS image_original_name_11,
  t0.image_mime_type AS image_mime_type_12,
  t0.image_size AS image_size_13,
  t0.image_dimensions AS image_dimensions_14,
  t0.link_id AS link_id_15,
  t0.created_by_id AS created_by_id_16,
  t0.updated_by_id AS updated_by_id_17
FROM
  image_interne t0
WHERE
  t0.slug = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.isdefault AS isdefault_2, t0.title AS title_3, t0.content AS content_4, t0.metadata AS metadata_5, t0.slug AS slug_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.enabled AS enabled_9, t0.image_name AS image_name_10, t0.image_original_name AS image_original_name_11, t0.image_mime_type AS image_mime_type_12, t0.image_size AS image_size_13, t0.image_dimensions AS image_dimensions_14, t0.link_id AS link_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM image_interne t0 WHERE t0.slug = 'documentheque' AND t0.enabled = 1 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 25)
5	App\Controller\ImageInterneController->searchImage (line 1864)
6	Twig\Extension\CoreExtension::getAttribute (line 193)
7	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->block_title_img (line 431)
8	Twig\Template->yieldBlock (line 126)
9	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
10	Twig\Template->yieldBlock (line 53)
11	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
12	Twig\Template->yield (line 61)
13	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
14	Twig\Template->yield (line 56)
15	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->doDisplay (line 387)
16	Twig\Template->yield (line 62)
17	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->doDisplay (line 387)
18	Twig\Template->yield (line 343)
19	Twig\Template->display (line 358)
20	Twig\Template->render (line 35)
21	Twig\TemplateWrapper->render (line 320)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
26	App\Controller\DocumentController->show (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

0.69 ms
(2.03%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_promoted AS is_promoted_3, t0.other_autors AS other_autors_4, t0.listen_number AS listen_number_5, t0.download_number AS download_number_6, t0.title AS title_7, t0.content AS content_8, t0.metadata AS metadata_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.enabled AS enabled_13, t0.link_name AS link_name_14, t0.link_original_name AS link_original_name_15, t0.link_mime_type AS link_mime_type_16, t0.link_size AS link_size_17, t0.link_dimensions AS link_dimensions_18, t0.categorie_fichier_id AS categorie_fichier_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM fichier t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "appel-a-contribution-pour-un-colloque-a-luniversite-de-parakou-les-20-et-21-fevrier-2025"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_promoted AS is_promoted_3,
  t0.other_autors AS other_autors_4,
  t0.listen_number AS listen_number_5,
  t0.download_number AS download_number_6,
  t0.title AS title_7,
  t0.content AS content_8,
  t0.metadata AS metadata_9,
  t0.slug AS slug_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.enabled AS enabled_13,
  t0.link_name AS link_name_14,
  t0.link_original_name AS link_original_name_15,
  t0.link_mime_type AS link_mime_type_16,
  t0.link_size AS link_size_17,
  t0.link_dimensions AS link_dimensions_18,
  t0.categorie_fichier_id AS categorie_fichier_id_19,
  t0.created_by_id AS created_by_id_20,
  t0.updated_by_id AS updated_by_id_21
FROM
  fichier t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_promoted AS is_promoted_3, t0.other_autors AS other_autors_4, t0.listen_number AS listen_number_5, t0.download_number AS download_number_6, t0.title AS title_7, t0.content AS content_8, t0.metadata AS metadata_9, t0.slug AS slug_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.enabled AS enabled_13, t0.link_name AS link_name_14, t0.link_original_name AS link_original_name_15, t0.link_mime_type AS link_mime_type_16, t0.link_size AS link_size_17, t0.link_dimensions AS link_dimensions_18, t0.categorie_fichier_id AS categorie_fichier_id_19, t0.created_by_id AS created_by_id_20, t0.updated_by_id AS updated_by_id_21 FROM fichier t0 WHERE t0.slug = 'appel-a-contribution-pour-un-colloque-a-luniversite-de-parakou-les-20-et-21-fevrier-2025' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 90)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.63 ms
(1.85%)

UPDATE fichier SET listen_number = ?, updated_at = ? WHERE id = ?

Parameters:

[
  4271
  "2026-10-22 16:38:31"
  7
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  fichier
SET
  listen_number = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE fichier SET listen_number = 4271, updated_at = '2026-10-22 16:38:31' WHERE id = 7;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 56)
7	App\Controller\DocumentController->show (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.49 ms
(1.44%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_page AS is_page_3, t0.title AS title_4, t0.route_name AS route_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.parent_id AS parent_id_9, t0.element_id AS element_id_10, t0.lien_interne_id AS lien_interne_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM menu t0 WHERE t0.enabled = ? ORDER BY t0.parent_id ASC, t0.position ASC, t0.title ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.is_page AS is_page_3,
  t0.title AS title_4,
  t0.route_name AS route_name_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.enabled AS enabled_8,
  t0.parent_id AS parent_id_9,
  t0.element_id AS element_id_10,
  t0.lien_interne_id AS lien_interne_id_11,
  t0.created_by_id AS created_by_id_12,
  t0.updated_by_id AS updated_by_id_13
FROM
  menu t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.parent_id ASC,
  t0.position ASC,
  t0.title ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.is_page AS is_page_3, t0.title AS title_4, t0.route_name AS route_name_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.enabled AS enabled_8, t0.parent_id AS parent_id_9, t0.element_id AS element_id_10, t0.lien_interne_id AS lien_interne_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM menu t0 WHERE t0.enabled = 1 ORDER BY t0.parent_id ASC, t0.position ASC, t0.title ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 31)
5	App\Controller\ParametreController->listMenu (line 1864)
6	Twig\Extension\CoreExtension::getAttribute (line 67)
7	__TwigTemplate_05c806418e72d7ee987bba3eb10695bf->doDisplay (line 387)
8	Twig\Template->yield (line 85)
9	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->block_body (line 431)
10	Twig\Template->yieldBlock (line 193)
11	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
12	Twig\Template->yieldBlock (line 53)
13	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
14	Twig\Template->yield (line 61)
15	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
16	Twig\Template->yield (line 56)
17	__TwigTemplate_f5e46dbc34b03213446f2944f8f7301e->doDisplay (line 387)
18	Twig\Template->yield (line 62)
19	__TwigTemplate_7d0c3aad93b9d75c3b5f0c5b31c14aa9->doDisplay (line 387)
20	Twig\Template->yield (line 343)
21	Twig\Template->display (line 358)
22	Twig\Template->render (line 35)
23	Twig\TemplateWrapper->render (line 320)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 58)
28	App\Controller\DocumentController->show (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.26 ms
(0.78%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 56)
4	App\Controller\DocumentController->show (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Fichier	No errors.
App\Entity\CategorieFichier	No errors.
App\Entity\User	The field App\Entity\User#pages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Page#created_by does not contain the required 'inversedBy="pages"' attribute.
App\Entity\Artiste	No errors.
App\Entity\ImageInterne	No errors.
App\Entity\Link	No errors.
App\Entity\Menu	No errors.
App\Entity\Page	The association App\Entity\Page#equipe refers to the inverse side field App\Entity\CategorieEquipe#pages which does not exist.
App\Entity\CategorieEquipe	No errors.
App\Entity\Galerie	No errors.
App\Entity\Tag	No errors.
App\Entity\Video	The association App\Entity\Video#galerie refers to the inverse side field App\Entity\Galerie#videos which does not exist.
App\Entity\Parametre	No errors.

Symfony Profiler

GET https://test.academie-sciences.bj/document/appel-a-contribution-pour-un-colloque-a-luniversite-de-parakou-les-20-et-21-fevrier-2025

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping