Symfony Profiler

Query Metrics

70 Database Queries

12 Different statements

26.69 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.48 ms
(35.52%)

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 162)
12	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->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_28b8f600b6faccdee0b2356cd51c54ce->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 52)
29	App\Controller\CitaController->afficher (line 24)
30	App\Controller\CitaController->index (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

5.94 ms
(22.26%)

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_28b8f600b6faccdee0b2356cd51c54ce->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 52)
24	App\Controller\CitaController->afficher (line 24)
25	App\Controller\CitaController->index (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

5.88 ms
(22.05%)

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 162)
12	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->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_28b8f600b6faccdee0b2356cd51c54ce->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 52)
29	App\Controller\CitaController->afficher (line 24)
30	App\Controller\CitaController->index (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

1.70 ms
(6.39%)

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 162)
12	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->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_28b8f600b6faccdee0b2356cd51c54ce->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 52)
29	App\Controller\CitaController->afficher (line 24)
30	App\Controller\CitaController->index (line 183)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 5)

0.71 ms
(2.66%)

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero AS numero_3, t0.theme AS theme_4, t0.lieu AS lieu_5, t0.date_conference AS date_conference_6, t0.presentation AS presentation_7, t0.publication AS publication_8, t0.consignes AS consignes_9, t0.evaluation AS evaluation_10, t0.soumission_url AS soumission_url_11, t0.site_url AS site_url_12, t0.template_url AS template_url_13, t0.contact_email AS contact_email_14, t0.en_cours AS en_cours_15, t0.actif AS actif_16, t0.media_type AS media_type_17, t0.image_name AS image_name_18, t0.updated_at AS updated_at_19, t0.video_url AS video_url_20 FROM cita_edition t0 WHERE t0.actif = ? AND t0.en_cours = ? ORDER BY t0.annee DESC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.numero AS numero_3,
  t0.theme AS theme_4,
  t0.lieu AS lieu_5,
  t0.date_conference AS date_conference_6,
  t0.presentation AS presentation_7,
  t0.publication AS publication_8,
  t0.consignes AS consignes_9,
  t0.evaluation AS evaluation_10,
  t0.soumission_url AS soumission_url_11,
  t0.site_url AS site_url_12,
  t0.template_url AS template_url_13,
  t0.contact_email AS contact_email_14,
  t0.en_cours AS en_cours_15,
  t0.actif AS actif_16,
  t0.media_type AS media_type_17,
  t0.image_name AS image_name_18,
  t0.updated_at AS updated_at_19,
  t0.video_url AS video_url_20
FROM
  cita_edition t0
WHERE
  t0.actif = ?
  AND t0.en_cours = ?
ORDER BY
  t0.annee DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero AS numero_3, t0.theme AS theme_4, t0.lieu AS lieu_5, t0.date_conference AS date_conference_6, t0.presentation AS presentation_7, t0.publication AS publication_8, t0.consignes AS consignes_9, t0.evaluation AS evaluation_10, t0.soumission_url AS soumission_url_11, t0.site_url AS site_url_12, t0.template_url AS template_url_13, t0.contact_email AS contact_email_14, t0.en_cours AS en_cours_15, t0.actif AS actif_16, t0.media_type AS media_type_17, t0.image_name AS image_name_18, t0.updated_at AS updated_at_19, t0.video_url AS video_url_20 FROM cita_edition t0 WHERE t0.actif = 1 AND t0.en_cours = 1 ORDER BY t0.annee DESC 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 21)
4	App\Controller\CitaController->index (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)

