https://staging.e-manazer.cz/api-internal/remote-data-control

Query Metrics

2 Database Queries
2 Different statements
1.55 ms Query time
2 Invalid entities

Queries

Group similar statements

# Time Info
1 0.59 ms
SELECT t0.id AS id_1, t0.control_from AS control_from_2, t0.updated_at AS updated_at_3, t0.created_at AS created_at_4, t0.gauge_id AS gauge_id_5 FROM gauge_control_task t0 WHERE t0.gauge_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1349
  1381
  1384
  1342
  1416
  1461
  1431
  1482
  1392
  1450
  1361
  1379
  1468
  1336
  1459
  1346
  1373
  1477
  1474
  1343
  1455
  1394
  1362
  1330
  1338
  1442
  1412
  8346
  1464
  8576
  9268
  9233
  9234
  9237
  9267
  9236
  9271
  9262
  9264
  9261
  9265
  11995
  11378
  11377
]
2 0.96 ms
SELECT g0_.id AS id_0, g0_.level AS level_1, g0_.type AS type_2, g0_.primary_source AS primary_source_3, g0_.primary_source_other AS primary_source_other_4, g0_.name AS name_5, g0_.qr_code_path AS qr_code_path_6, g0_.measurement_target AS measurement_target_7, g0_.remote AS remote_8, g0_.remote_as_primary AS remote_as_primary_9, g0_.show_in_output AS show_in_output_10, g0_.data_in_results AS data_in_results_11, g0_.last_sent_notification_at AS last_sent_notification_at_12, g0_.updated_at AS updated_at_13, g0_.created_at AS created_at_14, g0_.disabled_at AS disabled_at_15, g0_.disabled_reason AS disabled_reason_16, g0_.building_id AS building_id_17, g0_.parent AS parent_18, g0_.photo_id AS photo_id_19, g0_.el_dictributor_id AS el_dictributor_id_20, g0_.import_id AS import_id_21, g0_.created_by_id AS created_by_id_22, g0_.updated_by_id AS updated_by_id_23, g0_.disabled_by_id AS disabled_by_id_24 FROM gauges g0_ INNER JOIN consumption_limit_gauge c2_ ON g0_.id = c2_.gauge_id INNER JOIN consumption_limit c1_ ON c1_.id = c2_.consumption_limit_id WHERE g0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND c1_.enabled = 1
Parameters:
[
  1349
  1381
  1384
  1342
  1416
  1461
  1431
  1482
  1392
  1450
  1361
  1379
  1468
  1336
  1459
  1346
  1373
  1477
  1474
  1343
  1455
  1394
  1362
  1330
  1338
  1442
  1412
  8346
  1464
  8576
  9268
  9233
  9234
  9237
  9267
  9236
  9271
  9262
  9264
  9261
  9265
  11995
  11378
  11377
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Gauge\GaugeControlTask No errors.
App\Entity\Gauge\Gauge
  • The field App\Entity\Gauge\Gauge#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContractPrice\Contract#gauges does not contain the required 'inversedBy="contracts"' attribute.
App\Entity\Gauge\ConsumptionLimit No errors.
App\Entity\Building\Building No errors.
App\Entity\File
  • The field App\Entity\File#contracts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContractPrice\Contract#file does not contain the required 'inversedBy="contracts"' attribute.
App\Entity\PriceDecision\Distributor No errors.
App\Entity\Import\DataImport No errors.
App\Entity\User No errors.