Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

3.41 ms Query time

1 Invalid entities

#▲	Time	Info
1	2.97 ms	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_;
2	0.19 ms	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;
3	0.24 ms	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);

#▲

Time

Info

2.97 ms

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

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;

0.24 ms

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);

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.