Symfony Profiler

Query Metrics

9 Database Queries

8 Different statements

211.69 ms Query time

0 Invalid entities

2 Managed entities

Queries


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
"START TRANSACTION"
UPDATE agent SET last_seen_at = ? WHERE id = ?
"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
"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 (13,1,9,16,8,15)
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
) 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"

#▲	Time	Info
1	0.34 ms	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 Parameters: [`"e6d47f714cb6ebed1e8a79b7271a48b2b5701f463d9073526d0aa0a65df9bf2b"`] View formatted query View runnable query Explain query 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;
2	0.22 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
3	0.30 ms	UPDATE agent SET last_seen_at = ? WHERE id = ? Parameters: [`"2026-03-23 14:18:04" 1`] View formatted query View runnable query Explain query UPDATE agent SET last_seen_at = ? WHERE id = ? UPDATE agent SET last_seen_at = '2026-03-23 14:18:04' WHERE id = 1;
4	207.88 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
5	0.78 ms	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 Parameters: [`2`] View formatted query View runnable query Explain query 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;
6	0.21 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
7	0.82 ms	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 (13,1,9,16,8,15) Parameters: [`13 "2026-03-23 14:15:19" 1 1 "2026-03-23 14:15:19" 1 9 "2026-03-23 14:15:19" 0 16 "2026-03-23 14:15:19" 0 8 "2026-03-23 14:15:19" 0 15 "2026-03-23 14:15:19" 0 13 "2026-03-23 14:15:19" "2026-03-23 14:15:19" 1 "2026-03-23 14:15:19" "2026-03-23 14:15:19" 9 "2026-03-23 14:15:19" "2026-03-23 14:15:19" 16 "2026-03-23 14:15:19" "2026-03-23 14:15:19" 8 "2026-03-23 14:15:19" "2026-03-23 14:15:19" 15 "2026-03-23 14:15:19" "2026-03-23 14:15:19"`] View formatted query View runnable query Explain query 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 (13, 1, 9, 16, 8, 15) UPDATE asic SET status = CASE WHEN id = 13 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN 1 WHEN id = 1 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN 1 WHEN id = 9 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN 0 WHEN id = 16 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN 0 WHEN id = 8 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN 0 WHEN id = 15 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN 0 ELSE status END, last_seen_at = CASE WHEN id = 13 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN '2026-03-23 14:15:19' WHEN id = 1 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN '2026-03-23 14:15:19' WHEN id = 9 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN '2026-03-23 14:15:19' WHEN id = 16 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN '2026-03-23 14:15:19' WHEN id = 8 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN '2026-03-23 14:15:19' WHEN id = 15 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 14:15:19') THEN '2026-03-23 14:15:19' ELSE last_seen_at END WHERE id IN (13,1,9,16,8,15) ;
8	0.81 ms	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 ) 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) Parameters: [`2 "2026-03-23 14:18:04" 13 2 "ivan" "2026-03-23 14:00:00" 30 1 2 "ivan" "2026-03-23 14:00:00" 30 9 2 "ivan" "2026-03-23 14:00:00" 0 16 2 "ivan" "2026-03-23 14:00:00" 0 8 2 "ivan" "2026-03-23 14:00:00" 0 15 2 "ivan" "2026-03-23 14:00:00" 0`] View formatted query View runnable query Explain query 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 ) 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 14:18:04' AS updated_at FROM ( SELECT 13 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 14: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 14: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 14: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 14: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 14: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 14: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) ;
9	0.32 ms	"ROLLBACK" Parameters: [] View formatted query View runnable query Explain query "ROLLBACK" "ROLLBACK";

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\Agent	1
App\Entity\Location	1

Entities Mapping

Class	Mapping errors
App\Entity\Agent	No errors.
App\Entity\Location	No errors.

Symfony Profiler

GET https://dc-mining-monitoring-new-test.test.itlabs.top/api/agent/v1/samples

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping