Query Metrics

4 Database Queries
3 Different statements
5.09 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.91 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:
[
  "default_page_suffix"
]
2 1.22 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
  "valid"
]
3 1.21 ms
SELECT COUNT(p0_.id) AS sclr_0 FROM Prestataire p0_ WHERE p0_.status = ?
Parameters:
[
  "valid"
]
4 1.75 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\Option No errors.
App\Entity\Prestataire No errors.
App\Entity\Page No errors.
App\Entity\Url No errors.
App\Entity\Categorie No errors.