Query Metrics

515 Database Queries
15 Different statements
1068.98 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
976.31 ms
(91.33%)
242
SELECT p0_.id AS id_0, p0_.station AS station_1, p0_.date AS date_2, p0_.hourly_precipitation AS hourly_precipitation_3, p0_.precipitation_probability3h AS precipitation_probability3h_4, p0_.precipitation_probability24h AS precipitation_probability24h_5, p0_.precipitation_probability10mm12h AS precipitation_probability10mm12h_6, p0_.precipitation_probability10mm24h AS precipitation_probability10mm24h_7, p0_.precipitation_quantile10 AS precipitation_quantile10_8, p0_.precipitation_quantile90 AS precipitation_quantile90_9, p0_.updated_at AS updated_at_10 FROM precipitation_forecast p0_ WHERE p0_.station = ? AND p0_.date = ?
Parameters:
[
  "PAY"
  "2025-10-25 22:00:00"
]
38.27 ms
(3.58%)
225
UPDATE precipitation_forecast SET updated_at = ? WHERE id = ?
Parameters:
[
  "2025-10-25 22:15:16"
  10815
]
29.83 ms
(2.79%)
6
SELECT p0_.id AS id_0, p0_.station AS station_1, p0_.date AS date_2, p0_.hourly_precipitation AS hourly_precipitation_3, p0_.precipitation_probability3h AS precipitation_probability3h_4, p0_.precipitation_probability24h AS precipitation_probability24h_5, p0_.precipitation_probability10mm12h AS precipitation_probability10mm12h_6, p0_.precipitation_probability10mm24h AS precipitation_probability10mm24h_7, p0_.precipitation_quantile10 AS precipitation_quantile10_8, p0_.precipitation_quantile90 AS precipitation_quantile90_9, p0_.updated_at AS updated_at_10 FROM precipitation_forecast p0_ WHERE p0_.station = ? AND p0_.date >= ? AND p0_.date <= ? ORDER BY p0_.date ASC
Parameters:
[
  "NEU"
  "2025-10-25 22:15:17"
  "2025-10-26 22:15:17"
]
8.25 ms
(0.77%)
4
"COMMIT"
Parameters:
[]
5.13 ms
(0.48%)
1
SELECT DISTINCT p0_.station AS station_0 FROM precipitation_forecast p0_ ORDER BY p0_.station ASC
Parameters:
[]
2.70 ms
(0.25%)
8
SELECT t0.id AS id_1, t0.station AS station_2, t0.date AS date_3, t0.daily_precipitation AS daily_precipitation_4, t0.updated_at AS updated_at_5 FROM real_precipitation t0 WHERE t0.station = ? AND t0.date = ? LIMIT 1
Parameters:
[
  "NEU"
  "2025-10-21"
]
1.60 ms
(0.15%)
2
INSERT INTO precipitation_forecast (station, date, hourly_precipitation, precipitation_probability3h, precipitation_probability24h, precipitation_probability10mm12h, precipitation_probability10mm24h, precipitation_quantile10, precipitation_quantile90, updated_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  "PAY"
  "2025-10-30 21:00:00"
  0.0
  8
  null
  null
  null
  0.0
  0.0
  "2025-10-25 22:15:17"
]
1.54 ms
(0.14%)
8
UPDATE real_precipitation SET updated_at = ? WHERE id = ?
Parameters:
[
  "2025-10-25 22:15:17"
  451
]
1.29 ms
(0.12%)
7
UPDATE precipitation_forecast SET precipitation_probability3h = ?, updated_at = ? WHERE id = ?
Parameters:
[
  98
  "2025-10-25 22:15:16"
  10817
]
1.15 ms
(0.11%)
1
UPDATE precipitation_forecast SET hourly_precipitation = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?
Parameters:
[
  0.3
  0.3
  "2025-10-25 22:15:16"
  10811
]
0.86 ms
(0.08%)
2
SELECT t0.id AS id_1, t0.alert_level AS alert_level_2, t0.alert_degree AS alert_degree_3, t0.threshold24h AS threshold24h_4, t0.threshold48h AS threshold48h_5, t0.threshold72h AS threshold72h_6, t0.description AS description_7, t0.updated_at AS updated_at_8 FROM alert_parameter t0
Parameters:
[]
0.75 ms
(0.07%)
4
"START TRANSACTION"
Parameters:
[]
0.71 ms
(0.07%)
2
UPDATE precipitation_forecast SET precipitation_probability3h = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?
Parameters:
[
  18
  0.4
  "2025-10-25 22:15:16"
  10818
]
0.35 ms
(0.03%)
2
UPDATE precipitation_forecast SET hourly_precipitation = ?, precipitation_quantile10 = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?
Parameters:
[
  3.4
  0.9
  3.4
  "2025-10-25 22:15:17"
  10812
]
0.23 ms
(0.02%)
1
UPDATE precipitation_forecast SET precipitation_quantile10 = ?, updated_at = ? WHERE id = ?
Parameters:
[
  0.3
  "2025-10-25 22:15:16"
  10813
]

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\PrecipitationForecast No errors.
App\Entity\RealPrecipitation No errors.
App\Entity\AlertParameter No errors.