Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.60 ms Query time

0 Invalid entities

635 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.60 ms
(100.00%)

SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.reponse AS reponse_2, f0_.date_maj AS date_maj_3, f0_.histo_etat AS histo_etat_4, f0_.ordre AS ordre_5, f0_.date_creation AS date_creation_6, f0_.media_question AS media_question_7, f0_.media_reponse AS media_reponse_8, f0_.categorie_id AS categorie_id_9, f0_.etat_id AS etat_id_10 FROM flashcards f0_ ORDER BY f0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  f0_.id AS id_0,
  f0_.question AS question_1,
  f0_.reponse AS reponse_2,
  f0_.date_maj AS date_maj_3,
  f0_.histo_etat AS histo_etat_4,
  f0_.ordre AS ordre_5,
  f0_.date_creation AS date_creation_6,
  f0_.media_question AS media_question_7,
  f0_.media_reponse AS media_reponse_8,
  f0_.categorie_id AS categorie_id_9,
  f0_.etat_id AS etat_id_10
FROM
  flashcards f0_
ORDER BY
  f0_.id ASC

SELECT f0_.id AS id_0, f0_.question AS question_1, f0_.reponse AS reponse_2, f0_.date_maj AS date_maj_3, f0_.histo_etat AS histo_etat_4, f0_.ordre AS ordre_5, f0_.date_creation AS date_creation_6, f0_.media_question AS media_question_7, f0_.media_reponse AS media_reponse_8, f0_.categorie_id AS categorie_id_9, f0_.etat_id AS etat_id_10 FROM flashcards f0_ ORDER BY f0_.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\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 50)
10	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
11	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 50)
12	ApiPlatform\State\Provider\DeserializeProvider->provide (line 60)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
14	ApiPlatform\Symfony\Validator\State\ValidateProvider->provide (line 32)
15	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 62)
16	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 101)
17	ApiPlatform\State\Provider\ParameterProvider->provide (line 102)
18	ApiPlatform\State\Provider\ContentNegotiationProvider->provide (line 56)
19	ApiPlatform\Symfony\Controller\MainController->__invoke (line 94)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
22	Symfony\Component\HttpKernel\Kernel->handle (line 182)
23	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
24	require_once (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\Flashcards	602
App\Entity\Categorie	30
App\Entity\Etat	3

Entities Mapping

Class	Mapping errors
App\Entity\Flashcards	No errors.
App\Entity\Categorie	No errors.
App\Entity\Etat	No errors.

Symfony Profiler

GET https://mesflashcards.fr/api/flashcards

Configuration Settings

Theme

Page Width