Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

25.62 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

#▲

Time

Info

2.02 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.name AS name_5, t0.avatar_url AS avatar_url_6, t0.token_version AS token_version_7, t0.roles AS roles_8, t0.password_change_date AS password_change_date_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.enabled AS enabled_15 FROM admin t0 WHERE t0.username = ? AND t0.enabled = ? AND t0.deleted_at IS NULL LIMIT 1

Parameters:

[
  "developers@eboost.vn"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.avatar_url AS avatar_url_6,
  t0.token_version AS token_version_7,
  t0.roles AS roles_8,
  t0.password_change_date AS password_change_date_9,
  t0.fp_token AS fp_token_10,
  t0.fp_token_expires_at AS fp_token_expires_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.enabled AS enabled_15
FROM
  admin t0
WHERE
  t0.username = ?
  AND t0.enabled = ?
  AND t0.deleted_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.name AS name_5, t0.avatar_url AS avatar_url_6, t0.token_version AS token_version_7, t0.roles AS roles_8, t0.password_change_date AS password_change_date_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.enabled AS enabled_15 FROM admin t0 WHERE t0.username = 'developers@eboost.vn' AND t0.enabled = 1 AND t0.deleted_at IS NULL LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 43)
4	App\EventListener\JWTDecodedListener->onJWTDecoded (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 142)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 141)
9	Lexik\Bundle\JWTAuthenticationBundle\Services\JWTManager->parse (line 44)
10	App\Security\JwtUserAuthenticator->authenticate (line 68)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
15	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
16	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
17	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
18	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
19	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
20	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
21	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
23	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 142)
24	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

1.33 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.name AS name_5, t0.avatar_url AS avatar_url_6, t0.token_version AS token_version_7, t0.roles AS roles_8, t0.password_change_date AS password_change_date_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.enabled AS enabled_15 FROM admin t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "developers@eboost.vn"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.avatar_url AS avatar_url_6,
  t0.token_version AS token_version_7,
  t0.roles AS roles_8,
  t0.password_change_date AS password_change_date_9,
  t0.fp_token AS fp_token_10,
  t0.fp_token_expires_at AS fp_token_expires_at_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.deleted_at AS deleted_at_14,
  t0.enabled AS enabled_15
FROM
  admin t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.password AS password_4, t0.name AS name_5, t0.avatar_url AS avatar_url_6, t0.token_version AS token_version_7, t0.roles AS roles_8, t0.password_change_date AS password_change_date_9, t0.fp_token AS fp_token_10, t0.fp_token_expires_at AS fp_token_expires_at_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.deleted_at AS deleted_at_14, t0.enabled AS enabled_15 FROM admin t0 WHERE t0.username = 'developers@eboost.vn' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 240)
3	Doctrine\ORM\EntityRepository->findOneBy (line 60)
4	App\Security\JwtUserAuthenticator->authenticate (line 68)
5	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 176)
6	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 142)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

19.63 ms

SELECT e0_.id AS id_0, e0_.order_id AS order_id_1, e0_.invoice_id AS invoice_id_2, e0_.entity_name AS entity_name_3, e0_.entity_id AS entity_id_4, e0_.invoice_sign_status AS invoice_sign_status_5, e0_.profile_type AS profile_type_6, e0_.external_id AS external_id_7, e0_.buyer_tax_code AS buyer_tax_code_8, e0_.buyer_email AS buyer_email_9, e0_.buyer_name AS buyer_name_10, e0_.buyer_phone_number AS buyer_phone_number_11, e0_.buyer_address AS buyer_address_12, e0_.user_id AS user_id_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15, e0_.deleted_at AS deleted_at_16 FROM electronic_invoice e0_ WHERE e0_.order_id = ? OR e0_.invoice_id = ? OR e0_.external_id = ? ORDER BY e0_.created_at DESC

Parameters:

