Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

13.19 ms Query time

1 Invalid entities

Time▼	Count	Info
12.72 ms (96.42%)	1	SELECT count(DISTINCT r0_.regime_id) AS sclr_0 FROM `regime` r0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(DISTINCT r0_.regime_id) AS sclr_0 FROM `regime` r0_ SELECT count(DISTINCT r0_.regime_id) AS sclr_0 FROM `regime` r0_;
0.24 ms (1.79%)	1	SELECT DISTINCT r0_.regime_id AS regime_id_0 FROM `regime` r0_ LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT r0_.regime_id AS regime_id_0 FROM `regime` r0_ LIMIT 10 SELECT DISTINCT r0_.regime_id AS regime_id_0 FROM `regime` r0_ LIMIT 10;
0.24 ms (1.79%)	1	SELECT r0_.regime_id AS regime_id_0, r0_.libelle AS libelle_1 FROM `regime` r0_ WHERE r0_.regime_id IN (?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`1 2 3 4 5 6 7 8`] View formatted query View runnable query Explain query SELECT r0_.regime_id AS regime_id_0, r0_.libelle AS libelle_1 FROM `regime` r0_ WHERE r0_.regime_id IN (?, ?, ?, ?, ?, ?, ?, ?) SELECT r0_.regime_id AS regime_id_0, r0_.libelle AS libelle_1 FROM `regime` r0_ WHERE r0_.regime_id IN (1, 2, 3, 4, 5, 6, 7, 8);

Time▼

Count

Info

12.72 ms
(96.42%)

SELECT count(DISTINCT r0_.regime_id) AS sclr_0 FROM `regime` r0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT r0_.regime_id) AS sclr_0
FROM
  `regime` r0_

SELECT count(DISTINCT r0_.regime_id) AS sclr_0 FROM `regime` r0_;

0.24 ms
(1.79%)

SELECT DISTINCT r0_.regime_id AS regime_id_0 FROM `regime` r0_ LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT r0_.regime_id AS regime_id_0
FROM
  `regime` r0_
LIMIT
  10

SELECT DISTINCT r0_.regime_id AS regime_id_0 FROM `regime` r0_ LIMIT 10;

0.24 ms
(1.79%)

SELECT r0_.regime_id AS regime_id_0, r0_.libelle AS libelle_1 FROM `regime` r0_ WHERE r0_.regime_id IN (?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query

SELECT
  r0_.regime_id AS regime_id_0,
  r0_.libelle AS libelle_1
FROM
  `regime` r0_
WHERE
  r0_.regime_id IN (?, ?, ?, ?, ?, ?, ?, ?)

SELECT r0_.regime_id AS regime_id_0, r0_.libelle AS libelle_1 FROM `regime` r0_ WHERE r0_.regime_id IN (1, 2, 3, 4, 5, 6, 7, 8);

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\Regime	The field App\Entity\Regime#adaptes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Adapte#regime_id does not contain the required 'inversedBy: "adaptes"' attribute.
App\Entity\Adapte	No errors.