Symfony Profiler

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

Query Metrics

SELECT bp.*, c.Name, c.Surname, c.ParentID, c.Active as CustomerActive, c.Locked as CustomerLocked FROM BusinessPage bp INNER JOIN Customer c ON bp.CustomerID = c.ParentID WHERE (bp.Active = ?) AND (c.Active = ?) AND (c.Locked = ?) ORDER BY c. Surname ASC, bp.BusinessName ASC

[
  "Y"
  "Y"
  "N"
]

SELECT
  bp.*,
  c.Name,
  c.Surname,
  c.ParentID,
  c.Active as CustomerActive,
  c.Locked as CustomerLocked
FROM
  BusinessPage bp
  INNER JOIN Customer c ON bp.CustomerID = c.ParentID
WHERE
  (bp.Active = ?)
  AND (c.Active = ?)
  AND (c.Locked = ?)
ORDER BY
  c.Surname ASC,
  bp.BusinessName ASC

SELECT bp.*, c.Name, c.Surname, c.ParentID, c.Active as CustomerActive, c.Locked as CustomerLocked FROM BusinessPage bp INNER JOIN Customer c ON bp.CustomerID = c.ParentID WHERE (bp.Active = 'Y') AND (c.Active = 'Y') AND (c.Locked = 'N') ORDER BY c. Surname ASC, bp.BusinessName ASC;