Symfony Profiler

Query Metrics

3 Database Queries

2 Different statements

0.53 ms Query time

0 Invalid entities

2 Managed entities

Queries

Group similar statements

default connection

#▲

Time

Info

0.30 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "GoogleAuth"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.api_key AS api_key_4,
  t0.auth_token AS auth_token_5,
  t0.headers AS headers_6,
  t0.timeout AS timeout_7,
  t0.max_retry_attempts AS max_retry_attempts_8,
  t0.retry_interval AS retry_interval_9,
  t0.request_parameters AS request_parameters_10,
  t0.response_mapping AS response_mapping_11,
  t0.endpoint AS endpoint_12
FROM
  api_configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = 'GoogleAuth' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Service\GoogleAuth->__construct (line 20)
4	Container91guTnq\getSecurityControllerService->do (line 33)
5	Container91guTnq\App_KernelDevDebugContainer::load (line 710)
6	Symfony\Component\DependencyInjection\Container->make (line 221)
7	Symfony\Component\DependencyInjection\Container::get (line 203)
8	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
9	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
10	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
11	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
12	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
15	Symfony\Component\HttpKernel\Kernel->handle (line 193)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
17	require_once (line 29)
18	require_once (line 5)

0.09 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "FirebaseDesktop"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.api_key AS api_key_4,
  t0.auth_token AS auth_token_5,
  t0.headers AS headers_6,
  t0.timeout AS timeout_7,
  t0.max_retry_attempts AS max_retry_attempts_8,
  t0.retry_interval AS retry_interval_9,
  t0.request_parameters AS request_parameters_10,
  t0.response_mapping AS response_mapping_11,
  t0.endpoint AS endpoint_12
FROM
  api_configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.api_key AS api_key_4, t0.auth_token AS auth_token_5, t0.headers AS headers_6, t0.timeout AS timeout_7, t0.max_retry_attempts AS max_retry_attempts_8, t0.retry_interval AS retry_interval_9, t0.request_parameters AS request_parameters_10, t0.response_mapping AS response_mapping_11, t0.endpoint AS endpoint_12 FROM api_configuration t0 WHERE t0.name = 'FirebaseDesktop' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 779)
2	Doctrine\ORM\EntityRepository->findOneBy (line 240)
3	App\Controller\SecurityController->login (line 81)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 193)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.13 ms

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.html AS html_2, w0_.locale_id AS locale_id_3, w0_.warning_id AS warning_id_4 FROM warning_translation w0_ LEFT JOIN locale l1_ ON w0_.locale_id = l1_.id LEFT JOIN warning w2_ ON w0_.warning_id = w2_.id WHERE (w2_.is_active = ? OR w2_.id IS NULL) AND l1_.name = ? AND w2_.is_public = ? LIMIT 1

Parameters:

[
  1
  "cn"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.html AS html_2,
  w0_.locale_id AS locale_id_3,
  w0_.warning_id AS warning_id_4
FROM
  warning_translation w0_
  LEFT JOIN locale l1_ ON w0_.locale_id = l1_.id
  LEFT JOIN warning w2_ ON w0_.warning_id = w2_.id
WHERE
  (
    w2_.is_active = ?
    OR w2_.id IS NULL
  )
  AND l1_.name = ?
  AND w2_.is_public = ?
LIMIT
  1

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.html AS html_2, w0_.locale_id AS locale_id_3, w0_.warning_id AS warning_id_4 FROM warning_translation w0_ LEFT JOIN locale l1_ ON w0_.locale_id = l1_.id LEFT JOIN warning w2_ ON w0_.warning_id = w2_.id WHERE (w2_.is_active = 1 OR w2_.id IS NULL) AND l1_.name = 'cn' AND w2_.is_public = 1 LIMIT 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 958)
6	App\Repository\WarningTranslationRepository->getByLocale (line 32)
7	App\Controller\SecurityController->login (line 106)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 193)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
log	doctrine.dbal.log_connection

Entity Managers

Name	Service
naming_strategy	doctrine.orm.naming_strategy_entity_manager
default	doctrine.orm.default_entity_manager
log	doctrine.orm.log_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

naming_strategy entity manager

Class	Amount of managed objects

default entity manager

Class	Amount of managed objects
App\Entity\ApiConfiguration	2

log entity manager

Class	Amount of managed objects

Entities Mapping

naming_strategy entity manager

No loaded entities.

default entity manager

Class	Mapping errors
App\Entity\ApiConfiguration	No errors.
App\Entity\WarningTranslation	No errors.
App\Entity\Locale	No errors.
App\Entity\Warning	No errors.

log entity manager

No loaded entities.

Symfony Profiler

GET https://demo.yellowfishtravel.com/cn/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Managed Entities

naming_strategy entity manager

default entity manager

log entity manager

Entities Mapping

naming_strategy entity manager

default entity manager

log entity manager