Query Metrics
3
Database Queries
3
Different statements
6.85 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 4.91 ms |
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 <= ? ORDER BY s0_.published_at DESC LIMIT 10
Parameters:
[
"2024-12-22 16:31:00"
]
|
||||||||||||||||||||||||||||||||
2 | 1.10 ms |
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.slug AS slug_2, s0_.summary AS summary_3, s0_.content AS content_4, s0_.published_at AS published_at_5, s0_.filename AS filename_6, s1_.id AS id_7, s1_.full_name AS full_name_8, s1_.username AS username_9, s1_.email AS email_10, s1_.password AS password_11, s1_.roles AS roles_12, s2_.id AS id_13, s2_.name AS name_14, s0_.author_id AS author_id_15 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 s0_.id IN (?, ?) ORDER BY s0_.published_at DESC, s2_.name ASC
Parameters:
[ "2024-12-22 16:31:00" 35 34 ]
|
||||||||||||||||||||||||||||||||
3 | 0.84 ms |
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 <= ?
Parameters:
[
"2024-12-22 16:31:00"
]
|
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\Tag | No errors. |
App\Entity\Comment | No errors. |