Symfony Profiler

Query Metrics

9 Database Queries

9 Different statements

29.38 ms Query time

0 Invalid entities

821 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.14 ms
(31.09%)

SELECT u0_.id AS id_0, u0_.amount AS amount_1, u0_.created_at AS created_at_2, u0_.currency AS currency_3, u0_.account AS account_4, u0_.uid_id AS uid_id_5, u0_.bank_id AS bank_id_6 FROM user_balance u0_ WHERE u0_.uid_id = ? AND u0_.bank_id = ? AND u0_.account = ? ORDER BY u0_.created_at ASC

Parameters:

[
  2
  186
  "LT427044060008188858"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.amount AS amount_1,
  u0_.created_at AS created_at_2,
  u0_.currency AS currency_3,
  u0_.account AS account_4,
  u0_.uid_id AS uid_id_5,
  u0_.bank_id AS bank_id_6
FROM
  user_balance u0_
WHERE
  u0_.uid_id = ?
  AND u0_.bank_id = ?
  AND u0_.account = ?
ORDER BY
  u0_.created_at ASC

SELECT u0_.id AS id_0, u0_.amount AS amount_1, u0_.created_at AS created_at_2, u0_.currency AS currency_3, u0_.account AS account_4, u0_.uid_id AS uid_id_5, u0_.bank_id AS bank_id_6 FROM user_balance u0_ WHERE u0_.uid_id = 2 AND u0_.bank_id = 186 AND u0_.account = 'LT427044060008188858' ORDER BY u0_.created_at ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\AuthController->accountDetail (line 308)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

6.79 ms
(23.10%)

SELECT t0_.id AS id_0, t0_.created_at AS created_at_1, t0_.currency AS currency_2, t0_.amount AS amount_3, t0_.creditor AS creditor_4, t0_.status AS status_5, t0_.reference AS reference_6, t0_.info AS info_7, t0_.debtor AS debtor_8, t0_.operation AS operation_9, t0_.booking_date AS booking_date_10, t0_.value_date AS value_date_11, t0_.excange_rate AS excange_rate_12, t0_.transaction_date AS transaction_date_13, t0_.creditor_iban AS creditor_iban_14, t0_.debtor_iban AS debtor_iban_15, t0_.user_id_id AS user_id_id_16, t0_.bank_id AS bank_id_17, t0_.user_bank_id AS user_bank_id_18, t0_.category_id AS category_id_19 FROM transaction t0_ WHERE t0_.user_id_id = ? AND t0_.user_bank_id = ? ORDER BY t0_.booking_date DESC, t0_.id DESC LIMIT 100

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.created_at AS created_at_1,
  t0_.currency AS currency_2,
  t0_.amount AS amount_3,
  t0_.creditor AS creditor_4,
  t0_.status AS status_5,
  t0_.reference AS reference_6,
  t0_.info AS info_7,
  t0_.debtor AS debtor_8,
  t0_.operation AS operation_9,
  t0_.booking_date AS booking_date_10,
  t0_.value_date AS value_date_11,
  t0_.excange_rate AS excange_rate_12,
  t0_.transaction_date AS transaction_date_13,
  t0_.creditor_iban AS creditor_iban_14,
  t0_.debtor_iban AS debtor_iban_15,
  t0_.user_id_id AS user_id_id_16,
  t0_.bank_id AS bank_id_17,
  t0_.user_bank_id AS user_bank_id_18,
  t0_.category_id AS category_id_19
FROM
  transaction t0_
WHERE
  t0_.user_id_id = ?
  AND t0_.user_bank_id = ?
ORDER BY
  t0_.booking_date DESC,
  t0_.id DESC
LIMIT
  100

SELECT t0_.id AS id_0, t0_.created_at AS created_at_1, t0_.currency AS currency_2, t0_.amount AS amount_3, t0_.creditor AS creditor_4, t0_.status AS status_5, t0_.reference AS reference_6, t0_.info AS info_7, t0_.debtor AS debtor_8, t0_.operation AS operation_9, t0_.booking_date AS booking_date_10, t0_.value_date AS value_date_11, t0_.excange_rate AS excange_rate_12, t0_.transaction_date AS transaction_date_13, t0_.creditor_iban AS creditor_iban_14, t0_.debtor_iban AS debtor_iban_15, t0_.user_id_id AS user_id_id_16, t0_.bank_id AS bank_id_17, t0_.user_bank_id AS user_bank_id_18, t0_.category_id AS category_id_19 FROM transaction t0_ WHERE t0_.user_id_id = 2 AND t0_.user_bank_id = 2 ORDER BY t0_.booking_date DESC, t0_.id DESC LIMIT 100;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Controller\AuthController->accountDetail (line 352)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 191)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