0.58 ms
(2.15%)

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 162)
9	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->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_28b8f600b6faccdee0b2356cd51c54ce->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 52)
26	App\Controller\CitaController->afficher (line 24)
27	App\Controller\CitaController->index (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.47 ms
(1.75%)

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero AS numero_3, t0.theme AS theme_4, t0.lieu AS lieu_5, t0.date_conference AS date_conference_6, t0.presentation AS presentation_7, t0.publication AS publication_8, t0.consignes AS consignes_9, t0.evaluation AS evaluation_10, t0.soumission_url AS soumission_url_11, t0.site_url AS site_url_12, t0.template_url AS template_url_13, t0.contact_email AS contact_email_14, t0.en_cours AS en_cours_15, t0.actif AS actif_16, t0.media_type AS media_type_17, t0.image_name AS image_name_18, t0.updated_at AS updated_at_19, t0.video_url AS video_url_20 FROM cita_edition t0 WHERE t0.actif = ? ORDER BY t0.annee DESC LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.numero AS numero_3,
  t0.theme AS theme_4,
  t0.lieu AS lieu_5,
  t0.date_conference AS date_conference_6,
  t0.presentation AS presentation_7,
  t0.publication AS publication_8,
  t0.consignes AS consignes_9,
  t0.evaluation AS evaluation_10,
  t0.soumission_url AS soumission_url_11,
  t0.site_url AS site_url_12,
  t0.template_url AS template_url_13,
  t0.contact_email AS contact_email_14,
  t0.en_cours AS en_cours_15,
  t0.actif AS actif_16,
  t0.media_type AS media_type_17,
  t0.image_name AS image_name_18,
  t0.updated_at AS updated_at_19,
  t0.video_url AS video_url_20
FROM
  cita_edition t0
WHERE
  t0.actif = ?
ORDER BY
  t0.annee DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero AS numero_3, t0.theme AS theme_4, t0.lieu AS lieu_5, t0.date_conference AS date_conference_6, t0.presentation AS presentation_7, t0.publication AS publication_8, t0.consignes AS consignes_9, t0.evaluation AS evaluation_10, t0.soumission_url AS soumission_url_11, t0.site_url AS site_url_12, t0.template_url AS template_url_13, t0.contact_email AS contact_email_14, t0.en_cours AS en_cours_15, t0.actif AS actif_16, t0.media_type AS media_type_17, t0.image_name AS image_name_18, t0.updated_at AS updated_at_19, t0.video_url AS video_url_20 FROM cita_edition t0 WHERE t0.actif = 1 ORDER BY t0.annee DESC 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 22)
4	App\Controller\CitaController->index (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)

0.42 ms
(1.58%)

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero AS numero_3, t0.theme AS theme_4, t0.lieu AS lieu_5, t0.date_conference AS date_conference_6, t0.presentation AS presentation_7, t0.publication AS publication_8, t0.consignes AS consignes_9, t0.evaluation AS evaluation_10, t0.soumission_url AS soumission_url_11, t0.site_url AS site_url_12, t0.template_url AS template_url_13, t0.contact_email AS contact_email_14, t0.en_cours AS en_cours_15, t0.actif AS actif_16, t0.media_type AS media_type_17, t0.image_name AS image_name_18, t0.updated_at AS updated_at_19, t0.video_url AS video_url_20 FROM cita_edition t0 WHERE t0.actif = ? ORDER BY t0.annee ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.annee AS annee_2,
  t0.numero AS numero_3,
  t0.theme AS theme_4,
  t0.lieu AS lieu_5,
  t0.date_conference AS date_conference_6,
  t0.presentation AS presentation_7,
  t0.publication AS publication_8,
  t0.consignes AS consignes_9,
  t0.evaluation AS evaluation_10,
  t0.soumission_url AS soumission_url_11,
  t0.site_url AS site_url_12,
  t0.template_url AS template_url_13,
  t0.contact_email AS contact_email_14,
  t0.en_cours AS en_cours_15,
  t0.actif AS actif_16,
  t0.media_type AS media_type_17,
  t0.image_name AS image_name_18,
  t0.updated_at AS updated_at_19,
  t0.video_url AS video_url_20
FROM
  cita_edition t0
WHERE
  t0.actif = ?
ORDER BY
  t0.annee ASC

SELECT t0.id AS id_1, t0.annee AS annee_2, t0.numero AS numero_3, t0.theme AS theme_4, t0.lieu AS lieu_5, t0.date_conference AS date_conference_6, t0.presentation AS presentation_7, t0.publication AS publication_8, t0.consignes AS consignes_9, t0.evaluation AS evaluation_10, t0.soumission_url AS soumission_url_11, t0.site_url AS site_url_12, t0.template_url AS template_url_13, t0.contact_email AS contact_email_14, t0.en_cours AS en_cours_15, t0.actif AS actif_16, t0.media_type AS media_type_17, t0.image_name AS image_name_18, t0.updated_at AS updated_at_19, t0.video_url AS video_url_20 FROM cita_edition t0 WHERE t0.actif = 1 ORDER BY t0.annee 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 43)
4	App\Controller\CitaController->afficher (line 24)
5	App\Controller\CitaController->index (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)

