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"
]
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 = 'PAY' AND p0_.date = '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
]
UPDATE precipitation_forecast SET updated_at = '2025-10-25 22:15:16' WHERE id = 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"
]
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 = 'NEU' AND p0_.date >= '2025-10-25 22:15:17' AND p0_.date <= '2025-10-26 22:15:17' ORDER BY p0_.date ASC;
|
8.25 ms (0.77%)
|
4 |
"COMMIT"
|
5.13 ms (0.48%)
|
1 |
SELECT DISTINCT p0_.station AS station_0 FROM precipitation_forecast p0_ ORDER BY p0_.station ASC
SELECT DISTINCT p0_.station AS station_0 FROM precipitation_forecast p0_ ORDER BY p0_.station ASC;
|
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"
]
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 = 'NEU' AND t0.date = '2025-10-21' LIMIT 1;
|
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"
]
INSERT INTO precipitation_forecast (station, date, hourly_precipitation, precipitation_probability3h, precipitation_probability24h, precipitation_probability10mm12h, precipitation_probability10mm24h, precipitation_quantile10, precipitation_quantile90, updated_at) VALUES ('PAY', '2025-10-30 21:00:00', 0, 8, NULL, NULL, NULL, 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
]
UPDATE real_precipitation SET updated_at = '2025-10-25 22:15:17' WHERE id = 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
]
UPDATE precipitation_forecast SET precipitation_probability3h = 98, updated_at = '2025-10-25 22:15:16' WHERE id = 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
]
UPDATE precipitation_forecast SET hourly_precipitation = 0.3, precipitation_quantile90 = 0.3, updated_at = '2025-10-25 22:15:16' WHERE id = 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
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;
|
0.75 ms (0.07%)
|
4 |
"START TRANSACTION"
"START TRANSACTION";
|
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
]
UPDATE precipitation_forecast SET precipitation_probability3h = 18, precipitation_quantile90 = 0.4, updated_at = '2025-10-25 22:15:16' WHERE id = 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
]
UPDATE precipitation_forecast SET hourly_precipitation = 3.4, precipitation_quantile10 = 0.9, precipitation_quantile90 = 3.4, updated_at = '2025-10-25 22:15:17' WHERE id = 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
]
UPDATE precipitation_forecast SET precipitation_quantile10 = 0.3, updated_at = '2025-10-25 22:15:16' WHERE id = 10813;
|