Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.97 ms Query time

0 Invalid entities

#▲

Time

Info

1.97 ms

SELECT l0_.titre AS titre_0, l0_.auteur AS auteur_1 FROM livres l0_ WHERE l0_.auteur LIKE ? ORDER BY l0_.auteur ASC, l0_.titre ASC

Parameters:

[
  "%Simi, Giampaolo%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.titre AS titre_0,
  l0_.auteur AS auteur_1
FROM
  livres l0_
WHERE
  l0_.auteur LIKE ?
ORDER BY
  l0_.auteur ASC,
  l0_.titre ASC

SELECT l0_.titre AS titre_0, l0_.auteur AS auteur_1 FROM livres l0_ WHERE l0_.auteur LIKE '%Simi, Giampaolo%' ORDER BY l0_.auteur ASC, l0_.titre ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 56)
7	App\Repository\LivresRepository->findTitlesByAuteur (line 54)
8	App\Controller\MainController->search (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\Livres	No errors.