GET https://business-n2a.myn2a.online/menu/fonctionnement-particulier

Query Metrics

6 Database Queries
2 Different statements
2.32 ms Query time
0 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 1.10 ms
SELECT m0_.id AS id_0, m0_.label AS label_1, m0_.route AS route_2, m0_.url AS url_3, m0_.icon AS icon_4, m0_.enabled AS enabled_5, m0_.position AS position_6, m0_.blank AS blank_7, m0_.parent_id AS parent_id_8 FROM menu m0_ LEFT JOIN menu_role m2_ ON m0_.id = m2_.menu_id LEFT JOIN role r1_ ON r1_.code = m2_.role_code WHERE m0_.parent_id IS NULL AND m0_.enabled = 1 AND r1_.code IN (?) ORDER BY m0_.position ASC
Parameters:
[
  "ROLE_VISITEUR"
]
2 0.34 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  9
]
3 0.24 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  15
]
4 0.22 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  10
]
5 0.21 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  11
]
6 0.22 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.route AS route_3, t0.url AS url_4, t0.icon AS icon_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.blank AS blank_8, t0.parent_id AS parent_id_9 FROM menu t0 WHERE t0.parent_id = ?
Parameters:
[
  12
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Menu 7

Entities Mapping

Class Mapping errors
App\Entity\Menu No errors.
App\Entity\Role No errors.