Query Metrics
3
Database Queries
3
Different statements
6.39 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
2.74 ms (42.96%) |
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, u1_.full_name AS full_name_6, u1_.username AS username_7, u1_.telegram AS telegram_8, u1_.roles AS roles_9, u1_.name AS name_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.email AS email_13, u1_.email_verified_at AS email_verified_at_14, u1_.language AS language_15, u1_.password AS password_16, u1_.guid AS guid_17, u1_.is_verified AS is_verified_18, u1_.id AS id_19, u1_.date_created AS date_created_20, u1_.date_updated AS date_updated_21, s2_.id AS id_22, s2_.name AS name_23, s0_.author_id AS author_id_24, u1_.telegram_user_id AS telegram_user_id_25 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.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:
[ "2025-12-22 16:28:45" 91 92 93 94 95 96 97 98 99 100 ]
|
||||||||||||||||||||||||||||||||
|
2.12 ms (33.23%) |
1 |
SELECT DISTINCT s0_.id AS id_0, s0_.published_at AS published_at_1 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.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:
[
"2025-12-22 16:28:45"
]
|
||||||||||||||||||||||||||||||||
|
1.52 ms (23.81%) |
1 |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM symfony_demo_post s0_ INNER JOIN user u1_ ON s0_.author_id = u1_.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:
[
"2025-12-22 16:28:45"
]
|
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\Telegram\TelegramUser | No errors. |
| App\Entity\Comment | No errors. |
| App\Entity\Rental |
|
| App\Entity\eVisitor\EVisitorObject |
|
| App\Entity\Country | No errors. |