Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.84 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
2.56 ms (90.34%)	1	SELECT count(DISTINCT m0_.menu_id) AS sclr_0 FROM `menu` m0_ WHERE m0_.titre LIKE '1' Parameters: [] View formatted query View runnable query Explain query SELECT count(DISTINCT m0_.menu_id) AS sclr_0 FROM `menu` m0_ WHERE m0_.titre LIKE '1' SELECT count(DISTINCT m0_.menu_id) AS sclr_0 FROM `menu` m0_ WHERE m0_.titre LIKE '1';
0.27 ms (9.66%)	1	SELECT DISTINCT m0_.menu_id AS menu_id_0, m0_.quantite_restante AS quantite_restante_1 FROM `menu` m0_ WHERE m0_.titre LIKE '1' ORDER BY m0_.quantite_restante DESC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT m0_.menu_id AS menu_id_0, m0_.quantite_restante AS quantite_restante_1 FROM `menu` m0_ WHERE m0_.titre LIKE '1' ORDER BY m0_.quantite_restante DESC LIMIT 10 SELECT DISTINCT m0_.menu_id AS menu_id_0, m0_.quantite_restante AS quantite_restante_1 FROM `menu` m0_ WHERE m0_.titre LIKE '1' ORDER BY m0_.quantite_restante DESC LIMIT 10;

Time▼

Count

Info

2.56 ms
(90.34%)

SELECT count(DISTINCT m0_.menu_id) AS sclr_0 FROM `menu` m0_ WHERE m0_.titre LIKE '1'

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT m0_.menu_id) AS sclr_0
FROM
  `menu` m0_
WHERE
  m0_.titre LIKE '1'

SELECT count(DISTINCT m0_.menu_id) AS sclr_0 FROM `menu` m0_ WHERE m0_.titre LIKE '1';

0.27 ms
(9.66%)

SELECT DISTINCT m0_.menu_id AS menu_id_0, m0_.quantite_restante AS quantite_restante_1 FROM `menu` m0_ WHERE m0_.titre LIKE '1' ORDER BY m0_.quantite_restante DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT m0_.menu_id AS menu_id_0,
  m0_.quantite_restante AS quantite_restante_1
FROM
  `menu` m0_
WHERE
  m0_.titre LIKE '1'
ORDER BY
  m0_.quantite_restante DESC
LIMIT
  10

SELECT DISTINCT m0_.menu_id AS menu_id_0, m0_.quantite_restante AS quantite_restante_1 FROM `menu` m0_ WHERE m0_.titre LIKE '1' ORDER BY m0_.quantite_restante DESC LIMIT 10;

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\Menu	The mappings App\Entity\Menu#proposeplat and App\Entity\ProposePlat#menu_id are inconsistent with each other. The field App\Entity\Menu#proposetheme is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProposeTheme#menu_id does not contain the required 'inversedBy: "proposetheme"' attribute. The field App\Entity\Menu#adapte is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Adapte#menu_id does not contain the required 'inversedBy: "adapte"' attribute.

Class

Mapping errors

App\Entity\Menu

The mappings App\Entity\Menu#proposeplat and App\Entity\ProposePlat#menu_id are inconsistent with each other.
The field App\Entity\Menu#proposetheme is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProposeTheme#menu_id does not contain the required 'inversedBy: "proposetheme"' attribute.
The field App\Entity\Menu#adapte is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Adapte#menu_id does not contain the required 'inversedBy: "adapte"' attribute.