Symfony Profiler

Query Metrics

6 Database Queries

5 Different statements

1.64 ms Query time

4 Invalid entities

82 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.53 ms
(32.22%)

SELECT t1.id AS id_2, t1.email AS email_3, t1.password AS password_4, t1.first_name AS first_name_5, t1.lastname AS lastname_6, t1.phone AS phone_7, t1.profile_picture AS profile_picture_8, t1.location AS location_9, t1.active AS active_10, t1.email_verified AS email_verified_11, t1.google_id AS google_id_12, t1.role AS role_13, t1.last_seen AS last_seen_14, t1.created_at AS created_at_15, t1.updated_at AS updated_at_16, t1.member_since AS member_since_17, t1.last_activity AS last_activity_18, t1.email_auth_code AS email_auth_code_19, t1.email_auth_code_expires_at AS email_auth_code_expires_at_20, t1.is_verified AS is_verified_21, t1.status_subscription AS status_subscription_22, t1.stripe_customer_id AS stripe_customer_id_23, t1.subscription_start_date AS subscription_start_date_24, t1.subscription_end_date AS subscription_end_date_25, t1.status AS status_26, t1.blocked AS blocked_27, t1.agence AS agence_28, t1.profil AS profil_29, t1.website AS website_30, t1.company_name AS company_name_31, t1.siret AS siret_32, t1.siren AS siren_33, t1.registered AS registered_34, t1.api_token AS api_token_35, t0.bio AS bio_36, t0.adresse_salon AS adresse_salon_37, t0.notemoyenne AS notemoyenne_38, t0.adomicile AS adomicile_39, t0.en_salon AS en_salon_40, t0.type_abonnement AS type_abonnement_41, t0.abonnement_expiration AS abonnement_expiration_42, t0.photos AS photos_43, t0.disponibilites AS disponibilites_44, t0.localisation AS localisation_45, t0.piece AS piece_46, t0.distance_max AS distance_max_47, t0.titre AS titre_48, t0.bio_coiffeur AS bio_coiffeur_49, t0.rib AS rib_50, t1.user_type FROM coiffeur t0 INNER JOIN user t1 ON t0.id = t1.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t1.id AS id_2,
  t1.email AS email_3,
  t1.password AS password_4,
  t1.first_name AS first_name_5,
  t1.lastname AS lastname_6,
  t1.phone AS phone_7,
  t1.profile_picture AS profile_picture_8,
  t1.location AS location_9,
  t1.active AS active_10,
  t1.email_verified AS email_verified_11,
  t1.google_id AS google_id_12,
  t1.role AS role_13,
  t1.last_seen AS last_seen_14,
  t1.created_at AS created_at_15,
  t1.updated_at AS updated_at_16,
  t1.member_since AS member_since_17,
  t1.last_activity AS last_activity_18,
  t1.email_auth_code AS email_auth_code_19,
  t1.email_auth_code_expires_at AS email_auth_code_expires_at_20,
  t1.is_verified AS is_verified_21,
  t1.status_subscription AS status_subscription_22,
  t1.stripe_customer_id AS stripe_customer_id_23,
  t1.subscription_start_date AS subscription_start_date_24,
  t1.subscription_end_date AS subscription_end_date_25,
  t1.status AS status_26,
  t1.blocked AS blocked_27,
  t1.agence AS agence_28,
  t1.profil AS profil_29,
  t1.website AS website_30,
  t1.company_name AS company_name_31,
  t1.siret AS siret_32,
  t1.siren AS siren_33,
  t1.registered AS registered_34,
  t1.api_token AS api_token_35,
  t0.bio AS bio_36,
  t0.adresse_salon AS adresse_salon_37,
  t0.notemoyenne AS notemoyenne_38,
  t0.adomicile AS adomicile_39,
  t0.en_salon AS en_salon_40,
  t0.type_abonnement AS type_abonnement_41,
  t0.abonnement_expiration AS abonnement_expiration_42,
  t0.photos AS photos_43,
  t0.disponibilites AS disponibilites_44,
  t0.localisation AS localisation_45,
  t0.piece AS piece_46,
  t0.distance_max AS distance_max_47,
  t0.titre AS titre_48,
  t0.bio_coiffeur AS bio_coiffeur_49,
  t0.rib AS rib_50,
  t1.user_type
FROM
  coiffeur t0
  INNER JOIN user t1 ON t0.id = t1.id

SELECT t1.id AS id_2, t1.email AS email_3, t1.password AS password_4, t1.first_name AS first_name_5, t1.lastname AS lastname_6, t1.phone AS phone_7, t1.profile_picture AS profile_picture_8, t1.location AS location_9, t1.active AS active_10, t1.email_verified AS email_verified_11, t1.google_id AS google_id_12, t1.role AS role_13, t1.last_seen AS last_seen_14, t1.created_at AS created_at_15, t1.updated_at AS updated_at_16, t1.member_since AS member_since_17, t1.last_activity AS last_activity_18, t1.email_auth_code AS email_auth_code_19, t1.email_auth_code_expires_at AS email_auth_code_expires_at_20, t1.is_verified AS is_verified_21, t1.status_subscription AS status_subscription_22, t1.stripe_customer_id AS stripe_customer_id_23, t1.subscription_start_date AS subscription_start_date_24, t1.subscription_end_date AS subscription_end_date_25, t1.status AS status_26, t1.blocked AS blocked_27, t1.agence AS agence_28, t1.profil AS profil_29, t1.website AS website_30, t1.company_name AS company_name_31, t1.siret AS siret_32, t1.siren AS siren_33, t1.registered AS registered_34, t1.api_token AS api_token_35, t0.bio AS bio_36, t0.adresse_salon AS adresse_salon_37, t0.notemoyenne AS notemoyenne_38, t0.adomicile AS adomicile_39, t0.en_salon AS en_salon_40, t0.type_abonnement AS type_abonnement_41, t0.abonnement_expiration AS abonnement_expiration_42, t0.photos AS photos_43, t0.disponibilites AS disponibilites_44, t0.localisation AS localisation_45, t0.piece AS piece_46, t0.distance_max AS distance_max_47, t0.titre AS titre_48, t0.bio_coiffeur AS bio_coiffeur_49, t0.rib AS rib_50, t1.user_type FROM coiffeur t0 INNER JOIN user t1 ON t0.id = t1.id;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\HomeController->liste (line 122)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.52 ms
(31.42%)

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.accepted AS accepted_2, c0_.created_at AS created_at_3, c0_.expires_at AS expires_at_4, c0_.preferences AS preferences_5 FROM cookie_consent c0_ WHERE c0_.session_id = ? AND c0_.expires_at > ?

Parameters:

[
  "mahfummes5n5vg02sd68gb8von"
  "2026-03-05 11:12:42"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.session_id AS session_id_1,
  c0_.accepted AS accepted_2,
  c0_.created_at AS created_at_3,
  c0_.expires_at AS expires_at_4,
  c0_.preferences AS preferences_5
FROM
  cookie_consent c0_
WHERE
  c0_.session_id = ?
  AND c0_.expires_at > ?

SELECT c0_.id AS id_0, c0_.session_id AS session_id_1, c0_.accepted AS accepted_2, c0_.created_at AS created_at_3, c0_.expires_at AS expires_at_4, c0_.preferences AS preferences_5 FROM cookie_consent c0_ WHERE c0_.session_id = 'mahfummes5n5vg02sd68gb8von' AND c0_.expires_at > '2026-03-05 11:12:42';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\CookieConsentRepository->findBySessionId (line 28)
7	App\Service\CookieConsentService->hasConsent (line 28)
8	App\Twig\Extension\CookieConsentExtension->hasCookieConsent (line 26)
9	__TwigTemplate_c4714e40b884172df113b962bdf58e50->doDisplay (line 305)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_e8cf2180a6744160c1ab6c86b5396e0f->doDisplay (line 56)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\HomeController->liste (line 130)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.22 ms
(13.34%)

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.numero AS numero_2 FROM departement d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  d0_.id AS id_0,
  d0_.nom AS nom_1,
  d0_.numero AS numero_2
FROM
  departement d0_

SELECT d0_.id AS id_0, d0_.nom AS nom_1, d0_.numero AS numero_2 FROM departement d0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\HomeController->liste (line 133)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.20 ms
(12.11%)

SELECT v0_.id AS id_0, v0_.nom_ville AS nom_ville_1, v0_.departement_id AS departement_id_2 FROM ville v0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.nom_ville AS nom_ville_1,
  v0_.departement_id AS departement_id_2
FROM
  ville v0_

SELECT v0_.id AS id_0, v0_.nom_ville AS nom_ville_1, v0_.departement_id AS departement_id_2 FROM ville v0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\HomeController->liste (line 133)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.18 ms
(10.90%)

SELECT s0_.id AS id_0, s0_.nom AS nom_1 FROM specialite s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.nom AS nom_1
FROM
  specialite s0_

SELECT s0_.id AS id_0, s0_.nom AS nom_1 FROM specialite s0_;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 53)
7	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 29)
8	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 56)
9	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 187)
12	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 234)
14	Symfony\Component\Form\ResolvedFormType->buildView (line 107)
15	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
16	Symfony\Component\Form\ResolvedFormType->buildView (line 105)
17	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 78)
18	Symfony\Component\Form\Form->createView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	App\Controller\HomeController->liste (line 133)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Ville	45
App\Entity\Specialite	26
App\Entity\Departement	8
App\Entity\User	3

Entities Mapping

Class	Mapping errors
App\Entity\Departement	No errors.
App\Entity\Ville	No errors.
App\Entity\Specialite	No errors.
App\Entity\User	The field App\Entity\User#notifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#user does not contain the required 'inversedBy: "notifications"' attribute.
App\Entity\Coiffeur	The field App\Entity\Coiffeur#notifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#user does not contain the required 'inversedBy: "notifications"' attribute. The association App\Entity\Coiffeur#produits refers to the owning side field App\Entity\Produit#proprietaireProduit which does not exist.
App\Entity\Notification	No errors.
App\Entity\UserSubscription	No errors.
App\Entity\Comment	No errors.
App\Entity\Commande	No errors.
App\Entity\Prestation	The association App\Entity\Prestation#reservations refers to the owning side field App\Entity\Reservation#prestation which does not exist.
App\Entity\Avis	No errors.
App\Entity\Produit	No errors.
App\Entity\Service	No errors.
App\Entity\TypeCoiffure	No errors.
App\Entity\Reservation	No errors.
App\Entity\ReservationPostule	No errors.
App\Entity\MouvementPiece	No errors.
App\Entity\LieuPrestation	No errors.
App\Entity\RealisationCoiffeuse	No errors.
App\Entity\Disponibilite	No errors.
App\Entity\Client	The field App\Entity\Client#notifications is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Notification#user does not contain the required 'inversedBy: "notifications"' attribute.
App\Entity\CookieConsent	No errors.

Symfony Profiler

GET https://www.baschcoiffureafro.databoost.mg/coiffeuse

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping