Symfony Profiler

Query Metrics

4 Database Queries

3 Different statements

3.05 ms Query time

0 Invalid entities

18 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.09 ms

SELECT t0_.tenant_cd AS tenant_cd_0 FROM tenant t0_ WHERE t0_.subfolder = ?

Parameters:

[
  "login"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.tenant_cd AS tenant_cd_0
FROM
  tenant t0_
WHERE
  t0_.subfolder = ?

SELECT t0_.tenant_cd AS tenant_cd_0 FROM tenant t0_ WHERE t0_.subfolder = 'login';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 997)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 71)
7	Kzl\FrameworkBundle\Repository\TenantRepository->getActiveTenantCd (line 69)
8	Kzl\FrameworkBundle\Service\TenantManager->getTenantCdFromRequest (line 111)
9	Kzl\FrameworkBundle\Service\TenantManager->getTenantCd (line 34)
10	Kzl\FrameworkBundle\EventListener\OnRequestListener->onKernelRequest (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.97 ms

SELECT o0_.organization_code AS organization_code_0, o0_.ip_address AS ip_address_1 FROM organization o0_ WHERE o0_.login_flag = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.organization_code AS organization_code_0,
  o0_.ip_address AS ip_address_1
FROM
  organization o0_
WHERE
  o0_.login_flag = ?

SELECT o0_.organization_code AS organization_code_0, o0_.ip_address AS ip_address_1 FROM organization o0_ WHERE o0_.login_flag = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 72)
7	Jpno1\SaleBundle\Repository\OrganizationRepository->getAccessibleOrganizationIpList (line 154)
8	Jpno1\SaleBundle\Service\OrganizationManager->isAccessibleIp (line 104)
9	App\EventListener\BeforeFilterControllerListener->onKernelController (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 169)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.57 ms

SELECT t0.id AS id_1, t0.key_str AS key_str_2, t0.value_kbn AS value_kbn_3, t0.int_value AS int_value_4, t0.string_value AS string_value_5, t0.date_value AS date_value_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM system_setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.key_str AS key_str_2,
  t0.value_kbn AS value_kbn_3,
  t0.int_value AS int_value_4,
  t0.string_value AS string_value_5,
  t0.date_value AS date_value_6,
  t0.name AS name_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  system_setting t0

SELECT t0.id AS id_1, t0.key_str AS key_str_2, t0.value_kbn AS value_kbn_3, t0.int_value AS int_value_4, t0.string_value AS string_value_5, t0.date_value AS date_value_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM system_setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 45)
5	Jpno1\SaleBundle\Service\SystemManager->initialize (line 37)
6	Jpno1\SaleBundle\Service\SystemManager->__construct (line 2990)
7	ContainerGQOEUBM\App_KernelDevDebugContainer::getTwigService (line 404)
8	Symfony\Component\DependencyInjection\Container->getService (line 40)
9	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 448)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 38)
13	Kzl\BaseBundle\Security\SecurityController->login (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.42 ms

SELECT t0.id AS id_1, t0.key_str AS key_str_2, t0.value_kbn AS value_kbn_3, t0.int_value AS int_value_4, t0.string_value AS string_value_5, t0.date_value AS date_value_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM system_setting t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.key_str AS key_str_2,
  t0.value_kbn AS value_kbn_3,
  t0.int_value AS int_value_4,
  t0.string_value AS string_value_5,
  t0.date_value AS date_value_6,
  t0.name AS name_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  system_setting t0

SELECT t0.id AS id_1, t0.key_str AS key_str_2, t0.value_kbn AS value_kbn_3, t0.int_value AS int_value_4, t0.string_value AS string_value_5, t0.date_value AS date_value_6, t0.name AS name_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM system_setting t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 45)
5	Jpno1\SaleBundle\Service\SystemManager->initialize (line 37)
6	Jpno1\SaleBundle\Service\SystemManager->__construct (line 2992)
7	ContainerGQOEUBM\App_KernelDevDebugContainer::getTwigService (line 404)
8	Symfony\Component\DependencyInjection\Container->getService (line 40)
9	Symfony\Component\DependencyInjection\Argument\ServiceLocator->get (line 448)
10	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
11	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
12	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 38)
13	Kzl\BaseBundle\Security\SecurityController->login (line 181)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_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
Jpno1\SaleBundle\Entity\SystemSetting	18

Entities Mapping

Class	Mapping errors
Kzl\FrameworkBundle\Entity\Tenant	No errors.
Jpno1\SaleBundle\Entity\Organization	No errors.
Jpno1\SaleBundle\Entity\SystemSetting	No errors.

Symfony Profiler

GET https://jpno1.dev.kuzilla.co.jp/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping