Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

3.41 ms Query time

1 Invalid entities

Time▼	Count	Info
2.97 ms (87.22%)	1	SELECT count(DISTINCT t0_.theme_id) AS sclr_0 FROM `theme` t0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(DISTINCT t0_.theme_id) AS sclr_0 FROM `theme` t0_ SELECT count(DISTINCT t0_.theme_id) AS sclr_0 FROM `theme` t0_;
0.24 ms (7.17%)	1	SELECT t0_.theme_id AS theme_id_0, t0_.libelle AS libelle_1 FROM `theme` t0_ WHERE t0_.theme_id IN (?, ?, ?, ?) Parameters: [`1 2 3 4`] View formatted query View runnable query Explain query SELECT t0_.theme_id AS theme_id_0, t0_.libelle AS libelle_1 FROM `theme` t0_ WHERE t0_.theme_id IN (?, ?, ?, ?) SELECT t0_.theme_id AS theme_id_0, t0_.libelle AS libelle_1 FROM `theme` t0_ WHERE t0_.theme_id IN (1, 2, 3, 4);
0.19 ms (5.61%)	1	SELECT DISTINCT t0_.theme_id AS theme_id_0 FROM `theme` t0_ LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT t0_.theme_id AS theme_id_0 FROM `theme` t0_ LIMIT 10 SELECT DISTINCT t0_.theme_id AS theme_id_0 FROM `theme` t0_ LIMIT 10;

Time▼

Count

Info

2.97 ms
(87.22%)

SELECT count(DISTINCT t0_.theme_id) AS sclr_0 FROM `theme` t0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(DISTINCT t0_.theme_id) AS sclr_0
FROM
  `theme` t0_

SELECT count(DISTINCT t0_.theme_id) AS sclr_0 FROM `theme` t0_;

0.24 ms
(7.17%)

SELECT t0_.theme_id AS theme_id_0, t0_.libelle AS libelle_1 FROM `theme` t0_ WHERE t0_.theme_id IN (?, ?, ?, ?)

Parameters:

View formatted query View runnable query Explain query

SELECT
  t0_.theme_id AS theme_id_0,
  t0_.libelle AS libelle_1
FROM
  `theme` t0_
WHERE
  t0_.theme_id IN (?, ?, ?, ?)

SELECT t0_.theme_id AS theme_id_0, t0_.libelle AS libelle_1 FROM `theme` t0_ WHERE t0_.theme_id IN (1, 2, 3, 4);

0.19 ms
(5.61%)

SELECT DISTINCT t0_.theme_id AS theme_id_0 FROM `theme` t0_ LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT t0_.theme_id AS theme_id_0
FROM
  `theme` t0_
LIMIT
  10

SELECT DISTINCT t0_.theme_id AS theme_id_0 FROM `theme` t0_ LIMIT 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\Theme	The field App\Entity\Theme#proposetheme is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProposeTheme#theme_id does not contain the required 'inversedBy: "proposetheme"' attribute.
App\Entity\ProposeTheme	No errors.