Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

3 Different statements

0.39 ms Query time

0 Invalid entities

Time▼	Count	Info
0.25 ms (64.63%)	1	SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ ORDER BY s0_.name ASC LIMIT 20 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ ORDER BY s0_.name ASC LIMIT 20 SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ ORDER BY s0_.name ASC LIMIT 20;
0.07 ms (18.85%)	1	SELECT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.name ASC Parameters: [`4 3 8 5 2 6 1 9 7`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.name ASC SELECT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ WHERE s0_.id IN (4, 3, 8, 5, 2, 6, 1, 9, 7) ORDER BY s0_.name ASC;
0.06 ms (16.51%)	1	SELECT count(s0_.id) AS sclr_0 FROM symfony_demo_tag s0_ Parameters: [] View formatted query View runnable query Explain query SELECT count(s0_.id) AS sclr_0 FROM symfony_demo_tag s0_ SELECT count(s0_.id) AS sclr_0 FROM symfony_demo_tag s0_;

Time▼

Count

Info

0.25 ms
(64.63%)

SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ ORDER BY s0_.name ASC LIMIT 20

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.name AS name_1
FROM
  symfony_demo_tag s0_
ORDER BY
  s0_.name ASC
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ ORDER BY s0_.name ASC LIMIT 20;

0.07 ms
(18.85%)

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

Parameters:

View formatted query View runnable query Explain query

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

SELECT s0_.id AS id_0, s0_.name AS name_1 FROM symfony_demo_tag s0_ WHERE s0_.id IN (4, 3, 8, 5, 2, 6, 1, 9, 7) ORDER BY s0_.name ASC;

0.06 ms
(16.51%)

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

Parameters:

[]

View formatted query View runnable query Explain query

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

SELECT count(s0_.id) AS sclr_0 FROM symfony_demo_tag 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\Tag	No errors.