Symfony Profiler

Query Metrics

56 Database Queries

4 Different statements

23.89 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

11.47 ms
(48.02%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.address AS address_4, t0.location AS location_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.country AS country_8, t0.email AS email_9, t0.phone AS phone_10, t0.src AS src_11, t0.src_alt AS src_alt_12, t0.src_title AS src_title_13, t0.src_base64 AS src_base64_14, t0.favicon AS favicon_15, t0.website AS website_16, t0.sas AS sas_17, t0.rcs AS rcs_18, t0.siret AS siret_19, t0.tva AS tva_20, t0.email_contact AS email_contact_21, t0.seo_author AS seo_author_22, t0.twitter_account AS twitter_account_23, t0.twitter_card AS twitter_card_24, t0.schema_description AS schema_description_25, t0.name_bool AS name_bool_26, t0.src_bool AS src_bool_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.year_foundation AS year_foundation_30 FROM information t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "3k3239b6-d564-4fdc-6gfg-329tr47087d7"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.name AS name_3,
  t0.address AS address_4,
  t0.location AS location_5,
  t0.zip_code AS zip_code_6,
  t0.city AS city_7,
  t0.country AS country_8,
  t0.email AS email_9,
  t0.phone AS phone_10,
  t0.src AS src_11,
  t0.src_alt AS src_alt_12,
  t0.src_title AS src_title_13,
  t0.src_base64 AS src_base64_14,
  t0.favicon AS favicon_15,
  t0.website AS website_16,
  t0.sas AS sas_17,
  t0.rcs AS rcs_18,
  t0.siret AS siret_19,
  t0.tva AS tva_20,
  t0.email_contact AS email_contact_21,
  t0.seo_author AS seo_author_22,
  t0.twitter_account AS twitter_account_23,
  t0.twitter_card AS twitter_card_24,
  t0.schema_description AS schema_description_25,
  t0.name_bool AS name_bool_26,
  t0.src_bool AS src_bool_27,
  t0.created_at AS created_at_28,
  t0.updated_at AS updated_at_29,
  t0.year_foundation AS year_foundation_30
FROM
  information t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.name AS name_3, t0.address AS address_4, t0.location AS location_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.country AS country_8, t0.email AS email_9, t0.phone AS phone_10, t0.src AS src_11, t0.src_alt AS src_alt_12, t0.src_title AS src_title_13, t0.src_base64 AS src_base64_14, t0.favicon AS favicon_15, t0.website AS website_16, t0.sas AS sas_17, t0.rcs AS rcs_18, t0.siret AS siret_19, t0.tva AS tva_20, t0.email_contact AS email_contact_21, t0.seo_author AS seo_author_22, t0.twitter_account AS twitter_account_23, t0.twitter_card AS twitter_card_24, t0.schema_description AS schema_description_25, t0.name_bool AS name_bool_26, t0.src_bool AS src_bool_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.year_foundation AS year_foundation_30 FROM information t0 WHERE t0.uuid = '3k3239b6-d564-4fdc-6gfg-329tr47087d7' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 39)
