Symfony Profiler

Query Metrics

517 Database Queries

10 Different statements

1527.95 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1420.98 ms
(93.00%)

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"
  "2026-03-03 12: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 = '2026-03-03 12: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)

43.08 ms
(2.82%)

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"
  "2026-03-03 12:15:22"
  "2026-03-04 12:15:22"
]

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 >= '2026-03-03 12:15:22' AND p0_.date <= '2026-03-04 12:15:22' 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)

34.83 ms
(2.28%)

240

UPDATE precipitation_forecast SET updated_at = ? WHERE id = ?

Parameters:

[
  "2026-03-03 12:15:21"
  16983
]

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 = '2026-03-03 12:15:21' WHERE id = 16983;

#	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)

10.45 ms
(0.68%)

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)

8.48 ms
(0.55%)

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

4.94 ms
(0.32%)

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"
  "2026-02-27"
]

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 = '2026-02-27' 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.94 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"
  "2026-03-08 12:00:00"
  0.0
  0
  null
  0
  null
  0.0
  0.0
  "2026-03-03 12:15:22"
]

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', '2026-03-08 12:00:00', 0, 0, NULL, 0, NULL, 0, 0, '2026-03-03 12:15:22');

#	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.33 ms
(0.09%)

UPDATE real_precipitation SET updated_at = ? WHERE id = ?

Parameters:

[
  "2026-03-03 12:15:22"
  709
]

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 = '2026-03-03 12:15:22' WHERE id = 709;

#	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)

0.99 ms
(0.06%)

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)

0.94 ms
(0.06%)

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

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