Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

108.69 ms Query time

0 Invalid entities

18 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

60.60 ms
(55.75%)

SELECT m0_.id AS id_0, m0_.date AS date_1, m0_.temperature AS temperature_2, m0_.feels_like AS feels_like_3, m0_.humidity AS humidity_4, m0_.wind_speed AS wind_speed_5, m0_.wind_direction AS wind_direction_6, m0_.pressure AS pressure_7, m0_.precipitation_type AS precipitation_type_8, m0_.weather AS weather_9, m0_.summary AS summary_10, m0_.cloud_cover AS cloud_cover_11, m0_.zone AS zone_12 FROM meteo_data m0_ WHERE m0_.date = ? AND LOWER(m0_.zone) = ?

Parameters:

[
  "2026-01-17 15:48:12"
  "gavray"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.id AS id_0,
  m0_.date AS date_1,
  m0_.temperature AS temperature_2,
  m0_.feels_like AS feels_like_3,
  m0_.humidity AS humidity_4,
  m0_.wind_speed AS wind_speed_5,
  m0_.wind_direction AS wind_direction_6,
  m0_.pressure AS pressure_7,
  m0_.precipitation_type AS precipitation_type_8,
  m0_.weather AS weather_9,
  m0_.summary AS summary_10,
  m0_.cloud_cover AS cloud_cover_11,
  m0_.zone AS zone_12
FROM
  meteo_data m0_
WHERE
  m0_.date = ?
  AND LOWER(m0_.zone) = ?

SELECT m0_.id AS id_0, m0_.date AS date_1, m0_.temperature AS temperature_2, m0_.feels_like AS feels_like_3, m0_.humidity AS humidity_4, m0_.wind_speed AS wind_speed_5, m0_.wind_direction AS wind_direction_6, m0_.pressure AS pressure_7, m0_.precipitation_type AS precipitation_type_8, m0_.weather AS weather_9, m0_.summary AS summary_10, m0_.cloud_cover AS cloud_cover_11, m0_.zone AS zone_12 FROM meteo_data m0_ WHERE m0_.date = '2026-01-17 15:48:12' AND LOWER(m0_.zone) = 'gavray';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\MeteoDataRepository->findByDateAndZone (line 23)
7	App\Service\MeteoWidgetService->getMeteoData (line 90)
8	App\Service\MeteoWidgetService->getCurrentWeatherData (line 34)
9	App\Twig\MeteoWidgetExtension->getGlobals (line 22)
10	Twig\ExtensionSet->getGlobals (line 361)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 398)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\BatimentController->index (line 58)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

40.18 ms
(36.97%)

SELECT id FROM meteo_data 
                                WHERE LOWER(zone) = ? 
                  AND EXTRACT(MONTH FROM date) = ? 
                  AND EXTRACT(DAY FROM date) = ? 
                  AND EXTRACT(HOUR FROM date) = ? 
                ORDER BY date ASC 
                LIMIT 1

Parameters:

[
  "gavray"
  1
  17
  15
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  id
FROM
  meteo_data
WHERE
  LOWER(zone) = ?
  AND EXTRACT(
    MONTH
    FROM
      date
  ) = ?
  AND EXTRACT(
    DAY
    FROM
      date
  ) = ?
  AND EXTRACT(
    HOUR
    FROM
      date
  ) = ?
ORDER BY
  date ASC
LIMIT
  1

SELECT id FROM meteo_data 
                                WHERE LOWER(zone) = 'gavray' 
                  AND EXTRACT(MONTH FROM date) = 1 
                  AND EXTRACT(DAY FROM date) = 17 
                  AND EXTRACT(HOUR FROM date) = 15 
                ORDER BY date ASC 
                LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->fetchOne (line 627)
2	App\Repository\MeteoDataRepository->findClosestByDatetimeAndZone (line 52)
3	App\Service\MeteoWidgetService->getMeteoData (line 94)
4	App\Service\MeteoWidgetService->getCurrentWeatherData (line 34)
5	App\Twig\MeteoWidgetExtension->getGlobals (line 22)
6	Twig\ExtensionSet->getGlobals (line 361)
7	Twig\Environment->getGlobals (line 908)
8	Twig\Template->yield (line 398)
9	Twig\Template->display (line 358)
10	Twig\Template->render (line 373)
11	Twig\TemplateWrapper->render (line 51)
12	Twig\Environment->render (line 333)
13	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
16	App\Controller\BatimentController->index (line 58)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 182)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 29)
22	require_once (line 5)

6.11 ms
(5.62%)

