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

Grouped Statements

Show all queries

default connection

Time Count Info
3.55 ms
(50.37%)
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.56 ms
(22.19%)
1
"COMMIT"
Parameters:
[]
0.97 ms
(13.74%)
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.70 ms
(9.91%)
1
UPDATE solar_meter_day SET output = ? WHERE id = ?
Parameters:
[
  966
  1787
]
0.27 ms
(3.79%)
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.