Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

110.88 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

110.88 ms

SELECT t0.id AS id_1, t0.is_solo AS is_solo_2, t0.is_valide AS is_valide_3, t0.depart AS depart_4, t0.arrive AS arrive_5, t0.nom AS nom_6, t0.date_prev AS date_prev_7, t0.lat AS lat_8, t0.lon AS lon_9, t0.is_sel AS is_sel_10, t0.maj AS maj_11, t0.lieu_d_id AS lieu_d_id_12, t0.lieu_a_id AS lieu_a_id_13, t0.dernier_point_id AS dernier_point_id_14, t0.passage_actif_id AS passage_actif_id_15, t16.id AS id_17, t16.nom AS nom_18, t16.pass AS pass_19, t16.epreuve_sel_id AS epreuve_sel_id_20 FROM epreuve t0 LEFT JOIN trackeur t16 ON t16.epreuve_sel_id = t0.id

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.is_solo AS is_solo_2,
  t0.is_valide AS is_valide_3,
  t0.depart AS depart_4,
  t0.arrive AS arrive_5,
  t0.nom AS nom_6,
  t0.date_prev AS date_prev_7,
  t0.lat AS lat_8,
  t0.lon AS lon_9,
  t0.is_sel AS is_sel_10,
  t0.maj AS maj_11,
  t0.lieu_d_id AS lieu_d_id_12,
  t0.lieu_a_id AS lieu_a_id_13,
  t0.dernier_point_id AS dernier_point_id_14,
  t0.passage_actif_id AS passage_actif_id_15,
  t16.id AS id_17,
  t16.nom AS nom_18,
  t16.pass AS pass_19,
  t16.epreuve_sel_id AS epreuve_sel_id_20
FROM
  epreuve t0
  LEFT JOIN trackeur t16 ON t16.epreuve_sel_id = t0.id

SELECT t0.id AS id_1, t0.is_solo AS is_solo_2, t0.is_valide AS is_valide_3, t0.depart AS depart_4, t0.arrive AS arrive_5, t0.nom AS nom_6, t0.date_prev AS date_prev_7, t0.lat AS lat_8, t0.lon AS lon_9, t0.is_sel AS is_sel_10, t0.maj AS maj_11, t0.lieu_d_id AS lieu_d_id_12, t0.lieu_a_id AS lieu_a_id_13, t0.dernier_point_id AS dernier_point_id_14, t0.passage_actif_id AS passage_actif_id_15, t16.id AS id_17, t16.nom AS nom_18, t16.pass AS pass_19, t16.epreuve_sel_id AS epreuve_sel_id_20 FROM epreuve t0 LEFT JOIN trackeur t16 ON t16.epreuve_sel_id = t0.id;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 933)
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 15)
6	App\Controller\EpreuvesListController->index (line 178)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
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\Epreuve	The field App\Entity\Epreuve#trackeur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Trackeur#EpreuveSel does not contain the required 'inversedBy="trackeur"' attribute.
App\Entity\Lieu	No errors.
App\Entity\Point	No errors.
App\Entity\Passage	No errors.
App\Entity\Trackeur	No errors.
App\Entity\EpreuvesNageurs	No errors.

Symfony Profiler

GET https://swimtrack.san-forma.fr/

Configuration Settings

Theme