Symfony Profiler

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

Query Metrics

SELECT m0_.id AS id_0, m0_.page_id AS page_id_1, m0_.menu_group AS menu_group_2, m0_.is_popup AS is_popup_3, m0_.path AS path_4, m0_.level AS level_5, m0_.clone_parent_menu_id AS clone_parent_menu_id_6, m0_.is_internal AS is_internal_7, m0_.is_concated AS is_concated_8, m0_.is_archive AS is_archive_9, m0_.special_attribute AS special_attribute_10, m0_.is_editable AS is_editable_11, m0_.clone_parent_menu_id AS clone_parent_menu_id_12, m0_.page_id AS page_id_13 FROM menu m0_ INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id WHERE m1_.is_active = 1 AND ((m1_.concated_slug <> ? AND (LOCATE(m1_.concated_slug, ?) = 1 OR LOCATE(m1_.concated_slug_archive, ?) = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug), ?) = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug_archive), ?) = 1)) OR (m1_.url <> ? AND (m1_.url = ? OR m1_.url = ?))) AND m0_.menu_group = ? ORDER BY m1_.concated_slug DESC LIMIT 1

[
  ""
  "penzugyeim"
  "penzugyeim"
  "penzugyeim"
  "penzugyeim"
  ""
  "penzugyeim"
  "/penzugyeim"
  "fo_menu"
]

SELECT
  m0_.id AS id_0,
  m0_.page_id AS page_id_1,
  m0_.menu_group AS menu_group_2,
  m0_.is_popup AS is_popup_3,
  m0_.path AS path_4,
  m0_.level AS level_5,
  m0_.clone_parent_menu_id AS clone_parent_menu_id_6,
  m0_.is_internal AS is_internal_7,
  m0_.is_concated AS is_concated_8,
  m0_.is_archive AS is_archive_9,
  m0_.special_attribute AS special_attribute_10,
  m0_.is_editable AS is_editable_11,
  m0_.clone_parent_menu_id AS clone_parent_menu_id_12,
  m0_.page_id AS page_id_13
FROM
  menu m0_
  INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id
WHERE
  m1_.is_active = 1
  AND (
    (
      m1_.concated_slug <> ?
      AND (
        LOCATE(m1_.concated_slug, ?) = 1
        OR LOCATE(m1_.concated_slug_archive, ?) = 1
        OR LOCATE(
          CONCAT(m1_.lang, '/', m1_.concated_slug),
          ?
        ) = 1
        OR LOCATE(
          CONCAT(
            m1_.lang, '/', m1_.concated_slug_archive
          ),
          ?
        ) = 1
      )
    )
    OR (
      m1_.url <> ?
      AND (
        m1_.url = ?
        OR m1_.url = ?
      )
    )
  )
  AND m0_.menu_group = ?
ORDER BY
  m1_.concated_slug DESC
LIMIT
  1

SELECT m0_.id AS id_0, m0_.page_id AS page_id_1, m0_.menu_group AS menu_group_2, m0_.is_popup AS is_popup_3, m0_.path AS path_4, m0_.level AS level_5, m0_.clone_parent_menu_id AS clone_parent_menu_id_6, m0_.is_internal AS is_internal_7, m0_.is_concated AS is_concated_8, m0_.is_archive AS is_archive_9, m0_.special_attribute AS special_attribute_10, m0_.is_editable AS is_editable_11, m0_.clone_parent_menu_id AS clone_parent_menu_id_12, m0_.page_id AS page_id_13 FROM menu m0_ INNER JOIN menu_translation m1_ ON m0_.id = m1_.menu_id WHERE m1_.is_active = 1 AND ((m1_.concated_slug <> '' AND (LOCATE(m1_.concated_slug, 'penzugyeim') = 1 OR LOCATE(m1_.concated_slug_archive, 'penzugyeim') = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug), 'penzugyeim') = 1 OR LOCATE(CONCAT(m1_.lang, '/', m1_.concated_slug_archive), 'penzugyeim') = 1)) OR (m1_.url <> '' AND (m1_.url = 'penzugyeim' OR m1_.url = '/penzugyeim'))) AND m0_.menu_group = 'fo_menu' ORDER BY m1_.concated_slug DESC LIMIT 1;

