Query Metrics
2
Database Queries
2
Different statements
2.48 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.00 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:
[ 5249 5308 5352 5274 5278 5277 5295 5289 5290 5265 5286 5285 5293 5280 5279 5287 5271 5266 5298 5268 5270 5272 5281 5291 5273 5296 5297 5299 5300 5253 5247 5331 5307 5311 5256 5324 5327 5330 5334 5338 5347 5351 5260 5234 5315 5317 5263 5283 5252 ] |
| 2 | 1.48 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:
[ 5249 5308 5352 5274 5278 5277 5295 5289 5290 5265 5286 5285 5293 5280 5279 5287 5271 5266 5298 5268 5270 5272 5281 5291 5273 5296 5297 5299 5300 5253 5247 5331 5307 5311 5256 5324 5327 5330 5334 5338 5347 5351 5260 5234 5315 5317 5263 5283 5252 ] |
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. |