Symfony Profiler

Query Metrics

7 Database Queries

6 Different statements

4.19 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.38 ms
(32.99%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 434)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\Tracking\TrackingHubService->writeLog (line 175)
4	App\Service\Tracking\TrackingHubService->track (line 80)
5	App\Controller\Api\TrackingHubApiController->track (line 60)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

1.02 ms
(24.29%)

INSERT INTO tracking_log (tracking_number, carrier, provider, status, error_code, duration_ms, ip, created_at, api_client_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "1Z31E3Y60312335073"
  "ups"
  "shippo"
  "pending"
  null
  657
  null
  "2026-06-13 05:45:06"
  1
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO tracking_log (
  tracking_number, carrier, provider,
  status, error_code, duration_ms,
  ip, created_at, api_client_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO tracking_log (tracking_number, carrier, provider, status, error_code, duration_ms, ip, created_at, api_client_id) VALUES ('1Z31E3Y60312335073', 'ups', 'shippo', 'pending', NULL, 657, NULL, '2026-06-13 05:45:06', 1);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1061)
4	Doctrine\ORM\UnitOfWork->commit (line 404)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\Tracking\TrackingHubService->writeLog (line 175)
7	App\Service\Tracking\TrackingHubService->track (line 80)
8	App\Controller\Api\TrackingHubApiController->track (line 60)
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.54 ms
(12.78%)

SELECT t0.`key` AS key_1, t0.value AS value_2 FROM app_setting t0 WHERE t0.`key` = ?

Parameters:

[
  "tracking_hub_settings"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.`key` AS key_1,
  t0.value AS value_2
FROM
  app_setting t0
WHERE
  t0.`key` = ?

SELECT t0.`key` AS key_1, t0.value AS value_2 FROM app_setting t0 WHERE t0.`key` = 'tracking_hub_settings';

#	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\ServiceEntityRepositoryProxy->find (line 61)
6	App\Repository\AppSettingRepository->findByKey (line 23)
7	App\Repository\AppSettingRepository->getValue (line 28)
8	App\Settings\TrackingHubSettingsResolver->__construct (line 17)
9	ContainerMcCTGT5\getTrackingHubSettingsResolverService->do (line 23)
10	ContainerMcCTGT5\App_KernelDevDebugContainer::load (line 505)
11	ContainerMcCTGT5\getFedexDirectProviderService->do (line 25)
12	ContainerMcCTGT5\App_KernelDevDebugContainer::load (line 505)
13	ContainerMcCTGT5\getTrackingHubServiceService->ContainerMcCTGT5\{closure} (line 24)
14	App\Service\Tracking\TrackingHubService::__construct (line 27)
15	ContainerMcCTGT5\getTrackingHubServiceService->do (line 23)
16	ContainerMcCTGT5\App_KernelDevDebugContainer::load (line 505)
17	ContainerMcCTGT5\getTrackingHubApiControllerService->do (line 25)
18	ContainerMcCTGT5\App_KernelDevDebugContainer::load (line 505)
19	Symfony\Component\DependencyInjection\Container->make (line 221)
20	Symfony\Component\DependencyInjection\Container::get (line 203)
21	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
22	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
23	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
24	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
25	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
28	Symfony\Component\HttpKernel\Kernel->handle (line 193)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
30	require_once (line 32)
31	require_once (line 5)

0.52 ms
(12.35%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 383)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\Tracking\TrackingHubService->writeLog (line 175)
4	App\Service\Tracking\TrackingHubService->track (line 80)
5	App\Controller\Api\TrackingHubApiController->track (line 60)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 193)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

0.50 ms
(12.04%)

SELECT t0.id AS id_1, t0.carrier AS carrier_2, t0.provider AS provider_3, t0.enabled AS enabled_4, t0.priority AS priority_5, t0.note AS note_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM carrier_provider_route t0 WHERE t0.carrier = ? AND t0.enabled = ? LIMIT 1

Parameters:

[
  "ups"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.carrier AS carrier_2,
  t0.provider AS provider_3,
  t0.enabled AS enabled_4,
  t0.priority AS priority_5,
  t0.note AS note_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  carrier_provider_route t0
WHERE
  t0.carrier = ?
  AND t0.enabled = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.carrier AS carrier_2, t0.provider AS provider_3, t0.enabled AS enabled_4, t0.priority AS priority_5, t0.note AS note_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM carrier_provider_route t0 WHERE t0.carrier = 'ups' AND t0.enabled = 1 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\CarrierProviderRouteRepository->findByCarrier (line 23)
5	App\Service\Tracking\TrackingHubService->queueWhereparcelTrack (line 109)
6	App\Controller\Api\TrackingHubApiController->track (line 49)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.23 ms
(5.54%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.enabled AS enabled_4, t0.rate_limit_per_day AS rate_limit_per_day_5, t0.rate_limit_per_month AS rate_limit_per_month_6, t0.note AS note_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM api_client t0 WHERE t0.api_key = ? LIMIT 1

Parameters:

[
  "244e1ea55690ca9fd9e197ced9e7d207a533f4832d1eef95"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.api_key AS api_key_3,
  t0.enabled AS enabled_4,
  t0.rate_limit_per_day AS rate_limit_per_day_5,
  t0.rate_limit_per_month AS rate_limit_per_month_6,
  t0.note AS note_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  api_client t0
WHERE
  t0.api_key = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.api_key AS api_key_3, t0.enabled AS enabled_4, t0.rate_limit_per_day AS rate_limit_per_day_5, t0.rate_limit_per_month AS rate_limit_per_month_6, t0.note AS note_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM api_client t0 WHERE t0.api_key = '244e1ea55690ca9fd9e197ced9e7d207a533f4832d1eef95' 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\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\ApiClientRepository->findByKey (line 21)
5	App\Security\ApiKeyAuthenticator->authenticate (line 35)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 72)
7	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 185)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 167)
9	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 149)
10	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 38)
11	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 58)
12	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
21	Symfony\Component\HttpKernel\Kernel->handle (line 193)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
23	require_once (line 32)
24	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\ApiClient	1
App\Entity\AppSetting	1
App\Entity\CarrierProviderRoute	1
App\Entity\TrackingLog	1

Entities Mapping

Class	Mapping errors
App\Entity\ApiClient	No errors.
App\Entity\AppSetting	No errors.
App\Entity\CarrierProviderRoute	No errors.
App\Entity\TrackingLog	No errors.

Symfony Profiler

GET http://tracking.ecopanel.pw/api/v1/track/1Z31E3Y60312335073?carrier=ups&s=%2F%2Fapi%2Fv1%2Ftrack%2F1Z31E3Y60312335073

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping