Symfony Profiler

Query Metrics

515 Database Queries

27 Different statements

1201.87 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1094.79 ms
(91.09%)

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 17:00:00"
]

View formatted query View runnable query Explain query View query backtrace

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 = ?

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 17:00:00';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 36)
7	App\Repository\PrecipitationForecastRepository->findByStationAndDate (line 114)
8	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
9	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
10	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

27.49 ms
(2.29%)

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 17:15:18"
  "2025-10-26 17:15:18"
]

View formatted query View runnable query Explain query View query backtrace

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

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 17:15:18' AND p0_.date <= '2025-10-26 17:15:18' ORDER BY p0_.date ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 129)
7	App\Repository\PrecipitationForecastRepository->findForecastsBetweenDates (line 96)
8	App\Service\AlertNotificationService->calculatePrecipitationSum (line 46)
9	App\Service\AlertNotificationService->checkPrecipitationAlertsAndNotify (line 79)
10	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
11	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

18.06 ms
(1.50%)

UPDATE precipitation_forecast SET precipitation_probability3h = ?, updated_at = ? WHERE id = ?

Parameters:

[
  37
  "2025-10-25 17:15:16"
  10831
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability3h = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability3h = 37, updated_at = '2025-10-25 17:15:16' WHERE id = 10831;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

14.04 ms
(1.17%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1454)
2	Doctrine\DBAL\Connection->commit (line 430)
3	Doctrine\ORM\UnitOfWork->commit (line 264)
4	Doctrine\ORM\EntityManager->flush (line 139)
5	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
6	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
7	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

9.65 ms
(0.80%)

UPDATE precipitation_forecast SET precipitation_probability3h = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  98
  3.4
  "2025-10-25 17:15:16"
  10807
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability3h = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability3h = 98, precipitation_quantile90 = 3.4, updated_at = '2025-10-25 17:15:16' WHERE id = 10807;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

7.84 ms
(0.65%)

SELECT DISTINCT p0_.station AS station_0 FROM precipitation_forecast p0_ ORDER BY p0_.station ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 114)
7	App\Repository\PrecipitationForecastRepository->findUniqueStations (line 41)
8	App\Service\AlertNotificationService->checkPrecipitationAlertsAndNotify (line 79)
9	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
10	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

7.26 ms
(0.60%)

UPDATE precipitation_forecast SET updated_at = ? WHERE id = ?

Parameters:

[
  "2025-10-25 17:15:16"
  10835
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET updated_at = '2025-10-25 17:15:16' WHERE id = 10835;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

6.15 ms
(0.51%)

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"
]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 169)
5	App\Controller\Admin\PrecipitationController->processRealData (line 75)
6	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
7	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.90 ms
(0.16%)

UPDATE precipitation_forecast SET precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  0.1
  "2025-10-25 17:15:16"
  10863
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_quantile90 = 0.1, updated_at = '2025-10-25 17:15:16' WHERE id = 10863;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.59 ms
(0.13%)

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 16:00:00"
  0.0
  8
  null
  null
  null
  0.0
  0.0
  "2025-10-25 17:15:17"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO precipitation_forecast (
  station, date, hourly_precipitation,
  precipitation_probability3h, precipitation_probability24h,
  precipitation_probability10mm12h,
  precipitation_probability10mm24h,
  precipitation_quantile10, precipitation_quantile90,
  updated_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

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 16:00:00', 0, 8, NULL, NULL, NULL, 0, 0, '2025-10-25 17:15:17');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 251)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 1051)
4	Doctrine\ORM\UnitOfWork->executeInserts (line 400)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.57 ms
(0.13%)

UPDATE real_precipitation SET updated_at = ? WHERE id = ?

Parameters:

[
  "2025-10-25 17:15:17"
  451
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  real_precipitation
SET
  updated_at = ?
WHERE
  id = ?

UPDATE real_precipitation SET updated_at = '2025-10-25 17:15:17' WHERE id = 451;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 197)
7	App\Controller\Admin\PrecipitationController->processRealData (line 75)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.54 ms
(0.13%)

UPDATE precipitation_forecast SET hourly_precipitation = ?, precipitation_probability3h = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  0.3
  96
  2.4
  "2025-10-25 17:15:16"
  10809
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  hourly_precipitation = ?,
  precipitation_probability3h = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET hourly_precipitation = 0.3, precipitation_probability3h = 96, precipitation_quantile90 = 2.4, updated_at = '2025-10-25 17:15:16' WHERE id = 10809;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.38 ms
(0.11%)

UPDATE precipitation_forecast SET hourly_precipitation = ?, precipitation_quantile10 = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  1.1
  1.1
  1.1
  "2025-10-25 17:15:16"
  10801
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  hourly_precipitation = ?,
  precipitation_quantile10 = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET hourly_precipitation = 1.1, precipitation_quantile10 = 1.1, precipitation_quantile90 = 1.1, updated_at = '2025-10-25 17:15:16' WHERE id = 10801;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.17 ms
(0.10%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 51)
6	App\Service\AlertNotificationService->checkPrecipitationAlertsAndNotify (line 79)
7	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
8	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

1.07 ms
(0.09%)

UPDATE precipitation_forecast SET precipitation_probability3h = ?, precipitation_probability10mm12h = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  47
  24
  0.3
  "2025-10-25 17:15:16"
  10817
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability3h = ?,
  precipitation_probability10mm12h = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability3h = 47, precipitation_probability10mm12h = 24, precipitation_quantile90 = 0.3, updated_at = '2025-10-25 17:15:16' WHERE id = 10817;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.07 ms
(0.09%)

UPDATE precipitation_forecast SET precipitation_probability10mm12h = ?, updated_at = ? WHERE id = ?

Parameters:

[
  12
  "2025-10-25 17:15:16"
  10885
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability10mm12h = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability10mm12h = 12, updated_at = '2025-10-25 17:15:16' WHERE id = 10885;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.05 ms
(0.09%)

UPDATE precipitation_forecast SET precipitation_probability3h = ?, precipitation_probability10mm12h = ?, updated_at = ? WHERE id = ?

Parameters:

[
  67
  20
  "2025-10-25 17:15:16"
  10815
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability3h = ?,
  precipitation_probability10mm12h = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability3h = 67, precipitation_probability10mm12h = 20, updated_at = '2025-10-25 17:15:16' WHERE id = 10815;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

1.01 ms
(0.08%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 379)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 139)
4	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
5	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
6	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.89 ms
(0.07%)

UPDATE precipitation_forecast SET hourly_precipitation = ?, updated_at = ? WHERE id = ?

Parameters:

[
  0.8
  "2025-10-25 17:15:16"
  10881
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  hourly_precipitation = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET hourly_precipitation = 0.8, updated_at = '2025-10-25 17:15:16' WHERE id = 10881;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.55 ms
(0.05%)

UPDATE precipitation_forecast SET hourly_precipitation = ?, precipitation_probability10mm12h = ?, precipitation_quantile10 = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  1.9
  0
  0.1
  3.6
  "2025-10-25 17:15:16"
  10803
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  hourly_precipitation = ?,
  precipitation_probability10mm12h = ?,
  precipitation_quantile10 = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET hourly_precipitation = 1.9, precipitation_probability10mm12h = 0, precipitation_quantile10 = 0.1, precipitation_quantile90 = 3.6, updated_at = '2025-10-25 17:15:16' WHERE id = 10803;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.39 ms
(0.03%)

UPDATE precipitation_forecast SET precipitation_probability10mm12h = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  2
  3.1
  "2025-10-25 17:15:16"
  10805
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability10mm12h = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability10mm12h = 2, precipitation_quantile90 = 3.1, updated_at = '2025-10-25 17:15:16' WHERE id = 10805;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.33 ms
(0.03%)

UPDATE precipitation_forecast SET precipitation_probability10mm24h = ?, updated_at = ? WHERE id = ?

Parameters:

[
  20
  "2025-10-25 17:15:16"
  10912
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability10mm24h = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability10mm24h = 20, updated_at = '2025-10-25 17:15:16' WHERE id = 10912;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.32 ms
(0.03%)

UPDATE precipitation_forecast SET hourly_precipitation = ?, precipitation_probability3h = ?, precipitation_probability10mm12h = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  0.6
  96
  2
  1.8
  "2025-10-25 17:15:17"
  10804
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  hourly_precipitation = ?,
  precipitation_probability3h = ?,
  precipitation_probability10mm12h = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET hourly_precipitation = 0.6, precipitation_probability3h = 96, precipitation_probability10mm12h = 2, precipitation_quantile90 = 1.8, updated_at = '2025-10-25 17:15:17' WHERE id = 10804;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.22 ms
(0.02%)

UPDATE precipitation_forecast SET precipitation_probability3h = ?, precipitation_probability24h = ?, precipitation_probability10mm24h = ?, updated_at = ? WHERE id = ?

Parameters:

[
  2
  0
  45
  "2025-10-25 17:15:17"
  10962
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability3h = ?,
  precipitation_probability24h = ?,
  precipitation_probability10mm24h = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability3h = 2, precipitation_probability24h = 0, precipitation_probability10mm24h = 45, updated_at = '2025-10-25 17:15:17' WHERE id = 10962;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 147)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.21 ms
(0.02%)

UPDATE precipitation_forecast SET precipitation_probability3h = ?, precipitation_probability24h = ?, updated_at = ? WHERE id = ?

Parameters:

[
  0
  2
  "2025-10-25 17:15:17"
  10960
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability3h = ?,
  precipitation_probability24h = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability3h = 0, precipitation_probability24h = 2, updated_at = '2025-10-25 17:15:17' WHERE id = 10960;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.16 ms
(0.01%)

UPDATE precipitation_forecast SET precipitation_probability3h = ?, precipitation_probability10mm24h = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  39
  71
  0.4
  "2025-10-25 17:15:17"
  11010
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability3h = ?,
  precipitation_probability10mm24h = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability3h = 39, precipitation_probability10mm24h = 71, precipitation_quantile90 = 0.4, updated_at = '2025-10-25 17:15:17' WHERE id = 11010;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 147)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.16 ms
(0.01%)

UPDATE precipitation_forecast SET precipitation_probability3h = ?, precipitation_probability24h = ?, precipitation_quantile90 = ?, updated_at = ? WHERE id = ?

Parameters:

[
  29
  8
  0.2
  "2025-10-25 17:15:17"
  11008
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  precipitation_forecast
SET
  precipitation_probability3h = ?,
  precipitation_probability24h = ?,
  precipitation_quantile90 = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE precipitation_forecast SET precipitation_probability3h = 29, precipitation_probability24h = 8, precipitation_quantile90 = 0.2, updated_at = '2025-10-25 17:15:17' WHERE id = 11008;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1129)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 405)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 139)
7	App\Controller\Admin\PrecipitationController->processForecastData (line 70)
8	App\Controller\Admin\PrecipitationController->updatePrecipitationData (line 47)
9	App\Controller\Admin\PrecipitationController->cronUpdate (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

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.

Symfony Profiler

GET https://meteo.abageol.ch/admin/precipitation/cron_update?token=eyJhbGciOiJSUzI1NiIsInR5cCIgOiAiSldUIiwia2lkIiA6ICJ4YnIzSmtLZng3X1Bxd1NHYUpaX003ZUgwV3BGZXYtcnFZV…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping