Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

0.27 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.27 ms
(100.00%)

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.content AS content_3, v0_.publication_date AS publication_date_4, v0_.author AS author_5, m1_.id AS id_6, m1_.file_name AS file_name_7, m1_.file_path AS file_path_8, v2_.id AS id_9, v2_.libelle AS libelle_10, v3_.id AS id_11, v3_.state AS state_12, v0_.image_id AS image_id_13, v0_.category_id AS category_id_14, v0_.state_id AS state_id_15 FROM V_Article v0_ LEFT JOIN media_object m1_ ON v0_.image_id = m1_.id INNER JOIN V_Blog_Category v2_ ON v0_.category_id = v2_.id LEFT JOIN V_Article_State v3_ ON v0_.state_id = v3_.id WHERE v0_.id = ?

Parameters:

[
  10
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  v0_.id AS id_0,
  v0_.title AS title_1,
  v0_.description AS description_2,
  v0_.content AS content_3,
  v0_.publication_date AS publication_date_4,
  v0_.author AS author_5,
  m1_.id AS id_6,
  m1_.file_name AS file_name_7,
  m1_.file_path AS file_path_8,
  v2_.id AS id_9,
  v2_.libelle AS libelle_10,
  v3_.id AS id_11,
  v3_.state AS state_12,
  v0_.image_id AS image_id_13,
  v0_.category_id AS category_id_14,
  v0_.state_id AS state_id_15
FROM
  V_Article v0_
  LEFT JOIN media_object m1_ ON v0_.image_id = m1_.id
  INNER JOIN V_Blog_Category v2_ ON v0_.category_id = v2_.id
  LEFT JOIN V_Article_State v3_ ON v0_.state_id = v3_.id
WHERE
  v0_.id = ?

SELECT v0_.id AS id_0, v0_.title AS title_1, v0_.description AS description_2, v0_.content AS content_3, v0_.publication_date AS publication_date_4, v0_.author AS author_5, m1_.id AS id_6, m1_.file_name AS file_name_7, m1_.file_path AS file_path_8, v2_.id AS id_9, v2_.libelle AS libelle_10, v3_.id AS id_11, v3_.state AS state_12, v0_.image_id AS image_id_13, v0_.category_id AS category_id_14, v0_.state_id AS state_id_15 FROM V_Article v0_ LEFT JOIN media_object m1_ ON v0_.image_id = m1_.id INNER JOIN V_Blog_Category v2_ ON v0_.category_id = v2_.id LEFT JOIN V_Article_State v3_ ON v0_.state_id = v3_.id WHERE v0_.id = 10;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 87)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 79)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 50)
10	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
11	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
12	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 56)
13	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 32)
15	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 62)
16	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 87)
17	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 103)
18	ApiPlatform\State\Provider\ParameterProvider->provide (line 51)
19	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 83)
20	ApiPlatform\Symfony\Controller\MainController->__invoke (line 181)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	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\Article	1
App\Entity\MediaObject	1
App\Entity\VitrineBlogCategory	1
App\Entity\VitrineArticleState	1

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\Article	No errors.
App\Entity\MediaObject	No errors.
App\Entity\VitrineBlogCategory	No errors.
App\Entity\VitrineArticleState	No errors.

Symfony Profiler

GET https://back-oio.camileia.com/api/articles/10

Configuration Settings

Theme

Page Width