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.Active as CustomerActive, c.Locked as CustomerLocked FROM BusinessPage bp INNER JOIN Customer c ON bp.CustomerID = c.ID WHERE (bp.Active = ?) AND (c.Active = ?) AND (c.Locked = ?) AND (bp.Products != ?) ORDER BY bp.Products ASC, bp.BusinessName ASC

[
  "Y"
  "Y"
  "N"
  ""
]

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

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