Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

1.36 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

0.82 ms
(60.49%)

SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.db_name AS db_name_3, t0.driver_type AS driver_type_4, t0.db_user_name AS db_user_name_5, t0.db_password AS db_password_6, t0.db_host AS db_host_7, t0.db_port AS db_port_8, t0.database_status AS database_status_9 FROM tenant_db_config t0 WHERE t0.hostname = ? LIMIT 1

Parameters:

[
  "acc.jezzr.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hostname AS hostname_2,
  t0.db_name AS db_name_3,
  t0.driver_type AS driver_type_4,
  t0.db_user_name AS db_user_name_5,
  t0.db_password AS db_password_6,
  t0.db_host AS db_host_7,
  t0.db_port AS db_port_8,
  t0.database_status AS database_status_9
FROM
  tenant_db_config t0
WHERE
  t0.hostname = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.db_name AS db_name_3, t0.driver_type AS driver_type_4, t0.db_user_name AS db_user_name_5, t0.db_password AS db_password_6, t0.db_host AS db_host_7, t0.db_port AS db_port_8, t0.database_status AS database_status_9 FROM tenant_db_config t0 WHERE t0.hostname = 'acc.jezzr.com' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 42)
5	App\EventSubscriber\TenantConnectionSwitcher->onKernelRequest (line 115)
6	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
7	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
8	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.54 ms
(39.51%)

SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.db_name AS db_name_3, t0.driver_type AS driver_type_4, t0.db_user_name AS db_user_name_5, t0.db_password AS db_password_6, t0.db_host AS db_host_7, t0.db_port AS db_port_8, t0.database_status AS database_status_9 FROM tenant_db_config t0 WHERE t0.id = ? LIMIT 1

Parameters:

[
  "2"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.hostname AS hostname_2,
  t0.db_name AS db_name_3,
  t0.driver_type AS driver_type_4,
  t0.db_user_name AS db_user_name_5,
  t0.db_password AS db_password_6,
  t0.db_host AS db_host_7,
  t0.db_port AS db_port_8,
  t0.database_status AS database_status_9
FROM
  tenant_db_config t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.hostname AS hostname_2, t0.db_name AS db_name_3, t0.driver_type AS driver_type_4, t0.db_user_name AS db_user_name_5, t0.db_password AS db_password_6, t0.db_host AS db_host_7, t0.db_port AS db_port_8, t0.database_status AS database_status_9 FROM tenant_db_config t0 WHERE t0.id = '2' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 23)
5	Hakam\MultiTenancyBundle\Services\DbConfigService->findDbConfig (line 34)
6	Hakam\MultiTenancyBundle\EventListener\DbSwitchEventListener->onHakamMultiTenancyBundleEventSwitchDbEvent (line 115)
7	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
8	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
9	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 76)
11	App\EventSubscriber\TenantConnectionSwitcher->onKernelRequest (line 115)
12	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
13	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
14	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
15	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

Database Connections

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

Entity Managers

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

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

tenant entity manager

No loaded entities.

default entity manager

Class	Mapping errors
App\Entity\Main\TenantDbConfig	No errors.