Query Metrics
2
Database Queries
2
Different statements
2.04 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
1.19 ms (58.54%) |
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:
[ 5770 5774 5752 5850 5883 5799 5739 5803 5786 5895 5808 5766 5794 5838 5858 5825 5835 5817 5887 5888 5872 5863 5846 5811 5814 5894 5849 ] |
|
0.84 ms (41.46%) |
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:
[ 5770 5774 5752 5850 5883 5799 5739 5803 5786 5895 5808 5766 5794 5838 5858 5825 5835 5817 5887 5888 5872 5863 5846 5811 5814 5894 5849 ] |
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 |
|
| App\Entity\Gauge\ConsumptionLimit | No errors. |
| App\Entity\Building\Building | No errors. |
| App\Entity\File |
|
| App\Entity\PriceDecision\Distributor | No errors. |
| App\Entity\Import\DataImport | No errors. |
| App\Entity\User | No errors. |