Query Metrics
25
Database Queries
5
Different statements
37.52 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.41 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 | 23.12 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" "2026-07-15 00:20:18" ] |
| 3 | 0.49 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 | 0.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:
[
4490
]
|
| 5 | 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:
[
4472
]
|
| 6 | 0.23 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:
[
4460
]
|
| 7 | 0.35 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:
[
4455
]
|
| 8 | 0.67 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:
[
4437
]
|
| 9 | 0.61 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:
[
4441
]
|
| 10 | 0.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:
[
4425
]
|
| 11 | 0.78 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:
[
4398
]
|
| 12 | 0.69 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:
[
4414
]
|
| 13 | 0.42 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:
[
4409
]
|
| 14 | 0.26 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:
[
4396
]
|
| 15 | 0.93 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:
[
4383
]
|
| 16 | 1.04 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:
[
4380
]
|
| 17 | 0.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:
[
4323
]
|
| 18 | 1.00 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:
[
4229
]
|
| 19 | 0.47 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:
[
4017
]
|
| 20 | 0.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:
[
4340
]
|
| 21 | 0.76 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:
[
4348
]
|
| 22 | 0.50 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:
[
4347
]
|
| 23 | 0.89 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:
[
4338
]
|
| 24 | 0.55 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.35 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. |