0.40 ms
(1.51%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.titre AS titre_3, t0.sujets AS sujets_4, t0.edition_id AS edition_id_5 FROM cita_track t0 WHERE t0.edition_id = ? ORDER BY t0.position 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.titre AS titre_3,
  t0.sujets AS sujets_4,
  t0.edition_id AS edition_id_5
FROM
  cita_track t0
WHERE
  t0.edition_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.titre AS titre_3, t0.sujets AS sujets_4, t0.edition_id AS edition_id_5 FROM cita_track t0 WHERE t0.edition_id = 1 ORDER BY t0.position ASC;

#	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 307)
10	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->block_body (line 431)
11	Twig\Template->yieldBlock (line 193)
12	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
13	Twig\Template->yieldBlock (line 53)
14	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
15	Twig\Template->yield (line 61)
16	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->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 52)
27	App\Controller\CitaController->afficher (line 24)
28	App\Controller\CitaController->index (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.39 ms
(1.47%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.legende AS legende_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.edition_id AS edition_id_6 FROM cita_image t0 WHERE t0.edition_id = ? ORDER BY t0.position 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.legende AS legende_3,
  t0.image_name AS image_name_4,
  t0.updated_at AS updated_at_5,
  t0.edition_id AS edition_id_6
FROM
  cita_image t0
WHERE
  t0.edition_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.legende AS legende_3, t0.image_name AS image_name_4, t0.updated_at AS updated_at_5, t0.edition_id AS edition_id_6 FROM cita_image t0 WHERE t0.edition_id = 1 ORDER BY t0.position ASC;

#	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 506)
10	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->block_body (line 431)
11	Twig\Template->yieldBlock (line 193)
12	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
13	Twig\Template->yieldBlock (line 53)
14	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
15	Twig\Template->yield (line 61)
16	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->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 52)
27	App\Controller\CitaController->afficher (line 24)
28	App\Controller\CitaController->index (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.37 ms
(1.38%)

SELECT t0.id AS id_1, t0.groupe AS groupe_2, t0.position AS position_3, t0.nom AS nom_4, t0.institution AS institution_5, t0.pays AS pays_6, t0.role AS role_7, t0.edition_id AS edition_id_8 FROM cita_membre t0 WHERE t0.edition_id = ? ORDER BY t0.position ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.groupe AS groupe_2,
  t0.position AS position_3,
  t0.nom AS nom_4,
  t0.institution AS institution_5,
  t0.pays AS pays_6,
  t0.role AS role_7,
  t0.edition_id AS edition_id_8
FROM
  cita_membre t0
WHERE
  t0.edition_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.groupe AS groupe_2, t0.position AS position_3, t0.nom AS nom_4, t0.institution AS institution_5, t0.pays AS pays_6, t0.role AS role_7, t0.edition_id AS edition_id_8 FROM cita_membre t0 WHERE t0.edition_id = 1 ORDER BY t0.position ASC;

#	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 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 47)
8	App\Controller\CitaController->afficher (line 24)
9	App\Controller\CitaController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.34 ms
(1.28%)

SELECT t0.id AS id_1, t0.position AS position_2, t0.libelle AS libelle_3, t0.date_texte AS date_texte_4, t0.edition_id AS edition_id_5 FROM cita_date t0 WHERE t0.edition_id = ? ORDER BY t0.position 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.libelle AS libelle_3,
  t0.date_texte AS date_texte_4,
  t0.edition_id AS edition_id_5
FROM
  cita_date t0
WHERE
  t0.edition_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.libelle AS libelle_3, t0.date_texte AS date_texte_4, t0.edition_id AS edition_id_5 FROM cita_date t0 WHERE t0.edition_id = 1 ORDER BY t0.position ASC;

#	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 386)
10	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->block_body (line 431)
11	Twig\Template->yieldBlock (line 193)
12	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->block_html (line 431)
13	Twig\Template->yieldBlock (line 53)
14	__TwigTemplate_2625e891517ec92d15cfc52d02504223->doDisplay (line 387)
15	Twig\Template->yield (line 61)
16	__TwigTemplate_1e8ef709557abf3bc5a6037ea3c1a98d->doDisplay (line 387)
17	Twig\Template->yield (line 56)
18	__TwigTemplate_28b8f600b6faccdee0b2356cd51c54ce->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 52)
27	App\Controller\CitaController->afficher (line 24)
28	App\Controller\CitaController->index (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)

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\CitaEdition	No errors.
App\Entity\CitaTrack	No errors.
App\Entity\CitaDate	No errors.
App\Entity\CitaMembre	No errors.
App\Entity\CitaImage	No errors.
App\Entity\Menu	No errors.
Vich\UploaderBundle\Entity\File	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\Link	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\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/cita

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping