Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

1.57 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.70 ms
(44.42%)

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.name AS name_3, t0.code AS code_4, t0.flag AS flag_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM languages t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.name AS name_3,
  t0.code AS code_4,
  t0.flag AS flag_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  languages t0

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.name AS name_3, t0.code AS code_4, t0.flag AS flag_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM languages t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 49)
5	App\Twig\FunctionExtension->__construct (line 2179)
6	ContainerPC8Rms8\App_KernelDevDebugContainer::getTwigService (line 22)
7	ContainerPC8Rms8\getRenderBlocService::do (line 599)
8	ContainerPC8Rms8\App_KernelDevDebugContainer->load (line 23)
9	ContainerPC8Rms8\getPageCmsControllerService::do (line 599)
10	ContainerPC8Rms8\App_KernelDevDebugContainer->load (line 230)
11	Symfony\Component\DependencyInjection\Container::make (line 212)
12	Symfony\Component\DependencyInjection\Container->get (line 40)
13	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
14	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 106)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 74)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.27 ms
(17.28%)

SELECT t0.id AS id_1, t0.actif_bar_serach AS actif_bar_serach_2, t0.actif_titre AS actif_titre_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.tel AS tel_6, t0.email_site AS email_site_7, t0.image AS image_8, t0.lien_carte AS lien_carte_9, t0.apercu_image_lien AS apercu_image_lien_10, t0.image_header AS image_header_11, t0.image_footer AS image_footer_12, t0.maintenance AS maintenance_13, t0.htaccess_val AS htaccess_val_14, t0.meta_index AS meta_index_15, t0.meta_follow AS meta_follow_16, t0.robots AS robots_17, t0.analytics AS analytics_18, t0.cle_key AS cle_key_19, t0.cle_secret AS cle_secret_20, t0.tag_managerhead AS tag_managerhead_21, t0.tag_managerbody AS tag_managerbody_22, t0.cle_map AS cle_map_23, t0.active_smtp AS active_smtp_24, t0.email_from AS email_from_25, t0.email_sender AS email_sender_26, t0.host_smtp AS host_smtp_27, t0.type_cryptage AS type_cryptage_28, t0.port_tls AS port_tls_29, t0.port_ssl AS port_ssl_30, t0.smtp_user AS smtp_user_31, t0.smtp_pass AS smtp_pass_32, t0.slug_url AS slug_url_33, t0.lien_facebook AS lien_facebook_34, t0.lien_google_plus AS lien_google_plus_35, t0.lien_youtube AS lien_youtube_36, t0.lien_instegram AS lien_instegram_37 FROM parametre_site t0 ORDER BY t0.id DESC LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.actif_bar_serach AS actif_bar_serach_2,
  t0.actif_titre AS actif_titre_3,
  t0.email AS email_4,
  t0.adresse AS adresse_5,
  t0.tel AS tel_6,
  t0.email_site AS email_site_7,
  t0.image AS image_8,
  t0.lien_carte AS lien_carte_9,
  t0.apercu_image_lien AS apercu_image_lien_10,
  t0.image_header AS image_header_11,
  t0.image_footer AS image_footer_12,
  t0.maintenance AS maintenance_13,
  t0.htaccess_val AS htaccess_val_14,
  t0.meta_index AS meta_index_15,
  t0.meta_follow AS meta_follow_16,
  t0.robots AS robots_17,
  t0.analytics AS analytics_18,
  t0.cle_key AS cle_key_19,
  t0.cle_secret AS cle_secret_20,
  t0.tag_managerhead AS tag_managerhead_21,
  t0.tag_managerbody AS tag_managerbody_22,
  t0.cle_map AS cle_map_23,
  t0.active_smtp AS active_smtp_24,
  t0.email_from AS email_from_25,
  t0.email_sender AS email_sender_26,
  t0.host_smtp AS host_smtp_27,
  t0.type_cryptage AS type_cryptage_28,
  t0.port_tls AS port_tls_29,
  t0.port_ssl AS port_ssl_30,
  t0.smtp_user AS smtp_user_31,
  t0.smtp_pass AS smtp_pass_32,
  t0.slug_url AS slug_url_33,
  t0.lien_facebook AS lien_facebook_34,
  t0.lien_google_plus AS lien_google_plus_35,
  t0.lien_youtube AS lien_youtube_36,
  t0.lien_instegram AS lien_instegram_37
