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.86 ms
(56.12%)
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:
[
  14790
  14831
  14684
  14832
  14833
  14834
  14791
  14686
  14685
  14687
  14688
  15025
  14792
  14726
  14727
  14728
  14796
  14841
  14797
  14798
  14842
  14729
  14843
  14799
  150
  3530
  15066
  15065
]
0.67 ms
(43.88%)
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:
[
  14790
  14831
  14684
  14832
  14833
  14834
  14791
  14686
  14685
  14687
  14688
  15025
  14792
  14726
  14727
  14728
  14796
  14841
  14797
  14798
  14842
  14729
  14843
  14799
  150
  3530
  15066
  15065
]

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.