Symfony Profiler

Query Metrics

12 Database Queries

5 Different statements

6.60 ms Query time

0 Invalid entities

15 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.65 ms
(40.13%)

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_name = ? LIMIT 1

Parameters:

[
  "pod_personnel"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.identifier AS identifier_3,
  t0.api_name AS api_name_4,
  t0.created_at AS created_at_5,
  t0.revoked_at AS revoked_at_6,
  t0.type AS type_7,
  t0.url AS url_8
FROM
  api_keys t0
WHERE
  t0.api_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_name = 'pod_personnel' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	Ap2t\Controller\Services\PodSyncService->syncAll (line 43)
7	Ap2t\Controller\Controller\Sysop\ApiKeySyncController->syncAll (line 86)
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 32)
13	require_once (line 5)

2.33 ms
(35.25%)

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM settings t0 WHERE t0.setting_key = ? LIMIT 1

Parameters:

[
  "tierOne_id"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3
FROM
  settings t0
WHERE
  t0.setting_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3 FROM settings t0 WHERE t0.setting_key = 'tierOne_id' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	Ap2t\Controller\Repository\SettingsRepository->getSettingValue (line 36)
7	Ap2t\Controller\Services\PodSyncService->syncPersonnelSettings (line 83)
8	Ap2t\Controller\Services\PodSyncService->syncAll (line 69)
9	Ap2t\Controller\Controller\Sysop\ApiKeySyncController->syncAll (line 86)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

1.04 ms
(15.75%)

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.identifier = ? LIMIT 1

Parameters:

[
  "tierOne-0198e7c1-789b-78ce-9891-a72bba5bc593"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.identifier AS identifier_3,
  t0.api_name AS api_name_4,
  t0.created_at AS created_at_5,
  t0.revoked_at AS revoked_at_6,
  t0.type AS type_7,
  t0.url AS url_8
FROM
  api_keys t0
WHERE
  t0.identifier = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.identifier = 'tierOne-0198e7c1-789b-78ce-9891-a72bba5bc593' LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	Ap2t\Controller\Services\PodSyncService->syncPersonnelSettings (line 85)
7	Ap2t\Controller\Services\PodSyncService->syncAll (line 69)
8	Ap2t\Controller\Controller\Sysop\ApiKeySyncController->syncAll (line 86)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.33 ms
(5.00%)

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_key = ? AND t0.revoked_at IS NULL LIMIT 1

Parameters:

[
  "c338a9b0-461e-43a6-a322-a2454014f465"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.identifier AS identifier_3,
  t0.api_name AS api_name_4,
  t0.created_at AS created_at_5,
  t0.revoked_at AS revoked_at_6,
  t0.type AS type_7,
  t0.url AS url_8
FROM
  api_keys t0
WHERE
  t0.api_key = ?
  AND t0.revoked_at IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0 WHERE t0.api_key = 'c338a9b0-461e-43a6-a322-a2454014f465' AND t0.revoked_at IS NULL LIMIT 1;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingStatementForV4->execute (line 36)
2	Doctrine\DBAL\Connection->executeQuery (line 802)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
4	Doctrine\ORM\EntityRepository->findOneBy (line 125)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
6	LoremIpsumDev\LoremAuthBundle\Service\ApiKeyManager->validateApiKey (line 58)
7	Ap2t\Controller\Controller\Sysop\ApiKeySyncController->syncAll (line 83)
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 32)
13	require_once (line 5)

0.26 ms
(3.87%)

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.api_key AS api_key_2,
  t0.identifier AS identifier_3,
  t0.api_name AS api_name_4,
  t0.created_at AS created_at_5,
  t0.revoked_at AS revoked_at_6,
  t0.type AS type_7,
  t0.url AS url_8
FROM
  api_keys t0

SELECT t0.id AS id_1, t0.api_key AS api_key_2, t0.identifier AS identifier_3, t0.api_name AS api_name_4, t0.created_at AS created_at_5, t0.revoked_at AS revoked_at_6, t0.type AS type_7, t0.url AS url_8 FROM api_keys t0;

#	File/Call
1	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->traceFunction (line 246)
2	Sentry\SentryBundle\Tracing\Doctrine\DBAL\TracingDriverConnectionForV4->query (line 117)
3	Doctrine\DBAL\Connection->executeQuery (line 804)
4	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
5	Doctrine\ORM\EntityRepository->findBy (line 110)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
7	Doctrine\ORM\EntityRepository->findAll (line 96)
8	Ap2t\Controller\Services\PodSyncService->syncAll (line 27)
9	Ap2t\Controller\Controller\Sysop\ApiKeySyncController->syncAll (line 86)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	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
LoremIpsumDev\LoremAuthBundle\Entity\ApiKey	12
Ap2t\Controller\Entity\Settings	3

Entities Mapping

Class	Mapping errors
LoremIpsumDev\LoremAuthBundle\Entity\ApiKey	No errors.
Ap2t\Controller\Entity\Settings	No errors.

Symfony Profiler

POST https://y-0a-ustx-16.test-dev.ing/sysop/update/api-keys/full

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping