Symfony Profiler

Query Metrics

517 Database Queries

9 Different statements

1181.18 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1096.94 ms
(92.87%)

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-12-28 08: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-12-28 08: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)

33.02 ms
(2.80%)

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-12-28 08:30:17"
  "2025-12-29 08:30:17"
]

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-12-28 08:30:17' AND p0_.date <= '2025-12-29 08:30:17' 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)

30.44 ms
(2.58%)

242

UPDATE precipitation_forecast SET updated_at = ? WHERE id = ?

Parameters:

[
  "2025-12-28 08:30:16"
  13855
]

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-12-28 08:30:16' WHERE id = 13855;

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

8.69 ms
(0.74%)

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

6.17 ms
(0.52%)

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)

3.85 ms
(0.33%)

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

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-12-24' 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)

0.93 ms
(0.08%)

UPDATE real_precipitation SET updated_at = ? WHERE id = ?

Parameters:

[
  "2025-12-28 08:30:17"
  579
]

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-12-28 08:30:17' WHERE id = 579;

#	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.70 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.45 ms
(0.04%)

"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