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

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
0.94 ms
(61.52%)
1
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:
[
  125
  129
  130
  131
  14624
]
0.59 ms
(38.48%)
1
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:
[
  125
  129
  130
  131
  14624
]

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.