Query Metrics
2
Database Queries
2
Different statements
1.55 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.96 ms (61.62%) |
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:
[ 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 ] |
|
0.59 ms (38.38%) |
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:
[ 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 |
|
| 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. |