FROM
  parametre_site t0
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.actif_bar_serach AS actif_bar_serach_2, t0.actif_titre AS actif_titre_3, t0.email AS email_4, t0.adresse AS adresse_5, t0.tel AS tel_6, t0.email_site AS email_site_7, t0.image AS image_8, t0.lien_carte AS lien_carte_9, t0.apercu_image_lien AS apercu_image_lien_10, t0.image_header AS image_header_11, t0.image_footer AS image_footer_12, t0.maintenance AS maintenance_13, t0.htaccess_val AS htaccess_val_14, t0.meta_index AS meta_index_15, t0.meta_follow AS meta_follow_16, t0.robots AS robots_17, t0.analytics AS analytics_18, t0.cle_key AS cle_key_19, t0.cle_secret AS cle_secret_20, t0.tag_managerhead AS tag_managerhead_21, t0.tag_managerbody AS tag_managerbody_22, t0.cle_map AS cle_map_23, t0.active_smtp AS active_smtp_24, t0.email_from AS email_from_25, t0.email_sender AS email_sender_26, t0.host_smtp AS host_smtp_27, t0.type_cryptage AS type_cryptage_28, t0.port_tls AS port_tls_29, t0.port_ssl AS port_ssl_30, t0.smtp_user AS smtp_user_31, t0.smtp_pass AS smtp_pass_32, t0.slug_url AS slug_url_33, t0.lien_facebook AS lien_facebook_34, t0.lien_google_plus AS lien_google_plus_35, t0.lien_youtube AS lien_youtube_36, t0.lien_instegram AS lien_instegram_37 FROM parametre_site t0 ORDER BY t0.id DESC LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 771)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 45)
4	App\Twig\ParametreSiteExtension->ParametreSiteFunction (line 349)
5	__TwigTemplate_0f76ed16224d5e52e76e889a5ccdaa6c->block_javascripts (line 171)
6	Twig\Template->displayBlock (line 98)
7	__TwigTemplate_0f76ed16224d5e52e76e889a5ccdaa6c->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 51)
10	__TwigTemplate_401e225272e7b0643f1fcc4a13fa3732->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 379)
13	Twig\Template->render (line 38)
14	Twig\TemplateWrapper->render (line 280)
15	Twig\Environment->render (line 243)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 70)
18	App\Controller\Front\PageCmsController->index (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.17 ms
(10.90%)

SELECT p0_.id AS id_0, p0_.actif AS actif_1, p0_.alias AS alias_2, p0_.image AS image_3, p0_.image_bandeau AS image_bandeau_4, p0_.meta_title AS meta_title_5, p0_.meta_description AS meta_description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p0_.actif = 1 AND p1_.locale = ? AND p1_.slug = ?

Parameters:

[
  "fr"
  "d4b-secure"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.actif AS actif_1,
  p0_.alias AS alias_2,
  p0_.image AS image_3,
  p0_.image_bandeau AS image_bandeau_4,
  p0_.meta_title AS meta_title_5,
  p0_.meta_description AS meta_description_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8
FROM
  post p0_
  INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id
WHERE
  p0_.actif = 1
  AND p1_.locale = ?
  AND p1_.slug = ?

SELECT p0_.id AS id_0, p0_.actif AS actif_1, p0_.alias AS alias_2, p0_.image AS image_3, p0_.image_bandeau AS image_bandeau_4, p0_.meta_title AS meta_title_5, p0_.meta_description AS meta_description_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8 FROM post p0_ INNER JOIN post_translation p1_ ON p0_.id = p1_.translatable_id WHERE p0_.actif = 1 AND p1_.locale = 'fr' AND p1_.slug = 'd4b-secure';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 36)
7	App\Repository\PostRepository->findPageBySlug (line 43)
8	App\Controller\Front\PageCmsController->index (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.15 ms
(9.88%)

SELECT t0.id AS id_1, t0.full_path AS full_path_2, t0.file_name AS file_name_3, t0.position AS position_4, t0.filesize AS filesize_5, t0.id_page AS id_page_6, t0.titre AS titre_7, t0.description AS description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM media_file t0 WHERE t0.id_page = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.full_path AS full_path_2,
  t0.file_name AS file_name_3,
  t0.position AS position_4,
  t0.filesize AS filesize_5,
  t0.id_page AS id_page_6,
  t0.titre AS titre_7,
  t0.description AS description_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  media_file t0
WHERE
  t0.id_page = ?

SELECT t0.id AS id_1, t0.full_path AS full_path_2, t0.file_name AS file_name_3, t0.position AS position_4, t0.filesize AS filesize_5, t0.id_page AS id_page_6, t0.titre AS titre_7, t0.description AS description_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM media_file t0 WHERE t0.id_page = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 57)
4	App\Controller\Front\PageCmsController->index (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

0.15 ms
(9.31%)

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.image AS image_3, t0.position AS position_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.post_id AS post_id_8 FROM post_bloc t0 WHERE t0.post_id = ? AND t0.actif = ? ORDER BY t0.position ASC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.actif AS actif_2,
  t0.image AS image_3,
  t0.position AS position_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.post_id AS post_id_8
FROM
  post_bloc t0
WHERE
  t0.post_id = ?
  AND t0.actif = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.actif AS actif_2, t0.image AS image_3, t0.position AS position_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.post_id AS post_id_8 FROM post_bloc t0 WHERE t0.post_id = 11 AND t0.actif = 1 ORDER BY t0.position ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 939)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 37)
