Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

1.58 ms Query time

0 Invalid entities

#▲	Time	Info
1	0.79 ms	SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM shop s0_ ORDER BY s0_.id DESC LIMIT 20 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM shop s0_ ORDER BY s0_.id DESC LIMIT 20 SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM shop s0_ ORDER BY s0_.id DESC LIMIT 20;
2	0.43 ms	SELECT s0_.id AS id_0, s0_.name AS name_1 FROM shop s0_ WHERE s0_.id IN (?, ?, ?, ?) ORDER BY s0_.id DESC Parameters: [`4 3 2 1`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1 FROM shop s0_ WHERE s0_.id IN (?, ?, ?, ?) ORDER BY s0_.id DESC SELECT s0_.id AS id_0, s0_.name AS name_1 FROM shop s0_ WHERE s0_.id IN (4, 3, 2, 1) ORDER BY s0_.id DESC;
3	0.36 ms	SELECT count(s0_.id) AS sclr_0 FROM shop s0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(s0_.id) AS sclr_0 FROM shop s0_ SELECT count(s0_.id) AS sclr_0 FROM shop s0_;

#▲

Time

Info

0.79 ms

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM shop s0_ ORDER BY s0_.id DESC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.id AS id_1
FROM
  shop s0_
ORDER BY
  s0_.id DESC
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM shop s0_ ORDER BY s0_.id DESC LIMIT 20;

0.43 ms

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

Parameters:

View formatted query View runnable query Explain query

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

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

0.36 ms

SELECT count(s0_.id) AS sclr_0 FROM shop s0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(s0_.id) AS sclr_0
FROM
  shop s0_

SELECT count(s0_.id) AS sclr_0 FROM shop s0_;

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