5	App\Service\ParameterService->getInformation (line 1754)
6	Twig\Extension\CoreExtension::getAttribute (line 86)
7	__TwigTemplate_3e90a85af1c20992af472d5a0297d1b3->doDisplay (line 393)
8	Twig\Template->yield (line 65)
9	__TwigTemplate_6751b7b34811cac7e1111f53e202e994->doDisplay (line 393)
10	Twig\Template->yield (line 349)
11	Twig\Template->display (line 364)
12	Twig\Template->render (line 35)
13	Twig\TemplateWrapper->render (line 306)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
18	App\Controller\FooterController->privacyPolicy (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

7.18 ms
(30.08%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.title AS title_3, t0.title_fr AS title_fr_4, t0.content AS content_5, t0.content_fr AS content_fr_6, t0.src AS src_7, t0.alt AS alt_8, t0.title_src AS title_src_9, t0.status AS status_10, t0.listorder AS listorder_11, t0.category AS category_12, t0.path AS path_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keyword AS seo_keyword_16, t0.og_title AS og_title_17, t0.og_description AS og_description_18, t0.og_type AS og_type_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.robots AS robots_22, t0.description_schema_org AS description_schema_org_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.priority AS priority_26, t0.param AS param_27 FROM page t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "8f15cbbe-fc2e-4644-8595-e2b12ae30ac2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.title AS title_3,
  t0.title_fr AS title_fr_4,
  t0.content AS content_5,
  t0.content_fr AS content_fr_6,
  t0.src AS src_7,
  t0.alt AS alt_8,
  t0.title_src AS title_src_9,
  t0.status AS status_10,
  t0.listorder AS listorder_11,
  t0.category AS category_12,
  t0.path AS path_13,
  t0.seo_title AS seo_title_14,
  t0.seo_description AS seo_description_15,
  t0.seo_keyword AS seo_keyword_16,
  t0.og_title AS og_title_17,
  t0.og_description AS og_description_18,
  t0.og_type AS og_type_19,
  t0.twitter_title AS twitter_title_20,
  t0.twitter_description AS twitter_description_21,
  t0.robots AS robots_22,
  t0.description_schema_org AS description_schema_org_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.priority AS priority_26,
  t0.param AS param_27
FROM
  page t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.title AS title_3, t0.title_fr AS title_fr_4, t0.content AS content_5, t0.content_fr AS content_fr_6, t0.src AS src_7, t0.alt AS alt_8, t0.title_src AS title_src_9, t0.status AS status_10, t0.listorder AS listorder_11, t0.category AS category_12, t0.path AS path_13, t0.seo_title AS seo_title_14, t0.seo_description AS seo_description_15, t0.seo_keyword AS seo_keyword_16, t0.og_title AS og_title_17, t0.og_description AS og_description_18, t0.og_type AS og_type_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.robots AS robots_22, t0.description_schema_org AS description_schema_org_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.priority AS priority_26, t0.param AS param_27 FROM page t0 WHERE t0.uuid = '8f15cbbe-fc2e-4644-8595-e2b12ae30ac2' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 244)
5	App\Service\ParameterService->getPagePrivacyPolicy (line 1754)
6	Twig\Extension\CoreExtension::getAttribute (line 87)
7	__TwigTemplate_6751b7b34811cac7e1111f53e202e994->block_seoTitle (line 437)
8	Twig\Template->yieldBlock (line 74)
9	__TwigTemplate_3e90a85af1c20992af472d5a0297d1b3->doDisplay (line 393)
10	Twig\Template->yield (line 65)
11	__TwigTemplate_6751b7b34811cac7e1111f53e202e994->doDisplay (line 393)
12	Twig\Template->yield (line 349)
13	Twig\Template->display (line 364)
14	Twig\Template->render (line 35)
15	Twig\TemplateWrapper->render (line 306)
16	Twig\Environment->render (line 431)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
20	App\Controller\FooterController->privacyPolicy (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

3.93 ms
(16.47%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.length_token AS length_token_5, t0.size_svg AS size_svg_6, t0.size_string AS size_string_7, t0.size_link AS size_link_8, t0.size_pagination AS size_pagination_9, t0.time_inactivity AS time_inactivity_10, t0.time_password AS time_password_11, t0.status_social_network AS status_social_network_12, t0.status_register AS status_register_13, t0.status_google AS status_google_14, t0.status_inactivity AS status_inactivity_15, t0.primary_color AS primary_color_16, t0.secondary_color AS secondary_color_17, t0.background_color AS background_color_18, t0.src_admin AS src_admin_19, t0.status_multilingual AS status_multilingual_20, t0.status_cookie AS status_cookie_21, t0.time_cookie AS time_cookie_22, t0.status_footer AS status_footer_23, t0.time_change_email AS time_change_email_24, t0.maintenance AS maintenance_25, t0.status_seo AS status_seo_26, t0.calendly AS calendly_27, t0.business_prompt AS business_prompt_28, t0.business_picture_prompt AS business_picture_prompt_29, t0.header_pdf AS header_pdf_30, t0.footer_pdf AS footer_pdf_31, t0.size_pagination_product AS size_pagination_product_32, t0.video AS video_33 FROM configuration t0 WHERE t0.uuid = ? LIMIT 1

Parameters:

[
  "1b3606a6-b889-4fdc-9cef-819ea47094c1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.length_token AS length_token_5,
  t0.size_svg AS size_svg_6,
  t0.size_string AS size_string_7,
  t0.size_link AS size_link_8,
  t0.size_pagination AS size_pagination_9,
  t0.time_inactivity AS time_inactivity_10,
  t0.time_password AS time_password_11,
  t0.status_social_network AS status_social_network_12,
  t0.status_register AS status_register_13,
  t0.status_google AS status_google_14,
  t0.status_inactivity AS status_inactivity_15,
  t0.primary_color AS primary_color_16,
  t0.secondary_color AS secondary_color_17,
  t0.background_color AS background_color_18,
  t0.src_admin AS src_admin_19,
  t0.status_multilingual AS status_multilingual_20,
  t0.status_cookie AS status_cookie_21,
  t0.time_cookie AS time_cookie_22,
  t0.status_footer AS status_footer_23,
  t0.time_change_email AS time_change_email_24,
  t0.maintenance AS maintenance_25,
  t0.status_seo AS status_seo_26,
  t0.calendly AS calendly_27,
  t0.business_prompt AS business_prompt_28,
  t0.business_picture_prompt AS business_picture_prompt_29,
  t0.header_pdf AS header_pdf_30,
  t0.footer_pdf AS footer_pdf_31,
  t0.size_pagination_product AS size_pagination_product_32,
  t0.video AS video_33
FROM
  configuration t0
WHERE
  t0.uuid = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.length_token AS length_token_5, t0.size_svg AS size_svg_6, t0.size_string AS size_string_7, t0.size_link AS size_link_8, t0.size_pagination AS size_pagination_9, t0.time_inactivity AS time_inactivity_10, t0.time_password AS time_password_11, t0.status_social_network AS status_social_network_12, t0.status_register AS status_register_13, t0.status_google AS status_google_14, t0.status_inactivity AS status_inactivity_15, t0.primary_color AS primary_color_16, t0.secondary_color AS secondary_color_17, t0.background_color AS background_color_18, t0.src_admin AS src_admin_19, t0.status_multilingual AS status_multilingual_20, t0.status_cookie AS status_cookie_21, t0.time_cookie AS time_cookie_22, t0.status_footer AS status_footer_23, t0.time_change_email AS time_change_email_24, t0.maintenance AS maintenance_25, t0.status_seo AS status_seo_26, t0.calendly AS calendly_27, t0.business_prompt AS business_prompt_28, t0.business_picture_prompt AS business_picture_prompt_29, t0.header_pdf AS header_pdf_30, t0.footer_pdf AS footer_pdf_31, t0.size_pagination_product AS size_pagination_product_32, t0.video AS video_33 FROM configuration t0 WHERE t0.uuid = '1b3606a6-b889-4fdc-9cef-819ea47094c1' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
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\EventSubscriber\LocaleSubscriber->__construct (line 1183)
6	Container5YMvz1p\App_KernelDevDebugContainer::getLocaleSubscriberService (line 893)
7	Container5YMvz1p\App_KernelDevDebugContainer::{closure:Container5YMvz1p\App_KernelDevDebugContainer::getEventDispatcherService():893} (line 221)
8	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
9	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.30 ms
(5.43%)

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.status AS status_3, t0.listorder AS listorder_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.link AS link_8, t0.src AS src_9 FROM social_network t0 WHERE t0.status = ? ORDER BY t0.listorder ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.status AS status_3,
  t0.listorder AS listorder_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.title AS title_7,
  t0.link AS link_8,
  t0.src AS src_9
FROM
  social_network t0
WHERE
  t0.status = ?
ORDER BY
  t0.listorder ASC

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.status AS status_3, t0.listorder AS listorder_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.link AS link_8, t0.src AS src_9 FROM social_network t0 WHERE t0.status = 1 ORDER BY t0.listorder ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
5	App\Service\ParameterService->getSocialNetworks (line 1754)
6	Twig\Extension\CoreExtension::getAttribute (line 187)
7	__TwigTemplate_3e90a85af1c20992af472d5a0297d1b3->doDisplay (line 393)
8	Twig\Template->yield (line 65)
9	__TwigTemplate_6751b7b34811cac7e1111f53e202e994->doDisplay (line 393)
10	Twig\Template->yield (line 349)
11	Twig\Template->display (line 364)
12	Twig\Template->render (line 35)
13	Twig\TemplateWrapper->render (line 306)
14	Twig\Environment->render (line 431)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 33)
18	App\Controller\FooterController->privacyPolicy (line 183)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	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\Configuration	No errors.
App\Entity\Page	No errors.
App\Entity\Information	No errors.
App\Entity\SocialNetwork	No errors.

Symfony Profiler

GET https://prodelium.com/politique-de-confidentialite

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping