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 (bp.Areas != ?) AND (c.Active = ?) AND (c.Locked = ?) ORDER BY bp.Areas 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 (bp.Areas != ?)
  AND (c.Active = ?)
  AND (c.Locked = ?)
ORDER BY
  bp.Areas 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 (bp.Areas != '') AND (c.Active = 'Y') AND (c.Locked = 'N') ORDER BY bp.Areas ASC, bp.BusinessName ASC;