Symfony Profiler

Query Metrics

72 Database Queries

8 Different statements

31.39 ms Query time

3 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.19 ms
(26.10%)

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 214)
7	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 63)
17	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 53)
26	App\Controller\VideoController->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)

8.09 ms
(25.78%)

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 63)
22	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 53)
31	App\Controller\VideoController->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)

5.60 ms
(17.85%)

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 63)
17	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 53)
26	App\Controller\VideoController->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)

5.29 ms
(16.84%)

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 63)
22	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 53)
31	App\Controller\VideoController->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.63 ms
(5.18%)

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:

[
  "mediatheque"
  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 = 'mediatheque' 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 214)
7	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 63)
17	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 53)
26	App\Controller\VideoController->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.49 ms
(4.75%)

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 63)
22	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 53)
31	App\Controller\VideoController->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)

0.64 ms
(2.03%)

SELECT t0.id AS id_1, t0.link AS link_2, t0.position AS position_3, t0.promoted AS promoted_4, t0.title AS title_5, t0.content AS content_6, t0.metadata AS metadata_7, t0.slug AS slug_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.enabled AS enabled_11, t0.galerie_id AS galerie_id_12, t0.categorie_id AS categorie_id_13, t0.type_video_id AS type_video_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16 FROM video t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "seminaire-sur-le-processus-delaboration-du-budget"
]

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.title AS title_5,
  t0.content AS content_6,
  t0.metadata AS metadata_7,
  t0.slug AS slug_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.enabled AS enabled_11,
  t0.galerie_id AS galerie_id_12,
  t0.categorie_id AS categorie_id_13,
  t0.type_video_id AS type_video_id_14,
  t0.created_by_id AS created_by_id_15,
  t0.updated_by_id AS updated_by_id_16
FROM
  video t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.link AS link_2, t0.position AS position_3, t0.promoted AS promoted_4, t0.title AS title_5, t0.content AS content_6, t0.metadata AS metadata_7, t0.slug AS slug_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.enabled AS enabled_11, t0.galerie_id AS galerie_id_12, t0.categorie_id AS categorie_id_13, t0.type_video_id AS type_video_id_14, t0.created_by_id AS created_by_id_15, t0.updated_by_id AS updated_by_id_16 FROM video t0 WHERE t0.slug = 'seminaire-sur-le-processus-delaboration-du-budget' 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.46 ms
(1.47%)

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 63)
19	__TwigTemplate_2fb7bbbe5cd0e8c90cc93331ac8ccfe9->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 53)
28	App\Controller\VideoController->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)

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\Video	The association App\Entity\Video#galerie refers to the inverse side field App\Entity\Galerie#videos which does not exist.
Vich\UploaderBundle\Entity\File	No errors.
App\Entity\Galerie	No errors.
App\Entity\CategorieMedia	No errors.
App\Entity\TypeVideo	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\Page	The association App\Entity\Page#equipe refers to the inverse side field App\Entity\CategorieEquipe#pages which does not exist.
App\Entity\Actualite	No errors.
App\Entity\ImageInterne	No errors.
App\Entity\Link	No errors.
App\Entity\Menu	No errors.
App\Entity\CategorieEquipe	No errors.
App\Entity\Tag	No errors.
App\Entity\Parametre	No errors.

Symfony Profiler

GET https://test.academie-sciences.bj/video/seminaire-sur-le-processus-delaboration-du-budget

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping