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 
                    bof_numero,
                    bof_fecha,
                    bof_hora,
                    bof_total,
                    tdo_id,
                    bof_efectivo,
                    bof_vuelto,
                    (bof_efectivo - bof_vuelto) as efectivo_neto,
                    bof_tarjeta_debito,
                    bof_tarjeta_credito,
                    bof_transferencia,
                    bof_webpay,
                    bof_credito,
                    ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                     bof_transferencia + bof_webpay + bof_credito) as suma_pagos,
                    usu_nusuario as cajera,
                    caj_id
                FROM ven_boleta_fiscal
                WHERE bof_fecha = ?
                AND (
                    -- Boletas con pagos pero total 0

                    (bof_total = 0 AND ((bof_efectivo - bof_vuelto) > 0 OR bof_tarjeta_debito > 0 OR 
                                        bof_tarjeta_credito > 0 OR bof_transferencia > 0 OR bof_webpay > 0 OR bof_credito > 0))
                    OR
                    -- Boletas con más pago que el total (posible pago sin boleta real)

                    (((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                      bof_transferencia + bof_webpay + bof_credito) > bof_total + 100)
                )
                ORDER BY bof_hora DESC

[
  "2026-06-18"
]

SELECT
  bof_numero,
  bof_fecha,
  bof_hora,
  bof_total,
  tdo_id,
  bof_efectivo,
  bof_vuelto,
  (bof_efectivo - bof_vuelto) as efectivo_neto,
  bof_tarjeta_debito,
  bof_tarjeta_credito,
  bof_transferencia,
  bof_webpay,
  bof_credito,
  (
    (bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + bof_transferencia + bof_webpay + bof_credito
  ) as suma_pagos,
  usu_nusuario as cajera,
  caj_id
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha = ?
  AND (
    -- Boletas con pagos pero total 0

    (
      bof_total = 0
      AND (
        (bof_efectivo - bof_vuelto) > 0
        OR bof_tarjeta_debito > 0
        OR bof_tarjeta_credito > 0
        OR bof_transferencia > 0
        OR bof_webpay > 0
        OR bof_credito > 0
      )
    )
    OR -- Boletas con más pago que el total (posible pago sin boleta real)

    (
      (
        (bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + bof_transferencia + bof_webpay + bof_credito
      ) > bof_total + 100
    )
  )
ORDER BY
  bof_hora DESC

SELECT 
                    bof_numero,
                    bof_fecha,
                    bof_hora,
                    bof_total,
                    tdo_id,
                    bof_efectivo,
                    bof_vuelto,
                    (bof_efectivo - bof_vuelto) as efectivo_neto,
                    bof_tarjeta_debito,
                    bof_tarjeta_credito,
                    bof_transferencia,
                    bof_webpay,
                    bof_credito,
                    ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                     bof_transferencia + bof_webpay + bof_credito) as suma_pagos,
                    usu_nusuario as cajera,
                    caj_id
                FROM ven_boleta_fiscal
                WHERE bof_fecha = '2026-06-18'
                AND (
                    -- Boletas con pagos pero total 0

                    (bof_total = 0 AND ((bof_efectivo - bof_vuelto) > 0 OR bof_tarjeta_debito > 0 OR 
                                        bof_tarjeta_credito > 0 OR bof_transferencia > 0 OR bof_webpay > 0 OR bof_credito > 0))
                    OR
                    -- Boletas con más pago que el total (posible pago sin boleta real)

                    (((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                      bof_transferencia + bof_webpay + bof_credito) > bof_total + 100)
                )
                ORDER BY bof_hora DESC
            ;

SELECT 
                    b.bof_numero,
                    b.bof_fecha,
                    b.bof_hora,
                    b.bof_total,
                    b.tdo_id,
                    b.bof_efectivo,
                    b.bof_tarjeta_debito as debito,
                    b.bof_tarjeta_credito as credito,
                    b.bof_credito as credito_interno,
                    b.usu_nusuario as cajera
                FROM ven_boleta_fiscal b
                LEFT JOIN ven_boleta_fiscal_mov m ON b.bof_numero = m.bof_numero 
                    AND b.caj_id = m.caj_id AND b.suc_id = m.suc_id
                WHERE b.bof_fecha = ? AND b.bof_total > 0
                GROUP BY b.bof_numero, b.caj_id, b.suc_id, b.bof_fecha, b.bof_hora, 
                         b.bof_total, b.tdo_id, b.bof_efectivo, b.bof_tarjeta_debito, 
                         b.bof_tarjeta_credito, b.bof_credito, b.usu_nusuario
                HAVING COUNT(m.bfm_id) = 0
                ORDER BY b.bof_total DESC
                LIMIT 20

[
  "2026-06-18"
]

SELECT
  b.bof_numero,
  b.bof_fecha,
  b.bof_hora,
  b.bof_total,
  b.tdo_id,
  b.bof_efectivo,
  b.bof_tarjeta_debito as debito,
  b.bof_tarjeta_credito as credito,
  b.bof_credito as credito_interno,
  b.usu_nusuario as cajera
FROM
  ven_boleta_fiscal b
  LEFT JOIN ven_boleta_fiscal_mov m ON b.bof_numero = m.bof_numero
  AND b.caj_id = m.caj_id
  AND b.suc_id = m.suc_id
WHERE
  b.bof_fecha = ?
  AND b.bof_total > 0
GROUP BY
  b.bof_numero,
  b.caj_id,
  b.suc_id,
  b.bof_fecha,
  b.bof_hora,
  b.bof_total,
  b.tdo_id,
  b.bof_efectivo,
  b.bof_tarjeta_debito,
  b.bof_tarjeta_credito,
  b.bof_credito,
  b.usu_nusuario
HAVING
  COUNT(m.bfm_id) = 0
ORDER BY
  b.bof_total DESC
LIMIT
  20

SELECT 
                    b.bof_numero,
                    b.bof_fecha,
                    b.bof_hora,
                    b.bof_total,
                    b.tdo_id,
                    b.bof_efectivo,
                    b.bof_tarjeta_debito as debito,
                    b.bof_tarjeta_credito as credito,
                    b.bof_credito as credito_interno,
                    b.usu_nusuario as cajera
                FROM ven_boleta_fiscal b
                LEFT JOIN ven_boleta_fiscal_mov m ON b.bof_numero = m.bof_numero 
                    AND b.caj_id = m.caj_id AND b.suc_id = m.suc_id
                WHERE b.bof_fecha = '2026-06-18' AND b.bof_total > 0
                GROUP BY b.bof_numero, b.caj_id, b.suc_id, b.bof_fecha, b.bof_hora, 
                         b.bof_total, b.tdo_id, b.bof_efectivo, b.bof_tarjeta_debito, 
                         b.bof_tarjeta_credito, b.bof_credito, b.usu_nusuario
                HAVING COUNT(m.bfm_id) = 0
                ORDER BY b.bof_total DESC
                LIMIT 20
            ;