Query Metrics

3 Database Queries
3 Different statements
7.08 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.26 ms
(60.13%)
1
SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?)) ORDER BY s0_.published_at DESC LIMIT 10
Parameters:
[
  "2024-12-03 18:35:49"
  8
]
2.08 ms
(29.44%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Bizarre"
]
0.74 ms
(10.43%)
1
SELECT COUNT(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN symfony_demo_user s1_ ON s0_.author_id = s1_.id LEFT JOIN symfony_demo_post_tag s3_ ON s0_.id = s3_.post_id LEFT JOIN symfony_demo_tag s2_ ON s2_.id = s3_.tag_id WHERE s0_.published_at <= ? AND EXISTS (SELECT 1 FROM symfony_demo_post_tag s4_ WHERE s4_.post_id = s0_.id AND s4_.tag_id IN (?))
Parameters:
[
  "2024-12-03 18:35:49"
  8
]

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\Tag No errors.
App\Entity\Post No errors.
App\Entity\User No errors.