GET https://www.ship-safety.de/hot-work/report?end_date=2025-09-20&start_date=2025-06-22

Query Metrics

5 Database Queries
5 Different statements
0.95 ms Query time
0 Invalid entities
0 Managed entities

Queries

Group similar statements

# Time Info
1 0.60 ms
SELECT h0_.id AS id_0, h0_.work_date AS work_date_1, h0_.company AS company_2, h0_.start_time AS start_time_3, h0_.end_time AS end_time_4, h0_.deck AS deck_5, h0_.fire_zone AS fire_zone_6, h0_.frame AS frame_7, h0_.area AS area_8, h0_.side AS side_9, h0_.requirements AS requirements_10, h0_.activities AS activities_11, h0_.extinguisher_type AS extinguisher_type_12, h0_.fire_watch_required AS fire_watch_required_13, h0_.created_at AS created_at_14, h0_.fire_protection_officer AS fire_protection_officer_15, h0_.worker_name AS worker_name_16, h0_.status AS status_17, h0_.notes AS notes_18, h0_.approved_at AS approved_at_19, h0_.approved_by AS approved_by_20, h0_.updated_at AS updated_at_21 FROM hot_works h0_ WHERE h0_.work_date BETWEEN ? AND ? ORDER BY h0_.work_date DESC, h0_.start_time ASC
Parameters:
[
  "2025-06-22"
  "2025-09-20"
]
2 0.10 ms
SELECT h0_.status AS status_0, COUNT(h0_.id) AS sclr_1 FROM hot_works h0_ WHERE h0_.work_date BETWEEN ? AND ? GROUP BY h0_.status
Parameters:
[
  "2025-06-22"
  "2025-09-20"
]
3 0.09 ms
SELECT h0_.deck AS deck_0, COUNT(h0_.id) AS sclr_1 FROM hot_works h0_ WHERE h0_.work_date BETWEEN ? AND ? GROUP BY h0_.deck ORDER BY sclr_1 DESC
Parameters:
[
  "2025-06-22"
  "2025-09-20"
]
4 0.08 ms
SELECT h0_.company AS company_0, COUNT(h0_.id) AS sclr_1 FROM hot_works h0_ WHERE h0_.work_date BETWEEN ? AND ? GROUP BY h0_.company ORDER BY sclr_1 DESC
Parameters:
[
  "2025-06-22"
  "2025-09-20"
]
5 0.08 ms
SELECT COUNT(h0_.id) AS sclr_0 FROM hot_works h0_ WHERE (h0_.work_date BETWEEN ? AND ?) AND h0_.fire_watch_required = ?
Parameters:
[
  "2025-06-22"
  "2025-09-20"
  1
]

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.

Managed Entities

default entity manager

Class Amount of managed objects

Entities Mapping

Class Mapping errors
App\Entity\HotWork No errors.