Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

12.58 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

6.53 ms
(51.92%)

SELECT t0.id_pays AS id_pays_1, t0.code AS code_2, t0.code_alpha2 AS code_alpha2_3, t0.code_alpha3 AS code_alpha3_4, t0.actif AS actif_5, t0.nom_fr AS nom_fr_6, t0.nom_it AS nom_it_7, t0.nom_en AS nom_en_8, t0.nom_de AS nom_de_9, t0.nom_es AS nom_es_10, t0.nom_pt AS nom_pt_11 FROM lz_pays t0 WHERE t0.code_alpha2 = ? LIMIT 1

Parameters:

[
  "FR"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_pays AS id_pays_1,
  t0.code AS code_2,
  t0.code_alpha2 AS code_alpha2_3,
  t0.code_alpha3 AS code_alpha3_4,
  t0.actif AS actif_5,
  t0.nom_fr AS nom_fr_6,
  t0.nom_it AS nom_it_7,
  t0.nom_en AS nom_en_8,
  t0.nom_de AS nom_de_9,
  t0.nom_es AS nom_es_10,
  t0.nom_pt AS nom_pt_11
FROM
  lz_pays t0
WHERE
  t0.code_alpha2 = ?
LIMIT
  1

SELECT t0.id_pays AS id_pays_1, t0.code AS code_2, t0.code_alpha2 AS code_alpha2_3, t0.code_alpha3 AS code_alpha3_4, t0.actif AS actif_5, t0.nom_fr AS nom_fr_6, t0.nom_it AS nom_it_7, t0.nom_en AS nom_en_8, t0.nom_de AS nom_de_9, t0.nom_es AS nom_es_10, t0.nom_pt AS nom_pt_11 FROM lz_pays t0 WHERE t0.code_alpha2 = 'FR' 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 77)
4	App\Service\Divers\PaysLanguages::getIdPaysFromCodeAlpha (line 131)
5	App\Controller\Security\RegisterController->register (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.91 ms
(31.12%)

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 129)
5	App\Controller\Security\RegisterController->register (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)

1.44 ms
(11.48%)

SELECT t0.id_pays AS id_pays_1, t0.code AS code_2, t0.code_alpha2 AS code_alpha2_3, t0.code_alpha3 AS code_alpha3_4, t0.actif AS actif_5, t0.nom_fr AS nom_fr_6, t0.nom_it AS nom_it_7, t0.nom_en AS nom_en_8, t0.nom_de AS nom_de_9, t0.nom_es AS nom_es_10, t0.nom_pt AS nom_pt_11 FROM lz_pays t0 WHERE t0.actif = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id_pays AS id_pays_1,
  t0.code AS code_2,
  t0.code_alpha2 AS code_alpha2_3,
  t0.code_alpha3 AS code_alpha3_4,
  t0.actif AS actif_5,
  t0.nom_fr AS nom_fr_6,
  t0.nom_it AS nom_it_7,
  t0.nom_en AS nom_en_8,
  t0.nom_de AS nom_de_9,
  t0.nom_es AS nom_es_10,
  t0.nom_pt AS nom_pt_11
FROM
  lz_pays t0
WHERE
  t0.actif = ?

SELECT t0.id_pays AS id_pays_1, t0.code AS code_2, t0.code_alpha2 AS code_alpha2_3, t0.code_alpha3 AS code_alpha3_4, t0.actif AS actif_5, t0.nom_fr AS nom_fr_6, t0.nom_it AS nom_it_7, t0.nom_en AS nom_en_8, t0.nom_de AS nom_de_9, t0.nom_es AS nom_es_10, t0.nom_pt AS nom_pt_11 FROM lz_pays t0 WHERE t0.actif = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 151)
4	App\Service\Divers\PaysLanguages::getPaysArray (line 53)
5	App\Form\Security\UserRegisterType->buildForm (line 102)
6	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
7	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
8	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
9	Symfony\Component\Form\FormFactory->createBuilder (line 28)
10	Symfony\Component\Form\FormFactory->create (line 340)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 131)
12	App\Controller\Security\RegisterController->register (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	Symfony\Component\HttpKernel\Kernel->handle (line 21)

0.69 ms
(5.48%)

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:

[
  "REGISTER_RGPD_CHECKBOX"
]

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 = 'REGISTER_RGPD_CHECKBOX' 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 55)
5	App\Form\Security\UserRegisterType->buildForm (line 102)
6	Symfony\Component\Form\ResolvedFormType->buildForm (line 79)
7	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 58)
8	Symfony\Component\Form\FormFactory->createNamedBuilder (line 43)
9	Symfony\Component\Form\FormFactory->createBuilder (line 28)
10	Symfony\Component\Form\FormFactory->create (line 340)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 131)
12	App\Controller\Security\RegisterController->register (line 181)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
15	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\LzSettings	No errors.
App\Entity\LzSettingGroups	No errors.
App\Entity\LzPays	No errors.
App\Entity\LzActualites	No errors.
App\Entity\LzPromos	No errors.
App\Entity\LzJeuxConcours	No errors.
App\Entity\LzCustomTexts	No errors.

Symfony Profiler

GET https://phythosynthese.arobases.fr/register

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping