Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

7.93 ms Query time

0 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.39 ms
(30.07%)

UPDATE log SET latest = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  log
SET
  latest = ?
WHERE
  id = ?

UPDATE log SET latest = 0 WHERE id = 350;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\LogService->logIpUpdate (line 54)
7	App\Controller\ApiClient\IpController->setFree (line 205)
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)

1.38 ms
(17.36%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\LogService->logIpUpdate (line 54)
4	App\Controller\ApiClient\IpController->setFree (line 205)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	require_once (line 5)

1.12 ms
(14.16%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.client_user AS client_user_3, t0.provider_id AS provider_id_4 FROM `clients` t0 WHERE t0.client_user = ? LIMIT 1

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.client_user AS client_user_3,
  t0.provider_id AS provider_id_4
FROM
  `clients` t0
WHERE
  t0.client_user = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.client_user AS client_user_3, t0.provider_id AS provider_id_4 FROM `clients` t0 WHERE t0.client_user = 3 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\ClientRepository->findOneByUserId (line 38)
5	App\Security\TokenAuthenticator->authenticate (line 70)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
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 126)
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)

0.79 ms
(10.02%)

SELECT i0_.id AS id_0, i0_.address AS address_1, i0_.is_reserved AS is_reserved_2, i0_.is_subnet AS is_subnet_3, i0_.subnet_cidr AS subnet_cidr_4, i0_.connection_limits AS connection_limits_5, i0_.network_id AS network_id_6, i0_.client_id AS client_id_7, i0_.vlan_id AS vlan_id_8 FROM ip i0_ WHERE i0_.address IN (?) AND i0_.client_id = ? AND i0_.is_reserved = ?

Parameters:

[
  "172.19.0.14"
  "019e6426-2e95-7a6a-8708-1cd525829819"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.address AS address_1,
  i0_.is_reserved AS is_reserved_2,
  i0_.is_subnet AS is_subnet_3,
  i0_.subnet_cidr AS subnet_cidr_4,
  i0_.connection_limits AS connection_limits_5,
  i0_.network_id AS network_id_6,
  i0_.client_id AS client_id_7,
  i0_.vlan_id AS vlan_id_8
FROM
  ip i0_
WHERE
  i0_.address IN (?)
  AND i0_.client_id = ?
  AND i0_.is_reserved = ?

SELECT i0_.id AS id_0, i0_.address AS address_1, i0_.is_reserved AS is_reserved_2, i0_.is_subnet AS is_subnet_3, i0_.subnet_cidr AS subnet_cidr_4, i0_.connection_limits AS connection_limits_5, i0_.network_id AS network_id_6, i0_.client_id AS client_id_7, i0_.vlan_id AS vlan_id_8 FROM ip i0_ WHERE i0_.address IN ('172.19.0.14') AND i0_.client_id = '019e6426-2e95-7a6a-8708-1cd525829819' AND i0_.is_reserved = 1;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\IpRepository->findByAddressesAndClient (line 86)
7	App\Controller\ApiClient\IpController->setIPsFree (line 36)
8	App\Controller\ApiClient\IpController->setFree (line 204)
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.51 ms
(6.45%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.action AS action_3, t0.comment AS comment_4, t0.user_info AS user_info_5, t0.request_ip AS request_ip_6, t0.entity_type AS entity_type_7, t0.entity_description AS entity_description_8, t0.entity_id AS entity_id_9, t0.latest AS latest_10 FROM log t0 WHERE t0.entity_id = ? AND t0.latest = ?

Parameters:

[
  "019e745c-42fb-7299-9ce9-0fc20b0603ba"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.action AS action_3,
  t0.comment AS comment_4,
  t0.user_info AS user_info_5,
  t0.request_ip AS request_ip_6,
  t0.entity_type AS entity_type_7,
  t0.entity_description AS entity_description_8,
  t0.entity_id AS entity_id_9,
  t0.latest AS latest_10
FROM
  log t0
WHERE
  t0.entity_id = ?
  AND t0.latest = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.action AS action_3, t0.comment AS comment_4, t0.user_info AS user_info_5, t0.request_ip AS request_ip_6, t0.entity_type AS entity_type_7, t0.entity_description AS entity_description_8, t0.entity_id AS entity_id_9, t0.latest AS latest_10 FROM log t0 WHERE t0.entity_id = '019e745c-42fb-7299-9ce9-0fc20b0603ba' AND t0.latest = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	App\Repository\LogRepository->findLatestById (line 35)
5	App\Service\LogService->logIpUpdate (line 49)
6	App\Controller\ApiClient\IpController->setFree (line 205)
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.47 ms
(5.91%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_id AS token_id_5, t0.token_password AS token_password_6 FROM `users` t0 WHERE t0.token_id = ? LIMIT 1

Parameters:

[
  "68j2fkpfmd9dks78qwm1nx5gbh"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.token_id AS token_id_5,
  t0.token_password AS token_password_6
FROM
  `users` t0
WHERE
  t0.token_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.token_id AS token_id_5, t0.token_password AS token_password_6 FROM `users` t0 WHERE t0.token_id = '68j2fkpfmd9dks78qwm1nx5gbh' 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\UserRepository->findOneByTokenId (line 34)
5	App\Security\TokenAuthenticator->authenticate (line 51)
6	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 74)
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 126)
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)

0.38 ms
(4.75%)

UPDATE ip SET is_reserved = ?, client_id = ? WHERE id = ?

Parameters:

[
  0
  null
  "019e745c-42fb-7299-9ce9-0fc20b0603ba"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  ip
SET
  is_reserved = ?,
  client_id = ?
WHERE
  id = ?

UPDATE ip SET is_reserved = 0, client_id = NULL WHERE id = '019e745c-42fb-7299-9ce9-0fc20b0603ba';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 494)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 378)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1140)
4	Doctrine\ORM\UnitOfWork->commit (line 408)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\LogService->logIpUpdate (line 54)
7	App\Controller\ApiClient\IpController->setFree (line 205)
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.36 ms
(4.57%)

