Query Metrics

4 Database Queries
4 Different statements
5.38 ms Query time
0 Invalid entities

Show all queries

Timeâ–¼ Count Info
2.48 ms
(46.11%)
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:
0 of 0
[â–¼ "2025-03-14 18:08:12" 2 ]
1.27 ms
(23.65%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM symfony_demo_tag t0 WHERE t0.name = ? LIMIT 1
Parameters:
0 of 0
[â–¼ "ipsum" ]
0.94 ms
(17.55%)
1
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, s1_.id AS id_6, s1_.full_name AS full_name_7, s1_.username AS username_8, s1_.email AS email_9, s1_.password AS password_10, s1_.roles AS roles_11, s2_.id AS id_12, s2_.name AS name_13, s0_.author_id AS author_id_14 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 (?)) AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.published_at DESC, s2_.name ASC
Parameters:
0 of 0
[â–¼ "2025-03-14 18:08:12" 2 2 4 8 16 19 22 25 28 ]
0.68 ms
(12.68%)
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:
0 of 0
[â–¼ "2025-03-14 18:08:12" 2 ]