SELECT b0_.id AS id_0, b0_.code AS code_1, b0_.nom AS nom_2, b0_.categorie AS categorie_3, b0_.description AS description_4, b0_.prix_basique AS prix_basique_5, b0_.prix_standard AS prix_standard_6, b0_.prix_premium AS prix_premium_7, b0_.unite_calcul AS unite_calcul_8, b0_.capacite_basique AS capacite_basique_9, b0_.capacite_standard AS capacite_standard_10, b0_.capacite_premium AS capacite_premium_11, b0_.unite_capacite AS unite_capacite_12, b0_.formule_surface_basique AS formule_surface_basique_13, b0_.formule_surface_standard AS formule_surface_standard_14, b0_.formule_surface_premium AS formule_surface_premium_15, b0_.duree_construction_jours AS duree_construction_jours_16, b0_.avantages_basique AS avantages_basique_17, b0_.avantages_standard AS avantages_standard_18, b0_.avantages_premium AS avantages_premium_19, b0_.emoji AS emoji_20, b0_.actif AS actif_21, b0_.created_at AS created_at_22, b0_.updated_at AS updated_at_23 FROM batiment_modele b0_ WHERE b0_.actif = ? ORDER BY b0_.categorie ASC, b0_.nom ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.code AS code_1,
  b0_.nom AS nom_2,
  b0_.categorie AS categorie_3,
  b0_.description AS description_4,
  b0_.prix_basique AS prix_basique_5,
  b0_.prix_standard AS prix_standard_6,
  b0_.prix_premium AS prix_premium_7,
  b0_.unite_calcul AS unite_calcul_8,
  b0_.capacite_basique AS capacite_basique_9,
  b0_.capacite_standard AS capacite_standard_10,
  b0_.capacite_premium AS capacite_premium_11,
  b0_.unite_capacite AS unite_capacite_12,
  b0_.formule_surface_basique AS formule_surface_basique_13,
  b0_.formule_surface_standard AS formule_surface_standard_14,
  b0_.formule_surface_premium AS formule_surface_premium_15,
  b0_.duree_construction_jours AS duree_construction_jours_16,
  b0_.avantages_basique AS avantages_basique_17,
  b0_.avantages_standard AS avantages_standard_18,
  b0_.avantages_premium AS avantages_premium_19,
  b0_.emoji AS emoji_20,
  b0_.actif AS actif_21,
  b0_.created_at AS created_at_22,
  b0_.updated_at AS updated_at_23
FROM
  batiment_modele b0_
WHERE
  b0_.actif = ?
ORDER BY
  b0_.categorie ASC,
  b0_.nom ASC

SELECT b0_.id AS id_0, b0_.code AS code_1, b0_.nom AS nom_2, b0_.categorie AS categorie_3, b0_.description AS description_4, b0_.prix_basique AS prix_basique_5, b0_.prix_standard AS prix_standard_6, b0_.prix_premium AS prix_premium_7, b0_.unite_calcul AS unite_calcul_8, b0_.capacite_basique AS capacite_basique_9, b0_.capacite_standard AS capacite_standard_10, b0_.capacite_premium AS capacite_premium_11, b0_.unite_capacite AS unite_capacite_12, b0_.formule_surface_basique AS formule_surface_basique_13, b0_.formule_surface_standard AS formule_surface_standard_14, b0_.formule_surface_premium AS formule_surface_premium_15, b0_.duree_construction_jours AS duree_construction_jours_16, b0_.avantages_basique AS avantages_basique_17, b0_.avantages_standard AS avantages_standard_18, b0_.avantages_premium AS avantages_premium_19, b0_.emoji AS emoji_20, b0_.actif AS actif_21, b0_.created_at AS created_at_22, b0_.updated_at AS updated_at_23 FROM batiment_modele b0_ WHERE b0_.actif = 1 ORDER BY b0_.categorie ASC, b0_.nom ASC;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\BatimentModeleRepository->findAllActifs (line 27)
7	App\Controller\BatimentController->index (line 27)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

1.80 ms
(1.66%)

SELECT t0.id AS id_1, t0.date AS date_2, t0.temperature AS temperature_3, t0.feels_like AS feels_like_4, t0.humidity AS humidity_5, t0.wind_speed AS wind_speed_6, t0.wind_direction AS wind_direction_7, t0.pressure AS pressure_8, t0.precipitation_type AS precipitation_type_9, t0.weather AS weather_10, t0.summary AS summary_11, t0.cloud_cover AS cloud_cover_12, t0.zone AS zone_13 FROM meteo_data t0 WHERE t0.id = ?

Parameters:

[
  9184
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.temperature AS temperature_3,
  t0.feels_like AS feels_like_4,
  t0.humidity AS humidity_5,
  t0.wind_speed AS wind_speed_6,
  t0.wind_direction AS wind_direction_7,
  t0.pressure AS pressure_8,
  t0.precipitation_type AS precipitation_type_9,
  t0.weather AS weather_10,
  t0.summary AS summary_11,
  t0.cloud_cover AS cloud_cover_12,
  t0.zone AS zone_13
FROM
  meteo_data t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.temperature AS temperature_3, t0.feels_like AS feels_like_4, t0.humidity AS humidity_5, t0.wind_speed AS wind_speed_6, t0.wind_direction AS wind_direction_7, t0.pressure AS pressure_8, t0.precipitation_type AS precipitation_type_9, t0.weather AS weather_10, t0.summary AS summary_11, t0.cloud_cover AS cloud_cover_12, t0.zone AS zone_13 FROM meteo_data t0 WHERE t0.id = 9184;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	App\Repository\MeteoDataRepository->findClosestByDatetimeAndZone (line 63)
7	App\Service\MeteoWidgetService->getMeteoData (line 94)
8	App\Service\MeteoWidgetService->getCurrentWeatherData (line 34)
9	App\Twig\MeteoWidgetExtension->getGlobals (line 22)
10	Twig\ExtensionSet->getGlobals (line 361)
11	Twig\Environment->getGlobals (line 908)
12	Twig\Template->yield (line 398)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 250)
20	App\Controller\BatimentController->index (line 58)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\BatimentModele	17
App\Entity\MeteoData	1

Entities Mapping

Class	Mapping errors
App\Entity\BatimentModele	No errors.
App\Entity\MeteoData	No errors.

Symfony Profiler

GET https://agri.seo500france.com/batiment

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping