Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

25.29 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

22.04 ms
(87.15%)

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.email AS email_3, t0.abonne AS abonne_4 FROM client t0 WHERE t0.email = ? LIMIT 2

Parameters:

[
  "sdurieux03@gmail.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.prenom AS prenom_2,
  t0.email AS email_3,
  t0.abonne AS abonne_4
FROM
  client t0
WHERE
  t0.email = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.email AS email_3, t0.abonne AS abonne_4 FROM client t0 WHERE t0.email = 'sdurieux03@gmail.com' LIMIT 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 151)
4	Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntityValidator->validate (line 752)
5	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 485)
6	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 301)
7	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 131)
8	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 87)
9	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 61)
10	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 23)
11	App\Services\ClientService->NewClient (line 109)
12	App\Controller\PublicController->contact (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 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.02 ms
(4.04%)

SELECT f0_.id AS id_0, f0_.message AS message_1, f0_.finde_validite AS finde_validite_2 FROM flash_info f0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.message AS message_1,
  f0_.finde_validite AS finde_validite_2
FROM
  flash_info f0_

SELECT f0_.id AS id_0, f0_.message AS message_1, f0_.finde_validite AS finde_validite_2 FROM flash_info f0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 26)
7	App\Repository\FlashInfoRepository->FindTheFlashInfo (line 102)
8	App\Controller\PublicController->contact (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.67 ms
(2.67%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 26)
5	App\Services\ClientService->NewClient (line 109)
6	App\Controller\PublicController->contact (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.61 ms
(2.42%)

SELECT r0_.id AS id_0, r0_.message AS message_1, r0_.finde_validite AS finde_validite_2 FROM reponse_automatique r0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.message AS message_1,
  r0_.finde_validite AS finde_validite_2
FROM
  reponse_automatique r0_

SELECT r0_.id AS id_0, r0_.message AS message_1, r0_.finde_validite AS finde_validite_2 FROM reponse_automatique r0_;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 24)
7	App\Repository\ReponseAutomatiqueRepository->FindTheReponseAuto (line 74)
8	App\Services\EmailService->ReponseAutoEmail (line 35)
9	App\Services\EmailService->Contact (line 108)
10	App\Controller\PublicController->contact (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.49 ms
(1.95%)

INSERT INTO client (prenom, email, abonne) VALUES (?, ?, ?)

Parameters:

[
  "SYLVIE"
  "sdurieux03@gmail.com"
  1
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO client (prenom, email, abonne)
VALUES
  (?, ?, ?)

INSERT INTO client (prenom, email, abonne) VALUES ('SYLVIE', 'sdurieux03@gmail.com', 1);

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 285)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1183)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 447)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 26)
7	App\Services\ClientService->NewClient (line 109)
8	App\Controller\PublicController->contact (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.45 ms
(1.77%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 428)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 26)
4	App\Services\ClientService->NewClient (line 109)
5	App\Controller\PublicController->contact (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 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\FlashInfo	No errors.
App\Entity\ReponseAutomatique	No errors.
App\Entity\Client	No errors.

Symfony Profiler

POST https://www.cabinet-hypnose-riviere.com/Contact

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping