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

Query Metrics

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

Queries

Group similar statements

default connection

# Time Info
1 0.97 ms
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
]
2 2.02 ms
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
]
3 1.53 ms
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-06 00:00:00"
  1
]
4 0.27 ms
"START TRANSACTION"
Parameters:
[]
5 0.70 ms
UPDATE solar_meter_day SET output = ? WHERE id = ?
Parameters:
[
  966
  1787
]
6 1.56 ms
"COMMIT"
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.