Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

441.73 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

crux connection

Time▼

Count

Info

317.30 ms
(71.83%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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
        ;

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 113)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

46.58 ms
(10.54%)

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)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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)
        ;

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 59)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

38.67 ms
(8.75%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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
        ;

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 100)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

14.64 ms
(3.31%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 70)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

7.53 ms
(1.71%)

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)

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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)
        ;

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 48)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

6.82 ms
(1.54%)

SELECT * FROM mae_datos_empresa LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  *
FROM
  mae_datos_empresa
LIMIT
  1

SELECT * FROM mae_datos_empresa LIMIT 1;

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 130)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

3.79 ms
(0.86%)

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'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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'
        ;

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 82)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

3.22 ms
(0.73%)

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'

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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'
        ;

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 91)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

3.17 ms
(0.72%)

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

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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

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

#	File/Call
1	App\Controller\DashboardController->fetchDashboardData (line 76)
2	App\Controller\DashboardController->{closure:App\Controller\DashboardController::index():28} (line 31)
3	Symfony\Component\Cache\Adapter\TraceableAdapter->{closure:Symfony\Component\Cache\Adapter\TraceableAdapter::get():54} (line 57)
4	Symfony\Component\Cache\LockRegistry->compute (line 111)
5	Symfony\Component\Cache\Adapter\AbstractAdapter::{closure:Symfony\Component\Cache\Traits\ContractsTrait::doGet():85} (line 102)
6	Symfony\Component\Cache\Adapter\AbstractAdapter->contractsGet (line 64)
7	Symfony\Component\Cache\Adapter\AbstractAdapter->doGet (line 85)
8	Symfony\Component\Cache\Adapter\AbstractAdapter->get (line 30)
9	Symfony\Component\Cache\Adapter\TraceableAdapter->get (line 62)
10	App\Controller\DashboardController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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/dashboard

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