Symfony Profiler

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;

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;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  n0_.id AS id_0,
  n0_.ip_mask AS ip_mask_1,
  n0_.description AS description_2,
  n0_.type AS type_3,
  n0_.first_ip AS first_ip_4,
  n0_.last_ip AS last_ip_5,
  n0_.gateway AS gateway_6,
  n0_.last_ip_offset AS last_ip_offset_7,
  n0_.shared AS shared_8
FROM
  network n0_
  INNER JOIN network_provider n1_ ON (
    n0_.id = n1_.network_id
    AND n1_.provider_id = ?
  )
WHERE
  n0_.type = ?
  AND n0_.ip_mask IN (?) FOR
UPDATE

SELECT n0_.id AS id_0, n0_.ip_mask AS ip_mask_1, n0_.description AS description_2, n0_.type AS type_3, n0_.first_ip AS first_ip_4, n0_.last_ip AS last_ip_5, n0_.gateway AS gateway_6, n0_.last_ip_offset AS last_ip_offset_7, n0_.shared AS shared_8 FROM network n0_ INNER JOIN network_provider n1_ ON (n0_.id = n1_.network_id AND n1_.provider_id = '019e6425-de44-7d2a-8007-75fb30cb71df') WHERE n0_.type = 'ipv4' AND n0_.ip_mask IN ('172.19.0.1/24') FOR UPDATE;

SELECT
  n0_.id AS id_0,
  n0_.ip_mask AS ip_mask_1,
  n0_.description AS description_2,
  n0_.type AS type_3,
  n0_.first_ip AS first_ip_4,
  n0_.last_ip AS last_ip_5,
  n0_.gateway AS gateway_6,
  n0_.last_ip_offset AS last_ip_offset_7,
  n0_.shared AS shared_8
FROM
  network n0_
  INNER JOIN network_provider n1_ ON (
    n0_.id = n1_.network_id
    AND n1_.provider_id = ?
  )
WHERE
  n0_.type = ?
  AND n0_.ip_mask IN (?) FOR
UPDATE

SELECT n0_.id AS id_0, n0_.ip_mask AS ip_mask_1, n0_.description AS description_2, n0_.type AS type_3, n0_.first_ip AS first_ip_4, n0_.last_ip AS last_ip_5, n0_.gateway AS gateway_6, n0_.last_ip_offset AS last_ip_offset_7, n0_.shared AS shared_8 FROM network n0_ INNER JOIN network_provider n1_ ON (n0_.id = n1_.network_id AND n1_.provider_id = '019e6425-de44-7d2a-8007-75fb30cb71df') WHERE n0_.type = 'ipv4' AND n0_.ip_mask IN ('172.19.0.1/24') FOR UPDATE;

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;

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.is_reserved AS is_reserved_3,
  t0.is_subnet AS is_subnet_4,
  t0.subnet_cidr AS subnet_cidr_5,
  t0.connection_limits AS connection_limits_6,
  t0.network_id AS network_id_7,
  t0.client_id AS client_id_8,
  t0.vlan_id AS vlan_id_9
FROM
  ip t0
WHERE
  t0.network_id = ?

SELECT t0.id AS id_1, t0.address AS address_2, t0.is_reserved AS is_reserved_3, t0.is_subnet AS is_subnet_4, t0.subnet_cidr AS subnet_cidr_5, t0.connection_limits AS connection_limits_6, t0.network_id AS network_id_7, t0.client_id AS client_id_8, t0.vlan_id AS vlan_id_9 FROM ip t0 WHERE t0.network_id = 1;

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;

SELECT
  t0.id AS id_1,
  t0.address AS address_2,
  t0.is_reserved AS is_reserved_3,
  t0.is_subnet AS is_subnet_4,
  t0.subnet_cidr AS subnet_cidr_5,
  t0.connection_limits AS connection_limits_6,
  t0.network_id AS network_id_7,
  t0.client_id AS client_id_8,
  t0.vlan_id AS vlan_id_9
FROM
  ip t0
WHERE
  t0.network_id = ?

SELECT t0.id AS id_1, t0.address AS address_2, t0.is_reserved AS is_reserved_3, t0.is_subnet AS is_subnet_4, t0.subnet_cidr AS subnet_cidr_5, t0.connection_limits AS connection_limits_6, t0.network_id AS network_id_7, t0.client_id AS client_id_8, t0.vlan_id AS vlan_id_9 FROM ip t0 WHERE t0.network_id = 1;

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_.network_id = ?
  AND i0_.is_reserved = ?
LIMIT
  1 FOR
UPDATE

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_.network_id = 1 AND i0_.is_reserved = 0 LIMIT 1 FOR UPDATE;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

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

UPDATE ip SET is_reserved = 1, client_id = '019e6426-2e95-7a6a-8708-1cd525829819' WHERE id = '019e87a3-27ef-73e9-adae-900128e21665';

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

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 = '019e87a3-27ef-73e9-adae-900128e21665' AND t0.latest = 1;

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

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:59', 1, 'Tunnel client IP: skr.dev.gs2seek4dp.net', 'Symfony HttpClient (Curl)', '185.179.196.109', 'ip', '172.19.0.31', '019e87a3-27ef-73e9-adae-900128e21665', 1);

UPDATE
  log
SET
  latest = ?
WHERE
  id = ?

UPDATE log SET latest = 0 WHERE id = 149;

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

"COMMIT"

"COMMIT";