Symfony Profiler

Query Metrics

9 Database Queries

8 Different statements

34.40 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,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
) 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.37 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.11 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
3	0.26 ms	UPDATE agent SET last_seen_at = ? WHERE id = ? Parameters: [`"2026-03-23 11:02:53" 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 11:02:53' WHERE id = 1;
4	31.78 ms	"COMMIT" Parameters: [] View formatted query View runnable query Explain query "COMMIT" "COMMIT";
5	0.57 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.10 ms	"START TRANSACTION" Parameters: [] View formatted query View runnable query Explain query "START TRANSACTION" "START TRANSACTION";
7	0.62 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,16,9,15,8) Parameters: [`13 "2026-03-23 11:02:49" 1 1 "2026-03-23 11:02:49" 1 16 "2026-03-23 11:02:49" 0 9 "2026-03-23 11:02:49" 0 15 "2026-03-23 11:02:49" 0 8 "2026-03-23 11:02:49" 0 13 "2026-03-23 11:02:49" "2026-03-23 11:02:49" 1 "2026-03-23 11:02:49" "2026-03-23 11:02:49" 16 "2026-03-23 11:02:49" "2026-03-23 11:02:49" 9 "2026-03-23 11:02:49" "2026-03-23 11:02:49" 15 "2026-03-23 11:02:49" "2026-03-23 11:02:49" 8 "2026-03-23 11:02:49" "2026-03-23 11:02:49"`] 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, 16, 9, 15, 8) UPDATE asic SET status = CASE WHEN id = 13 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN 1 WHEN id = 1 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN 1 WHEN id = 16 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN 0 WHEN id = 9 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN 0 WHEN id = 15 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN 0 WHEN id = 8 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') 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 11:02:49') THEN '2026-03-23 11:02:49' WHEN id = 1 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN '2026-03-23 11:02:49' WHEN id = 16 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN '2026-03-23 11:02:49' WHEN id = 9 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN '2026-03-23 11:02:49' WHEN id = 15 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN '2026-03-23 11:02:49' WHEN id = 8 AND (last_seen_at IS NULL OR last_seen_at < '2026-03-23 11:02:49') THEN '2026-03-23 11:02:49' ELSE last_seen_at END WHERE id IN (13,1,16,9,15,8) ;
8	0.44 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 11:02:53" 13 2 "ivan" "2026-03-23 11:00:00" 30 1 2 "ivan" "2026-03-23 11:00:00" 30 16 2 "ivan" "2026-03-23 11:00:00" 0 9 2 "ivan" "2026-03-23 11:00:00" 0 15 2 "ivan" "2026-03-23 11:00:00" 0 8 2 "ivan" "2026-03-23 11: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 11:02:53' AS updated_at FROM ( SELECT 13 AS asic_id, 2 AS client_id, 'ivan' AS client_name, '2026-03-23 11: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 11: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 11: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 11: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 11: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 11: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.15 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.
App\Entity\Asic	No errors.
App\Entity\Client	No errors.
App\Entity\Tariff	No errors.
App\Entity\AsicPricingHistory	No errors.
App\Entity\User	No errors.
App\Entity\HistoryBill	No errors.
App\Entity\AsicUptimeBucket	No errors.
App\Entity\AsicPricingMonthSnapshot	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

POST 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