Query Metrics
7
Database Queries
5
Different statements
10.29 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.37 ms |
SELECT t0.id AS id_1, t0.url AS url_2, t0.redirect_on AS redirect_on_3, t4.id AS id_5, t4.type AS type_6, t4.creation_date AS creation_date_7, t4.modified_date AS modified_date_8, t4.title AS title_9, t4.menu_label AS menu_label_10, t4.page_title AS page_title_11, t4.page_description AS page_description_12, t4.bandeau_text_1 AS bandeau_text_1_13, t4.bandeau_text_2 AS bandeau_text_2_14, t4.bandeau_text_3 AS bandeau_text_3_15, t4.content AS content_16, t4.page_order AS page_order_17, t4.robots AS robots_18, t4.parent_id AS parent_id_19, t4.url_id AS url_id_20 FROM Url t0 LEFT JOIN Page t4 ON t4.url_id = t0.id WHERE t0.url = ? LIMIT 1
Parameters:
[
"solution-energetique.html"
]
|
| 2 | 1.88 ms |
SELECT p0_.id AS id_0, p0_.parent_id AS sclr_1, p0_.menu_label AS menu_label_2, c1_.description AS description_3, u2_.url AS url_4, c1_.id AS id_5 FROM Page p0_ INNER JOIN Url u2_ ON p0_.url_id = u2_.id LEFT JOIN Categorie c1_ ON (c1_.page_id = p0_.id) WHERE p0_.type = ? ORDER BY p0_.parent_id ASC, p0_.page_order ASC
Parameters:
[
"categorie"
]
|
| 3 | 0.47 ms |
SELECT c0_.id AS id_0 FROM Categorie c0_ WHERE c0_.page_id = ?
Parameters:
[
178
]
|
| 4 | 3.34 ms |
SELECT t0.id AS id_1, t0.option_key AS option_key_2, t0.option_value AS option_value_3 FROM `Option` t0 WHERE t0.option_key = ? LIMIT 1
Parameters:
[
"category_page_suffix"
]
|
| 5 | 1.01 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
"valid"
]
|
| 6 | 0.92 ms |
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
"valid"
]
|
| 7 | 1.30 ms |
SELECT p0_.id AS id_0, p0_.parent_id AS sclr_1, p0_.menu_label AS menu_label_2, c1_.description AS description_3, u2_.url AS url_4, c1_.id AS id_5 FROM Page p0_ INNER JOIN Url u2_ ON p0_.url_id = u2_.id LEFT JOIN Categorie c1_ ON (c1_.page_id = p0_.id) WHERE p0_.type = ? ORDER BY p0_.parent_id ASC, p0_.page_order ASC
Parameters:
[
"categorie"
]
|
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\Url | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\PageMeta | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Option | No errors. |
| App\Entity\Prestataire | No errors. |