Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.27 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.85 ms
(37.73%)

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.phone AS phone_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.e_actif AS e_actif_9, t10.id AS id_11, t10.couleur_primaire AS couleur_primaire_12, t10.couleur_secondaire AS couleur_secondaire_13, t10.couleur_sombre AS couleur_sombre_14, t10.couleur_information AS couleur_information_15, t10.afficher_pub AS afficher_pub_16, t10.lien_dans_principal AS lien_dans_principal_17, t10.trajet_dans_principal AS trajet_dans_principal_18, t10.entreprise_id AS entreprise_id_19 FROM entreprise t0 LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.raison_social AS raison_social_2,
  t0.phone AS phone_3,
  t0.adresse AS adresse_4,
  t0.ville AS ville_5,
  t0.pays AS pays_6,
  t0.logo AS logo_7,
  t0.slug AS slug_8,
  t0.e_actif AS e_actif_9,
  t10.id AS id_11,
  t10.couleur_primaire AS couleur_primaire_12,
  t10.couleur_secondaire AS couleur_secondaire_13,
  t10.couleur_sombre AS couleur_sombre_14,
  t10.couleur_information AS couleur_information_15,
  t10.afficher_pub AS afficher_pub_16,
  t10.lien_dans_principal AS lien_dans_principal_17,
  t10.trajet_dans_principal AS trajet_dans_principal_18,
  t10.entreprise_id AS entreprise_id_19
FROM
  entreprise t0
  LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.phone AS phone_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.e_actif AS e_actif_9, t10.id AS id_11, t10.couleur_primaire AS couleur_primaire_12, t10.couleur_secondaire AS couleur_secondaire_13, t10.couleur_sombre AS couleur_sombre_14, t10.couleur_information AS couleur_information_15, t10.afficher_pub AS afficher_pub_16, t10.lien_dans_principal AS lien_dans_principal_17, t10.trajet_dans_principal AS trajet_dans_principal_18, t10.entreprise_id AS entreprise_id_19 FROM entreprise t0 LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 47)
6	App\Service\EntrepriseTwigService->getConfigEntreprise (line 1754)
7	Twig\Extension\CoreExtension::getAttribute (line 48)
8	__TwigTemplate_cbc2f885dc697f13613ac8ea56374226->doDisplay (line 393)
9	Twig\Template->yield (line 109)
10	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_ca42051f33bdfbc996bd398f4978e0c1->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 243)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 84)
20	App\Controller\RegistrationController->register (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 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.66 ms
(29.08%)

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.title AS title_3, t0.html_text AS html_text_4, t0.created_at AS created_at_5, t0.html_text_en AS html_text_en_6, t0.title_en AS title_en_7, t0.e_accueil AS e_accueil_8, t0.entreprise_id AS entreprise_id_9 FROM page_public t0 WHERE t0.entreprise_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.title AS title_3,
  t0.html_text AS html_text_4,
  t0.created_at AS created_at_5,
  t0.html_text_en AS html_text_en_6,
  t0.title_en AS title_en_7,
  t0.e_accueil AS e_accueil_8,
  t0.entreprise_id AS entreprise_id_9
FROM
  page_public t0
WHERE
  t0.entreprise_id = ?

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.title AS title_3, t0.html_text AS html_text_4, t0.created_at AS created_at_5, t0.html_text_en AS html_text_en_6, t0.title_en AS title_en_7, t0.e_accueil AS e_accueil_8, t0.entreprise_id AS entreprise_id_9 FROM page_public t0 WHERE t0.entreprise_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 33)
4	App\Service\PublicPageTwigService->getAllPublicPage (line 1754)
5	Twig\Extension\CoreExtension::getAttribute (line 96)
6	__TwigTemplate_9ded4b8d057c9cf767746fb22b48a28b->doDisplay (line 393)
7	Twig\Template->yield (line 718)
8	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->block_footer (line 437)
9	Twig\Template->yieldBlock (line 401)
10	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_ca42051f33bdfbc996bd398f4978e0c1->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 243)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 84)
20	App\Controller\RegistrationController->register (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 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.42 ms
(18.53%)

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.phone AS phone_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.e_actif AS e_actif_9, t10.id AS id_11, t10.couleur_primaire AS couleur_primaire_12, t10.couleur_secondaire AS couleur_secondaire_13, t10.couleur_sombre AS couleur_sombre_14, t10.couleur_information AS couleur_information_15, t10.afficher_pub AS afficher_pub_16, t10.lien_dans_principal AS lien_dans_principal_17, t10.trajet_dans_principal AS trajet_dans_principal_18, t10.entreprise_id AS entreprise_id_19 FROM entreprise t0 LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.raison_social AS raison_social_2,
  t0.phone AS phone_3,
  t0.adresse AS adresse_4,
  t0.ville AS ville_5,
  t0.pays AS pays_6,
  t0.logo AS logo_7,
  t0.slug AS slug_8,
  t0.e_actif AS e_actif_9,
  t10.id AS id_11,
  t10.couleur_primaire AS couleur_primaire_12,
  t10.couleur_secondaire AS couleur_secondaire_13,
  t10.couleur_sombre AS couleur_sombre_14,
  t10.couleur_information AS couleur_information_15,
  t10.afficher_pub AS afficher_pub_16,
  t10.lien_dans_principal AS lien_dans_principal_17,
  t10.trajet_dans_principal AS trajet_dans_principal_18,
  t10.entreprise_id AS entreprise_id_19
FROM
  entreprise t0
  LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id

SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.phone AS phone_3, t0.adresse AS adresse_4, t0.ville AS ville_5, t0.pays AS pays_6, t0.logo AS logo_7, t0.slug AS slug_8, t0.e_actif AS e_actif_9, t10.id AS id_11, t10.couleur_primaire AS couleur_primaire_12, t10.couleur_secondaire AS couleur_secondaire_13, t10.couleur_sombre AS couleur_sombre_14, t10.couleur_information AS couleur_information_15, t10.afficher_pub AS afficher_pub_16, t10.lien_dans_principal AS lien_dans_principal_17, t10.trajet_dans_principal AS trajet_dans_principal_18, t10.entreprise_id AS entreprise_id_19 FROM entreprise t0 LEFT JOIN config_entreprise t10 ON t10.entreprise_id = t0.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 969)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 27)
5	App\Service\EntrepriseTwigService->getEntrepriseVisible (line 1754)
6	Twig\Extension\CoreExtension::getAttribute (line 231)
7	__TwigTemplate_7f0ccb1c82fe381ef635df3191c1c14f->doDisplay (line 393)
8	Twig\Template->yield (line 667)
9	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->block_navbar (line 437)
10	Twig\Template->yieldBlock (line 387)
11	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
12	Twig\Template->yield (line 56)
13	__TwigTemplate_ca42051f33bdfbc996bd398f4978e0c1->doDisplay (line 393)
14	Twig\Template->yield (line 349)
15	Twig\Template->display (line 364)
16	Twig\Template->render (line 35)
17	Twig\TemplateWrapper->render (line 306)
18	Twig\Environment->render (line 243)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 84)
21	App\Controller\RegistrationController->register (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.33 ms
(14.66%)

SELECT t0.id AS id_1, t0.admin_address AS admin_address_2, t0.relation_reservation AS relation_reservation_3, t0.phone_number AS phone_number_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.twiter AS twiter_7, t0.linked_in AS linked_in_8, t0.mode AS mode_9, t0.api_key AS api_key_10, t0.api_site AS api_site_11, t0.secret_key AS secret_key_12, t0.money_key AS money_key_13, t0.language AS language_14, t0.entreprise_id AS entreprise_id_15 FROM parameter t0 WHERE t0.entreprise_id = ? LIMIT 1

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.admin_address AS admin_address_2,
  t0.relation_reservation AS relation_reservation_3,
  t0.phone_number AS phone_number_4,
  t0.facebook AS facebook_5,
  t0.instagram AS instagram_6,
  t0.twiter AS twiter_7,
  t0.linked_in AS linked_in_8,
  t0.mode AS mode_9,
  t0.api_key AS api_key_10,
  t0.api_site AS api_site_11,
  t0.secret_key AS secret_key_12,
  t0.money_key AS money_key_13,
  t0.language AS language_14,
  t0.entreprise_id AS entreprise_id_15
FROM
  parameter t0
WHERE
  t0.entreprise_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.admin_address AS admin_address_2, t0.relation_reservation AS relation_reservation_3, t0.phone_number AS phone_number_4, t0.facebook AS facebook_5, t0.instagram AS instagram_6, t0.twiter AS twiter_7, t0.linked_in AS linked_in_8, t0.mode AS mode_9, t0.api_key AS api_key_10, t0.api_site AS api_site_11, t0.secret_key AS secret_key_12, t0.money_key AS money_key_13, t0.language AS language_14, t0.entreprise_id AS entreprise_id_15 FROM parameter t0 WHERE t0.entreprise_id = 2 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	App\Service\PublicPageTwigService->getParams (line 1754)
5	Twig\Extension\CoreExtension::getAttribute (line 65)
6	__TwigTemplate_9ded4b8d057c9cf767746fb22b48a28b->doDisplay (line 393)
7	Twig\Template->yield (line 718)
8	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->block_footer (line 437)
9	Twig\Template->yieldBlock (line 401)
10	__TwigTemplate_8a0017c2beece4eb82cbb037788e6cce->doDisplay (line 393)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_ca42051f33bdfbc996bd398f4978e0c1->doDisplay (line 393)
13	Twig\Template->yield (line 349)
14	Twig\Template->display (line 364)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 306)
17	Twig\Environment->render (line 243)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->renderView (line 254)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 84)
20	App\Controller\RegistrationController->register (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 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\User	No errors.
App\Entity\Entreprise	No errors.
App\Entity\ConfigEntreprise	No errors.
App\Entity\Abonnement	No errors.
App\Entity\PagePublic	No errors.
App\Entity\Parameter	No errors.

Symfony Profiler

GET https://myecocar.devsoft-pro.com/register

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping