Query Metrics
4
Database Queries
4
Different statements
0.92 ms
Query time
0
Invalid entities
1
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.33 ms (35.84%) |
1 |
SELECT t0.id AS id_1, t0.imei AS imei_2, t0.ts AS ts_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.alt AS alt_6, t0.ang AS ang_7, t0.sat AS sat_8, t0.sp AS sp_9, t0.evt AS evt_10, t0.raw_json AS raw_json_11, t0.created_at AS created_at_12 FROM teltonika_avl t0 WHERE t0.id = ?
Parameters:
[
3409965
]
|
|
0.29 ms (31.38%) |
1 |
INSERT INTO teltonika_avl (imei, ts, latitude, longitude, alt, ang, sat, sp, evt, raw_json, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "862272083847063" "1788999589607" 46.2967966 6.94524 376 "58" "30" "0" "0" "{"Altitude":376,"Angle":58,"Elements":[{"IOID":22,"Length":1,"Value":true},{"IOID":71,"Length":1,"Value":3},{"IOID":240,"Length":1,"Value":true},{"IOID":21,"Length":1,"Value":3},{"IOID":200,"Length":1,"Value":false},{"IOID":239,"Length":1,"Value":true},{"IOID":67,"Length":2,"Value":9905},{"IOID":68,"Length":2,"Value":0},{"IOID":181,"Length":2,"Value":8},{"IOID":182,"Length":2,"Value":4},{"IOID":66,"Length":2,"Value":25733},{"IOID":24,"Length":2,"Value":0}],"EventID":0,"Lat":462967966,"Lng":69452400,"Priority":0,"Speed":0,"Utime":1788999589,"UtimeMs":1788999589607,"VisSat":30}" "2026-09-10 02:20:45" ] |
|
0.17 ms (18.33%) |
1 |
"COMMIT"
Parameters:
[] |
|
0.13 ms (14.45%) |
1 |
"START TRANSACTION"
Parameters:
[] |
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\Fleet\TeltonikaAvl | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Fleet\TeltonikaAvl | No errors. |