Symfony Profiler

Query Metrics

6 Database Queries

2 Different statements

8.03 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

7.55 ms
(94.07%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.email AS email_3, t0.message AS message_4, t0.note AS note_5, t0.is_valid AS is_valid_6, t0.created_at AS created_at_7, t0.titre AS titre_8 FROM commentaires t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.email AS email_3,
  t0.message AS message_4,
  t0.note AS note_5,
  t0.is_valid AS is_valid_6,
  t0.created_at AS created_at_7,
  t0.titre AS titre_8
FROM
  commentaires t0

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.email AS email_3, t0.message AS message_4, t0.note AS note_5, t0.is_valid AS is_valid_6, t0.created_at AS created_at_7, t0.titre AS titre_8 FROM commentaires t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 944)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 225)
3	Doctrine\ORM\EntityRepository->findBy (line 207)
4	Doctrine\ORM\EntityRepository->findAll (line 37)
5	App\Controller\HomeController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.48 ms
(5.93%)

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.email AS email_2, c0_.message AS message_3, c0_.note AS note_4, c0_.is_valid AS is_valid_5, c0_.created_at AS created_at_6, c0_.titre AS titre_7 FROM commentaires c0_ ORDER BY c0_.note DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.nom AS nom_1,
  c0_.email AS email_2,
  c0_.message AS message_3,
  c0_.note AS note_4,
  c0_.is_valid AS is_valid_5,
  c0_.created_at AS created_at_6,
  c0_.titre AS titre_7
FROM
  commentaires c0_
ORDER BY
  c0_.note DESC
LIMIT
  3

SELECT c0_.id AS id_0, c0_.nom AS nom_1, c0_.email AS email_2, c0_.message AS message_3, c0_.note AS note_4, c0_.is_valid AS is_valid_5, c0_.created_at AS created_at_6, c0_.titre AS titre_7 FROM commentaires c0_ ORDER BY c0_.note DESC LIMIT 3;

#	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 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 33)
7	App\Repository\CommentairesRepository->findBestCommentaires (line 38)
8	App\Controller\HomeController->index (line 178)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	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\Commentaires	No errors.

Symfony Profiler

GET https://formcodeur-clients.fr/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DApp%255CController%255CHomeController%253A%253Afooter

Configuration Settings

Theme