Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.98 ms Query time

1 Invalid entities

Queries

Group similar statements

default connection

#▲

Time

Info

0.54 ms

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.50 ms

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)

tenant connection

#▲	Time	Info
1	2.94 ms	SELECT t0.id AS id_1, t0.guid AS guid_2, t0.source AS source_3, t0.external_id AS external_id_4, t0.name AS name_5, t0.spots AS spots_6, t0.is_active AS is_active_7, t0.training_type AS training_type_8, t0.site_id AS site_id_9 FROM room t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.guid AS guid_2, t0.source AS source_3, t0.external_id AS external_id_4, t0.name AS name_5, t0.spots AS spots_6, t0.is_active AS is_active_7, t0.training_type AS training_type_8, t0.site_id AS site_id_9 FROM room t0 SELECT t0.id AS id_1, t0.guid AS guid_2, t0.source AS source_3, t0.external_id AS external_id_4, t0.name AS name_5, t0.spots AS spots_6, t0.is_active AS is_active_7, t0.training_type AS training_type_8, t0.site_id AS site_id_9 FROM room t0;

#▲

Time

Info

2.94 ms

SELECT t0.id AS id_1, t0.guid AS guid_2, t0.source AS source_3, t0.external_id AS external_id_4, t0.name AS name_5, t0.spots AS spots_6, t0.is_active AS is_active_7, t0.training_type AS training_type_8, t0.site_id AS site_id_9 FROM room t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.guid AS guid_2,
  t0.source AS source_3,
  t0.external_id AS external_id_4,
  t0.name AS name_5,
  t0.spots AS spots_6,
  t0.is_active AS is_active_7,
  t0.training_type AS training_type_8,
  t0.site_id AS site_id_9
FROM
  room t0

SELECT t0.id AS id_1, t0.guid AS guid_2, t0.source AS source_3, t0.external_id AS external_id_4, t0.name AS name_5, t0.spots AS spots_6, t0.is_active AS is_active_7, t0.training_type AS training_type_8, t0.site_id AS site_id_9 FROM room t0;

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

Class	Mapping errors
App\Entity\Tenant\Room	No errors.
App\Entity\Tenant\Site	No errors.
App\Entity\Tenant\Lesson	The mappings App\Entity\Tenant\Lesson#trainingVersion and App\Entity\Tenant\TrainingVersion#lessons are inconsistent with each other.

default entity manager

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

Symfony Profiler

GET https://acc.jezzr.com/api/config

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

tenant connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

tenant entity manager

default entity manager