Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.22 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.22 ms
(100.00%)

SELECT l0_.id AS id_0, l0_.label AS label_1, l0_.country AS country_2, l1_.id AS id_3, l1_.label AS label_4, l1_.delay_in_days AS delay_in_days_5, l0_.frequency_id AS frequency_id_6 FROM language l0_ LEFT JOIN language_frequency l1_ ON l0_.frequency_id = l1_.id ORDER BY l0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  l0_.id AS id_0,
  l0_.label AS label_1,
  l0_.country AS country_2,
  l1_.id AS id_3,
  l1_.label AS label_4,
  l1_.delay_in_days AS delay_in_days_5,
  l0_.frequency_id AS frequency_id_6
FROM
  language l0_
  LEFT JOIN language_frequency l1_ ON l0_.frequency_id = l1_.id
ORDER BY
  l0_.id ASC

SELECT l0_.id AS id_0, l0_.label AS label_1, l0_.country AS country_2, l1_.id AS id_3, l1_.label AS label_4, l1_.delay_in_days AS delay_in_days_5, l0_.frequency_id AS frequency_id_6 FROM language l0_ LEFT JOIN language_frequency l1_ ON l0_.frequency_id = l1_.id ORDER BY l0_.id 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 81)
7	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 80)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 86)
10	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 103)
11	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
14	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 95)
15	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 115)
16	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
19	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
22	Symfony\Component\HttpKernel\Kernel->handle (line 35)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
24	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\Language	No errors.
App\Entity\LanguageFrequency	No errors.
App\Entity\Reservation	No errors.

Symfony Profiler

GET http://new-api.tra-diction.fr/api/languages

Configuration Settings

Theme