Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

4.17 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.07 ms
(49.64%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.id_stripe AS id_stripe_7, t0.created_at AS created_at_8, t0.cgv AS cgv_9, t0.rgpd AS rgpd_10, t0.reset_token AS reset_token_11, t0.reset_requested_at AS reset_requested_at_12, t0.last_seen_at AS last_seen_at_13, t0.id_wp AS id_wp_14, t0.status AS status_15, t0.artist_id AS artist_id_16, t17.id AS id_18, t17.structure_name AS structure_name_19, t17.type AS type_20, t17.function AS function_21, t17.other_type AS other_type_22, t17.utilisateur_id AS utilisateur_id_23, t24.id AS id_25, t24.street AS street_26, t24.street_add AS street_add_27, t24.post_code AS post_code_28, t24.city AS city_29, t24.oldid AS oldid_30, t24.utilisateur_id AS utilisateur_id_31, t24.coordinate_id AS coordinate_id_32, t33.id AS id_34, t33.website AS website_35, t33.facebook AS facebook_36, t33.linkedin AS linkedin_37, t33.twitter AS twitter_38, t33.youtube AS youtube_39, t33.is_see_info_contact AS is_see_info_contact_40, t33.instagram AS instagram_41, t33.utilisateur_id AS utilisateur_id_42 FROM "user" t0 LEFT JOIN programmer t17 ON t17.utilisateur_id = t0.id LEFT JOIN address t24 ON t24.utilisateur_id = t0.id LEFT JOIN more_information t33 ON t33.utilisateur_id = t0.id WHERE t0.email = ? LIMIT 2

Parameters:

[
  "lamelune.production@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.id_stripe AS id_stripe_7,
  t0.created_at AS created_at_8,
  t0.cgv AS cgv_9,
  t0.rgpd AS rgpd_10,
  t0.reset_token AS reset_token_11,
  t0.reset_requested_at AS reset_requested_at_12,
  t0.last_seen_at AS last_seen_at_13,
  t0.id_wp AS id_wp_14,
  t0.status AS status_15,
  t0.artist_id AS artist_id_16,
  t17.id AS id_18,
  t17.structure_name AS structure_name_19,
  t17.type AS type_20,
  t17.function AS function_21,
  t17.other_type AS other_type_22,
  t17.utilisateur_id AS utilisateur_id_23,
  t24.id AS id_25,
  t24.street AS street_26,
  t24.street_add AS street_add_27,
  t24.post_code AS post_code_28,
  t24.city AS city_29,
  t24.oldid AS oldid_30,
  t24.utilisateur_id AS utilisateur_id_31,
  t24.coordinate_id AS coordinate_id_32,
  t33.id AS id_34,
  t33.website AS website_35,
  t33.facebook AS facebook_36,
  t33.linkedin AS linkedin_37,
  t33.twitter AS twitter_38,
  t33.youtube AS youtube_39,
  t33.is_see_info_contact AS is_see_info_contact_40,
  t33.instagram AS instagram_41,
  t33.utilisateur_id AS utilisateur_id_42
FROM
  "user" t0
  LEFT JOIN programmer t17 ON t17.utilisateur_id = t0.id
  LEFT JOIN address t24 ON t24.utilisateur_id = t0.id
  LEFT JOIN more_information t33 ON t33.utilisateur_id = t0.id
WHERE
  t0.email = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.id_stripe AS id_stripe_7, t0.created_at AS created_at_8, t0.cgv AS cgv_9, t0.rgpd AS rgpd_10, t0.reset_token AS reset_token_11, t0.reset_requested_at AS reset_requested_at_12, t0.last_seen_at AS last_seen_at_13, t0.id_wp AS id_wp_14, t0.status AS status_15, t0.artist_id AS artist_id_16, t17.id AS id_18, t17.structure_name AS structure_name_19, t17.type AS type_20, t17.function AS function_21, t17.other_type AS other_type_22, t17.utilisateur_id AS utilisateur_id_23, t24.id AS id_25, t24.street AS street_26, t24.street_add AS street_add_27, t24.post_code AS post_code_28, t24.city AS city_29, t24.oldid AS oldid_30, t24.utilisateur_id AS utilisateur_id_31, t24.coordinate_id AS coordinate_id_32, t33.id AS id_34, t33.website AS website_35, t33.facebook AS facebook_36, t33.linkedin AS linkedin_37, t33.twitter AS twitter_38, t33.youtube AS youtube_39, t33.is_see_info_contact AS is_see_info_contact_40, t33.instagram AS instagram_41, t33.utilisateur_id AS utilisateur_id_42 FROM "user" t0 LEFT JOIN programmer t17 ON t17.utilisateur_id = t0.id LEFT JOIN address t24 ON t24.utilisateur_id = t0.id LEFT JOIN more_information t33 ON t33.utilisateur_id = t0.id WHERE t0.email = 'lamelune.production@gmail.com' LIMIT 2;

#	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	Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntityValidator->validate (line 155)
5	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 748)
6	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 481)
7	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 297)
8	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 127)
9	Symfony\Component\Form\Extension\Validator\Constraints\FormValidator->validate (line 105)
10	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 748)
11	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 481)
12	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 297)
13	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 127)
14	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 81)
15	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 58)
16	Symfony\Component\Form\Extension\Validator\EventListener\ValidationListener->validateForm (line 43)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
19	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 28)
20	Symfony\Component\Form\Form->submit (line 589)
21	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 107)
22	Symfony\Component\Form\Form->handleRequest (line 418)
23	App\Controller\RegistrationController->register (line 35)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 182)
27	handle (line 13)

0.43 ms
(10.33%)

INSERT INTO artist (phone, company_name, slug) VALUES (?, ?, ?)

Parameters:

[
  "0651538481"
  "Compagnie Lamelune"
  "Compagnie-Lamelune"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO artist (phone, company_name, slug)
VALUES
  (?, ?, ?)

INSERT INTO artist (phone, company_name, slug) VALUES ('0651538481', 'Compagnie Lamelune', 'Compagnie-Lamelune');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\RegistrationController->register (line 43)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	handle (line 13)

0.41 ms
(9.85%)

INSERT INTO "user" (email, roles, password, first_name, last_name, id_stripe, created_at, cgv, rgpd, reset_token, reset_requested_at, last_seen_at, id_wp, status, artist_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "lamelune.production@gmail.com"
  "["ROLE_ARTIST"]"
  "$2y$13$g.9M5uUHmd9P8qmq9VPZpOZSg9c5iYH9DUuVQG7adVe2G7E11wB8O"
  "Pascal"
  "Sylvain"
  "cus_TzRolW12ygAJqe"
  "2026-02-16"
  null
  null
  null
  null
  null
  null
  "active"
  990
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO "user" (
  email, roles, password, first_name,
  last_name, id_stripe, created_at,
  cgv, rgpd, reset_token, reset_requested_at,
  last_seen_at, id_wp, status, artist_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO "user" (email, roles, password, first_name, last_name, id_stripe, created_at, cgv, rgpd, reset_token, reset_requested_at, last_seen_at, id_wp, status, artist_id) VALUES ('lamelune.production@gmail.com', '[\"ROLE_ARTIST\"]', '$2y$13$g.9M5uUHmd9P8qmq9VPZpOZSg9c5iYH9DUuVQG7adVe2G7E11wB8O', 'Pascal', 'Sylvain', 'cus_TzRolW12ygAJqe', '2026-02-16', NULL, NULL, NULL, NULL, NULL, NULL, 'active', 990);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\RegistrationController->register (line 43)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	handle (line 13)

0.38 ms
(9.18%)

INSERT INTO address (street, street_add, post_code, city, oldid, utilisateur_id, coordinate_id) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "numéro 41, le Kiosque, 10 éme - mvac 35 , rue de l'aqueduc"
  null
  "75010"
  "Paris"
  null
  1060
  549
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO address (
  street, street_add, post_code, city,
  oldid, utilisateur_id, coordinate_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO address (street, street_add, post_code, city, oldid, utilisateur_id, coordinate_id) VALUES ('numéro 41, le Kiosque, 10 éme - mvac 35 , rue de l\'aqueduc', NULL, '75010', 'Paris', NULL, 1060, 549);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\RegistrationController->register (line 43)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	handle (line 13)

0.34 ms
(8.25%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 433)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\RegistrationController->register (line 43)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 182)
8	handle (line 13)

0.31 ms
(7.36%)

INSERT INTO coordinate (latitutude, longitude, min_lat, max_lat, min_lon, max_lon, distance) VALUES (?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  48.881865
  2.362616
  47.532882591122
  50.230847408878
  0.31103768907474
  4.4141943109253
  150
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO coordinate (
  latitutude, longitude, min_lat, max_lat,
  min_lon, max_lon, distance
)
VALUES
  (?, ?, ?, ?, ?, ?, ?)

INSERT INTO coordinate (latitutude, longitude, min_lat, max_lat, min_lon, max_lon, distance) VALUES (48.881865, 2.362616, 47.532882591122, 50.230847408878, 0.31103768907474, 4.4141943109253, 150);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\RegistrationController->register (line 43)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	handle (line 13)

0.22 ms
(5.39%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Controller\RegistrationController->register (line 43)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 182)
7	handle (line 13)

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\Artist	1
App\Entity\User	1
App\Entity\Coordinate	1
App\Entity\Address	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Artist	No errors.
App\Entity\Programmer	No errors.
App\Entity\Address	No errors.
App\Entity\Coordinate	No errors.
App\Entity\MoreInformation	No errors.
App\Entity\Category	No errors.
App\Entity\FestivalPresence	No errors.
App\Entity\ContactFestival	No errors.
App\Entity\Show	No errors.
App\Entity\Subscribe	No errors.
App\Entity\Favorite	No errors.
App\Entity\Seen	No errors.
App\Entity\Negociation	No errors.
App\Entity\Program	No errors.
App\Entity\Note	No errors.
App\Entity\Safe	No errors.
App\Entity\Search	No errors.
App\Entity\Tracking	No errors.
App\Entity\UserSession	No errors.
App\Entity\SubCategory	No errors.

Symfony Profiler

POST https://app.theaomai.fr/inscription/artiste

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping