Query Metrics

7 Database Queries
6 Different statements
8.54 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.43 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.summary AS summary_4, t0.content AS content_5, t0.published_at AS published_at_6, t0.author_id AS author_id_7 FROM symfony_demo_post t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "teres-talis-saepe-tractare-de-camerarius-flavum-sensorem"
]
2 1.10 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6 FROM symfony_demo_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
3 1.26 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 INNER JOIN symfony_demo_post_tag ON t0.id = symfony_demo_post_tag.tag_id WHERE symfony_demo_post_tag.post_id = ? ORDER BY t0.name ASC
Parameters:
[
  22
]
4 1.13 ms
SELECT t0.id AS id_1, t0.content AS content_2, t0.published_at AS published_at_3, t0.post_id AS post_id_4, t0.author_id AS author_id_5 FROM symfony_demo_comment t0 WHERE t0.post_id = ? ORDER BY t0.published_at DESC
Parameters:
[
  22
]
5 0.94 ms
SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6 FROM symfony_demo_user t0 WHERE t0.id = ?
Parameters:
[
  3
]
6 1.83 ms
SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'
Parameters:
[]
7 0.86 ms
SELECT DATABASE()
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Post No errors.
App\Entity\User No errors.
App\Entity\Comment No errors.
App\Entity\Tag No errors.