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 
                    COUNT(*) as total_boletas,
                    COALESCE(SUM(bof_total), 0) as total_ventas,
                    COALESCE(SUM(bof_neto), 0) as total_neto,
                    COALESCE(SUM(bof_efectivo), 0) as efectivo_bruto,
                    COALESCE(SUM(bof_vuelto), 0) as vuelto,
                    COALESCE(SUM(bof_efectivo - bof_vuelto), 0) as efectivo,
                    COALESCE(SUM(bof_tarjeta_debito), 0) as debito,
                    COALESCE(SUM(bof_tarjeta_credito), 0) as credito,
                    COALESCE(SUM(bof_transferencia), 0) as transferencia,
                    COALESCE(SUM(bof_webpay), 0) as webpay,
                    COALESCE(SUM(bof_credito), 0) as credito_interno,
                    COUNT(DISTINCT caj_id) as cajas_activas,
                    COUNT(DISTINCT usu_nusuario) as cajeros_activos,
                    MIN(bof_hora) as primera_venta,
                    MAX(bof_hora) as ultima_venta
                FROM ven_boleta_fiscal
                WHERE bof_fecha = ?

[
  "2026-04-17"
]

SELECT
  COUNT(*) as total_boletas,
  COALESCE(
    SUM(bof_total),
    0
  ) as total_ventas,
  COALESCE(
    SUM(bof_neto),
    0
  ) as total_neto,
  COALESCE(
    SUM(bof_efectivo),
    0
  ) as efectivo_bruto,
  COALESCE(
    SUM(bof_vuelto),
    0
  ) as vuelto,
  COALESCE(
    SUM(bof_efectivo - bof_vuelto),
    0
  ) as efectivo,
  COALESCE(
    SUM(bof_tarjeta_debito),
    0
  ) as debito,
  COALESCE(
    SUM(bof_tarjeta_credito),
    0
  ) as credito,
  COALESCE(
    SUM(bof_transferencia),
    0
  ) as transferencia,
  COALESCE(
    SUM(bof_webpay),
    0
  ) as webpay,
  COALESCE(
    SUM(bof_credito),
    0
  ) as credito_interno,
  COUNT(DISTINCT caj_id) as cajas_activas,
  COUNT(DISTINCT usu_nusuario) as cajeros_activos,
  MIN(bof_hora) as primera_venta,
  MAX(bof_hora) as ultima_venta
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha = ?

SELECT 
                    COUNT(*) as total_boletas,
                    COALESCE(SUM(bof_total), 0) as total_ventas,
                    COALESCE(SUM(bof_neto), 0) as total_neto,
                    COALESCE(SUM(bof_efectivo), 0) as efectivo_bruto,
                    COALESCE(SUM(bof_vuelto), 0) as vuelto,
                    COALESCE(SUM(bof_efectivo - bof_vuelto), 0) as efectivo,
                    COALESCE(SUM(bof_tarjeta_debito), 0) as debito,
                    COALESCE(SUM(bof_tarjeta_credito), 0) as credito,
                    COALESCE(SUM(bof_transferencia), 0) as transferencia,
                    COALESCE(SUM(bof_webpay), 0) as webpay,
                    COALESCE(SUM(bof_credito), 0) as credito_interno,
                    COUNT(DISTINCT caj_id) as cajas_activas,
                    COUNT(DISTINCT usu_nusuario) as cajeros_activos,
                    MIN(bof_hora) as primera_venta,
                    MAX(bof_hora) as ultima_venta
                FROM ven_boleta_fiscal
                WHERE bof_fecha = '2026-04-17'
            ;

SELECT COUNT(*) FROM ven_boleta_fiscal
                WHERE bof_fecha = ?
                AND ABS(bof_total - ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                                     bof_transferencia + bof_webpay + bof_credito)) > 1

[
  "2026-04-17"
]

SELECT
  COUNT(*)
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha = ?
  AND ABS(
    bof_total - (
      (bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + bof_transferencia + bof_webpay + bof_credito
    )
  ) > 1

SELECT COUNT(*) FROM ven_boleta_fiscal
                WHERE bof_fecha = '2026-04-17'
                AND ABS(bof_total - ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                                     bof_transferencia + bof_webpay + bof_credito)) > 1
            ;

SELECT 
                    COALESCE(SUM(m.bfm_total), 0) as total_items
                FROM ven_boleta_fiscal_mov m
                INNER JOIN ven_boleta_fiscal b ON m.bof_numero = b.bof_numero 
                    AND m.caj_id = b.caj_id AND m.suc_id = b.suc_id
                WHERE b.bof_fecha = ?

[
  "2026-04-17"
]

SELECT
  COALESCE(
    SUM(m.bfm_total),
    0
  ) as total_items
FROM
  ven_boleta_fiscal_mov m
  INNER JOIN ven_boleta_fiscal b ON m.bof_numero = b.bof_numero
  AND m.caj_id = b.caj_id
  AND m.suc_id = b.suc_id
WHERE
  b.bof_fecha = ?

SELECT 
                    COALESCE(SUM(m.bfm_total), 0) as total_items
                FROM ven_boleta_fiscal_mov m
                INNER JOIN ven_boleta_fiscal b ON m.bof_numero = b.bof_numero 
                    AND m.caj_id = b.caj_id AND m.suc_id = b.suc_id
                WHERE b.bof_fecha = '2026-04-17'
            ;