4	App\Service\RenderBloc->RenderBloc (line 59)
5	App\Controller\Front\PageCmsController->index (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.13 ms
(8.22%)

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.titre AS titre_3, t0.description AS description_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM post_translation t0 WHERE t0.translatable_id = ?

Parameters:

[
  11
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.titre AS titre_3,
  t0.description AS description_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.locale AS locale_7,
  t0.translatable_id AS translatable_id_8
FROM
  post_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.titre AS titre_3, t0.description AS description_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.locale AS locale_7, t0.translatable_id AS translatable_id_8 FROM post_translation t0 WHERE t0.translatable_id = 11;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1886)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1827)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 3224)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 215)
6	Doctrine\ORM\PersistentCollection->initialize (line 118)
7	Doctrine\Common\Collections\AbstractLazyCollection->get (line 447)
8	Doctrine\ORM\PersistentCollection->get (line 190)
9	App\Entity\Post->findTranslationByLocale (line 138)
10	App\Entity\Post->doTranslate (line 75)
11	App\Entity\Post->translate (line 179)
12	App\Entity\Post->proxyCurrentLocaleTranslation (line 58)
13	App\Entity\Post->__call (line 1635)
14	twig_get_attribute (line 71)
15	__TwigTemplate_401e225272e7b0643f1fcc4a13fa3732->block_header (line 171)
16	Twig\Template->displayBlock (line 82)
17	__TwigTemplate_0f76ed16224d5e52e76e889a5ccdaa6c->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 51)
20	__TwigTemplate_401e225272e7b0643f1fcc4a13fa3732->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 243)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 70)
28	App\Controller\Front\PageCmsController->index (line 181)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
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\Languages	No errors.
App\Entity\Post	No errors.
App\Entity\PostTranslation	No errors.
App\Entity\PostBloc	No errors.
App\Entity\MediaFile	No errors.
App\Entity\ParametreSite	No errors.
App\Entity\ParametreSiteTranslation	No errors.

Symfony Profiler

GET https://palace-consulting.com/d4b-secure

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping