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

Query Metrics

10 Database Queries
10 Different statements
6.35 ms Query time
0 Invalid entities
7 Managed entities

Queries

Group similar statements

# Time Info
1 0.49 ms
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"
]
2 0.96 ms
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
]
3 0.89 ms
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.12"
  "019e6426-2e95-7a6a-8708-1cd525829819"
  1
]
4 0.47 ms
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
]
5 0.58 ms
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-3888-7873-8fbc-f8518544c7d4"
  1
]
6 0.15 ms
"START TRANSACTION"
Parameters:
[]
7 0.52 ms
INSERT INTO log (date, action, comment, user_info, request_ip, entity_type, entity_description, entity_id, latest) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "2026-06-08 15:44:52"
  2
  ""
  "Symfony HttpClient (Curl)"
  "185.179.196.109"
  "ip"
  "172.19.0.12"
  "019e745c-3888-7873-8fbc-f8518544c7d4"
  1
]
8 0.46 ms
UPDATE ip SET is_reserved = ?, client_id = ? WHERE id = ?
Parameters:
[
  0
  null
  "019e745c-3888-7873-8fbc-f8518544c7d4"
]
9 0.26 ms
UPDATE log SET latest = ? WHERE id = ?
Parameters:
[
  0
  348
]
10 1.58 ms
"COMMIT"
Parameters:
[]

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.