Error 500 Internal Server Error

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

IP
192.168.32.1
Profiled on
Token
d31fdf
Forwarded to ErrorController (3f9bda)

Query Metrics

9 Database Queries
8 Different statements
71.67 ms Query time
0 Invalid entities
2 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
69.19 ms
(96.54%) 		1 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.72 ms
(1.01%) 		1 
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 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 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 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 15:38:38"
  1
  2
  "ivan"
  "2026-03-23 07:00:00"
  30
  13
  2
  "ivan"
  "2026-03-23 07:00:00"
  30
  15
  2
  "ivan"
  "2026-03-23 07:00:00"
  0
  16
  2
  "ivan"
  "2026-03-23 07:00:00"
  0
  9
  2
  "ivan"
  "2026-03-23 07:00:00"
  0
  8
  2
  "ivan"
  "2026-03-23 07:00:00"
  0
  13
  2
  "ivan"
  "2026-03-23 08:00:00"
  60
  1
  2
  "ivan"
  "2026-03-23 08:00:00"
  60
  15
  2
  "ivan"
  "2026-03-23 08:00:00"
  0
  9
  2
  "ivan"
  "2026-03-23 08:00:00"
  0
  8
  2
  "ivan"
  "2026-03-23 08:00:00"
  0
  16
  2
  "ivan"
  "2026-03-23 08:00:00"
  0
  1
  2
  "ivan"
  "2026-03-23 09:00:00"
  60
  13
  2
  "ivan"
  "2026-03-23 09:00:00"
  60
  8
  2
  "ivan"
  "2026-03-23 09:00:00"
  0
  15
  2
  "ivan"
  "2026-03-23 09:00:00"
  0
  9
  2
  "ivan"
  "2026-03-23 09:00:00"
  0
  16
  2
  "ivan"
  "2026-03-23 09:00:00"
  0
  1
  2
  "ivan"
  "2026-03-23 10:00:00"
  30
  13
  2
  "ivan"
  "2026-03-23 10:00:00"
  30
  8
  2
  "ivan"
  "2026-03-23 10:00:00"
  0
  9
  2
  "ivan"
  "2026-03-23 10:00:00"
  0
  16
  2
  "ivan"
  "2026-03-23 10:00:00"
  0
  15
  2
  "ivan"
  "2026-03-23 10:00:00"
  0
  1
  2
  "ivan"
  "2026-03-23 11:00:00"
  60
  13
  2
  "ivan"
  "2026-03-23 11:00:00"
  60
  9
  2
  "ivan"
  "2026-03-23 11:00:00"
  0
  16
  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
  13
  2
  "ivan"
  "2026-03-23 12:00:00"
  30
  1
  2
  "ivan"
  "2026-03-23 12:00:00"
  30
  8
  2
  "ivan"
  "2026-03-23 12:00:00"
  0
  9
  2
  "ivan"
  "2026-03-23 12:00:00"
  0
  15
  2
  "ivan"
  "2026-03-23 12:00:00"
  0
  16
  2
  "ivan"
  "2026-03-23 12:00:00"
  0
]
View formatted query    View runnable query    Explain query
0.42 ms
(0.58%) 		1 
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,15,16,9,8)
Parameters: 
[
  1
  "2026-03-23 12:38:19"
  1
  13
  "2026-03-23 12:38:19"
  1
  15
  "2026-03-23 12:38:19"
  0
  16
  "2026-03-23 12:38:19"
  0
  9
  "2026-03-23 12:38:19"
  0
  8
  "2026-03-23 12:38:19"
  0
  1
  "2026-03-23 12:38:19"
  "2026-03-23 12:38:19"
  13
  "2026-03-23 12:38:19"
  "2026-03-23 12:38:19"
  15
  "2026-03-23 12:38:19"
  "2026-03-23 12:38:19"
  16
  "2026-03-23 12:38:19"
  "2026-03-23 12:38:19"
  9
  "2026-03-23 12:38:19"
  "2026-03-23 12:38:19"
  8
  "2026-03-23 12:38:19"
  "2026-03-23 12:38:19"
]
View formatted query    View runnable query    Explain query
0.39 ms
(0.55%) 		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 = ? AND a.active = 1
Parameters: 
[
  2
]
View formatted query    View runnable query    Explain query
0.31 ms
(0.44%) 		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 = ? LIMIT 1
Parameters: 
[
  "e6d47f714cb6ebed1e8a79b7271a48b2b5701f463d9073526d0aa0a65df9bf2b"
]
View formatted query    View runnable query    Explain query
0.24 ms
(0.33%) 		1 
UPDATE agent SET last_seen_at = ? WHERE id = ?
Parameters: 
[
  "2026-03-23 15:38:38"
  1
]
View formatted query    View runnable query    Explain query
0.23 ms
(0.32%) 		2 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.17 ms
(0.24%) 		1 
"ROLLBACK"
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.