Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.13 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.72 ms

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.image AS image_5, t0.formule1 AS formule1_6, t0.formule2 AS formule2_7, t0.infos_pratiques AS infos_pratiques_8, t0.document_inscription AS document_inscription_9, t0.niveaux AS niveaux_10, t0.date_limite AS date_limite_11, t0.inscription_allow AS inscription_allow_12, t0.nb_jours AS nb_jours_13, t0.type AS type_14 FROM stage t0 ORDER BY t0.date_debut DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.titre AS titre_2,
  t0.date_debut AS date_debut_3,
  t0.date_fin AS date_fin_4,
  t0.image AS image_5,
  t0.formule1 AS formule1_6,
  t0.formule2 AS formule2_7,
  t0.infos_pratiques AS infos_pratiques_8,
  t0.document_inscription AS document_inscription_9,
  t0.niveaux AS niveaux_10,
  t0.date_limite AS date_limite_11,
  t0.inscription_allow AS inscription_allow_12,
  t0.nb_jours AS nb_jours_13,
  t0.type AS type_14
FROM
  stage t0
ORDER BY
  t0.date_debut DESC

SELECT t0.id AS id_1, t0.titre AS titre_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.image AS image_5, t0.formule1 AS formule1_6, t0.formule2 AS formule2_7, t0.infos_pratiques AS infos_pratiques_8, t0.document_inscription AS document_inscription_9, t0.niveaux AS niveaux_10, t0.date_limite AS date_limite_11, t0.inscription_allow AS inscription_allow_12, t0.nb_jours AS nb_jours_13, t0.type AS type_14 FROM stage t0 ORDER BY t0.date_debut DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 277)
5	App\Controller\DefaultController->stageGalery (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.41 ms

SELECT t0.id AS id_1, t0.text AS text_2 FROM dictionnaire t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.text AS text_2
FROM
  dictionnaire t0

SELECT t0.id AS id_1, t0.text AS text_2 FROM dictionnaire t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 904)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 278)
6	App\Controller\DefaultController->stageGalery (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\Stage	No errors.
App\Entity\Sections	No errors.
App\Entity\InscriptionStage	The association App\Entity\InscriptionStage#semaineStages refers to the owning side field App\Entity\SemaineStage#formulaire which does not exist.
App\Entity\SemaineStage	No errors.
App\Entity\Document	No errors.
App\Entity\SemaineStageAdulte	No errors.
App\Entity\Dictionnaire	No errors.

Symfony Profiler

GET https://www.tennisspora.lu/stages?p=stages

Configuration Settings

Theme