Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.55 ms Query time

2 Invalid entities

Time▼	Count	Info
0.62 ms (39.93%)	1	SELECT p0_.plat_id AS plat_id_0, p0_.titre_plat AS titre_plat_1, p0_.photo AS photo_2 FROM `plat` p0_ WHERE p0_.plat_id IN (?, ?) Parameters: [`21 22`] View formatted query View runnable query Explain query SELECT p0_.plat_id AS plat_id_0, p0_.titre_plat AS titre_plat_1, p0_.photo AS photo_2 FROM `plat` p0_ WHERE p0_.plat_id IN (?, ?) SELECT p0_.plat_id AS plat_id_0, p0_.titre_plat AS titre_plat_1, p0_.photo AS photo_2 FROM `plat` p0_ WHERE p0_.plat_id IN (21, 22);
0.58 ms (37.21%)	1	SELECT count(DISTINCT p0_.plat_id) AS sclr_0 FROM `plat` p0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(DISTINCT p0_.plat_id) AS sclr_0 FROM `plat` p0_ SELECT count(DISTINCT p0_.plat_id) AS sclr_0 FROM `plat` p0_;
0.36 ms (22.86%)	1	SELECT DISTINCT p0_.plat_id AS plat_id_0 FROM `plat` p0_ LIMIT 10 OFFSET 20 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT p0_.plat_id AS plat_id_0 FROM `plat` p0_ LIMIT 10 OFFSET 20 SELECT DISTINCT p0_.plat_id AS plat_id_0 FROM `plat` p0_ LIMIT 10 OFFSET 20;

Time▼

Count

Info

0.62 ms
(39.93%)

SELECT p0_.plat_id AS plat_id_0, p0_.titre_plat AS titre_plat_1, p0_.photo AS photo_2 FROM `plat` p0_ WHERE p0_.plat_id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query

SELECT
  p0_.plat_id AS plat_id_0,
  p0_.titre_plat AS titre_plat_1,
  p0_.photo AS photo_2
FROM
  `plat` p0_
WHERE
  p0_.plat_id IN (?, ?)

SELECT p0_.plat_id AS plat_id_0, p0_.titre_plat AS titre_plat_1, p0_.photo AS photo_2 FROM `plat` p0_ WHERE p0_.plat_id IN (21, 22);

0.58 ms
(37.21%)

SELECT count(DISTINCT p0_.plat_id) AS sclr_0 FROM `plat` p0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT p0_.plat_id) AS sclr_0
FROM
  `plat` p0_

SELECT count(DISTINCT p0_.plat_id) AS sclr_0 FROM `plat` p0_;

0.36 ms
(22.86%)

SELECT DISTINCT p0_.plat_id AS plat_id_0 FROM `plat` p0_ LIMIT 10 OFFSET 20

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT p0_.plat_id AS plat_id_0
FROM
  `plat` p0_
LIMIT
  10
OFFSET
  20

SELECT DISTINCT p0_.plat_id AS plat_id_0 FROM `plat` p0_ LIMIT 10 OFFSET 20;

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\Plat	The field App\Entity\Plat#proposeplat is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProposePlat#plat_id does not contain the required 'inversedBy: "proposeplat"' attribute. The field App\Entity\Plat#contient is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Contient#plat_id does not contain the required 'inversedBy: "contient"' attribute.
App\Entity\ProposePlat	The association App\Entity\ProposePlat#menu_id refers to the inverse side field App\Entity\Menu#proposePlat which does not exist.
App\Entity\Contient	No errors.