Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

2.09 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.93 ms	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_;
2	0.23 ms	SELECT DISTINCT p0_.plat_id AS plat_id_0 FROM `plat` p0_ LIMIT 10 OFFSET 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT p0_.plat_id AS plat_id_0 FROM `plat` p0_ LIMIT 10 OFFSET 10 SELECT DISTINCT p0_.plat_id AS plat_id_0 FROM `plat` p0_ LIMIT 10 OFFSET 10;
3	0.93 ms	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: [`11 12 13 14 15 16 17 18 19 20`] 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 (11, 12, 13, 14, 15, 16, 17, 18, 19, 20);

#▲

Time

Info

0.93 ms

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.23 ms

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

Parameters:

[]

View formatted query View runnable query Explain query

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

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

0.93 ms

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 (11, 12, 13, 14, 15, 16, 17, 18, 19, 20);

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\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.

Symfony Profiler

https://deltainformatique.org/ECF/plat/liste?page=2

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping