Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.20 ms Query time

1 Invalid entities

#▲	Time	Info
1	0.61 ms	SELECT count(DISTINCT a0_.allergene_id) AS sclr_0 FROM `allergene` a0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(DISTINCT a0_.allergene_id) AS sclr_0 FROM `allergene` a0_ SELECT count(DISTINCT a0_.allergene_id) AS sclr_0 FROM `allergene` a0_;
2	0.23 ms	SELECT DISTINCT a0_.allergene_id AS allergene_id_0 FROM `allergene` a0_ LIMIT 10 OFFSET 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT a0_.allergene_id AS allergene_id_0 FROM `allergene` a0_ LIMIT 10 OFFSET 10 SELECT DISTINCT a0_.allergene_id AS allergene_id_0 FROM `allergene` a0_ LIMIT 10 OFFSET 10;
3	0.36 ms	SELECT a0_.allergene_id AS allergene_id_0, a0_.libelle AS libelle_1 FROM `allergene` a0_ WHERE a0_.allergene_id IN (?, ?, ?, ?) Parameters: [`11 12 13 14`] View formatted query View runnable query Explain query SELECT a0_.allergene_id AS allergene_id_0, a0_.libelle AS libelle_1 FROM `allergene` a0_ WHERE a0_.allergene_id IN (?, ?, ?, ?) SELECT a0_.allergene_id AS allergene_id_0, a0_.libelle AS libelle_1 FROM `allergene` a0_ WHERE a0_.allergene_id IN (11, 12, 13, 14);

#▲

Time

Info

0.61 ms

SELECT count(DISTINCT a0_.allergene_id) AS sclr_0 FROM `allergene` a0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT a0_.allergene_id) AS sclr_0
FROM
  `allergene` a0_

SELECT count(DISTINCT a0_.allergene_id) AS sclr_0 FROM `allergene` a0_;

0.23 ms

SELECT DISTINCT a0_.allergene_id AS allergene_id_0 FROM `allergene` a0_ LIMIT 10 OFFSET 10

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT a0_.allergene_id AS allergene_id_0
FROM
  `allergene` a0_
LIMIT
  10
OFFSET
  10

SELECT DISTINCT a0_.allergene_id AS allergene_id_0 FROM `allergene` a0_ LIMIT 10 OFFSET 10;

0.36 ms

SELECT a0_.allergene_id AS allergene_id_0, a0_.libelle AS libelle_1 FROM `allergene` a0_ WHERE a0_.allergene_id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query

SELECT
  a0_.allergene_id AS allergene_id_0,
  a0_.libelle AS libelle_1
FROM
  `allergene` a0_
WHERE
  a0_.allergene_id IN (?, ?, ?, ?)

SELECT a0_.allergene_id AS allergene_id_0, a0_.libelle AS libelle_1 FROM `allergene` a0_ WHERE a0_.allergene_id IN (11, 12, 13, 14);

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\Allergene	The field App\Entity\Allergene#contient is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contient#allergene_id does not contain the required 'inversedBy: "contient"' attribute.
App\Entity\Contient	No errors.