Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.email AS email_2, t0.nombre AS nombre_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6 FROM app_user t0 WHERE t0.id = ?

[
  1
]

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.nombre AS nombre_3,
  t0.password AS password_4,
  t0.created_at AS created_at_5,
  t0.deleted_at AS deleted_at_6
FROM
  app_user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.nombre AS nombre_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.deleted_at AS deleted_at_6 FROM app_user t0 WHERE t0.id = 1;

SELECT s.id, w.name AS workerName, s.year, s.quarter_number AS quarterNumber FROM worker_schedule s INNER JOIN worker w ON w.id = s.worker_id WHERE w.deleted_at IS NULL ORDER BY s.year DESC, s.quarter_number DESC, w.name ASC, w.id ASC, s.id ASC LIMIT 20 OFFSET 0

[]

SELECT
  s.id,
  w.name AS workerName,
  s.year,
  s.quarter_number AS quarterNumber
FROM
  worker_schedule s
  INNER JOIN worker w ON w.id = s.worker_id
WHERE
  w.deleted_at IS NULL
ORDER BY
  s.year DESC,
  s.quarter_number DESC,
  w.name ASC,
  w.id ASC,
  s.id ASC
LIMIT
  20
OFFSET
  0

SELECT s.id, w.name AS workerName, s.year, s.quarter_number AS quarterNumber FROM worker_schedule s INNER JOIN worker w ON w.id = s.worker_id WHERE w.deleted_at IS NULL ORDER BY s.year DESC, s.quarter_number DESC, w.name ASC, w.id ASC, s.id ASC LIMIT 20 OFFSET 0;

SELECT COUNT(*) FROM worker_schedule s INNER JOIN worker w ON w.id = s.worker_id WHERE w.deleted_at IS NULL

[]

SELECT
  COUNT(*)
FROM
  worker_schedule s
  INNER JOIN worker w ON w.id = s.worker_id
WHERE
  w.deleted_at IS NULL

SELECT COUNT(*) FROM worker_schedule s INNER JOIN worker w ON w.id = s.worker_id WHERE w.deleted_at IS NULL;