INSERT INTO log (date, action, comment, user_info, request_ip, entity_type, entity_description, entity_id, latest) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-06-08 15:44:51"
  2
  ""
  "Symfony HttpClient (Curl)"
  "185.179.196.109"
  "ip"
  "172.19.0.14"
  "019e745c-42fb-7299-9ce9-0fc20b0603ba"
  1
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO log (
  date, action, comment, user_info, request_ip,
  entity_type, entity_description,
  entity_id, latest
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO log (date, action, comment, user_info, request_ip, entity_type, entity_description, entity_id, latest) VALUES ('2026-06-08 15:44:51', 2, '', 'Symfony HttpClient (Curl)', '185.179.196.109', 'ip', '172.19.0.14', '019e745c-42fb-7299-9ce9-0fc20b0603ba', 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 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\LogService->logIpUpdate (line 54)
7	App\Controller\ApiClient\IpController->setFree (line 205)
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.36 ms
(4.53%)

SELECT t0.id AS id_1, t0.ip_mask AS ip_mask_2, t0.description AS description_3, t0.type AS type_4, t0.first_ip AS first_ip_5, t0.last_ip AS last_ip_6, t0.gateway AS gateway_7, t0.last_ip_offset AS last_ip_offset_8, t0.shared AS shared_9 FROM network t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.ip_mask AS ip_mask_2,
  t0.description AS description_3,
  t0.type AS type_4,
  t0.first_ip AS first_ip_5,
  t0.last_ip AS last_ip_6,
  t0.gateway AS gateway_7,
  t0.last_ip_offset AS last_ip_offset_8,
  t0.shared AS shared_9
FROM
  network t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.ip_mask AS ip_mask_2, t0.description AS description_3, t0.type AS type_4, t0.first_ip AS first_ip_5, t0.last_ip AS last_ip_6, t0.gateway AS gateway_7, t0.last_ip_offset AS last_ip_offset_8, t0.shared AS shared_9 FROM network t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Network::getFirstIp (line 105)
5	App\Controller\ApiClient\IpController->setIPsFree (line 52)
6	App\Controller\ApiClient\IpController->setFree (line 204)
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.17 ms
(2.18%)

"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 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\LogService->logIpUpdate (line 54)
4	App\Controller\ApiClient\IpController->setFree (line 205)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 193)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 32)
10	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\Log	2
App\Entity\User	1
App\Entity\Client	1
App\Entity\Provider	1
App\Entity\Ip	1
App\Entity\Network	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Client	No errors.
App\Entity\Provider	No errors.
App\Entity\Ip	No errors.
App\Entity\Log	No errors.
App\Entity\Network	No errors.
App\Entity\VlanIp	No errors.

Symfony Profiler

POST https://ip.gp.dev.cdnnow.net/api/client/v1/ips/set_free

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping