Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.agent_id AS agent_id_2,
  t0.token_hash AS token_hash_3,
  t0.active AS active_4,
  t0.last_seen_at AS last_seen_at_5,
  t0.created_at AS created_at_6,
  t0.location_id AS location_id_7
FROM
  agent t0
WHERE
  t0.token_hash = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.agent_id AS agent_id_2, t0.token_hash AS token_hash_3, t0.active AS active_4, t0.last_seen_at AS last_seen_at_5, t0.created_at AS created_at_6, t0.location_id AS location_id_7 FROM agent t0 WHERE t0.token_hash = 'e6d47f714cb6ebed1e8a79b7271a48b2b5701f463d9073526d0aa0a65df9bf2b' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  agent
SET
  last_seen_at = ?
WHERE
  id = ?

UPDATE agent SET last_seen_at = '2026-03-23 09:30:58' WHERE id = 1;

"COMMIT"

"COMMIT";

SELECT
  a.id,
  a.internal_id,
  a.client_id,
  a.last_seen_at,
  COALESCE(c.name, '') AS client_name
FROM
  asic a
  LEFT JOIN client c ON c.id = a.client_id
WHERE
  a.location_id = ?
  AND a.active = 1

SELECT
                a.id,
                a.internal_id,
                a.client_id,
                a.last_seen_at,
                COALESCE(c.name, '') AS client_name
             FROM asic a
             LEFT JOIN client c ON c.id = a.client_id
             WHERE a.location_id = 2 AND a.active = 1;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  asic
SET
  status = CASE WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  ELSE
    status
  END,
  last_seen_at = CASE WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  WHEN id = ?
  AND (
    last_seen_at IS NULL
    OR last_seen_at < ?
  ) THEN
    ?
  ELSE
    last_seen_at
  END
WHERE
  id IN (1, 13, 16, 9, 15, 8)

UPDATE asic
            SET
                status = CASE WHEN id = 1 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN 1 WHEN id = 13 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN 1 WHEN id = 16 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN 0 WHEN id = 9 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN 0 WHEN id = 15 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN 0 WHEN id = 8 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN 0 ELSE status END,
                last_seen_at = CASE WHEN id = 1 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN '2026-03-23 08:30:49' WHEN id = 13 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN '2026-03-23 08:30:49' WHEN id = 16 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN '2026-03-23 08:30:49' WHEN id = 9 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN '2026-03-23 08:30:49' WHEN id = 15 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN '2026-03-23 08:30:49' WHEN id = 8 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 08:30:49') THEN '2026-03-23 08:30:49' ELSE last_seen_at END
            WHERE id IN (1,13,16,9,15,8)
        ;

INSERT INTO asic_uptime_bucket (
  location_id, asic_id, client_id, client_name,
  granularity, period_start, online_seconds,
  updated_at
)
SELECT
  ? AS location_id,
  d.asic_id,
  d.client_id,
  d.client_name,
  'hour' AS granularity,
  d.period_start,
  d.online,
  ? AS updated_at
FROM
  (
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
    UNION ALL
    SELECT
      ? AS asic_id,
      ? AS client_id,
      ? AS client_name,
      ? AS period_start,
      ? AS online
  ) d ON DUPLICATE KEY
UPDATE
  online_seconds = asic_uptime_bucket.online_seconds +
VALUES
  (online_seconds),
  updated_at =
VALUES
  (updated_at),
  client_name =
VALUES
  (client_name)

INSERT INTO asic_uptime_bucket
(location_id, asic_id, client_id, client_name, granularity, period_start, online_seconds, updated_at)
SELECT
  2 AS location_id,
  d.asic_id,
  d.client_id,
  d.client_name,
  'hour' AS granularity,
  d.period_start,
  d.online,
  '2026-03-23 09:30:58' AS updated_at
FROM (
  SELECT 1 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 07:00:00' AS period_start, 30 AS online UNION ALL SELECT 13 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 07:00:00' AS period_start, 30 AS online UNION ALL SELECT 16 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 07:00:00' AS period_start, 0 AS online UNION ALL SELECT 9 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 07:00:00' AS period_start, 0 AS online UNION ALL SELECT 15 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 07:00:00' AS period_start, 0 AS online UNION ALL SELECT 8 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 07:00:00' AS period_start, 0 AS online UNION ALL SELECT 13 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 08:00:00' AS period_start, 30 AS online UNION ALL SELECT 1 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 08:00:00' AS period_start, 30 AS online UNION ALL SELECT 9 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 08:00:00' AS period_start, 0 AS online UNION ALL SELECT 16 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 08:00:00' AS period_start, 0 AS online UNION ALL SELECT 8 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 08:00:00' AS period_start, 0 AS online UNION ALL SELECT 15 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 08:00:00' AS period_start, 0 AS online
) d
ON DUPLICATE KEY UPDATE
  online_seconds   = asic_uptime_bucket.online_seconds + VALUES(online_seconds),
  updated_at       = VALUES(updated_at),
  client_name      = VALUES(client_name)
;

"ROLLBACK"

"ROLLBACK";