Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

7.08 ms Query time

0 Invalid entities

2 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.72 ms
(24.27%)

SELECT
        d.domain,
        COUNT(DISTINCT bch.id) AS bike_charging,
        COUNT(DISTINCT cch.id) AS car_charging,
        COUNT(DISTINCT bch.id) + COUNT(DISTINCT cch.id) AS total_charging
    FROM domain d
    LEFT JOIN bike_charge_history bch
        ON bch.from_instance = d.domain
        AND bch.from_instance IS NOT NULL
        AND bch.status = ?
    LEFT JOIN car_charge_history cch
        ON cch.from_instance = d.domain
        AND cch.from_instance IS NOT NULL
        AND cch.status = ?
    WHERE d.enabled = ?
    AND d.is_fallback = ?
    GROUP BY d.domain
    ORDER BY total_charging DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  d.domain,
  COUNT(DISTINCT bch.id) AS bike_charging,
  COUNT(DISTINCT cch.id) AS car_charging,
  COUNT(DISTINCT bch.id) + COUNT(DISTINCT cch.id) AS total_charging
FROM
  domain d
  LEFT JOIN bike_charge_history bch ON bch.from_instance = d.domain
  AND bch.from_instance IS NOT NULL
  AND bch.status = ?
  LEFT JOIN car_charge_history cch ON cch.from_instance = d.domain
  AND cch.from_instance IS NOT NULL
  AND cch.status = ?
WHERE
  d.enabled = ?
  AND d.is_fallback = ?
GROUP BY
  d.domain
ORDER BY
  total_charging DESC

SELECT
        d.domain,
        COUNT(DISTINCT bch.id) AS bike_charging,
        COUNT(DISTINCT cch.id) AS car_charging,
        COUNT(DISTINCT bch.id) + COUNT(DISTINCT cch.id) AS total_charging
    FROM domain d
    LEFT JOIN bike_charge_history bch
        ON bch.from_instance = d.domain
        AND bch.from_instance IS NOT NULL
        AND bch.status = 0
    LEFT JOIN car_charge_history cch
        ON cch.from_instance = d.domain
        AND cch.from_instance IS NOT NULL
        AND cch.status = 0
    WHERE d.enabled = 1
    AND d.is_fallback = 0
    GROUP BY d.domain
    ORDER BY total_charging DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 141)
2	App\Controller\DomainController->listAvailableDomains (line 181)
3	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
4	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
5	Symfony\Component\HttpKernel\Kernel->handle (line 35)
6	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
7	require_once (line 5)

1.43 ms
(20.18%)

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.36 ms
(19.20%)

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)

1.30 ms
(18.41%)

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.is_fallback AS is_fallback_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.enabled AS enabled_7, t0.tag AS tag_8 FROM domain t0 WHERE t0.enabled = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.is_fallback AS is_fallback_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.enabled AS enabled_7,
  t0.tag AS tag_8
FROM
  domain t0
WHERE
  t0.enabled = ?

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.is_fallback AS is_fallback_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.enabled AS enabled_7, t0.tag AS tag_8 FROM domain t0 WHERE t0.enabled = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 98)
4	App\Controller\DomainController->listAvailableDomains (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	require_once (line 5)

1.27 ms
(17.93%)

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.is_fallback AS is_fallback_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.enabled AS enabled_7, t0.tag AS tag_8 FROM domain t0 WHERE t0.enabled = ? AND t0.is_fallback = ? AND t0.deleted_at IS NULL

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.domain AS domain_2,
  t0.is_fallback AS is_fallback_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.enabled AS enabled_7,
  t0.tag AS tag_8
FROM
  domain t0
WHERE
  t0.enabled = ?
  AND t0.is_fallback = ?
  AND t0.deleted_at IS NULL

SELECT t0.id AS id_1, t0.domain AS domain_2, t0.is_fallback AS is_fallback_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.enabled AS enabled_7, t0.tag AS tag_8 FROM domain t0 WHERE t0.enabled = 1 AND t0.is_fallback = 1 AND t0.deleted_at IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 150)
4	App\Controller\DomainController->listAvailableDomains (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 208)
7	Symfony\Component\HttpKernel\Kernel->handle (line 35)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
9	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\Domain	1

Entities Mapping

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

Symfony Profiler

GET https://eboost-api-uat.lpnserver.net/api/controller/domain/list-available

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping