Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.24 ms Query time

0 Invalid entities

23 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.24 ms
(100.00%)

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.description AS description_3, p1_.id AS id_4, p1_.name AS name_5, p2_.id AS id_6, p2_.name AS name_7, p3_.id AS id_8, p3_.count AS count_9, p3_.ip AS ip_10, p0_.categorie_id AS categorie_id_11, p0_.theme_id AS theme_id_12, p3_.oeuvre_id AS oeuvre_id_13 FROM prefix_oeuvre p0_ LEFT JOIN prefix_categorie p1_ ON p0_.categorie_id = p1_.id LEFT JOIN prefix_theme p2_ ON p0_.theme_id = p2_.id LEFT JOIN prefix_like p3_ ON p0_.id = p3_.oeuvre_id ORDER BY p0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.image AS image_2,
  p0_.description AS description_3,
  p1_.id AS id_4,
  p1_.name AS name_5,
  p2_.id AS id_6,
  p2_.name AS name_7,
  p3_.id AS id_8,
  p3_.count AS count_9,
  p3_.ip AS ip_10,
  p0_.categorie_id AS categorie_id_11,
  p0_.theme_id AS theme_id_12,
  p3_.oeuvre_id AS oeuvre_id_13
FROM
  prefix_oeuvre p0_
  LEFT JOIN prefix_categorie p1_ ON p0_.categorie_id = p1_.id
  LEFT JOIN prefix_theme p2_ ON p0_.theme_id = p2_.id
  LEFT JOIN prefix_like p3_ ON p0_.id = p3_.oeuvre_id
ORDER BY
  p0_.id ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.image AS image_2, p0_.description AS description_3, p1_.id AS id_4, p1_.name AS name_5, p2_.id AS id_6, p2_.name AS name_7, p3_.id AS id_8, p3_.count AS count_9, p3_.ip AS ip_10, p0_.categorie_id AS categorie_id_11, p0_.theme_id AS theme_id_12, p3_.oeuvre_id AS oeuvre_id_13 FROM prefix_oeuvre p0_ LEFT JOIN prefix_categorie p1_ ON p0_.categorie_id = p1_.id LEFT JOIN prefix_theme p2_ ON p0_.theme_id = p2_.id LEFT JOIN prefix_like p3_ ON p0_.id = p3_.oeuvre_id ORDER BY p0_.id ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	ApiPlatform\Doctrine\Orm\State\CollectionProvider->provide (line 80)
7	ApiPlatform\State\CallableProvider->provide (line 43)
8	ApiPlatform\State\Provider\ReadProvider->provide (line 84)
9	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 68)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 193)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 32)
26	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Oeuvre	16
App\Entity\Like	3
App\Entity\Categorie	2
App\Entity\Theme	2

Entities Mapping

Class	Mapping errors
App\Entity\Oeuvre	No errors.
App\Entity\Categorie	No errors.
App\Entity\Theme	No errors.
App\Entity\Like	No errors.

Symfony Profiler

GET https://bac.varascundo.com/api/oeuvres

Configuration Settings

Theme

Page Width