Symfony Profiler

• Request / Response
• Performance
• Validator
• Exception
• Logs 4
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• Doctrine
• Messages
• Serializer
• Configuration

Query Metrics

SELECT t0.id AS id_1, t0.code AS code_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5 FROM user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.full_name AS full_name_5
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5 FROM user t0 WHERE t0.id = 1;

SELECT
                IFNULL(plate_number, BIN_TO_UUID(uuid)) AS plateNumber,
                COUNT(*) AS qty,
                GROUP_CONCAT(service_number) AS serviceNumbers,
                GROUP_CONCAT(number) AS deliveryNumbers,
                GROUP_CONCAT(order_number) AS orderNumbers
            FROM delivery
            GROUP BY plateNumber

[]

SELECT
  IFNULL(
    plate_number,
    BIN_TO_UUID(uuid)
  ) AS plateNumber,
  COUNT(*) AS qty,
  GROUP_CONCAT(service_number) AS serviceNumbers,
  GROUP_CONCAT(number) AS deliveryNumbers,
  GROUP_CONCAT(order_number) AS orderNumbers
FROM
  delivery
GROUP BY
  plateNumber

SELECT
                IFNULL(plate_number, BIN_TO_UUID(uuid)) AS plateNumber,
                COUNT(*) AS qty,
                GROUP_CONCAT(service_number) AS serviceNumbers,
                GROUP_CONCAT(number) AS deliveryNumbers,
                GROUP_CONCAT(order_number) AS orderNumbers
            FROM delivery
            GROUP BY plateNumber
            
            ;