Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.88 ms Query time

0 Invalid entities

Time▼	Count	Info
0.48 ms (54.56%)	1	SELECT * FROM blog WHERE id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM blog WHERE id = ? SELECT * FROM blog WHERE id = 5;
0.22 ms (24.60%)	1	SELECT id, title FROM blog WHERE id < ? ORDER BY id DESC LIMIT 1 Parameters: [`5`] View formatted query View runnable query Explain query SELECT id, title FROM blog WHERE id < ? ORDER BY id DESC LIMIT 1 SELECT id, title FROM blog WHERE id < 5 ORDER BY id DESC LIMIT 1;
0.18 ms (20.84%)	1	SELECT id, title FROM blog WHERE id > ? ORDER BY id ASC LIMIT 1 Parameters: [`5`] View formatted query View runnable query Explain query SELECT id, title FROM blog WHERE id > ? ORDER BY id ASC LIMIT 1 SELECT id, title FROM blog WHERE id > 5 ORDER BY id ASC LIMIT 1;

Time▼

Count

Info

0.48 ms
(54.56%)

SELECT * FROM blog WHERE id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query

SELECT
  *
FROM
  blog
WHERE
  id = ?

SELECT * FROM blog WHERE id = 5;

0.22 ms
(24.60%)

SELECT id, title FROM blog WHERE id < ? ORDER BY id DESC LIMIT 1

Parameters:

[
  5
]

View formatted query View runnable query Explain query

SELECT
  id,
  title
FROM
  blog
WHERE
  id < ?
ORDER BY
  id DESC
LIMIT
  1

SELECT id, title FROM blog WHERE id < 5 ORDER BY id DESC LIMIT 1;

0.18 ms
(20.84%)

SELECT id, title FROM blog WHERE id > ? ORDER BY id ASC LIMIT 1

Parameters:

[
  5
]

View formatted query View runnable query Explain query

SELECT
  id,
  title
FROM
  blog
WHERE
  id > ?
ORDER BY
  id ASC
LIMIT
  1

SELECT id, title FROM blog WHERE id > 5 ORDER BY id ASC LIMIT 1;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.