Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

10.67 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.65 ms
(43.54%)

SELECT t0.id_setting AS id_setting_1, t0.nom AS nom_2, t0.description AS description_3, t0.valeur_fr AS valeur_fr_4, t0.valeur_it AS valeur_it_5, t0.valeur_en AS valeur_en_6, t0.valeur_de AS valeur_de_7, t0.valeur_es AS valeur_es_8, t0.valeur_pt AS valeur_pt_9, t0.id_setting_group AS id_setting_group_10 FROM lz_settings t0 WHERE t0.nom = ? LIMIT 1

Parameters:

[
  "CONNEXION_MAINTENANCE_ENABLE"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_setting AS id_setting_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.valeur_fr AS valeur_fr_4,
  t0.valeur_it AS valeur_it_5,
  t0.valeur_en AS valeur_en_6,
  t0.valeur_de AS valeur_de_7,
  t0.valeur_es AS valeur_es_8,
  t0.valeur_pt AS valeur_pt_9,
  t0.id_setting_group AS id_setting_group_10
FROM
  lz_settings t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id_setting AS id_setting_1, t0.nom AS nom_2, t0.description AS description_3, t0.valeur_fr AS valeur_fr_4, t0.valeur_it AS valeur_it_5, t0.valeur_en AS valeur_en_6, t0.valeur_de AS valeur_de_7, t0.valeur_es AS valeur_es_8, t0.valeur_pt AS valeur_pt_9, t0.id_setting_group AS id_setting_group_10 FROM lz_settings t0 WHERE t0.nom = 'CONNEXION_MAINTENANCE_ENABLE' 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 29)
4	App\Service\Divers\Setting->get (line 73)
5	App\Controller\Security\SecurityController->login (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 21)

3.50 ms
(32.82%)

SELECT t0.id_custom AS id_custom_1, t0.nom AS nom_2, t0.description AS description_3, t0.titre_fr AS titre_fr_4, t0.titre_it AS titre_it_5, t0.titre_en AS titre_en_6, t0.titre_de AS titre_de_7, t0.titre_es AS titre_es_8, t0.titre_pt AS titre_pt_9, t0.image AS image_10, t0.updatedAt AS updatedAt_11 FROM lz_custom_images t0 WHERE t0.nom = ? LIMIT 1

Parameters:

[
  "LOGIN_BACKGROUND"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_custom AS id_custom_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.titre_fr AS titre_fr_4,
  t0.titre_it AS titre_it_5,
  t0.titre_en AS titre_en_6,
  t0.titre_de AS titre_de_7,
  t0.titre_es AS titre_es_8,
  t0.titre_pt AS titre_pt_9,
  t0.image AS image_10,
  t0.updatedAt AS updatedAt_11
FROM
  lz_custom_images t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id_custom AS id_custom_1, t0.nom AS nom_2, t0.description AS description_3, t0.titre_fr AS titre_fr_4, t0.titre_it AS titre_it_5, t0.titre_en AS titre_en_6, t0.titre_de AS titre_de_7, t0.titre_es AS titre_es_8, t0.titre_pt AS titre_pt_9, t0.image AS image_10, t0.updatedAt AS updatedAt_11 FROM lz_custom_images t0 WHERE t0.nom = 'LOGIN_BACKGROUND' 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 63)
4	App\Service\Divers\Custom->getImage (line 1635)
5	twig_get_attribute (line 118)
6	__TwigTemplate_8b6b9d0634e23ec2786e058b2d35e647->block_stylesheetsCustom (line 171)
7	Twig\Template->displayBlock (line 83)
8	__TwigTemplate_ca46cb8e44c6890b5831805b9f0441d6->doDisplay (line 394)
9	Twig\Template->displayWithErrorHandling (line 367)
10	Twig\Template->display (line 51)
11	__TwigTemplate_8b6b9d0634e23ec2786e058b2d35e647->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 379)
14	Twig\Template->render (line 38)
15	Twig\TemplateWrapper->render (line 280)
16	Twig\Environment->render (line 448)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 77)
20	App\Controller\Security\SecurityController->login (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 21)

2.52 ms
(23.64%)

SELECT t0.id_custom AS id_custom_1, t0.nom AS nom_2, t0.description AS description_3, t0.titre_fr AS titre_fr_4, t0.titre_it AS titre_it_5, t0.titre_en AS titre_en_6, t0.titre_de AS titre_de_7, t0.titre_es AS titre_es_8, t0.titre_pt AS titre_pt_9, t0.texte_fr AS texte_fr_10, t0.texte_it AS texte_it_11, t0.texte_en AS texte_en_12, t0.texte_de AS texte_de_13, t0.texte_es AS texte_es_14, t0.texte_pt AS texte_pt_15 FROM lz_custom_texts t0 WHERE t0.nom = ? LIMIT 1

Parameters:

[
  "TEXTE_MSG_LOGIN"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_custom AS id_custom_1,
  t0.nom AS nom_2,
  t0.description AS description_3,
  t0.titre_fr AS titre_fr_4,
  t0.titre_it AS titre_it_5,
  t0.titre_en AS titre_en_6,
  t0.titre_de AS titre_de_7,
  t0.titre_es AS titre_es_8,
  t0.titre_pt AS titre_pt_9,
  t0.texte_fr AS texte_fr_10,
  t0.texte_it AS texte_it_11,
  t0.texte_en AS texte_en_12,
  t0.texte_de AS texte_de_13,
  t0.texte_es AS texte_es_14,
  t0.texte_pt AS texte_pt_15
FROM
  lz_custom_texts t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id_custom AS id_custom_1, t0.nom AS nom_2, t0.description AS description_3, t0.titre_fr AS titre_fr_4, t0.titre_it AS titre_it_5, t0.titre_en AS titre_en_6, t0.titre_de AS titre_de_7, t0.titre_es AS titre_es_8, t0.titre_pt AS titre_pt_9, t0.texte_fr AS texte_fr_10, t0.texte_it AS texte_it_11, t0.texte_en AS texte_en_12, t0.texte_de AS texte_de_13, t0.texte_es AS texte_es_14, t0.texte_pt AS texte_pt_15 FROM lz_custom_texts t0 WHERE t0.nom = 'TEXTE_MSG_LOGIN' 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 31)
4	App\Service\Divers\Custom->getTexte (line 72)
5	App\Controller\Security\SecurityController->login (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 21)

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\LzCustomTexts	No errors.
App\Entity\LzSettings	No errors.
App\Entity\LzSettingGroups	No errors.
App\Entity\LzCustomImages	No errors.

Symfony Profiler

GET https://phythosynthese.arobases.fr/public/login

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping