Query Metrics
25
Database Queries
5
Different statements
143.74 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.47 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 | 67.98 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 05:01:17" ] |
| 3 | 10.67 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 | 7.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:
[
5001
]
|
| 5 | 2.97 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:
[
4988
]
|
| 6 | 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:
[
4984
]
|
| 7 | 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:
[
4978
]
|
| 8 | 4.88 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:
[
4955
]
|
| 9 | 6.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:
[
4968
]
|
| 10 | 3.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:
[
4960
]
|
| 11 | 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:
[
4936
]
|
| 12 | 0.32 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:
[
4913
]
|
| 13 | 2.64 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:
[
4920
]
|
| 14 | 0.56 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:
[
4909
]
|
| 15 | 7.99 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:
[
4901
]
|
| 16 | 1.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:
[
4896
]
|
| 17 | 7.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:
[
4893
]
|
| 18 | 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:
[
4883
]
|
| 19 | 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:
[
4750
]
|
| 20 | 3.38 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:
[
4877
]
|
| 21 | 0.38 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:
[
4870
]
|
| 22 | 8.91 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:
[
4861
]
|
| 23 | 2.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:
[
4858
]
|
| 24 | 0.29 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.14 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. |