Query Metrics
25
Database Queries
5
Different statements
287.77 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.36 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3 FROM blog_kind t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"testy-aut"
]
|
| 2 | 164.27 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.description AS description_3, b0_.text AS text_4, b0_.keyword AS keyword_5, b0_.text_source AS text_source_6, b0_.visible AS visible_7, b0_.visible_homepage AS visible_homepage_8, b0_.create_at AS create_at_9, b0_.import_id AS import_id_10, b0_.top AS top_11, b0_.redirect AS redirect_12, b0_.main_kind_id AS main_kind_id_13, b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14, b0_.vehicle_model_id AS vehicle_model_id_15 FROM blog b0_ LEFT JOIN blog_blog_kind b2_ ON b0_.id = b2_.blog_id LEFT JOIN blog_kind b1_ ON b1_.id = b2_.blog_kind_id WHERE b1_.url = ? AND b0_.visible = 1 AND b0_.create_at <= ? ORDER BY b0_.create_at DESC
Parameters:
[ "testy-aut" "2025-12-16 13:10:14" ] |
| 3 | 9.79 ms |
SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.url AS url_2 FROM vehicle_manufacturer v0_ LEFT JOIN blog b1_ ON v0_.id = b1_.vehicle_manufacturer_id LEFT JOIN blog_blog_kind b3_ ON b1_.id = b3_.blog_id LEFT JOIN blog_kind b2_ ON b2_.id = b3_.blog_kind_id WHERE b2_.id = ? AND b1_.visible = 1 ORDER BY v0_.name ASC
Parameters:
[
2
]
|
| 4 | 10.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4328
]
|
| 5 | 1.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4311
]
|
| 6 | 13.98 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4327
]
|
| 7 | 5.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4320
]
|
| 8 | 13.10 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4318
]
|
| 9 | 7.13 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4314
]
|
| 10 | 1.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4267
]
|
| 11 | 5.30 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4304
]
|
| 12 | 1.29 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4297
]
|
| 13 | 0.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4292
]
|
| 14 | 0.52 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4281
]
|
| 15 | 6.09 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4282
]
|
| 16 | 3.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4280
]
|
| 17 | 4.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4279
]
|
| 18 | 0.95 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4212
]
|
| 19 | 3.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4271
]
|
| 20 | 4.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4253
]
|
| 21 | 5.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4262
]
|
| 22 | 1.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4217
]
|
| 23 | 6.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4243
]
|
| 24 | 15.26 ms |
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.url AS url_2, b0_.description AS description_3, b0_.text AS text_4, b0_.keyword AS keyword_5, b0_.text_source AS text_source_6, b0_.visible AS visible_7, b0_.visible_homepage AS visible_homepage_8, b0_.create_at AS create_at_9, b0_.import_id AS import_id_10, b0_.top AS top_11, b0_.redirect AS redirect_12, b0_.main_kind_id AS main_kind_id_13, b0_.vehicle_manufacturer_id AS vehicle_manufacturer_id_14, b0_.vehicle_model_id AS vehicle_model_id_15 FROM blog b0_ WHERE b0_.visible <> 0 AND b0_.top = 1 ORDER BY b0_.create_at DESC
Parameters:
[] |
| 25 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.main AS main_3, t0.blog_id AS blog_id_4 FROM blog_image t0 WHERE t0.blog_id = ? ORDER BY t0.main DESC, t0.id ASC
Parameters:
[
4981
]
|
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\BlogKind | No errors. |
| App\Entity\Blog | No errors. |
| App\Entity\VehicleManufacturer | No errors. |
| App\Entity\VehicleModel | No errors. |
| App\Entity\BlogImage | No errors. |
| App\Entity\Vehicle | No errors. |