Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

7.36 ms Query time

0 Invalid entities

0 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

1.57 ms

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

Parameters:

[
  "apply"
]

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 = 'apply';

#	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)

5.79 ms

SELECT t0.id AS id_1, t0.name_sei AS name_sei_2, t0.name_mei AS name_mei_3, t0.name_sei_k AS name_sei_k_4, t0.name_mei_k AS name_mei_k_5, t0.birthday AS birthday_6, t0.sex AS sex_7, t0.zipcode AS zipcode_8, t0.address1 AS address1_9, t0.address2 AS address2_10, t0.address3 AS address3_11, t0.tel_mobile AS tel_mobile_12, t0.tel AS tel_13, t0.email_mobile AS email_mobile_14, t0.internet_flg AS internet_flg_15, t0.email_pc AS email_pc_16, t0.history_flg AS history_flg_17, t0.keii AS keii_18, t0.keiietc AS keiietc_19, t0.syoukaisya AS syoukaisya_20, t0.password AS password_21, t0.salt AS salt_22, t0.line_id AS line_id_23, t0.enabled AS enabled_24, t0.last_login_datetime AS last_login_datetime_25, t0.regist_confirmed AS regist_confirmed_26, t0.staff_basic_info_id AS staff_basic_info_id_27, t0.send_mail_flg AS send_mail_flg_28, t0.inquiry AS inquiry_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.state AS state_32 FROM staff t0 WHERE t0.email_mobile = ? LIMIT 2

Parameters:

[
  "testing@example.com"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name_sei AS name_sei_2,
  t0.name_mei AS name_mei_3,
  t0.name_sei_k AS name_sei_k_4,
  t0.name_mei_k AS name_mei_k_5,
  t0.birthday AS birthday_6,
  t0.sex AS sex_7,
  t0.zipcode AS zipcode_8,
  t0.address1 AS address1_9,
  t0.address2 AS address2_10,
  t0.address3 AS address3_11,
  t0.tel_mobile AS tel_mobile_12,
  t0.tel AS tel_13,
  t0.email_mobile AS email_mobile_14,
  t0.internet_flg AS internet_flg_15,
  t0.email_pc AS email_pc_16,
  t0.history_flg AS history_flg_17,
  t0.keii AS keii_18,
  t0.keiietc AS keiietc_19,
  t0.syoukaisya AS syoukaisya_20,
  t0.password AS password_21,
  t0.salt AS salt_22,
  t0.line_id AS line_id_23,
  t0.enabled AS enabled_24,
  t0.last_login_datetime AS last_login_datetime_25,
  t0.regist_confirmed AS regist_confirmed_26,
  t0.staff_basic_info_id AS staff_basic_info_id_27,
  t0.send_mail_flg AS send_mail_flg_28,
  t0.inquiry AS inquiry_29,
  t0.created_at AS created_at_30,
  t0.updated_at AS updated_at_31,
  t0.state AS state_32
FROM
  staff t0
WHERE
  t0.email_mobile = ?
LIMIT
  2

SELECT t0.id AS id_1, t0.name_sei AS name_sei_2, t0.name_mei AS name_mei_3, t0.name_sei_k AS name_sei_k_4, t0.name_mei_k AS name_mei_k_5, t0.birthday AS birthday_6, t0.sex AS sex_7, t0.zipcode AS zipcode_8, t0.address1 AS address1_9, t0.address2 AS address2_10, t0.address3 AS address3_11, t0.tel_mobile AS tel_mobile_12, t0.tel AS tel_13, t0.email_mobile AS email_mobile_14, t0.internet_flg AS internet_flg_15, t0.email_pc AS email_pc_16, t0.history_flg AS history_flg_17, t0.keii AS keii_18, t0.keiietc AS keiietc_19, t0.syoukaisya AS syoukaisya_20, t0.password AS password_21, t0.salt AS salt_22, t0.line_id AS line_id_23, t0.enabled AS enabled_24, t0.last_login_datetime AS last_login_datetime_25, t0.regist_confirmed AS regist_confirmed_26, t0.staff_basic_info_id AS staff_basic_info_id_27, t0.send_mail_flg AS send_mail_flg_28, t0.inquiry AS inquiry_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.state AS state_32 FROM staff t0 WHERE t0.email_mobile = 'testing@example.com' LIMIT 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 972)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 156)
4	Symfony\Bridge\Doctrine\Validator\Constraints\UniqueEntityValidator->validate (line 752)
5	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 485)
6	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 301)
7	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 131)
8	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 108)
9	Symfony\Component\Form\Extension\Validator\Constraints\FormValidator->validate (line 752)
10	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateInGroup (line 485)
11	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateClassNode (line 301)
12	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validateObject (line 131)
13	Symfony\Component\Validator\Validator\RecursiveContextualValidator->validate (line 87)
14	Symfony\Component\Validator\Validator\RecursiveValidator->validate (line 61)
15	Symfony\Component\Validator\Validator\TraceableValidator->validate (line 49)
16	Symfony\Component\Form\Extension\Validator\EventListener\ValidationListener->validateForm (line 220)
17	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
18	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 30)
19	Symfony\Component\EventDispatcher\ImmutableEventDispatcher->dispatch (line 591)
20	Symfony\Component\Form\Form->submit (line 110)
21	Symfony\Component\Form\Extension\HttpFoundation\HttpFoundationRequestHandler->handleRequest (line 420)
22	Symfony\Component\Form\Form->handleRequest (line 77)
23	Kzl\JPowerWebBundle\Controller\ApplyStaffController->indexAction (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
staffmng	doctrine.dbal.staffmng_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
staffmng	doctrine.orm.staffmng_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects

staffmng entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

Class	Mapping errors
Kzl\FrameworkBundle\Entity\Tenant	No errors.
Kzl\JPowerWebBundle\Entity\Staff	No errors.

staffmng entity manager

No loaded entities.

Symfony Profiler

POST https://j-web-dev.kuzilla.co.jp/web/apply/entry

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

staffmng entity manager

Entities Mapping

default entity manager

staffmng entity manager