POST https://iot.ori-lab.cloud/api/solar/solar-day-update

Query Metrics

6 Database Queries
5 Different statements
6.90 ms Query time
2 Invalid entities
3 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
3.26 ms
(47.19%)
2
SELECT s0_.id AS id_0, s0_.date AS date_1, s0_.output AS output_2, s0_.input AS input_3, s0_.device_id AS device_id_4 FROM solar_meter_day s0_ WHERE s0_.date = ? AND s0_.device_id = ? LIMIT 1
Parameters:
[
  "2025-12-05 00:00:00"
  1
]
1.75 ms
(25.39%)
1
"COMMIT"
Parameters:
[]
1.01 ms
(14.64%)
1
SELECT t0.id AS id_1, t0.device_id AS device_id_2, t0.type AS type_3, t0.config AS config_4, t0.owner_id AS owner_id_5 FROM device t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.63 ms
(9.17%)
1
UPDATE solar_meter_day SET output = ?, input = ? WHERE id = ?
Parameters:
[
  1293
  26
  1787
]
0.25 ms
(3.61%)
1
"START TRANSACTION"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection
solar doctrine.dbal.solar_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\SolarMeterDay 2
App\Entity\Device 1

Entities Mapping

Class Mapping errors
App\Entity\Device No errors.
App\Entity\User
  • The association App\Entity\User#userDevices refers to the owning side field App\Entity\UserDevice#User which does not exist.
App\Entity\DataMessage No errors.
App\Entity\UserDevice
  • The mappings App\Entity\UserDevice#user and App\Entity\User#userDevices are inconsistent with each other.
App\Entity\SolarMeterDay No errors.