Query Metrics
6
Database Queries
6
Different statements
2.88 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM tag t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
"graphisme"
]
|
||||||||||||||||||||||||||||||||
| 2 | 0.57 ms |
SELECT DISTINCT p0_.id AS id_0, p0_.published_at AS published_at_1 FROM post p0_ INNER JOIN user u1_ ON p0_.author_id = u1_.id LEFT JOIN post_tag p3_ ON p0_.id = p3_.post_id LEFT JOIN tag t2_ ON t2_.id = p3_.tag_id WHERE p0_.published_at <= ? AND EXISTS (SELECT 1 FROM post_tag p4_ WHERE p4_.post_id = p0_.id AND p4_.tag_id IN (?)) ORDER BY p0_.published_at DESC LIMIT 10
Parameters:
[ "2025-12-06 08:15:14" 1 ]
|
||||||||||||||||||||||||||||||||
| 3 | 0.92 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.summary AS summary_3, p0_.content AS content_4, p0_.published_at AS published_at_5, p0_.image_file_name AS image_file_name_6, u1_.id AS id_7, u1_.full_name AS full_name_8, u1_.username AS username_9, u1_.email AS email_10, u1_.password AS password_11, u1_.roles AS roles_12, u1_.is_verified AS is_verified_13, u1_.image_file_name AS image_file_name_14, u1_.updated_at AS updated_at_15, t2_.id AS id_16, t2_.name AS name_17, p0_.author_id AS author_id_18 FROM post p0_ INNER JOIN user u1_ ON p0_.author_id = u1_.id LEFT JOIN post_tag p3_ ON p0_.id = p3_.post_id LEFT JOIN tag t2_ ON t2_.id = p3_.tag_id WHERE p0_.published_at <= ? AND EXISTS (SELECT 1 FROM post_tag p4_ WHERE p4_.post_id = p0_.id AND p4_.tag_id IN (?)) AND p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY p0_.published_at DESC, t2_.name ASC
Parameters:
[ "2025-12-06 08:15:14" 1 1 2 3 4 14 15 21 22 25 27 ]
|
||||||||||||||||||||||||||||||||
| 4 | 0.47 ms |
SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM post p0_ INNER JOIN user u1_ ON p0_.author_id = u1_.id LEFT JOIN post_tag p3_ ON p0_.id = p3_.post_id LEFT JOIN tag t2_ ON t2_.id = p3_.tag_id WHERE p0_.published_at <= ? AND EXISTS (SELECT 1 FROM post_tag p4_ WHERE p4_.post_id = p0_.id AND p4_.tag_id IN (?))
Parameters:
[ "2025-12-06 08:15:14" 1 ]
|
||||||||||||||||||||||||||||||||
| 5 | 0.25 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.sub_title AS sub_title_3, t0.image_file_name AS image_file_name_4, t0.title_job AS title_job_5, t0.title_team AS title_team_6, t0.sub_title_team AS sub_title_team_7, t0.title_value AS title_value_8, t0.sub_title_value AS sub_title_value_9, t0.video_value AS video_value_10, t0.image_value_name AS image_value_name_11, t0.updated_at AS updated_at_12, t0.phone AS phone_13, t0.email AS email_14, t0.adresse AS adresse_15 FROM about t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
| 6 | 0.28 ms |
SELECT t0.id AS id_1, t0.logo_file_name AS logo_file_name_2, t0.whatsapp_file_name AS whatsapp_file_name_3, t0.whatsapp_url AS whatsapp_url_4, t0.whatsapp_number AS whatsapp_number_5, t0.mail_file_name AS mail_file_name_6, t0.mail_text AS mail_text_7, t0.updated_at AS updated_at_8 FROM parameter t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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. |
| App\Entity\Comment | No errors. |
| App\Entity\About | No errors. |
| App\Entity\Parameter | No errors. |