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_fecha as periodo,
                DATE_FORMAT(bof_fecha, '%d/%m') as label,
                COUNT(*) as cantidad_ventas,
                COALESCE(SUM(bof_total), 0) as total_bruto,
                COALESCE(SUM(bof_neto), 0) as total_neto,
                COALESCE(SUM(bof_iva), 0) as total_iva,
                COALESCE(AVG(bof_total), 0) as ticket_promedio,
                MIN(bof_total) as venta_minima,
                MAX(bof_total) as venta_maxima
            FROM ven_boleta_fiscal
            WHERE bof_fecha >= ? AND bof_fecha <= ?
            GROUP BY bof_fecha, DATE_FORMAT(bof_fecha, '%d/%m')
            ORDER BY periodo ASC

[
  "2026-07-25"
  "2026-07-26"
]

SELECT
  bof_fecha as periodo,
  DATE_FORMAT(bof_fecha, '%d/%m') as label,
  COUNT(*) as cantidad_ventas,
  COALESCE(
    SUM(bof_total),
    0
  ) as total_bruto,
  COALESCE(
    SUM(bof_neto),
    0
  ) as total_neto,
  COALESCE(
    SUM(bof_iva),
    0
  ) as total_iva,
  COALESCE(
    AVG(bof_total),
    0
  ) as ticket_promedio,
  MIN(bof_total) as venta_minima,
  MAX(bof_total) as venta_maxima
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha >= ?
  AND bof_fecha <= ?
GROUP BY
  bof_fecha,
  DATE_FORMAT(bof_fecha, '%d/%m')
ORDER BY
  periodo ASC

SELECT 
                bof_fecha as periodo,
                DATE_FORMAT(bof_fecha, '%d/%m') as label,
                COUNT(*) as cantidad_ventas,
                COALESCE(SUM(bof_total), 0) as total_bruto,
                COALESCE(SUM(bof_neto), 0) as total_neto,
                COALESCE(SUM(bof_iva), 0) as total_iva,
                COALESCE(AVG(bof_total), 0) as ticket_promedio,
                MIN(bof_total) as venta_minima,
                MAX(bof_total) as venta_maxima
            FROM ven_boleta_fiscal
            WHERE bof_fecha >= '2026-07-25' AND bof_fecha <= '2026-07-26'
            GROUP BY bof_fecha, DATE_FORMAT(bof_fecha, '%d/%m')
            ORDER BY periodo ASC
        ;

SELECT 
                COUNT(*) as total_ventas,
                COALESCE(SUM(bof_total), 0) as total_bruto,
                COALESCE(SUM(bof_neto), 0) as total_neto,
                COALESCE(SUM(bof_iva), 0) as total_iva,
                COALESCE(AVG(bof_total), 0) as ticket_promedio
            FROM ven_boleta_fiscal
            WHERE bof_fecha >= ? AND bof_fecha <= ?

[
  "2026-07-25"
  "2026-07-26"
]

SELECT
  COUNT(*) as total_ventas,
  COALESCE(
    SUM(bof_total),
    0
  ) as total_bruto,
  COALESCE(
    SUM(bof_neto),
    0
  ) as total_neto,
  COALESCE(
    SUM(bof_iva),
    0
  ) as total_iva,
  COALESCE(
    AVG(bof_total),
    0
  ) as ticket_promedio
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha >= ?
  AND bof_fecha <= ?

SELECT 
                COUNT(*) as total_ventas,
                COALESCE(SUM(bof_total), 0) as total_bruto,
                COALESCE(SUM(bof_neto), 0) as total_neto,
                COALESCE(SUM(bof_iva), 0) as total_iva,
                COALESCE(AVG(bof_total), 0) as ticket_promedio
            FROM ven_boleta_fiscal
            WHERE bof_fecha >= '2026-07-25' AND bof_fecha <= '2026-07-26'
        ;

SELECT 
                COUNT(*) as total_ventas,
                COALESCE(SUM(bof_total), 0) as total_bruto
            FROM ven_boleta_fiscal
            WHERE bof_fecha >= ? AND bof_fecha <= ?

[
  "2026-07-24"
  "2026-07-25"
]

SELECT
  COUNT(*) as total_ventas,
  COALESCE(
    SUM(bof_total),
    0
  ) as total_bruto
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha >= ?
  AND bof_fecha <= ?

SELECT 
                COUNT(*) as total_ventas,
                COALESCE(SUM(bof_total), 0) as total_bruto
            FROM ven_boleta_fiscal
            WHERE bof_fecha >= '2026-07-24' AND bof_fecha <= '2026-07-25'
        ;