Query Metrics

7 Database Queries
5 Different statements
7.42 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.58 ms
(34.80%)
2
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"
]
2.12 ms
(28.53%)
2
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
  "valid"
]
1.85 ms
(24.86%)
1
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:
[
  "politique-de-confidentialite.html"
]
0.50 ms
(6.79%)
1
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:
[
  "default_page_suffix"
]
0.37 ms
(5.02%)
1
SELECT c0_.id AS id_0 FROM Categorie c0_ WHERE c0_.page_id = ?
Parameters:
[
  204
]

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.