Symfony Profiler

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

Query Metrics

SELECT GROUP_CONCAT(u0_.user_group SEPARATOR ',') AS sclr_0, n1_.navigation_id AS navigation_id_1, n1_.position AS position_2, n1_.section AS section_3, n1_.seperator AS seperator_4, n1_.name AS name_5, n1_.icon AS icon_6, n1_.color AS color_7, n1_.date_ins AS date_ins_8, n1_.date_upd AS date_upd_9, r2_.route_id AS route_id_10, r2_.name AS name_11, r2_.path AS path_12, r2_.is_ajax AS is_ajax_13, r2_.is_param AS is_param_14, r2_.is_index AS is_index_15, r2_.is_generated AS is_generated_16, n1_.parent_id AS parent_id_17, n1_.route_id AS route_id_18 FROM navigation n1_ LEFT JOIN routes r2_ ON n1_.route_id = r2_.route_id LEFT JOIN user_group_navigation u3_ ON n1_.navigation_id = u3_.navigation_id LEFT JOIN user_group u0_ ON u0_.user_group_id = u3_.user_group_id GROUP BY n1_.navigation_id ORDER BY n1_.position ASC

[]

SELECT
  GROUP_CONCAT(u0_.user_group SEPARATOR ',') AS sclr_0,
  n1_.navigation_id AS navigation_id_1,
  n1_.position AS position_2,
  n1_.section AS section_3,
  n1_.seperator AS seperator_4,
  n1_.name AS name_5,
  n1_.icon AS icon_6,
  n1_.color AS color_7,
  n1_.date_ins AS date_ins_8,
  n1_.date_upd AS date_upd_9,
  r2_.route_id AS route_id_10,
  r2_.name AS name_11,
  r2_.path AS path_12,
  r2_.is_ajax AS is_ajax_13,
  r2_.is_param AS is_param_14,
  r2_.is_index AS is_index_15,
  r2_.is_generated AS is_generated_16,
  n1_.parent_id AS parent_id_17,
  n1_.route_id AS route_id_18
FROM
  navigation n1_
  LEFT JOIN routes r2_ ON n1_.route_id = r2_.route_id
  LEFT JOIN user_group_navigation u3_ ON n1_.navigation_id = u3_.navigation_id
  LEFT JOIN user_group u0_ ON u0_.user_group_id = u3_.user_group_id
GROUP BY
  n1_.navigation_id
ORDER BY
  n1_.position ASC

SELECT GROUP_CONCAT(u0_.user_group SEPARATOR ',') AS sclr_0, n1_.navigation_id AS navigation_id_1, n1_.position AS position_2, n1_.section AS section_3, n1_.seperator AS seperator_4, n1_.name AS name_5, n1_.icon AS icon_6, n1_.color AS color_7, n1_.date_ins AS date_ins_8, n1_.date_upd AS date_upd_9, r2_.route_id AS route_id_10, r2_.name AS name_11, r2_.path AS path_12, r2_.is_ajax AS is_ajax_13, r2_.is_param AS is_param_14, r2_.is_index AS is_index_15, r2_.is_generated AS is_generated_16, n1_.parent_id AS parent_id_17, n1_.route_id AS route_id_18 FROM navigation n1_ LEFT JOIN routes r2_ ON n1_.route_id = r2_.route_id LEFT JOIN user_group_navigation u3_ ON n1_.navigation_id = u3_.navigation_id LEFT JOIN user_group u0_ ON u0_.user_group_id = u3_.user_group_id GROUP BY n1_.navigation_id ORDER BY n1_.position ASC;