6.45 ms
(21.96%)

SELECT t0_.currency AS currency_0, t0_.operation AS operation_1, SUM(ABS(t0_.amount)) AS sclr_2 FROM transaction t0_ WHERE t0_.user_id_id = ? AND t0_.user_bank_id = ? AND t0_.status = ? GROUP BY t0_.currency, t0_.operation

Parameters:

[
  2
  2
  "BOOK"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.currency AS currency_0,
  t0_.operation AS operation_1,
  SUM(
    ABS(t0_.amount)
  ) AS sclr_2
FROM
  transaction t0_
WHERE
  t0_.user_id_id = ?
  AND t0_.user_bank_id = ?
  AND t0_.status = ?
GROUP BY
  t0_.currency,
  t0_.operation

SELECT t0_.currency AS currency_0, t0_.operation AS operation_1, SUM(ABS(t0_.amount)) AS sclr_2 FROM transaction t0_ WHERE t0_.user_id_id = 2 AND t0_.user_bank_id = 2 AND t0_.status = 'BOOK' GROUP BY t0_.currency, t0_.operation;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getArrayResult (line 700)
6	App\Controller\AuthController->computeTransactionTotals (line 227)
7	App\Controller\AuthController->accountDetail (line 354)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

3.32 ms
(11.30%)

SELECT COUNT(t0_.id) AS sclr_0 FROM transaction t0_ WHERE t0_.user_id_id = ? AND t0_.user_bank_id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  transaction t0_
WHERE
  t0_.user_id_id = ?
  AND t0_.user_bank_id = ?

SELECT COUNT(t0_.id) AS sclr_0 FROM transaction t0_ WHERE t0_.user_id_id = 2 AND t0_.user_bank_id = 2;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Controller\AuthController->accountDetail (line 341)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 191)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.87 ms
(2.95%)

SELECT t0.id AS id_1, t0.iban AS iban_2, t0.obid AS obid_3, t0.session_expire AS session_expire_4, t0.bank_id AS bank_id_5, t0.user_id_id AS user_id_id_6 FROM user_bank t0 WHERE t0.user_id_id = ? AND t0.bank_id = ? AND t0.iban = ? LIMIT 1

Parameters:

