Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.name AS name_2, n0_.is_active AS is_active_3, n1_.id AS id_4, n1_.label AS label_5, n1_.icon AS icon_6, n1_.route_name AS route_name_7, n1_.route_params AS route_params_8, n1_.url AS url_9, n1_.open_in_new_tab AS open_in_new_tab_10, n1_.is_dropdown AS is_dropdown_11, n1_.is_visible AS is_visible_12, n1_.position AS position_13, n1_.required_roles AS required_roles_14, n2_.id AS id_15, n2_.label AS label_16, n2_.icon AS icon_17, n2_.route_name AS route_name_18, n2_.route_params AS route_params_19, n2_.url AS url_20, n2_.open_in_new_tab AS open_in_new_tab_21, n2_.is_dropdown AS is_dropdown_22, n2_.is_visible AS is_visible_23, n2_.position AS position_24, n2_.required_roles AS required_roles_25, n1_.menu_id AS menu_id_26, n1_.parent_id AS parent_id_27, n2_.menu_id AS menu_id_28, n2_.parent_id AS parent_id_29 FROM navigation_menu n0_ LEFT JOIN navigation_item n1_ ON n0_.id = n1_.menu_id LEFT JOIN navigation_item n2_ ON n1_.id = n2_.parent_id WHERE n0_.slug = ? AND n0_.is_active = 1 ORDER BY n1_.position ASC, n2_.position ASC

[
  "main"
]

SELECT
  n0_.id AS id_0,
  n0_.slug AS slug_1,
  n0_.name AS name_2,
  n0_.is_active AS is_active_3,
  n1_.id AS id_4,
  n1_.label AS label_5,
  n1_.icon AS icon_6,
  n1_.route_name AS route_name_7,
  n1_.route_params AS route_params_8,
  n1_.url AS url_9,
  n1_.open_in_new_tab AS open_in_new_tab_10,
  n1_.is_dropdown AS is_dropdown_11,
  n1_.is_visible AS is_visible_12,
  n1_.position AS position_13,
  n1_.required_roles AS required_roles_14,
  n2_.id AS id_15,
  n2_.label AS label_16,
  n2_.icon AS icon_17,
  n2_.route_name AS route_name_18,
  n2_.route_params AS route_params_19,
  n2_.url AS url_20,
  n2_.open_in_new_tab AS open_in_new_tab_21,
  n2_.is_dropdown AS is_dropdown_22,
  n2_.is_visible AS is_visible_23,
  n2_.position AS position_24,
  n2_.required_roles AS required_roles_25,
  n1_.menu_id AS menu_id_26,
  n1_.parent_id AS parent_id_27,
  n2_.menu_id AS menu_id_28,
  n2_.parent_id AS parent_id_29
FROM
  navigation_menu n0_
  LEFT JOIN navigation_item n1_ ON n0_.id = n1_.menu_id
  LEFT JOIN navigation_item n2_ ON n1_.id = n2_.parent_id
WHERE
  n0_.slug = ?
  AND n0_.is_active = 1
ORDER BY
  n1_.position ASC,
  n2_.position ASC

SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.name AS name_2, n0_.is_active AS is_active_3, n1_.id AS id_4, n1_.label AS label_5, n1_.icon AS icon_6, n1_.route_name AS route_name_7, n1_.route_params AS route_params_8, n1_.url AS url_9, n1_.open_in_new_tab AS open_in_new_tab_10, n1_.is_dropdown AS is_dropdown_11, n1_.is_visible AS is_visible_12, n1_.position AS position_13, n1_.required_roles AS required_roles_14, n2_.id AS id_15, n2_.label AS label_16, n2_.icon AS icon_17, n2_.route_name AS route_name_18, n2_.route_params AS route_params_19, n2_.url AS url_20, n2_.open_in_new_tab AS open_in_new_tab_21, n2_.is_dropdown AS is_dropdown_22, n2_.is_visible AS is_visible_23, n2_.position AS position_24, n2_.required_roles AS required_roles_25, n1_.menu_id AS menu_id_26, n1_.parent_id AS parent_id_27, n2_.menu_id AS menu_id_28, n2_.parent_id AS parent_id_29 FROM navigation_menu n0_ LEFT JOIN navigation_item n1_ ON n0_.id = n1_.menu_id LEFT JOIN navigation_item n2_ ON n1_.id = n2_.parent_id WHERE n0_.slug = 'main' AND n0_.is_active = 1 ORDER BY n1_.position ASC, n2_.position ASC;