[
  "3e84055b-35cc-4bf4-b678-ea2e9f91545c"
  "3e84055b-35cc-4bf4-b678-ea2e9f91545c"
  "3e84055b-35cc-4bf4-b678-ea2e9f91545c"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.order_id AS order_id_1,
  e0_.invoice_id AS invoice_id_2,
  e0_.entity_name AS entity_name_3,
  e0_.entity_id AS entity_id_4,
  e0_.invoice_sign_status AS invoice_sign_status_5,
  e0_.profile_type AS profile_type_6,
  e0_.external_id AS external_id_7,
  e0_.buyer_tax_code AS buyer_tax_code_8,
  e0_.buyer_email AS buyer_email_9,
  e0_.buyer_name AS buyer_name_10,
  e0_.buyer_phone_number AS buyer_phone_number_11,
  e0_.buyer_address AS buyer_address_12,
  e0_.user_id AS user_id_13,
  e0_.created_at AS created_at_14,
  e0_.updated_at AS updated_at_15,
  e0_.deleted_at AS deleted_at_16
FROM
  electronic_invoice e0_
WHERE
  e0_.order_id = ?
  OR e0_.invoice_id = ?
  OR e0_.external_id = ?
ORDER BY
  e0_.created_at DESC

SELECT e0_.id AS id_0, e0_.order_id AS order_id_1, e0_.invoice_id AS invoice_id_2, e0_.entity_name AS entity_name_3, e0_.entity_id AS entity_id_4, e0_.invoice_sign_status AS invoice_sign_status_5, e0_.profile_type AS profile_type_6, e0_.external_id AS external_id_7, e0_.buyer_tax_code AS buyer_tax_code_8, e0_.buyer_email AS buyer_email_9, e0_.buyer_name AS buyer_name_10, e0_.buyer_phone_number AS buyer_phone_number_11, e0_.buyer_address AS buyer_address_12, e0_.user_id AS user_id_13, e0_.created_at AS created_at_14, e0_.updated_at AS updated_at_15, e0_.deleted_at AS deleted_at_16 FROM electronic_invoice e0_ WHERE e0_.order_id = '3e84055b-35cc-4bf4-b678-ea2e9f91545c' OR e0_.invoice_id = '3e84055b-35cc-4bf4-b678-ea2e9f91545c' OR e0_.external_id = '3e84055b-35cc-4bf4-b678-ea2e9f91545c' ORDER BY e0_.created_at DESC;

#	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 734)
7	App\Controller\InvoiceController->getChargingElectronicInvoice (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

2.64 ms

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.invoice_id AS invoice_id_3, t0.entity_name AS entity_name_4, t0.entity_id AS entity_id_5, t0.invoice_sign_status AS invoice_sign_status_6, t0.profile_type AS profile_type_7, t0.external_id AS external_id_8, t0.buyer_tax_code AS buyer_tax_code_9, t0.buyer_email AS buyer_email_10, t0.buyer_name AS buyer_name_11, t0.buyer_phone_number AS buyer_phone_number_12, t0.buyer_address AS buyer_address_13, t0.user_id AS user_id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17 FROM electronic_invoice t0 WHERE t0.id = ?

Parameters:

[
  12859
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.order_id AS order_id_2,
  t0.invoice_id AS invoice_id_3,
  t0.entity_name AS entity_name_4,
  t0.entity_id AS entity_id_5,
  t0.invoice_sign_status AS invoice_sign_status_6,
  t0.profile_type AS profile_type_7,
  t0.external_id AS external_id_8,
  t0.buyer_tax_code AS buyer_tax_code_9,
  t0.buyer_email AS buyer_email_10,
  t0.buyer_name AS buyer_name_11,
  t0.buyer_phone_number AS buyer_phone_number_12,
  t0.buyer_address AS buyer_address_13,
  t0.user_id AS user_id_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.deleted_at AS deleted_at_17
FROM
  electronic_invoice t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.order_id AS order_id_2, t0.invoice_id AS invoice_id_3, t0.entity_name AS entity_name_4, t0.entity_id AS entity_id_5, t0.invoice_sign_status AS invoice_sign_status_6, t0.profile_type AS profile_type_7, t0.external_id AS external_id_8, t0.buyer_tax_code AS buyer_tax_code_9, t0.buyer_email AS buyer_email_10, t0.buyer_name AS buyer_name_11, t0.buyer_phone_number AS buyer_phone_number_12, t0.buyer_address AS buyer_address_13, t0.user_id AS user_id_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.deleted_at AS deleted_at_17 FROM electronic_invoice t0 WHERE t0.id = 12859;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 902)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->refresh (line 2479)
3	Doctrine\ORM\UnitOfWork->doRefresh (line 2440)
4	Doctrine\ORM\UnitOfWork->refresh (line 729)
5	Doctrine\ORM\EntityManager->refresh (line 773)
6	App\Controller\InvoiceController->getChargingElectronicInvoice (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	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\Admin	1
App\Entity\ElectronicInvoice	1

Entities Mapping

Class	Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\Admin	No errors.
App\Entity\ElectronicInvoice	No errors.

Symfony Profiler

GET https://eboost-api-uat.lpnserver.net/api/controller/invoice/charging/3e84055b-35cc-4bf4-b678-ea2e9f91545c

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping