Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

12.27 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

crux connection

Time▼

Count

Info

4.65 ms
(37.95%)

SELECT 
                    bof_numero,
                    bof_fecha,
                    bof_hora,
                    bof_total,
                    tdo_id,
                    ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                     bof_transferencia + bof_webpay + bof_credito) as suma_pagos,
                    bof_total - ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                                 bof_transferencia + bof_webpay + bof_credito) as diferencia,
                    bof_efectivo, bof_vuelto, (bof_efectivo - bof_vuelto) as efectivo_neto,
                    bof_tarjeta_debito, bof_tarjeta_credito,
                    bof_transferencia, bof_webpay, bof_credito, usu_nusuario as cajera
                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
                ORDER BY ABS(bof_total - ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                                          bof_transferencia + bof_webpay + bof_credito)) DESC
                LIMIT 50

Parameters:

[
  "2026-07-11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  bof_numero,
  bof_fecha,
  bof_hora,
  bof_total,
  tdo_id,
  (
    (bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + bof_transferencia + bof_webpay + bof_credito
  ) as suma_pagos,
  bof_total - (
    (bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + bof_transferencia + bof_webpay + bof_credito
  ) as diferencia,
  bof_efectivo,
  bof_vuelto,
  (bof_efectivo - bof_vuelto) as efectivo_neto,
  bof_tarjeta_debito,
  bof_tarjeta_credito,
  bof_transferencia,
  bof_webpay,
  bof_credito,
  usu_nusuario as cajera
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
ORDER BY
  ABS(
    bof_total - (
      (bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + bof_transferencia + bof_webpay + bof_credito
    )
  ) DESC
LIMIT
  50

SELECT 
                    bof_numero,
                    bof_fecha,
                    bof_hora,
                    bof_total,
                    tdo_id,
                    ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                     bof_transferencia + bof_webpay + bof_credito) as suma_pagos,
                    bof_total - ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                                 bof_transferencia + bof_webpay + bof_credito) as diferencia,
                    bof_efectivo, bof_vuelto, (bof_efectivo - bof_vuelto) as efectivo_neto,
                    bof_tarjeta_debito, bof_tarjeta_credito,
                    bof_transferencia, bof_webpay, bof_credito, usu_nusuario as cajera
                FROM ven_boleta_fiscal
                WHERE bof_fecha = '2026-07-11'
                AND ABS(bof_total - ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                                     bof_transferencia + bof_webpay + bof_credito)) > 1
                ORDER BY ABS(bof_total - ((bof_efectivo - bof_vuelto) + bof_tarjeta_debito + bof_tarjeta_credito + 
                                          bof_transferencia + bof_webpay + bof_credito)) DESC
                LIMIT 50
            ;

#	File/Call
1	App\Controller\VentasController->descuadre (line 239)
2	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
4	Symfony\Component\HttpKernel\Kernel->handle (line 193)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
6	require_once (line 32)
7	require_once (line 5)

4.09 ms
(33.35%)

SELECT 
                    COUNT(*) as total_boletas,
                    COALESCE(SUM(bof_total), 0) as total_ventas,
                    COALESCE(SUM(bof_neto), 0) as total_neto,
                    COALESCE(SUM(bof_iva), 0) as total_iva,
                    COALESCE(SUM(bof_efectivo), 0) as total_efectivo_bruto,
                    COALESCE(SUM(bof_vuelto), 0) as total_vuelto,
                    COALESCE(SUM(bof_efectivo - bof_vuelto), 0) as total_efectivo,
                    COALESCE(SUM(bof_tarjeta_debito), 0) as total_debito,
                    COALESCE(SUM(bof_tarjeta_credito), 0) as total_credito,
                    COALESCE(SUM(bof_transferencia), 0) as total_transferencia,
                    COALESCE(SUM(bof_webpay), 0) as total_webpay,
                    COALESCE(SUM(bof_credito), 0) as total_credito_interno,
                    COALESCE(SUM(bof_vuelto_transbank), 0) as total_vuelto_transbank
                FROM ven_boleta_fiscal
                WHERE bof_fecha = ?

Parameters:

[
  "2026-07-11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) as total_boletas,
  COALESCE(
    SUM(bof_total),
    0
  ) as total_ventas,
  COALESCE(
    SUM(bof_neto),
    0
  ) as total_neto,
  COALESCE(
    SUM(bof_iva),
    0
  ) as total_iva,
  COALESCE(
    SUM(bof_efectivo),
    0
  ) as total_efectivo_bruto,
  COALESCE(
    SUM(bof_vuelto),
    0
  ) as total_vuelto,
  COALESCE(
    SUM(bof_efectivo - bof_vuelto),
    0
  ) as total_efectivo,
  COALESCE(
    SUM(bof_tarjeta_debito),
    0
  ) as total_debito,
  COALESCE(
    SUM(bof_tarjeta_credito),
    0
  ) as total_credito,
  COALESCE(
    SUM(bof_transferencia),
    0
  ) as total_transferencia,
  COALESCE(
    SUM(bof_webpay),
    0
  ) as total_webpay,
  COALESCE(
    SUM(bof_credito),
    0
  ) as total_credito_interno,
  COALESCE(
    SUM(bof_vuelto_transbank),
    0
  ) as total_vuelto_transbank
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_iva), 0) as total_iva,
                    COALESCE(SUM(bof_efectivo), 0) as total_efectivo_bruto,
                    COALESCE(SUM(bof_vuelto), 0) as total_vuelto,
                    COALESCE(SUM(bof_efectivo - bof_vuelto), 0) as total_efectivo,
                    COALESCE(SUM(bof_tarjeta_debito), 0) as total_debito,
                    COALESCE(SUM(bof_tarjeta_credito), 0) as total_credito,
                    COALESCE(SUM(bof_transferencia), 0) as total_transferencia,
                    COALESCE(SUM(bof_webpay), 0) as total_webpay,
                    COALESCE(SUM(bof_credito), 0) as total_credito_interno,
                    COALESCE(SUM(bof_vuelto_transbank), 0) as total_vuelto_transbank
                FROM ven_boleta_fiscal
                WHERE bof_fecha = '2026-07-11'
            ;

#	File/Call
1	App\Controller\VentasController->descuadre (line 193)
2	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
4	Symfony\Component\HttpKernel\Kernel->handle (line 193)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
6	require_once (line 32)
7	require_once (line 5)

3.52 ms
(28.70%)

SELECT 
                    COUNT(*) as total_items,
                    COALESCE(SUM(m.bfm_cantidad), 0) as total_cantidad,
                    COALESCE(SUM(m.bfm_total), 0) as total_movimientos
                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 = ?

Parameters:

[
  "2026-07-11"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) as total_items,
  COALESCE(
    SUM(m.bfm_cantidad),
    0
  ) as total_cantidad,
  COALESCE(
    SUM(m.bfm_total),
    0
  ) as total_movimientos
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 
                    COUNT(*) as total_items,
                    COALESCE(SUM(m.bfm_cantidad), 0) as total_cantidad,
                    COALESCE(SUM(m.bfm_total), 0) as total_movimientos
                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-07-11'
            ;

#	File/Call
1	App\Controller\VentasController->descuadre (line 214)
2	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
3	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
4	Symfony\Component\HttpKernel\Kernel->handle (line 193)
5	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
6	require_once (line 32)
7	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
crux	doctrine.dbal.crux_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://app.wmarket.cl/api/ventas/descuadre?fecha=2026-07-11

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

crux connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping