Symfony Profiler

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

Query Metrics

SELECT child.id, child.slug, child.lft, child.rgt, cn.name, cm.meta_key, cm.meta_value
                FROM category anc 
                LEFT OUTER JOIN category child
                    ON child.lft > anc.lft AND child.lft < anc.rgt 
                LEFT JOIN category_name cn on child.id = cn.category_id 
                LEFT JOIN (
                    SELECT category_id, GROUP_CONCAT(meta_key) as meta_key, GROUP_CONCAT(meta_value) as meta_value 
                    FROM category_meta
                    GROUP BY category_id
                ) cm on child.id = cm.category_id
                WHERE anc.slug = :slug 
                  AND cn.locale_id = 1

[
  "slug" => "kb_blog"
]

SELECT
  child.id,
  child.slug,
  child.lft,
  child.rgt,
  cn.name,
  cm.meta_key,
  cm.meta_value
FROM
  category anc
  LEFT OUTER JOIN category child ON child.lft > anc.lft
  AND child.lft < anc.rgt
  LEFT JOIN category_name cn on child.id = cn.category_id
  LEFT JOIN (
    SELECT
      category_id,
      GROUP_CONCAT(meta_key) as meta_key,
      GROUP_CONCAT(meta_value) as meta_value
    FROM
      category_meta
    GROUP BY
      category_id
  ) cm on child.id = cm.category_id
WHERE
  anc.slug = :slug
  AND cn.locale_id = 1

SELECT child.id, child.slug, child.lft, child.rgt, cn.name, cm.meta_key, cm.meta_value
                FROM category anc 
                LEFT OUTER JOIN category child
                    ON child.lft > anc.lft AND child.lft < anc.rgt 
                LEFT JOIN category_name cn on child.id = cn.category_id 
                LEFT JOIN (
                    SELECT category_id, GROUP_CONCAT(meta_key) as meta_key, GROUP_CONCAT(meta_value) as meta_value 
                    FROM category_meta
                    GROUP BY category_id
                ) cm on child.id = cm.category_id
                WHERE anc.slug = 'kb_blog' 
                  AND cn.locale_id = 1 ;