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 
                    b1.bof_numero as folio1,
                    b2.bof_numero as folio2,
                    b1.bof_hora as hora1,
                    b2.bof_hora as hora2,
                    b1.bof_total as total,
                    b1.usu_nusuario as cajera1,
                    b2.usu_nusuario as cajera2,
                    b1.caj_id as caja1,
                    b2.caj_id as caja2
                FROM ven_boleta_fiscal b1
                INNER JOIN ven_boleta_fiscal b2 ON b1.bof_total = b2.bof_total 
                    AND b1.bof_fecha = b2.bof_fecha
                    AND b1.bof_numero < b2.bof_numero
                    AND ABS(TIME_TO_SEC(TIMEDIFF(b1.bof_hora, b2.bof_hora))) < 120
                WHERE b1.bof_fecha = ? AND b1.bof_total > 5000
                ORDER BY b1.bof_total DESC, b1.bof_hora
                LIMIT 30

[
  "2026-02-24"
]

SELECT
  b1.bof_numero as folio1,
  b2.bof_numero as folio2,
  b1.bof_hora as hora1,
  b2.bof_hora as hora2,
  b1.bof_total as total,
  b1.usu_nusuario as cajera1,
  b2.usu_nusuario as cajera2,
  b1.caj_id as caja1,
  b2.caj_id as caja2
FROM
  ven_boleta_fiscal b1
  INNER JOIN ven_boleta_fiscal b2 ON b1.bof_total = b2.bof_total
  AND b1.bof_fecha = b2.bof_fecha
  AND b1.bof_numero < b2.bof_numero
  AND ABS(
    TIME_TO_SEC(
      TIMEDIFF(b1.bof_hora, b2.bof_hora)
    )
  ) < 120
WHERE
  b1.bof_fecha = ?
  AND b1.bof_total > 5000
ORDER BY
  b1.bof_total DESC,
  b1.bof_hora
LIMIT
  30

SELECT 
                    b1.bof_numero as folio1,
                    b2.bof_numero as folio2,
                    b1.bof_hora as hora1,
                    b2.bof_hora as hora2,
                    b1.bof_total as total,
                    b1.usu_nusuario as cajera1,
                    b2.usu_nusuario as cajera2,
                    b1.caj_id as caja1,
                    b2.caj_id as caja2
                FROM ven_boleta_fiscal b1
                INNER JOIN ven_boleta_fiscal b2 ON b1.bof_total = b2.bof_total 
                    AND b1.bof_fecha = b2.bof_fecha
                    AND b1.bof_numero < b2.bof_numero
                    AND ABS(TIME_TO_SEC(TIMEDIFF(b1.bof_hora, b2.bof_hora))) < 120
                WHERE b1.bof_fecha = '2026-02-24' AND b1.bof_total > 5000
                ORDER BY b1.bof_total DESC, b1.bof_hora
                LIMIT 30
            ;

SELECT 
                    bof_numero,
                    COUNT(*) as veces,
                    GROUP_CONCAT(DISTINCT caj_id ORDER BY caj_id SEPARATOR ', ') as cajas,
                    SUM(bof_total) as total_sumado,
                    MIN(bof_hora) as primera_hora,
                    MAX(bof_hora) as ultima_hora
                FROM ven_boleta_fiscal
                WHERE bof_fecha = ?
                GROUP BY bof_numero
                HAVING COUNT(*) > 1
                ORDER BY veces DESC, total_sumado DESC

[
  "2026-02-24"
]

SELECT
  bof_numero,
  COUNT(*) as veces,
  GROUP_CONCAT(
    DISTINCT caj_id
    ORDER BY
      caj_id SEPARATOR ', '
  ) as cajas,
  SUM(bof_total) as total_sumado,
  MIN(bof_hora) as primera_hora,
  MAX(bof_hora) as ultima_hora
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha = ?
GROUP BY
  bof_numero
HAVING
  COUNT(*) > 1
ORDER BY
  veces DESC,
  total_sumado DESC

SELECT 
                    bof_numero,
                    COUNT(*) as veces,
                    GROUP_CONCAT(DISTINCT caj_id ORDER BY caj_id SEPARATOR ', ') as cajas,
                    SUM(bof_total) as total_sumado,
                    MIN(bof_hora) as primera_hora,
                    MAX(bof_hora) as ultima_hora
                FROM ven_boleta_fiscal
                WHERE bof_fecha = '2026-02-24'
                GROUP BY bof_numero
                HAVING COUNT(*) > 1
                ORDER BY veces DESC, total_sumado DESC
            ;