Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.22 ms Query time

0 Invalid entities

Time▼	Count	Info
0.75 ms (61.26%)	1	SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM category c0_ ORDER BY c0_.id DESC LIMIT 20 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM category c0_ ORDER BY c0_.id DESC LIMIT 20 SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM category c0_ ORDER BY c0_.id DESC LIMIT 20;
0.25 ms (20.60%)	1	SELECT c0_.id AS id_0, c0_.name AS name_1 FROM category c0_ WHERE c0_.id IN (?, ?, ?) ORDER BY c0_.id DESC Parameters: [`3 2 1`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1 FROM category c0_ WHERE c0_.id IN (?, ?, ?) ORDER BY c0_.id DESC SELECT c0_.id AS id_0, c0_.name AS name_1 FROM category c0_ WHERE c0_.id IN (3, 2, 1) ORDER BY c0_.id DESC;
0.22 ms (18.15%)	1	SELECT count(c0_.id) AS sclr_0 FROM category c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(c0_.id) AS sclr_0 FROM category c0_ SELECT count(c0_.id) AS sclr_0 FROM category c0_;

Time▼

Count

Info

0.75 ms
(61.26%)

SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM category c0_ ORDER BY c0_.id DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.id AS id_1
FROM
  category c0_
ORDER BY
  c0_.id DESC
LIMIT
  20

SELECT DISTINCT c0_.id AS id_0, c0_.id AS id_1 FROM category c0_ ORDER BY c0_.id DESC LIMIT 20;

0.25 ms
(20.60%)

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM category c0_ WHERE c0_.id IN (?, ?, ?) ORDER BY c0_.id DESC

Parameters:

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  category c0_
WHERE
  c0_.id IN (?, ?, ?)
ORDER BY
  c0_.id DESC

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM category c0_ WHERE c0_.id IN (3, 2, 1) ORDER BY c0_.id DESC;

0.22 ms
(18.15%)

SELECT count(c0_.id) AS sclr_0 FROM category c0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(c0_.id) AS sclr_0
FROM
  category c0_

SELECT count(c0_.id) AS sclr_0 FROM category c0_;

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\Category	No errors.
App\Entity\Article	No errors.