SELECT m.id AS id0, m.page_id AS page_id13, m.menu_group AS menu_group2, m.is_popup AS is_popup3, m.path AS path4, m.level AS level5, m.clone_parent_menu_id AS clone_parent_menu_id12, m.is_internal AS is_internal7, m.is_concated AS is_concated8, m.is_archive AS is_archive9, m.special_attribute AS special_attribute10, m.is_editable AS is_editable11, t.id AS id, t.lang AS lang, t.is_language_active AS is_language_active, t.is_active AS is_active, t.name AS name, t.slug AS slug, t.concated_slug AS concated_slug, t.concated_slug_archive AS concated_slug_archive, t.is_slug_visible AS is_slug_visible, t.url AS url, t.visibility AS visibility, t.dynamic_route_generator AS dynamic_route_generator, t.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator, t.menu_id AS menu_id,t.menu_id mid  FROM (SELECT * FROM menu WHERE menu_group="fo_menu" AND level<=999 ORDER BY path ASC) m JOIN menu_translation t ON (m.id=t.menu_id) 
              WHERE t.lang = "hu" AND t.is_active = 1 AND t.visibility IN (0, 1)

[]

SELECT
  m.id AS id0,
  m.page_id AS page_id13,
  m.menu_group AS menu_group2,
  m.is_popup AS is_popup3,
  m.path AS path4,
  m.level AS level5,
  m.clone_parent_menu_id AS clone_parent_menu_id12,
  m.is_internal AS is_internal7,
  m.is_concated AS is_concated8,
  m.is_archive AS is_archive9,
  m.special_attribute AS special_attribute10,
  m.is_editable AS is_editable11,
  t.id AS id,
  t.lang AS lang,
  t.is_language_active AS is_language_active,
  t.is_active AS is_active,
  t.name AS name,
  t.slug AS slug,
  t.concated_slug AS concated_slug,
  t.concated_slug_archive AS concated_slug_archive,
  t.is_slug_visible AS is_slug_visible,
  t.url AS url,
  t.visibility AS visibility,
  t.dynamic_route_generator AS dynamic_route_generator,
  t.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator,
  t.menu_id AS menu_id,
  t.menu_id mid
FROM
  (
    SELECT
      *
    FROM
      menu
    WHERE
      menu_group = "fo_menu"
      AND level <= 999
    ORDER BY
      path ASC
  ) m
  JOIN menu_translation t ON (m.id = t.menu_id)
WHERE
  t.lang = "hu"
  AND t.is_active = 1
  AND t.visibility IN (0, 1)

SELECT m.id AS id0, m.page_id AS page_id13, m.menu_group AS menu_group2, m.is_popup AS is_popup3, m.path AS path4, m.level AS level5, m.clone_parent_menu_id AS clone_parent_menu_id12, m.is_internal AS is_internal7, m.is_concated AS is_concated8, m.is_archive AS is_archive9, m.special_attribute AS special_attribute10, m.is_editable AS is_editable11, t.id AS id, t.lang AS lang, t.is_language_active AS is_language_active, t.is_active AS is_active, t.name AS name, t.slug AS slug, t.concated_slug AS concated_slug, t.concated_slug_archive AS concated_slug_archive, t.is_slug_visible AS is_slug_visible, t.url AS url, t.visibility AS visibility, t.dynamic_route_generator AS dynamic_route_generator, t.is_automatic_dynamic_route_generator AS is_automatic_dynamic_route_generator, t.menu_id AS menu_id,t.menu_id mid  FROM (SELECT * FROM menu WHERE menu_group="fo_menu" AND level<=999 ORDER BY path ASC) m JOIN menu_translation t ON (m.id=t.menu_id) 
              WHERE t.lang = "hu" AND t.is_active = 1 AND t.visibility IN (0, 1);