Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

98.54 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

19.86 ms
(20.15%)

SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = ? LIMIT 1

Parameters:

[
  "rifu.iridian.co"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.fqdn AS fqdn_2,
  t0.username AS username_3,
  t0.host AS host_4,
  t0.password AS password_5,
  t0.database_name AS database_name_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.tenant_id AS tenant_id_10,
  t11.id AS id_12,
  t11.uuid AS uuid_13,
  t11.created_at AS created_at_14,
  t11.updated_at AS updated_at_15,
  t11.deleted_at AS deleted_at_16,
  t11.local AS local_17
FROM
  hostname t0
  INNER JOIN tenant t11 ON t0.tenant_id = t11.id
WHERE
  t0.fqdn = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.fqdn AS fqdn_2, t0.username AS username_3, t0.host AS host_4, t0.password AS password_5, t0.database_name AS database_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.tenant_id AS tenant_id_10, t11.id AS id_12, t11.uuid AS uuid_13, t11.created_at AS created_at_14, t11.updated_at AS updated_at_15, t11.deleted_at AS deleted_at_16, t11.local AS local_17 FROM hostname t0 INNER JOIN tenant t11 ON t0.tenant_id = t11.id WHERE t0.fqdn = 'rifu.iridian.co' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 54)
4	MultiTenancyBundle\EventListener\TenantRequestListener->onKernelRequest (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

19.20 ms
(19.49%)

SELECT valor from main_setting where llave = 'validate_integrity';

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  valor
from
  main_setting
where
  llave = 'validate_integrity';

SELECT valor from main_setting where llave = 'validate_integrity';
            ;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 39)
2	App\EventListener\KernelRequestListener->onKernelRequest (line 116)
3	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
4	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
5	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
6	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

19.11 ms
(19.39%)

SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  if(
    @@global.time_zone = 'SYSTEM', @@system_time_zone,
    @@global.time_zone
  ) AS timezone;

SELECT if(@@global.time_zone = 'SYSTEM', @@system_time_zone, @@global.time_zone) AS timezone;;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 30)
2	App\EventListener\KernelRequestListener->onKernelRequest (line 116)
3	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
4	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
5	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
6	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

tenant connection

Time▼	Count	Info
21.44 ms (21.75%)	1	SELECT s0_.id AS id_0, m1_.id AS id_1, u2_.id AS id_2, s0_.fecha_expiracion AS fecha_expiracion_3, s0_.valor AS valor_4, b3_.id AS id_5 FROM saldo_condicionado s0_ INNER JOIN movimiento m1_ ON (m1_.saldo_condicionado_id = s0_.id) INNER JOIN usuario u2_ ON (m1_.usuario_id = u2_.id) INNER JOIN bono b3_ ON (m1_.bono_id = b3_.id) INNER JOIN estado_bono e4_ ON (b3_.estado_id = e4_.id) INNER JOIN tipo_calculo_descuento t5_ ON (b3_.tipo_id = t5_.id) INNER JOIN tipo_bono t6_ ON (t5_.tipo_id = t6_.id) WHERE s0_.fecha_expiracion <= CURRENT_TIMESTAMP AND s0_.fecha_expiracion >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND s0_.valor <> ? AND t5_.nombre = ? ORDER BY s0_.fecha_expiracion ASC Parameters: [`"0.0" "Saldo"`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, m1_.id AS id_1, u2_.id AS id_2, s0_.fecha_expiracion AS fecha_expiracion_3, s0_.valor AS valor_4, b3_.id AS id_5 FROM saldo_condicionado s0_ INNER JOIN movimiento m1_ ON ( m1_.saldo_condicionado_id = s0_.id ) INNER JOIN usuario u2_ ON (m1_.usuario_id = u2_.id) INNER JOIN bono b3_ ON (m1_.bono_id = b3_.id) INNER JOIN estado_bono e4_ ON (b3_.estado_id = e4_.id) INNER JOIN tipo_calculo_descuento t5_ ON (b3_.tipo_id = t5_.id) INNER JOIN tipo_bono t6_ ON (t5_.tipo_id = t6_.id) WHERE s0_.fecha_expiracion <= CURRENT_TIMESTAMP AND s0_.fecha_expiracion >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND s0_.valor <> ? AND t5_.nombre = ? ORDER BY s0_.fecha_expiracion ASC SELECT s0_.id AS id_0, m1_.id AS id_1, u2_.id AS id_2, s0_.fecha_expiracion AS fecha_expiracion_3, s0_.valor AS valor_4, b3_.id AS id_5 FROM saldo_condicionado s0_ INNER JOIN movimiento m1_ ON (m1_.saldo_condicionado_id = s0_.id) INNER JOIN usuario u2_ ON (m1_.usuario_id = u2_.id) INNER JOIN bono b3_ ON (m1_.bono_id = b3_.id) INNER JOIN estado_bono e4_ ON (b3_.estado_id = e4_.id) INNER JOIN tipo_calculo_descuento t5_ ON (b3_.tipo_id = t5_.id) INNER JOIN tipo_bono t6_ ON (t5_.tipo_id = t6_.id) WHERE s0_.fecha_expiracion <= CURRENT_TIMESTAMP AND s0_.fecha_expiracion >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND s0_.valor <> '0.0' AND t5_.nombre = 'Saldo' ORDER BY s0_.fecha_expiracion ASC;
18.93 ms (19.21%)	1	SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC Parameters: [] View formatted query View runnable query Explain query SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC;

Time▼

Count

Info

21.44 ms
(21.75%)

SELECT s0_.id AS id_0, m1_.id AS id_1, u2_.id AS id_2, s0_.fecha_expiracion AS fecha_expiracion_3, s0_.valor AS valor_4, b3_.id AS id_5 FROM saldo_condicionado s0_ INNER JOIN movimiento m1_ ON (m1_.saldo_condicionado_id = s0_.id) INNER JOIN usuario u2_ ON (m1_.usuario_id = u2_.id) INNER JOIN bono b3_ ON (m1_.bono_id = b3_.id) INNER JOIN estado_bono e4_ ON (b3_.estado_id = e4_.id) INNER JOIN tipo_calculo_descuento t5_ ON (b3_.tipo_id = t5_.id) INNER JOIN tipo_bono t6_ ON (t5_.tipo_id = t6_.id) WHERE s0_.fecha_expiracion <= CURRENT_TIMESTAMP AND s0_.fecha_expiracion >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND s0_.valor <> ? AND t5_.nombre = ? ORDER BY s0_.fecha_expiracion ASC

Parameters:

[
  "0.0"
  "Saldo"
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  m1_.id AS id_1,
  u2_.id AS id_2,
  s0_.fecha_expiracion AS fecha_expiracion_3,
  s0_.valor AS valor_4,
  b3_.id AS id_5
FROM
  saldo_condicionado s0_
  INNER JOIN movimiento m1_ ON (
    m1_.saldo_condicionado_id = s0_.id
  )
  INNER JOIN usuario u2_ ON (m1_.usuario_id = u2_.id)
  INNER JOIN bono b3_ ON (m1_.bono_id = b3_.id)
  INNER JOIN estado_bono e4_ ON (b3_.estado_id = e4_.id)
  INNER JOIN tipo_calculo_descuento t5_ ON (b3_.tipo_id = t5_.id)
  INNER JOIN tipo_bono t6_ ON (t5_.tipo_id = t6_.id)
WHERE
  s0_.fecha_expiracion <= CURRENT_TIMESTAMP
  AND s0_.fecha_expiracion >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY)
  AND s0_.valor <> ?
  AND t5_.nombre = ?
ORDER BY
  s0_.fecha_expiracion ASC

SELECT s0_.id AS id_0, m1_.id AS id_1, u2_.id AS id_2, s0_.fecha_expiracion AS fecha_expiracion_3, s0_.valor AS valor_4, b3_.id AS id_5 FROM saldo_condicionado s0_ INNER JOIN movimiento m1_ ON (m1_.saldo_condicionado_id = s0_.id) INNER JOIN usuario u2_ ON (m1_.usuario_id = u2_.id) INNER JOIN bono b3_ ON (m1_.bono_id = b3_.id) INNER JOIN estado_bono e4_ ON (b3_.estado_id = e4_.id) INNER JOIN tipo_calculo_descuento t5_ ON (b3_.tipo_id = t5_.id) INNER JOIN tipo_bono t6_ ON (t5_.tipo_id = t6_.id) WHERE s0_.fecha_expiracion <= CURRENT_TIMESTAMP AND s0_.fecha_expiracion >= DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 1 DAY) AND s0_.valor <> '0.0' AND t5_.nombre = 'Saldo' ORDER BY s0_.fecha_expiracion ASC;

18.93 ms
(19.21%)

SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  s0_.valor AS valor_0,
  s0_.llave AS llave_1
FROM
  setting s0_
ORDER BY
  s0_.id ASC

SELECT s0_.valor AS valor_0, s0_.llave AS llave_1 FROM setting s0_ ORDER BY s0_.id ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
tenant	doctrine.dbal.tenant_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
tenant	doctrine.orm.tenant_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
MultiTenancyBundle\Entity\Hostname	No errors.
MultiTenancyBundle\Entity\Tenant	No errors.

tenant entity manager

Class	Mapping errors
App\Entity\General\Setting	No errors.
App\Entity\Billetera\SaldoCondicionado	No errors.
App\Entity\Billetera\Movimiento	If association App\Entity\Billetera\Movimiento#pagoSaldo is many-to-one, then the inversed side App\Entity\Solicitud\SolicitudPago#movimiento has to be one-to-many.
App\Entity\Usuario\Usuario	No errors.
App\Entity\Billetera\Bono	The field App\Entity\Billetera\Bono#bonoMovimientos is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Billetera\Movimiento#bono does not contain the required 'inversedBy="bonoMovimientos"' attribute.
App\Entity\Billetera\EstadoBono	No errors.
App\Entity\Billetera\TipoCalculoDescuento	No errors.
App\Entity\Billetera\TipoBono	No errors.

Symfony Profiler

GET https://rifu.iridian.co/api/service/bonos/saldo/expire

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

tenant connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

tenant entity manager