Symfony Profiler

• Request / Response
• Performance
• Exception
• Logs 12
• Events
• Routing
• Cache
• Security
• Twig
• Doctrine
• JMS Serializer 0 + 0
• Configuration

Query Metrics

SELECT 
            MIN(c.fecha_embarque) AS fecha_inicio,
            MAX(c.fecha_desembarque) AS fecha_final,
            SEC_TO_TIME(SUM(TIMESTAMPDIFF(SECOND, fecha_embarque, fecha_desembarque))) AS tiempo_total,
            p.id AS id_pasajero,
            r.id AS id_ruta,
            t.id AS id_codigoRFID
        FROM control_acceso c
        JOIN tarjeta_rfid t ON c.tarjeta_rfid_id = t.id
        JOIN ruta r ON c.ruta_id = r.id
        JOIN pasajero p ON c.pasajero_id = p.id
        WHERE DATE(c.fecha_embarque) = DATE(c.fecha_desembarque)
        AND c.fecha_embarque BETWEEN :fechaInicio AND :fechaFinal
        GROUP BY DATE(c.fecha_embarque), p.id, r.id, t.id

[
  "fechaInicio" => "2026-03-01"
  "fechaFinal" => "2026-03-01"
]

SELECT
  MIN(c.fecha_embarque) AS fecha_inicio,
  MAX(c.fecha_desembarque) AS fecha_final,
  SEC_TO_TIME(
    SUM(
      TIMESTAMPDIFF(
        SECOND, fecha_embarque, fecha_desembarque
      )
    )
  ) AS tiempo_total,
  p.id AS id_pasajero,
  r.id AS id_ruta,
  t.id AS id_codigoRFID
FROM
  control_acceso c
  JOIN tarjeta_rfid t ON c.tarjeta_rfid_id = t.id
  JOIN ruta r ON c.ruta_id = r.id
  JOIN pasajero p ON c.pasajero_id = p.id
WHERE
  DATE(c.fecha_embarque) = DATE(c.fecha_desembarque)
  AND c.fecha_embarque BETWEEN :fechaInicio
  AND :fechaFinal
GROUP BY
  DATE(c.fecha_embarque),
  p.id,
  r.id,
  t.id

SELECT 
            MIN(c.fecha_embarque) AS fecha_inicio,
            MAX(c.fecha_desembarque) AS fecha_final,
            SEC_TO_TIME(SUM(TIMESTAMPDIFF(SECOND, fecha_embarque, fecha_desembarque))) AS tiempo_total,
            p.id AS id_pasajero,
            r.id AS id_ruta,
            t.id AS id_codigoRFID
        FROM control_acceso c
        JOIN tarjeta_rfid t ON c.tarjeta_rfid_id = t.id
        JOIN ruta r ON c.ruta_id = r.id
        JOIN pasajero p ON c.pasajero_id = p.id
        WHERE DATE(c.fecha_embarque) = DATE(c.fecha_desembarque)
        AND c.fecha_embarque BETWEEN '2026-03-01' AND '2026-03-01'
        GROUP BY DATE(c.fecha_embarque), p.id, r.id, t.id
    ;

SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, DATE_FORMAT(r0_.hora_inicio, '%H:%i:%s ') AS sclr_2, DATE_FORMAT(r0_.hora_final, '%H:%i:%s ') AS sclr_3, r0_.porcetaje AS porcetaje_4, r0_.descripcion AS descripcion_5, r0_.status AS status_6, CASE WHEN r0_.status = 1 THEN 'Activo' ELSE 'Inactivo' END AS sclr_7 FROM recargo r0_ WHERE r0_.delete_logic = 0 ORDER BY r0_.id ASC

[]

SELECT
  r0_.id AS id_0,
  r0_.nombre AS nombre_1,
  DATE_FORMAT(r0_.hora_inicio, '%H:%i:%s ') AS sclr_2,
  DATE_FORMAT(r0_.hora_final, '%H:%i:%s ') AS sclr_3,
  r0_.porcetaje AS porcetaje_4,
  r0_.descripcion AS descripcion_5,
  r0_.status AS status_6,
  CASE WHEN r0_.status = 1 THEN 'Activo' ELSE 'Inactivo' END AS sclr_7
FROM
  recargo r0_
WHERE
  r0_.delete_logic = 0
ORDER BY
  r0_.id ASC

SELECT r0_.id AS id_0, r0_.nombre AS nombre_1, DATE_FORMAT(r0_.hora_inicio, '%H:%i:%s ') AS sclr_2, DATE_FORMAT(r0_.hora_final, '%H:%i:%s ') AS sclr_3, r0_.porcetaje AS porcetaje_4, r0_.descripcion AS descripcion_5, r0_.status AS status_6, CASE WHEN r0_.status = 1 THEN 'Activo' ELSE 'Inactivo' END AS sclr_7 FROM recargo r0_ WHERE r0_.delete_logic = 0 ORDER BY r0_.id ASC;

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.perfil_user_id AS perfil_user_id_6 FROM user t0 WHERE t0.username = ? LIMIT 1

[
  "gerencia@libisoft.com.co"
]

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.email AS email_3,
  t0.roles AS roles_4,
  t0.password AS password_5,
  t0.perfil_user_id AS perfil_user_id_6
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.email AS email_3, t0.roles AS roles_4, t0.password AS password_5, t0.perfil_user_id AS perfil_user_id_6 FROM user t0 WHERE t0.username = 'gerencia@libisoft.com.co' LIMIT 1;