Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.20 ms Query time

1 Invalid entities

Time▼	Count	Info
0.61 ms (50.74%)	1	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.36 ms (29.94%)	1	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);
0.23 ms (19.31%)	1	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;

Time▼

Count

Info

0.61 ms
(50.74%)

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.36 ms
(29.94%)

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);

0.23 ms
(19.31%)

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;

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.