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 cantidad,
                COALESCE(SUM(bof_total), 0) as total
            FROM ven_boleta_fiscal 
            WHERE bof_fecha >= CURDATE() 
            AND bof_fecha < DATE_ADD(CURDATE(), INTERVAL 1 DAY)

[]

SELECT
  COUNT(*) as cantidad,
  COALESCE(
    SUM(bof_total),
    0
  ) as total
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha >= CURDATE()
  AND bof_fecha < DATE_ADD(
    CURDATE(),
    INTERVAL 1 DAY
  )

SELECT 
                COUNT(*) as cantidad,
                COALESCE(SUM(bof_total), 0) as total
            FROM ven_boleta_fiscal 
            WHERE bof_fecha >= CURDATE() 
            AND bof_fecha < DATE_ADD(CURDATE(), INTERVAL 1 DAY)
        ;

SELECT 
                COUNT(*) as cantidad,
                COALESCE(SUM(bof_total), 0) as total
            FROM ven_boleta_fiscal 
            WHERE bof_fecha >= DATE_FORMAT(CURDATE(), '%Y-%m-01')
            AND bof_fecha < DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH)

[]

SELECT
  COUNT(*) as cantidad,
  COALESCE(
    SUM(bof_total),
    0
  ) as total
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha >= DATE_FORMAT(
    CURDATE(),
    '%Y-%m-01'
  )
  AND bof_fecha < DATE_ADD(
    DATE_FORMAT(
      CURDATE(),
      '%Y-%m-01'
    ),
    INTERVAL 1 MONTH
  )

SELECT 
                COUNT(*) as cantidad,
                COALESCE(SUM(bof_total), 0) as total
            FROM ven_boleta_fiscal 
            WHERE bof_fecha >= DATE_FORMAT(CURDATE(), '%Y-%m-01')
            AND bof_fecha < DATE_ADD(DATE_FORMAT(CURDATE(), '%Y-%m-01'), INTERVAL 1 MONTH)
        ;

SELECT COUNT(*) as total FROM mae_productos WHERE pro_activo = 'SI'

[]

SELECT
  COUNT(*) as total
FROM
  mae_productos
WHERE
  pro_activo = 'SI'

SELECT COUNT(*) as total FROM mae_productos WHERE pro_activo = 'SI'
        ;

SELECT COUNT(*) as total FROM mae_clientes WHERE cli_activo = 'SI'

[]

SELECT
  COUNT(*) as total
FROM
  mae_clientes
WHERE
  cli_activo = 'SI'

SELECT COUNT(*) as total FROM mae_clientes WHERE cli_activo = 'SI'
        ;

SELECT COUNT(*) as total 
            FROM sys_stock s
            INNER JOIN mae_productos p ON s.pro_codigo_plu = p.pro_codigo_plu
            WHERE s.sto_stock < 10 AND s.sto_stock > 0 AND p.pro_activo = 'SI'

[]

SELECT
  COUNT(*) as total
FROM
  sys_stock s
  INNER JOIN mae_productos p ON s.pro_codigo_plu = p.pro_codigo_plu
WHERE
  s.sto_stock < 10
  AND s.sto_stock > 0
  AND p.pro_activo = 'SI'

SELECT COUNT(*) as total 
            FROM sys_stock s
            INNER JOIN mae_productos p ON s.pro_codigo_plu = p.pro_codigo_plu
            WHERE s.sto_stock < 10 AND s.sto_stock > 0 AND p.pro_activo = 'SI'
        ;

SELECT COUNT(*) as total 
            FROM sys_stock s
            INNER JOIN mae_productos p ON s.pro_codigo_plu = p.pro_codigo_plu
            WHERE s.sto_stock <= 0 AND p.pro_activo = 'SI'

[]

SELECT
  COUNT(*) as total
FROM
  sys_stock s
  INNER JOIN mae_productos p ON s.pro_codigo_plu = p.pro_codigo_plu
WHERE
  s.sto_stock <= 0
  AND p.pro_activo = 'SI'

SELECT COUNT(*) as total 
            FROM sys_stock s
            INNER JOIN mae_productos p ON s.pro_codigo_plu = p.pro_codigo_plu
            WHERE s.sto_stock <= 0 AND p.pro_activo = 'SI'
        ;

SELECT 
                DATE(bof_fecha) as fecha,
                COUNT(*) as cantidad,
                COALESCE(SUM(bof_total), 0) as total
            FROM ven_boleta_fiscal 
            WHERE bof_fecha >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)
            GROUP BY DATE(bof_fecha)
            ORDER BY fecha ASC

[]

SELECT
  DATE(bof_fecha) as fecha,
  COUNT(*) as cantidad,
  COALESCE(
    SUM(bof_total),
    0
  ) as total
FROM
  ven_boleta_fiscal
WHERE
  bof_fecha >= DATE_SUB(
    CURDATE(),
    INTERVAL 7 DAY
  )
GROUP BY
  DATE(bof_fecha)
ORDER BY
  fecha ASC

SELECT 
                DATE(bof_fecha) as fecha,
                COUNT(*) as cantidad,
                COALESCE(SUM(bof_total), 0) as total
            FROM ven_boleta_fiscal 
            WHERE bof_fecha >= DATE_SUB(CURDATE(), INTERVAL 7 DAY)
            GROUP BY DATE(bof_fecha)
            ORDER BY fecha ASC
        ;

SELECT 
                m.pro_codigo_plu,
                p.pro_nombre_producto,
                SUM(m.bfm_cantidad) as cantidad_vendida,
                SUM(m.bfm_total) as total_vendido
            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
            INNER JOIN mae_productos p ON m.pro_codigo_plu = p.pro_codigo_plu
            WHERE b.bof_fecha >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)
            GROUP BY m.pro_codigo_plu, p.pro_nombre_producto
            ORDER BY cantidad_vendida DESC
            LIMIT 10

[]

SELECT
  m.pro_codigo_plu,
  p.pro_nombre_producto,
  SUM(m.bfm_cantidad) as cantidad_vendida,
  SUM(m.bfm_total) as total_vendido
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
  INNER JOIN mae_productos p ON m.pro_codigo_plu = p.pro_codigo_plu
WHERE
  b.bof_fecha >= DATE_SUB(
    CURDATE(),
    INTERVAL 30 DAY
  )
GROUP BY
  m.pro_codigo_plu,
  p.pro_nombre_producto
ORDER BY
  cantidad_vendida DESC
LIMIT
  10

SELECT 
                m.pro_codigo_plu,
                p.pro_nombre_producto,
                SUM(m.bfm_cantidad) as cantidad_vendida,
                SUM(m.bfm_total) as total_vendido
            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
            INNER JOIN mae_productos p ON m.pro_codigo_plu = p.pro_codigo_plu
            WHERE b.bof_fecha >= DATE_SUB(CURDATE(), INTERVAL 30 DAY)
            GROUP BY m.pro_codigo_plu, p.pro_nombre_producto
            ORDER BY cantidad_vendida DESC
            LIMIT 10
        ;

SELECT * FROM mae_datos_empresa LIMIT 1

[]

SELECT
  *
FROM
  mae_datos_empresa
LIMIT
  1

SELECT * FROM mae_datos_empresa LIMIT 1;