Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

96.98 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲

Time

Info

19.97 ms

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)

18.88 ms

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)

18.95 ms

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)

tenant connection

#▲	Time	Info
1	19.56 ms	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;
2	19.63 ms	SELECT c0_.iso AS iso_0, c0_.symbol AS symbol_1 FROM currency c0_ Parameters: [] View formatted query View runnable query Explain query SELECT c0_.iso AS iso_0, c0_.symbol AS symbol_1 FROM currency c0_ SELECT c0_.iso AS iso_0, c0_.symbol AS symbol_1 FROM currency c0_;

#▲

Time

Info

19.56 ms

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;

19.63 ms

SELECT c0_.iso AS iso_0, c0_.symbol AS symbol_1 FROM currency c0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  c0_.iso AS iso_0,
  c0_.symbol AS symbol_1
FROM
  currency c0_

SELECT c0_.iso AS iso_0, c0_.symbol AS symbol_1 FROM currency c0_;

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\General\Currency	No errors.

Symfony Profiler

GET https://rifu.iridian.co/api/public/currencies

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

tenant connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

tenant entity manager