[
  2
  186
  "LT427044060008188858"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.iban AS iban_2,
  t0.obid AS obid_3,
  t0.session_expire AS session_expire_4,
  t0.bank_id AS bank_id_5,
  t0.user_id_id AS user_id_id_6
FROM
  user_bank t0
WHERE
  t0.user_id_id = ?
  AND t0.bank_id = ?
  AND t0.iban = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.iban AS iban_2, t0.obid AS obid_3, t0.session_expire AS session_expire_4, t0.bank_id AS bank_id_5, t0.user_id_id AS user_id_id_6 FROM user_bank t0 WHERE t0.user_id_id = 2 AND t0.bank_id = 186 AND t0.iban = 'LT427044060008188858' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findOneBy (line 86)
4	App\Controller\AuthController->accountDetail (line 293)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.75 ms
(2.55%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.avatar AS avatar_6, t0.receipt_forward_email AS receipt_forward_email_7, t0.roles AS roles_8, t0.any_transaction_noty AS any_transaction_noty_9, t0.daily_transaction_noty AS daily_transaction_noty_10, t0.montly_transaction_noty AS montly_transaction_noty_11, t0.use_trust_source AS use_trust_source_12, t0.accid AS accid_13, t0.pemkey AS pemkey_14 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.email AS email_3,
  t0.password AS password_4,
  t0.google_id AS google_id_5,
  t0.avatar AS avatar_6,
  t0.receipt_forward_email AS receipt_forward_email_7,
  t0.roles AS roles_8,
  t0.any_transaction_noty AS any_transaction_noty_9,
  t0.daily_transaction_noty AS daily_transaction_noty_10,
  t0.montly_transaction_noty AS montly_transaction_noty_11,
  t0.use_trust_source AS use_trust_source_12,
  t0.accid AS accid_13,
  t0.pemkey AS pemkey_14
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.password AS password_4, t0.google_id AS google_id_5, t0.avatar AS avatar_6, t0.receipt_forward_email AS receipt_forward_email_7, t0.roles AS roles_8, t0.any_transaction_noty AS any_transaction_noty_9, t0.daily_transaction_noty AS daily_transaction_noty_10, t0.montly_transaction_noty AS montly_transaction_noty_11, t0.use_trust_source AS use_trust_source_12, t0.accid AS accid_13, t0.pemkey AS pemkey_14 FROM `user` t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 97)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 52)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 64)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 88)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 86)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 191)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.71 ms
(2.41%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 ORDER BY t0.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  category t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0 ORDER BY t0.name ASC;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->findBy (line 78)
4	App\Controller\AuthController->accountDetail (line 355)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 191)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

0.70 ms
(2.38%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.logo AS logo_4, t0.bic AS bic_5 FROM bank t0 WHERE t0.id = ?

Parameters:

[
  186
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.country AS country_3,
  t0.logo AS logo_4,
  t0.bic AS bic_5
FROM
  bank t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.country AS country_3, t0.logo AS logo_4, t0.bic AS bic_5 FROM bank t0 WHERE t0.id = 186;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	Twig\Extension\CoreExtension::getAttribute (line 1795)
5	__TwigTemplate_632529bd4743de61a65e96719c0ec3be::block_title (line 77)
6	Twig\Template->yieldBlock (line 446)
7	__TwigTemplate_627b3fe21a82fc910fa52afdd2e835a6->doDisplay (line 59)
8	Twig\Template->yield (line 402)
9	__TwigTemplate_632529bd4743de61a65e96719c0ec3be->doDisplay (line 55)
10	Twig\Template->yield (line 402)
11	Twig\Template->display (line 358)
12	Twig\Template->render (line 373)
13	Twig\TemplateWrapper->render (line 51)
14	Twig\Environment->render (line 333)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 462)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 467)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 279)
18	App\Controller\AuthController->accountDetail (line 357)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 191)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	require_once (line 5)

0.66 ms
(2.26%)

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.currency AS currency_4, t0.account AS account_5, t0.uid_id AS uid_id_6, t0.bank_id AS bank_id_7 FROM user_balance t0 WHERE t0.id = ?

Parameters:

[
  "4007"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.created_at AS created_at_3,
  t0.currency AS currency_4,
  t0.account AS account_5,
  t0.uid_id AS uid_id_6,
  t0.bank_id AS bank_id_7
FROM
  user_balance t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.created_at AS created_at_3, t0.currency AS currency_4, t0.account AS account_5, t0.uid_id AS uid_id_6, t0.bank_id AS bank_id_7 FROM user_balance t0 WHERE t0.id = '4007';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository->find (line 66)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 69)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 91)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 191)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	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
App\Entity\UserBalance	701
App\Entity\Transaction	100
App\Entity\Category	17
App\Entity\User	1
App\Entity\Bank	1
App\Entity\UserBank	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\UserBalance	No errors.
App\Entity\Transaction	No errors.
App\Entity\UserBank	No errors.
App\Entity\UserTrustSource	No errors.
App\Entity\UserContact	No errors.
App\Entity\UserCategory	No errors.
App\Entity\Bank	No errors.
App\Entity\Category	No errors.

Symfony Profiler

GET https://ob.powar.cyou/dashboard/account/4007

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping