Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.81 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.81 ms

SELECT t0.id AS id_1, t0.flux AS flux_2, t0.typecontenant AS typecontenant_3, t0.volumecontenant AS volumecontenant_4, t0.poids AS poids_5, t0.tauxderemplissage AS tauxderemplissage_6, t0.collecte AS collecte_7, t0.cumulflux AS cumulflux_8, t0.qualitedetribennes AS qualitedetribennes_9, t0.estimatifbennes AS estimatifbennes_10, t0.collectebennes AS collectebennes_11, t0.cumulbennes AS cumulbennes_12, t0.datedesoumission AS datedesoumission_13, t0.commentaire AS commentaire_14, t0.heure AS heure_15, t0.exutoire AS exutoire_16, t0.numerobordereau AS numerobordereau_17, t0.hall_id AS hall_id_18, t0.leclient_id AS leclient_id_19, t0.evenement_id AS evenement_id_20, t0.centredetris_id AS centredetris_id_21, t0.auteur_id AS auteur_id_22 FROM suivi t0 WHERE t0.auteur_id IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.flux AS flux_2,
  t0.typecontenant AS typecontenant_3,
  t0.volumecontenant AS volumecontenant_4,
  t0.poids AS poids_5,
  t0.tauxderemplissage AS tauxderemplissage_6,
  t0.collecte AS collecte_7,
  t0.cumulflux AS cumulflux_8,
  t0.qualitedetribennes AS qualitedetribennes_9,
  t0.estimatifbennes AS estimatifbennes_10,
  t0.collectebennes AS collectebennes_11,
  t0.cumulbennes AS cumulbennes_12,
  t0.datedesoumission AS datedesoumission_13,
  t0.commentaire AS commentaire_14,
  t0.heure AS heure_15,
  t0.exutoire AS exutoire_16,
  t0.numerobordereau AS numerobordereau_17,
  t0.hall_id AS hall_id_18,
  t0.leclient_id AS leclient_id_19,
  t0.evenement_id AS evenement_id_20,
  t0.centredetris_id AS centredetris_id_21,
  t0.auteur_id AS auteur_id_22
FROM
  suivi t0
WHERE
  t0.auteur_id IS NULL

SELECT t0.id AS id_1, t0.flux AS flux_2, t0.typecontenant AS typecontenant_3, t0.volumecontenant AS volumecontenant_4, t0.poids AS poids_5, t0.tauxderemplissage AS tauxderemplissage_6, t0.collecte AS collecte_7, t0.cumulflux AS cumulflux_8, t0.qualitedetribennes AS qualitedetribennes_9, t0.estimatifbennes AS estimatifbennes_10, t0.collectebennes AS collectebennes_11, t0.cumulbennes AS cumulbennes_12, t0.datedesoumission AS datedesoumission_13, t0.commentaire AS commentaire_14, t0.heure AS heure_15, t0.exutoire AS exutoire_16, t0.numerobordereau AS numerobordereau_17, t0.hall_id AS hall_id_18, t0.leclient_id AS leclient_id_19, t0.evenement_id AS evenement_id_20, t0.centredetris_id AS centredetris_id_21, t0.auteur_id AS auteur_id_22 FROM suivi t0 WHERE t0.auteur_id IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 23)
5	App\Controller\SuiviController->index (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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\Suivi	No errors.
App\Entity\Hall	No errors.
App\Entity\Client	No errors.
App\Entity\Evenement	No errors.
App\Entity\Centredetri	No errors.
App\Entity\User	The field App\Entity\User#panier is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Panier#proprietaire does not contain the required 'inversedBy="panier"' attribute.
App\Entity\Photosarchives	No errors.

Symfony Profiler

GET https://bereup.online/suivi/

Configuration Settings

Theme